+ 'S_MCP_ACTION' => $url . "&i=$id&mode=$mode&start=$start" . (($action == 'merge_select') ? $selected_ids : ''),

+ if (!sizeof($topic_ids))

+ trigger_error($user->lang['NO_TOPIC_SELECTED']);

+ if (check_ids($topic_ids, TOPICS_TABLE, 'topic_id', array('m_')))

+ 'U_VIEW_TOPIC' => (!empty($row['viewtopic'])) ? $row['viewtopic'] : '',

+ $orig_ids = $ids;

+

+ if (!check_ids($ids, $table, $sql_id, array('m_lock')))

+ $ids = $orig_ids;

+

+ if (!check_ids($ids, $table, $sql_id, array('f_user_lock')))

+ unset($orig_ids);

+ $redirect = request_var('redirect', build_url(array('_f_', 'action')));

+ add_log('mod', $row['forum_id'], $row['topic_id'], 'LOG_' . strtoupper($action), $row['topic_title']);

+ // For changing topic types, we only allow operations in one forum.

+ $forum_id = check_ids($topic_ids, TOPICS_TABLE, 'topic_id', array('f_announce', 'f_sticky', 'm_'), true);

+

+ if ($forum_id === false)

+ // Here we limit the operation to one forum only

+ $forum_id = check_ids($topic_ids, TOPICS_TABLE, 'topic_id', array('m_move'), true);

+

+ if ($forum_id === false)

+ if (!check_ids($topic_ids, TOPICS_TABLE, 'topic_id', array('m_delete')))

+ $redirect = request_var('redirect', build_url(array('_f_', 'action')));

+ $forum_id = request_var('f', 0);

+ add_log('mod', $row['forum_id'], 0, 'LOG_TOPIC_DELETED', $row['topic_title']);

+ if (!check_ids($post_ids, POSTS_TABLE, 'post_id', array('m_delete')))

+ $redirect = request_var('redirect', build_url(array('_f_', 'action')));

+ $forum_id = request_var('f', 0);

+ include($phpbb_root_path . 'includes/functions_admin.' . $phpEx);

+ if (!check_ids($topic_ids, TOPICS_TABLE, 'topic_id', array('m_')))

+ $forum_id = request_var('forum_id', 0);

+ $redirect = request_var('redirect', build_url(array('_f_', 'action')));

+ $sql = 'SELECT t.topic_id, t.topic_title, t.forum_id, p.post_id, p.post_subject, p.post_username, p.poster_id, p.post_time, u.username, u.user_colour

+ $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

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

+ {

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

+ }

+

+ if (!check_ids($post_id_list, POSTS_TABLE, 'post_id', array('m_approve')))

+ $redirect = request_var('redirect', build_url(array('_f_')));

+ $total_topics = $total_posts = 0;

+ $forum_topics_posts = $topic_approve_sql = $topic_replies_sql = $post_approve_sql = $topic_id_list = $forum_id_list = array();

+ if ($post_data['forum_id'])

+ {

+ $forum_id_list[$post_data['forum_id']] = 1;

+ }

+

+ if (!isset($forum_topics_posts[$post_data['forum_id']]))

+ {

+ $forum_topics_posts[$post_data['forum_id']] = array(

+ 'forum_posts' => 0,

+ 'forum_topics' => 0

+ );

+ }

+

+ $forum_topics_posts[$post_data['forum_id']]['forum_topics']++;

+ $topic_replies_sql[$post_data['topic_id']] = 0;

+ $topic_replies_sql[$post_data['topic_id']]++;

+ if (!isset($forum_topics_posts[$post_data['forum_id']]))

+ {

+ $forum_topics_posts[$post_data['forum_id']] = array(

+ 'forum_posts' => 0,

+ 'forum_topics' => 0

+ );

+ }

+

+ $forum_topics_posts[$post_data['forum_id']]['forum_posts']++;

+ if (sizeof($forum_topics_posts))

+ foreach ($forum_topics_posts as $forum_id => $row)

+ {

+ $sql = 'UPDATE ' . FORUMS_TABLE . '

+ SET ';

+ $sql .= ($row['forum_topics']) ? "forum_topics = forum_topics + {$row['forum_topics']}" : '';

+ $sql .= ($row['forum_topics'] && $row['forum_posts']) ? ', ' : '';

+ $sql .= ($row['forum_posts']) ? "forum_posts = forum_posts + {$row['forum_posts']}" : '';

+ $sql .= " WHERE forum_id = $forum_id";

+ $db->sql_query($sql);

+ }

+ update_post_information('forum', array_keys($forum_id_list));

