Human Ingenuity
We haven’t had any comment spam since I implemented my home-made CAPTCHA some time ago. But last night we got hit by TrackBack spam. 293 separate spam trackbacks. Sheesh. So I went in and deleted them by hand in MySQL:
mysql> delete from wp_comments where comment_content like ‘%poker%’;
Then I implemented the ‘moderate-trackbacks’ plugin from http://dev.wp-plugins.org/browser/moderate-trackbacks
If it wasn’t so annoying, it would be funny…
February 1st, 2005 at 10:21 am
you can block them in your htaccess too:
RewriteCond %{HTTP:VIA} ^.+pinappleproxy
RewriteRule .* – [L,F]
February 3rd, 2005 at 11:23 am
Interesting. I checked my logs and I don’t see the ‘pinappleproxy’ string in there. I don’t see any ‘HTTP:VIA’ entries either. And the spam trackbacks are all coming from different IP addresses. I got another 193 of them last night. Fortunately, doing a mass delete from the MySQL command line is pretty easy.