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
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
Comment