Buy Revitol Scar Removal Cream for sale in Malaysia

, Friday, September 30, 2011
Scars can be caused by a variety of factors. It may be acne from your teen years, a minor surgical procedure, or just an accident that left a scar on your skin. However you got them, you know that scars can be terribly unsightly and you just want them gone. But how do we get rid of them? After all, aren't scars supposed to be permanent? That used to be true, but it doesn't have to be anymore. With Revitol Scar Removal Cream you can finally get rid of those ugly scars once and for all.

Weakness and bad parts of websites

, Saturday, September 24, 2011

facebook.com :
Problem 1 : When user upload a photo to an album, after the user choose the picture from the computer, there are 2 buttons "Open", "Select Photos". Supposly user have to click "Open" button, but most of the user will careless click on "Select Photos" button, it will cause error to the page. See the picture below for reference :

My Thing's Photo - Part 2

Friday, September 23, 2011
Above picture shows I got Sailor Moon sticker albums, and yes! I love Sailor Moon. Lol.
Above Picture shows My dragon ball stickers collections, I got about 15 albums, can imagine how many are the stickers I have. I wasted a lot of money on that when I was small. Ish
I got a lot of Sailor Moon stickers too. Wakaka. Above picture shows my Dragon Ball card collection. I got about 2000+ dragon ball cards, all are different from each other! Wow!

Best websites / players / softwares to watch latest movies

Thursday, September 22, 2011
Do you want to watch latest cinema movie online?
1) PPStream - http://www.ppstream.com
2) Funshion - http://www.funshion.com
3) Xun Lei - http://www.xunlei.com
4) QVOD - qvodsou.cc | 33md.cc | tom365.com
Comparison between them :
PPStream :
1) PPStream doesn't has latest movie an anymore, it has outdated movie only.
2) PPStream will slow down your internet speed when you are downloading movie. (Solution to avoid PPStream slow down your internet at HERE).
3) If you use software to limit PPStream uploading speed to 3kbps just to avoid it slow down your internet speed, its downloading speed also will be slowed down so much (movie downloading speed become extremely slow).

Funshion :
1) Funshion has many latest movies.
2) Funshion will not slow down your internet speed when you are downloading movie.
3) Some user facing problem about Funshion website loading very slow until they can't open it and can't download funshion player from it, the here is the solution http://ye5.blogspot.com/2011/09/cannot-open-funshion-website-loading.html

Xun Lei:
1) Xun Lei is a software to download movie, not a software to play movie, but the installer of Xun Lei comes with Kan Kan player.
2) You can't watch the movie when the movie is downloading unless you pause / stop the downloading. (You can download three movies at the same times, so when watch 1 of the movie, u can still downloading other 2 movies).
3) Xun Lei has many errors. For example, 错误代码:0x8004022F(-2147220945). You can fix this error by the following steps :
Step 1) Unistall Xun Lei completely. After uninstall it, go to delete all files and folder of Xun Lei in Computer > C drive > Program Files.
Step 2) Download latest version of Xun Lei from http://www.xunlei.com.
Step 3) Install it.
Step 4) Try to open it and use it to play movie to check whether or not the error is fixed.
Reference at http://zhidao.baidu.com/question/108361952.html.

QVOD :
There are two different versions of QVOD player, tom365.com | 33md.cc are using the same QVOD player, but qvodsou.cc using other version of QVOD player. So if you want to watch movies on all the websites, you need to install both versions of QVOD. qvodsou.cc has many latest movies. After installing QVOD player onto your compter, you need to open those website by Internet Explorer, then right click the Active-X plugin at top bar there, choose allow Active-X, then only you can start downloading the movie.


If you have installed all the players onto your computers, just like me. Some of the player will downloading / uploading the movies secretely behind the scene, they will slow down your internet. If you are facing internet slow problem, you want to exit all those players, you need to exit the player 1 by 1 and you need to press CTRL + ALT + DELETE to bring up Task Manager, search for the players' process, end the process... There are so many steps and very inconvenient that you need to spend time do all the steps repeat and repeat again everyday. So I have create a program to exit all of them in 1 click. To create the program, please follow the steps below :
1) Open a notepad.
2) type the following words into the notepad :
taskkill /f /im ppstream.exe
taskkill /f /im ppsap.exe
taskkill /f /im ppap.exe
taskkill /f /im qvodplayer.exe
taskkill /f /im qvodterminal.exe
taskkill /f /im funshion.exe
taskkill /f /im funshionservice.exe
taskkill /f /im thunder.exe
taskkill /f /im thunderplatform.exe

