function forumng_backup_one_mod($bf, $preferences, $forumng) { global $CFG; try { if (is_numeric($forumng)) { $forumng = forum_utils::get_record('forumng', 'id', $forumng); } $xb = new xml_backup($bf, $preferences, 3); $xb->tag_start('MOD'); // Required bits $xb->tag_full('ID', $forumng->id); $xb->tag_full('MODTYPE', 'forumng'); $xb->tag_full('NAME', $forumng->name); // Backup versioning require dirname(__FILE__) . '/version.php'; $xb->tag_full('FORUMNG_VERSION', $module->version); // Are we doing user data? $userdata = backup_userdata_selected($preferences, 'forumng', $forumng->id); // ForumNG-specific $xb->tag_full_notnull('TYPE', $forumng->type); $xb->tag_full_notnull('INTRO', $forumng->intro); $xb->tag_full('RATINGSCALE', $forumng->ratingscale); $xb->tag_full('RATINGFROM', $forumng->ratingfrom); $xb->tag_full('RATINGUNTIL', $forumng->ratinguntil); $xb->tag_full('RATINGTHRESHOLD', $forumng->ratingthreshold); $xb->tag_full('GRADING', $forumng->grading); $xb->tag_full('ATTACHMENTMAXBYTES', $forumng->attachmentmaxbytes); $xb->tag_full('REPORTINGEMAIL', $forumng->reportingemail); $xb->tag_full('SUBSCRIPTION', $forumng->subscription); $xb->tag_full('FEEDTYPE', $forumng->feedtype); $xb->tag_full('FEEDITEMS', $forumng->feeditems); $xb->tag_full('MAXPOSTSPERIOD', $forumng->maxpostsperiod); $xb->tag_full('MAXPOSTSBLOCK', $forumng->maxpostsblock); $xb->tag_full('POSTINGFROM', $forumng->postingfrom); $xb->tag_full('POSTINGUNTIL', $forumng->postinguntil); $xb->tag_full_notnull('TYPEDATA', $forumng->typedata); $xb->tag_full('MAGICNUMBER', $forumng->magicnumber); $xb->tag_full('COMPLETIONDISCUSSIONS', $forumng->completiondiscussions); $xb->tag_full('COMPLETIONREPLIES', $forumng->completionreplies); $xb->tag_full('COMPLETIONPOSTS', $forumng->completionposts); $xb->tag_full('REMOVEAFTER', $forumng->removeafter); $xb->tag_full('REMOVETO', $forumng->removeto); $xb->tag_full('SHARED', $forumng->shared); // When this is a clone forum, we store the idnumber of the original // forum so that it can be found afterward; this makes sense rather // than using the normal cmid mapping because it might be on a different // course or something, also idnumber is shown in the interface. if ($forumng->originalcmid) { $idnumber = get_field('course_modules', 'idnumber', 'id', $forumng->originalcmid); if ($idnumber) { $xb->tag_full('ORIGINALCMIDNUMBER', $idnumber); } } // We only back up most content when 'user data' is turned on if ($userdata) { $xb->tag_start('DISCUSSIONS'); $rs = forum_utils::get_recordset('forumng_discussions', 'forumid', $forumng->id); while ($discussion = rs_fetch_next_record($rs)) { forumng_backup_discussion($xb, $discussion); } rs_close($rs); $xb->tag_end('DISCUSSIONS'); $xb->tag_start('SUBSCRIPTIONS'); $rs = forum_utils::get_recordset('forumng_subscriptions', 'forumid', $forumng->id); while ($subscription = rs_fetch_next_record($rs)) { forumng_backup_subscription($xb, $subscription); } rs_close($rs); $xb->tag_end('SUBSCRIPTIONS'); forumng_backup_files($bf, $preferences, $forumng->id); } $xb->tag_end('MOD'); return true; } catch (Exception $e) { forum_utils::handle_backup_exception($e); return false; } }
/** * @param int $userid User ID or 0 for default * @return User object */ static function get_user($userid = 0) { global $USER; if ($userid && (empty($USER->id) || $USER->id != $userid)) { $user = forum_utils::get_record('id', $userid); } else { $user = $USER; } }
$author = stripslashes(trim(optional_param('author', null, PARAM_RAW))); $daterangefrom = optional_param('datefrom', 0, PARAM_INT); $daterangeto = optional_param('dateto', 0, PARAM_INT); $cloneid = optional_param('clone', 0, PARAM_INT); try { // Search in a single forum if ($cmid) { $forum = forum::get_from_cmid($cmid, $cloneid); $cm = $forum->get_course_module(); $course = $forum->get_course(); $forum->require_view(forum::NO_GROUPS, 0, true); forum::search_installed(); $allforums = false; } if ($courseid) { $course = forum_utils::get_record('course', 'id', $courseid); require_login($course); $coursecontext = get_context_instance(CONTEXT_COURSE, $courseid); forum::search_installed(); $allforums = true; } //display the form $editform = new advancedsearch_form('advancedsearch.php', array('course' => $courseid, 'id' => $cmid, 'cloneid' => $cloneid), 'get'); $inputdata = new stdClass(); $inputdata->query = $query; $inputdata->author = $author; $inputdata->daterangefrom = $daterangefrom; $inputdata->daterangeto = $daterangeto; $editform->set_data($inputdata); $data = $editform->get_data(); if ($editform->is_cancelled()) {
/** * Creates a new ForumNG by copying data (including all messages etc) from * an old forum. The old forum will be hidden. * * Behaviour is undefined if the old forum wasn't eligible for conversion * (forum_utils::get_convertible_forums). * @param object $course Moodle course object * @param int $forumcmid Old forum to convert * @param bool $progress If true, print progress to output * @param bool $hide If true, newly-created forum is also hidden * @param bool $nodata If true, no user data (posts, subscriptions, etc) * is copied; you only get a forum with same configuration * @param bool $insection If true, remeber to create the new forumNG in the same section. * @throws forum_exception If any error occurs */ public static function create_from_old_forum($course, $forumcmid, $progress, $hide, $nodata, $insection = true) { global $CFG; // Start the clock and a database transaction $starttime = microtime(true); forum_utils::start_transaction(); // Note we do not use get_fast_modinfo because it doesn't contain the // complete $cm object. $cm = forum_utils::get_record('course_modules', 'id', $forumcmid); $forum = forum_utils::get_record('forum', 'id', $cm->instance); if ($progress) { print_heading(s($forum->name), '', 3); print '<ul><li>' . get_string('convert_process_init', 'forumng'); flush(); } // Hide forum forum_utils::update_record('course_modules', (object) array('id' => $cm->id, 'visible' => 0)); // Table for changed subscription constants $subscriptiontranslate = array(0 => 1, 1 => 3, 2 => 2, 3 => 0); // Get, convert, and create forum table data $forumng = (object) array('course' => $course->id, 'name' => addslashes($forum->name), 'type' => 'general', 'intro' => addslashes($forum->intro), 'ratingscale' => $forum->scale, 'ratingfrom' => $forum->assesstimestart, 'ratinguntil' => $forum->assesstimefinish, 'ratingthreshold' => 1, 'grading' => $forum->assessed, 'attachmentmaxbytes' => $forum->maxbytes, 'subscription' => $subscriptiontranslate[$forum->forcesubscribe], 'feedtype' => $forum->rsstype, 'feeditems' => $forum->rssarticles, 'maxpostsperiod' => $forum->blockperiod, 'maxpostsblock' => $forum->blockafter, 'postingfrom' => 0, 'postinguntil' => 0, 'typedata' => null); require_once $CFG->dirroot . '/mod/forumng/lib.php'; // Note: The idnumber is required. We cannot copy it because then there // would be a duplicate idnumber. Let's just leave blank, people will // have to configure this manually. $forumng->cmidnumber = ''; if (!($newforumid = forumng_add_instance($forumng))) { throw new forum_exception("Failed to add forumng instance"); } // Create and add course-modules entry $newcm = new stdClass(); $newcm->course = $course->id; $newcm->module = get_field('modules', 'id', 'name', 'forumng'); if (!$newcm->module) { throw new forum_exception("Cannot find forumng module id"); } $newcm->instance = $newforumid; $newcm->section = $cm->section; $newcm->added = time(); $newcm->score = $cm->score; $newcm->indent = $cm->indent; $newcm->visible = 0; // Forums are always hidden until finished $newcm->groupmode = $cm->groupmode; $newcm->groupingid = $cm->groupingid; $newcm->idnumber = $cm->idnumber; $newcm->groupmembersonly = $cm->groupmembersonly; // Include extra OU-specific data if (class_exists('ouflags')) { $newcm->showto = $cm->showto; $newcm->stealth = $cm->stealth; $newcm->parentcmid = $cm->parentcmid; $newcm->completion = $cm->completion; $newcm->completiongradeitemnumber = $cm->completiongradeitemnumber; $newcm->completionview = $cm->completionview; $newcm->availablefrom = $cm->availablefrom; $newcm->availableuntil = $cm->availableuntil; $newcm->showavailability = $cm->showavailability; $newcm->parentpagename = $cm->parentpagename; } // Add $newcm->id = forum_utils::insert_record('course_modules', $newcm); // Update section if ($insection) { $section = forum_utils::get_record('course_sections', 'id', $newcm->section); $updatesection = (object) array('id' => $section->id, 'sequence' => str_replace($cm->id, $cm->id . ',' . $newcm->id, $section->sequence)); if ($updatesection->sequence == $section->sequence) { throw new forum_exception("Unable to update sequence"); } forum_utils::update_record('course_sections', $updatesection); } // Construct forum object for new forum $newforum = self::get_from_id($forumng->id, forum::CLONE_DIRECT); if ($progress) { print ' ' . get_string('convert_process_state_done', 'forumng') . '</li>'; } if (!$nodata) { // Convert subscriptions switch ($newforum->get_effective_subscription_option()) { case self::SUBSCRIPTION_PERMITTED: if ($progress) { print '<li>' . get_string('convert_process_subscriptions_normal', 'forumng'); flush(); } // Standard subscription - just copy subscriptions $rs = forum_utils::get_recordset('forum_subscriptions', 'forum', $forum->id); while ($rec = rs_fetch_next_record($rs)) { forum_utils::insert_record('forumng_subscriptions', (object) array('forumid' => $forumng->id, 'userid' => $rec->userid, 'subscribed' => 1)); } rs_close($rs); if ($progress) { print ' ' . get_string('convert_process_state_done', 'forumng') . '</li>'; } break; case self::SUBSCRIPTION_INITIALLY_SUBSCRIBED: // Initial subscription is handled differently; the old forum // stores all the subscriptions in the database, while in this // forum we only store people who chose to unsubscribe if ($progress) { print '<li>' . get_string('convert_process_subscriptions_initial', 'forumng'); flush(); } // Get list of those subscribed on old forum $rs = forum_utils::get_recordset('forum_subscriptions', 'forum', $forum->id); $subscribedbefore = array(); while ($rec = rs_fetch_next_record($rs)) { $subscribedbefore[$rec->userid] = true; } rs_close(); // Get list of those subscribed on new forum $new = $newforum->get_subscribers(); // For anyone in the new list but not the old list, add an // unsubscribe foreach ($new as $user) { if (!array_key_exists($user->id, $subscribedbefore)) { forum_utils::insert_record('forumng_subscriptions', (object) array('forumid' => $forumng->id, 'userid' => $user->id, 'subscribed' => 0)); } } if ($progress) { print ' ' . get_string('convert_process_state_done', 'forumng') . '</li>'; } break; } // Convert discussions if ($progress) { print '<li>' . get_string('convert_process_discussions', 'forumng'); flush(); } $rsd = forum_utils::get_recordset('forum_discussions', 'forum', $forum->id); $count = 0; while ($recd = rs_fetch_next_record($rsd)) { // Convert discussion options $newd = (object) array('forumid' => $forumng->id, 'timestart' => $recd->timestart, 'timeend' => $recd->timeend, 'deleted' => 0, 'locked' => 0, 'sticky' => 0); if ($recd->groupid == -1 || !$newcm->groupmode) { $newd->groupid = null; } else { $newd->groupid = $recd->groupid; } // Save discussion $newd->id = forum_utils::insert_record('forumng_discussions', $newd); // Convert posts $lastposttime = -1; $discussionupdate = (object) array('id' => $newd->id); $postids = array(); // From old post id to new post id $parentposts = array(); // From new post id to old parent id $subjects = array(); // From new id to subject text (no slashes) $rsp = forum_utils::get_recordset('forum_posts', 'discussion', $recd->id); while ($recp = rs_fetch_next_record($rsp)) { // Convert post $newp = (object) array('discussionid' => $newd->id, 'userid' => $recp->userid, 'created' => $recp->created, 'modified' => $recp->modified, 'deleted' => 0, 'deleteuserid' => null, 'mailstate' => self::MAILSTATE_DIGESTED, 'oldversion' => 0, 'edituserid' => null, 'subject' => addslashes($recp->subject), 'message' => addslashes($recp->message), 'format' => $recp->format, 'important' => 0); // Are there any attachments? $attachments = array(); if (class_exists('ouflags')) { // OU has customisation for existing forum that supports // multiple attachments $attachmentrecords = forum_utils::get_records('forum_attachments', 'postid', $recp->id); foreach ($attachmentrecords as $reca) { $attachments[] = $reca->attachment; } } else { // Standard forum uses attachment field for filename if ($recp->attachment) { $attachments[] = $recp->attachment; } } $newp->attachments = count($attachments) ? 1 : 0; // Add record $newp->id = forum_utils::insert_record('forumng_posts', $newp); // Remember details for later parent update $postids[$recp->id] = $newp->id; if ($recp->parent) { $parentposts[$newp->id] = $recp->parent; } else { $discussionupdate->postid = $newp->id; } if ($newp->created > $lastposttime) { $discussionupdate->lastpostid = $newp->id; } $subjects[$newp->id] = $recp->subject; // Copy attachments $oldfolder = $CFG->dataroot . "/{$course->id}/{$CFG->moddata}/forum/{$forum->id}/{$recp->id}"; $newfolder = forum_post::get_any_attachment_folder($course->id, $forumng->id, $newd->id, $newp->id); $filesok = 0; $filesfailed = 0; foreach ($attachments as $attachment) { // Create folder if it isn't there $attachment = clean_filename($attachment); check_dir_exists($newfolder, true, true); // Copy file try { forum_utils::copy("{$oldfolder}/{$attachment}", "{$newfolder}/{$attachment}"); $filesok++; } catch (forum_exception $e) { if ($progress) { print "[<strong>Warning</strong>: file copy failed for post " . $recp->id . " => " . $newp->id . ", file " . s($attachment) . "]"; } $filesfailed++; } } // If all files failed, clean up if ($filesfailed && !$filesok) { rmdir($newfolder); $noattachments = (object) array('id' => $newp->id, 'attachments' => 0); forum_utils::update_record('forumng_posts', $noattachments); } // Convert ratings if ($forumng->ratingscale) { $rsr = get_recordset('forum_ratings', 'post', $recp->id); while ($recr = rs_fetch_next_record($rsr)) { forum_utils::insert_record('forumng_ratings', (object) array('postid' => $newp->id, 'userid' => $recr->userid, 'time' => $recr->time, 'rating' => $recr->rating)); } rs_close($rsr); } } rs_close($rsp); // Update parent numbers $newparentids = array(); foreach ($parentposts as $newid => $oldparentid) { if (!array_key_exists($oldparentid, $postids)) { throw new forum_exception("Unknown parent post {$oldparentid}"); } $newparentid = $postids[$oldparentid]; forum_utils::update_record('forumng_posts', (object) array('id' => $newid, 'parentpostid' => $newparentid)); $newparentids[$newid] = $newparentid; } // Update subjects $removesubjects = array(); // Array of ints to cancel subjects foreach ($newparentids as $newid => $newparentid) { $subject = $subjects[$newid]; $parentsubject = $subjects[$newparentid]; if ($subject && ($subject == get_string('re', 'forum') . ' ' . $parentsubject || $subject == $parentsubject)) { $removesubjects[] = $newid; } } if (count($removesubjects)) { $in = forum_utils::in_or_equals($removesubjects); forum_utils::execute_sql("UPDATE {$CFG->prefix}forumng_posts SET subject=NULL WHERE id {$in}"); } // Update first/last post numbers forum_utils::update_record('forumng_discussions', $discussionupdate); // Convert read data $rsr = forum_utils::get_recordset_sql("\nSELECT\n userid, MAX(lastread) AS lastread\nFROM\n {$CFG->prefix}forum_read\nWHERE\n discussionid = {$recd->id}\nGROUP BY\n userid"); while ($recr = rs_fetch_next_record($rsr)) { forum_utils::insert_record('forumng_read', (object) array('discussionid' => $newd->id, 'userid' => $recr->userid, 'time' => $recr->lastread)); } rs_close($rsr); // Display dot for each discussion if ($progress) { print '.'; $count++; if ($count % 10 == 0) { print $count; } flush(); } } rs_close($rsd); if ($progress) { print ' ' . get_string('convert_process_state_done', 'forumng') . '</li>'; } } // Show forum if (!$hide && $cm->visible) { if ($progress) { print '<li>' . get_string('convert_process_show', 'forumng'); flush(); } $updatecm = (object) array('id' => $newcm->id, 'visible' => 1); forum_utils::update_record('course_modules', $updatecm); if ($progress) { print ' ' . get_string('convert_process_state_done', 'forumng') . '</li>'; } } // Transfer role assignments $oldcontext = get_context_instance(CONTEXT_MODULE, $cm->id); $newcontext = get_context_instance(CONTEXT_MODULE, $newcm->id); $roles = get_records('role_assignments', 'contextid', $oldcontext->id); if ($roles) { if ($progress) { print '<li>' . get_string('convert_process_assignments', 'forumng'); flush(); } foreach ($roles as $role) { $newrole = $role; $newrole->contextid = $newcontext->id; $newrole->enrol = addslashes($newrole->enrol); forum_utils::insert_record('role_assignments', $newrole); } if ($progress) { print ' ' . get_string('convert_process_state_done', 'forumng') . '</li>'; } } // Transfer capabilities $capabilities = array('moodle/course:viewhiddenactivities' => 'moodle/course:viewhiddenactivities', 'moodle/site:accessallgroups' => 'moodle/site:accessallgroups', 'moodle/site:trustcontent' => 'moodle/site:trustcontent', 'moodle/site:viewfullnames' => 'moodle/site:viewfullnames', 'mod/forum:viewdiscussion' => 'mod/forumng:viewdiscussion', 'mod/forum:startdiscussion' => 'mod/forumng:startdiscussion', 'mod/forum:replypost' => 'mod/forumng:replypost', 'mod/forum:viewrating' => 'mod/forumng:viewrating', 'mod/forum:viewanyrating' => 'mod/forumng:viewanyrating', 'mod/forum:rate' => 'mod/forumng:rate', 'mod/forum:createattachment' => 'mod/forumng:createattachment', 'mod/forum:deleteanypost' => 'mod/forumng:deleteanypost', 'mod/forum:splitdiscussions' => 'mod/forumng:splitdiscussions', 'mod/forum:movediscussions' => 'mod/forumng:movediscussions', 'mod/forum:editanypost' => 'mod/forumng:editanypost', 'mod/forum:viewsubscribers' => 'mod/forumng:viewsubscribers', 'mod/forum:managesubscriptions' => 'mod/forumng:managesubscriptions', 'mod/forum:viewhiddentimedposts' => 'mod/forumng:viewallposts'); $caps = get_records('role_capabilities', 'contextid', $oldcontext->id); if ($caps) { if ($progress) { print '<li>' . get_string('convert_process_overrides', 'forumng'); flush(); } foreach ($caps as $cap) { foreach ($capabilities as $key => $capability) { if ($cap->capability != $key) { continue; } $newcap = $cap; $newcap->contextid = $newcontext->id; $newcap->capability = $capability; $newcap->capability = addslashes($newcap->capability); forum_utils::insert_record('role_capabilities', $newcap); } } if ($progress) { print ' ' . get_string('convert_process_state_done', 'forumng') . '</li>'; } } // Do course cache rebuild_course_cache($course->id, true); // Update search data if (self::search_installed()) { if ($progress) { print '<li>' . get_string('convert_process_search', 'forumng') . '</li>'; flush(); } self::search_update_all($progress, $course->id, $newcm->id); } // OU only: Transfer external dashboard details to new forum if (class_exists('ouflags')) { if ($progress) { print '<li>' . get_string('convert_process_dashboard', 'forumng'); flush(); } require_once $CFG->dirroot . '/local/externaldashboard/external_dashboard.php'; $a = new stdClass(); list($a->yay, $a->nay) = external_dashboard::transfer_favourites($forumcmid, $newcm->id); if ($progress) { print ' ' . get_string('convert_process_dashboard_done', 'forumng', $a) . '</li>'; } } if ($progress) { print '<li>' . get_string('convert_process_update_subscriptions', 'forumng'); flush(); } self::group_subscription_update(false, $newcm->id); if ($progress) { print ' ' . get_string('convert_process_state_done', 'forumng') . '</li>'; } forum_utils::finish_transaction(); if ($progress) { $a = (object) array('seconds' => round(microtime(true) - $starttime, 1), 'link' => '<a href="view.php?id=' . $newcm->id . '">' . get_string('convert_newforum', 'forumng') . '</a>'); print '</ul><p>' . get_string('convert_process_complete', 'forumng', $a) . '</p>'; } }
if (!empty($fromform->alert_condition4)) { $alltext .= '* ' . get_string('alert_condition4', 'forumng') . "\n"; } if (!empty($fromform->alert_condition5)) { $alltext .= '* ' . get_string('alert_condition5', 'forumng') . "\n"; } if (!empty($fromform->alert_condition6)) { $alltext .= '* ' . get_string('alert_condition6', 'forumng') . "\n"; } if (!empty($fromform->alert_conditionmore)) { $alltext .= "\n" . $fromform->alert_conditionmore . "\n"; } //ccnote is only print when the email is sent to 2 different addresses //so that they can decide between themselves who should deal with the report $ccnote = ''; $forumfields = forum_utils::get_record('forumng', 'id', $forumid); $siteemail = $CFG->forumng_reportunacceptable; $forumemail = $forum->get_reportingemail(); $emailcopy = 1; if (!empty($siteemail) && $forumemail != null && $siteemail != $forumemail) { $emailcopy = 2; $fakeuser1 = (object) array('email' => $siteemail, 'mailformat' => 1, 'id' => 0, 'ccnote' => get_string('alert_note', 'forumng', $forumemail)); $fakeuser2 = (object) array('email' => $forumemail, 'mailformat' => 1, 'id' => 0, 'ccnote' => get_string('alert_note', 'forumng', $siteemail)); } else { if (!empty($siteemail)) { $fakeuser = (object) array('email' => $siteemail, 'mailformat' => 1, 'id' => 0); } else { $fakeuser = (object) array('email' => $forumemail, 'mailformat' => 1, 'id' => 0); } } $from = $USER;