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 | $phpbb_root_path = (defined('PHPBB_ROOT_PATH')) ? PHPBB_ROOT_PATH : './';
|
---|
16 | $phpEx = substr(strrchr(__FILE__, '.'), 1);
|
---|
17 | include($phpbb_root_path . 'common.' . $phpEx);
|
---|
18 | include($phpbb_root_path . 'includes/functions_display.' . $phpEx);
|
---|
19 | include($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?
|
---|
54 | if (!$topic_id && !$post_id)
|
---|
55 | {
|
---|
56 | trigger_error('NO_TOPIC');
|
---|
57 | }
|
---|
58 |
|
---|
59 | // Find topic id if user requested a newer or older topic
|
---|
60 | if ($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.
|
---|
191 | if ($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.
|
---|
197 | if ($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 |
|
---|
206 | if ($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 |
|
---|
241 | if (!$post_id)
|
---|
242 | {
|
---|
243 | $sql_array['WHERE'] = "t.topic_id = $topic_id";
|
---|
244 | }
|
---|
245 | else
|
---|
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 |
|
---|
252 | if (!$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 | }
|
---|
258 | else
|
---|
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
|
---|
276 | if (!$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) ? "&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)
|
---|
289 | if ($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) ? "&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
|
---|
337 | 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())
|
---|
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 |
|
---|
351 | if (!$topic_data['topic_approved'] && !$auth->acl_get('m_approve', $forum_id))
|
---|
352 | {
|
---|
353 | trigger_error('NO_TOPIC');
|
---|
354 | }
|
---|
355 |
|
---|
356 | // Start auth check
|
---|
357 | if (!$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
|
---|
369 | if ($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
|
---|
375 | if (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&t=$topic_id");
|
---|
380 |
|
---|
381 | if ($user->data['user_id'] == ANONYMOUS)
|
---|
382 | {
|
---|
383 | login_box($redirect_url . "&p=$post_id&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) ? "&p=$jump_to" : "&p=$post_id") . "#p$jump_to");
|
---|
390 | }
|
---|
391 | }
|
---|
392 |
|
---|
393 | // What is start equal to?
|
---|
394 | if ($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
|
---|
400 | if (!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 |
|
---|
426 | 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);
|
---|
427 |
|
---|
428 | // Obtain correct post count and ordering SQL if user has
|
---|
429 | // requested anything different
|
---|
430 | if ($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 | }
|
---|
450 | else
|
---|
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 = '';
|
---|
458 | if ($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
|
---|
474 | if ($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&t=$topic_id&start=$start" . ((strlen($u_sort_param)) ? "&$u_sort_param" : '') . (($highlight_match) ? "&hilit=$highlight" : ''));
|
---|
481 |
|
---|
482 | // Are we watching this topic?
|
---|
483 | $s_watching_topic = array(
|
---|
484 | 'link' => '',
|
---|
485 | 'title' => '',
|
---|
486 | 'is_watching' => false,
|
---|
487 | );
|
---|
488 |
|
---|
489 | if (($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
|
---|
502 | if ($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();
|
---|
540 | if ($topic_data['topic_attachment'])
|
---|
541 | {
|
---|
542 | $extensions = $cache->obtain_attach_extensions($forum_id);
|
---|
543 | }
|
---|
544 |
|
---|
545 | // Forum rules listing
|
---|
546 | $s_forum_rules = '';
|
---|
547 | gen_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&t=$topic_id" . ((strlen($u_sort_param)) ? "&$u_sort_param" : '') . (($highlight_match) ? "&hilit=$highlight" : '')), $total_posts, $config['posts_per_page'], $start);
|
---|
568 |
|
---|
569 | // Navigation links
|
---|
570 | generate_forum_nav($topic_data);
|
---|
571 |
|
---|
572 | // Forum Rules
|
---|
573 | generate_forum_rules($topic_data);
|
---|
574 |
|
---|
575 | // Moderators
|
---|
576 | $forum_moderators = array();
|
---|
577 | if ($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&mode=topic_view&f=$forum_id&t=$topic_id&start=$start" . ((strlen($u_sort_param)) ? "&$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&t=$topic_id&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&t=$topic_id&start=$start&quickmod=1&redirect=" . urlencode(str_replace('&', '&', $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&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&t=$topic_id&view=previous"),
|
---|
650 | 'U_VIEW_NEWER_TOPIC' => append_sid("{$phpbb_root_path}viewtopic.$phpEx", "f=$forum_id&t=$topic_id&view=next"),
|
---|
651 | 'U_PRINT_TOPIC' => ($auth->acl_get('f_print', $forum_id)) ? $viewtopic_url . '&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&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 . '&bookmark=1&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&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&f=$forum_id&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&f=$forum_id&t=$topic_id&hash=" . generate_link_hash("topic_$topic_id")) : '')
|
---|
664 | );
|
---|
665 |
|
---|
666 | // Does this topic contain a poll?
|
---|
667 | if (!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&t=$topic_id&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&t=$topic_id&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 . '&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 |
|
---|
898 | if ($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 | }
|
---|
911 | else
|
---|
912 | {
|
---|
913 | // Select the sort order
|
---|
914 | $direction = (($sort_dir == 'd') ? 'DESC' : 'ASC');
|
---|
915 | $sql_start = $start;
|
---|
916 | }
|
---|
917 |
|
---|
918 | if (is_array($sort_by_sql[$sort_key]))
|
---|
919 | {
|
---|
920 | $sql_sort_order = implode(' ' . $direction . ', ', $sort_by_sql[$sort_key]) . ' ' . $direction;
|
---|
921 | }
|
---|
922 | else
|
---|
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;
|
---|
944 | while ($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 |
|
---|
951 | if (!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
|
---|
992 | while ($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&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&action=aim&u=$poster_id") : '',
|
---|
1136 | 'msn' => ($row['user_msnm'] && $auth->acl_get('u_sendim')) ? append_sid("{$phpbb_root_path}memberlist.$phpEx", "mode=contact&action=msnm&u=$poster_id") : '',
|
---|
1137 | 'yim' => ($row['user_yim']) ? 'http://edit.yahoo.com/config/send_webmesg?.target=' . urlencode($row['user_yim']) . '&.src=pg' : '',
|
---|
1138 | 'jabber' => ($row['user_jabber'] && $auth->acl_get('u_sendim')) ? append_sid("{$phpbb_root_path}memberlist.$phpEx", "mode=contact&action=jabber&u=$poster_id") : '',
|
---|
1139 | 'search' => ($auth->acl_get('u_search')) ? append_sid("{$phpbb_root_path}search.$phpEx", "author_id=$poster_id&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&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'] . '&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
|
---|
1194 | if ($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
|
---|
1222 | if ($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 | }
|
---|
1237 | unset($id_cache);
|
---|
1238 |
|
---|
1239 | // Pull attachment data
|
---|
1240 | if (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
|
---|
1312 | if ($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;
|
---|
1326 | for ($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&f=$forum_id&p={$row['post_id']}") : '',
|
---|
1525 | 'U_QUOTE' => ($auth->acl_get('f_reply', $forum_id)) ? append_sid("{$phpbb_root_path}posting.$phpEx", "mode=quote&f=$forum_id&p={$row['post_id']}") : '',
|
---|
1526 | 'U_INFO' => ($auth->acl_get('m_info', $forum_id)) ? append_sid("{$phpbb_root_path}mcp.$phpEx", "i=main&mode=post_details&f=$forum_id&p=" . $row['post_id'], true, $user->session_id) : '',
|
---|
1527 | 'U_DELETE' => ($delete_allowed) ? append_sid("{$phpbb_root_path}posting.$phpEx", "mode=delete&f=$forum_id&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&mode=compose&action=quotepost&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 . '&p=' . $row['post_id']) : '',
|
---|
1541 | 'U_MCP_REPORT' => ($auth->acl_get('m_report', $forum_id)) ? append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=reports&mode=report_details&f=' . $forum_id . '&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&mode=approve_details&f=' . $forum_id . '&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) ? '&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&mode=user_notes&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&mode=warn_post&f=' . $forum_id . '&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 . "&p={$row['post_id']}&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 | }
|
---|
1598 | unset($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'
|
---|
1601 | if (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
|
---|
1620 | if ($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.
|
---|
1640 | 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])
|
---|
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 | }
|
---|
1647 | else
|
---|
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
|
---|
1653 | if ($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&t=$topic_id&view=unread") . '#unread',
|
---|
1665 | ));
|
---|
1666 | }
|
---|
1667 | }
|
---|
1668 | else 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&t=$topic_id&view=unread") . '#unread',
|
---|
1683 | ));
|
---|
1684 | }
|
---|
1685 | }
|
---|
1686 |
|
---|
1687 | // let's set up quick_reply
|
---|
1688 | $s_quick_reply = false;
|
---|
1689 | if ($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 |
|
---|
1695 | if ($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&f=$forum_id&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.
|
---|
1735 | if (empty($_REQUEST['f']))
|
---|
1736 | {
|
---|
1737 | $_REQUEST['f'] = $forum_id;
|
---|
1738 | }
|
---|
1739 |
|
---|
1740 | // We need to do the same with the topic_id. See #53025.
|
---|
1741 | if (empty($_REQUEST['t']) && !empty($topic_id))
|
---|
1742 | {
|
---|
1743 | $_REQUEST['t'] = $topic_id;
|
---|
1744 | }
|
---|
1745 |
|
---|
1746 | // Output the page
|
---|
1747 | page_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 | );
|
---|
1752 | make_jumpbox(append_sid("{$phpbb_root_path}viewforum.$phpEx"), $forum_id);
|
---|
1753 |
|
---|
1754 | page_footer();
|
---|
1755 |
|
---|
1756 | ?>
|
---|