• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

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’