Edit File by line

<?php

[0] Fix | Delete

[1] Fix | Delete

function update_icl_strings_charset_and_collations() {

[2] Fix | Delete

global $wpdb;

[3] Fix | Delete

[4] Fix | Delete

if ( ! icl_table_column_exists( 'icl_strings', 'domain_name_context_md5' ) ) {

[5] Fix | Delete

include_once dirname(__FILE__) . '/upgrade-3.2.3.php';

[6] Fix | Delete

}

[7] Fix | Delete

[8] Fix | Delete

$collate = false;

[9] Fix | Delete

[10] Fix | Delete

if ( method_exists( $wpdb, 'has_cap' ) && $wpdb->has_cap( 'collation' ) ) {

[11] Fix | Delete

$collate = true;

[12] Fix | Delete

}

[13] Fix | Delete

[14] Fix | Delete

$language_data = upgrade_3_5_1_get_language_charset_and_collation();

[15] Fix | Delete

[16] Fix | Delete

$sql_template = "ALTER TABLE `{$wpdb->prefix}%s` MODIFY `%s` VARCHAR(%d) CHARACTER SET %s %s";

[17] Fix | Delete

[18] Fix | Delete

$fields = array(

[19] Fix | Delete

array(

[20] Fix | Delete

'table' => 'icl_strings',

[21] Fix | Delete

'column' => 'name',

[22] Fix | Delete

'size' => WPML_STRING_TABLE_NAME_CONTEXT_LENGTH,

[23] Fix | Delete

'charset' => 'UTF8',

[24] Fix | Delete

'collation' => $collate ? 'COLLATE utf8_general_ci' : ''

[25] Fix | Delete

[26] Fix | Delete

array(

[27] Fix | Delete

'table' => 'icl_strings',

[28] Fix | Delete

'column' => 'context',

[29] Fix | Delete

'size' => WPML_STRING_TABLE_NAME_CONTEXT_LENGTH,

[30] Fix | Delete

'charset' => 'UTF8',

[31] Fix | Delete

'collation' => $collate ? 'COLLATE utf8_general_ci' : ''

[32] Fix | Delete

[33] Fix | Delete

array(

[34] Fix | Delete

'table' => 'icl_strings',

[35] Fix | Delete

'column' => 'domain_name_context_md5',

[36] Fix | Delete

'size' => 32,

[37] Fix | Delete

'charset' => 'LATIN1',

[38] Fix | Delete

'collation' => $collate ? 'COLLATE latin1_general_ci' : ''

[39] Fix | Delete

[40] Fix | Delete

);

[41] Fix | Delete

[42] Fix | Delete

foreach ( $fields as $setting ) {

[43] Fix | Delete

if ( $wpdb->query( "SHOW TABLES LIKE '{$wpdb->prefix}{$setting['table']}'" ) ) {

[44] Fix | Delete

$sql = sprintf( $sql_template, $setting['table'], $setting['column'], $setting['size'], $setting['charset'], $setting['collation'] );

[45] Fix | Delete

[46] Fix | Delete

if ( $wpdb->query( $sql ) === false ) {

[47] Fix | Delete

throw new Exception( $wpdb->last_error );

[48] Fix | Delete

}

[49] Fix | Delete

}

[50] Fix | Delete

}

[51] Fix | Delete

}

[52] Fix | Delete

[53] Fix | Delete

function upgrade_3_5_1_get_language_charset_and_collation() {

[54] Fix | Delete

[55] Fix | Delete

global $wpdb;

[56] Fix | Delete

[57] Fix | Delete

$data = null;

[58] Fix | Delete

[59] Fix | Delete

$column_data = $wpdb->get_results( "SELECT * FROM INFORMATION_SCHEMA.COLUMNS where TABLE_NAME='{$wpdb->prefix}icl_strings' AND TABLE_SCHEMA='{$wpdb->dbname}' ");

[60] Fix | Delete

foreach ( $column_data as $column ) {

[61] Fix | Delete

if ( 'language' === $column->COLUMN_NAME ) {

[62] Fix | Delete

$data['collation'] = $column->COLLATION_NAME;

[63] Fix | Delete

$data['charset'] = $column->CHARACTER_SET_NAME;

[64] Fix | Delete

}

[65] Fix | Delete

}

[66] Fix | Delete

[67] Fix | Delete

return $data;

[68] Fix | Delete

}

[69] Fix | Delete

[70] Fix | Delete

update_icl_strings_charset_and_collations();

[71] Fix | Delete

[72] Fix | Delete