PEAK XOOPS - Re: Display recent topics replies, ti custom block! 
TOP
>
Forum
>
XOOPS Hacks
>
Hacks
>
Display recent topics replies, ti custom block!
>
Re: Display recent topics replies, ti custom block!
Re: Display recent topics replies, ti custom block!
Re: Display recent topics replies, ti custom block!
msg# 1.1
- depth:
- 1
GIJOE
Posts: 4110
Posts: 4110
Just a query hint.
"SELECT t.topic_id, t.topic_title, t.topic_last_post_id, t.topic_time, t.topic_views, t.topic_replies, t.forum_id, f.forum_name, p.post_id, p.uid, p.subject FROM ".$db->prefix("bb_topics")." t LEFT JOIN ".$db->prefix("bb_forums")." f ON f.forum_id=t.forum_id LEFT JOIN ".$db->prefix("bb_posts")." p ON p.topic_id=t.topic_id ORDER BY p.post_time"
"SELECT t.topic_id, t.topic_title, t.topic_last_post_id, t.topic_time, t.topic_views, t.topic_replies, t.forum_id, f.forum_name, p.post_id, p.uid, p.subject FROM ".$db->prefix("bb_topics")." t LEFT JOIN ".$db->prefix("bb_forums")." f ON f.forum_id=t.forum_id LEFT JOIN ".$db->prefix("bb_posts")." p ON p.topic_id=t.topic_id ORDER BY p.post_time"
Votes:7
Average:7.14
Posts tree
-
Display recent topics replies, ti custom block!
(JimKarvo, 2006/4/7 21:28)
-
Re: Display recent topics replies, ti custom block!
(GIJOE, 2006/4/8 5:18)
-
Re: Display recent topics replies, ti custom block!
(JimKarvo, 2006/4/8 6:20)
-
Re: Display recent topics replies, ti custom block!
(GIJOE, 2006/4/9 5:47)
-
-
-
Login