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

'deleted_posts' => array('title' => 'MCP_QUEUE_DELETED_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')),

),

case 'unapproved_topics':

case 'unapproved_posts':

case 'deleted_posts':

$m_perm = 'm_approve';

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

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

$base_url = $this->u_action . "&f=$forum_id&st=$sort_days&sk=$sort_key&sd=$sort_dir";

phpbb_generate_template_pagination($template, $base_url, 'pagination', 'start', $total, $config['topics_per_page'], $start);

// Now display the page

$template->assign_vars(array(

'L_EXPLAIN' => $user->lang['MCP_QUEUE_' . strtoupper($mode) . '_EXPLAIN'],

'L_TITLE' => $user->lang['MCP_QUEUE_' . strtoupper($mode)],

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

'i' => $id,

'mode' => $mode,

'post_id_list' => $post_id_list,

$post_info = get_post_data($post_id_list, 'm_approve');

}

/**

* Approve Post/Topic

*/

function approve_posts($post_id_list, $id, $mode)

'MCP_QUEUE_UNAPPROVED_TOPICS_EXPLAIN' => 'This is a list of all topics which require approving before they will be visible to users.',

'MCP_QUEUE_DELETED_POSTS' => 'Deleted posts',

'MCP_QUEUE_DELETED_POSTS_EXPLAIN' => 'This is a list of all posts which have been soft deleted. You can restore or permanently delete the posts from this screen.',

'MCP_VIEW_USER' => 'View warnings for a specific user',

'NO_POST' => 'You have to select a post in order to warn the user for a post.',

'NO_POST_REPORT' => 'This post was not reported.',

'NO_POST_SELECTED' => 'You must select at least one post to perform this action.',

'NO_POSTS_QUEUE' => 'There are no posts waiting for approval.',

'NO_REASON_DISAPPROVAL' => 'Please give an appropriate reason for disapproval.',

'NO_REPORT' => 'No report found',

'NO_REPORT_SELECTED' => 'You must select at least one report to perform this action.',

'NO_TOPIC_ICON' => 'None',

'NO_TOPIC_SELECTED' => 'You must select at least one topic to perform this action.',

'NO_TOPICS_QUEUE' => 'There are no topics waiting for approval.',

'ONLY_TOPIC' => 'Only topic “%s”',

$where_sql " . $db->sql_in_set('p.forum_id', ($forum_id) ? array($forum_id) : array_intersect(get_forum_list('f_read'), get_forum_list('m_approve'))) . '

AND p.post_visibility = ' . $visibility_const . '

AND t.topic_id = p.topic_id

if ($min_time)

{

break;

case 'unapproved_topics':

$type = 'topics';

$default_key = 't';

$default_dir = 'd';

$sql = 'SELECT COUNT(topic_id) AS total

FROM ' . TOPICS_TABLE . "

$where_sql " . $db->sql_in_set('forum_id', ($forum_id) ? array($forum_id) : array_intersect(get_forum_list('f_read'), get_forum_list('m_approve'))) . '

if ($min_time)

{

'S_SELECT_SORT_DAYS' => $s_limit_days)

);

{

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

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

</li>

</ul>

<!-- ELSE -->

<!-- ENDIF -->

</div>