+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+$pagination = $phpbb_container->get('pagination');

+

+ SET forum_posts_approved = forum_posts_approved + 1

+// Is a forum specific topic count required?

+if ($forum_data['forum_topics_per_page'])

+{

+ $config['topics_per_page'] = $forum_data['forum_topics_per_page'];

+}

+

+/* @var $phpbb_content_visibility \phpbb\content_visibility */

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

+

+$topics_count = $phpbb_content_visibility->get_count('forum_topics', $forum_data, $forum_id);

+$start = $pagination->validate_start($start, $config['topics_per_page'], $topics_count);

+

+page_header($forum_data['forum_name'] . ($start ? ' - ' . $user->lang('PAGE_TITLE_NUMBER', $pagination->get_on_page($config['topics_per_page'], $start)) : ''), true, $forum_id);

+ markread('topics', array($forum_id), false, request_var('mark_time', 0));

+ if ($request->is_ajax())

+ {

+ // Tell the ajax script what language vars and URL need to be replaced

+ $data = array(

+ 'NO_UNREAD_POSTS' => $user->lang['NO_UNREAD_POSTS'],

+ 'UNREAD_POSTS' => $user->lang['UNREAD_POSTS'],

+ 'U_MARK_TOPICS' => ($user->data['is_registered'] || $config['load_anon_lastread']) ? append_sid("{$phpbb_root_path}viewforum.$phpEx", 'hash=' . generate_link_hash('global') . "&f=$forum_id&mark=topics&mark_time=" . time()) : '',

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

+ 'MESSAGE_TEXT' => $user->lang['TOPICS_MARKED']

+ );

+ $json_response = new \phpbb\json_response();

+ $json_response->send($data);

+ }

+ trigger_error($user->lang['TOPICS_MARKED'] . '<br /><br />' . sprintf($user->lang['RETURN_FORUM'], '<a href="' . $redirect_url . '">', '</a>'));

+if (!$config['use_system_cron'])

+ $cron = $phpbb_container->get('cron.manager');

+

+ $task = $cron->find_task('cron.task.core.prune_forum');

+ $task->set_forum_data($forum_data);

+

+ if ($task->is_ready())

+ {

+ $url = $task->get_url();

+ $template->assign_var('RUN_CRON_TASK', '<img src="' . $url . '" width="1" height="1" alt="cron" />');

+ }

+ else

+ {

+ // See if we should prune the shadow topics instead

+ $task = $cron->find_task('cron.task.core.prune_shadow_topics');

+ $task->set_forum_data($forum_data);

+

+ if ($task->is_ready())

+ {

+ $url = $task->get_url();

+ $template->assign_var('RUN_CRON_TASK', '<img src="' . $url . '" width="1" height="1" alt="cron" />');

+ }

+ }

+ 'link_toggle' => '',

+ 'title_toggle' => '',

+if ($config['allow_forum_notify'] && $forum_data['forum_type'] == FORUM_POST && ($auth->acl_get('f_subscribe', $forum_id) || $user->data['user_id'] == ANONYMOUS))

+$sort_by_sql = array('a' => 't.topic_first_poster_name', 't' => array('t.topic_last_post_time', 't.topic_last_post_id'), 'r' => (($auth->acl_get('m_approve', $forum_id)) ? 't.topic_posts_approved + t.topic_posts_unapproved + t.topic_posts_softdeleted' : 't.topic_posts_approved'), 's' => 'LOWER(t.topic_title)', 'v' => 't.topic_views');

+ $sql_array = array(

+ 'SELECT' => 'COUNT(t.topic_id) AS num_topics',

+ 'FROM' => array(

+ TOPICS_TABLE => 't',

+ ),

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

+ AND (t.topic_last_post_time >= ' . $min_post_time . '

+ OR t.topic_type = ' . POST_ANNOUNCE . '

+ OR t.topic_type = ' . POST_GLOBAL . ')

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

+ );

+

+ /**

+ * Modify the sort data SQL query for getting additional fields if needed

+ *

+ * @event core.viewforum_modify_sort_data_sql

+ * @var int forum_id The forum_id whose topics are being listed

+ * @var int start Variable containing start for pagination

+ * @var int sort_days The oldest topic displayable in elapsed days

+ * @var string sort_key The sorting by. It is one of the first character of (in low case):

+ * Author, Post time, Replies, Subject, Views

+ * @var string sort_dir Either "a" for ascending or "d" for descending

+ * @var array sql_array The SQL array to get the data of all topics

+ * @since 3.1.9-RC1

+ */

