/**
* Merges the contents of this discussion into another discussion.
* @param forum_discussion $targetdiscussion Target discussion
* @param int $userid User ID (0 = current)
* @param bool $log True to log this action
*/
public function merge_into($targetdiscussion, $userid = 0, $log = true)
{
global $CFG;
forum_utils::start_transaction();
// Update parent post id of root post
$record = new stdClass();
$record->id = $this->discussionfields->postid;
$record->parentpostid = $targetdiscussion->discussionfields->postid;
forum_utils::update_record('forumng_posts', $record);
// Move all posts into new discussion
forum_utils::execute_sql("UPDATE {$CFG->prefix}forumng_posts SET " . "discussionid=" . $targetdiscussion->get_id() . " WHERE discussionid=" . $this->get_id());
// Delete this discussion
forum_utils::delete_records('forumng_discussions', 'id', $this->discussionfields->id);
// Merge attachments (if any)
$oldfolder = $this->get_attachment_folder();
$newfolder = $targetdiscussion->get_attachment_folder();
if (is_dir($oldfolder)) {
$handle = forum_utils::opendir($oldfolder);
$madenewfolder = false;
while (false !== ($name = readdir($handle))) {
if ($name != '.' && $name != '..') {
if (!$madenewfolder) {
check_dir_exists($newfolder, true, true);
$madenewfolder = true;
}
$oldname = $oldfolder . '/' . $name;
$newname = $newfolder . '/' . $name;
forum_utils::rename($oldname, $newname);
}
}
closedir($handle);
}
// Merging the discussion into another might cause completion changes
// (if there was a requirement for discussions and this is no longer
// a discussion in its own right).
$this->update_completion(false);
if ($log) {
$this->log('merge discussion d' . $targetdiscussion->get_id());
}
forum_utils::finish_transaction();
$this->uncache();
$targetdiscussion->uncache();
}
static function delete_old_posts()
{
global $CFG;
// Check if deletion is turned off
if (empty($CFG->forumng_permanentdeletion)) {
return;
}
mtrace('Beginning forum deleted/edit message cleanup...');
// Work out how long ago things have to have been 'deleted' before we
// permanently delete them
$deletebefore = time() - $CFG->forumng_permanentdeletion;
// Handle all posts which were deleted (that long ago) or which are in
// discussions which were deleted (that long ago)
$mainquery = "\nFROM\n {$CFG->prefix}forumng_posts fp\n INNER JOIN {$CFG->prefix}forumng_discussions fd ON fd.id = fp.discussionid\n INNER JOIN {$CFG->prefix}forumng f ON fd.forumid = f.id\nWHERE\n (fp.deleted<>0 AND fp.deleted<{$deletebefore})\n OR (fp.oldversion<>0 AND fp.modified<{$deletebefore})\n OR (fd.deleted<>0 AND fd.deleted<{$deletebefore})";
$idquery = "SELECT fp.id {$mainquery} ";
$before = microtime(true);
mtrace('Message search: ', '');
$count = count_records_sql("SELECT COUNT(1) {$mainquery}");
mtrace(round(microtime(true) - $before, 1) . 's');
if ($count == 0) {
mtrace("No old deleted / edited messages to clean up.");
} else {
mtrace("Permanently deleting {$count} old deleted / edited messages.");
}
if ($count) {
$before = microtime(true);
mtrace('Database post deletion: ', '');
forum_utils::start_transaction();
// Delete all ratings
forum_utils::execute_sql("DELETE FROM {$CFG->prefix}forumng_ratings WHERE postid IN ({$idquery})");
// Find all attachments
$attachmentrecords = forum_utils::get_records_sql("\nSELECT\n fp.id AS postid, fd.id AS discussionid, f.id AS forumid, f.course AS courseid\n{$mainquery}\n AND fp.attachments<>0");
// Delete all posts
forum_utils::update_with_subquery_grrr_mysql("DELETE FROM {$CFG->prefix}forumng_posts WHERE id %'IN'%", $idquery);
// Now delete all discussions
forum_utils::execute_sql("DELETE FROM {$CFG->prefix}forumng_discussions " . "WHERE deleted<>0 AND deleted<{$deletebefore}");
mtrace(round(microtime(true) - $before, 1) . 's');
$before = microtime(true);
mtrace('Filesystem attachment deletion: ', '');
// OK, now delete attachments (this is done last in case the db update
// failed and gets rolled back)
foreach ($attachmentrecords as $attachmentrecord) {
$folder = forum_post::get_any_attachment_folder($attachmentrecord->courseid, $attachmentrecord->forumid, $attachmentrecord->discussionid, $attachmentrecord->postid);
// Delete post folder
if (!remove_dir($folder)) {
mtrace("\nError deleting post folder: {$folder}");
// But don't stop because we can't undo earlier changes
}
}
// Get list of all discussions that might need deleting
$discussions = array();
foreach ($attachmentrecords as $attachmentrecord) {
// This will ensure we have only one entry per discussion
$discussions[$attachmentrecord->discussionid] = $attachmentrecord;
}
// Delete discussion folder only if empty (there might be other
// not-yet-deleted posts)
foreach ($discussions as $attachmentrecord) {
$folder = forum_discussion::get_attachment_folder($attachmentrecord->courseid, $attachmentrecord->forumid, $attachmentrecord->discussionid);
$handle = @opendir($folder);
if (!$handle) {
mtrace("\nError opening discussion folder: {$folder}");
continue;
}
$gotfiles = false;
while (($file = readdir($handle)) !== false) {
if ($file != '.' && $file != '..') {
$gotfiles = true;
break;
}
}
closedir($handle);
if (!$gotfiles) {
if (!rmdir($folder)) {
mtrace("\nError deleting discussion folder: {$folder}");
}
}
}
forum_utils::finish_transaction();
mtrace(round(microtime(true) - $before, 1) . 's');
}
}
/**
* Gets the attachment folder for any post.
* @param int $courseid Course
* @param int $forumid Forum
* @param int $discussionid Discussion
* @param int $postid Post
*/
static function get_any_attachment_folder($courseid, $forumid, $discussionid, $postid)
{
return forum_discussion::get_attachment_folder($courseid, $forumid, $discussionid) . '/' . $postid;
}
