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 : 9.6 (9 years 1 months 3 weeks 5 days 11 hours 40 minutes 27 seconds ago) by trevor
Changed : +18 -18 lines
Comment: Fixed all headers and tabified files


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


Code Credits - Privacy Policy