3) Save the notepad (Choose All Files (*.*) at "Save as type :" field. Then type exitPlayers.bat at "File Name :" field. Then Choose Desktop as the saving location.
4) Everytime you want to exits all the players, you just need to double click exitPlayers.bat icon on your desktop.

Mobile phone connect to wifi but charge fee for gprs

Tuesday, September 20, 2011
When you are connecting your mobile phone or handphone to wifi or wlan, you still get charged fee for gprs when you are :
1) browsing the website.
2) downloading java games or application.
3) download android games or application.
4) playing games.

Why this happen? It is because you didn't change GPRS to WIFI / WLAN in profiles settings yet, There are many profiles settings to be set :
1) Java setting,
2) Java games setting,
3) Service setting,
4) Browser setting,
5) Android app default setting,
6) Android games setting.

Different phone has different setting location, I give u example for my phone below :
To set java games : select game > options > receiver > java sim1 profile > WLAN

To set safari browser : safari > setting > profile > WLAN

After set all things from GPRS to Wifi / WLAN, you can test it by the following steps :
1) You can go to reset your gprs counter to 0. The gprs counter is on Call History for some mobile phone.
2) Try to online browse some website / download games / play game.
3) Check gprs counter.

Note that gprs delay to charge the fee. Last time I was stupid enough, I used my mobile phone browse website, download games, play games, then I go check my phone credit balance, the balance is still the same, so I though I was using wifi, and not using gprs. But on the next day, I checked my phone credit balance again, OMG! It charged RM25 for gprs! So if you want to check gprs charge, don't check with your credit balance, you can check with gprs counter.

Cannot open funshion website loading slow

Tuesday, September 20, 2011
Funshion is so good but unfortunately some internet users might have some trouble to download Funshion player due to Funshion website server loading is too slow. If you are having this problem. Below is the solution steps :
1) Use Google DNS. The info of Google DNS at http://code.google.com/speed/public-dns/
2) Use Internet Explorer visit http://fs.funshion.com/download/.
3) Click on 新浪下载 to download Funshion player. If 新浪下载 server is too slow for u and fail to download it, then u should try click on 太平洋下载 or 腾讯下载 or ZOL下载 or 天空下载. You need to try 1 by 1 until you success download it. Be careful see the download button carefully, make sure you click the right button, see the picture below, most of people will click the first download button but it is actually a wrong button!!

4) If you have tried to download the player from all servers but none of them success, you can download it from my own hosting at http://2aek.com/inventory/funshion.exe which is 2.4.2.56 version only.

5) Install it.
6) Click "Play" button on the movie that you want to watch.

Computer cannot connect to wireless network until restart the computer

Saturday, September 17, 2011
Do you face this problem? When your computer is connecting to wireless network, suddenly it disconnected and cannot connect it back until you restart the computer. Actually you don't need to restart your computer:

If your computer can't find / can't detect / can't search / can't connect the wireless network, you can try to unplug the wireless adapter, then plug it to other usb port, then connect your computer to wirefless network.

If your computer can connect to wireless network, but cannot surf the internet, cannot browse website, then do the 5 steps below :
1) Right click on wireless icon,
2) Choose "Diagnose and Repair",
3) Choose "Restart DHCP".
4) It will take 10 seconds to restart DHCP,
5) Then you go to connect wireless again, it should work.

One of my friend said that when her laptop disconnected from wireless network, she was in the middle of something important so she cannot restart the computer, she need internet connection to save her works. She said she waited for 30 minutes later then only her laptop can connect back to the wireless network. So conclusion is there are 3 different solutions to solve this problem :
1) Restart computer / laptop,
2) Restart DHCP,
3) Wait for 30 minutes.
Obviously solution number 2 (Restart DHCP) is better than all of other.

Windows Vista / 7 / iphone cannot connect to wireless network which has password security? Resolved!

Thursday, September 15, 2011
It is hard to connect wireless network that has password security on windows vista and windows 7 and iphone4.

