Switch Case in SQL
Usually when designing a database I often use an integer to save values that represent a string. To make it clear see table below:
|
Name |
Role ID |
|
Markus |
1 |
|
Jose |
2 |
|
Anonymous |
3 |
On the table above I use integers to represent role id names, 1 = ‘Administrator’, 2 = ‘User’, 3 = ‘Guest’.
Another Fraud, Using Torabika Name
Two days ago I post about a fraud using a telco provider named Fren. Last night my mother called me and said that my father win a Toyota Innova car from an instant coffee maker. This instant coffee called “Torabika†held an incentive program that will give prizes to its consumer if they bought their product with winner sign inside the sachet.
My father open a sachet of Torabika coffee and found a coupon inside it stated that my father win a car. My first impression is “is it another scam?†as I got a fraudulent phone call two days ago. I said to my mother that may be it’s just another scam, but my mother thinks that it’s not scam as on the sachet it says that Torabika held an incentive program. Plus, my father got the winning coupon from inside the sachet with a contact name (the criminal using “drs. H. Budiman†as his name), a landline phone number and two cell phone numbers to confirm the winning coupon.
Be Careful! Fraud Using Fren Name
Last night around 19.00 WIB I got a phone call to my Fren number from a Fren number that I didn’t know. The caller said that he is from Mobile 8 which is the company that own Fren Telco service. He introduce him self as ‘Budi Setiawan’ a representative from Mobile 8 that want to let me know that I won Rp. 15.000.000,- in cash and Rp. 1.000.000,- of free pulse for my Fren cell phone number.
I feel strange when I receive his call, first it’s Sunday night (19.00 WIB) obviously it’s off of office hours. Secondly, he doesn’t know my name as he asking for my name. From this point I start to be aware that he might be a liar, so I said to him to call me back in 30 minutes as I want to confirm from Fren customer care number. His voice tone changed to a little bit angry and he said why it took so long (30 minutes), third strange.
Last Year, Baby
Last year (from today) I was 23 years old. I was in the Netherlands that day, enjoying the cold weather, clean air, a quiet and nice neighborhood, very fast internet 
having new Indonesian friends that stay in the Netherlands and also new Dutch friends too..
I’m kind of missing the Netherlands, the smell of its air, the buses, the trains, and the bicycle lane. It’s giving me memories that I can’t forget it.
Hard Resetting O2 XPhone II
Today I do a hard reset on my O2 XPhone II. I do the hard reset because I feel that my smartphone was running so slow and having problem with the keypad when I type SMS.
Below are the steps to do a hard reset on O2 XPhone II:
- Turn off your smartphone
- While pressing both softkeys (right and left) press the power key for 1.5 seconds (timing is important)
- If you do it correctly you’ll see a black screen with a message to press ‘0’ to continue the hard reset
- Press ‘0’ and wait the hard reset to finish restoring the settings of your XPhone II to its factory default
- Finish
PS: be sure to backup all your data (contacts, sms, emails, etc.) before you do a hard reset as all data will be erased!
Markus
Crash Problem with PHP 4.4.5 Session Extension
Yesterday I updating PHP on RevTI server from PHP 4.4.4 version to PHP 4.4.5, the update run smoothly until a client complaining that his website show 500 Internal Server Error. My friend, Willy also complaint to me that his website having the same problem.