[RSS Feed/News] Housecleaning-Delete all users with no posts and bounced email

[XenForo]

With one click, I just wiped out 2,632 members with no posts and bounced email accounts. I cannot think of any user at all for them!

DELETE FROM myforumname.xf_user WHERE (user_state like 'email_bounce' AND message_count = '0');

Does anyone else have any other housecleaning tips?

ادامه مطلب...