if (!defined("IN_FUSION")) { header("Location:../../index.php"); exit; }

$result = dbquery(
"SELECT tf.*, tt.*, tu.user_id,user_name, MAX(tp.post_id) as last_id, COUNT(tp.post_id) as count_posts FROM ".$db_prefix."forums tf
INNER JOIN ".$db_prefix."threads tt USING(forum_id)
INNER JOIN ".$db_prefix."posts tp USING(thread_id)
INNER JOIN ".$db_prefix."users tu ON tt.thread_lastuser=tu.user_id
WHERE ".groupaccess('forum_access')." GROUP BY thread_id ORDER BY thread_lastpost DESC LIMIT 0,".$settings['numofthreads']
);
if (dbrows($result) != 0) {
$i = 0;
opentable($locale['025']);
echo "\n\n";
if ($theme_width == "100%") echo "\n";
echo "


\n";
while ($data = dbarray($result)) {
if ($i % 2 == 0) { $row_color = "tbl1"; } else { $row_color = "tbl2"; }
echo "\n";
if ($theme_width == "100%") {
echo "
\n";
} else {
echo "\n";
}
echo "


\n";
$i++;
}
if (iMEMBER) {
echo "\n\n\n" ;


}
echo "

".$locale['030']."	".$locale['031']."	".$locale['033']."	".$locale['034']."
".$data['forum_name']."	".trimlink($data['thread_subject'], 30)."	".trimlink($data['thread_subject'], 30)."	".($data['count_posts']-1)."	".$data['user_name']."	".showdate("forumdate", $data['thread_lastpost'])."
".$locale['026']." | ".$locale['027']." | ".$locale['028']."

\n";
closetable();
}
?>

"