Habe dazu folgende SQL Abfrage:
Code: Alles auswählen
$sql = "SELECT p.post_id, p.topic_id, p.forum_id, p.poster_id, p.post_time,
t.topic_id, t.topic_title, t.topic_last_post_id,
po.post_id, po.post_text,
u.user_id, u.username,
f.forum_id, f.forum_name, f.auth_view
FROM phpbb_posts p, phpbb_topics t, phpbb_posts_text po, phpbb_users u, phpbb_forums f
WHERE (p.post_id = t.topic_last_post_id) AND (po.post_id = p.post_id)
AND (u.user_id = p.poster_id) AND (f.forum_id = p.forum_id) AND (f.auth_view = 0)
ORDER BY p.post_time DESC
LIMIT 5";
Wäre dankbar für eine Antwort.
