Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
plugins-topic
Spam Registrations: delete from SP or database?
Avatar
MartiL
Member
Free Members
sp_UserOfflineSmall Offline
Mar 23, 2012 - 6:53 am

Hi guys,

Quick question: I'd like to use the Spam Registrations plugin, but would like to know if it removes the users from SP only or will it delete their WP account?

I would like to clean out all the lurkers, but I don't want their WordPress account removed as we use the account for more then just the forum.

Thanks!

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Mar 23, 2012 - 7:51 am

Complete and total removal I am afraid.

But - it is a VERY simple code change if you wanted to change it for your own purposes.

In the file /admin/sp-spam-reg-admin-list-save.php there are 4 sql DELETE statements. All you would need to do is remove or comment out the top two (users and usermeta tables).

andy-signature.png
YELLOW
SWORDFISH
Avatar
MartiL
Member
Free Members
sp_UserOfflineSmall Offline
Mar 23, 2012 - 8:15 am

That's *very* easy indeed, thx!

When accounts are removed that way -only from SP but not the WP database-, are those users then 'blocked' from the forum or can they simply logon again? (Because then, I just realised, it would be kind of useless ;)).

If so, is it possible to edit the code so spammers/lurkers are moved to certain usergroup?

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Mar 23, 2012 - 8:30 am

they can log in (because that is a WordPress function) but they belong to no SP User Groups so will be treated as a Guest and subject to whatever permissions you have assigned to Guest status.

They will also appear in the Manage User Groups admin panel as users with no memberships.

andy-signature.png
YELLOW
SWORDFISH
Avatar
MartiL
Member
Free Members
sp_UserOfflineSmall Offline
Mar 23, 2012 - 8:42 am

Ah, that's perfect! 🙂

Thanks (again!), I'm off to install and edit the plugin and start cleaning house laugh

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Mar 23, 2012 - 8:58 am

Good luck! Always recommend making a quick backup of the DB first of course!

andy-signature.png
YELLOW
SWORDFISH
Avatar
MartiL
Member
Free Members
sp_UserOfflineSmall Offline
Mar 23, 2012 - 9:16 am

Erhm, yes, I've learned the backup-lesson ... 😉

Sorry to keep you at your computer (the sun is finally shining!) but I just ran the plugin, wanting to remove all members who have been lurking for (at least) 60 days. I noticed the plugin selects all lurkers/spammers though, not just the 60+ day members.

Am I not getting the purpose of that setting or what could cause this?

60-days.pngImage Enlarger

captain-rob-1.pngImage Enlarger

There's more than just that one guy, I just noticed him because I remember him registering for the site.

(and yes, the User-ID was a tip-off as well laugh)

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Mar 23, 2012 - 9:24 am

Oh dear - do we have a bug? Let mew go and look at the code.

andy-signature.png
YELLOW
SWORDFISH
Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Mar 23, 2012 - 9:35 am

Does that image show some sort of membership plugin registration? If so can you check for 'Captain Rob' in the WordPress users to see of he was registered prior to that on the site? Or is that not a possibility?

andy-signature.png
YELLOW
SWORDFISH
Avatar
MartiL
Member
Free Members
sp_UserOfflineSmall Offline
Mar 23, 2012 - 9:43 am

Yes, I use s2Member, but there were no registrations on this site before s2 was installed. The image you see is the regular WP user search, not s2's - even if you access the users through the s2 menu you're redirected to WP itself.

Edit: just in case it's relevant: this user has a free membership, so nothing much happening with s2 member since there's no payment processing or anything else going on.

I've had a look around; the plugin has selected all 0-post users, regardless of their registration date. Same thing when I use another offset.

I'm not knowledgeable enough to make sure it doesn't have anything to do with s2, but since all data is stored in wp_users I don't think it should be a problem?

Forum Timezone: Europe/Stockholm
Most Users Ever Online: 1170
Currently Online:
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Mr Papa: 19448
Ike: 2086
Brandon: 864
kvr28: 804
jim: 650
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 619
Members: 17362
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10127
Posts: 79625