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

LG F100S or F100L Phone

Upgrade LG F100L to 4.1.2 Khmer version

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).

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.

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

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

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.

How to Convert Excel Numeric Cell Value into Words

There is no built-in formula in excel, you have to add a vb script and permanently save it with your MS. Excel's installation as Add-In.

Step1: press Alt+F11 Step2: MENU: (Tool Strip) Insert Module Step3: copy and paste the below code

Important and useful website:

Coloring page for Kids:
1)  http://www.colouring-page.org/
2) http://www.coloring.ws/
3) http://www.dltk-kids.com/

Web design company
1) http://www.provab.com/
2) http://bayontech.com

Mobile Technology
1) http://www.redmondpie.com/
2) http://android.pandaapp.com/

Web Coding / Windows
1) http://stackoverflow.com/

Windows system assessment tool has stopped working Win 7

How to solve Windows system assessment tool has stopped working Win 7 when running rating
Sometimes it's cache gets bugged, and will not provide a rating. Try this - (copied from another site)
Go to Start menu and find Command Prompt in Accessories.

How to Auto Share YouTube Videos on a Facebook Fan Page with the Cueler YouTube App

YouTube allows its users to auto-share their posts both on Twitter as well as on a Facebook profile. But not on a Facebook page (otherwise called fan-page). There is an app now on Facebook called "Cueler YouTube" that allows this as well as the following features: