recent happenings

Lots of things are happening around me.

Firstly, construction has begun in my block. They’re upgrading the elavators that are more than 10 years old to new ones and they’re breaking holes in the walls so the elevators will now stop at every floor.

They’ve recently just begun and the estimated finishing time is the 3rd quarter of 2007. Wow…

Because of them breaking holes in the walls, there’s been a lot of dust floating around. On day 1, when I reached home after work, I noticed dust on my computer desk. The desk is black so it’s easy to see. Now I close the windows and my bedroom door before I leave for work.

– 

I’ve decided to get a digital camera. A Canon Ixus 800. About $629 SGD. And there’s some freebies like a 512MB and a 1GB SD card. Promotional poster here. I’ll need to get a tripod too, to take nice quality pictures.

– 

I forgot about signing up for Japanese lessons! But perhaps, this might be a good chance for me to consider another school, Bunka Language Private School. They seem to be famous for conducting fast and effective lessons.

3 hours a week, total of 8 lessons. And I can choose either Tuesday or Thursday which is friendly to my busy schedule. I hope to start around March or April 2007 because….

I’m planning to go back to Malaysia during Chinese New Year in February 2007! The main reason is to escape work and FFXI. It will also be a good chance to relax and eat lots of delicious food.

The best thing about visiting my relatives in Malaysia is that we go out in a big group every night for dinner. 

Haha, seems like I will have to postpone my plans for visiting Japan to Nov/Dec 2007. I need to accumulate enough days of vacation first to apply for leave. 

SQL puzzle

Can you solve this puzzle?

Comments table:

id entry_id name comment
1 10 wyred tra lala
2 10 bobby boo hoohoo
3 10 teddy lol
4 12 wyred roflcopter
5 13 wyred pong!
6 10 wyred stfu!

id = primary key, auto increment
entry_id = id of the blog entry

Target Result:

Name Comment Total no. of Comments posted
wyred tra lala 4
bobby boo hoohoo 1
teddy lol 1
wyred stfu! 4

Explanation:
Can you come up with an SQL statement that retrieves all the comments for the entry of entry_id=10?

For each user that was retrieved, also calculate the sum of comments he’s made in total.

All this to be done in 1 SQL statement.

argh!

Should have done backups!

I was tweaking the database when I changed the datatype of my comments field from TINYTEXT to MEDIUMINT, I wanted MEDIUMTEXT.

So yea, the change in datatype cause me to lose 265 of the latest comments posted on my blog. I managed to find an old backup of the database but it was very old. Sigh…

*goes off to perform backups*

to a certain dumb cat

You dumb cat! (ノ ゜Д゜)ノ ==== ┻━━┻

I had a feeling you were going to quit but I didn’t expect you to sell your account. But yea, Strawberrie is right, it’s your choice. I guess you find it hard to delete us from your friendlist, drop those linkpearls and say goodbye so it’s easier if you just sold it off and cut it clean.

Meh, I had so much I wanted to tell you when you came back. I was happy when I saw your name online in my friendlist and waited for you to log into the game, it took a few hours so I guess you’re getting the updates. Then when "you" finally logged on, I found out it was a different person.

The new guy seems pretty bad at communicating and he looks like he’s set to dirty the skilled-player reputation you’ve built up over the years. But at least he’s not a gilfarmer from what I’ve observed so far. Bah, I hoped he’d at least tell me first that he’s the new owner instead of making me feel stupid.

I hoped you would have let me know so I didn’t have to feel dumb trying to talk with the new person. I felt glad for Tuufless for being able to quit so I would feel the same for you. Although he’s been showing signs of wanting to return, I think I may just stop him now instead of encouraging him.

I levelled PLD to 75 for a friend who quit, to show my appreciation of him. I will level WHM to 75 (of course not in a hardcore manner!) if you bother to email me or if you don’t have my email, PM me in our sky LS forum. But if you wish to totally break off with the friends you’ve made in FFXI, I’ll understand too.

Wish you all the best in your new relationship! (´з`)y-~