Just nak share jer knowledge dengan korang.

Okay let say.. ko ada movie yang mungkin baru lepas download, dan ko seriously amat memerlukan subtitle untuk faham apa yang dikatakan dalam filem tersebut, dan kalau macam tuh korang boleh cuba pergi cari di Open Subtitles (http://www.opensubtitles.org/en) sana. Ada pelbagai title korang boleh pilih, just search the movie, dan download. Semudah itu.

Langkah seterusnya, pergi ke video player korang (aku amat cadangkan korang guna VLC video player), dan open file subtitle tersebut. Dan dalam beberapa saat sahaja, subtitle akan muncul dalam video anda. Semoga tutorial amat gila pendek ini akan mengurangkan kesesatan anda tentang maksud mana-mana filem selepas ini.

Continue reading →

Another tutorial i found on Google, it shows you how to delete duplicate rows of data on your SQL. And after i test it, its really work. Try it!

Link-Back: http://mediakey.dk/~cc/mysql-remove-duplicate-entries/

mysql > ALTER IGNORE TABLE tablename ADD UNIQUE INDEX(value1, value2);

Continue reading →

Finally, i found a way to convert it, thanks to this blogpost i found from Google. Hope it will helps you too developer of the world.

Link-back: http://arjen-lentz.livejournal.com/44290.html

mysql > SELECT INET_ATON('192.168.0.10') AS ipn;
+------------+
| ipn        |
+------------+
| 3232235530 |
+------------+

mysql > SELECT INET_NTOA(3232235530) AS ipa;
+--------------+
| ipa          |
+--------------+
| 192.168.0.10 |
+--------------+

Continue reading →