Help. Showing threads in both subforum and main forum

Hi,

I'm trying to make a hack that will show threads of the subforums in the main forum or the parent forum. This will encourage ppl to post in the right subforum cause they know it will be shown in the crowded forum also

I think the change should be done in forumdisplay.php
in specific this part.

$getthreadids=$DB_site->query(" 
SELECT ".iif($sortfield=="voteavg",$votequery,"")." thread.threadid 
FROM thread 
WHERE thread.forumid='$foruminfo[forumid]' AND thread.visible=1 
$datecut $limitothers $ignoreusers 
ORDER BY sticky DESC, $sortfield $sqlsortorder 
LIMIT ".($limitlower-1).",$perpage 
");

What I'm looking for now is the variable to add after

 WHERE thread.forumid='$foruminfo[forumid]'

which will list all the subforums of this forum so it should look like

WHERE thread.forumid='$foruminfo[forumid]' 
OR thread.forumid=((SUBFORUMS))

Any suggestions guys?


Thanks in advance.

Nobody?

I would like an option to display subs in the main as well... Haven't had time to research it tho

I think what should be done is something like this

$getforumids=$DB_site->query(" 
forumid FROM forum
WHERE parent='$foruminfo[forumid]' AND thread.visible=1 
");

Then a while loop to fetch all the subforums,, then include what we get in the main query (getthreadsid).

I really can't put this together,, if anyone can give us a hand ?

Not even a hint?

Ya, no one else cares I quess...

Strange,, I showed most of what need to be changed,, we only need someone to tell us a small bit of information so I can proceed.

There is still no one able to help in that?

bump

Personally I don't see the point in this.

Explain to me the benefits of having posts in multiple forums? All I can see is confusion.