Edit File by line

<?php

[0] Fix | Delete

global $wpdb;

[1] Fix | Delete

$sql = "UPDATE {$wpdb->prefix}icl_flags SET flag = 'eo.png' WHERE lang_code = 'eo' AND flag = 'nil.png' ";

[2] Fix | Delete

$wpdb->query($sql);

[3] Fix | Delete

$sql = "UPDATE {$wpdb->prefix}icl_flags SET flag = 'qu.png' WHERE lang_code = 'qu' AND flag = 'nil.png' ";

[4] Fix | Delete

$wpdb->query($sql);

[5] Fix | Delete

$sql = "UPDATE {$wpdb->prefix}icl_flags SET flag = 'zu.png' WHERE lang_code = 'zu' AND flag = 'nil.png' ";

[6] Fix | Delete

$wpdb->query($sql);

[7] Fix | Delete

[8] Fix | Delete

$cols = $wpdb->get_results("SHOW COLUMNS FROM {$wpdb->prefix}icl_languages");

[9] Fix | Delete

if(empty($cols[6]) || $cols[6]->Field != 'encode_url'){

[10] Fix | Delete

$sql = "ALTER TABLE {$wpdb->prefix}icl_languages ADD COLUMN encode_url TINYINT(1) NOT NULL DEFAULT 0";

[11] Fix | Delete

$wpdb->query($sql);

[12] Fix | Delete

[13] Fix | Delete

$encurls = array('ru', 'uk', 'zh-hans', 'zh-hant', 'ja', 'ko', 'vi', 'th', 'he', 'ar', 'el', 'fa');

[14] Fix | Delete

$sql = "UPDATE {$wpdb->prefix}icl_languages SET encode_url = 1 WHERE code IN ('" . join("','", $encurls) . "')";

[15] Fix | Delete

$wpdb->query($sql);

[16] Fix | Delete

}

[17] Fix | Delete

[18] Fix | Delete