Author |
Topic |
X002548
Not Just a Number
15586 Posts |
Posted - 2005-05-04 : 14:49:28
|
Anyone know how to delete a bunch of spam from the blogs at once?Brett8-) |
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-05-04 : 15:19:16
|
I don't know, but I delete them as soon as I get an e-mail that it was posted. For a while, I was having to do about 10 or so per day. Now it's very few, so it's easy to keep up with it.Tara |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2005-05-04 : 15:31:26
|
I swear I got blasted with about 100 of them a few times in successive weeks, which is when I turned off my comments. And i noticed I could not turn them off globally in my preferences, I had to go to each post one by one and disable them . A bug?I have them back up for now, let's see how long this lasts ....- Jeff |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-05-04 : 15:48:21
|
I got invaded by Pokemon on my blog. I've deleted all of them manually.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2005-05-04 : 15:59:05
|
There's got to be a btter way...I'm getting hit with texas hold sites...I used to like to play nickle dime quater cards...Now that it's so popular...I can't take it....I should go back and join the Thursday night dart league...Brett8-) |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2005-05-04 : 16:21:09
|
>> I should go back and join the Thursday night dart league...Nostalgia, the dart boards have all but disappeared from the pubs here ,which is a shame 'cause I was thinking about picking up a sport again.rockmoose |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2005-05-04 : 16:37:50
|
There's always the closest bar you know....the home!Brett8-) |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2005-05-04 : 16:48:46
|
And You never get thrown out!!! rockmoose |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2005-05-04 : 16:58:25
|
quote: Originally posted by rockmoose And You never get thrown out!!! rockmoose
I thought you were married.Brett8-) |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2005-05-04 : 17:02:16
|
*LOL* ...was...And I did get thrown out...rockmoose |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2005-05-05 : 06:16:39
|
Unfortunately comment spam is quite common amongst weblog sites. The popular weblog software like movabletype has plugins written for it to help deal with the stuff. Your best bet with a custom weblog might be either a regexp based delete or comment moderation.-------Moo. :) |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2005-05-06 : 14:23:49
|
Could you elaborate just a little bit more?Brett8-) |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2005-05-09 : 04:37:09
|
quote: Originally posted by X002548 Could you elaborate just a little bit more?
I can always do that, what would you like elaborating -------Moo. :) |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2005-05-10 : 13:51:25
|
quote: Originally posted by mr_mist Your best bet with a custom weblog might be either a regexp based delete or comment moderation.-------Moo. :)
ThisBrett8-) |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2005-05-11 : 04:41:11
|
ahh ok. I'm not sure exactly what sort of setup you have for the weblogs. Generally the lines of defence would be some kind of moderation (either blanket moderation of comments or moderation based on regular expressions (eg texas holdem)), or firefighting, where you would delete stuff after the event. alternatively you can shift the burden to the user by requiring registration or human-intervention through those picture type things, but that's discouraging to the average reader. Most of the lines of defence require that your system be written to allow for them, or that you can directly access the database to run deletes (not very user friendly.) People have written some fairly good plugins for things like movabletype that practically eliminate all the hard work. mt-blacklist for example, which you should be able to find through a google search, would be a good code base to work from if you wanted to write your own filtering backend.-------Moo. :) |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2005-05-11 : 10:21:44
|
It would nice to have a blacklist...and to flood the sender when the try it.....it's becoming a daily chore...and for one lazy dba...this $ucks.....Brett8-) |
|
|
|