Subforums on Forumhome (no extra queries Version)

Well, i think most of you know the hack already but with a great ammount of additional queries.

This hack shows on every forum on forumhome (also on categories if you want it so) all it's Subforums.
It works dynamically so whenever you add a forum, it will be added to the list

One disadvantage on having it queryless is, that if you have private subforums below nonprivate mainforums that these will be seen so (not accesable but seen)

Hope it fits in what some of you need

[deathemperor]

well, I'm truly sorry, that was my terrible mistake.
I shouldn't have worked when I am exhausted
it works perfectly. Much thanks, Xenon

[Xenon]

np, at least it works now, that's all what counts

[translucent]

Great hack! I changed the field "title" to "displayorder" in order to have the subforums sorted accordingly:

PHP Code:

$forums=$DB_site->query("SELECT forumid, title, parentlist FROM forum ORDER BY displayorder"); 


[cerebro]

i made another MOD

  $forums=$DB_site->query("SELECT forumid, title, parentlist FROM forum WHERE parentid=53 OR parentid=2 OR parentid=3 OR parentid=60  ORDER BY title");

And only show First Level of Subforums, but not all.

[Xenon]

@cerebro: that way looks better:

PHP Code:

$forums=$DB_site->query("SELECT forumid, title, parentlist FROM forum WHERE parentid IN(53, 2, 3, 60) ORDER BY title"); 


[cerebro]

Originally Posted by Xenon

@cerebro: that way looks better:

PHP Code:

$forums=$DB_site->query("SELECT forumid, title, parentlist FROM forum WHERE parentid IN(53, 2, 3, 60) ORDER BY title"); 


Nice!...
sos un Groso! :d (in spanish)

[Oblivion Knight]

Is it possible to hide sub-forums that are currently turned off (active=0).?

I've tried adding this myself, with little success..

[Xenon]

just add a
[sql]active = 1 AND [/sql]

behinde the WHERE tag

[mzbcarper]

is there a version 4 vBB 3.0 to expect ?

[Xenon]

vb3 has this hack already included iirc