Support Forum
Support Forum
Offline
I'm getting a lot of spam registrations on my Wordpress blog and have been removing them as they come in (captcha plugins not working, but that's another story for elsewhere). My Simple-Press forum is located in a subfolder.
To delete these spam registrations, I go into the site's mysql database via phpMyAdmin and delete them from the wp_users table.
My question is that, while these spammers' names disappear from my main Wordpress site's members list, I can still see them appearing on my forum pages, at the bottom where the Newest Members are listed. When I click on their names, the pop-up profile shows them as "guest" which indicates that the user has been removed.
I would like to know how do I remove these names in this Newest Members listing altogether?
I thought that removing their registrations from the wp_users table would remove all traces of these spammers, but I have also found them in two other tables, one of them I believe is a Simple Press forum table - wp_signups and wp_sfmembers.
Even when I remove the records in these two other tables, I am still unable to get rid of their names in the Newest Members listing.
Can anyone help with a solution to this issue?
Offline
There is a lot of code that both WP and SP executes when a user is deleted.
By removing user entries directly in the database then none of that code is being run which is going to leave many traces of a users existence hanging around. the sfmember record is just one instance. There will also be many rows in the usermeta table and traces in other locations.
WP gives you the tools to delete a user through the UI. So - in fact - does SP. I would urge you to use these tools instead.
 |
YELLOW
SWORDFISH
|
Offline
That makes sense, although, with a lot of spam registrations, its tedious to delete each account one-by-one.
Offline
Why not use the SP Spam Registration plugin which will enable you to periodically clear them out safely.
|
YELLOW
SWORDFISH
|
Offline
I have a number of members who registered some time ago but never posted. I know they are not spammers.
I'm referring to the more recent registrations with names that are obviously spammers.
Will the plugin remove ALL who have never posted, including the non-spammers, or will it allow me to set a cut-off date or other option to selectively delete members?
Offline
you can specify the cut off date - the number of days to go back...
also, you will get a list of the potential names to be deleted... you can deslect any that you want to keep and they wont be deleted...
Visit Cruise Talk Central and Mr Papa's World
All RSS1 Guest(s)