WordPress.org

1. galbaras
   Member
   Posted 1 year ago #

   I have lots of users and I suspect many of them are inactive spammers that will never confirm their registrations, leaving me with a database full of garbage.

   I was looking for a plugin that cleans up unconfirmed (not inactive) users, but haven't found one, so I thought of writing a query that deletes from wp_users where user_activation_key is NULL and the date is up to 30 days ago.

   Would that do the right thing?

2. Ashfame
   Member
   Posted 1 year ago #

   I have a plan for dealing with such things, and I might do a plugin for it this weekend. I will post an update here.

3. galbaras
   Member
   Posted 1 year ago #

   If combine it with a good plugin for removing inactive users, that might make it a complete single offer. Either way, will my query do the trick? This way, I can get going manually for a bit.

Topic Closed

This topic has been closed to new replies.