phpBB.de

Code: Alles auswählen

$sql = "SELECT t.*, u.username, u.user_id, u2.username as user2, u2.user_id as id2, p.post_username, p2.post_username AS post_username2, p2.post_time 
            FROM " . TOPICS_TABLE . " t, " . USERS_TABLE . " u, " . POSTS_TABLE . " p, " . POSTS_TABLE . " p2, " . USERS_TABLE . " u2 
        LEFT JOIN " . FORUMS_TABLE . " f 
        ON t.forum_id=f.forum_id 
            WHERE t.topic_poster = u.user_id 
                    AND p.post_id = t.topic_first_post_id 
                       AND p2.post_id = t.topic_last_post_id 
                       AND u2.user_id = p2.poster_id 
            AND f.auth_view < 2 
           ORDER BY t.topic_last_post_id DESC 
           LIMIT 5"; 
if ( !($result = $db->sql_query($sql)) ) 
{ 
   message_die(GENERAL_ERROR, 'Could not obtain topic information', '', __LINE__, __FILE__, $sql); 
} 

Code: Alles auswählen

$sql = "SELECT t.*, u.username, u.user_id, u2.username as user2, u2.user_id as id2, p.post_username, p2.post_username AS post_username2, p2.post_time
FROM (" . TOPICS_TABLE . " t, " . USERS_TABLE . " u, " . POSTS_TABLE . " p, " . POSTS_TABLE . " p2, " . USERS_TABLE . " u2)
LEFT JOIN " . FORUMS_TABLE . " f
ON t.forum_id=f.forum_id
WHERE t.topic_poster = u.user_id
AND p.post_id = t.topic_first_post_id
AND p2.post_id = t.topic_last_post_id
AND u2.user_id = p2.poster_id
AND f.auth_view < 2
ORDER BY t.topic_last_post_id DESC
LIMIT 5";

if ( !($result = $db->sql_query($sql)) ) 
{ 
   message_die(GENERAL_ERROR, 'Could not obtain topic information', '', __LINE__, __FILE__, $sql); 
}