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

),

);

{

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

global $phpEx, $phpbb_root_path, $config;

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

$sort_by_sql = $sort_order_sql = array();

mcp_sorting('viewforum', $sort_days, $sort_key, $sort_dir, $sort_by_sql, $sort_order_sql, $total, $forum_id);

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

$base_url = $url . "&i=$id&action=$action&mode=$mode&sd=$sort_dir&sk=$sort_key&st=$sort_days" . (($merge_select) ? $selected_ids : '');

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

$read_tracking_join = $read_tracking_select = '';

}

$sql = 'SELECT t.topic_id

FROM ' . TOPICS_TABLE . ' t

WHERE t.forum_id = ' . $forum_id . '

$limit_time_sql

ORDER BY t.topic_type DESC, $sort_order_sql";

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

$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 . '&i=queue&mode=' . (($topic_unapproved) ? 'approve_details' : 'unapproved_posts') . '&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_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,

);

$sql = 'SELECT COUNT(post_id) AS total

FROM ' . POSTS_TABLE . '

WHERE ' . $db->sql_in_set('forum_id', $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) . '

ORDER BY post_time DESC';

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

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_sync_data[$forum_id] = current($topic_data);

$forum_sync_data[$to_forum_id] = $forum_data;

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

{

{

}

{

}

}

// Move topics, but do not resync yet

move_topics($topic_ids, $to_forum_id, false);

$db->sql_query($sql);

}

$forum_ids = array($to_forum_id);

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

{

add_log('mod', $to_forum_id, $topic_id, 'LOG_MOVE', $row['forum_name'], $forum_data['forum_name']);

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

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

}

/**

* Delete Topics

*/

{

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

{

return;

}

'topic_id_list' => $topic_ids,

'f' => $forum_id,

);

$success_msg = '';

}

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

{

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

{

$topic_data = get_topic_data($topic_ids, 'f_post');

$new_topic_id_list = array();

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

{

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

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

$new_topic_id = $db->sql_nextid();

$new_topic_id_list[$topic_id] = $new_topic_id;

if ($topic_row['poll_start'])

{

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

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

}

}

$template->assign_vars(array(

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

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

'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&f={$post_info['forum_id']}&p={$post_info['post_id']}") : '',

'U_FIND_USERNAME' => append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=searchuser&form=mcp_chgposter&field=username&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']),

}

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

var $p_master;

var $u_action;

{

$this->p_master = &$p_master;

}

{

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

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;

}

$template->assign_vars(array(

'S_TOPIC_REVIEW' => true,

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

}

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

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

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

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

}

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

{

$sort_by_sql = $sort_order_sql = array();

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

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

$forum_names = array();

{

$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

$limit_time_sql

ORDER BY $sort_order_sql";

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

else

{

$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

$limit_time_sql

ORDER BY $sort_order_sql";

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

{

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

{

}

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

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

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

'FORUM_NAME' => $forum_names[$row['forum_id']],

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

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

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

'PAGE_NUMBER' => phpbb_on_page($template, $user, $base_url, $total, $config['topics_per_page'], $start),

'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

{

{

{

}

}

{

}

{

{

{

}

}

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

{

{

}

}

{

{

{

}

}

{

}

{

}

$lang_reasons = array();

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

{

{

{

{

{

}

}

{

$phpbb_notifications->add_notifications('disapprove_topic', $post_data);

}

{

$phpbb_notifications->add_notifications('disapprove_post', $post_data);

}

}

}

}

else

{

{

}

else

{

}

{

}

}

}

'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_USER_NOTES' => true,

$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

$sort_by_sql = $sort_order_sql = array();

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

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

if ($mode == 'reports')

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

{

global $phpEx, $phpbb_root_path, $config;

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

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

{

}

}

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

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

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

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

}

// Grab extensions

$extensions = $attachments = array();

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;

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

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

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

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