|
|
Flash :: Onlinespiele :: Arcade :: Space Invaders
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
SELECT t.*, f.forum_id, f.forum_name, p.post_subject, u2.username AS last_poster, u2.user_id AS last_poster_id, p.post_username AS first_poster_name, p2.post_username AS last_poster_name, p2.post_time FROM phpbb_topics t, phpbb_forums f, phpbb_users u, phpbb_posts p, phpbb_posts p2, phpbb_users u2 WHERE t.topic_poster = u.user_id AND f.forum_id = t.forum_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 ORDER BY t.topic_last_post_id DESC LIMIT 0, 5
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
