myforumname.xf_user WHERE (user_state like 'email_bounce' AND message_count = '0');
I didn't even know this was a feature. LOL! I've had a forum for so long that I've always had to use the other method.
www.xf2addons.com
I don't see any reason to delete a user that has posted just because they haven't posted in 365 days if they have a valid email address. We've had plenty of members since 2001 that lurk or they will sell their car and buy another one a couple years later and return.andy has an addon that automates this by cleaning users who haven't posted in 365 days. quite nice.
Delete users
Description: Delete users who never made a post after 365 days and other conditions set in the options page. (Example of Options page) Features: In addition to the conditions set in the options page, the following conditions will prevent...
yeah... don't use a mySQL command to do that? Use the built in functions of your script so that it keeps all records in sync?
From a business perspective, having members with valid email addresses has value, especially if you have paid for advertising to get them to join. For example, no large corporation like WalMart is going to delete customer accounts because they have not made a purchase in a year. It's free to have them stored in the database. The only reason I could see that anyone would remove a valid customer/member is severe OCD.
is it possible to delete banned members?
Yes, but it makes sense to keep them IMO. In many cases it can be useful to stop them rejoining. Yes they can be sock puppets of course, but many aren’t bothered to get another email address, VPN etc.
Spammers will keep registering in both cases, but only problem wanting to delete them because banned members will still receive email notifications
Why should a banned user get notifications? Something is wrong if that happens.
no idea
Maybe an addon is causing that?
It is going to be a long process to identify that, that's why I deleted banned spammers
Easy on a test installation.
