".$locale['021']."\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 10 "); if (dbrows($result) != 0) { while($data = dbarray($result)) { $itemsubject = trimlink($data['thread_subject'], 23); echo " $itemsubject
\n"; } } else { echo "".$locale['004']."\n"; } echo "

".$locale['022']."

\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(); ?>