Query for 'Warn Administrators'

[Eagle Creek]

Hi!

I want to enable the Warn Administrators option on all my forums. What's the query I can use?

[Floris]

Turn on/off 'Warn Administrators' for all forums:
On: UPDATE forum SET options=options + 131072 WHERE NOT(options & 131072);
Off: UPDATE forum SET options=options - 131072 WHERE (options & 131072);

Note Check for a table prefix before running the query otherwise it will fail.

[Eagle Creek]

Thank you!

I don't have a table prefix. Is that a problem?

[Colin F]

Not at all.