Additional option to set user state of batch selected users

ehd

Active member
I am using this:

Code:
UPDATE xf_user SET user_state = 'moderated' WHERE user_state = 'email_confirm' AND user_id > 50000
Modified from Brogan's post
 

ActorMike

Active member
I can't believe this has not been added in yet.
Agreed, very unfortunate. Ultimately it's their decision whether they want to keep their customers happy. For a large board this could really be an issue, we have 39 they need updated ourselves.
 

Thunderfall

Member
Hi,

Is this feature request added?

I still don't see an option to batch update user state to Valid from Awaiting email confirmation.
 

Thunderfall

Member
I updated manually for now. SQLs used:

SELECT *, FROM_UNIXTIME(register_date) FROM `xf_user` WHERE `user_group_id` = 2 and `user_state` = 'email_confirm' and FROM_UNIXTIME(register_date) > '2016-10-01 00:00:01’

update `xf_user` set `user_state` = 'valid' WHERE `user_group_id` = 2 and `user_state` = 'email_confirm' and FROM_UNIXTIME(register_date) > '2016-10-01 00:00:01’
 
Top