Why the crazy spam?
I wish my silly blog can’t be found by crazy bots that spam for the sake of Google search ranking. I haven’t used SQL for ages, but I had to rely on it to kill off over 5000 spam comments just earlier.
Deleted rows: 5494 (Query took 0.1457 sec)
SQL query: DELETE FROM `wp_comments` WHERE `comment_content` LIKE ‘%host.com%’
So, thank you, SQL! I wuv you =) A shout out to Rob who showed me SQL long ago! Anyway, I don’t really know how to stop them spam effectively — maybe I’ll do the image thing again which requires people to type out numbers before posting.. but that was really PITA.
April 9th, 2006 at 9:45 am
Dude, have you upgraded to the newest version of WP? If so, Let me know I can give you a little sumtin-sumtin to help with the spam.
April 12th, 2006 at 11:57 am
Oh no… upgrade! I’m still using 1.5.1.2 — that’s ancient history old! But, yea ~ the spam problem is really outta control. Just now, I realized I whacked quite a few legit comments too. Reminds me of the time when I worked at Publishers and I was running untested SQL queries =) hahhahahaha,… haaa..
Let’s get to upgradin then!
April 13th, 2006 at 7:00 pm
This whole SQL post reminded me of this one time when we were taking sofware engineering… I think Morph was on my tem… we had this database project… testing it out I decided to use some Bill Clinton/Monica Lewinsky reference as my user/name and password… then when we were presenting the project to the TA one of the other groups ran into a problem and had to open the database in plain text and there was my nasty password in plain view for anyone to see. I was quite glad that nobody ever found it was my fault. lol.
April 15th, 2006 at 2:13 pm
Ahh, I remember me sticking weird comments into all the programs I wrote while workign with Rob =) I’ll get bored and write comments about big events! I don’t remember seeing the nasty password though…