+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+ 'deleted_topics' => array('title' => 'MCP_QUEUE_DELETED_TOPICS', 'auth' => 'aclf_m_approve', 'cat' => array('MCP_QUEUE')),

+ 'deleted_posts' => array('title' => 'MCP_QUEUE_DELETED_POSTS', 'auth' => 'aclf_m_approve', 'cat' => array('MCP_QUEUE')),

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+ global $request, $phpbb_dispatcher, $phpbb_container;

+ $request->overwrite('sk', null);

+ $request->overwrite('sd', null);

+ $request->overwrite('sk', null, phpbb_request_interface::POST);

+ $request->overwrite('sd', null, phpbb_request_interface::POST);

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

+ $base_url = $url . "&i=$id&action=$action&mode=$mode&sd=$sort_dir&sk=$sort_key&st=$sort_days" . (($merge_select) ? $selected_ids : '');

+ phpbb_generate_template_pagination($template, $base_url, 'pagination', 'start', $forum_topics, $topics_per_page, $start);

+

+ 'S_CAN_RESTORE' => $auth->acl_get('m_approve', $forum_id),

+ 'PAGE_NUMBER' => phpbb_on_page($template, $user, $base_url, $forum_topics, $topics_per_page, $start),

+ 'TOTAL_TOPICS' => $user->lang('VIEW_FORUM_TOPICS', (int) $forum_topics),

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

+

+ $sql = 'SELECT t.topic_id

+ FROM ' . TOPICS_TABLE . ' t

+ WHERE t.forum_id = ' . $forum_id . '

+ AND ' . $phpbb_content_visibility->get_visibility_sql('topic', $forum_id, 't.') . "

+ $topic_tracking_info = get_topic_tracking($forum_id, $topic_list, $topic_rows, array($forum_id => $forum_info['mark_time']));

+ $topic_tracking_info = get_complete_topic_tracking($forum_id, $topic_list);

+ $replies = $phpbb_content_visibility->get_count('topic_posts', $row, $forum_id) - 1;

+ $topic_unapproved = ($row['topic_visibility'] == ITEM_UNAPPROVED && $auth->acl_get('m_approve', $row['forum_id'])) ? true : false;

+ $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 = (!$u_mcp_queue && $topic_deleted) ? $url . '&i=queue&mode=deleted_topics&t=' . $topic_id : $u_mcp_queue;

+ 'TOPIC_IMG_STYLE' => $folder_img,

+ 'DELETED_IMG' => ($topic_deleted) ? $user->img('icon_topic_deleted', 'POSTS_DELETED') : '',

+ 'REPLIES' => $phpbb_content_visibility->get_count('topic_posts', $row, $row['forum_id']) - 1,

+ 'S_TOPIC_DELETED' => $topic_deleted,

+ /**

+ * Modify the topic data before it is assigned to the template in MCP

+ *

+ * @event core.mcp_view_forum_modify_topicrow

+ * @var array row Array with topic data

+ * @var array topic_row Template array with topic data

+ * @since 3.1-A1

+ */

+ $vars = array('row', 'topic_row');

+ extract($phpbb_dispatcher->trigger_event('core.mcp_view_forum_modify_topicrow', compact($vars)));

+

+ $redirect = request_var('redirect', "{$phpbb_root_path}viewtopic.$phpEx?f=$to_forum_id&t=$to_topic_id");

+ meta_refresh(3, $redirect);

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

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

+ AND post_visibility = ' . ITEM_UNAPPROVED;

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

+ AND post_visibility = ' . ITEM_UNAPPROVED . '

+ $sql = 'SELECT p.post_id, p.post_subject, p.post_time, p.post_attachment, p.poster_id, p.post_username, u.username, u.username_clean, u.user_colour, t.topic_id, t.topic_title, t.topic_first_post_id, p.forum_id

+ 'U_MCP_FORUM' => append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=main&mode=forum_view&f=' . $row['forum_id']),

+ 'U_FORUM' => append_sid("{$phpbb_root_path}viewforum.$phpEx", 'f=' . $row['forum_id']),

+ 'FORUM_NAME' => $forum_names[$row['forum_id']],

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

+ 'ATTACH_ICON_IMG' => ($auth->acl_get('u_download') && $auth->acl_get('f_download', $row['forum_id']) && $row['post_attachment']) ? $user->img('icon_topic_attach', $user->lang['TOTAL_ATTACHMENTS']) : '',

+ ));

+ 'L_UNAPPROVED_TOTAL' => $user->lang('UNAPPROVED_POSTS_TOTAL', (int) $total),

+ 'S_HAS_UNAPPROVED_POSTS'=> ($total != 0),

+ AND ' . $db->sql_in_set('p.forum_id', $forum_list);

+ $sql_ary = array(

+ 'SELECT' => 'r.report_time, p.post_id, p.post_subject, p.post_time, p.post_attachment, 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',

+ POSTS_TABLE => 'p',

+ 'ON' => 'f.forum_id = p.forum_id',

+ ),

+ AND ' . $db->sql_in_set('p.forum_id', $forum_list),

+ 'ORDER_BY' => 'p.post_time DESC',

+ );

+ $sql = $db->sql_build_query('SELECT', $sql_ary);

+ 'U_MCP_FORUM' => append_sid("{$phpbb_root_path}mcp.$phpEx", 'f=' . $row['forum_id'] . "&i=$id&mode=forum_view"),

+ 'U_FORUM' => append_sid("{$phpbb_root_path}viewforum.$phpEx", 'f=' . $row['forum_id']),

+ 'FORUM_NAME' => $row['forum_name'],

+ 'ATTACH_ICON_IMG' => ($auth->acl_get('u_download') && $auth->acl_get('f_download', $row['forum_id']) && $row['post_attachment']) ? $user->img('icon_topic_attach', $user->lang['TOTAL_ATTACHMENTS']) : '',

+ $template->assign_vars(array(

+ 'L_REPORTS_TOTAL' => $user->lang('REPORTS_TOTAL', (int) $total),

+ 'S_HAS_REPORTS' => ($total != 0),

+ ));

+ $sql_ary = array(

+ 'SELECT' => 'r.report_id, r.report_time, p.msg_id, p.message_subject, p.message_time, p.to_address, p.bcc_address, p.message_attachment, 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',

+ PRIVMSGS_TABLE => 'p',

+ 'ORDER_BY' => 'p.message_time DESC',

+ );

+ $sql = $db->sql_build_query('SELECT', $sql_ary);

+ 'ATTACH_ICON_IMG' => ($auth->acl_get('u_download') && $row['message_attachment']) ? $user->img('icon_topic_attach', $user->lang['TOTAL_ATTACHMENTS']) : '',

+ $template->assign_vars(array(

+ 'L_PM_REPORTS_TOTAL' => $user->lang('PM_REPORTS_TOTAL', (int) $total),

+ 'S_HAS_PM_REPORTS' => ($total != 0),

+ ));

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+ $base_url = $this->u_action . "&$u_sort_param$keywords_param";

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

+

+ 'PAGE_NUMBER' => phpbb_on_page($template, $user, $base_url, $log_count, $config['topics_per_page'], $start),

+ 'TOTAL' => $user->lang('TOTAL_LOGS', (int) $log_count),

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+ global $config, $phpbb_root_path, $phpEx, $request;

+ // f parameter is not reliable for permission usage, however we just use it to decide

+ // which permission we will check later on. So if it is manipulated, we will still catch it later on.

+ $forum_id = $request->variable('f', 0);

+ $topic_ids = (!$quickmod) ? $request->variable('topic_id_list', array(0)) : array($request->variable('t', 0));

+ $soft_delete = (($request->is_set_post('confirm') && !$request->is_set_post('delete_permanent')) || !$auth->acl_get('m_delete', $forum_id)) ? true : false;

+ mcp_delete_topic($topic_ids, $soft_delete, ($soft_delete) ? $request->variable('delete_reason', '', true) : '');

+ // f parameter is not reliable for permission usage, however we just use it to decide

+ // which permission we will check later on. So if it is manipulated, we will still catch it later on.

+ $forum_id = $request->variable('f', 0);

+ $post_ids = (!$quickmod) ? $request->variable('post_id_list', array(0)) : array($request->variable('p', 0));

+ $soft_delete = (($request->is_set_post('confirm') && !$request->is_set_post('delete_permanent')) || !$auth->acl_get('m_delete', $forum_id)) ? true : false;

+ mcp_delete_post($post_ids, $soft_delete, ($soft_delete) ? $request->variable('delete_reason', '', true) : '');

+ break;

+

+ case 'restore_topic':

+ $user->add_lang('posting');

+

+ $topic_ids = (!$quickmod) ? $request->variable('topic_id_list', array(0)) : array($request->variable('t', 0));

+

+ if (!sizeof($topic_ids))

