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

  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:

    Code:
    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

    Hi,

    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

    No.
     

Share This Page