For windows xp, just double click to connect the wireless, then type password can d, but for windows vista/7/iphone is NOT that easy!!!,

Western Union Scam

, Wednesday, September 14, 2011
Western Union is good for transferring money to family & friends NOT for purchasing things online!
Published: 17 Mar 2009 02:02:29 PST
This scam is becoming one of the most common scams used by scammers. Essentially, a Western Union scam is any scam that takes place using the Western Union method of payment.
Most commonly, there is a situation where a buyer pays for something via Western Union, and then never receives what was paid for; or the buyer pays for an item via Western Union, and then receives an item of a value far lower than what was actually paid for.

Php and mySQL Notes

Wednesday, September 14, 2011
Convert datetime format by using php :
$originalDate = "2010-03-21";
$newDate = date("d-m-Y", strtotime($originalDate));


$servertime = date("Y-m-d H:i:sa",time());
if(strtotime($servertime) < time()-10800)

the if statement will fail because variable $servertime contain value of "am/pm", need to delete the "a" from "Y-m-d H:i:sa" will fix it.

ADDTIME ('zzz'); and TIMEDIFF ('zzz') fail because there is a space before (

3D Tattoos

, Monday, September 12, 2011
Here are some creative 3D tattoos :

Strange illness

Monday, September 12, 2011
Below are some strange illness that you might not seen before, please tell me what illness are they, give me the name of illness, factor that cause the illness, provide me the link for reference if u know any. Thank you.
1

Crazy Body Modifications Pictures - Part 2

, Monday, September 12, 2011
Here are some crazy body modification pictures, they said "pain is a beauty", they enjoy the pain process and they love how they look like. This page has some video about their body modification process surgery : http://ye5.blogspot.com/2010/11/8-most-crazy-body-modifications.html

My Favorite Cars

Monday, September 12, 2011
Below are 3 of my favorite cars :
1 - Lamborghini Aventador - I don't like it's back, I personally think it's back is ugly.
2 - GTE Evora - It looks very cool. I like its sharp shape with little curve. Perfect sides and back view, front view is not so good.
3 - Lotus Elise - Cute. Full of curve, less sharp (Not should me because I am Z, the alphabet "Z" has no curve. I am like cool instead of cute), but I don't know why I still very in love with its cute shape, love this car!

I wondering they can drive into car-park in shopping complex since their bumper is quite low, maybe need to change a bigger wheels?

Fully imported car in Malaysia have to pay tax for Extra 200% .(100% car price + 200% tax).
I saw road tax Malaysia for Lamborghini are RM8000, RM16,000, and RM18,000.

How to use phpMyAdmin Database

, Saturday, September 03, 2011
To create a Foreign Key :
1) Convert all MySQL tables from MyISAM to InnoDB.
2) Set Index onto column which u want it to be foreign key.
3) Click Relation view > Choose parent column (primary key for other table) > Choose CASCADE on "ON DELETE" drop down list.

If you can't apply Foreign Key to a particular field, because of error #1216 or #1452 - Cannot add or update a child row: a foreign key constraint fails. Why? Because parent's table doesn't has the records that child's table has, so can't apply foreign key on the child's table. Fortunately, I've found some handy SQL queries using LEFT OUTER JOIN to clean child tables and easily delete unmatched records. As always, don't forget to BACK EVERYTHING UP before attempting these queries!! First, to find "wayward" records with no matching id in a corresponding parent table:
SELECT * FROM `agenda` LEFT OUTER JOIN meetings on
agenda.meeting_id=meetings.meeting_id WHERE
meetings.meeting_id is NULL;

DELETE agenda.* FROM `agenda` LEFT
OUTER JOIN `meetings` ON agenda.meeting_id =
meetings.meeting_id WHERE meetings.meeting_id IS NULL;


Reference at : http://www.mytechmusings.com/2008/04/using-foreign-keys-in-mysql.html and http://lists.mysql.com/mysql/212302


To add a Composite Primary Key :
You can use SQL ALTER TABLE myTable
ADD CONSTRAINT pk_myConstraint PRIMARY KEY (Column1,Column2)


Or use the interface, after the table is created, you can add an index (type 2 or 3 in textbox of columns). Then select columns to be the composite primary key, then choose "Primary Key" from Index Type drop down list.

