$result = mysql_query("SELECT `termid` FROM connected_texts");
while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
$orig_term_tax_id = $row['termid'];
$result2 = mysql_query("SELECT * FROM term_relationships WHERE `term_taxonomy_id` = '$orig_term_tax_id'");
while ($row2 = mysql_fetch_array($result2, MYSQL_BOTH)) {
$objectid_textid = $row2[0];
if (!$bookpart) {
$result3= mysql_query("SELECT `bookpart` FROM `texts` WHERE `textid`='$objectid_textid'");
while ($row3 = mysql_fetch_array($result3, MYSQL_BOTH)) {
$bookpart = $row3['bookpart'];
if ($bookpart == '1') {
$bookno = $objectid_textid;
$result4= mysql_query("UPDATE connected_texts SET `textid` = '$bookno' WHERE `termid` = '$orig_term_tax_id'");
}
}
}
$result3= mysql_query("SELECT `bookpart` FROM `texts` WHERE `textid`='$objectid_textid'");
while ($row3 = mysql_fetch_array($result3, MYSQL_BOTH)) {
$result4= mysql_query("UPDATE texts SET `book` = '$bookno' WHERE `textid` = '$objectid_textid'");
}
}
$bookpart = '';
}
It's amazing what your brain can do when it's not got two tons of unhappy perched on top.
while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
$orig_term_tax_id = $row['termid'];
$result2 = mysql_query("SELECT * FROM term_relationships WHERE `term_taxonomy_id` = '$orig_term_tax_id'");
while ($row2 = mysql_fetch_array($result2, MYSQL_BOTH)) {
$objectid_textid = $row2[0];
if (!$bookpart) {
$result3= mysql_query("SELECT `bookpart` FROM `texts` WHERE `textid`='$objectid_textid'");
while ($row3 = mysql_fetch_array($result3, MYSQL_BOTH)) {
$bookpart = $row3['bookpart'];
if ($bookpart == '1') {
$bookno = $objectid_textid;
$result4= mysql_query("UPDATE connected_texts SET `textid` = '$bookno' WHERE `termid` = '$orig_term_tax_id'");
}
}
}
$result3= mysql_query("SELECT `bookpart` FROM `texts` WHERE `textid`='$objectid_textid'");
while ($row3 = mysql_fetch_array($result3, MYSQL_BOTH)) {
$result4= mysql_query("UPDATE texts SET `book` = '$bookno' WHERE `textid` = '$objectid_textid'");
}
}
$bookpart = '';
}
It's amazing what your brain can do when it's not got two tons of unhappy perched on top.
A completely tongue-in-cheek (or shark-tooth-in-kneecap, as case may be) representation of the past twenty-four hours' realization that coming out from under the bed was A BAD IDEA. (You know I love you guys... right? You do know that, right? Right?)
A visual representation of my brain right now:

( It starts with a story. IT ALWAYS STARTS WITH A STORY. )
That is my brain, on fandom.
in case it's not obvious, this post is a JOKE, and mostly on me: because somefandoms days you're the shark, and some fandoms days you're the chum.
A visual representation of my brain right now:

