phpBB/viewtopic.php

   1 <?php
   2 /**
   3 *
   4 * @package phpBB3
   5 * @version $Id$
   6 * @copyright (c) 2005 phpBB Group
   7 * @license http://opensource.org/licenses/gpl-license.php GNU Public License
   8 *
   9 */
  10
  11 /**
  12 * @ignore
  13 */
  14 define('IN_PHPBB', true);
  15 if (!defined('PHPBB_ROOT_PATH')) define('PHPBB_ROOT_PATH', './');
  16 if (!defined('PHP_EXT')) define('PHP_EXT', substr(strrchr(__FILE__, '.'), 1));
  17 include(PHPBB_ROOT_PATH . 'common.' . PHP_EXT);
  18 include(PHPBB_ROOT_PATH . 'includes/functions_display.' . PHP_EXT);
  19 include(PHPBB_ROOT_PATH . 'includes/bbcode.' . PHP_EXT);
  20
  21 // Start session management
  22 $user->session_begin();
  23 $auth->acl($user->data);
  24
  25 // Initial var setup
  26 $forum_id       = request_var('f', 0);
  27 $topic_id       = request_var('t', 0);
  28 $post_id        = request_var('p', 0);
  29 $voted_id       = request_var('vote_id', array('' => 0));
  30
  31 $start          = request_var('start', 0);
  32 $view           = request_var('view', '');
  33
  34 $default_sort_days      = (!empty($user->data['user_post_show_days'])) ? $user->data['user_post_show_days'] : 0;
  35 $default_sort_key       = (!empty($user->data['user_post_sortby_type'])) ? $user->data['user_post_sortby_type'] : 't';
  36 $default_sort_dir       = (!empty($user->data['user_post_sortby_dir'])) ? $user->data['user_post_sortby_dir'] : 'a';
  37
  38 $sort_days      = request_var('st', $default_sort_days);
  39 $sort_key       = request_var('sk', $default_sort_key);
  40 $sort_dir       = request_var('sd', $default_sort_dir);
  41
  42 $update         = request_var('update', false);
  43
  44 /**
  45 * @todo normalize?
  46 */
  47 $hilit_words    = request_var('hilit', '', true);
  48
  49 // Do we have a topic or post id?
  50 if (!$topic_id && !$post_id)
  51 {
  52         trigger_error('NO_TOPIC');
  53 }
  54
  55 // Find topic id if user requested a newer or older topic
  56 if ($view && !$post_id)
  57 {
  58         if (!$forum_id)
  59         {
  60                 $sql = 'SELECT forum_id
  61                         FROM ' . TOPICS_TABLE . "
  62                         WHERE topic_id = $topic_id";
  63                 $result = $db->sql_query($sql);
  64                 $forum_id = (int) $db->sql_fetchfield('forum_id');
  65                 $db->sql_freeresult($result);
  66
  67                 if (!$forum_id)
  68                 {
  69                         trigger_error('NO_TOPIC');
  70                 }
  71         }
  72
  73         if ($view == 'unread')
  74         {
  75                 // Get topic tracking info
  76                 $topic_tracking_info = get_complete_topic_tracking($forum_id, $topic_id);
  77
  78                 $topic_last_read = (isset($topic_tracking_info[$topic_id])) ? $topic_tracking_info[$topic_id] : 0;
  79
  80                 $sql = 'SELECT post_id, topic_id, forum_id
  81                         FROM ' . POSTS_TABLE . "
  82                         WHERE topic_id = $topic_id
  83                                 " . (($auth->acl_get('m_approve', $forum_id)) ? '' : 'AND post_approved = 1') . "
  84                                 AND post_time > $topic_last_read
  85                         ORDER BY post_time ASC";
  86                 $result = $db->sql_query_limit($sql, 1);
  87                 $row = $db->sql_fetchrow($result);
  88                 $db->sql_freeresult($result);
  89
  90                 if (!$row)
  91                 {
  92                         $sql = 'SELECT topic_last_post_id as post_id, topic_id, forum_id
  93                                 FROM ' . TOPICS_TABLE . '
  94                                 WHERE topic_id = ' . $topic_id;
  95                         $result = $db->sql_query($sql);
  96                         $row = $db->sql_fetchrow($result);
  97                         $db->sql_freeresult($result);
  98                 }
  99
 100                 if (!$row)
 101                 {
 102                         // Setup user environment so we can process lang string
 103                         $user->setup('viewtopic');
 104
 105                         trigger_error('NO_TOPIC');
 106                 }
 107
 108                 $post_id = $row['post_id'];
 109                 $topic_id = $row['topic_id'];
 110         }
 111         else if ($view == 'next' || $view == 'previous')
 112         {
 113                 $sql_condition = ($view == 'next') ? '>' : '<';
 114                 $sql_ordering = ($view == 'next') ? 'ASC' : 'DESC';
 115
 116                 $sql = 'SELECT forum_id, topic_last_post_time
 117                         FROM ' . TOPICS_TABLE . '
 118                         WHERE topic_id = ' . $topic_id;
 119                 $result = $db->sql_query($sql);
 120                 $row = $db->sql_fetchrow($result);
 121                 $db->sql_freeresult($result);
 122
 123                 if (!$row)
 124                 {
 125                         $user->setup('viewtopic');
 126                         // OK, the topic doesn't exist. This error message is not helpful, but technically correct.
 127                         trigger_error(($view == 'next') ? 'NO_NEWER_TOPICS' : 'NO_OLDER_TOPICS');
 128                 }
 129                 else
 130                 {
 131                         $sql = 'SELECT topic_id, forum_id
 132                                 FROM ' . TOPICS_TABLE . '
 133                                 WHERE forum_id = ' . $row['forum_id'] . "
 134                                         AND topic_moved_id = 0
 135                                         AND topic_last_post_time $sql_condition {$row['topic_last_post_time']}
 136                                         " . (($auth->acl_get('m_approve', $row['forum_id'])) ? '' : 'AND topic_approved = 1') . "
 137                                 ORDER BY topic_last_post_time $sql_ordering";
 138                         $result = $db->sql_query_limit($sql, 1);
 139                         $row = $db->sql_fetchrow($result);
 140                         $db->sql_freeresult($result);
 141
 142                         if (!$row)
 143                         {
 144                                 $user->setup('viewtopic');
 145                                 trigger_error(($view == 'next') ? 'NO_NEWER_TOPICS' : 'NO_OLDER_TOPICS');
 146                         }
 147                         else
 148                         {
 149                                 $topic_id = $row['topic_id'];
 150
 151                                 // Check for global announcement correctness?
 152                                 if (!$row['forum_id'] && !$forum_id)
 153                                 {
 154                                         trigger_error('NO_TOPIC');
 155                                 }
 156                                 else if ($row['forum_id'])
 157                                 {
 158                                         $forum_id = $row['forum_id'];
 159                                 }
 160                         }
 161                 }
 162         }
 163
 164         // Check for global announcement correctness?
 165         if ((!isset($row) || !$row['forum_id']) && !$forum_id)
 166         {
 167                 trigger_error('NO_TOPIC');
 168         }
 169         else if (isset($row) && $row['forum_id'])
 170         {
 171                 $forum_id = $row['forum_id'];
 172         }
 173 }
 174
 175 // This rather complex gaggle of code handles querying for topics but
 176 // also allows for direct linking to a post (and the calculation of which
 177 // page the post is on and the correct display of viewtopic)
 178 $sql_array = array(
 179         'SELECT'        => 't.*, f.*',
 180
 181         'FROM'          => array(FORUMS_TABLE => 'f'),
 182 );
 183
 184 // The FROM-Order is quite important here, else t.* columns can not be correctly bound.
 185 if ($post_id)
 186 {
 187         $sql_array['FROM'][POSTS_TABLE] = 'p';
 188 }
 189
 190 // Topics table need to be the last in the chain
 191 $sql_array['FROM'][TOPICS_TABLE] = 't';
 192
 193 if ($user->data['is_registered'])
 194 {
 195         $sql_array['SELECT'] .= ', tw.notify_status';
 196         $sql_array['LEFT_JOIN'] = array();
 197
 198         $sql_array['LEFT_JOIN'][] = array(
 199                 'FROM'  => array(TOPICS_WATCH_TABLE => 'tw'),
 200                 'ON'    => 'tw.user_id = ' . $user->data['user_id'] . ' AND t.topic_id = tw.topic_id'
 201         );
 202
 203         if ($config['allow_bookmarks'])
 204         {
 205                 $sql_array['SELECT'] .= ', bm.topic_id as bookmarked';
 206                 $sql_array['LEFT_JOIN'][] = array(
 207                         'FROM'  => array(BOOKMARKS_TABLE => 'bm'),
 208                         'ON'    => 'bm.user_id = ' . $user->data['user_id'] . ' AND t.topic_id = bm.topic_id'
 209                 );
 210         }
 211
 212         if ($config['load_db_lastread'])
 213         {
 214                 $sql_array['SELECT'] .= ', tt.mark_time, ft.mark_time as forum_mark_time';
 215
 216                 $sql_array['LEFT_JOIN'][] = array(
 217                         'FROM'  => array(TOPICS_TRACK_TABLE => 'tt'),
 218                         'ON'    => 'tt.user_id = ' . $user->data['user_id'] . ' AND t.topic_id = tt.topic_id'
 219                 );
 220
 221                 $sql_array['LEFT_JOIN'][] = array(
 222                         'FROM'  => array(FORUMS_TRACK_TABLE => 'ft'),
 223                         'ON'    => 'ft.user_id = ' . $user->data['user_id'] . ' AND t.forum_id = ft.forum_id'
 224                 );
 225         }
 226 }
 227
 228 if (!$post_id)
 229 {
 230         $sql_array['WHERE'] = "t.topic_id = $topic_id";
 231 }
 232 else
 233 {
 234         $sql_array['WHERE'] = "p.post_id = $post_id AND t.topic_id = p.topic_id" . ((!$auth->acl_get('m_approve', $forum_id)) ? ' AND p.post_approved = 1' : '');
 235 }
 236
 237 $sql_array['WHERE'] .= ' AND (f.forum_id = t.forum_id';
 238
 239 if (!$forum_id)
 240 {
 241         // If it is a global announcement make sure to set the forum id to a postable forum
 242         $sql_array['WHERE'] .= ' OR (t.topic_type = ' . POST_GLOBAL . '
 243                 AND f.forum_type = ' . FORUM_POST . ')';
 244 }
 245 else
 246 {
 247         $sql_array['WHERE'] .= ' OR (t.topic_type = ' . POST_GLOBAL . "
 248                 AND f.forum_id = $forum_id)";
 249 }
 250
 251 $sql_array['WHERE'] .= ')';
 252
 253 // Join to forum table on topic forum_id unless topic forum_id is zero
 254 // whereupon we join on the forum_id passed as a parameter ... this
 255 // is done so navigation, forum name, etc. remain consistent with where
 256 // user clicked to view a global topic
 257 $sql = $db->sql_build_query('SELECT', $sql_array);
 258 $result = $db->sql_query($sql);
 259 $topic_data = $db->sql_fetchrow($result);
 260 $db->sql_freeresult($result);
 261
 262 if (!$topic_data)
 263 {
 264         // If post_id was submitted, we try at least to display the topic as a last resort...
 265         if ($post_id && $forum_id && $topic_id)
 266         {
 267                 redirect(append_sid('viewtopic', "f=$forum_id&amp;t=$topic_id"));
 268         }
 269
 270         trigger_error('NO_TOPIC');
 271 }
 272
 273 // This is for determining where we are (page)
 274 if ($post_id)
 275 {
 276         if ($post_id == $topic_data['topic_first_post_id'] || $post_id == $topic_data['topic_last_post_id'])
 277         {
 278                 $check_sort = ($post_id == $topic_data['topic_first_post_id']) ? 'd' : 'a';
 279
 280                 if ($sort_dir == $check_sort)
 281                 {
 282                         $topic_data['prev_posts'] = ($auth->acl_get('m_approve', $forum_id)) ? $topic_data['topic_replies_real'] : $topic_data['topic_replies'];
 283                 }
 284                 else
 285                 {
 286                         $topic_data['prev_posts'] = 0;
 287                 }
 288         }
 289         else
 290         {
 291                 $sql = 'SELECT COUNT(p1.post_id) AS prev_posts
 292                         FROM ' . POSTS_TABLE . ' p1, ' . POSTS_TABLE . " p2
 293                         WHERE p1.topic_id = {$topic_data['topic_id']}
 294                                 AND p2.post_id = {$post_id}
 295                                 " . ((!$auth->acl_get('m_approve', $forum_id)) ? 'AND p1.post_approved = 1' : '') . '
 296                                 AND ' . (($sort_dir == 'd') ? 'p1.post_time >= p2.post_time' : 'p1.post_time <= p2.post_time');
 297
 298                 $result = $db->sql_query($sql);
 299                 $row = $db->sql_fetchrow($result);
 300                 $db->sql_freeresult($result);
 301
 302                 $topic_data['prev_posts'] = $row['prev_posts'] - 1;
 303         }
 304 }
 305
 306 $forum_id = (int) $topic_data['forum_id'];
 307 $topic_id = (int) $topic_data['topic_id'];
 308
 309 //
 310 $topic_replies = ($auth->acl_get('m_approve', $forum_id)) ? $topic_data['topic_replies_real'] : $topic_data['topic_replies'];
 311
 312 // Check sticky/announcement time limit
 313 if (($topic_data['topic_type'] == POST_STICKY || $topic_data['topic_type'] == POST_ANNOUNCE) && $topic_data['topic_time_limit'] && ($topic_data['topic_time'] + $topic_data['topic_time_limit']) < time())
 314 {
 315         $sql = 'UPDATE ' . TOPICS_TABLE . '
 316                 SET topic_type = ' . POST_NORMAL . ', topic_time_limit = 0
 317                 WHERE topic_id = ' . $topic_id;
 318         $db->sql_query($sql);
 319
 320         $topic_data['topic_type'] = POST_NORMAL;
 321         $topic_data['topic_time_limit'] = 0;
 322 }
 323
 324 // Setup look and feel
 325 $user->setup('viewtopic', $topic_data['forum_style']);
 326
 327 if (!$topic_data['topic_approved'] && !$auth->acl_get('m_approve', $forum_id))
 328 {
 329         trigger_error('NO_TOPIC');
 330 }
 331
 332 // Start auth check
 333 if (!$auth->acl_get('f_read', $forum_id))
 334 {
 335         if ($user->data['user_id'] != ANONYMOUS)
 336         {
 337                 trigger_error('SORRY_AUTH_READ');
 338         }
 339
 340         login_box('', $user->lang['LOGIN_VIEWFORUM']);
 341 }
 342
 343 // Forum is passworded ... check whether access has been granted to this
 344 // user this session, if not show login box
 345 if ($topic_data['forum_password'])
 346 {
 347         login_forum_box($topic_data);
 348 }
 349
 350 // Redirect to login or to the correct post upon emailed notification links
 351 if (isset($_GET['e']))
 352 {
 353         $jump_to = request_var('e', 0);
 354
 355         $redirect_url = append_sid('viewtopic', "f=$forum_id&amp;t=$topic_id");
 356
 357         if ($user->data['user_id'] == ANONYMOUS)
 358         {
 359                 login_box($redirect_url . "&amp;p=$post_id&amp;e=$jump_to", $user->lang['LOGIN_NOTIFY_TOPIC']);
 360         }
 361
 362         if ($jump_to > 0)
 363         {
 364                 // We direct the already logged in user to the correct post...
 365                 redirect($redirect_url . ((!$post_id) ? "&amp;p=$jump_to" : "&amp;p=$post_id") . "#p$jump_to");
 366         }
 367 }
 368
 369 // What is start equal to?
 370 if ($post_id)
 371 {
 372         $start = floor(($topic_data['prev_posts']) / $config['posts_per_page']) * $config['posts_per_page'];
 373 }
 374
 375 // Get topic tracking info
 376 if (!isset($topic_tracking_info))
 377 {
 378         $topic_tracking_info = array();
 379
 380         // Get topic tracking info
 381         if ($config['load_db_lastread'] && $user->data['is_registered'])
 382         {
 383                 $tmp_topic_data = array($topic_id => $topic_data);
 384                 $topic_tracking_info = get_topic_tracking($forum_id, $topic_id, $tmp_topic_data, array($forum_id => $topic_data['forum_mark_time']));
 385                 unset($tmp_topic_data);
 386         }
 387         else if ($config['load_anon_lastread'] || $user->data['is_registered'])
 388         {
 389                 $topic_tracking_info = get_complete_topic_tracking($forum_id, $topic_id);
 390         }
 391 }
 392
 393 // Post ordering options
 394 $limit_days = array(0 => $user->lang['ALL_POSTS'], 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']);
 395
 396 $sort_by_text = array('a' => $user->lang['AUTHOR'], 't' => $user->lang['POST_TIME'], 's' => $user->lang['SUBJECT']);
 397 $sort_by_sql = array('a' => 'u.username_clean', 't' => 'p.post_time', 's' => 'p.post_subject');
 398
 399 $s_limit_days = $s_sort_key = $s_sort_dir = $u_sort_param = '';
 400
 401 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);
 402
 403 // Obtain correct post count and ordering SQL if user has
 404 // requested anything different
 405 if ($sort_days)
 406 {
 407         $min_post_time = time() - ($sort_days * 86400);
 408
 409         $sql = 'SELECT COUNT(post_id) AS num_posts
 410                 FROM ' . POSTS_TABLE . "
 411                 WHERE topic_id = $topic_id
 412                         AND post_time >= $min_post_time
 413                 " . (($auth->acl_get('m_approve', $forum_id)) ? '' : 'AND post_approved = 1');
 414         $result = $db->sql_query($sql);
 415         $total_posts = (int) $db->sql_fetchfield('num_posts');
 416         $db->sql_freeresult($result);
 417
 418         $limit_posts_time = "AND p.post_time >= $min_post_time ";
 419
 420         if (isset($_POST['sort']))
 421         {
 422                 $start = 0;
 423         }
 424 }
 425 else
 426 {
 427         $total_posts = $topic_replies + 1;
 428         $limit_posts_time = '';
 429 }
 430
 431 // Was a highlight request part of the URI?
 432 $highlight_match = $highlight = '';
 433 if ($hilit_words)
 434 {
 435         foreach (explode(' ', trim($hilit_words)) as $word)
 436         {
 437                 if (trim($word))
 438                 {
 439                         $word = str_replace('\*', '\w+?', preg_quote($word, '#'));
 440                         $word = preg_replace('#(^|\s)\\\\w\*\?(\s|$)#', '$1\w+?$2', $word);
 441                         $highlight_match .= (($highlight_match != '') ? '|' : '') . $word;
 442                 }
 443         }
 444
 445         $highlight = urlencode($hilit_words);
 446 }
 447
 448 // Make sure $start is set to the last page if it exceeds the amount
 449 if ($start < 0 || $start > $total_posts)
 450 {
 451         $start = ($start < 0) ? 0 : floor(($total_posts - 1) / $config['posts_per_page']) * $config['posts_per_page'];
 452 }
 453
 454 // General Viewtopic URL for return links
 455 $viewtopic_url = append_sid('viewtopic', "f=$forum_id&amp;t=$topic_id&amp;start=$start" . ((strlen($u_sort_param)) ? "&amp;$u_sort_param" : '') . (($highlight_match) ? "&amp;hilit=$highlight" : ''));
 456
 457 // Are we watching this topic?
 458 $s_watching_topic = array(
 459         'link'                  => '',
 460         'title'                 => '',
 461         'is_watching'   => false,
 462 );
 463
 464 if (($config['email_enable'] || $config['jab_enable']) && $config['allow_topic_notify'] && $user->data['is_registered'])
 465 {
 466         watch_topic_forum('topic', $s_watching_topic, $user->data['user_id'], $forum_id, $topic_id, $topic_data['notify_status'], $start);
 467
 468         // Reset forum notification if forum notify is set
 469         if ($config['allow_forum_notify'] && $auth->acl_get('f_subscribe', $forum_id))
 470         {
 471                 $s_watching_forum = $s_watching_topic;
 472                 watch_topic_forum('forum', $s_watching_forum, $user->data['user_id'], $forum_id, 0);
 473         }
 474 }
 475
 476 // Bookmarks
 477 if ($config['allow_bookmarks'] && $user->data['is_registered'] && request_var('bookmark', 0))
 478 {
 479         if (check_link_hash(request_var('hash', ''),"topic_$topic_id"))
 480         {
 481                 if (!$topic_data['bookmarked'])
 482                 {
 483                         $sql = 'INSERT INTO ' . BOOKMARKS_TABLE . ' ' . $db->sql_build_array('INSERT', array(
 484                                 'user_id'       => $user->data['user_id'],
 485                                 'topic_id'      => $topic_id,
 486                         ));
 487                         $db->sql_query($sql);
 488                 }
 489                 else
 490                 {
 491                         $sql = 'DELETE FROM ' . BOOKMARKS_TABLE . "
 492                                 WHERE user_id = {$user->data['user_id']}
 493                                         AND topic_id = $topic_id";
 494                         $db->sql_query($sql);
 495                 }
 496                 $message = (($topic_data['bookmarked']) ? $user->lang['BOOKMARK_REMOVED'] : $user->lang['BOOKMARK_ADDED']) . '<br /><br />' . sprintf($user->lang['RETURN_TOPIC'], '<a href="' . $viewtopic_url . '">', '</a>');
 497         }
 498         else
 499         {
 500                 $message = $user->lang['BOOKMARK_ERR'] . '<br /><br />' . sprintf($user->lang['RETURN_TOPIC'], '<a href="' . $viewtopic_url . '">', '</a>');
 501         }
 502         meta_refresh(3, $viewtopic_url);
 503
 504         trigger_error($message);
 505 }
 506
 507 // Grab ranks
 508 $ranks = cache::obtain_ranks();
 509
 510 // Grab icons
 511 $icons = cache::obtain_icons();
 512
 513 // Grab extensions
 514 $extensions = array();
 515 if ($topic_data['topic_attachment'])
 516 {
 517         $extensions = cache::obtain_attach_extensions($forum_id);
 518 }
 519
 520 // Forum rules listing
 521 $s_forum_rules = '';
 522 gen_forum_auth_level('topic', $forum_id, $topic_data['forum_status']);
 523
 524 // Quick mod tools
 525 $allow_change_type = ($auth->acl_get('m_', $forum_id) || ($user->data['is_registered'] && $user->data['user_id'] == $topic_data['topic_poster'])) ? true : false;
 526
 527 $topic_mod = '';
 528 $topic_mod .= ($auth->acl_get('m_lock', $forum_id) || ($auth->acl_get('f_user_lock', $forum_id) && $user->data['is_registered'] && $user->data['user_id'] == $topic_data['topic_poster'] && $topic_data['topic_status'] == ITEM_UNLOCKED)) ? (($topic_data['topic_status'] == ITEM_UNLOCKED) ? '<option value="lock">' . $user->lang['LOCK_TOPIC'] . '</option>' : '<option value="unlock">' . $user->lang['UNLOCK_TOPIC'] . '</option>') : '';
 529 $topic_mod .= ($auth->acl_get('m_delete', $forum_id)) ? '<option value="delete_topic">' . $user->lang['DELETE_TOPIC'] . '</option>' : '';
 530 $topic_mod .= ($auth->acl_get('m_move', $forum_id) && $topic_data['topic_status'] != ITEM_MOVED) ? '<option value="move">' . $user->lang['MOVE_TOPIC'] . '</option>' : '';
 531 $topic_mod .= ($auth->acl_get('m_split', $forum_id)) ? '<option value="split">' . $user->lang['SPLIT_TOPIC'] . '</option>' : '';
 532 $topic_mod .= ($auth->acl_get('m_merge', $forum_id)) ? '<option value="merge">' . $user->lang['MERGE_POSTS'] . '</option>' : '';
 533 $topic_mod .= ($auth->acl_get('m_merge', $forum_id)) ? '<option value="merge_topic">' . $user->lang['MERGE_TOPIC'] . '</option>' : '';
 534 $topic_mod .= ($auth->acl_get('m_move', $forum_id)) ? '<option value="fork">' . $user->lang['FORK_TOPIC'] . '</option>' : '';
 535 $topic_mod .= ($allow_change_type && $auth->acl_gets('f_sticky', 'f_announce', $forum_id) && $topic_data['topic_type'] != POST_NORMAL) ? '<option value="make_normal">' . $user->lang['MAKE_NORMAL'] . '</option>' : '';
 536 $topic_mod .= ($allow_change_type && $auth->acl_get('f_sticky', $forum_id) && $topic_data['topic_type'] != POST_STICKY) ? '<option value="make_sticky">' . $user->lang['MAKE_STICKY'] . '</option>' : '';
 537 $topic_mod .= ($allow_change_type && $auth->acl_get('f_announce', $forum_id) && $topic_data['topic_type'] != POST_ANNOUNCE) ? '<option value="make_announce">' . $user->lang['MAKE_ANNOUNCE'] . '</option>' : '';
 538 $topic_mod .= ($allow_change_type && $auth->acl_get('f_announce', $forum_id) && $topic_data['topic_type'] != POST_GLOBAL) ? '<option value="make_global">' . $user->lang['MAKE_GLOBAL'] . '</option>' : '';
 539 $topic_mod .= ($auth->acl_get('m_', $forum_id)) ? '<option value="topic_logs">' . $user->lang['VIEW_TOPIC_LOGS'] . '</option>' : '';
 540
 541 // If we've got a hightlight set pass it on to pagination.
 542 $pagination = generate_pagination(append_sid('viewtopic', "f=$forum_id&amp;t=$topic_id" . ((strlen($u_sort_param)) ? "&amp;$u_sort_param" : '') . (($highlight_match) ? "&amp;hilit=$highlight" : '')), $total_posts, $config['posts_per_page'], $start);
 543
 544 // Navigation links
 545 generate_forum_nav($topic_data);
 546
 547 // Forum Rules
 548 generate_forum_rules($topic_data);
 549
 550 // Moderators
 551 $forum_moderators = array();
 552 get_moderators($forum_moderators, $forum_id);
 553
 554 // This is only used for print view so ...
 555 $server_path = (!$view) ? PHPBB_ROOT_PATH : generate_board_url() . '/';
 556
 557 // Replace naughty words in title
 558 $topic_data['topic_title'] = censor_text($topic_data['topic_title']);
 559
 560 // Send vars to template
 561 $template->assign_vars(array(
 562         'FORUM_ID'              => $forum_id,
 563         'FORUM_NAME'    => $topic_data['forum_name'],
 564         'FORUM_DESC'    => generate_text_for_display($topic_data['forum_desc'], $topic_data['forum_desc_uid'], $topic_data['forum_desc_bitfield'], $topic_data['forum_desc_options']),
 565         'TOPIC_ID'              => $topic_id,
 566         'TOPIC_TITLE'   => $topic_data['topic_title'],
 567         'TOPIC_POSTER'  => $topic_data['topic_poster'],
 568
 569         'TOPIC_AUTHOR_FULL'             => get_username_string('full', $topic_data['topic_poster'], $topic_data['topic_first_poster_name'], $topic_data['topic_first_poster_colour']),
 570         'TOPIC_AUTHOR_COLOUR'   => get_username_string('colour', $topic_data['topic_poster'], $topic_data['topic_first_poster_name'], $topic_data['topic_first_poster_colour']),
 571         'TOPIC_AUTHOR'                  => get_username_string('username', $topic_data['topic_poster'], $topic_data['topic_first_poster_name'], $topic_data['topic_first_poster_colour']),
 572
 573         'PAGINATION'    => $pagination,
 574         'PAGE_NUMBER'   => on_page($total_posts, $config['posts_per_page'], $start),
 575         'TOTAL_POSTS'   => ($total_posts == 1) ? $user->lang['VIEW_TOPIC_POST'] : sprintf($user->lang['VIEW_TOPIC_POSTS'], $total_posts),
 576         'U_MCP'                 => ($auth->acl_get('m_', $forum_id)) ? append_sid('mcp', "i=main&amp;mode=topic_view&amp;f=$forum_id&amp;t=$topic_id&amp;start=$start" . ((strlen($u_sort_param)) ? "&amp;$u_sort_param" : ''), true, $user->session_id) : '',
 577
 578         'MODERATORS'    => (isset($forum_moderators[$forum_id]) && sizeof($forum_moderators[$forum_id])) ? implode(', ', $forum_moderators[$forum_id]) : '',
 579
 580         'POST_IMG'                      => ($topic_data['forum_status'] == ITEM_LOCKED) ? $user->img('button_topic_locked', 'FORUM_LOCKED') : $user->img('button_topic_new', 'POST_NEW_TOPIC'),
 581         'QUOTE_IMG'             => $user->img('icon_post_quote', 'REPLY_WITH_QUOTE'),
 582         'REPLY_IMG'                     => ($topic_data['forum_status'] == ITEM_LOCKED || $topic_data['topic_status'] == ITEM_LOCKED) ? $user->img('button_topic_locked', 'TOPIC_LOCKED') : $user->img('button_topic_reply', 'REPLY_TO_TOPIC'),
 583         'EDIT_IMG'                      => $user->img('icon_post_edit', 'EDIT_POST'),
 584         'DELETE_IMG'            => $user->img('icon_post_delete', 'DELETE_POST'),
 585         'INFO_IMG'                      => $user->img('icon_post_info', 'VIEW_INFO'),
 586         'PROFILE_IMG'           => $user->img('icon_user_profile', 'READ_PROFILE'),
 587         'SEARCH_IMG'            => $user->img('icon_user_search', 'SEARCH_USER_POSTS'),
 588         'PM_IMG'                        => $user->img('icon_contact_pm', 'SEND_PRIVATE_MESSAGE'),
 589         'EMAIL_IMG'             => $user->img('icon_contact_email', 'SEND_EMAIL'),
 590         'WWW_IMG'                       => $user->img('icon_contact_www', 'VISIT_WEBSITE'),
 591         'ICQ_IMG'                       => $user->img('icon_contact_icq', 'ICQ'),
 592         'AIM_IMG'                       => $user->img('icon_contact_aim', 'AIM'),
 593         'MSN_IMG'                       => $user->img('icon_contact_msnm', 'MSNM'),
 594         'YIM_IMG'                       => $user->img('icon_contact_yahoo', 'YIM'),
 595         'JABBER_IMG'            => $user->img('icon_contact_jabber', 'JABBER') ,
 596         'REPORT_IMG'            => $user->img('icon_post_report', 'REPORT_POST'),
 597         'REPORTED_IMG'          => $user->img('icon_topic_reported', 'POST_REPORTED'),
 598         'UNAPPROVED_IMG'        => $user->img('icon_topic_unapproved', 'POST_UNAPPROVED'),
 599         'WARN_IMG'                      => $user->img('icon_user_warn', 'WARN_USER'),
 600
 601         'S_IS_LOCKED'                   =>($topic_data['topic_status'] == ITEM_UNLOCKED) ? false : true,
 602         'S_SELECT_SORT_DIR'     => $s_sort_dir,
 603         'S_SELECT_SORT_KEY'     => $s_sort_key,
 604         'S_SELECT_SORT_DAYS'    => $s_limit_days,
 605         'S_SINGLE_MODERATOR'    => (!empty($forum_moderators[$forum_id]) && sizeof($forum_moderators[$forum_id]) > 1) ? false : true,
 606         'S_TOPIC_ACTION'                => append_sid('viewtopic', "f=$forum_id&amp;t=$topic_id&amp;start=$start"),
 607         'S_TOPIC_MOD'                   => ($topic_mod != '') ? '<select name="action" id="quick-mod-select">' . $topic_mod . '</select>' : '',
 608         'S_MOD_ACTION'                  => append_sid('mcp', "f=$forum_id&amp;t=$topic_id&amp;quickmod=1&amp;redirect=" . urlencode(str_replace('&amp;', '&', $viewtopic_url)), true, $user->session_id),
 609
 610         'S_VIEWTOPIC'                   => true,
 611         'S_DISPLAY_SEARCHBOX'   => ($auth->acl_get('u_search') && $auth->acl_get('f_search', $forum_id) && $config['load_search']) ? true : false,
 612         'S_SEARCHBOX_ACTION'    => append_sid('search', 't=' . $topic_id),
 613
 614         'S_DISPLAY_POST_INFO'   => ($topic_data['forum_type'] == FORUM_POST && ($auth->acl_get('f_post', $forum_id) || $user->data['user_id'] == ANONYMOUS)) ? true : false,
 615         'S_DISPLAY_REPLY_INFO'  => ($topic_data['forum_type'] == FORUM_POST && ($auth->acl_get('f_reply', $forum_id) || $user->data['user_id'] == ANONYMOUS)) ? true : false,
 616
 617         'U_TOPIC'                               => "{$server_path}viewtopic." . PHP_EXT . "?f=$forum_id&amp;t=$topic_id",
 618         'U_FORUM'                               => $server_path,
 619         'U_VIEW_TOPIC'                  => $viewtopic_url,
 620         'U_VIEW_FORUM'                  => append_sid('viewforum', 'f=' . $forum_id),
 621         'U_VIEW_OLDER_TOPIC'    => append_sid('viewtopic', "f=$forum_id&amp;t=$topic_id&amp;view=previous"),
 622         'U_VIEW_NEWER_TOPIC'    => append_sid('viewtopic', "f=$forum_id&amp;t=$topic_id&amp;view=next"),
 623         'U_PRINT_TOPIC'                 => ($auth->acl_get('f_print', $forum_id)) ? $viewtopic_url . '&amp;view=print' : '',
 624         'U_EMAIL_TOPIC'                 => ($auth->acl_get('f_email', $forum_id) && $config['email_enable']) ? append_sid('memberlist', "mode=email&amp;t=$topic_id") : '',
 625
 626         'U_WATCH_TOPIC'                 => $s_watching_topic['link'],
 627         'L_WATCH_TOPIC'                 => $s_watching_topic['title'],
 628         'S_WATCHING_TOPIC'              => $s_watching_topic['is_watching'],
 629
 630         'U_BOOKMARK_TOPIC'              => ($user->data['is_registered'] && $config['allow_bookmarks']) ? $viewtopic_url . '&amp;bookmark=1&amp;hash=' . generate_link_hash("topic_$topic_id") : '',
 631         'L_BOOKMARK_TOPIC'              => ($user->data['is_registered'] && $config['allow_bookmarks'] && $topic_data['bookmarked']) ? $user->lang['BOOKMARK_TOPIC_REMOVE'] : $user->lang['BOOKMARK_TOPIC'],
 632
 633         'U_POST_NEW_TOPIC'              => ($auth->acl_get('f_post', $forum_id) || $user->data['user_id'] == ANONYMOUS) ? append_sid('posting', "mode=post&amp;f=$forum_id") : '',
 634         'U_POST_REPLY_TOPIC'    => ($auth->acl_get('f_reply', $forum_id) || $user->data['user_id'] == ANONYMOUS) ? append_sid('posting', "mode=reply&amp;f=$forum_id&amp;t=$topic_id") : '',
 635         'U_BUMP_TOPIC'                  => (bump_topic_allowed($forum_id, $topic_data['topic_bumped'], $topic_data['topic_last_post_time'], $topic_data['topic_poster'], $topic_data['topic_last_poster_id'])) ? append_sid('posting', "mode=bump&amp;f=$forum_id&amp;t=$topic_id&amp;hash=" . generate_link_hash("topic_$topic_id")) : '')
 636 );
 637
 638 // Does this topic contain a poll?
 639 if (!empty($topic_data['poll_start']))
 640 {
 641         $sql = 'SELECT o.*, p.bbcode_bitfield, p.bbcode_uid
 642                 FROM ' . POLL_OPTIONS_TABLE . ' o, ' . POSTS_TABLE . " p
 643                 WHERE o.topic_id = $topic_id
 644                         AND p.post_id = {$topic_data['topic_first_post_id']}
 645                         AND p.topic_id = o.topic_id
 646                 ORDER BY o.poll_option_id";
 647         $result = $db->sql_query($sql);
 648
 649         $poll_info = array();
 650         while ($row = $db->sql_fetchrow($result))
 651         {
 652                 $poll_info[] = $row;
 653         }
 654         $db->sql_freeresult($result);
 655
 656         $cur_voted_id = array();
 657         if ($user->data['is_registered'])
 658         {
 659                 $sql = 'SELECT poll_option_id
 660                         FROM ' . POLL_VOTES_TABLE . '
 661                         WHERE topic_id = ' . $topic_id . '
 662                                 AND vote_user_id = ' . $user->data['user_id'];
 663                 $result = $db->sql_query($sql);
 664
 665                 while ($row = $db->sql_fetchrow($result))
 666                 {
 667                         $cur_voted_id[] = $row['poll_option_id'];
 668                 }
 669                 $db->sql_freeresult($result);
 670         }
 671         else
 672         {
 673                 // Cookie based guest tracking ... I don't like this but hum ho
 674                 // it's oft requested. This relies on "nice" users who don't feel
 675                 // the need to delete cookies to mess with results.
 676                 if (isset($_COOKIE[$config['cookie_name'] . '_poll_' . $topic_id]))
 677                 {
 678                         $cur_voted_id = explode(',', $_COOKIE[$config['cookie_name'] . '_poll_' . $topic_id]);
 679                         $cur_voted_id = array_map('intval', $cur_voted_id);
 680                 }
 681         }
 682
 683         $s_can_vote = (((!sizeof($cur_voted_id) && $auth->acl_get('f_vote', $forum_id)) ||
 684                 ($auth->acl_get('f_votechg', $forum_id) && $topic_data['poll_vote_change'])) &&
 685                 (($topic_data['poll_length'] != 0 && $topic_data['poll_start'] + $topic_data['poll_length'] > time()) || $topic_data['poll_length'] == 0) &&
 686                 $topic_data['topic_status'] != ITEM_LOCKED &&
 687                 $topic_data['forum_status'] != ITEM_LOCKED) ? true : false;
 688         $s_display_results = (!$s_can_vote || ($s_can_vote && sizeof($cur_voted_id)) || $view == 'viewpoll') ? true : false;
 689
 690         if ($update && $s_can_vote)
 691         {
 692
 693                 if (!sizeof($voted_id) || sizeof($voted_id) > $topic_data['poll_max_options'] || in_array(VOTE_CONVERTED, $cur_voted_id))
 694                 {
 695                         $redirect_url = append_sid('viewtopic', "f=$forum_id&amp;t=$topic_id&amp;start=$start");
 696
 697                         meta_refresh(5, $redirect_url);
 698                         if (!sizeof($voted_id))
 699                         {
 700                                 $message = 'NO_VOTE_OPTION';
 701                         }
 702                         else if (sizeof($voted_id) > $topic_data['poll_max_options'])
 703                         {
 704                                 $message = 'TOO_MANY_VOTE_OPTIONS';
 705                         }
 706                         else
 707                         {
 708                                 $message = 'VOTE_CONVERTED';
 709                         }
 710
 711                         $message = $user->lang[$message] . '<br /><br />' . sprintf($user->lang['RETURN_TOPIC'], '<a href="' . $redirect_url . '">', '</a>');
 712                         trigger_error($message);
 713                 }
 714
 715                 foreach ($voted_id as $option)
 716                 {
 717                         if (in_array($option, $cur_voted_id))
 718                         {
 719                                 continue;
 720                         }
 721
 722                         $sql = 'UPDATE ' . POLL_OPTIONS_TABLE . '
 723                                 SET poll_option_total = poll_option_total + 1
 724                                 WHERE poll_option_id = ' . (int) $option . '
 725                                         AND topic_id = ' . (int) $topic_id;
 726                         $db->sql_query($sql);
 727
 728                         if ($user->data['is_registered'])
 729                         {
 730                                 $sql_ary = array(
 731                                         'topic_id'                      => (int) $topic_id,
 732                                         'poll_option_id'        => (int) $option,
 733                                         'vote_user_id'          => (int) $user->data['user_id'],
 734                                         'vote_user_ip'          => (string) $user->ip,
 735                                 );
 736
 737                                 $sql = 'INSERT INTO ' . POLL_VOTES_TABLE . ' ' . $db->sql_build_array('INSERT', $sql_ary);
 738                                 $db->sql_query($sql);
 739                         }
 740                 }
 741
 742                 foreach ($cur_voted_id as $option)
 743                 {
 744                         if (!in_array($option, $voted_id))
 745                         {
 746                                 $sql = 'UPDATE ' . POLL_OPTIONS_TABLE . '
 747                                         SET poll_option_total = poll_option_total - 1
 748                                         WHERE poll_option_id = ' . (int) $option . '
 749                                                 AND topic_id = ' . (int) $topic_id;
 750                                 $db->sql_query($sql);
 751
 752                                 if ($user->data['is_registered'])
 753                                 {
 754                                         $sql = 'DELETE FROM ' . POLL_VOTES_TABLE . '
 755                                                 WHERE topic_id = ' . (int) $topic_id . '
 756                                                         AND poll_option_id = ' . (int) $option . '
 757                                                         AND vote_user_id = ' . (int) $user->data['user_id'];
 758                                         $db->sql_query($sql);
 759                                 }
 760                         }
 761                 }
 762
 763                 if ($user->data['user_id'] == ANONYMOUS && !$user->data['is_bot'])
 764                 {
 765                         $user->set_cookie('poll_' . $topic_id, implode(',', $voted_id), time() + 31536000);
 766                 }
 767
 768                 $sql = 'UPDATE ' . TOPICS_TABLE . '
 769                         SET poll_last_vote = ' . time() . "
 770                         WHERE topic_id = $topic_id";
 771                 //, topic_last_post_time = ' . time() . " -- for bumping topics with new votes, ignore for now
 772                 $db->sql_query($sql);
 773
 774                 $redirect_url = append_sid('viewtopic', "f=$forum_id&amp;t=$topic_id&amp;start=$start");
 775
 776                 meta_refresh(5, $redirect_url);
 777                 trigger_error($user->lang['VOTE_SUBMITTED'] . '<br /><br />' . sprintf($user->lang['RETURN_TOPIC'], '<a href="' . $redirect_url . '">', '</a>'));
 778         }
 779
 780         $poll_total = 0;
 781         foreach ($poll_info as $poll_option)
 782         {
 783                 $poll_total += $poll_option['poll_option_total'];
 784         }
 785
 786         if ($poll_info[0]['bbcode_bitfield'])
 787         {
 788                 $poll_bbcode = new bbcode();
 789         }
 790         else
 791         {
 792                 $poll_bbcode = false;
 793         }
 794
 795         for ($i = 0, $size = sizeof($poll_info); $i < $size; $i++)
 796         {
 797                 $poll_info[$i]['poll_option_text'] = censor_text($poll_info[$i]['poll_option_text']);
 798
 799                 if ($poll_bbcode !== false)
 800                 {
 801                         $poll_bbcode->bbcode_second_pass($poll_info[$i]['poll_option_text'], $poll_info[$i]['bbcode_uid'], $poll_option['bbcode_bitfield']);
 802                 }
 803
 804                 $poll_info[$i]['poll_option_text'] = bbcode_nl2br($poll_info[$i]['poll_option_text']);
 805                 $poll_info[$i]['poll_option_text'] = smiley_text($poll_info[$i]['poll_option_text']);
 806         }
 807
 808         $topic_data['poll_title'] = censor_text($topic_data['poll_title']);
 809
 810         if ($poll_bbcode !== false)
 811         {
 812                 $poll_bbcode->bbcode_second_pass($topic_data['poll_title'], $poll_info[0]['bbcode_uid'], $poll_info[0]['bbcode_bitfield']);
 813         }
 814
 815         $topic_data['poll_title'] = bbcode_nl2br($topic_data['poll_title']);
 816         $topic_data['poll_title'] = smiley_text($topic_data['poll_title']);
 817
 818         unset($poll_bbcode);
 819
 820         foreach ($poll_info as $poll_option)
 821         {
 822                 $option_pct = ($poll_total > 0) ? $poll_option['poll_option_total'] / $poll_total : 0;
 823                 $option_pct_txt = sprintf("%.1d%%", ($option_pct * 100));
 824
 825                 $template->assign_block_vars('poll_option', array(
 826                         'POLL_OPTION_ID'                => $poll_option['poll_option_id'],
 827                         'POLL_OPTION_CAPTION'   => $poll_option['poll_option_text'],
 828                         'POLL_OPTION_RESULT'    => $poll_option['poll_option_total'],
 829                         'POLL_OPTION_PERCENT'   => $option_pct_txt,
 830                         'POLL_OPTION_PCT'               => round($option_pct * 100),
 831                         'POLL_OPTION_IMG'               => $user->img('poll_center', $option_pct_txt, '', round($option_pct * 250)),
 832                         'POLL_OPTION_VOTED'             => (in_array($poll_option['poll_option_id'], $cur_voted_id)) ? true : false)
 833                 );
 834         }
 835
 836         $poll_end = $topic_data['poll_length'] + $topic_data['poll_start'];
 837
 838         $template->assign_vars(array(
 839                 'POLL_QUESTION'         => $topic_data['poll_title'],
 840                 'TOTAL_VOTES'           => $poll_total,
 841                 'POLL_LEFT_CAP_IMG'     => $user->img('poll_left'),
 842                 'POLL_RIGHT_CAP_IMG'=> $user->img('poll_right'),
 843
 844                 'L_MAX_VOTES'           => ($topic_data['poll_max_options'] == 1) ? $user->lang['MAX_OPTION_SELECT'] : sprintf($user->lang['MAX_OPTIONS_SELECT'], $topic_data['poll_max_options']),
 845                 'L_POLL_LENGTH'         => ($topic_data['poll_length']) ? sprintf($user->lang[($poll_end > time()) ? 'POLL_RUN_TILL' : 'POLL_ENDED_AT'], $user->format_date($poll_end)) : '',
 846
 847                 'S_HAS_POLL'            => true,
 848                 'S_CAN_VOTE'            => $s_can_vote,
 849                 'S_DISPLAY_RESULTS'     => $s_display_results,
 850                 'S_IS_MULTI_CHOICE'     => ($topic_data['poll_max_options'] > 1) ? true : false,
 851                 'S_POLL_ACTION'         => $viewtopic_url,
 852
 853                 'U_VIEW_RESULTS'        => $viewtopic_url . '&amp;view=viewpoll')
 854         );
 855
 856         unset($poll_end, $poll_info, $voted_id);
 857 }
 858
 859 // If the user is trying to reach the second half of the topic, fetch it starting from the end
 860 $store_reverse = false;
 861 $sql_limit = $config['posts_per_page'];
 862
 863 if ($start > $total_posts / 2)
 864 {
 865         $store_reverse = true;
 866
 867         if ($start + $config['posts_per_page'] > $total_posts)
 868         {
 869                 $sql_limit = min($config['posts_per_page'], max(1, $total_posts - $start));
 870         }
 871
 872         // Select the sort order
 873         $sql_sort_order = $sort_by_sql[$sort_key] . ' ' . (($sort_dir == 'd') ? 'ASC' : 'DESC');
 874         $sql_start = max(0, $total_posts - $sql_limit - $start);
 875 }
 876 else
 877 {
 878         // Select the sort order
 879         $sql_sort_order = $sort_by_sql[$sort_key] . ' ' . (($sort_dir == 'd') ? 'DESC' : 'ASC');
 880         $sql_start = $start;
 881 }
 882
 883 // Container for user details, only process once
 884 $post_list = $user_cache = $id_cache = $attachments = $attach_list = $rowset = $update_count = $post_edit_list = array();
 885 $has_attachments = $display_notice = false;
 886 $bbcode_bitfield = '';
 887 $i = $i_total = 0;
 888
 889 // Go ahead and pull all data for this topic
 890 $sql = 'SELECT p.post_id
 891         FROM ' . POSTS_TABLE . ' p' . (($sort_by_sql[$sort_key][0] == 'u') ? ', ' . USERS_TABLE . ' u': '') . "
 892         WHERE p.topic_id = $topic_id
 893                 " . ((!$auth->acl_get('m_approve', $forum_id)) ? 'AND p.post_approved = 1' : '') . "
 894                 " . (($sort_by_sql[$sort_key][0] == 'u') ? 'AND u.user_id = p.poster_id': '') . "
 895                 $limit_posts_time
 896         ORDER BY $sql_sort_order";
 897 $result = $db->sql_query_limit($sql, $sql_limit, $sql_start);
 898
 899 $i = ($store_reverse) ? $sql_limit - 1 : 0;
 900 while ($row = $db->sql_fetchrow($result))
 901 {
 902         $post_list[$i] = $row['post_id'];
 903         ($store_reverse) ? $i-- : $i++;
 904 }
 905 $db->sql_freeresult($result);
 906
 907 if (!sizeof($post_list))
 908 {
 909         if ($sort_days)
 910         {
 911                 trigger_error('NO_POSTS_TIME_FRAME');
 912         }
 913         else
 914         {
 915                 trigger_error('NO_TOPIC');
 916         }
 917 }
 918
 919 // Holding maximum post time for marking topic read
 920 // We need to grab it because we do reverse ordering sometimes
 921 $max_post_time = 0;
 922
 923 $sql = $db->sql_build_query('SELECT', array(
 924         'SELECT'        => 'u.*, z.friend, z.foe, p.*',
 925
 926         'FROM'          => array(
 927                 USERS_TABLE             => 'u',
 928                 POSTS_TABLE             => 'p',
 929         ),
 930
 931         'LEFT_JOIN'     => array(
 932                 array(
 933                         'FROM'  => array(ZEBRA_TABLE => 'z'),
 934                         'ON'    => 'z.user_id = ' . $user->data['user_id'] . ' AND z.zebra_id = p.poster_id'
 935                 )
 936         ),
 937
 938         'WHERE'         => $db->sql_in_set('p.post_id', $post_list) . '
 939                 AND u.user_id = p.poster_id'
 940 ));
 941
 942 $result = $db->sql_query($sql);
 943
 944 $now = getdate(time() + $user->timezone + $user->dst - date('Z'));
 945
 946 // Posts are stored in the $rowset array while $attach_list, $user_cache
 947 // and the global bbcode_bitfield are built
 948 while ($row = $db->sql_fetchrow($result))
 949 {
 950         // Set max_post_time
 951         if ($row['post_time'] > $max_post_time)
 952         {
 953                 $max_post_time = $row['post_time'];
 954         }
 955
 956         $poster_id = $row['poster_id'];
 957
 958         // Does post have an attachment? If so, add it to the list
 959         if ($row['post_attachment'] && $config['allow_attachments'])
 960         {
 961                 $attach_list[] = $row['post_id'];
 962
 963                 if ($row['post_approved'])
 964                 {
 965                         $has_attachments = true;
 966                 }
 967         }
 968
 969         $rowset[$row['post_id']] = array(
 970                 'hide_post'                     => ($row['foe'] && ($view != 'show' || $post_id != $row['post_id'])) ? true : false,
 971
 972                 'post_id'                       => $row['post_id'],
 973                 'post_time'                     => $row['post_time'],
 974                 'user_id'                       => $row['user_id'],
 975                 'username'                      => $row['username'],
 976                 'user_colour'           => $row['user_colour'],
 977                 'topic_id'                      => $row['topic_id'],
 978                 'forum_id'                      => $row['forum_id'],
 979                 'post_subject'          => $row['post_subject'],
 980                 'post_edit_count'       => $row['post_edit_count'],
 981                 'post_edit_time'        => $row['post_edit_time'],
 982                 'post_edit_reason'      => $row['post_edit_reason'],
 983                 'post_edit_user'        => $row['post_edit_user'],
 984
 985                 // Make sure the icon actually exists
 986                 'icon_id'                       => (isset($icons[$row['icon_id']]['img'], $icons[$row['icon_id']]['height'], $icons[$row['icon_id']]['width'])) ? $row['icon_id'] : 0,
 987                 'post_attachment'       => $row['post_attachment'],
 988                 'post_approved'         => $row['post_approved'],
 989                 'post_reported'         => $row['post_reported'],
 990                 'post_username'         => $row['post_username'],
 991                 'post_text'                     => $row['post_text'],
 992                 'bbcode_uid'            => $row['bbcode_uid'],
 993                 'bbcode_bitfield'       => $row['bbcode_bitfield'],
 994                 'enable_smilies'        => $row['enable_smilies'],
 995                 'enable_sig'            => $row['enable_sig'],
 996                 'friend'                        => $row['friend'],
 997                 'foe'                           => $row['foe'],
 998         );
 999
1000         // Define the global bbcode bitfield, will be used to load bbcodes
1001         $bbcode_bitfield = $bbcode_bitfield | base64_decode($row['bbcode_bitfield']);
1002
1003         // Is a signature attached? Are we going to display it?
1004         if ($row['enable_sig'] && $config['allow_sig'] && $user->optionget('viewsigs'))
1005         {
1006                 $bbcode_bitfield = $bbcode_bitfield | base64_decode($row['user_sig_bbcode_bitfield']);
1007         }
1008
1009         // Cache various user specific data ... so we don't have to recompute
1010         // this each time the same user appears on this page
1011         if (!isset($user_cache[$poster_id]))
1012         {
1013                 if ($poster_id == ANONYMOUS)
1014                 {
1015                         $user_cache[$poster_id] = array(
1016                                 'joined'                => '',
1017                                 'posts'                 => '',
1018                                 'from'                  => '',
1019
1020                                 'sig'                                   => '',
1021                                 'sig_bbcode_uid'                => '',
1022                                 'sig_bbcode_bitfield'   => '',
1023
1024                                 'online'                        => false,
1025                                 'avatar'                        => ($user->optionget('viewavatars')) ? get_user_avatar($row['user_avatar'], $row['user_avatar_type'], $row['user_avatar_width'], $row['user_avatar_height']) : '',
1026                                 'rank_title'            => '',
1027                                 'rank_image'            => '',
1028                                 'rank_image_src'        => '',
1029                                 'sig'                           => '',
1030                                 'profile'                       => '',
1031                                 'pm'                            => '',
1032                                 'email'                         => '',
1033                                 'www'                           => '',
1034                                 'icq_status_img'        => '',
1035                                 'icq'                           => '',
1036                                 'aim'                           => '',
1037                                 'msn'                           => '',
1038                                 'yim'                           => '',
1039                                 'jabber'                        => '',
1040                                 'search'                        => '',
1041                                 'age'                           => '',
1042
1043                                 'username'                      => $row['username'],
1044                                 'user_colour'           => $row['user_colour'],
1045
1046                                 'warnings'                      => 0,
1047                                 'allow_pm'                      => 0,
1048                         );
1049
1050                         get_user_rank($row['user_rank'], $row['user_posts'], $user_cache[$poster_id]['rank_title'], $user_cache[$poster_id]['rank_image'], $user_cache[$poster_id]['rank_image_src']);
1051                 }
1052                 else
1053                 {
1054                         $user_sig = '';
1055
1056                         // We add the signature to every posters entry because enable_sig is post dependant
1057                         if ($row['user_sig'] && $config['allow_sig'] && $user->optionget('viewsigs'))
1058                         {
1059                                 $user_sig = $row['user_sig'];
1060                         }
1061
1062                         $id_cache[] = $poster_id;
1063
1064                         $user_cache[$poster_id] = array(
1065                                 'joined'                => $user->format_date($row['user_regdate']),
1066                                 'posts'                 => $row['user_posts'],
1067                                 'warnings'              => (isset($row['user_warnings'])) ? $row['user_warnings'] : 0,
1068                                 'from'                  => (!empty($row['user_from'])) ? $row['user_from'] : '',
1069
1070                                 'sig'                                   => $user_sig,
1071                                 'sig_bbcode_uid'                => (!empty($row['user_sig_bbcode_uid'])) ? $row['user_sig_bbcode_uid'] : '',
1072                                 'sig_bbcode_bitfield'   => (!empty($row['user_sig_bbcode_bitfield'])) ? $row['user_sig_bbcode_bitfield'] : '',
1073
1074                                 'viewonline'    => $row['user_allow_viewonline'],
1075                                 'allow_pm'              => $row['user_allow_pm'],
1076
1077                                 'avatar'                => ($user->optionget('viewavatars')) ? get_user_avatar($row['user_avatar'], $row['user_avatar_type'], $row['user_avatar_width'], $row['user_avatar_height']) : '',
1078                                 'age'                   => '',
1079
1080                                 'rank_title'            => '',
1081                                 'rank_image'            => '',
1082                                 'rank_image_src'        => '',
1083
1084                                 'username'                      => $row['username'],
1085                                 'user_colour'           => $row['user_colour'],
1086
1087                                 'online'                => false,
1088                                 'profile'               => append_sid('memberlist', "mode=viewprofile&amp;u=$poster_id"),
1089                                 'www'                   => $row['user_website'],
1090                                 'aim'                   => ($row['user_aim'] && $auth->acl_get('u_sendim')) ? append_sid('memberlist', "mode=contact&amp;action=aim&amp;u=$poster_id") : '',
1091                                 'msn'                   => ($row['user_msnm'] && $auth->acl_get('u_sendim')) ? append_sid('memberlist', "mode=contact&amp;action=msnm&amp;u=$poster_id") : '',
1092                                 'yim'                   => ($row['user_yim']) ? 'http://edit.yahoo.com/config/send_webmesg?.target=' . urlencode($row['user_yim']) . '&amp;.src=pg' : '',
1093                                 'jabber'                => ($row['user_jabber'] && $auth->acl_get('u_sendim')) ? append_sid('memberlist', "mode=contact&amp;action=jabber&amp;u=$poster_id") : '',
1094                                 'search'                => ($auth->acl_get('u_search')) ? append_sid('search', "author_id=$poster_id&amp;sr=posts") : '',
1095                         );
1096
1097                         get_user_rank($row['user_rank'], $row['user_posts'], $user_cache[$poster_id]['rank_title'], $user_cache[$poster_id]['rank_image'], $user_cache[$poster_id]['rank_image_src']);
1098
1099                         if (!empty($row['user_allow_viewemail']) || $auth->acl_get('a_email'))
1100                         {
1101                                 $user_cache[$poster_id]['email'] = ($config['board_email_form'] && $config['email_enable']) ? append_sid('memberlist', "mode=email&amp;u=$poster_id") : (($config['board_hide_emails'] && !$auth->acl_get('a_email')) ? '' : 'mailto:' . $row['user_email']);
1102                         }
1103                         else
1104                         {
1105                                 $user_cache[$poster_id]['email'] = '';
1106                         }
1107
1108                         if (!empty($row['user_icq']))
1109                         {
1110                                 $user_cache[$poster_id]['icq'] = 'http://www.icq.com/people/webmsg.php?to=' . $row['user_icq'];
1111                                 $user_cache[$poster_id]['icq_status_img'] = '<img src="http://web.icq.com/whitepages/online?icq=' . $row['user_icq'] . '&amp;img=5" width="18" height="18" alt="" />';
1112                         }
1113                         else
1114                         {
1115                                 $user_cache[$poster_id]['icq_status_img'] = '';
1116                                 $user_cache[$poster_id]['icq'] = '';
1117                         }
1118
1119                         if ($config['allow_birthdays'] && !empty($row['user_birthday']))
1120                         {
1121                                 list($bday_day, $bday_month, $bday_year) = array_map('intval', explode('-', $row['user_birthday']));
1122
1123                                 if ($bday_year)
1124                                 {
1125                                         $diff = $now['mon'] - $bday_month;
1126                                         if ($diff == 0)
1127                                         {
1128                                                 $diff = ($now['mday'] - $bday_day < 0) ? 1 : 0;
1129                                         }
1130                                         else
1131                                         {
1132                                                 $diff = ($diff < 0) ? 1 : 0;
1133                                         }
1134
1135                                         $user_cache[$poster_id]['age'] = (int) ($now['year'] - $bday_year - $diff);
1136                                 }
1137                         }
1138                 }
1139         }
1140 }
1141 $db->sql_freeresult($result);
1142
1143 // Load custom profile fields
1144 if ($config['load_cpf_viewtopic'])
1145 {
1146         include(PHPBB_ROOT_PATH . 'includes/functions_profile_fields.' . PHP_EXT);
1147         $cp = new custom_profile();
1148
1149         // Grab all profile fields from users in id cache for later use - similar to the poster cache
1150         $profile_fields_cache = $cp->generate_profile_fields_template('grab', $id_cache);
1151 }
1152
1153 // Generate online information for user
1154 if ($config['load_onlinetrack'] && sizeof($id_cache))
1155 {
1156         $sql = 'SELECT session_user_id, MAX(session_time) as online_time, MIN(session_viewonline) AS viewonline
1157                 FROM ' . SESSIONS_TABLE . '
1158                 WHERE ' . $db->sql_in_set('session_user_id', $id_cache) . '
1159                 GROUP BY session_user_id';
1160         $result = $db->sql_query($sql);
1161
1162         $update_time = $config['load_online_time'] * 60;
1163         while ($row = $db->sql_fetchrow($result))
1164         {
1165                 $user_cache[$row['session_user_id']]['online'] = (time() - $update_time < $row['online_time'] && (($row['viewonline']) || $auth->acl_get('u_viewonline'))) ? true : false;
1166         }
1167         $db->sql_freeresult($result);
1168 }
1169 unset($id_cache);
1170
1171 // Pull attachment data
1172 if (sizeof($attach_list))
1173 {
1174         if ($auth->acl_get('u_download') && $auth->acl_get('f_download', $forum_id))
1175         {
1176                 $sql = 'SELECT *
1177                         FROM ' . ATTACHMENTS_TABLE . '
1178                         WHERE ' . $db->sql_in_set('post_msg_id', $attach_list) . '
1179                                 AND in_message = 0
1180                         ORDER BY filetime DESC, post_msg_id ASC';
1181                 $result = $db->sql_query($sql);
1182
1183                 while ($row = $db->sql_fetchrow($result))
1184                 {
1185                         $attachments[$row['post_msg_id']][] = $row;
1186                 }
1187                 $db->sql_freeresult($result);
1188
1189                 // No attachments exist, but post table thinks they do so go ahead and reset post_attach flags
1190                 if (!sizeof($attachments))
1191                 {
1192                         $sql = 'UPDATE ' . POSTS_TABLE . '
1193                                 SET post_attachment = 0
1194                                 WHERE ' . $db->sql_in_set('post_id', $attach_list);
1195                         $db->sql_query($sql);
1196
1197                         // We need to update the topic indicator too if the complete topic is now without an attachment
1198                         if (sizeof($rowset) != $total_posts)
1199                         {
1200                                 // Not all posts are displayed so we query the db to find if there's any attachment for this topic
1201                                 $sql = 'SELECT a.post_msg_id as post_id
1202                                         FROM ' . ATTACHMENTS_TABLE . ' a, ' . POSTS_TABLE . " p
1203                                         WHERE p.topic_id = $topic_id
1204                                                 AND p.post_approved = 1
1205                                                 AND p.topic_id = a.topic_id";
1206                                 $result = $db->sql_query_limit($sql, 1);
1207                                 $row = $db->sql_fetchrow($result);
1208                                 $db->sql_freeresult($result);
1209
1210                                 if (!$row)
1211                                 {
1212                                         $sql = 'UPDATE ' . TOPICS_TABLE . "
1213                                                 SET topic_attachment = 0
1214                                                 WHERE topic_id = $topic_id";
1215                                         $db->sql_query($sql);
1216                                 }
1217                         }
1218                         else
1219                         {
1220                                 $sql = 'UPDATE ' . TOPICS_TABLE . "
1221                                         SET topic_attachment = 0
1222                                         WHERE topic_id = $topic_id";
1223                                 $db->sql_query($sql);
1224                         }
1225                 }
1226                 else if ($has_attachments && !$topic_data['topic_attachment'])
1227                 {
1228                         // Topic has approved attachments but its flag is wrong
1229                         $sql = 'UPDATE ' . TOPICS_TABLE . "
1230                                 SET topic_attachment = 1
1231                                 WHERE topic_id = $topic_id";
1232                         $db->sql_query($sql);
1233
1234                         $topic_data['topic_attachment'] = 1;
1235                 }
1236         }
1237         else
1238         {
1239                 $display_notice = true;
1240         }
1241 }
1242
1243 // Instantiate BBCode if need be
1244 if ($bbcode_bitfield !== '')
1245 {
1246         $bbcode = new bbcode(base64_encode($bbcode_bitfield));
1247 }
1248
1249 $i_total = sizeof($rowset) - 1;
1250 $prev_post_id = '';
1251
1252 $template->assign_vars(array(
1253         'S_NUM_POSTS' => sizeof($post_list))
1254 );
1255
1256 // Output the posts
1257 $first_unread = $post_unread = false;
1258 for ($i = 0, $end = sizeof($post_list); $i < $end; ++$i)
1259 {
1260         // A non-existing rowset only happens if there was no user present for the entered poster_id
1261         // This could be a broken posts table.
1262         if (!isset($rowset[$post_list[$i]]))
1263         {
1264                 continue;
1265         }
1266
1267         $row =& $rowset[$post_list[$i]];
1268         $poster_id = $row['user_id'];
1269
1270         // End signature parsing, only if needed
1271         if ($user_cache[$poster_id]['sig'] && $row['enable_sig'] && empty($user_cache[$poster_id]['sig_parsed']))
1272         {
1273                 $user_cache[$poster_id]['sig'] = censor_text($user_cache[$poster_id]['sig']);
1274
1275                 if ($user_cache[$poster_id]['sig_bbcode_bitfield'])
1276                 {
1277                         $bbcode->bbcode_second_pass($user_cache[$poster_id]['sig'], $user_cache[$poster_id]['sig_bbcode_uid'], $user_cache[$poster_id]['sig_bbcode_bitfield']);
1278                 }
1279
1280                 $user_cache[$poster_id]['sig'] = bbcode_nl2br($user_cache[$poster_id]['sig']);
1281                 $user_cache[$poster_id]['sig'] = smiley_text($user_cache[$poster_id]['sig']);
1282                 $user_cache[$poster_id]['sig_parsed'] = true;
1283         }
1284
1285         // Parse the message and subject
1286         $message = censor_text($row['post_text']);
1287
1288         // Second parse bbcode here
1289         if ($row['bbcode_bitfield'])
1290         {
1291                 $bbcode->bbcode_second_pass($message, $row['bbcode_uid'], $row['bbcode_bitfield']);
1292         }
1293
1294         $message = bbcode_nl2br($message);
1295         $message = smiley_text($message);
1296
1297         if (!empty($attachments[$row['post_id']]))
1298         {
1299                 parse_attachments($forum_id, $message, $attachments[$row['post_id']], $update_count);
1300         }
1301
1302         // Replace naughty words such as farty pants
1303         $row['post_subject'] = censor_text($row['post_subject']);
1304
1305         // Highlight active words (primarily for search)
1306         if ($highlight_match)
1307         {
1308                 $message = preg_replace('#(?!<.*)(?<!\w)(' . $highlight_match . ')(?!\w|[^<>]*(?:</s(?:cript|tyle))?>)#is', '<span class="posthilit">\1</span>', $message);
1309                 $row['post_subject'] = preg_replace('#(?!<.*)(?<!\w)(' . $highlight_match . ')(?!\w|[^<>]*(?:</s(?:cript|tyle))?>)#is', '<span class="posthilit">\1</span>', $row['post_subject']);
1310         }
1311
1312         // Editing information
1313         if (($row['post_edit_count'] && $config['display_last_edited']) || $row['post_edit_reason'])
1314         {
1315                 // Get usernames for all following posts if not already stored
1316                 if (!sizeof($post_edit_list) && ($row['post_edit_reason'] || ($row['post_edit_user'] && !isset($user_cache[$row['post_edit_user']]))))
1317                 {
1318                         // Remove all post_ids already parsed (we do not have to check them)
1319                         $post_storage_list = (!$store_reverse) ? array_slice($post_list, $i) : array_slice(array_reverse($post_list), $i);
1320
1321                         $sql = 'SELECT DISTINCT u.user_id, u.username, u.user_colour
1322                                 FROM ' . POSTS_TABLE . ' p, ' . USERS_TABLE . ' u
1323                                 WHERE ' . $db->sql_in_set('p.post_id', $post_storage_list) . '
1324                                         AND p.post_edit_count <> 0
1325                                         AND p.post_edit_user <> 0
1326                                         AND p.post_edit_user = u.user_id';
1327                         $result2 = $db->sql_query($sql);
1328                         while ($user_edit_row = $db->sql_fetchrow($result2))
1329                         {
1330                                 $post_edit_list[$user_edit_row['user_id']] = $user_edit_row;
1331                         }
1332                         $db->sql_freeresult($result2);
1333
1334                         unset($post_storage_list);
1335                 }
1336
1337                 $l_edit_time_total = ($row['post_edit_count'] == 1) ? $user->lang['EDITED_TIME_TOTAL'] : $user->lang['EDITED_TIMES_TOTAL'];
1338
1339                 if ($row['post_edit_reason'])
1340                 {
1341                         // User having edited the post also being the post author?
1342                         if (!$row['post_edit_user'] || $row['post_edit_user'] == $poster_id)
1343                         {
1344                                 $display_username = get_username_string('full', $poster_id, $row['username'], $row['user_colour'], $row['post_username']);
1345                         }
1346                         else
1347                         {
1348                                 $display_username = get_username_string('full', $row['post_edit_user'], $post_edit_list[$row['post_edit_user']]['username'], $post_edit_list[$row['post_edit_user']]['user_colour']);
1349                         }
1350
1351                         $l_edited_by = sprintf($l_edit_time_total, $display_username, $user->format_date($row['post_edit_time']), $row['post_edit_count']);
1352                 }
1353                 else
1354                 {
1355                         if ($row['post_edit_user'] && !isset($user_cache[$row['post_edit_user']]))
1356                         {
1357                                 $user_cache[$row['post_edit_user']] = $post_edit_list[$row['post_edit_user']];
1358                         }
1359
1360                         // User having edited the post also being the post author?
1361                         if (!$row['post_edit_user'] || $row['post_edit_user'] == $poster_id)
1362                         {
1363                                 $display_username = get_username_string('full', $poster_id, $row['username'], $row['user_colour'], $row['post_username']);
1364                         }
1365                         else
1366                         {
1367                                 $display_username = get_username_string('full', $row['post_edit_user'], $user_cache[$row['post_edit_user']]['username'], $user_cache[$row['post_edit_user']]['user_colour']);
1368                         }
1369
1370                         $l_edited_by = sprintf($l_edit_time_total, $display_username, $user->format_date($row['post_edit_time']), $row['post_edit_count']);
1371                 }
1372         }
1373         else
1374         {
1375                 $l_edited_by = '';
1376         }
1377
1378         // Bump information
1379         if ($topic_data['topic_bumped'] && $row['post_id'] == $topic_data['topic_last_post_id'] && isset($user_cache[$topic_data['topic_bumper']]) )
1380         {
1381                 // It is safe to grab the username from the user cache array, we are at the last
1382                 // post and only the topic poster and last poster are allowed to bump.
1383                 // Admins and mods are bound to the above rules too...
1384                 $l_bumped_by = '<br /><br />' . sprintf($user->lang['BUMPED_BY'], $user_cache[$topic_data['topic_bumper']]['username'], $user->format_date($topic_data['topic_last_post_time']));
1385         }
1386         else
1387         {
1388                 $l_bumped_by = '';
1389         }
1390
1391         $cp_row = array();
1392
1393         //
1394         if ($config['load_cpf_viewtopic'])
1395         {
1396                 $cp_row = (isset($profile_fields_cache[$poster_id])) ? $cp->generate_profile_fields_template('show', false, $profile_fields_cache[$poster_id]) : array();
1397         }
1398
1399         $post_unread = (isset($topic_tracking_info[$topic_id]) && $row['post_time'] > $topic_tracking_info[$topic_id]) ? true : false;
1400
1401         $s_first_unread = false;
1402         if (!$first_unread && $post_unread)
1403         {
1404                 $s_first_unread = $first_unread = true;
1405         }
1406
1407         //
1408         $postrow = array(
1409                 'POST_AUTHOR_FULL'              => get_username_string('full', $poster_id, $row['username'], $row['user_colour'], $row['post_username']),
1410                 'POST_AUTHOR_COLOUR'    => get_username_string('colour', $poster_id, $row['username'], $row['user_colour'], $row['post_username']),
1411                 'POST_AUTHOR'                   => get_username_string('username', $poster_id, $row['username'], $row['user_colour'], $row['post_username']),
1412                 'U_POST_AUTHOR'                 => get_username_string('profile', $poster_id, $row['username'], $row['user_colour'], $row['post_username']),
1413
1414                 'RANK_TITLE'            => $user_cache[$poster_id]['rank_title'],
1415                 'RANK_IMG'                      => $user_cache[$poster_id]['rank_image'],
1416                 'RANK_IMG_SRC'          => $user_cache[$poster_id]['rank_image_src'],
1417                 'POSTER_JOINED'         => $user_cache[$poster_id]['joined'],
1418                 'POSTER_POSTS'          => $user_cache[$poster_id]['posts'],
1419                 'POSTER_FROM'           => $user_cache[$poster_id]['from'],
1420                 'POSTER_AVATAR'         => $user_cache[$poster_id]['avatar'],
1421                 'POSTER_WARNINGS'       => $user_cache[$poster_id]['warnings'],
1422                 'POSTER_AGE'            => $user_cache[$poster_id]['age'],
1423
1424                 'POST_DATE'                     => $user->format_date($row['post_time']),
1425                 'POST_SUBJECT'          => $row['post_subject'],
1426                 'MESSAGE'                       => $message,
1427                 'SIGNATURE'                     => ($row['enable_sig']) ? $user_cache[$poster_id]['sig'] : '',
1428                 'EDITED_MESSAGE'        => $l_edited_by,
1429                 'EDIT_REASON'           => $row['post_edit_reason'],
1430                 'BUMPED_MESSAGE'        => $l_bumped_by,
1431
1432                 'MINI_POST_IMG'                 => ($post_unread) ? $user->img('icon_post_target_unread', 'NEW_POST') : $user->img('icon_post_target', 'POST'),
1433                 'POST_ICON_IMG'                 => ($topic_data['enable_icons'] && !empty($row['icon_id'])) ? $icons[$row['icon_id']]['img'] : '',
1434                 'POST_ICON_IMG_WIDTH'   => ($topic_data['enable_icons'] && !empty($row['icon_id'])) ? $icons[$row['icon_id']]['width'] : '',
1435                 'POST_ICON_IMG_HEIGHT'  => ($topic_data['enable_icons'] && !empty($row['icon_id'])) ? $icons[$row['icon_id']]['height'] : '',
1436                 'ICQ_STATUS_IMG'                => $user_cache[$poster_id]['icq_status_img'],
1437                 'ONLINE_IMG'                    => ($poster_id == ANONYMOUS || !$config['load_onlinetrack']) ? '' : (($user_cache[$poster_id]['online']) ? $user->img('icon_user_online', 'ONLINE') : $user->img('icon_user_offline', 'OFFLINE')),
1438                 'S_ONLINE'                              => ($poster_id == ANONYMOUS || !$config['load_onlinetrack']) ? false : (($user_cache[$poster_id]['online']) ? true : false),
1439
1440                 'U_EDIT'                        => (!$user->data['is_registered']) ? '' : ((($user->data['user_id'] == $poster_id && $auth->acl_get('f_edit', $forum_id) && ($row['post_time'] > time() - ($config['edit_time'] * 60) || !$config['edit_time'])) || $auth->acl_get('m_edit', $forum_id)) ? append_sid('posting', "mode=edit&amp;f=$forum_id&amp;p={$row['post_id']}") : ''),
1441                 'U_QUOTE'                       => ($auth->acl_get('f_reply', $forum_id)) ? append_sid('posting', "mode=quote&amp;f=$forum_id&amp;p={$row['post_id']}") : '',
1442                 'U_INFO'                        => ($auth->acl_get('m_info', $forum_id)) ? append_sid('mcp', "i=main&amp;mode=post_details&amp;f=$forum_id&amp;p=" . $row['post_id'], true, $user->session_id) : '',
1443                 'U_DELETE'                      => (!$user->data['is_registered']) ? '' : ((($user->data['user_id'] == $poster_id && $auth->acl_get('f_delete', $forum_id) && $topic_data['topic_last_post_id'] == $row['post_id'] && ($row['post_time'] > time() - ($config['edit_time'] * 60) || !$config['edit_time'])) || $auth->acl_get('m_delete', $forum_id)) ? append_sid('posting', "mode=delete&amp;f=$forum_id&amp;p={$row['post_id']}") : ''),
1444
1445                 'U_PROFILE'             => $user_cache[$poster_id]['profile'],
1446                 'U_SEARCH'              => $user_cache[$poster_id]['search'],
1447                 'U_PM'                  => ($poster_id != ANONYMOUS && $config['allow_privmsg'] && $auth->acl_get('u_sendpm') && ($user_cache[$poster_id]['allow_pm'] || $auth->acl_gets('a_', 'm_') || $auth->acl_getf_global('m_'))) ? append_sid('ucp', 'i=pm&amp;mode=compose&amp;action=quotepost&amp;p=' . $row['post_id']) : '',
1448                 'U_EMAIL'               => $user_cache[$poster_id]['email'],
1449                 'U_WWW'                 => $user_cache[$poster_id]['www'],
1450                 'U_ICQ'                 => $user_cache[$poster_id]['icq'],
1451                 'U_AIM'                 => $user_cache[$poster_id]['aim'],
1452                 'U_MSN'                 => $user_cache[$poster_id]['msn'],
1453                 'U_YIM'                 => $user_cache[$poster_id]['yim'],
1454                 'U_JABBER'              => $user_cache[$poster_id]['jabber'],
1455
1456                 'U_REPORT'                      => ($auth->acl_get('f_report', $forum_id)) ? append_sid('report', 'f=' . $forum_id . '&amp;p=' . $row['post_id']) : '',
1457                 'U_MCP_REPORT'          => ($auth->acl_get('m_report', $forum_id)) ? append_sid('mcp', 'i=reports&amp;mode=report_details&amp;f=' . $forum_id . '&amp;p=' . $row['post_id'], true, $user->session_id) : '',
1458                 'U_MCP_APPROVE'         => ($auth->acl_get('m_approve', $forum_id)) ? append_sid('mcp', 'i=queue&amp;mode=approve_details&amp;f=' . $forum_id . '&amp;p=' . $row['post_id'], true, $user->session_id) : '',
1459                 'U_MINI_POST'           => append_sid('viewtopic', 'p=' . $row['post_id']) . (($topic_data['topic_type'] == POST_GLOBAL) ? '&amp;f=' . $forum_id : '') . '#p' . $row['post_id'],
1460                 'U_NEXT_POST_ID'        => ($i < $i_total && isset($rowset[$post_list[$i + 1]])) ? $rowset[$post_list[$i + 1]]['post_id'] : '',
1461                 'U_PREV_POST_ID'        => $prev_post_id,
1462                 'U_NOTES'                       => ($auth->acl_getf_global('m_')) ? append_sid('mcp', 'i=notes&amp;mode=user_notes&amp;u=' . $poster_id, true, $user->session_id) : '',
1463                 'U_WARN'                        => ($auth->acl_get('m_warn') && $poster_id != $user->data['user_id'] && $poster_id != ANONYMOUS) ? append_sid('mcp', 'i=warn&amp;mode=warn_post&amp;f=' . $forum_id . '&amp;p=' . $row['post_id'], true, $user->session_id) : '',
1464
1465                 'POST_ID'                       => $row['post_id'],
1466                 'POSTER_ID'                     => $poster_id,
1467
1468                 'S_HAS_ATTACHMENTS'     => (!empty($attachments[$row['post_id']])) ? true : false,
1469                 'S_POST_UNAPPROVED'     => ($row['post_approved']) ? false : true,
1470                 'S_POST_REPORTED'       => ($row['post_reported'] && $auth->acl_get('m_report', $forum_id)) ? true : false,
1471                 'S_DISPLAY_NOTICE'      => $display_notice && $row['post_attachment'],
1472                 'S_FRIEND'                      => ($row['friend']) ? true : false,
1473                 'S_UNREAD_POST'         => $post_unread,
1474                 'S_FIRST_UNREAD'        => $s_first_unread,
1475                 'S_CUSTOM_FIELDS'       => (isset($cp_row['row']) && sizeof($cp_row['row'])) ? true : false,
1476                 'S_TOPIC_POSTER'        => ($topic_data['topic_poster'] == $poster_id) ? true : false,
1477
1478                 'S_IGNORE_POST'         => ($row['hide_post']) ? true : false,
1479                 'L_IGNORE_POST'         => ($row['hide_post']) ? sprintf($user->lang['POST_BY_FOE'], get_username_string('full', $poster_id, $row['username'], $row['user_colour'], $row['post_username']), '<a href="' . $viewtopic_url . "&amp;p={$row['post_id']}&amp;view=show#p{$row['post_id']}" . '">', '</a>') : '',
1480         );
1481
1482         if (isset($cp_row['row']) && sizeof($cp_row['row']))
1483         {
1484                 $postrow = array_merge($postrow, $cp_row['row']);
1485         }
1486
1487         // Dump vars into template
1488         $template->assign_block_vars('postrow', $postrow);
1489
1490         if (!empty($cp_row['blockrow']))
1491         {
1492                 foreach ($cp_row['blockrow'] as $field_data)
1493                 {
1494                         $template->assign_block_vars('postrow.custom_fields', $field_data);
1495                 }
1496         }
1497
1498         // Display not already displayed Attachments for this post, we already parsed them. ;)
1499         if (!empty($attachments[$row['post_id']]))
1500         {
1501                 foreach ($attachments[$row['post_id']] as $attachment)
1502                 {
1503                         $template->assign_block_vars('postrow.attachment', array(
1504                                 'DISPLAY_ATTACHMENT'    => $attachment)
1505                         );
1506                 }
1507         }
1508
1509         $prev_post_id = $row['post_id'];
1510
1511         unset($rowset[$post_list[$i]]);
1512         unset($attachments[$row['post_id']]);
1513 }
1514 unset($rowset, $user_cache);
1515
1516 // Update topic view and if necessary attachment view counters ... but only for humans and if this is the first 'page view'
1517 if (isset($user->data['session_page']) && !$user->data['is_bot'] && strpos($user->data['session_page'], '&t=' . $topic_id) === false)
1518 {
1519         $sql = 'UPDATE ' . TOPICS_TABLE . '
1520                 SET topic_views = topic_views + 1, topic_last_view_time = ' . time() . "
1521                 WHERE topic_id = $topic_id";
1522         $db->sql_query($sql);
1523
1524         // Update the attachment download counts
1525         if (sizeof($update_count))
1526         {
1527                 $sql = 'UPDATE ' . ATTACHMENTS_TABLE . '
1528                         SET download_count = download_count + 1
1529                         WHERE ' . $db->sql_in_set('attach_id', array_unique($update_count));
1530                 $db->sql_query($sql);
1531         }
1532 }
1533
1534 // Only mark topic if it's currently unread. Also make sure we do not set topic tracking back if earlier pages are viewed.
1535 if (isset($topic_tracking_info[$topic_id]) && $topic_data['topic_last_post_time'] > $topic_tracking_info[$topic_id] && $max_post_time > $topic_tracking_info[$topic_id])
1536 {
1537         markread('topic', $forum_id, $topic_id, $max_post_time);
1538
1539         // Update forum info
1540         $all_marked_read = update_forum_tracking_info($forum_id, $topic_data['forum_last_post_time'], (isset($topic_data['forum_mark_time'])) ? $topic_data['forum_mark_time'] : false, false);
1541 }
1542 else
1543 {
1544         $all_marked_read = true;
1545 }
1546
1547 // If there are absolutely no more unread posts in this forum and unread posts shown, we can savely show the #unread link
1548 if ($all_marked_read)
1549 {
1550         if ($post_unread)
1551         {
1552                 $template->assign_vars(array(
1553                         'U_VIEW_UNREAD_POST'    => '#unread',
1554                 ));
1555         }
1556         else if (isset($topic_tracking_info[$topic_id]) && $topic_data['topic_last_post_time'] > $topic_tracking_info[$topic_id])
1557         {
1558                 $template->assign_vars(array(
1559                         'U_VIEW_UNREAD_POST'    => append_sid('viewtopic', "f=$forum_id&amp;t=$topic_id&amp;view=unread") . '#unread',
1560                 ));
1561         }
1562 }
1563 else if (!$all_marked_read)
1564 {
1565         $last_page = ((floor($start / $config['posts_per_page']) + 1) == max(ceil($total_posts / $config['posts_per_page']), 1)) ? true : false;
1566
1567         // What can happen is that we are at the last displayed page. If so, we also display the #unread link based in $post_unread
1568         if ($last_page && $post_unread)
1569         {
1570                 $template->assign_vars(array(
1571                         'U_VIEW_UNREAD_POST'    => '#unread',
1572                 ));
1573         }
1574         else if (!$last_page)
1575         {
1576                 $template->assign_vars(array(
1577                         'U_VIEW_UNREAD_POST'    => append_sid('viewtopic', "f=$forum_id&amp;t=$topic_id&amp;view=unread") . '#unread',
1578                 ));
1579         }
1580 }
1581
1582 // We overwrite $_REQUEST['f'] if there is no forum specified
1583 // to be able to display the correct online list.
1584 // One downside is that the user currently viewing this topic/post is not taken into account.
1585 if (empty($_REQUEST['f']))
1586 {
1587         $_REQUEST['f'] = $forum_id;
1588 }
1589
1590 // Output the page
1591 page_header($user->lang['VIEW_TOPIC'] . ' - ' . $topic_data['topic_title']);
1592
1593 $template->set_filenames(array(
1594         'body' => ($view == 'print') ? 'viewtopic_print.html' : 'viewtopic_body.html')
1595 );
1596 make_jumpbox(append_sid('viewforum'), $forum_id);
1597
1598 page_footer();
1599
1600 ?>