+ {

+ trigger_error('NO_TOPIC_SELECTED');

+ }

+

+ mcp_restore_topic($topic_ids);

+ $sql = 'UPDATE ' . TOPICS_TABLE . "

+ SET topic_type = $new_topic_type

+ WHERE " . $db->sql_in_set('topic_id', $topic_ids);

+ $db->sql_query($sql);

+

+ if (($new_topic_type == POST_GLOBAL) && sizeof($topic_ids))

+ // Delete topic shadows for global announcements

+ $sql = 'DELETE FROM ' . TOPICS_TABLE . '

+ WHERE ' . $db->sql_in_set('topic_moved_id', $topic_ids);

+ $db->sql_query($sql);

+

+ WHERE " . $db->sql_in_set('topic_id', $topic_ids);

+ confirm_box(false, $l_new_type, build_hidden_fields($s_hidden_fields));

+ global $request;

+ $request->overwrite('confirm', null, phpbb_request_interface::POST);

+ $request->overwrite('confirm_key', null);

+ $topics_moved = $topics_moved_unapproved = $topics_moved_softdeleted = 0;

+ $posts_moved = $posts_moved_unapproved = $posts_moved_softdeleted = 0;

+ if ($topic_info['topic_visibility'] == ITEM_APPROVED)

+ $topics_moved++;

+ elseif ($topic_info['topic_visibility'] == ITEM_UNAPPROVED)

+ $topics_moved_unapproved++;

+ elseif ($topic_info['topic_visibility'] == ITEM_DELETED)

+ {

+ $topics_moved_softdeleted++;

+ }

+

+ $posts_moved += $topic_info['topic_posts_approved'];

+ $posts_moved_unapproved += $topic_info['topic_posts_unapproved'];

+ $posts_moved_softdeleted += $topic_info['topic_posts_softdeleted'];

+ // Move topics, but do not resync yet

+ move_topics($topic_ids, $to_forum_id, false);

+ if ($request->is_set_post('move_lock_topics') && $auth->acl_get('m_lock', $to_forum_id))

+ $sql = 'UPDATE ' . TOPICS_TABLE . '

+ SET topic_status = ' . ITEM_LOCKED . '

+ WHERE ' . $db->sql_in_set('topic_id', $topic_ids);

+ $db->sql_query($sql);

+ $shadow_topics = 0;

+ if ($leave_shadow && $row['topic_visibility'] == ITEM_APPROVED && $row['topic_type'] != POST_GLOBAL)

+ 'topic_visibility' => ITEM_APPROVED, // a shadow topic is always approved

+ 'topic_posts_approved' => (int) $row['topic_posts_approved'],

+ 'topic_posts_unapproved'=> (int) $row['topic_posts_unapproved'],

+ 'topic_posts_softdeleted'=> (int) $row['topic_posts_softdeleted'],

+ $shadow_topics++;

+ $sync_sql = array();

+ if ($posts_moved)

+ $sync_sql[$to_forum_id][] = 'forum_posts_approved = forum_posts_approved + ' . (int) $posts_moved;

+ $sync_sql[$forum_id][] = 'forum_posts_approved = forum_posts_approved - ' . (int) $posts_moved;

+ if ($posts_moved_unapproved)

+ {

+ $sync_sql[$to_forum_id][] = 'forum_posts_unapproved = forum_posts_unapproved + ' . (int) $posts_moved_unapproved;

+ $sync_sql[$forum_id][] = 'forum_posts_unapproved = forum_posts_unapproved - ' . (int) $posts_moved_unapproved;

+ }

+ if ($posts_moved_softdeleted)

+ $sync_sql[$to_forum_id][] = 'forum_posts_softdeleted = forum_posts_softdeleted + ' . (int) $posts_moved_softdeleted;

+ $sync_sql[$forum_id][] = 'forum_posts_softdeleted = forum_posts_softdeleted - ' . (int) $posts_moved_softdeleted;

+ if ($topics_moved)

+ {

+ $sync_sql[$to_forum_id][] = 'forum_topics_approved = forum_topics_approved + ' . (int) $topics_moved;

+ if ($topics_moved - $shadow_topics > 0)

+ {

+ $sync_sql[$forum_id][] = 'forum_topics_approved = forum_topics_approved - ' . (int) ($topics_moved - $shadow_topics);

+ }

+ }

+ if ($topics_moved_unapproved)

+ {

+ $sync_sql[$to_forum_id][] = 'forum_topics_unapproved = forum_topics_unapproved + ' . (int) $topics_moved_unapproved;

+ $sync_sql[$forum_id][] = 'forum_topics_unapproved = forum_topics_unapproved - ' . (int) $topics_moved_unapproved;

+ }

+ if ($topics_moved_softdeleted)

+ $sync_sql[$to_forum_id][] = 'forum_topics_softdeleted = forum_topics_softdeleted + ' . (int) $topics_moved_softdeleted;

+ $sync_sql[$forum_id][] = 'forum_topics_softdeleted = forum_topics_softdeleted - ' . (int) $topics_moved_softdeleted;

+ 'S_CAN_LOCK_TOPIC' => ($auth->acl_get('m_lock', $to_forum_id)) ? true : false,

+* Restore Topics

+*/

+function mcp_restore_topic($topic_ids)

+{

+ global $auth, $user, $db, $phpEx, $phpbb_root_path, $request, $phpbb_container;

+

+ if (!check_ids($topic_ids, TOPICS_TABLE, 'topic_id', array('m_approve')))

+ {

+ return;

+ }

+

+ $redirect = $request->variable('redirect', build_url(array('action', 'quickmod')));

+ $forum_id = $request->variable('f', 0);

+

+ $s_hidden_fields = build_hidden_fields(array(

+ 'topic_id_list' => $topic_ids,

+ 'f' => $forum_id,

+ 'action' => 'restore_topic',

+ 'redirect' => $redirect,

+ ));

+ $success_msg = '';

+

+ if (confirm_box(true))

+ {

+ $success_msg = (sizeof($topic_ids) == 1) ? 'TOPIC_RESTORED_SUCCESS' : 'TOPICS_RESTORED_SUCCESS';

+

+ $data = get_topic_data($topic_ids);

+

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

+ foreach ($data as $topic_id => $row)

+ {

+ $return = $phpbb_content_visibility->set_topic_visibility(ITEM_APPROVED, $topic_id, $row['forum_id'], $user->data['user_id'], time(), '');

+ if (!empty($return))

+ {

+ add_log('mod', $row['forum_id'], $topic_id, 'LOG_RESTORE_TOPIC', $row['topic_title'], $row['topic_first_poster_name']);

+ }

+ }

+ }

+ else

+ {

+ confirm_box(false, (sizeof($topic_ids) == 1) ? 'RESTORE_TOPIC' : 'RESTORE_TOPICS', $s_hidden_fields);

+ }

+

+ $topic_id = $request->variable('t', 0);

+ if (!$request->is_set('quickmod', phpbb_request_interface::REQUEST))

+ {

+ $redirect = $request->variable('redirect', "index.$phpEx");

+ $redirect = reapply_sid($redirect);

+ $redirect_message = 'PAGE';

+ }

+ else if ($topic_id)

+ {

+ $redirect = append_sid("{$phpbb_root_path}viewtopic.$phpEx", 't=' . $topic_id);

+ $redirect_message = 'TOPIC';

+ }

+ else

+ {

+ $redirect = append_sid("{$phpbb_root_path}viewforum.$phpEx", 'f=' . $forum_id);

+ $redirect_message = 'FORUM';

+ }

+

+ if (!$success_msg)

+ {

+ redirect($redirect);

+ }

+ else

+ {

+ meta_refresh(3, $redirect);

+ trigger_error($user->lang[$success_msg] . '<br /><br />' . sprintf($user->lang['RETURN_' . $redirect_message], '<a href="' . $redirect . '">', '</a>'));

+ }

+}

+

