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

$db->sql_freeresult($result);

if ($auth->acl_get('u_download') && $f_download)

{

$i = 0;

while ($row = ($buffer ? $rows[$i++] : $db->sql_fetchrow($result)))

{

{

$this->search->index('post', $row['post_id'], $row['post_text'], $row['post_subject'], $row['poster_id'], $row['forum_id']);

}

if (!($prune_flags & FORUM_FLAG_PRUNE_ANNOUNCE))

{

$sql_and .= ' AND topic_type <> ' . POST_ANNOUNCE;

}

if (!($prune_flags & FORUM_FLAG_PRUNE_STICKY))

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

{

{

}

if ($auth->acl_gets('a_', 'm_', $row['forum_id']))

$forum_tracking_info = array();

$branch_root_id = $root_data['forum_id'];

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

{

$forum_id = $row['forum_id'];

}

else

{

markread('topics', $forum_ids);

$message = sprintf($user->lang['RETURN_FORUM'], '<a href="' . $redirect . '">', '</a>');

}

$forum_unread = (isset($forum_tracking_info[$forum_id]) && $row['orig_forum_last_post_time'] > $forum_tracking_info[$forum_id]) ? true : false;

$folder_image = $folder_alt = $l_subforums = '';

$subforums_list = array();

$topic_type_array[] = array(

'VALUE' => $topic_value['const'],

'L_TOPIC_TYPE' => $user->lang[$topic_value['lang']]

);

}

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

$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'];

break;

case 'delete_last_post':

$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_replies_real = topic_replies_real - 1' . (($data['post_approved']) ? ', topic_replies = topic_replies - 1' : '');

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

case 'post':

case 'reply':

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

'poster_id' => (int) $user->data['user_id'],

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

'poster_ip' => $user->ip,

}

$sql_data[POSTS_TABLE]['sql'] = array_merge($sql_data[POSTS_TABLE]['sql'], array(

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

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

'post_approved' => (!$post_approval) ? 0 : $data['post_approved'],

'topic_poster' => (int) $user->data['user_id'],

'topic_time' => $current_time,

'topic_last_view_time' => $current_time,

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

'topic_approved' => $post_approval,

'topic_title' => $subject,

$sql_data[USERS_TABLE]['stat'][] = "user_lastpost_time = $current_time" . (($auth->acl_get('f_postcount', $data['forum_id']) && $post_approval) ? ', user_posts = user_posts + 1' : '');

{

}

break;

case 'reply':

$sql_data[USERS_TABLE]['stat'][] = "user_lastpost_time = $current_time" . (($auth->acl_get('f_postcount', $data['forum_id']) && $post_approval) ? ', user_posts = user_posts + 1' : '');

{

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

}

}

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

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

'topic_approved' => (!$post_approval) ? 0 : $data['topic_approved'],

'topic_title' => $subject,

unset($sql_data[POSTS_TABLE]['sql']);

}

// Update the topics table

if (isset($sql_data[TOPICS_TABLE]['sql']))

{

}

// we need to update the last forum information

{

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

// We make a new topic

}

}

}

// topic sync time!

// simply, we update if it is a reply or the last post is edited

}

// Delete topic shadows (if any exist). We do not need a shadow topic for an global announcement

{

$sql = 'DELETE FROM ' . TOPICS_TABLE . '

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

trigger_error($error);

}

}

// Topic Notification, do not change if moderator is changing other users posts...

// Mark this topic as read

// We do not use post_time here, this is intended (post_time can have a date in the past if editing a message)

//

if ($config['load_db_lastread'] && $user->data['is_registered'])

$sql = 'SELECT mark_time

FROM ' . FORUMS_TRACK_TABLE . '

WHERE user_id = ' . $user->data['user_id'] . '

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

$f_mark_time = (int) $db->sql_fetchfield('mark_time');

$db->sql_freeresult($result);

if (($config['load_db_lastread'] && $user->data['is_registered']) || $config['load_anon_lastread'] || $user->data['is_registered'])

{

// Update forum info

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

$forum_last_post_time = (int) $db->sql_fetchfield('forum_last_post_time');

$db->sql_freeresult($result);

}

// Send Notifications

$read_tracking_join = $read_tracking_select = '';

}

$limit_time_sql

ORDER BY t.topic_type DESC, $sort_order_sql";

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

{

$sql = 'SELECT COUNT(post_id) AS total

FROM ' . POSTS_TABLE . '

AND post_approved = 0';

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

$total = (int) $db->sql_fetchfield('total');

if ($total)

{

$sql = 'SELECT forum_id, forum_name

FROM ' . FORUMS_TABLE . '

WHERE ' . $db->sql_in_set('forum_id', $forum_list);

$sql = 'SELECT post_id

FROM ' . POSTS_TABLE . '

AND post_approved = 0

ORDER BY post_time DESC';

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

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

{

$template->assign_block_vars('unapproved', array(

'U_POST_DETAILS' => append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=queue&amp;mode=approve_details&amp;f=' . $row['forum_id'] . '&amp;p=' . $row['post_id']),

'U_MCP_TOPIC' => append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=main&amp;mode=topic_view&amp;f=' . $row['forum_id'] . '&amp;t=' . $row['topic_id']),

'U_TOPIC' => append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . $row['forum_id'] . '&amp;t=' . $row['topic_id']),

'AUTHOR_FULL' => get_username_string('full', $row['poster_id'], $row['username'], $row['user_colour']),

'AUTHOR_COLOUR' => get_username_string('colour', $row['poster_id'], $row['username'], $row['user_colour']),

'U_AUTHOR' => get_username_string('profile', $row['poster_id'], $row['username'], $row['user_colour']),

'POST_ID' => $row['post_id'],

'TOPIC_TITLE' => $row['topic_title'],

'SUBJECT' => ($row['post_subject']) ? $row['post_subject'] : $user->lang['NO_SUBJECT'],

WHERE r.post_id = p.post_id

AND r.pm_id = 0

AND r.report_closed = 0

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

$total = (int) $db->sql_fetchfield('total');

$db->sql_freeresult($result);

if ($total)

{

$sql = $db->sql_build_query('SELECT', array(

'SELECT' => 'r.report_time, p.post_id, p.post_subject, p.post_time, u.username, u.username_clean, u.user_colour, u.user_id, u2.username as author_name, u2.username_clean as author_name_clean, u2.user_colour as author_colour, u2.user_id as author_id, t.topic_id, t.topic_title, f.forum_id, f.forum_name',

AND p.topic_id = t.topic_id

AND r.user_id = u.user_id

AND p.poster_id = u2.user_id

'ORDER_BY' => 'p.post_time DESC'

));

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

{

$template->assign_block_vars('report', array(

'U_POST_DETAILS' => append_sid("{$phpbb_root_path}mcp.$phpEx", 'f=' . $row['forum_id'] . '&amp;p=' . $row['post_id'] . "&amp;i=reports&amp;mode=report_details"),

'U_MCP_TOPIC' => append_sid("{$phpbb_root_path}mcp.$phpEx", 'f=' . $row['forum_id'] . '&amp;t=' . $row['topic_id'] . "&amp;i=$id&amp;mode=topic_view"),

'U_TOPIC' => append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . $row['forum_id'] . '&amp;t=' . $row['topic_id']),

'REPORTER_FULL' => get_username_string('full', $row['user_id'], $row['username'], $row['user_colour']),

'AUTHOR_COLOUR' => get_username_string('colour', $row['author_id'], $row['author_name'], $row['author_colour']),

'U_AUTHOR' => get_username_string('profile', $row['author_id'], $row['author_name'], $row['author_colour']),

'TOPIC_TITLE' => $row['topic_title'],

'SUBJECT' => ($row['post_subject']) ? $row['post_subject'] : $user->lang['NO_SUBJECT'],

'REPORT_TIME' => $user->format_date($row['report_time']),

if (!empty($forum_list))

{

$log_count = false;

$log = array();

view_log('mod', $log, $log_count, 5, 0, $forum_list);

$topic_posts_added += $topic_info['topic_replies'];

}

}

$forum_ids[] = $row['forum_id'];

add_log('mod', $to_forum_id, $topic_id, 'LOG_MOVE', $row['forum_name'], $forum_data['forum_name']);

// Leave a redirection if required and only if the topic is visible to users

if ($leave_shadow && $row['topic_approved'] && $row['topic_type'] != POST_GLOBAL)

{

trigger_error('NOT_MODERATOR');

}

$forum_list = implode(', ', $forum_list);

$sql = 'SELECT SUM(forum_topics) as sum_forum_topics

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

$forum_info['forum_topics'] = (int) $db->sql_fetchfield('sum_forum_topics');

$db->sql_freeresult($result);

$forum_info = $forum_info[$forum_id];

$forum_list = $forum_id;

}

$forum_options = '<option value="0"' . (($forum_id == 0) ? ' selected="selected"' : '') . '>' . $user->lang['ALL_FORUMS'] . '</option>';

if ($mode == 'unapproved_posts')

{

$sql = 'SELECT p.post_id

AND p.post_approved = 0

' . (($topic_id) ? 'AND p.topic_id = ' . $topic_id : '') . "

AND t.topic_id = p.topic_id

AND t.topic_first_post_id <> p.post_id

$post_data = $rowset = array();

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

{

$post_data[$row['post_id']] = $row;

}

$db->sql_freeresult($result);

{

$sql = 'SELECT t.forum_id, t.topic_id, t.topic_title, t.topic_title AS post_subject, t.topic_time AS post_time, t.topic_poster AS poster_id, t.topic_first_post_id AS post_id, t.topic_first_poster_name AS username, t.topic_first_poster_colour AS user_colour

FROM ' . TOPICS_TABLE . " t

AND topic_approved = 0

$limit_time_sql

ORDER BY $sort_order_sql";

$rowset = array();

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

{

$rowset[] = $row;

}

$db->sql_freeresult($result);

foreach ($rowset as $row)

{

if (empty($row['post_username']))

{

$row['post_username'] = $user->lang['GUEST'];

$template->assign_block_vars('postrow', array(

'U_TOPIC' => append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . $row['forum_id'] . '&amp;t=' . $row['topic_id']),

'U_VIEWPOST' => append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . $row['forum_id'] . '&amp;p=' . $row['post_id']) . (($mode == 'unapproved_posts') ? '#p' . $row['post_id'] : ''),

'U_VIEW_DETAILS' => append_sid("{$phpbb_root_path}mcp.$phpEx", "i=queue&amp;start=$start&amp;mode=approve_details&amp;f={$row['forum_id']}&amp;p={$row['post_id']}" . (($mode == 'unapproved_topics') ? "&amp;t={$row['topic_id']}" : '')),

'U_POST_AUTHOR' => get_username_string('profile', $row['poster_id'], $row['username'], $row['user_colour'], $row['post_username']),

'POST_ID' => $row['post_id'],

'POST_SUBJECT' => ($row['post_subject'] != '') ? $row['post_subject'] : $user->lang['NO_SUBJECT'],

'TOPIC_TITLE' => $row['topic_title'],

'POST_TIME' => $user->format_date($row['post_time']))

}

$topic_id_list[$post_data['topic_id']] = 1;

// User post update (we do not care about topic or post, since user posts are strictly connected to posts)

// But we care about forums where post counts get not increased. ;)

// Topic or Post. ;)

if ($post_data['topic_first_post_id'] == $post_id)

{

$topic_approve_sql[] = $post_data['topic_id'];

$approve_log[] = array(

);

}

}

$post_approve_sql[] = $post_id;

$forum_info = $forum_info[$forum_id];

$forum_list = array($forum_id);

}

$forum_list[] = 0;

$report_data = $rowset = array();

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

{

$template->assign_block_vars('postrow', array(

'U_VIEWPOST' => append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . $row['forum_id'] . '&amp;p=' . $row['post_id']) . '#p' . $row['post_id'],

'U_VIEW_DETAILS' => append_sid("{$phpbb_root_path}mcp.$phpEx", "i=reports&amp;start=$start&amp;mode=report_details&amp;f={$row['forum_id']}&amp;r={$row['report_id']}"),

'REPORTER' => get_username_string('username', $row['reporter_id'], $row['reporter_name'], $row['reporter_colour']),

'U_REPORTER' => get_username_string('profile', $row['reporter_id'], $row['reporter_name'], $row['reporter_colour']),

'POST_ID' => $row['post_id'],

'POST_SUBJECT' => ($row['post_subject']) ? $row['post_subject'] : $user->lang['NO_SUBJECT'],

'POST_TIME' => $user->format_date($row['post_time']),

$folder = 'global_read';

$folder_new = 'global_unread';

$forum_ary = array_unique(array_keys($forum_ary));

$sql = "SELECT t.* $sql_select

FROM $sql_from

ORDER BY t.topic_last_post_time DESC';

$topic_list = $rowset = array();

// If the user can't see any forums, he can't read any posts because fid of 0 is invalid

{

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

'S_UNREAD' => $unread_topic,

'U_TOPIC_AUTHOR' => get_username_string('profile', $row['topic_poster'], $row['topic_first_poster_name'], $row['topic_first_poster_colour']),

'U_LAST_POST_AUTHOR' => get_username_string('profile', $row['topic_last_poster_id'], $row['topic_last_poster_name'], $row['topic_last_poster_colour']),

);

}

'U_LAST_POST_AUTHOR' => get_username_string('profile', $row['topic_last_poster_id'], $row['topic_last_poster_name'], $row['topic_last_poster_colour']),

'S_DELETED_TOPIC' => (!$row['topic_id']) ? true : false,

'REPLIES' => $replies,

'VIEWS' => $row['topic_views'],

'TOPIC_TITLE' => censor_text($row['topic_title']),

$sql = 'SELECT DISTINCT poster_id

FROM ' . POSTS_TABLE . '

WHERE poster_ip ' . ((strpos($ips, '%') !== false) ? 'LIKE' : 'IN') . " ($ips)

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

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

if ($forum_data['forum_type'] == FORUM_POST)

{

// Obtain announcements ... removed sort ordering, sort by time in all cases

$sql = $db->sql_build_query('SELECT', array(

'SELECT' => $sql_array['SELECT'],

'LEFT_JOIN' => $sql_array['LEFT_JOIN'],

'WHERE' => '(t.forum_id = ' . $forum_id . '

'ORDER_BY' => 't.topic_time DESC',

));