Announcement

Collapse
No announcement yet.

Is there a mysql query list somewhere

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Is there a mysql query list somewhere

    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.
    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)
    Greetings, Black Tiger
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X