Additional option to set user state of batch selected users

ehd

Active member
#7
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
 
#15
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