As Dated.

C152, its been really quiet around here. Anyhow, Mario's birthday was on the 23rd of this month, Saturday. I'm thinking of celebrating it for him in the club, on monday. Are you guys free? Please let me know on msn if you see this. He himself never visits here, so its a safe bet that our plans are secret lol.

On an off note, a nice song:

SoY Cosfest 2008 @ Ngee Ann (again, copy-pasted from personal blog)

It's been awhile. This was meant to be written two weeks ago. But then, thanks to killer projects and empty-outcomed exam papers, I hadn't much time for leisure. We even stopped playing badminton, me and my coursemates. And what's worst, the final submission for AI is due. God..

As always, after one paragraph of moaning, let's go the 'fun' part. Not really fun in my opinion, because it was destroyed by location. You will know what I mean soon enough. SoY 2008, short for Start of Year, is a cosplaying event held at Ngee Ann Poly sometime around late last month. Me, Shawn, Zech, Kok and Del went to manage Sticker no Tenchi. In order of positions following the above line-up, it's Noob Designer, Lead Designer, Manager, and Vice Manager. Del? He's 'I anything', so that's how he ended up with us for that trip.

We set off at around 9am, because we have to set up our booth by 11am, which was the time the event commenced. We reached the nearest MRT station and took a bus there, and dropped one stop earlier. What the hell. So anyway, we walked over to Ngee Ann. It's a beautiful place, with colourful buildings and even traffic lights inside the campus (THEY HAVE POWER SOCKETS UNDER THE BENCHES, ZOMG), but what the peeps don't like about Ngee Ann, it's anti-WoW, lols.

We reached the event area, and waited for directions to our booth. I had the information that we have Booth 14, the nearest booth to the stage. But guess what, they relocated the event to an LT (Lecture Theater), so our booth got relocated too. From having the most obvious booth, we got an oblivious booth now, with the same number. Zzz. Some management.

The traffic was bad, and the outcome, few sales. This is stupid. At least we covered the rental cost, I won't reveal any further, but it was stupid. Even Shawn got pissed, that's rare, but not so rare in DotA. Hehe. The cosplayers themselves are not bad, I managed to run around abit, but didn't get to see much because of lack of movement. So anyway, here are the pictures from the event. Enjoy, and til next time, ja ne~

Setting up the booth

Setting up the banner

Booth set-ed up

Banner set-up (with help from our bags, lols, 'cause the wind was strong)

The awful boot location (50m away from LT, zzz)

The LT exterior

The traffic there, better eh?

It was damn heavy at the main foyer, haiz

Honey-Senpai again?

Hah, caught it when she dropped it, lols

Guess who...

It's Ryuk!

Pose up! With Ping Guo!

Random Picture

Random Picture

Akito and Agito

Still, still..

Finally got their pose up, but I got my angle wrong, zzz

Random Picture

Ryuk up on stage

Black Rose, my Kouhai likes it

Zomg, he really look like a boss (hehe, he didn't notice me taking the picture)

The few who passed by

Hanging sticker display

The two "middle schoolers" me and Shawn drools over

Make-up, make-up...

Zech knew the red-haired dude

A very young (and short) Luffy

Lawl-ed

A little post for the (artificial) intelligent.

"so i can safely presume you geniuses are all EXTREMELY intelligent, because CLEARLY the BIN, of all things, can "amuse" us more than either you or me. Perfectly logical, huh?

You know how we can find out who you guys are? simple. We'll know it you when we see people staring at that random bin and actually finding it funny.

Heres a little quote i have for you limbless geniuses, from yours truly. "LIFE. Get some." Firo, Out."

- Firozaki

As Dated.

I don't want to add more shit to the other post, so here's for all the drummers. Watch the first minute at least =D


Who says girls can't be hawt and play too?
p.s. I wonder if it'll hurt getting punched by her. Her beauty might offset the pain from her strength-modifier.

As Dated.

Okay. Knowing how much a sucker for all things japanese so many of YOU are (er-hem. Not me, thank you very much.), I've decided to bring to your attention this as-of-now-defunct japanese CHICK band. Really. They're good. (AND THEY LOOK GOOD TOO OMIGOSH.)

First Vid (Pedo Alert, someone restrain that bear! They were 13 at the taking of this vid!)


In Better Times


In Better Times, continued...


Their Last Live (Band CUI-ed, and they were only 18 D= )

It's highly suggested you guys go trawl through j00toobis and look for their last live perfomances. They're really good.(AND IT REALLY DOESN'T HURT THAT THE BASSIST IS SO DARN CUTE AND THE DRUMMER IS PRETTY TOO!)

p.s. Now, did I really post that? No, I didn't. This post never existed, agree?

p.s. of the p.s. my all time favourite song from ZONE:

database

lol jem... nice of you to.

all the best to ppl takin the test...

Answers for ONGD Revision. lolz

ONGD Re-test 5/2/08 LT4 3pm-5pm D=

2a)
SELECT SUM(Quantity) FROM stamp_album;

b)
SELECT Member_ID, Count(*) "Number of Albums" FROM album WHERE Member_ID IN ('S03','S05') GROUP BY Member_ID;

c)
SELECT a.album_ID, a.album_theme, SUM(s.quantity) FROM album a, stamp_album s WHERE a.album_id = s.album_id GROUP BY a.album_ID, a.album_theme;

d)
SELECT * FROM stamp WHERE Country = 'Singapore' AND date_issued between '01-Jan-60' AND '31-Dec-70' AND Price > 15 AND Stamp_desc LIKE '%Orchid%';

3a)i)
DELETE FROM member WHERE member_id = 'S05';

ii)
This operation will fail as it violates Referential integrity constraint. The value from member_id is referenced by album_table.

b) i)
INSERT INTO stamp VALUES (29501, 'U.S.A(Hawaii)','150th Anniversary of the Honolulu Advertiser','2006-07-02',26);

ii)
This operation will succeed. the stamp_id is unique. It does not violate the Primary Key constraint.

e)i)
UPDATE stamp_album SET album_ID = 5 WHERE stamp_id = 10000 AND album_id = 1;
ii)
This operation will fail as it violates referential integrity constraint. there is no album_ID 5 in the album table.