I really like how this works on the front page:
$forum_id = 1;
$forum_one_topics = $bbdb->get_results("SELECT * FROM $bbdb->topics WHERE forum_id = $forum_id ORDER BY topic_time DESC LIMIT 0,10")
foreach($forum_one_topics as $topic) :
?>
but would like to use this for the whole site. Is it possible to make this the logic of the entire site loop?
Just for some more clarification - I would like my forum to show the most recent topics first - not the most active. Is there some easy way to set this up?
I figured it out and wanted to share. This code goes at the top of my forums.php file (template).
<?php
$forum_id = 1;
$limit = bb_get_option('page_topics');
$offset = ($page-1)*$limit;
$forum_one_topics = $bbdb->get_results("SELECT * FROM $bbdb->topics WHERE forum_id = $forum_id AND topic_status = 0 ORDER BY topic_id DESC LIMIT $limit OFFSET $offset")
?>My posts loop:
<?php
foreach($forum_one_topics as $topic) : $forum_one_topic_posts = get_thread( $topic->topic_id); ?>
Works like a charm
You must log in to post.