$sql = 'SELECT t.topic_id

FROM ' . TOPICS_TABLE . ' t

WHERE t.forum_id = ' . $forum_id . '

$limit_time_sql

ORDER BY t.topic_type DESC, $sort_order_sql";

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

$topic_title = censor_text($row['topic_title']);

$u_mcp_queue = ($topic_unapproved || $posts_unapproved) ? $url . '&i=queue&mode=' . (($topic_unapproved) ? 'approve_details' : 'unapproved_posts') . '&t=' . $row['topic_id'] : '';

$topic_row = array(

'ATTACH_ICON_IMG' => ($auth->acl_get('u_download') && $auth->acl_get('f_download', $row['forum_id']) && $row['topic_attachment']) ? $user->img('icon_topic_attach', $user->lang['TOTAL_ATTACHMENTS']) : '',

'TOPIC_ICON_IMG_WIDTH' => (!empty($icons[$row['icon_id']])) ? $icons[$row['icon_id']]['width'] : '',

'TOPIC_ICON_IMG_HEIGHT' => (!empty($icons[$row['icon_id']])) ? $icons[$row['icon_id']]['height'] : '',

'UNAPPROVED_IMG' => ($topic_unapproved || $posts_unapproved) ? $user->img('icon_topic_unapproved', ($topic_unapproved) ? 'TOPIC_UNAPPROVED' : 'POSTS_UNAPPROVED') : '',

'TOPIC_AUTHOR' => get_username_string('username', $row['topic_poster'], $row['topic_first_poster_name'], $row['topic_first_poster_colour']),

'TOPIC_AUTHOR_COLOUR' => get_username_string('colour', $row['topic_poster'], $row['topic_first_poster_name'], $row['topic_first_poster_colour']),

'S_TOPIC_REPORTED' => (!empty($row['topic_reported']) && empty($row['topic_moved_id']) && $auth->acl_get('m_report', $row['forum_id'])) ? true : false,

'S_TOPIC_UNAPPROVED' => $topic_unapproved,

'S_POSTS_UNAPPROVED' => $posts_unapproved,

'S_UNREAD_TOPIC' => $unread_topic,

);

if ($row['topic_status'] == ITEM_MOVED)

$sql = 'SELECT COUNT(post_id) AS total

FROM ' . POSTS_TABLE . '

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

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

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

$db->sql_freeresult($result);

$sql = 'SELECT post_id

FROM ' . POSTS_TABLE . '

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

ORDER BY post_time DESC';

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

foreach ($topic_data as $topic_id => $topic_info)

{

{

$topics_authed_moved++;

$topic_posts_added++;

$topics_removed++;

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

{

$topics_authed_removed++;

$topic_posts_removed++;

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

{

$shadow = array(

'forum_id' => (int) $row['forum_id'],

'icon_id' => (int) $row['icon_id'],

'topic_attachment' => (int) $row['topic_attachment'],

'topic_reported' => 0, // a shadow topic is never reported

'topic_title' => (string) $row['topic_title'],

'topic_poster' => (int) $row['topic_poster'],

'forum_id' => (int) $to_forum_id,

'icon_id' => (int) $topic_row['icon_id'],

'topic_attachment' => (int) $topic_row['topic_attachment'],

'topic_reported' => 0,

'topic_title' => (string) $topic_row['topic_title'],

'topic_poster' => (int) $topic_row['topic_poster'],

'icon_id' => (int) $row['icon_id'],

'poster_ip' => (string) $row['poster_ip'],

'post_time' => (int) $row['post_time'],

'post_reported' => 0,

'enable_bbcode' => (int) $row['enable_bbcode'],

'enable_smilies' => (int) $row['enable_smilies'],

'S_CAN_DELETE_POST' => $auth->acl_get('m_delete', $post_info['forum_id']),

'S_POST_REPORTED' => ($post_info['post_reported']) ? true : false,

'S_POST_LOCKED' => ($post_info['post_edit_locked']) ? true : false,

'S_USER_NOTES' => true,

'S_CLEAR_ALLOWED' => ($auth->acl_get('a_clearlogs')) ? true : false,

}

// Adjust post counts... only if the post is approved (else, it was not added the users post count anyway)

{

$sql = 'UPDATE ' . USERS_TABLE . '

SET user_posts = user_posts - 1

'U_APPROVE_ACTION' => append_sid("{$phpbb_root_path}mcp.$phpEx", "i=queue&p=$post_id&f=$forum_id"),

'S_CAN_VIEWIP' => $auth->acl_get('m_info', $post_info['forum_id']),

'S_POST_REPORTED' => $post_info['post_reported'],

'S_POST_LOCKED' => $post_info['post_edit_locked'],

'S_USER_NOTES' => true,

$sql = 'SELECT p.post_id

FROM ' . POSTS_TABLE . ' p, ' . TOPICS_TABLE . ' t' . (($sort_order_sql[0] == 'u') ? ', ' . USERS_TABLE . ' u' : '') . '

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

' . (($sort_order_sql[0] == 'u') ? 'AND u.user_id = p.poster_id' : '') . '

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

AND t.topic_id = p.topic_id

$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_attachment AS post_attachment, t.topic_first_poster_name AS username, t.topic_first_poster_colour AS user_colour

FROM ' . TOPICS_TABLE . " t

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

$limit_time_sql

ORDER BY $sort_order_sql";

$result = $db->sql_query_limit($sql, $config['topics_per_page'], $start);

foreach ($post_info as $post_id => $post_data)

{

{

$post_approved_list[] = $post_id;

continue;

if (sizeof($topic_approve_sql))

{

$sql = 'UPDATE ' . TOPICS_TABLE . '

WHERE ' . $db->sql_in_set('topic_id', $topic_approve_sql);

$db->sql_query($sql);

}

if (sizeof($post_approve_sql))

{

$sql = 'UPDATE ' . POSTS_TABLE . '

WHERE ' . $db->sql_in_set('post_id', $post_approve_sql);

$db->sql_query($sql);

}

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

'S_CAN_VIEWIP' => $auth->acl_get('m_info', $post_info['forum_id']),

'S_POST_REPORTED' => $post_info['post_reported'],

'S_POST_LOCKED' => $post_info['post_edit_locked'],

'S_USER_NOTES' => true,

$sql = 'SELECT u.username, u.username_clean, u.user_colour, p.*

FROM ' . POSTS_TABLE . ' p, ' . USERS_TABLE . ' u

WHERE ' . (($action == 'reports') ? 'p.post_reported = 1 AND ' : '') . '

AND p.poster_id = u.user_id ' .

$limit_time_sql . '

ORDER BY ' . $sort_order_sql;

parse_attachments($topic_info['forum_id'], $message, $attachments[$row['post_id']], $update_count);

}

{

$has_unapproved_posts = true;

}

'MINI_POST_IMG' => ($post_unread) ? $user->img('icon_post_target_unread', 'UNREAD_POST') : $user->img('icon_post_target', 'POST'),

'S_POST_REPORTED' => ($row['post_reported'] && $auth->acl_get('m_report', $topic_info['forum_id'])),

'S_CHECKED' => (($submitted_id_list && !in_array(intval($row['post_id']), $submitted_id_list)) || in_array(intval($row['post_id']), $checked_ids)) ? true : false,

'S_HAS_ATTACHMENTS' => (!empty($attachments[$row['post_id']])) ? true : false,

if ($sort_order_sql[0] == 'u')

{

FROM ' . POSTS_TABLE . ' p, ' . USERS_TABLE . " u

WHERE p.topic_id = $topic_id

AND p.poster_id = u.user_id

}

else

{

FROM ' . POSTS_TABLE . " p

WHERE p.topic_id = $topic_id

$limit_time_sql

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

{

// If split from selected post (split_beyond), we split the unapproved items too.

{

// continue;

}

$icon_id = request_var('icon', 0);

$sql_ary = array(

);

$sql = 'INSERT INTO ' . TOPICS_TABLE . ' ' . $db->sql_build_array('INSERT', $sql_ary);