See Release Notes
Long Term Support Release
<?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/>. /** * Upgrade code for install * * @package mod_assign * @copyright 2012 NetSpot {@link http://www.netspot.com.au} * @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later */ defined('MOODLE_INTERNAL') || die(); /** * upgrade this assignment instance - this function could be skipped but it will be needed later * @param int $oldversion The old version of the assign module * @return bool */ function xmldb_assign_upgrade($oldversion) { global $CFG, $DB; $dbman = $DB->get_manager();< // Automatically generated Moodle v3.5.0 release upgrade line. < // Put any upgrade step following this. < < // Automatically generated Moodle v3.6.0 release upgrade line.> // Automatically generated Moodle v3.9.0 release upgrade line.// Put any upgrade step following this.< if ($oldversion < 2018120500) { < // Define field hidegrader to be added to assign.> if ($oldversion < 2021110901) { > // Define field activity to be added to assign.$table = new xmldb_table('assign');< $field = new xmldb_field('hidegrader', XMLDB_TYPE_INTEGER, '2', null, XMLDB_NOTNULL, null, '0', 'blindmarking');> $field = new xmldb_field('activity', XMLDB_TYPE_TEXT, null, null, null, null, null, 'alwaysshowdescription');> // Conditionally launch add field activity.if (!$dbman->field_exists($table, $field)) { $dbman->add_field($table, $field); }< // Assignment savepoint reached. < upgrade_mod_savepoint(true, 2018120500, 'assign');> $field = new xmldb_field('activityformat', XMLDB_TYPE_INTEGER, '4', null, XMLDB_NOTNULL, null, '0', 'activity'); > > // Conditionally launch add field activityformat. > if (!$dbman->field_exists($table, $field)) { > $dbman->add_field($table, $field);}< // Automatically generated Moodle v3.7.0 release upgrade line. < // Put any upgrade step following this.> $field = new xmldb_field('timelimit', XMLDB_TYPE_INTEGER, '10', null, XMLDB_NOTNULL, null, '0', 'cutoffdate');< // Automatically generated Moodle v3.8.0 release upgrade line. < // Put any upgrade step following this.> // Conditionally launch add field timelimit. > if (!$dbman->field_exists($table, $field)) { > $dbman->add_field($table, $field); > }< // Automatically generated Moodle v3.9.0 release upgrade line.> $field = new xmldb_field('submissionattachments', XMLDB_TYPE_INTEGER, '2', > null, XMLDB_NOTNULL, null, '0', 'activityformat'); > > // Conditionally launch add field submissionattachments. > if (!$dbman->field_exists($table, $field)) { > $dbman->add_field($table, $field); > } > > $table = new xmldb_table('assign_submission'); > $field = new xmldb_field('timestarted', XMLDB_TYPE_INTEGER, '10', null, null, null, null, 'timemodified'); > > // Conditionally launch add field timestarted. > if (!$dbman->field_exists($table, $field)) { > $dbman->add_field($table, $field); > } > > // Define field timelimit to be added to assign_overrides. > $table = new xmldb_table('assign_overrides'); > $field = new xmldb_field('timelimit', XMLDB_TYPE_INTEGER, '10', null, null, null, null, 'cutoffdate'); > > // Conditionally launch add field timelimit. > if (!$dbman->field_exists($table, $field)) { > $dbman->add_field($table, $field); > } > > // Assign savepoint reached. > upgrade_mod_savepoint(true, 2021110901, 'assign'); > } > > // Automatically generated Moodle v4.0.0 release upgrade line.// Put any upgrade step following this.< // Automatically generated Moodle v3.10.0 release upgrade line.> if ($oldversion < 2022071300) { > // The most recent assign submission should always have latest = 1, we want to find all records where this is not the case. > // Find the records with the maximum timecreated for each assign and user combination where latest is also 0. > $sqluser = "SELECT s.id > FROM {assign_submission} s > WHERE s.timecreated = ( > SELECT MAX(timecreated) timecreated > FROM {assign_submission} sm > WHERE s.assignment = sm.assignment > AND s.userid = sm.userid > AND sm.groupid = 0) > AND s.groupid = 0 > AND s.latest = 0"; > $idstofixuser = $DB->get_records_sql($sqluser, null); > > $sqlgroup = "SELECT s.id > FROM {assign_submission} s > WHERE s.timecreated = ( > SELECT MAX(timecreated) timecreated > FROM {assign_submission} sm > WHERE s.assignment = sm.assignment > AND s.groupid = sm.groupid > AND sm.groupid <> 0) > AND s.groupid <> 0 > AND s.latest = 0"; > $idstofixgroup = $DB->get_records_sql($sqlgroup, null); > > $idstofix = array_merge(array_keys($idstofixuser), array_keys($idstofixgroup)); > > if (count($idstofix)) { > [$insql, $inparams] = $DB->get_in_or_equal($idstofix); > $DB->set_field_select('assign_submission', 'latest', 1, "id $insql", $inparams); > } > > // Assignment savepoint reached. > upgrade_mod_savepoint(true, 2022071300, 'assign'); > } > // Automatically generated Moodle v4.1.0 release upgrade line.// Put any upgrade step following this. return true; }