if ($type != 'topic')

{

$topic_join = ', ' . TOPICS_TABLE . ' t';

}

else

{

FROM ' . POSTS_TABLE . " p $topic_join

WHERE " . $db->sql_in_set('p.' . $type . '_id', $ids) . "

$topic_condition

}

else

{

FROM ' . POSTS_TABLE . " p $topic_join

WHERE " . $db->sql_in_set('p.' . $type . '_id', $ids) . "

$topic_condition

GROUP BY p.{$type}_id";

}

$result = $db->sql_query($sql);

$sql = 'SELECT p.post_id

FROM ' . POSTS_TABLE . ' p' . "

WHERE p.topic_id = $topic_id

' . (($mode == 'post_review') ? " AND p.post_id > $cur_post_id" : '') . '

' . (($mode == 'post_review_edit') ? " AND p.post_id = $cur_post_id" : '') . '

ORDER BY p.post_time ';

delete_topics('topic_id', array($topic_id), false);

$sql_data[FORUMS_TABLE] .= 'forum_topics_real = forum_topics_real - 1';

$update_sql = update_post_information('forum', $forum_id, true);

if (sizeof($update_sql))

$row = $db->sql_fetchrow($result);

$db->sql_freeresult($result);

$sql_data[TOPICS_TABLE] = 'topic_poster = ' . intval($row['poster_id']) . ', topic_first_post_id = ' . intval($row['post_id']) . ", topic_first_poster_colour = '" . $db->sql_escape($row['user_colour']) . "', topic_first_poster_name = '" . (($row['poster_id'] == ANONYMOUS) ? $db->sql_escape($row['post_username']) : $db->sql_escape($row['username'])) . "', topic_time = " . (int) $row['post_time'];

// Decrementing topic_replies here is fine because this case only happens if there is more than one post within the topic - basically removing one "reply"

$next_post_id = (int) $row['post_id'];

break;

case 'delete_last_post':

$update_sql = update_post_information('forum', $forum_id, true);

if (sizeof($update_sql))

$sql_data[FORUMS_TABLE] .= implode(', ', $update_sql[$forum_id]);

}

$update_sql = update_post_information('topic', $topic_id, true);

if (sizeof($update_sql))

{

$sql = 'SELECT MAX(post_id) as last_post_id

FROM ' . POSTS_TABLE . "

$result = $db->sql_query($sql);

$row = $db->sql_fetchrow($result);

$db->sql_freeresult($result);

case 'delete':

$sql = 'SELECT post_id

FROM ' . POSTS_TABLE . "

AND post_time > ' . $data['post_time'] . '

ORDER BY post_time ASC';

$result = $db->sql_query_limit($sql, 1);

$row = $db->sql_fetchrow($result);

$db->sql_freeresult($result);

$next_post_id = (int) $row['post_id'];

break;

}

$poster_id = ($mode == 'edit') ? $data['poster_id'] : (int) $user->data['user_id'];

// Retrieve some additional information if not present

{

FROM ' . TOPICS_TABLE . ' t, ' . POSTS_TABLE . ' p

WHERE t.topic_id = p.topic_id

AND p.post_id = ' . $data['post_id'];

$topic_row = $db->sql_fetchrow($result);

$db->sql_freeresult($result);

}

// This variable indicates if the user is able to post or put into the queue - it is used later for all code decisions regarding approval

'icon_id' => $data['icon_id'],

'poster_ip' => $user->ip,

'post_time' => $current_time,

'enable_bbcode' => $data['enable_bbcode'],

'enable_smilies' => $data['enable_smilies'],

'enable_magic_url' => $data['enable_urls'],

'forum_id' => $data['forum_id'],

'poster_id' => $data['poster_id'],

'icon_id' => $data['icon_id'],

'enable_bbcode' => $data['enable_bbcode'],

'enable_smilies' => $data['enable_smilies'],

'enable_magic_url' => $data['enable_urls'],

break;

}

$topic_row = array();

// And the topic ladies and gentlemen

'topic_last_view_time' => $current_time,

'forum_id' => $data['forum_id'],

'icon_id' => $data['icon_id'],

'topic_title' => $subject,

'topic_first_poster_name' => (!$user->data['is_registered'] && $username) ? $username : (($user->data['user_id'] != ANONYMOUS) ? $user->data['username'] : ''),

'topic_first_poster_colour' => $user->data['user_colour'],

$sql_data[TOPICS_TABLE]['sql'] = array(

'forum_id' => $data['forum_id'],

'icon_id' => $data['icon_id'],

'topic_title' => $subject,

'topic_first_poster_name' => $username,

'topic_type' => $topic_type,

);

// Correctly set back the topic replies and forum posts... only if the topic was approved before and now gets disapproved

{

// Do we need to grab some topic informations?

if (!sizeof($topic_row))

{

FROM ' . TOPICS_TABLE . '

WHERE topic_id = ' . $data['topic_id'];

$result = $db->sql_query($sql);

case 'edit_last_post':

// Correctly set back the topic replies and forum posts... but only if the post was approved before.

{

$sql_data[TOPICS_TABLE]['stat'][] = 'topic_replies = topic_replies - 1, topic_last_view_time = ' . $current_time;

$sql_data[FORUMS_TABLE]['stat'][] = 'forum_posts = forum_posts - 1';

// we need to update the last forum information

// only applicable if the topic is approved

{

// the last post makes us update the forum table. This can happen if...

// We make a new topic

$sql_data[FORUMS_TABLE]['stat'][] = "forum_last_poster_name = '" . $db->sql_escape($username) . "'";

}

}

{

// we need a fresh change of socks, everything has become invalidated

$sql = 'SELECT MAX(topic_last_post_id) as last_post_id

FROM ' . TOPICS_TABLE . '

WHERE forum_id = ' . (int) $data['forum_id'] . '

$result = $db->sql_query($sql);

$row = $db->sql_fetchrow($result);

$db->sql_freeresult($result);

}

}

}

{

// like having the rug pulled from under us

$sql = 'SELECT MAX(post_id) as last_post_id

FROM ' . POSTS_TABLE . '

WHERE topic_id = ' . (int) $data['topic_id'] . '

$result = $db->sql_query($sql);

$row = $db->sql_fetchrow($result);

$db->sql_freeresult($result);