Howto Show threads from the beginning, sorted by Last Post Time in Descending Order?

[nyunyu]

My forum is currently show threads from the beginning, sorted by Thread Title in Ascending order by default.

How can I change default setting to:

Show threads from the beginning, sorted by Last Post Time in Descending Order?

I need this setting to be permanent, i.e. this setting will be applied to all users. I believe I can run sql query correct? Can anyone give me the query to do this?

Many thanks.

[borbole]

Originally Posted by nyunyu

My forum is currently show threads from the beginning, sorted by Thread Title in Ascending order by default.

How can I change default setting to:

Show threads from the beginning, sorted by Last Post Time in Descending Order?

I need this setting to be permanent, i.e. this setting will be applied to all users. I believe I can run sql query correct? Can anyone give me the query to do this?

Many thanks.

You can change that on a forum per forum basis at Forum Manager-Edit Forum and the options you need are:

Default View Age

Default Sort Field

Default Sort Order


or you can change them for all the forums in one fell swoop at the phpmyadmin in the cp of your host by running the following queries:

To show threads from the begin:

UPDATE forum SET daysprune = -1

To sort by Last Post Time:

UPDATE forum SET defaultsortfield = 'lastpost';

Whereas to sort in a descending order:

UPDATE forum SET defaultsortorder = 'desc';

If your db tables have a prefix you should include that as well in the query. Hope it helps.

[nyunyu]

Thanks borbole, that does the trick!
Although I see no difference after I did that, I remember that I need to update the counter after any changes.

Admin CP -> Import & Maintenance -> Update Counters -> Rebuild Forum Information

Thanks again.

[borbole]

You are welcome. Glad to have been of help.

[markoroots]

Thanks guys.
You have also helped me. And sure many others.

[markoroots]

Sorry but if I'm using a prefix where must be added??
Thanks in advance.

[kh99]

Originally Posted by markoroots

Sorry but if I'm using a prefix where must be added??
Thanks in advance.

If you have a table prefix, it would go before forum. for example, if your prefix is 'vb', then you'd need something like this:

UPDATE vbforum SET defaultsortorder = 'desc';