SUBSIM Radio Room Forums - The Great SUBSIM Spam Hunt of 2011

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)

Little SPAM-ships ahead, Hr. Kaleun:

v*a**a for the crew -> "Auf Gefechtsstationen":rotfl2:
paubra7548
http://www.subsim.com/radioroom/member.php?u=275298

please sit down, new furniture for the captain:
PauBu23
http://www.subsim.com/radioroom/member.php?u=276415

need help for facebook :damn:
paul.tom86
http://www.subsim.com/radioroom/member.php?u=274071

can't describe what it is in english, but it is SPAM:
paul321
http://www.subsim.com/radioroom/member.php?u=274450

need to be reviewed, but I think it is SPAM too:
http://www.subsim.com/radioroom/member.php?u=272630

furnitures ....
paul59
http://www.subsim.com/radioroom/member.php?u=275852

No need for media copies:
paulbrown978
http://www.subsim.com/radioroom/member.php?u=262222

furnitures, tooth withening, ...
paulcoper1933
http://www.subsim.com/radioroom/member.php?u=274636

Bulletproof vests for the gunmen, Hr. Kaleun?
PaulCowburn07
http://www.subsim.com/radioroom/member.php?u=275007

Software:
pauldenn25
http://www.subsim.com/radioroom/member.php?u=267990

cigar:
paulhill146
http://www.subsim.com/radioroom/member.php?u=268259

More to come ....

Hmmm, I think a search direct to the database is much easier than searching by hand in the profiles.

A search like this is a good point to start:
select id,name from "table memberlist" where registrationdate=last_Activity and about_me like "%http%"

what do you think?

Paco.

Quote:

Originally Posted by Raptor1 (Post 1669329)

We can't afford time to dwell on the individual spambot, they must be exterminated without mercy.

Like so:

sssssssssssssssssssssssssssspapppppppppppppaaaaaaa aaaaaaaammmmmmmmmmmmmmmmmmmmmmm

Hahaha, awesome.

I am caught up to the end of page 3,

so far
Chad 29
Torplexed 26
Raptor1 39

and Raptor has the oldest spammer, Last Activity: 03-09-2010 06:04 AM

Important: If you find a spammer older than 3-9-10, be sure to mention that in your post!

Quote:

Hmmm, I think a search direct to the database is much easier than searching by hand in the profiles.

A search like this is a good point to start:
select id,name from "table memberlist" where registrationdate=last_Activity and about_me like "%http%"

what do you think?

Paco.

Great idea, I'll try that. You must have missed my other SQL question:
http://www.subsim.com/radioroom/showthread.php?p=1669029#post1669029

Thanks and thanks! I am slowly wiping them out, grinning all the while.

Neal

Ok, this worked:

Code:

SELECT `user_id` , `user_name` , `home_page` 

FROM `user` 

WHERE `home_page` LIKE '%http%'

AND `joinupdate` >1275354061

AND `posts` =0

Quote:

Originally Posted by Neal Stevens (Post 1670122)

Great idea, I'll try that. You must have missed my other SQL question:
http://www.subsim.com/radioroom/showthread.php?p=1669029#post1669029

Aehm, haven't seen it. Ok, moving there.:cool:

Quicker Kaleuns, quicker! :DL There a new ones joining already:

http://www.subsim.com/radioroom/member.php?u=279417

But I guess there's no prize for finding the latest spammer, is there? ;)

may I claim for the oldest shoot so far?

wilson Johns http://www.subsim.com/radioroom/member.php?u=253310

Join Date 01-18-2010

He is good at wealthy affiliate

Well,
danasan

Quote:

Originally Posted by danasan (Post 1670240)

may I claim for the oldest shoot so far?

wilson Johns http://www.subsim.com/radioroom/member.php?u=253310

Join Date 01-18-2010

sorry danasan:

http://www.subsim.com/radioroom/member.php?u=219975
Join date 06-21-2005

Power Tools, for Power-Users :woot:

wow Paco,

what a great find!

let's go on.

OK, these are not spammers, but I think they would not remember their nicknames today:

http://www.subsim.com/radioroom/memb...posts&page=505 completly.

there are a few on the pages 504 and 506 as well.

Edit: I think they are automatically generated spam accounts made at the same date / time... About 66 accounts. Sink them!

This guy crys for being fired:

Removeme :) http://www.subsim.com/radioroom/member.php?u=213516

join date: 05-11-2004 04:12 AM

danasan

Quote:

Originally Posted by Paco (Post 1670246)

sorry danasan:

http://www.subsim.com/radioroom/member.php?u=219975
Join date 06-21-2005

Power Tools, for Power-Users :woot:

2005?!?!?! :o that's very old, what a great find :salute:

not sure about this one... but I claim for

FADM Gonepostal

http://www.subsim.com/radioroom/member.php?u=210630

linked page is down, but "big bens navy" could be tobacco pipes... Hard to judge 9 years later

Join Date 03-27-2002

Maybe we better wait until the so- far- cleanup is done...

Up to post 47

Chad 29
Torplexed 30
Raptor1 39
deceptiboat 1