Log in

View Full Version : Close all threads in a forum


sully02
09-03-2005, 10:38 PM
I think I've got this right, but figured I'd ask before doing something that may or may not mess up my forums. I'd like to lock all threads in a forum. Only problem is, that would mean going through and closing several hundred-plus threads. Here's the query I'm thinking will do the trick, I just want to know if it's the right one (Note that vb3_ represents a table prefix):

UPDATE 'vb3_thread' SET 'open' = 0 WHERE 'forumid' = (forum's ID#)

Yea or nay?

White_Snake
09-03-2005, 11:51 PM
i think is also right, seems fine for me but in anycase is good always to have a test board :)