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.18 (8 years 6 months 2 weeks 6 days 22 hours 48 minutes 5 seconds ago) by djmaze
Changed : +9 -9 lines
Comment: Activated the rest of skype and fixed some XHTML bugs


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


Code Credits - Privacy Policy