openside($locale['412']);
echo "".$locale['412']."
\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 20
");
if (dbrows($result)) {
$counter = 0; $columns = 4;
echo "\n\n";
while($data = dbarray($result)) {
if ($counter != 0 && ($counter % $columns == 0)) { echo "
\n\n"; }
$itemsubject = trimlink($data['thread_subject'], 900);
echo "| $itemsubject | | \n";
$counter++;
}
echo "
\n
\n";
} else {
echo "".$locale['global_023']."
\n";
}
closeside();