Delete all posts except if in forumid x,xx - vbulletin

Discussion in 'vBulletin' started by MixedBag, Oct 28, 2009.

0
  1. #1
    Hi,

    I was wondering if it were possible to delete all threads from my vbulletin database, except those in a specific forum. I have the forum IDs of the sections I have threads in I want to keep but I need to delete all the other threads which aren't in the specified forums.

    Is it possible to do this through a SQL command? I've been manually deleting for the past 15 minutes and seem to be getting no where! :(
     
    MixedBag, Oct 28, 2009 IP
  2. digitalpoint

    digitalpoint Overlord of no one Staff

    Messages:
    38,334
    Likes Received:
    2,613
    Best Answers:
    462
    Trophy Points:
    710
    Digital Goods:
    29
    #2
    You probably want to do it from the admin... Threads & Posts -> Prune

    Doing it direct in the database will cause problems with numbering of things like post counts.
     
    digitalpoint, Oct 28, 2009 IP
  3. Skyline_GTR

    Skyline_GTR Well-Known Member

    Messages:
    442
    Likes Received:
    10
    Best Answers:
    0
    Trophy Points:
    130
    #3
    Or you can move all the posts in the forums that you want to delete to one forum, then prune all the posts in that one forum.
     
    Skyline_GTR, Oct 31, 2009 IP