return array(

'filename' => 'mcp_ban',

'title' => 'MCP_BAN',

'modes' => array(

'user' => array('title' => 'MCP_BAN_USERNAMES', 'auth' => 'acl_m_ban', 'cat' => array('MCP_BAN')),

'ip' => array('title' => 'MCP_BAN_IPS', 'auth' => 'acl_m_ban', 'cat' => array('MCP_BAN')),

return array(

'filename' => 'mcp_logs',

'title' => 'MCP_LOGS',

'modes' => array(

'front' => array('title' => 'MCP_LOGS_FRONT', 'auth' => 'acl_m_ || aclf_m_', 'cat' => array('MCP_LOGS')),

'forum_logs' => array('title' => 'MCP_LOGS_FORUM_VIEW', 'auth' => 'acl_m_,$id', 'cat' => array('MCP_LOGS')),

return array(

'filename' => 'mcp_main',

'title' => 'MCP_MAIN',

'modes' => array(

'front' => array('title' => 'MCP_MAIN_FRONT', 'auth' => '', 'cat' => array('MCP_MAIN')),

'forum_view' => array('title' => 'MCP_MAIN_FORUM_VIEW', 'auth' => 'acl_m_,$id', 'cat' => array('MCP_MAIN')),

return array(

'filename' => 'mcp_notes',

'title' => 'MCP_NOTES',

'modes' => array(

'front' => array('title' => 'MCP_NOTES_FRONT', 'auth' => '', 'cat' => array('MCP_NOTES')),

'user_notes' => array('title' => 'MCP_NOTES_USER', 'auth' => '', 'cat' => array('MCP_NOTES')),

return array(

'filename' => 'mcp_pm_reports',

'title' => 'MCP_PM_REPORTS',

'modes' => array(

),

);

}

return array(

'filename' => 'mcp_queue',

'title' => 'MCP_QUEUE',

'modes' => array(

'unapproved_topics' => array('title' => 'MCP_QUEUE_UNAPPROVED_TOPICS', 'auth' => 'aclf_m_approve', 'cat' => array('MCP_QUEUE')),

'unapproved_posts' => array('title' => 'MCP_QUEUE_UNAPPROVED_POSTS', 'auth' => 'aclf_m_approve', 'cat' => array('MCP_QUEUE')),

return array(

'filename' => 'mcp_reports',

'title' => 'MCP_REPORTS',

'modes' => array(

'reports' => array('title' => 'MCP_REPORTS_OPEN', 'auth' => 'aclf_m_report', 'cat' => array('MCP_REPORTS')),

'reports_closed' => array('title' => 'MCP_REPORTS_CLOSED', 'auth' => 'aclf_m_report', 'cat' => array('MCP_REPORTS')),

return array(

'filename' => 'mcp_warn',

'title' => 'MCP_WARN',

'modes' => array(

'front' => array('title' => 'MCP_WARN_FRONT', 'auth' => 'aclf_m_warn', 'cat' => array('MCP_WARN')),

'list' => array('title' => 'MCP_WARN_LIST', 'auth' => 'aclf_m_warn', 'cat' => array('MCP_WARN')),

global $db, $user, $auth, $template, $request, $phpbb_dispatcher;

global $phpbb_root_path, $phpEx;

// Include the admin banning interface...

include($phpbb_root_path . 'includes/acp/acp_ban.' . $phpEx);

{

$post_info = phpbb_get_post_data($post_id, 'm_ban');

{

switch ($mode)

{

// merge_topic is the quickmod action, merge_topics is the mcp_forum action, and merge_select is the mcp_topic action

$merge_select = ($action == 'merge_select' || $action == 'merge_topic' || $action == 'merge_topics') ? true : false;

$forum_id = $forum_info['forum_id'];

$url_extra = '';

$url_extra .= ($forum_id) ? "&f=$forum_id" : '';

switch ($action)

{

case 'resync':

mcp_resync_topics($topic_ids);

break;

break;

}

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

{

'S_CAN_SYNC' => $auth->acl_get('m_', $forum_id),

'S_CAN_APPROVE' => $auth->acl_get('m_approve', $forum_id),

'S_MERGE_SELECT' => ($merge_select) ? true : false,

'S_CAN_MAKE_STICKY' => $auth->acl_get('f_sticky', $forum_id),

'S_CAN_MAKE_ANNOUNCE' => $auth->acl_get('f_announce', $forum_id),

'U_VIEW_FORUM' => append_sid("{$phpbb_root_path}viewforum.$phpEx", 'f=' . $forum_id),

'U_VIEW_FORUM_LOGS' => ($auth->acl_gets('a_', 'm_', $forum_id) && $module->loaded('logs')) ? append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=logs&mode=forum_logs&f=' . $forum_id) : '',

$read_tracking_join = $read_tracking_select = '';

}

$phpbb_content_visibility = $phpbb_container->get('content.visibility');

$sql = 'SELECT t.topic_id

$topic_list = $topic_tracking_info = array();

{

}

$db->sql_freeresult($result);

WHERE " . $db->sql_in_set('t.topic_id', $topic_list, false, true);

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

{

}

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

{

foreach ($topic_list as $topic_id)

{

{

$unread_topic = false;

}

else

{

}

// Get folder img, topic status/type related information

$folder_img = $folder_alt = $topic_type = '';

$u_mcp_queue = (!$u_mcp_queue && $topic_deleted) ? $url . '&i=queue&mode=deleted_topics&t=' . $topic_id : $u_mcp_queue;

$topic_row = array(

'TOPIC_IMG_STYLE' => $folder_img,

'TOPIC_FOLDER_IMG' => $user->img($folder_img, $folder_alt),

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

'TOPIC_TYPE' => $topic_type,

'TOPIC_TITLE' => $topic_title,

'S_TOPIC_UNAPPROVED' => $topic_unapproved,

'S_POSTS_UNAPPROVED' => $posts_unapproved,

'S_TOPIC_DELETED' => $topic_deleted,

'S_UNREAD_TOPIC' => $unread_topic,

);

{

$topic_row = array_merge($topic_row, array(

'S_MOVED_TOPIC' => true,

));

}

else

{

if ($action == 'merge_topic' || $action == 'merge_topics')

{

}

else

{

}

$topic_row = array_merge($topic_row, array(

'U_SELECT_TOPIC' => $u_select_topic,

'U_MCP_QUEUE' => $u_mcp_queue,

));

}

/**

* Modify the topic data before it is assigned to the template in MCP

*

* @event core.mcp_view_forum_modify_topicrow

* @var array topic_row Template array with topic data

* @since 3.1.0-a1

*/

$vars = array('row', 'topic_row');

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

$template->assign_block_vars('topicrow', $topic_row);

}

*/

function mcp_resync_topics($topic_ids)

{

{

trigger_error('NO_TOPIC_SELECTED');

}

// Log this action

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

{

}

$db->sql_freeresult($result);

meta_refresh(3, $redirect);

trigger_error($msg . '<br /><br />' . sprintf($user->lang['RETURN_PAGE'], '<a href="' . $redirect . '">', '</a>'));

*/

function merge_topics($forum_id, $topic_ids, $to_topic_id)

{

{

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

return;

$sync_topics = array_merge($topic_ids, array($to_topic_id));

{

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

return;

}

$sync_forums = array();

{

$sync_forums[$data['forum_id']] = $data['forum_id'];

}

{

$sql = 'SELECT post_id

FROM ' . POSTS_TABLE . '

$db->sql_freeresult($result);

}

{

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

return;

return;

}

$s_hidden_fields = build_hidden_fields(array(

'i' => 'main',

'redirect' => $redirect,

'topic_id_list' => $topic_ids)

);

if (confirm_box(true))

{

move_posts($post_id_list, $to_topic_id, false);

// Message and return links

$success_msg = 'POSTS_MERGED_SUCCESS';

// Link to the new topic

$return_link .= (($return_link) ? '<br /><br />' : '') . sprintf($user->lang['RETURN_NEW_TOPIC'], '<a href="' . append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . $to_forum_id . '&amp;t=' . $to_topic_id) . '">', '</a>');

$redirect = reapply_sid($redirect);

meta_refresh(3, $redirect);

trigger_error($user->lang[$success_msg] . '<br /><br />' . $return_link);

}

*/

function mcp_front_view($id, $mode, $action)

{

global $template, $db, $user, $auth, $module;

// Latest 5 unapproved

if ($module->loaded('queue'))

$post_list = array();

$forum_names = array();

$template->assign_var('S_SHOW_UNAPPROVED', (!empty($forum_list)) ? true : false);

if (!empty($forum_list))

{

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

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

$db->sql_freeresult($result);

AND r.pm_id = 0

AND r.report_closed = 0

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

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

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

$db->sql_freeresult($result);

* Alter sql query to get latest reported posts

*

* @event core.mcp_front_reports_listing_query_before

* @since 3.1.0-RC3

*/

$vars = array('sql_ary', 'forum_list');

}

// Latest 5 reported PMs

{

$template->assign_var('S_SHOW_PM_REPORTS', true);

$user->add_lang(array('ucp'));

function main($id, $mode)

{

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

if (is_array($action))

{

}

else

{

}

// Set up general vars

$deletemark = ($action == 'del_marked') ? true : false;

$deleteall = ($action == 'del_all') ? true : false;

// Sort keys

$this->tpl_name = 'mcp_logs';

$this->page_title = 'MCP_LOGS';

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

$forum_list = array_values(array_intersect(get_forum_list('f_read'), get_forum_list('m_')));

break;

case 'forum_logs':

if (!in_array($forum_id, $forum_list))

{

trigger_error('NOT_AUTHORISED');

}

break;

case 'topic_logs':

$sql = 'SELECT forum_id

FROM ' . TOPICS_TABLE . '

if (!in_array($forum_id, $forum_list))

{

trigger_error('NOT_AUTHORISED');

}

{

if (confirm_box(true))

{

{

$conditions = array(

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

}

else if ($deleteall)

{

$conditions = array(

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

'sd' => $sort_dir,

'i' => $id,

'mode' => $mode,

);

}

}

$sql_where = ($sort_days) ? (time() - ($sort_days * 86400)) : 0;

$sql_sort = $sort_by_sql[$sort_key] . ' ' . (($sort_dir == 'd') ? 'DESC' : 'ASC');

$keywords_param = !empty($keywords) ? '&amp;keywords=' . urlencode(htmlspecialchars_decode($keywords)) : '';

// Grab log data

{

$data = array();

foreach ($checks as $check)

{

if (isset($row[$check]) && $row[$check])

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

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

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

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

)

);

function main($id, $mode)

{

global $phpbb_dispatcher;

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

{

case 'lock':

case 'unlock':

{

trigger_error('NO_TOPIC_SELECTED');

}

case 'lock_post':

case 'unlock_post':

{

trigger_error('NO_POST_SELECTED');

}

case 'make_global':

case 'make_normal':

{

trigger_error('NO_TOPIC_SELECTED');

}

case 'move':

$user->add_lang('viewtopic');

{

trigger_error('NO_TOPIC_SELECTED');

}

case 'fork':

$user->add_lang('viewtopic');

{

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');

}

* @var string action Topic quick moderation action name

* @var bool quickmod Flag indicating whether MCP is in quick moderation mode

* @since 3.1.0-a4

*/

$vars = array('action', 'quickmod');

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

$user->add_lang('viewforum');

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

{

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

return;

break;

default:

trigger_error('NO_MODE', E_USER_ERROR);

break;

}

*/

function lock_unlock($action, $ids)

{

if ($action == 'lock' || $action == 'unlock')

{

}

unset($orig_ids);

$redirect = reapply_sid($redirect);

$s_hidden_fields = build_hidden_fields(array(

'action' => $action,

'redirect' => $redirect)

);

if (confirm_box(true))

{

foreach ($data as $id => $row)

{

}

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;

break;

case 'make_sticky':

$new_topic_type = POST_STICKY;

$check_acl = 'f_sticky';

break;

default:

$new_topic_type = POST_NORMAL;

$check_acl = false;

break;

}

return;

}

$redirect = reapply_sid($redirect);

$s_hidden_fields = array(

'action' => $action,

'redirect' => $redirect,

);

if (confirm_box(true))

{

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

$db->sql_query($sql);

{

// Delete topic shadows for global announcements

$sql = 'DELETE FROM ' . TOPICS_TABLE . '

$db->sql_query($sql);

}

{

$data = phpbb_get_topic_data($topic_ids);

foreach ($data as $topic_id => $row)

{

}

}

*/

function mcp_move_topic($topic_ids)

{

global $phpEx, $phpbb_root_path;

// Here we limit the operation to one forum only

return;

}

$additional_msg = $success_msg = '';

$s_hidden_fields = build_hidden_fields(array(

{

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

{

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

}

'poll_last_vote' => (int) $row['poll_last_vote']

);

$db->sql_query('INSERT INTO ' . TOPICS_TABLE . $db->sql_build_array('INSERT', $shadow));

// Shadow topics only count on new "topics" and not posts... a shadow topic alone has 0 posts

$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 = reapply_sid($redirect);

if (!$success_msg)

*/

function mcp_restore_topic($topic_ids)

{

if (!phpbb_check_ids($topic_ids, TOPICS_TABLE, 'topic_id', array('m_approve')))

{

if (confirm_box(true))

{

$data = phpbb_get_topic_data($topic_ids);

$phpbb_content_visibility = $phpbb_container->get('content.visibility');

foreach ($data as $topic_id => $row)

{

$return = $phpbb_content_visibility->set_topic_visibility(ITEM_APPROVED, $topic_id, $row['forum_id'], $user->data['user_id'], time(), '');

if (!empty($return))

{

}

}

}

else

{

}

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

*/

function mcp_delete_topic($topic_ids, $is_soft = false, $soft_delete_reason = '', $action = 'delete_topic')

{

$check_permission = ($is_soft) ? 'm_softdelete' : 'm_delete';

if (!phpbb_check_ids($topic_ids, TOPICS_TABLE, 'topic_id', array($check_permission)))

if (confirm_box(true))

{

$data = phpbb_get_topic_data($topic_ids);

{

if ($row['topic_moved_id'])

{

}

else

{

// Only soft delete non-shadow topics

if ($is_soft)

{

$phpbb_content_visibility = $phpbb_container->get('content.visibility');

$return = $phpbb_content_visibility->set_topic_visibility(ITEM_DELETED, $topic_id, $row['forum_id'], $user->data['user_id'], time(), $soft_delete_reason);

if (!empty($return))

{

}

}

else

{

}

}

}

if (!$is_soft)

{

}

}

else

}

$template->assign_vars(array(

));

if ($only_softdeleted)

{

$l_confirm .= '_PERMANENTLY';

*/

function mcp_delete_post($post_ids, $is_soft = false, $soft_delete_reason = '', $action = 'delete_post')

{

$check_permission = ($is_soft) ? 'm_softdelete' : 'm_delete';

if (!phpbb_check_ids($post_ids, POSTS_TABLE, 'post_id', array($check_permission)))

$approve_log[] = array(

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

'topic_id' => $post_data['topic_id'],

'post_subject' => $post_data['post_subject'],

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

'post_username' => $post_data['post_username'],

);

}

$phpbb_content_visibility = $phpbb_container->get('content.visibility');

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

{

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

{

$post_username = ($row['poster_id'] == ANONYMOUS && !empty($row['post_username'])) ? $row['post_username'] : $row['username'];

}

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

{

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

}

$db->sql_freeresult($result);

$post_data = phpbb_get_post_data($post_ids);

foreach ($post_data as $id => $row)

{

$post_username = ($row['poster_id'] == ANONYMOUS && !empty($row['post_username'])) ? $row['post_username'] : $row['username'];

}

// Now delete the posts, topics and forums are automatically resync'ed

}

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

{

if ($deleted_topics)

{

}

$template->assign_vars(array(

));

if ($only_softdeleted)

{

$l_confirm .= '_PERMANENTLY';

function mcp_fork_topic($topic_ids)

{

global $auth, $user, $db, $template, $config;

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

{

return;

}

$additional_msg = $success_msg = '';

$counter = array();

{

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

}

}

$error = false;

$search_mode = 'post';

if ($error)

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

);

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

$new_topic_id = $db->sql_nextid();

$new_topic_id_list[$topic_id] = $new_topic_id;

if ($topic_row['poll_start'])

{

$sql = 'SELECT *

FROM ' . POLL_OPTIONS_TABLE . "

WHERE topic_id = $topic_id";

}

$db->sql_freeresult($result);

{

continue;

}

}

$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);

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

{

}

}

else

{

'ADDITIONAL_MSG' => $additional_msg)

);

}

$redirect = reapply_sid($redirect);

if (!$success_msg)

function main($id, $mode)

{

if (is_array($action))

{

*/

function mcp_notes_user_view($action)

{

global $template, $db, $user, $auth, $phpbb_container;

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

add_form_key('mcp_notes');

$deletemark = ($action == 'del_marked') ? true : false;

$deleteall = ($action == 'del_all') ? true : false;

// Handle any actions

if (($deletemark || $deleteall) && $auth->acl_get('a_clearlogs'))

$where_sql";

$db->sql_query($sql);

$msg = ($deletemark) ? 'MARKED_NOTES_DELETED' : 'ALL_NOTES_DELETED';

}

{

if (check_form_key('mcp_notes'))

{

$msg = $user->lang['USER_FEEDBACK_ADDED'];

}

else

$sql_where = ($st) ? (time() - ($st * 86400)) : 0;

$sql_sort = $sort_by_sql[$sk] . ' ' . (($sd == 'd') ? 'DESC' : 'ASC');

$keywords_param = !empty($keywords) ? '&amp;keywords=' . urlencode(htmlspecialchars_decode($keywords)) : '';

$log_data = array();

function main($id, $mode)

{

global $config, $phpbb_root_path, $phpEx, $action, $phpbb_container;

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

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

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

$this->page_title = 'MCP_PM_REPORTS';

case 'delete':

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

{

trigger_error('NO_REPORT_SELECTED');

}

$user->add_lang(array('posting', 'viewforum', 'viewtopic', 'ucp'));

$sql = 'SELECT r.pm_id, r.user_id, r.report_id, r.report_closed, report_time, r.report_text, rr.reason_title, rr.reason_description, u.username, u.username_clean, u.user_colour

FROM ' . REPORTS_TABLE . ' r, ' . REPORTS_REASONS_TABLE . ' rr, ' . USERS_TABLE . ' u

trigger_error('NO_REPORT');

}

$phpbb_notifications = $phpbb_container->get('notification_manager');

$pm_id = $report['pm_id'];

$report_id = $report['report_id'];

$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);

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

'POST_DATE' => $user->format_date($pm_info['message_time']),

'POST_IP' => $pm_info['author_ip'],

'POST_ID' => $pm_info['msg_id'],

'U_LOOKUP_IP' => ($auth->acl_getf_global('m_info')) ? $this->u_action . '&amp;r=' . $report_id . '&amp;pm=' . $pm_id . '&amp;lookup=' . $pm_info['author_ip'] . '#ip' : '',

}

$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);

*/

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

{

$user->add_lang('posting');

// Get post data

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

add_form_key('mcp_post_details');

{

trigger_error('POST_NOT_EXIST');

}

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

{

$template->assign_vars(array(

'RETURN_POST' => sprintf($user->lang['RETURN_POST'], '<a href="' . append_sid("{$phpbb_root_path}mcp.$phpEx", "i=$id&amp;mode=$mode&amp;p=$post_id") . '">', '</a>'),

if ($action == 'chgposter')

{

$sql_where = "username_clean = '" . $db->sql_escape(utf8_clean_string($username)) . "'";

}

else

{

$sql_where = 'user_id = ' . $new_user_id;

}

}

break;

}

// Set some vars

$users_ary = $usernames_ary = array();

$attachments = $extensions = array();

$post_id = $post_info['post_id'];

// Get topic tracking info

if ($config['load_db_lastread'])

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

{

$sql = 'SELECT *

FROM ' . ATTACHMENTS_TABLE . '

WHERE post_msg_id = ' . $post_id . '

}

$db->sql_freeresult($result);

{

$user->add_lang('viewtopic');

$update_count = array();

$l_deleted_by = '';

}

'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

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

'POST_SUBJECT' => $post_info['post_subject'],

'POST_DATE' => $user->format_date($post_info['post_time']),

'POST_IP' => $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 User Notes

$log_data = array();

// Get IP

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

{

if ($rdns_ip_num != 'all')

{

);

}

// Get other users who've posted under this IP

$sql = 'SELECT poster_id, COUNT(poster_id) as postings

FROM ' . POSTS_TABLE . "

WHERE poster_ip = '" . $db->sql_escape($post_info['poster_ip']) . "'

GROUP BY poster_id

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

{

{

}

}

{

// Get the usernames

$sql = 'SELECT user_id, username

// A compound index on poster_id, poster_ip (posts table) would help speed up this query a lot,

// but the extra size is only valuable if there are persons having more than a thousands posts.

// This is better left to the really really big forums.

$sql = 'SELECT poster_ip, COUNT(poster_ip) AS postings

FROM ' . POSTS_TABLE . '

WHERE poster_id = ' . $post_info['poster_id'] . "

GROUP BY poster_ip

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

{

$hostname = (($rdns_ip_num == $row['poster_ip'] || $rdns_ip_num == 'all') && $row['poster_ip']) ? @gethostbyaddr($row['poster_ip']) : '';

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

}

$db->sql_freeresult($result);

$user_select = '';

{

ksort($usernames_ary);

}

/**

* Change a post's poster

*/

function change_poster(&$post_info, $userdata)

{

if (empty($userdata) || $userdata['user_id'] == $post_info['user_id'])

{

{

// We do some additional checks in the module to ensure it can actually be utilised

$error = false;

if (!$error && method_exists($search, 'destroy_cache'))

{

$from_username = $post_info['username'];

$to_username = $userdata['username'];

// Renew post info

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

{

trigger_error('POST_NOT_EXIST');

}

$post_info = $post_info[$post_id];

// Now add log entry

}

public function main($id, $mode)

{

global $config, $phpbb_root_path, $phpEx, $action, $phpbb_container;

global $phpbb_dispatcher;

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

$this->page_title = 'MCP_QUEUE';

case 'delete':

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

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

if (!empty($post_id_list))

{

global $phpbb_root_path, $phpEx;

include($phpbb_root_path . 'includes/mcp/mcp_main.' . $phpEx);

}

}

else if (!empty($topic_id_list))

{

global $phpbb_root_path, $phpEx;

include($phpbb_root_path . 'includes/mcp/mcp_main.' . $phpEx);

}

}

else

{

if (!empty($topic_id_list) && $mode == 'deleted_topics')

{

{

global $phpbb_root_path, $phpEx;

include($phpbb_root_path . 'includes/mcp/mcp_main.' . $phpEx);

$user->add_lang(array('posting', 'viewtopic'));

$phpbb_notifications = $phpbb_container->get('notification_manager');

if ($topic_id)

{

$post_id = (int) $topic_info[$topic_id]['topic_first_post_id'];

}

else

{

}

}

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

{

trigger_error('NO_POST_SELECTED');

}

));

}

// Get topic tracking info

if ($config['load_db_lastread'])

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

{

$sql = 'SELECT *

FROM ' . ATTACHMENTS_TABLE . '

WHERE post_msg_id = ' . $post_id . '

}

$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_VIEWIP' => $auth->acl_get('m_info', $post_info['forum_id']),

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

'S_POST_UNAPPROVED' => $post_info['post_visibility'] == ITEM_UNAPPROVED || $post_info['post_visibility'] == ITEM_REAPPROVE,

'POST_SUBJECT' => $post_info['post_subject'],

'POST_DATE' => $user->format_date($post_info['post_time']),

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

'POST_ID' => $post_info['post_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_id = $request->variable('t', 0);

$forum_info = array();

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

if ($topic_id)

{

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

}

$forum_list = $forum_id;

}

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

foreach ($forum_list_approve as $row)

{

}

$sort_days = $total = 0;

$sort_by_sql = $sort_order_sql = array();

phpbb_mcp_sorting($mode, $sort_days, $sort_key, $sort_dir, $sort_by_sql, $sort_order_sql, $total, $forum_id, $topic_id);

$limit_time_sql = ($sort_days) ? 'AND t.topic_last_post_time >= ' . (time() - ($sort_days * 86400)) : '';

$forum_names = array();

}

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

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

}

unset($rowset, $forum_names);

*/

static public function approve_posts($action, $post_id_list, $id, $mode)

{

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

{

trigger_error('NOT_AUTHORISED');

}

$redirect = $request->variable('redirect', build_url(array('quickmod')));

$redirect = reapply_sid($redirect);

$approve_log = array();

$num_topics = 0;

$approve_log[] = array(

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

'topic_id' => $post_data['topic_id'],

'post_subject' => $post_data['post_subject'],

);

}

$phpbb_content_visibility = $phpbb_container->get('content.visibility');

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

{

foreach ($approve_log as $log_data)

{

}

// Only send out the mails, when the posts are being approved

if ($action == 'approve')

{

$phpbb_notifications = $phpbb_container->get('notification_manager');

// Handle notifications

$phpbb_notifications->add_notifications(array('notification.type.quote'), $post_data);

$phpbb_notifications->delete_notifications('notification.type.post_in_queue', $post_id);

'notification.type.quote',

'notification.type.bookmark',

'notification.type.post',

}

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');

}

*/

static public function approve_topics($action, $topic_id_list, $id, $mode)

{

global $phpEx, $phpbb_root_path, $request, $phpbb_container, $phpbb_dispatcher;

if (!phpbb_check_ids($topic_id_list, TOPICS_TABLE, 'topic_id', array('m_approve')))

{

trigger_error('NOT_AUTHORISED');

}

{

$notify_poster = ($action == 'approve' && isset($_REQUEST['notify_poster'])) ? true : false;

$phpbb_content_visibility = $phpbb_container->get('content.visibility');

$first_post_ids = array();

);

}

{

}

foreach ($approve_log as $log_data)

{

}

// Only send out the mails, when the posts are being approved

$db->sql_freeresult($result);

// Handle notifications

$phpbb_notifications = $phpbb_container->get('notification_manager');

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

), $topic_data);

}

if ($notify_poster)

{

$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);

*/

static public function disapprove_posts($post_id_list, $id, $mode)

{

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

{

trigger_error('NOT_AUTHORISED');

}

$redirect = reapply_sid($redirect);

$reason = $request->variable('reason', '', true);

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

$s_hidden_fields = build_hidden_fields(array(

'i' => $id,

if (confirm_box(true))

{

$topic_posts_unapproved = $post_disapprove_list = $topic_information = array();

// Build a list of posts to be disapproved and get the related topics real replies count

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

{

$post_disapprove_list[$post_id] = $post_data['topic_id'];

if (!isset($topic_posts_unapproved[$post_data['topic_id']]))

{

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

}

// Now we build the log array

foreach ($post_disapprove_list as $post_id => $topic_id)

{

}

// 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'))

{

if ($is_disapproving)

{

$l_log_message = ($log_data['type'] == 'topic') ? 'LOG_TOPIC_DISAPPROVED' : 'LOG_POST_DISAPPROVED';

}

else

{

$l_log_message = ($log_data['type'] == 'topic') ? 'LOG_DELETE_TOPIC' : 'LOG_DELETE_POST';

}

}

}

$phpbb_notifications = $phpbb_container->get('notification_manager');

$lang_reasons = array();

continue;

}

if (isset($disapprove_reason_lang))

{

// Okay we need to get the reason from the posters language

}

else

{

$show_notify = false;

foreach ($post_info as $post_data)

$confirm_template = 'mcp_approve.html';

if ($is_disapproving)

{

}

else

{

$l_confirm_msg = 'DELETE_POST_PERMANENTLY';

$confirm_template = 'confirm_delete_body.html';

}

$template->assign_vars(array(

'S_NOTIFY_POSTER' => $show_notify,

function main($id, $mode)

{

global $config, $phpbb_root_path, $phpEx, $action, $phpbb_container, $phpbb_dispatcher;

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

$this->page_title = 'MCP_REPORTS';

case 'delete':

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

{

trigger_error('NO_REPORT_SELECTED');

}

$user->add_lang(array('posting', 'viewforum', 'viewtopic'));

// closed reports are accessed by report id

AND rr.reason_id = r.reason_id

AND r.user_id = u.user_id

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

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

$db->sql_freeresult($result);

if (!$report)

{

trigger_error('NO_REPORT');

}

$phpbb_notifications = $phpbb_container->get('notification_manager');

if (!$report_id && $report['report_closed'])

{

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

{

trigger_error('NO_REPORT_SELECTED');

}

));

}

// Get topic tracking info

if ($config['load_db_lastread'])

{

}

$db->sql_freeresult($result);

{

$update_count = array();

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

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

'POST_DATE' => $user->format_date($post_info['post_time']),

'POST_IP' => $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' : '',

case 'reports':

case 'reports_closed':

$forum_info = array();

$forum_list_reports = get_forum_list('m_report', false, true);

{

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

{

trigger_error('TOPIC_NOT_EXIST');

}

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

}

{

trigger_error('NOT_MODERATOR');

}

$sql = 'SELECT SUM(forum_topics_approved) as sum_forum_topics

FROM ' . FORUMS_TABLE . '

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

{

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

{

trigger_error('NOT_MODERATOR');

}

$forum_list = array($forum_id);

}

$forum_list[] = 0;

$forum_data = array();

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

foreach ($forum_list_reports as $row)

$sort_by_sql = $sort_order_sql = array();

phpbb_mcp_sorting($mode, $sort_days, $sort_key, $sort_dir, $sort_by_sql, $sort_order_sql, $total, $forum_id, $topic_id);

$limit_time_sql = ($sort_days) ? 'AND r.report_time >= ' . (time() - ($sort_days * 86400)) : '';

if ($mode == 'reports')

}

$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

ORDER BY ' . $sort_order_sql;

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

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

{

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

*/

function close_report($report_id_list, $mode, $action, $pm = false)

{

global $phpEx, $phpbb_root_path, $phpbb_container;

$pm_where = ($pm) ? ' AND r.post_id = 0 ' : ' AND r.pm_id = 0 ';

{

$post_id_list[] = $row[$id_column];

}

$post_id_list = array_unique($post_id_list);

if ($pm)

{

if (!$auth->acl_getf_global('m_report'))

{

trigger_error('NOT_AUTHORISED');

}

}

{

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

{

trigger_error('NOT_AUTHORISED');

}

}

if ($action == 'delete' && strpos($user->data['session_page'], 'mode=report_details') !== false)

{

}

else if ($action == 'delete' && strpos($user->data['session_page'], 'mode=pm_report_details') !== false)

{

}

{

}

else

{

}

$success_msg = '';

$forum_ids = array();

}

$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

}

unset($close_report_posts, $close_report_topics);

$phpbb_notifications = $phpbb_container->get('notification_manager');

foreach ($reports as $report)

{

if ($pm)

{

$phpbb_notifications->delete_notifications('notification.type.report_pm', $report['pm_id']);

}

else

{

$phpbb_notifications->delete_notifications('notification.type.report_post', $report['post_id']);

}

}

// Notify reporters

{

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

{

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

}

else

{

}

$redirect = reapply_sid($redirect);

if (!$success_msg)

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 />';

}

*/

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

{

$url = append_sid("{$phpbb_root_path}mcp.$phpEx?" . phpbb_extra_url());

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

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

{

trigger_error('TOPIC_NOT_EXIST');

}

$topic_info = $topic_info[$topic_id];

// Set up some vars

$sort = isset($_POST['sort']) ? true : false;

// Resync Topic?

if ($action == 'resync')

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

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

{

trigger_error('NO_POST_SELECTED');

}

$sort_by_sql = $sort_order_sql = array();

phpbb_mcp_sorting('viewtopic', $sort_days, $sort_key, $sort_dir, $sort_by_sql, $sort_order_sql, $total, $topic_info['forum_id'], $topic_id, $where_sql);

$phpbb_content_visibility = $phpbb_container->get('content.visibility');

if ($total == -1)

{

$total = $phpbb_content_visibility->get_count('topic_posts', $topic_info, $topic_info['forum_id']);

}

if ($posts_per_page == 0)

{

$posts_per_page = $total;

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

$rowset = $post_id_list = array();

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

{

$rowset[] = $row;

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

}

$db->sql_freeresult($result);

// Get topic tracking info

if ($config['load_db_lastread'])

{

$has_unapproved_posts = $has_deleted_posts = false;

// Grab extensions

{

// Get attachments...

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

{

}

}

foreach ($rowset as $i => $row)

{

$message = $row['post_text'];

'U_MCP_REPORT' => ($auth->acl_get('m_report', $topic_info['forum_id'])) ? append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=reports&amp;mode=report_details&amp;f=' . $topic_info['forum_id'] . '&amp;p=' . $row['post_id']) : '',

);

/**

* Event to modify the template data block for topic reviews in the MCP

*

* @var int current_row_number Number of the post on this page

* @var array post_row Template block array of the current post

* @var array row Array with original post and user data

* @since 3.1.4-RC1

*/

$vars = array(

'current_row_number',

'post_row',

'row',

);

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

{

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

{

$to_topic_id = 0;

}

*/

function split_topic($action, $topic_id, $to_forum_id, $subject)

{

{

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

return;

}

$s_hidden_fields = build_hidden_fields(array(

'i' => 'main',

'redirect' => $redirect,

'subject' => $subject,

'to_forum_id' => $to_forum_id,

);

if (confirm_box(true))

{

$db->sql_freeresult($result);

}

{

trigger_error('NO_POST_SELECTED');

}

$sql_ary = array(

'forum_id' => $to_forum_id,

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

$topic_info = $topic_info[$topic_id];

// Change topic title of first post

$sql = 'UPDATE ' . POSTS_TABLE . "

WHERE post_id = {$post_id_list[0]}";

$db->sql_query($sql);

// Copy topic subscriptions to new topic

$sql = 'SELECT user_id, notify_status

FROM ' . TOPICS_WATCH_TABLE . '

}

$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);

}

$success_msg = 'TOPIC_SPLIT_SUCCESS';

// Update forum statistics

// Link back to both topics

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

$redirect = reapply_sid($redirect);

meta_refresh(3, $redirect);

*/

function merge_posts($topic_id, $to_topic_id)

{

if (!$to_topic_id)

{

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

{

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

return;

$topic_data = $topic_data[$to_topic_id];

{

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

return;

return;

}

$s_hidden_fields = build_hidden_fields(array(

'i' => 'main',

'redirect' => $redirect,

't' => $topic_id)

);

if (confirm_box(true))

{

$to_forum_id = $topic_data['forum_id'];

move_posts($post_id_list, $to_topic_id, false);

// Message and return links

$success_msg = 'POSTS_MERGED_SUCCESS';

// Link to the new topic

$return_link .= (($return_link) ? '<br /><br />' : '') . sprintf($user->lang['RETURN_NEW_TOPIC'], '<a href="' . append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . $to_forum_id . '&amp;t=' . $to_topic_id) . '">', '</a>');

$redirect = reapply_sid($redirect);

meta_refresh(3, $redirect);

trigger_error($user->lang[$success_msg] . '<br /><br />' . $return_link);

}

function main($id, $mode)

{

if (is_array($action))

{

*/

function mcp_warn_front_view()

{

$template->assign_vars(array(

'U_FIND_USERNAME' => append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=searchuser&amp;form=mcp&amp;field=username&amp;select_single=true'),

function mcp_warn_list_view($action)

{

global $phpEx, $phpbb_root_path, $config, $phpbb_container;

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

$limit_days = array(0 => $user->lang['ALL_ENTRIES'], 1 => $user->lang['1_DAY'], 7 => $user->lang['7_DAYS'], 14 => $user->lang['2_WEEKS'], 30 => $user->lang['1_MONTH'], 90 => $user->lang['3_MONTHS'], 180 => $user->lang['6_MONTHS'], 365 => $user->lang['1_YEAR']);

$sort_by_text = array('a' => $user->lang['SORT_USERNAME'], 'b' => $user->lang['SORT_DATE'], 'c' => $user->lang['SORT_WARNINGS']);

*/

function mcp_warn_post_view($action)

{

$notify = (isset($_REQUEST['notify_user'])) ? true : false;

$sql = 'SELECT u.*, p.*

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

*/

function mcp_warn_user_view($action)

{

$notify = (isset($_REQUEST['notify_user'])) ? true : false;

$sql_where = ($user_id) ? "user_id = $user_id" : "username_clean = '" . $db->sql_escape(utf8_clean_string($username)) . "'";

*/

function add_warning($user_row, $warning, $send_pm = true, $post_id = 0)

{

if ($send_pm)

{

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

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

$message_parser = new parse_message();

$message_parser->parse(true, true, true, false, false, true, true);

$pm_data = array(

'address_list' => array('u' => array($user_row['user_id'] => 'to')),

);

}

$sql_ary = array(

'user_id' => $user_row['user_id'],

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

$db->sql_freeresult($result);

}