order ALL subforums in alphabetical order

[Tilmanitou]

I am searching for a way to order ALL sub-forums in my forum in alphabetical order.
in vB2 it was done like that:

in forumdisplay.php:

find:

PHP Code:

$forums=$DB_site->query('SELECT * FROM forum WHERE displayorder<>0 AND active=1 ORDER BY parentid,displayorder,forumid'); 


and replace with:

PHP Code:

$forums=$DB_site->query('SELECT * FROM forum WHERE displayorder<>0 AND active=1 ORDER BY parentid,title,forumid'); 


pretty easy and small hack, just one word to change. is there anyone out there who knows how to do that in vB3?
Thanks!

[KW802]

*bump*

Any quick solutions for VB3?

[AN-net]

y dont u just order them using the display number system built into vb

[kodeking]

I think because he has A LOT of sub forums, say for a game site that has a sub forum for each game. It would be nice to be able to add a forum and not have to worry about re-arranging.

[Rich]

Hello,
This would be nice. I have over 100 forums and I have manually rearranged them as I add another. This would save me a great deal of time. perhaps I will look further into it when I have a minute and see what i can come up with.