+/**

+function mcp_delete_topic($topic_ids, $is_soft = false, $soft_delete_reason = '', $action = 'delete_topic')

+ global $auth, $user, $db, $phpEx, $phpbb_root_path, $request, $phpbb_container;

+ $redirect = $request->variable('redirect', build_url(array('action', 'quickmod')));

+ $forum_id = $request->variable('f', 0);

+ $s_hidden_fields = array(

+ 'action' => $action,

+ 'redirect' => $redirect,

+ // Only soft delete non-shadow topics

+ if ($is_soft)

+ {

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

+ $return = $phpbb_content_visibility->set_topic_visibility(ITEM_DELETED, $topic_id, $row['forum_id'], $user->data['user_id'], time(), $soft_delete_reason);

+ if (!empty($return))

+ {

+ add_log('mod', $row['forum_id'], $topic_id, 'LOG_SOFTDELETE_TOPIC', $row['topic_title'], $row['topic_first_poster_name']);

+ }

+ }

+ else

+ {

+ add_log('mod', $row['forum_id'], $topic_id, 'LOG_DELETE_TOPIC', $row['topic_title'], $row['topic_first_poster_name']);

+ }

+ if (!$is_soft)

+ {

+ $return = delete_topics('topic_id', $topic_ids);

+ }

+ global $template;

+

+ $user->add_lang('posting');

+

+ $only_softdeleted = false;

+ if ($auth->acl_get('m_delete', $forum_id) && $auth->acl_get('m_softdelete', $forum_id))

+ {

+ // If there are only soft deleted topics, we display a message why the option is not available

+ $sql = 'SELECT topic_id

+ FROM ' . TOPICS_TABLE . '

+ WHERE ' . $db->sql_in_set('topic_id', $topic_ids) . '

+ AND topic_visibility <> ' . ITEM_DELETED;

+ $result = $db->sql_query_limit($sql, 1);

+ $only_softdeleted = !$db->sql_fetchfield('topic_id');

+ $db->sql_freeresult($result);

+ }

+

+ $template->assign_vars(array(

+ 'S_SOFTDELETED' => $only_softdeleted,

+ 'S_TOPIC_MODE' => true,

+ 'S_ALLOWED_DELETE' => $auth->acl_get('m_delete', $forum_id),

+ 'S_ALLOWED_SOFTDELETE' => $auth->acl_get('m_softdelete', $forum_id),

+ 'S_DELETE_REASON' => $auth->acl_get('m_softdelete', $forum_id),

+ ));

+

+ $l_confirm = (sizeof($topic_ids) == 1) ? 'DELETE_TOPIC' : 'DELETE_TOPICS';

+ if ($only_softdeleted)

+ {

+ $l_confirm .= '_PERMANENTLY';

+ $s_hidden_fields['delete_permanent'] = '1';

+ }

+ else if (!$auth->acl_get('m_softdelete', $forum_id))

+ {

+ $s_hidden_fields['delete_permanent'] = '1';

+ }

+

+ confirm_box(false, $l_confirm, build_hidden_fields($s_hidden_fields), 'confirm_delete_body.html');

+ $topic_id = $request->variable('t', 0);

+ if (!$request->is_set('quickmod', phpbb_request_interface::REQUEST))

+ $redirect = $request->variable('redirect', "index.$phpEx");

+ else if ($is_soft && $topic_id)

+ {

+ $redirect = append_sid("{$phpbb_root_path}viewtopic.$phpEx", 't=' . $topic_id);

+ $redirect_message = 'TOPIC';

+ }

+function mcp_delete_post($post_ids, $is_soft = false, $soft_delete_reason = '', $action = 'delete_post')

+ global $auth, $user, $db, $phpEx, $phpbb_root_path, $request, $phpbb_container;

+ if (!check_ids($post_ids, POSTS_TABLE, 'post_id', array('m_softdelete')))

+ $redirect = $request->variable('redirect', build_url(array('action', 'quickmod')));

+ $forum_id = $request->variable('f', 0);

+ $s_hidden_fields = array(

+ 'action' => $action,

+ 'redirect' => $redirect,

+ if (confirm_box(true) && $is_soft)

+ {

+ $post_info = get_post_data($post_ids);

+

+ $topic_info = $approve_log = array();

+

+ // Group the posts by topic_id

+ foreach ($post_info as $post_id => $post_data)

+ {

+ if ($post_data['post_visibility'] != ITEM_APPROVED)

+ {

+ continue;

+ }

+ $topic_id = (int) $post_data['topic_id'];

+

+ $topic_info[$topic_id]['posts'][] = (int) $post_id;

+ $topic_info[$topic_id]['forum_id'] = (int) $post_data['forum_id'];

+

+ if ($post_id == $post_data['topic_first_post_id'])

+ {

+ $topic_info[$topic_id]['first_post'] = true;

+ }

+

+ if ($post_id == $post_data['topic_last_post_id'])

+ {

+ $topic_info[$topic_id]['last_post'] = true;

+ }

+

+ $approve_log[] = array(

+ 'forum_id' => $post_data['forum_id'],

+ 'topic_id' => $post_data['topic_id'],

+ 'post_subject' => $post_data['post_subject'],

+ 'poster_id' => $post_data['poster_id'],

+ 'post_username' => $post_data['post_username'],

+ 'username' => $post_data['username'],

+ );

+ }

+

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

+ foreach ($topic_info as $topic_id => $topic_data)

+ {

+ $phpbb_content_visibility->set_post_visibility(ITEM_DELETED, $topic_data['posts'], $topic_id, $topic_data['forum_id'], $user->data['user_id'], time(), $soft_delete_reason, isset($topic_data['first_post']), isset($topic_data['last_post']));

+ }

+ $affected_topics = sizeof($topic_info);

+ // None of the topics is really deleted, so a redirect won't hurt much.

+ $deleted_topics = 0;

+

+ $success_msg = (sizeof($post_info) == 1) ? 'POST_DELETED_SUCCESS' : 'POSTS_DELETED_SUCCESS';

+

+ foreach ($approve_log as $row)

+ {

+ $post_username = ($row['poster_id'] == ANONYMOUS && !empty($row['post_username'])) ? $row['post_username'] : $row['username'];

+ add_log('mod', $row['forum_id'], $row['topic_id'], 'LOG_SOFTDELETE_POST', $row['post_subject'], $post_username);

+ }

+

+ $topic_id = $request->variable('t', 0);

+

+ // Return links

+ $return_link = array();

+ if ($affected_topics == 1 && $topic_id)

+ {

+ $return_link[] = sprintf($user->lang['RETURN_TOPIC'], '<a href="' . append_sid("{$phpbb_root_path}viewtopic.$phpEx", "f=$forum_id&amp;t=$topic_id") . '">', '</a>');

+ }

+ $return_link[] = sprintf($user->lang['RETURN_FORUM'], '<a href="' . append_sid("{$phpbb_root_path}viewforum.$phpEx", 'f=' . $forum_id) . '">', '</a>');

+

+ }

+ else if (confirm_box(true))

+ $topic_id = $request->variable('t', 0);

+ global $template;

+

+ $user->add_lang('posting');

+

+ $only_softdeleted = false;

+ if ($auth->acl_get('m_delete', $forum_id) && $auth->acl_get('m_softdelete', $forum_id))

+ {

+ // If there are only soft deleted posts, we display a message why the option is not available

+ $sql = 'SELECT post_id

+ FROM ' . POSTS_TABLE . '

+ WHERE ' . $db->sql_in_set('post_id', $post_ids) . '

+ AND post_visibility <> ' . ITEM_DELETED;

+ $result = $db->sql_query_limit($sql, 1);

+ $only_softdeleted = !$db->sql_fetchfield('post_id');

+ $db->sql_freeresult($result);

+ }

+

+ $template->assign_vars(array(

+ 'S_SOFTDELETED' => $only_softdeleted,

+ 'S_ALLOWED_DELETE' => $auth->acl_get('m_delete', $forum_id),

+ 'S_ALLOWED_SOFTDELETE' => $auth->acl_get('m_softdelete', $forum_id),

+ 'S_DELETE_REASON' => $auth->acl_get('m_softdelete', $forum_id),

+ ));

+

+ $l_confirm = (sizeof($post_ids) == 1) ? 'DELETE_POST' : 'DELETE_POSTS';

+ if ($only_softdeleted)

+ {

+ $l_confirm .= '_PERMANENTLY';

+ $s_hidden_fields['delete_permanent'] = '1';

+ }

+ else if (!$auth->acl_get('m_softdelete', $forum_id))

+ {

+ $s_hidden_fields['delete_permanent'] = '1';

+ }

+

+ confirm_box(false, $l_confirm, build_hidden_fields($s_hidden_fields), 'confirm_delete_body.html');

+ $redirect = $request->variable('redirect', "index.$phpEx");

+ $request->overwrite('confirm', null, phpbb_request_interface::POST);

+ $request->overwrite('confirm_key', null);

+ $total_topics = $total_topics_unapproved = $total_topics_softdeleted = 0;

+ $total_posts = $total_posts_unapproved = $total_posts_softdeleted = 0;

+ $search_type = $config['search_type'];

+ trigger_error('NO_SUCH_SEARCH_MODULE');

+ $search = new $search_type($error, $phpbb_root_path, $phpEx, $auth, $config, $db, $user);

+ 'topic_visibility' => (int) $topic_row['topic_visibility'],

+ 'topic_posts_approved' => (int) $topic_row['topic_posts_approved'],

+ 'topic_posts_unapproved' => (int) $topic_row['topic_posts_unapproved'],

+ 'topic_posts_softdeleted' => (int) $topic_row['topic_posts_softdeleted'],

+ switch ($topic_row['topic_visibility'])

+ {

+ case ITEM_APPROVED:

+ $total_topics++;

+ break;

+ case ITEM_UNAPPROVED:

+ $total_topics_unapproved++;

+ break;

+ case ITEM_DELETED:

+ $total_topics_softdeleted++;

+ break;

+ }

+

+ 'post_visibility' => (int) $row['post_visibility'],

+ switch ($row['post_visibility'])

+ {

+ case ITEM_APPROVED:

+ $total_posts++;

+ break;

+ case ITEM_UNAPPROVED:

+ $total_posts_unapproved++;

+ break;

+ case ITEM_DELETED:

+ $total_posts_softdeleted++;

+ break;

+ }

+

+ $sql = 'UPDATE ' . FORUMS_TABLE . '

+ SET forum_posts_approved = forum_posts_approved + ' . $total_posts . ',

+ forum_posts_unapproved = forum_posts_unapproved + ' . $total_posts_unapproved . ',

+ forum_posts_softdeleted = forum_posts_softdeleted + ' . $total_posts_softdeleted . ',

+ forum_topics_approved = forum_topics_approved + ' . $total_topics . ',

+ forum_topics_unapproved = forum_topics_unapproved + ' . $total_topics_unapproved . ',

+ forum_topics_softdeleted = forum_topics_softdeleted + ' . $total_topics_softdeleted . '

+ WHERE forum_id = ' . $to_forum_id;

+ $db->sql_query($sql);

+ sync('topic', 'topic_id', $new_topic_id_list);

+

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+ if (!function_exists('phpbb_get_user_avatar'))

+ $avatar_img = phpbb_get_user_avatar($userrow);

+ $base_url = $this->u_action . "&amp;$u_sort_param$keywords_param";

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

+

+ 'PAGE_NUMBER' => phpbb_on_page($template, $user, $base_url, $log_count, $config['topics_per_page'], $start),

+ 'TOTAL_REPORTS' => $user->lang('LIST_REPORTS', (int) $log_count),

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+ global $config, $phpbb_root_path, $phpEx, $action, $phpbb_container;

+ $phpbb_notifications = $phpbb_container->get('notification_manager');

+

+ $phpbb_notifications->mark_notifications_read_by_parent('report_pm', $report_id, $user->data['user_id']);

+

+ $parse_flags = ($pm_info['bbcode_bitfield'] ? OPTION_FLAG_BBCODE : 0) | OPTION_FLAG_SMILIES;

+ $message = generate_text_for_display($pm_info['message_text'], $pm_info['bbcode_uid'], $pm_info['bbcode_bitfield'], $parse_flags, false);

+ 'RECIPIENTS' => implode($user->lang['COMMA_SEPARATOR'], $address_list[$row['msg_id']]),

+ 'ATTACH_ICON_IMG' => ($auth->acl_get('u_download') && $row['message_attachment']) ? $user->img('icon_topic_attach', $user->lang['TOTAL_ATTACHMENTS']) : '',

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

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

+

+ 'PAGE_NUMBER' => phpbb_on_page($template, $user, $base_url, $total, $config['topics_per_page'], $start),

+ 'TOTAL_REPORTS' => $user->lang('LIST_REPORTS', (int) $total),

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+ $parse_flags = ($post_info['bbcode_bitfield'] ? OPTION_FLAG_BBCODE : 0) | OPTION_FLAG_SMILIES;

+ $message = generate_text_for_display($post_info['post_text'], $post_info['bbcode_uid'], $post_info['bbcode_bitfield'], $parse_flags, false);

+ // Deleting information

+ if ($post_info['post_visibility'] == ITEM_DELETED && $post_info['post_delete_user'])

+ {

+ // User having deleted the post also being the post author?

+ if (!$post_info['post_delete_user'] || $post_info['post_delete_user'] == $post_info['poster_id'])

+ {

+ $display_username = get_username_string('full', $post_info['poster_id'], $post_info['username'], $post_info['user_colour'], $post_info['post_username']);

+ }

+ else

+ {

+ $sql = 'SELECT user_id, username, user_colour

+ FROM ' . USERS_TABLE . '

+ WHERE user_id = ' . (int) $post_info['post_delete_user'];

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

+ $user_delete_row = $db->sql_fetchrow($result);

+ $db->sql_freeresult($result);

+ $display_username = get_username_string('full', $post_info['post_delete_user'], $user_delete_row['username'], $user_delete_row['user_colour']);

+ }

+

+ $user->add_lang('viewtopic');

+ $l_deleted_by = $user->lang('DELETED_INFORMATION', $display_username, $user->format_date($post_info['post_delete_time'], false, true));

+ }

+ else

+ {

+ $l_deleted_by = '';

+ }

+

+ 'S_POST_UNAPPROVED' => ($post_info['post_visibility'] == ITEM_UNAPPROVED) ? true : false,

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

+ 'DELETED_MESSAGE' => $l_deleted_by,

+ 'DELETE_REASON' => $post_info['post_delete_reason'],

+ 'DELETED_IMG' => $user->img('icon_topic_deleted', $user->lang['POST_DELETED']),

+ global $auth, $db, $config, $phpbb_root_path, $phpEx, $user;

+ if ($post_info['post_postcount'] && $post_info['post_visibility'] == ITEM_APPROVED)

+ $search_type = $config['search_type'];

+ if (class_exists($search_type))

+ $search = new $search_type($error, $phpbb_root_path, $phpEx, $auth, $config, $db, $user);

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+ public function mcp_queue(&$p_master)

+ public function main($id, $mode)

+ global $auth, $db, $user, $template, $cache, $request;

+ global $config, $phpbb_root_path, $phpEx, $action, $phpbb_container;

+ case 'restore':

+ $post_id_list = $request->variable('post_id_list', array(0));

+ $topic_id_list = $request->variable('topic_id_list', array(0));

+ if (!empty($post_id_list))

+ {

+ self::approve_posts($action, $post_id_list, 'queue', $mode);

+ }

+ else if (!empty($topic_id_list))

+ {

+ self::approve_topics($action, $topic_id_list, 'queue', $mode);

+ }

+ else

+ break;

+

+ case 'delete':

+ $post_id_list = $request->variable('post_id_list', array(0));

+ $topic_id_list = $request->variable('topic_id_list', array(0));

+ if (!empty($post_id_list))

+ {

+ if (!function_exists('mcp_delete_post'))

+ {

+ global $phpbb_root_path, $phpEx;

+ include($phpbb_root_path . 'includes/mcp/mcp_main.' . $phpEx);

+ }

+ mcp_delete_post($post_id_list, false, '', $action);

+ }

+ else if (!empty($topic_id_list))

+ if (!function_exists('mcp_delete_topic'))

+ {

+ global $phpbb_root_path, $phpEx;

+ include($phpbb_root_path . 'includes/mcp/mcp_main.' . $phpEx);

+ }

+ mcp_delete_topic($topic_id_list, false, '', $action);

+ trigger_error('NO_POST_SELECTED');

+ break;

+ case 'disapprove':

+ $post_id_list = $request->variable('post_id_list', array(0));

+ $topic_id_list = $request->variable('topic_id_list', array(0));

+

+ if (!empty($topic_id_list) && $mode == 'deleted_topics')

+ {

+ if (!function_exists('mcp_delete_topics'))

+ {

+ global $phpbb_root_path, $phpEx;

+ include($phpbb_root_path . 'includes/mcp/mcp_main.' . $phpEx);

+ }

+ mcp_delete_topic($topic_id_list, false, '', 'disapprove');

+ return;

+ }

+

+ if (!class_exists('messenger'))

+ {

+ include($phpbb_root_path . 'includes/functions_messenger.' . $phpEx);

+ }

+

+ if (!empty($topic_id_list))

+ {

+ $post_visibility = ($mode == 'deleted_topics') ? ITEM_DELETED : ITEM_UNAPPROVED;

+ $sql = 'SELECT post_id

+ FROM ' . POSTS_TABLE . '

+ WHERE post_visibility = ' . $post_visibility . '

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

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

+

+ $post_id_list = array();

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

+ {

+ $post_id_list[] = (int) $row['post_id'];

+ }

+ $db->sql_freeresult($result);

+ }

+

+ if (!empty($post_id_list))

+ {

+ self::disapprove_posts($post_id_list, 'queue', $mode);

+ }

+ else

+ {

+ trigger_error('NO_POST_SELECTED');

+ }

+ $phpbb_notifications = $phpbb_container->get('notification_manager');

+

+

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

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

+

+ 'TOPIC_TITLE' => $post_info['topic_title'],

+ ));

+ $parse_flags = ($post_info['bbcode_bitfield'] ? OPTION_FLAG_BBCODE : 0) | OPTION_FLAG_SMILIES;

+ $message = generate_text_for_display($post_info['post_text'], $post_info['bbcode_uid'], $post_info['bbcode_bitfield'], $parse_flags, false);

+ 'DISPLAY_ATTACHMENT' => $attachment,

+ ));

+ // Deleting information

+ if ($post_info['post_visibility'] == ITEM_DELETED && $post_info['post_delete_user'])

+ {

+ // User having deleted the post also being the post author?

+ if (!$post_info['post_delete_user'] || $post_info['post_delete_user'] == $post_info['poster_id'])

+ {

+ $display_username = get_username_string('full', $post_info['poster_id'], $post_info['username'], $post_info['user_colour'], $post_info['post_username']);

+ }

+ else

+ {

+ $sql = 'SELECT u.user_id, u.username, u.user_colour

+ FROM ' . POSTS_TABLE . ' p, ' . USERS_TABLE . ' u

+ WHERE p.post_id = ' . $post_info['post_id'] . '

+ AND p.post_delete_user = u.user_id';

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

+ $post_delete_userinfo = $db->sql_fetchrow($result);

+ $db->sql_freeresult($result);

+ $display_username = get_username_string('full', $post_info['post_delete_user'], $post_delete_userinfo['username'], $post_delete_userinfo['user_colour']);

+ }

+

+ $l_deleted_by = $user->lang('DELETED_INFORMATION', $display_username, $user->format_date($post_info['post_delete_time'], false, true));

+ }

+ else

+ {

+ $l_deleted_by = '';

+ }

+

+ 'S_POST_UNAPPROVED' => ($post_info['post_visibility'] == ITEM_UNAPPROVED),

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

+ 'DELETED_MESSAGE' => $l_deleted_by,

+ 'DELETE_REASON' => $post_info['post_delete_reason'],

+

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

+ case 'deleted_topics':

+ case 'deleted_posts':

+ $m_perm = 'm_approve';

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

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

+ $visibility_const = (!$is_restore) ? ITEM_UNAPPROVED : ITEM_DELETED;

+

+ $topic_id = $request->variable('t', 0);

+ $forum_list_approve = get_forum_list($m_perm, false, true);

+ $sql = 'SELECT SUM(forum_topics_approved) as sum_forum_topics

+ FROM ' . FORUMS_TABLE . '

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

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

+ $forum_info = get_forum_data(array($forum_id), $m_perm);

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

+ if (!$is_topics)

+ 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) . '

+ AND p.post_visibility = ' . $visibility_const . '

+ ' . (($sort_order_sql[0] == 'u') ? 'AND u.user_id = p.poster_id' : '') . '

+ AND (t.topic_visibility <> p.post_visibility

+ OR t.topic_delete_user = 0)

+ $sql = 'SELECT t.topic_id, t.topic_title, t.forum_id, p.post_id, p.post_subject, p.post_username, p.poster_id, p.post_time, p.post_attachment, u.username, u.username_clean, u.user_colour

+ $forum_names[] = $row['forum_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_visibility = ' . $visibility_const . "

+ AND topic_delete_user <> 0

+ $forum_names[] = $row['forum_id'];

+ $row['post_username'] = $row['username'] ?: $user->lang['GUEST'];

+ 'U_VIEWFORUM' => append_sid("{$phpbb_root_path}viewforum.$phpEx", 'f=' . $row['forum_id']),

+ 'TOPIC_ID' => $row['topic_id'],

+ 'FORUM_NAME' => $forum_names[$row['forum_id']],

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

+ 'ATTACH_ICON_IMG' => ($auth->acl_get('u_download') && $auth->acl_get('f_download', $row['forum_id']) && $row['post_attachment']) ? $user->img('icon_topic_attach', $user->lang['TOTAL_ATTACHMENTS']) : '',

+ ));

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

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

+

+ 'L_DISPLAY_ITEMS' => (!$is_topics) ? $user->lang['DISPLAY_POSTS'] : $user->lang['DISPLAY_TOPICS'],

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

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

+ 'S_TOPICS' => $is_topics,

+ 'S_RESTORE' => $is_restore,

+ 'PAGE_NUMBER' => phpbb_on_page($template, $user, $base_url, $total, $config['topics_per_page'], $start),

+ 'TOTAL' => $user->lang(((!$is_topics) ? 'VIEW_TOPIC_POSTS' : 'VIEW_FORUM_TOPICS'), (int) $total),

+ /**

+ * Approve/Restore posts

+ *

+ * @param $action string Action we perform on the posts ('approve' or 'restore')

+ * @param $post_id_list array IDs of the posts to approve/restore

+ * @param $id mixed Category of the current active module

+ * @param $mode string Active module

+ * @return null

+ */

