Announcement

Collapse
No announcement yet.

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

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

  • 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?

  • #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...
    X