rlp AntiSpam Squad

December 21, 2007 - 6:23pm

Hi - Tim from Jethro here, sorry to hijack rlp for a technical thing, but I guess rlp has already started that with the previous post about this site.

First I want to thank all the rlp readers who have been commenting, and emailing Gordon with ideas. We are reviewing them all and who knows something may be just what we need! Keep them coming.

As Gordon mentioned this site is built on Drupal. Unfortunately a very old version - we hope just "young" enough that we can upgrade it. Drupal has some fantastic spam control in new versions so while we appreciate comments about fixing the spam problem, that is mostly in hand. The real issue is what to do about the existing comments.

We really don't want to just delete them all, though that is our fall back position. The rlp community obviously values the comments for the continued conversations sparked by rlp writing. There are some techie ways we can try and delete just the spam comments (involving mySQL and PHP queries) but we are not sure that we can make that work entirely successfully.

I want to throw an idea to you. It's crazy enough that rlp might have thought of it himself, though the credit falls to me.

I know there’s 3,000 odd of you readers on any given day, and there's over 1,000 of you who have created user accounts. The way I figure it is if even half of those people, say 500, could delete 100 spam comments each they would all be gone.
So here’s the plan.

If you want to help, and that’s a big if, only if you can spare maybe half an hour of your time, then create an account and add a comment here with your user name (or existing user name) offering to help.
I will give you access to delete comments, and some easy instructions. As a bonus, you will gain access to the rlp subscription area for a period as well. You will be known as the "rlp antispam squad".

If you want to go nuts, I will even ask the preacher to formally recognize the person who deletes the most spam comments.

Thanks for helping - and being part of this community. Personally, I see this like sweeping up the playground in your street after vandals have trashed it. That’s what a community does.

Peace.
Tim

Submitted by islandpastor on December 21, 2007 - 6:47pm.

Great idea. Sign me up! Kevin

Submitted by Kittycatty on December 21, 2007 - 7:14pm.

Very clever, very clever indeed. I'm in.

Submitted by zachawry on December 21, 2007 - 7:14pm.

I'm up for it: zachawry

Submitted by Tyrdium on December 21, 2007 - 7:17pm.

Spambusting *and* helping RLP? Sounds great!

Username: Tyrdium

Submitted by jeffy on December 21, 2007 - 7:19pm.

Be vewy vewy quiet we awe hunting spambits.

I'll play.

Submitted by Satchel Pooch on December 21, 2007 - 7:44pm.

Bring it on, Tim!

Submitted by Betsy on December 21, 2007 - 8:09pm.

I'm in!

username=Betsy

Submitted by Larry Vaughan on December 21, 2007 - 8:32pm.

Sir Spam-a-Lot here. My prestidigitation is at your service.

Submitted by SusanL on December 21, 2007 - 8:35pm.

Love the idea...it takes a village. Count me in!

Submitted by grizzlybear on December 21, 2007 - 8:42pm.

Sign me up! My time is at your service.
GrizzlyBear

Submitted by racerbrad on December 21, 2007 - 8:50pm.

can do!

Submitted by Episcopilot on December 21, 2007 - 8:58pm.

Sign me up...Add your light to the sum of Light...

Submitted by Jacob on December 21, 2007 - 9:17pm.

Great idea. I'm in.

Submitted by CDMoyer on December 21, 2007 - 9:18pm.

Count me in.

Submitted by direcow (not verified) on December 21, 2007 - 9:21pm.

Let me give it a shot - I cleared 60000+ spam at a shot before from my friend's blog, but I had a chance to use phpadmin, and delte spam using keywords.

Submitted by backrowbass on December 21, 2007 - 9:43pm.

Glad to help sweeping.

Let me know when it's time.

Submitted by David Goldfarb on December 21, 2007 - 9:51pm.

I had thought of this myself, but didn't know if it would be technically feasible. Since it is, sign me up!

Submitted by donandval on December 21, 2007 - 9:51pm.

Hells yeah. We in.

Submitted by Wondering Pastor on December 21, 2007 - 10:33pm.

