<?php

/**

*

*

*/

class mcp_ban_info

{

function module()

{

}

}

<?php

/**

*

*

*/

class mcp_logs_info

{

function module()

{

}

}

<?php

/**

*

*

*/

class mcp_main_info

{

function module()

{

}

}

<?php

/**

*

*

*/

class mcp_notes_info

{

function module()

{

}

}

<?php

/**

*

*

*/

class mcp_pm_reports_info

{

function module()

'title' => 'MCP_PM_REPORTS',

'version' => '1.0.0',

'modes' => array(

),

);

}

{

}

}

<?php

/**

*

*

*/

class mcp_queue_info

{

function module()

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

'approve_details' => array('title' => 'MCP_QUEUE_APPROVE_DETAILS', 'auth' => 'acl_m_approve,$id || (!$id && aclf_m_approve)', 'cat' => array('MCP_QUEUE')),

),

);

{

}

}

<?php

/**

*

*

*/

class mcp_reports_info

{

function module()

{

}

}

<?php

/**

*

*

*/

class mcp_warn_info

{

function module()

{

}

}

<?php

/**

*

*

*/

exit;

}

class mcp_ban

{

var $u_action;

function main($id, $mode)

{

global $phpbb_root_path, $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

/**

*

*

*/

{

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

global $phpEx, $phpbb_root_path, $config;

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

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

$start = request_var('start', 0);

$topic_id_list = request_var('topic_id_list', array(0));

break;

}

$selected_ids = '';

if (sizeof($post_id_list) && $action != 'merge_topics')

{

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

$template->assign_vars(array(

'ACTION' => $action,

'FORUM_NAME' => $forum_info['forum_name'],

'S_CAN_REPORT' => $auth->acl_get('m_report', $forum_id),

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

'S_CAN_MERGE' => $auth->acl_get('m_merge', $forum_id),

'S_CAN_MOVE' => $auth->acl_get('m_move', $forum_id),

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

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

));

// Grab icons

$read_tracking_join = $read_tracking_select = '';

}

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

{

if ($config['load_db_lastread'])

{

}

else

{

}

}

$row = &$topic_rows[$topic_id];

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

{

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

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

$topic_row = array(

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

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

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

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

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

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

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

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

'TOPIC_TYPE' => $topic_type,

'TOPIC_TITLE' => $topic_title,

'LAST_POST_TIME' => $user->format_date($row['topic_last_post_time']),

'FIRST_POST_TIME' => $user->format_date($row['topic_time']),

'LAST_POST_SUBJECT' => $row['topic_last_post_subject'],

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

'S_TOPIC_UNAPPROVED' => $topic_unapproved,

'S_POSTS_UNAPPROVED' => $posts_unapproved,

'S_UNREAD_TOPIC' => $unread_topic,

);

));

}

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

}

unset($topic_rows);

trigger_error('NO_TOPIC_SELECTED');

}

{

return;

}

*/

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;

}

$post_id_list = request_var('post_id_list', array(0));

$start = request_var('start', 0);

return;

}

{

return;

}

$s_hidden_fields = build_hidden_fields(array(

'i' => 'main',

if (confirm_box(true))

{

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

}

else

{

}

}

<?php

/**

*

*

*/

{

global $phpEx, $phpbb_root_path, $config;

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

// Latest 5 unapproved

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

if (!empty($forum_list))

{

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

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

$db->sql_freeresult($result);

if ($total)

{

$sql = 'SELECT forum_id, forum_name

FROM ' . FORUMS_TABLE . '

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

$sql = 'SELECT post_id

FROM ' . POSTS_TABLE . '

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

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

}

}

if ($total)

{

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

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

{

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

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

'U_MCP_TOPIC' => append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=main&amp;mode=topic_view&amp;f=' . $row['forum_id'] . '&amp;t=' . $row['topic_id']),

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

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

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

'U_AUTHOR' => get_username_string('profile', $row['poster_id'], $row['username'], $row['user_colour']),

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

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

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

}

$db->sql_freeresult($result);

}

$template->assign_vars(array(

'S_HIDDEN_FIELDS' => $s_hidden_fields,

'S_MCP_QUEUE_ACTION' => append_sid("{$phpbb_root_path}mcp.$phpEx", "i=queue"),

));

}

}

