|
still June 2010
http://www.subsim.com/radioroom/member.php?u=265350 http://www.subsim.com/radioroom/member.php?u=265374 Neal, if I had to clean up the database, I would go for all the accounts which have: last activity = join date and total posts = 0 and downloads = 0 and uploads = 0 there should be a value for last activity/join date I would say until 2011, 1st of January, for example. Meeting all these criteria, I would not expect any activity in future time. That would make a couple of thousands... danasan |
The great Subsim turkey shoot
http://www.subsim.com/radioroom/member.php?u=279457 <- do i get the reward for the newest spammer? this guy joined on the 05-26-2011
http://www.subsim.com/radioroom/member.php?u=279382 <- second place aswell? This one joined on the 05-24-2011 http://www.subsim.com/radioroom/member.php?u=279062 http://www.subsim.com/radioroom/member.php?u=278924 <- cleverly hidden http://www.subsim.com/radioroom/member.php?u=278842 http://www.subsim.com/radioroom/member.php?u=278835 http://www.subsim.com/radioroom/member.php?u=278833 http://www.subsim.com/radioroom/member.php?u=278438 http://www.subsim.com/radioroom/member.php?u=278828 http://www.subsim.com/radioroom/member.php?u=278824 http://www.subsim.com/radioroom/member.php?u=278821 <- super mario anyone? http://www.subsim.com/radioroom/member.php?u=278807 http://www.subsim.com/radioroom/member.php?u=278789 http://www.subsim.com/radioroom/member.php?u=278604 http://www.subsim.com/radioroom/member.php?u=278533 http://www.subsim.com/radioroom/member.php?u=278562 http://www.subsim.com/radioroom/member.php?u=278586 http://www.subsim.com/radioroom/member.php?u=278799 <- obvious spambot is obvious http://www.subsim.com/radioroom/member.php?u=278800 http://www.subsim.com/radioroom/member.php?u=277641 http://www.subsim.com/radioroom/member.php?u=275498 Check visitor messages of: http://www.subsim.com/radioroom/member.php?u=278802 http://www.subsim.com/radioroom/member.php?u=278771 |
http://www.subsim.com/radioroom/member.php?u=267070
http://www.subsim.com/radioroom/member.php?u=267097 http://www.subsim.com/radioroom/member.php?u=267173 http://www.subsim.com/radioroom/member.php?u=267250 http://www.subsim.com/radioroom/member.php?u=267332 http://www.subsim.com/radioroom/member.php?u=267451 http://www.subsim.com/radioroom/member.php?u=267456 http://www.subsim.com/radioroom/member.php?u=267684 http://www.subsim.com/radioroom/member.php?u=267905 August 2010 |
Quote:
Hi danasa, check this thread http://www.subsim.com/radioroom/show...37#post1669437 Ok, contest concluded, I will tally the kills and check for duplicates. Thanks to each of you, it means a lot to have help running this forum and keeping the spam out. :salute: Next, I'll backup the database and start spinning up the nukes. |
Quote:
Ok, the top Spam Killer is danasan with 254 :rock: Oldest spam detected by Paco: Joindate 01-11-2002 Funniest spammer: danny60, chicken coops Hottest spammer: Torplexed and his babe Final standings: danasan 254 Raptor1 199 danny60 135 paco 93 ria 88 Torplexed 69 penguin 38 peabody 35 Chad 29 deceptiboat 29 aanker 14 Anthony W 13 indy 4 Golden Rivet 4 joea 1 ZeeWolf 1 flatsixes 1 Kaleun Cook 1 Thanks and thanks again. :salute:Once I nuke all the spammers with my db queries, we'll check these links and see if any survived. Danasan and danny 60, PM me where you want your goodies sent. :yeah: Neal SUBSIM |
Don't watch this video if you have shaky nerves or a weak heart: this is what we're up against!
SPAMBOT in action . |
Neal, I missed your SQL - thread, sorry for confusing...
We are seriously in need of a video of the "nukification" ! When you press the button. Neal, is it a typo, I am sure, Paco had the oldest, Danny the funniest ? |
Hmm.. i'm not sure, The spammer that PACO brought up was not really a spammer (or alteast thats the general vibe I got from what neal and raptor1's posted)
Mind you, I don't think that I trawled that far back into the depths of the user list. |
Oh, you're right, when I sorted my spreadsheet to get the order from most to fewest, I didn't include the specials. I will honor the prize to danny60, he had the funniest spammer, and one to Torplexed for the hottest spammer.
Send me some contact info for the mail. Neal |
UPDATE FROM THE FRONT:
Boys, we now have the tools now to win this war. The registration is now linked in to an NSA spam database that will block 97% of the spamho's before they can check "I agree with the terms of this foru...". I've added a new Spam WMD that will alert the moderators when a new member joins with spam in his sig or homepage, even before he has a chance to post. My server tech just upgraded my automated backups, so the entire domain and forum db are copied. I've made a second copy of the 2.3GB forum db to use as a test platform. I have just tested a magnificent 3-part MySQL script on the test db for a 2 year segment of users and it took 1364 spammers and put them in the spammer usergroup to be pruned. With our shocktroop moderators and spamkilling specialists smashing their righteous fists down on the Report Bad Posts http://www.subsim.com/radioroom/smartdark/report.gif http://www.subsim.com/radioroom/hayl...ons/report.gif http://www.subsim.com/radioroom/imag...ons/report.gif buttons AT THE FIRST SIGN OF INTRUSION,* we will nuke any spammers that make it to the shore before their boots are dry. Let it be said: no more unauthorized selling of viagra, real estate, furniture, and chicken coops, not here, not ever. :rock: I'm setting myself a calendar reminder at the end of the month to go back 30 days and follow up the SpamCheck for any spammers who wait a week to post their spam (that's very unusual), they won't have a chance. We will all think back someday, with our grandchildren at our feet, of how the pestilent spam hordes put us to the test, and we prevailed. Audeamus! Onkel Neal :salute: *I had to use some all caps somewhere.... |
Great work. So you kinda came up with a Spam Hunt Interferance Tool? :03:
|
Nice one Neal :yeah:
|
There is still work to do... with the resident evil
The first I picked without any criteria or sense... http://www.subsim.com/radioroom/member.php?u=264033 |
Thanks, dan, but stand by, I am still working through the back log, my friend. Hopefully by Monday I can report that none of the spam detected links posted in this thread will still be active :up: I have to be careful not to delete any legit members in my sorting.
|
| All times are GMT -5. The time now is 05:27 AM. |
Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright © 1995- 2024 Subsim®
"Subsim" is a registered trademark, all rights reserved.