I have been combing through the stored procedures trying to find a way to modify the displayed order of subforums when viewing a page at:

http://localhost/forum/default.aspx?g=topics&f=2

I would like to avoid manually entering an adjusting SORT ORDER values in the admin page for every subforum every time a new one is created and would desire the subforum list to merely come out in alphabetical order by their name.

I am a dunce at this...but searching the forum here didn't really turn up any ideas for me...

Which stored proc actually delivers this listings and can I merely modify its ORDER BY statement....or are the data_sort routines I see in the DB.cs class going to mess me up even if I deliver the datasets in a different order?

Thanks for your help. I owe folks a beer if they can point me in the right direction...

You set the sort order in the admin section. Either when creating the forum, or by editing it and re-setting the sort order. The sort order is numerical (by forum, board topic ID), to change this, you'll have to re-code YAF to do so.

I had the haunting feeling I was stuck with manually setting the sort order for subforums in the admin screen without a major recode since there did not appear to be a stored procedure really controlling the order of data I could easily modify with an ORDER BY clause...

Cheers and thanks...