Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 14 Apr 2010, 06:20
nyunyu nyunyu is offline
 
Join Date: Dec 2004
Howto Show threads from the beginning, sorted by Last Post Time in Descending Order?

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.
Reply With Quote
  #2  
Old 14 Apr 2010, 15:01
borbole's Avatar
borbole borbole is offline
 
Join Date: Jan 2010
Originally Posted by nyunyu View Post
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.
__________________
My mods.
Reply With Quote
  #3  
Old 14 Apr 2010, 17:00
nyunyu nyunyu is offline
 
Join Date: Dec 2004
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.
Reply With Quote
  #4  
Old 14 Apr 2010, 17:08
borbole's Avatar
borbole borbole is offline
 
Join Date: Jan 2010
You are welcome. Glad to have been of help.
__________________
My mods.
Reply With Quote
  #5  
Old 29 May 2014, 17:53
markoroots markoroots is offline
 
Join Date: May 2013
Real name: Marco Miglietta
Thanks guys.
You have also helped me. And sure many others.
Reply With Quote
  #6  
Old 07 Nov 2014, 15:48
markoroots markoroots is offline
 
Join Date: May 2013
Real name: Marco Miglietta
Sorry but if I'm using a prefix where must be added??
Thanks in advance.
Reply With Quote
  #7  
Old 07 Nov 2014, 16:10
kh99 kh99 is offline
 
Join Date: Aug 2009
Real name: Kevin
Originally Posted by markoroots View Post
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.

Reply With Quote
Reply

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mini Mods Show poll results in descending order 1.0 ForumsMods vBulletin 3.7 Add-ons 9 01 May 2012 20:20
Show poll results in descending order Andreas vBulletin 3.0 Full Releases 24 29 Oct 2007 22:17



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 19:34.

Layout Options | Width: Wide Color: