public static function get_recentTopics($forum_id = 0)
{
$forum_settings = self::get_forum_settings();
$result = dbquery("SELECT tt.*, tf.*, tp.post_id, tp.post_datestamp,\n\t\t\tu.user_id, u.user_name as last_user_name, u.user_status as last_user_status, u.user_avatar as last_user_avatar,\n\t\t\tuc.user_id AS s_user_id, uc.user_name AS author_name, uc.user_status AS author_status, uc.user_avatar AS author_avatar,\n\t\t\tcount(v.post_id) AS vote_count\n\t\t\tFROM " . DB_FORUM_THREADS . " tt\n\t\t\tINNER JOIN " . DB_FORUMS . " tf ON (tt.forum_id=tf.forum_id)\n\t\t\tLEFT JOIN " . DB_FORUM_POSTS . " tp on (tt.thread_lastpostid = tp.post_id)\n\t\t\tLEFT JOIN " . DB_USERS . " u ON u.user_id=tt.thread_lastuser\n\t\t\tLEFT JOIN " . DB_USERS . " uc ON uc.user_id=tt.thread_author\n\t\t\tLEFT JOIN " . DB_FORUM_VOTES . " v ON v.thread_id = tt.thread_id AND tp.post_id = v.post_id\n\t\t\t" . (multilang_table("FO") ? "WHERE tf.forum_language='" . LANGUAGE . "' AND" : "WHERE") . "\n\t\t\t" . groupaccess('tf.forum_access') . " AND tt.thread_hidden='0'\n\t\t\t" . ($forum_id ? "AND forum_id='" . intval($forum_id) . "'" : '') . "\n\t\t\tGROUP BY thread_id ORDER BY tt.thread_lastpost LIMIT 0, " . $forum_settings['threads_per_page'] . "");
$info['rows'] = dbrows($result);
if ($info['rows'] > 0) {
// need to throw moderator as an object
while ($data = dbarray($result)) {
$data['moderators'] = self::moderator()->parse_forum_mods($data['forum_mods']);
$info['item'][$data['thread_id']] = $data;
}
}
return $info;
}
