+ Reply to Thread
Results 1 to 2 of 2

Thread: Need Query: all forums last post descending

  1. #1
    Member Hendrizius has disabled reputation Hendrizius's Avatar
    Join Date
    May 2007
    Posts
    61

    Need Query: all forums last post descending

    Which query do I have to use to show the posts in all forums sorted descending by last post?

    Thanks.
    www.duoblogger.com - blogging about advertising.
    Twitter: @hendricius

  2. #2
    vBulletin Team Jake Bunce has a spectacular aura about Jake Bunce has a spectacular aura about Jake Bunce's Avatar
    Join Date
    Dec 2000
    Location
    Land of the In-N-Out Burger
    Age
    28
    Posts
    46,521
    Run these queries:

    Code:
    UPDATE forum
    SET defaultsortorder = 'desc'
    Code:
    UPDATE forum
    SET defaultsortfield = 'lastpost'
    Then you will need to update your forum info:

    Admin CP -> Maintenance -> Update Counters

+ Reply to Thread

Similar Threads

  1. changing all forums to descending and last post time
    By xjuliox in forum vBulletin 3.6 Questions, Problems and Troubleshooting
    Replies: 6
    Last Post: Sun 25th Nov '07, 2:10am
  2. ascending and descending threads
    By Pagefault in forum vBulletin 2 'How Do I' and Troubleshooting
    Replies: 13
    Last Post: Fri 2nd Nov '07, 7:54pm
  3. How to put Posts descending ?
    By Christian8a in forum vBulletin 3.6 Questions, Problems and Troubleshooting
    Replies: 1
    Last Post: Wed 16th May '07, 12:54am
  4. Ascending / Descending Post Issue
    By anjaan79 in forum vBulletin 3.6 Questions, Problems and Troubleshooting
    Replies: 3
    Last Post: Tue 23rd Jan '07, 8:30pm
  5. Query to check post counts enabled on all forums
    By mvigod in forum vBulletin 3.5 'How Do I' Questions and Troubleshooting
    Replies: 3
    Last Post: Mon 8th Aug '05, 3:41pm

Bookmarks

Posting Permissions

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