XF 1.3 Mass Changing User State

[JayX]

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.

 

[Paul B]

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]

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.

 

[Paul B]

UPDATE xf_user SET user_state = 'valid' WHERE user_state = 'email_confirm'