+ $vars = array(

+ 'forum_id',

+ 'start',

+ 'sort_days',

+ 'sort_key',

+ 'sort_dir',

+ 'sql_array',

+ );

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

+

+ $result = $db->sql_query($db->sql_build_query('SELECT', $sql_array));

+ 'MODERATORS' => (!empty($moderators[$forum_id])) ? implode($user->lang['COMMA_SEPARATOR'], $moderators[$forum_id]) : '',

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

+ 'POLL_IMG' => $user->img('icon_topic_poll', 'TOPIC_POLL'),

+ 'U_WATCH_FORUM_LINK' => $s_watching_forum['link'],

+ 'U_WATCH_FORUM_TOGGLE' => $s_watching_forum['link_toggle'],

+ 'S_WATCH_FORUM_TOGGLE' => $s_watching_forum['title_toggle'],

+ 'U_CANONICAL' => generate_board_url() . '/' . append_sid("viewforum.$phpEx", "f=$forum_id" . (($start) ? "&amp;start=$start" : ''), true, ''),

+ 'U_MARK_TOPICS' => ($user->data['is_registered'] || $config['load_anon_lastread']) ? append_sid("{$phpbb_root_path}viewforum.$phpEx", 'hash=' . generate_link_hash('global') . "&amp;f=$forum_id&amp;mark=topics&amp;mark_time=" . time()) : '',

+$rowset = $announcement_list = $topic_list = $global_announce_forums = array();

+/**

+* Event to modify the SQL query before the topic data is retrieved

+*

+* It may also be used to override the above assigned template vars

+*

+* @event core.viewforum_get_topic_data

+* @var array forum_data Array with forum data

+* @var array sql_array The SQL array to get the data of all topics

+* @var int forum_id The forum_id whose topics are being listed

+* @var int topics_count The total number of topics for display

+* @var int sort_days The oldest topic displayable in elapsed days

+* @var string sort_key The sorting by. It is one of the first character of (in low case):

+* Author, Post time, Replies, Subject, Views

+* @var string sort_dir Either "a" for ascending or "d" for descending

+* @since 3.1.0-a1

+* @changed 3.1.0-RC4 Added forum_data var

+* @changed 3.1.4-RC1 Added forum_id, topics_count, sort_days, sort_key and sort_dir vars

+* @changed 3.1.9-RC1 Fix types of properties

+*/

+$vars = array(

+ 'forum_data',

+ 'sql_array',

+ 'forum_id',

+ 'topics_count',

+ 'sort_days',

+ 'sort_key',

+ 'sort_dir',

+);

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

+

+$sql_approved = ' AND ' . $phpbb_content_visibility->get_visibility_sql('topic', $forum_id, 't.');

+ // Get global announcement forums

+ $g_forum_ary = $auth->acl_getf('f_read', true);

+ $g_forum_ary = array_unique(array_keys($g_forum_ary));

+

+ $sql_anounce_array['LEFT_JOIN'] = $sql_array['LEFT_JOIN'];

+ $sql_anounce_array['LEFT_JOIN'][] = array('FROM' => array(FORUMS_TABLE => 'f'), 'ON' => 'f.forum_id = t.forum_id');

+ $sql_anounce_array['SELECT'] = $sql_array['SELECT'] . ', f.forum_name';

+

+ $sql_ary = array(

+ 'SELECT' => $sql_anounce_array['SELECT'],

+ 'LEFT_JOIN' => $sql_anounce_array['LEFT_JOIN'],

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

+ AND t.topic_type = ' . POST_ANNOUNCE . ') OR

+ (' . $db->sql_in_set('t.forum_id', $g_forum_ary) . '

+ AND t.topic_type = ' . POST_GLOBAL . ')',

+ );

+

+ /**

+ * Event to modify the SQL query before the announcement topic ids data is retrieved

+ *

+ * @event core.viewforum_get_announcement_topic_ids_data

+ * @var array forum_data Data about the forum

+ * @var array g_forum_ary Global announcement forums array

+ * @var array sql_anounce_array SQL announcement array

+ * @var array sql_ary SQL query array to get the announcement topic ids data

+ * @var int forum_id The forum ID

+ *

+ * @since 3.1.10-RC1

+ */

+ $vars = array(

+ 'forum_data',

+ 'g_forum_ary',

+ 'sql_anounce_array',

+ 'sql_ary',

+ 'forum_id',

+ );

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

