lamerfreak | January 1, 2008
So, was looking for something - I now forget what, exactly - and came across this old blog. For some reason, it had been inundated by comment spam since I left it. Tens of thousands worth. I found that there were actually *no* real comments among the cruft, so I deleted all of them, and disabled comments on all posts... let's see if that keeps.
I suspect there is a way that they get posted, regardless... if so, perhaps a read-only database...
Keeping this for posterity, and to remind me, as always, how stupid I may be.
Also, bBlog is no more, and hasn't been anything for, apparently, years, so it's best I continue with the current http://blog.namor.ca
I suspect there is a way that they get posted, regardless... if so, perhaps a read-only database...
Keeping this for posterity, and to remind me, as always, how stupid I may be.
Also, bBlog is no more, and hasn't been anything for, apparently, years, so it's best I continue with the current http://blog.namor.ca
lamerfreak | July 11, 2006
I'll probably have to change this blog system. Old software without any protection means it's getting overwhelmed.
delete * from bB_comments where commenttext like "%http%";
Query OK, 55334 rows affected (38.90 sec)
Motherfuck. 55,334 comments since the last time I did this. Time for housecleaning.
Oh, and more SQL geekiness:
update bB_posts set allowcomments = "disallow" where allowcomments = "allow";
Query OK, 25 rows affected (0.01 sec)
Rows matched: 25 Changed: 25 Warnings: 0
delete * from bB_comments where commenttext like "%http%";
Query OK, 55334 rows affected (38.90 sec)
Motherfuck. 55,334 comments since the last time I did this. Time for housecleaning.
Oh, and more SQL geekiness:
update bB_posts set allowcomments = "disallow" where allowcomments = "allow";
Query OK, 25 rows affected (0.01 sec)
Rows matched: 25 Changed: 25 Warnings: 0
lamerfreak | July 11, 2006
I can't like poetry. It's self-embellishment of the dregs.
And if you can't understand that, then you now know my reason.
I made a bad (multiple) decision, and have to let everyone go. Out. Out of my life. I'm better, ensconced in nothing, without interaction forced upon me.
I hate that I can't feel that I can speak in my completely personal (everything here is mine but the code) demesnes.
So. *WHY* are you reading this? Do something useful instead.
And if you can't understand that, then you now know my reason.
I made a bad (multiple) decision, and have to let everyone go. Out. Out of my life. I'm better, ensconced in nothing, without interaction forced upon me.
I hate that I can't feel that I can speak in my completely personal (everything here is mine but the code) demesnes.
So. *WHY* are you reading this? Do something useful instead.
lamerfreak | June 12, 2006
So, I may go insane. It's a delicious trip!
Y'see, it's starting to become... obvious? Perhaps. This is secondary information - that my mother is descending into further compulsions.
I'd call it something like OCD. There's a term for the specific symptom, though usually you'd just call it 'hoarding'.
See, I was over to see my brother about hooking up my stereo. While there, my mother wasn't around, so... I took my new digital camera (woo! nudity on the way!) and went through a bit of the place.
And made a gallery and put it online. Of course. I *am* still a geek, aren't I?
http://home.namor.ca/
Now, realize - some of this is supposed to have a genetic component. I've always been aware that I am prone to suffering from similar issues, but guarded against it most vigorously on my own. Does it get worse with age? Will I develop similar symptoms?
At least it's not pets.
Y'see, it's starting to become... obvious? Perhaps. This is secondary information - that my mother is descending into further compulsions.
I'd call it something like OCD. There's a term for the specific symptom, though usually you'd just call it 'hoarding'.
See, I was over to see my brother about hooking up my stereo. While there, my mother wasn't around, so... I took my new digital camera (woo! nudity on the way!) and went through a bit of the place.
And made a gallery and put it online. Of course. I *am* still a geek, aren't I?
http://home.namor.ca/
Now, realize - some of this is supposed to have a genetic component. I've always been aware that I am prone to suffering from similar issues, but guarded against it most vigorously on my own. Does it get worse with age? Will I develop similar symptoms?
At least it's not pets.
lamerfreak | June 12, 2006
So. I go to check out my blog and post something somewhat topical... (well, it's all topical, in my perfect estimation... snork).
And find that the latest post has 10 comments. What? And pending moderation?
And so begins the search that turns up thousands of comment spams. Eventually I found that, bblog (the software here) must be doing it *really* stupidly, because it took a couple of minutes to delete every batch of 50. I had to grab the password and go in, delete all comments that had a link in them (%href%) so... if this meant yours disappeared, sorry.
I should see if I can set the default to only allow comments for a short period, too... hm.
Damned spammers.
If I were more determined, I'd have grabbed all of the IPs and fed them into a blacklist file as well. But meh.
And find that the latest post has 10 comments. What? And pending moderation?
And so begins the search that turns up thousands of comment spams. Eventually I found that, bblog (the software here) must be doing it *really* stupidly, because it took a couple of minutes to delete every batch of 50. I had to grab the password and go in, delete all comments that had a link in them (%href%) so... if this meant yours disappeared, sorry.
I should see if I can set the default to only allow comments for a short period, too... hm.
Damned spammers.
If I were more determined, I'd have grabbed all of the IPs and fed them into a blacklist file as well. But meh.
lamerfreak | May 2, 2006
I have been completely emasculated, and compensating for it is doing (similarly) nothing.
Paid off one loan.
Started reading confessions.
Installed RT-IR. That was a mess and SSL still isn't working properly here...
Maybe a drinking problem would help. (is it a problem if you seek out the disease?)
Paid off one loan.
Started reading confessions.
Installed RT-IR. That was a mess and SSL still isn't working properly here...
Maybe a drinking problem would help. (is it a problem if you seek out the disease?)
lamerfreak | April 19, 2006
I am getting addicted to LiveJournal pictures.
http://ga2so.com/lj2.php
Everyone will leave, now.
(there is no point to this space ) <-orthatone.
http://ga2so.com/lj2.php
Everyone will leave, now.
(there is no point to this space ) <-orthatone.
lamerfreak | April 16, 2006
I may be the only person in this house who isn't afraid of moths.
lamerfreak | April 10, 2006
So, I'm cruising back home, taking an alternate way. I get to McPhillips. See a Young's market or... something, coming up, turn in and let's see what's up.
First off, I have never seen so much seafood in a can. How many squids can you fit in a tin, and WHY? For god's sake, who BUYS these?
Interesting ice creams. There's a general chatter in languages I can't understand, and the announcements disturbing the music are reiterated in three. Strangely, 'sale' seems to sound the same in every of them.
Ah, the music... yes, then 'Build me Up, Buttercup' came on, and... everyone sang. If it was just under their breath, or tapping their feet, but... middle-aged woman digging through the freezer section, didn't look like she was paying attention, but between tossing aside platters of full fish, she'd mutter in time to the music, ".... buttahcup..."
*surreal*
First off, I have never seen so much seafood in a can. How many squids can you fit in a tin, and WHY? For god's sake, who BUYS these?
Interesting ice creams. There's a general chatter in languages I can't understand, and the announcements disturbing the music are reiterated in three. Strangely, 'sale' seems to sound the same in every of them.
Ah, the music... yes, then 'Build me Up, Buttercup' came on, and... everyone sang. If it was just under their breath, or tapping their feet, but... middle-aged woman digging through the freezer section, didn't look like she was paying attention, but between tossing aside platters of full fish, she'd mutter in time to the music, ".... buttahcup..."
*surreal*
lamerfreak | March 28, 2006
Prince Grr-Miaow.
Upset over his food supplies, water running low, took solace in the boot supply until his trust lieutenant did refresh the victuals.
Back to napping. This 1 hour awake thing is really tiring.
Upset over his food supplies, water running low, took solace in the boot supply until his trust lieutenant did refresh the victuals.
Back to napping. This 1 hour awake thing is really tiring.