+* @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

+* @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;

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

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

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

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

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

+

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

+ $sql = 'SELECT t.topic_id

+ FROM ' . TOPICS_TABLE . ' t

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

+ ' . (($auth->acl_get('m_approve', $forum_id)) ? '' : 'AND t.topic_approved = 1') . "

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

+ 'TOPIC_IMG_STYLE' => $folder_img,

+ /**

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

+

+ if (!function_exists('phpbb_update_rows_avoiding_duplicates_notify_status'))

+ {

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

+ }

+

+ // Update the topic watch table.

+ phpbb_update_rows_avoiding_duplicates_notify_status($db, TOPICS_WATCH_TABLE, 'topic_id', $topic_ids, $to_topic_id);

+ // Update the bookmarks table.

+ phpbb_update_rows_avoiding_duplicates($db, BOOKMARKS_TABLE, 'topic_id', $topic_ids, $to_topic_id);

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

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

+ $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

+ $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_removed++;

+ $topic_posts_removed += $topic_info['topic_replies'];

+ if ($topic_info['topic_approved'])

+ {

+ $topics_authed_removed++;

+ $topic_posts_removed++;

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

+ }

+

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

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

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

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

+ trigger_error('NO_SUCH_SEARCH_MODULE');

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

+ // Copy topic subscriptions to new topic

+

+ // Copy bookmarks to new topic

+ $sql = 'SELECT user_id

+ FROM ' . BOOKMARKS_TABLE . '

+ WHERE topic_id = ' . $topic_id;

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

+

+ $sql_ary = array();

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

+ {

+ $sql_ary[] = array(

+ 'topic_id' => (int) $new_topic_id,

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

+ );

+ }

+ $db->sql_freeresult($result);

+

+ if (sizeof($sql_ary))

+ {

+ $db->sql_multi_insert(BOOKMARKS_TABLE, $sql_ary);

+ }

+* @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_REPORTS' => $user->lang('LIST_REPORTS', (int) $log_count),

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

+ $report['report_text'] = make_clickable(bbcode_nl2br($report['report_text']));

+ '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 . "&st=$sort_days&sk=$sort_key&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

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

+ $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

+ FROM ' . FORUMS_TABLE . '

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

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

+ $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

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

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

+ 'U_VIEWFORUM' => 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']) : '',

+ ));

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

+

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

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

+ global $request;

+ $forum_id_list[$post_data['forum_id']] = 1;

+ $total_topics++;

+ $total_posts++;

+ // Increment by topic_replies if we approve a topic...

+ // This works because we do not adjust the topic_replies when re-approving a topic after an edit.

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

+ {

+ $total_posts += $post_data['topic_replies'];

+ $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,

+ 'approved' => true

+ ));

+ }

+

+ trigger_error($message);

+ global $request;

+

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

+ $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,

+ 'approved' => false

+ ));

+ }

+

+ trigger_error($message);

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

+ $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

+

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

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

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

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

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

+ }

+

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

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

+ // Copy topic subscriptions to new topic

+ $sql = 'SELECT user_id, notify_status

+ FROM ' . TOPICS_WATCH_TABLE . '

+ WHERE topic_id = ' . $topic_id;

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

+

+ $sql_ary = array();

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

+ {

+ $sql_ary[] = array(

+ 'topic_id' => (int) $to_topic_id,

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

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

+ );

+ }

+ $db->sql_freeresult($result);

+

+ if (sizeof($sql_ary))

+ {

+ $db->sql_multi_insert(TOPICS_WATCH_TABLE, $sql_ary);

+ }

+

+ // Copy bookmarks to new topic

+ $sql = 'SELECT user_id

+ FROM ' . BOOKMARKS_TABLE . '

+ WHERE topic_id = ' . $topic_id;

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

+

+ $sql_ary = array();

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

+ {

+ $sql_ary[] = array(

+ 'topic_id' => (int) $to_topic_id,

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

+ );

+ }

+ $db->sql_freeresult($result);

+

+ if (sizeof($sql_ary))

+ {

+ $db->sql_multi_insert(BOOKMARKS_TABLE, $sql_ary);

+ }

+

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

+ meta_refresh(3, $redirect);

+ if (!function_exists('phpbb_update_rows_avoiding_duplicates_notify_status'))

+ {

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

+ }

+

+ phpbb_update_rows_avoiding_duplicates_notify_status($db, TOPICS_WATCH_TABLE, 'topic_id', $topic_ids, $to_topic_id);

+ // If the topic no longer exist, we will update the bookmarks table.

+ phpbb_update_rows_avoiding_duplicates($db, BOOKMARKS_TABLE, 'topic_id', $topic_id, $to_topic_id);

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

+ $auth2 = new phpbb_auth();