MySQL statement that sets all forums to html disabled?

[ludachris]

I just realized that many of my forums and sub forums have HTML enabled. Can someone share the MySQL syntax to set all forums to disabled?

[kh99]

I *think* this works:

UPDATE forum set options = options & ~256 WHERE (options & 256 != 0)

But I think I'd feel better about going through the forum manager and looking at the settings, unless you have hundreds of child forums or something.

[ludachris]

I have over 100 child forums, that's why I'd like to try to do a mass change.

[kh99]

OK, well I did test it a bit and it seemed to turn off that option, but now that I think of it you mgiht also have to force it to rebuild some cached info, which you can do (after running the query) by going to the forum manager, editing a forum and pressing "save".