COPPA user Yes|No flag in database that matches the admincp field?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • randomdriver
    Member
    • Jul 2010
    • 30
    • 3.8.x

    COPPA user Yes|No flag in database that matches the admincp field?

    In the admincp if a user is COPPA there is a flag with a Yes|No radio button option. I haven't been able to figure out where that is in the database in the user table. Any suggestions or help?
  • Lats
    Senior Member
    • Mar 2002
    • 3671

    #2
    It's stored as a bitfield, so a query to show all coppa users would be...
    Code:
    SELECT
        userid
    FROM
        user
    WHERE (options & 8)
    8 = is coppa user
    Lats...

    Comment

    Related Topics

    Collapse

    Working...