Two Simple Scripts to Detect Spammers in SMF

February 14th, 2009 | by Ozgur Cem Sen |

I’ve been going through some spring cleaning in our forum today, and ended up running few SQL scripts against our SMF forum database to get a better idea of who might be spamming us.

I got some counts from those simple scripts below, and registered a lot of “Ban on IP” and “Ban on email” triggers. Perhaps, they might be useful for somebody else too.

1
2
3
SELECT `memberIP`, count(`memberIP`) AS `how_many` FROM `smf_members` WHERE `is_activated=0` GROUP BY `memberIP` ORDER BY `how_many` DESC

SELECT `memberIP`, count(`memberIP`) AS `how_many` FROM `smf_members`GROUP BY `memberIP` ORDER BY `how_many` DESC

This spamming stuff sucks big time. Every other month, I end up wasting 4-5 hours of my time trying to clean the crap of those low-lives leave behind.

Sorry, comments for this entry are closed at this time.