+

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

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

+ // Do not display announcements that are waiting for approval or soft deleted.

+ if ($forum_id != $row['forum_id'])

+ $topics_count++;

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

+ }

+ $db->sql_freeresult($result);

+}

+

+$forum_tracking_info = array();

+

+if ($user->data['is_registered'] && $config['load_db_lastread'])

+{

+ $forum_tracking_info[$forum_id] = $forum_data['mark_time'];

+

+ if (!empty($global_announce_forums))

+ {

+ $sql = 'SELECT forum_id, mark_time

+ FROM ' . FORUMS_TRACK_TABLE . '

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

+ AND user_id = ' . $user->data['user_id'];

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

+

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

+ $forum_tracking_info[$row['forum_id']] = $row['mark_time'];

+ $db->sql_freeresult($result);

+ $direction = (($sort_dir == 'd') ? 'ASC' : 'DESC');

+

+ $sql_limit = $pagination->reverse_limit($start, $sql_limit, $topics_count - sizeof($announcement_list));

+ $sql_start = $pagination->reverse_start($start, $sql_limit, $topics_count - sizeof($announcement_list));

+ $direction = (($sort_dir == 'd') ? 'DESC' : 'ASC');

+if (is_array($sort_by_sql[$sort_key]))

+{

+ $sql_sort_order = implode(' ' . $direction . ', ', $sort_by_sql[$sort_key]) . ' ' . $direction;

+}

+else

+{

+ $sql_sort_order = $sort_by_sql[$sort_key] . ' ' . $direction;

+}

+

+$sql_ary = array(

+ 'SELECT' => 't.topic_id',

+ 'FROM' => array(

+ TOPICS_TABLE => 't',

+ ),

+ 'WHERE' => "$sql_where

+ $sql_limit_time",

+ 'ORDER_BY' => 't.topic_type ' . ((!$store_reverse) ? 'DESC' : 'ASC') . ', ' . $sql_sort_order,

+);

+

+/**

+* Event to modify the SQL query before the topic ids data is retrieved

+*

+* @event core.viewforum_get_topic_ids_data

+* @var array forum_data Data about the forum

+* @var array sql_ary SQL query array to get the topic ids data

+* @var string sql_approved Topic visibility SQL string

+* @var int sql_limit Number of records to select

+* @var string sql_limit_time SQL string to limit topic_last_post_time data

+* @var array sql_sort_order SQL sorting string

+* @var int sql_start Offset point to start selection from

+* @var string sql_where SQL WHERE clause string

+* @var bool store_reverse Flag indicating if we select from the late pages

+*

+* @since 3.1.0-RC4

+*

+* @changed 3.1.3 Added forum_data

+*/

+$vars = array(

+ 'forum_data',

+ 'sql_ary',

+ 'sql_approved',

+ 'sql_limit',

+ 'sql_limit_time',

+ 'sql_sort_order',

+ 'sql_start',

+ 'sql_where',

+ 'store_reverse',

+);

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

+

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

+ // SQL array for obtaining shadow topics

+ $sql_array = array(

+ 'SELECT' => 't.*',

+ 'FROM' => array(

+ TOPICS_TABLE => 't'

+ ),

+ 'WHERE' => $db->sql_in_set('t.topic_id', array_keys($shadow_topic_list)),

+ );

+

+ /**

+ * Event to modify the SQL query before the shadowtopic data is retrieved

+ *

+ * @event core.viewforum_get_shadowtopic_data

+ * @var array sql_array SQL array to get the data of any shadowtopics

+ * @since 3.1.0-a1

+ */

+ $vars = array('sql_array');

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

+

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

+// We need to remove the global announcements from the forums total topic count,

+// otherwise the number is different from the one on the forum list

+$total_topic_count = $topics_count - sizeof($announcement_list);

+

+$base_url = append_sid("{$phpbb_root_path}viewforum.$phpEx", "f=$forum_id" . ((strlen($u_sort_param)) ? "&amp;$u_sort_param" : ''));

+$pagination->generate_template_pagination($base_url, 'pagination', 'start', $total_topic_count, $config['topics_per_page'], $start);

+ 'TOTAL_TOPICS' => ($s_display_active) ? false : $user->lang('VIEW_FORUM_TOPICS', (int) $total_topic_count),

+));

