YourWBB

$show_posts = isset($_COOKIE['show_last_posts']) && $_COOKIE['show_last_posts'] != 0;

$show_posts = !isset($_COOKIE['show_last_posts']) || $_COOKIE['show_last_posts'] != 0;

$lang->load("START");

$lang->load("START,LASTPOSTS");

$result = $db->unbuffered_query('
            SELECT
                p.postid, p.threadid, p.userid, p.username, p.posttime, p.message,
                t.topic
            FROM
                bb'.$n.'_posts p
            LEFT JOIN
                bb'.$n.'_threads t
                USING (threadid)
            WHERE
                p.visible=1
                AND
                t.boardid IN(0'.getSearchableBoards().')
            GROUP BY
                threadid
            ORDER BY
                postid DESC
            LIMIT
                5
        ');

$result = $db->unbuffered_query('
    SELECT
        t.topic, t.threadid,
        p.postid, p.threadid, p.userid, p.username, p.posttime, p.message
    FROM
        bb'.$n.'_threads t
    LEFT JOIN
        bb'.$n.'_posts p ON(t.lastpostid=p.postid)
    WHERE
        p.visible=1
        AND
        t.boardid IN(0'.getSearchableBoards().')
    ORDER BY
        t.lastposttime DESC
    LIMIT
        5
');