2||$ThemeSet['ForumStyle']<1) { $ThemeSet['ForumStyle'] = 1; } $checkquery = sql_pre_query("SELECT * FROM \"".$Settings['sqltable']."categories\" WHERE \"id\"=%i".$CatIgnoreList2." LIMIT 1", array($_GET['id'])); $checkresult=sql_query($checkquery,$SQLStat); $checknum=sql_num_rows($checkresult); if($checknum==0) { redirect("location",$rbasedir.url_maker($exfile['index'],$Settings['file_ext'],"act=view",$Settings['qstr'],$Settings['qsep'],$prexqstr['index'],$exqstr['index'],false)); sql_free_result($checkresult); ob_clean(); header("Content-Type: text/plain; charset=".$Settings['charset']); $urlstatus = 302; gzip_page($Settings['use_gzip'],$GZipEncode['Type']); session_write_close(); die(); } if($checknum>=1) { $CategoryID=sql_result($checkresult,0,"id"); $CategoryName=sql_result($checkresult,0,"Name"); $CategoryShow=sql_result($checkresult,0,"ShowCategory"); if($CategoryShow=="no") { $_SESSION['ShowActHidden'] = "yes"; } $CategoryType=sql_result($checkresult,0,"CategoryType"); $InSubCategory=sql_result($checkresult,0,"InSubCategory"); $SubShowForums=sql_result($checkresult,0,"SubShowForums"); $CategoryType = strtolower($CategoryType); $SubShowForums = strtolower($SubShowForums); $SCategoryName = $CategoryName; if(!isset($CatPermissionInfo['CanViewCategory'][$CategoryID])) { $CatPermissionInfo['CanViewCategory'][$CategoryID] = "no"; } if($CatPermissionInfo['CanViewCategory'][$CategoryID]=="no"|| $CatPermissionInfo['CanViewCategory'][$CategoryID]!="yes") { redirect("location",$rbasedir.url_maker($exfile['index'],$Settings['file_ext'],"act=view",$Settings['qstr'],$Settings['qsep'],$prexqstr['index'],$exqstr['index'],false)); ob_clean(); header("Content-Type: text/plain; charset=".$Settings['charset']); $urlstatus = 302; gzip_page($Settings['use_gzip'],$GZipEncode['Type']); session_write_close(); die(); } if($CatPermissionInfo['CanViewCategory'][$CategoryID]=="yes") { if(isset($_SESSION['OldViewingPage'])) { $_SESSION['AncientViewingPage'] = $_SESSION['OldViewingPage']; } else { $_SESSION['AncientViewingPage'] = url_maker(null,"no+ext","act=view","&","=",$prexqstr['index'],$exqstr['index']); } if(isset($_SESSION['OldViewingFile'])) { $_SESSION['AncientViewingFile'] = $_SESSION['OldViewingFile']; } else { if($Settings['file_ext']!="no+ext"&&$Settings['file_ext']!="no ext") { $_SESSION['AncientViewingFile'] = $exfile['index'].$Settings['file_ext']; } if($Settings['file_ext']=="no+ext"||$Settings['file_ext']=="no ext") { $_SESSION['AncientViewingFile'] = $exfile['index']; } } if(isset($_SESSION['OldPreViewingTitle'])) { $_SESSION['AncientPreViewingTitle'] = $_SESSION['OldPreViewingTitle']; } else { $_SESSION['AncientPreViewingTitle'] = "Viewing"; } if(isset($_SESSION['OldViewingTitle'])) { $_SESSION['AncientViewingTitle'] = $_SESSION['OldViewingTitle']; } else { $_SESSION['AncientViewingTitle'] = "Board index"; } if(isset($_SESSION['OldExtraData'])) { $_SESSION['AncientExtraData'] = $_SESSION['OldExtraData']; } else { $_SESSION['AncientExtraData'] = "currentact:view; currentcategoryid:0; currentforumid:0; currenttopicid:0; currentmessageid:0; currenteventid:0; currentmemberid:0;"; } if(isset($_SESSION['ViewingPage'])) { $_SESSION['OldViewingPage'] = $_SESSION['ViewingPage']; } else { $_SESSION['OldViewingPage'] = url_maker(null,"no+ext","act=view","&","=",$prexqstr['index'],$exqstr['index']); } if(isset($_SESSION['ViewingFile'])) { $_SESSION['OldViewingFile'] = $_SESSION['ViewingFile']; } else { if($Settings['file_ext']!="no+ext"&&$Settings['file_ext']!="no ext") { $_SESSION['OldViewingFile'] = $exfile['index'].$Settings['file_ext']; } if($Settings['file_ext']=="no+ext"||$Settings['file_ext']=="no ext") { $_SESSION['OldViewingFile'] = $exfile['index']; } } if(isset($_SESSION['PreViewingTitle'])) { $_SESSION['OldPreViewingTitle'] = $_SESSION['PreViewingTitle']; } else { $_SESSION['OldPreViewingTitle'] = "Viewing"; } if(isset($_SESSION['ViewingTitle'])) { $_SESSION['OldViewingTitle'] = $_SESSION['ViewingTitle']; } else { $_SESSION['OldViewingTitle'] = "Board index"; } if(isset($_SESSION['ExtraData'])) { $_SESSION['OldExtraData'] = $_SESSION['ExtraData']; } else { $_SESSION['OldExtraData'] = "currentact:view; currentcategoryid:0; currentforumid:0; currenttopicid:0; currentmessageid:0; currenteventid:0; currentmemberid:0;"; } $_SESSION['ViewingPage'] = url_maker(null,"no+ext","act=view&id=".$CategoryID,"&","=",$prexqstr[$CategoryType],$exqstr[$CategoryType]); if($Settings['file_ext']!="no+ext"&&$Settings['file_ext']!="no ext") { $_SESSION['ViewingFile'] = $exfile[$CategoryType].$Settings['file_ext']; } if($Settings['file_ext']=="no+ext"||$Settings['file_ext']=="no ext") { $_SESSION['ViewingFile'] = $exfile[$CategoryType]; } $_SESSION['PreViewingTitle'] = "Viewing SubCategory:"; $_SESSION['ViewingTitle'] = $CategoryName; $_SESSION['ExtraData'] = "currentact:".$_GET['act']."; currentcategoryid:".$InSubCategory.",".$CategoryID."; currentforumid:0; currenttopicid:0; currentmessageid:0; currenteventid:0; currentmemberid:0;"; if($InSubCategory!="0") { $iscquery = sql_pre_query("SELECT * FROM \"".$Settings['sqltable']."categories\" WHERE \"id\"=%i".$CatIgnoreList2." LIMIT 1", array($InSubCategory)); $iscresult=sql_query($iscquery,$SQLStat); $iscnum=sql_num_rows($iscresult); if($iscnum>=1) { $iscCategoryID=sql_result($iscresult,0,"id"); $iscCategoryName=sql_result($iscresult,0,"Name"); $iscCategoryShow=sql_result($iscresult,0,"ShowCategory"); $iscCategoryType=sql_result($iscresult,0,"CategoryType"); $iscCategoryType = strtolower($iscCategoryType); } if($iscnum<1) { $InSubCategory = "0"; } sql_free_result($iscresult); } ?> =1) { ?>
">
=1) { while ($apci < $apcnum) { $NumsTopics=sql_result($apcresult,$apci,"NumTopics"); $NumTopics = $NumsTopics + $NumTopics; $NumsPosts=sql_result($apcresult,$apci,"NumPosts"); $NumPosts = $NumsPosts + $NumPosts; $SubsForumID=sql_result($apcresult,$apci,"id"); $SubsForumName=sql_result($apcresult,$apci,"Name"); $SubsForumType=sql_result($apcresult,$apci,"ForumType"); $SubsForumShowTopics=sql_result($result,$i,"CanHaveTopics"); if(isset($PermissionInfo['CanViewForum'][$SubsForumID])&& $PermissionInfo['CanViewForum'][$SubsForumID]=="yes") { $ExStr = ""; if ($SubsForumType!="redirect"&& $SubsForumShowTopics!="no") { $ExStr = "&page=1"; } $sfurl = "".$SubsForumName.""; if($apcl==1) { $sflist = "Subforums:"; $sflist = $sflist." ".$sfurl; } if($apcl>1) { $sflist = $sflist.", ".$sfurl; } $gltf[$apcl] = $SubsForumID; ++$apcl; } ++$apci; } sql_free_result($apcresult); } } $gltf = array(null); $gltf[0] = $ForumID; if ($ForumType=="subforum") { $apcquery = sql_pre_query("SELECT * FROM \"".$Settings['sqltable']."forums\" WHERE \"ShowForum\"='yes' AND \"InSubForum\"=%i".$ForumIgnoreList2." ORDER BY \"OrderID\" ASC, \"id\" ASC", array($ForumID)); $apcresult=sql_query($apcquery,$SQLStat); $apcnum=sql_num_rows($apcresult); $apci=0; $apcl=1; if($apcnum>=1) { while ($apci < $apcnum) { $NumsTopics=sql_result($apcresult,$apci,"NumTopics"); $NumTopics = $NumsTopics + $NumTopics; $NumsPosts=sql_result($apcresult,$apci,"NumPosts"); $NumPosts = $NumsPosts + $NumPosts; $SubsForumID=sql_result($apcresult,$apci,"id"); $SubsForumName=sql_result($apcresult,$apci,"Name"); $SubsForumType=sql_result($apcresult,$apci,"ForumType"); if(isset($PermissionInfo['CanViewForum'][$SubsForumID])&& $PermissionInfo['CanViewForum'][$SubsForumID]=="yes") { $sfurl = "".$SubsForumName.""; if($apcl==1) { $sflist = "Subforums:"; $sflist = $sflist." ".$sfurl; } if($apcl>1) { $sflist = $sflist.", ".$sfurl; } $gltf[$apcl] = $SubsForumID; ++$apcl; } ++$apci; } sql_free_result($apcresult); } } if ($ForumType=="subforum") { $apcquery = sql_pre_query("SELECT * FROM \"".$Settings['sqltable']."forums\" WHERE \"ShowForum\"='yes' AND \"InSubForum\"=%i".$ForumIgnoreList2." ORDER BY \"OrderID\" ASC, \"id\" ASC", array($ForumID)); $apcresult=sql_query($apcquery,$SQLStat); $apcnum=sql_num_rows($apcresult); $apci=0; $apcl=1; if($apcnum>=1) { while ($apci < $apcnum) { $NumsTopics=sql_result($apcresult,$apci,"NumTopics"); $NumTopics = $NumsTopics + $NumTopics; $NumsPosts=sql_result($apcresult,$apci,"NumPosts"); $NumPosts = $NumsPosts + $NumPosts; $SubsForumID=sql_result($apcresult,$apci,"id"); if(isset($PermissionInfo['CanViewForum'][$SubsForumID])&& $PermissionInfo['CanViewForum'][$SubsForumID]=="yes") { $gltf[$apcl] = $SubsForumID; ++$apcl; } ++$apci; } sql_free_result($apcresult); } } if(isset($PermissionInfo['CanViewForum'][$ForumID])&& $PermissionInfo['CanViewForum'][$ForumID]=="yes") { $LastTopic = " 
 
 "; if(!isset($LastTopic)) { $LastTopic = null; } $gltnum = count($gltf); $glti = 0; $OldUpdateTime = 0; $UseThisFonum = null; if ($ForumType=="subforum") { while ($glti < $gltnum) { $ExtraIgnores = null; if($PermissionInfo['CanModForum'][$gltf[$glti]]=="no") { $ExtraIgnores = " AND \"Closed\"<>3"; } $gltfoquery = sql_pre_query("SELECT * FROM \"".$Settings['sqltable']."topics\" WHERE \"ForumID\"=%i".$ExtraIgnores.$ForumIgnoreList4." ORDER BY \"LastUpdate\" DESC LIMIT 1", array($gltf[$glti])); $gltforesult=sql_query($gltfoquery,$SQLStat); $gltfonum=sql_num_rows($gltforesult); if($gltfonum>0) { $NewUpdateTime=sql_result($gltforesult,0,"LastUpdate"); if($NewUpdateTime>$OldUpdateTime) { $UseThisFonum = $gltf[$glti]; $OldUpdateTime = $NewUpdateTime; } sql_free_result($gltforesult); } ++$glti; } if($UseThisFonum==0) { $UseThisFonum = $gltf[0]; } } if ($ForumType!="subforum"&&$ForumType!="redirect") { $UseThisFonum = $gltf[0]; } if ($ForumType!="redirect") { $ExtraIgnores = null; if($PermissionInfo['CanModForum'][$UseThisFonum]=="no") { $ExtraIgnores = " AND \"Closed\"<>3"; } $gltquery = sql_pre_query("SELECT * FROM \"".$Settings['sqltable']."topics\" WHERE (\"ForumID\"=%i".$ExtraIgnores.$ForumIgnoreList4.") OR (\"OldForumID\"=%i".$ExtraIgnores.$ForumIgnoreList4.") ORDER BY \"LastUpdate\" DESC LIMIT 1", array($UseThisFonum,$UseThisFonum)); $gltresult=sql_query($gltquery,$SQLStat); $gltnum=sql_num_rows($gltresult); if($gltnum>0){ $TopicID=sql_result($gltresult,0,"id"); $TopicName=sql_result($gltresult,0,"TopicName"); $NumReplys=sql_result($gltresult,0,"NumReply"); $NumPages = null; $NumRPosts = $NumReplys + 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; } $TopicName1 = pre_substr($TopicName,0,20); $oldtopicname=$TopicName; if (pre_strlen($TopicName)>20) { $TopicName1 = $TopicName1."..."; $TopicName=$TopicName1; } $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){ $ReplyID=sql_result($glrresult,0,"id"); $UsersID=sql_result($glrresult,0,"UserID"); $GuestsName=sql_result($glrresult,0,"GuestName"); $TimeStamp=sql_result($glrresult,0,"TimeStamp"); $tmpusrcurtime = new DateTime(); $tmpusrcurtime->setTimestamp($TimeStamp); $tmpusrcurtime->setTimezone($usertz); $TimeStamp=$tmpusrcurtime->format($_SESSION['iDBDateFormat'].", ".$_SESSION['iDBTimeFormat']); sql_free_result($glrresult); } $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"; } } $UsersName1 = pre_substr($UsersName,0,20); $oldusername=$UsersName; if (pre_strlen($UsersName)>20) { $UsersName1 = $UsersName1."..."; $UsersName=$UsersName1; } $lul = null; if($UsersID>0&&$UsersHidden=="no") { $lul = url_maker($exfile['member'],$Settings['file_ext'],"act=view&id=".$UsersID,$Settings['qstr'],$Settings['qsep'],$prexqstr['member'],$exqstr['member']); $LastTopic = $TimeStamp."
