SUBSIM Radio Room Forums



SUBSIM: The Web's #1 resource for all submarine & naval simulations since 1997

Go Back   SUBSIM Radio Room Forums > Special Projects > Subsim Events & Activities
Forget password? Reset here

Reply
 
Thread Tools Display Modes
Old 05-28-11, 07:04 AM   #151
danasan
Elite Spam Hunter
 
Join Date: Dec 2009
Location: Flensburg / Germany
Posts: 1,141
Downloads: 39
Uploads: 0
Default

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."
danasan is offline   Reply With Quote
Old 05-28-11, 10:01 AM   #152
deceptiboat
A-ganger
 
Join Date: Dec 2010
Posts: 79
Downloads: 104
Uploads: 0
Default

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
deceptiboat is offline   Reply With Quote
Old 05-28-11, 11:37 AM   #153
danny60
A-ganger
 
Join Date: Jan 2009
Location: You know, I have no idea where I am...
Posts: 73
Downloads: 13
Uploads: 0
Default 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

Last edited by danny60; 05-28-11 at 12:08 PM. Reason: Gol' damn, theres load of'em
danny60 is offline   Reply With Quote
Old 05-28-11, 09:47 PM   #155
Onkel Neal
Born to Run Silent
 
Onkel Neal's Avatar
 
Join Date: Jan 1997
Location: Cougar Trap, Texas
Posts: 21,276
Downloads: 534
Uploads: 224


Default

Quote:
Originally Posted by danasan View Post
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

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
Onkel Neal is offline   Reply With Quote
Old 05-28-11, 11:45 PM   #156
Onkel Neal
Born to Run Silent
 
Onkel Neal's Avatar
 
Join Date: Jan 1997
Location: Cougar Trap, Texas
Posts: 21,276
Downloads: 534
Uploads: 224


Default

Quote:
Originally Posted by SS-0 Sub-Zero View Post
hey Neal, do you know Chrysanthos? He always bumping old thread and asking for help in creating a ship, but not in an appropriate place (Asking in someone else's thread). He may be active, but many of his post is complaining about many of the mod link is dead(Of course is dead, it's an old thread!). So, do you regard this as a spam, or not? If you regard this as a spam, then i'm gonna get the most active spammer award(more than 200 post, if i remembered)
Lol, no, that's not true spam. At least he's a real person.


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
Onkel Neal is offline   Reply With Quote
Old 05-29-11, 01:03 AM   #157
Onkel Neal
Born to Run Silent
 
Onkel Neal's Avatar
 
Join Date: Jan 1997
Location: Cougar Trap, Texas
Posts: 21,276
Downloads: 534
Uploads: 224


Default

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
Onkel Neal is offline   Reply With Quote
Old 05-29-11, 06:00 AM   #158
danasan
Elite Spam Hunter
 
Join Date: Dec 2009
Location: Flensburg / Germany
Posts: 1,141
Downloads: 39
Uploads: 0
Default

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."
danasan is offline   Reply With Quote
Old 05-29-11, 09:06 AM   #159
danny60
A-ganger
 
Join Date: Jan 2009
Location: You know, I have no idea where I am...
Posts: 73
Downloads: 13
Uploads: 0
Default

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.
danny60 is offline   Reply With Quote
Old 05-29-11, 09:43 AM   #160
Onkel Neal
Born to Run Silent
 
Onkel Neal's Avatar
 
Join Date: Jan 1997
Location: Cougar Trap, Texas
Posts: 21,276
Downloads: 534
Uploads: 224


Default

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
Onkel Neal is offline   Reply With Quote
Old 06-03-11, 06:50 PM   #161
Onkel Neal
Born to Run Silent
 
Onkel Neal's Avatar
 
Join Date: Jan 1997
Location: Cougar Trap, Texas
Posts: 21,276
Downloads: 534
Uploads: 224


Default

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.
Onkel Neal is offline   Reply With Quote
Old 06-03-11, 06:54 PM   #162
Bakkels
Seasoned Skipper
 
Join Date: Jan 2011
Location: Groningen, The Netherlands
Posts: 709
Downloads: 101
Uploads: 6
Default

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
Bakkels is offline   Reply With Quote
Old 06-03-11, 07:41 PM   #163
Jimbuna
Chief of the Boat
 
Jimbuna's Avatar
 
Join Date: Feb 2006
Location: 250 metres below the surface
Posts: 180,321
Downloads: 63
Uploads: 13


Default

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)
Jimbuna is offline   Reply With Quote
Old 06-04-11, 04:31 AM   #164
danasan
Elite Spam Hunter
 
Join Date: Dec 2009
Location: Flensburg / Germany
Posts: 1,141
Downloads: 39
Uploads: 0
Default

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."
danasan is offline   Reply With Quote
Old 06-04-11, 10:35 AM   #165
Onkel Neal
Born to Run Silent
 
Onkel Neal's Avatar
 
Join Date: Jan 1997
Location: Cougar Trap, Texas
Posts: 21,276
Downloads: 534
Uploads: 224


Default

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
Onkel Neal is offline   Reply With Quote
Reply

Tags
spam; spamholes; spambots

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -5. The time now is 09:11 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.