{

}

}

{

}

}

{

}

}

{

}

}

{

}

}

{

}

}

{

}

}

{

}

}

}

}

}

{

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

global $phpEx, $phpbb_root_path, $config;

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

if ($merge_select)

{

// Fixes a "bug" that makes forum_view use the same ordering as topic_view

}

$forum_id = $forum_info['forum_id'];

'PAGINATION' => generate_pagination($url . "&i=$id&action=$action&mode=$mode&sd=$sort_dir&sk=$sort_key&st=$sort_days" . (($merge_select) ? $selected_ids : ''), $forum_topics, $topics_per_page, $start),

'PAGE_NUMBER' => on_page($forum_topics, $topics_per_page, $start),

));

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

{

if ($config['load_db_lastread'])

{

}

else

{

}

}

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

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

}

}

{

$sql = 'SELECT COUNT(post_id) AS total

FROM ' . POSTS_TABLE . '

AND post_approved = 0';

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

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

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

AND post_approved = 0

ORDER BY post_time DESC';

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

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

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

));

}

}

}

}

{

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

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

}

$template->assign_vars(array(

'PAGE_NUMBER' => on_page($log_count, $config['topics_per_page'], $start),

'PAGINATION' => generate_pagination($this->u_action . "&amp;$u_sort_param$keywords_param", $log_count, $config['topics_per_page'], $start),

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

}

}

}

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

}

else

{

}

$redirect = request_var('redirect', "index.$phpEx");

{

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

global $phpEx, $phpbb_root_path;

// Here we limit the operation to one forum only

$forum_id = check_ids($topic_ids, TOPICS_TABLE, 'topic_id', array('m_move'), true);

if (!$to_forum_id || $additional_msg)

{

}

if (confirm_box(true))

$topic_posts_added += $topic_info['topic_replies'];

}

}

// Move topics, but do not resync yet

move_topics($topic_ids, $to_forum_id, false);

$forum_ids = array($to_forum_id);

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

{

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

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

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

{

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

);

if ($additional_msg)

{

}

if (confirm_box(true))

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

}

}

'PAGE_NUMBER' => on_page($log_count, $config['topics_per_page'], $start),

'PAGINATION' => generate_pagination($this->u_action . "&amp;$u_sort_param$keywords_param", $log_count, $config['topics_per_page'], $start),

'RANK_TITLE' => $rank_title,

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

}

}

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

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

));

}

}

'PAGINATION' => generate_pagination($this->u_action . "&amp;st=$sort_days&amp;sk=$sort_key&amp;sd=$sort_dir", $total, $config['topics_per_page'], $start),

'PAGE_NUMBER' => on_page($total, $config['topics_per_page'], $start),

'TOTAL' => $total,

)

);

}

}

}

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

}

trigger_error('NOT_MODERATOR');

}

$forum_list = implode(', ', $forum_list);

$sql = 'SELECT SUM(forum_topics) as sum_forum_topics

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

$forum_info['forum_topics'] = (int) $db->sql_fetchfield('sum_forum_topics');

$db->sql_freeresult($result);

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

if ($mode == 'unapproved_posts')

{

$sql = 'SELECT p.post_id

AND p.post_approved = 0

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

AND t.topic_id = p.topic_id

AND t.topic_first_post_id <> p.post_id

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

{

FROM ' . TOPICS_TABLE . " t

AND topic_approved = 0

$limit_time_sql

ORDER BY $sort_order_sql";

$rowset = array();

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

{

$rowset[] = $row;

}

$db->sql_freeresult($result);

foreach ($rowset as $row)

{

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

{

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

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

'PAGINATION' => generate_pagination($this->u_action . "&amp;f=$forum_id&amp;st=$sort_days&amp;sk=$sort_key&amp;sd=$sort_dir", $total, $config['topics_per_page'], $start),

'PAGE_NUMBER' => on_page($total, $config['topics_per_page'], $start),

'TOPIC_ID' => $topic_id,

));

$this->tpl_name = 'mcp_queue';

}

$topic_id_list[$post_data['topic_id']] = 1;

// User post update (we do not care about topic or post, since user posts are strictly connected to posts)

// But we care about forums where post counts get not increased. ;)

// Topic or Post. ;)

if ($post_data['topic_first_post_id'] == $post_id)

{

$topic_approve_sql[] = $post_data['topic_id'];

$approve_log[] = array(

);

}

}

$post_approve_sql[] = $post_id;

{

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

global $phpEx, $phpbb_root_path;

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

{

if (!$row || (!$reason && strtolower($row['reason_title']) == 'other'))

{

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

}

else

{

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

}

}

$forum_info = $forum_info[$forum_id];

$forum_list = array($forum_id);

}

$forum_list[] = 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);

'PAGE_NUMBER' => on_page($total, $config['topics_per_page'], $start),

'TOPIC_ID' => $topic_id,

'TOTAL' => $total,

)

);

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

}

}

'PAGE_NUMBER' => on_page($total, $posts_per_page, $start),

'PAGINATION' => (!$posts_per_page) ? '' : generate_pagination(append_sid("{$phpbb_root_path}mcp.$phpEx", "i=$id&amp;t={$topic_info['topic_id']}&amp;mode=$mode&amp;action=$action&amp;to_topic_id=$to_topic_id&amp;posts_per_page=$posts_per_page&amp;st=$sort_days&amp;sk=$sort_key&amp;sd=$sort_dir"), $total, $posts_per_page, $start),

));

}

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

}

}

'PAGE_NUMBER' => on_page($user_count, $config['topics_per_page'], $start),

'PAGINATION' => generate_pagination(append_sid("{$phpbb_root_path}mcp.$phpEx", "i=warn&amp;mode=list&amp;st=$st&amp;sk=$sk&amp;sd=$sd"), $user_count, $config['topics_per_page'], $start),

));

}

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

}