Implemented Additional option to set user state of batch selected users

[Paul B]

As per this post, an additional option to set the user state of batch selected users would be useful: http://xenforo.com/community/threads/batch-management-of-users-waiting-approval.55773/#post-594260

 

[xf_phantom]

I agree. This task was also the reason, why i requested http://xenforo.com/community/threads/deferred-user-thread-class.55458/

 

[Sage Knight]

Here's me hoping this is included in 1.3

 

[ehd]

Would be *very* useful. Is there any mod that does this?

 

[Moddis]

I agree. If you are able to Batch Search for all users in a specific User State or a Banned State, it would only make sense that you are able to Batch Update those states for the users you Batch Searched for.

BTW, in a way here is a related idea: http://xenforo.com/community/threads/add-user-to-user-group-rather-then-manually-approve.68463/

 

[r1pe]

Any news on this one yet, such a feature would be good to have.

 

[ehd]

I am using this:

UPDATE xf_user SET user_state = 'moderated' WHERE user_state = 'email_confirm' AND user_id > 50000

Modified from Brogan's post

 

[ekool]

Bump, this should be built in...

 

[Biker]

Bump, this should be built in...

Then you should like the first post.

 

[ekool]

I can't believe this has not been added in yet.

 

[ActorMike]

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.

 

[Maxxamillion]

YES YES this is a must why is it not already a part of the software

 

[Martok]

YES YES this is a must why is it not already a part of the software

Don't forget to like the first post.

 

[Thunderfall]

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]

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’

 

[Amaury]

Is this feature request added?

No.

 

[Alpha1]

Please add this.

 

[Sim]

Was looking for this functionality today!

 

[Naz]

I quickly hacked together an add-on to make this possible: https://github.com/NixFifty/XenForo-StateUpdate

XF doesn't make it easy to extend the batch update tools so it's a bit hacky but it does the job.

 

[Alpha1]

Putting the words 'hacky' and 'batch update' in the same sentence makes me nervous.