<?php

/**

*

*

*/

class mcp_ban_info

{

function module()

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

<?php

/**

*

*

*/

class mcp_logs_info

{

function module()

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

<?php

/**

*

*

*/

class mcp_main_info

{

function module()

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

<?php

/**

*

*

*/

class mcp_notes_info

{

function module()

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

<?php

/**

*

*

*/

class mcp_pm_reports_info

{

function module()

return array(

'filename' => 'mcp_pm_reports',

'title' => 'MCP_PM_REPORTS',

'modes' => array(

),

);

}

<?php

/**

*

*

*/

class mcp_queue_info

{

function module()

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

<?php

/**

*

*

*/

class mcp_reports_info

{

function module()

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

<?php

/**

*

*

*/

class mcp_warn_info

{

function module()

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

<?php

/**

*

*

*/

exit;

}

class mcp_ban

{

var $u_action;

function main($id, $mode)

{

global $phpbb_root_path, $phpEx;

include($phpbb_root_path . 'includes/functions_user.' . $phpEx);

// Include the admin banning interface...

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

$user->add_lang(array('acp/ban', 'acp/users'));

$this->tpl_name = 'mcp_ban';

// Ban submitted?

if ($bansubmit)

{

// Grab the list of entries

if ($ban)

{

if (confirm_box(true))

{

trigger_error($user->lang['BAN_UPDATE_SUCCESSFUL'] . '<br /><br /><a href="' . $this->u_action . '">&laquo; ' . $user->lang['BACK_TO_PREV'] . '</a>');

}

else

{

'mode' => $mode,

'ban' => $ban,

'bansubmit' => true,

'banexclude' => $ban_exclude,

'banreason' => $ban_reason,

}

}

}

else if ($unbansubmit)

{

if ($ban)

{

}

// As a "service" we will check if any post id is specified and populate the username of the poster id if given

if ($user_id && $user_id <> ANONYMOUS)

{

case 'user':

$pre_fill = (string) $db->sql_fetchfield('username');

break;

case 'ip':

$pre_fill = (string) $db->sql_fetchfield('user_ip');

break;

}

else if ($post_id)

{

if (sizeof($post_info) && !empty($post_info[$post_id]))

{

<?php

/**

*

*

*/

// 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) ? "&amp;f=$forum_id" : '';

switch ($action)

{

case 'resync':

mcp_resync_topics($topic_ids);

break;

break;

}

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

$selected_ids = '';

$sort_days = $total = 0;

$sort_key = $sort_dir = '';

$sort_by_sql = $sort_order_sql = array();

$forum_topics = ($total == -1) ? $forum_info['forum_topics_approved'] : $total;

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

'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&amp;mode=forum_logs&amp;f=' . $forum_id) : '',

$read_tracking_join = $read_tracking_select = '';

}

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

$sql = 'SELECT t.topic_id

AND ' . $phpbb_content_visibility->get_visibility_sql('topic', $forum_id, 't.') . "

$limit_time_sql

ORDER BY t.topic_type DESC, $sort_order_sql";

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

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

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 . '&amp;i=queue&amp;mode=deleted_topics&amp;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') : '',

'DELETED_IMG' => ($topic_deleted) ? $user->img('icon_topic_deleted', 'POSTS_DELETED') : '',

'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

*/

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

{

if (!sizeof($topic_ids))

{

trigger_error('NO_TOPIC_SELECTED');

}

{

return;

}

// Log this action

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

{

}

$db->sql_freeresult($result);

$msg = (sizeof($topic_ids) == 1) ? $user->lang['TOPIC_RESYNC_SUCCESS'] : $user->lang['TOPICS_RESYNC_SUCCESS'];

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)

{

if (!sizeof($topic_ids))

{

return;

}

{

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

return;

}

$topic_data = $topic_data[$to_topic_id];

if (!sizeof($post_id_list) && sizeof($topic_ids))

{

return;

}

{

return;

}

$s_hidden_fields = build_hidden_fields(array(

'i' => 'main',

'redirect' => $redirect,

'topic_id_list' => $topic_ids)

);

if (confirm_box(true))

{

$to_forum_id = $topic_data['forum_id'];

// Message and return links

$success_msg = 'POSTS_MERGED_SUCCESS';

// Update the bookmarks table.

phpbb_update_rows_avoiding_duplicates($db, BOOKMARKS_TABLE, 'topic_id', $topic_ids, $to_topic_id);

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

<?php

/**

*

*

*/

*/

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

$sql = 'SELECT post_id

FROM ' . POSTS_TABLE . '

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

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

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

}

}

if ($total)

{

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

WHERE ' . $db->sql_in_set('p.post_id', $post_list) . '

AND t.topic_id = p.topic_id

AND p.poster_id = u.user_id

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

while ($row = $db->sql_fetchrow($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);

AND p.poster_id = u2.user_id

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

);

$sql = $db->sql_build_query('SELECT', $sql_ary);

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

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

));

}

}

$template->assign_vars(array(

}

// Latest 5 reported PMs

{

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

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

$pm_by_id[(int) $row['msg_id']] = $row;

$pm_list[] = (int) $row['msg_id'];

}

$address_list = get_recipient_strings($pm_by_id);

<?php

/**

*

*

*/

/**

* mcp_logs

* Handling warning the users

*/

class mcp_logs

{

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

{

break;

case 'topic_logs':

$sql = 'SELECT forum_id

FROM ' . TOPICS_TABLE . '

{

if ($deletemark && sizeof($marked))

{

}

else if ($deleteall)

{

if ($mode == 'topic_logs')

{

}

}

}

else

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

<?php

/**

*

*

*/

/**

* mcp_main

* Handling mcp actions

*/

class mcp_main

{

function main($id, $mode)

{

global $phpbb_dispatcher;

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

{

case 'lock':

case 'unlock':

if (!sizeof($topic_ids))

{

case 'lock_post':

case 'unlock_post':

if (!sizeof($post_ids))

{

case 'make_global':

case 'make_normal':

if (!sizeof($topic_ids))

{

case 'move':

$user->add_lang('viewtopic');

if (!sizeof($topic_ids))

{

case 'fork':

$user->add_lang('viewtopic');

if (!sizeof($topic_ids))

{

trigger_error('NO_TOPIC_SELECTED');

}

break;

case 'delete_post':

trigger_error('NO_POST_SELECTED');

}

break;

case 'restore_topic':

* This event allows you to handle custom quickmod options

*

* @event core.modify_quickmod_actions

* @since 3.1.0-a4

*/

break;

}

$user->add_lang('viewforum');

if (!sizeof($forum_info))

{

break;

default:

trigger_error('NO_MODE', E_USER_ERROR);

break;

}

*/

function lock_unlock($action, $ids)

{

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

{

$orig_ids = $ids;

{

// Make sure that for f_user_lock only the lock action is triggered.

if ($action != 'lock')

$ids = $orig_ids;

{

return;

}

}

unset($orig_ids);

$redirect = reapply_sid($redirect);

$s_hidden_fields = build_hidden_fields(array(

'action' => $action,

'redirect' => $redirect)

);

if (confirm_box(true))

{

WHERE ' . $db->sql_in_set($sql_id, $ids);

$db->sql_query($sql);

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

{

}

$success_msg = $l_prefix . ((sizeof($ids) == 1) ? '' : 'S') . '_' . (($action == 'lock' || $action == 'lock_post') ? 'LOCKED' : 'UNLOCKED') . '_SUCCESS';

meta_refresh(2, $redirect);

*/

function change_topic_type($action, $topic_ids)

{

switch ($action)

{

case 'make_global':

$new_topic_type = POST_GLOBAL;

$l_new_type = (sizeof($topic_ids) == 1) ? 'MCP_MAKE_GLOBAL' : 'MCP_MAKE_GLOBALS';

break;

break;

}

if ($forum_id === false)

{

return;

}

$redirect = reapply_sid($redirect);

$s_hidden_fields = array(

'action' => $action,

'redirect' => $redirect,

);

if (confirm_box(true))

{

if (sizeof($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

if ($forum_id === false)

{

return;

}

$additional_msg = $success_msg = '';

$s_hidden_fields = build_hidden_fields(array(

if ($to_forum_id)

{

if (!sizeof($forum_data))

{

if (confirm_box(true))

{

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

$forum_sync_data = array();

{

$topics_moved++;

}

{

$topics_moved_unapproved++;

}

{

$topics_moved_softdeleted++;

}

$forum_ids = array($to_forum_id);

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

{

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

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

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

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

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

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

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

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

'topic_moved_id' => (int) $row['topic_id'],

confirm_box(false, 'MOVE_TOPIC' . ((sizeof($topic_ids) == 1) ? '' : 'S'), $s_hidden_fields, 'mcp_move.html');

}

$redirect = reapply_sid($redirect);

if (!$success_msg)

*/

function mcp_restore_topic($topic_ids)

{

{

return;

}

{

$success_msg = (sizeof($topic_ids) == 1) ? 'TOPIC_RESTORED_SUCCESS' : 'TOPICS_RESTORED_SUCCESS';

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

{

}

}

}

*/

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

{

{

return;

}

{

$success_msg = (sizeof($topic_ids) == 1) ? 'TOPIC_DELETED_SUCCESS' : 'TOPICS_DELETED_SUCCESS';

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

{

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

$user->add_lang('posting');

$only_softdeleted = false;

{

// If there are only soft deleted topics, we display a message why the option is not available

$sql = 'SELECT topic_id

}

$template->assign_vars(array(

'S_SOFTDELETED' => $only_softdeleted,

'S_TOPIC_MODE' => true,

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

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

));

$l_confirm = (sizeof($topic_ids) == 1) ? 'DELETE_TOPIC' : 'DELETE_TOPICS';

$l_confirm .= '_PERMANENTLY';

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

}

{

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

}

*/

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

{

{

return;

}

if (confirm_box(true) && $is_soft)

{

$topic_info = $approve_log = array();

);

}

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

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

{

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

$affected_topics = sizeof($topic_id_list);

$db->sql_freeresult($result);

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

'S_SOFTDELETED' => $only_softdeleted,

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

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

));

$l_confirm = (sizeof($post_ids) == 1) ? 'DELETE_POST' : 'DELETE_POSTS';

function mcp_fork_topic($topic_ids)

{

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

{

return;

}

$additional_msg = $success_msg = '';

$s_hidden_fields = build_hidden_fields(array(

'topic_id_list' => $topic_ids,

if ($to_forum_id)

{

if (!sizeof($topic_ids))

{

if (confirm_box(true))

{

$total_topics = $total_topics_unapproved = $total_topics_softdeleted = 0;

$total_posts = $total_posts_unapproved = $total_posts_softdeleted = 0;

}

$error = false;

$search_mode = 'post';

if ($error)

$total_topics++;

break;

case ITEM_UNAPPROVED:

$total_topics_unapproved++;

break;

case ITEM_DELETED:

if ($topic_row['poll_start'])

{

$sql = 'SELECT *

FROM ' . POLL_OPTIONS_TABLE . "

WHERE topic_id = $topic_id";

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

}

}

$sql = 'SELECT *

FROM ' . POSTS_TABLE . "

WHERE topic_id = $topic_id

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

$post_rows = array();

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

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

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

);

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

$new_post_id = $db->sql_nextid();

$total_posts++;

break;

case ITEM_UNAPPROVED:

$total_posts_unapproved++;

break;

case ITEM_DELETED:

WHERE forum_id = ' . $to_forum_id;

$db->sql_query($sql);

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)

{

}

$success_msg = (sizeof($topic_ids) == 1) ? 'TOPIC_FORKED_SUCCESS' : 'TOPICS_FORKED_SUCCESS';

confirm_box(false, 'FORK_TOPIC' . ((sizeof($topic_ids) == 1) ? '' : 'S'), $s_hidden_fields, 'mcp_move.html');

}

$redirect = reapply_sid($redirect);

if (!$success_msg)

<?php

/**

*

*

*/

/**

* mcp_notes

* Displays notes about a user

*/

class mcp_notes

{

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

}

// Generate the appropriate user information for the user we are looking at

$rank_title = $rank_img = '';

$avatar_img = phpbb_get_user_avatar($userrow);

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

<?php

/**

*

*

*/

/**

* mcp_reports

* Handling the reports queue

*/

class mcp_pm_reports

{

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

if (!sizeof($report_id_list))

{

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

if (!sizeof($pm_info))

{

'U_MCP_USER_NOTES' => append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=notes&amp;mode=user_notes&amp;u=' . $pm_info['author_id']),

'U_MCP_WARN_REPORTER' => ($auth->acl_get('m_warn')) ? append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=warn&amp;mode=warn_user&amp;u=' . $report['user_id']) : '',

'U_MCP_WARN_USER' => ($auth->acl_get('m_warn')) ? append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=warn&amp;mode=warn_user&amp;u=' . $pm_info['author_id']) : '',

'EDIT_IMG' => $user->img('icon_post_edit', $user->lang['EDIT_POST']),

'MINI_POST_IMG' => $user->img('icon_post_target', 'POST'),

'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' : '',

$sort_days = $total = 0;

$sort_key = $sort_dir = '';

$sort_by_sql = $sort_order_sql = array();

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

$template->assign_vars(array(

'L_EXPLAIN' => ($mode == 'pm_reports') ? $user->lang['MCP_PM_REPORTS_OPEN_EXPLAIN'] : $user->lang['MCP_PM_REPORTS_CLOSED_EXPLAIN'],

'L_TITLE' => ($mode == 'pm_reports') ? $user->lang['MCP_PM_REPORTS_OPEN'] : $user->lang['MCP_PM_REPORTS_CLOSED'],

'S_PM' => true,

'S_MCP_ACTION' => $this->u_action,

'S_CLOSED' => ($mode == 'pm_reports_closed') ? true : false,

<?php

/**

*

*

*/

*/

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

{

$user->add_lang('posting');

// Get post data

add_form_key('mcp_post_details');

}

$post_info = $post_info[$post_id];

switch ($action)

{

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

{

include($phpbb_root_path . 'includes/functions_user.' . $phpEx);

$template->assign_vars(array(

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 . '

if (sizeof($attachments))

{

$update_count = array();

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

}

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

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

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

'S_POST_DELETED' => ($post_info['post_visibility'] == ITEM_DELETED) ? true : false,

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

'S_USER_NOTES' => true,

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

'REPORT_ID' => $row['report_id'],

'REASON_TITLE' => $row['reason_title'],

'REASON_DESC' => $row['reason_description'],

'USER_NOTIFY' => ($row['user_notify']) ? true : false,

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

'REPORT_TEXT' => bbcode_nl2br(trim($row['report_text'])),

// Get IP

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

{

if ($rdns_ip_num != 'all')

{

foreach ($users_ary as $user_id => $user_row)

{

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

'NUM_POSTS' => $user_row['postings'],

'L_POST_S' => ($user_row['postings'] == 1) ? $user->lang['POST'] : $user->lang['POSTS'],

'U_SEARCHPOSTS' => append_sid("{$phpbb_root_path}search.$phpEx", 'author_id=' . $user_id . '&amp;sr=topics'))

);

}

*/

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

if (!sizeof($post_info))

{

$post_info = $post_info[$post_id];

// Now add log entry

}

<?php

/**

*

*

*/

/**

* mcp_queue

* Handling the moderation queue

*/

class mcp_queue

{

public function main($id, $mode)

{

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

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

{

$sql = 'SELECT post_id

FROM ' . POSTS_TABLE . '

AND ' . $db->sql_in_set('topic_id', $topic_id_list);

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

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

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

if ($topic_id)

{

if (isset($topic_info[$topic_id]['topic_first_post_id']))

{

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

}

else

{

}

}

if (!sizeof($post_info))

{

));

}

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

$template->assign_vars(array(

'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_LOCKED' => $post_info['post_edit_locked'],

'S_USER_NOTES' => true,

'S_POST_DELETED' => ($post_info['post_visibility'] == ITEM_DELETED),

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

'RETURN_QUEUE' => sprintf($user->lang['RETURN_QUEUE'], '<a href="' . append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=queue' . (($topic_id) ? '&amp;mode=unapproved_topics' : '&amp;mode=unapproved_posts')) . '&amp;start=' . $start . '">', '</a>'),

'RETURN_POST' => sprintf($user->lang['RETURN_POST'], '<a href="' . $post_url . '">', '</a>'),

'RETURN_TOPIC_SIMPLE' => sprintf($user->lang['RETURN_TOPIC_SIMPLE'], '<a href="' . $topic_url . '">', '</a>'),

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

$m_perm = 'm_approve';

$is_topics = ($mode == 'unapproved_topics' || $mode == 'deleted_topics') ? true : false;

$is_restore = ($mode == 'deleted_posts' || $mode == 'deleted_topics') ? true : false;

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

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

$forum_info = array();

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

if ($topic_id)

{

if (!sizeof($topic_info))

{

}

else

{

if (!sizeof($forum_info))

{

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_key = $sort_dir = '';

$sort_by_sql = $sort_order_sql = array();

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

$forum_names = array();

$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

OR t.topic_delete_user = 0)

$limit_time_sql

ORDER BY $sort_order_sql";

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

$i = 0;

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

AND topic_delete_user <> 0

$limit_time_sql

ORDER BY $sort_order_sql";

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

$rowset = array();

*/

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

{

{

trigger_error('NOT_AUTHORISED');

}

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

$redirect = reapply_sid($redirect);

$approve_log = array();

$s_hidden_fields = build_hidden_fields(array(

'i' => $id,

'redirect' => $redirect,

));

if (confirm_box(true))

{

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

{

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

}

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

// A single topic approval may also happen here, so handle deleting the respective notification.

if (!$post_data['topic_posts_approved'])

{

}

), $post_data['post_id'], $user->data['user_id']);

// Notify Poster?

continue;

}

}

}

}

meta_refresh(3, $redirect);

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

{

foreach ($post_info as $post_data)

{

{

}

{

$show_notify = true;

}

}

}

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

));

}

redirect($redirect);

*/

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

{

{

trigger_error('NOT_AUTHORISED');

}

'redirect' => $redirect,

));

if (confirm_box(true))

{

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

'post_subject' => $topic_data['topic_title'],

'post_time' => $topic_data['topic_time'],

'poster_id' => $topic_data['topic_poster'],

));

if ($notify_poster)

{

}

}

}

meta_refresh(3, $redirect);

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

*/

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

{

{

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,

}

}

$is_disapproving = false;

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

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)

{

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

$topic_information[$topic_id]['topic_posts_softdeleted'] == 0 &&

$topic_information[$topic_id]['topic_posts_unapproved'] == $topic_posts_unapproved[$topic_id];

// Do we disapprove the whole topic? Remove potential notifications

if ($disapprove_all_posts_in_topic)

{

}

// Notify Poster?

continue;

}

if (isset($disapprove_reason_lang))

{

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

$post_data['disapprove_reason'] .= ($reason) ? "\n\n" . $reason : '';

}

if ($disapprove_all_posts_in_topic && $topic_information[$topic_id]['topic_posts_unapproved'] == 1)

{

// If there is only 1 post when disapproving the topic,

// we send the user a "disapprove topic" notification...

}

else

{

// ... otherwise there are multiple unapproved posts and

// all of them are disapproved as posts.

}

}

}

if ($num_disapproved_topics)

{

$success_msg = ($num_disapproved_topics == 1) ? 'TOPIC' : 'TOPICS';

$success_msg .= '_DELETED_SUCCESS';

}

meta_refresh(3, $redirect);

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

}

else

{

$show_notify = false;

foreach ($post_info as $post_data)

$confirm_template = 'mcp_approve.html';

if ($is_disapproving)

{

}

else

{

<?php

/**

*

*

*/

/**

* mcp_reports

* Handling the reports queue

*/

class mcp_reports

{

function main($id, $mode)

{

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

if (!sizeof($report_id_list))

{

$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_id = $report['post_id'];

$report_id = $report['report_id'];

$parse_post_flags = $report['reported_post_enable_bbcode'] ? OPTION_FLAG_BBCODE : 0;

$parse_post_flags += $report['reported_post_enable_smilies'] ? OPTION_FLAG_SMILIES : 0;

if (!sizeof($post_info))

{

));

}

// Get topic tracking info

if ($config['load_db_lastread'])

{

}

$post_unread = (isset($topic_tracking_info[$post_info['topic_id']]) && $post_info['post_time'] > $topic_tracking_info[$post_info['topic_id']]) ? true : false;

$report['report_text'] = make_clickable(bbcode_nl2br($report['report_text']));

FROM ' . ATTACHMENTS_TABLE . '

WHERE post_msg_id = ' . $post_id . '

AND in_message = 0

ORDER BY filetime DESC';

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

if (sizeof($attachments))

{

$update_count = array();

}

// Display not already displayed Attachments for this post, we already parsed them. ;)

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

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

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

'S_REPORT_CLOSED' => $report['report_closed'],

'S_USER_NOTES' => true,

'REPORTER_NAME' => get_username_string('username', $report['user_id'], $report['username'], $report['user_colour']),

'U_VIEW_REPORTER_PROFILE' => get_username_string('profile', $report['user_id'], $report['username'], $report['user_colour']),

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

if ($topic_id)

{

if (!sizeof($topic_info))

{

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

}

else

{

if (!sizeof($forum_info))

{

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_days = $total = 0;

$sort_key = $sort_dir = '';

$sort_by_sql = $sort_order_sql = array();

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

if ($mode == 'reports')

AND r.pm_id = 0

$limit_time_sql

ORDER BY $sort_order_sql";

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

$i = 0;

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)

}

else

{

{

trigger_error('NOT_AUTHORISED');

}

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

{

}

{

}

{

}

else

{

}

$success_msg = '';

$forum_ids = array();

if (confirm_box(true))

{

$sql = "SELECT r.report_id, r.$id_column, r.report_closed, r.user_id, r.user_notify, u.username, u.username_clean, u.user_email, u.user_jabber, u.user_lang, u.user_notify_type

FROM " . REPORTS_TABLE . ' r, ' . USERS_TABLE . ' u

}

$db->sql_query($sql);

if (sizeof($close_report_posts))

{

if ($pm)

}

unset($close_report_posts, $close_report_topics);

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

foreach ($reports as $report)

{

if ($pm)

{

}

else

{

}

}

if ($pm)

{

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

'closer_id' => $user->data['user_id'],

'from_user_id' => $post_info[$post_id]['author_id'],

}

else

{

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

'closer_id' => $user->data['user_id'],

)));

confirm_box(false, $user->lang[strtoupper($action) . "_{$pm_prefix}REPORT" . ((sizeof($report_id_list) == 1) ? '' : 'S') . '_CONFIRM'], $s_hidden_fields);

}

$redirect = reapply_sid($redirect);

if (!$success_msg)

<?php

/**

*

*

*/

*/

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

{

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

if (!sizeof($topic_info))

{

$topic_info = $topic_info[$topic_id];

// Set up some vars

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

// Resync Topic?

if ($action == 'resync')

$sort_days = $total = 0;

$sort_key = $sort_dir = '';

$sort_by_sql = $sort_order_sql = array();

$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

if ($topic_info['topic_attachment'] && sizeof($post_id_list))

{

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

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

}

{

$has_unapproved_posts = true;

}

$post_unread = (isset($topic_tracking_info[$topic_id]) && $row['post_time'] > $topic_tracking_info[$topic_id]) ? true : false;

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

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

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

'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_POST_DELETED' => ($row['post_visibility'] == ITEM_DELETED && $auth->acl_get('m_approve', $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,

'U_POST_DETAILS' => "$url&amp;i=$id&amp;p={$row['post_id']}&amp;mode=post_details" . (($forum_id) ? "&amp;f=$forum_id" : ''),

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

);

// Display not already displayed Attachments for this post, we already parsed them. ;)

if (!empty($attachments[$row['post_id']]))

// Has the user selected a topic for merge?

if ($to_topic_id)

{

if (!sizeof($to_topic_info))

{

*/

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

{

if (!sizeof($post_id_list))

{

return;

}

{

return;

}

$post_id = $post_id_list[0];

if (!sizeof($post_info))

{

return;

}

if (!sizeof($forum_info))

{

return;

}

$s_hidden_fields = build_hidden_fields(array(

'i' => 'main',

'redirect' => $redirect,

'subject' => $subject,

'to_forum_id' => $to_forum_id,

);

if (confirm_box(true))

{

$sort_days = $total = 0;

$sort_key = $sort_dir = '';

$sort_by_sql = $sort_order_sql = array();

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

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

{

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

{

// continue;

}

trigger_error('NO_POST_SELECTED');

}

$sql_ary = array(

'forum_id' => $to_forum_id,

$to_topic_id = $db->sql_nextid();

move_posts($post_id_list, $to_topic_id);

$topic_info = $topic_info[$topic_id];

// Change topic title of first post

$sql = 'UPDATE ' . POSTS_TABLE . "

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

{

return;

}

{

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

return;

}

$topic_data = $topic_data[$to_topic_id];

if (!sizeof($post_id_list))

{

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

// Message and return links

$success_msg = 'POSTS_MERGED_SUCCESS';

// Does the original topic still exist? If yes, link back to it

$sql = 'SELECT forum_id

WHERE topic_id = ' . $topic_id;

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

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

phpbb_update_rows_avoiding_duplicates($db, BOOKMARKS_TABLE, 'topic_id', array($topic_id), $to_topic_id);

}

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

<?php

/**

*

*

*/

/**

* mcp_warn

* Handling warning the users

*/

class mcp_warn

{

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

'U_NOTES' => append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=notes&amp;mode=user_notes&amp;u=' . $row['user_id']),

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

'WARNING_TIME' => $user->format_date($row['user_last_warning']),

'WARNINGS' => $row['user_warnings'],

'U_NOTES' => append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=notes&amp;mode=user_notes&amp;u=' . $row['user_id']),

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

'WARNING_TIME' => $user->format_date($row['warning_time']),

'WARNINGS' => $row['user_warnings'],

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

'U_NOTES' => append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=notes&amp;mode=user_notes&amp;u=' . $row['user_id']),

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

'WARNING_TIME' => $user->format_date($row['user_last_warning']),

'WARNINGS' => $row['user_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

{

if (check_form_key('mcp_warn'))

{

}

else

{

}

}

// OK, they didn't submit a warning so lets build the page for them to do so

// We want to make the message available here as a reminder

// Parse the message and subject

$message = generate_text_for_display($user_row['post_text'], $user_row['bbcode_uid'], $user_row['bbcode_bitfield'], $parse_flags, true);

// Generate the appropriate user information for the user we are looking at

{

include($phpbb_root_path . 'includes/functions_display.' . $phpEx);

}

$avatar_img = phpbb_get_user_avatar($user_row);

$template->assign_vars(array(

'POST' => $message,

'USERNAME' => $user_row['username'],

'USER_COLOR' => (!empty($user_row['user_colour'])) ? $user_row['user_colour'] : '',

'JOINED' => $user->format_date($user_row['user_regdate']),

'POSTS' => ($user_row['user_posts']) ? $user_row['user_posts'] : 0,

'WARNINGS' => ($user_row['user_warnings']) ? $user_row['user_warnings'] : 0,

'AVATAR_IMG' => $avatar_img,

'L_WARNING_POST_DEFAULT' => sprintf($user->lang['WARNING_POST_DEFAULT'], generate_board_url() . "/viewtopic.$phpEx?f=$forum_id&amp;p=$post_id#p$post_id"),

*/

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

{

if (check_form_key('mcp_warn'))

{

}

else

{

}

}

// Generate the appropriate user information for the user we are looking at

{

include($phpbb_root_path . 'includes/functions_display.' . $phpEx);

}

$avatar_img = phpbb_get_user_avatar($user_row);

// OK, they didn't submit a warning so lets build the page for them to do so

$template->assign_vars(array(

'U_POST_ACTION' => $this->u_action,

'JOINED' => $user->format_date($user_row['user_regdate']),

'POSTS' => ($user_row['user_posts']) ? $user_row['user_posts'] : 0,

'WARNINGS' => ($user_row['user_warnings']) ? $user_row['user_warnings'] : 0,

'U_PROFILE' => get_username_string('profile', $user_row['user_id'], $user_row['username'], $user_row['user_colour']),

'AVATAR_IMG' => $avatar_img,

'S_CAN_NOTIFY' => $s_can_notify,

));

*/

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

{

if ($send_pm)

{

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

}