Announcement

Collapse
No announcement yet.

Is there a querry that will allow me to do this?

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

  • Is there a querry that will allow me to do this?

    Hi all,

    I am wanting to set all the default view age of all the threads in my forums to a different number than what we used when we first built our board.

    Rather than changing each one individually, is there a querry that I can execute that will change them all? I hate the tought of having to do each one manually!

    Any help will be appreciated.

    Thanks in advance.
    Last edited by Cancorp; Mon 30 Jun '03, 7:49am.

  • #2
    UPDATE forum SET daysprune = {x}

    where {x} = the number of days to display.
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment


    • #3
      Thank you so much Steve! You have no idea how how much work you just saved me.

      *does a happy dance and runs off to phpMyAdmin*

      Comment


      • #4
        What would you put in x to show all threads?
        Alan

        Comment


        • #5
          That query is for vB2, and you would use 1000 to show all threads.
          Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
          Change CKEditor Colors to Match Style (for 4.1.4 and above)

          Steve Machol Photography


          Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


          Comment

          widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
          Working...
          X