/** * This file keeps track of upgrades to * the forum module * * Sometimes, changes between versions involve * alterations to database structures and other * major things that may break installations. * * The upgrade function in this file will attempt * to perform all the necessary actions to upgrade * your older installation to the current version. * * If there's something it cannot do itself, it * will tell you what you need to do. * * The commands in here will all be database-neutral, * using the methods of database_manager class * * Please do not forget to use upgrade_set_timeout() * before any action that may take longer time to finish. * * @package mod-forum * @copyright 2003 onwards Eloy Lafuente (stronk7) {@link http://stronk7.com} * @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later */ function xmldb_forum_upgrade($oldversion) { global $CFG, $DB, $OUTPUT; $dbman = $DB->get_manager(); // Loads ddl manager and xmldb classes. // Moodle v2.2.0 release upgrade line. // Put any upgrade step following this. // Moodle v2.3.0 release upgrade line. // Put any upgrade step following this. // Moodle v2.4.0 release upgrade line. // Put any upgrade step following this. if ($oldversion < 2013020500) { // Define field displaywordcount to be added to forum. $table = new xmldb_table('forum'); $field = new xmldb_field('displaywordcount', XMLDB_TYPE_INTEGER, '1', null, XMLDB_NOTNULL, null, '0', 'completionposts'); // Conditionally launch add field displaywordcount. if (!$dbman->field_exists($table, $field)) { $dbman->add_field($table, $field); } // Forum savepoint reached. upgrade_mod_savepoint(true, 2013020500, 'forum'); } // Forcefully assign mod/forum:allowforcesubscribe to frontpage role, as we missed that when // capability was introduced. if ($oldversion < 2013021200) { // If capability mod/forum:allowforcesubscribe is defined then set it for frontpage role. if (get_capability_info('mod/forum:allowforcesubscribe')) { assign_legacy_capabilities('mod/forum:allowforcesubscribe', array('frontpage' => CAP_ALLOW)); } // Forum savepoint reached. upgrade_mod_savepoint(true, 2013021200, 'forum'); } // Moodle v2.5.0 release upgrade line. // Put any upgrade step following this. if ($oldversion < 2013071000) { // Define table forum_digests to be created. $table = new xmldb_table('forum_digests'); // Adding fields to table forum_digests. $table->add_field('id', XMLDB_TYPE_INTEGER, '10', null, XMLDB_NOTNULL, XMLDB_SEQUENCE, null); $table->add_field('userid', XMLDB_TYPE_INTEGER, '10', null, XMLDB_NOTNULL, null, null); $table->add_field('forum', XMLDB_TYPE_INTEGER, '10', null, XMLDB_NOTNULL, null, null); $table->add_field('maildigest', XMLDB_TYPE_INTEGER, '1', null, XMLDB_NOTNULL, null, '-1'); // Adding keys to table forum_digests. $table->add_key('primary', XMLDB_KEY_PRIMARY, array('id')); $table->add_key('userid', XMLDB_KEY_FOREIGN, array('userid'), 'user', array('id')); $table->add_key('forum', XMLDB_KEY_FOREIGN, array('forum'), 'forum', array('id')); $table->add_key('forumdigest', XMLDB_KEY_UNIQUE, array('forum', 'userid', 'maildigest')); // Conditionally launch create table for forum_digests. if (!$dbman->table_exists($table)) { $dbman->create_table($table); } // Forum savepoint reached. upgrade_mod_savepoint(true, 2013071000, 'forum'); } // Moodle v2.6.0 release upgrade line. // Put any upgrade step following this. return true; }
/** * This file keeps track of upgrades to * the forum module * * Sometimes, changes between versions involve * alterations to database structures and other * major things that may break installations. * * The upgrade function in this file will attempt * to perform all the necessary actions to upgrade * your older installation to the current version. * * If there's something it cannot do itself, it * will tell you what you need to do. * * The commands in here will all be database-neutral, * using the methods of database_manager class * * Please do not forget to use upgrade_set_timeout() * before any action that may take longer time to finish. * * @package mod-forum * @copyright 2003 onwards Eloy Lafuente (stronk7) {@link http://stronk7.com} * @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later */ function xmldb_forum_upgrade($oldversion) { global $CFG, $DB, $OUTPUT; $dbman = $DB->get_manager(); // Loads ddl manager and xmldb classes. // Moodle v2.2.0 release upgrade line. // Put any upgrade step following this. // Moodle v2.3.0 release upgrade line. // Put any upgrade step following this. // Moodle v2.4.0 release upgrade line. // Put any upgrade step following this. // Moodle v2.5.0 release upgrade line. // Put any upgrade step following this. if ($oldversion < 2013020500) { // Define field displaywordcount to be added to forum. $table = new xmldb_table('forum'); $field = new xmldb_field('displaywordcount', XMLDB_TYPE_INTEGER, '1', null, XMLDB_NOTNULL, null, '0', 'completionposts'); // Conditionally launch add field displaywordcount. if (!$dbman->field_exists($table, $field)) { $dbman->add_field($table, $field); } // Forum savepoint reached. upgrade_mod_savepoint(true, 2013020500, 'forum'); } // Forcefully assign mod/forum:allowforcesubscribe to frontpage role, as we missed that when // capability was introduced. if ($oldversion < 2013021200) { // If capability mod/forum:allowforcesubscribe is defined then set it for frontpage role. if (get_capability_info('mod/forum:allowforcesubscribe')) { assign_legacy_capabilities('mod/forum:allowforcesubscribe', array('frontpage' => CAP_ALLOW)); } // Forum savepoint reached. upgrade_mod_savepoint(true, 2013021200, 'forum'); } return true; }
/** * This file keeps track of upgrades to * the forum module * * Sometimes, changes between versions involve * alterations to database structures and other * major things that may break installations. * * The upgrade function in this file will attempt * to perform all the necessary actions to upgrade * your older installation to the current version. * * If there's something it cannot do itself, it * will tell you what you need to do. * * The commands in here will all be database-neutral, * using the methods of database_manager class * * Please do not forget to use upgrade_set_timeout() * before any action that may take longer time to finish. * * @package mod-forum * @copyright 2003 onwards Eloy Lafuente (stronk7) {@link http://stronk7.com} * @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later */ function xmldb_forum_upgrade($oldversion) { global $CFG, $DB, $OUTPUT; $dbman = $DB->get_manager(); // loads ddl manager and xmldb classes // Moodle v2.2.0 release upgrade line // Put any upgrade step following this // Moodle v2.3.0 release upgrade line // Put any upgrade step following this // Forcefully assign mod/forum:allowforcesubscribe to frontpage role, as we missed that when // capability was introduced. if ($oldversion < 2012061702) { // If capability mod/forum:allowforcesubscribe is defined then set it for frontpage role. if (get_capability_info('mod/forum:allowforcesubscribe')) { assign_legacy_capabilities('mod/forum:allowforcesubscribe', array('frontpage' => CAP_ALLOW)); } // Forum savepoint reached. upgrade_mod_savepoint(true, 2012061702, 'forum'); } return true; }
/** * Updates the capabilities table with the component capability definitions. * If no parameters are given, the function updates the core moodle * capabilities. * * Note that the absence of the db/access.php capabilities definition file * will cause any stored capabilities for the component to be removed from * the database. * * @param string $component examples: 'moodle', 'mod/forum', 'block/quiz_results' * @return boolean true if success, exception in case of any problems */ function update_capabilities($component = 'moodle') { global $DB, $OUTPUT; $storedcaps = array(); $filecaps = load_capability_def($component); foreach ($filecaps as $capname => $unused) { if (!preg_match('|^[a-z]+/[a-z_0-9]+:[a-z_0-9]+$|', $capname)) { debugging("Coding problem: Invalid capability name '{$capname}', use 'clonepermissionsfrom' field for migration."); } } $cachedcaps = get_cached_capabilities($component); if ($cachedcaps) { foreach ($cachedcaps as $cachedcap) { array_push($storedcaps, $cachedcap->name); // update risk bitmasks and context levels in existing capabilities if needed if (array_key_exists($cachedcap->name, $filecaps)) { if (!array_key_exists('riskbitmask', $filecaps[$cachedcap->name])) { $filecaps[$cachedcap->name]['riskbitmask'] = 0; // no risk if not specified } if ($cachedcap->captype != $filecaps[$cachedcap->name]['captype']) { $updatecap = new stdClass(); $updatecap->id = $cachedcap->id; $updatecap->captype = $filecaps[$cachedcap->name]['captype']; $DB->update_record('capabilities', $updatecap); } if ($cachedcap->riskbitmask != $filecaps[$cachedcap->name]['riskbitmask']) { $updatecap = new stdClass(); $updatecap->id = $cachedcap->id; $updatecap->riskbitmask = $filecaps[$cachedcap->name]['riskbitmask']; $DB->update_record('capabilities', $updatecap); } if (!array_key_exists('contextlevel', $filecaps[$cachedcap->name])) { $filecaps[$cachedcap->name]['contextlevel'] = 0; // no context level defined } if ($cachedcap->contextlevel != $filecaps[$cachedcap->name]['contextlevel']) { $updatecap = new stdClass(); $updatecap->id = $cachedcap->id; $updatecap->contextlevel = $filecaps[$cachedcap->name]['contextlevel']; $DB->update_record('capabilities', $updatecap); } } } } // Are there new capabilities in the file definition? $newcaps = array(); foreach ($filecaps as $filecap => $def) { if (!$storedcaps || $storedcaps && in_array($filecap, $storedcaps) === false) { if (!array_key_exists('riskbitmask', $def)) { $def['riskbitmask'] = 0; // no risk if not specified } $newcaps[$filecap] = $def; } } // Add new capabilities to the stored definition. foreach ($newcaps as $capname => $capdef) { $capability = new stdClass(); $capability->name = $capname; $capability->captype = $capdef['captype']; $capability->contextlevel = $capdef['contextlevel']; $capability->component = $component; $capability->riskbitmask = $capdef['riskbitmask']; $DB->insert_record('capabilities', $capability, false); if (isset($capdef['clonepermissionsfrom']) && in_array($capdef['clonepermissionsfrom'], $storedcaps)) { if ($rolecapabilities = $DB->get_records('role_capabilities', array('capability' => $capdef['clonepermissionsfrom']))) { foreach ($rolecapabilities as $rolecapability) { //assign_capability will update rather than insert if capability exists if (!assign_capability($capname, $rolecapability->permission, $rolecapability->roleid, $rolecapability->contextid, true)) { echo $OUTPUT->notification('Could not clone capabilities for ' . $capname); } } } // we ignore archetype key if we have cloned permissions } else { if (isset($capdef['archetypes']) && is_array($capdef['archetypes'])) { assign_legacy_capabilities($capname, $capdef['archetypes']); // 'legacy' is for backward compatibility with 1.9 access.php } else { if (isset($capdef['legacy']) && is_array($capdef['legacy'])) { assign_legacy_capabilities($capname, $capdef['legacy']); } } } } // Are there any capabilities that have been removed from the file // definition that we need to delete from the stored capabilities and // role assignments? capabilities_cleanup($component, $filecaps); // reset static caches accesslib_clear_all_caches(false); return true; }
/** * Updates the capabilities table with the component capability definitions. * If no parameters are given, the function updates the core moodle * capabilities. * * Note that the absence of the db/access.php capabilities definition file * will cause any stored capabilities for the component to be removed from * the database. * * @param $component - examples: 'moodle', 'mod/forum', 'block/quiz_results' * @return boolean true if success, exception in case of any problems */ function update_capabilities($component = 'moodle') { global $DB; $storedcaps = array(); $filecaps = load_capability_def($component); $cachedcaps = get_cached_capabilities($component); if ($cachedcaps) { foreach ($cachedcaps as $cachedcap) { array_push($storedcaps, $cachedcap->name); // update risk bitmasks and context levels in existing capabilities if needed if (array_key_exists($cachedcap->name, $filecaps)) { if (!array_key_exists('riskbitmask', $filecaps[$cachedcap->name])) { $filecaps[$cachedcap->name]['riskbitmask'] = 0; // no risk if not specified } if ($cachedcap->riskbitmask != $filecaps[$cachedcap->name]['riskbitmask']) { $updatecap = new object(); $updatecap->id = $cachedcap->id; $updatecap->riskbitmask = $filecaps[$cachedcap->name]['riskbitmask']; $DB->update_record('capabilities', $updatecap); } if (!array_key_exists('contextlevel', $filecaps[$cachedcap->name])) { $filecaps[$cachedcap->name]['contextlevel'] = 0; // no context level defined } if ($cachedcap->contextlevel != $filecaps[$cachedcap->name]['contextlevel']) { $updatecap = new object(); $updatecap->id = $cachedcap->id; $updatecap->contextlevel = $filecaps[$cachedcap->name]['contextlevel']; $DB->update_record('capabilities', $updatecap); } } } } // Are there new capabilities in the file definition? $newcaps = array(); foreach ($filecaps as $filecap => $def) { if (!$storedcaps || $storedcaps && in_array($filecap, $storedcaps) === false) { if (!array_key_exists('riskbitmask', $def)) { $def['riskbitmask'] = 0; // no risk if not specified } $newcaps[$filecap] = $def; } } // Add new capabilities to the stored definition. foreach ($newcaps as $capname => $capdef) { $capability = new object(); $capability->name = $capname; $capability->captype = $capdef['captype']; $capability->contextlevel = $capdef['contextlevel']; $capability->component = $component; $capability->riskbitmask = $capdef['riskbitmask']; $DB->insert_record('capabilities', $capability, false); if (isset($capdef['clonepermissionsfrom']) && in_array($capdef['clonepermissionsfrom'], $storedcaps)) { if ($rolecapabilities = $DB->get_records('role_capabilities', array('capability' => $capdef['clonepermissionsfrom']))) { foreach ($rolecapabilities as $rolecapability) { //assign_capability will update rather than insert if capability exists if (!assign_capability($capname, $rolecapability->permission, $rolecapability->roleid, $rolecapability->contextid, true)) { notify('Could not clone capabilities for ' . $capname); } } } // Do we need to assign the new capabilities to roles that have the // legacy capabilities moodle/legacy:* as well? // we ignore legacy key if we have cloned permissions } else { if (isset($capdef['legacy']) && is_array($capdef['legacy']) && !assign_legacy_capabilities($capname, $capdef['legacy'])) { notify('Could not assign legacy capabilities for ' . $capname); } } } // Are there any capabilities that have been removed from the file // definition that we need to delete from the stored capabilities and // role assignments? capabilities_cleanup($component, $filecaps); // reset static caches is_valid_capability('reset', false); return true; }
/** * This file keeps track of upgrades to * the forum module * * Sometimes, changes between versions involve * alterations to database structures and other * major things that may break installations. * * The upgrade function in this file will attempt * to perform all the necessary actions to upgrade * your older installation to the current version. * * If there's something it cannot do itself, it * will tell you what you need to do. * * The commands in here will all be database-neutral, * using the methods of database_manager class * * Please do not forget to use upgrade_set_timeout() * before any action that may take longer time to finish. * * @package mod_forum * @copyright 2003 onwards Eloy Lafuente (stronk7) {@link http://stronk7.com} * @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later */ function xmldb_forum_upgrade($oldversion) { global $CFG, $DB, $OUTPUT; $dbman = $DB->get_manager(); // Loads ddl manager and xmldb classes. // Moodle v2.2.0 release upgrade line. // Put any upgrade step following this. // Moodle v2.3.0 release upgrade line. // Put any upgrade step following this. // Moodle v2.4.0 release upgrade line. // Put any upgrade step following this. if ($oldversion < 2013020500) { // Define field displaywordcount to be added to forum. $table = new xmldb_table('forum'); $field = new xmldb_field('displaywordcount', XMLDB_TYPE_INTEGER, '1', null, XMLDB_NOTNULL, null, '0', 'completionposts'); // Conditionally launch add field displaywordcount. if (!$dbman->field_exists($table, $field)) { $dbman->add_field($table, $field); } // Forum savepoint reached. upgrade_mod_savepoint(true, 2013020500, 'forum'); } // Forcefully assign mod/forum:allowforcesubscribe to frontpage role, as we missed that when // capability was introduced. if ($oldversion < 2013021200) { // If capability mod/forum:allowforcesubscribe is defined then set it for frontpage role. if (get_capability_info('mod/forum:allowforcesubscribe')) { assign_legacy_capabilities('mod/forum:allowforcesubscribe', array('frontpage' => CAP_ALLOW)); } // Forum savepoint reached. upgrade_mod_savepoint(true, 2013021200, 'forum'); } // Moodle v2.5.0 release upgrade line. // Put any upgrade step following this. if ($oldversion < 2013071000) { // Define table forum_digests to be created. $table = new xmldb_table('forum_digests'); // Adding fields to table forum_digests. $table->add_field('id', XMLDB_TYPE_INTEGER, '10', null, XMLDB_NOTNULL, XMLDB_SEQUENCE, null); $table->add_field('userid', XMLDB_TYPE_INTEGER, '10', null, XMLDB_NOTNULL, null, null); $table->add_field('forum', XMLDB_TYPE_INTEGER, '10', null, XMLDB_NOTNULL, null, null); $table->add_field('maildigest', XMLDB_TYPE_INTEGER, '1', null, XMLDB_NOTNULL, null, '-1'); // Adding keys to table forum_digests. $table->add_key('primary', XMLDB_KEY_PRIMARY, array('id')); $table->add_key('userid', XMLDB_KEY_FOREIGN, array('userid'), 'user', array('id')); $table->add_key('forum', XMLDB_KEY_FOREIGN, array('forum'), 'forum', array('id')); $table->add_key('forumdigest', XMLDB_KEY_UNIQUE, array('forum', 'userid', 'maildigest')); // Conditionally launch create table for forum_digests. if (!$dbman->table_exists($table)) { $dbman->create_table($table); } // Forum savepoint reached. upgrade_mod_savepoint(true, 2013071000, 'forum'); } // Moodle v2.6.0 release upgrade line. // Put any upgrade step following this. if ($oldversion < 2014040400) { // Define index userid-postid (not unique) to be dropped form forum_read. $table = new xmldb_table('forum_read'); $index = new xmldb_index('userid-postid', XMLDB_INDEX_NOTUNIQUE, array('userid', 'postid')); // Conditionally launch drop index userid-postid. if ($dbman->index_exists($table, $index)) { $dbman->drop_index($table, $index); } // Define index postid-userid (not unique) to be added to forum_read. $index = new xmldb_index('postid-userid', XMLDB_INDEX_NOTUNIQUE, array('postid', 'userid')); // Conditionally launch add index postid-userid. if (!$dbman->index_exists($table, $index)) { $dbman->add_index($table, $index); } // Forum savepoint reached. upgrade_mod_savepoint(true, 2014040400, 'forum'); } // Moodle v2.7.0 release upgrade line. // Put any upgrade step following this. if ($oldversion < 2014051201) { // Incorrect values that need to be replaced. $replacements = array(11 => 20, 12 => 50, 13 => 100); // Run the replacements. foreach ($replacements as $old => $new) { $DB->set_field('forum', 'maxattachments', $new, array('maxattachments' => $old)); } // Forum savepoint reached. upgrade_mod_savepoint(true, 2014051201, 'forum'); } if ($oldversion < 2014081500) { // Define index course (not unique) to be added to forum_discussions. $table = new xmldb_table('forum_discussions'); $index = new xmldb_index('course', XMLDB_INDEX_NOTUNIQUE, array('course')); // Conditionally launch add index course. if (!$dbman->index_exists($table, $index)) { $dbman->add_index($table, $index); } // Forum savepoint reached. upgrade_mod_savepoint(true, 2014081500, 'forum'); } if ($oldversion < 2014081900) { // Define table forum_discussion_subs to be created. $table = new xmldb_table('forum_discussion_subs'); // Adding fields to table forum_discussion_subs. $table->add_field('id', XMLDB_TYPE_INTEGER, '10', null, XMLDB_NOTNULL, XMLDB_SEQUENCE, null); $table->add_field('forum', XMLDB_TYPE_INTEGER, '10', null, XMLDB_NOTNULL, null, null); $table->add_field('userid', XMLDB_TYPE_INTEGER, '10', null, XMLDB_NOTNULL, null, null); $table->add_field('discussion', XMLDB_TYPE_INTEGER, '10', null, XMLDB_NOTNULL, null, null); $table->add_field('preference', XMLDB_TYPE_INTEGER, '1', null, XMLDB_NOTNULL, null, '1'); // Adding keys to table forum_discussion_subs. $table->add_key('primary', XMLDB_KEY_PRIMARY, array('id')); $table->add_key('forum', XMLDB_KEY_FOREIGN, array('forum'), 'forum', array('id')); $table->add_key('userid', XMLDB_KEY_FOREIGN, array('userid'), 'user', array('id')); $table->add_key('discussion', XMLDB_KEY_FOREIGN, array('discussion'), 'forum_discussions', array('id')); $table->add_key('user_discussions', XMLDB_KEY_UNIQUE, array('userid', 'discussion')); // Conditionally launch create table for forum_discussion_subs. if (!$dbman->table_exists($table)) { $dbman->create_table($table); } // Forum savepoint reached. upgrade_mod_savepoint(true, 2014081900, 'forum'); } if ($oldversion < 2014103000) { // Find records with multiple userid/postid combinations and find the lowest ID. // Later we will remove all those which don't match this ID. $sql = "\n SELECT MIN(id) as lowid, userid, postid\n FROM {forum_read}\n GROUP BY userid, postid\n HAVING COUNT(id) > 1"; if ($duplicatedrows = $DB->get_recordset_sql($sql)) { foreach ($duplicatedrows as $row) { $DB->delete_records_select('forum_read', 'userid = ? AND postid = ? AND id <> ?', array($row->userid, $row->postid, $row->lowid)); } } $duplicatedrows->close(); // Forum savepoint reached. upgrade_mod_savepoint(true, 2014103000, 'forum'); } if ($oldversion < 2014110300) { // Changing precision of field preference on table forum_discussion_subs to (10). $table = new xmldb_table('forum_discussion_subs'); $field = new xmldb_field('preference', XMLDB_TYPE_INTEGER, '10', null, XMLDB_NOTNULL, null, '1', 'discussion'); // Launch change of precision for field preference. $dbman->change_field_precision($table, $field); // Forum savepoint reached. upgrade_mod_savepoint(true, 2014110300, 'forum'); } // Moodle v2.8.0 release upgrade line. // Put any upgrade step following this. // Moodle v2.9.0 release upgrade line. // Put any upgrade step following this. if ($oldversion < 2015102900) { // Groupid = 0 is never valid. $DB->set_field('forum_discussions', 'groupid', -1, array('groupid' => 0)); // Forum savepoint reached. upgrade_mod_savepoint(true, 2015102900, 'forum'); } // Moodle v3.0.0 release upgrade line. // Put any upgrade step following this. if ($oldversion < 2015120800) { // Add support for pinned discussions. $table = new xmldb_table('forum_discussions'); $field = new xmldb_field('pinned', XMLDB_TYPE_INTEGER, '1', null, XMLDB_NOTNULL, null, '0', 'timeend'); if (!$dbman->field_exists($table, $field)) { $dbman->add_field($table, $field); } // Forum savepoint reached. upgrade_mod_savepoint(true, 2015120800, 'forum'); } return true; }
/** * This file keeps track of upgrades to * the forum module * * Sometimes, changes between versions involve * alterations to database structures and other * major things that may break installations. * * The upgrade function in this file will attempt * to perform all the necessary actions to upgrade * your older installation to the current version. * * If there's something it cannot do itself, it * will tell you what you need to do. * * The commands in here will all be database-neutral, * using the methods of database_manager class * * Please do not forget to use upgrade_set_timeout() * before any action that may take longer time to finish. * * @package mod_hsuforum * @copyright 2003 onwards Eloy Lafuente (stronk7) {@link http://stronk7.com} * @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later * @copyright Copyright (c) 2012 Moodlerooms Inc. (http://www.moodlerooms.com) * @author Mark Nielsen */ function xmldb_hsuforum_upgrade($oldversion) { global $CFG, $DB, $OUTPUT; $dbman = $DB->get_manager(); // loads ddl manager and xmldb classes //===== 1.9.0 upgrade line ======// if ($oldversion < 2011112801) { /// HSUFORUM UPGRADES // Rename field hsuforum on table hsuforum_discussions to forum $table = new xmldb_table('hsuforum_discussions'); $field = new xmldb_field('hsuforum', XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, XMLDB_NOTNULL, null, '0', 'course'); // Launch rename field hsuforum $dbman->rename_field($table, $field, 'forum'); // Rename field hsuforum on table hsuforum_subscriptions to forum $table = new xmldb_table('hsuforum_subscriptions'); $field = new xmldb_field('hsuforum', XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, XMLDB_NOTNULL, null, '0', 'userid'); // Launch rename field hsuforum $dbman->rename_field($table, $field, 'forum'); // Rename field hsuforumid on table hsuforum_read to forumid $table = new xmldb_table('hsuforum_read'); $field = new xmldb_field('hsuforumid', XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, XMLDB_NOTNULL, null, '0', 'userid'); // Launch rename field hsuforumid $dbman->rename_field($table, $field, 'forumid'); // hsuforum_discussion_subscripts was too long of a name // Define table hsuforum_discussion_subscripts to be renamed to hsuforum_subscriptions_disc $table = new xmldb_table('hsuforum_discussion_subscripts'); // Launch rename table for hsuforum_discussion_subscripts $dbman->rename_table($table, 'hsuforum_subscriptions_disc'); /// HSUFORUM UPGRADES END //MDL-13866 - send forum ratins to gradebook again require_once $CFG->dirroot . '/mod/hsuforum/lib.php'; hsuforum_upgrade_grades(); upgrade_mod_savepoint(true, 2011112801, 'hsuforum'); } if ($oldversion < 2011112802) { /// Define field completiondiscussions to be added to forum $table = new xmldb_table('hsuforum'); $field = new xmldb_field('completiondiscussions'); $field->set_attributes(XMLDB_TYPE_INTEGER, '9', XMLDB_UNSIGNED, XMLDB_NOTNULL, null, '0', 'blockperiod'); /// Launch add field completiondiscussions if (!$dbman->field_exists($table, $field)) { $dbman->add_field($table, $field); } $field = new xmldb_field('completionreplies'); $field->set_attributes(XMLDB_TYPE_INTEGER, '9', XMLDB_UNSIGNED, XMLDB_NOTNULL, null, '0', 'completiondiscussions'); /// Launch add field completionreplies if (!$dbman->field_exists($table, $field)) { $dbman->add_field($table, $field); } /// Define field completionposts to be added to forum $field = new xmldb_field('completionposts'); $field->set_attributes(XMLDB_TYPE_INTEGER, '9', XMLDB_UNSIGNED, XMLDB_NOTNULL, null, '0', 'completionreplies'); /// Launch add field completionposts if (!$dbman->field_exists($table, $field)) { $dbman->add_field($table, $field); } upgrade_mod_savepoint(true, 2011112802, 'hsuforum'); } if ($oldversion < 2011112803) { ///////////////////////////////////// /// new file storage upgrade code /// ///////////////////////////////////// $fs = get_file_storage(); $empty = $DB->sql_empty(); // silly oracle empty string handling workaround $sqlfrom = "FROM {hsuforum_posts} p\n JOIN {hsuforum_discussions} d ON d.id = p.discussion\n JOIN {hsuforum} f ON f.id = d.forum\n JOIN {modules} m ON m.name = 'hsuforum'\n JOIN {course_modules} cm ON (cm.module = m.id AND cm.instance = f.id)\n WHERE p.attachment <> '{$empty}' AND p.attachment <> '1'"; $count = $DB->count_records_sql("SELECT COUNT('x') {$sqlfrom}"); $rs = $DB->get_recordset_sql("SELECT p.id, p.attachment, p.userid, d.forum, f.course, cm.id AS cmid {$sqlfrom} ORDER BY f.course, f.id, d.id"); if ($rs->valid()) { $pbar = new progress_bar('migrateforumfiles', 500, true); $i = 0; foreach ($rs as $post) { $i++; upgrade_set_timeout(60); // set up timeout, may also abort execution $pbar->update($i, $count, "Migrating forum posts - {$i}/{$count}."); $attachmentmigrated = false; $basepath = "{$CFG->dataroot}/{$post->course}/{$CFG->moddata}/hsuforum/{$post->forum}/{$post->id}"; $files = get_directory_list($basepath); foreach ($files as $file) { $filepath = "{$basepath}/{$file}"; if (!is_readable($filepath)) { //file missing?? echo $OUTPUT->notification("File not readable, skipping: " . $filepath); $post->attachment = ''; $DB->update_record('hsuforum_posts', $post); continue; } $context = context_module::instance($post->cmid); $filearea = 'attachment'; $filename = clean_param(pathinfo($filepath, PATHINFO_BASENAME), PARAM_FILE); if ($filename === '') { echo $OUTPUT->notification("Unsupported post filename, skipping: " . $filepath); $post->attachment = ''; $DB->update_record('hsuforum_posts', $post); continue; } if (!$fs->file_exists($context->id, 'mod_hsuforum', $filearea, $post->id, '/', $filename)) { $file_record = array('contextid' => $context->id, 'component' => 'mod_hsuforum', 'filearea' => $filearea, 'itemid' => $post->id, 'filepath' => '/', 'filename' => $filename, 'userid' => $post->userid); if ($fs->create_file_from_pathname($file_record, $filepath)) { $attachmentmigrated = true; unlink($filepath); } } } if ($attachmentmigrated) { $post->attachment = '1'; $DB->update_record('hsuforum_posts', $post); } // remove dirs if empty @rmdir("{$CFG->dataroot}/{$post->course}/{$CFG->moddata}/hsuforum/{$post->forum}/{$post->id}"); @rmdir("{$CFG->dataroot}/{$post->course}/{$CFG->moddata}/hsuforum/{$post->forum}"); @rmdir("{$CFG->dataroot}/{$post->course}/{$CFG->moddata}/hsuforum"); } } $rs->close(); upgrade_mod_savepoint(true, 2011112803, 'hsuforum'); } if ($oldversion < 2011112804) { /// Define field maxattachments to be added to forum $table = new xmldb_table('hsuforum'); $field = new xmldb_field('maxattachments', XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, XMLDB_NOTNULL, null, '1', 'maxbytes'); /// Conditionally launch add field maxattachments if (!$dbman->field_exists($table, $field)) { $dbman->add_field($table, $field); } /// HSUFORUM specific upgrades to maxattach and multiattach $field = new xmldb_field('maxattach', XMLDB_TYPE_INTEGER, '2', XMLDB_UNSIGNED, XMLDB_NOTNULL, null, '5'); if ($dbman->field_exists($table, $field)) { $DB->execute("\n UPDATE {hsuforum}\n SET maxattachments = maxattach\n "); $dbman->drop_field($table, $field); } $field = new xmldb_field('multiattach', XMLDB_TYPE_INTEGER, '1', XMLDB_UNSIGNED, XMLDB_NOTNULL, null, '1'); if ($dbman->field_exists($table, $field)) { // This disabled attachments, so clear out maxattachments $DB->execute("\n UPDATE {hsuforum}\n SET maxattachments = 0\n WHERE multiattach = 0\n "); $dbman->drop_field($table, $field); } /// forum savepoint reached upgrade_mod_savepoint(true, 2011112804, 'hsuforum'); } if ($oldversion < 2011112805) { /// Rename field format on table hsuforum_posts to messageformat $table = new xmldb_table('hsuforum_posts'); $field = new xmldb_field('format', XMLDB_TYPE_INTEGER, '2', null, XMLDB_NOTNULL, null, '0', 'message'); /// Launch rename field format $dbman->rename_field($table, $field, 'messageformat'); /// forum savepoint reached upgrade_mod_savepoint(true, 2011112805, 'hsuforum'); } if ($oldversion < 2011112806) { /// Define field messagetrust to be added to hsuforum_posts $table = new xmldb_table('hsuforum_posts'); $field = new xmldb_field('messagetrust', XMLDB_TYPE_INTEGER, '2', XMLDB_UNSIGNED, XMLDB_NOTNULL, null, '0', 'messageformat'); /// Launch add field messagetrust $dbman->add_field($table, $field); /// forum savepoint reached upgrade_mod_savepoint(true, 2011112806, 'hsuforum'); } if ($oldversion < 2011112807) { $trustmark = '#####TRUSTTEXT#####'; $rs = $DB->get_recordset_sql("SELECT * FROM {hsuforum_posts} WHERE message LIKE ?", array($trustmark . '%')); foreach ($rs as $post) { if (strpos($post->message, $trustmark) !== 0) { // probably lowercase in some DBs? continue; } $post->message = str_replace($trustmark, '', $post->message); $post->messagetrust = 1; $DB->update_record('hsuforum_posts', $post); } $rs->close(); /// forum savepoint reached upgrade_mod_savepoint(true, 2011112807, 'hsuforum'); } if ($oldversion < 2011112808) { /// Define field introformat to be added to forum $table = new xmldb_table('hsuforum'); $field = new xmldb_field('introformat', XMLDB_TYPE_INTEGER, '4', XMLDB_UNSIGNED, XMLDB_NOTNULL, null, '0', 'intro'); /// Launch add field introformat if (!$dbman->field_exists($table, $field)) { $dbman->add_field($table, $field); } // conditionally migrate to html format in intro if ($CFG->texteditors !== 'textarea') { $rs = $DB->get_recordset('hsuforum', array('introformat' => FORMAT_MOODLE), '', 'id,intro,introformat'); foreach ($rs as $f) { $f->intro = text_to_html($f->intro, false, false, true); $f->introformat = FORMAT_HTML; $DB->update_record('hsuforum', $f); upgrade_set_timeout(); } $rs->close(); } /// forum savepoint reached upgrade_mod_savepoint(true, 2011112808, 'hsuforum'); } /// Dropping all enums/check contraints from core. MDL-18577 if ($oldversion < 2011112809) { /// Changing list of values (enum) of field type on table forum to none $table = new xmldb_table('hsuforum'); $field = new xmldb_field('type', XMLDB_TYPE_CHAR, '20', null, XMLDB_NOTNULL, null, 'general', 'course'); /// Launch change of list of values for field type $dbman->drop_enum_from_field($table, $field); /// forum savepoint reached upgrade_mod_savepoint(true, 2011112809, 'hsuforum'); } if ($oldversion < 2011112810) { /// Clean existing wrong rates. MDL-18227 $DB->delete_records('hsuforum_ratings', array('post' => 0)); /// forum savepoint reached upgrade_mod_savepoint(true, 2011112810, 'hsuforum'); } if ($oldversion < 2011112811) { //migrate forumratings to the central rating table $table = new xmldb_table('hsuforum_ratings'); if ($dbman->table_exists($table)) { //forum ratings only have a single time column so use it for both time created and modified $sql = "INSERT INTO {rating} (contextid, component, ratingarea, scaleid, itemid, rating, userid, timecreated, timemodified)\n\n SELECT cxt.id, 'mod_hsuforum', 'post', f.scale, r.post AS itemid, r.rating, r.userid, r.time AS timecreated, r.time AS timemodified\n FROM {hsuforum_ratings} r\n JOIN {hsuforum_posts} p ON p.id=r.post\n JOIN {hsuforum_discussions} d ON d.id=p.discussion\n JOIN {hsuforum} f ON f.id=d.forum\n JOIN {course_modules} cm ON cm.instance=f.id\n JOIN {context} cxt ON cxt.instanceid=cm.id\n JOIN {modules} m ON m.id=cm.module\n WHERE m.name = :modname AND cxt.contextlevel = :contextlevel"; $params['modname'] = 'hsuforum'; $params['contextlevel'] = CONTEXT_MODULE; $DB->execute($sql, $params); //now drop hsuforum_ratings $dbman->drop_table($table); } upgrade_mod_savepoint(true, 2011112811, 'hsuforum'); } if ($oldversion < 2011112812) { // Remove the forum digests message provider MDL-23145 $DB->delete_records('message_providers', array('name' => 'digests', 'component' => 'mod_hsuforum')); // forum savepoint reached upgrade_mod_savepoint(true, 2011112812, 'hsuforum'); } if ($oldversion < 2011112813) { // rename files from borked upgrade in 2.0dev $fs = get_file_storage(); $rs = $DB->get_recordset('files', array('component' => 'mod_form')); foreach ($rs as $oldrecord) { $file = $fs->get_file_instance($oldrecord); $newrecord = array('component' => 'mod_hsuforum'); if (!$fs->file_exists($oldrecord->contextid, 'mod_hsuforum', $oldrecord->filearea, $oldrecord->itemid, $oldrecord->filepath, $oldrecord->filename)) { $fs->create_file_from_storedfile($newrecord, $file); } $file->delete(); } $rs->close(); upgrade_mod_savepoint(true, 2011112813, 'hsuforum'); } if ($oldversion < 2011112814) { // rating.component and rating.ratingarea have now been added as mandatory fields. // Presently you can only rate forum posts so component = 'mod_hsuforum' and ratingarea = 'post' // for all ratings with a forum context. // We want to update all ratings that belong to a forum context and don't already have a // component set. // This could take a while reset upgrade timeout to 5 min upgrade_set_timeout(60 * 20); $sql = "UPDATE {rating}\n SET component = 'mod_hsuforum', ratingarea = 'post'\n WHERE contextid IN (\n SELECT ctx.id\n FROM {context} ctx\n JOIN {course_modules} cm ON cm.id = ctx.instanceid\n JOIN {modules} m ON m.id = cm.module\n WHERE ctx.contextlevel = 70 AND\n m.name = 'hsuforum'\n ) AND component = 'unknown'"; $DB->execute($sql); upgrade_mod_savepoint(true, 2011112814, 'hsuforum'); } // Moodle v2.1.0 release upgrade line // Put any upgrade step following this // Moodle v2.2.0 release upgrade line // Put any upgrade step following this if ($oldversion < 2011112907) { /// Conditionally add field privatereply to be added to hsuforum $table = new xmldb_table('hsuforum_posts'); $field = new xmldb_field('privatereply'); $field->set_attributes(XMLDB_TYPE_INTEGER, '10', null, XMLDB_NOTNULL, null, '0', 'flags'); if (!$dbman->field_exists($table, $field)) { $dbman->add_field($table, $field); } // Define index privatereply (not unique) to be added to hsuforum_posts $table = new xmldb_table('hsuforum_posts'); $index = new xmldb_index('privatereply', XMLDB_INDEX_NOTUNIQUE, array('privatereply')); // Conditionally launch add index privatereply if (!$dbman->index_exists($table, $index)) { $dbman->add_index($table, $index); } // Rename field hsuforumid on table hsuforum_track_prefs to forumid $table = new xmldb_table('hsuforum_track_prefs'); $field = new xmldb_field('hsuforumid', XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, XMLDB_NOTNULL, null, '0', 'userid'); // Conditionally launch rename field hsuforumid (if it exists) if ($dbman->field_exists($table, $field)) { $dbman->rename_field($table, $field, 'forumid'); } // hsuforum savepoint reached upgrade_mod_savepoint(true, 2011112907, 'hsuforum'); } // Moodle v2.2.0 release upgrade line // Put any upgrade step following this // Moodle v2.3.0 release upgrade line // Put any upgrade step following this // Moodle v2.4.0 release upgrade line // Put any upgrade step following this // Forcefully assign mod/hsuforum:allowforcesubscribe to frontpage role, as we missed that when // capability was introduced. if ($oldversion < 2012112901) { // If capability mod/hsuforum:allowforcesubscribe is defined then set it for frontpage role. if (get_capability_info('mod/hsuforum:allowforcesubscribe')) { assign_legacy_capabilities('mod/hsuforum:allowforcesubscribe', array('frontpage' => CAP_ALLOW)); } // Forum savepoint reached. upgrade_mod_savepoint(true, 2012112901, 'hsuforum'); } if ($oldversion < 2012112902) { // Forum and hsuforum were reading from the same $CFG values, create new ones for hsuforum. $digestmailtime = 17; // Default in settings.php if (!empty($CFG->digestmailtime)) { $digestmailtime = $CFG->digestmailtime; } set_config('hsuforum_digestmailtime', $digestmailtime); $digestmailtimelast = 0; if (!empty($CFG->digestmailtimelast)) { $digestmailtimelast = $CFG->digestmailtimelast; } set_config('hsuforum_digestmailtimelast', $digestmailtimelast); // Forum savepoint reached. upgrade_mod_savepoint(true, 2012112902, 'hsuforum'); } if ($oldversion < 2013020500) { // Define field displaywordcount to be added to forum. $table = new xmldb_table('hsuforum'); $field = new xmldb_field('displaywordcount', XMLDB_TYPE_INTEGER, '1', null, XMLDB_NOTNULL, null, '0', 'completionposts'); // Conditionally launch add field displaywordcount. if (!$dbman->field_exists($table, $field)) { $dbman->add_field($table, $field); } // Forum savepoint reached. upgrade_mod_savepoint(true, 2013020500, 'hsuforum'); } // Moodle v2.5.0 release upgrade line. // Put any upgrade step following this. if ($oldversion < 2014021900) { // Define table hsuforum_digests to be created. $table = new xmldb_table('hsuforum_digests'); // Adding fields to table hsuforum_digests. $table->add_field('id', XMLDB_TYPE_INTEGER, '10', null, XMLDB_NOTNULL, XMLDB_SEQUENCE, null); $table->add_field('userid', XMLDB_TYPE_INTEGER, '10', null, XMLDB_NOTNULL, null, null); $table->add_field('forum', XMLDB_TYPE_INTEGER, '10', null, XMLDB_NOTNULL, null, null); $table->add_field('maildigest', XMLDB_TYPE_INTEGER, '1', null, XMLDB_NOTNULL, null, '-1'); // Adding keys to table hsuforum_digests. $table->add_key('primary', XMLDB_KEY_PRIMARY, array('id')); $table->add_key('userid', XMLDB_KEY_FOREIGN, array('userid'), 'user', array('id')); $table->add_key('forum', XMLDB_KEY_FOREIGN, array('forum'), 'forum', array('id')); $table->add_key('forumdigest', XMLDB_KEY_UNIQUE, array('forum', 'userid', 'maildigest')); // Conditionally launch create table for hsuforum_digests. if (!$dbman->table_exists($table)) { $dbman->create_table($table); } // Forum savepoint reached. upgrade_mod_savepoint(true, 2014021900, 'hsuforum'); } // Moodle v2.6.0 release upgrade line. // Put any upgrade step following this. if ($oldversion < 2014040400) { // Define index userid-postid (not unique) to be dropped form hsuforum_read. $table = new xmldb_table('hsuforum_read'); $index = new xmldb_index('userid-postid', XMLDB_INDEX_NOTUNIQUE, array('userid', 'postid')); // Conditionally launch drop index userid-postid. if ($dbman->index_exists($table, $index)) { $dbman->drop_index($table, $index); } // Define index postid-userid (not unique) to be added to hsuforum_read. $index = new xmldb_index('postid-userid', XMLDB_INDEX_NOTUNIQUE, array('postid', 'userid')); // Conditionally launch add index postid-userid. if (!$dbman->index_exists($table, $index)) { $dbman->add_index($table, $index); } // Forum savepoint reached. upgrade_mod_savepoint(true, 2014040400, 'hsuforum'); } // Moodle v2.7.0 release upgrade line. // Put any upgrade step following this. if ($oldversion < 2014051201) { // Incorrect values that need to be replaced. $replacements = array(11 => 20, 12 => 50, 13 => 100); // Run the replacements. foreach ($replacements as $old => $new) { $DB->set_field('hsuforum', 'maxattachments', $new, array('maxattachments' => $old)); } // Forum savepoint reached. upgrade_mod_savepoint(true, 2014051201, 'hsuforum'); } if ($oldversion < 2014051203) { // Find records with multiple userid/postid combinations and find the lowest ID. // Later we will remove all those which don't match this ID. $sql = "\n SELECT MIN(id) as lowid, userid, postid\n FROM {hsuforum_read}\n GROUP BY userid, postid\n HAVING COUNT(id) > 1"; if ($duplicatedrows = $DB->get_recordset_sql($sql)) { foreach ($duplicatedrows as $row) { $DB->delete_records_select('hsuforum_read', 'userid = ? AND postid = ? AND id <> ?', array($row->userid, $row->postid, $row->lowid)); } } $duplicatedrows->close(); // Forum savepoint reached. upgrade_mod_savepoint(true, 2014051203, 'hsuforum'); } if ($oldversion < 2014092400) { // Define fields to be added to hsuforum table. $table = new xmldb_table('hsuforum'); $fields = array(); $fields[] = new xmldb_field('showsubstantive', XMLDB_TYPE_INTEGER, '1', null, XMLDB_NOTNULL, null, '0', 'displaywordcount'); $fields[] = new xmldb_field('showbookmark', XMLDB_TYPE_INTEGER, '1', null, XMLDB_NOTNULL, null, '0', 'showsubstantive'); // Go through each field and add if it doesn't already exist. foreach ($fields as $field) { // Conditionally launch add field. if (!$dbman->field_exists($table, $field)) { $dbman->add_field($table, $field); } } // Hsuforum savepoint reached. upgrade_mod_savepoint(true, 2014092400, 'hsuforum'); } if ($oldversion < 2014093000) { // Define fields to be added to hsuforum table. $table = new xmldb_table('hsuforum'); $field = new xmldb_field('allowprivatereplies', XMLDB_TYPE_INTEGER, '1', null, XMLDB_NOTNULL, null, '0', 'showbookmark'); // Conditionally launch add field. if (!$dbman->field_exists($table, $field)) { $dbman->add_field($table, $field); } // Hsuforum savepoint reached. upgrade_mod_savepoint(true, 2014093000, 'hsuforum'); } if ($oldversion < 2014093001) { // Set default settings for existing forums. $DB->execute("\n UPDATE {hsuforum}\n SET allowprivatereplies = 1,\n showsubstantive = 1,\n showbookmark = 1\n\n "); // Hsuforum savepoint reached. upgrade_mod_savepoint(true, 2014093001, 'hsuforum'); } // Convert global configs to plugin configs if ($oldversion < 2014100600) { $configs = array('allowforcedreadtracking', 'cleanreadtime', 'digestmailtime', 'digestmailtimelast', 'disablebookmark', 'disablesubstantive', 'displaymode', 'enablerssfeeds', 'enabletimedposts', 'lastreadclean', 'longpost', 'manydiscussions', 'maxattachments', 'maxbytes', 'oldpostdays', 'replytouser', 'shortpost', 'showbookmark', 'showsubstantive', 'trackingtype', 'trackreadposts', 'usermarksread'); // Migrate legacy configs to plugin configs. foreach ($configs as $config) { $oldvar = 'hsuforum_' . $config; if (isset($CFG->{$oldvar})) { // Set new config variable up based on legacy config. set_config($config, $CFG->{$oldvar}, 'hsuforum'); // Delete legacy config. unset_config($oldvar); } } // Hsuforum savepoint reached. upgrade_mod_savepoint(true, 2014100600, 'hsuforum'); } if ($oldversion < 2014121700) { // Define fields to be added to hsuforum table. $table = new xmldb_table('hsuforum'); $field = new xmldb_field('showrecent', XMLDB_TYPE_INTEGER, '1', null, XMLDB_NOTNULL, null, '0', 'displaywordcount'); // Conditionally launch add field. if (!$dbman->field_exists($table, $field)) { $dbman->add_field($table, $field); } // Hsuforum savepoint reached. upgrade_mod_savepoint(true, 2014121700, 'hsuforum'); } return true; }
/** * This file keeps track of upgrades to * the forum module * * Sometimes, changes between versions involve * alterations to database structures and other * major things that may break installations. * * The upgrade function in this file will attempt * to perform all the necessary actions to upgrade * your older installation to the current version. * * If there's something it cannot do itself, it * will tell you what you need to do. * * The commands in here will all be database-neutral, * using the methods of database_manager class * * Please do not forget to use upgrade_set_timeout() * before any action that may take longer time to finish. * * @package mod_forum * @copyright 2003 onwards Eloy Lafuente (stronk7) {@link http://stronk7.com} * @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later */ function xmldb_forum_upgrade($oldversion) { global $CFG, $DB, $OUTPUT; $dbman = $DB->get_manager(); // Loads ddl manager and xmldb classes. // Moodle v2.2.0 release upgrade line. // Put any upgrade step following this. // Moodle v2.3.0 release upgrade line. // Put any upgrade step following this. // Moodle v2.4.0 release upgrade line. // Put any upgrade step following this. if ($oldversion < 2013020500) { // Define field displaywordcount to be added to forum. $table = new xmldb_table('forum'); $field = new xmldb_field('displaywordcount', XMLDB_TYPE_INTEGER, '1', null, XMLDB_NOTNULL, null, '0', 'completionposts'); // Conditionally launch add field displaywordcount. if (!$dbman->field_exists($table, $field)) { $dbman->add_field($table, $field); } // Forum savepoint reached. upgrade_mod_savepoint(true, 2013020500, 'forum'); } // Forcefully assign mod/forum:allowforcesubscribe to frontpage role, as we missed that when // capability was introduced. if ($oldversion < 2013021200) { // If capability mod/forum:allowforcesubscribe is defined then set it for frontpage role. if (get_capability_info('mod/forum:allowforcesubscribe')) { assign_legacy_capabilities('mod/forum:allowforcesubscribe', array('frontpage' => CAP_ALLOW)); } // Forum savepoint reached. upgrade_mod_savepoint(true, 2013021200, 'forum'); } // Moodle v2.5.0 release upgrade line. // Put any upgrade step following this. if ($oldversion < 2013071000) { // Define table forum_digests to be created. $table = new xmldb_table('forum_digests'); // Adding fields to table forum_digests. $table->add_field('id', XMLDB_TYPE_INTEGER, '10', null, XMLDB_NOTNULL, XMLDB_SEQUENCE, null); $table->add_field('userid', XMLDB_TYPE_INTEGER, '10', null, XMLDB_NOTNULL, null, null); $table->add_field('forum', XMLDB_TYPE_INTEGER, '10', null, XMLDB_NOTNULL, null, null); $table->add_field('maildigest', XMLDB_TYPE_INTEGER, '1', null, XMLDB_NOTNULL, null, '-1'); // Adding keys to table forum_digests. $table->add_key('primary', XMLDB_KEY_PRIMARY, array('id')); $table->add_key('userid', XMLDB_KEY_FOREIGN, array('userid'), 'user', array('id')); $table->add_key('forum', XMLDB_KEY_FOREIGN, array('forum'), 'forum', array('id')); $table->add_key('forumdigest', XMLDB_KEY_UNIQUE, array('forum', 'userid', 'maildigest')); // Conditionally launch create table for forum_digests. if (!$dbman->table_exists($table)) { $dbman->create_table($table); } // Forum savepoint reached. upgrade_mod_savepoint(true, 2013071000, 'forum'); } // Moodle v2.6.0 release upgrade line. // Put any upgrade step following this. if ($oldversion < 2014040400) { // Define index userid-postid (not unique) to be dropped form forum_read. $table = new xmldb_table('forum_read'); $index = new xmldb_index('userid-postid', XMLDB_INDEX_NOTUNIQUE, array('userid', 'postid')); // Conditionally launch drop index userid-postid. if ($dbman->index_exists($table, $index)) { $dbman->drop_index($table, $index); } // Define index postid-userid (not unique) to be added to forum_read. $index = new xmldb_index('postid-userid', XMLDB_INDEX_NOTUNIQUE, array('postid', 'userid')); // Conditionally launch add index postid-userid. if (!$dbman->index_exists($table, $index)) { $dbman->add_index($table, $index); } // Forum savepoint reached. upgrade_mod_savepoint(true, 2014040400, 'forum'); } // Moodle v2.7.0 release upgrade line. // Put any upgrade step following this. if ($oldversion < 2014051201) { // Incorrect values that need to be replaced. $replacements = array(11 => 20, 12 => 50, 13 => 100); // Run the replacements. foreach ($replacements as $old => $new) { $DB->set_field('forum', 'maxattachments', $new, array('maxattachments' => $old)); } // Forum savepoint reached. upgrade_mod_savepoint(true, 2014051201, 'forum'); } return true; }
/** * Updates the capabilities table with the component capability definitions. * If no parameters are given, the function updates the core moodle * capabilities. * * Note that the absence of the db/access.php capabilities definition file * will cause any stored capabilities for the component to be removed from * the database. * * @param $component - examples: 'moodle', 'mod/forum', 'block/quiz_results' * @return boolean */ function update_capabilities($component = 'moodle') { $storedcaps = array(); $filecaps = load_capability_def($component); $cachedcaps = get_cached_capabilities($component); if ($cachedcaps) { foreach ($cachedcaps as $cachedcap) { array_push($storedcaps, $cachedcap->name); // update risk bitmasks and context levels in existing capabilities if needed if (array_key_exists($cachedcap->name, $filecaps)) { if (!array_key_exists('riskbitmask', $filecaps[$cachedcap->name])) { $filecaps[$cachedcap->name]['riskbitmask'] = 0; // no risk if not specified } if ($cachedcap->riskbitmask != $filecaps[$cachedcap->name]['riskbitmask']) { $updatecap = new object(); $updatecap->id = $cachedcap->id; $updatecap->riskbitmask = $filecaps[$cachedcap->name]['riskbitmask']; if (!update_record('capabilities', $updatecap)) { return false; } } if (!array_key_exists('contextlevel', $filecaps[$cachedcap->name])) { $filecaps[$cachedcap->name]['contextlevel'] = 0; // no context level defined } if ($cachedcap->contextlevel != $filecaps[$cachedcap->name]['contextlevel']) { $updatecap = new object(); $updatecap->id = $cachedcap->id; $updatecap->contextlevel = $filecaps[$cachedcap->name]['contextlevel']; if (!update_record('capabilities', $updatecap)) { return false; } } } } } // Are there new capabilities in the file definition? $newcaps = array(); foreach ($filecaps as $filecap => $def) { if (!$storedcaps || $storedcaps && in_array($filecap, $storedcaps) === false) { if (!array_key_exists('riskbitmask', $def)) { $def['riskbitmask'] = 0; // no risk if not specified } $newcaps[$filecap] = $def; } } // Add new capabilities to the stored definition. foreach ($newcaps as $capname => $capdef) { $capability = new object(); $capability->name = $capname; $capability->captype = $capdef['captype']; $capability->contextlevel = $capdef['contextlevel']; $capability->component = $component; $capability->riskbitmask = $capdef['riskbitmask']; if (!insert_record('capabilities', $capability, false, 'id')) { return false; } // Do we need to assign the new capabilities to roles that have the // legacy capabilities moodle/legacy:* as well? if (isset($capdef['legacy']) && is_array($capdef['legacy']) && !assign_legacy_capabilities($capname, $capdef['legacy'])) { notify('Could not assign legacy capabilities for ' . $capname); } } // Are there any capabilities that have been removed from the file // definition that we need to delete from the stored capabilities and // role assignments? capabilities_cleanup($component, $filecaps); return true; }