• 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

JayX

Active member
#1
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.

Thanks.
 

Brogan

XenForo moderator
Staff member
#2
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.
 

JayX

Active member
#3
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.
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.