3 This program is free software; you can redistribute it and/or modify
4 it under the terms of the Revised BSD License.
6 This program is distributed in the hope that it will be useful,
7 but WITHOUT ANY WARRANTY; without even the implied warranty of
8 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
9 Revised BSD License for more details.
11 Copyright 2004-2010 iDB Support - http://idb.berlios.de/
12 Copyright 2004-2010 Game Maker 2k - http://gamemaker2k.org/
14 $FileInfo: searchs.php - Last Update: 09/05/2010 SVN 572 - Author: cooldude2k $
16 $File3Name = basename($_SERVER['SCRIPT_NAME']);
17 if ($File3Name=="searchs.php"||
$File3Name=="/searchs.php") {
20 if($Settings['enable_search']=="off"||
21 $GroupInfo['CanSearch']=="no") {
22 redirect("location",$rbasedir.url_maker($exfile['index'],$Settings['file_ext'],"act=view",$Settings['qstr'],$Settings['qsep'],$prexqstr['index'],$exqstr['index'],false));
23 header("Content-Type: text/plain; charset=".$Settings['charset']);
24 ob_clean(); echo "Sorry you do not have permission to do a search.";
25 gzip_page($Settings['use_gzip'],$GZipEncode['Type']); session_write_close(); die(); }
27 if($Settings['enable_search']=="on"||
28 $GroupInfo['CanSearch']=="yes") {
29 $_SESSION['ViewingPage'] = url_maker(null,"no+ext","act=topics","&","=",$prexqstr['search'],$exqstr['search']);
30 if($Settings['file_ext']!="no+ext"&&$Settings['file_ext']!="no ext") {
31 $_SESSION['ViewingFile'] = $exfile['search'].$Settings['file_ext']; }
32 if($Settings['file_ext']=="no+ext"||
$Settings['file_ext']=="no ext") {
33 $_SESSION['ViewingFile'] = $exfile['search']; }
34 $_SESSION['PreViewingTitle'] = "Searching";
35 $_SESSION['ViewingTitle'] = "Topics";
36 if($_GET['act']=="topics") {
37 if($_GET['search']==null&&$_GET['type']==null) {
39 <div
class="NavLinks"><?php
echo $ThemeSet['NavLinkIcon']; ?
><a href
="<?php echo url_maker($exfile['index'],$Settings['file_ext'],"act
=view
",$Settings['qstr'],$Settings['qsep'],$prexqstr['index'],$exqstr['index']); ?>">Board index
</a
><?php
echo $ThemeSet['NavLinkDivider']; ?
><a href
="<?php echo url_maker($exfile['search'],$Settings['file_ext'],"act
=topics
",$Settings['qstr'],$Settings['qsep'],$prexqstr['search'],$exqstr['search']); ?>">Search topics
</a
></div
>
40 <div
class="DivNavLinks"> 
;</div
>
41 <div
class="Table1Border">
42 <?php
if($ThemeSet['TableStyle']=="div") { ?
>
43 <div
class="TableRow1">
44 <span style
="text-align: left;">
45 <?php
echo $ThemeSet['TitleIcon']; ?
><a href
="<?php echo url_maker($exfile['search'],$Settings['file_ext'],"act
=topics
",$Settings['qstr'],$Settings['qsep'],$prexqstr['search'],$exqstr['search']); ?>">Topic Search
</a
></span
></div
>
47 <table
class="Table1">
48 <?php
if($ThemeSet['TableStyle']=="table") { ?
>
49 <tr id
="SearchStart" class="TableRow1">
50 <td
class="TableColumn1" colspan
="6"><span style
="text-align: left;">
51 <?php
echo $ThemeSet['TitleIcon']; ?
><a href
="<?php echo url_maker($exfile['search'],$Settings['file_ext'],"act
=topics
",$Settings['qstr'],$Settings['qsep'],$prexqstr['search'],$exqstr['search']); ?>">Topic Search
</a
></span
>
54 <tr
class="TableRow2">
55 <th
class="TableColumn2" style
="width: 100%; text-align: left;"> 
;Search
for topic
: </th
>
57 <tr
class="TableRow3">
58 <td
class="TableColumn3">
59 <form style
="display: inline;" method
="post" action
="<?php echo url_maker($exfile['search'],$Settings['file_ext'],"act
=topics
",$Settings['qstr'],$Settings['qsep'],$prexqstr['search'],$exqstr['search']); ?>">
60 <table style
="text-align: left;">
61 <tr style
="text-align: left;">
62 <td style
="width: 30%;"><label
class="TextBoxLabel" for="search">Enter SearchTerm
: </label
></td
>
63 <td style
="width: 70%;"><input maxlength
="35" class="TextBox" id
="search" type
="text" name
="search" /></td
>
64 </tr
><tr style
="text-align: left;">
65 <td style
="width: 30%;"><label
class="TextBoxLabel" for="msearch">Filter by
Member (optional
): </label
></td
>
66 <td style
="width: 70%;"><input maxlength
="25" class="TextBox" id
="msearch" type
="text" name
="msearch" /></td
>
67 </tr
><tr style
="text-align: left;">
68 <td style
="width: 30%;"><label
class="TextBoxLabel" title
="Wildcard is %" for="type">Search Type
: </label
></td
>
69 <td style
="width: 70%;"><select id
="type" name
="type" class="TextBox">
70 <option value
="normal">Normal Search
</option
>
71 <option value
="wildcard">Wildcard Search
</option
>
74 <table style
="text-align: left;">
75 <tr style
="text-align: left;">
76 <td style
="width: 100%;">
77 <input type
="hidden" name
="act" value
="topics" style
="display: none;" />
78 <input
class="Button" type
="submit" value
="Search" />
83 <tr
class="TableRow4">
84 <td
class="TableColumn4"> 
;</td
>
87 <?php
} if($_GET['search']!=null&&$_GET['type']!=null) {
88 if(pre_strlen($_GET['msearch'])>="25") {
89 $_GET['msearch'] = null; }
90 if($_GET['msearch']!=null) {
91 $memsiquery = sql_pre_query("SELECT * FROM \"".$Settings['sqltable']."members\" WHERE \"Name\"='%s' LIMIT 1", array($_GET['msearch']));
92 $memsiresult=sql_query($memsiquery,$SQLStat);
93 $memsinum=sql_num_rows($memsiresult);
95 if($memsinum==0) { $memsid = -1; }
97 $memsid=sql_result($memsiresult,$memsi,"id");
98 sql_free_result($memsiresult); } }
99 //Get SQL LIMIT Number
100 $nums = $_GET['page'] * $Settings['max_topics'];
101 $PageLimit = $nums - $Settings['max_topics'];
102 if($PageLimit<0) { $PageLimit = 0; }
103 if($_GET['msearch']==null) {
104 if($_GET['type']!="wildcard") {
105 $query = sql_pre_query("SELECT * FROM \"".$Settings['sqltable']."topics\" WHERE \"TopicName\"='%s'".$ForumIgnoreList4." ORDER BY \"LastUpdate\" DESC ".$SQLimit, array($_GET['search'],$PageLimit,$Settings['max_topics']));
106 $rnquery = sql_pre_query("SELECT COUNT(*) FROM \"".$Settings['sqltable']."topics\" WHERE \"TopicName\"='%s'".$ForumIgnoreList4."", array($_GET['search'])); }
107 if($_GET['type']=="wildcard") {
108 $query = sql_pre_query("SELECT * FROM \"".$Settings['sqltable']."topics\" WHERE \"TopicName\" LIKE '%s'".$ForumIgnoreList4." ORDER BY \"LastUpdate\" DESC ".$SQLimit, array($_GET['search'],$PageLimit,$Settings['max_topics']));
109 $rnquery = sql_pre_query("SELECT COUNT(*) FROM \"".$Settings['sqltable']."topics\" WHERE \"TopicName\" LIKE '%s'".$ForumIgnoreList4."", array($_GET['search'])); } }
110 if($_GET['msearch']!=null) {
111 if($_GET['type']!="wildcard") {
112 $query = sql_pre_query("SELECT * FROM \"".$Settings['sqltable']."topics\" WHERE \"TopicName\"='%s' AND \"UserID\"=%i".$ForumIgnoreList4." ORDER BY \"LastUpdate\" DESC ".$SQLimit, array($_GET['search'],$memsid,$PageLimit,$Settings['max_topics']));
113 $rnquery = sql_pre_query("SELECT COUNT(*) FROM \"".$Settings['sqltable']."topics\" WHERE \"TopicName\"='%s' AND \"UserID\"=%i".$ForumIgnoreList4."", array($_GET['search']));
115 $query = sql_pre_query("SELECT * FROM \"".$Settings['sqltable']."topics\" WHERE \"TopicName\"='%s' AND \"GuestName\"='%s'".$ForumIgnoreList4." ORDER BY \"LastUpdate\" DESC ".$SQLimit, array($_GET['search'],$_GET['msearch'],$PageLimit,$Settings['max_topics']));
116 $rnquery = sql_pre_query("SELECT COUNT(*) FROM \"".$Settings['sqltable']."topics\" WHERE \"TopicName\"='%s' AND \"GuestName\"='%s'".$ForumIgnoreList4."", array($_GET['search'],$_GET['msearch'])); } }
117 if($_GET['type']=="wildcard") {
118 $query = sql_pre_query("SELECT * FROM \"".$Settings['sqltable']."topics\" WHERE \"TopicName\" LIKE '%s' AND \"UserID\"=%i".$ForumIgnoreList4." ORDER BY \"LastUpdate\" DESC ".$SQLimit, array($_GET['search'],$memsid,$PageLimit,$Settings['max_topics']));
119 $rnquery = sql_pre_query("SELECT COUNT(*) FROM \"".$Settings['sqltable']."topics\" WHERE \"TopicName\" LIKE '%s' AND \"UserID\"=%i".$ForumIgnoreList4."", array($_GET['search'],$_GET['msearch']));
121 $query = sql_pre_query("SELECT * FROM \"".$Settings['sqltable']."topics\" WHERE \"TopicName\" LIKE '%s' AND \"GuestName\"='%s'".$ForumIgnoreList4." ORDER BY \"LastUpdate\" DESC ".$SQLimit, array($_GET['search'],$_GET['msearch'],$PageLimit,$Settings['max_topics']));
122 $rnquery = sql_pre_query("SELECT COUNT(*) FROM \"".$Settings['sqltable']."topics\" WHERE \"TopicName\" LIKE '%s' AND \"GuestName\"='%s'".$ForumIgnoreList4."", array($_GET['search'],$_GET['msearch'])); } } }
123 $result=sql_query($query,$SQLStat);
124 $rnresult=sql_query($rnquery,$SQLStat);
125 $NumberTopics = sql_result($rnresult,0);
126 sql_free_result($rnresult);
127 if($NumberTopics==null) {
129 $num = $NumberTopics;
130 //Start Topic Page Code
131 if(!isset($Settings['max_topics'])) { $Settings['max_topics'] = 10; }
132 if($_GET['page']==null) { $_GET['page'] = 1; }
133 if($_GET['page']<=0) { $_GET['page'] = 1; }
134 $nums = $_GET['page'] * $Settings['max_topics'];
135 if($nums>$num) { $nums = $num; }
136 $numz = $nums - $Settings['max_topics'];
137 if($numz<=0) { $numz = 0; }
139 if($nums<$num) { $nextpage = $_GET['page'] +
1; }
140 if($nums>=$num) { $nextpage = $_GET['page']; }
141 if($numz>=$Settings['max_topics']) { $backpage = $_GET['page'] - 1; }
142 if($_GET['page']<=1) { $backpage = 1; }
143 $pnum = $num; $l = 1; $Pages = null;
145 if($pnum>=$Settings['max_topics']) {
146 $pnum = $pnum - $Settings['max_topics'];
147 $Pages[$l] = $l; ++
$l; }
148 if($pnum<$Settings['max_topics']&&$pnum>0) {
149 $pnum = $pnum - $pnum;
150 $Pages[$l] = $l; ++
$l; } }
151 //End Topic Page Code
152 $num=sql_num_rows($result);
154 redirect("location",$rbasedir.url_maker($exfile['search'],$Settings['file_ext'],"act=topics",$Settings['qstr'],$Settings['qsep'],$prexqstr['search'],$exqstr['search'],false));
155 header("Content-Type: text/plain; charset=".$Settings['charset']);
156 ob_clean(); echo "Sorry could not find any search results."; sql_free_result($result);
157 gzip_page($Settings['use_gzip'],$GZipEncode['Type']); session_write_close(); die(); }
159 //List Page Number Code Start
160 $pagenum=count($Pages);
161 if($_GET['page']>$pagenum) {
162 $_GET['page'] = $pagenum; }
163 $pagei=0; $pstring = null;
165 $pstring = "<div class=\"PageList\"><span class=\"pagelink\">".$pagenum." Pages:</span> "; }
166 if($_GET['page']<4) { $Pagez[0] = null; }
167 if($_GET['page']>=4) { $Pagez[0] = "First"; }
168 if($_GET['page']>=3) {
169 $Pagez[1] = $_GET['page'] - 2; }
170 if($_GET['page']<3) {
172 if($_GET['page']>=2) {
173 $Pagez[2] = $_GET['page'] - 1; }
174 if($_GET['page']<2) {
176 $Pagez[3] = $_GET['page'];
177 if($_GET['page']<$pagenum) {
178 $Pagez[4] = $_GET['page'] +
1; }
179 if($_GET['page']>=$pagenum) {
181 $pagenext = $_GET['page'] +
1;
182 if($pagenext<$pagenum) {
183 $Pagez[5] = $_GET['page'] +
2; }
184 if($pagenext>=$pagenum) {
186 if($_GET['page']<$pagenum) { $Pagez[6] = "Last"; }
187 if($_GET['page']>=$pagenum) { $Pagez[6] = null; }
188 $pagenumi=count($Pagez);
191 if($_GET['msearch']==null) {
193 if($_GET['msearch']!=null) {
197 while ($pagei < $pagenumi) {
198 if($_GET['msearch']==null) {
199 if($_GET['page']!=1&&$pagei==1) {
200 $Pback = $_GET['page'] - 1;
201 $pstring = $pstring."<span class=\"pagelink\"><a href=\"".url_maker($exfile['search'],$Settings['file_ext'],"act=topics&search=".$_GET['search']."&type=".$_GET['type']."&page=".$Pback,$Settings['qstr'],$Settings['qsep'],$prexqstr['search'],$exqstr['search'])."\"><</a></span> "; } }
202 if($_GET['msearch']!=null) {
203 if($_GET['page']!=1&&$pagei==1) {
204 $Pback = $_GET['page'] - 1;
205 $pstring = $pstring."<span class=\"pagelink\"><a href=\"".url_maker($exfile['search'],$Settings['file_ext'],"act=topics&search=".$_GET['search']."&type=".$_GET['type']."&msearch=".$_GET['msearch']."&page=".$Pback,$Settings['qstr'],$Settings['qsep'],$prexqstr['search'],$exqstr['search'])."\"><</a></span> "; } }
206 if($Pagez[$pagei]!=null&&
207 $Pagez[$pagei]!="First"&&
208 $Pagez[$pagei]!="Last") {
209 if($_GET['msearch']==null) {
211 $pstring = $pstring."<span class=\"pagelink\"><a href=\"".url_maker($exfile['search'],$Settings['file_ext'],"act=topics&search=".$_GET['search']."&type=".$_GET['type']."&page=".$Pagez[$pagei],$Settings['qstr'],$Settings['qsep'],$prexqstr['search'],$exqstr['search'])."\">".$Pagez[$pagei]."</a></span> "; }
213 $pstring = $pstring."<span class=\"pagecurrent\"><a href=\"".url_maker($exfile['search'],$Settings['file_ext'],"act=topics&search=".$_GET['search']."&type=".$_GET['type']."&page=".$Pagez[$pagei],$Settings['qstr'],$Settings['qsep'],$prexqstr['search'],$exqstr['search'])."\">".$Pagez[$pagei]."</a></span> "; } }
214 if($_GET['msearch']!=null) {
216 $pstring = $pstring."<span class=\"pagelink\"><a href=\"".url_maker($exfile['search'],$Settings['file_ext'],"act=topics&search=".$_GET['search']."&type=".$_GET['type']."&msearch=".$_GET['msearch']."&page=".$Pagez[$pagei],$Settings['qstr'],$Settings['qsep'],$prexqstr['search'],$exqstr['search'])."\">".$Pagez[$pagei]."</a></span> "; }
218 $pstring = $pstring."<span class=\"pagecurrent\"><a href=\"".url_maker($exfile['search'],$Settings['file_ext'],"act=topics&search=".$_GET['search']."&type=".$_GET['type']."&msearch=".$_GET['msearch']."&page=".$Pagez[$pagei],$Settings['qstr'],$Settings['qsep'],$prexqstr['search'],$exqstr['search'])."\">".$Pagez[$pagei]."</a></span> "; } } }
219 if($Pagez[$pagei]=="First") {
220 if($_GET['msearch']==null) {
221 $pstring = $pstring."<span class=\"pagelinklast\"><a href=\"".url_maker($exfile['search'],$Settings['file_ext'],"act=topics&search=".$_GET['search']."&type=".$_GET['type']."&page=1",$Settings['qstr'],$Settings['qsep'],$prexqstr['search'],$exqstr['search'])."\">«</a></span> "; }
222 if($_GET['msearch']!=null) {
223 $pstring = $pstring."<span class=\"pagelinklast\"><a href=\"".url_maker($exfile['search'],$Settings['file_ext'],"act=topics&search=".$_GET['search']."&type=".$_GET['type']."&msearch=".$_GET['msearch']."&page=1",$Settings['qstr'],$Settings['qsep'],$prexqstr['search'],$exqstr['search'])."\">«</a></span> "; } }
224 if($Pagez[$pagei]=="Last") {
225 if($_GET['msearch']==null) {
226 $ptestnext = $pagenext +
1;
228 $Pnext = $_GET['page'] +
1;
229 $pstring = $pstring."<span class=\"pagelink\"><a href=\"".url_maker($exfile['search'],$Settings['file_ext'],"act=topics&search=".$_GET['search']."&type=".$_GET['type']."&page=".$Pnext,$Settings['qstr'],$Settings['qsep'],$prexqstr['search'],$exqstr['search'])."\">></a></span> ";
230 if($ptestnext<$pagenum) {
231 $pstring = $pstring."<span class=\"pagelinklast\"><a href=\"".url_maker($exfile['search'],$Settings['file_ext'],"act=topics&search=".$_GET['search']."&type=".$_GET['type']."&page=".$pagenum,$Settings['qstr'],$Settings['qsep'],$prexqstr['search'],$exqstr['search'])."\">»</a></span> "; } }
232 if($_GET['msearch']!=null) {
233 $ptestnext = $pagenext +
1;
235 $Pnext = $_GET['page'] +
1;
236 $pstring = $pstring."<span class=\"pagelink\"><a href=\"".url_maker($exfile['search'],$Settings['file_ext'],"act=topics&search=".$_GET['search']."&type=".$_GET['type']."&msearch=".$_GET['msearch']."&page=".$Pnext,$Settings['qstr'],$Settings['qsep'],$prexqstr['search'],$exqstr['search'])."\">></a></span> ";
237 if($ptestnext<$pagenum) {
238 $pstring = $pstring."<span class=\"pagelinklast\"><a href=\"".url_maker($exfile['search'],$Settings['file_ext'],"act=topics&search=".$_GET['search']."&type=".$_GET['type']."&msearch=".$_GET['msearch']."&page=".$pagenum,$Settings['qstr'],$Settings['qsep'],$prexqstr['search'],$exqstr['search'])."\">»</a></span> "; } } }
239 ++
$pagei; } $pstring = $pstring."</div>"; }
241 <div
class="NavLinks"><?php
echo $ThemeSet['NavLinkIcon']; ?
><a href
="<?php echo url_maker($exfile['index'],$Settings['file_ext'],"act
=view
",$Settings['qstr'],$Settings['qsep'],$prexqstr['index'],$exqstr['index']); ?>">Board index
</a
><?php
echo $ThemeSet['NavLinkDivider']; ?
><a href
="<?php echo url_maker($exfile['search'],$Settings['file_ext'],"act
=topics
",$Settings['qstr'],$Settings['qsep'],$prexqstr['search'],$exqstr['search']); ?>">Search topics
</a
></div
>
242 <div
class="DivNavLinks"> 
;</div
>
245 //List Page Number Code end
248 <div
class="DivPageLinks"> 
;</div
>
250 <div
class="Table1Border">
251 <?php
if($ThemeSet['TableStyle']=="div") { ?
>
252 <div
class="TableRow1">
253 <span style
="text-align: left;">
254 <?php
echo $ThemeSet['TitleIcon'];
255 if($_GET['msearch']==null) { ?
>
256 <a href
="<?php echo url_maker($exfile['search'],$Settings['file_ext'],"act
=topics
&search
=".$_GET['search']."&type
=".$_GET['type']."&page
=".$_GET['page'],$Settings['qstr'],$Settings['qsep'],$prexqstr['search'],$exqstr['search']); ?>">Searching
for <?php
echo $_GET['search']; ?
></a
>
257 <?php
} if($_GET['msearch']!=null) { ?
>
258 <a href
="<?php echo url_maker($exfile['search'],$Settings['file_ext'],"act
=topics
&search
=".$_GET['search']."&type
=".$_GET['type']."&msearch
=".$_GET['msearch']."&page
=".$_GET['page'],$Settings['qstr'],$Settings['qsep'],$prexqstr['search'],$exqstr['search']); ?>">Searching
for <?php
echo $_GET['search']; ?
> by
<?php
echo $_GET['msearch']; ?
></a
>
259 <?php
} ?
></span
></div
>
261 <table
class="Table1">
262 <?php
if($ThemeSet['TableStyle']=="table") { ?
>
263 <tr id
="SearchStart" class="TableRow1">
264 <td
class="TableColumn1" colspan
="6"><span style
="text-align: left;">
265 <?php
echo $ThemeSet['TitleIcon'];
266 if($_GET['msearch']==null) { ?
>
267 <a href
="<?php echo url_maker($exfile['search'],$Settings['file_ext'],"act
=topics
&search
=".$_GET['search']."&type
=".$_GET['type']."&page
=".$_GET['page'],$Settings['qstr'],$Settings['qsep'],$prexqstr['search'],$exqstr['search']); ?>">Searching
for <?php
echo $_GET['search']; ?
></a
>
268 <?php
} if($_GET['msearch']!=null) { ?
>
269 <a href
="<?php echo url_maker($exfile['search'],$Settings['file_ext'],"act
=topics
&search
=".$_GET['search']."&type
=".$_GET['type']."&msearch
=".$_GET['msearch']."&page
=".$_GET['page'],$Settings['qstr'],$Settings['qsep'],$prexqstr['search'],$exqstr['search']); ?>">Searching
for <?php
echo $_GET['search']; ?
> by
<?php
echo $_GET['msearch']; ?
></a
>
273 <tr id
="SearchStatRow" class="TableRow2">
274 <th
class="TableColumn2" style
="width: 4%;">State
</th
>
275 <th
class="TableColumn2" style
="width: 36%;">Topic Name
</th
>
276 <th
class="TableColumn2" style
="width: 15%;">Author
</th
>
277 <th
class="TableColumn2" style
="width: 15%;">Time
</th
>
278 <th
class="TableColumn2" style
="width: 5%;">Replys
</th
>
279 <th
class="TableColumn2" style
="width: 25%;">Last Reply
</th
>
283 $TopicID=sql_result($result,$i,"id");
284 $ForumID=sql_result($result,$i,"ForumID");
285 $prequery = sql_pre_query("SELECT * FROM \"".$Settings['sqltable']."forums\" WHERE \"id\"=%i".$ForumIgnoreList2." LIMIT 1", array($ForumID));
286 $preresult=sql_query($prequery,$SQLStat);
287 $prenum=sql_num_rows($preresult);
288 $HotTopicPosts = $Settings['hot_topic_num'];
290 $HotTopicPosts = sql_result($preresult,0,"HotTopicPosts"); }
291 sql_free_result($preresult);
292 if($HotTopicPosts!=0&&is_numeric($HotTopicPosts)) {
293 $Settings['hot_topic_num'] = $HotTopicPosts; }
294 if(!is_numeric($Settings['hot_topic_num'])) {
295 $Settings['hot_topic_num'] = 15; }
296 $CategoryID=sql_result($result,$i,"CategoryID");
297 $UsersID=sql_result($result,$i,"UserID");
298 $GuestsName=sql_result($result,$i,"GuestName");
299 $TheTime=sql_result($result,$i,"TimeStamp");
300 $TheTime=GMTimeChange("F j Y, g:i a",$TheTime,$_SESSION['UserTimeZone'],0,$_SESSION['UserDST']);
301 $NumReply=sql_result($result,$i,"NumReply");
302 $NumberPosts=$NumReply +
1;
304 if(!isset($Settings['max_posts'])) {
305 $Settings['max_posts'] = 10; }
306 if(!isset($ThemeSet['MiniPageAltStyle'])) {
307 $ThemeSet['MiniPageAltStyle'] = "off"; }
308 if($ThemeSet['MiniPageAltStyle']!="on"&&
309 $ThemeSet['MiniPageAltStyle']!="off") {
310 $ThemeSet['MiniPageAltStyle'] = "off"; }
311 if($NumberPosts>$Settings['max_posts']) {
312 $NumberPages = ceil($NumberPosts/$Settings['max_posts']); }
313 if($NumberPosts<=$Settings['max_posts']) {
316 $prepagelist = " "; }
317 if($NumberPages>=2) {
318 if($ThemeSet['MiniPageAltStyle']=="off") {
319 $prepagelist = "<span class=\"small\">(Pages: "; }
320 if($ThemeSet['MiniPageAltStyle']=="on") {
321 $prepagelist = $prepagelist."<span class=\"minipagelink\">"; }
322 $prepagelist = $prepagelist."<a href=\"".url_maker($exfile['topic'],$Settings['file_ext'],"act=view&id=".$TopicID."&page=1",$Settings['qstr'],$Settings['qsep'],$prexqstr['topic'],$exqstr['topic'])."\">1</a>";
323 if($ThemeSet['MiniPageAltStyle']=="on") {
324 $prepagelist = $prepagelist."</span>"; }
325 if($ThemeSet['MiniPageAltStyle']=="off") { $prepagelist = $prepagelist." "; }
326 if($ThemeSet['MiniPageAltStyle']=="on") {
327 $prepagelist = $prepagelist."<span class=\"minipagelink\">"; }
328 $prepagelist = $prepagelist."<a href=\"".url_maker($exfile['topic'],$Settings['file_ext'],"act=view&id=".$TopicID."&page=2",$Settings['qstr'],$Settings['qsep'],$prexqstr['topic'],$exqstr['topic'])."\">2</a>";
329 if($ThemeSet['MiniPageAltStyle']=="on") {
330 $prepagelist = $prepagelist."</span>"; }
331 if($NumberPages>=3) {
332 if($ThemeSet['MiniPageAltStyle']=="off") { $prepagelist = $prepagelist." "; }
333 if($ThemeSet['MiniPageAltStyle']=="on") {
334 $prepagelist = $prepagelist."<span class=\"minipagelink\">"; }
335 $prepagelist = $prepagelist."<a href=\"".url_maker($exfile['topic'],$Settings['file_ext'],"act=view&id=".$TopicID."&page=3",$Settings['qstr'],$Settings['qsep'],$prexqstr['topic'],$exqstr['topic'])."\">3</a>";
336 if($ThemeSet['MiniPageAltStyle']=="on") {
337 $prepagelist = $prepagelist."</span>"; } }
338 if($NumberPages==4) {
339 if($ThemeSet['MiniPageAltStyle']=="off") { $prepagelist = $prepagelist." "; }
340 if($ThemeSet['MiniPageAltStyle']=="on") {
341 $prepagelist = $prepagelist."<span class=\"minipagelinklast\">"; }
342 if($ThemeSet['MiniPageAltStyle']=="on") {
343 $prepagelist = $prepagelist."<a href=\"".url_maker($exfile['topic'],$Settings['file_ext'],"act=view&id=".$TopicID."&page=4",$Settings['qstr'],$Settings['qsep'],$prexqstr['topic'],$exqstr['topic'])."\">4</a>"; }
344 if($ThemeSet['MiniPageAltStyle']=="off") {
345 $prepagelist = $prepagelist."<a href=\"".url_maker($exfile['topic'],$Settings['file_ext'],"act=view&id=".$TopicID."&page=4",$Settings['qstr'],$Settings['qsep'],$prexqstr['topic'],$exqstr['topic'])."\"> ...4</a>"; }
346 if($ThemeSet['MiniPageAltStyle']=="on") {
347 $prepagelist = $prepagelist."</span>"; } }
349 if($ThemeSet['MiniPageAltStyle']=="off") { $prepagelist = $prepagelist." "; }
350 if($ThemeSet['MiniPageAltStyle']=="on") {
351 $prepagelist = $prepagelist."<span class=\"minipagelinklast\">"; }
352 if($ThemeSet['MiniPageAltStyle']=="on") {
353 $prepagelist = $prepagelist."<a href=\"".url_maker($exfile['topic'],$Settings['file_ext'],"act=view&id=".$TopicID."&page=".$NumberPages,$Settings['qstr'],$Settings['qsep'],$prexqstr['topic'],$exqstr['topic'])."\">» ".$NumberPages."</a>"; }
354 if($ThemeSet['MiniPageAltStyle']=="off") {
355 $prepagelist = $prepagelist."<a href=\"".url_maker($exfile['topic'],$Settings['file_ext'],"act=view&id=".$TopicID."&page=".$NumberPages,$Settings['qstr'],$Settings['qsep'],$prexqstr['topic'],$exqstr['topic'])."\"> ...".$NumberPages."</a>"; }
356 if($ThemeSet['MiniPageAltStyle']=="on") {
357 $prepagelist = $prepagelist."</span>"; } }
358 if($ThemeSet['MiniPageAltStyle']=="off") {
359 $prepagelist = $prepagelist.")</span>"; } }
360 $TopicName=sql_result($result,$i,"TopicName");
361 $TopicDescription=sql_result($result,$i,"Description");
362 $PinnedTopic=sql_result($result,$i,"Pinned");
363 if ($PinnedTopic>2) { $PinnedTopic = 1; }
364 if ($PinnedTopic<0) { $PinnedTopic = 0; }
365 if(!is_numeric($PinnedTopic)) { $PinnedTopic = 0; }
366 $TopicStat=sql_result($result,$i,"Closed");
367 if ($TopicStat>3) { $TopicStat = 1; }
368 if ($TopicStat<0) { $TopicStat = 0; }
369 if(!is_numeric($TopicStat)) { $TopicStat = 1; }
370 $PreUsersName = GetUserName($UsersID,$Settings['sqltable'],$SQLStat);
371 if($PreUsersName['Name']===null) { $UsersID = -1;
372 $PreUsersName = GetUserName($UsersID,$Settings['sqltable'],$SQLStat); }
373 $UsersName = $PreUsersName['Name'];
374 $UsersHidden = $PreUsersName['Hidden'];
375 if($UsersName=="Guest") { $UsersName=$GuestsName;
376 if($UsersName==null) { $UsersName="Guest"; } }
377 if(($PermissionInfo['CanViewForum'][$ForumID]=="yes"&&
378 $CatPermissionInfo['CanViewCategory'][$CategoryID]=="yes"&&
379 $TopicStat>=0&&$TopicStat<3)||
380 ($PermissionInfo['CanViewForum'][$ForumID]=="yes"&&
381 $CatPermissionInfo['CanViewCategory'][$CategoryID]=="yes"&&
382 $PermissionInfo['CanModForum'][$ForumID]=="yes"&&$TopicStat==3)) {
383 $LastReply = " <br /> ";
384 $glrquery = sql_pre_query("SELECT * FROM \"".$Settings['sqltable']."posts\" WHERE \"TopicID\"=%i ORDER BY \"TimeStamp\" DESC LIMIT 1", array($TopicID));
385 $glrresult=sql_query($glrquery,$SQLStat);
386 $glrnum=sql_num_rows($glrresult);
388 $ReplyID1=sql_result($glrresult,0,"id");
389 $UsersID1=sql_result($glrresult,0,"UserID");
390 $GuestsName1=sql_result($glrresult,0,"GuestName");
391 $TimeStamp1=sql_result($glrresult,0,"TimeStamp");
392 $TimeStamp1=GMTimeChange("F j Y, g:i a",$TimeStamp1,$_SESSION['UserTimeZone'],0,$_SESSION['UserDST']);
393 $PreUsersName1 = GetUserName($UsersID1,$Settings['sqltable'],$SQLStat);
394 if($PreUsersName1['Name']===null) { $UsersID1 = -1;
395 $PreUsersName1 = GetUserName($UsersID1,$Settings['sqltable'],$SQLStat); }
396 $UsersName1 = $PreUsersName1['Name'];
397 $UsersHidden1 = $PreUsersName1['Hidden']; }
398 $NumPages = null; $NumRPosts = $NumReply +
1;
399 if(!isset($Settings['max_posts'])) { $Settings['max_posts'] = 10; }
400 if($NumRPosts>$Settings['max_posts']) {
401 $NumPages = ceil($NumRPosts/$Settings['max_posts']); }
402 if($NumRPosts<=$Settings['max_posts']) { $NumPages = 1; }
403 $Users_Name1 = pre_substr($UsersName1,0,20);
404 if($UsersName1=="Guest") { $UsersName1=$GuestsName1;
405 if($UsersName1==null) { $UsersName1="Guest"; } }
406 if (pre_strlen($UsersName1)>20) { $Users_Name1 = $Users_Name1."...";
407 $oldusername=$UsersName1; $UsersName1=$Users_Name1; } $lul = null;
408 if($TimeStamp1!=null) { $lul = null;
409 if($UsersID1>0&&$UsersHidden1=="no") {
410 $lul = url_maker($exfile['member'],$Settings['file_ext'],"act=view&id=".$UsersID1,$Settings['qstr'],$Settings['qsep'],$prexqstr['member'],$exqstr['member']);
411 $luln = url_maker($exfile['topic'],$Settings['file_ext'],"act=view&id=".$TopicID."&page=".$NumPages,$Settings['qstr'],$Settings['qsep'],$prexqstr['topic'],$exqstr['topic']).$qstrhtml."#reply".$NumRPosts;
412 $LastReply = "Time: <a href=\"".$luln."\">".$TimeStamp1."</a><br />\nUser: <a href=\"".$lul."\" title=\"".$oldusername."\">".$UsersName1."</a>"; }
413 if($UsersID1<=0||
$UsersHidden1=="yes") {
414 if($UsersID1==-1) { $UserPre = "Guest:"; }
415 if(($UsersID1<-1&&$UsersHidden1=="yes")||
$UsersID1==0||
($UsersID1>0&&$UsersHidden1=="yes")) {
416 $UserPre = "Hidden:"; }
417 $lul = url_maker($exfile['index'],$Settings['file_ext'],"act=view",$Settings['qstr'],$Settings['qsep'],$prexqstr['index'],$exqstr['index']);
418 $luln = url_maker($exfile['topic'],$Settings['file_ext'],"act=view&id=".$TopicID."&page=".$NumPages,$Settings['qstr'],$Settings['qsep'],$prexqstr['topic'],$exqstr['topic']).$qstrhtml."#reply".$NumRPosts;
419 $LastReply = "Time: <a href=\"".$luln."\">".$TimeStamp1."</a><br />\n".$UserPre." <span title=\"".$oldusername."\">".$UsersName1."</span>"; } }
420 sql_free_result($glrresult);
421 if($TimeStamp1==null) { $LastReply = " <br /> "; }
422 $PreTopic = $ThemeSet['TopicIcon'];
423 if ($PinnedTopic>0&&$PinnedTopic<3&&$TopicStat==0) {
424 if($NumReply>=$Settings['hot_topic_num']) {
425 $PreTopic=$ThemeSet['HotPinTopic']; }
426 if($NumReply<$Settings['hot_topic_num']) {
427 $PreTopic=$ThemeSet['PinTopic']; } }
428 if ($TopicStat>=0&&$TopicStat<=3&&$PinnedTopic==0) {
429 if($NumReply>=$Settings['hot_topic_num']) {
430 $PreTopic=$ThemeSet['HotClosedTopic']; }
431 if($NumReply<$Settings['hot_topic_num']) {
432 $PreTopic=$ThemeSet['ClosedTopic']; } }
433 if ($PinnedTopic==0&&$TopicStat==0) {
434 if($NumReply>=$Settings['hot_topic_num']) {
435 $PreTopic=$ThemeSet['HotTopic']; }
436 if($NumReply<$Settings['hot_topic_num']) {
437 $PreTopic=$ThemeSet['TopicIcon']; } }
438 if ($PinnedTopic>0&&$PinnedTopic<3&&$TopicStat>=0&&$TopicStat<=3) {
439 if($NumReply>=$Settings['hot_topic_num']) {
440 $PreTopic=$ThemeSet['HotPinClosedTopic']; }
441 if($NumReply<$Settings['hot_topic_num']) {
442 $PreTopic=$ThemeSet['PinClosedTopic']; } }
444 <tr
class="TableRow3" id
="Topic<?php echo $TopicID; ?>">
445 <td
class="TableColumn3"><div
class="topicstate">
446 <?php
echo $PreTopic; ?
></div
></td
>
447 <td
class="TableColumn3"><div
class="topicname">
448 <a href
="<?php echo url_maker($exfile['topic'],$Settings['file_ext'],"act
=view
&id
=".$TopicID,$Settings['qstr'],$Settings['qsep'],$prexqstr['topic'],$exqstr['topic']); ?>"><?php
echo $TopicName; ?
></a
>
449 <?php
if($prepagelist!==null) { echo $prepagelist; } ?
></div
>
450 <div
class="topicdescription"><?php
echo $TopicDescription; ?
></div
></td
>
451 <td
class="TableColumn3" style
="text-align: center;"><?php
454 echo url_maker($exfile['member'],$Settings['file_ext'],"act=view&id=".$UsersID,$Settings['qstr'],$Settings['qsep'],$prexqstr['member'],$exqstr['member']);
455 echo "\">".$UsersName."</a>"; }
457 echo "<span>".$UsersName."</span>"; }
459 <td
class="TableColumn3" style
="text-align: center;"><?php
echo $TheTime; ?
></td
>
460 <td
class="TableColumn3" style
="text-align: center;"><?php
echo $NumReply; ?
></td
>
461 <td
class="TableColumn3"><?php
echo $LastReply; ?
></td
>
465 <tr id
="SearchEnd" class="TableRow4">
466 <td
class="TableColumn4" colspan
="6"> 
;</td
>
469 <?php
if($pagenum>1) { ?
>
470 <div
class="DivSearch"> 
;</div
>
473 //List Page Number Code end
476 <div
class="DivPageLinks"> 
;</div
>
478 sql_free_result($result); } } }
480 <div
class="DivSearch"> 
;</div
>