So yesterday had me doing the housework to tidy up and clean before Dave and Alex came over for a late lunch (of nomm pasta bake). Much beer and wine was drunk over the course of the afternoon. Then the original plan was for them to go home and put The Mighty Angus to bed, but someone had the idea for us to go over and play Singstar :) Where of course we drank quite a lot more wine. And sang lots. And I got beaten! :) These guys are pretty good :) Wasn't a hugely late night, but the effects of ten hours of drinking kinda made itself known heh.
Today played some wii for a bit, then went over to Scott and Kerry's, then did our grocery shopping. And watched quite a lot of tv.
And so now the weekend's over :(
Was really not feeling like going out tonight. Had a crap late afternoon at work (upstream servers again, not even my crap downstream ones) and it was rainy and miserable.
But we forced ourselves to go out, and had a lovely curried chicken of Nanette's and had some beer and did lots of Singstar.
Was a fun evening :)
(did you know how freaking hard "The Circle of Life" is to do on Singstar???)
It's Thursday and I've had nothing interesting to say in two days.
So go read someone else's blog and their reaction to Vegemite... maybe I should send her some Tim Tams..? :)
Just a couple of cool things I've not marked read yet in my feed reader cause I thought they were cool...
Last night I made six-cheese pizzas. There's colby, tasty, parmesan, mozarella, feta and some mystery softish cheese leftover from work on Friday. They were epic nom.
(I put olives and capers on Stu's, I just had the cheese :) )
Tonight we finally remembered to go look for the International Space Station. We managed to see it very briefly as a tiny little moving dot, before it went behind a cloud and then presumably a tree (as we didn't see it again).
Oh and there was the whole thing about me breaking things in a big way today, which was really not what I needed at the moment. *sigh*
Had a nice quiet house day today. Late this arvo we headed out to Yass, despite the second migraine for the sweetie in two days :(
I got to take a whole heap of photos of the chookens
.. before moving in the wrong way freaked one of them out and she flew over the fence and onto the balcony then the garage roof..
Annie made a delicous lasagna, and then we all watched Nanny McPhee.
Took a photo of a very yellow looking blue moon..
And that's mars there on the bottom left... (really!)
Woke up early this morning (6am) and couldn't get back to sleep. So got up early and saw this..
Tonight I juiced about a dozen lemons (the slightly older ones). There's still a dozen left! Anyone want any lemons? We have them coming out the wazoo at the moment..
Tonight I juiced about a dozen lemons (the slightly older ones). There's still a dozen left! Anyone want any lemons? We have them coming out the wazoo at the moment..
Tonight after drinks we went over to Damien and Amanda's then out to The Dumpling Inn for dinner. Was a very pleasant meal and evening. The Dumpling Inn was the emptiest I've ever seen it - usually it's packed to overflowing...
I was actually online to have a look at an old script and bit of SQL code which stopped working when I transferred my hosting off Godzilla a couple of years ago. I took a while to remember the sql password and figure out what I needed to change to access MySQL on the new host. Finally got the address book scripts to work, but the birthday script wasn't ordering correctly - it was ordering by item key, not what I'd said to order by. Figured it out tonight - it had some extra ' characters that it didn't need.
Check this out:
$SQL="select id, firstname, lastname, birthday, month(birthday), monthname(birthday), year(birthday), dayofmonth(birthday), ceiling((TO_DAYS(NOW())-TO_DAYS(birthday))/365.25) AS agenext from addressbook where ceiling((TO_DAYS(NOW())-TO_DAYS(birthday))/365.25) is not null order by month(birthday), dayofmonth(birthday);";
So it pulls out a bunch of data from a database including the person's name and their birthday day/month/year. Then it figures out the age they are turning next by looking at the date now and the date of their birthday and dividing by the number of days in the year. The .25 on the end is important, as MySQL uses this for years, and the calculations could be out by a day on the day of the person's birthday if it's wrong. Then it orders it chronologically. Perl is used to put it all together into a neat table which has the person, their birthday, and their age next birthday in a table, ordered correctly, on the fly.
I'm sure there's probably better, less hacky ways of doing it, but I was pretty impressed with it at the time (feel free to put down how you'd do it in the comments :) )
<snip>
Welcome to my little piece of the Blogosphere!
I am a recent Canberra resident after having spent the first 34 years of my life in Sydney. I am married to my beautiful husband Stu, and we live with several computers and a lot of fish.
Kazza's mood:
I am a recent Canberra resident after having spent the first 34 years of my life in Sydney. I am married to my beautiful husband Stu, and we live with several computers and a lot of fish.
Kazza's mood:
Photos
Weather Pixie
Hosting