count me in

Submitted by janetmckinney on December 21, 2007 - 11:26pm.

Clean up time all around. As we are a day ahead in Aus from you lot, I will get a head start on everyone!

Janet McKinney, Canberra Australia

Submitted by dominic (not verified) on December 21, 2007 - 11:31pm.

Tim, One of the things I once implemented when I wrote my own blog engine, was to incorporate SpamAssassin into the comment processing. Having collected a few-300 of older spams as a learning corpus, I set to work pushing all historical (and later, future) comments through SA. Once properly trained, I had a near-100% hit rate on eliminating spam. If you're interested, use your sleuthing skills to drop me an email and we can talk. :)

Submitted by parodie on December 21, 2007 - 11:37pm.

I'm happy to help!

Submitted by Mary Jo on December 21, 2007 - 11:51pm.

I would be happy to lend my services as well!

~ Mary Jo

Submitted by janelle on December 22, 2007 - 12:20am.

I'll be glad to help too (:

Submitted by LutheranHusker on December 22, 2007 - 1:25am.

Great. Now I have the Monty Python Spam sketch going through my head in its entirety. =)

I suppose you'll just have to sign me up to help rid the site of that dreaded word...though spam sausage spam spam bacon spam tomato and spam might be nice... =)

http://lutheranhusker.blogspot.com

Submitted by xyp on December 22, 2007 - 2:02am.

sign me up!

Honesty is the best policy, but insanity is a better defense.

Submitted by Sandykins on December 22, 2007 - 2:25am.

Count me in!

Submitted by Patch on December 22, 2007 - 2:28am.

Sign me up!

Submitted by ns336 on December 22, 2007 - 3:45am.

Sounds great - get me sweeping...

Submitted by casey rousseau on December 22, 2007 - 5:59am.

Divide and Conquer! I'm in.

Submitted by DE Adams (not verified) on December 22, 2007 - 7:33am.

I'd like to help with the spam purge.

Submitted by Mr. Bee on December 22, 2007 - 7:59am.

My user name is "Mr. Bee"
If you are still in need of help, do whatever it is you need to do and send me some instructions and I'm your man until my eyes fail me.

Merry Christmas to everyone...happy holidays and have a safe and happy new year also.

God Bless

Submitted by Tripp Hudgins on December 22, 2007 - 8:06am.

Yep. I'm in, too. Spam. Spam. Spam. Spam! (ala Monty Python...)

Tripp Hudgins

http://www.anglobaptist.org

Submitted by notarev on December 22, 2007 - 8:32am.

me too!!!

Submitted by brigid23 on December 22, 2007 - 9:00am.

Lemme at em :)

Submitted by OldPoet on December 22, 2007 - 9:05am.

I have my spam-gun set on vaporize. OldPoet

Submitted by Idle Pilgrim (not verified) on December 22, 2007 - 10:25am.

I'm in

Submitted by Rawja on December 22, 2007 - 10:26am.

If you still need help, count me in!

Submitted by Hook on December 22, 2007 - 11:44am.

I'm willing to work at it a while.

Peace
Hook

Submitted by gretch68 on December 22, 2007 - 1:00pm.

Tim

I'd also be glad to help. Spam sucks :)

Submitted by Val on December 22, 2007 - 3:20pm.

If you still need the help, I'm SO in. :)

Submitted by administrator on December 22, 2007 - 3:32pm.

everybody down to here has been added - thanks so much for helping - over 4000 comments removed in the last 7 hours!
Anybody is welcome so if you want to help just add your a comment using your user name in here.

Thanks
Tim

Submitted by Gail Cromack (not verified) on December 22, 2007 - 3:40pm.

count me in ( spameaters anonymous?) gailcromack@msn.com

Submitted by rlp on December 22, 2007 - 7:32pm.

Wow, 4000. Amazing. Thanks everyone!!

Submitted by ChuckeeT on December 22, 2007 - 7:42pm.

SPAM: a chopped pork shoulder and ham mixture. Mmm.

