Monday, September 8, 2014

How to type Khmer Unicode ver1_km

យូនីកូត​គឺ​ជា​គ្រោង​ការណ៍​បម្លែង​កូដ​ជា​អក្សរ​សកល​សម្រាប់​វាយ​អក្សរ និង​អត្ថបទ​ដែល​កំណត់​នូវ​វីធី​ជាប់​លាប់​នៃ​ការ​បម្លែង​កូដ ប្រើ​បាន​ច្រើន​ភាសារ ដែល​អាច​ផ្លាស់​ប្តូរ​ទិន្នន័យ​អត្ថបទ ជា​អន្តរជាតិ និង​បង្កើត​មូលដ្ឋាន​គ្រិះ​សំរាប់​ផ្នែក​ទន់​ជា​សកល។
How to use Khmer Unicode by Nida: https://www.dropbox.com/s/64fbdpopy4z6185/How_to_type_Khmer_Unicode_ver1_1km.pdf?dl=0

Khmer Unicode Keyboard (Nida):
https://www.dropbox.com/s/smgve75v39nku7p/KhmerUnicodeKeyboardLayout.pdf?dl=0

Khmer Unicode Keyboard (Windows):
https://www.dropbox.com/s/3g5rxj40mh02oqz/keyboard-Windows.pdf?dl=0

Khmer Unicode Typing: https://www.dropbox.com/s/727az6vo69p13bc/KhmerUnicodeTyping1.6.0.exe?dl=0

Friday, May 2, 2014

Auto sync two mysql tables with exception

Auto sync two mysql tables with exception

-- this is comment in SQL language (line starts with --)
CREATE EVENT event_daily_copy_something
    ON SCHEDULE
      EVERY 1 DAY
    COMMENT 'This text will appear in MySQL Workbench as description of event'
    DO
      BEGIN
        INSERT INTO your_db_name.target_table_name(id, field)
          SELECT id, something
            FROM your_db_name.source_table_name
            WHERE id = 3;
      END

Synchronization of tables is quite complicated. I think you need few operations in event.
  1. Check for new rows and copy
  2. Check for deleted rows and delete them in "copy" table
  3. Check for changed rows (here trigger on source table would be very useful, because trigger "knows" what row is edited and you can access new field values in table 1 and use them to update table 2).

Thursday, May 1, 2014

How to insert 3 or multiple arrays into 1 or 2 MySql tables

After googling for 2 days, Here is how to add multi-arrays into MySQL tables

Example we have 3 arrays:

$item= array(1, 2, 3, 4, 5);
$fruit= array('apple', 'banana', 'ananas', 'orange', 'lemon');
$price= array(32, 54, 26, 97, 47);

foreach($fruit as $key => $fruitName)
    {
    $query = " INSERT INTO fruits (item, fruit)
               VALUES ('$item[$key]', '$fruit[$key]')";
    mysql_query($query) or exit(mysql_error());
    $query = " INSERT INTO prices (item, price)
               VALUES ('$item[$key]', '$price[$key]')";
    mysql_query($query) or exit(mysql_error());
    }
This code is working as charm ! Enjoy.

Sunday, March 30, 2014

The wizard was interrupted before Symantec Endpoint Protection could be completely installed

Common Error for Symantec Endpoint V 11.5:

1) The wizard interrupted before Symantec Endpoint Protection could be completely installed2) Error: LiveUpdate could not access its settings. Error Code: 0x00000000

Solution

1. A clean install of the latest compatible release of LiveUpdate often resolves this issue.

Uninstall Symantec LiveUpdate with Add/Remove Programs
Change the following registry key:

Saturday, March 22, 2014

My Jailbroken iphone 5 appears as non jailbroken in iTools and cannot install IPA from AppCake

My Jailbroken iphone 5 appears as non jailbroken in iTools. How to fix it:


1) Go to Cydia 
2) Search for afc2add 
3) Install it.

Wow, it is working as charm.

My Jailbroken Iphone 5s IOS7 cannot install IPA from AppCake:
1) Go to Cydia 
2) Search for appsync for ios 7.0
3) Install it.

Wow, it is working as charm.

Note: Heavenstore is not working, so you have to import IPA file to AppCake by using Ifile or similar app. afc2addafc2add

Thursday, March 13, 2014

How to Reset Restriction Passcode on iPhone/iPad Using iFile [Jailbreak Required]

One of the hardest things to happen is you forgetting the Restriction passcode. We’re talking about the passcode that you set for Settings  General Restrictions.
Restrictions help you control what part of your iPhone/iPad is accessible. You can disable apps, control the installation /deletion of apps etc. through Restrictions. In order to use them, you should set a passcode. And if you happen to forget it, it seems impossible to reset the code without restoring your iPhone/iPad as a new device.