vBulletin Mods

The Official vBulletin Modifications Site
https://www.vbulletin.org/forum/showthread.php?t=240421

Howto Show threads from the beginning, sorted by Last Post Time in Descending Order?
by nyunyu
14 Apr 2010 07:20

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 14 Apr 2010 16:01

Quote:

Originally Posted by nyunyu (Post 2020909)
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:


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.



To sort by Last Post Time:


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.


Whereas to sort in a descending order:


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.



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

nyunyu 14 Apr 2010 18:00

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 14 Apr 2010 18:08

You are welcome. Glad to have been of help.

markoroots 29 May 2014 18:53

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

markoroots 07 Nov 2014 16:48

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

kh99 07 Nov 2014 17:10

Quote:

Originally Posted by markoroots (Post 2521814)
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:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.



All times are GMT. The time now is 23:48.

Powered by vBulletin® Version 3.8.14
Copyright © 2020, MH Sub I, LLC dba vBulletin. All Rights Reserved. vBulletin® is a registered trademark of MH Sub I, LLC
Copyright ©2001 - , vbulletin.org. All rights reserved.