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

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)

break;

}

}

else if ($post_visibility == ITEM_DELETED)

{

switch ($mode)

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

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

}

case 'unapproved_posts':

case 'deleted_posts':

$type = 'posts';

$default_key = 't';

$default_dir = 'd';

FROM ' . POSTS_TABLE . ' p, ' . TOPICS_TABLE . " t

$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

AND t.topic_visibility <> p.post_visibility';

case 'unapproved_topics':

case 'deleted_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)

{

$sql = 'SELECT COUNT(post_id) as posts_in_queue

FROM ' . POSTS_TABLE . '

WHERE poster_id = ' . $user_id . '

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

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

$db->sql_freeresult($result);

/**

* Change visibility status of one post or all posts of a topic

*

* @param $post_id mixed Post ID or array of post IDs to act on,

* if it is empty, all posts of topic_id will be modified

* @param $topic_id int Topic where $post_id is found

* @param $forum_id int Forum where $topic_id is found

* @param $user_id int User performing the action

* @param $time int Timestamp when the action is performed

* @param $is_starter bool Is this the first post of the topic changed?

* @param $is_latest bool Is this the last post of the topic changed?

* @param $limit_visibility mixed Limit updating per topic_id to a certain visibility

* @param $limit_delete_time mixed Limit updating per topic_id to a certain deletion time

*/

public function set_post_visibility($visibility, $post_id, $topic_id, $forum_id, $user_id, $time, $reason, $is_starter, $is_latest, $limit_visibility = false, $limit_delete_time = false)

{

{

return array();

}

// Update users postcounts

foreach ($postcounts as $num_posts => $poster_ids)

{

{

$sql = 'UPDATE ' . $this->users_table . '

SET user_posts = 0

ITEM_APPROVED => 'posts_approved',

ITEM_UNAPPROVED => 'posts_unapproved',

ITEM_DELETED => 'posts_softdeleted',

);

$cur_posts = array_fill_keys($field_alias, 0);

* as soft deleted.

* If you want to update all posts, use the force option.

*

* @param $topic_id mixed Topic ID to act on

* @param $forum_id int Forum where $topic_id is found

* @param $user_id int User performing the action

*/

public function set_topic_visibility($visibility, $topic_id, $forum_id, $user_id, $time, $reason, $force_update_all = false)

{

{

return array();

}

}

else if (!$force_update_all && $original_topic_data['topic_visibility'] == ITEM_APPROVED && $visibility == ITEM_DELETED)

{

$this->set_post_visibility($visibility, false, $topic_id, $forum_id, $user_id, $time, '', true, true, $original_topic_data['topic_visibility']);

}

else

$unread_topic = (isset($topic_tracking_info[$forum_id][$row['topic_id']]) && $row['topic_last_post_time'] > $topic_tracking_info[$forum_id][$row['topic_id']]) ? true : false;

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

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

$u_mcp_queue = ($topic_unapproved || $posts_unapproved) ? append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=queue&amp;mode=' . (($topic_unapproved) ? 'approve_details' : 'unapproved_posts') . "&amp;t=$result_topic_id", true, $user->session_id) : '';

$view_topic_url_params = 'f=' . $row['forum_id'] . '&amp;t=' . $topic_id;

$view_topic_url = append_sid("{$phpbb_root_path}viewtopic.$phpEx", $view_topic_url_params);

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

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

if ($post_id)

{

// are we where we are supposed to be?

{

// If post_id was submitted, we try at least to display the topic as a last resort...

if ($topic_id)

{

$attach_list[] = (int) $row['post_id'];

{

$has_attachments = true;

}

'S_HAS_ATTACHMENTS' => (!empty($attachments[$row['post_id']])) ? true : false,

'S_MULTIPLE_ATTACHMENTS' => !empty($attachments[$row['post_id']]) && sizeof($attachments[$row['post_id']]) > 1,

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

'L_POST_DELETED_MESSAGE' => $l_deleted_message,

'S_POST_REPORTED' => ($row['post_reported'] && $auth->acl_get('m_report', $forum_id)) ? true : false,