Quote:
They aren't displayed on the main page if they are deep enough or you have it set to only show one level of depth on the homepage (as we do). I tried this behavior out and users had a fit, because they missed new posts within children conferences.
|
I already sent you a query that solves this in one single DB operation. Here's the copy:
Code:
select a.forumid as forumid, max(b.lastpost) as lastpost, min(ifnull(m.timestamp,0)) timestamp
from forum a
inner join forum b
on instr( concat(',',b.parentlist), concat(',',a.forumid,',') ) > 0
left outer join forumread m
on m.userid = $user and m.forumid = b.forumid
group by a.forumid;
Guille