WHERE u.user_id <> ' . ANONYMOUS . '

AND u.user_type <> ' . USER_FOUNDER .

((!empty($user_ids)) ? 'AND ' . $db->sql_in_set('p.poster_id', $user_ids) : '') . '

AND u.user_id = p.poster_id

GROUP BY p.poster_id

HAVING queue_posts ' . $key_match[$queue_select] . ' ' . $posts_on_queue;

{

if ($topic_id_ary[$row['topic_id']][ITEM_APPROVED] == $row['topic_posts_approved']

&& $topic_id_ary[$row['topic_id']][ITEM_UNAPPROVED] == $row['topic_posts_unapproved']

&& $topic_id_ary[$row['topic_id']][ITEM_DELETED] == $row['topic_posts_softdeleted'])

{

$move_topic_ary[] = $row['topic_id'];

$sql = 'SELECT COUNT(post_id) as posts_in_queue

FROM ' . POSTS_TABLE . '

WHERE poster_id = ' . $user_id . '

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

$user_row['posts_in_queue'] = (int) $db->sql_fetchfield('posts_in_queue');

$db->sql_freeresult($result);

define('ITEM_UNAPPROVED', 0); // => has not yet been approved

define('ITEM_APPROVED', 1); // => has been approved, and has not been soft deleted

define('ITEM_DELETED', 2); // => has been soft deleted

// Forum Flags

define('FORUM_FLAG_LINK_TRACK', 1);

// Notifications types to delete

$delete_notifications_types = array(

'quote',

'approve_post',

'post_in_queue',

);

ITEM_DELETED => (!empty($topics_softdeleted)) ? ' WHERE ' . $db->sql_in_set('topic_id', $topics_softdeleted) : '',

);

{

if ($sql_where)

{

{

$forum_data[$forum_id]['topics_approved'] = $row['total_topics'];

}

{

$forum_data[$forum_id]['topics_unapproved'] = $row['total_topics'];

}

{

$topic_data[$topic_id]['posts_approved'] = $row['total_posts'];

}

{

$topic_data[$topic_id]['posts_unapproved'] = $row['total_posts'];

}

$topic_data[$topic_id]['first_post_id'] = (!empty($topic_data[$topic_id]['first_post_id'])) ? min($topic_data[$topic_id]['first_post_id'], $row['first_post_id']) : $row['first_post_id'];

$topic_data[$topic_id]['last_post_id'] = max($topic_data[$topic_id]['last_post_id'], $row['last_post_id']);

{

// Soft delete status is stronger than unapproved.

$topic_data[$topic_id]['visibility'] = $row['post_visibility'];

{

$sql_data[FORUMS_TABLE] .= 'forum_posts_approved = forum_posts_approved - 1, forum_topics_approved = forum_topics_approved - 1';

}

{

$sql_data[FORUMS_TABLE] .= 'forum_posts_unapproved = forum_posts_unapproved - 1, forum_topics_unapproved = forum_topics_unapproved - 1';

}

{

$phpbb_content_visibility->remove_post_from_statistic($data, $sql_data);

}

{

$sql_data[FORUMS_TABLE] = (($sql_data[FORUMS_TABLE]) ? $sql_data[FORUMS_TABLE] . ', ' : '') . 'forum_posts_unapproved = forum_posts_unapproved - 1';

$sql_data[TOPICS_TABLE] = (($sql_data[TOPICS_TABLE]) ? $sql_data[TOPICS_TABLE] . ', ' : '') . 'topic_posts_unapproved = topic_posts_unapproved - 1';

{

// Post not approved, but in queue

$post_visibility = ITEM_UNAPPROVED;

}

// MODs/Extensions are able to force any visibility on posts

if (isset($data['force_approved_state']))

{

}

if (isset($data['force_visibility']))

{

}

// Start the transaction here

$first_post_has_topic_info = ($post_mode == 'edit_first_post' &&

(($post_visibility == ITEM_DELETED && $data['topic_posts_softdeleted'] == 1) ||

($post_visibility == ITEM_UNAPPROVED && $data['topic_posts_unapproved'] == 1) ||

($post_visibility == ITEM_APPROVED && $data['topic_posts_approved'] == 1)));

// Fix the post's and topic's visibility and first/last post information, when the post is edited

if (($post_mode != 'post' && $post_mode != 'reply') && $data['post_visibility'] != $post_visibility)

// If the post was not approved, it could also be the starter,

// so we sync the starter after approving/restoring, to ensure that the stats are correct

// Same applies for the last post

$is_latest = ($post_mode == 'edit_last_post' || $post_mode == 'edit_topic' || $data['post_visibility'] != ITEM_APPROVED);

$phpbb_content_visibility = $phpbb_container->get('content.visibility');

case 'edit_first_post':

case 'edit':

case 'edit_last_post':

break;

}

}

{

switch ($mode)

{

case 'post':

case 'reply':

case 'quote':

// Nothing to do here

break;

case 'edit_topic':

case 'edit_first_post':

case 'edit':

case 'edit_last_post':

break;

}

}

$topic_title = censor_text($row['topic_title']);

$posts_unapproved = ($row['topic_visibility'] == ITEM_APPROVED && $row['topic_posts_unapproved'] && $auth->acl_get('m_approve', $row['forum_id'])) ? true : false;

$topic_deleted = $row['topic_visibility'] == ITEM_DELETED;

$u_mcp_queue = ($topic_unapproved || $posts_unapproved) ? $url . '&amp;i=queue&amp;mode=' . (($topic_unapproved) ? 'approve_details' : 'unapproved_posts') . '&amp;t=' . $row['topic_id'] : '';

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

{

$topics_moved++;

}

{

$topics_moved_unapproved++;

}

$total_topics++;

break;

case ITEM_UNAPPROVED:

$total_topics_unapproved++;

break;

case ITEM_DELETED:

$total_posts++;

break;

case ITEM_UNAPPROVED:

$total_posts_unapproved++;

break;

case ITEM_DELETED:

'S_CAN_DELETE_POST' => $auth->acl_get('m_delete', $post_info['forum_id']),

'S_POST_REPORTED' => ($post_info['post_reported']) ? true : false,

'S_POST_DELETED' => ($post_info['post_visibility'] == ITEM_DELETED) ? true : false,

'S_POST_LOCKED' => ($post_info['post_edit_locked']) ? true : false,

'S_USER_NOTES' => true,

if (!empty($topic_id_list))

{

$sql = 'SELECT post_id

FROM ' . POSTS_TABLE . '

AND ' . $db->sql_in_set('topic_id', $topic_id_list);

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

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

'S_POST_DELETED' => ($post_info['post_visibility'] == ITEM_DELETED),

$m_perm = 'm_approve';

$is_topics = ($mode == 'unapproved_topics' || $mode == 'deleted_topics') ? true : false;

$is_restore = ($mode == 'deleted_posts' || $mode == 'deleted_topics') ? true : false;

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

$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

$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

FROM ' . TOPICS_TABLE . ' t

WHERE ' . $db->sql_in_set('forum_id', $forum_list) . '

AND topic_delete_user <> 0

$limit_time_sql

ORDER BY $sort_order_sql";

}

$phpbb_notifications->delete_notifications('post_in_queue', $post_id);

$phpbb_notifications->mark_notifications_read(array(

'quote',

));

$phpbb_notifications->delete_notifications('topic_in_queue', $topic_id);

$phpbb_notifications->mark_notifications_read('quote', $topic_data['post_id'], $user->data['user_id']);

$phpbb_notifications->mark_notifications_read('topic', $topic_id, $user->data['user_id']);

'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_REPORT_CLOSED' => $report['report_closed'],

'S_USER_NOTES' => true,

parse_attachments($topic_info['forum_id'], $message, $attachments[$row['post_id']], $update_count);

}

{

$has_unapproved_posts = true;

}

'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_POST_DELETED' => ($row['post_visibility'] == ITEM_DELETED && $auth->acl_get('m_approve', $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,

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

{

// If split from selected post (split_beyond), we split the unapproved items too.

{

// continue;

}