Dragonfly CMS logo Server sponsored and hosted by
DedicatedNOW
CVS logo  
.:: Home :: Dev. Resources :: Forums ::.
Dragonfly CMS CVS Repository
 Location: / cvs / html / modules / Forums / viewtopic.php
This is a web interface to the Dragonfly CMS CVS tree. You can browse the file hierarchy by picking directories. If you pick a file, you will see the revision history for that file.
Selecting a revision number will show that revision of the file. There are links at each revision to display diffs, annotate and download.
Note: Info about CVS and our commits can be found at our CVS Info Forum
File name: html/modules/Forums/viewtopic.php
Revision : 8.15 (9 years 4 months 2 weeks 3 days 13 hours 37 minutes 33 seconds ago) by akamu
Changed : +15 -7 lines
Comment: added user: bio, timezone,occupation,interests to template definitions so themes can use at forum post display


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


Code Credits - Privacy Policy