Modifica a Script per gli ultimi 10 topic

[ellecubo]

ah tu volevi solo i topic...skusami

mhm prova un pò questa

SELECT t.topic_id, t.topic_title, t.topic_last_post_id, t.forum_id, p.post_id, p.poster_id, p.post_time, u.user_id, u.username
FROM phpbb_topics t, phpbb_forums f, phpbb_posts p, phpbb_users u
WHERE f.auth_view =0
AND t.topic_id = p.topic_id
AND f.forum_id = t.forum_id
AND t.topic_status <>2
AND p.poster_id = u.user_id
GROUP BY t.topic_last_post_id
ORDER BY p.post_time DESC
LIMIT 10