}

// Include the admin banning interface...

$bansubmit = $request->is_set_post('bansubmit');

$unbansubmit = $request->is_set_post('unbansubmit');

}

else if ($post_id)

{

{

switch ($mode)

{

$pagination = $phpbb_container->get('pagination');

$selected_ids = '';

{

foreach ($post_id_list as $num => $post_id)

{

$selected_ids .= '&post_id_list[' . $num . ']=' . $post_id;

}

}

{

foreach ($topic_id_list as $num => $topic_id)

{

$db->sql_freeresult($result);

// If there is more than one page, but we have no topic list, then the start parameter is... erm... out of sync

{

redirect($url . "&i=$id&action=$action&mode=$mode");

}

// Get topic tracking info

{

if ($config['load_db_lastread'])

{

{

global $db, $user, $phpbb_log, $request;

{

trigger_error('NO_TOPIC_SELECTED');

}

}

$db->sql_freeresult($result);

$redirect = $request->variable('redirect', $user->data['session_page']);

{

global $db, $template, $user, $phpEx, $phpbb_root_path, $phpbb_log, $request, $phpbb_dispatcher;

{

$template->assign_var('MESSAGE', $user->lang['NO_TOPIC_SELECTED']);

return;

$all_topic_data = phpbb_get_topic_data($sync_topics, 'm_merge');

{

$template->assign_var('MESSAGE', $user->lang['NO_FINAL_TOPIC_SELECTED']);

return;

$post_id_list = $request->variable('post_id_list', array(0));

$start = $request->variable('start', 0);

{

$sql = 'SELECT post_id

FROM ' . POSTS_TABLE . '

$db->sql_freeresult($result);

}

{

$template->assign_var('MESSAGE', $user->lang['NO_POST_SELECTED']);

return;

if ($total)

{

$sql_ary = array(

'SELECT' => 'r.report_id, r.report_time, p.msg_id, p.message_subject, p.message_time, p.to_address, p.bcc_address, p.message_attachment, 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',

var $u_action;

var $p_master;

{

}

function main($id, $mode)

{

if (confirm_box(true))

{

{

$conditions = array(

'forum_id' => array('IN' => $forum_list),

'IP' => $row['ip'],

'DATE' => $user->format_date($row['time']),

'ACTION' => $row['action'],

'ID' => $row['id'],

)

);

var $p_master;

var $u_action;

{

}

function main($id, $mode)

$quickmod = ($mode == 'quickmod') ? true : false;

switch ($action)

{

case 'lock':

case 'unlock':

$topic_ids = (!$quickmod) ? $request->variable('topic_id_list', array(0)) : array($request->variable('t', 0));

{

trigger_error('NO_TOPIC_SELECTED');

}

$post_ids = (!$quickmod) ? $request->variable('post_id_list', array(0)) : array($request->variable('p', 0));

{

trigger_error('NO_POST_SELECTED');

}

$topic_ids = (!$quickmod) ? $request->variable('topic_id_list', array(0)) : array($request->variable('t', 0));

{

trigger_error('NO_TOPIC_SELECTED');

}

$topic_ids = (!$quickmod) ? $request->variable('topic_id_list', array(0)) : array($request->variable('t', 0));

{

trigger_error('NO_TOPIC_SELECTED');

}

$topic_ids = (!$quickmod) ? $request->variable('topic_id_list', array(0)) : array($request->variable('t', 0));

{

trigger_error('NO_TOPIC_SELECTED');

}

$topic_ids = (!$quickmod) ? $request->variable('topic_id_list', array(0)) : array($request->variable('t', 0));

$soft_delete = (($request->is_set_post('confirm') && !$request->is_set_post('delete_permanent')) || !$auth->acl_get('m_delete', $forum_id)) ? true : false;

{

trigger_error('NO_TOPIC_SELECTED');

}

$post_ids = (!$quickmod) ? $request->variable('post_id_list', array(0)) : array($request->variable('p', 0));

$soft_delete = (($request->is_set_post('confirm') && !$request->is_set_post('delete_permanent')) || !$auth->acl_get('m_delete', $forum_id)) ? true : false;

{

trigger_error('NO_POST_SELECTED');

}

$topic_ids = (!$quickmod) ? $request->variable('topic_id_list', array(0)) : array($request->variable('t', 0));

{

trigger_error('NO_TOPIC_SELECTED');

}

switch ($mode)

{

case 'front':

$user->add_lang('acp/common');

break;

case 'forum_view':

$user->add_lang('viewforum');

$forum_info = phpbb_get_forum_data($forum_id, 'm_', true);

{

$this->main('main', 'front');

return;

break;

case 'topic_view':

mcp_topic_view($id, $mode, $action);

break;

case 'post_details':

mcp_post_details($id, $mode, $action);

);

extract($phpbb_dispatcher->trigger_event('core.mcp_lock_unlock_after', compact($vars)));

meta_refresh(2, $redirect);

$message = $user->lang[$success_msg];

}

else

{

}

redirect($redirect);

*/

function change_topic_type($action, $topic_ids)

{

switch ($action)

{

case 'make_announce':

$new_topic_type = POST_ANNOUNCE;

$check_acl = 'f_announce';

break;

case 'make_global':

$new_topic_type = POST_GLOBAL;

$check_acl = 'f_announce_global';

break;

case 'make_sticky':

$new_topic_type = POST_STICKY;

$check_acl = 'f_sticky';

break;

default:

$new_topic_type = POST_NORMAL;

$check_acl = false;

break;

}

if (confirm_box(true))

{

$sql = 'UPDATE ' . TOPICS_TABLE . "

SET topic_type = $new_topic_type

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

$db->sql_query($sql);

{

// Delete topic shadows for global announcements

$sql = 'DELETE FROM ' . TOPICS_TABLE . '

WHERE ' . $db->sql_in_set('topic_moved_id', $topic_ids);

$db->sql_query($sql);

}

{

$data = phpbb_get_topic_data($topic_ids);

}

}

meta_refresh(2, $redirect);

$message = $user->lang[$success_msg];

{

$forum_data = phpbb_get_forum_data($to_forum_id, 'f_post');

{

$additional_msg = $user->lang['FORUM_NOT_EXIST'];

}

$sync_sql[$forum_id][] = 'forum_topics_softdeleted = forum_topics_softdeleted - ' . (int) $topics_moved_softdeleted;

}

foreach ($sync_sql as $forum_id_key => $array)

{

'ADDITIONAL_MSG' => $additional_msg)

);

}

$redirect = $request->variable('redirect', "index.$phpEx");

if (confirm_box(true))

{

$data = phpbb_get_topic_data($topic_ids);

}

else

{

}

$topic_id = $request->variable('t', 0);

if (confirm_box(true))

{

$data = phpbb_get_topic_data($topic_ids);

'S_TOPIC_MODE' => true,

'S_ALLOWED_DELETE' => $auth->acl_get('m_delete', $forum_id),

'S_ALLOWED_SOFTDELETE' => $auth->acl_get('m_softdelete', $forum_id),

));

if ($only_softdeleted)

{

$s_hidden_fields['delete_permanent'] = '1';

}

else if ($only_shadow || !$auth->acl_get('m_softdelete', $forum_id))

{

$phpbb_content_visibility->set_post_visibility(ITEM_DELETED, $topic_data['posts'], $topic_id, $topic_data['forum_id'], $user->data['user_id'], time(), $soft_delete_reason, isset($topic_data['first_post']), isset($topic_data['last_post']));

}

// None of the topics is really deleted, so a redirect won't hurt much.

$deleted_topics = 0;

foreach ($approve_log as $row)

{

{

$topic_id_list[] = $row['topic_id'];

}

$db->sql_freeresult($result);

$post_data = phpbb_get_post_data($post_ids);

}

$return_link[] = sprintf($user->lang['RETURN_FORUM'], '<a href="' . append_sid("{$phpbb_root_path}viewforum.$phpEx", 'f=' . $forum_id) . '">', '</a>');

{

if ($deleted_topics)

{

'S_SOFTDELETED' => $only_softdeleted,

'S_ALLOWED_DELETE' => $auth->acl_get('m_delete', $forum_id),

'S_ALLOWED_SOFTDELETE' => $auth->acl_get('m_softdelete', $forum_id),

));

if ($only_softdeleted)

{

$s_hidden_fields['delete_permanent'] = '1';

}

else if (!$auth->acl_get('m_softdelete', $forum_id))

{

$forum_data = phpbb_get_forum_data($to_forum_id, 'f_post');

{

$additional_msg = $user->lang['NO_TOPIC_SELECTED'];

}

{

$additional_msg = $user->lang['FORUM_NOT_EXIST'];

}

}

$db->sql_freeresult($result);

{

continue;

}

$db->sql_query('INSERT INTO ' . POSTS_TABLE . ' ' . $db->sql_build_array('INSERT', $sql_ary));

$new_post_id = $db->sql_nextid();

switch ($row['post_visibility'])

{

case ITEM_APPROVED:

}

$db->sql_freeresult($result);

{

$db->sql_multi_insert(ATTACHMENTS_TABLE, $sql_ary);

}

}

$db->sql_freeresult($result);

{

$db->sql_multi_insert(TOPICS_WATCH_TABLE, $sql_ary);

}

}

$db->sql_freeresult($result);

{

$db->sql_multi_insert(BOOKMARKS_TABLE, $sql_ary);

}

sync('topic', 'topic_id', $new_topic_id_list);

sync('forum', 'forum_id', $to_forum_id);

$config->increment('num_posts', $total_posts, false);

foreach ($new_topic_id_list as $topic_id => $new_topic_id)

));

}

}

else

{

'ADDITIONAL_MSG' => $additional_msg)

);

}

$redirect = $request->variable('redirect', "index.$phpEx");

var $p_master;

var $u_action;

{

}

function main($id, $mode)

var $p_master;

var $u_action;

{

}

function main($id, $mode)

$report_id_list = $request->variable('report_id_list', array(0));

{

trigger_error('NO_REPORT_SELECTED');

}

$pm_info = phpbb_get_pm_data(array($pm_id));

{

trigger_error('NO_REPORT_SELECTED');

}

}

$db->sql_freeresult($result);

{

$update_count = array();

parse_attachments(0, $message, $attachments, $update_count);

}

$db->sql_freeresult($result);

{

$sql = 'SELECT p.*, u.username, u.username_clean, 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

FROM ' . REPORTS_TABLE . ' r, ' . PRIVMSGS_TABLE . ' p, ' . USERS_TABLE . ' u, ' . USERS_TABLE . ' ru

}

$db->sql_freeresult($result);

{

$address_list = get_recipient_strings($pm_by_id);

add_form_key('mcp_post_details');

{

trigger_error('POST_NOT_EXIST');

}

}

$db->sql_freeresult($result);

{

$user->add_lang('viewtopic');

$update_count = array();

$l_deleted_by = '';

}

$mcp_post_template_data = array(

'U_MCP_ACTION' => "$url&amp;i=main&amp;quickmod=1&amp;mode=post_details", // Use this for mode paramaters

'U_POST_ACTION' => "$url&amp;i=$id&amp;mode=post_details", // Use this for action parameters

'POST_IP' => $post_info['poster_ip'],

'POST_IPADDR' => ($auth->acl_get('m_info', $post_info['forum_id']) && $request->variable('lookup', '')) ? @gethostbyaddr($post_info['poster_ip']) : '',

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

'U_LOOKUP_IP' => ($auth->acl_get('m_info', $post_info['forum_id'])) ? "$url&amp;i=$id&amp;mode=$mode&amp;lookup={$post_info['poster_ip']}#ip" : '',

'U_WHOIS' => ($auth->acl_get('m_info', $post_info['forum_id'])) ? append_sid("{$phpbb_root_path}mcp.$phpEx", "i=$id&amp;mode=$mode&amp;action=whois&amp;p=$post_id&amp;ip={$post_info['poster_ip']}") : '',

);

}

{

// Get the usernames

$sql = 'SELECT user_id, username

$user_select = '';

{

ksort($usernames_ary);

// Renew post info

$post_info = phpbb_get_post_data(array($post_id), false, true);

{

trigger_error('POST_NOT_EXIST');

}

var $p_master;

var $u_action;

{

}

public function main($id, $mode)

$post_info = phpbb_get_post_data(array($post_id), 'm_approve', true);

{

trigger_error('NO_POST_SELECTED');

}

}

$db->sql_freeresult($result);

{

$update_count = array();

parse_attachments($post_info['forum_id'], $message, $attachments, $update_count);

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

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

'S_MCP_QUEUE' => true,

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

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

'S_FIRST_POST' => ($post_info['topic_first_post_id'] == $post_id),

'U_LOOKUP_IP' => ($auth->acl_get('m_info', $post_info['forum_id'])) ? append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=queue&amp;mode=approve_details&amp;f=' . $post_info['forum_id'] . '&amp;p=' . $post_id . '&amp;lookup=' . $post_info['poster_ip']) . '#ip' : '',

break;

{

$topic_info = phpbb_get_topic_data(array($topic_id));

{

trigger_error('TOPIC_NOT_EXIST');

}

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

}

{

trigger_error('NOT_MODERATOR');

}

{

$forum_info = phpbb_get_forum_data(array($forum_id), $m_perm);

{

trigger_error('NOT_MODERATOR');

}

}

$db->sql_freeresult($result);

{

$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, p.post_attachment, u.username, u.username_clean, u.user_colour

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

AND t.topic_id = p.topic_id

AND u.user_id = p.poster_id

ORDER BY ' . $sort_order_sql;

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

$post_data = $rowset = array();

$db->sql_freeresult($result);

}

{

// Select the names for the forum_ids

$sql = 'SELECT forum_id, forum_name

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

}

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

'U_VIEWFORUM' => append_sid("{$phpbb_root_path}viewforum.$phpEx", 'f=' . $row['forum_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'] : ''),

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

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

'S_HAS_ATTACHMENTS' => $auth->acl_get('u_download') && $auth->acl_get('f_download', $row['forum_id']) && $row['post_attachment'],

}

unset($rowset, $forum_names);

}

else

{

}

/**

$message .= '<br /><br />' . $user->lang('RETURN_PAGE', '<a href="' . $redirect . '">', '</a>');

// If approving one post, also give links back to post...

{

$message .= '<br /><br />' . $user->lang('RETURN_POST', '<a href="' . $post_url . '">', '</a>');

}

// Create the confirm box message

$action_msg = strtoupper($action);

if ($num_topics > 0 && $num_posts <= 0)

{

$action_msg .= '_TOPIC' . (($num_topics == 1) ? '' : 'S');

}

else

{

}

confirm_box(false, $action_msg, $s_hidden_fields, 'mcp_approve.html');

}

);

}

{

}

foreach ($approve_log as $log_data)

$message .= '<br /><br />' . $user->lang('RETURN_PAGE', '<a href="' . $redirect . '">', '</a>');

// If approving one topic, also give links back to topic...

{

$message .= '<br /><br />' . $user->lang('RETURN_TOPIC', '<a href="' . $topic_url . '">', '</a>');

}

'S_' . strtoupper($action) => true,

));

}

redirect($redirect);

}

// Get disapproved posts/topics counts separately

// Build the whole log

$disapprove_log = array_merge($disapprove_log_topics, $disapprove_log_posts);

unset($post_data, $disapprove_log_topics, $disapprove_log_posts);

// Let's do the job - delete disapproved posts

{

if (!function_exists('delete_posts'))

{

$l_confirm_msg = 'DELETE_POST_PERMANENTLY';

$confirm_template = 'confirm_delete_body.html';

}

$template->assign_vars(array(

'S_NOTIFY_POSTER' => $show_notify,

var $p_master;

var $u_action;

{

}

function main($id, $mode)

$report_id_list = $request->variable('report_id_list', array(0));

{

trigger_error('NO_REPORT_SELECTED');

}

$post_info = phpbb_get_post_data(array($post_id), 'm_report', true);

{

trigger_error('NO_REPORT_SELECTED');

}

}

$db->sql_freeresult($result);

{

$update_count = array();

parse_attachments($post_info['forum_id'], $message, $attachments, $update_count);

}

}

'S_MCP_REPORT' => true,

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

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

'POST_IP' => $post_info['poster_ip'],

'POST_IPADDR' => ($auth->acl_get('m_info', $post_info['forum_id']) && $request->variable('lookup', '')) ? @gethostbyaddr($post_info['poster_ip']) : '',

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

'U_LOOKUP_IP' => ($auth->acl_get('m_info', $post_info['forum_id'])) ? $this->u_action . '&amp;r=' . $report_id . '&amp;p=' . $post_id . '&amp;f=' . $forum_id . '&amp;lookup=' . $post_info['poster_ip'] . '#ip' : '',

$this->tpl_name = 'mcp_post';

{

$topic_info = phpbb_get_topic_data(array($topic_id));

{

trigger_error('TOPIC_NOT_EXIST');

}

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

}

{

trigger_error('NOT_MODERATOR');

}

{

$forum_info = phpbb_get_forum_data(array($forum_id), 'm_report');

{

trigger_error('NOT_MODERATOR');

}

}

$db->sql_freeresult($result);

{

$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, p.post_attachment, u.username, u.username_clean, 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

FROM ' . REPORTS_TABLE . ' r, ' . POSTS_TABLE . ' p, ' . TOPICS_TABLE . ' t, ' . USERS_TABLE . ' u, ' . USERS_TABLE . ' ru

}

$db->sql_freeresult($result);

{

$close_report_posts = array_unique($close_report_posts);

$close_report_topics = array_unique($close_report_topics);

{

// Get a list of topics that still contain reported posts

$sql = 'SELECT DISTINCT topic_id

}

$db->sql_query($sql);

{

if ($pm)

{

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

$db->sql_query($sql);

{

$sql = 'UPDATE ' . TOPICS_TABLE . '

SET topic_reported = 0

}

// Notify reporters

{

foreach ($notify_reporters as $report_id => $reporter)

{

unset($notify_reporters, $post_info, $reports);

}

else

{

}

$redirect = $request->variable('redirect', "index.$phpEx");

if (!$pm)

{

{

$return_forum = sprintf($user->lang['RETURN_FORUM'], '<a href="' . append_sid("{$phpbb_root_path}viewforum.$phpEx", 'f=' . current($forum_ids)) . '">', '</a>') . '<br /><br />';

}

{

$return_topic = sprintf($user->lang['RETURN_TOPIC'], '<a href="' . append_sid("{$phpbb_root_path}viewtopic.$phpEx", 't=' . current($topic_ids) . '&amp;f=' . current($forum_ids)) . '">', '</a>') . '<br /><br />';

}

$topic_id = $request->variable('t', 0);

$topic_info = phpbb_get_topic_data(array($topic_id), false, true);

{

trigger_error('TOPIC_NOT_EXIST');

}

// Restore or pprove posts?

if (($action == 'restore' || $action == 'approve') && $auth->acl_get('m_approve', $topic_info['forum_id']))

{

include_once($phpbb_root_path . 'includes/functions_posting.' . $phpEx);

include_once($phpbb_root_path . 'includes/functions_messenger.' . $phpEx);

{

trigger_error('NO_POST_SELECTED');

}

}

$start = $pagination->validate_start($start, $posts_per_page, $total);

p.topic_id = ' . $topic_id . '

AND ' . $phpbb_content_visibility->get_visibility_sql('post', $topic_info['forum_id'], 'p.') . '

AND p.poster_id = u.user_id ' .

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

$rowset = $post_id_list = array();

// Grab extensions

$attachments = array();

{

// Get attachments...

if ($auth->acl_get('u_download') && $auth->acl_get('f_download', $topic_info['forum_id']))

{

$to_topic_info = phpbb_get_topic_data(array($to_topic_id), 'm_merge');

{

$to_topic_id = 0;

}

$forum_id = $request->variable('forum_id', 0);

$start = $request->variable('start', 0);

{

$template->assign_var('MESSAGE', $user->lang['NO_POST_SELECTED']);

return;

$post_id = $post_id_list[0];

$post_info = phpbb_get_post_data(array($post_id));

{

$template->assign_var('MESSAGE', $user->lang['NO_POST_SELECTED']);

return;

$forum_info = phpbb_get_forum_data(array($to_forum_id), 'f_post');

{

$template->assign_var('MESSAGE', $user->lang['USER_CANNOT_POST']);

return;

$db->sql_freeresult($result);

}

{

trigger_error('NO_POST_SELECTED');

}

}

$db->sql_freeresult($result);

{

$db->sql_multi_insert(TOPICS_WATCH_TABLE, $sql_ary);

}

}

$db->sql_freeresult($result);

{

$db->sql_multi_insert(BOOKMARKS_TABLE, $sql_ary);

}

$topic_data = phpbb_get_topic_data($sync_topics, 'm_merge');

{

$template->assign_var('MESSAGE', $user->lang['NO_FINAL_TOPIC_SELECTED']);

return;

$post_id_list = $request->variable('post_id_list', array(0));

$start = $request->variable('start', 0);

{

$template->assign_var('MESSAGE', $user->lang['NO_POST_SELECTED']);

return;

var $p_master;

var $u_action;

{

}

function main($id, $mode)