Monday, November 10, 2014

How To Host Sub-Domain On Different Hosting Account

How to hoste Sub-domain on Other hosting company:

In my case, I decided to host my forum on Bluehost hosting, and keep my main blog on WPEngine only. This way, I will avoid the huge charges of WPEngine (Their Billing plan works on number of visits), and this will make more sense in term of server load. Here is the exact steps I followed, and it will work with almost all the hosting and domain registrar.

In my scenario: My Domain is hosted on ShoutMyDomain and blog is hosted on WpEngine. And my goal was to host forum.shoutmeloud.com on Bluehost hosting.

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

Wednesday, August 20, 2014

LG F100S or F100L Phone

Upgrade LG F100L to 4.1.2 Khmer version

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.

Check for new rows and copy
Check for deleted rows and delete them in "copy" table
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:

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