Still need help? I'm game.

ChuckeeT

Submitted by CDMoyer on December 22, 2007 - 10:45pm.

Oops, forgot to include my username, CDMoyer.

Submitted by parodie on December 23, 2007 - 10:48am.

Since deleting a comment deletes the whole thread (comment + replies) and that the replies to spam comments are always spam comments, it would be really useful to know how the comments are threaded when deleting them.
I have done a bit of hunting on the posts themselves (follow comment to post, figure out if the spam comment is part of a longer thread that can be deleted) but it seems inefficient.

Submitted by administrator on December 23, 2007 - 5:16pm.

The rlpASS have removed over 50,000 comments already.
WOW!

Submitted by MusicianofHope on December 23, 2007 - 8:18pm.

Alright, seems like there is still some work to do. I'm in.

Submitted by iandunn on December 24, 2007 - 8:36am.

That's a really good idea, count me in.

Submitted by smpuckster on December 24, 2007 - 8:50am.

Count me in if you still need help.

Steve

http://web.mac.com/smpuckster

Submitted by smpuckster on December 24, 2007 - 8:51am.

Count me in if you still need help.

Steve

http://web.mac.com/smpuckster

Submitted by brotherterry on December 24, 2007 - 9:14am.

Sign me up if you still need help!

peace,
brotherterry

Submitted by tx10s on December 24, 2007 - 9:25am.

I'll do it.

Submitted by Carl Holmes (not verified) on December 24, 2007 - 8:39pm.

Sign me up... jcubsdad.

Submitted by administrator on December 25, 2007 - 4:45am.

Thanks for offering - more hands are gratefully received.
Everybody up to here has been added.
Check the instructions out and also the comments under the instructions for what to do.
Theres also a subscribers only video from rlp for you to view too.
Merry Christmas
Tim

Submitted by grizzlybear on December 27, 2007 - 3:49am.

Lessee, I have been at this for four hours and thirty-five minutes.
I must have removed at least a couple hundred adds for viagra, cialis, acomplia, breast augmentation, sports fishing, canopy rental, navy exchange, xanax, free-ware games, and several dozen porn sites.

I know RLP needs to find a paying job, but did he have to resort to this? (KIDDING! Just KIDDING! Sad joke perhaps, but at this point I have a major headache and my eyes are crossing!)

So, how are we doing? Are we there, yet?

I am running into a pile of "anonymous user" comments that are are of the afore-mentioned persuasions, but when I click on them I get the message that the comment no longer exists. If that is the case, why are they still showing up?

GrizzlyBear

Submitted by administrator on December 27, 2007 - 10:09am.

Wow Grizzly - time for a break!
Try refreshing your cache - use CTRL F5 to refresh the page - that might fix the missing comments - maybe someone else is deleting them also.
We got to be near the end - and your efforts are very much appreciated.
Thanks so much!
The anonymous ones are the hardest, as there are a bunch of real comments entered by anonymous also. Try sorting by subject - that may help you locate valid ones to delete.

Submitted by Wading on December 28, 2007 - 12:51am.

If you still need help, sign me up. I still have two weeks of vacation left and nothing better to do.

Submitted by David Goldfarb on December 28, 2007 - 1:21am.

Things seem to be pretty well cleaned up at this point.

Submitted by administrator on December 28, 2007 - 7:19pm.

I have added you Wading
Maybe you can help with the next little project - to be advised (nothing like deleting 130,000 spam comments though!)

Submitted by jenjie on December 30, 2007 - 10:15am.

It sounds like things might be taken care of for this go around. If you do need help though, let me know.

jenjie

Submitted by administrator on December 30, 2007 - 10:52pm.

thanks jenjie
If you like you can help David clear out the moderation queue - theres a few in there - Ive given you access

Cheers
Tim

Submitted by sharonlea1 on January 2, 2008 - 10:42am.

Been out of town. Am I too late to help?

Submitted by administrator on January 10, 2008 - 1:05am.

on this one yes sharonlea1 but I have given you permissions to handle the second job
tim