+ static public function approve_posts($action, $post_id_list, $id, $mode)

+ global $db, $template, $user, $config, $request, $phpbb_container;

+ global $phpEx, $phpbb_root_path;

+ if (!check_ids($post_id_list, POSTS_TABLE, 'post_id', array('m_approve')))

+ {

+ trigger_error('NOT_AUTHORISED');

+ }

+ $redirect = $request->variable('redirect', build_url(array('quickmod')));

+ $success_msg = $post_url = '';

+ $approve_log = array();

+ $s_hidden_fields = build_hidden_fields(array(

+ 'i' => $id,

+ 'mode' => $mode,

+ 'post_id_list' => $post_id_list,

+ 'action' => $action,

+ 'redirect' => $redirect,

+ ));

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

+ if (confirm_box(true))

+ $notify_poster = ($action == 'approve' && isset($_REQUEST['notify_poster']));

+ $topic_info = array();

+ // Group the posts by topic_id

+ foreach ($post_info as $post_id => $post_data)

+ if ($post_data['post_visibility'] == ITEM_APPROVED)

+ {

+ continue;

+ }

+ $topic_id = (int) $post_data['topic_id'];

+ $topic_info[$topic_id]['posts'][] = (int) $post_id;

+ $topic_info[$topic_id]['forum_id'] = (int) $post_data['forum_id'];

