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

XF 1.2 Anyway to mass approve "awaiting e-mail activation" users?

Discussion in 'XenForo Questions and Support' started by Sage Knight, Jan 29, 2014.

  1. Sage Knight

    Sage Knight Well-Known Member

    As per the title of the thread, is their any query or addon that provides this?

    Or any other way.

  2. Liam W

    Liam W Well-Known Member

    UPDATE TABLE `xf_user` SET `user_state`='valid' WHERE `user_state`='email_confirm';
    Should work but I haven't tested it.

    Sage Knight likes this.
  3. Sage Knight

    Sage Knight Well-Known Member

    I'll test this on a test board and report back. Thanks =]
  4. Itworx4me

    Itworx4me Well-Known Member

    @Sage Knight
    Why can't you just batch update users ??
  5. W1zzard

    W1zzard Well-Known Member

    We use an addon that adds buttons for select all, reject all, approve all on the listing page. You'd still have to go through all pages, I usually select all, reject all and then visually scan through the list to approve any which don't look like obvious spammers (usually none)
  6. RoldanLT

    RoldanLT Well-Known Member

    This one really works:
    UPDATE xf_user
    SET user_state = 'valid'
    WHERE xf_user.user_state = 'email_confirm';
    Sage Knight likes this.
  7. Sage Knight

    Sage Knight Well-Known Member

    It's not an option, unfortunately. There is a suggestion however.

    It would be awesome if you could share it here =3

    Indeed! This is the one that worked, @Liam W's gave an error :p

    Thanks a lot Roldan. This just saved me hours of manual work.
  8. W1zzard

    W1zzard Well-Known Member

Share This Page