Edit File by line

<?php

[0] Fix | Delete

/**

[1] Fix | Delete

* @package wpml-core

[2] Fix | Delete

[3] Fix | Delete

[4] Fix | Delete

function update_gettext_context_schema() {

[5] Fix | Delete

[6] Fix | Delete

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

[7] Fix | Delete

[8] Fix | Delete

$columns_definitions = array( );

[9] Fix | Delete

[10] Fix | Delete

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

[11] Fix | Delete

$columns_definitions[ ] = array(

[12] Fix | Delete

'action' => 'ADD',

[13] Fix | Delete

'name' => 'gettext_context',

[14] Fix | Delete

'type' => 'TEXT',

[15] Fix | Delete

'null' => false,

[16] Fix | Delete

'after' => 'status',

[17] Fix | Delete

);

[18] Fix | Delete

}

[19] Fix | Delete

[20] Fix | Delete

$columns_definitions[ ] = array(

[21] Fix | Delete

'action' => 'ADD',

[22] Fix | Delete

'name' => 'domain_name_context_md5',

[23] Fix | Delete

'type' => 'VARCHAR(32)',

[24] Fix | Delete

'charset' => 'LATIN1',

[25] Fix | Delete

'null' => false,

[26] Fix | Delete

'default' => '',

[27] Fix | Delete

'after' => 'gettext_context',

[28] Fix | Delete

);

[29] Fix | Delete

[30] Fix | Delete

if ( icl_alter_table_columns( 'icl_strings', $columns_definitions ) ) {

[31] Fix | Delete

if ( icl_table_index_exists( 'icl_strings', 'context_name' ) ) {

[32] Fix | Delete

if ( icl_drop_table_index( 'icl_strings', 'context_name' ) ) {

[33] Fix | Delete

}

[34] Fix | Delete

}

[35] Fix | Delete

if ( icl_table_index_exists( 'icl_strings', 'context_name_gettext_context' ) ) {

[36] Fix | Delete

if ( icl_drop_table_index( 'icl_strings', 'context_name_gettext_context' ) ) {

[37] Fix | Delete

}

[38] Fix | Delete

}

[39] Fix | Delete

}

[40] Fix | Delete

[41] Fix | Delete

update_domain_name_context( );

[42] Fix | Delete

[43] Fix | Delete

$index_definition = array(

[44] Fix | Delete

'name' => 'uc_domain_name_context_md5',

[45] Fix | Delete

'type' => 'BTREE',

[46] Fix | Delete

'choice' => 'UNIQUE',

[47] Fix | Delete

'columns' => array( 'domain_name_context_md5' ),

[48] Fix | Delete

);

[49] Fix | Delete

icl_create_table_index( 'icl_strings', $index_definition );

[50] Fix | Delete

[51] Fix | Delete

}

[52] Fix | Delete

[53] Fix | Delete

if ( icl_table_column_exists( 'icl_strings', 'gettext_context_md5' ) ) {

[54] Fix | Delete

$columns_definitions = array(

[55] Fix | Delete

array(

[56] Fix | Delete

'action' => 'DROP',

[57] Fix | Delete

'name' => 'gettext_context_md5',

[58] Fix | Delete

)

[59] Fix | Delete

);

[60] Fix | Delete

icl_alter_table_columns( 'icl_strings', $columns_definitions);

[61] Fix | Delete

}

[62] Fix | Delete

[63] Fix | Delete

}

[64] Fix | Delete

[65] Fix | Delete

function update_domain_name_context( ) {

[66] Fix | Delete

[67] Fix | Delete

global $wpdb;

[68] Fix | Delete

[69] Fix | Delete

$results = $wpdb->get_results("SELECT id, name, value, context as domain, gettext_context FROM {$wpdb->prefix}icl_strings WHERE id > 0");

[70] Fix | Delete

[71] Fix | Delete

$domain_name_context_md5_used = array( );

[72] Fix | Delete

$duplicate_count = 0;

[73] Fix | Delete

foreach( $results as $string ) {

[74] Fix | Delete

[75] Fix | Delete

$domain_name_context_md5 = md5( $string->domain . $string->name . $string->gettext_context );

[76] Fix | Delete

while ( in_array( $domain_name_context_md5, $domain_name_context_md5_used ) ) {

[77] Fix | Delete

[78] Fix | Delete

/* We need to handle duplicates because previous versions of WPML didn't strictly

[79] Fix | Delete

* disallow them when handling gettext contexts.

[80] Fix | Delete

* This solution doesn't solve the problem because there is no solution

[81] Fix | Delete

* It just stops any DB errors about duplicate keys.

[82] Fix | Delete

[83] Fix | Delete

[84] Fix | Delete

$duplicate_count++;

[85] Fix | Delete

$domain_name_context_md5 = md5( $string->domain . $string->name . 'duplicate-' . $duplicate_count . '-' . $string->gettext_context );

[86] Fix | Delete

}

[87] Fix | Delete

[88] Fix | Delete

$domain_name_context_md5_used[ ] = $domain_name_context_md5;

[89] Fix | Delete

[90] Fix | Delete

$data = array(

[91] Fix | Delete

'domain_name_context_md5' => $domain_name_context_md5,

[92] Fix | Delete

);

[93] Fix | Delete

$where = array( 'id' => $string->id );

[94] Fix | Delete

$wpdb->update( $wpdb->prefix . 'icl_strings', $data, $where );

[95] Fix | Delete

}

[96] Fix | Delete

}

[97] Fix | Delete

[98] Fix | Delete

update_gettext_context_schema( );

[99] Fix | Delete

[100] Fix | Delete

[101] Fix | Delete