Spammer and the site database

Latest news from this site.

Moderators: Pete, Mods

User avatar
Pete
Site Admin
Posts: 887
Joined: Sun Dec 07, 2003 9:10 pm
Location: Candor, NY
Contact:

Spammer and the site database

Post by Pete »

Some asshole spammer posted about twenty topics for online casinos and texas hold'em poker this morning. He posted them through the "Submit QB News" link, so they would appear not only on the front page of my site but also on this forum by the user QB News.

Unfortunately, by flooding my news script with so many spam posts at once it corrupted the database that has all the information for just about all the dynamic areas of this site. I had to restore to my latest backup, from April 6th.

SO: If you have submitted anything since April 6th, it has been lost. Feel free to resubmit it. Sorry for the inconvenience.

It's lucky that I had that recent of a backup, or we could be in for some real trouble. I'm going to have to rethink how I handle the news submission on this site. I'm definitely not going to keep it "open to everyone" and "anonymous". I think I'll just make it so I have to approve stories before they're posted, much to my chagrin.

I fork hate spammers.
MystikShadows
Veteran
Posts: 703
Joined: Sun Nov 14, 2004 7:36 am
Contact:

Post by MystikShadows »

I hear ya there Pete. God damn spammers need to spam else where....even well itnentioned website like yours get it bad....all this because these ignorant morons think they'll be making money out of it. (probably been said they'd get some cash by spamming or something and they don't know any bettah....


On the other hand, because the presence is there and definitaly felt, there's no choice....but most of probably understand what this is all about....:-).
When God created light, so too was born, the first Shadow!

MystikShadows

Need hosting? http://www.jc-hosting.net

Interested in Text & ASCII development? Look no further!
http://www.ascii-world.com
User avatar
Levi
Veteran
Posts: 79
Joined: Tue Jul 27, 2004 11:44 pm
Location: Alone and forgotten
Contact:

Post by Levi »

Wow, first that horrible mess with the front page of the forums, now this.

If they're stupid enough it might be the same person or people. I'll never understand the mentality of such fools. Oh well. Later.
Later days,
Matthew

May those who love us love us
And those who don't
May the good Lord turn their hearts
And if he doesn't
May he turn their ankles
So we'll know them by their limping
-Irish prayer
User avatar
Mitth'raw'nuruodo
Veteran
Posts: 839
Joined: Sat Jan 22, 2005 11:04 am
Location: Eastern Coast of US
Contact:

Post by Mitth'raw'nuruodo »

Ya, spammers....no respect for QBers.... :lol:

Well, that good you had a back up from april 6th.... :wink:
"But...It was so beutifully done"
Rattrapmax6
Veteran
Posts: 1055
Joined: Sun Jan 02, 2005 2:11 pm
Location: At my computer
Contact:

Post by Rattrapmax6 »

That sucks,...

Why not make a automated buffer,.. Like either, only members can submit news,. who have to be approved.. then you don't have to filter every thing... :wink:
-Kevin (aka:Rattra)
(x.t.r.GRAPHICS)
User avatar
Pete
Site Admin
Posts: 887
Joined: Sun Dec 07, 2003 9:10 pm
Location: Candor, NY
Contact:

Post by Pete »

I could do that for QB News... but what about all the other categories? Files... Projects... FAQ Entries... QB Humor... "QB Philosophy"... all of them can be spammed.

I set them all up to allow for unregistered users to post. When you require registration on this type of site, nobody ever bother to submit anything. I hope it doesn't have to come to that.
Z!re
Veteran
Posts: 887
Joined: Wed Aug 04, 2004 11:15 am

Post by Z!re »

Make it so guests can only post once every 30th second or so.

Wont get rid of the bots, but will make it harder to spam out topics...


If you feel like messing with PHP you could track posting activity, so when someone spams out many posts fast, you make it so they cant post anymore..
I have left this dump.
User avatar
Pete
Site Admin
Posts: 887
Joined: Sun Dec 07, 2003 9:10 pm
Location: Candor, NY
Contact:

Post by Pete »

Spammed again... this is getting ridiculous. I've banned the spammer's IP address...but that probably won't change much.

As far as I can tell, this wasn't done by a bot, but by hand.
User avatar
Mitth'raw'nuruodo
Veteran
Posts: 839
Joined: Sat Jan 22, 2005 11:04 am
Location: Eastern Coast of US
Contact:

Post by Mitth'raw'nuruodo »

*Raises eyebrow* Somebody hate you Pete?

You have any enemies online?
"But...It was so beutifully done"
User avatar
{Nathan}
Veteran
Posts: 1169
Joined: Thu Aug 19, 2004 6:08 pm
Location: The wetlands of central Ohio, USA
Contact:

Post by {Nathan} »

Just approve certaian people that have proved themselves loyal to the qmunity to submit... that way crapholes cant!
Image
User avatar
Mitth'raw'nuruodo
Veteran
Posts: 839
Joined: Sat Jan 22, 2005 11:04 am
Location: Eastern Coast of US
Contact:

Post by Mitth'raw'nuruodo »

