Rev Author Line No. Line
130 kaklik 1 <?php
2 /***************************************************************************
3 * topic_review.php
4 * -------------------
5 * begin : Saturday, Feb 13, 2001
6 * copyright : (C) 2001 The phpBB Group
7 * email : support@phpbb.com
8 *
9 * $Id: topic_review.php,v 1.5.2.4 2005/05/06 20:50:12 acydburn Exp $
10 *
11 *
12 ***************************************************************************/
13  
14 /***************************************************************************
15 *
16 * This program is free software; you can redistribute it and/or modify
17 * it under the terms of the GNU General Public License as published by
18 * the Free Software Foundation; either version 2 of the License, or
19 * (at your option) any later version.
20 *
21 *
22 ***************************************************************************/
23  
24 function topic_review($topic_id, $is_inline_review)
25 {
26 global $db, $board_config, $template, $lang, $images, $theme, $phpEx, $phpbb_root_path;
27 global $userdata, $user_ip;
28 global $orig_word, $replacement_word;
29 global $starttime;
30  
31 if ( !$is_inline_review )
32 {
33 if ( !isset($topic_id) || !$topic_id)
34 {
35 message_die(GENERAL_MESSAGE, 'Topic_post_not_exist');
36 }
37  
38 //
39 // Get topic info ...
40 //
41 $sql = "SELECT t.topic_title, 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
42 FROM " . TOPICS_TABLE . " t, " . FORUMS_TABLE . " f
43 WHERE t.topic_id = $topic_id
44 AND f.forum_id = t.forum_id";
45 if ( !($result = $db->sql_query($sql)) )
46 {
47 message_die(GENERAL_ERROR, 'Could not obtain topic information', '', __LINE__, __FILE__, $sql);
48 }
49  
50 if ( !($forum_row = $db->sql_fetchrow($result)) )
51 {
52 message_die(GENERAL_MESSAGE, 'Topic_post_not_exist');
53 }
54 $db->sql_freeresult($result);
55  
56 $forum_id = $forum_row['forum_id'];
57 $topic_title = $forum_row['topic_title'];
58  
59 //
60 // Start session management
61 //
62 $userdata = session_pagestart($user_ip, $forum_id);
63 init_userprefs($userdata);
64 //
65 // End session management
66 //
67  
68 $is_auth = array();
69 $is_auth = auth(AUTH_ALL, $forum_id, $userdata, $forum_row);
70  
71 if ( !$is_auth['auth_read'] )
72 {
73 message_die(GENERAL_MESSAGE, sprintf($lang['Sorry_auth_read'], $is_auth['auth_read_type']));
74 }
75 }
76  
77 //
78 // Define censored word matches
79 //
80 if ( empty($orig_word) && empty($replacement_word) )
81 {
82 $orig_word = array();
83 $replacement_word = array();
84  
85 obtain_word_list($orig_word, $replacement_word);
86 }
87  
88 //
89 // Dump out the page header and load viewtopic body template
90 //
91 if ( !$is_inline_review )
92 {
93 $gen_simple_header = TRUE;
94  
95 $page_title = $lang['Topic_review'] . ' - ' . $topic_title;
96 include($phpbb_root_path . 'includes/page_header.'.$phpEx);
97  
98 $template->set_filenames(array(
99 'reviewbody' => 'posting_topic_review.tpl')
100 );
101 }
102  
103 //
104 // Go ahead and pull all data for this topic
105 //
106 $sql = "SELECT u.username, u.user_id, p.*, pt.post_text, pt.post_subject, pt.bbcode_uid
107 FROM " . POSTS_TABLE . " p, " . USERS_TABLE . " u, " . POSTS_TEXT_TABLE . " pt
108 WHERE p.topic_id = $topic_id
109 AND p.poster_id = u.user_id
110 AND p.post_id = pt.post_id
111 ORDER BY p.post_time DESC
112 LIMIT " . $board_config['posts_per_page'];
113 if ( !($result = $db->sql_query($sql)) )
114 {
115 message_die(GENERAL_ERROR, 'Could not obtain post/user information', '', __LINE__, __FILE__, $sql);
116 }
117  
118 //
119 // Okay, let's do the loop, yeah come on baby let's do the loop
120 // and it goes like this ...
121 //
122 if ( $row = $db->sql_fetchrow($result) )
123 {
124 $mini_post_img = $images['icon_minipost'];
125 $mini_post_alt = $lang['Post'];
126  
127 $i = 0;
128 do
129 {
130 $poster_id = $row['user_id'];
131 $poster = $row['username'];
132  
133 $post_date = create_date($board_config['default_dateformat'], $row['post_time'], $board_config['board_timezone']);
134  
135 //
136 // Handle anon users posting with usernames
137 //
138 if( $poster_id == ANONYMOUS && $row['post_username'] != '' )
139 {
140 $poster = $row['post_username'];
141 $poster_rank = $lang['Guest'];
142 }
143 elseif ( $poster_id == ANONYMOUS )
144 {
145 $poster = $lang['Guest'];
146 $poster_rank = '';
147 }
148  
149 $post_subject = ( $row['post_subject'] != '' ) ? $row['post_subject'] : '';
150  
151 $message = $row['post_text'];
152 $bbcode_uid = $row['bbcode_uid'];
153  
154 //
155 // If the board has HTML off but the post has HTML
156 // on then we process it, else leave it alone
157 //
158 if ( !$board_config['allow_html'] && $row['enable_html'] )
159 {
160 $message = preg_replace('#(<)([\/]?.*?)(>)#is', '&lt;\2&gt;', $message);
161 }
162  
163 if ( $bbcode_uid != "" )
164 {
165 $message = ( $board_config['allow_bbcode'] ) ? bbencode_second_pass($message, $bbcode_uid) : preg_replace('/\:[0-9a-z\:]+\]/si', ']', $message);
166 }
167  
168 $message = make_clickable($message);
169  
170 if ( count($orig_word) )
171 {
172 $post_subject = preg_replace($orig_word, $replacement_word, $post_subject);
173 $message = preg_replace($orig_word, $replacement_word, $message);
174 }
175  
176 if ( $board_config['allow_smilies'] && $row['enable_smilies'] )
177 {
178 $message = smilies_pass($message);
179 }
180  
181 $message = str_replace("\n", '<br />', $message);
182  
183 //
184 // Again this will be handled by the templating
185 // code at some point
186 //
187 $row_color = ( !($i % 2) ) ? $theme['td_color1'] : $theme['td_color2'];
188 $row_class = ( !($i % 2) ) ? $theme['td_class1'] : $theme['td_class2'];
189  
190 $template->assign_block_vars('postrow', array(
191 'ROW_COLOR' => '#' . $row_color,
192 'ROW_CLASS' => $row_class,
193  
194 'MINI_POST_IMG' => $mini_post_img,
195 'POSTER_NAME' => $poster,
196 'POST_DATE' => $post_date,
197 'POST_SUBJECT' => $post_subject,
198 'MESSAGE' => $message,
199  
200 'L_MINI_POST_ALT' => $mini_post_alt)
201 );
202  
203 $i++;
204 }
205 while ( $row = $db->sql_fetchrow($result) );
206 }
207 else
208 {
209 message_die(GENERAL_MESSAGE, 'Topic_post_not_exist', '', __LINE__, __FILE__, $sql);
210 }
211 $db->sql_freeresult($result);
212  
213 $template->assign_vars(array(
214 'L_AUTHOR' => $lang['Author'],
215 'L_MESSAGE' => $lang['Message'],
216 'L_POSTED' => $lang['Posted'],
217 'L_POST_SUBJECT' => $lang['Post_subject'],
218 'L_TOPIC_REVIEW' => $lang['Topic_review'])
219 );
220  
221 if ( !$is_inline_review )
222 {
223 $template->pparse('reviewbody');
224 include($phpbb_root_path . 'includes/page_tail.'.$phpEx);
225 }
226 }
227  
228 ?>