McDonald Monopoly Singapore 2009
I’ve quite a number of repeated pieces, sigh! Anybody wants it? 
at last, when will i win the final prize of $50,000!
Randoms
- Been going down to velvet, phuture and zouk lately for work related purposes; day time
- Explored various imaging techniques, various raid transferring stuffs, it’s interesting how various licensing can be cloned from one system to another
- I’m gonna catch funny people movie tomorrow
- Windows OEM SLP for the win (:
LogParser v2.2 Output to MySQL
There are multitudes of reasons why you should backup your data to a trustworthy location. Went back to office this afternoon, realised that the files on the server was being deleted; thus causing the script to malfunction, infact the main script was deleted. Anyway, i had to recode from scratch. sigh.
The company is running a standalone MyMailList Deluxe software for years, and they need to merge the datas on the software with the internal application i created for the company. Not everything is automated, the administrator still has to export the CSV file manually to the proper designated folder that propagates the data into database.
Here goes my codes for those who needs it.
———————————————————–
@echo off
echo **************************
echo * Author: John Goh, byon@testaccelerator.com
echo * Date: Oct 06, 2009
echo * Description:
echo * Allows internal application to retrieve latest
echo * company mailinglist information
echo *
echo * Remember to save ExpFile.csv in C:\
echo *
echo * Pre-requisite for server setup,
echo * – install LogParser 2.2, MySQL ODBC 5.1 Driver, MySQL Server 5.0
echo * – Setup ODBC DSN to: mailListDSN under Control Panel (WinXP/2K3)
echo * – Scheduled Tasks this Script Daily
echo * – Put this script in a important directory D:\Applications\
echo * – Remember to do daily backups to this file
echo * – Setup LogParser in the ENVIRONMENTAL PATH VARIABLE
echo *
echo **************************
logparser “SELECT [Acct Start], [Address1], [Address2], [Attn], [Business], [Check Digit], [Company], [Credit], [Custom1], [Custom10], [Custom11], [Custom12], [Custom2], [Custom3], [Custom4], [Custom5], [Custom6], [Custom7], [Custom8], [Custom9], [Special Instructions] AS [SpecialInstructions] FROM C:\ExpFile.csv TO maillist WHERE NOT Company = ”” -i:CSV -o:SQL -server:localhost -database:courier -username:root -dsn:mailListDSN -driver:”MySQL ODBC 5.1 Driver” -cleartable:ON -createtable:ON
———————————————————–
Save it as query.bat and run it off Command Prompt, or Schedule Task it!
Singapore 3.5G Dongle Login for 3G Routers
For people who wants to connect their 3G or 3.5G dongle to a router that supports 3G (HSDPA) dongle, in Singapore,
For M1
Dial number: *99#
Username: ppp@aplus.at
Password: ppp
PDP Type: IP
APN Name: sunsurf
For SingNet/SingTel
Dial number: *99#
APN Name: internet
For StarHub
APN name: StarHub Internet
Access Point Name: shinternet
Username: none
Password: none
Authentication: Normal
Humans akin me, make mistakes
I make terrible mistakes, I want to know if you are forgiving about it. I’m sorry.
You are the only one whom i have ever been real close with ever. (:
Let’s enjoy the show later.
Work now, cya.
Solution: Google Earth: ‘DirectX’ mode not supported
I’ve been using Google Earth on various computers and laptops until i installed Google Earth on Fujitsu Lifebook S6421. The problem doesn’t lie in the proper drivers that are not installed or directx 9.0c. It should also affect: Fujitsu Lifebook S6421BW, S6420WS.
I even went to install DirectX 10 on my Windows XP. But it still fails.
Solution:
- Start -> Settings -> Control Panel -> Display -> Settings tab
- Click ‘Advanced’ button, ‘Troubleshoot’ tab
- Under ‘Hardware acceleration’
- Move the lever to Full
- Check ‘Enable write combining’
- Press ‘Ok’
Now try Google Earth again!
Solution: Uninstall/Removing TrendMicro OfficeScan Password
I have been searching everywhere on removing Trend Micro OfficeScan pre-installed on laptops bought in SMU matriculation. I’ve successfully uninstalled it, here’s the solution if anybody is interested.
Necessary steps:
#1. Change Registry Keys
HKEY_LOCAL_MACHINE\SOFTWARE\TrendMicro\PC-cillinNTCorp\CurrentVersion\Misc
- AllowUninstall value to 1
- NoPwdProtect value to 1
#2. Disconnect from the Internet / Disable Wireless/LAN Adapter
#3. Modify certain values in C:\Program Files\Trend Micro\OfficeScan Client\OfcScan.ini
- Search for [INI_CLIENT_SECTION]
- Change the Keys to these Values
Uninstall_Pwd=70
Client_Allow_Uninstall=1
Client_Allow_Unload=1
Save Ofcscan.ini, Uninstall. It didn’t prompt me for a password, but if it did, enter “1″.
* if it doesnt work, restart the laptop/computer, disable internet connection, then uninstall.
I’ve installed ESET NOD32 over this.
Cheers.
Singapore Traffic Police system has cockups!
notice the date i was fined, 27 Jun 2009 11:58pm.
i was only licensed to drive a class 3 vehicle on 4 Aug 2009
I passed my Class 3 Driving License on 4 August 2009.
Some facts during the period, June, to specifically 27 Jun 2009.
- I just enrolled driving and only drove Mitsubishi Lancer EX
- I was at home sleeping at the point of offense
- I did not have a valid license
- I did not drive SCW604B during that period
definitely a major cockup in their TP computer system. There were no system validations at all. and i almost wanted to pay for it. were they just out for the profits?
fyi, it is a fact that government entities e.g., LTA, are expected to run like a profit organisation. it should ring a bell the day they decided to outsource their traffic management services to Cisco security.
loving you
No one else can make me feel
The colors that you bring
Stay with me while we grow old
And we will live each day in springtime
Cause lovin’ you has made my life so beautiful
And every day my life is filled with lovin’ you
