source: branches/posledni/forum/viewtopic.php

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