No, cause then no one new couldn't start submitting stuff, and would discourage newcomers. All you can do Pete is just backup often and ban IPs.

Also I liked Z!re's suggestion. :wink:
"But...It was so beutifully done"
User avatar
ShadowWolf
Veteran
Posts: 56
Joined: Thu Mar 04, 2004 1:32 pm
Contact:

Post by ShadowWolf »

a better although more dificult solution would be run all the posts though some kind of spam finger printing algo i.e. look for some key phrase's and words then asign wight values to them once the total weight value excides the trigger point the post is then simple gets trashed.

the hard part is preventing the filter from not throwing out good posts.
User avatar
QT-Pi
Coder
Posts: 15
Joined: Sun Apr 10, 2005 4:36 pm
Location: We are from Venus!

Post by QT-Pi »

Possible solution: Make it where only registered people can post on the forum, this could exempt spam, on the other hand, new comers would have to register before posting. Allow any surfer to read posts, but reg. to actually post. This might not be what you want, but could take care of your spam problem or pin point spammer(s). If a user "MUST" reg. to post on the forum, then so be it.
Life is Sweet!
~QT-Pi~
_____________________________________
"Its never too late to be what you might have been"
_____________________________________
We are the Negative to your Positive, the Positive to your Negative....Always
anarky
Coder
Posts: 37
Joined: Mon Apr 18, 2005 11:57 am
Location: Australia
Contact:

Post by anarky »

I agree with having to register, but it is a put-off to those visitors who simply want to tell the site about something. A lot of spam stuff actually comes from bots, this I know from Yahoo! chat rooms and the like. A way around this is including a failsafe anti-bot feature when posting, such as a server generated image with a random set of letters and numbers. All posters will have to type this in EXACTLY as is. This way, visitors may need not register to post something. When it comes to your site overall, I'd personally have a "user must register" policy. But, it's your choice.

That's my 2 cents. Perhaps this should be elaborated with a bit more research and placed in an article for the mag? /egotrip

No, two articles a month is enough for now. BTW Pete, my interview with Jorden Chamid is complete. I'll send that off to you soon after I have proof-read it etc.

>anarky
User avatar
Mitth'raw'nuruodo
Veteran
Posts: 839
Joined: Sat Jan 22, 2005 11:04 am
Location: Eastern Coast of US
Contact:

Post by Mitth'raw'nuruodo »

arky, don't you understand? Pete said it was a human spammer. A Pic like that wont discourage a human spammer
"But...It was so beutifully done"
User avatar
mundofr
Coder
Posts: 34
Joined: Sat Apr 16, 2005 9:11 pm
Location: IN, USA
Contact:

Post by mundofr »

yeah Pete u should put like a lock for Anonymous users, so they can just post like 2 posts per day ukno, so everyone could post a new but not spam :D, and also u can let the experts to post every 30 seconds or somethin like that..
lol as some1 said.. "my two cents"
:wink:
<b><i> "Rock is the first thing in life, after rock comes the comp...." Rock on Big M</i></b>
<img src="http://www.freewebs.com/mundofr/bigm2.bmp">
anarky
Coder
Posts: 37
Joined: Mon Apr 18, 2005 11:57 am
Location: Australia
Contact:

Post by anarky »

Am I not allowed to be tired? Even I need sleep. I'm only human. :p
User avatar
Mitth'raw'nuruodo
Veteran
Posts: 839
Joined: Sat Jan 22, 2005 11:04 am
Location: Eastern Coast of US
Contact:

Post by Mitth'raw'nuruodo »

lol anarky.
I don't think her highnesses do though. QT-Pi seems to be either skizto or a queen learder of a hive. I son't think that 'they' need sleep.

Hey, mundofr! Yep keep those two-cents comming, I like that idea too.

Pete: you should do what anarky said though, in case if you do get bots. If you start getting human spammers, then just start banning IPs. :wink:
"But...It was so beutifully done"
Rattrapmax6
Veteran
Posts: 1055
Joined: Sun Jan 02, 2005 2:11 pm
Location: At my computer
Contact:

Post by Rattrapmax6 »

QT-Pi wrote:Possible solution: Make it where only registered people can post on the forum, this could exempt spam, on the other hand, new comers would have to register before posting. Allow any surfer to read posts, but reg. to actually post. This might not be what you want, but could take care of your spam problem or pin point spammer(s). If a user "MUST" reg. to post on the forum, then so be it.
Eh, we are on the main site: http://www.petesqbsite.com.

There is a news poster there, then that also activates the "QBNews" bot and it sends it here to.... Registering only to the forum wouldn't block it,. the QBNews bot is registered.. :lol: :wink:
-Kevin (aka:Rattra)
(x.t.r.GRAPHICS)
User avatar
Mitth'raw'nuruodo
Veteran
Posts: 839
Joined: Sat Jan 22, 2005 11:04 am
Location: Eastern Coast of US
Contact:

Post by Mitth'raw'nuruodo »

A thought...ban any posts with a texas holdem poker
"But...It was so beutifully done"
Post Reply