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 "\n"; while($data = dbarray($result)) { $itemsubject = trimlink($data['thread_subject'], 20); echo "\n\n"; echo "\n\n"; } echo "
·$itemsubject[".($data['thread_postcount'] - 1)."]
\n"; } else { echo "
".$locale['global_023']."
\n"; } echo "
";