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

XF 1.3 Mass Changing User State

Discussion in 'XenForo Questions and Support' started by JayX, Apr 4, 2014.

  1. JayX

    JayX Active Member

    I currently have a large amount of users with the user state 'Awaiting confirmation'. I want to update all of these to 'Valid' now that my forum no longer uses the email confirmation system.

    Is there a way to do this, as I couldn't see an option on the Batch Update Users page.

  2. Brogan

    Brogan XenForo Moderator Staff Member

    The Batch Update Users function doesn't allow for changing the state.
    You could do it with a query, if you're familiar with using phpMyAdmin.
  3. JayX

    JayX Active Member

    Thanks for the quick response. Unfortunately I'm not familiar with phpMyAdmin. If anyone here would be willing to help creating a query for this, I'd be very grateful.
  4. Brogan

    Brogan XenForo Moderator Staff Member

    UPDATE xf_user SET user_state = 'valid' WHERE user_state = 'email_confirm'
    RoyalRumble, ehd and JayX like this.

Share This Page