echo "
"; echo "".$locale['global_020']." | ||
"; echo "".$locale['global_021']." \n"; $result = dbquery(" SELECT tt.forum_id, tt.thread_id, tt.thread_subject, tt.thread_lastpost FROM ".DB_THREADS." tt INNER JOIN ".DB_FORUMS." tf ON tt.forum_id=tf.forum_id WHERE ".groupaccess('forum_access')." ORDER BY thread_lastpost DESC LIMIT 5 "); if (dbrows($result)) { while($data = dbarray($result)) { $itemsubject = trimlink($data['thread_subject'], 23); echo "· $itemsubject \n"; } } else { echo " ".$locale['global_023']." \n";
}
echo "".$locale['global_022']."\n";
list($min_posts) = dbarraynum(dbquery("SELECT thread_postcount FROM ".DB_THREADS." ORDER BY thread_postcount DESC LIMIT 4,5"));
$result = dbquery("
SELECT tf.forum_id, tt.thread_id, tt.thread_subject, tt.thread_postcount
FROM ".DB_FORUMS." tf
INNER JOIN ".DB_THREADS." tt USING(forum_id)
WHERE ".groupaccess('forum_access')." AND tt.thread_postcount >= '$min_posts'
ORDER BY thread_postcount DESC, thread_lastpost DESC LIMIT 5
");
if (dbrows($result) != 0) {
echo "
".$locale['global_023']." \n";
}
echo " |