Die letzten 5 Beiträge

1:

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

1:

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

1:

$lang->load("START");

1:

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

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:

$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
        ');

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:

$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
');