SUBSIM Radio Room Forums

SUBSIM Radio Room Forums (https://www.subsim.com/radioroom/index.php)
-   Subsim Events & Activities (https://www.subsim.com/radioroom/forumdisplay.php?f=236)
-   -   The Great SUBSIM Spam Hunt of 2011 (https://www.subsim.com/radioroom/showthread.php?t=183894)

TarJak 06-04-11 07:48 PM

Quote:

Originally Posted by Neal Stevens (Post 1676915)
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 INTRUSTION,* 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....

OOORRRAHHH!:yeah:

Gerald 06-04-11 11:25 PM

Quote:

Originally Posted by Neal Stevens (Post 1676915)
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 INTRUSTION,* 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....

Good news Neal, and a solid work from you as usual, and from the staff! :yep:

Paco 06-05-11 12:42 PM

Great work, yeah :salute:

Onkel Neal 06-06-11 11:14 AM

Almost there. I think we're at the 97% spam free threshold. I've run all my queries, to the point where I am picking off the odd spammer who is outside the normal bounds (logged in 10 days later, made 2 posts, etc.)

I should be reporting back by Weds.:salute:

danasan 06-07-11 01:28 PM

Today one of these delivery guys from UPS or DHL rang at the door and handed me a

really nice and perfectly fitting SUBSIM T - shirt

and a fridge magnet like this:

http://images6.cpcache.com/product/5...x480_Front.jpg

From the brand new collection... I have to be honest and have to admit that it really looks much cooler than on the picture. I want to recommend you guys and Frau Kaleun, of course, to get one or more of those magnets.

Thank you very much, Neal. That was much much faster here than I would have thought.

danasan

McBeck 06-08-11 01:37 PM

Quote:

Originally Posted by danasan (Post 1679396)
Today one of these delivery guys from UPS or DHL rang at the door and handed me a

really nice and perfectly fitting SUBSIM T - shirt

and a fridge magnet like this:

http://images6.cpcache.com/product/5...x480_Front.jpg

From the brand new collection... I have to be honest and have to admit that it really looks much cooler than on the picture. I want to recommend you guys and Frau Kaleun, of course, to get one or more of those magnets.

Thank you very much, Neal. That was much much faster here than I would have thought.

danasan

Congrats!

Gerald 06-08-11 01:40 PM

Congratulation, Neal's generosity is overwhelming, :DL

nimitz98 06-08-11 01:50 PM

Aww... Now there's no spam left for me to report! :D

Onkel Neal 06-08-11 04:14 PM

Actually, once I complete the last purges tomorrow night, I will start Phase II of the Spam Hunt, where you can win a prize if you find a single spammer.* :cool:




*Subject to rules TBD

Jimbuna 06-08-11 04:17 PM

Quote:

Originally Posted by Neal Stevens (Post 1680059)
Actually, once I complete the last purges tomorrow night, I will start Phase II of the Spam Hunt, where you can win a prize if you find a single spammer.* :cool:




*Subject to rules TBD

Shouldn't be too hard :O:

Onkel Neal 06-08-11 04:19 PM

Hey! Whose side are you on? :arrgh!:

Jimbuna 06-09-11 03:56 AM

Quote:

Originally Posted by Neal Stevens (Post 1680062)
Hey! Whose side are you on? :arrgh!:

Yours of course...I'm suprised you even asked :DL

Herr-Berbunch 06-09-11 05:22 AM

Quote:

Originally Posted by Neal Stevens (Post 1676915)
Let it be said: no more unauthorized selling of viagra... ...not here, not ever.

Quote:

Originally Posted by jimbuna (Post 1680060)
Shouldn't be too hard

Jim, if you want it to be hard you need the authorised stuff available from the SUBSIM store!


:yep:

Jimbuna 06-09-11 08:29 AM

Quote:

Originally Posted by Herr-Berbunch (Post 1680307)
Jim, if you want it to be hard you need the authorised stuff available from the SUBSIM store!


:yep:

Regarding the 'hard' bit....perish the thought, I'd rather start collecting diecast :DL

TarJak 06-09-11 08:39 AM

Quote:

Originally Posted by Neal Stevens (Post 1680059)
Actually, once I complete the last purges tomorrow night, I will start Phase II of the Spam Hunt, where you can win a prize if you find a single spammer.* :cool:




*Subject to rules TBD

Quote:

Originally Posted by jimbuna (Post 1680060)
Shouldn't be too hard :O:

I assume spotting Jim doesn't count?:O:


All times are GMT -5. The time now is 04:07 PM.

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.