+ // Refresh the first post, if the time or id is older then the current one

+ if ($post_id <= $post_data['topic_first_post_id'] || $post_data['post_time'] <= $post_data['topic_time'])

+ $topic_info[$topic_id]['first_post'] = true;

+

+ // Refresh the last post, if the time or id is newer then the current one

+ if ($post_id >= $post_data['topic_last_post_id'] || $post_data['post_time'] >= $post_data['topic_last_post_time'])

+ {

+ $topic_info[$topic_id]['last_post'] = true;

+ }

+

+ $post_url = append_sid("{$phpbb_root_path}viewtopic.$phpEx", "f={$post_data['forum_id']}&amp;t={$post_data['topic_id']}&amp;p={$post_data['post_id']}") . '#p' . $post_data['post_id'];

+ 'post_subject' => $post_data['post_subject'],

+

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

+ foreach ($topic_info as $topic_id => $topic_data)

+ $phpbb_content_visibility->set_post_visibility(ITEM_APPROVED, $topic_data['posts'], $topic_id, $topic_data['forum_id'], $user->data['user_id'], time(), '', isset($topic_data['first_post']), isset($topic_data['last_post']));

+ if (sizeof($post_info) >= 1)

+ $success_msg = (sizeof($post_info) == 1) ? 'POST_' . strtoupper($action) . 'D_SUCCESS' : 'POSTS_' . strtoupper($action) . 'D_SUCCESS';

+ }

+ foreach ($approve_log as $log_data)

+ {

+ add_log('mod', $log_data['forum_id'], $log_data['topic_id'], 'LOG_POST_' . strtoupper($action) . 'D', $log_data['post_subject']);

+ }

+

+ // Only send out the mails, when the posts are being approved

+ if ($action == 'approve')

