Purging users "awaiting email confirmation"

[Hardcore]

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.

 

[Mouth]

The add-on XenUtiles can do this for you automatically

 

[Hardcore]

The add-on XenUtiles can do this for you automatically

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

 

[Mouth]

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

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