2,435 comments deleted - at least

[Tdarcos]

This is the uncensored version of the posting http://www.paul-robinson.us/index.php/2 ... d-at-least on my blog at paul-robinson.us

I talk in the sidebar of my blog about why I don't allow comments any more after I decided to lock down my blog after the 300th piece of spam. I was wrong. I thought I'd gotten rid of it all but I hadn't. The admin system there kept showing me old draft comments - ones not yet approved for publication - from 2008, approximately when I locked the place down. It kept showing them, and showing them, and all you could do was delete them one at a time, and the system required me to confirm each item I wanted to delete, whereupon yet another new piece of crap replaced the one I had just removed. It was like busting open pest insect hives in a badly infested building or something, the more insects you found, the more you kept finding.

So I had a better idea. I used PHPMyAdmin - a high-powered database management tool - to go through the comments. And what I saw over and over were draft, unapproved comments for things I wouldn't approve on my blog. Adult dating ("meet someone new and fuck them tonight!"), hardcore sex sites ("meet someone new and fuck them in the ass tonight!"), porn sites ("watch people fuck and suck each other or get fucked and sucked in every possible position and opening with things you wouldn't believe!"), drugs ("get the drugs you need to be able to fuck all night, dozens of times!"), all the stuff no legitimate business could actually afford to <i>pay</i> to advertise because there's no percentage in it, if the true cost of running a business were included they'd be out of business.

I once figured if I could catch a bunch of spammers and make them come up with $1 for each item I've had to delete, remove or expunge, I could probably make a pretty good living. If spammers had to pay the true cost of what they send out - the way people who use the Post Office do - spam would die, and <i>fast</i>.

I suspect the stuff they're spamming probably isn't even <i>good</i> porn, or they wouldn't have to spamvertise. Larry Flynt - the sick fuck who runs <i>Hustler Magazine</i> - correctly poked fun at the ridiculous Wall Street Bailouts by publicly announcing how the porn industry was hurting too, it employs a lot of people and contributes to the economy, it deserves a
bailout too!

Correctly working businesses don't need bailouts, as has been pointed out, the porn industry does do quite well selling its wares.

So I used PHPMyAdmin to do a cursory look over, 300 at a time, and was able to delete that many all at once. Then after a few of these, I got more confident and did about 1000 at a time, twice.

So, with the ones I deleted manually and the ones I bulk-deleted I dropped at least 2,500, probably more than 3,000 bogus comments.

I have exactly what I think is about right. 4 comments - the only ones marked as published - that had any validity out of perhaps 5,000 or more pieces of shit that were posted there over the years.

[Ice Cream Jonsey]

Yeah, but what if you need some dick pills at some point, so you can come in somebody's eye? You didn't send all that shit to /dev/null, didja CptTdarcos?

[Tdarcos]

Yeah, but what if you need some dick pills at some point, so you can come in somebody's eye? You didn't send all that shit to /dev/null, didja CptTdarcos?

Yes I did discard all of it, it was garbage. For your information I don't do facials, and I already have some ED pills. I asked my doctor for some samples of Viagra; I still have them if I ever need them. (I have diabetes and can't really get an erection.)

[Flack]

What blog software are you running?

I run Akismet and lr2Spam on my Wordpress blog and, between they two, they have completely eliminated my spam problem. At one point I was getting 5-10 spam comments a day. Now I get 1 a week, and it goes right to the spam folder.

The only problem with the plugin is that I have one or two users that it always seems to categorize as spam and I'm not sure why. I had to manually add those guys to the filter's white list and now they're good.

Both of those plugins are free, btw.

[Tdarcos]

What blog software are you running?

I run B2Evolution, I got it before I ever heard of Wordpress. It does what I need to do, which is, to give me a place to post my rantings and thoughts, sort of like a journal but basically open to the public, I probably have a loyal following of about 5-10 readers, and maybe 100 casual visitors a year. Probably similar to this place, only from the system displays it's probably 10x as popular as mine.

[Flack]

I'm not familiar with the workings of B2E, but if you don't have a lot of people who comment you can always just limit comments to registered folks.