+ {

+ $phpbb_notifications = $phpbb_container->get('notification_manager');

+

+ // Handle notifications

+ foreach ($post_info as $post_id => $post_data)

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

+

+ $phpbb_notifications->add_notifications(array(

+ 'quote',

+ 'bookmark',

+ 'post',

+ ), $post_data);

+

+ $phpbb_notifications->mark_notifications_read(array(

+ 'quote',

+ 'bookmark',

+ 'post',

+ ), $post_data['post_id'], $user->data['user_id']);

+

+ // Notify Poster?

+ if ($notify_poster)

+ {

+ if ($post_data['poster_id'] == ANONYMOUS)

+ {

+ continue;

+ }

+

+ $phpbb_notifications->add_notifications('approve_post', $post_data);

+ }

+ else

+ $show_notify = false;

+ if ($action == 'approve')

+ {

+ foreach ($post_info as $post_data)

+ {

+ if ($post_data['poster_id'] == ANONYMOUS)

+ {

+ continue;

+ }

+ else

+ {

+ $show_notify = true;

+ break;

+ }

+ }

+ }

+ $template->assign_vars(array(

+ 'S_NOTIFY_POSTER' => $show_notify,

+ 'S_' . strtoupper($action) => true,

+ ));

+

+ confirm_box(false, strtoupper($action) . '_POST' . ((sizeof($post_id_list) == 1) ? '' : 'S'), $s_hidden_fields, 'mcp_approve.html');

+ $redirect = $request->variable('redirect', "index.$phpEx");

+ $redirect = reapply_sid($redirect);

+ if (!$success_msg)

+ redirect($redirect);

+ else

+ meta_refresh(3, $redirect);

+ // If approving one post, also give links back to post...

+ $add_message = '';

+ if (sizeof($post_info) == 1 && $post_url)

+ $add_message = '<br /><br />' . sprintf($user->lang['RETURN_POST'], '<a href="' . $post_url . '">', '</a>');

+ $message = $user->lang[$success_msg] . '<br /><br />' . sprintf($user->lang['RETURN_PAGE'], '<a href="' . $redirect . '">', '</a>') . $add_message;

+

+ if ($request->is_ajax())

+ $json_response = new phpbb_json_response;

+ $json_response->send(array(

+ 'MESSAGE_TITLE' => $user->lang['INFORMATION'],

+ 'MESSAGE_TEXT' => $message,

+ 'REFRESH_DATA' => null,

+ 'visible' => true,

+ ));

+ trigger_error($message);

+ }

+ /**

+ * Approve/Restore topics

+ *

+ * @param $action string Action we perform on the posts ('approve' or 'restore')

+ * @param $topic_id_list array IDs of the topics to approve/restore

+ * @param $id mixed Category of the current active module

+ * @param $mode string Active module

+ * @return null

+ */

+ static public function approve_topics($action, $topic_id_list, $id, $mode)

+ {

+ global $db, $template, $user, $config;

+ global $phpEx, $phpbb_root_path, $request, $phpbb_container;

+

+ if (!check_ids($topic_id_list, TOPICS_TABLE, 'topic_id', array('m_approve')))

+ trigger_error('NOT_AUTHORISED');

+ $redirect = $request->variable('redirect', build_url(array('quickmod')));

+ $success_msg = $topic_url = '';

+ $approve_log = array();

+ $s_hidden_fields = build_hidden_fields(array(

+ 'i' => $id,

+ 'mode' => $mode,

+ 'topic_id_list' => $topic_id_list,

+ 'action' => $action,

+ 'redirect' => $redirect,

+ ));

+ $topic_info = get_topic_data($topic_id_list, 'm_approve');

+ if (confirm_box(true))

+ {

+ $notify_poster = ($action == 'approve' && isset($_REQUEST['notify_poster'])) ? true : false;

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

+ foreach ($topic_info as $topic_id => $topic_data)

+ {

+ $phpbb_content_visibility->set_topic_visibility(ITEM_APPROVED, $topic_id, $topic_data['forum_id'], $user->data['user_id'], time(), '');

+ $topic_url = append_sid("{$phpbb_root_path}viewtopic.$phpEx", "f={$topic_data['forum_id']}&amp;t={$topic_id}");

+ $approve_log[] = array(

+ 'forum_id' => $topic_data['forum_id'],

+ 'topic_id' => $topic_data['topic_id'],

+ 'topic_title' => $topic_data['topic_title'],

+ if (sizeof($topic_info) >= 1)

+ $success_msg = (sizeof($topic_info) == 1) ? 'TOPIC_' . strtoupper($action) . 'D_SUCCESS' : 'TOPICS_' . strtoupper($action) . 'D_SUCCESS';

+

+ foreach ($approve_log as $log_data)

+ add_log('mod', $log_data['forum_id'], $log_data['topic_id'], 'LOG_TOPIC_' . strtoupper($action) . 'D', $log_data['topic_title']);

+ // Only send out the mails, when the posts are being approved

+ if ($action == 'approve')

+ {

+ // Handle notifications

+ $phpbb_notifications = $phpbb_container->get('notification_manager');

+ foreach ($topic_info as $topic_id => $topic_data)

+ {

+ $phpbb_notifications->delete_notifications('topic_in_queue', $post_data['topic_id']);

+ $phpbb_notifications->add_notifications(array(

+ 'quote',

+ 'topic',

+ ), $post_data);

+

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

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

+

+ if ($notify_poster)

+ {

+ $phpbb_notifications->add_notifications('approve_topic', $post_data);

+ }

+ }

+ }

+ $show_notify = false;

+ if ($action == 'approve')

+ foreach ($topic_info as $topic_data)

+ if ($topic_data['topic_poster'] == ANONYMOUS)

+ {

+ continue;

+ }

+ else

+ {

+ $show_notify = true;

+ break;

+ }

+ $template->assign_vars(array(

+ 'S_NOTIFY_POSTER' => $show_notify,

+ 'S_' . strtoupper($action) => true,

+ ));

+ confirm_box(false, strtoupper($action) . '_TOPIC' . ((sizeof($topic_id_list) == 1) ? '' : 'S'), $s_hidden_fields, 'mcp_approve.html');

+ }

+ $redirect = $request->variable('redirect', "index.$phpEx");

+ $redirect = reapply_sid($redirect);

+ if (!$success_msg)

+ redirect($redirect);

+ else

+ {

+ meta_refresh(3, $redirect);

+ // If approving one topic, also give links back to topic...

+ $add_message = '';

+ if (sizeof($topic_info) == 1 && $topic_url)

+ {

+ $add_message = '<br /><br />' . sprintf($user->lang['RETURN_TOPIC'], '<a href="' . $topic_url . '">', '</a>');

+ }

+ $message = $user->lang[$success_msg] . '<br /><br />' . sprintf($user->lang['RETURN_PAGE'], '<a href="' . $redirect . '">', '</a>') . $add_message;

+ if ($request->is_ajax())

+ {

+ $json_response = new phpbb_json_response;

+ $json_response->send(array(

+ 'MESSAGE_TITLE' => $user->lang['INFORMATION'],

+ 'MESSAGE_TEXT' => $message,

+ 'REFRESH_DATA' => null,

+ 'visible' => true,

+ ));

+ }

+ trigger_error($message);

+ }

+ }

+ /**

+ * Disapprove Post

+ *

+ * @param $post_id_list array IDs of the posts to disapprove/delete

+ * @param $id mixed Category of the current active module

+ * @param $mode string Active module

+ * @return null

+ */

+ static public function disapprove_posts($post_id_list, $id, $mode)

+ global $db, $template, $user, $config, $phpbb_container;

+ global $phpEx, $phpbb_root_path, $request;

+

+ if (!check_ids($post_id_list, POSTS_TABLE, 'post_id', array('m_approve')))

+ trigger_error('NOT_AUTHORISED');

+ $redirect = $request->variable('redirect', build_url(array('t', 'mode', 'quickmod')) . "&amp;mode=$mode");

+ $reason = $request->variable('reason', '', true);

+ $reason_id = $request->variable('reason_id', 0);

+ $success_msg = $additional_msg = '';

+

+ $s_hidden_fields = build_hidden_fields(array(

+ 'i' => $id,

+ 'mode' => $mode,

+ 'post_id_list' => $post_id_list,

+ 'action' => 'disapprove',

+ 'redirect' => $redirect,

+ ));

+

+ $notify_poster = $request->is_set('notify_poster');

+ $disapprove_reason = '';

+

+ if ($reason_id)

+ {

+ $sql = 'SELECT reason_title, reason_description

+ FROM ' . REPORTS_REASONS_TABLE . "

+ WHERE reason_id = $reason_id";

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

+ $row = $db->sql_fetchrow($result);

+ $db->sql_freeresult($result);

+

+ if (!$row || (!$reason && strtolower($row['reason_title']) == 'other'))

+ $additional_msg = $user->lang['NO_REASON_DISAPPROVAL'];

+

+ $request->overwrite('confirm', null, phpbb_request_interface::POST);

+ $request->overwrite('confirm_key', null, phpbb_request_interface::POST);

+ $request->overwrite('confirm_key', null, phpbb_request_interface::REQUEST);

+ else

+ {

+ // If the reason is defined within the language file, we will use the localized version, else just use the database entry...

+ $disapprove_reason = (strtolower($row['reason_title']) != 'other') ? ((isset($user->lang['report_reasons']['DESCRIPTION'][strtoupper($row['reason_title'])])) ? $user->lang['report_reasons']['DESCRIPTION'][strtoupper($row['reason_title'])] : $row['reason_description']) : '';

+ $disapprove_reason .= ($reason) ? "\n\n" . $reason : '';

+ if (isset($user->lang['report_reasons']['DESCRIPTION'][strtoupper($row['reason_title'])]))

+ {

+ $disapprove_reason_lang = strtoupper($row['reason_title']);

+ }

+ }

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

+ $is_disapproving = false;

+ if ($post_data['post_visibility'] == ITEM_DELETED)

+ continue;

+

+ $is_disapproving = true;

+ if (confirm_box(true))

+ $disapprove_log = $disapprove_log_topics = $disapprove_log_posts = array();

+ $topic_posts_unapproved = $post_disapprove_list = $topic_information = array();

+

+ // Build a list of posts to be disapproved and get the related topics real replies count

+ foreach ($post_info as $post_id => $post_data)

+ $post_disapprove_list[$post_id] = $post_data['topic_id'];

+ if (!isset($topic_posts_unapproved[$post_data['topic_id']]))

+ $topic_information[$post_data['topic_id']] = $post_data;

+ $topic_posts_unapproved[$post_data['topic_id']] = 0;

+ $topic_posts_unapproved[$post_data['topic_id']]++;

+

+ // Now we build the log array

+ foreach ($post_disapprove_list as $post_id => $topic_id)

+ // If the count of disapproved posts for the topic is equal

+ // to the number of unapproved posts in the topic, and there are no different

+ // posts, we disapprove the hole topic

+ if ($topic_information[$topic_id]['topic_posts_approved'] == 0 &&

+ $topic_information[$topic_id]['topic_posts_softdeleted'] == 0 &&

+ $topic_information[$topic_id]['topic_posts_unapproved'] == $topic_posts_unapproved[$topic_id])

+ {

+ // Don't write the log more than once for every topic

+ if (!isset($disapprove_log_topics[$topic_id]))

+ {

+ // Build disapproved topics log

+ $disapprove_log_topics[$topic_id] = array(

+ 'type' => 'topic',

+ 'post_subject' => $post_info[$post_id]['topic_title'],

+ 'forum_id' => $post_info[$post_id]['forum_id'],

+ 'topic_id' => 0, // useless to log a topic id, as it will be deleted

+ 'post_username' => ($post_info[$post_id]['poster_id'] == ANONYMOUS && !empty($post_info[$post_id]['post_username'])) ? $post_info[$post_id]['post_username'] : $post_info[$post_id]['username'],

+ );

+ }

+ }

+ else

+ {

+ // Build disapproved posts log

+ $disapprove_log_posts[] = array(

+ 'type' => 'post',

+ 'post_subject' => $post_info[$post_id]['post_subject'],

+ 'forum_id' => $post_info[$post_id]['forum_id'],

+ 'topic_id' => $post_info[$post_id]['topic_id'],

+ 'post_username' => ($post_info[$post_id]['poster_id'] == ANONYMOUS && !empty($post_info[$post_id]['post_username'])) ? $post_info[$post_id]['post_username'] : $post_info[$post_id]['username'],

+ );

+ }

+ // Get disapproved posts/topics counts separately

+ $num_disapproved_topics = sizeof($disapprove_log_topics);

+ $num_disapproved_posts = sizeof($disapprove_log_posts);

+ // Build the whole log

+ $disapprove_log = array_merge($disapprove_log_topics, $disapprove_log_posts);

+ // Unset unneeded arrays

+ unset($post_data, $disapprove_log_topics, $disapprove_log_posts);

+ // Let's do the job - delete disapproved posts

+ if (sizeof($post_disapprove_list))

+ if (!function_exists('delete_posts'))

+ {

+ include($phpbb_root_path . 'includes/functions_admin.' . $phpEx);

+ }

+ // We do not check for permissions here, because the moderator allowed approval/disapproval should be allowed to delete the disapproved posts

+ // Note: function delete_posts triggers related forums/topics sync,

+ // so we don't need to call update_post_information later and to adjust real topic replies or forum topics count manually

+ delete_posts('post_id', array_keys($post_disapprove_list));

+ foreach ($disapprove_log as $log_data)

+ {

+ if ($is_disapproving)

+ {

+ $l_log_message = ($log_data['type'] == 'topic') ? 'LOG_TOPIC_DISAPPROVED' : 'LOG_POST_DISAPPROVED';

+ add_log('mod', $log_data['forum_id'], $log_data['topic_id'], $l_log_message, $log_data['post_subject'], $disapprove_reason);

+ }

+ else

+ {

+ $l_log_message = ($log_data['type'] == 'topic') ? 'LOG_DELETE_TOPIC' : 'LOG_DELETE_POST';

+ add_log('mod', $log_data['forum_id'], $log_data['topic_id'], $l_log_message, $log_data['post_subject'], $log_data['post_username']);

+ }

+ }

+ $phpbb_notifications = $phpbb_container->get('notification_manager');

+ $disapprove_all_posts_in_topic = $topic_information[$topic_id]['topic_posts_approved'] == 0 &&

+ $topic_information[$topic_id]['topic_posts_softdeleted'] == 0 &&

+ $topic_information[$topic_id]['topic_posts_unapproved'] == $topic_posts_unapproved[$topic_id];

+

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

+

+ // Do we disapprove the whole topic? Remove potential notifications

+ if ($disapprove_all_posts_in_topic)

+ $phpbb_notifications->delete_notifications('topic_in_queue', $post_data['topic_id']);

+ // Notify Poster?

+ if ($notify_poster)

+ if ($post_data['poster_id'] == ANONYMOUS)

+ continue;

+ }

+ $post_data['disapprove_reason'] = '';

+ if (isset($disapprove_reason_lang))

+ {

+ // Okay we need to get the reason from the posters language

+ if (!isset($lang_reasons[$post_data['user_lang']]))

+ // Assign the current users translation as the default, this is not ideal but getting the board default adds another layer of complexity.

+ $lang_reasons[$post_data['user_lang']] = $user->lang['report_reasons']['DESCRIPTION'][$disapprove_reason_lang];

+ // Only load up the language pack if the language is different to the current one

+ if ($post_data['user_lang'] != $user->lang_name && file_exists($phpbb_root_path . '/language/' . $post_data['user_lang'] . '/mcp.' . $phpEx))

+ // Load up the language pack

+ $lang = array();

+ @include($phpbb_root_path . '/language/' . basename($post_data['user_lang']) . '/mcp.' . $phpEx);

+

+ // If we find the reason in this language pack use it

+ if (isset($lang['report_reasons']['DESCRIPTION'][$disapprove_reason_lang]))

+ {

+ $lang_reasons[$post_data['user_lang']] = $lang['report_reasons']['DESCRIPTION'][$disapprove_reason_lang];

+ }

+ unset($lang); // Free memory

+ }

+ $post_data['disapprove_reason'] = $lang_reasons[$post_data['user_lang']];

+ $post_data['disapprove_reason'] .= ($reason) ? "\n\n" . $reason : '';

+ }

+ if ($disapprove_all_posts_in_topic && $topic_information[$topic_id]['topic_posts_unapproved'] == 1)

+ {

+ // If there is only 1 post when disapproving the topic,

+ // we send the user a "disapprove topic" notification...

+ $phpbb_notifications->add_notifications('disapprove_topic', $post_data);

+ }

+ else

+ {

+ // ... otherwise there are multiple unapproved posts and

+ // all of them are disapproved as posts.

+ $phpbb_notifications->add_notifications('disapprove_post', $post_data);

+ }

+ }

