Edit File by line

<?php

[0] Fix | Delete

/**

[1] Fix | Delete

* @package wpml-core

[2] Fix | Delete

[3] Fix | Delete

[4] Fix | Delete

global $wpdb;

[5] Fix | Delete

[6] Fix | Delete

$current_table = 'icl_languages';

[7] Fix | Delete

$sql = "ALTER TABLE {$wpdb->prefix}icl_languages MODIFY default_locale varchar(35), MODIFY tag varchar(35);";

[8] Fix | Delete

$result = $wpdb->query( $sql );

[9] Fix | Delete

if(false!==$result) {

[10] Fix | Delete

$current_table = 'icl_locale_map';

[11] Fix | Delete

$sql = "ALTER TABLE {$wpdb->prefix}icl_locale_map MODIFY locale varchar(35);";

[12] Fix | Delete

$result = $wpdb->query( $sql );

[13] Fix | Delete

}

[14] Fix | Delete

[15] Fix | Delete

function update_seo_settings() {

[16] Fix | Delete

global $wpdb;

[17] Fix | Delete

[18] Fix | Delete

$sql = "SELECT option_value FROM {$wpdb->options} WHERE option_name = %s;";

[19] Fix | Delete

$sql_prepared = $wpdb->prepare( $sql, array( 'icl_sitepress_settings' ) );

[20] Fix | Delete

$data = $wpdb->get_var( $sql_prepared );

[21] Fix | Delete

$sitepress_settings = unserialize( $data );

[22] Fix | Delete

[23] Fix | Delete

$settings_updated = false;

[24] Fix | Delete

if ( ! array_key_exists( 'seo', $sitepress_settings ) ) {

[25] Fix | Delete

$sitepress_settings['seo'] = array();

[26] Fix | Delete

}

[27] Fix | Delete

[28] Fix | Delete

if ( ! array_key_exists( 'head_langs', $sitepress_settings['seo'] ) ) {

[29] Fix | Delete

$sitepress_settings['head_langs'] = 1;

[30] Fix | Delete

$settings_updated = true;

[31] Fix | Delete

}

[32] Fix | Delete

[33] Fix | Delete

if ( ! array_key_exists( 'canonicalization_duplicates', $sitepress_settings['seo'] ) ) {

[34] Fix | Delete

$sitepress_settings['canonicalization_duplicates'] = 1;

[35] Fix | Delete

$settings_updated = true;

[36] Fix | Delete

}

[37] Fix | Delete

[38] Fix | Delete

if ( ! array_key_exists( 'head_langs_priority', $sitepress_settings['seo'] ) ) {

[39] Fix | Delete

$sitepress_settings['head_langs_priority'] = 1;

[40] Fix | Delete

$settings_updated = true;

[41] Fix | Delete

}

[42] Fix | Delete

[43] Fix | Delete

if ( $settings_updated ) {

[44] Fix | Delete

$data = serialize( $sitepress_settings );

[45] Fix | Delete

$wpdb->update( $wpdb->options, array( 'option_value' => $data ), array( 'option_name' => 'icl_sitepress_settings' ) );

[46] Fix | Delete

}

[47] Fix | Delete

}

[48] Fix | Delete

[49] Fix | Delete

update_seo_settings();

[50] Fix | Delete

[51] Fix | Delete

if(false==$result) {

[52] Fix | Delete

throw new Exception('Error upgrading schema for table "' . $current_table . '": ' . $wpdb->last_error );

[53] Fix | Delete

}

[54] Fix | Delete