forum_id ";} $query="SELECT t1.forum_id, t1.topic_id FROM $bbdb->topics AS t1 JOIN (SELECT MAX(topic_last_post_id) AS topic_last_post_id FROM $bbdb->topics WHERE topic_status=0 $WHERE GROUP BY forum_id) AS t2 ON t1.topic_last_post_id = t2.topic_last_post_id"; $last_topics = $bbdb->get_results($query); foreach ($last_topics as $last_topic) {$forum_last_poster[$last_topic->forum_id]=$last_topic->topic_id;} bb_update_option('forum_last_poster',$forum_last_poster); return $forum_last_poster; } function forum_last_topic_id($id = 0) { global $forums_last_topic_id, $forum, $bb_topic_cache, $wp_object_cache; if (!$id) {$id=$forum->forum_id;} if (isset($forums_last_topic_id)) {return $forums_last_topic_id[$id];} $last_topics=bb_get_option('forum_last_poster'); if (empty($last_topics)) {$last_topics=forum_last_poster_update();} foreach ($last_topics as $key=>$id) { $forums_last_topic_id[$key]=$id; if (!isset($bb_topic_cache[$id]) && !isset($wp_object_cache->cache['bb_topic'][$id])) {$add_cache[]->topic_id=$id;} } if (!empty($add_cache)) {bb_cache_post_topics($add_cache);} // cache topics not already in cache return $forums_last_topic_id[$id]; } function forum_last_poster_recount_list() { global $recount_list; $recount_list[66] = array('forum-last-poster', __('Set Last Poster for each forum'),'forum_last_poster_recount'); } function forum_last_poster_recount() { if ( isset($_POST['forum-last-poster']) && 1 == $_POST['forum-last-poster'] && bb_current_user_can('administrate')) { echo "\t

\n"; echo "\t\t" . __('Setting last posters for each forum.'); forum_last_poster_update(); echo "\n\t

\n"; } } ?>