WHERE r.post_id = p.post_id

AND r.pm_id = 0

AND r.report_closed = 0

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

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

$db->sql_freeresult($result);

if ($total)

{

'FROM' => array(

REPORTS_TABLE => 'r',

REPORTS_REASONS_TABLE => 'rr',

TOPICS_TABLE => 't',

USERS_TABLE => array('u', 'u2'),

),

'LEFT_JOIN' => array(

array(

'FROM' => array(FORUMS_TABLE => 'f'),

),

'WHERE' => 'r.post_id = p.post_id

AND p.topic_id = t.topic_id

AND r.user_id = u.user_id

AND p.poster_id = u2.user_id

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

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

{

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

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

'U_MCP_TOPIC' => append_sid("{$phpbb_root_path}mcp.$phpEx", 'f=' . $row['forum_id'] . '&amp;t=' . $row['topic_id'] . "&amp;i=$id&amp;mode=topic_view"),

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

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

'AUTHOR_COLOUR' => get_username_string('colour', $row['author_id'], $row['author_name'], $row['author_colour']),

'U_AUTHOR' => get_username_string('profile', $row['author_id'], $row['author_name'], $row['author_colour']),

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

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

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

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

));

}

}

}

}

// Latest 5 reported PMs

{

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

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

{

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

'FROM' => array(

REPORTS_TABLE => 'r',

REPORTS_REASONS_TABLE => 'rr',

USERS_TABLE => array('u', 'u2'),

),

'WHERE' => 'r.pm_id = p.msg_id

AND r.user_id = u.user_id

AND p.author_id = u2.user_id',

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

$pm_by_id = $pm_list = array();

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

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

}

$address_list = get_recipient_strings($pm_by_id);

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

'PM_TIME' => $user->format_date($row['message_time']),

'RECIPIENTS' => implode(', ', $address_list[$row['msg_id']]),

));

}

}

}

// Latest 5 logs

if (!empty($forum_list))

