/** * Delete a comment * @param int $PostID */ public static function delete($PostID) { $QueryID = G::$DB->get_query_id(); // Get page, pageid G::$DB->query("SELECT Page, PageID FROM comments WHERE ID = {$PostID}"); if (!G::$DB->has_results()) { // no such comment? G::$DB->set_query_id($QueryID); return false; } list($Page, $PageID) = G::$DB->next_record(); // get number of pages G::$DB->query("\n\t\t\tSELECT\n\t\t\t\tCEIL(COUNT(ID) / " . TORRENT_COMMENTS_PER_PAGE . ") AS Pages,\n\t\t\t\tCEIL(SUM(IF(ID <= {$PostID}, 1, 0)) / " . TORRENT_COMMENTS_PER_PAGE . ") AS Page\n\t\t\tFROM comments\n\t\t\tWHERE Page = '{$Page}'\n\t\t\t\tAND PageID = {$PageID}\n\t\t\tGROUP BY PageID"); if (!G::$DB->has_results()) { // the comment $PostID was probably not posted on $Page G::$DB->set_query_id($QueryID); return false; } list($CommPages, $CommPage) = G::$DB->next_record(); // $CommPages = number of pages in the thread // $CommPage = which page the post is on // These are set for cache clearing. G::$DB->query("\n\t\t\tDELETE FROM comments\n\t\t\tWHERE ID = {$PostID}"); G::$DB->query("\n\t\t\tDELETE FROM comments_edits\n\t\t\tWHERE Page = '{$Page}'\n\t\t\t\tAND PostID = {$PostID}"); G::$DB->query("\n\t\t\tDELETE FROM users_notify_quoted\n\t\t\tWHERE Page = '{$Page}'\n\t\t\t\tAND PostID = {$PostID}"); Subscriptions::flush_subscriptions($Page, $PageID); Subscriptions::flush_quote_notifications($Page, $PageID); //We need to clear all subsequential catalogues as they've all been bumped with the absence of this post $ThisCatalogue = floor((TORRENT_COMMENTS_PER_PAGE * $CommPage - TORRENT_COMMENTS_PER_PAGE) / THREAD_CATALOGUE); $LastCatalogue = floor((TORRENT_COMMENTS_PER_PAGE * $CommPages - TORRENT_COMMENTS_PER_PAGE) / THREAD_CATALOGUE); for ($i = $ThisCatalogue; $i <= $LastCatalogue; ++$i) { G::$Cache->delete_value($Page . '_comments_' . $PageID . '_catalogue_' . $i); } G::$Cache->delete_value($Page . '_comments_' . $PageID); if ($Page == 'collages') { // On collages, we also need to clear the collage key (collage_$CollageID), because it has the comments in it... (why??) G::$Cache->delete_value("collage_{$PageID}"); } G::$DB->set_query_id($QueryID); return true; }
//Merge it } else { $Forum = $Part1 + $Part2 + $Part3; //Merge it } $Cache->cache_value("forums_{$ForumID}", array($Forum, '', 0, $Stickies), 0); //Update the forum root $Cache->begin_transaction('forums_list'); $Cache->update_row($ForumID, array('NumPosts' => '+1', 'LastPostID' => $PostID, 'LastPostAuthorID' => $LoggedUser['ID'], 'LastPostTopicID' => $TopicID, 'LastPostTime' => $SQLTime, 'Title' => $ThreadInfo['Title'], 'IsLocked' => $ThreadInfo['IsLocked'], 'IsSticky' => $ThreadInfo['IsSticky'])); $Cache->commit_transaction(0); } else { //If there's no cache, we have no data, and if there's no data $Cache->delete_value('forums_list'); } //This calculates the block of 500 posts that this one will fall under $CatalogueID = floor((POSTS_PER_PAGE * ceil($ThreadInfo['Posts'] / POSTS_PER_PAGE) - POSTS_PER_PAGE) / THREAD_CATALOGUE); //Insert the post into the thread catalogue (block of 500 posts) $Cache->begin_transaction("thread_{$TopicID}" . "_catalogue_{$CatalogueID}"); $Cache->insert('', array('ID' => $PostID, 'AuthorID' => $LoggedUser['ID'], 'AddedTime' => $SQLTime, 'Body' => $Body, 'EditedUserID' => 0, 'EditedTime' => '0000-00-00 00:00:00', 'Username' => $LoggedUser['Username'])); $Cache->commit_transaction(0); //Update the thread info $Cache->begin_transaction("thread_{$TopicID}" . '_info'); $Cache->update_row(false, array('Posts' => '+1', 'LastPostAuthorID' => $LoggedUser['ID'])); $Cache->commit_transaction(0); //Increment this now to make sure we redirect to the correct page $ThreadInfo['Posts']++; } Subscriptions::flush_subscriptions('forums', $TopicID); Subscriptions::quote_notify($Body, $PostID, 'forums', $TopicID); header("Location: forums.php?action=viewthread&threadid={$TopicID}&page=" . ceil($ThreadInfo['Posts'] / $PerPage)); die;
if (!is_number($CollageID) || !$CollageID) { error(404); } $DB->query("\n\tSELECT Name, CategoryID, UserID\n\tFROM collages\n\tWHERE ID = '{$CollageID}'"); list($Name, $CategoryID, $UserID) = $DB->next_record(MYSQLI_NUM, false); if (!check_perms('site_collages_delete') && $UserID !== $LoggedUser['ID']) { error(403); } $Reason = trim($_POST['reason']); if (!$Reason) { error('You must enter a reason!'); } $DB->query("\n\tSELECT GroupID\n\tFROM collages_torrents\n\tWHERE CollageID = '{$CollageID}'"); while (list($GroupID) = $DB->next_record()) { $Cache->delete_value("torrents_details_{$GroupID}"); $Cache->delete_value("torrent_collages_{$GroupID}"); $Cache->delete_value("torrent_collages_personal_{$GroupID}"); } //Personal collages have CategoryID 0 if ($CategoryID == 0) { $DB->query("\n\t\tDELETE FROM collages\n\t\tWHERE ID = '{$CollageID}'"); $DB->query("\n\t\tDELETE FROM collages_torrents\n\t\tWHERE CollageID = '{$CollageID}'"); Comments::delete_page('collages', $CollageID); } else { $DB->query("\n\t\tUPDATE collages\n\t\tSET Deleted = '1'\n\t\tWHERE ID = '{$CollageID}'"); Subscriptions::flush_subscriptions('collages', $CollageID); Subscriptions::flush_quote_notifications('collages', $CollageID); } Misc::write_log("Collage {$CollageID} ({$Name}) was deleted by " . $LoggedUser['Username'] . ": {$Reason}"); $Cache->delete_value("collage_{$CollageID}"); header('Location: collages.php');