inc/categories.php

   1 <?php
   2 /*
   3     This program is free software; you can redistribute it and/or modify
   4     it under the terms of the Revised BSD License.
   5
   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.
  10
  11     Copyright 2004-2007 Cool Dude 2k - http://intdb.sourceforge.net/
  12     Copyright 2004-2007 Game Maker 2k - http://upload.idb.s1.jcink.com/
  13
  14     $FileInfo: categories.php - Last Update: 07/13/2007 SVN 42 - Author: cooldude2k $
  15 */
  16 $File3Name = basename($_SERVER['SCRIPT_NAME']);
  17 if ($File3Name=="categories.php"||$File3Name=="/categories.php") {
  18         require('index.php');
  19         exit(); }
  20 $prequery = query("select * from `".$Settings['sqltable']."categories` where `id`=%i and `ShowCategory`='yes'", array($_GET['id']));
  21 $preresult=mysql_query($prequery);
  22 $prenum=mysql_num_rows($preresult);
  23 $prei=0;
  24 if($prenum==0) { redirect("location",$basedir.url_maker($exfile['index'],$Settings['file_ext'],"act=view",$Settings['qstr'],$Settings['qsep'],$prexqstr['index'],$exqstr['index'],false)); }
  25 while ($prei < $prenum) {
  26 $CategoryID=mysql_result($preresult,$prei,"id");
  27 $CategoryName=mysql_result($preresult,$prei,"Name");
  28 $CategoryShow=mysql_result($preresult,$prei,"ShowCategory");
  29 $CategoryType=mysql_result($preresult,$prei,"CategoryType");
  30 $SubShowForums=mysql_result($preresult,$prei,"SubShowForums");
  31 $CategoryDescription=mysql_result($preresult,$prei,"Description");
  32 $CategoryType = strtolower($CategoryType); $SubShowForums = strtolower($SubShowForums);
  33 if($CatCheck!="skip") {
  34 if($CategoryType=="subcategory") {
  35 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)); } }
  36 $query = query("select * from `".$Settings['sqltable']."forums` where `ShowForum`='yes' and `CategoryID`=%i and `InSubForum`=0 ORDER BY `id`", array($CategoryID));
  37 $result=mysql_query($query);
  38 $num=mysql_num_rows($result);
  39 $i=0;
  40 if($num>=1) {
  41 ?>
  42 <div class="Table1Border">
  43 <table id="Cat<?php echo $CategoryID; ?>" class="Table1">
  44 <tr id="CatStart<?php echo $CategoryID; ?>" class="TableRow1">
  45 <td class="TableRow1" colspan="5"><span style="float: left;">
  46 <?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>
  47 <?php echo "<span style=\"float: right;\">&nbsp;</span>"; ?></td>
  48 </tr>
  49 <tr id="ForumStatRow<?php echo $CategoryID; ?>" class="TableRow2">
  50 <th class="TableRow2" style="width: 4%;">&nbsp;</th>
  51 <th class="TableRow2" style="width: 58%;">Forum</th>
  52 <th class="TableRow2" style="width: 7%;">Topics</th>
  53 <th class="TableRow2" style="width: 7%;">Posts</th>
  54 <th class="TableRow2" style="width: 24%;">Last Topic</th>
  55 </tr>
  56 <?php }
  57 while ($i < $num) {
  58 $ForumID=mysql_result($result,$i,"id");
  59 $ForumName=mysql_result($result,$i,"Name");
  60 $ForumShow=mysql_result($result,$i,"ShowForum");
  61 $ForumType=mysql_result($result,$i,"ForumType");
  62 $NumTopics=mysql_result($result,$i,"NumTopics");
  63 $NumPosts=mysql_result($result,$i,"NumPosts");
  64 $ForumDescription=mysql_result($result,$i,"Description");
  65 unset($LastTopic);
  66 $gltquery = query("select * from `".$Settings['sqltable']."topics` where `CategoryID`=%i and `ForumID`=%i ORDER BY `LastUpdate` DESC", array($CategoryID,$ForumID));
  67 $gltresult=mysql_query($gltquery);
  68 $gltnum=mysql_num_rows($gltresult);
  69 if($gltnum>0){
  70 $TopicID=mysql_result($gltresult,0,"id");
  71 $TopicName=mysql_result($gltresult,0,"TopicName");
  72 $NumReplys=mysql_result($gltresult,0,"NumReply");
  73 $ShowReply = $NumReplys + 1;
  74 $TopicName1 = substr($TopicName,0,15);
  75 if (strlen($TopicName)>12) { $TopicName1 = $TopicName1."..."; }
  76 $UsersID=mysql_result($gltresult,0,"UserID");
  77 $GuestName=mysql_result($gltresult,0,"GuestName");
  78 $UsersName = GetUserName($UsersID,$Settings['sqltable']);
  79 if($UsersName=="Guest") { $UsersName=$GuestName;
  80 if($UsersName==null) { $UsersName="Guest"; } }
  81 $UsersName1 = substr($UsersName,0,18);
  82 if (strlen($UsersName)>15) { $UsersName1 = $UsersName1."...";
  83 $oldtopicname=$TopicName; $oldusername=$UsersName;
  84 $TopicName=$TopicName1; $UsersName=$UsersName1; } $lul = null;
  85 if($UsersID!="-1") {
  86 $lul = url_maker($exfile['member'],$Settings['file_ext'],"act=view&id=".$UsersID,$Settings['qstr'],$Settings['qsep'],$prexqstr['member'],$exqstr['member']);
  87 $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>"; }
  88 if($UsersID=="-1") {
  89 $LastTopic = "User: <span title=\"".$oldusername."\">".$UsersName."</span><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>"; } }
  90 @mysql_free_result($gltresult);
  91 $ForumType = strtolower($ForumType);
  92 if ($ForumType=="forum") { $PreForum=$ThemeSet['ForumIcon']; }
  93 if ($ForumType=="subforum") { $PreForum=$ThemeSet['SubForumIcon']; }
  94 if ($ForumType=="subforum") { $PreForum=$ThemeSet['SubForumIcon']; }
  95 if ($ForumType=="redirect") { $PreForum=$ThemeSet['RedirectIcon']; }
  96 ?>
  97 <tr class="TableRow3" id="Forum<?php echo $ForumID; ?>">
  98 <td class="TableRow3"><div class="forumicon">
  99 <?php echo $PreForum; ?></div></td>
 100 <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>
 101 <div class="forumescription"><?php echo $ForumDescription; ?></div></td>
 102 <td class="TableRow3" style="text-align: center;"><?php echo $NumTopics; ?></td>
 103 <td class="TableRow3" style="text-align: center;"><?php echo $NumPosts; ?></td>
 104 <td class="TableRow3"><?php echo $LastTopic; ?></td>
 105 </tr>
 106 <?php
 107 ++$i; } @mysql_free_result($result);
 108 if($num>=1) { ?>
 109 <tr id="CatEnd<?php echo $CategoryID; ?>" class="TableRow4">
 110 <td class="TableRow4" colspan="5">&nbsp;</td>
 111 </tr>
 112 </table></div>
 113 <div>&nbsp;</div>
 114 <?php } ++$prei; }
 115 @mysql_free_result($preresult); ?>