+ }

+ unset($lang_reasons, $post_info, $disapprove_reason, $disapprove_reason_lang);

+ if ($num_disapproved_topics)

+ {

+ $success_msg = ($num_disapproved_topics == 1) ? 'TOPIC' : 'TOPICS';

+ }

+ else

+ {

+ $success_msg = ($num_disapproved_posts == 1) ? 'POST' : 'POSTS';

+ if ($is_disapproving)

+ {

+ $success_msg .= '_DISAPPROVED_SUCCESS';

+ }

+ else

+ {

+ $success_msg .= '_DELETED_SUCCESS';

+ }

+ if (!function_exists('display_reasons'))

+ {

+ include($phpbb_root_path . 'includes/functions_display.' . $phpEx);

+ }

+ $show_notify = false;

+ foreach ($post_info as $post_data)

+ {

+ if ($post_data['poster_id'] == ANONYMOUS)

+ {

+ continue;

+ }

+ else

+ {

+ $show_notify = true;

+ break;

+ }

+ }

+ $l_confirm_msg = 'DISAPPROVE_POST';

+ $confirm_template = 'mcp_approve.html';

+ if ($is_disapproving)

+ display_reasons($reason_id);

+ $user->add_lang('posting');

+

+ $l_confirm_msg = 'DELETE_POST_PERMANENTLY';

+ $confirm_template = 'confirm_delete_body.html';

+ $l_confirm_msg .= ((sizeof($post_id_list) == 1) ? '' : 'S');

+

+ $template->assign_vars(array(

+ 'S_NOTIFY_POSTER' => $show_notify,

+ 'S_APPROVE' => false,

+ 'REASON' => ($is_disapproving) ? $reason : '',

+ 'ADDITIONAL_MSG' => $additional_msg,

+ ));

+

+ confirm_box(false, $l_confirm_msg, $s_hidden_fields, $confirm_template);

+ $redirect = $request->variable('redirect', "index.$phpEx");

+ $redirect = reapply_sid($redirect);

+ if (!$success_msg)

+ {

+ redirect($redirect);

+ }

+ else

+ {

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

+ if ($request->is_ajax())

+ {

+ $json_response = new phpbb_json_response;

+ $json_response->send(array(

+ 'MESSAGE_TITLE' => $user->lang['INFORMATION'],

+ 'MESSAGE_TEXT' => $message,

+ 'REFRESH_DATA' => null,

+ 'visible' => false,

+ ));

+ }

+ meta_refresh(3, $redirect);

+ trigger_error($message);

+ }

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+ global $config, $phpbb_root_path, $phpEx, $action, $phpbb_container;

+ $sql = 'SELECT r.post_id, r.user_id, r.report_id, r.report_closed, report_time, r.report_text, r.reported_post_text, r.reported_post_uid, r.reported_post_bitfield, r.reported_post_enable_magic_url, r.reported_post_enable_smilies, r.reported_post_enable_bbcode, rr.reason_title, rr.reason_description, u.username, u.username_clean, u.user_colour

+ $phpbb_notifications = $phpbb_container->get('notification_manager');

+

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

+

+

+ $parse_post_flags = $report['reported_post_enable_bbcode'] ? OPTION_FLAG_BBCODE : 0;

+ $parse_post_flags += $report['reported_post_enable_smilies'] ? OPTION_FLAG_SMILIES : 0;

+ $parse_post_flags += $report['reported_post_enable_magic_url'] ? OPTION_FLAG_LINKS : 0;

+ 'TOPIC_TITLE' => $post_info['topic_title'],

+ 'REPORTED_POST_ID' => $post_id,

+ ));

