Example #1
0
 if (empty($posts)) {
     message($lang_misc['No posts selected']);
 }
 if (isset($_POST['delete_posts_comply'])) {
     //confirm_referrer('moderate.php');
     if (@preg_match('/[^0-9,]/', $posts)) {
         message($lang_common['Bad request']);
     }
     // Verify that the post IDs are valid
     $result = $db->query('SELECT 1 FROM ' . $db->prefix . 'posts WHERE id IN(' . $posts . ') AND topic_id=' . $tid) or error('Unable to check posts', __FILE__, __LINE__, $db->error());
     if ($db->num_rows($result) != substr_count($posts, ',') + 1) {
         message($lang_common['Bad request']);
     }
     //Attachment Mod Block Start
     foreach (explode(',', $posts) as $value) {
         attach_delete_post($value);
     }
     //Attachment Mod Block End
     // Delete the posts
     $db->query('DELETE FROM ' . $db->prefix . 'posts WHERE id IN(' . $posts . ')') or error('Unable to delete posts', __FILE__, __LINE__, $db->error());
     require PUN_ROOT . 'include/search_idx.php';
     strip_search_index($posts);
     // Get last_post, last_post_id, and last_poster for the topic after deletion
     $result = $db->query('SELECT id, poster, posted FROM ' . $db->prefix . 'posts WHERE topic_id=' . $tid . ' ORDER BY id DESC LIMIT 1') or error('Unable to fetch post info', __FILE__, __LINE__, $db->error());
     $last_post = $db->fetch_assoc($result);
     // How many posts did we just delete?
     $num_posts_deleted = substr_count($posts, ',') + 1;
     // Update the topic
     $db->query('UPDATE ' . $db->prefix . 'topics SET last_post=' . $last_post['posted'] . ', last_post_id=' . $last_post['id'] . ', last_poster=\'' . $db->escape($last_post['poster']) . '\', num_replies=num_replies-' . $num_posts_deleted . ' WHERE id=' . $tid) or error('Unable to update topic', __FILE__, __LINE__, $db->error());
     update_forum($fid);
     redirect('viewtopic.php?id=' . $tid, $lang_misc['Delete posts redirect']);
Example #2
0
     $admins = get_admin_ids();
     for ($i = 0; $i < count($admins); $i++) {
         $data[] = $admins[$i];
         $markers[] = '?';
     }
     $sql .= ' AND poster_id NOT IN(' . implode(',', $markers) . ')';
 }
 // Run the SQL
 $ps = $db->run($sql, $data);
 if (!$ps->rowCount()) {
     message($lang_common['Bad request'], false, '404 Not Found');
 } else {
     $deleted_posts = $ps->rowCount();
 }
 foreach ($posts as $id) {
     attach_delete_post($id);
 }
 // Delete the posts
 if ($panther_config['o_delete_full'] == '1') {
     $db->run('DELETE FROM ' . $db->prefix . 'posts WHERE id IN(' . implode(',', $placeholders) . ')', $post_data);
 } else {
     $db->run('UPDATE ' . $db->prefix . 'posts SET deleted=1 WHERE id IN(' . implode(',', $placeholders) . ')', $post_data);
 }
 require PANTHER_ROOT . 'include/search_idx.php';
 strip_search_index($posts);
 $data = array(':id' => $tid);
 // Get last_post, last_post_id, and last_poster for the topic after deletion
 $ps = $db->select('posts', 'id, poster, posted', $data, 'topic_id=:id', 'id DESC LIMIT 1');
 $last_post = $ps->fetch();
 // How many posts did we just delete?
 $num_replies = $cur_topic['num_replies'] - $deleted_posts;
Example #3
0
function delete_post($post_id, $topic_id)
{
    global $db, $panther_config;
    $topic_data = array(':id' => $topic_id);
    $post_data = array(':id' => $post_id);
    $ps = $db->select('posts', 'id, poster, posted', $topic_data, 'topic_id=:id AND approved=1 AND deleted=0', 'id DESC LIMIT 2');
    list($last_id, , ) = $ps->fetch(PDO::FETCH_NUM);
    list($second_last_id, $second_poster, $second_posted) = $ps->fetch(PDO::FETCH_NUM);
    // Delete the post
    attach_delete_post($post_id);
    $update = array('deleted' => 1);
    $db->update('posts', $update, 'id=:id', $post_data);
    strip_search_index(array($post_id));
    // Count number of replies in the topic
    $ps = $db->select('posts', 'COUNT(id)', $topic_data, 'topic_id=:id AND approved=1 AND deleted=0');
    $num_replies = $ps->fetchColumn() - 1;
    // Decrement the deleted post
    // If the message we deleted is the most recent in the topic (at the end of the topic)
    if ($last_id == $post_id) {
        // If there is a $second_last_id there is more than 1 reply to the topic
        if (!empty($second_last_id)) {
            $update = array('last_post' => $second_posted, 'last_post_id' => $second_last_id, 'last_poster' => $second_poster, 'num_replies' => $num_replies);
            $data = array(':id' => $topic_id);
            $db->update('topics', $update, 'id=:id', $data);
        } else {
            $data = array(':id' => $topic_id, ':num_replies' => $num_replies - 1);
            // We deleted the only reply, so now last_post/last_post_id/last_poster is posted/id/poster from the topic itself
            $db->run('UPDATE ' . $db->prefix . 'topics SET last_post=posted, last_post_id=id, last_poster=poster, num_replies=:num_replies WHERE id=:id', $data);
        }
    } else {
        $update = array('num_replies' => $num_replies);
        $db->update('topics', $update, 'id=:id', $topic_data);
    }
    if ($panther_config['o_delete_full'] == '1') {
        permanently_delete_post($post_id);
    }
}