phpBB.de

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";