Announcement

Collapse
No announcement yet.

Question about the "AdminEmail" checkbox

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

  • Jake Bunce
    replied
    Code:
    SELECT *
    FROM vb_user
    WHERE options & 16

    Leave a comment:


  • cerebro
    replied
    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.

    Leave a comment:


  • Jake Bunce
    replied
    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)

    Leave a comment:


  • cerebro
    started a topic Question about the "AdminEmail" checkbox

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