Show Signatures
On: UPDATE user SET options=options + 1 WHERE NOT(options & 1);
Off: UPDATE user SET options=options - 1 WHERE options & 1;
Show Avatars
On: UPDATE user SET options=options + 2 WHERE NOT(options & 2);
Off: UPDATE user SET options=options - 2 WHERE options & 2;
Show Images
On: UPDATE user SET options=options + 4 WHERE NOT(options & 4);
Off: UPDATE user SET options=options - 4 WHERE options & 4;
COPPA User
Yes: UPDATE user SET options=options + 8 WHERE NOT(options & 8);
No: UPDATE user SET options=options - 8 WHERE options & 8;
Receive Admin Emails
On: UPDATE user SET options=options + 16 WHERE NOT(options & 16);
Off: UPDATE user SET options=options - 16 WHERE options & 16;
vCard Download
On: UPDATE user SET options=options + 32 WHERE NOT(options & 32);
Off: UPDATE user SET options=options - 32 WHERE options & 32;
DST Auto-Correct
On: UPDATE user SET options=options + 64 WHERE NOT(options & 64);
Off: UPDATE user SET options=options - 64 WHERE options & 64;
DST On/Off
On: UPDATE user SET options=options + 128 WHERE NOT(options & 128);
Off: UPDATE user SET options=options - 128 WHERE options & 128;
Show Email Address
On: UPDATE user SET options=options + 256 WHERE NOT(options & 256);
Off: UPDATE user SET options=options - 256 WHERE options & 256;
Invisible
On: UPDATE user SET options=options + 512 WHERE NOT(options & 512);
Off: UPDATE user SET options=options - 512 WHERE options & 512;
Show Reputation
On: UPDATE user SET options=options + 1024 WHERE NOT(options & 1024);
Off: UPDATE user SET options=options - 1024 WHERE options & 1024;
Receive PMs
On: UPDATE user SET options=options + 2048 WHERE NOT(options & 2048);
Off: UPDATE user SET options=options - 2048 WHERE options & 2048;
Get email for new PMs
On: UPDATE user SET options=options + 4096 WHERE NOT(options & 4096);
Off: UPDATE user SET options=options - 4096 WHERE options & 4096;
Show New Private Message Notification Pop-up
On: UPDATE user SET pmpopup = 1;
Off: UPDATE user SET pmpopup = 0;
Post Order
Newest first: UPDATE user SET options=options + 32768 WHERE NOT(options & 32768);
Oldest first: UPDATE user SET options=options - 32768 WHERE options & 32768;
Receive Private Messages only from Buddies
On: UPDATE user SET options=options + 131072 WHERE NOT(options & 131072);
Off: UPDATE user SET options=options - 131072 WHERE options & 131072;
Show User CSS on Profiles
On: UPDATE user SET options=options + 1048576 WHERE NOT(options & 1048576);
Off: UPDATE user SET options=options - 1048576 WHERE options & 1048576;
Enable Visitor Messages
On: UPDATE user SET options=options + 8388608 WHERE NOT(options & 8388608);
Off: UPDATE user SET options=options - 8388608 WHERE options & 8388608;
Limit Visitor Messages to Contacts
On: UPDATE user SET options=options + 16777216 WHERE NOT(options & 16777216);
Off: UPDATE user SET options=options - 16777216 WHERE options & 16777216;
Save Copy of PMs by Default
On: UPDATE user SET options=options + 33554432 WHERE NOT(options & 33554432);
Off: UPDATE user SET options=options - 33554432 WHERE options & 33554432;
On: UPDATE user SET options=options + 1 WHERE NOT(options & 1);
Off: UPDATE user SET options=options - 1 WHERE options & 1;
Show Avatars
On: UPDATE user SET options=options + 2 WHERE NOT(options & 2);
Off: UPDATE user SET options=options - 2 WHERE options & 2;
Show Images
On: UPDATE user SET options=options + 4 WHERE NOT(options & 4);
Off: UPDATE user SET options=options - 4 WHERE options & 4;
COPPA User
Yes: UPDATE user SET options=options + 8 WHERE NOT(options & 8);
No: UPDATE user SET options=options - 8 WHERE options & 8;
Receive Admin Emails
On: UPDATE user SET options=options + 16 WHERE NOT(options & 16);
Off: UPDATE user SET options=options - 16 WHERE options & 16;
vCard Download
On: UPDATE user SET options=options + 32 WHERE NOT(options & 32);
Off: UPDATE user SET options=options - 32 WHERE options & 32;
DST Auto-Correct
On: UPDATE user SET options=options + 64 WHERE NOT(options & 64);
Off: UPDATE user SET options=options - 64 WHERE options & 64;
DST On/Off
On: UPDATE user SET options=options + 128 WHERE NOT(options & 128);
Off: UPDATE user SET options=options - 128 WHERE options & 128;
Show Email Address
On: UPDATE user SET options=options + 256 WHERE NOT(options & 256);
Off: UPDATE user SET options=options - 256 WHERE options & 256;
Invisible
On: UPDATE user SET options=options + 512 WHERE NOT(options & 512);
Off: UPDATE user SET options=options - 512 WHERE options & 512;
Show Reputation
On: UPDATE user SET options=options + 1024 WHERE NOT(options & 1024);
Off: UPDATE user SET options=options - 1024 WHERE options & 1024;
Receive PMs
On: UPDATE user SET options=options + 2048 WHERE NOT(options & 2048);
Off: UPDATE user SET options=options - 2048 WHERE options & 2048;
Get email for new PMs
On: UPDATE user SET options=options + 4096 WHERE NOT(options & 4096);
Off: UPDATE user SET options=options - 4096 WHERE options & 4096;
Show New Private Message Notification Pop-up
On: UPDATE user SET pmpopup = 1;
Off: UPDATE user SET pmpopup = 0;
Post Order
Newest first: UPDATE user SET options=options + 32768 WHERE NOT(options & 32768);
Oldest first: UPDATE user SET options=options - 32768 WHERE options & 32768;
Receive Private Messages only from Buddies
On: UPDATE user SET options=options + 131072 WHERE NOT(options & 131072);
Off: UPDATE user SET options=options - 131072 WHERE options & 131072;
Show User CSS on Profiles
On: UPDATE user SET options=options + 1048576 WHERE NOT(options & 1048576);
Off: UPDATE user SET options=options - 1048576 WHERE options & 1048576;
Enable Visitor Messages
On: UPDATE user SET options=options + 8388608 WHERE NOT(options & 8388608);
Off: UPDATE user SET options=options - 8388608 WHERE options & 8388608;
Limit Visitor Messages to Contacts
On: UPDATE user SET options=options + 16777216 WHERE NOT(options & 16777216);
Off: UPDATE user SET options=options - 16777216 WHERE options & 16777216;
Save Copy of PMs by Default
On: UPDATE user SET options=options + 33554432 WHERE NOT(options & 33554432);
Off: UPDATE user SET options=options - 33554432 WHERE options & 33554432;
Comment