Announcement

Collapse
No announcement yet.

Query to reset options by email address

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

  • Query to reset options by email address

    I want to reset the options for all AOL users so that they do not receive any emails generated by vB unless they opt in again.

    These are all of them I think:

    - Receive email from administrators
    - Receive email from other members
    - Notification of new replies to subscribed threads
    - Notification of new Private Messages

    Can someone help me with the queries that I would need to run please?

    Thanks
    John

  • #2
    - Receive email from administrators

    Code:
    UPDATE [color=green]user[/color]
    SET [color=blue]options[/color] = [color=blue]options[/color] - [color=red]16[/color]
    WHERE [color=blue]options[/color] & [color=red]16[/color]
    AND email LIKE '%aol.com'
    - Receive email from other members

    Code:
    UPDATE [color=green]user[/color]
    SET [color=blue]options[/color] = [color=blue]options[/color] - [color=red]256[/color]
    WHERE [color=blue]options[/color] & [color=red]256[/color]
    AND email LIKE '%aol.com'
    - Notification of new replies to subscribed threads

    Code:
    UPDATE user
    SET autosubscribe = -1
    WHERE email LIKE '%aol.com'
    - Notification of new Private Messages

    Code:
    UPDATE [color=green]user[/color]
    SET [color=blue]options[/color] = [color=blue]options[/color] - [color=red]4096[/color]
    WHERE [color=blue]options[/color] & [color=red]4096[/color]
    AND email LIKE '%aol.com'
    That should do it. Backup first.

    See this thread for a detailed explanation.

    Comment


    • #3
      Originally posted by Jake Bunce
      See this thread for a detailed explanation.
      Thanks Jake

      I did search the forums, but I obviously missed that one!

      John

      Comment

      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
      Working...
      X