[Booost This]

Originally Posted by Analogpoint

Sure, you could do it by editing the file, or with a plugin, but it's going to be a lot easier to just run the following 2 lines (as separate SQL queries) (vB ACP -> Maintenance -> Execute SQL Query)

[sql]UPDATE forum SET defaultsortfield = 'title'[/sql]

[sql]UPDATE forum SET defaultsortorder = 'asc'[/sql]

Then run "Rebuild Forum Information" in ACP -> Maintenance -> Update Counters.

Thanks but is this reversible? I want a solution that is completely reversible if need be. I would prefer to edit the file whereas if I would like to change it all I have to do is upload the original.

To make these queries reversable i would just have to change it to

[sql]UPDATE forum SET defaultsortfield = 'lastpost'[/sql]

[sql]UPDATE forum SET defaultsortorder = 'desc'[/sql]

Correct?