\nTopic: ".$TopicName."
\nUser: ".$UsersName.""; } if($UsersID<=0||$UsersHidden=="yes") { if($UsersID==-1) { $UserPre = "Guest:"; } if(($UsersID<-1&&$UsersHidden=="yes")||$UsersID==0||($UsersID>0&&$UsersHidden=="yes")) { $UserPre = "Hidden:"; } $LastTopic = $TimeStamp."
\nTopic: ".$TopicName."
\n".$UserPre." ".$UsersName.""; } } if($LastTopic==null) { $LastTopic = " 
 
 "; } sql_free_result($gltresult); } if ($ForumType=="redirect") { $LastTopic=" 
Redirects: ".$NumRedirects."
 "; } $PreForum = $ThemeSet['ForumIcon']; if ($ForumType=="forum") { $PreForum=$ThemeSet['ForumIcon']; } if ($ForumType=="subforum") { $PreForum=$ThemeSet['SubForumIcon']; } if ($ForumType=="redirect") { $PreForum=$ThemeSet['RedirectIcon']; } $ExStr = ""; if ($ForumType!="redirect"&& $ForumShowTopics!="no") { $ExStr = "&page=1"; } if($ThemeSet['ForumStyle']==1) { $ForumClass[1] = " class=\"TableColumn3\" "; $ForumClass[2] = " class=\"TableColumn3\" "; $ForumClass[3] = " class=\"TableColumn3\" "; $ForumClass[4] = " class=\"TableColumn3\" "; $ForumClass[5] = " class=\"TableColumn3\" "; } if($ThemeSet['ForumStyle']==2) { $ForumClass[1] = " class=\"TableColumn3\" "; $ForumClass[2] = " class=\"TableColumn3\" "; $ForumClass[3] = " class=\"TableColumn3Alt\" "; $ForumClass[4] = " class=\"TableColumn3Alt\" "; $ForumClass[5] = " class=\"TableColumn3Alt\" "; } ?> >
>

style="text-align: center;"> style="text-align: center;"> >
=1) { ?>
">
  Forum Topics Posts Last Topic