Announcement

Collapse
No announcement yet.

Question about the "AdminEmail" checkbox

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

  • Question about the "AdminEmail" checkbox

    Hi everyone, i was wondering, under what table in the db can i find the "AdminEmail" checkbox value that indicates if the user wants to receive staff email or not?

    Thanks in advance

  • #2
    It is contained within a bit field. For example, run this query to disable that option for all users (backup first):

    Code:
    UPDATE user
    SET options = options - 16
    WHERE options & 16
    Run this one to enable it:

    Code:
    UPDATE user
    SET options = options + 16
    WHERE NOT(options & 16)

    Comment


    • #3
      So i suppose that if i want to get all the users that has this option enabled i should run the query:

      Code:
      SELECT vb_user WHERE options & 16
      right? Thanks for the answer.

      Comment


      • #4
        Code:
        SELECT *
        FROM vb_user
        WHERE options & 16

        Comment

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