+/**

+* Modify topics data before we display the viewforum page

+*

+* @event core.viewforum_modify_topics_data

+* @var array topic_list Array with current viewforum page topic ids

+* @var array rowset Array with topics data (in topic_id => topic_data format)

+* @var int total_topic_count Forum's total topic count

+* @var int forum_id Forum identifier

+* @since 3.1.0-b3

+* @changed 3.1.11-RC1 Added forum_id

+*/

+$vars = array('topic_list', 'rowset', 'total_topic_count', 'forum_id');

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

+

+ // Generate topic forum list...

+ $topic_forum_list = array();

+ foreach ($rowset as $t_id => $row)

+ if (isset($forum_tracking_info[$row['forum_id']]))

+ $row['forum_mark_time'] = $forum_tracking_info[$row['forum_id']];

+ $topic_forum_list[$row['forum_id']]['forum_mark_time'] = ($config['load_db_lastread'] && $user->data['is_registered'] && isset($row['forum_mark_time'])) ? $row['forum_mark_time'] : 0;

+ $topic_forum_list[$row['forum_id']]['topics'][] = (int) $t_id;

+ }

+

+ if ($config['load_db_lastread'] && $user->data['is_registered'])

+ {

+ foreach ($topic_forum_list as $f_id => $topic_row)

+ $topic_tracking_info += get_topic_tracking($f_id, $topic_row['topics'], $rowset, array($f_id => $topic_row['forum_mark_time']));

+ }

+ else if ($config['load_anon_lastread'] || $user->data['is_registered'])

+ {

+ foreach ($topic_forum_list as $f_id => $topic_row)

+ $topic_tracking_info += get_complete_topic_tracking($f_id, $topic_row['topics']);

+

+ unset($topic_forum_list);

+

+ if (!$s_display_active)

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

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

+ $topic_unapproved = (($row['topic_visibility'] == ITEM_UNAPPROVED || $row['topic_visibility'] == ITEM_REAPPROVE) && $auth->acl_get('m_approve', $row['forum_id']));

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

+

+ $u_mcp_queue = (!$u_mcp_queue && $topic_deleted) ? append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=queue&amp;mode=deleted_topics&amp;t=' . $topic_id, true, $user->session_id) : $u_mcp_queue;

+ $topic_row = array(

+ 'FORUM_ID' => $row['forum_id'],

+ 'FORUM_NAME' => (isset($row['forum_name'])) ? $row['forum_name'] : $forum_data['forum_name'],

+ 'TOPIC_IMG_STYLE' => $folder_img,

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

+ 'S_TOPIC_REPORTED' => (!empty($row['topic_reported']) && $auth->acl_get('m_report', $row['forum_id'])) ? true : false,

+ 'S_TOPIC_DELETED' => $topic_deleted,

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

+ 'U_MCP_REPORT' => append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=reports&amp;mode=reports&amp;f=' . $row['forum_id'] . '&amp;t=' . $topic_id, true, $user->session_id),

+ 'S_TOPIC_TYPE_SWITCH' => ($s_type_switch == $s_type_switch_test) ? -1 : $s_type_switch_test,

+ /**

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

+ *

+ * @event core.viewforum_modify_topicrow

+ * @var array row Array with topic data

+ * @var array topic_row Template array with topic data

+ * @var bool s_type_switch Flag indicating if the topic type is [global] announcement

+ * @var bool s_type_switch_test Flag indicating if the test topic type is [global] announcement

+ * @since 3.1.0-a1

+ *

+ * @changed 3.1.10-RC1 Added s_type_switch, s_type_switch_test

+ */

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

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

+

+ $template->assign_block_vars('topicrow', $topic_row);

+

+ $pagination->generate_template_pagination($view_topic_url, 'topicrow.pagination', 'start', $replies + 1, $config['posts_per_page'], 1, true, true);

+

+ /**

+ * Event after the topic data has been assigned to the template

+ *

+ * @event core.viewforum_topic_row_after

+ * @var array row Array with the topic data

+ * @var array rowset Array with topics data (in topic_id => topic_data format)

+ * @var bool s_type_switch Flag indicating if the topic type is [global] announcement

+ * @var int topic_id The topic ID

+ * @var array topic_list Array with current viewforum page topic ids

+ * @var array topic_row Template array with topic data

+ * @since 3.1.3-RC1

+ */

+ $vars = array(

+ 'row',

+ 'rowset',

+ 's_type_switch',

+ 'topic_id',

+ 'topic_list',

+ 'topic_row',

+ );

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

+