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

[lifesourcerec]

Today at 10:00 AM Nietzsche said this in Post #60
@WE and life:
To get the subforums bold you have to edit the part in forum.php and after that, you have to edit a forum to update the cache like you have to do when you first install the hack.

Thanks. Worked like a charm.

[csidlernet]

Thankyou!

/me hits install button

[kaotic]

I would really like to install this nice little hack, but sadly, I'm getting an error:

Database error in vBulletin Control Panel 2.3.0:

Invalid SQL: UPDATE forum SET subforums=''
mysql error: Unknown column 'subforums' in 'field list'

mysql error number: 1054

I triple checked the query that I was suppose to run. It worked perfectly. Can someone point me in the right direction?

[Xenon]

you must have made an error while runing the alter table query.
do it again, i can't help any further....

[kaotic]

Is there another method that I could use to update the cache? Like a query that I could run myself.

[Xenon]

to update the cache yourself you have to run a lot of queries yourself, so i don't suggest you'd do that ^^

also the problem you reported above is not because of the caching, but because you haven't installed the hack correctly

[kaotic]

I knew I followed instructions correctly. After running repair.php, it finally started working. Thanks for the hack.

[Xenon]

ah, ok a db problem could always produce unknown bugs ^^

[Oblivion Knight]

Working like a charm, as always Xenon

[lifesourcerec]

Can't get it to work on v2.3.0