bbPress support forums Topic: Alter Loop for Paged Forum Pages?

bbPress support forums Topic: Alter Loop for Paged Forum Pages? http://bbpress.org/forums/ bbPress support forums Topic: Alter Loop for Paged Forum Pages? en Wed, 03 Dec 2008 03:31:18 +0000 jenz on "Alter Loop for Paged Forum Pages?" http://bbpress.org/forums/topic/alter-loop-for-paged-forum-pages#post-15704 Wed, 23 Apr 2008 02:41:16 +0000 jenz 15704@http://bbpress.org/forums/ I figured it out and wanted to share. This code goes at the top of my forums.php file (template). <pre><code><?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") ?></code></pre> My posts loop: <code> <?php foreach($forum_one_topics as $topic) : $forum_one_topic_posts = get_thread( $topic->topic_id); ?> </code> Works like a charm jenz on "Alter Loop for Paged Forum Pages?" http://bbpress.org/forums/topic/alter-loop-for-paged-forum-pages#post-15620 Mon, 21 Apr 2008 16:35:02 +0000 jenz 15620@http://bbpress.org/forums/ 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? jenz on "Alter Loop for Paged Forum Pages?" http://bbpress.org/forums/topic/alter-loop-for-paged-forum-pages#post-15553 Sun, 20 Apr 2008 02:04:04 +0000 jenz 15553@http://bbpress.org/forums/ I really like how this works on the front page: <code> $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) : ?> </code> but would like to use this for the whole site. Is it possible to make this the logic of the entire site loop?