I wonder because I've got some custom mysql query's to make.
For instance I would like to remove all subscribtions to threads for users who got banned (usergroupid 10).
How do I do that?
If there was a list it would make things a lot easyer.
I already got these, but it would be nicer if the list was complete.
For instance I would like to remove all subscribtions to threads for users who got banned (usergroupid 10).
How do I do that?
If there was a list it would make things a lot easyer.
I already got these, but it would be nicer if the list was complete.

Set Everyone's showsignatures to off:
UPDATE user SET options=options-1 WHERE options&1
Set Everyone's showsignatures to on
UPDATE user SET options=options+1 WHERE NOT(options&1)
Set Everyone's showavatars to off:
UPDATE user SET options=options-2 WHERE options&2
Set Everyone's showavatars to on:
UPDATE user SET options=options+2 WHERE NOT(options&2)
Set Everyone's showimages to off:
UPDATE user SET options=options-4 WHERE options&4
Set Everyone's showimages to on:
UPDATE user SET options=options+4 WHERE NOT(options&4)
Set Everyone's showvbcode to off:
UPDATE user SET options=options-8 WHERE options&8
Set Everyone's showvbcode to on:
UPDATE user SET options=options+8 WHERE NOT(options&8)
UPDATE user SET options=options-1 WHERE options&1
Set Everyone's showsignatures to on
UPDATE user SET options=options+1 WHERE NOT(options&1)
Set Everyone's showavatars to off:
UPDATE user SET options=options-2 WHERE options&2
Set Everyone's showavatars to on:
UPDATE user SET options=options+2 WHERE NOT(options&2)
Set Everyone's showimages to off:
UPDATE user SET options=options-4 WHERE options&4
Set Everyone's showimages to on:
UPDATE user SET options=options+4 WHERE NOT(options&4)
Set Everyone's showvbcode to off:
UPDATE user SET options=options-8 WHERE options&8
Set Everyone's showvbcode to on:
UPDATE user SET options=options+8 WHERE NOT(options&8)