Implemented Additional option to set user state of batch selected users

This suggestion has been implemented. Votes are no longer accepted.
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
 
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.
 
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 Bottom