Cevap: User options queries Make all forums active/inactive: Active: UPDATE forum SET options=options + 1 WHERE NOT(options & 1); Inactive: UPDATE forum SET options=options - 1 WHERE (options & 1);
Open/Close all forums for new posts: Open: UPDATE forum SET options=options + 2 WHERE NOT(options & 2); Close: UPDATE forum SET options=options - 2 WHERE (options & 2);
Set all forums to act as categories/forums: Act as forums: UPDATE forum SET options=options + 4 WHERE NOT(options & 4); Act as categories:UPDATE forum SET options=options - 4 WHERE (options & 4);
Turn on/off Post Moderation for all forums: On: UPDATE forum SET options=options + 8 WHERE NOT(options & 8); Off: UPDATE forum SET options=options - 8 WHERE (options & 8); Turn on/off Thread Moderation for all forums: On: UPDATE forum SET options=options + 16 WHERE NOT(options & 16); Off: UPDATE forum SET options=options - 16 WHERE (options & 16); Turn on/off Attachment Moderation for all forums: On: UPDATE forum SET options=options + 32 WHERE NOT(options & 32); Off: UPDATE forum SET options=options - 32 WHERE (options & 32); Turn on/off BBCode for all forums: On: UPDATE forum SET options=options + 64 WHERE NOT(options & 64); Off: UPDATE forum SET options=options - 64 WHERE (options & 64); Turn on/off Images for all forums: On: UPDATE forum SET options=options + 128 WHERE NOT(options & 128); Off: UPDATE forum SET options=options - 128 WHERE (options & 128); Turn on/off HTML for all forums: On: UPDATE forum SET options=options + 256 WHERE NOT(options & 256); Off: UPDATE forum SET options=options - 256 WHERE (options & 256); Turn on/off Smilies for all forums: On: UPDATE forum SET options=options + 512 WHERE NOT(options & 512); Off: UPDATE forum SET options=options - 512 WHERE (options & 512); Turn on/off Post Icons for all forums: On: UPDATE forum SET options=options + 1024 WHERE NOT(options & 1024); Off: UPDATE forum SET options=options - 1024 WHERE (options & 1024); Turn on/off Thread Rating for all forums: On: UPDATE forum SET options=options + 2048 WHERE NOT(options & 2048); Off: UPDATE forum SET options=options - 2048 WHERE (options & 2048); Turn on/off Post Counting for all forums: On: UPDATE forum SET options=options + 4096 WHERE NOT(options & 4096); Off: UPDATE forum SET options=options - 4096 WHERE (options & 4096); Set 'Can have Password' on/off for all forums: On: UPDATE forum SET options=options + 8192 WHERE NOT(options & 8192); Off: UPDATE forum SET options=options - 8192 WHERE (options & 8192); Turn on/off Search Indexing for all forums: On: UPDATE forum SET options=options + 16384 WHERE NOT(options & 16384); Off: UPDATE forum SET options=options - 16384 WHERE (options & 16384); Turn on/off Style Overriding for all forums: On: UPDATE forum SET options=options + 32768 WHERE NOT(options & 32768); Off: UPDATE forum SET options=options - 32768 WHERE (options & 32768); Turn on/off 'Show on ForumJump Menu' for all forums: On: UPDATE forum SET options=options + 65536 WHERE NOT(options & 65536); Off: UPDATE forum SET options=options - 65536 WHERE (options & 65536); 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); |