How to remove unconfirmed users after x days ?

Question

I need a plugin or some part of script how to make automatic remove of unconfirmed users after 3 days. Can someone tell me how can i insert something like this ? There must be some command for this. Because i delete over 30 spammers evry day ! They register without confirm the email adresses. So i need a plugin or some code to insert. Please help !

Answer 1

Check out the plugin newest users page, it gives you a list where you can see all users (confirmed or not confirmed): https://github.com/echteinfachtv/q2a-newest-users-page

$emailConfirmed = ( QA_USER_FLAGS_EMAIL_CONFIRMED && $userrow['flags'] ) ? "x" : qa_lang_html('qa_new_users_lang/user_email_notconfirmed');

You might want to edit the plugin to clear these unconfirmed ones. Should be one mysql command ~ delete from _ where `flags` = QA_USER_FLAGS_EMAIL_CONFIRMED and created < now() - interval 3 day. This is no correct syntax, just how it can be done...