{

}

}

{

}

}

{

}

}

{

}

}

{

}

}

{

}

}

{

}

}

{

}

}

}

}

}

{

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

$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_FOLDER_IMG_SRC' => $user->img($folder_img, $folder_alt, false, '', 'src'),

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

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

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

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)

{

$sql = $db->sql_build_query('SELECT', array(

'SELECT' => 'r.report_time, p.post_id, p.post_subject, p.post_time, u.username, u.username_clean, u.user_colour, u.user_id, u2.username as author_name, u2.username_clean as author_name_clean, u2.user_colour as author_colour, u2.user_id as author_id, t.topic_id, t.topic_title, f.forum_id, f.forum_name',

AND p.topic_id = t.topic_id

AND r.user_id = u.user_id

AND p.poster_id = u2.user_id

'ORDER_BY' => 'p.post_time DESC'

));

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

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

}

}

}

}

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

}

}

}

}

}

}

}

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

$post_data = $rowset = array();

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

{

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

}

$db->sql_freeresult($result);

{

$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_first_poster_name AS username, t.topic_first_poster_colour AS user_colour

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

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

}

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

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

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

}

}

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

}

}

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

}