Announcement

Collapse
No announcement yet.

mass change "Default sort field"

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • mass change "Default sort field"

    How can I change the default sort field for all forums to list it by latest post? I saw a thread on this before, I think, but cannot find it. Thanks!
    Check out my creative writing forum.

  • #2
    You most likely seen it within this thread.
    http://www.vbulletin.com/forum/showthread.php?t=213135


    It is this thread, as the other I gave is for post within a thread.
    http://www.vbulletin.com/forum/showthread.php?t=249152

    Comment


    • #3
      OK.... but can you explain step by step what I do with this information?

      I don't know where to cut and paste that code to.

      Complete noob here so step by step would REALLY help!!!

      Comment


      • #4
        Originally posted by floydian1 View Post
        OK.... but can you explain step by step what I do with this information?

        I don't know where to cut and paste that code to.

        Complete noob here so step by step would REALLY help!!!
        Execute SQL Query
        Maintenance > Execute SQL Query

        Manual Query – if you wish to run your own query, you may enter it here. Ensure that no Automatic Query is selected. Additionally, you may only run one query at a time.
        These are two seperate queries that needs to be run individually
        Code:
        UPDATE forum SET defaultsortfield = 'lastpost'
        UPDATE forum SET defaultsortorder = 'desc'
        Make sure you read all within manual page.

        Comment

        Loading...
        Working...
        X