Forums

Join
bbPress Support Forums › Troubleshooting › Alter Loop for Paged Forum Pages?

Info

Tags

Alter Loop for Paged Forum Pages?

    • Posted 4 years ago #

    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?

    • Posted 4 years ago #

    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?

    • Posted 4 years ago #

    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

    • Posted 3 years ago #
    $forum_one_topics = $bbdb->get_results("SELECT * FROM $bbdb->topics WHERE forum_id = $forum_id AND topic_status = 0 AND topic_sticky = 0 ORDER BY topic_id DESC LIMIT $limit OFFSET $offset");

    updated to leave out sticky posts from the second loop (added AND topic_sticky = 0 to query).

    If you leave out '$forum_id = 1;' it will work on multiple forums.

    I've done this so that my front page summary shows latest active posts, but my specific forum pages list by topic order.

  5. You must log in to post.