$tccellh"."
$tccellh"."Forum
$tccellh"."Threads
$tccellh"."Posts
$tccellh"."Last post";
while ($category=mysqli_fetch_assoc($categories)) {
$forumcount=0;
//$i=0;
if ($category['id']>0) {
$forumlist.="";
}
$nesticle=mysqli_query($con,"SELECT * FROM forums WHERE catid = $category[id] ORDER BY 'order' DESC");
$forumlist.="| $fonttag"."$category[name] | ";
while($row = mysqli_fetch_array($nesticle)) {
if ($row['catid']==$category['id']) {
$new="";
/*
if ($forumlastpost1['$i']>$postread['$loguserid']['$i'] and $forumpostcount['$i']>0 and $logpassword!="") {
$new=" ";
}
*/
$numthreads=mysqli_num_rows(mysqli_query($con,"SELECT forum FROM threads WHERE forum = $row[id]"));
$numposts=mysqli_num_rows(mysqli_query($con,"SELECT threads.forum,threads.id,posts.thread FROM threads INNER JOIN posts ON threads.id=posts.thread WHERE forum=$row[id]"));
$luser=mysqli_fetch_array(mysqli_query($con,"SELECT threads.forum,posts.id,posts.date,users.id,users.name FROM threads INNER JOIN posts ON threads.id=posts.thread AND threads.forum=$row[id] INNER JOIN users ON posts.user=users.id ORDER BY date DESC"));
$forumlist.=" $tccell1$new";
$forumlist.="$tccell2"."$row[title]
";
$forumlist.="$smallfont$row[description]";
$forumlist.="$tccell1$numthreads$tccell1$numposts";
if ($luser['id']) {
$forumlist.="$tccell2w".date("m-d-y h:i A",$luser['date']+$tzoff)."
$smallfont by $luser[name]";
}
else {
$forumlist.="$tccell2w"."-------- --:-- --";
}
}
}
}
print "$forumlist
|
";
print "$footer