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

Purging users "awaiting email confirmation"

Discussion in 'XenForo Questions and Support' started by Hardcore, Dec 27, 2012.

  1. Hardcore

    Hardcore Active Member

    Greetings -

    We have well-over 10,000 accounts with a user state of "awaiting email confirmation." I'd like to create a custom script that will remove these accounts on a regular basis. Which tables would I need to include to ensure they're completely removed?

    So far I've identified:
    • xf_user
    • xf_user_authenticate
    • xf_user_group_relation
    • xf_user_option
    • xf_user_privacy
    • xf_user_profile
    Accurate? Are there any others?

    Thanks in advance.
  2. Mouth

    Mouth Well-Known Member

    The add-on XenUtiles can do this for you automatically
  3. Hardcore

    Hardcore Active Member

    I'd prefer to create my own script for this specific task.
  4. Mouth

    Mouth Well-Known Member

    You can still make use of the add-on by downloading it and seeing the SQL that it uses.

Share This Page