global $phpEx, $phpbb_root_path, $config;

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

// Latest 5 unapproved

$forum_list = get_forum_list('m_approve');

$post_list = array();

if ($total)

{

$sql = 'SELECT forum_id, forum_name

FROM ' . FORUMS_TABLE . '

WHERE forum_id IN (' . implode(', ', $forum_list) . ')';

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

{

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

'U_AUTHOR' => ($row['poster_id'] == ANONYMOUS) ? '' : append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=viewprofile&u=' . $row['poster_id']),

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

'AUTHOR' => ($row['poster_id'] == ANONYMOUS) ? (($row['post_username']) ? $row['post_username'] : $user->lang['GUEST']) : $row['username'],

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

if ($total)

{

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

'SELECT' => 'r.*, p.post_id, p.post_subject, u.username, t.topic_id, t.topic_title, f.forum_id, f.forum_name',

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

{

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

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

'U_REPORTER' => ($row['user_id'] == ANONYMOUS) ? '' : append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=viewprofile&u=' . $row['user_id']),

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

'REPORTER' => ($row['user_id'] == ANONYMOUS) ? $user->lang['GUEST'] : $row['username'],

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

'S_HAS_LOGS' => (!empty($log)) ? true : false)

);

}

?> \ No newline at end of file

$template->assign_vars(array(

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

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

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

'S_CAN_CHGPOSTER' => $auth->acl_get('m_chgposter', $post_info['forum_id']),

'S_USER_NOTES' => true,

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

'U_FIND_MEMBER' => append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=searchuser&form=mcp_chgposter&field=username'),

'U_MCP_WARN_USER' => ($auth->acl_getf_global('m_warn')) ? append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=warn&mode=warn_user&u=' . $post_info['user_id']) : '',

'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_reported', $user->lang['POST_REPORTED']),

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

if ($topic_id)

{

$topic_info = get_topic_data(array($topic_id), 'm_approve');

}

$post_info = get_post_data(array($post_id), 'm_approve');

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

'S_POST_UNAPPROVED' => !$post_info['post_approved'],

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

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

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

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

$sql = 'SELECT SUM(forum_topics) as sum_forum_topics

FROM ' . FORUMS_TABLE . "

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

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

$db->sql_freeresult($result);

}

else

{

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

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

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

if ($mode == 'unapproved_posts')

{

$sql = 'SELECT p.post_id

FROM ' . POSTS_TABLE . ' p, ' . TOPICS_TABLE . ' t' . (($sort_order_sql{0} == 'u') ? ', ' . USERS_TABLE . ' u' : '') . "

AND p.post_approved = 0

" . (($sort_order_sql{0} == 'u') ? 'AND u.user_id = p.poster_id' : '') . '

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

if (sizeof($post_ids))

{

WHERE p.post_id IN (" . implode(', ', $post_ids) . ")

AND t.topic_id = p.topic_id

AND u.user_id = p.poster_id";

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

$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 ($row['poster_id'] == ANONYMOUS)

$s_checkbox = '<input type="checkbox" name="post_id_list[]" value="' . $row['post_id'] . '" />';

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

// Q: Why accessing the topic by a post_id instead of its topic_id?

// A: To prevent the post from being hidden because of wrong encoding or different charset

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

'U_VIEWPROFILE' => ($row['poster_id'] != ANONYMOUS) ? append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=viewprofile&amp;u=' . $row['poster_id']) : '',

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

'POSTER' => $poster,

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

);

}

unset($rowset);

// Now display the page

$template->assign_vars(array(

trigger_error('NOT_AUTHORIZED');

}

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

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

$success_msg = $additional_msg = '';

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

'S_POST_UNAPPROVED' => !$post_info['post_approved'],

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

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

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

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

$forum_info = array();

if ($topic_id)

{

$close_report_topics = array_unique($close_report_topics);

// Get a list of topics that still contain reported posts

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

$keep_report_topics = array();

'S_POST_UNAPPROVED' => ($row['post_approved']) ? false : true,

'U_POST_DETAILS' => "$url&amp;i=$id&amp;p={$row['post_id']}&amp;mode=post_details",

);

unset($rowset[$i]);