Query required to set all users "COPPA User" to NO

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • fer_75
    Member
    • May 2007
    • 82

    [Forum] Query required to set all users "COPPA User" to NO

    Hi,

    I have imported some users to my board, it is all working perfect. But now all that users has "COPPA User" set to YES.

    I would like to run a query to SET all COPPA User to NO. I do not find the field for coppa in user table.

    Could you please help me out and provide me the right Query to set all user coppa field to NO?



    Can some please help me with this query ?
  • viarun
    New Member
    • Feb 2010
    • 11

    #2
    update user set options = options - 8 WHERE (options & 8);


    Or, if your user table has the vb_ prefix:

    update vb_user set options = options - 8 WHERE (options & 8);

    Comment

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