|
|
SUBSIM: The Web's #1 resource for all submarine & naval simulations since 1997
|
SUBSIM: The Web's #1 resource for all submarine & naval simulations since 1997 |
05-28-11, 07:04 AM
|
#151 |
|
Elite Spam Hunter
Join Date: Dec 2009
Location: Flensburg / Germany
Posts: 1,141
Downloads: 39
Uploads: 0
|
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
__________________
 "I invite you to go inside this submergible hole in the water where you can nicely hide from destroyers." 
|
|
|
|
05-28-11, 10:01 AM
|
#152 |
|
A-ganger
 Join Date: Dec 2010
Posts: 79
Downloads: 113
Uploads: 0
|
http://www.subsim.com/radioroom/member.php?u=279062
http://www.subsim.com/radioroom/member.php?u=279026 http://www.subsim.com/radioroom/member.php?u=279018 http://www.subsim.com/radioroom/member.php?u=279017 http://www.subsim.com/radioroom/member.php?u=279096 http://www.subsim.com/radioroom/member.php?u=279386 http://www.subsim.com/radioroom/member.php?u=279382
__________________
My completed X360 game: Battstat:Pac & Mdwy, TF:ROTF&Wr Fr Cybrtrn, AC I&II&Brotherhood, Tom Clancy's HAWX 1&2, Ace Cmbt 6, Mass Effect I&II, MotoGp 09/10&10/11, The Saboteur, Fallout 3&NewVegas, Halo 3&Reach, AVP, Far Cry 2, Lost Plnt 2, BF:BC 2, COD:MW 2&Blck Ops, SplntrCll:Cnvctn, Mafia II, MOH, Vanquish, Nrt:Ult.Ninj Strm 2, StrWrs:TFU II, Drgn Age II, Homfrnt, F1 2010, Crysis 2,And Many More |
|
|
|
|
05-28-11, 02:16 PM
|
#154 |
|
Elite Spam Hunter
Join Date: Dec 2009
Location: Flensburg / Germany
Posts: 1,141
Downloads: 39
Uploads: 0
|
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
__________________
"I invite you to go inside this submergible hole in the water where you can nicely hide from destroyers."
|
|
|
|
|
05-28-11, 09:47 PM
|
#155 | |
|
Born to Run Silent
Join Date: Jan 1997
Location: Cougar Trap, Texas
Posts: 21,363
Downloads: 541
Uploads: 224
|
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.  Next, I'll backup the database and start spinning up the nukes.
__________________
SUBSIM - 26 Years on the Web |
|
|
|
|
|
05-28-11, 11:45 PM
|
#156 | |
|
Born to Run Silent
Join Date: Jan 1997
Location: Cougar Trap, Texas
Posts: 21,363
Downloads: 541
Uploads: 224
|
Quote:
 Ok, the top Spam Killer is danasan with 254  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. 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.  Neal SUBSIM
__________________
SUBSIM - 26 Years on the Web Last edited by Onkel Neal; 05-29-11 at 09:43 AM. Reason: fixed typo |
|
|
|
|
|
05-29-11, 01:03 AM
|
#157 |
|
Born to Run Silent
Join Date: Jan 1997
Location: Cougar Trap, Texas
Posts: 21,363
Downloads: 541
Uploads: 224
|
Don't watch this video if you have shaky nerves or a weak heart: this is what we're up against!
SPAMBOT in action .
__________________
SUBSIM - 26 Years on the Web |
|
|
|
|
05-29-11, 06:00 AM
|
#158 |
|
Elite Spam Hunter
Join Date: Dec 2009
Location: Flensburg / Germany
Posts: 1,141
Downloads: 39
Uploads: 0
|
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 ?
__________________
"I invite you to go inside this submergible hole in the water where you can nicely hide from destroyers."
|
|
|
|
|
05-29-11, 09:06 AM
|
#159 |
|
A-ganger
Join Date: Jan 2009
Location: You know, I have no idea where I am...
Posts: 73
Downloads: 13
Uploads: 0
|
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. Last edited by danny60; 05-29-11 at 09:28 AM. |
|
|
|
|
05-29-11, 09:43 AM
|
#160 |
|
Born to Run Silent
Join Date: Jan 1997
Location: Cougar Trap, Texas
Posts: 21,363
Downloads: 541
Uploads: 224
|
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
__________________
SUBSIM - 26 Years on the Web |
|
|
|
|
06-03-11, 06:50 PM
|
#161 |
|
Born to Run Silent
Join Date: Jan 1997
Location: Cougar Trap, Texas
Posts: 21,363
Downloads: 541
Uploads: 224
|
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    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. 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 *I had to use some all caps somewhere....
__________________
SUBSIM - 26 Years on the Web Last edited by Onkel Neal; 06-16-11 at 06:17 PM. |
|
|
|
|
06-03-11, 06:54 PM
|
#162 |
|
Seasoned Skipper
 Join Date: Jan 2011
Location: Groningen, The Netherlands
Posts: 709
Downloads: 101
Uploads: 6
|
Great work. So you kinda came up with a Spam Hunt Interferance Tool?
__________________
My sh3 skins : http://www.gamefront.com/files/user/Bakkels Or go to the sh3 downloads section > skins |
|
|
|
|
06-03-11, 07:41 PM
|
#163 |
|
Chief of the Boat
 Join Date: Feb 2006
Location: 250 metres below the surface
Posts: 185,080
Downloads: 63
Uploads: 13
|
Nice one Neal
__________________
Wise men speak because they have something to say; Fools because they have to say something.
Oh my God, not again!!  GWX3.0 Download Page - Donation/instant access to GWX (Help SubSim) |
|
|
|
|
06-04-11, 04:31 AM
|
#164 |
|
Elite Spam Hunter
Join Date: Dec 2009
Location: Flensburg / Germany
Posts: 1,141
Downloads: 39
Uploads: 0
|
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
__________________
"I invite you to go inside this submergible hole in the water where you can nicely hide from destroyers."
|
|
|
|
|
06-04-11, 10:35 AM
|
#165 |
|
Born to Run Silent
Join Date: Jan 1997
Location: Cougar Trap, Texas
Posts: 21,363
Downloads: 541
Uploads: 224
|
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
 I have to be careful not to delete any legit members in my sorting.
__________________
SUBSIM - 26 Years on the Web |
|
|
|
 |
| Tags |
| spam; spamholes; spambots |
|
|
Linear Mode
