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

XF 1.3 Confirm account or delete

Discussion in 'XenForo Questions and Support' started by polle, Jul 10, 2014.

  1. polle

    polle Active Member

    I have an old forum and I want to do some cleaning. My idea is to mail all users asking them to confirm their account or it will be deleted in 60 days.

    How can I accomplish that ?

    The idea is simple, please confirm you want to keep your account or it will be deleted. So the user has to click something or post in a specific forum or something like that.

    Anyone ?

    Thanks.
     
  2. Brogan

    Brogan XenForo Moderator Staff Member

    Set the status to awaiting email confirmation from edit.

    Any which are still that status after the expired time, delete them.
     
  3. Mike

    Mike XenForo Developer Staff Member

    Alternatively, you could just ask them to visit the forum (and be logged in). You would then use the batch user update tool to delete people who haven't visited for X period of time.
     
  4. polle

    polle Active Member

    Thanks Brogan.

    How can I set the status to awaiting email confirmation for 7000 users?
    If I change it that way, then what ?

    There is no "haven't visited for X period of time" option, so select all the years by clicking can be an option. But I want to have them make "some action" like posting in a specific node or thread.

    Is that possible ?

    Thanks.
     
  5. Mike

    Mike XenForo Developer Staff Member

    If you want them to take an action like posting in a thread, you would need custom development.
     
  6. The Forum Heroes

    The Forum Heroes Well-Known Member

    Change everyone's usergroup to "1" in the database using phpmyadmin.
     
  7. polle

    polle Active Member

    And that can be done doing ? is there a query for that ?

    Thanks.
     
  8. The Forum Heroes

    The Forum Heroes Well-Known Member

    Code:
    UPDATE `xf_user` SET `user_group_id` = '1', `secondary_group_ids` = '';
    
    
    Make sure to note your admin account user and secondary ids to edit back in afterwards.[/code]
     
  9. polle

    polle Active Member

    Thank you.

    Whats the URL needed for ?

    If I go to phpMyAdmin I can run a query there for the XF database and directly to affect the table I need, in this case "xf_user". Why does that URL pointing to your forum is needed ?
     
  10. Brogan

    Brogan XenForo Moderator Staff Member

    I would strongly advise against doing that as the permission sets won't be updated correctly.
     
    polle likes this.
  11. polle

    polle Active Member

    Thanks.

    How can I set the status to awaiting email confirmation for 7000 users?
    If I change it that way, then what ?
     
  12. The Forum Heroes

    The Forum Heroes Well-Known Member

    Appeared in my copy paste of the query.. That's why I edited it and then fixed it.
     
  13. polle

    polle Active Member

    I see now.

    I think I will pass on that option waiting to see a better one.

    Thanks.
     
  14. The Forum Heroes

    The Forum Heroes Well-Known Member

    Shouldn't it work correctly after rebuilding user cache?
     
  15. polle

    polle Active Member

    Thanks.

    How can I set the status to awaiting email confirmation for 7000 users?
    If I change it that way, then what ?
     
  16. Martok

    Martok Well-Known Member

    This add-on has the "user hasn't logged on in X days" criteria. It also has these criteria:

    • number of posts in a specific thread(s)*;
    • number of posts in a specific node(s)*;
    • number of discussions started in a specific node(s)*


    http://xenforo.com/community/resources/user-criteria-by-waindigo.813/

    You could send out an email to all users via the ACP asking them to visit the site and use one or multiple of these criteria to create a promotion where users that don't visit the site in a period of X days or post in a specific forum or thread are added to a new usergroup you create. You can then use the batch user update feature in the ACP to delete all users who are added to this group.
     

Share This Page