$ps = $db->select('posts', 'id, poster, posted', $topic_data, 'topic_id=:id AND approved=1 AND deleted=0', 'id DESC LIMIT 1');
list($last_id, $poster, $posted) = $ps->fetch(PDO::FETCH_NUM);
$ps = $db->select('topics', 'num_replies', $topic_data, 'id=:id');
$num_replies = $ps->fetchColumn();
$update = array('num_replies' => $num_replies + 1, 'last_post' => $posted, 'last_post_id' => $last_id, 'last_poster' => $poster);
$db->update('topics', $update, 'id=:id', $topic_data);
update_search_index('post', $post_id, $post['message']);
update_forum($post['forum_id']);
redirect(panther_link($panther_url['admin_deleted']), $lang_admin_deleted['Post approved redirect']);
}
} else {
if ($is_topic_post) {
permanently_delete_topic($post['topic_id']);
redirect(panther_link($panther_url['admin_deleted']), $lang_admin_deleted['Topic deleted redirect']);
} else {
permanently_delete_post($post_id);
redirect(panther_link($panther_url['admin_deleted']), $lang_admin_deleted['Post deleted redirect']);
}
}
}
$ps = $db->run('SELECT t.id AS topic_id, t.forum_id, p.poster, p.poster_id, p.posted, p.message, p.id AS pid, p.hide_smilies, t.subject, f.forum_name FROM ' . $db->prefix . 'posts AS p LEFT JOIN ' . $db->prefix . 'topics AS t ON p.topic_id=t.id LEFT JOIN ' . $db->prefix . 'forums AS f ON t.forum_id=f.id WHERE p.deleted=1 OR t.deleted=1 ORDER BY p.posted DESC');
require PANTHER_ROOT . 'include/parser.php';
$page_title = array($panther_config['o_board_title'], $lang_admin_common['Admin'], $lang_admin_common['Deleted']);
define('PANTHER_ACTIVE_PAGE', 'admin');
require PANTHER_ROOT . 'header.php';
generate_admin_menu('deleted');
$posts = array();
foreach ($ps as $cur_post) {
$posts[] = array('id' => $cur_post['pid'], 'posted' => format_time($cur_post['posted']), 'message' => $parser->parse_message($cur_post['message'], $cur_post['hide_smilies']), 'poster' => $cur_post['poster'] != '' ? array('href' => panther_link($panther_url['profile'], array($cur_post['poster_id'], url_friendly($cur_post['poster']))), 'poster' => $cur_post['poster']) : '', 'forum' => $cur_post['forum_name'] != '' ? array('href' => panther_link($panther_url['forum'], array($cur_post['forum_id'], url_friendly($cur_post['forum_name']))), 'forum_name' => $cur_post['forum_name']) : '', 'topic' => $cur_post['subject'] != '' ? array('href' => panther_link($panther_url['topic'], array($cur_post['topic_id'], url_friendly($cur_post['subject']))), 'subject' => $cur_post['subject']) : '', 'post' => $cur_post['pid'] != '' ? array('href' => panther_link($panther_url['post'], array($cur_post['pid'])), 'post' => sprintf($lang_admin_deleted['Post ID'], $cur_post['pid'])) : '');
}
$tpl = load_template('admin_deleted.tpl');
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);
}
}