print "<table class='lista' border='0' width='100%' cellspacing='1' cellpadding='5'>\n";
print "<tr><td class='header' align='center'>" . FORUM . "</td><td class='header' align='center' width='15%'>" . TOPICS . "</td>" . "<td class='header' align='center' width='15%'>" . POSTS . "</td>" . "<td class='header' align='center' width='15%'>" . LASTPOST . "</td></tr>\n";
if ($forums_res->num_rows == 0) {
print "<tr><td class='lista' colspan='4' align='center'>" . NO_FORUMS . "</td></tr>";
}
while ($forums_arr = $forums_res->fetch_assoc()) {
if (user::$current["id_level"] < $forums_arr["minclassread"]) {
continue;
}
$forumid = (int) $forums_arr["id"];
$forumname = security::html_safe(unesc($forums_arr["name"]));
$forumdescription = security::html_safe(unesc($forums_arr["description"]));
$topiccount = number_format((int) $forums_arr["topiccount"]);
$postcount = number_format((int) $forums_arr["postcount"]);
// Find last post ID
$lastpostid = Cached::get_forum_last_post($forumid);
// Get last post info
$post_res = $db->query("SELECT added, topicid, userid FROM posts WHERE id = " . $lastpostid) or sqlerr(__FILE__, __LINE__);
if ($post_res->num_rows == 1) {
$post_arr = $post_res->fetch_assoc() or die(ERR_BAD_LAST_POST);
$lastposterid = (int) $post_arr["userid"];
$lastpostdate = get_date_time($post_arr["added"]);
$lasttopicid = (int) $post_arr["topicid"];
$user_res = $db->query("SELECT username FROM users WHERE id = " . $lastposterid) or sqlerr(__FILE__, __LINE__);
$user_arr = $user_res->fetch_assoc();
$lastposter = security::html_safe($user_arr['username']);
$topic_res = $db->query("SELECT subject FROM topics WHERE id = " . $lasttopicid) or sqlerr(__FILE__, __LINE__);
$topic_arr = $topic_res->fetch_assoc();
$lasttopic = security::html_safe(unesc($topic_arr['subject']));
//---- Get reply count
$postsperpage = user::$current["postsperpage"] > 0 ? user::$current["postsperpage"] : 15;