+ parse_attachments($post_info['forum_id'], $report['reported_post_text'], $attachments, $update_count);

+ 'S_POST_UNAPPROVED' => ($post_info['post_visibility'] == ITEM_UNAPPROVED),

+ 'POST_PREVIEW' => generate_text_for_display($report['reported_post_text'], $report['reported_post_uid'], $report['reported_post_bitfield'], $parse_post_flags, false),

+ $sql = 'SELECT SUM(forum_topics_approved) as sum_forum_topics

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

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

+ $sql = 'SELECT t.forum_id, t.topic_id, t.topic_title, p.post_id, p.post_subject, p.post_username, p.poster_id, p.post_time, p.post_attachment, u.username, u.username_clean, u.user_colour, r.user_id as reporter_id, ru.username as reporter_name, ru.user_colour as reporter_colour, r.report_time, r.report_id

+ 'U_VIEWFORUM' => append_sid("{$phpbb_root_path}viewforum.$phpEx", 'f=' . $row['forum_id']),

+ 'FORUM_NAME' => $forum_data[$row['forum_id']]['forum_name'],

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

+ 'ATTACH_ICON_IMG' => ($auth->acl_get('u_download') && $auth->acl_get('f_download', $row['forum_id']) && $row['post_attachment']) ? $user->img('icon_topic_attach', $user->lang['TOTAL_ATTACHMENTS']) : '',

+ ));

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

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

+

+ 'PAGE_NUMBER' => phpbb_on_page($template, $user, $base_url, $total, $config['topics_per_page'], $start),

+ 'TOTAL_REPORTS' => $user->lang('LIST_REPORTS', (int) $total),

+ global $phpEx, $phpbb_root_path, $phpbb_container;

+ $phpbb_notifications = $phpbb_container->get('notification_manager');

+

+ $phpbb_notifications->add_notifications('report_pm_closed', array_merge($post_info[$post_id], array(

+ 'reporter' => $reporter['user_id'],

+ 'closer_id' => $user->data['user_id'],

+ 'from_user_id' => $post_info[$post_id]['author_id'],

+ )));

+

+ $phpbb_notifications->delete_notifications('report_pm', $post_id);

+ $phpbb_notifications->add_notifications('report_post_closed', array_merge($post_info[$post_id], array(

+ 'reporter' => $reporter['user_id'],

+ 'closer_id' => $user->data['user_id'],

+ )));

+ $phpbb_notifications->delete_notifications('report_post', $post_id);

+ }

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+ global $template, $db, $user, $auth, $cache, $phpbb_container;

+ // Restore or pprove posts?

+ if (($action == 'restore' || $action == 'approve') && $auth->acl_get('m_approve', $topic_info['forum_id']))

+ mcp_queue::approve_posts($action, $post_id_list, $id, $mode);

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

+ $total = $phpbb_content_visibility->get_count('topic_posts', $topic_info, $topic_info['forum_id']);

+ p.topic_id = ' . $topic_id . '

+ AND ' . $phpbb_content_visibility->get_visibility_sql('post', $topic_info['forum_id'], 'p.') . '

+ $has_unapproved_posts = $has_deleted_posts = false;

+ $parse_flags = ($row['bbcode_bitfield'] ? OPTION_FLAG_BBCODE : 0) | OPTION_FLAG_SMILIES;

+ $message = generate_text_for_display($message, $row['bbcode_uid'], $row['bbcode_bitfield'], $parse_flags, false);

+ if ($row['post_visibility'] == ITEM_UNAPPROVED)

+ if ($row['post_visibility'] == ITEM_DELETED)

+ {

+ $has_deleted_posts = true;

+ }

+

+ 'S_POST_UNAPPROVED' => ($row['post_visibility'] == ITEM_UNAPPROVED && $auth->acl_get('m_approve', $topic_info['forum_id'])),

+ 'S_POST_DELETED' => ($row['post_visibility'] == ITEM_DELETED && $auth->acl_get('m_approve', $topic_info['forum_id'])),

+ $base_url = append_sid("{$phpbb_root_path}mcp.$phpEx", "i=$id&amp;t={$topic_info['topic_id']}&amp;mode=$mode&amp;action=$action&amp;to_topic_id=$to_topic_id&amp;posts_per_page=$posts_per_page&amp;st=$sort_days&amp;sk=$sort_key&amp;sd=$sort_dir");

+ if ($posts_per_page)

+ {

+ phpbb_generate_template_pagination($template, $base_url, 'pagination', 'start', $total, $posts_per_page, $start);

+ }

+

+ 'DELETED_IMG' => $user->img('icon_topic_deleted', 'POST_DELETED_RESTORE'),

+ 'S_CAN_RESTORE' => ($has_deleted_posts && $auth->acl_get('m_approve', $topic_info['forum_id'])) ? true : false,

+ 'PAGE_NUMBER' => phpbb_on_page($template, $user, $base_url, $total, $posts_per_page, $start),

+ 'TOTAL_POSTS' => $user->lang('VIEW_TOPIC_POSTS', (int) $total),

+ $sql = 'SELECT p.post_id, p.forum_id, p.post_visibility

+ $sql = 'SELECT p.post_id, p.forum_id, p.post_visibility

+ if ($row['post_visibility'] == ITEM_UNAPPROVED && !$auth->acl_get('m_approve', $row['forum_id']))

+ 'forum_id' => $to_forum_id,

+ 'topic_title' => $subject,

+ 'icon_id' => $icon_id,

+ 'topic_visibility' => 1

+ $redirect = request_var('redirect', "{$phpbb_root_path}viewtopic.$phpEx?f=$to_forum_id&amp;t=$to_topic_id");

+ meta_refresh(3, $redirect);

+ $redirect = request_var('redirect', "{$phpbb_root_path}viewtopic.$phpEx?f=$to_forum_id&amp;t=$to_topic_id");

+ meta_refresh(3, $redirect);

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+ $base_url = append_sid("{$phpbb_root_path}mcp.$phpEx", "i=warn&amp;mode=list&amp;st=$st&amp;sk=$sk&amp;sd=$sd");

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

+

+ 'PAGE_NUMBER' => phpbb_on_page($template, $user, $base_url, $user_count, $config['topics_per_page'], $start),

+ 'TOTAL_USERS' => $user->lang('LIST_USERS', (int) $user_count),

+ $auth2 = new phpbb_auth();

+ $parse_flags = OPTION_FLAG_SMILIES | ($row['bbcode_bitfield'] ? OPTION_FLAG_BBCODE : 0);

+ $message = generate_text_for_display($user_row['post_text'], $user_row['bbcode_uid'], $user_row['bbcode_bitfield'], $parse_flags, true);

+ if (!function_exists('phpbb_get_user_avatar'))

+ $avatar_img = phpbb_get_user_avatar($user_row);

+ $auth2 = new phpbb_auth();

+ if (!function_exists('phpbb_get_user_avatar'))

+ $avatar_img = phpbb_get_user_avatar($user_row);