Close query

[Eagle Creek]

Hi!

I want to close all my forums. What query do I need?

UPDATE forum
SET ??='-?'

[Eagle Creek]

Also I want to give all my forums the propertie of "Forum is Active".

[Colin F]

Check here: http://www.vbulletin.com/forum/showthread.php?t=197826

[Eagle Creek]

That's an awesome thread! Bookmarked it!

Thank you

[Eagle Creek]

I ran
Open/Close all forums for new posts:
Close: UPDATE forum SET options=options - 2 WHERE (options & 2);

But all my forums are still opened?

EDIT: Oops.. I forgot to rebuild the forum stats .

[Colin F]

That query works fine for me.
Can you actually start a new thread?

[Eagle Creek]

Look at my edit: EDIT: Oops.. I forgot to rebuild the forum stats .
The forums didn't show the closed icon. After this, they did.

Thanks for your reply Colin!