Announcement

Collapse
No announcement yet.

Finding users that declined Admin email.

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

  • Finding users that declined Admin email.

    Is the a way to produce a list or search for members that have "declined Admin email", other than manually going through each users profile?

  • #2
    This query will generate a list of userids and usernames that have that option disabled.

    Code:
    SELECT userid, username
    FROM user
    WHERE NOT(options & 16)

    Comment

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