+ unset($topic_id_list, $forum_id_list);

+ 'U_VIEW_TOPIC' => generate_board_url() . "/viewtopic.$phpEx?f={$post_data['forum_id']}&t={$post_data['topic_id']}&e=0",

+ 'U_VIEW_POST' => generate_board_url() . "/viewtopic.$phpEx?f={$post_data['forum_id']}&t={$post_data['topic_id']}&p=$post_id&e=$post_id")

+ user_notification('post', $post_data['topic_title'], $post_data['topic_title'], $post_data['forum_name'], $post_data['forum_id'], $post_data['topic_id'], $post_id);

+ user_notification('reply', $post_data['post_subject'], $post_data['topic_title'], $post_data['forum_name'], $post_data['forum_id'], $post_data['topic_id'], $post_id);

+ if ($total_topics)

+ $success_msg = ($total_topics == 1) ? 'TOPIC_APPROVED_SUCCESS' : 'TOPICS_APPROVED_SUCCESS';

+ if (!check_ids($post_id_list, POSTS_TABLE, 'post_id', array('m_approve')))

+ $redirect = request_var('redirect', build_url(array('t', 'mode', '_f_')) . '&mode=unapproved_topics');

+ $num_disapproved = 0;

+ $forum_topics_real = $topic_id_list = $forum_id_list = $topic_replies_real_sql = $post_disapprove_sql = array();

+ if ($post_data['forum_id'])

+ {

+ $forum_id_list[$post_data['forum_id']] = 1;

+ }

+

+ if (!isset($forum_topics_real[$post_data['forum_id']]))

+ {

+ $forum_topics_real[$post_data['forum_id']] = 0;

+ }

+ $forum_topics_real[$post_data['forum_id']]++;

+ $num_disapproved++;

+ $topic_replies_real_sql[$post_data['topic_id']] = 0;

+ $topic_replies_real_sql[$post_data['topic_id']]++;

+ if (sizeof($forum_topics_real))

+ foreach ($forum_topics_real as $forum_id => $topics_real)

+ {

+ $sql = 'UPDATE ' . FORUMS_TABLE . "

+ SET forum_topics_real = forum_topics_real - $topics_real

+ WHERE forum_id = $forum_id";

+ $db->sql_query($sql);

+ }

+

+ if (sizeof($forum_id_list))

+ {

+ update_post_information('forum', array_keys($forum_id_list));

+ }

+ unset($topic_id_list, $forum_id_list);

+ if (sizeof($forum_topics_real))

+ $success_msg = ($num_disapproved == 1) ? 'TOPIC_DISAPPROVED_SUCCESS' : 'TOPICS_DISAPPROVED_SUCCESS';

+ 'S_CLOSE_ACTION' => $this->u_action . '&p=' . $post_id . 'f=' . $forum_id,

+ 'RETURN_REPORTS' => sprintf($user->lang['RETURN_REPORTS'], '<a href="' . append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=reports' . (($post_info['post_reported']) ? '&amp;mode=reports' : '&amp;mode=reports_closed') . '&amp;start=' . $start . '&amp;f=' . $post_info['forum_id']) . '">', '</a>'),

+ $sql = 'SELECT t.forum_id, t.topic_id, t.topic_title, p.post_id, p.post_subject, p.post_username, p.poster_id, p.post_time, u.username, u.user_colour, r.user_id as reporter_id, ru.username as reporter_name, ru.user_colour as reporter_colour, r.report_time, r.report_id

+ 'REPORTER_FULL' => get_username_string('full', $row['reporter_id'], $row['reporter_name'], $row['reporter_colour']),

+ 'REPORTER_COLOUR' => get_username_string('colour', $row['reporter_id'], $row['reporter_name'], $row['reporter_colour']),

+ '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']),

+

+ 'S_MCP_ACTION' => $this->u_action,

+ if (!check_ids($post_id_list, POSTS_TABLE, 'post_id', array('m_report')))

+ $redirect = request_var('redirect', build_url(array('mode', '_f_', 'r')) . '&amp;mode=reports');

+ $redirect = request_var('redirect', build_url(array('_f_')));

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

+ $forum_id = request_var('forum_id', 0);

+ if (!check_ids($post_id_list, POSTS_TABLE, 'post_id', array('m_split')))

+ if (!check_ids($post_id_list, POSTS_TABLE, 'post_id', array('m_merge')))

+ $return_link .= sprintf($user->lang['RETURN_TOPIC'], '<a href="' . append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . $topic_data['forum_id'] . '&amp;t=' . $topic_id) . '">', '</a>');