Removing unconfirmed users (3 posts)

  1. Gal Baras
    Posted 5 years 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
    Posted 5 years 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. Gal Baras
    Posted 5 years 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.

About this Topic