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-25-11, 01:20 AM   #106
Paco
Captain
 
Join Date: May 2005
Location: Kassel, Germany
Posts: 542
Downloads: 345
Uploads: 0
Default

Little SPAM-ships ahead, Hr. Kaleun:

v*a**a for the crew -> "Auf Gefechtsstationen"
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
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.

Last edited by Paco; 05-25-11 at 01:37 AM.
Paco is offline   Reply With Quote
Old 05-25-11, 01:38 AM   #107
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 Raptor1 View Post
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
__________________
SUBSIM - 26 Years on the Web
Onkel Neal is offline   Reply With Quote
Old 05-25-11, 01:56 AM   #108
deceptiboat
A-ganger
 
Join Date: Dec 2010
Posts: 79
Downloads: 104
Uploads: 0
Default

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

alferd44
http://www.subsim.com/radioroom/member.php?u=279116
__________________
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-25-11, 02:12 AM   #109
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

Ok, this worked:

Code:
SELECT `user_id` , `user_name` , `home_page` 
FROM `user` 
WHERE `home_page` LIKE '%http%'
AND `joinupdate` >1275354061
AND `posts` =0
__________________
SUBSIM - 26 Years on the Web

Last edited by Onkel Neal; 05-25-11 at 02:26 AM.
Onkel Neal is offline   Reply With Quote
Old 05-25-11, 03:13 AM   #110
Paco
Captain
 
Join Date: May 2005
Location: Kassel, Germany
Posts: 542
Downloads: 345
Uploads: 0
Default

Quote:
Originally Posted by Neal Stevens View Post
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.
Paco is offline   Reply With Quote
Old 05-25-11, 05:52 AM   #111
Paco
Captain
 
Join Date: May 2005
Location: Kassel, Germany
Posts: 542
Downloads: 345
Uploads: 0
Default

Spammers ahead:

Kaleuns need romantic beach vacations?
peden623
http://www.subsim.com/radioroom/member.php?u=274340

Powertools for your Crew:ped
http://www.subsim.com/radioroom/member.php?u=219975
Oh, this entry is from 2005, great

too much money: finding discount property in New Zealand.
pdiscount01
http://www.subsim.com/radioroom/member.php?u=267157

oh no, I wont get my exgirlfriend back. My wife could become nervous ;-)
pcutright1931
http://www.subsim.com/radioroom/member.php?u=274635

climb the kilimanjaro?
pdeakin1939
http://www.subsim.com/radioroom/member.php?u=274653

and once more: furnitures ...
paxthien2010
http://www.subsim.com/radioroom/member.php?u=274195

furnitures
PauWi23
http://www.subsim.com/radioroom/member.php?u=276730

books, cameras:
pepene96
http://www.subsim.com/radioroom/member.php?u=278506

websitecreator:
pekeng023
http://www.subsim.com/radioroom/member.php?u=276159

Datingservice for the lonesome kaleun:
Peggygayle
http://www.subsim.com/radioroom/member.php?u=269379

different stuff:
peghydra1962
http://www.subsim.com/radioroom/member.php?u=275879

furnitures
PeJa23
http://www.subsim.com/radioroom/member.php?u=276630

aehm, furnitures ....
peter11pan
http://www.subsim.com/radioroom/member.php?u=276160

nice, furnitures again
peter12gelespi
http://www.subsim.com/radioroom/member.php?u=276058

recruiting .... no thanks.
Pertolamis
http://www.subsim.com/radioroom/member.php?u=277947

furnitures again
PetBean7
http://www.subsim.com/radioroom/member.php?u=275342

tooth problems?
perjacks1920
http://www.subsim.com/radioroom/member.php?u=274432

Last edited by Paco; 05-25-11 at 08:01 AM.
Paco is offline   Reply With Quote
Old 05-25-11, 06:16 AM   #112
Kaleun Cook
Chief
 
Join Date: Apr 2007
Location: ger
Posts: 313
Downloads: 25
Uploads: 0
Default

Quicker Kaleuns, quicker! 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?
Kaleun Cook is offline   Reply With Quote
Old 05-25-11, 06:27 AM   #113
danasan
Elite Spam Hunter
 
Join Date: Dec 2009
Location: Flensburg / Germany
Posts: 1,141
Downloads: 39
Uploads: 0
Default

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

Last edited by danasan; 05-25-11 at 06:39 AM.
danasan is offline   Reply With Quote
Old 05-25-11, 06:42 AM   #114
Paco
Captain
 
Join Date: May 2005
Location: Kassel, Germany
Posts: 542
Downloads: 345
Uploads: 0
Default

