| 130 |
kaklik |
1 |
<?php |
|
|
2 |
/*************************************************************************** |
|
|
3 |
* viewtopic.php |
|
|
4 |
* ------------------- |
|
|
5 |
* begin : Saturday, Feb 13, 2001 |
|
|
6 |
* copyright : (C) 2001 The phpBB Group |
|
|
7 |
* email : support@phpbb.com |
|
|
8 |
* |
|
|
9 |
* $Id: viewtopic.php,v 1.186.2.46 2006/04/21 19:07:46 grahamje Exp $ |
|
|
10 |
* |
|
|
11 |
* |
|
|
12 |
***************************************************************************/ |
|
|
13 |
|
|
|
14 |
/*************************************************************************** |
|
|
15 |
* |
|
|
16 |
* This program is free software; you can redistribute it and/or modify |
|
|
17 |
* it under the terms of the GNU General Public License as published by |
|
|
18 |
* the Free Software Foundation; either version 2 of the License, or |
|
|
19 |
* (at your option) any later version. |
|
|
20 |
* |
|
|
21 |
***************************************************************************/ |
|
|
22 |
|
|
|
23 |
define('IN_PHPBB', true); |
|
|
24 |
$phpbb_root_path = './'; |
|
|
25 |
include($phpbb_root_path . 'extension.inc'); |
|
|
26 |
include($phpbb_root_path . 'common.'.$phpEx); |
|
|
27 |
include($phpbb_root_path . 'includes/bbcode.'.$phpEx); |
|
|
28 |
|
|
|
29 |
// |
|
|
30 |
// Start initial var setup |
|
|
31 |
// |
|
|
32 |
$topic_id = $post_id = 0; |
|
|
33 |
if ( isset($HTTP_GET_VARS[POST_TOPIC_URL]) ) |
|
|
34 |
{ |
|
|
35 |
$topic_id = intval($HTTP_GET_VARS[POST_TOPIC_URL]); |
|
|
36 |
} |
|
|
37 |
else if ( isset($HTTP_GET_VARS['topic']) ) |
|
|
38 |
{ |
|
|
39 |
$topic_id = intval($HTTP_GET_VARS['topic']); |
|
|
40 |
} |
|
|
41 |
|
|
|
42 |
if ( isset($HTTP_GET_VARS[POST_POST_URL])) |
|
|
43 |
{ |
|
|
44 |
$post_id = intval($HTTP_GET_VARS[POST_POST_URL]); |
|
|
45 |
} |
|
|
46 |
|
|
|
47 |
|
|
|
48 |
$start = ( isset($HTTP_GET_VARS['start']) ) ? intval($HTTP_GET_VARS['start']) : 0; |
|
|
49 |
|
|
|
50 |
if (!$topic_id && !$post_id) |
|
|
51 |
{ |
|
|
52 |
message_die(GENERAL_MESSAGE, 'Topic_post_not_exist'); |
|
|
53 |
} |
|
|
54 |
|
|
|
55 |
// |
|
|
56 |
// Find topic id if user requested a newer |
|
|
57 |
// or older topic |
|
|
58 |
// |
|
|
59 |
if ( isset($HTTP_GET_VARS['view']) && empty($HTTP_GET_VARS[POST_POST_URL]) ) |
|
|
60 |
{ |
|
|
61 |
if ( $HTTP_GET_VARS['view'] == 'newest' ) |
|
|
62 |
{ |
|
|
63 |
if ( isset($HTTP_COOKIE_VARS[$board_config['cookie_name'] . '_sid']) || isset($HTTP_GET_VARS['sid']) ) |
|
|
64 |
{ |
|
|
65 |
$session_id = isset($HTTP_COOKIE_VARS[$board_config['cookie_name'] . '_sid']) ? $HTTP_COOKIE_VARS[$board_config['cookie_name'] . '_sid'] : $HTTP_GET_VARS['sid']; |
|
|
66 |
|
|
|
67 |
if (!preg_match('/^[A-Za-z0-9]*$/', $session_id)) |
|
|
68 |
{ |
|
|
69 |
$session_id = ''; |
|
|
70 |
} |
|
|
71 |
|
|
|
72 |
if ( $session_id ) |
|
|
73 |
{ |
|
|
74 |
$sql = "SELECT p.post_id |
|
|
75 |
FROM " . POSTS_TABLE . " p, " . SESSIONS_TABLE . " s, " . USERS_TABLE . " u |
|
|
76 |
WHERE s.session_id = '$session_id' |
|
|
77 |
AND u.user_id = s.session_user_id |
|
|
78 |
AND p.topic_id = $topic_id |
|
|
79 |
AND p.post_time >= u.user_lastvisit |
|
|
80 |
ORDER BY p.post_time ASC |
|
|
81 |
LIMIT 1"; |
|
|
82 |
if ( !($result = $db->sql_query($sql)) ) |
|
|
83 |
{ |
|
|
84 |
message_die(GENERAL_ERROR, 'Could not obtain newer/older topic information', '', __LINE__, __FILE__, $sql); |
|
|
85 |
} |
|
|
86 |
|
|
|
87 |
if ( !($row = $db->sql_fetchrow($result)) ) |
|
|
88 |
{ |
|
|
89 |
message_die(GENERAL_MESSAGE, 'No_new_posts_last_visit'); |
|
|
90 |
} |
|
|
91 |
|
|
|
92 |
$post_id = $row['post_id']; |
|
|
93 |
|
|
|
94 |
if (isset($HTTP_GET_VARS['sid'])) |
|
|
95 |
{ |
|
|
96 |
redirect("viewtopic.$phpEx?sid=$session_id&" . POST_POST_URL . "=$post_id#$post_id"); |
|
|
97 |
} |
|
|
98 |
else |
|
|
99 |
{ |
|
|
100 |
redirect("viewtopic.$phpEx?" . POST_POST_URL . "=$post_id#$post_id"); |
|
|
101 |
} |
|
|
102 |
} |
|
|
103 |
} |
|
|
104 |
|
|
|
105 |
redirect(append_sid("viewtopic.$phpEx?" . POST_TOPIC_URL . "=$topic_id", true)); |
|
|
106 |
} |
|
|
107 |
else if ( $HTTP_GET_VARS['view'] == 'next' || $HTTP_GET_VARS['view'] == 'previous' ) |
|
|
108 |
{ |
|
|
109 |
$sql_condition = ( $HTTP_GET_VARS['view'] == 'next' ) ? '>' : '<'; |
|
|
110 |
$sql_ordering = ( $HTTP_GET_VARS['view'] == 'next' ) ? 'ASC' : 'DESC'; |
|
|
111 |
|
|
|
112 |
$sql = "SELECT t.topic_id |
|
|
113 |
FROM " . TOPICS_TABLE . " t, " . TOPICS_TABLE . " t2 |
|
|
114 |
WHERE |
|
|
115 |
t2.topic_id = $topic_id |
|
|
116 |
AND t.forum_id = t2.forum_id |
|
|
117 |
AND t.topic_moved_id = 0 |
|
|
118 |
AND t.topic_last_post_id $sql_condition t2.topic_last_post_id |
|
|
119 |
ORDER BY t.topic_last_post_id $sql_ordering |
|
|
120 |
LIMIT 1"; |
|
|
121 |
if ( !($result = $db->sql_query($sql)) ) |
|
|
122 |
{ |
|
|
123 |
message_die(GENERAL_ERROR, "Could not obtain newer/older topic information", '', __LINE__, __FILE__, $sql); |
|
|
124 |
} |
|
|
125 |
|
|
|
126 |
if ( $row = $db->sql_fetchrow($result) ) |
|
|
127 |
{ |
|
|
128 |
$topic_id = intval($row['topic_id']); |
|
|
129 |
} |
|
|
130 |
else |
|
|
131 |
{ |
|
|
132 |
$message = ( $HTTP_GET_VARS['view'] == 'next' ) ? 'No_newer_topics' : 'No_older_topics'; |
|
|
133 |
message_die(GENERAL_MESSAGE, $message); |
|
|
134 |
} |
|
|
135 |
} |
|
|
136 |
} |
|
|
137 |
|
|
|
138 |
// |
|
|
139 |
// This rather complex gaggle of code handles querying for topics but |
|
|
140 |
// also allows for direct linking to a post (and the calculation of which |
|
|
141 |
// page the post is on and the correct display of viewtopic) |
|
|
142 |
// |
|
|
143 |
$join_sql_table = (!$post_id) ? '' : ", " . POSTS_TABLE . " p, " . POSTS_TABLE . " p2 "; |
|
|
144 |
$join_sql = (!$post_id) ? "t.topic_id = $topic_id" : "p.post_id = $post_id AND t.topic_id = p.topic_id AND p2.topic_id = p.topic_id AND p2.post_id <= $post_id"; |
|
|
145 |
$count_sql = (!$post_id) ? '' : ", COUNT(p2.post_id) AS prev_posts"; |
|
|
146 |
|
|
|
147 |
$order_sql = (!$post_id) ? '' : "GROUP BY p.post_id, t.topic_id, t.topic_title, t.topic_status, t.topic_replies, t.topic_time, t.topic_type, t.topic_vote, t.topic_last_post_id, f.forum_name, f.forum_status, f.forum_id, f.auth_view, f.auth_read, f.auth_post, f.auth_reply, f.auth_edit, f.auth_delete, f.auth_sticky, f.auth_announce, f.auth_pollcreate, f.auth_vote, f.auth_attachments ORDER BY p.post_id ASC"; |
|
|
148 |
|
|
|
149 |
$sql = "SELECT t.topic_id, t.topic_title, t.topic_status, t.topic_replies, t.topic_time, t.topic_type, t.topic_vote, t.topic_last_post_id, f.forum_name, f.forum_status, f.forum_id, f.auth_view, f.auth_read, f.auth_post, f.auth_reply, f.auth_edit, f.auth_delete, f.auth_sticky, f.auth_announce, f.auth_pollcreate, f.auth_vote, f.auth_attachments" . $count_sql . " |
|
|
150 |
FROM " . TOPICS_TABLE . " t, " . FORUMS_TABLE . " f" . $join_sql_table . " |
|
|
151 |
WHERE $join_sql |
|
|
152 |
AND f.forum_id = t.forum_id |
|
|
153 |
$order_sql"; |
|
|
154 |
if ( !($result = $db->sql_query($sql)) ) |
|
|
155 |
{ |
|
|
156 |
message_die(GENERAL_ERROR, "Could not obtain topic information", '', __LINE__, __FILE__, $sql); |
|
|
157 |
} |
|
|
158 |
|
|
|
159 |
if ( !($forum_topic_data = $db->sql_fetchrow($result)) ) |
|
|
160 |
{ |
|
|
161 |
message_die(GENERAL_MESSAGE, 'Topic_post_not_exist'); |
|
|
162 |
} |
|
|
163 |
|
|
|
164 |
$forum_id = intval($forum_topic_data['forum_id']); |
|
|
165 |
|
|
|
166 |
// |
|
|
167 |
// Start session management |
|
|
168 |
// |
|
|
169 |
$userdata = session_pagestart($user_ip, $forum_id); |
|
|
170 |
init_userprefs($userdata); |
|
|
171 |
// |
|
|
172 |
// End session management |
|
|
173 |
// |
|
|
174 |
|
|
|
175 |
// |
|
|
176 |
// Start auth check |
|
|
177 |
// |
|
|
178 |
$is_auth = array(); |
|
|
179 |
$is_auth = auth(AUTH_ALL, $forum_id, $userdata, $forum_topic_data); |
|
|
180 |
|
|
|
181 |
if( !$is_auth['auth_view'] || !$is_auth['auth_read'] ) |
|
|
182 |
{ |
|
|
183 |
if ( !$userdata['session_logged_in'] ) |
|
|
184 |
{ |
|
|
185 |
$redirect = ($post_id) ? POST_POST_URL . "=$post_id" : POST_TOPIC_URL . "=$topic_id"; |
|
|
186 |
$redirect .= ($start) ? "&start=$start" : ''; |
|
|
187 |
redirect(append_sid("login.$phpEx?redirect=viewtopic.$phpEx&$redirect", true)); |
|
|
188 |
} |
|
|
189 |
|
|
|
190 |
$message = ( !$is_auth['auth_view'] ) ? $lang['Topic_post_not_exist'] : sprintf($lang['Sorry_auth_read'], $is_auth['auth_read_type']); |
|
|
191 |
|
|
|
192 |
message_die(GENERAL_MESSAGE, $message); |
|
|
193 |
} |
|
|
194 |
// |
|
|
195 |
// End auth check |
|
|
196 |
// |
|
|
197 |
|
|
|
198 |
$forum_name = $forum_topic_data['forum_name']; |
|
|
199 |
$topic_title = $forum_topic_data['topic_title']; |
|
|
200 |
$topic_id = intval($forum_topic_data['topic_id']); |
|
|
201 |
$topic_time = $forum_topic_data['topic_time']; |
|
|
202 |
|
|
|
203 |
if ($post_id) |
|
|
204 |
{ |
|
|
205 |
$start = floor(($forum_topic_data['prev_posts'] - 1) / intval($board_config['posts_per_page'])) * intval($board_config['posts_per_page']); |
|
|
206 |
} |
|
|
207 |
|
|
|
208 |
// |
|
|
209 |
// Is user watching this thread? |
|
|
210 |
// |
|
|
211 |
if( $userdata['session_logged_in'] ) |
|
|
212 |
{ |
|
|
213 |
$can_watch_topic = TRUE; |
|
|
214 |
|
|
|
215 |
$sql = "SELECT notify_status |
|
|
216 |
FROM " . TOPICS_WATCH_TABLE . " |
|
|
217 |
WHERE topic_id = $topic_id |
|
|
218 |
AND user_id = " . $userdata['user_id']; |
|
|
219 |
if ( !($result = $db->sql_query($sql)) ) |
|
|
220 |
{ |
|
|
221 |
message_die(GENERAL_ERROR, "Could not obtain topic watch information", '', __LINE__, __FILE__, $sql); |
|
|
222 |
} |
|
|
223 |
|
|
|
224 |
if ( $row = $db->sql_fetchrow($result) ) |
|
|
225 |
{ |
|
|
226 |
if ( isset($HTTP_GET_VARS['unwatch']) ) |
|
|
227 |
{ |
|
|
228 |
if ( $HTTP_GET_VARS['unwatch'] == 'topic' ) |
|
|
229 |
{ |
|
|
230 |
$is_watching_topic = 0; |
|
|
231 |
|
|
|
232 |
$sql_priority = (SQL_LAYER == "mysql") ? "LOW_PRIORITY" : ''; |
|
|
233 |
$sql = "DELETE $sql_priority FROM " . TOPICS_WATCH_TABLE . " |
|
|
234 |
WHERE topic_id = $topic_id |
|
|
235 |
AND user_id = " . $userdata['user_id']; |
|
|
236 |
if ( !($result = $db->sql_query($sql)) ) |
|
|
237 |
{ |
|
|
238 |
message_die(GENERAL_ERROR, "Could not delete topic watch information", '', __LINE__, __FILE__, $sql); |
|
|
239 |
} |
|
|
240 |
} |
|
|
241 |
|
|
|
242 |
$template->assign_vars(array( |
|
|
243 |
'META' => '<meta http-equiv="refresh" content="3;url=' . append_sid("viewtopic.$phpEx?" . POST_TOPIC_URL . "=$topic_id&start=$start") . '">') |
|
|
244 |
); |
|
|
245 |
|
|
|
246 |
$message = $lang['No_longer_watching'] . '<br /><br />' . sprintf($lang['Click_return_topic'], '<a href="' . append_sid("viewtopic.$phpEx?" . POST_TOPIC_URL . "=$topic_id&start=$start") . '">', '</a>'); |
|
|
247 |
message_die(GENERAL_MESSAGE, $message); |
|
|
248 |
} |
|
|
249 |
else |
|
|
250 |
{ |
|
|
251 |
$is_watching_topic = TRUE; |
|
|
252 |
|
|
|
253 |
if ( $row['notify_status'] ) |
|
|
254 |
{ |
|
|
255 |
$sql_priority = (SQL_LAYER == "mysql") ? "LOW_PRIORITY" : ''; |
|
|
256 |
$sql = "UPDATE $sql_priority " . TOPICS_WATCH_TABLE . " |
|
|
257 |
SET notify_status = 0 |
|
|
258 |
WHERE topic_id = $topic_id |
|
|
259 |
AND user_id = " . $userdata['user_id']; |
|
|
260 |
if ( !($result = $db->sql_query($sql)) ) |
|
|
261 |
{ |
|
|
262 |
message_die(GENERAL_ERROR, "Could not update topic watch information", '', __LINE__, __FILE__, $sql); |
|
|
263 |
} |
|
|
264 |
} |
|
|
265 |
} |
|
|
266 |
} |
|
|
267 |
else |
|
|
268 |
{ |
|
|
269 |
if ( isset($HTTP_GET_VARS['watch']) ) |
|
|
270 |
{ |
|
|
271 |
if ( $HTTP_GET_VARS['watch'] == 'topic' ) |
|
|
272 |
{ |
|
|
273 |
$is_watching_topic = TRUE; |
|
|
274 |
|
|
|
275 |
$sql_priority = (SQL_LAYER == "mysql") ? "LOW_PRIORITY" : ''; |
|
|
276 |
$sql = "INSERT $sql_priority INTO " . TOPICS_WATCH_TABLE . " (user_id, topic_id, notify_status) |
|
|
277 |
VALUES (" . $userdata['user_id'] . ", $topic_id, 0)"; |
|
|
278 |
if ( !($result = $db->sql_query($sql)) ) |
|
|
279 |
{ |
|
|
280 |
message_die(GENERAL_ERROR, "Could not insert topic watch information", '', __LINE__, __FILE__, $sql); |
|
|
281 |
} |
|
|
282 |
} |
|
|
283 |
|
|
|
284 |
$template->assign_vars(array( |
|
|
285 |
'META' => '<meta http-equiv="refresh" content="3;url=' . append_sid("viewtopic.$phpEx?" . POST_TOPIC_URL . "=$topic_id&start=$start") . '">') |
|
|
286 |
); |
|
|
287 |
|
|
|
288 |
$message = $lang['You_are_watching'] . '<br /><br />' . sprintf($lang['Click_return_topic'], '<a href="' . append_sid("viewtopic.$phpEx?" . POST_TOPIC_URL . "=$topic_id&start=$start") . '">', '</a>'); |
|
|
289 |
message_die(GENERAL_MESSAGE, $message); |
|
|
290 |
} |
|
|
291 |
else |
|
|
292 |
{ |
|
|
293 |
$is_watching_topic = 0; |
|
|
294 |
} |
|
|
295 |
} |
|
|
296 |
} |
|
|
297 |
else |
|
|
298 |
{ |
|
|
299 |
if ( isset($HTTP_GET_VARS['unwatch']) ) |
|
|
300 |
{ |
|
|
301 |
if ( $HTTP_GET_VARS['unwatch'] == 'topic' ) |
|
|
302 |
{ |
|
|
303 |
redirect(append_sid("login.$phpEx?redirect=viewtopic.$phpEx&" . POST_TOPIC_URL . "=$topic_id&unwatch=topic", true)); |
|
|
304 |
} |
|
|
305 |
} |
|
|
306 |
else |
|
|
307 |
{ |
|
|
308 |
$can_watch_topic = 0; |
|
|
309 |
$is_watching_topic = 0; |
|
|
310 |
} |
|
|
311 |
} |
|
|
312 |
|
|
|
313 |
// |
|
|
314 |
// Generate a 'Show posts in previous x days' select box. If the postdays var is POSTed |
|
|
315 |
// then get it's value, find the number of topics with dates newer than it (to properly |
|
|
316 |
// handle pagination) and alter the main query |
|
|
317 |
// |
|
|
318 |
$previous_days = array(0, 1, 7, 14, 30, 90, 180, 364); |
|
|
319 |
$previous_days_text = array($lang['All_Posts'], $lang['1_Day'], $lang['7_Days'], $lang['2_Weeks'], $lang['1_Month'], $lang['3_Months'], $lang['6_Months'], $lang['1_Year']); |
|
|
320 |
|
|
|
321 |
if( !empty($HTTP_POST_VARS['postdays']) || !empty($HTTP_GET_VARS['postdays']) ) |
|
|
322 |
{ |
|
|
323 |
$post_days = ( !empty($HTTP_POST_VARS['postdays']) ) ? intval($HTTP_POST_VARS['postdays']) : intval($HTTP_GET_VARS['postdays']); |
|
|
324 |
$min_post_time = time() - (intval($post_days) * 86400); |
|
|
325 |
|
|
|
326 |
$sql = "SELECT COUNT(p.post_id) AS num_posts |
|
|
327 |
FROM " . TOPICS_TABLE . " t, " . POSTS_TABLE . " p |
|
|
328 |
WHERE t.topic_id = $topic_id |
|
|
329 |
AND p.topic_id = t.topic_id |
|
|
330 |
AND p.post_time >= $min_post_time"; |
|
|
331 |
if ( !($result = $db->sql_query($sql)) ) |
|
|
332 |
{ |
|
|
333 |
message_die(GENERAL_ERROR, "Could not obtain limited topics count information", '', __LINE__, __FILE__, $sql); |
|
|
334 |
} |
|
|
335 |
|
|
|
336 |
$total_replies = ( $row = $db->sql_fetchrow($result) ) ? intval($row['num_posts']) : 0; |
|
|
337 |
|
|
|
338 |
$limit_posts_time = "AND p.post_time >= $min_post_time "; |
|
|
339 |
|
|
|
340 |
if ( !empty($HTTP_POST_VARS['postdays'])) |
|
|
341 |
{ |
|
|
342 |
$start = 0; |
|
|
343 |
} |
|
|
344 |
} |
|
|
345 |
else |
|
|
346 |
{ |
|
|
347 |
$total_replies = intval($forum_topic_data['topic_replies']) + 1; |
|
|
348 |
|
|
|
349 |
$limit_posts_time = ''; |
|
|
350 |
$post_days = 0; |
|
|
351 |
} |
|
|
352 |
|
|
|
353 |
$select_post_days = '<select name="postdays">'; |
|
|
354 |
for($i = 0; $i < count($previous_days); $i++) |
|
|
355 |
{ |
|
|
356 |
$selected = ($post_days == $previous_days[$i]) ? ' selected="selected"' : ''; |
|
|
357 |
$select_post_days .= '<option value="' . $previous_days[$i] . '"' . $selected . '>' . $previous_days_text[$i] . '</option>'; |
|
|
358 |
} |
|
|
359 |
$select_post_days .= '</select>'; |
|
|
360 |
|
|
|
361 |
// |
|
|
362 |
// Decide how to order the post display |
|
|
363 |
// |
|
|
364 |
if ( !empty($HTTP_POST_VARS['postorder']) || !empty($HTTP_GET_VARS['postorder']) ) |
|
|
365 |
{ |
|
|
366 |
$post_order = (!empty($HTTP_POST_VARS['postorder'])) ? htmlspecialchars($HTTP_POST_VARS['postorder']) : htmlspecialchars($HTTP_GET_VARS['postorder']); |
|
|
367 |
$post_time_order = ($post_order == "asc") ? "ASC" : "DESC"; |
|
|
368 |
} |
|
|
369 |
else |
|
|
370 |
{ |
|
|
371 |
$post_order = 'asc'; |
|
|
372 |
$post_time_order = 'ASC'; |
|
|
373 |
} |
|
|
374 |
|
|
|
375 |
$select_post_order = '<select name="postorder">'; |
|
|
376 |
if ( $post_time_order == 'ASC' ) |
|
|
377 |
{ |
|
|
378 |
$select_post_order .= '<option value="asc" selected="selected">' . $lang['Oldest_First'] . '</option><option value="desc">' . $lang['Newest_First'] . '</option>'; |
|
|
379 |
} |
|
|
380 |
else |
|
|
381 |
{ |
|
|
382 |
$select_post_order .= '<option value="asc">' . $lang['Oldest_First'] . '</option><option value="desc" selected="selected">' . $lang['Newest_First'] . '</option>'; |
|
|
383 |
} |
|
|
384 |
$select_post_order .= '</select>'; |
|
|
385 |
|
|
|
386 |
// |
|
|
387 |
// Go ahead and pull all data for this topic |
|
|
388 |
// |
|
|
389 |
$sql = "SELECT u.username, u.user_id, u.user_posts, u.user_from, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_regdate, u.user_msnm, u.user_viewemail, u.user_rank, u.user_sig, u.user_sig_bbcode_uid, u.user_avatar, u.user_avatar_type, u.user_allowavatar, u.user_allowsmile, p.*, pt.post_text, pt.post_subject, pt.bbcode_uid |
|
|
390 |
FROM " . POSTS_TABLE . " p, " . USERS_TABLE . " u, " . POSTS_TEXT_TABLE . " pt |
|
|
391 |
WHERE p.topic_id = $topic_id |
|
|
392 |
$limit_posts_time |
|
|
393 |
AND pt.post_id = p.post_id |
|
|
394 |
AND u.user_id = p.poster_id |
|
|
395 |
ORDER BY p.post_time $post_time_order |
|
|
396 |
LIMIT $start, ".$board_config['posts_per_page']; |
|
|
397 |
if ( !($result = $db->sql_query($sql)) ) |
|
|
398 |
{ |
|
|
399 |
message_die(GENERAL_ERROR, "Could not obtain post/user information.", '', __LINE__, __FILE__, $sql); |
|
|
400 |
} |
|
|
401 |
|
|
|
402 |
$postrow = array(); |
|
|
403 |
if ($row = $db->sql_fetchrow($result)) |
|
|
404 |
{ |
|
|
405 |
do |
|
|
406 |
{ |
|
|
407 |
$postrow[] = $row; |
|
|
408 |
} |
|
|
409 |
while ($row = $db->sql_fetchrow($result)); |
|
|
410 |
$db->sql_freeresult($result); |
|
|
411 |
|
|
|
412 |
$total_posts = count($postrow); |
|
|
413 |
} |
|
|
414 |
else |
|
|
415 |
{ |
|
|
416 |
include($phpbb_root_path . 'includes/functions_admin.' . $phpEx); |
|
|
417 |
sync('topic', $topic_id); |
|
|
418 |
|
|
|
419 |
message_die(GENERAL_MESSAGE, $lang['No_posts_topic']); |
|
|
420 |
} |
|
|
421 |
|
|
|
422 |
$resync = FALSE; |
|
|
423 |
if ($forum_topic_data['topic_replies'] + 1 < $start + count($postrow)) |
|
|
424 |
{ |
|
|
425 |
$resync = TRUE; |
|
|
426 |
} |
|
|
427 |
elseif ($start + $board_config['posts_per_page'] > $forum_topic_data['topic_replies']) |
|
|
428 |
{ |
|
|
429 |
$row_id = intval($forum_topic_data['topic_replies']) % intval($board_config['posts_per_page']); |
|
|
430 |
if ($postrow[$row_id]['post_id'] != $forum_topic_data['topic_last_post_id'] || $start + count($postrow) < $forum_topic_data['topic_replies']) |
|
|
431 |
{ |
|
|
432 |
$resync = TRUE; |
|
|
433 |
} |
|
|
434 |
} |
|
|
435 |
elseif (count($postrow) < $board_config['posts_per_page']) |
|
|
436 |
{ |
|
|
437 |
$resync = TRUE; |
|
|
438 |
} |
|
|
439 |
|
|
|
440 |
if ($resync) |
|
|
441 |
{ |
|
|
442 |
include($phpbb_root_path . 'includes/functions_admin.' . $phpEx); |
|
|
443 |
sync('topic', $topic_id); |
|
|
444 |
|
|
|
445 |
$result = $db->sql_query('SELECT COUNT(post_id) AS total FROM ' . POSTS_TABLE . ' WHERE topic_id = ' . $topic_id); |
|
|
446 |
$row = $db->sql_fetchrow($result); |
|
|
447 |
$total_replies = $row['total']; |
|
|
448 |
} |
|
|
449 |
|
|
|
450 |
$sql = "SELECT * |
|
|
451 |
FROM " . RANKS_TABLE . " |
|
|
452 |
ORDER BY rank_special, rank_min"; |
|
|
453 |
if ( !($result = $db->sql_query($sql)) ) |
|
|
454 |
{ |
|
|
455 |
message_die(GENERAL_ERROR, "Could not obtain ranks information.", '', __LINE__, __FILE__, $sql); |
|
|
456 |
} |
|
|
457 |
|
|
|
458 |
$ranksrow = array(); |
|
|
459 |
while ( $row = $db->sql_fetchrow($result) ) |
|
|
460 |
{ |
|
|
461 |
$ranksrow[] = $row; |
|
|
462 |
} |
|
|
463 |
$db->sql_freeresult($result); |
|
|
464 |
|
|
|
465 |
// |
|
|
466 |
// Define censored word matches |
|
|
467 |
// |
|
|
468 |
$orig_word = array(); |
|
|
469 |
$replacement_word = array(); |
|
|
470 |
obtain_word_list($orig_word, $replacement_word); |
|
|
471 |
|
|
|
472 |
// |
|
|
473 |
// Censor topic title |
|
|
474 |
// |
|
|
475 |
if ( count($orig_word) ) |
|
|
476 |
{ |
|
|
477 |
$topic_title = preg_replace($orig_word, $replacement_word, $topic_title); |
|
|
478 |
} |
|
|
479 |
|
|
|
480 |
// |
|
|
481 |
// Was a highlight request part of the URI? |
|
|
482 |
// |
|
|
483 |
$highlight_match = $highlight = ''; |
|
|
484 |
if (isset($HTTP_GET_VARS['highlight'])) |
|
|
485 |
{ |
|
|
486 |
// Split words and phrases |
|
|
487 |
$words = explode(' ', trim(htmlspecialchars($HTTP_GET_VARS['highlight']))); |
|
|
488 |
|
|
|
489 |
for($i = 0; $i < sizeof($words); $i++) |
|
|
490 |
{ |
|
|
491 |
if (trim($words[$i]) != '') |
|
|
492 |
{ |
|
|
493 |
$highlight_match .= (($highlight_match != '') ? '|' : '') . str_replace('*', '\w*', preg_quote($words[$i], '#')); |
|
|
494 |
} |
|
|
495 |
} |
|
|
496 |
unset($words); |
|
|
497 |
|
|
|
498 |
$highlight = urlencode($HTTP_GET_VARS['highlight']); |
|
|
499 |
$highlight_match = phpbb_rtrim($highlight_match, "\\"); |
|
|
500 |
} |
|
|
501 |
|
|
|
502 |
// |
|
|
503 |
// Post, reply and other URL generation for |
|
|
504 |
// templating vars |
|
|
505 |
// |
|
|
506 |
$new_topic_url = append_sid("posting.$phpEx?mode=newtopic&" . POST_FORUM_URL . "=$forum_id"); |
|
|
507 |
$reply_topic_url = append_sid("posting.$phpEx?mode=reply&" . POST_TOPIC_URL . "=$topic_id"); |
|
|
508 |
$view_forum_url = append_sid("viewforum.$phpEx?" . POST_FORUM_URL . "=$forum_id"); |
|
|
509 |
$view_prev_topic_url = append_sid("viewtopic.$phpEx?" . POST_TOPIC_URL . "=$topic_id&view=previous"); |
|
|
510 |
$view_next_topic_url = append_sid("viewtopic.$phpEx?" . POST_TOPIC_URL . "=$topic_id&view=next"); |
|
|
511 |
|
|
|
512 |
// |
|
|
513 |
// Mozilla navigation bar |
|
|
514 |
// |
|
|
515 |
$nav_links['prev'] = array( |
|
|
516 |
'url' => $view_prev_topic_url, |
|
|
517 |
'title' => $lang['View_previous_topic'] |
|
|
518 |
); |
|
|
519 |
$nav_links['next'] = array( |
|
|
520 |
'url' => $view_next_topic_url, |
|
|
521 |
'title' => $lang['View_next_topic'] |
|
|
522 |
); |
|
|
523 |
$nav_links['up'] = array( |
|
|
524 |
'url' => $view_forum_url, |
|
|
525 |
'title' => $forum_name |
|
|
526 |
); |
|
|
527 |
|
|
|
528 |
$reply_img = ( $forum_topic_data['forum_status'] == FORUM_LOCKED || $forum_topic_data['topic_status'] == TOPIC_LOCKED ) ? $images['reply_locked'] : $images['reply_new']; |
|
|
529 |
$reply_alt = ( $forum_topic_data['forum_status'] == FORUM_LOCKED || $forum_topic_data['topic_status'] == TOPIC_LOCKED ) ? $lang['Topic_locked'] : $lang['Reply_to_topic']; |
|
|
530 |
$post_img = ( $forum_topic_data['forum_status'] == FORUM_LOCKED ) ? $images['post_locked'] : $images['post_new']; |
|
|
531 |
$post_alt = ( $forum_topic_data['forum_status'] == FORUM_LOCKED ) ? $lang['Forum_locked'] : $lang['Post_new_topic']; |
|
|
532 |
|
|
|
533 |
// |
|
|
534 |
// Set a cookie for this topic |
|
|
535 |
// |
|
|
536 |
if ( $userdata['session_logged_in'] ) |
|
|
537 |
{ |
|
|
538 |
$tracking_topics = ( isset($HTTP_COOKIE_VARS[$board_config['cookie_name'] . '_t']) ) ? unserialize($HTTP_COOKIE_VARS[$board_config['cookie_name'] . '_t']) : array(); |
|
|
539 |
$tracking_forums = ( isset($HTTP_COOKIE_VARS[$board_config['cookie_name'] . '_f']) ) ? unserialize($HTTP_COOKIE_VARS[$board_config['cookie_name'] . '_f']) : array(); |
|
|
540 |
|
|
|
541 |
if ( !empty($tracking_topics[$topic_id]) && !empty($tracking_forums[$forum_id]) ) |
|
|
542 |
{ |
|
|
543 |
$topic_last_read = ( $tracking_topics[$topic_id] > $tracking_forums[$forum_id] ) ? $tracking_topics[$topic_id] : $tracking_forums[$forum_id]; |
|
|
544 |
} |
|
|
545 |
else if ( !empty($tracking_topics[$topic_id]) || !empty($tracking_forums[$forum_id]) ) |
|
|
546 |
{ |
|
|
547 |
$topic_last_read = ( !empty($tracking_topics[$topic_id]) ) ? $tracking_topics[$topic_id] : $tracking_forums[$forum_id]; |
|
|
548 |
} |
|
|
549 |
else |
|
|
550 |
{ |
|
|
551 |
$topic_last_read = $userdata['user_lastvisit']; |
|
|
552 |
} |
|
|
553 |
|
|
|
554 |
if ( count($tracking_topics) >= 150 && empty($tracking_topics[$topic_id]) ) |
|
|
555 |
{ |
|
|
556 |
asort($tracking_topics); |
|
|
557 |
unset($tracking_topics[key($tracking_topics)]); |
|
|
558 |
} |
|
|
559 |
|
|
|
560 |
$tracking_topics[$topic_id] = time(); |
|
|
561 |
|
|
|
562 |
setcookie($board_config['cookie_name'] . '_t', serialize($tracking_topics), 0, $board_config['cookie_path'], $board_config['cookie_domain'], $board_config['cookie_secure']); |
|
|
563 |
} |
|
|
564 |
|
|
|
565 |
// |
|
|
566 |
// Load templates |
|
|
567 |
// |
|
|
568 |
$template->set_filenames(array( |
|
|
569 |
'body' => 'viewtopic_body.tpl') |
|
|
570 |
); |
|
|
571 |
make_jumpbox('viewforum.'.$phpEx, $forum_id); |
|
|
572 |
|
|
|
573 |
// |
|
|
574 |
// Output page header |
|
|
575 |
// |
|
|
576 |
$page_title = $lang['View_topic'] .' - ' . $topic_title; |
|
|
577 |
include($phpbb_root_path . 'includes/page_header.'.$phpEx); |
|
|
578 |
|
|
|
579 |
// |
|
|
580 |
// User authorisation levels output |
|
|
581 |
// |
|
|
582 |
$s_auth_can = ( ( $is_auth['auth_post'] ) ? $lang['Rules_post_can'] : $lang['Rules_post_cannot'] ) . '<br />'; |
|
|
583 |
$s_auth_can .= ( ( $is_auth['auth_reply'] ) ? $lang['Rules_reply_can'] : $lang['Rules_reply_cannot'] ) . '<br />'; |
|
|
584 |
$s_auth_can .= ( ( $is_auth['auth_edit'] ) ? $lang['Rules_edit_can'] : $lang['Rules_edit_cannot'] ) . '<br />'; |
|
|
585 |
$s_auth_can .= ( ( $is_auth['auth_delete'] ) ? $lang['Rules_delete_can'] : $lang['Rules_delete_cannot'] ) . '<br />'; |
|
|
586 |
$s_auth_can .= ( ( $is_auth['auth_vote'] ) ? $lang['Rules_vote_can'] : $lang['Rules_vote_cannot'] ) . '<br />'; |
|
|
587 |
|
|
|
588 |
$topic_mod = ''; |
|
|
589 |
|
|
|
590 |
if ( $is_auth['auth_mod'] ) |
|
|
591 |
{ |
|
|
592 |
$s_auth_can .= sprintf($lang['Rules_moderate'], "<a href=\"modcp.$phpEx?" . POST_FORUM_URL . "=$forum_id&sid=" . $userdata['session_id'] . '">', '</a>'); |
|
|
593 |
|
|
|
594 |
$topic_mod .= "<a href=\"modcp.$phpEx?" . POST_TOPIC_URL . "=$topic_id&mode=delete&sid=" . $userdata['session_id'] . '"><img src="' . $images['topic_mod_delete'] . '" alt="' . $lang['Delete_topic'] . '" title="' . $lang['Delete_topic'] . '" border="0" /></a> '; |
|
|
595 |
|
|
|
596 |
$topic_mod .= "<a href=\"modcp.$phpEx?" . POST_TOPIC_URL . "=$topic_id&mode=move&sid=" . $userdata['session_id'] . '"><img src="' . $images['topic_mod_move'] . '" alt="' . $lang['Move_topic'] . '" title="' . $lang['Move_topic'] . '" border="0" /></a> '; |
|
|
597 |
|
|
|
598 |
$topic_mod .= ( $forum_topic_data['topic_status'] == TOPIC_UNLOCKED ) ? "<a href=\"modcp.$phpEx?" . POST_TOPIC_URL . "=$topic_id&mode=lock&sid=" . $userdata['session_id'] . '"><img src="' . $images['topic_mod_lock'] . '" alt="' . $lang['Lock_topic'] . '" title="' . $lang['Lock_topic'] . '" border="0" /></a> ' : "<a href=\"modcp.$phpEx?" . POST_TOPIC_URL . "=$topic_id&mode=unlock&sid=" . $userdata['session_id'] . '"><img src="' . $images['topic_mod_unlock'] . '" alt="' . $lang['Unlock_topic'] . '" title="' . $lang['Unlock_topic'] . '" border="0" /></a> '; |
|
|
599 |
|
|
|
600 |
$topic_mod .= "<a href=\"modcp.$phpEx?" . POST_TOPIC_URL . "=$topic_id&mode=split&sid=" . $userdata['session_id'] . '"><img src="' . $images['topic_mod_split'] . '" alt="' . $lang['Split_topic'] . '" title="' . $lang['Split_topic'] . '" border="0" /></a> '; |
|
|
601 |
} |
|
|
602 |
|
|
|
603 |
// |
|
|
604 |
// Topic watch information |
|
|
605 |
// |
|
|
606 |
$s_watching_topic = ''; |
|
|
607 |
if ( $can_watch_topic ) |
|
|
608 |
{ |
|
|
609 |
if ( $is_watching_topic ) |
|
|
610 |
{ |
|
|
611 |
$s_watching_topic = "<a href=\"viewtopic.$phpEx?" . POST_TOPIC_URL . "=$topic_id&unwatch=topic&start=$start&sid=" . $userdata['session_id'] . '">' . $lang['Stop_watching_topic'] . '</a>'; |
|
|
612 |
$s_watching_topic_img = ( isset($images['topic_un_watch']) ) ? "<a href=\"viewtopic.$phpEx?" . POST_TOPIC_URL . "=$topic_id&unwatch=topic&start=$start&sid=" . $userdata['session_id'] . '"><img src="' . $images['topic_un_watch'] . '" alt="' . $lang['Stop_watching_topic'] . '" title="' . $lang['Stop_watching_topic'] . '" border="0"></a>' : ''; |
|
|
613 |
} |
|
|
614 |
else |
|
|
615 |
{ |
|
|
616 |
$s_watching_topic = "<a href=\"viewtopic.$phpEx?" . POST_TOPIC_URL . "=$topic_id&watch=topic&start=$start&sid=" . $userdata['session_id'] . '">' . $lang['Start_watching_topic'] . '</a>'; |
|
|
617 |
$s_watching_topic_img = ( isset($images['Topic_watch']) ) ? "<a href=\"viewtopic.$phpEx?" . POST_TOPIC_URL . "=$topic_id&watch=topic&start=$start&sid=" . $userdata['session_id'] . '"><img src="' . $images['Topic_watch'] . '" alt="' . $lang['Start_watching_topic'] . '" title="' . $lang['Start_watching_topic'] . '" border="0"></a>' : ''; |
|
|
618 |
} |
|
|
619 |
} |
|
|
620 |
|
|
|
621 |
// |
|
|
622 |
// If we've got a hightlight set pass it on to pagination, |
|
|
623 |
// I get annoyed when I lose my highlight after the first page. |
|
|
624 |
// |
|
|
625 |
$pagination = ( $highlight != '' ) ? generate_pagination("viewtopic.$phpEx?" . POST_TOPIC_URL . "=$topic_id&postdays=$post_days&postorder=$post_order&highlight=$highlight", $total_replies, $board_config['posts_per_page'], $start) : generate_pagination("viewtopic.$phpEx?" . POST_TOPIC_URL . "=$topic_id&postdays=$post_days&postorder=$post_order", $total_replies, $board_config['posts_per_page'], $start); |
|
|
626 |
|
|
|
627 |
// |
|
|
628 |
// Send vars to template |
|
|
629 |
// |
|
|
630 |
$template->assign_vars(array( |
|
|
631 |
'FORUM_ID' => $forum_id, |
|
|
632 |
'FORUM_NAME' => $forum_name, |
|
|
633 |
'TOPIC_ID' => $topic_id, |
|
|
634 |
'TOPIC_TITLE' => $topic_title, |
|
|
635 |
'PAGINATION' => $pagination, |
|
|
636 |
'PAGE_NUMBER' => sprintf($lang['Page_of'], ( floor( $start / intval($board_config['posts_per_page']) ) + 1 ), ceil( $total_replies / intval($board_config['posts_per_page']) )), |
|
|
637 |
|
|
|
638 |
'POST_IMG' => $post_img, |
|
|
639 |
'REPLY_IMG' => $reply_img, |
|
|
640 |
|
|
|
641 |
'L_AUTHOR' => $lang['Author'], |
|
|
642 |
'L_MESSAGE' => $lang['Message'], |
|
|
643 |
'L_POSTED' => $lang['Posted'], |
|
|
644 |
'L_POST_SUBJECT' => $lang['Post_subject'], |
|
|
645 |
'L_VIEW_NEXT_TOPIC' => $lang['View_next_topic'], |
|
|
646 |
'L_VIEW_PREVIOUS_TOPIC' => $lang['View_previous_topic'], |
|
|
647 |
'L_POST_NEW_TOPIC' => $post_alt, |
|
|
648 |
'L_POST_REPLY_TOPIC' => $reply_alt, |
|
|
649 |
'L_BACK_TO_TOP' => $lang['Back_to_top'], |
|
|
650 |
'L_DISPLAY_POSTS' => $lang['Display_posts'], |
|
|
651 |
'L_LOCK_TOPIC' => $lang['Lock_topic'], |
|
|
652 |
'L_UNLOCK_TOPIC' => $lang['Unlock_topic'], |
|
|
653 |
'L_MOVE_TOPIC' => $lang['Move_topic'], |
|
|
654 |
'L_SPLIT_TOPIC' => $lang['Split_topic'], |
|
|
655 |
'L_DELETE_TOPIC' => $lang['Delete_topic'], |
|
|
656 |
'L_GOTO_PAGE' => $lang['Goto_page'], |
|
|
657 |
|
|
|
658 |
'S_TOPIC_LINK' => POST_TOPIC_URL, |
|
|
659 |
'S_SELECT_POST_DAYS' => $select_post_days, |
|
|
660 |
'S_SELECT_POST_ORDER' => $select_post_order, |
|
|
661 |
'S_POST_DAYS_ACTION' => append_sid("viewtopic.$phpEx?" . POST_TOPIC_URL . '=' . $topic_id . "&start=$start"), |
|
|
662 |
'S_AUTH_LIST' => $s_auth_can, |
|
|
663 |
'S_TOPIC_ADMIN' => $topic_mod, |
|
|
664 |
'S_WATCH_TOPIC' => $s_watching_topic, |
|
|
665 |
'S_WATCH_TOPIC_IMG' => $s_watching_topic_img, |
|
|
666 |
|
|
|
667 |
'U_VIEW_TOPIC' => append_sid("viewtopic.$phpEx?" . POST_TOPIC_URL . "=$topic_id&start=$start&postdays=$post_days&postorder=$post_order&highlight=$highlight"), |
|
|
668 |
'U_VIEW_FORUM' => $view_forum_url, |
|
|
669 |
'U_VIEW_OLDER_TOPIC' => $view_prev_topic_url, |
|
|
670 |
'U_VIEW_NEWER_TOPIC' => $view_next_topic_url, |
|
|
671 |
'U_POST_NEW_TOPIC' => $new_topic_url, |
|
|
672 |
'U_POST_REPLY_TOPIC' => $reply_topic_url) |
|
|
673 |
); |
|
|
674 |
|
|
|
675 |
// |
|
|
676 |
// Does this topic contain a poll? |
|
|
677 |
// |
|
|
678 |
if ( !empty($forum_topic_data['topic_vote']) ) |
|
|
679 |
{ |
|
|
680 |
$s_hidden_fields = ''; |
|
|
681 |
|
|
|
682 |
$sql = "SELECT vd.vote_id, vd.vote_text, vd.vote_start, vd.vote_length, vr.vote_option_id, vr.vote_option_text, vr.vote_result |
|
|
683 |
FROM " . VOTE_DESC_TABLE . " vd, " . VOTE_RESULTS_TABLE . " vr |
|
|
684 |
WHERE vd.topic_id = $topic_id |
|
|
685 |
AND vr.vote_id = vd.vote_id |
|
|
686 |
ORDER BY vr.vote_option_id ASC"; |
|
|
687 |
if ( !($result = $db->sql_query($sql)) ) |
|
|
688 |
{ |
|
|
689 |
message_die(GENERAL_ERROR, "Could not obtain vote data for this topic", '', __LINE__, __FILE__, $sql); |
|
|
690 |
} |
|
|
691 |
|
|
|
692 |
if ( $vote_info = $db->sql_fetchrowset($result) ) |
|
|
693 |
{ |
|
|
694 |
$db->sql_freeresult($result); |
|
|
695 |
$vote_options = count($vote_info); |
|
|
696 |
|
|
|
697 |
$vote_id = $vote_info[0]['vote_id']; |
|
|
698 |
$vote_title = $vote_info[0]['vote_text']; |
|
|
699 |
|
|
|
700 |
$sql = "SELECT vote_id |
|
|
701 |
FROM " . VOTE_USERS_TABLE . " |
|
|
702 |
WHERE vote_id = $vote_id |
|
|
703 |
AND vote_user_id = " . intval($userdata['user_id']); |
|
|
704 |
if ( !($result = $db->sql_query($sql)) ) |
|
|
705 |
{ |
|
|
706 |
message_die(GENERAL_ERROR, "Could not obtain user vote data for this topic", '', __LINE__, __FILE__, $sql); |
|
|
707 |
} |
|
|
708 |
|
|
|
709 |
$user_voted = ( $row = $db->sql_fetchrow($result) ) ? TRUE : 0; |
|
|
710 |
$db->sql_freeresult($result); |
|
|
711 |
|
|
|
712 |
if ( isset($HTTP_GET_VARS['vote']) || isset($HTTP_POST_VARS['vote']) ) |
|
|
713 |
{ |
|
|
714 |
$view_result = ( ( ( isset($HTTP_GET_VARS['vote']) ) ? $HTTP_GET_VARS['vote'] : $HTTP_POST_VARS['vote'] ) == 'viewresult' ) ? TRUE : 0; |
|
|
715 |
} |
|
|
716 |
else |
|
|
717 |
{ |
|
|
718 |
$view_result = 0; |
|
|
719 |
} |
|
|
720 |
|
|
|
721 |
$poll_expired = ( $vote_info[0]['vote_length'] ) ? ( ( $vote_info[0]['vote_start'] + $vote_info[0]['vote_length'] < time() ) ? TRUE : 0 ) : 0; |
|
|
722 |
|
|
|
723 |
if ( $user_voted || $view_result || $poll_expired || !$is_auth['auth_vote'] || $forum_topic_data['topic_status'] == TOPIC_LOCKED ) |
|
|
724 |
{ |
|
|
725 |
$template->set_filenames(array( |
|
|
726 |
'pollbox' => 'viewtopic_poll_result.tpl') |
|
|
727 |
); |
|
|
728 |
|
|
|
729 |
$vote_results_sum = 0; |
|
|
730 |
|
|
|
731 |
for($i = 0; $i < $vote_options; $i++) |
|
|
732 |
{ |
|
|
733 |
$vote_results_sum += $vote_info[$i]['vote_result']; |
|
|
734 |
} |
|
|
735 |
|
|
|
736 |
$vote_graphic = 0; |
|
|
737 |
$vote_graphic_max = count($images['voting_graphic']); |
|
|
738 |
|
|
|
739 |
for($i = 0; $i < $vote_options; $i++) |
|
|
740 |
{ |
|
|
741 |
$vote_percent = ( $vote_results_sum > 0 ) ? $vote_info[$i]['vote_result'] / $vote_results_sum : 0; |
|
|
742 |
$vote_graphic_length = round($vote_percent * $board_config['vote_graphic_length']); |
|
|
743 |
|
|
|
744 |
$vote_graphic_img = $images['voting_graphic'][$vote_graphic]; |
|
|
745 |
$vote_graphic = ($vote_graphic < $vote_graphic_max - 1) ? $vote_graphic + 1 : 0; |
|
|
746 |
|
|
|
747 |
if ( count($orig_word) ) |
|
|
748 |
{ |
|
|
749 |
$vote_info[$i]['vote_option_text'] = preg_replace($orig_word, $replacement_word, $vote_info[$i]['vote_option_text']); |
|
|
750 |
} |
|
|
751 |
|
|
|
752 |
$template->assign_block_vars("poll_option", array( |
|
|
753 |
'POLL_OPTION_CAPTION' => $vote_info[$i]['vote_option_text'], |
|
|
754 |
'POLL_OPTION_RESULT' => $vote_info[$i]['vote_result'], |
|
|
755 |
'POLL_OPTION_PERCENT' => sprintf("%.1d%%", ($vote_percent * 100)), |
|
|
756 |
|
|
|
757 |
'POLL_OPTION_IMG' => $vote_graphic_img, |
|
|
758 |
'POLL_OPTION_IMG_WIDTH' => $vote_graphic_length) |
|
|
759 |
); |
|
|
760 |
} |
|
|
761 |
|
|
|
762 |
$template->assign_vars(array( |
|
|
763 |
'L_TOTAL_VOTES' => $lang['Total_votes'], |
|
|
764 |
'TOTAL_VOTES' => $vote_results_sum) |
|
|
765 |
); |
|
|
766 |
|
|
|
767 |
} |
|
|
768 |
else |
|
|
769 |
{ |
|
|
770 |
$template->set_filenames(array( |
|
|
771 |
'pollbox' => 'viewtopic_poll_ballot.tpl') |
|
|
772 |
); |
|
|
773 |
|
|
|
774 |
for($i = 0; $i < $vote_options; $i++) |
|
|
775 |
{ |
|
|
776 |
if ( count($orig_word) ) |
|
|
777 |
{ |
|
|
778 |
$vote_info[$i]['vote_option_text'] = preg_replace($orig_word, $replacement_word, $vote_info[$i]['vote_option_text']); |
|
|
779 |
} |
|
|
780 |
|
|
|
781 |
$template->assign_block_vars("poll_option", array( |
|
|
782 |
'POLL_OPTION_ID' => $vote_info[$i]['vote_option_id'], |
|
|
783 |
'POLL_OPTION_CAPTION' => $vote_info[$i]['vote_option_text']) |
|
|
784 |
); |
|
|
785 |
} |
|
|
786 |
|
|
|
787 |
$template->assign_vars(array( |
|
|
788 |
'L_SUBMIT_VOTE' => $lang['Submit_vote'], |
|
|
789 |
'L_VIEW_RESULTS' => $lang['View_results'], |
|
|
790 |
|
|
|
791 |
'U_VIEW_RESULTS' => append_sid("viewtopic.$phpEx?" . POST_TOPIC_URL . "=$topic_id&postdays=$post_days&postorder=$post_order&vote=viewresult")) |
|
|
792 |
); |
|
|
793 |
|
|
|
794 |
$s_hidden_fields = '<input type="hidden" name="topic_id" value="' . $topic_id . '" /><input type="hidden" name="mode" value="vote" />'; |
|
|
795 |
} |
|
|
796 |
|
|
|
797 |
if ( count($orig_word) ) |
|
|
798 |
{ |
|
|
799 |
$vote_title = preg_replace($orig_word, $replacement_word, $vote_title); |
|
|
800 |
} |
|
|
801 |
|
|
|
802 |
$s_hidden_fields .= '<input type="hidden" name="sid" value="' . $userdata['session_id'] . '" />'; |
|
|
803 |
|
|
|
804 |
$template->assign_vars(array( |
|
|
805 |
'POLL_QUESTION' => $vote_title, |
|
|
806 |
|
|
|
807 |
'S_HIDDEN_FIELDS' => $s_hidden_fields, |
|
|
808 |
'S_POLL_ACTION' => append_sid("posting.$phpEx?mode=vote&" . POST_TOPIC_URL . "=$topic_id")) |
|
|
809 |
); |
|
|
810 |
|
|
|
811 |
$template->assign_var_from_handle('POLL_DISPLAY', 'pollbox'); |
|
|
812 |
} |
|
|
813 |
} |
|
|
814 |
|
|
|
815 |
// |
|
|
816 |
// Update the topic view counter |
|
|
817 |
// |
|
|
818 |
$sql = "UPDATE " . TOPICS_TABLE . " |
|
|
819 |
SET topic_views = topic_views + 1 |
|
|
820 |
WHERE topic_id = $topic_id"; |
|
|
821 |
if ( !$db->sql_query($sql) ) |
|
|
822 |
{ |
|
|
823 |
message_die(GENERAL_ERROR, "Could not update topic views.", '', __LINE__, __FILE__, $sql); |
|
|
824 |
} |
|
|
825 |
|
|
|
826 |
// |
|
|
827 |
// Okay, let's do the loop, yeah come on baby let's do the loop |
|
|
828 |
// and it goes like this ... |
|
|
829 |
// |
|
|
830 |
for($i = 0; $i < $total_posts; $i++) |
|
|
831 |
{ |
|
|
832 |
$poster_id = $postrow[$i]['user_id']; |
|
|
833 |
$poster = ( $poster_id == ANONYMOUS ) ? $lang['Guest'] : $postrow[$i]['username']; |
|
|
834 |
|
|
|
835 |
$post_date = create_date($board_config['default_dateformat'], $postrow[$i]['post_time'], $board_config['board_timezone']); |
|
|
836 |
|
|
|
837 |
$poster_posts = ( $postrow[$i]['user_id'] != ANONYMOUS ) ? $lang['Posts'] . ': ' . $postrow[$i]['user_posts'] : ''; |
|
|
838 |
|
|
|
839 |
$poster_from = ( $postrow[$i]['user_from'] && $postrow[$i]['user_id'] != ANONYMOUS ) ? $lang['Location'] . ': ' . $postrow[$i]['user_from'] : ''; |
|
|
840 |
|
|
|
841 |
$poster_joined = ( $postrow[$i]['user_id'] != ANONYMOUS ) ? $lang['Joined'] . ': ' . create_date($lang['DATE_FORMAT'], $postrow[$i]['user_regdate'], $board_config['board_timezone']) : ''; |
|
|
842 |
|
|
|
843 |
$poster_avatar = ''; |
|
|
844 |
if ( $postrow[$i]['user_avatar_type'] && $poster_id != ANONYMOUS && $postrow[$i]['user_allowavatar'] ) |
|
|
845 |
{ |
|
|
846 |
switch( $postrow[$i]['user_avatar_type'] ) |
|
|
847 |
{ |
|
|
848 |
case USER_AVATAR_UPLOAD: |
|
|
849 |
$poster_avatar = ( $board_config['allow_avatar_upload'] ) ? '<img src="' . $board_config['avatar_path'] . '/' . $postrow[$i]['user_avatar'] . '" alt="" border="0" />' : ''; |
|
|
850 |
break; |
|
|
851 |
case USER_AVATAR_REMOTE: |
|
|
852 |
$poster_avatar = ( $board_config['allow_avatar_remote'] ) ? '<img src="' . $postrow[$i]['user_avatar'] . '" alt="" border="0" />' : ''; |
|
|
853 |
break; |
|
|
854 |
case USER_AVATAR_GALLERY: |
|
|
855 |
$poster_avatar = ( $board_config['allow_avatar_local'] ) ? '<img src="' . $board_config['avatar_gallery_path'] . '/' . $postrow[$i]['user_avatar'] . '" alt="" border="0" />' : ''; |
|
|
856 |
break; |
|
|
857 |
} |
|
|
858 |
} |
|
|
859 |
|
|
|
860 |
// |
|
|
861 |
// Define the little post icon |
|
|
862 |
// |
|
|
863 |
if ( $userdata['session_logged_in'] && $postrow[$i]['post_time'] > $userdata['user_lastvisit'] && $postrow[$i]['post_time'] > $topic_last_read ) |
|
|
864 |
{ |
|
|
865 |
$mini_post_img = $images['icon_minipost_new']; |
|
|
866 |
$mini_post_alt = $lang['New_post']; |
|
|
867 |
} |
|
|
868 |
else |
|
|
869 |
{ |
|
|
870 |
$mini_post_img = $images['icon_minipost']; |
|
|
871 |
$mini_post_alt = $lang['Post']; |
|
|
872 |
} |
|
|
873 |
|
|
|
874 |
$mini_post_url = append_sid("viewtopic.$phpEx?" . POST_POST_URL . '=' . $postrow[$i]['post_id']) . '#' . $postrow[$i]['post_id']; |
|
|
875 |
|
|
|
876 |
// |
|
|
877 |
// Generate ranks, set them to empty string initially. |
|
|
878 |
// |
|
|
879 |
$poster_rank = ''; |
|
|
880 |
$rank_image = ''; |
|
|
881 |
if ( $postrow[$i]['user_id'] == ANONYMOUS ) |
|
|
882 |
{ |
|
|
883 |
} |
|
|
884 |
else if ( $postrow[$i]['user_rank'] ) |
|
|
885 |
{ |
|
|
886 |
for($j = 0; $j < count($ranksrow); $j++) |
|
|
887 |
{ |
|
|
888 |
if ( $postrow[$i]['user_rank'] == $ranksrow[$j]['rank_id'] && $ranksrow[$j]['rank_special'] ) |
|
|
889 |
{ |
|
|
890 |
$poster_rank = $ranksrow[$j]['rank_title']; |
|
|
891 |
$rank_image = ( $ranksrow[$j]['rank_image'] ) ? '<img src="' . $ranksrow[$j]['rank_image'] . '" alt="' . $poster_rank . '" title="' . $poster_rank . '" border="0" /><br />' : ''; |
|
|
892 |
} |
|
|
893 |
} |
|
|
894 |
} |
|
|
895 |
else |
|
|
896 |
{ |
|
|
897 |
for($j = 0; $j < count($ranksrow); $j++) |
|
|
898 |
{ |
|
|
899 |
if ( $postrow[$i]['user_posts'] >= $ranksrow[$j]['rank_min'] && !$ranksrow[$j]['rank_special'] ) |
|
|
900 |
{ |
|
|
901 |
$poster_rank = $ranksrow[$j]['rank_title']; |
|
|
902 |
$rank_image = ( $ranksrow[$j]['rank_image'] ) ? '<img src="' . $ranksrow[$j]['rank_image'] . '" alt="' . $poster_rank . '" title="' . $poster_rank . '" border="0" /><br />' : ''; |
|
|
903 |
} |
|
|
904 |
} |
|
|
905 |
} |
|
|
906 |
|
|
|
907 |
// |
|
|
908 |
// Handle anon users posting with usernames |
|
|
909 |
// |
|
|
910 |
if ( $poster_id == ANONYMOUS && $postrow[$i]['post_username'] != '' ) |
|
|
911 |
{ |
|
|
912 |
$poster = $postrow[$i]['post_username']; |
|
|
913 |
$poster_rank = $lang['Guest']; |
|
|
914 |
} |
|
|
915 |
|
|
|
916 |
$temp_url = ''; |
|
|
917 |
|
|
|
918 |
if ( $poster_id != ANONYMOUS ) |
|
|
919 |
{ |
|
|
920 |
$temp_url = append_sid("profile.$phpEx?mode=viewprofile&" . POST_USERS_URL . "=$poster_id"); |
|
|
921 |
$profile_img = '<a href="' . $temp_url . '"><img src="' . $images['icon_profile'] . '" alt="' . $lang['Read_profile'] . '" title="' . $lang['Read_profile'] . '" border="0" /></a>'; |
|
|
922 |
$profile = '<a href="' . $temp_url . '">' . $lang['Read_profile'] . '</a>'; |
|
|
923 |
|
|
|
924 |
$temp_url = append_sid("privmsg.$phpEx?mode=post&" . POST_USERS_URL . "=$poster_id"); |
|
|
925 |
$pm_img = '<a href="' . $temp_url . '"><img src="' . $images['icon_pm'] . '" alt="' . $lang['Send_private_message'] . '" title="' . $lang['Send_private_message'] . '" border="0" /></a>'; |
|
|
926 |
$pm = '<a href="' . $temp_url . '">' . $lang['Send_private_message'] . '</a>'; |
|
|
927 |
|
|
|
928 |
if ( !empty($postrow[$i]['user_viewemail']) || $is_auth['auth_mod'] ) |
|
|
929 |
{ |
|
|
930 |
$email_uri = ( $board_config['board_email_form'] ) ? append_sid("profile.$phpEx?mode=email&" . POST_USERS_URL .'=' . $poster_id) : 'mailto:' . $postrow[$i]['user_email']; |
|
|
931 |
|
|
|
932 |
$email_img = '<a href="' . $email_uri . '"><img src="' . $images['icon_email'] . '" alt="' . $lang['Send_email'] . '" title="' . $lang['Send_email'] . '" border="0" /></a>'; |
|
|
933 |
$email = '<a href="' . $email_uri . '">' . $lang['Send_email'] . '</a>'; |
|
|
934 |
} |
|
|
935 |
else |
|
|
936 |
{ |
|
|
937 |
$email_img = ''; |
|
|
938 |
$email = ''; |
|
|
939 |
} |
|
|
940 |
|
|
|
941 |
$www_img = ( $postrow[$i]['user_website'] ) ? '<a href="' . $postrow[$i]['user_website'] . '" target="_userwww"><img src="' . $images['icon_www'] . '" alt="' . $lang['Visit_website'] . '" title="' . $lang['Visit_website'] . '" border="0" /></a>' : ''; |
|
|
942 |
$www = ( $postrow[$i]['user_website'] ) ? '<a href="' . $postrow[$i]['user_website'] . '" target="_userwww">' . $lang['Visit_website'] . '</a>' : ''; |
|
|
943 |
|
|
|
944 |
if ( !empty($postrow[$i]['user_icq']) ) |
|
|
945 |
{ |
|
|
946 |
$icq_status_img = '<a href="http://wwp.icq.com/' . $postrow[$i]['user_icq'] . '#pager"><img src="http://web.icq.com/whitepages/online?icq=' . $postrow[$i]['user_icq'] . '&img=5" width="18" height="18" border="0" /></a>'; |
|
|
947 |
$icq_img = '<a href="http://wwp.icq.com/scripts/search.dll?to=' . $postrow[$i]['user_icq'] . '"><img src="' . $images['icon_icq'] . '" alt="' . $lang['ICQ'] . '" title="' . $lang['ICQ'] . '" border="0" /></a>'; |
|
|
948 |
$icq = '<a href="http://wwp.icq.com/scripts/search.dll?to=' . $postrow[$i]['user_icq'] . '">' . $lang['ICQ'] . '</a>'; |
|
|
949 |
} |
|
|
950 |
else |
|
|
951 |
{ |
|
|
952 |
$icq_status_img = ''; |
|
|
953 |
$icq_img = ''; |
|
|
954 |
$icq = ''; |
|
|
955 |
} |
|
|
956 |
|
|
|
957 |
$aim_img = ( $postrow[$i]['user_aim'] ) ? '<a href="aim:goim?screenname=' . $postrow[$i]['user_aim'] . '&message=Hello+Are+you+there?"><img src="' . $images['icon_aim'] . '" alt="' . $lang['AIM'] . '" title="' . $lang['AIM'] . '" border="0" /></a>' : ''; |
|
|
958 |
$aim = ( $postrow[$i]['user_aim'] ) ? '<a href="aim:goim?screenname=' . $postrow[$i]['user_aim'] . '&message=Hello+Are+you+there?">' . $lang['AIM'] . '</a>' : ''; |
|
|
959 |
|
|
|
960 |
$temp_url = append_sid("profile.$phpEx?mode=viewprofile&" . POST_USERS_URL . "=$poster_id"); |
|
|
961 |
$msn_img = ( $postrow[$i]['user_msnm'] ) ? '<a href="' . $temp_url . '"><img src="' . $images['icon_msnm'] . '" alt="' . $lang['MSNM'] . '" title="' . $lang['MSNM'] . '" border="0" /></a>' : ''; |
|
|
962 |
$msn = ( $postrow[$i]['user_msnm'] ) ? '<a href="' . $temp_url . '">' . $lang['MSNM'] . '</a>' : ''; |
|
|
963 |
|
|
|
964 |
$yim_img = ( $postrow[$i]['user_yim'] ) ? '<a href="http://edit.yahoo.com/config/send_webmesg?.target=' . $postrow[$i]['user_yim'] . '&.src=pg"><img src="' . $images['icon_yim'] . '" alt="' . $lang['YIM'] . '" title="' . $lang['YIM'] . '" border="0" /></a>' : ''; |
|
|
965 |
$yim = ( $postrow[$i]['user_yim'] ) ? '<a href="http://edit.yahoo.com/config/send_webmesg?.target=' . $postrow[$i]['user_yim'] . '&.src=pg">' . $lang['YIM'] . '</a>' : ''; |
|
|
966 |
} |
|
|
967 |
else |
|
|
968 |
{ |
|
|
969 |
$profile_img = ''; |
|
|
970 |
$profile = ''; |
|
|
971 |
$pm_img = ''; |
|
|
972 |
$pm = ''; |
|
|
973 |
$email_img = ''; |
|
|
974 |
$email = ''; |
|
|
975 |
$www_img = ''; |
|
|
976 |
$www = ''; |
|
|
977 |
$icq_status_img = ''; |
|
|
978 |
$icq_img = ''; |
|
|
979 |
$icq = ''; |
|
|
980 |
$aim_img = ''; |
|
|
981 |
$aim = ''; |
|
|
982 |
$msn_img = ''; |
|
|
983 |
$msn = ''; |
|
|
984 |
$yim_img = ''; |
|
|
985 |
$yim = ''; |
|
|
986 |
} |
|
|
987 |
|
|
|
988 |
$temp_url = append_sid("posting.$phpEx?mode=quote&" . POST_POST_URL . "=" . $postrow[$i]['post_id']); |
|
|
989 |
$quote_img = '<a href="' . $temp_url . '"><img src="' . $images['icon_quote'] . '" alt="' . $lang['Reply_with_quote'] . '" title="' . $lang['Reply_with_quote'] . '" border="0" /></a>'; |
|
|
990 |
$quote = '<a href="' . $temp_url . '">' . $lang['Reply_with_quote'] . '</a>'; |
|
|
991 |
|
|
|
992 |
$temp_url = append_sid("search.$phpEx?search_author=" . urlencode($postrow[$i]['username']) . "&showresults=posts"); |
|
|
993 |
$search_img = '<a href="' . $temp_url . '"><img src="' . $images['icon_search'] . '" alt="' . sprintf($lang['Search_user_posts'], $postrow[$i]['username']) . '" title="' . sprintf($lang['Search_user_posts'], $postrow[$i]['username']) . '" border="0" /></a>'; |
|
|
994 |
$search = '<a href="' . $temp_url . '">' . sprintf($lang['Search_user_posts'], $postrow[$i]['username']) . '</a>'; |
|
|
995 |
|
|
|
996 |
if ( ( $userdata['user_id'] == $poster_id && $is_auth['auth_edit'] ) || $is_auth['auth_mod'] ) |
|
|
997 |
{ |
|
|
998 |
$temp_url = append_sid("posting.$phpEx?mode=editpost&" . POST_POST_URL . "=" . $postrow[$i]['post_id']); |
|
|
999 |
$edit_img = '<a href="' . $temp_url . '"><img src="' . $images['icon_edit'] . '" alt="' . $lang['Edit_delete_post'] . '" title="' . $lang['Edit_delete_post'] . '" border="0" /></a>'; |
|
|
1000 |
$edit = '<a href="' . $temp_url . '">' . $lang['Edit_delete_post'] . '</a>'; |
|
|
1001 |
} |
|
|
1002 |
else |
|
|
1003 |
{ |
|
|
1004 |
$edit_img = ''; |
|
|
1005 |
$edit = ''; |
|
|
1006 |
} |
|
|
1007 |
|
|
|
1008 |
if ( $is_auth['auth_mod'] ) |
|
|
1009 |
{ |
|
|
1010 |
$temp_url = "modcp.$phpEx?mode=ip&" . POST_POST_URL . "=" . $postrow[$i]['post_id'] . "&" . POST_TOPIC_URL . "=" . $topic_id . "&sid=" . $userdata['session_id']; |
|
|
1011 |
$ip_img = '<a href="' . $temp_url . '"><img src="' . $images['icon_ip'] . '" alt="' . $lang['View_IP'] . '" title="' . $lang['View_IP'] . '" border="0" /></a>'; |
|
|
1012 |
$ip = '<a href="' . $temp_url . '">' . $lang['View_IP'] . '</a>'; |
|
|
1013 |
|
|
|
1014 |
$temp_url = "posting.$phpEx?mode=delete&" . POST_POST_URL . "=" . $postrow[$i]['post_id'] . "&sid=" . $userdata['session_id']; |
|
|
1015 |
$delpost_img = '<a href="' . $temp_url . '"><img src="' . $images['icon_delpost'] . '" alt="' . $lang['Delete_post'] . '" title="' . $lang['Delete_post'] . '" border="0" /></a>'; |
|
|
1016 |
$delpost = '<a href="' . $temp_url . '">' . $lang['Delete_post'] . '</a>'; |
|
|
1017 |
} |
|
|
1018 |
else |
|
|
1019 |
{ |
|
|
1020 |
$ip_img = ''; |
|
|
1021 |
$ip = ''; |
|
|
1022 |
|
|
|
1023 |
if ( $userdata['user_id'] == $poster_id && $is_auth['auth_delete'] && $forum_topic_data['topic_last_post_id'] == $postrow[$i]['post_id'] ) |
|
|
1024 |
{ |
|
|
1025 |
$temp_url = "posting.$phpEx?mode=delete&" . POST_POST_URL . "=" . $postrow[$i]['post_id'] . "&sid=" . $userdata['session_id']; |
|
|
1026 |
$delpost_img = '<a href="' . $temp_url . '"><img src="' . $images['icon_delpost'] . '" alt="' . $lang['Delete_post'] . '" title="' . $lang['Delete_post'] . '" border="0" /></a>'; |
|
|
1027 |
$delpost = '<a href="' . $temp_url . '">' . $lang['Delete_post'] . '</a>'; |
|
|
1028 |
} |
|
|
1029 |
else |
|
|
1030 |
{ |
|
|
1031 |
$delpost_img = ''; |
|
|
1032 |
$delpost = ''; |
|
|
1033 |
} |
|
|
1034 |
} |
|
|
1035 |
|
|
|
1036 |
$post_subject = ( $postrow[$i]['post_subject'] != '' ) ? $postrow[$i]['post_subject'] : ''; |
|
|
1037 |
|
|
|
1038 |
$message = $postrow[$i]['post_text']; |
|
|
1039 |
$bbcode_uid = $postrow[$i]['bbcode_uid']; |
|
|
1040 |
|
|
|
1041 |
$user_sig = ( $postrow[$i]['enable_sig'] && $postrow[$i]['user_sig'] != '' && $board_config['allow_sig'] ) ? $postrow[$i]['user_sig'] : ''; |
|
|
1042 |
$user_sig_bbcode_uid = $postrow[$i]['user_sig_bbcode_uid']; |
|
|
1043 |
|
|
|
1044 |
// |
|
|
1045 |
// Note! The order used for parsing the message _is_ important, moving things around could break any |
|
|
1046 |
// output |
|
|
1047 |
// |
|
|
1048 |
|
|
|
1049 |
// |
|
|
1050 |
// If the board has HTML off but the post has HTML |
|
|
1051 |
// on then we process it, else leave it alone |
|
|
1052 |
// |
|
|
1053 |
if ( !$board_config['allow_html'] || !$userdata['user_allowhtml']) |
|
|
1054 |
{ |
|
|
1055 |
if ( $user_sig != '' ) |
|
|
1056 |
{ |
|
|
1057 |
$user_sig = preg_replace('#(<)([\/]?.*?)(>)#is', "<\\2>", $user_sig); |
|
|
1058 |
} |
|
|
1059 |
|
|
|
1060 |
if ( $postrow[$i]['enable_html'] ) |
|
|
1061 |
{ |
|
|
1062 |
$message = preg_replace('#(<)([\/]?.*?)(>)#is', "<\\2>", $message); |
|
|
1063 |
} |
|
|
1064 |
} |
|
|
1065 |
|
|
|
1066 |
// |
|
|
1067 |
// Parse message and/or sig for BBCode if reqd |
|
|
1068 |
// |
|
|
1069 |
if ($user_sig != '' && $user_sig_bbcode_uid != '') |
|
|
1070 |
{ |
|
|
1071 |
$user_sig = ($board_config['allow_bbcode']) ? bbencode_second_pass($user_sig, $user_sig_bbcode_uid) : preg_replace("/\:$user_sig_bbcode_uid/si", '', $user_sig); |
|
|
1072 |
} |
|
|
1073 |
|
|
|
1074 |
if ($bbcode_uid != '') |
|
|
1075 |
{ |
|
|
1076 |
$message = ($board_config['allow_bbcode']) ? bbencode_second_pass($message, $bbcode_uid) : preg_replace("/\:$bbcode_uid/si", '', $message); |
|
|
1077 |
} |
|
|
1078 |
|
|
|
1079 |
if ( $user_sig != '' ) |
|
|
1080 |
{ |
|
|
1081 |
$user_sig = make_clickable($user_sig); |
|
|
1082 |
} |
|
|
1083 |
$message = make_clickable($message); |
|
|
1084 |
|
|
|
1085 |
// |
|
|
1086 |
// Parse smilies |
|
|
1087 |
// |
|
|
1088 |
if ( $board_config['allow_smilies'] ) |
|
|
1089 |
{ |
|
|
1090 |
if ( $postrow[$i]['user_allowsmile'] && $user_sig != '' ) |
|
|
1091 |
{ |
|
|
1092 |
$user_sig = smilies_pass($user_sig); |
|
|
1093 |
} |
|
|
1094 |
|
|
|
1095 |
if ( $postrow[$i]['enable_smilies'] ) |
|
|
1096 |
{ |
|
|
1097 |
$message = smilies_pass($message); |
|
|
1098 |
} |
|
|
1099 |
} |
|
|
1100 |
|
|
|
1101 |
// |
|
|
1102 |
// Highlight active words (primarily for search) |
|
|
1103 |
// |
|
|
1104 |
if ($highlight_match) |
|
|
1105 |
{ |
|
|
1106 |
// This has been back-ported from 3.0 CVS |
|
|
1107 |
$message = preg_replace('#(?!<.*)(?<!\w)(' . $highlight_match . ')(?!\w|[^<>]*>)#i', '<b style="color:#'.$theme['fontcolor3'].'">\1</b>', $message); |
|
|
1108 |
} |
|
|
1109 |
|
|
|
1110 |
// |
|
|
1111 |
// Replace naughty words |
|
|
1112 |
// |
|
|
1113 |
if (count($orig_word)) |
|
|
1114 |
{ |
|
|
1115 |
$post_subject = preg_replace($orig_word, $replacement_word, $post_subject); |
|
|
1116 |
|
|
|
1117 |
if ($user_sig != '') |
|
|
1118 |
{ |
|
|
1119 |
$user_sig = str_replace('\"', '"', substr(@preg_replace('#(\>(((?>([^><]+|(?R)))*)\<))#se', "@preg_replace(\$orig_word, \$replacement_word, '\\0')", '>' . $user_sig . '<'), 1, -1)); |
|
|
1120 |
} |
|
|
1121 |
|
|
|
1122 |
$message = str_replace('\"', '"', substr(@preg_replace('#(\>(((?>([^><]+|(?R)))*)\<))#se', "@preg_replace(\$orig_word, \$replacement_word, '\\0')", '>' . $message . '<'), 1, -1)); |
|
|
1123 |
} |
|
|
1124 |
|
|
|
1125 |
// |
|
|
1126 |
// Replace newlines (we use this rather than nl2br because |
|
|
1127 |
// till recently it wasn't XHTML compliant) |
|
|
1128 |
// |
|
|
1129 |
if ( $user_sig != '' ) |
|
|
1130 |
{ |
|
|
1131 |
$user_sig = '<br />_________________<br />' . str_replace("\n", "\n<br />\n", $user_sig); |
|
|
1132 |
} |
|
|
1133 |
|
|
|
1134 |
$message = str_replace("\n", "\n<br />\n", $message); |
|
|
1135 |
|
|
|
1136 |
// |
|
|
1137 |
// Editing information |
|
|
1138 |
// |
|
|
1139 |
if ( $postrow[$i]['post_edit_count'] ) |
|
|
1140 |
{ |
|
|
1141 |
$l_edit_time_total = ( $postrow[$i]['post_edit_count'] == 1 ) ? $lang['Edited_time_total'] : $lang['Edited_times_total']; |
|
|
1142 |
|
|
|
1143 |
$l_edited_by = '<br /><br />' . sprintf($l_edit_time_total, $poster, create_date($board_config['default_dateformat'], $postrow[$i]['post_edit_time'], $board_config['board_timezone']), $postrow[$i]['post_edit_count']); |
|
|
1144 |
} |
|
|
1145 |
else |
|
|
1146 |
{ |
|
|
1147 |
$l_edited_by = ''; |
|
|
1148 |
} |
|
|
1149 |
|
|
|
1150 |
// |
|
|
1151 |
// Again this will be handled by the templating |
|
|
1152 |
// code at some point |
|
|
1153 |
// |
|
|
1154 |
$row_color = ( !($i % 2) ) ? $theme['td_color1'] : $theme['td_color2']; |
|
|
1155 |
$row_class = ( !($i % 2) ) ? $theme['td_class1'] : $theme['td_class2']; |
|
|
1156 |
|
|
|
1157 |
$template->assign_block_vars('postrow', array( |
|
|
1158 |
'ROW_COLOR' => '#' . $row_color, |
|
|
1159 |
'ROW_CLASS' => $row_class, |
|
|
1160 |
'POSTER_NAME' => $poster, |
|
|
1161 |
'POSTER_RANK' => $poster_rank, |
|
|
1162 |
'RANK_IMAGE' => $rank_image, |
|
|
1163 |
'POSTER_JOINED' => $poster_joined, |
|
|
1164 |
'POSTER_POSTS' => $poster_posts, |
|
|
1165 |
'POSTER_FROM' => $poster_from, |
|
|
1166 |
'POSTER_AVATAR' => $poster_avatar, |
|
|
1167 |
'POST_DATE' => $post_date, |
|
|
1168 |
'POST_SUBJECT' => $post_subject, |
|
|
1169 |
'MESSAGE' => $message, |
|
|
1170 |
'SIGNATURE' => $user_sig, |
|
|
1171 |
'EDITED_MESSAGE' => $l_edited_by, |
|
|
1172 |
|
|
|
1173 |
'MINI_POST_IMG' => $mini_post_img, |
|
|
1174 |
'PROFILE_IMG' => $profile_img, |
|
|
1175 |
'PROFILE' => $profile, |
|
|
1176 |
'SEARCH_IMG' => $search_img, |
|
|
1177 |
'SEARCH' => $search, |
|
|
1178 |
'PM_IMG' => $pm_img, |
|
|
1179 |
'PM' => $pm, |
|
|
1180 |
'EMAIL_IMG' => $email_img, |
|
|
1181 |
'EMAIL' => $email, |
|
|
1182 |
'WWW_IMG' => $www_img, |
|
|
1183 |
'WWW' => $www, |
|
|
1184 |
'ICQ_STATUS_IMG' => $icq_status_img, |
|
|
1185 |
'ICQ_IMG' => $icq_img, |
|
|
1186 |
'ICQ' => $icq, |
|
|
1187 |
'AIM_IMG' => $aim_img, |
|
|
1188 |
'AIM' => $aim, |
|
|
1189 |
'MSN_IMG' => $msn_img, |
|
|
1190 |
'MSN' => $msn, |
|
|
1191 |
'YIM_IMG' => $yim_img, |
|
|
1192 |
'YIM' => $yim, |
|
|
1193 |
'EDIT_IMG' => $edit_img, |
|
|
1194 |
'EDIT' => $edit, |
|
|
1195 |
'QUOTE_IMG' => $quote_img, |
|
|
1196 |
'QUOTE' => $quote, |
|
|
1197 |
'IP_IMG' => $ip_img, |
|
|
1198 |
'IP' => $ip, |
|
|
1199 |
'DELETE_IMG' => $delpost_img, |
|
|
1200 |
'DELETE' => $delpost, |
|
|
1201 |
|
|
|
1202 |
'L_MINI_POST_ALT' => $mini_post_alt, |
|
|
1203 |
|
|
|
1204 |
'U_MINI_POST' => $mini_post_url, |
|
|
1205 |
'U_POST_ID' => $postrow[$i]['post_id']) |
|
|
1206 |
); |
|
|
1207 |
} |
|
|
1208 |
|
|
|
1209 |
$template->pparse('body'); |
|
|
1210 |
|
|
|
1211 |
include($phpbb_root_path . 'includes/page_tail.'.$phpEx); |
|
|
1212 |
|
|
|
1213 |
?> |