PageRenderTime 144ms CodeModel.GetById 29ms RepoModel.GetById 6ms app.codeStats 0ms

/forum/includes/functions_display.php

https://github.com/GreyTeardrop/socionicasys-forum
PHP | 1399 lines | 1157 code | 127 blank | 115 comment | 202 complexity | 93da59312c1a050fb1c2aa9b53ec8cdc MD5 | raw file
Possible License(s): AGPL-1.0, LGPL-3.0, MPL-2.0-no-copyleft-exception 
    

  1. <?php
    2. 

  2. /**
    3. 

  3. *
    4. 

  4. * @package phpBB3
    5. 

  5. * @version $Id$
    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. if (!defined('IN_PHPBB'))
    15. 

  15. {
    16. 

  16. 	exit;
    17. 

  17. }
    18. 

  18. 

  19. /**
    20. 

  20. * Display Forums
    21. 

  21. */
    22. 

  22. function display_forums($root_data = '', $display_moderators = true, $return_moderators = false)
    23. 

  23. {
    24. 

  24. 	global $db, $auth, $user, $template;
    25. 

  25. 	global $phpbb_root_path, $phpEx, $config;
    26. 

  26. 	// www.phpBB-SEO.com SEO TOOLKIT BEGIN
    27. 

  27. 	global $phpbb_seo;
    28. 

  28. 	// www.phpBB-SEO.com SEO TOOLKIT END
    29. 

  29. 	$forum_rows = $subforums = $forum_ids = $forum_ids_moderator = $forum_moderators = $active_forum_ary = array();
    30. 

  30. 	$parent_id = $visible_forums = 0;
    31. 

  31. 	$sql_from = '';
    32. 

  32. 

  33. 	// Mark forums read?
    34. 

  34. 	$mark_read = request_var('mark', '');
    35. 

  35. 

  36. 	if ($mark_read == 'all')
    37. 

  37. 	{
    38. 

  38. 		$mark_read = '';
    39. 

  39. 	}
    40. 

  40. 

  41. 	if (!$root_data)
    42. 

  42. 	{
    43. 

  43. 		if ($mark_read == 'forums')
    44. 

  44. 		{
    45. 

  45. 			$mark_read = 'all';
    46. 

  46. 		}
    47. 

  47. 

  48. 		$root_data = array('forum_id' => 0);
    49. 

  49. 		$sql_where = '';
    50. 

  50. 	}
    51. 

  51. 	else
    52. 

  52. 	{
    53. 

  53. 		$sql_where = 'left_id > ' . $root_data['left_id'] . ' AND left_id < ' . $root_data['right_id'];
    54. 

  54. 	}
    55. 

  55. 

  56. 	// Display list of active topics for this category?
    57. 

  57. 	$show_active = (isset($root_data['forum_flags']) && ($root_data['forum_flags'] & FORUM_FLAG_ACTIVE_TOPICS)) ? true : false;
    58. 

  58. 

  59. 	$sql_array = array(
    60. 

  60. 		'SELECT'	=> 'f.*',
    61. 

  61. 		'FROM'		=> array(
    62. 

  62. 			FORUMS_TABLE		=> 'f'
    63. 

  63. 		),
    64. 

  64. 		'LEFT_JOIN'	=> array(),
    65. 

  65. 	);
    66. 

  66. 

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

  68. 	{
    69. 

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

  70. 		$sql_array['SELECT'] .= ', ft.mark_time';
    71. 

  71. 	}
    72. 

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

  73. 	{
    74. 

  74. 		$tracking_topics = (isset($_COOKIE[$config['cookie_name'] . '_track'])) ? ((STRIP) ? stripslashes($_COOKIE[$config['cookie_name'] . '_track']) : $_COOKIE[$config['cookie_name'] . '_track']) : '';
    75. 

  75. 		$tracking_topics = ($tracking_topics) ? tracking_unserialize($tracking_topics) : array();
    76. 

  76. 

  77. 		if (!$user->data['is_registered'])
    78. 

  78. 		{
    79. 

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

  80. 		}
    81. 

  81. 	}
    82. 

  82. 

  83. 	if ($show_active)
    84. 

  84. 	{
    85. 

  85. 		$sql_array['LEFT_JOIN'][] = array(
    86. 

  86. 			'FROM'	=> array(FORUMS_ACCESS_TABLE => 'fa'),
    87. 

  87. 			'ON'	=> "fa.forum_id = f.forum_id AND fa.session_id = '" . $db->sql_escape($user->session_id) . "'"
    88. 

  88. 		);
    89. 

  89. 

  90. 		$sql_array['SELECT'] .= ', fa.user_id';
    91. 

  91. 	}
    92. 

  92. 	// www.phpBB-SEO.com SEO TOOLKIT BEGIN -> no dupe
    93. 

  93. 	if (!empty($phpbb_seo->seo_opt['no_dupe']['on'])) {
    94. 

  94. 		$sql_array['SELECT'] .= ', t.topic_id, t.topic_title, t.topic_replies, t.topic_replies_real, t.topic_status, t.topic_type, t.topic_moved_id' . (!empty($phpbb_seo->seo_opt['sql_rewrite']) ? ', t.topic_url ' : ' ');
    95. 

  95. 		$sql_array['LEFT_JOIN'][] = array(
    96. 

  96. 			'FROM'	=> array(TOPICS_TABLE => 't'),
    97. 

  97. 			'ON'	=> "f.forum_last_post_id = t.topic_last_post_id"
    98. 

  98. 		);
    99. 

  99. 	}
    100. 

  100. 	// www.phpBB-SEO.com SEO TOOLKIT END -> no dupe
    101. 

  101. 	$sql = $db->sql_build_query('SELECT', array(
    102. 

  102. 		'SELECT'	=> $sql_array['SELECT'],
    103. 

  103. 		'FROM'		=> $sql_array['FROM'],
    104. 

  104. 		'LEFT_JOIN'	=> $sql_array['LEFT_JOIN'],
    105. 

  105. 

  106. 		'WHERE'		=> $sql_where,
    107. 

  107. 

  108. 		'ORDER_BY'	=> 'f.left_id',
    109. 

  109. 	));
    110. 

  110. 

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

  112. 

  113. 	$forum_tracking_info = array();
    114. 

  114. 	$branch_root_id = $root_data['forum_id'];
    115. 

  115. 

  116. 	// Check for unread global announcements (index page only)
    117. 

  117. 	$ga_unread = false;
    118. 

  118. 	if ($root_data['forum_id'] == 0)
    119. 

  119. 	{
    120. 

  120. 		$unread_ga_list = get_unread_topics($user->data['user_id'], 'AND t.forum_id = 0', '', 1);
    121. 

  121. 

  122. 		if (!empty($unread_ga_list))
    123. 

  123. 		{
    124. 

  124. 			$ga_unread = true;
    125. 

  125. 		}
    126. 

  126. 	}
    127. 

  127. 

  128. 	while ($row = $db->sql_fetchrow($result))
    129. 

  129. 	{
    130. 

  130. 		$forum_id = $row['forum_id'];
    131. 

  131. 		// www.phpBB-SEO.com SEO TOOLKIT BEGIN
    132. 

  132. 		$phpbb_seo->set_url($row['forum_name'], $forum_id, 'forum');
    133. 

  133. 		// www.phpBB-SEO.com SEO TOOLKIT END
    134. 

  134. 		// Mark forums read?
    135. 

  135. 		if ($mark_read == 'forums' || $mark_read == 'all')
    136. 

  136. 		{
    137. 

  137. 			if ($auth->acl_get('f_list', $forum_id))
    138. 

  138. 			{
    139. 

  139. 				$forum_ids[] = $forum_id;
    140. 

  140. 				continue;
    141. 

  141. 			}
    142. 

  142. 		}
    143. 

  143. 

  144. 		// Category with no members
    145. 

  145. 		if ($row['forum_type'] == FORUM_CAT && ($row['left_id'] + 1 == $row['right_id']))
    146. 

  146. 		{
    147. 

  147. 			continue;
    148. 

  148. 		}
    149. 

  149. 

  150. 		// Skip branch
    151. 

  151. 		if (isset($right_id))
    152. 

  152. 		{
    153. 

  153. 			if ($row['left_id'] < $right_id)
    154. 

  154. 			{
    155. 

  155. 				continue;
    156. 

  156. 			}
    157. 

  157. 			unset($right_id);
    158. 

  158. 		}
    159. 

  159. 

  160. 		if (!$auth->acl_get('f_list', $forum_id))
    161. 

  161. 		{
    162. 

  162. 			// if the user does not have permissions to list this forum, skip everything until next branch
    163. 

  163. 			$right_id = $row['right_id'];
    164. 

  164. 			continue;
    165. 

  165. 		}
    166. 

  166. 

  167. 		$forum_ids[] = $forum_id;
    168. 

  168. 

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

  170. 		{
    171. 

  171. 			$forum_tracking_info[$forum_id] = (!empty($row['mark_time'])) ? $row['mark_time'] : $user->data['user_lastmark'];
    172. 

  172. 		}
    173. 

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

  174. 		{
    175. 

  175. 			if (!$user->data['is_registered'])
    176. 

  176. 			{
    177. 

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

  178. 			}
    179. 

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

  180. 		}
    181. 

  181. 

  182. 		// Count the difference of real to public topics, so we can display an information to moderators
    183. 

  183. 		$row['forum_id_unapproved_topics'] = ($auth->acl_get('m_approve', $forum_id) && ($row['forum_topics_real'] != $row['forum_topics'])) ? $forum_id : 0;
    184. 

  184. 		// www.phpBB-SEO.com SEO TOOLKIT BEGIN -> no dupe
    185. 

  185. 		if (!empty($phpbb_seo->seo_opt['no_dupe']['on'])) {
    186. 

  186. 			if ($row['topic_status'] == ITEM_MOVED) {
    187. 

  187. 				$row['topic_id'] = $row['topic_moved_id'];
    188. 

  188. 			}
    189. 

  189. 			$phpbb_seo->seo_opt['topic_forum_name'][$row['topic_id']] = $row['forum_name'];
    190. 

  190. 			if ($auth->acl_get('m_approve', $forum_id)) {
    191. 

  191. 				$row['forum_topics'] = $row['forum_topics_real'];
    192. 

  192. 				$replies = $row['topic_replies_real'];
    193. 

  193. 			} else {
    194. 

  194. 				$row['forum_topics'] = $row['forum_topics'];
    195. 

  195. 				$replies = $row['topic_replies'];
    196. 

  196. 			}
    197. 

  197. 			if (($replies + 1) > $phpbb_seo->seo_opt['topic_per_page']) {
    198. 

  198. 				$phpbb_seo->seo_opt['topic_last_page'][$row['topic_id']] = floor($replies / $phpbb_seo->seo_opt['topic_per_page']) * $phpbb_seo->seo_opt['topic_per_page'];
    199. 

  199. 			}
    200. 

  200. 		} else {
    201. 

  201. 			$row['forum_topics'] = ($auth->acl_get('m_approve', $forum_id)) ? $row['forum_topics_real'] : $row['forum_topics'];
    202. 

  202. 		}
    203. 

  203. 		// www.phpBB-SEO.com SEO TOOLKIT END -> no dupe
    204. 

  204. 

  205. 		// Display active topics from this forum?
    206. 

  206. 		if ($show_active && $row['forum_type'] == FORUM_POST && $auth->acl_get('f_read', $forum_id) && ($row['forum_flags'] & FORUM_FLAG_ACTIVE_TOPICS))
    207. 

  207. 		{
    208. 

  208. 			if (!isset($active_forum_ary['forum_topics']))
    209. 

  209. 			{
    210. 

  210. 				$active_forum_ary['forum_topics'] = 0;
    211. 

  211. 			}
    212. 

  212. 

  213. 			if (!isset($active_forum_ary['forum_posts']))
    214. 

  214. 			{
    215. 

  215. 				$active_forum_ary['forum_posts'] = 0;
    216. 

  216. 			}
    217. 

  217. 

  218. 			$active_forum_ary['forum_id'][]		= $forum_id;
    219. 

  219. 			$active_forum_ary['enable_icons'][]	= $row['enable_icons'];
    220. 

  220. 			$active_forum_ary['forum_topics']	+= $row['forum_topics'];
    221. 

  221. 			$active_forum_ary['forum_posts']	+= $row['forum_posts'];
    222. 

  222. 

  223. 			// If this is a passworded forum we do not show active topics from it if the user is not authorised to view it...
    224. 

  224. 			if ($row['forum_password'] && $row['user_id'] != $user->data['user_id'])
    225. 

  225. 			{
    226. 

  226. 				$active_forum_ary['exclude_forum_id'][] = $forum_id;
    227. 

  227. 			}
    228. 

  228. 		}
    229. 

  229. 

  230. 		//
    231. 

  231. 		if ($row['parent_id'] == $root_data['forum_id'] || $row['parent_id'] == $branch_root_id)
    232. 

  232. 		{
    233. 

  233. 			if ($row['forum_type'] != FORUM_CAT)
    234. 

  234. 			{
    235. 

  235. 				$forum_ids_moderator[] = (int) $forum_id;
    236. 

  236. 			}
    237. 

  237. 

  238. 			// Direct child of current branch
    239. 

  239. 			$parent_id = $forum_id;
    240. 

  240. 			$forum_rows[$forum_id] = $row;
    241. 

  241. 

  242. 			if ($row['forum_type'] == FORUM_CAT && $row['parent_id'] == $root_data['forum_id'])
    243. 

  243. 			{
    244. 

  244. 				$branch_root_id = $forum_id;
    245. 

  245. 			}
    246. 

  246. 			$forum_rows[$parent_id]['forum_id_last_post'] = $row['forum_id'];
    247. 

  247. 			$forum_rows[$parent_id]['orig_forum_last_post_time'] = $row['forum_last_post_time'];
    248. 

  248. 		}
    249. 

  249. 		else if ($row['forum_type'] != FORUM_CAT)
    250. 

  250. 		{
    251. 

  251. 			$subforums[$parent_id][$forum_id]['display'] = ($row['display_on_index']) ? true : false;
    252. 

  252. 			$subforums[$parent_id][$forum_id]['name'] = $row['forum_name'];
    253. 

  253. 			$subforums[$parent_id][$forum_id]['orig_forum_last_post_time'] = $row['forum_last_post_time'];
    254. 

  254. 			$subforums[$parent_id][$forum_id]['children'] = array();
    255. 

  255. 

  256. 			if (isset($subforums[$parent_id][$row['parent_id']]) && !$row['display_on_index'])
    257. 

  257. 			{
    258. 

  258. 				$subforums[$parent_id][$row['parent_id']]['children'][] = $forum_id;
    259. 

  259. 			}
    260. 

  260. 

  261. 			if (!$forum_rows[$parent_id]['forum_id_unapproved_topics'] && $row['forum_id_unapproved_topics'])
    262. 

  262. 			{
    263. 

  263. 				$forum_rows[$parent_id]['forum_id_unapproved_topics'] = $forum_id;
    264. 

  264. 			}
    265. 

  265. 

  266. 			$forum_rows[$parent_id]['forum_topics'] += $row['forum_topics'];
    267. 

  267. 

  268. 			// Do not list redirects in LINK Forums as Posts.
    269. 

  269. 			if ($row['forum_type'] != FORUM_LINK)
    270. 

  270. 			{
    271. 

  271. 				$forum_rows[$parent_id]['forum_posts'] += $row['forum_posts'];
    272. 

  272. 			}
    273. 

  273. 

  274. 			if ($row['forum_last_post_time'] > $forum_rows[$parent_id]['forum_last_post_time'])
    275. 

  275. 			{
    276. 

  276. 				$forum_rows[$parent_id]['forum_last_post_id'] = $row['forum_last_post_id'];
    277. 

  277. 				$forum_rows[$parent_id]['forum_last_post_subject'] = $row['forum_last_post_subject'];
    278. 

  278. 				$forum_rows[$parent_id]['forum_last_post_time'] = $row['forum_last_post_time'];
    279. 

  279. 				$forum_rows[$parent_id]['forum_last_poster_id'] = $row['forum_last_poster_id'];
    280. 

  280. 				$forum_rows[$parent_id]['forum_last_poster_name'] = $row['forum_last_poster_name'];
    281. 

  281. 				$forum_rows[$parent_id]['forum_last_poster_colour'] = $row['forum_last_poster_colour'];
    282. 

  282. 				$forum_rows[$parent_id]['forum_id_last_post'] = $forum_id;
    283. 

  283. 				// www.phpBB-SEO.com SEO TOOLKIT BEGIN -> no dupe
    284. 

  284. 				if (!empty($phpbb_seo->seo_opt['no_dupe']['on'])) {
    285. 

  285. 					$forum_rows[$parent_id]['topic_id'] = $row['topic_id'];
    286. 

  286. 					$forum_rows[$parent_id]['topic_title'] = $row['topic_title'];
    287. 

  287. 					$forum_rows[$parent_id]['topic_type'] = $row['topic_type'];
    288. 

  288. 					$forum_rows[$parent_id]['forum_password'] = $row['forum_password'];
    289. 

  289. 					$forum_rows[$parent_id]['topic_url'] = isset($row['topic_url']) ? $row['topic_url'] : '';
    290. 

  290. 				}
    291. 

  291. 				// www.phpBB-SEO.com SEO TOOLKIT END -> no dupe
    292. 

  292. 			}
    293. 

  293. 		}
    294. 

  294. 	}
    295. 

  295. 	$db->sql_freeresult($result);
    296. 

  296. 

  297. 	// Handle marking posts
    298. 

  298. 	if ($mark_read == 'forums' || $mark_read == 'all')
    299. 

  299. 	{
    300. 

  300. 		$redirect = build_url(array('mark', 'hash'));
    301. 

  301. 		$token = request_var('hash', '');
    302. 

  302. 		if (check_link_hash($token, 'global'))
    303. 

  303. 		{
    304. 

  304. 			if ($mark_read == 'all')
    305. 

  305. 			{
    306. 

  306. 				markread('all');
    307. 

  307. 				$message = sprintf($user->lang['RETURN_INDEX'], '<a href="' . $redirect . '">', '</a>');
    308. 

  308. 			}
    309. 

  309. 			else
    310. 

  310. 			{
    311. 

  311. 				// Add 0 to forums array to mark global announcements correctly
    312. 

  312. 				$forum_ids[] = 0;
    313. 

  313. 				markread('topics', $forum_ids);
    314. 

  314. 				$message = sprintf($user->lang['RETURN_FORUM'], '<a href="' . $redirect . '">', '</a>');
    315. 

  315. 			}
    316. 

  316. 			meta_refresh(3, $redirect);
    317. 

  317. 			trigger_error($user->lang['FORUMS_MARKED'] . '<br /><br />' . $message);
    318. 

  318. 		}
    319. 

  319. 		else
    320. 

  320. 		{
    321. 

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

  322. 			meta_refresh(3, $redirect);
    323. 

  323. 			trigger_error($message);
    324. 

  324. 		}
    325. 

  325. 

  326. 	}
    327. 

  327. 

  328. 	// Grab moderators ... if necessary
    329. 

  329. 	if ($display_moderators)
    330. 

  330. 	{
    331. 

  331. 		if ($return_moderators)
    332. 

  332. 		{
    333. 

  333. 			$forum_ids_moderator[] = $root_data['forum_id'];
    334. 

  334. 		}
    335. 

  335. 		get_moderators($forum_moderators, $forum_ids_moderator);
    336. 

  336. 	}
    337. 

  337. 

  338. 	// Used to tell whatever we have to create a dummy category or not.
    339. 

  339. 	$last_catless = true;
    340. 

  340. 	foreach ($forum_rows as $row)
    341. 

  341. 	{
    342. 

  342. 		// Empty category
    343. 

  343. 		if ($row['parent_id'] == $root_data['forum_id'] && $row['forum_type'] == FORUM_CAT)
    344. 

  344. 		{
    345. 

  345. 			$template->assign_block_vars('forumrow', array(
    346. 

  346. 				'S_IS_CAT'				=> true,
    347. 

  347. 				'FORUM_ID'				=> $row['forum_id'],
    348. 

  348. 				'FORUM_NAME'			=> $row['forum_name'],
    349. 

  349. 				'FORUM_DESC'			=> generate_text_for_display($row['forum_desc'], $row['forum_desc_uid'], $row['forum_desc_bitfield'], $row['forum_desc_options']),
    350. 

  350. 				'FORUM_FOLDER_IMG'		=> '',
    351. 

  351. 				'FORUM_FOLDER_IMG_SRC'	=> '',
    352. 

  352. 				'FORUM_IMAGE'			=> ($row['forum_image']) ? '<img src="' . $phpbb_root_path . $row['forum_image'] . '" alt="' . $user->lang['FORUM_CAT'] . '" />' : '',
    353. 

  353. 				'FORUM_IMAGE_SRC'		=> ($row['forum_image']) ? $phpbb_root_path . $row['forum_image'] : '',
    354. 

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

  355. 			);
    356. 

  356. 

  357. 			continue;
    358. 

  358. 		}
    359. 

  359. 

  360. 		$visible_forums++;
    361. 

  361. 		$forum_id = $row['forum_id'];
    362. 

  362. 

  363. 		$forum_unread = (isset($forum_tracking_info[$forum_id]) && $row['orig_forum_last_post_time'] > $forum_tracking_info[$forum_id]) ? true : false;
    364. 

  364. 

  365. 		// Mark the first visible forum on index as unread if there's any unread global announcement
    366. 

  366. 		if ($ga_unread && !empty($forum_ids_moderator) && $forum_id == $forum_ids_moderator[0])
    367. 

  367. 		{
    368. 

  368. 			$forum_unread = true;
    369. 

  369. 		}
    370. 

  370. 

  371. 		$folder_image = $folder_alt = $l_subforums = '';
    372. 

  372. 		$subforums_list = array();
    373. 

  373. 

  374. 		// Generate list of subforums if we need to
    375. 

  375. 		if (isset($subforums[$forum_id]))
    376. 

  376. 		{
    377. 

  377. 			foreach ($subforums[$forum_id] as $subforum_id => $subforum_row)
    378. 

  378. 			{
    379. 

  379. 				$subforum_unread = (isset($forum_tracking_info[$subforum_id]) && $subforum_row['orig_forum_last_post_time'] > $forum_tracking_info[$subforum_id]) ? true : false;
    380. 

  380. 

  381. 				if (!$subforum_unread && !empty($subforum_row['children']))
    382. 

  382. 				{
    383. 

  383. 					foreach ($subforum_row['children'] as $child_id)
    384. 

  384. 					{
    385. 

  385. 						if (isset($forum_tracking_info[$child_id]) && $subforums[$forum_id][$child_id]['orig_forum_last_post_time'] > $forum_tracking_info[$child_id])
    386. 

  386. 						{
    387. 

  387. 							// Once we found an unread child forum, we can drop out of this loop
    388. 

  388. 							$subforum_unread = true;
    389. 

  389. 							break;
    390. 

  390. 						}
    391. 

  391. 					}
    392. 

  392. 				}
    393. 

  393. 

  394. 				if ($subforum_row['display'] && $subforum_row['name'])
    395. 

  395. 				{
    396. 

  396. 					$subforums_list[] = array(
    397. 

  397. 						'link'		=> append_sid("{$phpbb_root_path}viewforum.$phpEx", 'f=' . $subforum_id),
    398. 

  398. 						'name'		=> $subforum_row['name'],
    399. 

  399. 						'unread'	=> $subforum_unread,
    400. 

  400. 					);
    401. 

  401. 				}
    402. 

  402. 				else
    403. 

  403. 				{
    404. 

  404. 					unset($subforums[$forum_id][$subforum_id]);
    405. 

  405. 				}
    406. 

  406. 

  407. 				// If one subforum is unread the forum gets unread too...
    408. 

  408. 				if ($subforum_unread)
    409. 

  409. 				{
    410. 

  410. 					$forum_unread = true;
    411. 

  411. 				}
    412. 

  412. 			}
    413. 

  413. 

  414. 			$l_subforums = (sizeof($subforums[$forum_id]) == 1) ? $user->lang['SUBFORUM'] . ': ' : $user->lang['SUBFORUMS'] . ': ';
    415. 

  415. 			$folder_image = ($forum_unread) ? 'forum_unread_subforum' : 'forum_read_subforum';
    416. 

  416. 		}
    417. 

  417. 		else
    418. 

  418. 		{
    419. 

  419. 			switch ($row['forum_type'])
    420. 

  420. 			{
    421. 

  421. 				case FORUM_POST:
    422. 

  422. 					$folder_image = ($forum_unread) ? 'forum_unread' : 'forum_read';
    423. 

  423. 				break;
    424. 

  424. 

  425. 				case FORUM_LINK:
    426. 

  426. 					$folder_image = 'forum_link';
    427. 

  427. 				break;
    428. 

  428. 			}
    429. 

  429. 		}
    430. 

  430. 

  431. 		// Which folder should we display?
    432. 

  432. 		if ($row['forum_status'] == ITEM_LOCKED)
    433. 

  433. 		{
    434. 

  434. 			$folder_image = ($forum_unread) ? 'forum_unread_locked' : 'forum_read_locked';
    435. 

  435. 			$folder_alt = 'FORUM_LOCKED';
    436. 

  436. 		}
    437. 

  437. 		else
    438. 

  438. 		{
    439. 

  439. 			$folder_alt = ($forum_unread) ? 'UNREAD_POSTS' : 'NO_UNREAD_POSTS';
    440. 

  440. 		}
    441. 

  441. 

  442. 		// Create last post link information, if appropriate
    443. 

  443. 		if ($row['forum_last_post_id'])
    444. 

  444. 		{
    445. 

  445. 			$last_post_subject = $row['forum_last_post_subject'];
    446. 

  446. 			$last_post_time = $user->format_date($row['forum_last_post_time']);
    447. 

  447. 			// www.phpBB-SEO.com SEO TOOLKIT BEGIN -> no dupe
    448. 

  448. 			if (!empty($phpbb_seo->seo_opt['no_dupe']['on']) && !$row['forum_password'] && $auth->acl_get('f_read', $row['forum_id_last_post'])) {
    449. 

  449. 				$phpbb_seo->prepare_iurl($row, 'topic', $row['topic_type'] == POST_GLOBAL ? $phpbb_seo->seo_static['global_announce'] : $phpbb_seo->seo_url['forum'][$row['forum_id_last_post']]);
    450. 

  450. 				$last_post_url =  append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . $row['forum_id_last_post'] . '&amp;t=' . $row['topic_id'] . '&amp;start=' . @intval($phpbb_seo->seo_opt['topic_last_page'][$row['topic_id']]) ) . '#p' . $row['forum_last_post_id'];
    451. 

  451. 				$topic_title = censor_text($row['topic_title']);
    452. 

  452. 				// Limit in chars for the last post link text.
    453. 

  453. 				$char_limit = 25;
    454. 

  454. 				// Limit topic text link to $char_limit, without breacking words
    455. 

  455. 				$topic_text_lilnk = $char_limit > 0 && ( ( $length = utf8_strlen($topic_title) ) > $char_limit ) ? ( utf8_strlen($fragment = utf8_substr($topic_title, 0, $char_limit + 1 - 4)) < $length + 1 ? preg_replace('`\s*\S*$`', '', $fragment) . ' ...' : $topic_title ) : $topic_title;
    456. 

  456. 				$last_post_link = '<a href="' . append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . $row['forum_id_last_post'] . '&amp;t=' . $row['topic_id']) . '" title="' . $topic_title . ' : ' . $phpbb_seo->seo_opt['topic_forum_name'][$row['topic_id']] . '">' . $topic_text_lilnk . '</a>';
    457. 

  457. 			} else {
    458. 

  458. 				$last_post_url =  append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . $row['forum_id_last_post'] . '&amp;p=' . $row['forum_last_post_id']) . '#p' . $row['forum_last_post_id'];
    459. 

  459. 				$last_post_link = '';
    460. 

  460. 			}
    461. 

  461. 		}
    462. 

  462. 		else
    463. 

  463. 		{
    464. 

  464. 			$last_post_subject = $last_post_time = $last_post_url = $last_post_link = '';
    465. 

  465. 			// www.phpBB-SEO.com SEO TOOLKIT END -> no dupe
    466. 

  466. 		}
    467. 

  467. 

  468. 		// Output moderator listing ... if applicable
    469. 

  469. 		$l_moderator = $moderators_list = '';
    470. 

  470. 		if ($display_moderators && !empty($forum_moderators[$forum_id]))
    471. 

  471. 		{
    472. 

  472. 			$l_moderator = (sizeof($forum_moderators[$forum_id]) == 1) ? $user->lang['MODERATOR'] : $user->lang['MODERATORS'];
    473. 

  473. 			$moderators_list = implode(', ', $forum_moderators[$forum_id]);
    474. 

  474. 		}
    475. 

  475. 

  476. 		$l_post_click_count = ($row['forum_type'] == FORUM_LINK) ? 'CLICKS' : 'POSTS';
    477. 

  477. 		$post_click_count = ($row['forum_type'] != FORUM_LINK || $row['forum_flags'] & FORUM_FLAG_LINK_TRACK) ? $row['forum_posts'] : '';
    478. 

  478. 

  479. 		$s_subforums_list = array();
    480. 

  480. 		foreach ($subforums_list as $subforum)
    481. 

  481. 		{
    482. 

  482. 			$s_subforums_list[] = '<a href="' . $subforum['link'] . '" class="subforum ' . (($subforum['unread']) ? 'unread' : 'read') . '" title="' . (($subforum['unread']) ? $user->lang['UNREAD_POSTS'] : $user->lang['NO_UNREAD_POSTS']) . '">' . $subforum['name'] . '</a>';
    483. 

  483. 		}
    484. 

  484. 		$s_subforums_list = (string) implode(', ', $s_subforums_list);
    485. 

  485. 		$catless = ($row['parent_id'] == $root_data['forum_id']) ? true : false;
    486. 

  486. 

  487. 		if ($row['forum_type'] != FORUM_LINK)
    488. 

  488. 		{
    489. 

  489. 			$u_viewforum = append_sid("{$phpbb_root_path}viewforum.$phpEx", 'f=' . $row['forum_id']);
    490. 

  490. 		}
    491. 

  491. 		else
    492. 

  492. 		{
    493. 

  493. 			// If the forum is a link and we count redirects we need to visit it
    494. 

  494. 			// If the forum is having a password or no read access we do not expose the link, but instead handle it in viewforum
    495. 

  495. 			if (($row['forum_flags'] & FORUM_FLAG_LINK_TRACK) || $row['forum_password'] || !$auth->acl_get('f_read', $forum_id))
    496. 

  496. 			{
    497. 

  497. 				$u_viewforum = append_sid("{$phpbb_root_path}viewforum.$phpEx", 'f=' . $row['forum_id']);
    498. 

  498. 			}
    499. 

  499. 			else
    500. 

  500. 			{
    501. 

  501. 				$u_viewforum = $row['forum_link'];
    502. 

  502. 			}
    503. 

  503. 		}
    504. 

  504. 

  505. 		$template->assign_block_vars('forumrow', array(
    506. 

  506. 			'S_IS_CAT'			=> false,
    507. 

  507. 			'S_NO_CAT'			=> $catless && !$last_catless,
    508. 

  508. 			'S_IS_LINK'			=> ($row['forum_type'] == FORUM_LINK) ? true : false,
    509. 

  509. 			'S_UNREAD_FORUM'	=> $forum_unread,
    510. 

  510. 			'S_LOCKED_FORUM'	=> ($row['forum_status'] == ITEM_LOCKED) ? true : false,
    511. 

  511. 			'S_LIST_SUBFORUMS'	=> ($row['display_subforum_list']) ? true : false,
    512. 

  512. 			'S_SUBFORUMS'		=> (sizeof($subforums_list)) ? true : false,
    513. 

  513. 			'S_FEED_ENABLED'	=> ($config['feed_forum'] && !phpbb_optionget(FORUM_OPTION_FEED_EXCLUDE, $row['forum_options']) && $row['forum_type'] == FORUM_POST) ? true : false,
    514. 

  514. 

  515. 			'FORUM_ID'				=> $row['forum_id'],
    516. 

  516. 			'FORUM_NAME'			=> $row['forum_name'],
    517. 

  517. 			'FORUM_DESC'			=> generate_text_for_display($row['forum_desc'], $row['forum_desc_uid'], $row['forum_desc_bitfield'], $row['forum_desc_options']),
    518. 

  518. 			'TOPICS'				=> $row['forum_topics'],
    519. 

  519. 			$l_post_click_count		=> $post_click_count,
    520. 

  520. 			'FORUM_FOLDER_IMG'		=> $user->img($folder_image, $folder_alt),
    521. 

  521. 			'FORUM_FOLDER_IMG_SRC'	=> $user->img($folder_image, $folder_alt, false, '', 'src'),
    522. 

  522. 			'FORUM_FOLDER_IMG_ALT'	=> isset($user->lang[$folder_alt]) ? $user->lang[$folder_alt] : '',
    523. 

  523. 			'FORUM_IMAGE'			=> ($row['forum_image']) ? '<img src="' . $phpbb_root_path . $row['forum_image'] . '" alt="' . $user->lang[$folder_alt] . '" />' : '',
    524. 

  524. 			'FORUM_IMAGE_SRC'		=> ($row['forum_image']) ? $phpbb_root_path . $row['forum_image'] : '',
    525. 

  525. 			'LAST_POST_SUBJECT'		=> censor_text($last_post_subject),
    526. 

  526. 			'LAST_POST_TIME'		=> $last_post_time,
    527. 

  527. 			'LAST_POSTER'			=> get_username_string('username', $row['forum_last_poster_id'], $row['forum_last_poster_name'], $row['forum_last_poster_colour']),
    528. 

  528. 			'LAST_POSTER_COLOUR'	=> get_username_string('colour', $row['forum_last_poster_id'], $row['forum_last_poster_name'], $row['forum_last_poster_colour']),
    529. 

  529. 			'LAST_POSTER_FULL'		=> get_username_string('full', $row['forum_last_poster_id'], $row['forum_last_poster_name'], $row['forum_last_poster_colour']),
    530. 

  530. 			'MODERATORS'			=> $moderators_list,
    531. 

  531. 			'SUBFORUMS'				=> $s_subforums_list,
    532. 

  532. 

  533. 			'L_SUBFORUM_STR'		=> $l_subforums,
    534. 

  534. 			'L_MODERATOR_STR'		=> $l_moderator,
    535. 

  535. 

  536. 			'U_UNAPPROVED_TOPICS'	=> ($row['forum_id_unapproved_topics']) ? append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=queue&amp;mode=unapproved_topics&amp;f=' . $row['forum_id_unapproved_topics']) : '',
    537. 

  537. 			'U_VIEWFORUM'		=> $u_viewforum,
    538. 

  538. 			'U_LAST_POSTER'		=> get_username_string('profile', $row['forum_last_poster_id'], $row['forum_last_poster_name'], $row['forum_last_poster_colour']),
    539. 

  539. 			// www.phpBB-SEO.com SEO TOOLKIT BEGIN -> no dupe
    540. 

  540. 			'LAST_POST_LINK'	=> $last_post_link,
    541. 

  541. 			// www.phpBB-SEO.com SEO TOOLKIT END -> no dupe
    542. 

  542. 			'U_LAST_POST'		=> $last_post_url)
    543. 

  543. 		);
    544. 

  544. 

  545. 		// Assign subforums loop for style authors
    546. 

  546. 		foreach ($subforums_list as $subforum)
    547. 

  547. 		{
    548. 

  548. 			$template->assign_block_vars('forumrow.subforum', array(
    549. 

  549. 				'U_SUBFORUM'	=> $subforum['link'],
    550. 

  550. 				'SUBFORUM_NAME'	=> $subforum['name'],
    551. 

  551. 				'S_UNREAD'		=> $subforum['unread'])
    552. 

  552. 			);
    553. 

  553. 		}
    554. 

  554. 

  555. 		$last_catless = $catless;
    556. 

  556. 	}
    557. 

  557. 

  558. 	$template->assign_vars(array(
    559. 

  559. 		'U_MARK_FORUMS'		=> ($user->data['is_registered'] || $config['load_anon_lastread']) ? append_sid("{$phpbb_root_path}viewforum.$phpEx", 'hash=' . generate_link_hash('global') . '&amp;f=' . $root_data['forum_id'] . '&amp;mark=forums') : '',
    560. 

  560. 		'S_HAS_SUBFORUM'	=> ($visible_forums) ? true : false,
    561. 

  561. 		'L_SUBFORUM'		=> ($visible_forums == 1) ? $user->lang['SUBFORUM'] : $user->lang['SUBFORUMS'],
    562. 

  562. 		'LAST_POST_IMG'		=> $user->img('icon_topic_latest', 'VIEW_LATEST_POST'),
    563. 

  563. 		'UNAPPROVED_IMG'	=> $user->img('icon_topic_unapproved', 'TOPICS_UNAPPROVED'),
    564. 

  564. 	));
    565. 

  565. 

  566. 	if ($return_moderators)
    567. 

  567. 	{
    568. 

  568. 		return array($active_forum_ary, $forum_moderators);
    569. 

  569. 	}
    570. 

  570. 

  571. 	return array($active_forum_ary, array());
    572. 

  572. }
    573. 

  573. 

  574. /**
    575. 

  575. * Create forum rules for given forum
    576. 

  576. */
    577. 

  577. function generate_forum_rules(&$forum_data)
    578. 

  578. {
    579. 

  579. 	if (!$forum_data['forum_rules'] && !$forum_data['forum_rules_link'])
    580. 

  580. 	{
    581. 

  581. 		return;
    582. 

  582. 	}
    583. 

  583. 

  584. 	global $template, $phpbb_root_path, $phpEx;
    585. 

  585. 

  586. 	if ($forum_data['forum_rules'])
    587. 

  587. 	{
    588. 

  588. 		$forum_data['forum_rules'] = generate_text_for_display($forum_data['forum_rules'], $forum_data['forum_rules_uid'], $forum_data['forum_rules_bitfield'], $forum_data['forum_rules_options']);
    589. 

  589. 	}
    590. 

  590. 

  591. 	$template->assign_vars(array(
    592. 

  592. 		'S_FORUM_RULES'	=> true,
    593. 

  593. 		'U_FORUM_RULES'	=> $forum_data['forum_rules_link'],
    594. 

  594. 		'FORUM_RULES'	=> $forum_data['forum_rules'])
    595. 

  595. 	);
    596. 

  596. }
    597. 

  597. 

  598. /**
    599. 

  599. * Create forum navigation links for given forum, create parent
    600. 

  600. * list if currently null, assign basic forum info to template
    601. 

  601. */
    602. 

  602. function generate_forum_nav(&$forum_data)
    603. 

  603. {
    604. 

  604. 	global $db, $user, $template, $auth, $config;
    605. 

  605. 	global $phpEx, $phpbb_root_path;
    606. 

  606. 	// www.phpBB-SEO.com SEO TOOLKIT BEGIN
    607. 

  607. 	global $phpbb_seo;
    608. 

  608. 	// www.phpBB-SEO.com SEO TOOLKIT END
    609. 

  609. 	if (!$auth->acl_get('f_list', $forum_data['forum_id']))
    610. 

  610. 	{
    611. 

  611. 		return;
    612. 

  612. 	}
    613. 

  613. 

  614. 	// Get forum parents
    615. 

  615. 	$forum_parents = get_forum_parents($forum_data);
    616. 

  616. 

  617. 	// Build navigation links
    618. 

  618. 	if (!empty($forum_parents))
    619. 

  619. 	{
    620. 

  620. 		foreach ($forum_parents as $parent_forum_id => $parent_data)
    621. 

  621. 		{
    622. 

  622. 			list($parent_name, $parent_type) = array_values($parent_data);
    623. 

  623. 			// www.phpBB-SEO.com SEO TOOLKIT BEGIN
    624. 

  624. 			$phpbb_seo->set_url($parent_name, $parent_forum_id, 'forum');
    625. 

  625. 			// www.phpBB-SEO.com SEO TOOLKIT END
    626. 

  626. 			// Skip this parent if the user does not have the permission to view it
    627. 

  627. 			if (!$auth->acl_get('f_list', $parent_forum_id))
    628. 

  628. 			{
    629. 

  629. 				continue;
    630. 

  630. 			}
    631. 

  631. 

  632. 			$template->assign_block_vars('navlinks', array(
    633. 

  633. 				'S_IS_CAT'		=> ($parent_type == FORUM_CAT) ? true : false,
    634. 

  634. 				'S_IS_LINK'		=> ($parent_type == FORUM_LINK) ? true : false,
    635. 

  635. 				'S_IS_POST'		=> ($parent_type == FORUM_POST) ? true : false,
    636. 

  636. 				'FORUM_NAME'	=> $parent_name,
    637. 

  637. 				'FORUM_ID'		=> $parent_forum_id,
    638. 

  638. 				'U_VIEW_FORUM'	=> append_sid("{$phpbb_root_path}viewforum.$phpEx", 'f=' . $parent_forum_id))
    639. 

  639. 			);
    640. 

  640. 		}
    641. 

  641. 	}
    642. 

  642. 

  643. 	$template->assign_block_vars('navlinks', array(
    644. 

  644. 		'S_IS_CAT'		=> ($forum_data['forum_type'] == FORUM_CAT) ? true : false,
    645. 

  645. 		'S_IS_LINK'		=> ($forum_data['forum_type'] == FORUM_LINK) ? true : false,
    646. 

  646. 		'S_IS_POST'		=> ($forum_data['forum_type'] == FORUM_POST) ? true : false,
    647. 

  647. 		'FORUM_NAME'	=> $forum_data['forum_name'],
    648. 

  648. 		'FORUM_ID'		=> $forum_data['forum_id'],
    649. 

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

  650. 	);
    651. 

  651. 

  652. 	$template->assign_vars(array(
    653. 

  653. 		'FORUM_ID' 		=> $forum_data['forum_id'],
    654. 

  654. 		'FORUM_NAME'	=> $forum_data['forum_name'],
    655. 

  655. 		'FORUM_DESC'	=> generate_text_for_display($forum_data['forum_desc'], $forum_data['forum_desc_uid'], $forum_data['forum_desc_bitfield'], $forum_data['forum_desc_options']),
    656. 

  656. 

  657. 		'S_ENABLE_FEEDS_FORUM'	=> ($config['feed_forum'] && $forum_data['forum_type'] == FORUM_POST && !phpbb_optionget(FORUM_OPTION_FEED_EXCLUDE, $forum_data['forum_options'])) ? true : false,
    658. 

  658. 	));
    659. 

  659. 

  660. 	return;
    661. 

  661. }
    662. 

  662. 

  663. /**
    664. 

  664. * Returns forum parents as an array. Get them from forum_data if available, or update the database otherwise
    665. 

  665. */
    666. 

  666. function get_forum_parents(&$forum_data)
    667. 

  667. {
    668. 

  668. 	global $db;
    669. 

  669. 

  670. 	$forum_parents = array();
    671. 

  671. 

  672. 	if ($forum_data['parent_id'] > 0)
    673. 

  673. 	{
    674. 

  674. 		if ($forum_data['forum_parents'] == '')
    675. 

  675. 		{
    676. 

  676. 			$sql = 'SELECT forum_id, forum_name, forum_type
    677. 

  677. 				FROM ' . FORUMS_TABLE . '
    678. 

  678. 				WHERE left_id < ' . $forum_data['left_id'] . '
    679. 

  679. 					AND right_id > ' . $forum_data['right_id'] . '
    680. 

  680. 				ORDER BY left_id ASC';
    681. 

  681. 			$result = $db->sql_query($sql);
    682. 

  682. 

  683. 			while ($row = $db->sql_fetchrow($result))
    684. 

  684. 			{
    685. 

  685. 				$forum_parents[$row['forum_id']] = array($row['forum_name'], (int) $row['forum_type']);
    686. 

  686. 			}
    687. 

  687. 			$db->sql_freeresult($result);
    688. 

  688. 

  689. 			$forum_data['forum_parents'] = serialize($forum_parents);
    690. 

  690. 

  691. 			$sql = 'UPDATE ' . FORUMS_TABLE . "
    692. 

  692. 				SET forum_parents = '" . $db->sql_escape($forum_data['forum_parents']) . "'
    693. 

  693. 				WHERE parent_id = " . $forum_data['parent_id'];
    694. 

  694. 			$db->sql_query($sql);
    695. 

  695. 		}
    696. 

  696. 		else
    697. 

  697. 		{
    698. 

  698. 			$forum_parents = unserialize($forum_data['forum_parents']);
    699. 

  699. 		}
    700. 

  700. 	}
    701. 

  701. 

  702. 	return $forum_parents;
    703. 

  703. }
    704. 

  704. 

  705. /**
    706. 

  706. * Generate topic pagination
    707. 

  707. */
    708. 

  708. function topic_generate_pagination($replies, $url)
    709. 

  709. {
    710. 

  710. 	global $config, $user;
    711. 

  711. 	// www.phpBB-SEO.com SEO TOOLKIT BEGIN
    712. 

  712. 	global $phpbb_seo, $phpEx;
    713. 

  713. 	// www.phpBB-SEO.com SEO TOOLKIT END
    714. 

  714. 	// Make sure $per_page is a valid value
    715. 

  715. 	$per_page = ($config['posts_per_page'] <= 0) ? 1 : $config['posts_per_page'];
    716. 

  716. 

  717. 	if (($replies + 1) > $per_page)
    718. 

  718. 	{
    719. 

  719. 		$total_pages = ceil(($replies + 1) / $per_page);
    720. 

  720. 		$pagination = '';
    721. 

  721. 

  722. 		$times = 1;
    723. 

  723. 		for ($j = 0; $j < $replies + 1; $j += $per_page)
    724. 

  724. 		{
    725. 

  725. 			$pagination .= '<a href="' . $url . ($j == 0 ? '' : '&amp;start=' . $j) . '">' . $times . '</a>';
    726. 

  726. 			if ($times == 1 && $total_pages > 5)
    727. 

  727. 			{
    728. 

  728. 				$pagination .= ' ... ';
    729. 

  729. 

  730. 				// Display the last three pages
    731. 

  731. 				$times = $total_pages - 3;
    732. 

  732. 				$j += ($total_pages - 4) * $per_page;
    733. 

  733. 			}
    734. 

  734. 			else if ($times < $total_pages)
    735. 

  735. 			{
    736. 

  736. 				$pagination .= '<span class="page-sep">' . $user->lang['COMMA_SEPARATOR'] . '</span>';
    737. 

  737. 			}
    738. 

  738. 			$times++;
    739. 

  739. 		}
    740. 

  740. 		// www.phpBB-SEO.com SEO TOOLKIT BEGIN
    741. 

  741. 		if (!empty($phpbb_seo->seo_opt['url_rewrite'])) {
    742. 

  742. 			static $pagin_find = array();
    743. 

  743. 			static $pagin_replace = array();
    744. 

  744. 			if (empty($pagin_find)) {
    745. 

  745. 				$pagin_find = array(
    746. 

  746. 					// http://example.com/a_n-y/d.i.r/with.ext
    747. 

  747. 					'`(https?\://[a-z0-9_/\.-]+/[a-z0-9_\.-]+)(\.[a-z0-9]+)(\?[\w$%&~\-;:=,@+\. ]+)?(#[a-z0-9_\.-]+)?(&amp;|\?)start=([0-9]+)`i',
    748. 

  748. 					// http://example.com/a_n-y/d.i.r/withoutext
    749. 

  749. 					'`(https?\://[a-z0-9_/\.-]+/[a-z0-9_-]+)/?(\?[\w$%&~\-;:=,@+\. ]+)?(#[a-z0-9_\.-]+)?(&amp;|\?)start=([0-9]+)`i'
    750. 

  750. 				);
    751. 

  751. 				$pagin_replace = array(
    752. 

  752. 					// http://example.com/a_n-y/d.i.r/with-xx.ext
    753. 

  753. 					'\1' . $phpbb_seo->seo_delim['start'] . '\6\2\3\4',
    754. 

  754. 					// http://example.com/a_n-y/d.i.r/withoutext/pagexx.html
    755. 

  755. 					'\1/' . $phpbb_seo->seo_static['pagination'] . '\5' . $phpbb_seo->seo_ext['pagination'] . '\2\3'
    756. 

  756. 				);
    757. 

  757. 			}
    758. 

  758. 			$pagination = preg_replace( $pagin_find, $pagin_replace, $pagination );
    759. 

  759. 		}
    760. 

  760. 		// www.phpBB-SEO.com SEO TOOLKIT END
    761. 

  761. 	}
    762. 

  762. 	else
    763. 

  763. 	{
    764. 

  764. 		$pagination = '';
    765. 

  765. 	}
    766. 

  766. 

  767. 	return $pagination;
    768. 

  768. }
    769. 

  769. 

  770. /**
    771. 

  771. * Obtain list of moderators of each forum
    772. 

  772. */
    773. 

  773. function get_moderators(&$forum_moderators, $forum_id = false)
    774. 

  774. {
    775. 

  775. 	global $config, $template, $db, $phpbb_root_path, $phpEx, $user, $auth;
    776. 

  776. 	// www.phpBB-SEO.com SEO TOOLKIT BEGIN
    777. 

  777. 	global $phpbb_seo;
    778. 

  778. 	// www.phpBB-SEO.com SEO TOOLKIT END
    779. 

  779. 	$forum_id_ary = array();
    780. 

  780. 

  781. 	if ($forum_id !== false)
    782. 

  782. 	{
    783. 

  783. 		if (!is_array($forum_id))
    784. 

  784. 		{
    785. 

  785. 			$forum_id = array($forum_id);
    786. 

  786. 		}
    787. 

  787. 

  788. 		// Exchange key/value pair to be able to faster check for the forum id existence
    789. 

  789. 		$forum_id_ary = array_flip($forum_id);
    790. 

  790. 	}
    791. 

  791. 

  792. 	$sql_array = array(
    793. 

  793. 		'SELECT'	=> 'm.*, u.user_colour, g.group_colour, g.group_type',
    794. 

  794. 

  795. 		'FROM'		=> array(
    796. 

  796. 			MODERATOR_CACHE_TABLE	=> 'm',
    797. 

  797. 		),
    798. 

  798. 

  799. 		'LEFT_JOIN'	=> array(
    800. 

  800. 			array(
    801. 

  801. 				'FROM'	=> array(USERS_TABLE => 'u'),
    802. 

  802. 				'ON'	=> 'm.user_id = u.user_id',
    803. 

  803. 			),
    804. 

  804. 			array(
    805. 

  805. 				'FROM'	=> array(GROUPS_TABLE => 'g'),
    806. 

  806. 				'ON'	=> 'm.group_id = g.group_id',
    807. 

  807. 			),
    808. 

  808. 		),
    809. 

  809. 

  810. 		'WHERE'		=> 'm.display_on_index = 1',
    811. 

  811. 	);
    812. 

  812. 

  813. 	// We query every forum here because for caching we should not have any parameter.
    814. 

  814. 	$sql = $db->sql_build_query('SELECT', $sql_array);
    815. 

  815. 	$result = $db->sql_query($sql, 3600);
    816. 

  816. 

  817. 	while ($row = $db->sql_fetchrow($result))
    818. 

  818. 	{
    819. 

  819. 		$f_id = (int) $row['forum_id'];
    820. 

  820. 

  821. 		if (!isset($forum_id_ary[$f_id]))
    822. 

  822. 		{
    823. 

  823. 			continue;
    824. 

  824. 		}
    825. 

  825. 

  826. 		if (!empty($row['user_id']))
    827. 

  827. 		{
    828. 

  828. 			$forum_moderators[$f_id][] = get_username_string('full', $row['user_id'], $row['username'], $row['user_colour']);
    829. 

  829. 		}
    830. 

  830. 		else
    831. 

  831. 		{
    832. 

  832. 			// www.phpBB-SEO.com SEO TOOLKIT BEGIN
    833. 

  833. 			$phpbb_seo->prepare_url('group', $row['group_name'], $row['group_id']);
    834. 

  834. 			// www.phpBB-SEO.com SEO TOOLKIT END
    835. 

  835. 			$group_name = (($row['group_type'] == GROUP_SPECIAL) ? $user->lang['G_' . $row['group_name']] : $row['group_name']);
    836. 

  836. 

  837. 			if ($user->data['user_id'] != ANONYMOUS && !$auth->acl_get('u_viewprofile'))
    838. 

  838. 			{
    839. 

  839. 				$forum_moderators[$f_id][] = '<span' . (($row['group_colour']) ? ' style="color:#' . $row['group_colour'] . ';"' : '') . '>' . $group_name . '</span>';
    840. 

  840. 			}
    841. 

  841. 			else
    842. 

  842. 			{
    843. 

  843. 				$forum_moderators[$f_id][] = '<a' . (($row['group_colour']) ? ' style="color:#' . $row['group_colour'] . ';"' : '') . ' href="' . append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=group&amp;g=' . $row['group_id']) . '">' . $group_name . '</a>';
    844. 

  844. 			}
    845. 

  845. 		}
    846. 

  846. 	}
    847. 

  847. 	$db->sql_freeresult($result);
    848. 

  848. 

  849. 	return;
    850. 

  850. }
    851. 

  851. 

  852. /**
    853. 

  853. * User authorisation levels output
    854. 

  854. *
    855. 

  855. * @param	string	$mode			Can be forum or topic. Not in use at the moment.
    856. 

  856. * @param	int		$forum_id		The current forum the user is in.
    857. 

  857. * @param	int		$forum_status	The forums status bit.
    858. 

  858. */
    859. 

  859. function gen_forum_auth_level($mode, $forum_id, $forum_status)
    860. 

  860. {
    861. 

  861. 	global $template, $auth, $user, $config;
    862. 

  862. 

  863. 	$locked = ($forum_status == ITEM_LOCKED && !$auth->acl_get('m_edit', $forum_id)) ? true : false;
    864. 

  864. 

  865. 	$rules = array(
    866. 

  866. 		($auth->acl_get('f_post', $forum_id) && !$locked) ? $user->lang['RULES_POST_CAN'] : $user->lang['RULES_POST_CANNOT'],
    867. 

  867. 		($auth->acl_get('f_reply', $forum_id) && !$locked) ? $user->lang['RULES_REPLY_CAN'] : $user->lang['RULES_REPLY_CANNOT'],
    868. 

  868. 		($user->data['is_registered'] && $auth->acl_gets('f_edit', 'm_edit', $forum_id) && !$locked) ? $user->lang['RULES_EDIT_CAN'] : $user->lang['RULES_EDIT_CANNOT'],
    869. 

  869. 		($user->data['is_registered'] && $auth->acl_gets('f_delete', 'm_delete', $forum_id) && !$locked) ? $user->lang['RULES_DELETE_CAN'] : $user->lang['RULES_DELETE_CANNOT'],
    870. 

  870. 	);
    871. 

  871. 

  872. 	if ($config['allow_attachments'])
    873. 

  873. 	{
    874. 

  874. 		$rules[] = ($auth->acl_get('f_attach', $forum_id) && $auth->acl_get('u_attach') && !$locked) ? $user->lang['RULES_ATTACH_CAN'] : $user->lang['RULES_ATTACH_CANNOT'];
    875. 

  875. 	}
    876. 

  876. 

  877. 	foreach ($rules as $rule)
    878. 

  878. 	{
    879. 

  879. 		$template->assign_block_vars('rules', array('RULE' => $rule));
    880. 

  880. 	}
    881. 

  881. 

  882. 	return;
    883. 

  883. }
    884. 

  884. 

  885. /**
    886. 

  886. * Generate topic status
    887. 

  887. */
    888. 

  888. function topic_status(&$topic_row, $replies, $unread_topic, &$folder_img, &$folder_alt, &$topic_type)
    889. 

  889. {
    890. 

  890. 	global $user, $config;
    891. 

  891. 

  892. 	$folder = $folder_new = '';
    893. 

  893. 

  894. 	if ($topic_row['topic_status'] == ITEM_MOVED)
    895. 

  895. 	{
    896. 

  896. 		$topic_type = $user->lang['VIEW_TOPIC_MOVED'];
    897. 

  897. 		$folder_img = 'topic_moved';
    898. 

  898. 		$folder_alt = 'TOPIC_MOVED';
    899. 

  899. 	}
    900. 

  900. 	else
    901. 

  901. 	{
    902. 

  902. 		switch ($topic_row['topic_type'])
    903. 

  903. 		{
    904. 

  904. 			case POST_GLOBAL:
    905. 

  905. 				$topic_type = $user->lang['VIEW_TOPIC_GLOBAL'];
    906. 

  906. 				$folder = 'global_read';
    907. 

  907. 				$folder_new = 'global_unread';
    908. 

  908. 			break;
    909. 

  909. 

  910. 			case POST_ANNOUNCE:
    911. 

  911. 				$topic_type = $user->lang['VIEW_TOPIC_ANNOUNCEMENT'];
    912. 

  912. 				$folder = 'announce_read';
    913. 

  913. 				$folder_new = 'announce_unread';
    914. 

  914. 			break;
    915. 

  915. 

  916. 			case POST_STICKY:
    917. 

  917. 				$topic_type = $user->lang['VIEW_TOPIC_STICKY'];
    918. 

  918. 				$folder = 'sticky_read';
    919. 

  919. 				$folder_new = 'sticky_unread';
    920. 

  920. 			break;
    921. 

  921. 

  922. 			default:
    923. 

  923. 				$topic_type = '';
    924. 

  924. 				$folder = 'topic_read';
    925. 

  925. 				$folder_new = 'topic_unread';
    926. 

  926. 

  927. 				// Hot topic threshold is for posts in a topic, which is replies + the first post. ;)
    928. 

  928. 				if ($config['hot_threshold'] && ($replies + 1) >= $config['hot_threshold'] && $topic_row['topic_status'] != ITEM_LOCKED)
    929. 

  929. 				{
    930. 

  930. 					$folder .= '_hot';
    931. 

  931. 					$folder_new .= '_hot';
    932. 

  932. 				}
    933. 

  933. 			break;
    934. 

  934. 		}
    935. 

  935. 

  936. 		if ($topic_row['topic_status'] == ITEM_LOCKED)
    937. 

  937. 		{
    938. 

  938. 			$topic_type = $user->lang['VIEW_TOPIC_LOCKED'];
    939. 

  939. 			$folder .= '_locked';
    940. 

  940. 			$folder_new .= '_locked';
    941. 

  941. 		}
    942. 

  942. 

  943. 

  944. 		$folder_img = ($unread_topic) ? $folder_new : $folder;
    945. 

  945. 		$folder_alt = ($unread_topic) ? 'UNREAD_POSTS' : (($topic_row['topic_status'] == ITEM_LOCKED) ? 'TOPIC_LOCKED' : 'NO_UNREAD_POSTS');
    946. 

  946. 

  947. 		// Posted image?
    948. 

  948. 		if (!empty($topic_row['topic_posted']) && $topic_row['topic_posted'])
    949. 

  949. 		{
    950. 

  950. 			$folder_img .= '_mine';
    951. 

  951. 		}
    952. 

  952. 	}
    953. 

  953. 

  954. 	if ($topic_row['poll_start'] && $topic_row['topic_status'] != ITEM_MOVED)
    955. 

  955. 	{
    956. 

  956. 		$topic_type = $user->lang['VIEW_TOPIC_POLL'];
    957. 

  957. 	}
    958. 

  958. }
    959. 

  959. 

  960. /**
    961. 

  961. * Assign/Build custom bbcodes for display in screens supporting using of bbcodes
    962. 

  962. * The custom bbcodes buttons will be placed within the template block 'custom_codes'
    963. 

  963. */
    964. 

  964. function display_custom_bbcodes()
    965. 

  965. {
    966. 

  966. 	global $db, $template, $user;
    967. 

  967. 

  968. 	// Start counting from 22 for the bbcode ids (every bbcode takes two ids - opening/closing)
    969. 

  969. 	$num_predefined_bbcodes = 22;
    970. 

  970. 

  971. 	$sql = 'SELECT bbcode_id, bbcode_tag, bbcode_helpline
    972. 

  972. 		FROM ' . BBCODES_TABLE . '
    973. 

  973. 		WHERE display_on_posting = 1
    974. 

  974. 		ORDER BY bbcode_tag';
    975. 

  975. 	$result = $db->sql_query($sql);
    976. 

  976. 

  977. 	$i = 0;
    978. 

  978. 	while ($row = $db->sql_fetchrow($result))
    979. 

  979. 	{
    980. 

  980. 		// If the helpline is defined within the language file, we will use the localised version, else just use the database entry...
    981. 

  981. 		if (isset($user->lang[strtoupper($row['bbcode_helpline'])]))
    982. 

  982. 		{
    983. 

  983. 			$row['bbcode_helpline'] = $user->lang[strtoupper($row['bbcode_helpline'])];
    984. 

  984. 		}
    985. 

  985. 

  986. 		$template->assign_block_vars('custom_tags', array(
    987. 

  987. 			'BBCODE_NAME'		=> "'[{$row['bbcode_tag']}]', '[/" . str_replace('=', '', $row['bbcode_tag']) . "]'",
    988. 

  988. 			'BBCODE_ID'			=> $num_predefined_bbcodes + ($i * 2),
    989. 

  989. 			'BBCODE_TAG'		=> $row['bbcode_tag'],
    990. 

  990. 			'BBCODE_HELPLINE'	=> $row['bbcode_helpline'],
    991. 

  991. 			'A_BBCODE_HELPLINE'	=> str_replace(array('&amp;', '&quot;', "'", '&lt;', '&gt;'), array('&', '"', "\'", '<', '>'), $row['bbcode_helpline']),
    992. 

  992. 		));
    993. 

  993. 

  994. 		$i++;
    995. 

  995. 	}
    996. 

  996. 	$db->sql_freeresult($result);
    997. 

  997. }
    998. 

  998. 

  999. /**
    1000. 

  1000. * Display reasons
    1001. 

  1001. */
    1002. 

  1002. function display_reasons($reason_id = 0)
    1003. 

  1003. {
    1004. 

  1004. 	global $db, $user, $template;
    1005. 

  1005. 

  1006. 	$sql = 'SELECT *
    1007. 

  1007. 		FROM ' . REPORTS_REASONS_TABLE . '
    1008. 

  1008. 		ORDER BY reason_order ASC';
    1009. 

  1009. 	$result = $db->sql_query($sql);
    1010. 

  1010. 

  1011. 	while ($row = $db->sql_fetchrow($result))
    1012. 

  1012. 	{
    1013. 

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

  1014. 		if (isset($user->lang['report_reasons']['TITLE'][strtoupper($row['reason_title'])]) && isset($user->lang['report_reasons']['DESCRIPTION'][strtoupper($row['reason_title'])]))
    1015. 

  1015. 		{
    1016. 

  1016. 			$row['reason_description'] = $user->lang['report_reasons']['DESCRIPTION'][strtoupper($row['reason_title'])];
    1017. 

  1017. 			$row['reason_title'] = $user->lang['report_reasons']['TITLE'][strtoupper($row['reason_title'])];
    1018. 

  1018. 		}
    1019. 

  1019. 

  1020. 		$template->assign_block_vars('reason', array(
    1021. 

  1021. 			'ID'			=> $row['reason_id'],
    1022. 

  1022. 			'TITLE'			=> $row['reason_title'],
    1023. 

  1023. 			'DESCRIPTION'	=> $row['reason_description'],
    1024. 

  1024. 			'S_SELECTED'	=> ($row['reason_id'] == $reason_id) ? true : false)
    1025. 

  1025. 		);
    1026. 

  1026. 	}
    1027. 

  1027. 	$db->sql_freeresult($result);
    1028. 

  1028. }
    1029. 

  1029. 

  1030. /**
    1031. 

  1031. * Display user activity (action forum/topic)
    1032. 

  1032. */
    1033. 

  1033. function display_user_activity(&$userdata)
    1034. 

  1034. {
    1035. 

  1035. 	global $auth, $template, $db, $user;
    1036. 

  1036. 	global $phpbb_root_path, $phpEx;
    1037. 

  1037. 	// www.phpBB-SEO.com SEO TOOLKIT BEGIN
    1038. 

  1038. 	global $phpbb_seo;
    1039. 

  1039. 	// www.phpBB-SEO.com SEO TOOLKIT END
    1040. 

  1040. 	// Do not display user activity for users having more than 5000 posts...
    1041. 

  1041. 	if ($userdata['user_posts'] > 5000)
    1042. 

  1042. 	{
    1043. 

  1043. 		return;
    1044. 

  1044. 	}
    1045. 

  1045. 

  1046. 	$forum_ary = array();
    1047. 

  1047. 

  1048. 	// Do not include those forums the user is not having read access to...
    1049. 

  1049. 	$forum_read_ary = $auth->acl_getf('!f_read');
    1050. 

  1050. 

  1051. 	foreach ($forum_read_ary as $forum_id => $not_allowed)
    1052. 

  1052. 	{
    1053. 

  1053. 		if ($not_allowed['f_read'])
    1054. 

  1054. 		{
    1055. 

  1055. 			$forum_ary[] = (int) $forum_id;
    1056. 

  1056. 		}
    1057. 

  1057. 	}
    1058. 

  1058. 

  1059. 	$forum_ary = array_unique($forum_ary);
    1060. 

  1060. 	$forum_sql = (sizeof($forum_ary)) ? 'AND ' . $db->sql_in_set('forum_id', $forum_ary, true) : '';
    1061. 

  1061. 

  1062. 	$fid_m_approve = $auth->acl_getf('m_approve', true);
    1063. 

  1063. 	$sql_m_approve = (!empty($fid_m_approve)) ? 'OR ' . $db->sql_in_set('forum_id', array_keys($fid_m_approve)) : '';
    1064. 

  1064. 

  1065. 	// Obtain active forum
    1066. 

  1066. 	$sql = 'SELECT forum_id, COUNT(post_id) AS num_posts
    1067. 

  1067. 		FROM ' . POSTS_TABLE . '
    1068. 

  1068. 		WHERE poster_id = ' . $userdata['user_id'] . "
    1069. 

  1069. 			AND post_postcount = 1
    1070. 

  1070. 			AND (post_approved = 1
    1071. 

  1071. 				$sql_m_approve)
    1072. 

  1072. 			$forum_sql
    1073. 

  1073. 		GROUP BY forum_id
    1074. 

  1074. 		ORDER BY num_posts DESC";
    1075. 

  1075. 	$result = $db->sql_query_limit($sql, 1);
    1076. 

  1076. 	$active_f_row = $db->sql_fetchrow($result);
    1077. 

  1077. 	$db->sql_freeresult($result);
    1078. 

  1078. 

  1079. 	if (!empty($active_f_row))
    1080. 

  1080. 	{
    1081. 

  1081. 		$sql = 'SELECT forum_name
    1082. 

  1082. 			FROM ' . FORUMS_TABLE . '
    1083. 

  1083. 			WHERE forum_id = ' . $active_f_row['forum_id'];
    1084. 

  1084. 		$result = $db->sql_query($sql, 3600);
    1085. 

  1085. 		$active_f_row['forum_name'] = (string) $db->sql_fetchfield('forum_name');
    1086. 

  1086. 		$db->sql_freeresult($result);
    1087. 

  1087. 	}
    1088. 

  1088. 

  1089. 	// Obtain active topic
    1090. 

  1090. 	$sql = 'SELECT topic_id, COUNT(post_id) AS num_posts
    1091. 

  1091. 		FROM ' . POSTS_TABLE . '
    1092. 

  1092. 		WHERE poster_id = ' . $userdata['user_id'] . "
    1093. 

  1093. 			AND post_postcount = 1
    1094. 

  1094. 			AND (post_approved = 1
    1095. 

  1095. 				$sql_m_approve)
    1096. 

  1096. 			$forum_sql
    1097. 

  1097. 		GROUP BY topic_id
    1098. 

  1098. 		ORDER BY num_posts DESC";
    1099. 

  1099. 	$result = $db->sql_query_limit($sql, 1);
    1100. 

  1100. 	$active_t_row = $db->sql_fetchrow($result);
    1101. 

  1101. 	$db->sql_freeresult($result);
    1102. 

  1102. 

  1103. 	if (!empty($active_t_row))
    1104. 

  1104. 	{
    1105. 

  1105. 		// www.phpBB-SEO.com SEO TOOLKIT BEGIN
    1106. 

  1106. 		$sql_array = array(
    1107. 

  1107. 			'SELECT'	=> 't.topic_title, t.topic_type ' . (!empty($phpbb_seo->seo_opt['sql_rewrite']) ? ', t.topic_url' : '') . ', f.forum_id, f.forum_name',
    1108. 

  1108. 			'FROM'		=> array(
    1109. 

  1109. 				TOPICS_TABLE	=> 't',
    1110. 

  1110. 			),
    1111. 

  1111. 			'LEFT_JOIN' => array(
    1112. 

  1112. 				array(
    1113. 

  1113. 					'FROM'	=> array(FORUMS_TABLE => 'f'),
    1114. 

  1114. 					'ON'	=> 'f.forum_id = t.forum_id',
    1115. 

  1115. 				),
    1116. 

  1116. 			),
    1117. 

  1117. 			'WHERE' => 't.topic_id = ' . (int) $active_t_row['topic_id']
    1118. 

  1118. 		);
    1119. 

  1119. 		$result = $db->sql_query($db->sql_build_query('SELECT', $sql_array));
    1120. 

  1120. 		$seo_active_t_row = $db->sql_fetchrow($result);
    1121. 

  1121. 		$db->sql_freeresult($result);
    1122. 

  1122. 		if ($seo_active_t_row) {
    1123. 

  1123. 			$active_t_row = array_merge($active_t_row, $seo_active_t_row);
    1124. 

  1124. 		}
    1125. 

  1125. 		// www.phpBB-SEO.com SEO TOOLKIT END
    1126. 

  1126. 	}
    1127. 

  1127. 

  1128. 	$userdata['active_t_row'] = $active_t_row;
    1129. 

  1129. 	$userdata['active_f_row'] = $active_f_row;
    1130. 

  1130. 

  1131. 	$active_f_name = $active_f_id = $active_f_count = $active_f_pct = '';
    1132. 

  1132. 	if (!empty($active_f_row['num_posts']))
    1133. 

  1133. 	{
    1134. 

  1134. 		$active_f_name = $active_f_row['forum_name'];
    1135. 

  1135. 		$active_f_id = $active_f_row['forum_id'];
    1136. 

  1136. 		$active_f_count = $active_f_row['num_posts'];
    1137. 

  1137. 		$active_f_pct = ($userdata['user_posts']) ? ($active_f_count / $userdata['user_posts']) * 100 : 0;
    1138. 

  1138. 		// www.phpBB-SEO.com SEO TOOLKIT BEGIN
    1139. 

  1139. 		$phpbb_seo->set_url($active_f_name, $active_f_id, 'forum');
    1140. 

  1140. 		// www.phpBB-SEO.com SEO TOOLKIT END
    1141. 

  1141. 	}
    1142. 

  1142. 

  1143. 	$active_t_name = $active_t_id = $active_t_count = $active_t_pct = '';
    1144. 

  1144. 	if (!empty($active_t_row['num_posts']))
    1145. 

  1145. 	{
    1146. 

  1146. 		$active_t_name = $active_t_row['topic_title'];
    1147. 

  1147. 		$active_t_id = $active_t_row['topic_id'];
    1148. 

  1148. 		$active_t_count = $active_t_row['num_posts'];
    1149. 

  1149. 		$active_t_pct = ($userdata['user_posts']) ? ($active_t_count / $userdata['user_posts']) * 100 : 0;
    1150. 

  1150. 		// www.phpBB-SEO.com SEO TOOLKIT BEGIN
    1151. 

  1151. 		if (!empty($seo_active_t_row)) {
    1152. 

  1152. 			$active_t_forum_id = (int) $active_t_row['forum_id'];
    1153. 

  1153. 			$phpbb_seo->set_url($active_t_row['forum_name'], $active_t_forum_id, 'forum');
    1154. 

  1154. 			$phpbb_seo->prepare_iurl($active_t_row, 'topic', $active_t_row['topic_type'] == POST_GLOBAL ? $phpbb_seo->seo_static['global_announce'] : $phpbb_seo->seo_url['forum'][$active_t_forum_id]);
    1155. 

  1155. 		}
    1156. 

  1156. 		// www.phpBB-SEO.com SEO TOOLKIT END
    1157. 

  1157. 	}
    1158. 

  1158. 

  1159. 	$l_active_pct = ($userdata['user_id'] != ANONYMOUS && $userdata['user_id'] == $user->data['user_id']) ? $user->lang['POST_PCT_ACTIVE_OWN'] : $user->lang['POST_PCT_ACTIVE'];
    1160. 

  1160. 

  1161. 	$template->assign_vars(array(
    1162. 

  1162. 		'ACTIVE_FORUM'			=> $active_f_name,
    1163. 

  1163. 		'ACTIVE_FORUM_POSTS'	=> ($active_f_count == 1) ? sprintf($user->lang['USER_POST'], 1) : sprintf($user->lang['USER_POSTS'], $active_f_count),
    1164. 

  1164. 		'ACTIVE_FORUM_PCT'		=> sprintf($l_active_pct, $active_f_pct),
    1165. 

  1165. 		'ACTIVE_TOPIC'			=> censor_text($active_t_name),
    1166. 

  1166. 		'ACTIVE_TOPIC_POSTS'	=> ($active_t_count == 1) ? sprintf($user->lang['USER_POST'], 1) : sprintf($user->lang['USER_POSTS'], $active_t_count),
    1167. 

  1167. 		'ACTIVE_TOPIC_PCT'		=> sprintf($l_active_pct, $active_t_pct),
    1168. 

  1168. 		'U_ACTIVE_FORUM'		=> append_sid("{$phpbb_root_path}viewforum.$phpEx", 'f=' . $active_f_id),
    1169. 

  1169. 		'U_ACTIVE_TOPIC'		=> append_sid("{$phpbb_root_path}viewtopic.$phpEx", 't=' . $active_t_id),
    1170. 

  1170. 		'S_SHOW_ACTIVITY'		=> true)
    1171. 

  1171. 	);
    1172. 

  1172. }
    1173. 

  1173. 

  1174. /**
    1175. 

  1175. * Topic and forum watching common code
    1176. 

  1176. */
    1177. 

  1177. function watch_topic_forum($mode, &$s_watching, $user_id, $forum_id, $topic_id, $notify_status = 'unset', $start = 0)
    1178. 

  1178. {
    1179. 

  1179. 	global $template, $db, $user, $phpEx, $start, $phpbb_root_path;
    1180. 

  1180. 

  1181. 	$table_sql = ($mode == 'forum') ? FORUMS_WATCH_TABLE : TOPICS_WATCH_TABLE;
    1182. 

  1182. 	$where_sql = ($mode == 'forum') ? 'forum_id' : 'topic_id';
    1183. 

  1183. 	$match_id = ($mode == 'forum') ? $forum_id : $topic_id;
    1184. 

  1184. 	$u_url = "uid={$user->data['user_id']}";
    1185. 

  1185. 	$u_url .= ($mode == 'forum') ? '&amp;f' : '&amp;f=' . $forum_id . '&amp;t';
    1186. 

  1186. 

  1187. 	// Is user watching this thread?
    1188. 

  1188. 	if ($user_id != ANONYMOUS)
    1189. 

  1189. 	{
    1190. 

  1190. 		$can_watch = true;
    1191. 

  1191. 

  1192. 		if ($notify_status == 'unset')
    1193. 

  1193. 		{
    1194. 

  1194. 			$sql = "SELECT notify_status
    1195. 

  1195. 				FROM $table_sql
    1196. 

  1196. 				WHERE $where_sql = $match_id
    1197. 

  1197. 					AND user_id = $user_id";
    1198. 

  1198. 			$result = $db->sql_query($sql);
    1199. 

  1199. 

  1200. 			$notify_status = ($row = $db->sql_fetchrow($result)) ? $row['notify_status'] : NULL;
    1201. 

  1201. 			$db->sql_freeresult($result);
    1202. 

  1202. 		}
    1203. 

  1203. 

  1204. 		if (!is_null($notify_status) && $notify_status !== '')
    1205. 

  1205. 		{
    1206. 

  1206. 

  1207. 			if (isset($_GET['unwatch']))
    1208. 

  1208. 			{
    1209. 

  1209. 				$uid = request_var('uid', 0);
    1210. 

  1210. 				if ($uid != $user_id)
    1211. 

  1211. 				{
    1212. 

  1212. 					$redirect_url = append_sid("{$phpbb_root_path}view$mode.$phpEx", "$u_url=$match_id&amp;start=$start");
    1213. 

  1213. 					$message = $user->lang['ERR_UNWATCHING'] . '<br /><br />' . sprintf($user->lang['RETURN_' . strtoupper($mode)], '<a href="' . $redirect_url . '">', '</a>');
    1214. 

  1214. 					trigger_error($message);
    1215. 

  1215. 				}
    1216. 

  1216. 				if ($_GET['unwatch'] == $mode)
    1217. 

  1217. 				{
    1218. 

  1218. 					$is_watching = 0;
    1219. 

  1219. 

  1220. 					$sql = 'DELETE FROM ' . $table_sql . "
    1221. 

  1221. 						WHERE $where_sql = $match_id
    1222. 

  1222. 							AND user_id = $user_id";
    1223. 

  1223. 					$db->sql_query($sql);
    1224. 

  1224. 				}
    1225. 

  1225. 

  1226. 				$redirect_url = append_sid("{$phpbb_root_path}view$mode.$phpEx", "$u_url=$match_id&amp;start=$start");
    1227. 

  1227. 

  1228. 				meta_refresh(3, $redirect_url);
    1229. 

  1229. 

  1230. 				$message = $user->lang['NOT_WATCHING_' . strtoupper($mode)] . '<br /><br />' . sprintf($user->lang['RETURN_' . strtoupper($mode)], '<a href="' . $redirect_url . '">', '</a>');
    1231. 

  1231. 				trigger_error($message);
    1232. 

  1232. 			}
    1233. 

  1233. 			else
    1234. 

  1234. 			{
    1235. 

  1235. 				$is_watching = true;
    1236. 

  1236. 

  1237. 				if ($notify_status != NOTIFY_YES)
    1238. 

  1238. 				{
    1239. 

  1239. 					$sql = 'UPDATE ' . $table_sql . "
    1240. 

  1240. 						SET notify_status = " . NOTIFY_YES . "
    1241. 

  1241. 						WHERE $where_sql = $match_id
    1242. 

  1242. 							AND user_id = $user_id";
    1243. 

  1243. 					$db->sql_query($sql);
    1244. 

  1244. 				}
    1245. 

  1245. 			}
    1246. 

  1246. 		}
    1247. 

  1247. 		else
    1248. 

  1248. 		{
    1249. 

  1249. 			if (isset($_GET['watch']))
    1250. 

  1250. 			{
    1251. 

  1251. 				$token = request_var('hash', '');
    1252. 

  1252. 				$redirect_url = append_sid("{$phpbb_root_path}view$mode.$phpEx", "$u_url=$match_id&amp;start=$start");
    1253. 

  1253. 

  1254. 				if ($_GET['watch'] == $mode && check_link_hash($token, "{$mode}_$match_id"))
    1255. 

  1255. 				{
    1256. 

  1256. 					$is_watching = true;
    1257. 

  1257. 

  1258. 					$sql = 'INSERT INTO ' . $table_sql . " (user_id, $where_sql, notify_status)
    1259. 

  1259. 						VALUES ($user_id, $match_id, " . NOTIFY_YES . ')';
    1260. 

  1260. 					$db->sql_query($sql);
    1261. 

  1261. 					$message = $user->lang['ARE_WATCHING_' . strtoupper($mode)] . '<br /><br />' . sprintf($user->lang['RETURN_' . strtoupper($mode)], '<a href="' . $redirect_url . '">', '</a>');
    1262. 

  1262. 				}
    1263. 

  1263. 				else
    1264. 

  1264. 				{
    1265. 

  1265. 					$message = $user->lang['ERR_WATCHING'] . '<br /><br />' . sprintf($user->lang['RETURN_' . strtoupper($mode)], '<a href="' . $redirect_url . '">', '</a>');
    1266. 

  1266. 				}
    1267. 

  1267. 

  1268. 				meta_refresh(3, $redirect_url);
    1269. 

  1269. 

  1270. 				trigger_error($message);
    1271. 

  1271. 			}
    1272. 

  1272. 			else
    1273. 

  1273. 			{
    1274. 

  1274. 				$is_watching = 0;
    1275. 

  1275. 			}
    1276. 

  1276. 		}
    1277. 

  1277. 	}
    1278. 

  1278. 	else
    1279. 

  1279. 	{
    1280. 

  1280. 		if (isset($_GET['unwatch']) && $_GET['unwatch'] == $mode)
    1281. 

  1281. 		{
    1282. 

  1282. 			login_box();
    1283. 

  1283. 		}
    1284. 

  1284. 		else
    1285. 

  1285. 		{
    1286. 

  1286. 			$can_watch = 0;
    1287. 

  1287. 			$is_watching = 0;
    1288. 

  1288. 		}
    1289. 

  1289. 	}
    1290. 

  1290. 

  1291. 	if ($can_watch)
    1292. 

  1292. 	{
    1293. 

  1293. 		$s_watching['link'] = append_sid("{$phpbb_root_path}view$mode.$phpEx", "$u_url=$match_id&amp;" . (($is_watching) ? 'unwatch' : 'watch') . "=$mode&amp;start=$start&amp;hash=" . generate_link_hash("{$mode}_$match_id"));
    1294. 

  1294. 		$s_watching['title'] = $user->lang[(($is_watching) ? 'STOP' : 'START') . '_WATCHING_' . strtoupper($mode)];
    1295. 

  1295. 		$s_watching['is_watching'] = $is_watching;
    1296. 

  1296. 	}
    1297. 

  1297. 

  1298. 	return;
    1299. 

  1299. }
    1300. 

  1300. 

  1301. /**
    1302. 

  1302. * Get user rank title and image
    1303. 

  1303. *
    1304. 

  1304. * @param int $user_rank the current stored users rank id
    1305. 

  1305. * @param int $user_posts the users number of posts
    1306. 

  1306. * @param string &$rank_title the rank title will be stored here after execution
    1307. 

  1307. * @param string &$rank_img the rank image as full img tag is stored here after execution
    1308. 

  1308. * @param string &$rank_img_src the rank image source is stored here after execution
    1309. 

  1309. *
    1310. 

  1310. * Note: since we do not want to break backwards-compatibility, this function will only properly assign ranks to guests if you call it for them with user_posts == false
    1311. 

  1311. */
    1312. 

  1312. function get_user_rank($user_rank, $user_posts, &$rank_title, &$rank_img, &$rank_img_src)
    1313. 

  1313. {
    1314. 

  1314. 	global $ranks, $config, $phpbb_root_path;
    1315. 

  1315. 

  1316. 	if (empty($ranks))
    1317. 

  1317. 	{
    1318. 

  1318. 		global $cache;
    1319. 

  1319. 		$ranks = $cache->obtain_ranks();
    1320. 

  1320. 	}
    1321. 

  1321. 

  1322. 	if (!empty($user_rank))
    1323. 

  1323. 	{
    1324. 

  1324. 		$rank_title = (isset($ranks['special'][$user_rank]['rank_title'])) ? $ranks['special'][$user_rank]['rank_title'] : '';
    1325. 

  1325. 		$rank_img = (!empty($ranks['special'][$user_rank]['rank_image'])) ? '<img src="' . $phpbb_root_path . $config['ranks_path'] . '/' . $ranks['special'][$user_rank]['rank_image'] . '" alt="' . $ranks['special'][$user_rank]['rank_title'] . '" title="' . $ranks['special'][$user_rank]['rank_title'] . '" />' : '';
    1326. 

  1326. 		$rank_img_src = (!empty($ranks['special'][$user_rank]['rank_image'])) ? $phpbb_root_path . $config['ranks_path'] . '/' . $ranks['special'][$user_rank]['rank_image'] : '';
    1327. 

  1327. 	}
    1328. 

  1328. 	else if ($user_posts !== false)
    1329. 

  1329. 	{
    1330. 

  1330. 		if (!empty($ranks['normal']))
    1331. 

  1331. 		{
    1332. 

  1332. 			foreach ($ranks['normal'] as $rank)
    1333. 

  1333. 			{
    1334. 

  1334. 				if ($user_posts >= $rank['rank_min'])
    1335. 

  1335. 				{
    1336. 

  1336. 					$rank_title = $rank['rank_title'];
    1337. 

  1337. 					$rank_img = (!empty($rank['rank_image'])) ? '<img src="' . $phpbb_root_path . $config['ranks_path'] . '/' . $rank['rank_image'] . '" alt="' . $rank['rank_title'] . '" title="' . $rank['rank_title'] . '" />' : '';
    1338. 

  1338. 					$rank_img_src = (!empty($rank['rank_image'])) ? $phpbb_root_path . $config['ranks_path'] . '/' . $rank['rank_image'] : '';
    1339. 

  1339. 					break;
    1340. 

  1340. 				}
    1341. 

  1341. 			}
    1342. 

  1342. 		}
    1343. 

  1343. 	}
    1344. 

  1344. }
    1345. 

  1345. 

  1346. /**
    1347. 

  1347. * Get user avatar
    1348. 

  1348. *
    1349. 

  1349. * @param string $avatar Users assigned avatar name
    1350. 

  1350. * @param int $avatar_type Type of avatar
    1351. 

  1351. * @param string $avatar_width Width of users avatar
    1352. 

  1352. * @param string $avatar_height Height of users avatar
    1353. 

  1353. * @param string $alt Optional language string for alt tag within image, can be a language key or text
    1354. 

  1354. * @param bool $ignore_config Ignores the config-setting, to be still able to view the avatar in the UCP
    1355. 

  1355. *
    1356. 

  1356. * @return string Avatar image
    1357. 

  1357. */
    1358. 

  1358. function get_user_avatar($avatar, $avatar_type, $avatar_width, $avatar_height, $alt = 'USER_AVATAR', $ignore_config = false)
    1359. 

  1359. {
    1360. 

  1360. 	global $user, $config, $phpbb_root_path, $phpEx;
    1361. 

  1361. 

  1362. 	if (empty($avatar) || !$avatar_type || (!$config['allow_avatar'] && !$ignore_config))
    1363. 

  1363. 	{
    1364. 

  1364. 		return '';
    1365. 

  1365. 	}
    1366. 

  1366. 

  1367. 	$avatar_img = '';
    1368. 

  1368. 

  1369. 	switch ($avatar_type)
    1370. 

  1370. 	{
    1371. 

  1371. 		case AVATAR_UPLOAD:
    1372. 

  1372. 			if (!$config['allow_avatar_upload'] && !$ignore_config)
    1373. 

  1373. 			{
    1374. 

  1374. 				return '';
    1375. 

  1375. 			}
    1376. 

  1376. 			$avatar_img = $phpbb_root_path . "download/file.$phpEx?avatar=";
    1377. 

  1377. 		break;
    1378. 

  1378. 

  1379. 		case AVATAR_GALLERY:
    1380. 

  1380. 			if (!$config['allow_avatar_local'] && !$ignore_config)
    1381. 

  1381. 			{
    1382. 

  1382. 				return '';
    1383. 

  1383. 			}
    1384. 

  1384. 			$avatar_img = $phpbb_root_path . $config['avatar_gallery_path'] . '/';
    1385. 

  1385. 		break;
    1386. 

  1386. 

  1387. 		case AVATAR_REMOTE:
    1388. 

  1388. 			if (!$config['allow_avatar_remote'] && !$ignore_config)
    1389. 

  1389. 			{
    1390. 

  1390. 				return '';
    1391. 

  1391. 			}
    1392. 

  1392. 		break;
    1393. 

  1393. 	}
    1394. 

  1394. 

  1395. 	$avatar_img .= $avatar;
    1396. 

  1396. 	return '<img src="' . (str_replace(' ', '%20', $avatar_img)) . '" width="' . $avatar_width . '" height="' . $avatar_height . '" alt="' . ((!empty($user->lang[$alt])) ? $user->lang[$alt] : $alt) . '" />';
    1397. 

  1397. }
    1398. 

  1398. 

  1399. ?>
    1400.