{

$log_count = false;

$log = array();

view_log('mod', $log, $log_count, 5, 0, $forum_list);

$template->assign_var('S_MCP_ACTION', append_sid("{$phpbb_root_path}mcp.$phpEx"));

make_jumpbox(append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=main&amp;mode=forum_view'), 0, false, 'm_', true);

}

<?php

/**

*

*

*/

/**

* mcp_logs

* Handling warning the users

*/

class mcp_logs

{

function main($id, $mode)

{

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

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

$this->tpl_name = 'mcp_logs';

$this->page_title = 'MCP_LOGS';

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

$forum_list[] = 0;

{

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

{

}

else if ($deleteall)

{

if ($mode == 'topic_logs')

{

}

}

}

else

$log_count = 0;

$start = view_log('mod', $log_data, $log_count, $config['topics_per_page'], $start, $forum_list, $topic_id, 0, $sql_where, $sql_sort, $keywords);

$template->assign_vars(array(

'L_TITLE' => $user->lang['MCP_LOGS'],

}

}

}

<?php

/**

*

*

*/

/**

* mcp_main

* Handling mcp actions

*/

class mcp_main

{

function main($id, $mode)

{

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

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

case 'delete_topic':

$user->add_lang('viewtopic');

if (!sizeof($topic_ids))

{

trigger_error('NO_TOPIC_SELECTED');

}

break;

case 'delete_post':

$user->add_lang('posting');

if (!sizeof($post_ids))

{

trigger_error('NO_POST_SELECTED');

}

break;

}

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

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 = request_var('redirect', build_url(array('action', 'quickmod')));

$s_hidden_fields = build_hidden_fields(array(

$sql_id . '_list' => $ids,

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

$db->sql_query($sql);

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

{

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

}

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

}

else

{

}

}

/**

*/

function change_topic_type($action, $topic_ids)

{

switch ($action)

{

break;

}

if ($forum_id === false)

{

}

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

$s_hidden_fields = array(

'topic_id_list' => $topic_ids,

if (confirm_box(true))

{

{

$sql = 'UPDATE ' . TOPICS_TABLE . "

SET topic_type = $new_topic_type

$db->sql_query($sql);

}

$success_msg = (sizeof($topic_ids) == 1) ? 'TOPIC_TYPE_CHANGED' : 'TOPICS_TYPE_CHANGED';

if (sizeof($topic_ids))

{

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

{

add_log('mod', $forum_id, $topic_id, 'LOG_TOPIC_TYPE_CHANGED', $row['topic_title']);

}

}

{

}

}

else

{

}

}

/**

*/

function mcp_move_topic($topic_ids)

{

global $phpEx, $phpbb_root_path;

// Here we limit the operation to one forum only

if ($forum_id === false)

{

if ($to_forum_id)

{

if (!sizeof($forum_data))

{

if (!$to_forum_id || $additional_msg)

{

}

if (confirm_box(true))

{

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

$forum_sync_data = array();

$forum_sync_data[$forum_id] = current($topic_data);

$forum_sync_data[$to_forum_id] = $forum_data;

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

{

{

}

{

}

}

$db->sql_transaction('begin');

{

}

$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

{

$shadow = array(

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

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

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

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

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

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

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

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

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

'topic_status' => ITEM_MOVED,

'topic_type' => POST_NORMAL,

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

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

'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

}

}

unset($topic_data);

{

}

{

}

{

}

$success_msg = (sizeof($topic_ids) == 1) ? 'TOPIC_MOVED_SUCCESS' : 'TOPICS_MOVED_SUCCESS';

$template->assign_vars(array(

'S_FORUM_SELECT' => make_forum_select($to_forum_id, $forum_id, false, true, true, true),

'S_CAN_LEAVE_SHADOW' => true,

'ADDITIONAL_MSG' => $additional_msg)

);

}

/**

*/

{

{

return;

}

$s_hidden_fields = build_hidden_fields(array(

'topic_id_list' => $topic_ids,

'f' => $forum_id,

);

$success_msg = '';

{

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

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

{

}

else

{

}

}

}

else

{

}

{

$redirect = reapply_sid($redirect);

$redirect_message = 'PAGE';

}

else

{

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

/**

* Delete Posts

*/

{

{

return;

}

'post_id_list' => $post_ids,

'f' => $forum_id,

);

$success_msg = '';

{

if (!function_exists('delete_posts'))

{

$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

$deleted_topics = ($row = $db->sql_fetchrow($result)) ? ($affected_topics - $row['topics_left']) : $affected_topics;

$db->sql_freeresult($result);

// Return links

$return_link = array();

}

else

{

}

$redirect = reapply_sid($redirect);

if (!$success_msg)

function mcp_fork_topic($topic_ids)

{

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

{

return;

}

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

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

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

{

}

if (confirm_box(true))

{

$new_topic_id_list = array();

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

{

if (!isset($search_type) && $topic_row['enable_indexing'])

{

// Select the search method and do some additional checks to ensure it can actually be utilised

if (!class_exists($search_type))

{

}

$error = false;

$search_mode = 'post';

if ($error)

'forum_id' => (int) $to_forum_id,

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

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

'topic_reported' => 0,

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

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

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

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

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

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

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

{

$poll_rows = array();

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

continue;

}

foreach ($post_rows as $row)

{

$sql_ary = array(

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

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

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

'post_reported' => 0,

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

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

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

// Copy whether the topic is dotted

markread('post', $to_forum_id, $new_topic_id, 0, $row['poster_id']);

}

// Sync new topics, parent forums and board stats

{

}

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

set_config_count('num_topics', sizeof($new_topic_id_list), true);

set_config_count('num_posts', $total_posts, true);

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

}

}

<?php

/**

*

*

*/

/**

* mcp_notes

* Displays notes about a user

*/

class mcp_notes

{

function mcp_notes_user_view($action)

{

global $phpEx, $phpbb_root_path, $config;

$user_id = request_var('u', 0);

$username = request_var('username', '', true);

$st = request_var('st', 0);

$sk = request_var('sk', 'b');

$sd = request_var('sd', 'd');

add_form_key('mcp_notes');

}

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

$rank_title = $rank_img = '';

$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_IP'], 'd' => $user->lang['SORT_ACTION']);

}

}

$template->assign_vars(array(

'U_POST_ACTION' => $this->u_action,

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

'L_TITLE' => $user->lang['MCP_NOTES_USER'],

'RANK_TITLE' => $rank_title,

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

}

}

<?php

/**

*

*

*/

/**

* mcp_reports

* Handling the reports queue

*/

class mcp_pm_reports

{

function main($id, $mode)

{

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

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

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

$start = request_var('start', 0);

$this->page_title = 'MCP_PM_REPORTS';

trigger_error('NO_REPORT');

}

$pm_id = $report['pm_id'];

$report_id = $report['report_id'];

if (!sizeof($pm_info))

{

}

// Process message, leave it uncensored

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

if ($pm_info['message_attachment'] && $auth->acl_get('u_pm_download'))

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

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

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

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

));

}

}

}

// Now display the page

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

'TOTAL' => $total,

)

);

}

}

}

<?php

/**

*

*

*/

*/

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

{

$user->add_lang('posting');

$start = request_var('start', 0);

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

{

$ip = request_var('ip', '');

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

}

break;

}

// Set some vars

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

// Process message, leave it uncensored

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

{

}

}

'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_LOCKED' => ($post_info['post_edit_locked']) ? true : false,

'S_USER_NOTES' => true,

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

'U_EDIT' => ($auth->acl_get('m_edit', $post_info['forum_id'])) ? append_sid("{$phpbb_root_path}posting.$phpEx", "mode=edit&amp;f={$post_info['forum_id']}&amp;p={$post_info['post_id']}") : '',

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

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

'REPORTED_IMG' => $user->img('icon_topic_reported', $user->lang['POST_REPORTED']),

'UNAPPROVED_IMG' => $user->img('icon_topic_unapproved', $user->lang['POST_UNAPPROVED']),

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

'SEARCH_IMG' => $user->img('icon_user_search', $user->lang['SEARCH']),

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

{

);

}

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

{

{

}

}

if (sizeof($users_ary))

{

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

);

}

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

if (sizeof($usernames_ary))

}