( It starts with a story. IT ALWAYS STARTS WITH A STORY. )
That is my brain, on fandom.
in case it's not obvious, this post is a JOKE, and mostly on me: because some
aaaaaand... delayed author reaction!
7 Apr 2010 12:27 amI probably shouldn't find this so amusing, but I do. Okay, I take that back. I have every right to find this amusing.
On September 29TH, 2007 -- did you miss that? we're talking almost three years ago -- I posted a novel critique: for those times when wiki just ain't enough. It's linked over on the sidebar (on my DW layout) because it remains a fond favorite for no reason other than how the story is an absolute wealth of amusement on all the ways exoticization -- of another culture and of the inscrutable homosexual -- can lead you wrong, though when writing the review I was too busy being amused in general to bother with the fancy words for the philosophical side of things.
( Tonight, I got this anonymous reply. )
Being an author -- in terms of one's interaction with the public -- is a lot like being a cat, I've figured out. When you forget yourself for a moment (or for an entire book) and do the equivalent of raising your leg to lick your own ass and then promptly fall off the sofa, you do not pop up with fur flying to hiss at the humans laughing at you. No, a public-skilled author is like a cat, barely a ruffle and at most an attitude of, I meant to do that. Perhaps a bit of self-grooming just to look like the cat, err, author is simply Too Busy to deign to react to the silly humans' reactions, and then a calm and self-possessed stroll from the room, tail in air. No words are needed for the cat to make it clear that We Will Never Discuss This Again.
The authors I respect as professionals, that's pretty much how they react to negative reviews, at least publicly: they don't give those reviews the time of day, because doing so is only guaranteed to make the humans laugh even harder.
Let this be a lesson to you, kids. Don't go replying to negative reviews -- and if you do, keep in mind that taking three years to get around to (a) discovering the review and (b) getting all self-righteous is only going to lead to (c) a bunch of folks rediscovering the fun all over again. Which, I would hope, is not the author's intended outcome.
[I especially like the part about "try and write a mystery novel"... because I have, and I find it a lot easier if you write it without excessive references to wispy hair. What kind of hair, you ask? Why, just read the review to find out!]
ETA: and another response, in comments, scroll down to enjoy. *rolls eyes*
ETA 2: please remember to sign your comment if you're replying anon... well, unless it's really obvious who you are. And I mean really obvious.
On September 29TH, 2007 -- did you miss that? we're talking almost three years ago -- I posted a novel critique: for those times when wiki just ain't enough. It's linked over on the sidebar (on my DW layout) because it remains a fond favorite for no reason other than how the story is an absolute wealth of amusement on all the ways exoticization -- of another culture and of the inscrutable homosexual -- can lead you wrong, though when writing the review I was too busy being amused in general to bother with the fancy words for the philosophical side of things.
( Tonight, I got this anonymous reply. )
Being an author -- in terms of one's interaction with the public -- is a lot like being a cat, I've figured out. When you forget yourself for a moment (or for an entire book) and do the equivalent of raising your leg to lick your own ass and then promptly fall off the sofa, you do not pop up with fur flying to hiss at the humans laughing at you. No, a public-skilled author is like a cat, barely a ruffle and at most an attitude of, I meant to do that. Perhaps a bit of self-grooming just to look like the cat, err, author is simply Too Busy to deign to react to the silly humans' reactions, and then a calm and self-possessed stroll from the room, tail in air. No words are needed for the cat to make it clear that We Will Never Discuss This Again.
The authors I respect as professionals, that's pretty much how they react to negative reviews, at least publicly: they don't give those reviews the time of day, because doing so is only guaranteed to make the humans laugh even harder.
Let this be a lesson to you, kids. Don't go replying to negative reviews -- and if you do, keep in mind that taking three years to get around to (a) discovering the review and (b) getting all self-righteous is only going to lead to (c) a bunch of folks rediscovering the fun all over again. Which, I would hope, is not the author's intended outcome.
[I especially like the part about "try and write a mystery novel"... because I have, and I find it a lot easier if you write it without excessive references to wispy hair. What kind of hair, you ask? Why, just read the review to find out!]
ETA: and another response, in comments, scroll down to enjoy. *rolls eyes*
ETA 2: please remember to sign your comment if you're replying anon... well, unless it's really obvious who you are. And I mean really obvious.
I really should not have to tell you what reference this screen is making. Okay, if you know Kuroshitsuji then I shouldn't have to tell you.

This one should be a bit more obvious.

