OSDN Git Service

Another small update.
[idb/iDB.git.git] / inc / categories.php
index a4073df..74dc9bb 100644 (file)
-<?php\r
-/*\r
-    This program is free software; you can redistribute it and/or modify\r
-    it under the terms of the Revised BSD License.\r
-\r
-    This program is distributed in the hope that it will be useful,\r
-    but WITHOUT ANY WARRANTY; without even the implied warranty of\r
-    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the\r
-    Revised BSD License for more details.\r
-\r
-    Copyright 2004-2007 Cool Dude 2k - http://intdb.sourceforge.net/\r
-    Copyright 2004-2007 Game Maker 2k - http://upload.idb.s1.jcink.com/\r
-\r
-    $FileInfo: categories.php - Last Update: 05/24/2007 SVN 13 - Author: cooldude2k $\r
-*/\r
-$File1Name = dirname($_SERVER['SCRIPT_NAME'])."/";\r
-$File2Name = $_SERVER['SCRIPT_NAME'];\r
-$File3Name=str_replace($File1Name, null, $File2Name);\r
-if ($File3Name=="categories.php"||$File3Name=="/categories.php") {\r
-       require('index.php');\r
-       exit(); }\r
-$prequery = query("select * from ".$Settings['sqltable']."categories where ID=%i and ShowCategory='yes'", array($_GET['id']));\r
-$preresult=mysql_query($prequery);\r
-$prenum=mysql_num_rows($preresult);\r
-$prei=0;\r
-if($prenum==0) { redirect("location",$basedir.url_maker($exfile['index'],$Settings['file_ext'],"act=view",$Settings['qstr'],$Settings['qsep'],$prexqstr['index'],$exqstr['index'],false)); }\r
-while ($prei < $prenum) {\r
-$CategoryID=mysql_result($preresult,$prei,"id");\r
-$CategoryName=mysql_result($preresult,$prei,"Name");\r
-$CategoryShow=mysql_result($preresult,$prei,"ShowCategory");\r
-$CategoryType=mysql_result($preresult,$prei,"CategoryType");\r
-$SubShowForums=mysql_result($preresult,$prei,"SubShowForums");\r
-$CategoryDescription=mysql_result($preresult,$prei,"Description");\r
-$CategoryType = strtolower($CategoryType); $SubShowForums = strtolower($SubShowForums);\r
-if($CatCheck!="skip") {\r
-if($CategoryType=="subcategory") {\r
-redirect("location",$basedir.url_maker($exfile['subcategory'],$Settings['file_ext'],"act=".$_GET['act']."&id=".$_GET['id'],$Settings['qstr'],$Settings['qsep'],$prexqstr['subcategory'],$exqstr['subcategory'],FALSE)); } }\r
-$query = query("select * from ".$Settings['sqltable']."forums where ShowForum='yes' and CategoryID=%i and InSubForum=0 ORDER BY ID", array($CategoryID));\r
-$result=mysql_query($query);\r
-$num=mysql_num_rows($result);\r
-$i=0;\r
-if($num>=1) {\r
-?>\r
-<div class="Table1Border">\r
-<table id="Cat<?php echo $CategoryID; ?>" class="Table1">\r
-<tr id="CatStart<?php echo $CategoryID; ?>" class="TableRow1">\r
-<td class="TableRow1" colspan="5"><span style="float: left;">\r
-<?php echo $ThemeSet['TitleIcon'] ?><a href="<?php echo url_maker($exfile[$CategoryType],$Settings['file_ext'],"act=view&id=".$CategoryID,$Settings['qstr'],$Settings['qsep'],$prexqstr[$CategoryType],$exqstr[$CategoryType]); ?>""><?php echo $CategoryName; ?></a></span>\r
-<?php echo "<span style=\"float: right;\">&nbsp;</span>"; ?></td>\r
-</tr>\r
-<tr id="ForumStatRow<?php echo $CategoryID; ?>" class="TableRow2">\r
-<th class="TableRow2" style="width: 4%;">&nbsp;</th>\r
-<th class="TableRow2" style="width: 58%;">Forum</th>\r
-<th class="TableRow2" style="width: 7%;">Topics</th>\r
-<th class="TableRow2" style="width: 7%;">Posts</th>\r
-<th class="TableRow2" style="width: 24%;">Last Topic</th>\r
-</tr>\r
-<?php }\r
-while ($i < $num) {\r
-$ForumID=mysql_result($result,$i,"id");\r
-$ForumName=mysql_result($result,$i,"Name");\r
-$ForumShow=mysql_result($result,$i,"ShowForum");\r
-$ForumType=mysql_result($result,$i,"ForumType");\r
-$NumTopics=mysql_result($result,$i,"NumTopics");\r
-$NumPosts=mysql_result($result,$i,"NumPosts");\r
-$ForumDescription=mysql_result($result,$i,"Description");\r
-unset($LastTopic);\r
-$gltquery = query("select * from ".$Settings['sqltable']."topics where (CategoryID=%i and ForumID=%i) ORDER BY LastUpdate DESC", array($CategoryID,$ForumID));\r
-$gltresult=mysql_query($gltquery);\r
-$gltnum=mysql_num_rows($gltresult);\r
-if($gltnum>0){\r
-$TopicID=mysql_result($gltresult,0,"id");\r
-$TopicName=mysql_result($gltresult,0,"TopicName");\r
-$NumReplys=mysql_result($gltresult,0,"NumReply");\r
-$ShowReply = $NumReplys + 1;\r
-$TopicName1 = substr($TopicName,0,15);\r
-if (strlen($TopicName)>12) { $TopicName1 = $TopicName1."..."; }\r
-$UsersID=mysql_result($gltresult,0,"UserID");\r
-$GuestName=mysql_result($gltresult,0,"GuestName");\r
-$UsersName = GetUserName($UsersID,$Settings['sqltable']);\r
-if($UsersName=="Guest") { $UsersName=$GuestName;\r
-if($UsersName==null) { $UsersName="Guest"; } }\r
-$UsersName1 = substr($UsersName,0,18);\r
-if (strlen($UsersName)>15) { $UsersName1 = $UsersName1."...";\r
-$oldtopicname=$TopicName; $oldusername=$UsersName;\r
-$TopicName=$TopicName1; $UsersName=$UsersName1; } $lul = null;\r
-if($UsersID!="-1") {\r
-$lul = url_maker($exfile['member'],$Settings['file_ext'],"act=view&id=".$UsersID,$Settings['qstr'],$Settings['qsep'],$prexqstr['member'],$exqstr['member']); }\r
-if($UsersID=="-1") {\r
-$lul = url_maker($exfile['index'],$Settings['file_ext'],"act=view",$Settings['qstr'],$Settings['qsep'],$prexqstr['index'],$exqstr['index']); }\r
-$LastTopic = "User: <a href=\"".$lul."\" title=\"".$oldusername."\">".$UsersName."</a><br />\nTopic: <a href=\"".url_maker($exfile['topic'],$Settings['file_ext'],"act=view&id=".$TopicID,$Settings['qstr'],$Settings['qsep'],$prexqstr['topic'],$exqstr['topic'])."#post".$ShowReply."\" title=\"".$oldtopicname."\">".$TopicName."</a>"; }\r
-@mysql_free_result($gltresult);\r
-$ForumType = strtolower($ForumType);\r
-if ($ForumType=="forum") {\r
-       $PreForum=$ThemeSet['ForumIcon']; }\r
-if ($ForumType=="subforum") {\r
-       $PreForum=$ThemeSet['SubForumIcon']; }\r
-if ($ForumType=="subforum") {\r
-       $PreForum=$ThemeSet['SubForumIcon']; }\r
-if ($ForumType=="redirect") {\r
-       $PreForum=$ThemeSet['RedirectIcon']; }\r
-?>\r
-<tr class="TableRow3" id="Forum<?php echo $ForumID; ?>">\r
-<td class="TableRow3"><div class="forumicon">\r
-<?php echo $PreForum; ?></div></td>\r
-<td class="TableRow3"><div class="forumname"><a href="<?php echo url_maker($exfile[$ForumType],$Settings['file_ext'],"act=view&id=".$ForumID,$Settings['qstr'],$Settings['qsep'],$prexqstr[$ForumType],$exqstr[$ForumType]); ?>"><?php echo $ForumName; ?></a></div>\r
-<div class="forumescription"><?php echo $ForumDescription; ?></div></td>\r
-<td class="TableRow3" style="text-align: center;"><?php echo $NumTopics; ?></td>\r
-<td class="TableRow3" style="text-align: center;"><?php echo $NumPosts; ?></td>\r
-<td class="TableRow3"><?php echo $LastTopic; ?></td>\r
-</tr>\r
-<?php\r
-++$i; } @mysql_free_result($result);\r
-if($num>=1) { ?>\r
-<tr id="CatEnd<?php echo $CategoryID; ?>" class="TableRow4">\r
-<td class="TableRow4" colspan="5">&nbsp;</td>\r
-</tr>\r
-</table></div>\r
-<div>&nbsp;</div>\r
-<?php } ++$prei; }\r
-@mysql_free_result($preresult); ?>\r
+<?php
+/*
+    This program is free software; you can redistribute it and/or modify
+    it under the terms of the Revised BSD License.
+
+    This program is distributed in the hope that it will be useful,
+    but WITHOUT ANY WARRANTY; without even the implied warranty of
+    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+    Revised BSD License for more details.
+
+    Copyright 2004-2008 Cool Dude 2k - http://idb.berlios.de/
+    Copyright 2004-2008 Game Maker 2k - http://intdb.sourceforge.net/
+
+    $FileInfo: categories.php - Last Update: 12/12/2008 SVN 215 - Author: cooldude2k $
+*/
+$File3Name = basename($_SERVER['SCRIPT_NAME']);
+if ($File3Name=="categories.php"||$File3Name=="/categories.php") {
+       require('index.php');
+       exit(); }
+if(!is_numeric($_GET['id'])) { $_GET['id'] = null; }
+$prequery = query("SELECT * FROM `".$Settings['sqltable']."categories` WHERE `id`=%i LIMIT 1", array($_GET['id']));
+$preresult=mysql_query($prequery);
+$prenum=mysql_num_rows($preresult);
+if($prenum==0) { redirect("location",$basedir.url_maker($exfile['index'],$Settings['file_ext'],"act=view",$Settings['qstr'],$Settings['qsep'],$prexqstr['index'],$exqstr['index'],false)); @mysql_free_result($preresult);
+ob_clean(); @header("Content-Type: text/plain; charset=".$Settings['charset']);
+gzip_page($Settings['use_gzip'],$GZipEncode['Type']); @mysql_close(); die(); }
+if($prenum>=1) {
+$CategoryID=mysql_result($preresult,0,"id");
+$CategoryName=mysql_result($preresult,0,"Name");
+$CategoryShow=mysql_result($preresult,0,"ShowCategory");
+$CategoryType=mysql_result($preresult,0,"CategoryType");
+$SubShowForums=mysql_result($preresult,0,"SubShowForums");
+$CategoryDescription=mysql_result($preresult,0,"Description");
+$CategoryType = strtolower($CategoryType); $SubShowForums = strtolower($SubShowForums);
+$CategoryPostCountView=mysql_result($preresult,0,"PostCountView");
+$CategoryKarmaCountView=mysql_result($preresult,0,"KarmaCountView");
+if($MyPostCountChk==null) { $MyPostCountChk = 0; }
+if($MyKarmaCount==null) { $MyKarmaCount = 0; }
+if($GroupInfo['HasAdminCP']!="yes"||$GroupInfo['HasModCP']!="yes") {
+if($CategoryPostCountView!=0&&$MyPostCountChk<$CategoryPostCountView) {
+redirect("location",$basedir.url_maker($exfile['index'],$Settings['file_ext'],"act=view",$Settings['qstr'],$Settings['qsep'],$prexqstr['index'],$exqstr['index'],false)); }
+if($CategoryKarmaCountView!=0&&$MyKarmaCount<$CategoryKarmaCountView) {
+redirect("location",$basedir.url_maker($exfile['index'],$Settings['file_ext'],"act=view",$Settings['qstr'],$Settings['qsep'],$prexqstr['index'],$exqstr['index'],false)); } }
+if(!isset($CatPermissionInfo['CanViewCategory'][$CategoryID])) {
+       $CatPermissionInfo['CanViewCategory'][$CategoryID] = "no"; }
+if($CatPermissionInfo['CanViewCategory'][$CategoryID]=="no"||
+       $CatPermissionInfo['CanViewCategory'][$CategoryID]!="yes") {
+redirect("location",$basedir.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']);
+gzip_page($Settings['use_gzip'],$GZipEncode['Type']); @mysql_close(); die(); }
+if($CatPermissionInfo['CanViewCategory'][$CategoryID]=="yes") {
+if(!isset($CatCheck)) { $CatCheck = null; } 
+if($CatCheck!="skip") {
+?>
+<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[$CategoryType],$Settings['file_ext'],"act=view&id=".$CategoryID,$Settings['qstr'],$Settings['qsep'],$prexqstr[$CategoryType],$exqstr[$CategoryType]); ?>"><?php echo $CategoryName; ?></a></div>
+<div class="DivNavLinks">&nbsp;</div>
+<?php
+if($CategoryType=="subcategory") {
+redirect("location",$basedir.url_maker($exfile['subcategory'],$Settings['file_ext'],"act=".$_GET['act']."&id=".$_GET['id'],$Settings['qstr'],$Settings['qsep'],$prexqstr['subcategory'],$exqstr['subcategory'],FALSE));
+ob_clean(); @header("Content-Type: text/plain; charset=".$Settings['charset']);
+gzip_page($Settings['use_gzip'],$GZipEncode['Type']); @mysql_close(); die(); } }
+$query = query("SELECT * FROM `".$Settings['sqltable']."forums` WHERE `ShowForum`='yes' AND `CategoryID`=%i AND `InSubForum`=0 ORDER BY `OrderID` ASC, `id` ASC", array($CategoryID));
+$result=mysql_query($query);
+$num=mysql_num_rows($result);
+$i=0;
+if($num>=1) {
+?>
+<div class="Table1Border">
+<?php if($ThemeSet['TableStyle']=="div") { ?>
+<div class="TableRow1">
+<span style="text-align: left;">
+<?php echo $ThemeSet['TitleIcon']; ?><a href="<?php echo url_maker($exfile[$CategoryType],$Settings['file_ext'],"act=view&id=".$CategoryID,$Settings['qstr'],$Settings['qsep'],$prexqstr[$CategoryType],$exqstr[$CategoryType]); ?>"><?php echo $CategoryName; ?></a></span></div>
+<?php } ?>
+<table id="Cat<?php echo $CategoryID; ?>" class="Table1">
+<?php if($ThemeSet['TableStyle']=="table") { ?>
+<tr id="CatStart<?php echo $CategoryID; ?>" class="TableRow1">
+<td class="TableColumn1" colspan="5"><span style="text-align: left;">
+<?php echo $ThemeSet['TitleIcon']; ?><a href="<?php echo url_maker($exfile[$CategoryType],$Settings['file_ext'],"act=view&id=".$CategoryID,$Settings['qstr'],$Settings['qsep'],$prexqstr[$CategoryType],$exqstr[$CategoryType]); ?>"><?php echo $CategoryName; ?></a></span>
+</td>
+</tr><?php } ?>
+<tr id="ForumStatRow<?php echo $CategoryID; ?>" class="TableRow2">
+<th class="TableColumn2" style="width: 4%;">&nbsp;</th>
+<th class="TableColumn2" style="width: 58%;">Forum</th>
+<th class="TableColumn2" style="width: 7%;">Topics</th>
+<th class="TableColumn2" style="width: 7%;">Posts</th>
+<th class="TableColumn2" style="width: 24%;">Last Topic</th>
+</tr>
+<?php }
+while ($i < $num) {
+$ForumID=mysql_result($result,$i,"id");
+$ForumName=mysql_result($result,$i,"Name");
+$ForumShow=mysql_result($result,$i,"ShowForum");
+$ForumType=mysql_result($result,$i,"ForumType");
+$ForumShowTopics=mysql_result($result,$i,"CanHaveTopics");
+$ForumShowTopics = strtolower($ForumShowTopics);
+$NumTopics=mysql_result($result,$i,"NumTopics");
+$NumPosts=mysql_result($result,$i,"NumPosts");
+$NumRedirects=mysql_result($result,$i,"Redirects");
+$ForumDescription=mysql_result($result,$i,"Description");
+$ForumType = strtolower($ForumType); $sflist = null;
+$gltf = array(null); $gltf[0] = $ForumID;
+if ($ForumType=="subforum") { 
+$apcquery = query("SELECT * FROM `".$Settings['sqltable']."forums` WHERE `ShowForum`='yes' AND `InSubForum`=%i ORDER BY `OrderID` ASC, `id` ASC", array($ForumID));
+$apcresult=mysql_query($apcquery);
+$apcnum=mysql_num_rows($apcresult);
+$apci=0; $apcl=1; if($apcnum>=1) {
+while ($apci < $apcnum) {
+$NumsTopics=mysql_result($apcresult,$apci,"NumTopics");
+$NumTopics = $NumsTopics + $NumTopics;
+$NumsPosts=mysql_result($apcresult,$apci,"NumPosts");
+$NumPosts = $NumsPosts + $NumPosts;
+$SubsForumID=mysql_result($apcresult,$apci,"id");
+$SubsForumName=mysql_result($apcresult,$apci,"Name");
+$SubsForumType=mysql_result($apcresult,$apci,"ForumType");
+if(isset($PermissionInfo['CanViewForum'][$SubsForumID])&&
+       $PermissionInfo['CanViewForum'][$SubsForumID]=="yes") {
+$sfurl = "<a href=\"";
+$sfurl = url_maker($exfile[$SubsForumType],$Settings['file_ext'],"act=view&id=".$SubsForumID.$ExStr,$Settings['qstr'],$Settings['qsep'],$prexqstr[$SubsForumType],$exqstr[$SubsForumType]);
+$sfurl = "<a href=\"".$sfurl."\">".$SubsForumName."</a>";
+if($apcl==1) {
+$sflist = "Subforums:";
+$sflist = $sflist." ".$sfurl; }
+if($apcl>1) {
+$sflist = $sflist.", ".$sfurl; }
+$gltf[$apcl] = $SubsForumID; ++$apcl; }
+++$apci; }
+@mysql_free_result($apcresult); } }
+if(isset($PermissionInfo['CanViewForum'][$ForumID])&&
+       $PermissionInfo['CanViewForum'][$ForumID]=="yes") {
+$LastTopic = "&nbsp;<br />&nbsp;<br />&nbsp;";
+if(!isset($LastTopic)) { $LastTopic = null; }
+$gltnum = count($gltf); $glti = 0; 
+$OldUpdateTime = 0; $UseThisFonum = null;
+if ($ForumType=="subforum") { 
+while ($glti < $gltnum) {
+$gltfoquery = query("SELECT * FROM `".$Settings['sqltable']."topics` WHERE `ForumID`=%i ORDER BY `LastUpdate` DESC LIMIT 1", array($gltf[$glti]));
+$gltforesult=mysql_query($gltfoquery);
+$gltfonum=mysql_num_rows($gltforesult);
+if($gltfonum>0) {
+$NewUpdateTime=mysql_result($gltforesult,0,"LastUpdate");
+if($NewUpdateTime>$OldUpdateTime) { 
+       $UseThisFonum = $gltf[$glti]; 
+$OldUpdateTime = $NewUpdateTime; } }
+@mysql_free_result($gltforesult);
+++$glti; } }
+if ($ForumType!="subforum"&&$ForumType!="redirect") { $UseThisFonum = $gltf[0]; }
+if ($ForumType!="redirect") {
+$gltquery = query("SELECT * FROM `".$Settings['sqltable']."topics` WHERE `ForumID`=%i ORDER BY `LastUpdate` DESC LIMIT 1", array($UseThisFonum));
+$gltresult=mysql_query($gltquery);
+$gltnum=mysql_num_rows($gltresult);
+if($gltnum>0){
+$TopicID=mysql_result($gltresult,0,"id");
+$TopicName=mysql_result($gltresult,0,"TopicName");
+$NumReplys=mysql_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 = query("SELECT * FROM `".$Settings['sqltable']."posts` WHERE `TopicID`=%i ORDER BY `TimeStamp` DESC LIMIT 1", array($TopicID));
+$glrresult=mysql_query($glrquery);
+$glrnum=mysql_num_rows($glrresult);
+if($glrnum>0){
+$ReplyID=mysql_result($glrresult,0,"id");
+$UsersID=mysql_result($glrresult,0,"UserID");
+$GuestName=mysql_result($glrresult,0,"GuestName");
+$TimeStamp=mysql_result($glrresult,0,"TimeStamp");
+$TimeStamp=GMTimeChange("F j Y, g:i a",$TimeStamp,$_SESSION['UserTimeZone'],0,$_SESSION['UserDST']);
+@mysql_free_result($glrresult); }
+$UsersName = GetUserName($UsersID,$Settings['sqltable']);
+if($UsersName=="Guest") { $UsersName=$GuestName;
+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!="-1") {
+$lul = url_maker($exfile['member'],$Settings['file_ext'],"act=view&id=".$UsersID,$Settings['qstr'],$Settings['qsep'],$prexqstr['member'],$exqstr['member']);
+$LastTopic = $TimeStamp."<br />\nTopic: <a href=\"".url_maker($exfile['topic'],$Settings['file_ext'],"act=view&id=".$TopicID."&page=".$NumPages,$Settings['qstr'],$Settings['qsep'],$prexqstr['topic'],$exqstr['topic'])."&#35;post".$ReplyID."\" title=\"".$oldtopicname."\">".$TopicName."</a><br />\nUser: <a href=\"".$lul."\" title=\"".$oldusername."\">".$UsersName."</a>"; }
+if($UsersID=="-1") {
+$LastTopic = $TimeStamp."<br />\nTopic: <a href=\"".url_maker($exfile['topic'],$Settings['file_ext'],"act=view&id=".$TopicID."&page=".$NumPages,$Settings['qstr'],$Settings['qsep'],$prexqstr['topic'],$exqstr['topic'])."&#35;post".$ReplyID."\" title=\"".$oldtopicname."\">".$TopicName."</a><br />\nGuest: <span title=\"".$oldusername."\">".$UsersName."</span>"; } }
+if($LastTopic==null) { $LastTopic = "&nbsp;<br />&nbsp;<br />&nbsp;"; } }
+@mysql_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"; }
+?>
+<tr class="TableRow3" id="Forum<?php echo $ForumID; ?>">
+<td class="TableColumn3"><div class="forumicon">
+<?php echo $PreForum; ?></div></td>
+<td class="TableColumn3"><div class="forumname"><a href="<?php echo url_maker($exfile[$ForumType],$Settings['file_ext'],"act=view&id=".$ForumID.$ExStr,$Settings['qstr'],$Settings['qsep'],$prexqstr[$ForumType],$exqstr[$ForumType]); ?>"<?php if($ForumType=="redirect") { echo " onclick=\"window.open(this.href);return false;\""; } ?>><?php echo $ForumName; ?></a></div>
+<div class="forumdescription">
+<?php echo $ForumDescription; ?><br />
+<?php echo $sflist; ?></div></td>
+<td class="TableColumn3" style="text-align: center;"><?php echo $NumTopics; ?></td>
+<td class="TableColumn3" style="text-align: center;"><?php echo $NumPosts; ?></td>
+<td class="TableColumn3"><?php echo $LastTopic; ?></td>
+</tr>
+<?php } ++$i; } @mysql_free_result($result);
+if($num>=1) { ?>
+<tr id="CatEnd<?php echo $CategoryID; ?>" class="TableRow4">
+<td class="TableColumn4" colspan="5">&nbsp;</td>
+</tr>
+</table></div>
+<div class="DivCategories">&nbsp;</div>
+<?php } } }
+@mysql_free_result($preresult); ?>