function xmldb_forumng_upgrade($oldversion = 0) { global $CFG, $THEME, $db; require_once $CFG->dirroot . '/mod/forumng/forum.php'; $result = true; /// And upgrade begins here. For each one, you'll need one /// block of code similar to the next one. Please, delete /// this comment lines once this file start handling proper /// upgrade code. /// if ($result && $oldversion < YYYYMMDD00) { //New version in version.php /// $result = result of "/lib/ddllib.php" function calls /// } if ($result && $oldversion < 2009071703) { /// Add search data require_once dirname(__FILE__) . '/../lib.php'; require_once dirname(__FILE__) . '/../forum.php'; if (forum::search_installed()) { global $db; $olddebug = $db->debug; $db->debug = false; print '<ul>'; forumng_ousearch_update_all(true); print '</ul>'; $db->debug = $olddebug; } } if ($result && $oldversion < 2009102001) { /// Define table forumng_drafts to be created $table = new XMLDBTable('forumng_drafts'); /// Adding fields to table forumng_drafts $table->addFieldInfo('id', XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, XMLDB_NOTNULL, XMLDB_SEQUENCE, null, null, null); $table->addFieldInfo('userid', XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, XMLDB_NOTNULL, null, null, null, null); $table->addFieldInfo('forumid', XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, XMLDB_NOTNULL, null, null, null, null); $table->addFieldInfo('groupid', XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, null, null, null, null, null); $table->addFieldInfo('parentpostid', XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, null, null, null, null, null); $table->addFieldInfo('subject', XMLDB_TYPE_CHAR, '255', null, null, null, null, null, null); $table->addFieldInfo('message', XMLDB_TYPE_TEXT, 'small', null, XMLDB_NOTNULL, null, null, null, null); $table->addFieldInfo('format', XMLDB_TYPE_INTEGER, '1', XMLDB_UNSIGNED, XMLDB_NOTNULL, null, null, null, null); $table->addFieldInfo('attachments', XMLDB_TYPE_INTEGER, '1', XMLDB_UNSIGNED, XMLDB_NOTNULL, null, null, null, '0'); $table->addFieldInfo('saved', XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, XMLDB_NOTNULL, null, null, null, null); $table->addFieldInfo('options', XMLDB_TYPE_TEXT, 'small', null, null, null, null, null, null); /// Adding keys to table forumng_drafts $table->addKeyInfo('primary', XMLDB_KEY_PRIMARY, array('id')); $table->addKeyInfo('userid', XMLDB_KEY_FOREIGN, array('userid'), 'user', array('id')); $table->addKeyInfo('forumid', XMLDB_KEY_FOREIGN, array('forumid'), 'forumng', array('id')); $table->addKeyInfo('parentpostid', XMLDB_KEY_FOREIGN, array('parentpostid'), 'forumng_posts', array('id')); /// Launch create table for forumng_drafts $result = $result && create_table($table); } if ($result && $oldversion < 2009110401) { /// Define field important to be added to forumng_posts $table = new XMLDBTable('forumng_posts'); $field = new XMLDBField('important'); $field->setAttributes(XMLDB_TYPE_INTEGER, '1', XMLDB_UNSIGNED, XMLDB_NOTNULL, null, null, null, '0', 'deleteuserid'); /// Launch add field important $result = $result && add_field($table, $field); } if ($result && $oldversion < 2009110600) { /// Define field subscribed to be added to forumng_subscriptions $table = new XMLDBTable('forumng_subscriptions'); $field = new XMLDBField('subscribed'); $field->setAttributes(XMLDB_TYPE_INTEGER, '1', XMLDB_UNSIGNED, XMLDB_NOTNULL, null, null, null, '1', 'forumid'); /// Launch add field subscribed $result = $result && add_field($table, $field); /// Changing the default of field subscribed on table forumng_subscriptions to drop it $table = new XMLDBTable('forumng_subscriptions'); $field = new XMLDBField('subscribed'); $field->setAttributes(XMLDB_TYPE_INTEGER, '1', XMLDB_UNSIGNED, XMLDB_NOTNULL, null, null, null, null, 'forumid'); /// Launch change of default for field subscribed $result = $result && change_field_default($table, $field); } if ($result && $oldversion < 2009111001) { /// Define field reportingemail to be added to forumng $table = new XMLDBTable('forumng'); $field = new XMLDBField('reportingemail'); $field->setAttributes(XMLDB_TYPE_CHAR, '255', null, null, null, null, null, null, 'attachmentmaxbytes'); /// Launch add field reportingemail $result = $result && add_field($table, $field); } if ($result && $oldversion < 2009111002) { /// Define table forumng_flags to be created $table = new XMLDBTable('forumng_flags'); /// Adding fields to table forumng_flags $table->addFieldInfo('id', XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, XMLDB_NOTNULL, XMLDB_SEQUENCE, null, null, null); $table->addFieldInfo('userid', XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, XMLDB_NOTNULL, null, null, null, null); $table->addFieldInfo('postid', XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, XMLDB_NOTNULL, null, null, null, null); $table->addFieldInfo('flagged', XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, XMLDB_NOTNULL, null, null, null, null); /// Adding keys to table forumng_flags $table->addKeyInfo('primary', XMLDB_KEY_PRIMARY, array('id')); $table->addKeyInfo('userid', XMLDB_KEY_FOREIGN, array('userid'), 'user', array('id')); $table->addKeyInfo('postid', XMLDB_KEY_FOREIGN, array('postid'), 'forumng_posts', array('id')); /// Launch create table for forumng_flags $result = $result && create_table($table); } if ($result && $oldversion < 2009120200) { // For OU version only, rebuild course cache - it is missing some of // the completion information if (class_exists('ouflags')) { rebuild_course_cache(0, true); } } if ($result && $oldversion < 2010020200) { /// Define field discussionid to be added to forumng_subscriptions $table = new XMLDBTable('forumng_subscriptions'); $field = new XMLDBField('discussionid'); $field->setAttributes(XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, null, null, null, null, null, 'subscribed'); /// Launch add field discussionid $result = $result && add_field($table, $field); } if ($result && $oldversion < 2010051300) { /// Define field removeafter to be added to forumng $table = new XMLDBTable('forumng'); $field = new XMLDBField('removeafter'); $field->setAttributes(XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, XMLDB_NOTNULL, null, null, null, '0', 'completionposts'); /// Launch add field removeafter $result = $result && add_field($table, $field); $field = new XMLDBField('removeto'); $field->setAttributes(XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, null, null, null, null, null, 'removeafter'); /// Launch add field removeto $result = $result && add_field($table, $field); } if ($result && $oldversion < 2010071900) { /// Define field shared to be added to forumng $table = new XMLDBTable('forumng'); $field = new XMLDBField('shared'); $field->setAttributes(XMLDB_TYPE_INTEGER, '1', XMLDB_UNSIGNED, XMLDB_NOTNULL, null, null, null, '0', 'removeto'); /// Launch add field shared $result = $result && add_field($table, $field); /// Define field originalcmid to be added to forumng $field = new XMLDBField('originalcmid'); $field->setAttributes(XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, null, null, null, null, null, 'shared'); /// Launch add field originalcmid $result = $result && add_field($table, $field); /// Define key originalcmid (foreign) to be added to forumng $key = new XMLDBKey('originalcmid'); $key->setAttributes(XMLDB_KEY_FOREIGN, array('originalcmid'), 'course_modules', array('id')); /// Launch add key originalcmid $result = $result && add_key($table, $key); } if ($result && $oldversion < 2010072100) { /// Define field clonecmid to be added to forumng_subscriptions $table = new XMLDBTable('forumng_subscriptions'); $field = new XMLDBField('clonecmid'); $field->setAttributes(XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, null, null, null, null, null, 'discussionid'); /// Launch add field clonecmid $result = $result && add_field($table, $field); /// Define key clonecmid (foreign) to be added to forumng_subscriptions $key = new XMLDBKey('clonecmid'); $key->setAttributes(XMLDB_KEY_FOREIGN, array('clonecmid'), 'course_modules', array('id')); /// Launch add key clonecmid $result = $result && add_key($table, $key); } if ($result && $oldversion < 2010073000) { /// Define field groupid to be added to forumng_subscriptions $table = new XMLDBTable('forumng_subscriptions'); $field = new XMLDBField('groupid'); $field->setAttributes(XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, null, null, null, null, null, 'clonecmid'); /// Launch add field groupid $result = $result && add_field($table, $field); } if ($result && $oldversion < 2010073001) { $db->debug = false; forum::group_subscription_update(true); $db->debug = true; } return $result; }
function forumng_decode_content_links_caller($restore) { // Get all the items that might have links in, from the relevant new course try { global $CFG, $db; // 1. Intros if ($intros = get_records_select('forumng', 'course=' . $restore->course_id . ' AND intro IS NOT NULL', '', 'id, intro, name')) { foreach ($intros as $intro) { $newintro = $intro->intro; // Special behaviour hidden in intro $matches = array(); if (preg_match('~%%CMIDNUMBER:([^%]+)%%$~', $newintro, $matches)) { $newintro = substr($newintro, 0, -strlen($matches[0])); $idnumber = $matches[1]; $cm = forum::get_shared_cm_from_idnumber($idnumber); if ($cm) { set_field('forumng', 'originalcmid', $cm->id, 'id', $intro->id); } else { // The original forum cannot be found, so restore // this as not shared if (!defined('RESTORE_SILENTLY')) { $a = (object) array('name' => s($intro->name), 'idnumber' => s($idnumber)); print '<br />' . get_string('error_nosharedforum', 'forumng', $a) . '<br />'; } } } if (preg_match('~%%REMOVETHIS%%$~', $newintro)) { $newintro = substr($newintro, 0, -14); } $newintro = restore_decode_content_links_worker($newintro, $restore); if ($newintro != $intro->intro) { if (!set_field('forumng', 'intro', addslashes($newintro), 'id', $intro->id)) { throw new forum_exception("Failed to set intro for forum {$intro->id}: " . $db->ErrorMsg()); } } } } // 2. Post content $rs = get_recordset_sql("\nSELECT\n fp.id, fp.message, fp.format\nFROM\n {$CFG->prefix}forumng f\n INNER JOIN {$CFG->prefix}forumng_discussions d ON d.forumid = f.id\n INNER JOIN {$CFG->prefix}forumng_posts fp ON fp.discussionid = d.id\nWHERE\n f.course={$restore->course_id}\n"); if (!$rs) { throw new forum_exception("Failed to query for forum data: " . $db->ErrorMsg()); } while ($rec = rs_fetch_next_record($rs)) { $newcontent = restore_decode_content_links_worker($rec->message, $restore); if ($newcontent != $rec->message) { if (!set_field('forumng_posts', 'message', addslashes($newcontent), 'id', $rec->id)) { throw new forum_exception("Failed to update content {$ec->id}: " . $db->ErrorMsg()); } } } rs_close($rs); // 3. Update search data (note this is not actually do with content // links, but it has to be done here because we need a course-module // id. if (forum::search_installed()) { forumng_ousearch_update_all(false, $restore->course_id); } return true; } catch (Exception $e) { forum_utils::handle_backup_exception($e, 'restore'); return false; } }