( Alright, people, let's fire this baby up and get the show on the road. )
Yes, it is a crazy series.

This one should be a bit more obvious.

( Alright, people, let's fire this baby up and get the show on the road. )
Yes, it is a crazy series.
blaming okaasan for this one
12 Mar 2010 08:20 pm...and her observation that "yet another one of the downfalls of so many electronic distractions for my kids is that they've never heard most of these [family] stories."
Which reminded me of the drawback of being able to ask about family stories is that this translates for kids to "asking about all history" thanks to "history" being a pretty vague concept up to a certain age -- consisting entirely of "stuff that happened before I was born."
Thus is the logic for when my sister had a 2nd grade report due on the Revolutionary War. So she asked our mom over dinner what the Revolutionary War was like. Mom kinda blinks and admits that she wasn't even alive for World War II (she's a true baby boomer, born a year after the war ended). My sister was rather crushed, especially when our folks explained that the Revolutionary War was a long time before World War Two.
Then Mom gets the bright idea (for reasons I totally get now) to call her mother, explaining that although Mom doesn't know, Mom's certain Gramma will. (Remarkably, she kept a straight face while assuring us of this.) She puts my sister on the extension, and after the obligatory greetings, my sister explains she has to do a report and she has some questions. Gramma, gracious as always, is more than willing to help with any school project.
So my sister trots out the question: "Gramma, what was the Revolutionary War like?"
My grandmother doesn't even miss a beat. "Oh, goodness," she tells my sister, "I only go as far back as the Civil War. For anything about the Revolutionary War, we'll have to ask your grandfather."
Which reminded me of the drawback of being able to ask about family stories is that this translates for kids to "asking about all history" thanks to "history" being a pretty vague concept up to a certain age -- consisting entirely of "stuff that happened before I was born."
Thus is the logic for when my sister had a 2nd grade report due on the Revolutionary War. So she asked our mom over dinner what the Revolutionary War was like. Mom kinda blinks and admits that she wasn't even alive for World War II (she's a true baby boomer, born a year after the war ended). My sister was rather crushed, especially when our folks explained that the Revolutionary War was a long time before World War Two.
Then Mom gets the bright idea (for reasons I totally get now) to call her mother, explaining that although Mom doesn't know, Mom's certain Gramma will. (Remarkably, she kept a straight face while assuring us of this.) She puts my sister on the extension, and after the obligatory greetings, my sister explains she has to do a report and she has some questions. Gramma, gracious as always, is more than willing to help with any school project.
So my sister trots out the question: "Gramma, what was the Revolutionary War like?"
My grandmother doesn't even miss a beat. "Oh, goodness," she tells my sister, "I only go as far back as the Civil War. For anything about the Revolutionary War, we'll have to ask your grandfather."
the irritants of the day
17 Feb 2010 02:27 pmI took my 3-yr old camcorder to Fry's yesterday, in an attempt to find out a) what sim-card to use, b) whether I could record for longer with card or mini-dv, and c) what kind of security/exterior cameras they have.
Actual conversation.
Me: *holding up camcorder* I'd like to find out--
Clerk #1: We don't sell that camera.
Me: --what---wait, what?
Clerk #1: We don't sell that camera.
Me: *mildly annoyed* I would certainly hope not.
Clerk #1: *smug look goes away* Hunh?
Me: I've already purchased it once. I have no interest in a second one.
Clerk #1: *blank stare*
( Me: Now that we've gotten that out of the way, I'd like to know what kind of card it uses. )
Some days, leaving the house just isn't freaking worth it.
Actual conversation.
Me: *holding up camcorder* I'd like to find out--
Clerk #1: We don't sell that camera.
Me: --what---wait, what?
Clerk #1: We don't sell that camera.
Me: *mildly annoyed* I would certainly hope not.
Clerk #1: *smug look goes away* Hunh?
Me: I've already purchased it once. I have no interest in a second one.
Clerk #1: *blank stare*
( Me: Now that we've gotten that out of the way, I'd like to know what kind of card it uses. )
Some days, leaving the house just isn't freaking worth it.
As the Suburbs Turn
15 Jan 2010 12:51 amAlright, headcold proceeds apace, other things generally suck, I think we're getting rained out over here, but it's 1am and I'm awake and I figure might as well launch into the story, because some things simply cannot wait. So, get comfortable, pull up your popcorn and/or your socks, have a seat, this won't take too long.
Two weeks ago, I had reason (don't ask) to go knocking door-to-door among my neighbors (no, not selling anything!). We've lived here for, oh, four years now, I suppose, and I'd never really met much beyond the neighbors just on our tiny cul-de-sac. But now I was meeting people who live a block or two away, and some of them I got talking with. And we kept talking, and eventually myinformant neighbor let me in on ( the story of U-Haul Guy, Sweet Momma, and the Iranian Rug Dealer. )
Two weeks ago, I had reason (don't ask) to go knocking door-to-door among my neighbors (no, not selling anything!). We've lived here for, oh, four years now, I suppose, and I'd never really met much beyond the neighbors just on our tiny cul-de-sac. But now I was meeting people who live a block or two away, and some of them I got talking with. And we kept talking, and eventually my
Oi, now I feel like an idiot.
18 Nov 2009 10:30 amI just read a romance review (mostly b/c I was already on the site for an SFF book review and started clicking random links), and spent a good ten minutes after the review thinking I had to be missing something. A puritan, and the Witchfinders, and the book's set during the Civil War. Oh, yeah, SURE the author did his/her homework, puritans weren't anywhere around by the Civil War! Obviously someone's been sniffing the historical glue. *nods firmly*
And then I realized: the setting is the English Civil War.
Oh. Right. In which case, puritans? Yeah. There would be puritans.
*heddesk*
And then I realized: the setting is the English Civil War.
Oh. Right. In which case, puritans? Yeah. There would be puritans.
*heddesk*
tonight's special: cat soup!
12 Oct 2009 12:32 amCe n'est pas un chat.

( C'est a damn nine-pound demon in pinstripes. )
( And a few other random notes. )
Last week's humpday Sinfest would be a great deal more amusing if I'd not had to live through this weekend.

( C'est a damn nine-pound demon in pinstripes. )
( And a few other random notes. )
Last week's humpday Sinfest would be a great deal more amusing if I'd not had to live through this weekend.
how reviews sell books
11 Sep 2009 12:02 pmBecause I'm halfway tempted to track down the book based on this sentence alone:
If the bastard daughter of Red Dwarf and Hitchhiker’s Guide to the Galaxy had a lovechild with Aaron Sorkin, its slash fandom would produce something like this.
I mean, honestly, how could I resist?
ETA: whoops, sorry, didn't mean to forget the actual, y'know, BOOK info. The quote is from a review at Uniquely Pleasurable, about Sakana Sara's Cheesecake and the Art of Political Warfare. Free story posted on LJ. And gotta say, within the first four paragraphs, I'm totally down with the reviewer's observation.
If the bastard daughter of Red Dwarf and Hitchhiker’s Guide to the Galaxy had a lovechild with Aaron Sorkin, its slash fandom would produce something like this.
I mean, honestly, how could I resist?
ETA: whoops, sorry, didn't mean to forget the actual, y'know, BOOK info. The quote is from a review at Uniquely Pleasurable, about Sakana Sara's Cheesecake and the Art of Political Warfare. Free story posted on LJ. And gotta say, within the first four paragraphs, I'm totally down with the reviewer's observation.
.... and tentacles.
18 Aug 2009 09:00 pmAll thanks to this conversation, I went perusing the 'net for more on this Torchwood thing, having been completely convinced for some time (for reasons still unclear) that it was a western. Oddly, when I mentioned to CP that the show had tentacles, CP's response was, "isn't that a western?" So apparently it's a group hallucination.
( Regardless, what we have here is your basic quasi-live-blogging. Sort of. )
( Regardless, what we have here is your basic quasi-live-blogging. Sort of. )
so about those stereotypes
11 Apr 2009 03:53 amSitting at the corner, waiting to pull into traffic, watching big freaking trucks (of the sort that wish they had license plates that say "farm vehicle" but in fact have never seen a spec of dirt in their life), and I end up having to pull in behind a pokey mini-van. Gnashing my teeth, of course, at the quick glimpse of kid seat in the back, not exactly a Windstar but definitely one of those "room for everyone!" minivans that may be big on the inside but they're damn well small on style, and maybe that's why they're a favorite of suburban souls with no sense of individuality.
Or maybe not.
Because not more than half-block of driving behind this minivan, I realized just what I'd been reading on the bumpersticker right in the middle of the minivan's bumper.
I belong to the NRA, and I voted for Obama.
That sound you hear? That was the sound of my stereotypes getting kicked to the door.
Or maybe not.
Because not more than half-block of driving behind this minivan, I realized just what I'd been reading on the bumpersticker right in the middle of the minivan's bumper.
I belong to the NRA, and I voted for Obama.
That sound you hear? That was the sound of my stereotypes getting kicked to the door.
Earlier this week, I was out running a quick errand, and feeling mighty pissed-off about the current project's deadline wackiness. Fortunately I have a collection of songs on the iPod for just such pissed-off moments when driving -- several collections, in fact. One that's suitably cranky for pissed-off moods, and one that's songs I normally wouldn't listen to but can't not be in a good mood as soon as I hear them.
Most of these get the curled lip ' scorn from the Leo if I don't change the playlist when he gets in the car -- there's several from the Monkees, and a few Erasure songs, that kind of semi-inane but relatively cheerful and uncomplicated pop and dance tunes. That includes 'Game of Love', discovered after viewing a truly amazing AMV, and 'Carameldansen,' an inclusion I blame entirely on
misshallelujah, who was the source of my first introduction to this bizarre phenomenon -- a series of animated gifs of the Gundam 00 characters doing that... dance... thing.
( And it was thus that I discovered that if MissHallie ever gets her duff to the States, she should swing through this city so the two can meet. )
(This city's weird. I know that, but this level of weird is off the charts.)
Most of these get the curled lip ' scorn from the Leo if I don't change the playlist when he gets in the car -- there's several from the Monkees, and a few Erasure songs, that kind of semi-inane but relatively cheerful and uncomplicated pop and dance tunes. That includes 'Game of Love', discovered after viewing a truly amazing AMV, and 'Carameldansen,' an inclusion I blame entirely on
![[livejournal.com profile]](https://www.dreamwidth.org/img/external/lj-userinfo.gif)
( And it was thus that I discovered that if MissHallie ever gets her duff to the States, she should swing through this city so the two can meet. )
(This city's weird. I know that, but this level of weird is off the charts.)