1. 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

Discussion in 'XenForo Suggestions' started by Brogan, Jul 27, 2013.

  1. Brogan

    Brogan XenForo Moderator Staff Member

    maszd, Sim, beanfan78 and 24 others like this.
  2. xf_phantom

    xf_phantom Well-Known Member

  3. Sage Knight

    Sage Knight Well-Known Member

    Here's me hoping this is included in 1.3 :D
  4. ehd

    ehd Active Member

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

    Moddis Active Member

  6. r1pe

    r1pe Member

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

    ehd Active Member

    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
    r1pe likes this.
  8. ekool

    ekool Member

    Bump, this should be built in...
  9. Biker

    Biker Well-Known Member

    Then you should like the first post.
  10. ekool

    ekool Member

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

    ActorMike Active Member

    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.
  12. Maxxamillion

    Maxxamillion Active Member

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

    Martok Well-Known Member

    Don't forget to like the first post. :)
  14. Thunderfall

    Thunderfall Member


    Is this feature request added?

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

    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’
  16. Amaury

    Amaury Well-Known Member

  17. Alfa1

    Alfa1 Well-Known Member

    Please add this.
    beanfan78 likes this.
  18. Sim

    Sim Well-Known Member

    Was looking for this functionality today!
  19. NixFifty

    NixFifty Well-Known Member

    Alfa1 likes this.
  20. Alfa1

    Alfa1 Well-Known Member

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

Share This Page