Quote:
Originally Posted by danasan View Post
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
Paco is offline   Reply With Quote
Old 05-25-11, 06:43 AM   #115
Penguin
Ocean Warrior
 
Penguin's Avatar
 
Join Date: Mar 2010
Location: Rheinische Republik
Posts: 3,322
Downloads: 92
Uploads: 0


Default

found one!

elwodtark42 another SEO professional, lol :
http://www.subsim.com/radioroom/member.php?u=275587

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

this guy has spam in the visitor message:
http://www.subsim.com/radioroom/member.php?u=275580

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

March 8th,2011, spammer's day:
http://www.subsim.com/radioroom/member.php?u=275546
http://www.subsim.com/radioroom/member.php?u=275545
http://www.subsim.com/radioroom/member.php?u=275544
http://www.subsim.com/radioroom/member.php?u=275543
http://www.subsim.com/radioroom/member.php?u=275542
http://www.subsim.com/radioroom/member.php?u=275541
http://www.subsim.com/radioroom/member.php?u=275540
http://www.subsim.com/radioroom/member.php?u=275539
http://www.subsim.com/radioroom/member.php?u=275538
http://www.subsim.com/radioroom/member.php?u=275537
http://www.subsim.com/radioroom/member.php?u=275536
http://www.subsim.com/radioroom/member.php?u=275535
http://www.subsim.com/radioroom/member.php?u=275534
http://www.subsim.com/radioroom/member.php?u=275533
http://www.subsim.com/radioroom/member.php?u=275532
http://www.subsim.com/radioroom/member.php?u=275531
http://www.subsim.com/radioroom/member.php?u=275530
http://www.subsim.com/radioroom/member.php?u=275529
http://www.subsim.com/radioroom/member.php?u=275528
surprise: one legit user in 27
http://www.subsim.com/radioroom/member.php?u=275526
http://www.subsim.com/radioroom/member.php?u=275525
http://www.subsim.com/radioroom/member.php?u=275524
http://www.subsim.com/radioroom/member.php?u=275523
http://www.subsim.com/radioroom/member.php?u=275522
http://www.subsim.com/radioroom/member.php?u=275518
http://www.subsim.com/radioroom/member.php?u=275517
http://www.subsim.com/radioroom/member.php?u=275514

favourite subsim game: Hearts Of Iron 3 , but spam sig:
http://www.subsim.com/radioroom/member.php?u=275509

http://www.subsim.com/radioroom/member.php?u=275508
http://www.subsim.com/radioroom/member.php?u=275505
http://www.subsim.com/radioroom/member.php?u=275501
http://www.subsim.com/radioroom/member.php?u=254409
http://www.subsim.com/radioroom/member.php?u=254401

visitor message spam again:
http://www.subsim.com/radioroom/member.php?u=254382



damn, found one from feb 2010, but danasan beat me - congrats!
edit: wow, 2005, good find, Paco! The quest for the oldest one goes on!

Last edited by Penguin; 05-25-11 at 06:45 AM. Reason: new oldest date
Penguin is offline   Reply With Quote
Old 05-25-11, 06:48 AM   #116
danasan
Elite Spam Hunter
 
Join Date: Dec 2009
Location: Flensburg / Germany
Posts: 1,141
Downloads: 39
Uploads: 0
Default

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

Last edited by danasan; 05-25-11 at 10:14 AM.
danasan is offline   Reply With Quote
Old 05-25-11, 07:07 AM   #117
deceptiboat
A-ganger
 
Join Date: Dec 2010
Posts: 79
Downloads: 104
Uploads: 0
Default

Quote:
Originally Posted by Paco View Post
sorry danasan:

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

Power Tools, for Power-Users
2005?!?!?! that's very old, what a great find
__________________
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-25-11, 08:55 AM   #118
Raptor1
Navy Seal
 
Join Date: Jul 2007
Location: Stavka
Posts: 8,211
Downloads: 13
Uploads: 0
Default

Right, then. Moving on to...

