The Great SUBSIM Spam Hunt of 2011

[TarJak]

Originally Posted by Neal Stevens

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 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.

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....

OOORRRAHHH!

[Gerald]

Originally Posted by Neal Stevens

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 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.

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....

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

[Paco]

Great work, yeah

[Onkel Neal]

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.

[danasan]

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:



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]

Originally Posted by danasan

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:



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]

Congratulation, Neal's generosity is overwhelming,

[nimitz98]

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

[Onkel Neal]

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.*




*Subject to rules TBD

[Jimbuna]

Originally Posted by Neal Stevens

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.*




*Subject to rules TBD

Shouldn't be too hard

[Onkel Neal]

Hey! Whose side are you on?

[Jimbuna]

Originally Posted by Neal Stevens

Hey! Whose side are you on?

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

[Herr-Berbunch]

Originally Posted by Neal Stevens

Let it be said: no more unauthorized selling of viagra... ...not here, not ever.

Originally Posted by jimbuna

Shouldn't be too hard

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

[Jimbuna]

Originally Posted by Herr-Berbunch

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

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

[TarJak]

Originally Posted by Neal Stevens

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.*




*Subject to rules TBD

Originally Posted by jimbuna

Shouldn't be too hard

I assume spotting Jim doesn't count?