jeste jednou...
Tak jsem si vlezl do databaze a spustil ten SQL dotaz ktery se tam provadi pro vypis nejnovejsich prispevku:
Kód: Vybrat vše
SELECT p.post_time,t.*, MAX(p.post_id) AS last_post
FROM phpbb_posts AS p, phpbb_topics AS t
WHERE t.topic_id = p.topic_id AND t.forum_id = p.forum_id
GROUP BY p.topic_id
ORDER BY p.post_time DESCKód: Vybrat vše
SELECT p.post_time,t.*, MAX(p.post_id) AS last_post, MAX( p.post_time ) AS last_post_time
FROM phpbb_posts AS p, phpbb_topics AS t
WHERE t.topic_id = p.topic_id AND t.forum_id = p.forum_id
GROUP BY p.topic_id
ORDER BY last_post_time DESCNikdo jiny ten prolem nemel? Mozna se jednalo jen o spatne groupovani nasi DB, a tak se to obeslo....
jestli to nejde takhle sestavit 
