openside($locale['020']);
echo "\n";
$result = dbquery("
SELECT * FROM ".$db_prefix."threads
INNER JOIN ".$db_prefix."forums ON ".$db_prefix."threads.forum_id=".$db_prefix."forums.forum_id
WHERE ".groupaccess('forum_access')." ORDER BY thread_lastpost DESC LIMIT 5
");
if (dbrows($result) != 0) {
while($data = dbarray($result)) {
$itemsubject = trimlink($data['thread_subject'], 23);
echo " $itemsubject
\n";
}
} else {
echo "".$locale['004']."\n";
}
echo "\n";
$result = dbquery("
SELECT tf.forum_id, tt.thread_id, tt.thread_subject, 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)
WHERE ".groupaccess('forum_access')." GROUP BY thread_id ORDER BY count_posts DESC, thread_lastpost DESC LIMIT 5
");
if (dbrows($result) != 0) {
echo "\n";
while($data = dbarray($result)) {
$itemsubject = trimlink($data['thread_subject'], 20);
echo "\n
\n\n";
}
echo "

$itemsubject

[".($data['count_posts']-1)."]

\n";
} else {
echo "".$locale['004']."\n";
}
closeside();

openside($locale['020']);
echo "\n";
$result = dbquery("
SELECT * FROM ".$db_prefix."threads
INNER JOIN ".$db_prefix."forums ON ".$db_prefix."threads.forum_id=".$db_prefix."forums.forum_id
WHERE ".groupaccess('forum_access')." ORDER BY thread_lastpost DESC LIMIT 5
");
if (dbrows($result) != 0) {
while($data = dbarray($result)) {
$itemsubject = trimlink($data['thread_subject'], 23);
echo " $itemsubject
\n";
}
} else {
echo "".$locale['004']."\n";
}
closeside();