http://www.subsim.com/radioroom/member.php?u=276618
http://www.subsim.com/radioroom/member.php?u=276619
http://www.subsim.com/radioroom/member.php?u=276621
http://www.subsim.com/radioroom/member.php?u=276625
http://www.subsim.com/radioroom/member.php?u=276626
http://www.subsim.com/radioroom/member.php?u=276628
http://www.subsim.com/radioroom/member.php?u=276629
http://www.subsim.com/radioroom/member.php?u=276632
http://www.subsim.com/radioroom/member.php?u=276633
http://www.subsim.com/radioroom/member.php?u=276634
http://www.subsim.com/radioroom/member.php?u=276635
http://www.subsim.com/radioroom/member.php?u=276638
http://www.subsim.com/radioroom/member.php?u=276639
http://www.subsim.com/radioroom/member.php?u=276640
http://www.subsim.com/radioroom/member.php?u=276641
http://www.subsim.com/radioroom/member.php?u=276643
http://www.subsim.com/radioroom/member.php?u=276644
http://www.subsim.com/radioroom/member.php?u=276647
http://www.subsim.com/radioroom/member.php?u=276649
http://www.subsim.com/radioroom/member.php?u=276659
http://www.subsim.com/radioroom/member.php?u=276660
http://www.subsim.com/radioroom/member.php?u=276665
http://www.subsim.com/radioroom/member.php?u=276668
http://www.subsim.com/radioroom/member.php?u=276675
http://www.subsim.com/radioroom/member.php?u=276677
http://www.subsim.com/radioroom/member.php?u=276679
http://www.subsim.com/radioroom/member.php?u=276681
http://www.subsim.com/radioroom/member.php?u=276682
http://www.subsim.com/radioroom/member.php?u=276683
http://www.subsim.com/radioroom/member.php?u=276686
http://www.subsim.com/radioroom/member.php?u=276702
http://www.subsim.com/radioroom/member.php?u=276703
http://www.subsim.com/radioroom/member.php?u=276704
http://www.subsim.com/radioroom/member.php?u=276705
http://www.subsim.com/radioroom/member.php?u=276706
http://www.subsim.com/radioroom/member.php?u=276707 (One of the members who looked at his profile is...yet another spambot)
http://www.subsim.com/radioroom/member.php?u=276690
http://www.subsim.com/radioroom/member.php?u=276693
http://www.subsim.com/radioroom/member.php?u=276694
http://www.subsim.com/radioroom/member.php?u=276697
http://www.subsim.com/radioroom/member.php?u=276698
http://www.subsim.com/radioroom/member.php?u=276700
http://www.subsim.com/radioroom/member.php?u=276710
http://www.subsim.com/radioroom/member.php?u=276711 (Strange)
http://www.subsim.com/radioroom/member.php?u=276713
http://www.subsim.com/radioroom/member.php?u=276718
http://www.subsim.com/radioroom/member.php?u=276719
http://www.subsim.com/radioroom/member.php?u=276722
http://www.subsim.com/radioroom/member.php?u=276724
http://www.subsim.com/radioroom/member.php?u=276725
http://www.subsim.com/radioroom/member.php?u=276728
http://www.subsim.com/radioroom/member.php?u=276734
http://www.subsim.com/radioroom/member.php?u=276735
http://www.subsim.com/radioroom/member.php?u=276736
http://www.subsim.com/radioroom/member.php?u=276737
http://www.subsim.com/radioroom/member.php?u=276742
http://www.subsim.com/radioroom/member.php?u=276746
http://www.subsim.com/radioroom/member.php?u=276750
http://www.subsim.com/radioroom/member.php?u=276766
http://www.subsim.com/radioroom/member.php?u=276769
http://www.subsim.com/radioroom/member.php?u=276770 (furnitu102? Very subtle...)
http://www.subsim.com/radioroom/member.php?u=276771
http://www.subsim.com/radioroom/member.php?u=276754
http://www.subsim.com/radioroom/member.php?u=276756
http://www.subsim.com/radioroom/member.php?u=276773
http://www.subsim.com/radioroom/member.php?u=276774
http://www.subsim.com/radioroom/member.php?u=276778
http://www.subsim.com/radioroom/member.php?u=276779
http://www.subsim.com/radioroom/member.php?u=276780
http://www.subsim.com/radioroom/member.php?u=276785
http://www.subsim.com/radioroom/member.php?u=276787
http://www.subsim.com/radioroom/member.php?u=276788
__________________
Current Eastern Front status: Probable Victory
Raptor1 is offline   Reply With Quote
Old 05-25-11, 09:55 AM   #119
danasan
Elite Spam Hunter
 
Join Date: Dec 2009
Location: Flensburg / Germany
Posts: 1,141
Downloads: 39
Uploads: 0
Default

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

Last edited by danasan; 05-25-11 at 11:17 AM.
danasan is offline   Reply With Quote
Old 05-25-11, 12:12 PM   #120
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

Up to post 47

Chad 29
Torplexed 30
Raptor1 39
deceptiboat 1
__________________
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 03:42 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.