Is there a way to automatically delete users who have not confirmed their email even after a month?

Question

Spam is increasing on my site and then is no way to stop it at the moment. But till we find a way can we have a method to delete the useless user account by deleting those accounts which have not confirmed their email even after a month from registration.
I know that this method will only work for those sites which have enabled necessary email confirmation option for users. But this can actually help admins a lot.

Comments

I thought this is already part of the script, like if a user does not verify their email after certain days (maybe 30 days)script deletes that account....

Am I wrong????

Answer 1

Just to clarify. This feature has not been implemented (yet?). Features that get fired by a time event, such as this one, or getting a daily email with the summary of the day's questions or receiving a reminder that your password is about to expire, etc rely on a piece of software that is called CRON (in the Linux world).

This tool, is an application that fires programs, scripts, whatever, at specified intervals. In order for a program to fired by Cron you need to configure it in such a way that Cron knows where the program is. If you are using a hosting service it is them the ones that can (sometimes for a fee) provide a user interface for you to configure it.

Then, the program itself, must be developed in such a way that allows Cron to fire it, taking the necessary security measures.

So it is clear that not many users would know how to setup this feature even if it existed. Not to mention that it will depend on Cron access and, as far as I know, no current feature depends on anything in Q2A.

I don't really know if this will be implemented (and heavily documented) in the future but I'm pretty sure it will not be present in 1.7.

Comments

Yeah this kind of thing is not in q2a and as you say CRON won't be a good idea... but at least there can be a way to list out all the not cofirmed members for more then a month and a bulk delete option which can be manually done. This would reduce the pain to some extent.

---

Right, a manual clean up would be more appropriate, based on how things are done in Q2A... maybe in a similar way as a db cleanup option

---

For this also, bulk user deletion and user database filteration based on non confirmed users would be needed... And this is not present in q2a till now.

---

This "bulk user deletion and user database filteration based on non confirmed users would be needed" is so needed

---

I think bulk delete option with checkboxes good idea...
Also having a system triggered unconfirmed account deletion is good idea too...

Like famous boards IPB, Vbulletin are giving option to admin to set a date to delete an account if they do not confirm their email. It is a system triggered process...

---

@trushonlytrush are you talking about http://www.invisionpower.com?
SO how was it when you compared it with this q2a?

---

Dude, we are not comparing scripts, just an example of deleting unverrified USER feature... Get it????

Answer 2

Here, I am going to share a best way to solve this problem using database.

Click here to watch this video to remove or delete spam users from q2a.

Comments

I can not found 'user prefix ' in database of  q2a 1.8.3 version. So please solve this...

---

In this video it will delete all users, not those who have not confirmed their email.