Star Wars: Retold (By Someone Who Hasn't Seen It)

0

Posted in ,

I found this via plurk when a friend posted it. It's really something. Made me laugh really hard in the middle of the night (dawn). Enjoy!



Star Wars: Retold (by someone who hasn't seen it) from Joe Nicolosi on Vimeo.
Read More

SQL SubSelect

0

Posted in ,

I came across this examples online when I am looking for a solution in selecting data from database that starts with numbers only.

SQL Subselect

SQL Subselect Example One

Q: What Harrison Ford movies were made in 1984?

Select Film_Title
From Thespian_Film_Table
Where Thespian_Last_Name = "Ford"
and Thespian_First_Name = "Harrison"
and Film_Title in
(Select Film_Title
From Film_Table
Where Film_Year equals "1984");

Indiana Jones and the Temple of Doom
Note: The first select gets all Harrison Ford movies. The second select gets all movies made in 1984. Combined the selects get all Harrison Ford movies made in 1984.

SQL Subselect Example Two - Not In

Q: What Harrison Ford movies were not made in 1984?

Select Film_Title
From Thespian_Film_Table
Where Thespian_Last_Name = "Ford"
and Thespian_First_Name = "Harrison"
and Film_Title not in
(Select Film_Title
From Film_Table
Where Film_Year equals "1984");


Air Force One
American Graffiti
Apocalypse Now
Blade Runner
Clear and Present Danger
Frantic
Hanover Street
Heroes
Indiana Jones and the Last Crusade
Patriot Games
Presumed Innocent
Raiders of the Lost Ark
Regarding Henry
Return of the Jedi
Six Days Seven Nights
Star Wars
The Empire Strikes Back
The Frisco Kid
The Fugitive
The Mosquito Coast
Working Girl

Note: The first select gets all Harrison Ford movies. The second select gets all movies made in 1984. Combined with a not the selects get all Harrison Ford movies not made in 1984.

SQL Subselect Example Three - A Correlated Subquery

Q: What movies has Harrison Ford acted in with George Lucas directing?

Select Thespian_Film_Table.Film_Title
From Thespian_Film_Table
Where Thespian_Last_Name = "Ford"
and Thespian_First_Name = "Harrison"
and exists
(Select *
From Director_Film_Table
Where Director_Last_Name = "Lucas"
and Director_First_Name = "George"
and Director_Film_Table.Film_Title
= Thespian_Film_Table.Film_Title);

American Graffiti
Star Wars
Note: A correlated subquery directly ties the table nested in the subquery back to a table in the query.
The first select gets all Harrison Ford movies. The second select gets all Harrison Ford movies Directed by George Lucas. The statement "and Director_Film_Table.Film_Title = Thespian_Film_Table.Film_Title" in the subselect is where both tables are "tied together" or correlated.
Read More

A Penny...

0

Posted in

Several years ago, a friend of mine and her husband were invited to spend the weekend at the husband's employer's home. My friend, Arlene, was nervous about the weekend. The boss was very wealthy, with a fine home on the waterway, and cars costing more than her house.

The first day and evening went well, and Arlene was delighted to have this rare glimpse into how the very wealthy live. The husband's employer was quite generous as a host, and took them to the finest restaurants. Arlene knew she would never have the opportunity to indulge in this kind of extravagance again, so was enjoying herself immensely.

As the three of them were about to enter an exclusive restaurant that evening, the boss was walking slightly ahead of Arlene and her husband.

He stopped suddenly, looking down on the pavement for a long, silent moment. Arlene wondered if she was supposed to pass him. There was nothing on the ground except a single darkened penny that someone had dropped, and a few cigarette butts.

Still silent, the man reached down and picked up the penny. He held it up and smiled, then put it in his pocket as if he had found a great treasure. How absurd! What need did this man have for a single penny? Why would he even take the time to stop and pick it up? Throughout dinner, the entire scene nagged at her.

Finally, she could stand it no longer. She causally mentioned that her daughter once had a coin collection, and asked if the penny he had found had been of some value.

A smile crept across the man's face as he reached into his pocket for the penny and held it out for her to see. She had seen many pennies before! What was the point of this?

"Look at it." He said. "Read what it says."

She read the words "United States of America."

"No, not that; read further."

"One cent?"

"No, keep reading."

"In God we Trust?"

"Yes!"

"And?"

"And if I trust in God, the name of God is holy, even on a coin. Whenever I find a coin I see that inscription. It is written on every single United States coin, but we never seem to notice it! God drops a message right in front of me telling me to trust Him? Who am I to pass it by? When I see a coin, I pray, I stop to see if my trust IS in God at that moment. I pick the coin up as a response to God; that I do trust in Him. For a short time, at least, I cherish it as if it were gold. I think it is God's way of starting a conversation with me. Lucky for me, God is patient and pennies are plentiful!

When I was out shopping today, I found a penny on the sidewalk. I stopped and picked it up, and realized that I had been worrying and fretting in my mind about things I cannot change. I read the words, "In God We Trust," and had to laugh. Yes, God, I get the message. It seems that I have been finding an inordinate number of pennies in the last few months, but then, pennies are plentiful!

And, God is patient...

Have a blessed day!!

The best mathematical equation I have ever seen:

1 cross + 3 nails -------- 4 given

Read More

Decisions

0

Posted in

Have you ever been into a split decisions that you are afraid to make but have no choice but to do so? Or have you ever been into a situation where all is left but to regret the decision we have made after all ?

Lately, I have pushed myself into many situations. Situations that could thwart me hard into thinking or leave me nothing but to make a hasty but unpondered decisions. Those decisions that I don't want to chose yet I have to. Decisions that if left unmade could be troublesome sooner or later.

I don't think I have made the right decisions in my life either. Some of them I have regrets some of them I don't. Regrets that I have for all those mistakes I have made in my past. After all, mistakes don't leave trails of emptiness and sadness in our life all the time. It also leave a lesson or two that we could ponder on. Lessons that must be instilled not only in our very consciousness but also within our hearts.

Maybe, when the next repeating situations pass by, I can make a good choice. As what they say, Experience is a good teacher.

Read More

Downloading Subtitles Using MPC (Media Player Classic)

0

Posted in , ,

MPC means Media Player Classic (download), it is a little old - latest release is dated to 2006-03-20, but that means nothing. It is still one of the best software players floating around. I will show you in this guide how to download perfectly matched subtitles without opening any website using OpenSubtitles.org ISDb protocol.

At the start of deciding which hash should be used for matching subtitles with movies, I checked, if there is no hash algo for this. I found in MPC, it supports downloading subtitles from website, so I contacted Gabest - coder of MPC. We changed some mails, he gave me access to download database, and I came to conclusion - OS should use this special hash - not the best one - but there were already some thousands of hashes submitted. Currently opensubtitles.org have more than 94.000 hashes.

Problem with MPC is, no subtitle database currently exists, so no one can use its unique features. I grabbed some MPC source codes, and programmed ISDb support. Let’s see how it works, it is really simple, and if you will setup MPC, you will (almost) never use “normal” searching anymore.

Step 1: Open MPC, press “O” - you will get options window

Step 2: Find Playback -> Output, change settings to VMR9 (renderless) or VMR7 (renderless) - if you will not change this, Download will be disabled!

Step 3: In options window set in Subtitles -> Database: “www.opensubtitles.org/isdb”, you can test it if you want

Step 4: Open some movie (drag and drop, CTRL+O), and click File-> Subtitle Database -> Download

Step 5: Select some subtitle in your language, click to Download & Open

Congratulations - you are watching movie with subtitles!

If no subtitles are available - don’t panic, go to File -> Subtitle Database -> Search - browser will open and maybe it finds something :) If this step fails too, you have to search those subtitles manually - if they exists on website it means they are not connected with your movie, so it should be nice, if you upload them again.

Maybe you ask how this works - basically it is simple - every movie is connected to subtitle using special hashes (not filenames!). You can help other people, if you will upload subtitles with movie hashes, so other will be able to download them “in fast way”. For the moment it is not possible (and maybe I will never allow this, because I’m afraid there will be many mistakes in uploads) upload subtitles using MPC. For uploading - and for other cool things - you have to use OSCAR or SubDownloader.

Source: http://blog.opensubtitles.org/opensubtitlesorg/downloading-subtitles-using-mpc

Read More

IT3 Family

0

Posted in , ,

The IT3 did enjoy our 10-18-19-06 Trip… After having our dinner with my mates down the space burger and them at a nearby cafe (which i forgot the name) We decided to have our tripping. They wanted to go to someplace exciting. Excitement as in lots of fun and risks. You know, how about going to interlude or someplace similar to that. hehehe.. We went bar hopping (at least everyone at the back of the pick-up knew what i meant) we pass by autoshop, venue, and wew, didn’t quite expect it but landed on the… no, not in MARS, but it is way much better that MARS… we landed on QueensLand. wew! don’t think bad, we just go there to out of curiousity. We park the vehicle nearby the shore, and
just good enough to sniff the smell of the saltiness of the sea. We ate balot (me, plong, kitel, and badjoy) while the others are strolling down the sea. and we talk about stuffs that we don’t normally talk like… (secret!) and we talk and we talk… we talk about stuffs like the teenage stuffs and about the place and about the magnificent statue that Kuya is so curioust about. There badjoy also divulge teptep’s nick - CHICHAY and donna’s nick… (ano nga un???) hehehe.. then after which, we went to a nearby gasoline station to withdraw (C.R.) what we have eaten a while ago. and then deposit food for the vehicle (gasolina). By that time it was past 12 midnight. But everyone isn’t ready to go home. After thinking for a place to stay, they finally decided to go the Chowking. We hopped again to the vehicle and off it goes to Chowking bajada. But then as we entered some of our doodz parted because of some circumstances for instance Kuya Cris because of programming, and dirk because of i dunno. and ghetz which i do not know too. anyways,
There we ate food “Unusually” because we ate against conditions… hehehe… (si leri lang pala un) After a hearty meal. (para sa iba its their breakfast), We then finally decided to go home because its past 2 am na and some of us will be having our defense. We first drop off plong at belisario, then we go to (tagal ko nalaman) jade valley to visit the norstrom’s head programmer and kitels. after which we then search for kuja’s abode and then dropped him (este her pala) off. Then next in line is kitels (for which how many times i thought na bababa na tlga xa kac un na place nya). Then after we drop mario to his pigeon hole and next we dropped donna to his home with me as backup and with a few bodyguards guarding (guarding bah? murag dle gyud.) nearby. Then off we got to teppy’s (chichay’s) house alongside with badjoy and leria and me. We dropped them off (cla duha ni teppy-chichay ug badj) to teppy’s (chichay’s) home then after dropping them off me and leria went home (actually nakikisakay lang po ako) and then she drops me off in the kanto and i rode a motor to my home (kac ayaw daw ni leria ihatid ako kac takot na xa about sa… kaya pala may unan) and then i just went home and un… i am here writing about what happened today… wee… i can’t sleep and its about 6 am here and its minutes to count before i have to take a bath and prepare for school (hanep no walang tulugan). Till hir ciao! and IT3 your my best family ever!!!

Read More

Colorful Life

0

Posted in ,

Happiness is still a mystery to me. Questions mingle with emotions. There are times when mind speaks over heart and so is there a time when the latter speaks over the former. You could question me all you want. Because even you, don’t know that I am also questioning myself the very thing that has been bothering you. Yet I don’t doubt it. Taken will be its end, only I could accept. But I would give in without a fight. Exhausted all means, then death will take its toll.

Still moonless nights of shimmering velvet,
cast over a thousand of times over me.
Still thoughts lingers, could not forget,
if only my heart you could only see.

Dreams floating in vivid crystal green,
keeps me awake in a lonely night.
If the words you said is enough to mean,
will cause this weary heart to flight.

Undying love that rekindles in yellow,
burning love deep, gentle and true.
My life will not end nor even mellow,
because what colors my life is you

Read More