Listing Sub-Forums in alphabetical order..

[Tweaksta]

Greetings...

After much hunting I have discovered that vBulletin doesn't have the ability to list all of my Sub-Forums alphabetically out of the box....it can be done by inserting the right bit of code into the right .php file.

Can any of you vBulletin Modders give me a push in the right direction here?

I was just reminiscing how easy it was to write a BASIC program 25 years ago which could sort lists alphabetically. Isn't it funny how with today's powerful computers and software I've had to submit multiple posts to multiple forums in the hope that I've caught the attention of someone who can answer this?

Oh, and manually doing it isn't an option - several thousand subforums and daily additions/removals. It needs to be 100% automatic.

Thanks in advance!!

[Dismounted]

You could probably create a script to sort the forums using sort().

[Lynne]

I posted this on your thread at vb.com:

Go to the file /includes/adminfunctions.php around line 3077. There is a query called $newforumcache and it is ORDER BY displayorder. Change that line to ORDER BY title. Save. Upload file. You may have to go to Forum Manager and hit Save Display Order to get the datastore cache rebuilt. See if that works. Warning though!!! That will put it all in alphabetical order including the Main Categories. You would have to tweak that area in the code to do it differently.

[Tweaksta]

Thank you!!

It worked!!

This is exactly what I was after....

Special thanks to Lynne!

[sundarmobiles]

is this possible to make this one only forum subforum? i dont want main forum is this possible

[Killhunter]

is this possible to make this one only forum subforum? i dont want main forum is this possible

same problem here

[insidegames]

same problem here..

--------------- Added 1360267704 at 1360267704 ---------------

is this possible to make this only one forum subforum? i dont want all my main forum are listed in alphabetical order.

i want only listed this sub-forums:

http://forum.insidegames.ch/xbox-live-arcade-games-f173
http://forum.insidegames.ch/windows-phone-7-games-f218
http://forum.insidegames.ch/playstation-vita-games-f838
http://forum.insidegames.ch/xbox-360-ps3-retail-games-f96

and all subforums in their subforums

[insidegames]

Nobody?

[Lynne]

Did you try just putting a condition around it based on the forumid?

[insidegames]

Hi, thank you very much for your kind response. Actually we tried to solve the problem by adding a field in the order by part of the Query (actually i do not remember which one but the idea was to order by Forum an then by title if I remember well). But this didn't change anything (maybe it was the wrong field). Is that what you asked or do you mean an approach on the forum structure itself ?

[Lynne]

It's hard to know if you did it correctly if you don't post the exact code you used and then let us see the results.

[insidegames]

It was:

There is a query called $newforumcache and it is ORDER BY displayorder. Change that line to ORDER BY title

ORDER BY parentid, title

[christleo]

Can i sort sub forum by lastest thread/post reply?

[zhono]

Anyone that's still looking for this, follow Lynne's instructions, but use this:

ORDER BY displayorder, title

Now what will happen is the display order will work normally. But if you want some subforums to be listed/displayed alphabetically, just give them the same display number. For your existing forums to get this, just go to maintencance and rebuild forum information. All new forums added will get placed alphabetically right from the start IF you use the same display number. If you use a different number, it'll will be listed where it normally would. But if you later decide to change the number to the same as the rest and hit save, it'll pop right in line with the alphabetical stuff. So far I haven't seen any issues with this method and it's incredibly simple and easy to manage my 400+ subforums. Some are alpha, some are not, and it doesn't take me ANY time to mess around with display order numbers.:D

*EDIT* A little clarification. Just because some items have the same number, doesn't mean they will be sorted alphabetically. They have to have the same number AND be subforums of the SAME forum or category.

[Ghostt]

big Thanks to zhono and lynne . this helped me and safed a lot of work!