">">Search topics
 
">Topic Search
">Topic Search
 Search for topic:
">
 
="25") { $_GET['msearch'] = null; } if(isset($_GET['msearch'])&&$_GET['msearch']!=null) { $_GET['memid'] = null; $memsiquery = sql_pre_query("SELECT * FROM \"".$Settings['sqltable']."members\" WHERE \"Name\"='%s' LIMIT 1", array($_GET['msearch'])); $memsiresult=sql_query($memsiquery,$SQLStat); $memsinum=sql_num_rows($memsiresult); $memsi=0; if($memsinum==0) { $memsid = -1; } if($memsinum!=0) { $memsid=sql_result($memsiresult,$memsi,"id"); sql_free_result($memsiresult); } } if(!isset($_GET['memid'])) { $_GET['memid'] = null; } if(!is_numeric($_GET['memid'])||$_GET['memid']<1) { $_GET['memid'] = null; } if($_GET['memid']!=null&&is_numeric($_GET['memid'])) { $memnamea = GetUserName($_GET['memid'],$Settings['sqltable']); if($memnamea['Hidden']=="no") { $_GET['msearch'] = $memnamea['Name']; $memsid = $_GET['memid']; } if($memnamea['Hidden']=="yes") { $_GET['msearch'] = null; $_GET['memid'] = null; $memsid = null; } } //Get SQL LIMIT Number $nums = $_GET['page'] * $Settings['max_topics']; $PageLimit = $nums - $Settings['max_topics']; if($PageLimit<0) { $PageLimit = 0; } if($_GET['msearch']==null) { if($_GET['type']=="normal") { $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'])); $rnquery = sql_pre_query("SELECT COUNT(*) FROM \"".$Settings['sqltable']."topics\" WHERE \"TopicName\"='%s'".$ForumIgnoreList4."", array($_GET['search'])); } if($_GET['type']=="wildcard") { $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'])); $rnquery = sql_pre_query("SELECT COUNT(*) FROM \"".$Settings['sqltable']."topics\" WHERE \"TopicName\" LIKE '%s'".$ForumIgnoreList4."", array($_GET['search'])); } } if($_GET['msearch']!=null) { if($_GET['type']=="normal") { $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'])); $rnquery = sql_pre_query("SELECT COUNT(*) FROM \"".$Settings['sqltable']."topics\" WHERE \"TopicName\"='%s' AND \"UserID\"=%i".$ForumIgnoreList4."", array($_GET['search'])); if($memsid==-1) { $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'])); $rnquery = sql_pre_query("SELECT COUNT(*) FROM \"".$Settings['sqltable']."topics\" WHERE \"TopicName\"='%s' AND \"GuestName\"='%s'".$ForumIgnoreList4."", array($_GET['search'],$_GET['msearch'])); } } if($_GET['type']=="wildcard") { $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'])); $rnquery = sql_pre_query("SELECT COUNT(*) FROM \"".$Settings['sqltable']."topics\" WHERE \"TopicName\" LIKE '%s' AND \"UserID\"=%i".$ForumIgnoreList4."", array($_GET['search'],$_GET['msearch'])); if($memsid==-1) { $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'])); $rnquery = sql_pre_query("SELECT COUNT(*) FROM \"".$Settings['sqltable']."topics\" WHERE \"TopicName\" LIKE '%s' AND \"GuestName\"='%s'".$ForumIgnoreList4."", array($_GET['search'],$_GET['msearch'])); } } } if($_GET['type']=="getactive") { $active_month = $usercurtime->format("m"); $active_day = $usercurtime->format("d"); $active_year = $usercurtime->format("Y"); $active_start = mktime(0,0,0,$active_month,$active_day,$active_year); $active_end = mktime(23,59,59,$active_month,$active_day,$active_year); $query = sql_pre_query("SELECT * FROM \"".$Settings['sqltable']."topics\" WHERE (\"TimeStamp\">=%i AND \"TimeStamp\"<=%i) OR (\"LastUpdate\">=%i AND \"LastUpdate\"<=%i)".$ForumIgnoreList4." ORDER BY \"LastUpdate\" DESC ".$SQLimit, array($active_start,$active_end,$active_start,$active_end,$PageLimit,$Settings['max_topics'])); $rnquery = sql_pre_query("SELECT COUNT(*) FROM \"".$Settings['sqltable']."topics\" WHERE (\"TimeStamp\">=%i AND \"TimeStamp\"<=%i) OR (\"LastUpdate\">=%i AND \"LastUpdate\"<=%i)".$ForumIgnoreList4."", array($active_start,$active_end,$active_start,$active_end)); } $result=sql_query($query,$SQLStat); $rnresult=sql_query($rnquery,$SQLStat); $NumberTopics = sql_result($rnresult,0); sql_free_result($rnresult); if($NumberTopics==null) { $NumberTopics = 0; } $num = $NumberTopics; //Start Topic Page Code if(!isset($Settings['max_topics'])) { $Settings['max_topics'] = 10; } if($_GET['page']==null) { $_GET['page'] = 1; } if($_GET['page']<=0) { $_GET['page'] = 1; } $nums = $_GET['page'] * $Settings['max_topics']; if($nums>$num) { $nums = $num; } $numz = $nums - $Settings['max_topics']; if($numz<=0) { $numz = 0; } //$i=$numz; if($nums<$num) { $nextpage = $_GET['page'] + 1; } if($nums>=$num) { $nextpage = $_GET['page']; } if($numz>=$Settings['max_topics']) { $backpage = $_GET['page'] - 1; } if($_GET['page']<=1) { $backpage = 1; } $pnum = $num; $l = 1; $Pages = null; while ($pnum>0) { if($pnum>=$Settings['max_topics']) { $pnum = $pnum - $Settings['max_topics']; $Pages[$l] = $l; ++$l; } if($pnum<$Settings['max_topics']&&$pnum>0) { $pnum = $pnum - $pnum; $Pages[$l] = $l; ++$l; } } //End Topic Page Code $num=sql_num_rows($result); if($num<=0) { redirect("location",$rbasedir.url_maker($exfile['search'],$Settings['file_ext'],"act=topics",$Settings['qstr'],$Settings['qsep'],$prexqstr['search'],$exqstr['search'],false)); header("Content-Type: text/plain; charset=".$Settings['charset']); $urlstatus = 302; ob_clean(); echo "Sorry could not find any search results."; sql_free_result($result); gzip_page($Settings['use_gzip'],$GZipEncode['Type']); session_write_close(); die(); } $i=0; //List Page Number Code Start $pagenum=count($Pages); if($_GET['page']>$pagenum) { $_GET['page'] = $pagenum; } $pagei=0; $pstring = null; if($pagenum>1) { $pstring = "
".$pagenum." Pages: "; } if($_GET['page']<4) { $Pagez[0] = null; } if($_GET['page']>=4) { $Pagez[0] = "First"; } if($_GET['page']>=3) { $Pagez[1] = $_GET['page'] - 2; } if($_GET['page']<3) { $Pagez[1] = null; } if($_GET['page']>=2) { $Pagez[2] = $_GET['page'] - 1; } if($_GET['page']<2) { $Pagez[2] = null; } $Pagez[3] = $_GET['page']; if($_GET['page']<$pagenum) { $Pagez[4] = $_GET['page'] + 1; } if($_GET['page']>=$pagenum) { $Pagez[4] = null; } $pagenext = $_GET['page'] + 1; if($pagenext<$pagenum) { $Pagez[5] = $_GET['page'] + 2; } if($pagenext>=$pagenum) { $Pagez[5] = null; } if($_GET['page']<$pagenum) { $Pagez[6] = "Last"; } if($_GET['page']>=$pagenum) { $Pagez[6] = null; } $pagenumi=count($Pagez); if($num==0) { $pagenumi = 0; if($_GET['msearch']==null) { $pstring = null; } if($_GET['msearch']!=null) { $pstring = null; } } if($pagenum>1) { while ($pagei < $pagenumi) { if($_GET['msearch']==null) { if($_GET['page']!=1&&$pagei==1) { $Pback = $_GET['page'] - 1; $pstring = $pstring."< "; } } if($_GET['msearch']!=null) { if($_GET['page']!=1&&$pagei==1) { $Pback = $_GET['page'] - 1; $pstring = $pstring."< "; } } if($Pagez[$pagei]!=null&& $Pagez[$pagei]!="First"&& $Pagez[$pagei]!="Last") { if($_GET['msearch']==null) { if($pagei!=3) { $pstring = $pstring."".$Pagez[$pagei]." "; } if($pagei==3) { $pstring = $pstring."".$Pagez[$pagei]." "; } } if($_GET['msearch']!=null) { if($pagei!=3) { $pstring = $pstring."".$Pagez[$pagei]." "; } if($pagei==3) { $pstring = $pstring."".$Pagez[$pagei]." "; } } } if($Pagez[$pagei]=="First") { if($_GET['msearch']==null) { $pstring = $pstring."« "; } if($_GET['msearch']!=null) { $pstring = $pstring."« "; } } if($Pagez[$pagei]=="Last") { if($_GET['msearch']==null) { $ptestnext = $pagenext + 1; $paget = $pagei - 1; $Pnext = $_GET['page'] + 1; $pstring = $pstring."> "; if($ptestnext<$pagenum) { $pstring = $pstring."» "; } } if($_GET['msearch']!=null) { $ptestnext = $pagenext + 1; $paget = $pagei - 1; $Pnext = $_GET['page'] + 1; $pstring = $pstring."> "; if($ptestnext<$pagenum) { $pstring = $pstring."» "; } } } ++$pagei; } $pstring = $pstring."
"; } ?>
">">Search topics
 
