Extend your Whatapps subscription period for Android phone!

Android Whatapps users, worried about the free 1 year subscription expiring and not sure whether will Whatapps will extend for free for another year?

Found a partial solution that is almost as good as a permanent solution. I am not sure, but will Whatapps still be there 10 yrs down the road?

What you need to prepare :
1) An iPhone with Whatapps installed
2) A friend who do not mind their existing Whatapps account being deleted temporarily (will exit all chat groups and delete msg history)
3) (Optional) Backup msg history for yourself and the friend.

Steps
1) Friend to delete Whatapps account on his/her iphone.
2) Delete your Whatapps account
3) Friend to re-register Whatapps account using your phone number. You will receive the sms code from Whatapps. Give the code to your friend.
4) Once registration completed, register your Whatapps account on your phone. You will not get the sms code again but be able to register. Check the subscription date, it should extend for 10 years on your original expiry date.
5) Friend to unregister your Whatapps account on his/her iPhone and re-register using his own number back again~!

Presto~! 10 years extension  of your Android Whatapps~! We deserve the same as iPhone users~!

Find the last alphabet of Singapore Registered Vehicles

Always been trying to remember car number plates to check the vehicle model.
Remembering the first 3 letters + number is easy but the last alphabet tends to slip the mind!
Finally found the formula to generate the last alphabet, in short the checksum of the license plate~! It will be good if there is a website so there is no need to be dependent on anything, just go to website, input and be done with it but till then, the excel file will have to suffice for it.

Excel file here - http://www.mediafire.com/?281rvor0tii2k47

The website to check is https://vrl.lta.gov.sg/lta/vrl/action/pubfunc?ID=EnquireTransferFee

Just key in the licence plate number and a future transfer date. Any date is fine since it is fake.

Unable to run Installshield installer

Error Prompt : Error 2103 = Could not resolve path for shell folder

See follow website for resolution
http://www.appdeploy.com/msierrors/detail.asp?id=143

Alternatively like my case, the profile is corrupted so I deleted it off. Next try will take some time later but hope it works.
After login, it defaults to the basic profile and not of the normal profile loaded.
As the installer needs to refer to some registry settings for folder location. Being unable to locate the registry entry for the folders required, the installer fails.....


From OFF2000: "Internal Error 2103" Error Message Is Displayed During Setup
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q302472

This behavior can occur if the following registry key is missing or damaged:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer\Shell Folders

Remove duplicates rows from a table?

SQL> DELETE FROM table_name A WHERE ROWID > (
2 SELECT min(rowid) FROM table_name B
3 WHERE A.key_values = B.key_values);

Javascript checker

Found this site while being lazy to verify the js myself line by line.
Good parser which actually helps the lazy programmer and prevent future maintenance issues. The site is here.

Remove hyperlinks from Excel

I always had this issue with unwanted hyperlinks due to copying from other places, especially a website.

Finally google for an answer and it is a simple VB script, executable by a marco.
If you need it, here is it

Opera Mobile Bookmark file

The file is opera6.adr (it should be in My Device/Application Data/Opera9).
Copy out and edit on a normal text editor.

Interesting image search

Tineye looks interesting as it helps you find where your image come from. So you can find the rest of the pictures together or just a verification of what you have just seen!

HTML Entities

A website to display HTML Entities with their html codes~!
Nice~!

Xmas coming in a month or so, so here goes~! ❄❄❄❄

Some SEO tips + google recrawling rate

Re-crawl rate -
http://www.google.com/support/forum/p/Webmasters/thread?tid=4c78d983bd68123f&hl=en

SEO tips
http://www.google.com/support/forum/p/Webmasters/thread?tid=337fa24f413c07bd&hl=en

This software suck!

Flexerasoftware's Installshield

Reply from their offline activation

I am glad to assist you in activating your Flexera Software product. Our records show that you have already activated your product.

Once InstallShield is installed and activated, you must uninstall it to free the license. Once you have done so, you can install and activate InstallShield on another machine. We suggest that you follow the below-given procedures for uninstalling your product...

I am just using the bloody software at work and it prompted me to reactivate. I wonder whose problem is this! idiots!

Synchronisation of computer to AD

Just to note that beside checking the date and time of the computer to be joined to the domain, do ensure the timezone is correct also.
Otherwise translation to the timezone of the AD, it is grossly out of time and the allowance for time difference is only 5 mins.

Paying HDB fire insurance using AXS machine

Had a difficult time trying to pay for the HDB fire insurance via AXS as the options for HDB does not include fire insurance.
After trial and error and a final proper look at the letter, there are actually clear instructions.

Some background information :
HDB approved fire insurer - ETIQA Insurance Berhad(ETIQA) (Link)
Seems like there are other fire insurance from various insurance companies that you can buy yours from. Mine seems to be AIA (they have a counter at HDB so make things easier)

Steps :
Choose Bills on the right pane.
Choose Insurance on the tabs
Choose ETIQA and follow the steps.
Fill in some information and you are on your way to pay it.

Do note that it depends who you buy your fire insurance from. Previously, it should be ETIQA and now more commonly AIA.

Hmm quit facebook?

Gizmondo article here

Initially setting privacy settings to prevent others from looking is fine. But it seems like the information are leaking out via applications also...
hmmm....

Omnia II screen resolution

Just a reminder blog to myself that Omnia II resolution is 480 x 800 pixels in case I need it =)

Export/Import Data For SQL Server 2000

useful link

http://articles.techrepublic.com.com/5100-10878_11-1050309.html

Tools to auto detect downtimes on site

http://www.dailyblogtips.com/5-tools-to-auto-detect-downtimes-on-your-site/

Quite a good site to find tools for detecting downtimes.
some of the comments posted their feedback and also other recommendations. Do read thru them also~!

Stylish script for hardwarezone

Stylish add on for hardwarezone

@namespace url(http://www.w3.org/1999/xhtml);

@-moz-document domain("forums.hardwarezone.com.sg") {

div[class="hwz-ad-postbit"]
{
display:none !important;
}
}

Mapking and Garmin settings for Omnia

Found this wordpress guide for Mapking and Garmin settings for Omnia.

A word of advise. To off the com splitter after user mapking. It is still working in the background and will cause your Omnia to be very hot.

Online conversion guide

Was looking for a square meter to square foot conversion and found this on google.

Looks like a decent site with lotsof conversion.

Taking anote here for easy reference. =)

This site is here~!