1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

2400 Users Awaiting Approval

Discussion in 'XenForo Questions and Support' started by alkahf, May 28, 2013.

  1. alkahf

    alkahf Member

    how can i Approve them ?
  2. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    Run this query on your database to approve all users who are currently awaiting approval:

    UPDATE xf_user
    SET user_state = 'valid'
    WHERE user_state = 'moderated';
    Allan likes this.
  3. alkahf

    alkahf Member

    2409 rows affected. ( Query took 0.1493 sec ) (y)
    Thank U so much Jake

  4. cjwinternet

    cjwinternet Member

    Could someone please supply the various user state names please to use in SQL.

  5. Brogan

    Brogan XenForo Moderator Staff Member

    I believe this is related to your other thread, which I responded to.

    However, the possible states are: 'valid','email_confirm','email_confirm_edit','moderated','email_bounce'
  6. Fred.

    Fred. Well-Known Member

    Interesting to know.

    Just because I can't add tags here and I want to be able to find this back.

    Update user state :)
  7. Allan

    Allan Well-Known Member

    Thank you :)

Share This Page