/**

* Change a post's poster

*/

function change_poster(&$post_info, $userdata)

{

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

{

}

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

{

$sql = 'UPDATE ' . USERS_TABLE . '

SET user_posts = user_posts - 1

}

// refresh search cache of this post

{

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

{

// Now add log entry

add_log('mod', $post_info['forum_id'], $post_info['topic_id'], 'LOG_MCP_CHANGE_POSTER', $post_info['topic_title'], $from_username, $to_username);

}

<?php

/**

*

*

*/

/**

* mcp_queue

* Handling the moderation queue

*/

class mcp_queue

{

var $p_master;

var $u_action;

{

$this->p_master = &$p_master;

}

{

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

switch ($action)

{

case 'approve':

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

{

trigger_error('NO_POST_SELECTED');

}

{

}

else

{

}

break;

}

$post_id = request_var('p', 0);

$topic_id = request_var('t', 0);

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

{

$template->assign_vars(array(

'S_TOPIC_REVIEW' => true,

'S_BBCODE_ALLOWED' => $post_info['enable_bbcode'],

}

$extensions = $attachments = $topic_tracking_info = array();

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

// Process message, leave it uncensored

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

{

foreach ($attachments as $attachment)

{

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

}

}

}

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

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

'U_EDIT' => ($auth->acl_get('m_edit', $post_info['forum_id'])) ? append_sid("{$phpbb_root_path}posting.$phpEx", "mode=edit&amp;f={$post_info['forum_id']}&amp;p={$post_info['post_id']}") : '',

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

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

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

'REPORTED_IMG' => $user->img('icon_topic_reported', $user->lang['POST_REPORTED']),

case 'unapproved_topics':

case 'unapproved_posts':

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

$forum_info = array();

if ($topic_id)

{

if (!sizeof($topic_info))

{

$forum_id = $topic_info['forum_id'];

}

$forum_list_read = array_flip(get_forum_list('f_read', true, true)); // Flipped so we can isset() the forum IDs

// Remove forums we cannot read

trigger_error('NOT_MODERATOR');

}

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

$db->sql_freeresult($result);

}

else

{

if (!sizeof($forum_info))

{

$forum_info = $forum_info[$forum_id];

$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

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

AND t.topic_id = p.topic_id

$limit_time_sql

ORDER BY $sort_order_sql";

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

$i = 0;

if (sizeof($post_ids))

{

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

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

AND t.topic_id = p.topic_id

$post_data = $rowset = array();

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

{

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

}

$db->sql_freeresult($result);

}

else

{

$limit_time_sql

ORDER BY $sort_order_sql";

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

$rowset = array();

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

{

$rowset[] = $row;

}

$db->sql_freeresult($result);

foreach ($rowset as $row)

{

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

{

}

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

'U_TOPIC' => append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . $row['forum_id'] . '&amp;t=' . $row['topic_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'] : ''),

'U_VIEW_DETAILS' => append_sid("{$phpbb_root_path}mcp.$phpEx", "i=queue&amp;start=$start&amp;mode=approve_details&amp;f={$row['forum_id']}&amp;p={$row['post_id']}" . (($mode == 'unapproved_topics') ? "&amp;t={$row['topic_id']}" : '')),

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

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

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

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

}

unset($rowset, $forum_names);

// Now display the page

$template->assign_vars(array(

'L_ONLY_TOPIC' => ($topic_id) ? sprintf($user->lang['ONLY_TOPIC'], $topic_info['topic_title']) : '',

'S_FORUM_OPTIONS' => $forum_options,

'S_MCP_ACTION' => build_url(array('t', 'f', 'sd', 'st', 'sk')),

'TOPIC_ID' => $topic_id,

));

$this->tpl_name = 'mcp_queue';

break;

}

}

{

{

{

{

}

$approve_log[] = array(

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

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

);

}

{

}

{

{

}

}

}

{

{

}

{

}

}

{

}

);

}

}

{

}

}

else

{

{

{

}

}

redirect($redirect);

}

{

{

}

{

{

}

}

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

{

{

}

}

{

{

{

}

}

{

}

{

}

$lang_reasons = array();

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

{

{

}

{

{

{

{

}

}

}

}

}

else

{

{

}

else

{

redirect($redirect);

}

}

<?php

/**

*

*

*/

/**

* mcp_reports

* Handling the reports queue

*/

class mcp_reports

{

function main($id, $mode)

{

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

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

// closed reports are accessed by report id

$report_id = request_var('r', 0);

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

}

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

{

trigger_error('REPORT_CLOSED');

$post_id = $report['post_id'];

$report_id = $report['report_id'];

if (!sizeof($post_info))

{

$template->assign_vars(array(

'S_TOPIC_REVIEW' => true,

'S_BBCODE_ALLOWED' => $post_info['enable_bbcode'],

}

$topic_tracking_info = $extensions = $attachments = array();

}

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

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

FROM ' . ATTACHMENTS_TABLE . '

WHERE post_msg_id = ' . $post_id . '

AND in_message = 0

ORDER BY filetime DESC';

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

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

if ($topic_id)

{

if (!sizeof($topic_info))

{

$global_id = $forum_list[0];

FROM ' . FORUMS_TABLE . '

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

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

$db->sql_freeresult($result);

}

else

{

if (!sizeof($forum_info))

{

$forum_info = $forum_info[$forum_id];

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

if (sizeof($report_ids))

{

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

WHERE ' . $db->sql_in_set('r.report_id', $report_ids) . '

AND t.topic_id = p.topic_id

$report_data = $rowset = array();

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

{

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

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

'U_VIEW_DETAILS' => append_sid("{$phpbb_root_path}mcp.$phpEx", "i=reports&amp;start=$start&amp;mode=report_details&amp;f={$row['forum_id']}&amp;r={$row['report_id']}"),

'REPORTER' => get_username_string('username', $row['reporter_id'], $row['reporter_name'], $row['reporter_colour']),

'U_REPORTER' => get_username_string('profile', $row['reporter_id'], $row['reporter_name'], $row['reporter_colour']),

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

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

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

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

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

}

$db->sql_freeresult($result);

unset($report_ids, $row);

}

// Now display the page

$template->assign_vars(array(

'L_EXPLAIN' => ($mode == 'reports') ? $user->lang['MCP_REPORTS_OPEN_EXPLAIN'] : $user->lang['MCP_REPORTS_CLOSED_EXPLAIN'],

'S_FORUM_OPTIONS' => $forum_options,

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

'TOPIC_ID' => $topic_id,

'TOTAL' => $total,

)

);

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

{

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

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

$id_column = ($pm) ? 'pm_id' : 'post_id';

{

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

}

$post_id_list = array_unique($post_id_list);

if ($pm)

}

else

{

{

trigger_error('NOT_AUTHORISED');

}

{

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

}

{

$redirect = request_var('redirect', build_url(array('mode', 'r', 'quickmod')) . '&amp;mode=pm_reports');

}

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

foreach ($reports as $report)

{

if ($pm)

{

add_log('mod', 0, 0, 'LOG_PM_REPORT_' . strtoupper($action) . 'D', $post_info[$report['pm_id']]['message_subject']);

}

else

{

add_log('mod', $post_info[$report['post_id']]['forum_id'], $post_info[$report['post_id']]['topic_id'], 'LOG_REPORT_' . strtoupper($action) . 'D', $post_info[$report['post_id']]['post_subject']);

}

}

// Notify reporters

if (sizeof($notify_reporters))

{

$post_id = $reporter[$id_column];

if ($pm)

{

}

else

{

}

}

}

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

$success_msg = (sizeof($report_id_list) == 1) ? "{$pm_prefix}REPORT_" . strtoupper($action) . 'D_SUCCESS' : "{$pm_prefix}REPORTS_" . strtoupper($action) . 'D_SUCCESS';

}

else

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

}

}

<?php

/**

*

*

*/

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

{

global $phpEx, $phpbb_root_path, $config;

$user->add_lang('viewtopic');

$topic_id = request_var('t', 0);

if (!sizeof($topic_info))

{

$subject = $topic_info['topic_title'];

}

{

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

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

if (!$sort)

{

}

}

$sort_days = $total = 0;

$sort_key = $sort_dir = '';

$sort_by_sql = $sort_order_sql = array();

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

if ($total == -1)

{

}

$posts_per_page = max(0, request_var('posts_per_page', intval($config['posts_per_page'])));

{

$start = 0;

}

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

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

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

AND p.poster_id = u.user_id ' .

$limit_time_sql . '

ORDER BY ' . $sort_order_sql;

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

$topic_tracking_info = array();

// Get topic tracking info

$topic_tracking_info = get_complete_topic_tracking($topic_info['forum_id'], $topic_id);

}

// Grab extensions

$extensions = $attachments = array();

}

}

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

{

$message = $row['post_text'];

$post_subject = ($row['post_subject'] != '') ? $row['post_subject'] : $topic_info['topic_title'];

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

{

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

{

'post_ids' => $post_id_list,

));

$template->assign_vars(array(

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

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

'REPORTED_IMG' => $user->img('icon_topic_reported', 'POST_REPORTED'),

'UNAPPROVED_IMG' => $user->img('icon_topic_unapproved', 'POST_UNAPPROVED'),

'INFO_IMG' => $user->img('icon_post_info', 'VIEW_INFO'),

'S_MCP_ACTION' => "$url&amp;i=$id&amp;mode=$mode&amp;action=$action&amp;start=$start",

'S_CAN_MERGE' => ($auth->acl_get('m_merge', $topic_info['forum_id'])) ? true : false,

'S_CAN_DELETE' => ($auth->acl_get('m_delete', $topic_info['forum_id'])) ? true : false,

'S_CAN_APPROVE' => ($has_unapproved_posts && $auth->acl_get('m_approve', $topic_info['forum_id'])) ? true : false,

'S_CAN_LOCK' => ($auth->acl_get('m_lock', $topic_info['forum_id'])) ? true : false,

'S_CAN_REPORT' => ($auth->acl_get('m_report', $topic_info['forum_id'])) ? true : false,

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

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

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

));

}

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

{

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

$post_id_list = request_var('post_id_list', array(0));

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

return;

}

{

return;

}

$post_id = $post_id_list[0];

if (!sizeof($post_info))

{

return;

}

if (!sizeof($forum_info))

{

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

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

{

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

WHERE p.topic_id = $topic_id

AND p.poster_id = u.user_id

}

else

{

FROM ' . POSTS_TABLE . " p

WHERE p.topic_id = $topic_id

$limit_time_sql

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

{

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

{

// continue;

}

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

$sql_ary = array(

);

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

$to_topic_id = $db->sql_nextid();

move_posts($post_id_list, $to_topic_id);

$topic_info = $topic_info[$topic_id];

add_log('mod', $to_forum_id, $to_topic_id, 'LOG_SPLIT_DESTINATION', $subject);

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

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

}

else

{

}

}

*/

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

$post_id_list = request_var('post_id_list', array(0));

return;

}

{

return;

}

{

$to_forum_id = $topic_data['forum_id'];

add_log('mod', $to_forum_id, $to_topic_id, 'LOG_MERGE', $topic_data['topic_title']);

// Message and return links

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

}

else

{

}

}

<?php

/**

*

*

*/

/**

* mcp_warn

* Handling warning the users

*/

class mcp_warn

{

'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 $template, $db, $user, $auth;

$user->add_lang('memberlist');

$start = request_var('start', 0);

$st = request_var('st', 0);

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

));

}

$template->assign_vars(array(

'U_POST_ACTION' => $this->u_action,

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

'S_SELECT_SORT_KEY' => $s_sort_key,

'S_SELECT_SORT_DAYS' => $s_limit_days,

));

}

function mcp_warn_post_view($action)

{

global $phpEx, $phpbb_root_path, $config;

$post_id = request_var('p', 0);

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

// Check if can send a notification

if ($config['allow_privmsg'])

{

$auth2->acl($user_row);

$s_can_notify = ($auth2->acl_get('u_readpm')) ? true : false;

unset($auth2);

{

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

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

{

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

}

$template->assign_vars(array(

'U_POST_ACTION' => $this->u_action,

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

{

global $phpEx, $phpbb_root_path, $config, $module;

$user_id = request_var('u', 0);

$username = request_var('username', '', true);

// Check if can send a notification

if ($config['allow_privmsg'])

{

$auth2->acl($user_row);

$s_can_notify = ($auth2->acl_get('u_readpm')) ? true : false;

unset($auth2);

{

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

}

// 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,

));

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

);

}

add_log('admin', 'LOG_USER_WARNING', $user_row['username']);

add_log('mod', $row['forum_id'], $row['topic_id'], 'LOG_USER_WARNING', $user_row['username']);

}