C:/xampp/htdocs/moodle/admin/tool/qeupgradehelper/partialupgrade-example.php

Go to the documentation of this file.

<?php
// This file is part of Moodle - http://moodle.org/
//
// Moodle is free software: you can redistribute it and/or modify
// it under the terms of the GNU General Public License as published by
// the Free Software Foundation, either version 3 of the License, or
// (at your option) any later version.
//
// Moodle is distributed in the hope that it will be useful,
// but WITHOUT ANY WARRANTY; without even the implied warranty of
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
// GNU General Public License for more details.
//
// You should have received a copy of the GNU General Public License
// along with Moodle.  If not, see <http://www.gnu.org/licenses/>.

//function tool_qeupgradehelper_get_quizzes_to_upgrade() {
//    return array(1, 2, 3);
//}


//function tool_qeupgradehelper_get_quizzes_to_upgrade() {
//    global $CFG;
//    $rawids = file($CFG->dirroot . '/' . $CFG->admin . '/tool/qeupgradehelper/quiz-ids-to-upgrade.txt');
//    $cleanids = array();
//    foreach ($rawids as $id) {
//        $id = clean_param($id, PARAM_INT);
//        if ($id) {
//            $cleanids[] = $id;
//        }
//    }
//    return $cleanids;
//}


//function tool_qeupgradehelper_get_quizzes_to_upgrade() {
//    global $DB;
//
//    $quizmoduleid = $DB->get_field('modules', 'id', array('name' => 'quiz'));
//
//    $oneyearago = strtotime('-1 year');
//
//    return $DB->get_fieldset_sql('
//        SELECT DISTINCT quiz.id
//
//        FROM {quiz} quiz
//        JOIN {course_modules} cm ON cm.module = :quizmoduleid
//                AND cm.instance = quiz.id
//        JOIN {course} c ON quiz.course = c.id
//
//        WHERE c.startdate > :cutoffdate
//
//        ORDER BY quiz.id
//        ', array('quizmoduleid' => $quizmoduleid, 'cutoffdate' => $oneyearago));
//    ");
//}