function wipe_forums($courseid) { global $CFG; // Get list of course-module IDs $forumid = get_field('modules', 'id', 'name', 'forumng'); $cms = get_records_sql("\nSELECT\n id, course, instance, section\nFROM\n {$CFG->prefix}course_modules cm\nWHERE\n cm.module={$forumid} AND cm.course={$courseid}"); $cms = $cms ? $cms : array(); $count = count($cms); print "<h3>Wiping {$count} forums</h3><pre>"; $time = time(); $i = 0; foreach ($cms as $cm) { wipe_forumng($cm); print '.'; if (($i + 1) % 20 == 0) { print " (" . ($i + 1) . ")\n"; } flush(); $i++; } print "</pre>"; rebuild_course_cache($courseid); }
function wipe_forums($courseid) { global $DB; // Get list of course-module IDs $forumngid = $DB->get_field('modules', 'id', array('name' => 'forumng')); $cms = $DB->get_records_sql("\nSELECT\n id, course, instance, section\nFROM\n {course_modules} cm\nWHERE\n cm.module = ? AND cm.course = ?", array($forumngid, $courseid)); $count = count($cms); print "<h3>Wiping {$count} forums</h3><pre>"; $time = time(); $i = 0; foreach ($cms as $cm) { wipe_forumng($cm); print '.'; if (($i + 1) % 20 == 0) { print " (" . ($i + 1) . ")\n"; } flush(); $i++; } print "</pre>"; rebuild_course_cache($courseid); }