<?
require("global.php");

$foruminfo=$DB_site->query("SELECT forumid, title FROM forum WHERE forumid<>33 AND forumid<>34 ORDER BY categoryid,displayorder");
while ($forum=$DB_site->fetch_array($foruminfo)) {
  echo ("<b><br><a href=\"forumdisplay.php?forumid=".$forum[forumid]."\">".$forum[title]."</a></b><br>");
  $threadinfo=$DB_site->query("SELECT threadid,title,replycount,views FROM thread WHERE forumid=$forum[forumid] AND dateline > UNIX_TIMESTAMP(curdate()-30) ORDER BY views DESC LIMIT 4");
  while ($thread=$DB_site->fetch_array($threadinfo)) {
    echo ("???<a href=\"showthread.php?threadid=".$thread[threadid]."\">".htmlspecialchars($thread[title])."</a><font color=\"#0000ff\">?[views: ".$thread[views]."]?[replies: ".$thread[replycount]."]</font><br>");
  }
}

?>