Reference at : http://www.sitepoint.com/forums/mysql-182/composite-key-through-phpmyadmin-290795.html and http://stackoverflow.com/questions/1545571/how-do-i-make-a-composite-key-with-sql-server-management-studio


To reset auto increment id on table :
You don't need to waste time to create a new table, you can just delete all records in existing table then run SQL : ALTER TABLE `table_name` AUTO_INCREMENT =0
Reference at : http://www.knowledgesutra.com/discuss/ttlist-reset-auto-increment-phpmyadmin.om


To find where is the foreign keys of particular primary key (getting error when trying to rename the field of primary key because there is foreign key on other table linked by the primary key) :
There are 2 different solutions :
1) SQL to list out all tables that has foreign keys of a particular primary key :
select ku.*
from INFORMATION_SCHEMA.table_constraints tc
INNER JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE ku ON
(tc.CONSTRAINT_NAME = ku.CONSTRAINT_NAME and tc.CONSTRAINT_SCHEMA = ku.CONSTRAINT_SCHEMA )
where constraint_type='FOREIGN KEY' and ku.REFERENCED_TABLE_NAME = 'your_table_name'


2) You go rename the field to get error, then type SQL :
SHOW ENGINE INNODB STATUS
Then look at the "LATEST FOREIGN KEY ERROR" section. Reference at http://stackoverflow.com/questions/7463221/sql-lists-out-all-foreign-keys-of-a-primary-key


SERIAL is the best datatype for auto increament id field, because SERIAL is BIGINT UNSIGNED NOT NULL AUTO_INCREMENT UNIQUE. It can accept integers from 0 up to 18446744073709551615 (max is 20 digits only), if I assign length 50, it will still accept 20 digits only, it won't accept 50 digits. 18446744073709551615 is the largest integer accepted. You cannot use 2 Serial on two fields in a table because 1 table can has 1 AUTO_INCREMENT field only. The word UNSIGNED is attribute. Reference at here.

I cannot find the different between BIGINT Signed and Unsigned, however the different between CHAR Signed and Unsigned :
-Signed char, which gives you at least the -128 to 127 range.
-Unsigned char, which gives you at least the 0 to 255 range.
-Signed number uses one bit to determine whether the number is positive or negative, an unsigned number is positive.
Reference at here.


Different between datatype Char and Varchar :
Char :
- Use Char if all of records values have the same length. Eg, if u set Char to 5 characters, each records will be 5 bytes.
- Don't use Char if all of records values have difference length. Eg, u store "abc123" on Char(10), it will be "0000abc123" or "abc1230000", u need extra work to delete all 0000. This feature could lead to many irritating bugs during development and makes testing harder). Info at here.
- Char can be faster and more space efficient.
- Use Char if you need to update the records frequently, because it won't grow the size everytime update the records.

Varchar :
- Use Varchar if all of records values have different length. Eg, if you save record "love1234", the size will be 8 bytes (to save the value) + 1 byte (to save the length of value). Varchar need extra 1 or 2 bytes to save the length of value. Info of datatype at here. The example of size of data / records are at here.
- Don't use Varchar if records need to be updated frequently because their size will grow, which can cause extra work. if a row grows and no longer fits in its original location, the behavior is storage engine-dependent. Info at here.

Example :
store the word "FooBar" :
CHAR(6) = 6 bytes (no overhead)
CHAR(10) = 10 bytes (4 bytes of overhead)
VARCHAR(10) = 7 bytes (1 byte of overhead)

Conclusion : Use Char only if you have fixed length of records values. Don't use Char if the length of records values are different, even 1 character different also must NOT use Char.


Comparison between Varchar vs Text at here.


Normalization :
If some of the fields are missing (null) for a bunch of the rows, they make a good candidate for splitting off -- the extra table would have fewer rows. You would use LEFT JOIN to put things back together when needed. Eg :
FROM t1 JOIN t2 on t1.ID = t2.ID

JOIN / INNER JOIN show the records on both tables. LEFT JOIN / LEFT OUTER JOIN show the records on 1st table. RIGHT JOIN / RIGHT OUTER JOIN show the records on 2nd table.







Enter your email address:

Subscribe in a reader

Follow zac1987 on Twitter

Donation

If you feel my website is informative and it is useful for you, please donate some money to support me or buy me a drink. I will continues this good works. Thank you.