SELECT c.cat_id, c.cat_title, f.forum_id, f.forum_name, t.topic_id, t.topic_title, t.topic_last_post_id, t.topic_replies
FROM phpbb_topics t
LEFT JOIN phpbb_forums f ON f.forum_id = t.forum_id
LEFT JOIN phpbb_categories c ON c.cat_id = f.cat_id
LEFT JOIN phpbb_posts p ON p.post_id = t.topic_last_post_id
WHERE f.auth_view = 0
AND f.auth_read = 0
AND IF(f.forum_moderate, p.post_approve, 1)
ORDER BY c.cat_order, f.forum_order, t.topic_last_post_id DESC
LIMIT 0, 100
Line : 109 File : sitemap.php
Jeśli nie potrafisz znaleźć rozwiązania tego problemu, możesz spróbować poszukać, lub zadać pytanie na forum: http://www.przemo.org/phpBB2/
FAQ
