/viewforum.php

https://github.com/sietf/sietf.org · PHP · 701 lines · 510 code · 114 blank · 77 comment · 137 complexity · 2c33cd27f33bc7849d50758eb5f1a5c2 MD5 · raw file 

    

  1. <?php
    2. 

  2. /**
    3. 

  3. *
    4. 

  4. * @package phpBB3
    5. 

  5. * @version $Id: viewforum.php 9459 2009-04-17 15:08:09Z acydburn $
    6. 

  6. * @copyright (c) 2005 phpBB Group
    7. 

  7. * @license http://opensource.org/licenses/gpl-license.php GNU Public License
    8. 

  8. *
    9. 

  9. */
    10. 

  10. 

  11. /**
    12. 

  12. * @ignore
    13. 

  13. */
    14. 

  14. define('IN_PHPBB', true);
    15. 

  15. $phpbb_root_path = (defined('PHPBB_ROOT_PATH')) ? PHPBB_ROOT_PATH : './';
    16. 

  16. $phpEx = substr(strrchr(__FILE__, '.'), 1);
    17. 

  17. include($phpbb_root_path . 'common.' . $phpEx);
    18. 

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

  19. 

  20. // Start session
    21. 

  21. $user->session_begin();
    22. 

  22. $auth->acl($user->data);
    23. 

  23. 

  24. // Start initial var setup
    25. 

  25. $forum_id	= request_var('f', 0);
    26. 

  26. $mark_read	= request_var('mark', '');
    27. 

  27. $start		= request_var('start', 0);
    28. 

  28. 

  29. $default_sort_days	= (!empty($user->data['user_topic_show_days'])) ? $user->data['user_topic_show_days'] : 0;
    30. 

  30. $default_sort_key	= (!empty($user->data['user_topic_sortby_type'])) ? $user->data['user_topic_sortby_type'] : 't';
    31. 

  31. $default_sort_dir	= (!empty($user->data['user_topic_sortby_dir'])) ? $user->data['user_topic_sortby_dir'] : 'd';
    32. 

  32. 

  33. $sort_days	= request_var('st', $default_sort_days);
    34. 

  34. $sort_key	= request_var('sk', $default_sort_key);
    35. 

  35. $sort_dir	= request_var('sd', $default_sort_dir);
    36. 

  36. 

  37. // Check if the user has actually sent a forum ID with his/her request
    38. 

  38. // If not give them a nice error page.
    39. 

  39. if (!$forum_id)
    40. 

  40. {
    41. 

  41. 	trigger_error('NO_FORUM');
    42. 

  42. }
    43. 

  43. 

  44. $sql_from = FORUMS_TABLE . ' f';
    45. 

  45. $lastread_select = '';
    46. 

  46. 

  47. // Grab appropriate forum data
    48. 

  48. if ($config['load_db_lastread'] && $user->data['is_registered'])
    49. 

  49. {
    50. 

  50. 	$sql_from .= ' LEFT JOIN ' . FORUMS_TRACK_TABLE . ' ft ON (ft.user_id = ' . $user->data['user_id'] . '
    51. 

  51. 		AND ft.forum_id = f.forum_id)';
    52. 

  52. 	$lastread_select .= ', ft.mark_time';
    53. 

  53. }
    54. 

  54. 

  55. if ($user->data['is_registered'])
    56. 

  56. {
    57. 

  57. 	$sql_from .= ' LEFT JOIN ' . FORUMS_WATCH_TABLE . ' fw ON (fw.forum_id = f.forum_id AND fw.user_id = ' . $user->data['user_id'] . ')';
    58. 

  58. 	$lastread_select .= ', fw.notify_status';
    59. 

  59. }
    60. 

  60. 

  61. $sql = "SELECT f.* $lastread_select
    62. 

  62. 	FROM $sql_from
    63. 

  63. 	WHERE f.forum_id = $forum_id";
    64. 

  64. $result = $db->sql_query($sql);
    65. 

  65. $forum_data = $db->sql_fetchrow($result);
    66. 

  66. $db->sql_freeresult($result);
    67. 

  67. 

  68. if (!$forum_data)
    69. 

  69. {
    70. 

  70. 	trigger_error('NO_FORUM');
    71. 

  71. }
    72. 

  72. 

  73. 

  74. // Configure style, language, etc.
    75. 

  75. $user->setup('viewforum', $forum_data['forum_style']);
    76. 

  76. 

  77. // Redirect to login upon emailed notification links
    78. 

  78. if (isset($_GET['e']) && !$user->data['is_registered'])
    79. 

  79. {
    80. 

  80. 	login_box('', $user->lang['LOGIN_NOTIFY_FORUM']);
    81. 

  81. }
    82. 

  82. 

  83. // Permissions check
    84. 

  84. if (!$auth->acl_gets('f_list', 'f_read', $forum_id) || ($forum_data['forum_type'] == FORUM_LINK && $forum_data['forum_link'] && !$auth->acl_get('f_read', $forum_id)))
    85. 

  85. {
    86. 

  86. 	if ($user->data['user_id'] != ANONYMOUS)
    87. 

  87. 	{
    88. 

  88. 		trigger_error('SORRY_AUTH_READ');
    89. 

  89. 	}
    90. 

  90. 

  91. 	login_box('', $user->lang['LOGIN_VIEWFORUM']);
    92. 

  92. }
    93. 

  93. 

  94. // Forum is passworded ... check whether access has been granted to this
    95. 

  95. // user this session, if not show login box
    96. 

  96. if ($forum_data['forum_password'])
    97. 

  97. {
    98. 

  98. 	login_forum_box($forum_data);
    99. 

  99. }
    100. 

  100. 

  101. // Is this forum a link? ... User got here either because the
    102. 

  102. // number of clicks is being tracked or they guessed the id
    103. 

  103. if ($forum_data['forum_type'] == FORUM_LINK && $forum_data['forum_link'])
    104. 

  104. {
    105. 

  105. 	// Does it have click tracking enabled?
    106. 

  106. 	if ($forum_data['forum_flags'] & FORUM_FLAG_LINK_TRACK)
    107. 

  107. 	{
    108. 

  108. 		$sql = 'UPDATE ' . FORUMS_TABLE . '
    109. 

  109. 			SET forum_posts = forum_posts + 1
    110. 

  110. 			WHERE forum_id = ' . $forum_id;
    111. 

  111. 		$db->sql_query($sql);
    112. 

  112. 	}
    113. 

  113. 

  114. 	// We redirect to the url. The third parameter indicates that external redirects are allowed.
    115. 

  115. 	redirect($forum_data['forum_link'], false, true);
    116. 

  116. 	return;
    117. 

  117. }
    118. 

  118. 

  119. // Build navigation links
    120. 

  120. generate_forum_nav($forum_data);
    121. 

  121. 

  122. // Forum Rules
    123. 

  123. if ($auth->acl_get('f_read', $forum_id))
    124. 

  124. {
    125. 

  125. 	generate_forum_rules($forum_data);
    126. 

  126. }
    127. 

  127. 

  128. // Do we have subforums?
    129. 

  129. $active_forum_ary = $moderators = array();
    130. 

  130. 

  131. if ($forum_data['left_id'] != $forum_data['right_id'] - 1)
    132. 

  132. {
    133. 

  133. 	list($active_forum_ary, $moderators) = display_forums($forum_data, $config['load_moderators'], $config['load_moderators']);
    134. 

  134. }
    135. 

  135. else
    136. 

  136. {
    137. 

  137. 	$template->assign_var('S_HAS_SUBFORUM', false);
    138. 

  138. 	get_moderators($moderators, $forum_id);
    139. 

  139. }
    140. 

  140. 

  141. // Dump out the page header and load viewforum template
    142. 

  142. page_header($user->lang['VIEW_FORUM'] . ' - ' . $forum_data['forum_name']);
    143. 

  143. 

  144. $template->set_filenames(array(
    145. 

  145. 	'body' => 'viewforum_body.html')
    146. 

  146. );
    147. 

  147. 

  148. make_jumpbox(append_sid("{$phpbb_root_path}viewforum.$phpEx"), $forum_id);
    149. 

  149. 

  150. $template->assign_vars(array(
    151. 

  151. 	'U_VIEW_FORUM'			=> append_sid("{$phpbb_root_path}viewforum.$phpEx", "f=$forum_id&amp;start=$start"),
    152. 

  152. ));
    153. 

  153. 

  154. // Not postable forum or showing active topics?
    155. 

  155. if (!($forum_data['forum_type'] == FORUM_POST || (($forum_data['forum_flags'] & FORUM_FLAG_ACTIVE_TOPICS) && $forum_data['forum_type'] == FORUM_CAT)))
    156. 

  156. {
    157. 

  157. 	page_footer();
    158. 

  158. }
    159. 

  159. 

  160. // Ok, if someone has only list-access, we only display the forum list.
    161. 

  161. // We also make this circumstance available to the template in case we want to display a notice. ;)
    162. 

  162. if (!$auth->acl_get('f_read', $forum_id))
    163. 

  163. {
    164. 

  164. 	$template->assign_vars(array(
    165. 

  165. 		'S_NO_READ_ACCESS'		=> true,
    166. 

  166. 		'S_AUTOLOGIN_ENABLED'	=> ($config['allow_autologin']) ? true : false,
    167. 

  167. 		'S_LOGIN_ACTION'		=> append_sid("{$phpbb_root_path}ucp.$phpEx", 'mode=login') . '&amp;redirect=' . urlencode(str_replace('&amp;', '&', build_url())),
    168. 

  168. 	));
    169. 

  169. 

  170. 	page_footer();
    171. 

  171. }
    172. 

  172. 

  173. // Handle marking posts
    174. 

  174. if ($mark_read == 'topics')
    175. 

  175. {
    176. 

  176. 	$token = request_var('hash', '');
    177. 

  177. 	if (check_link_hash($token, 'global'))
    178. 

  178. 	{
    179. 

  179. 		markread('topics', $forum_id);
    180. 

  180. 	}
    181. 

  181. 	$redirect_url = append_sid("{$phpbb_root_path}viewforum.$phpEx", 'f=' . $forum_id);
    182. 

  182. 	meta_refresh(3, $redirect_url);
    183. 

  183. 

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

  185. }
    186. 

  186. 

  187. // Is a forum specific topic count required?
    188. 

  188. if ($forum_data['forum_topics_per_page'])
    189. 

  189. {
    190. 

  190. 	$config['topics_per_page'] = $forum_data['forum_topics_per_page'];
    191. 

  191. }
    192. 

  192. 

  193. // Do the forum Prune thang - cron type job ...
    194. 

  194. if ($forum_data['prune_next'] < time() && $forum_data['enable_prune'])
    195. 

  195. {
    196. 

  196. 	$template->assign_var('RUN_CRON_TASK', '<img src="' . append_sid($phpbb_root_path . 'cron.' . $phpEx, 'cron_type=prune_forum&amp;f=' . $forum_id) . '" alt="cron" width="1" height="1" />');
    197. 

  197. }
    198. 

  198. 

  199. // Forum rules and subscription info
    200. 

  200. $s_watching_forum = array(
    201. 

  201. 	'link'			=> '',
    202. 

  202. 	'title'			=> '',
    203. 

  203. 	'is_watching'	=> false,
    204. 

  204. );
    205. 

  205. 

  206. if (($config['email_enable'] || $config['jab_enable']) && $config['allow_forum_notify'] && $forum_data['forum_type'] == FORUM_POST && $auth->acl_get('f_subscribe', $forum_id))
    207. 

  207. {
    208. 

  208. 	$notify_status = (isset($forum_data['notify_status'])) ? $forum_data['notify_status'] : NULL;
    209. 

  209. 	watch_topic_forum('forum', $s_watching_forum, $user->data['user_id'], $forum_id, 0, $notify_status);
    210. 

  210. }
    211. 

  211. 

  212. $s_forum_rules = '';
    213. 

  213. gen_forum_auth_level('forum', $forum_id, $forum_data['forum_status']);
    214. 

  214. 

  215. // Topic ordering options
    216. 

  216. $limit_days = array(0 => $user->lang['ALL_TOPICS'], 1 => $user->lang['1_DAY'], 7 => $user->lang['7_DAYS'], 14 => $user->lang['2_WEEKS'], 30 => $user->lang['1_MONTH'], 90 => $user->lang['3_MONTHS'], 180 => $user->lang['6_MONTHS'], 365 => $user->lang['1_YEAR']);
    217. 

  217. 

  218. $sort_by_text = array('a' => $user->lang['AUTHOR'], 't' => $user->lang['POST_TIME'], 'r' => $user->lang['REPLIES'], 's' => $user->lang['SUBJECT'], 'v' => $user->lang['VIEWS']);
    219. 

  219. $sort_by_sql = array('a' => 't.topic_first_poster_name', 't' => 't.topic_last_post_time', 'r' => 't.topic_replies', 's' => 't.topic_title', 'v' => 't.topic_views');
    220. 

  220. 

  221. $s_limit_days = $s_sort_key = $s_sort_dir = $u_sort_param = '';
    222. 

  222. gen_sort_selects($limit_days, $sort_by_text, $sort_days, $sort_key, $sort_dir, $s_limit_days, $s_sort_key, $s_sort_dir, $u_sort_param, $default_sort_days, $default_sort_key, $default_sort_dir);
    223. 

  223. 

  224. // Limit topics to certain time frame, obtain correct topic count
    225. 

  225. // global announcements must not be counted, normal announcements have to
    226. 

  226. // be counted, as forum_topics(_real) includes them
    227. 

  227. if ($sort_days)
    228. 

  228. {
    229. 

  229. 	$min_post_time = time() - ($sort_days * 86400);
    230. 

  230. 

  231. 	$sql = 'SELECT COUNT(topic_id) AS num_topics
    232. 

  232. 		FROM ' . TOPICS_TABLE . "
    233. 

  233. 		WHERE forum_id = $forum_id
    234. 

  234. 			AND ((topic_type <> " . POST_GLOBAL . " AND topic_last_post_time >= $min_post_time)
    235. 

  235. 				OR topic_type = " . POST_ANNOUNCE . ")
    236. 

  236. 		" . (($auth->acl_get('m_approve', $forum_id)) ? '' : 'AND topic_approved = 1');
    237. 

  237. 	$result = $db->sql_query($sql);
    238. 

  238. 	$topics_count = (int) $db->sql_fetchfield('num_topics');
    239. 

  239. 	$db->sql_freeresult($result);
    240. 

  240. 

  241. 	if (isset($_POST['sort']))
    242. 

  242. 	{
    243. 

  243. 		$start = 0;
    244. 

  244. 	}
    245. 

  245. 	$sql_limit_time = "AND t.topic_last_post_time >= $min_post_time";
    246. 

  246. 

  247. 	// Make sure we have information about day selection ready
    248. 

  248. 	$template->assign_var('S_SORT_DAYS', true);
    249. 

  249. }
    250. 

  250. else
    251. 

  251. {
    252. 

  252. 	$topics_count = ($auth->acl_get('m_approve', $forum_id)) ? $forum_data['forum_topics_real'] : $forum_data['forum_topics'];
    253. 

  253. 	$sql_limit_time = '';
    254. 

  254. }
    255. 

  255. 

  256. // Make sure $start is set to the last page if it exceeds the amount
    257. 

  257. if ($start < 0 || $start > $topics_count)
    258. 

  258. {
    259. 

  259. 	$start = ($start < 0) ? 0 : floor(($topics_count - 1) / $config['topics_per_page']) * $config['topics_per_page'];
    260. 

  260. }
    261. 

  261. 

  262. // Basic pagewide vars
    263. 

  263. $post_alt = ($forum_data['forum_status'] == ITEM_LOCKED) ? $user->lang['FORUM_LOCKED'] : $user->lang['POST_NEW_TOPIC'];
    264. 

  264. 

  265. // Display active topics?
    266. 

  266. $s_display_active = ($forum_data['forum_type'] == FORUM_CAT && ($forum_data['forum_flags'] & FORUM_FLAG_ACTIVE_TOPICS)) ? true : false;
    267. 

  267. 

  268. $template->assign_vars(array(
    269. 

  269. 	'MODERATORS'	=> (!empty($moderators[$forum_id])) ? implode(', ', $moderators[$forum_id]) : '',
    270. 

  270. 

  271. 	'POST_IMG'					=> ($forum_data['forum_status'] == ITEM_LOCKED) ? $user->img('button_topic_locked', $post_alt) : $user->img('button_topic_new', $post_alt),
    272. 

  272. 	'NEWEST_POST_IMG'			=> $user->img('icon_topic_newest', 'VIEW_NEWEST_POST'),
    273. 

  273. 	'LAST_POST_IMG'				=> $user->img('icon_topic_latest', 'VIEW_LATEST_POST'),
    274. 

  274. 	'FOLDER_IMG'				=> $user->img('topic_read', 'NO_NEW_POSTS'),
    275. 

  275. 	'FOLDER_NEW_IMG'			=> $user->img('topic_unread', 'NEW_POSTS'),
    276. 

  276. 	'FOLDER_HOT_IMG'			=> $user->img('topic_read_hot', 'NO_NEW_POSTS_HOT'),
    277. 

  277. 	'FOLDER_HOT_NEW_IMG'		=> $user->img('topic_unread_hot', 'NEW_POSTS_HOT'),
    278. 

  278. 	'FOLDER_LOCKED_IMG'			=> $user->img('topic_read_locked', 'NO_NEW_POSTS_LOCKED'),
    279. 

  279. 	'FOLDER_LOCKED_NEW_IMG'		=> $user->img('topic_unread_locked', 'NEW_POSTS_LOCKED'),
    280. 

  280. 	'FOLDER_STICKY_IMG'			=> $user->img('sticky_read', 'POST_STICKY'),
    281. 

  281. 	'FOLDER_STICKY_NEW_IMG'		=> $user->img('sticky_unread', 'POST_STICKY'),
    282. 

  282. 	'FOLDER_ANNOUNCE_IMG'		=> $user->img('announce_read', 'POST_ANNOUNCEMENT'),
    283. 

  283. 	'FOLDER_ANNOUNCE_NEW_IMG'	=> $user->img('announce_unread', 'POST_ANNOUNCEMENT'),
    284. 

  284. 	'FOLDER_MOVED_IMG'			=> $user->img('topic_moved', 'TOPIC_MOVED'),
    285. 

  285. 	'REPORTED_IMG'				=> $user->img('icon_topic_reported', 'TOPIC_REPORTED'),
    286. 

  286. 	'UNAPPROVED_IMG'			=> $user->img('icon_topic_unapproved', 'TOPIC_UNAPPROVED'),
    287. 

  287. 	'GOTO_PAGE_IMG'				=> $user->img('icon_post_target', 'GOTO_PAGE'),
    288. 

  288. 

  289. 	'L_NO_TOPICS' 			=> ($forum_data['forum_status'] == ITEM_LOCKED) ? $user->lang['POST_FORUM_LOCKED'] : $user->lang['NO_TOPICS'],
    290. 

  290. 

  291. 	'S_DISPLAY_POST_INFO'	=> ($forum_data['forum_type'] == FORUM_POST && ($auth->acl_get('f_post', $forum_id) || $user->data['user_id'] == ANONYMOUS)) ? true : false,
    292. 

  292. 

  293. 	'S_IS_POSTABLE'			=> ($forum_data['forum_type'] == FORUM_POST) ? true : false,
    294. 

  294. 	'S_USER_CAN_POST'		=> ($auth->acl_get('f_post', $forum_id)) ? true : false,
    295. 

  295. 	'S_DISPLAY_ACTIVE'		=> $s_display_active,
    296. 

  296. 	'S_SELECT_SORT_DIR'		=> $s_sort_dir,
    297. 

  297. 	'S_SELECT_SORT_KEY'		=> $s_sort_key,
    298. 

  298. 	'S_SELECT_SORT_DAYS'	=> $s_limit_days,
    299. 

  299. 	'S_TOPIC_ICONS'			=> ($s_display_active && sizeof($active_forum_ary)) ? max($active_forum_ary['enable_icons']) : (($forum_data['enable_icons']) ? true : false),
    300. 

  300. 	'S_WATCH_FORUM_LINK'	=> $s_watching_forum['link'],
    301. 

  301. 	'S_WATCH_FORUM_TITLE'	=> $s_watching_forum['title'],
    302. 

  302. 	'S_WATCHING_FORUM'		=> $s_watching_forum['is_watching'],
    303. 

  303. 	'S_FORUM_ACTION'		=> append_sid("{$phpbb_root_path}viewforum.$phpEx", "f=$forum_id&amp;start=$start"),
    304. 

  304. 	'S_DISPLAY_SEARCHBOX'	=> ($auth->acl_get('u_search') && $auth->acl_get('f_search', $forum_id) && $config['load_search']) ? true : false,
    305. 

  305. 	'S_SEARCHBOX_ACTION'	=> append_sid("{$phpbb_root_path}search.$phpEx", 'fid[]=' . $forum_id),
    306. 

  306. 	'S_SINGLE_MODERATOR'	=> (!empty($moderators[$forum_id]) && sizeof($moderators[$forum_id]) > 1) ? false : true,
    307. 

  307. 	'S_IS_LOCKED'			=> ($forum_data['forum_status'] == ITEM_LOCKED) ? true : false,
    308. 

  308. 	'S_VIEWFORUM'			=> true,
    309. 

  309. 

  310. 	'U_MCP'				=> ($auth->acl_get('m_', $forum_id)) ? append_sid("{$phpbb_root_path}mcp.$phpEx", "f=$forum_id&amp;i=main&amp;mode=forum_view", true, $user->session_id) : '',
    311. 

  311. 	'U_POST_NEW_TOPIC'	=> ($auth->acl_get('f_post', $forum_id) || $user->data['user_id'] == ANONYMOUS) ? append_sid("{$phpbb_root_path}posting.$phpEx", 'mode=post&amp;f=' . $forum_id) : '',
    312. 

  312. 	'U_VIEW_FORUM'		=> append_sid("{$phpbb_root_path}viewforum.$phpEx", "f=$forum_id" . ((strlen($u_sort_param)) ? "&amp;$u_sort_param" : '') . "&amp;start=$start"),
    313. 

  313. 	'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") : '',
    314. 

  314. ));
    315. 

  315. 

  316. // Grab icons
    317. 

  317. $icons = $cache->obtain_icons();
    318. 

  318. 

  319. // Grab all topic data
    320. 

  320. $rowset = $announcement_list = $topic_list = $global_announce_list = array();
    321. 

  321. 

  322. $sql_array = array(
    323. 

  323. 	'SELECT'	=> 't.*',
    324. 

  324. 	'FROM'		=> array(
    325. 

  325. 		TOPICS_TABLE		=> 't'
    326. 

  326. 	),
    327. 

  327. 	'LEFT_JOIN'	=> array(),
    328. 

  328. );
    329. 

  329. 

  330. $sql_approved = ($auth->acl_get('m_approve', $forum_id)) ? '' : 'AND t.topic_approved = 1';
    331. 

  331. 

  332. if ($user->data['is_registered'])
    333. 

  333. {
    334. 

  334. 	if ($config['load_db_track'])
    335. 

  335. 	{
    336. 

  336. 		$sql_array['LEFT_JOIN'][] = array('FROM' => array(TOPICS_POSTED_TABLE => 'tp'), 'ON' => 'tp.topic_id = t.topic_id AND tp.user_id = ' . $user->data['user_id']);
    337. 

  337. 		$sql_array['SELECT'] .= ', tp.topic_posted';
    338. 

  338. 	}
    339. 

  339. 

  340. 	if ($config['load_db_lastread'])
    341. 

  341. 	{
    342. 

  342. 		$sql_array['LEFT_JOIN'][] = array('FROM' => array(TOPICS_TRACK_TABLE => 'tt'), 'ON' => 'tt.topic_id = t.topic_id AND tt.user_id = ' . $user->data['user_id']);
    343. 

  343. 		$sql_array['SELECT'] .= ', tt.mark_time';
    344. 

  344. 

  345. 		if ($s_display_active && sizeof($active_forum_ary))
    346. 

  346. 		{
    347. 

  347. 			$sql_array['LEFT_JOIN'][] = array('FROM' => array(FORUMS_TRACK_TABLE => 'ft'), 'ON' => 'ft.forum_id = t.forum_id AND ft.user_id = ' . $user->data['user_id']);
    348. 

  348. 			$sql_array['SELECT'] .= ', ft.mark_time AS forum_mark_time';
    349. 

  349. 		}
    350. 

  350. 	}
    351. 

  351. }
    352. 

  352. 

  353. if ($forum_data['forum_type'] == FORUM_POST)
    354. 

  354. {
    355. 

  355. 	// Obtain announcements ... removed sort ordering, sort by time in all cases
    356. 

  356. 	$sql = $db->sql_build_query('SELECT', array(
    357. 

  357. 		'SELECT'	=> $sql_array['SELECT'],
    358. 

  358. 		'FROM'		=> $sql_array['FROM'],
    359. 

  359. 		'LEFT_JOIN'	=> $sql_array['LEFT_JOIN'],
    360. 

  360. 

  361. 		'WHERE'		=> 't.forum_id IN (' . $forum_id . ', 0)
    362. 

  362. 			AND t.topic_type IN (' . POST_ANNOUNCE . ', ' . POST_GLOBAL . ')',
    363. 

    364. 

  364. 		'ORDER_BY'	=> 't.topic_time DESC',
    365. 

  365. 	));
    366. 

  366. 	$result = $db->sql_query($sql);
    367. 

  367. 

  368. 	while ($row = $db->sql_fetchrow($result))
    369. 

  369. 	{
    370. 

  370. 		$rowset[$row['topic_id']] = $row;
    371. 

  371. 		$announcement_list[] = $row['topic_id'];
    372. 

  372. 

  373. 		if ($row['topic_type'] == POST_GLOBAL)
    374. 

  374. 		{
    375. 

  375. 			$global_announce_list[$row['topic_id']] = true;
    376. 

  376. 		}
    377. 

  377. 		else
    378. 

  378. 		{
    379. 

  379. 			$topics_count--;
    380. 

  380. 		}
    381. 

  381. 	}
    382. 

  382. 	$db->sql_freeresult($result);
    383. 

  383. }
    384. 

  384. 

  385. // If the user is trying to reach late pages, start searching from the end
    386. 

  386. $store_reverse = false;
    387. 

  387. $sql_limit = $config['topics_per_page'];
    388. 

  388. if ($start > $topics_count / 2)
    389. 

  389. {
    390. 

  390. 	$store_reverse = true;
    391. 

  391. 

  392. 	if ($start + $config['topics_per_page'] > $topics_count)
    393. 

  393. 	{
    394. 

  394. 		$sql_limit = min($config['topics_per_page'], max(1, $topics_count - $start));
    395. 

  395. 	}
    396. 

  396. 

  397. 	// Select the sort order
    398. 

  398. 	$sql_sort_order = $sort_by_sql[$sort_key] . ' ' . (($sort_dir == 'd') ? 'ASC' : 'DESC');
    399. 

  399. 	$sql_start = max(0, $topics_count - $sql_limit - $start);
    400. 

  400. }
    401. 

  401. else
    402. 

  402. {
    403. 

  403. 	// Select the sort order
    404. 

  404. 	$sql_sort_order = $sort_by_sql[$sort_key] . ' ' . (($sort_dir == 'd') ? 'DESC' : 'ASC');
    405. 

  405. 	$sql_start = $start;
    406. 

  406. }
    407. 

  407. 

  408. if ($forum_data['forum_type'] == FORUM_POST || !sizeof($active_forum_ary))
    409. 

  409. {
    410. 

  410. 	$sql_where = 't.forum_id = ' . $forum_id;
    411. 

  411. }
    412. 

  412. else if (empty($active_forum_ary['exclude_forum_id']))
    413. 

  413. {
    414. 

  414. 	$sql_where = $db->sql_in_set('t.forum_id', $active_forum_ary['forum_id']);
    415. 

  415. }
    416. 

  416. else
    417. 

  417. {
    418. 

  418. 	$get_forum_ids = array_diff($active_forum_ary['forum_id'], $active_forum_ary['exclude_forum_id']);
    419. 

  419. 	$sql_where = (sizeof($get_forum_ids)) ? $db->sql_in_set('t.forum_id', $get_forum_ids) : 't.forum_id = ' . $forum_id;
    420. 

  420. }
    421. 

  421. 

  422. // Grab just the sorted topic ids
    423. 

  423. $sql = 'SELECT t.topic_id
    424. 

  424. 	FROM ' . TOPICS_TABLE . " t
    425. 

  425. 	WHERE $sql_where
    426. 

  426. 		AND t.topic_type IN (" . POST_NORMAL . ', ' . POST_STICKY . ")
    427. 

  427. 		$sql_approved
    428. 

  428. 		$sql_limit_time
    429. 

  429. 	ORDER BY t.topic_type " . ((!$store_reverse) ? 'DESC' : 'ASC') . ', ' . $sql_sort_order;
    430. 

  430. $result = $db->sql_query_limit($sql, $sql_limit, $sql_start);
    431. 

  431. 

  432. while ($row = $db->sql_fetchrow($result))
    433. 

  433. {
    434. 

  434. 	$topic_list[] = (int) $row['topic_id'];
    435. 

  435. }
    436. 

  436. $db->sql_freeresult($result);
    437. 

  437. 

  438. // For storing shadow topics
    439. 

  439. $shadow_topic_list = array();
    440. 

  440. 

  441. if (sizeof($topic_list))
    442. 

  442. {
    443. 

  443. 	// SQL array for obtaining topics/stickies
    444. 

  444. 	$sql_array = array(
    445. 

  445. 		'SELECT'		=> $sql_array['SELECT'],
    446. 

  446. 		'FROM'			=> $sql_array['FROM'],
    447. 

  447. 		'LEFT_JOIN'		=> $sql_array['LEFT_JOIN'],
    448. 

  448. 

  449. 		'WHERE'			=> $db->sql_in_set('t.topic_id', $topic_list),
    450. 

  450. 	);
    451. 

  451. 

  452. 	// If store_reverse, then first obtain topics, then stickies, else the other way around...
    453. 

  453. 	// Funnily enough you typically save one query if going from the last page to the middle (store_reverse) because
    454. 

  454. 	// the number of stickies are not known
    455. 

  455. 	$sql = $db->sql_build_query('SELECT', $sql_array);
    456. 

  456. 	$result = $db->sql_query($sql);
    457. 

  457. 

  458. 	while ($row = $db->sql_fetchrow($result))
    459. 

  459. 	{
    460. 

  460. 		if ($row['topic_status'] == ITEM_MOVED)
    461. 

  461. 		{
    462. 

  462. 			$shadow_topic_list[$row['topic_moved_id']] = $row['topic_id'];
    463. 

  463. 		}
    464. 

  464. 

  465. 		$rowset[$row['topic_id']] = $row;
    466. 

  466. 	}
    467. 

  467. 	$db->sql_freeresult($result);
    468. 

  468. }
    469. 

  469. 

  470. // If we have some shadow topics, update the rowset to reflect their topic information
    471. 

  471. if (sizeof($shadow_topic_list))
    472. 

  472. {
    473. 

  473. 	$sql = 'SELECT *
    474. 

  474. 		FROM ' . TOPICS_TABLE . '
    475. 

  475. 		WHERE ' . $db->sql_in_set('topic_id', array_keys($shadow_topic_list));
    476. 

  476. 	$result = $db->sql_query($sql);
    477. 

  477. 

  478. 	while ($row = $db->sql_fetchrow($result))
    479. 

  479. 	{
    480. 

  480. 		$orig_topic_id = $shadow_topic_list[$row['topic_id']];
    481. 

  481. 

  482. 		// If the shadow topic is already listed within the rowset (happens for active topics for example), then do not include it...
    483. 

  483. 		if (isset($rowset[$row['topic_id']]))
    484. 

  484. 		{
    485. 

  485. 			// We need to remove any trace regarding this topic. :)
    486. 

  486. 			unset($rowset[$orig_topic_id]);
    487. 

  487. 			unset($topic_list[array_search($orig_topic_id, $topic_list)]);
    488. 

  488. 			$topics_count--;
    489. 

  489. 

  490. 			continue;
    491. 

  491. 		}
    492. 

  492. 

  493. 		// Do not include those topics the user has no permission to access
    494. 

  494. 		if (!$auth->acl_get('f_read', $row['forum_id']))
    495. 

  495. 		{
    496. 

  496. 			// We need to remove any trace regarding this topic. :)
    497. 

  497. 			unset($rowset[$orig_topic_id]);
    498. 

  498. 			unset($topic_list[array_search($orig_topic_id, $topic_list)]);
    499. 

  499. 			$topics_count--;
    500. 

  500. 

  501. 			continue;
    502. 

  502. 		}
    503. 

  503. 

  504. 		// We want to retain some values
    505. 

  505. 		$row = array_merge($row, array(
    506. 

  506. 			'topic_moved_id'	=> $rowset[$orig_topic_id]['topic_moved_id'],
    507. 

  507. 			'topic_status'		=> $rowset[$orig_topic_id]['topic_status'],
    508. 

  508. 			'topic_type'		=> $rowset[$orig_topic_id]['topic_type'],
    509. 

  509. 		));
    510. 

  510. 

  511. 		// Shadow topics are never reported
    512. 

  512. 		$row['topic_reported'] = 0;
    513. 

  513. 

  514. 		$rowset[$orig_topic_id] = $row;
    515. 

  515. 	}
    516. 

  516. 	$db->sql_freeresult($result);
    517. 

  517. }
    518. 

  518. unset($shadow_topic_list);
    519. 

  519. 

  520. // Ok, adjust topics count for active topics list
    521. 

  521. if ($s_display_active)
    522. 

  522. {
    523. 

  523. 	$topics_count = 1;
    524. 

  524. }
    525. 

  525. 

  526. $template->assign_vars(array(
    527. 

  527. 	'PAGINATION'	=> generate_pagination(append_sid("{$phpbb_root_path}viewforum.$phpEx", "f=$forum_id" . ((strlen($u_sort_param)) ? "&amp;$u_sort_param" : '')), $topics_count, $config['topics_per_page'], $start),
    528. 

  528. 	'PAGE_NUMBER'	=> on_page($topics_count, $config['topics_per_page'], $start),
    529. 

  529. 	'TOTAL_TOPICS'	=> ($s_display_active) ? false : (($topics_count == 1) ? $user->lang['VIEW_FORUM_TOPIC'] : sprintf($user->lang['VIEW_FORUM_TOPICS'], $topics_count)))
    530. 

  530. );
    531. 

  531. 

  532. $topic_list = ($store_reverse) ? array_merge($announcement_list, array_reverse($topic_list)) : array_merge($announcement_list, $topic_list);
    533. 

  533. $topic_tracking_info = $tracking_topics = array();
    534. 

  534. 

  535. // Okay, lets dump out the page ...
    536. 

  536. if (sizeof($topic_list))
    537. 

  537. {
    538. 

  538. 	$mark_forum_read = true;
    539. 

  539. 	$mark_time_forum = 0;
    540. 

  540. 

  541. 	// Active topics?
    542. 

  542. 	if ($s_display_active && sizeof($active_forum_ary))
    543. 

  543. 	{
    544. 

  544. 		// Generate topic forum list...
    545. 

  545. 		$topic_forum_list = array();
    546. 

  546. 		foreach ($rowset as $t_id => $row)
    547. 

  547. 		{
    548. 

  548. 			$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;
    549. 

  549. 			$topic_forum_list[$row['forum_id']]['topics'][] = $t_id;
    550. 

  550. 		}
    551. 

  551. 

  552. 		if ($config['load_db_lastread'] && $user->data['is_registered'])
    553. 

  553. 		{
    554. 

  554. 			foreach ($topic_forum_list as $f_id => $topic_row)
    555. 

  555. 			{
    556. 

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

  557. 			}
    558. 

  558. 		}
    559. 

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

  560. 		{
    561. 

  561. 			foreach ($topic_forum_list as $f_id => $topic_row)
    562. 

  562. 			{
    563. 

  563. 				$topic_tracking_info += get_complete_topic_tracking($f_id, $topic_row['topics'], false);
    564. 

  564. 			}
    565. 

  565. 		}
    566. 

  566. 

  567. 		unset($topic_forum_list);
    568. 

  568. 	}
    569. 

  569. 	else
    570. 

  570. 	{
    571. 

  571. 		if ($config['load_db_lastread'] && $user->data['is_registered'])
    572. 

  572. 		{
    573. 

  573. 			$topic_tracking_info = get_topic_tracking($forum_id, $topic_list, $rowset, array($forum_id => $forum_data['mark_time']), $global_announce_list);
    574. 

  574. 			$mark_time_forum = (!empty($forum_data['mark_time'])) ? $forum_data['mark_time'] : $user->data['user_lastmark'];
    575. 

  575. 		}
    576. 

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

  577. 		{
    578. 

  578. 			$topic_tracking_info = get_complete_topic_tracking($forum_id, $topic_list, $global_announce_list);
    579. 

  579. 

  580. 			if (!$user->data['is_registered'])
    581. 

  581. 			{
    582. 

  582. 				$user->data['user_lastmark'] = (isset($tracking_topics['l'])) ? (int) (base_convert($tracking_topics['l'], 36, 10) + $config['board_startdate']) : 0;
    583. 

  583. 			}
    584. 

  584. 			$mark_time_forum = (isset($tracking_topics['f'][$forum_id])) ? (int) (base_convert($tracking_topics['f'][$forum_id], 36, 10) + $config['board_startdate']) : $user->data['user_lastmark'];
    585. 

  585. 		}
    586. 

  586. 	}
    587. 

  587. 

  588. 	$s_type_switch = 0;
    589. 

  589. 	foreach ($topic_list as $topic_id)
    590. 

  590. 	{
    591. 

  591. 		$row = &$rowset[$topic_id];
    592. 

  592. 

  593. 		// This will allow the style designer to output a different header
    594. 

  594. 		// or even separate the list of announcements from sticky and normal topics
    595. 

  595. 		$s_type_switch_test = ($row['topic_type'] == POST_ANNOUNCE || $row['topic_type'] == POST_GLOBAL) ? 1 : 0;
    596. 

  596. 

  597. 		// Replies
    598. 

  598. 		$replies = ($auth->acl_get('m_approve', $forum_id)) ? $row['topic_replies_real'] : $row['topic_replies'];
    599. 

  599. 

  600. 		if ($row['topic_status'] == ITEM_MOVED)
    601. 

  601. 		{
    602. 

  602. 			$topic_id = $row['topic_moved_id'];
    603. 

  603. 			$unread_topic = false;
    604. 

  604. 		}
    605. 

  605. 		else
    606. 

  606. 		{
    607. 

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

  608. 		}
    609. 

  609. 

  610. 		// Get folder img, topic status/type related information
    611. 

  611. 		$folder_img = $folder_alt = $topic_type = '';
    612. 

  612. 		topic_status($row, $replies, $unread_topic, $folder_img, $folder_alt, $topic_type);
    613. 

  613. 

  614. 		// Generate all the URIs ...
    615. 

  615. 		$view_topic_url_params = 'f=' . (($row['forum_id']) ? $row['forum_id'] : $forum_id) . '&amp;t=' . $topic_id;
    616. 

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

  617. 

  618. 		$topic_unapproved = (!$row['topic_approved'] && $auth->acl_get('m_approve', $forum_id)) ? true : false;
    619. 

  619. 		$posts_unapproved = ($row['topic_approved'] && $row['topic_replies'] < $row['topic_replies_real'] && $auth->acl_get('m_approve', $forum_id)) ? true : false;
    620. 

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

  621. 

  622. 		// Send vars to template
    623. 

  623. 		$template->assign_block_vars('topicrow', array(
    624. 

  624. 			'FORUM_ID'					=> $forum_id,
    625. 

  625. 			'TOPIC_ID'					=> $topic_id,
    626. 

  626. 			'TOPIC_AUTHOR'				=> get_username_string('username', $row['topic_poster'], $row['topic_first_poster_name'], $row['topic_first_poster_colour']),
    627. 

  627. 			'TOPIC_AUTHOR_COLOUR'		=> get_username_string('colour', $row['topic_poster'], $row['topic_first_poster_name'], $row['topic_first_poster_colour']),
    628. 

  628. 			'TOPIC_AUTHOR_FULL'			=> get_username_string('full', $row['topic_poster'], $row['topic_first_poster_name'], $row['topic_first_poster_colour']),
    629. 

  629. 			'FIRST_POST_TIME'			=> $user->format_date($row['topic_time']),
    630. 

  630. 			'LAST_POST_SUBJECT'			=> censor_text($row['topic_last_post_subject']),
    631. 

  631. 			'LAST_POST_TIME'			=> $user->format_date($row['topic_last_post_time']),
    632. 

  632. 			'LAST_VIEW_TIME'			=> $user->format_date($row['topic_last_view_time']),
    633. 

  633. 			'LAST_POST_AUTHOR'			=> get_username_string('username', $row['topic_last_poster_id'], $row['topic_last_poster_name'], $row['topic_last_poster_colour']),
    634. 

  634. 			'LAST_POST_AUTHOR_COLOUR'	=> get_username_string('colour', $row['topic_last_poster_id'], $row['topic_last_poster_name'], $row['topic_last_poster_colour']),
    635. 

  635. 			'LAST_POST_AUTHOR_FULL'		=> get_username_string('full', $row['topic_last_poster_id'], $row['topic_last_poster_name'], $row['topic_last_poster_colour']),
    636. 

  636. 

  637. 			'PAGINATION'		=> topic_generate_pagination($replies, $view_topic_url),
    638. 

  638. 			'REPLIES'			=> $replies,
    639. 

  639. 			'VIEWS'				=> $row['topic_views'],
    640. 

  640. 			'TOPIC_TITLE'		=> censor_text($row['topic_title']),
    641. 

  641. 			'TOPIC_TYPE'		=> $topic_type,
    642. 

  642. 

  643. 			'TOPIC_FOLDER_IMG'		=> $user->img($folder_img, $folder_alt),
    644. 

  644. 			'TOPIC_FOLDER_IMG_SRC'	=> $user->img($folder_img, $folder_alt, false, '', 'src'),
    645. 

  645. 			'TOPIC_FOLDER_IMG_ALT'	=> $user->lang[$folder_alt],
    646. 

  646. 			'TOPIC_FOLDER_IMG_WIDTH'=> $user->img($folder_img, '', false, '', 'width'),
    647. 

  647. 			'TOPIC_FOLDER_IMG_HEIGHT'	=> $user->img($folder_img, '', false, '', 'height'),
    648. 

  648. 

  649. 			'TOPIC_ICON_IMG'		=> (!empty($icons[$row['icon_id']])) ? $icons[$row['icon_id']]['img'] : '',
    650. 

  650. 			'TOPIC_ICON_IMG_WIDTH'	=> (!empty($icons[$row['icon_id']])) ? $icons[$row['icon_id']]['width'] : '',
    651. 

  651. 			'TOPIC_ICON_IMG_HEIGHT'	=> (!empty($icons[$row['icon_id']])) ? $icons[$row['icon_id']]['height'] : '',
    652. 

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

  653. 			'UNAPPROVED_IMG'		=> ($topic_unapproved || $posts_unapproved) ? $user->img('icon_topic_unapproved', ($topic_unapproved) ? 'TOPIC_UNAPPROVED' : 'POSTS_UNAPPROVED') : '',
    654. 

  654. 

  655. 			'S_TOPIC_TYPE'			=> $row['topic_type'],
    656. 

  656. 			'S_USER_POSTED'			=> (isset($row['topic_posted']) && $row['topic_posted']) ? true : false,
    657. 

  657. 			'S_UNREAD_TOPIC'		=> $unread_topic,
    658. 

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

  659. 			'S_TOPIC_UNAPPROVED'	=> $topic_unapproved,
    660. 

  660. 			'S_POSTS_UNAPPROVED'	=> $posts_unapproved,
    661. 

  661. 			'S_HAS_POLL'			=> ($row['poll_start']) ? true : false,
    662. 

  662. 			'S_POST_ANNOUNCE'		=> ($row['topic_type'] == POST_ANNOUNCE) ? true : false,
    663. 

  663. 			'S_POST_GLOBAL'			=> ($row['topic_type'] == POST_GLOBAL) ? true : false,
    664. 

  664. 			'S_POST_STICKY'			=> ($row['topic_type'] == POST_STICKY) ? true : false,
    665. 

  665. 			'S_TOPIC_LOCKED'		=> ($row['topic_status'] == ITEM_LOCKED) ? true : false,
    666. 

  666. 			'S_TOPIC_MOVED'			=> ($row['topic_status'] == ITEM_MOVED) ? true : false,
    667. 

  667. 

  668. 			'U_NEWEST_POST'			=> append_sid("{$phpbb_root_path}viewtopic.$phpEx", $view_topic_url_params . '&amp;view=unread') . '#unread',
    669. 

  669. 			'U_LAST_POST'			=> append_sid("{$phpbb_root_path}viewtopic.$phpEx", $view_topic_url_params . '&amp;p=' . $row['topic_last_post_id']) . '#p' . $row['topic_last_post_id'],
    670. 

  670. 			'U_LAST_POST_AUTHOR'	=> get_username_string('profile', $row['topic_last_poster_id'], $row['topic_last_poster_name'], $row['topic_last_poster_colour']),
    671. 

  671. 			'U_TOPIC_AUTHOR'		=> get_username_string('profile', $row['topic_poster'], $row['topic_first_poster_name'], $row['topic_first_poster_colour']),
    672. 

  672. 			'U_VIEW_TOPIC'			=> $view_topic_url,
    673. 

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

  674. 			'U_MCP_QUEUE'			=> $u_mcp_queue,
    675. 

  675. 

  676. 			'S_TOPIC_TYPE_SWITCH'	=> ($s_type_switch == $s_type_switch_test) ? -1 : $s_type_switch_test)
    677. 

  677. 		);
    678. 

  678. 

  679. 		$s_type_switch = ($row['topic_type'] == POST_ANNOUNCE || $row['topic_type'] == POST_GLOBAL) ? 1 : 0;
    680. 

  680. 

  681. 		if ($unread_topic)
    682. 

  682. 		{
    683. 

  683. 			$mark_forum_read = false;
    684. 

  684. 		}
    685. 

  685. 

  686. 		unset($rowset[$topic_id]);
    687. 

  687. 	}
    688. 

  688. }
    689. 

  689. 

  690. // This is rather a fudge but it's the best I can think of without requiring information
    691. 

  691. // on all topics (as we do in 2.0.x). It looks for unread or new topics, if it doesn't find
    692. 

  692. // any it updates the forum last read cookie. This requires that the user visit the forum
    693. 

  693. // after reading a topic
    694. 

  694. if ($forum_data['forum_type'] == FORUM_POST && sizeof($topic_list) && $mark_forum_read)
    695. 

  695. {
    696. 

  696. 	update_forum_tracking_info($forum_id, $forum_data['forum_last_post_time'], false, $mark_time_forum);
    697. 

  697. }
    698. 

  698. 

  699. page_footer();
    700. 

  700. 

  701. ?>
    702.