> |
query($DB, $sSQL);
if($q->numrows()){
$num_posts=$q->field("posts", 0);
}
else{
$num_posts='0';
}
$sSQL="select max(datestamp) as max_date from $forum[table]";
$q->query($DB, $sSQL);
$last_post_date=$q->field("max_date", 0);
if($last_post_date==0){
$last_post_date=date_format("0000-00-00");
}
else{
$last_post_date=date_format($last_post_date);
}
echo "";
echo "";
echo "- $name
| ";
echo " $lNumPosts: $num_posts $lLastPostDate: $last_post_date |
";
echo "";
echo "";
echo $forum["description"];
echo " |
\n";
}
$forum=next($forums);
}
}
if($empty){
echo $lNoActiveForums;
}
?>