1) { ?>
 
">Searching for ">Searching for by ">Todays Active Topics
0) { $HotTopicPosts = sql_result($preresult,0,"HotTopicPosts"); } sql_free_result($preresult); if($HotTopicPosts!=0&&is_numeric($HotTopicPosts)) { $Settings['hot_topic_num'] = $HotTopicPosts; } if(!is_numeric($Settings['hot_topic_num'])) { $Settings['hot_topic_num'] = 15; } $CategoryID=sql_result($result,$i,"CategoryID"); $UsersID=sql_result($result,$i,"UserID"); $GuestsName=sql_result($result,$i,"GuestName"); $TheTime=sql_result($result,$i,"TimeStamp"); $tmpusrcurtime = new DateTime(); $tmpusrcurtime->setTimestamp($TheTime); $tmpusrcurtime->setTimezone($usertz); $TheTime=$tmpusrcurtime->format($_SESSION['iDBDateFormat'].", ".$_SESSION['iDBTimeFormat']); $NumReply=sql_result($result,$i,"NumReply"); $NumberPosts=$NumReply + 1; $prepagelist = null; if(!isset($Settings['max_posts'])) { $Settings['max_posts'] = 10; } if(!isset($ThemeSet['MiniPageAltStyle'])) { $ThemeSet['MiniPageAltStyle'] = "off"; } if($ThemeSet['MiniPageAltStyle']!="on"&& $ThemeSet['MiniPageAltStyle']!="off") { $ThemeSet['MiniPageAltStyle'] = "off"; } if($NumberPosts>$Settings['max_posts']) { $NumberPages = ceil($NumberPosts/$Settings['max_posts']); } if($NumberPosts<=$Settings['max_posts']) { $NumberPages = 1; } if($NumberPages>4) { $prepagelist = "  "; } if($NumberPages>=2) { if($ThemeSet['MiniPageAltStyle']=="off") { $prepagelist = "(Pages: "; } if($ThemeSet['MiniPageAltStyle']=="on") { $prepagelist = $prepagelist.""; } $prepagelist = $prepagelist."1"; if($ThemeSet['MiniPageAltStyle']=="on") { $prepagelist = $prepagelist.""; } if($ThemeSet['MiniPageAltStyle']=="off") { $prepagelist = $prepagelist." "; } if($ThemeSet['MiniPageAltStyle']=="on") { $prepagelist = $prepagelist.""; } $prepagelist = $prepagelist."2"; if($ThemeSet['MiniPageAltStyle']=="on") { $prepagelist = $prepagelist.""; } if($NumberPages>=3) { if($ThemeSet['MiniPageAltStyle']=="off") { $prepagelist = $prepagelist." "; } if($ThemeSet['MiniPageAltStyle']=="on") { $prepagelist = $prepagelist.""; } $prepagelist = $prepagelist."3"; if($ThemeSet['MiniPageAltStyle']=="on") { $prepagelist = $prepagelist.""; } } if($NumberPages==4) { if($ThemeSet['MiniPageAltStyle']=="off") { $prepagelist = $prepagelist." "; } if($ThemeSet['MiniPageAltStyle']=="on") { $prepagelist = $prepagelist.""; } if($ThemeSet['MiniPageAltStyle']=="on") { $prepagelist = $prepagelist."4"; } if($ThemeSet['MiniPageAltStyle']=="off") { $prepagelist = $prepagelist." ...4"; } if($ThemeSet['MiniPageAltStyle']=="on") { $prepagelist = $prepagelist.""; } } if($NumberPages>4) { if($ThemeSet['MiniPageAltStyle']=="off") { $prepagelist = $prepagelist." "; } if($ThemeSet['MiniPageAltStyle']=="on") { $prepagelist = $prepagelist.""; } if($ThemeSet['MiniPageAltStyle']=="on") { $prepagelist = $prepagelist."» ".$NumberPages.""; } if($ThemeSet['MiniPageAltStyle']=="off") { $prepagelist = $prepagelist." ...".$NumberPages.""; } if($ThemeSet['MiniPageAltStyle']=="on") { $prepagelist = $prepagelist.""; } } if($ThemeSet['MiniPageAltStyle']=="off") { $prepagelist = $prepagelist.")"; } } $TopicName=sql_result($result,$i,"TopicName"); $TopicDescription=sql_result($result,$i,"Description"); $PinnedTopic=sql_result($result,$i,"Pinned"); if ($PinnedTopic>2) { $PinnedTopic = 1; } if ($PinnedTopic<0) { $PinnedTopic = 0; } if(!is_numeric($PinnedTopic)) { $PinnedTopic = 0; } $TopicStat=sql_result($result,$i,"Closed"); if ($TopicStat>3) { $TopicStat = 1; } if ($TopicStat<0) { $TopicStat = 0; } if(!is_numeric($TopicStat)) { $TopicStat = 1; } $PreUsersName = GetUserName($UsersID,$Settings['sqltable'],$SQLStat); if($PreUsersName['Name']===null) { $UsersID = -1; $PreUsersName = GetUserName($UsersID,$Settings['sqltable'],$SQLStat); } $UsersName = $PreUsersName['Name']; $UsersHidden = $PreUsersName['Hidden']; if($UsersName=="Guest") { $UsersName=$GuestsName; if($UsersName==null) { $UsersName="Guest"; } } if(($PermissionInfo['CanViewForum'][$ForumID]=="yes"&& $CatPermissionInfo['CanViewCategory'][$CategoryID]=="yes"&& $TopicStat>=0&&$TopicStat<3)|| ($PermissionInfo['CanViewForum'][$ForumID]=="yes"&& $CatPermissionInfo['CanViewCategory'][$CategoryID]=="yes"&& $PermissionInfo['CanModForum'][$ForumID]=="yes"&&$TopicStat==3)) { $LastReply = " 
 "; $glrquery = sql_pre_query("SELECT * FROM \"".$Settings['sqltable']."posts\" WHERE \"TopicID\"=%i ORDER BY \"TimeStamp\" DESC LIMIT 1", array($TopicID)); $glrresult=sql_query($glrquery,$SQLStat); $glrnum=sql_num_rows($glrresult); if($glrnum>0){ $ReplyID1=sql_result($glrresult,0,"id"); $UsersID1=sql_result($glrresult,0,"UserID"); $GuestsName1=sql_result($glrresult,0,"GuestName"); $TimeStamp1=sql_result($glrresult,0,"TimeStamp"); $tmpusrcurtime = new DateTime(); $tmpusrcurtime->setTimestamp($TimeStamp1); $tmpusrcurtime->setTimezone($usertz); $TimeStamp1=$tmpusrcurtime->format($_SESSION['iDBDateFormat'].", ".$_SESSION['iDBTimeFormat']); $PreUsersName1 = GetUserName($UsersID1,$Settings['sqltable'],$SQLStat); if($PreUsersName1['Name']===null) { $UsersID1 = -1; $PreUsersName1 = GetUserName($UsersID1,$Settings['sqltable'],$SQLStat); } $UsersName1 = $PreUsersName1['Name']; $UsersHidden1 = $PreUsersName1['Hidden']; } $NumPages = null; $NumRPosts = $NumReply + 1; if(!isset($Settings['max_posts'])) { $Settings['max_posts'] = 10; } if($NumRPosts>$Settings['max_posts']) { $NumPages = ceil($NumRPosts/$Settings['max_posts']); } if($NumRPosts<=$Settings['max_posts']) { $NumPages = 1; } $Users_Name1 = pre_substr($UsersName1,0,20); if($UsersName1=="Guest") { $UsersName1=$GuestsName1; if($UsersName1==null) { $UsersName1="Guest"; } } if (pre_strlen($UsersName1)>20) { $Users_Name1 = $Users_Name1."..."; $oldusername=$UsersName1; $UsersName1=$Users_Name1; } $lul = null; if($TimeStamp1!=null) { $lul = null; if($UsersID1>0&&$UsersHidden1=="no") { $lul = url_maker($exfile['member'],$Settings['file_ext'],"act=view&id=".$UsersID1,$Settings['qstr'],$Settings['qsep'],$prexqstr['member'],$exqstr['member']); $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; $LastReply = "Time: ".$TimeStamp1."
\nUser: ".$UsersName1.""; } if($UsersID1<=0||$UsersHidden1=="yes") { if($UsersID1==-1) { $UserPre = "Guest:"; } if(($UsersID1<-1&&$UsersHidden1=="yes")||$UsersID1==0||($UsersID1>0&&$UsersHidden1=="yes")) { $UserPre = "Hidden:"; } $lul = url_maker($exfile['index'],$Settings['file_ext'],"act=view",$Settings['qstr'],$Settings['qsep'],$prexqstr['index'],$exqstr['index']); $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; $LastReply = "Time: ".$TimeStamp1."
\n".$UserPre." ".$UsersName1.""; } } sql_free_result($glrresult); if($TimeStamp1==null) { $LastReply = " 
 "; } $PreTopic = $ThemeSet['TopicIcon']; if ($PinnedTopic>0&&$PinnedTopic<3&&$TopicStat==0) { if($NumReply>=$Settings['hot_topic_num']) { $PreTopic=$ThemeSet['HotPinTopic']; } if($NumReply<$Settings['hot_topic_num']) { $PreTopic=$ThemeSet['PinTopic']; } } if ($TopicStat>=0&&$TopicStat<=3&&$PinnedTopic==0) { if($NumReply>=$Settings['hot_topic_num']) { $PreTopic=$ThemeSet['HotClosedTopic']; } if($NumReply<$Settings['hot_topic_num']) { $PreTopic=$ThemeSet['ClosedTopic']; } } if ($PinnedTopic==0&&$TopicStat==0) { if($NumReply>=$Settings['hot_topic_num']) { $PreTopic=$ThemeSet['HotTopic']; } if($NumReply<$Settings['hot_topic_num']) { $PreTopic=$ThemeSet['TopicIcon']; } } if ($PinnedTopic>0&&$PinnedTopic<3&&$TopicStat>=0&&$TopicStat<=3) { if($NumReply>=$Settings['hot_topic_num']) { $PreTopic=$ThemeSet['HotPinClosedTopic']; } if($NumReply<$Settings['hot_topic_num']) { $PreTopic=$ThemeSet['PinClosedTopic']; } } ?>
">Searching for ">Searching for by ">Todays Active Topics
State Topic Name Author Time Replys Last Reply
">
0) { echo "".$UsersName.""; } if($UsersID<=0) { echo "".$UsersName.""; } ?>
 
1) { ?>
 
1) { ?>