<?php

[0] Fix | Delete

[1] Fix | Delete

$wp_api = new WPML_WP_API();

[2] Fix | Delete

[3] Fix | Delete

if (!defined('ICL_SITEPRESS_DEV_VERSION') && ( $wp_api->version_compare_naked( get_option( 'icl_sitepress_version' ), ICL_SITEPRESS_VERSION, '=' ) || ( isset( $_REQUEST[ 'action' ] ) && $_REQUEST[ 'action' ] == 'error_scrape' ) || ! isset( $wpdb ) )) {

[4] Fix | Delete

return;

[5] Fix | Delete

}

[6] Fix | Delete

[7] Fix | Delete

[8] Fix | Delete

if ( get_option( 'icl_sitepress_version' ) && version_compare( get_option( 'icl_sitepress_version' ), '1.7.0', '<' ) ) {

[9] Fix | Delete

define( 'WPML_UPGRADE_NOT_POSSIBLE', true );

[10] Fix | Delete

add_action( 'admin_notices', 'icl_plugin_too_old' );

[11] Fix | Delete

[12] Fix | Delete

return;

[13] Fix | Delete

}

[14] Fix | Delete

[15] Fix | Delete

add_action('plugins_loaded', 'icl_plugin_upgrade' , 1);

[16] Fix | Delete

[17] Fix | Delete

[18] Fix | Delete

function icl_plugin_upgrade(){

[19] Fix | Delete

global $wpdb;

[20] Fix | Delete

[21] Fix | Delete

$iclsettings = get_option('icl_sitepress_settings');

[22] Fix | Delete

[23] Fix | Delete

require_once WPML_PLUGIN_PATH . '/inc/cache.php';

[24] Fix | Delete

icl_cache_clear('locale_cache_class');

[25] Fix | Delete

icl_cache_clear('flags_cache_class');

[26] Fix | Delete

icl_cache_clear('language_name_cache_class');

[27] Fix | Delete

[28] Fix | Delete

if(get_option('icl_sitepress_version') && version_compare(get_option('icl_sitepress_version'), '1.7.2', '<')){

[29] Fix | Delete

$wpdb->update($wpdb->prefix.'icl_flags', array('flag'=>'ku.png'), array('lang_code'=>'ku'));

[30] Fix | Delete

$wpdb->update($wpdb->prefix.'icl_languages_translations', array('name'=>'Magyar'), array('language_code'=>'hu', 'display_language_code'=>'hu'));

[31] Fix | Delete

$wpdb->update($wpdb->prefix.'icl_languages_translations', array('name'=>'Hrvatski'), array('language_code'=>'hr', 'display_language_code'=>'hr'));

[32] Fix | Delete

$wpdb->update($wpdb->prefix.'icl_languages_translations', array('name'=>'فارسی'), array('language_code'=>'fa', 'display_language_code'=>'fa'));

[33] Fix | Delete

}

[34] Fix | Delete

[35] Fix | Delete

if(get_option('icl_sitepress_version') && version_compare(get_option('icl_sitepress_version'), '1.7.3', '<')){

[36] Fix | Delete

$wpdb->update($wpdb->prefix.'icl_languages_translations', array('name'=>'پارسی'), array('language_code'=>'fa', 'display_language_code'=>'fa'));

[37] Fix | Delete

}

[38] Fix | Delete

[39] Fix | Delete

if(get_option('icl_sitepress_version') && version_compare(get_option('icl_sitepress_version'), '1.7.7', '<')){

[40] Fix | Delete

if(!isset($iclsettings['promote_wpml'])){

[41] Fix | Delete

$iclsettings['promote_wpml'] = 0;

[42] Fix | Delete

update_option('icl_sitepress_settings',$iclsettings);

[43] Fix | Delete

}

[44] Fix | Delete

if(!isset($iclsettings['auto_adjust_ids'])){

[45] Fix | Delete

$iclsettings['auto_adjust_ids'] = 0;

[46] Fix | Delete

update_option('icl_sitepress_settings',$iclsettings);

[47] Fix | Delete

}

[48] Fix | Delete

[49] Fix | Delete

$wpdb->query("UPDATE {$wpdb->prefix}icl_translations SET element_type='tax_post_tag' WHERE element_type='tag'"); // @since 3.1.5 - mysql_* function deprecated in php 5.5+

[50] Fix | Delete

$wpdb->query("UPDATE {$wpdb->prefix}icl_translations SET element_type='tax_category' WHERE element_type='category'");

[51] Fix | Delete

}

[52] Fix | Delete

[53] Fix | Delete

if(get_option('icl_sitepress_version') && version_compare(get_option('icl_sitepress_version'), '1.7.8', '<')){

[54] Fix | Delete

$res = $wpdb->get_results("SELECT ID, post_type FROM {$wpdb->posts}");

[55] Fix | Delete

$post_types = array();

[56] Fix | Delete

foreach($res as $row){

[57] Fix | Delete

$post_types[$row->post_type][] = $row->ID;

[58] Fix | Delete

}

[59] Fix | Delete

foreach($post_types as $type=>$ids){

[60] Fix | Delete

if(!empty($ids)){

[61] Fix | Delete

$q = "UPDATE {$wpdb->prefix}icl_translations SET element_type=%s WHERE element_type='post' AND element_id IN(".join(',',$ids).")";

[62] Fix | Delete

$q_prepared = $wpdb->prepare($q, 'post_'.$type);

[63] Fix | Delete

$wpdb->query($q_prepared); // @since 3.1.5 - mysql_* function deprecated in php 5.5+

[64] Fix | Delete

}

[65] Fix | Delete

}

[66] Fix | Delete

[67] Fix | Delete

// fix categories & tags in icl_translations

[68] Fix | Delete

$res = $wpdb->get_results("SELECT term_taxonomy_id, taxonomy FROM {$wpdb->term_taxonomy}");

[69] Fix | Delete

foreach($res as $row) {

[70] Fix | Delete

$icltr = $wpdb->get_row(

[71] Fix | Delete

$wpdb->prepare("SELECT translation_id, element_type FROM {$wpdb->prefix}icl_translations WHERE element_id=%d AND element_type LIKE %s",

[72] Fix | Delete

array( $row->term_taxonomy_id, wpml_like_escape('tax_') . '%' ))

[73] Fix | Delete

);

[74] Fix | Delete

if('tax_' . $row->taxonomy != $icltr->element_type){

[75] Fix | Delete

$wpdb->update($wpdb->prefix . 'icl_translations', array('element_type'=>'tax_'.$row->taxonomy), array('translation_id'=>$icltr->translation_id));

[76] Fix | Delete

}

[77] Fix | Delete

}

[78] Fix | Delete

}

[79] Fix | Delete

[80] Fix | Delete

if(get_option('icl_sitepress_version') && version_compare(get_option('icl_sitepress_version'), '2.0.0', '<')){

[81] Fix | Delete

include_once WPML_PLUGIN_PATH . '/inc/upgrade-functions/upgrade-2.0.0.php';

[82] Fix | Delete

[83] Fix | Delete

if(empty($iclsettings['migrated_2_0_0'])){

[84] Fix | Delete

define('ICL_MULTI_STEP_UPGRADE', true);

[85] Fix | Delete

return; // GET OUT AND DO NOT SET THE NEW VERSION

[86] Fix | Delete

}

[87] Fix | Delete

}

[88] Fix | Delete

[89] Fix | Delete

if(get_option('icl_sitepress_version') && version_compare(get_option('icl_sitepress_version'), '2.0.4', '<')){

[90] Fix | Delete

$sql = "ALTER TABLE {$wpdb->prefix}icl_translation_status ADD COLUMN `_prevstate` longtext";

[91] Fix | Delete

$wpdb->query($sql);

[92] Fix | Delete

}

[93] Fix | Delete

[94] Fix | Delete

$versions = array(

[95] Fix | Delete

'2.0.5',

[96] Fix | Delete

'2.2.2',

[97] Fix | Delete

'2.3.0',

[98] Fix | Delete

'2.3.1',

[99] Fix | Delete

'2.3.3',

[100] Fix | Delete

'2.4.0',

[101] Fix | Delete

'2.5.0',

[102] Fix | Delete

'2.5.2',

[103] Fix | Delete

'2.6.0',

[104] Fix | Delete

'2.7' ,

[105] Fix | Delete

'2.9' ,

[106] Fix | Delete

'2.9.3',

[107] Fix | Delete

'3.1' ,

[108] Fix | Delete

'3.1.5',

[109] Fix | Delete

'3.1.8',

[110] Fix | Delete

'3.1.9.5',

[111] Fix | Delete

'3.2',

[112] Fix | Delete

'3.2.3',

[113] Fix | Delete

'3.3',

[114] Fix | Delete

'3.3.7',

[115] Fix | Delete

'3.5.1'

[116] Fix | Delete

);

[117] Fix | Delete

[118] Fix | Delete

foreach($versions as $version) {

[119] Fix | Delete

icl_upgrade_version( $version );

[120] Fix | Delete

}

[121] Fix | Delete

[122] Fix | Delete

//Forcing upgrade logic when ICL_SITEPRESS_DEV_VERSION is defined

[123] Fix | Delete

//This allow to run the logic between different alpha/beta/RC versions

[124] Fix | Delete

//since we are now storing only the formal version in the options

[125] Fix | Delete

if(defined('ICL_SITEPRESS_DEV_VERSION')) {

[126] Fix | Delete

icl_upgrade_version(ICL_SITEPRESS_DEV_VERSION, true);

[127] Fix | Delete

}

[128] Fix | Delete

[129] Fix | Delete

if(version_compare(get_option('icl_sitepress_version'), ICL_SITEPRESS_VERSION, '<')){

[130] Fix | Delete

update_option('icl_sitepress_version', ICL_SITEPRESS_VERSION);

[131] Fix | Delete

}

[132] Fix | Delete

[133] Fix | Delete

do_action( 'wpml_upgraded', ICL_SITEPRESS_VERSION );

[134] Fix | Delete

}

[135] Fix | Delete

[136] Fix | Delete

function icl_upgrade_version($version, $force = false){

[137] Fix | Delete

global $wpdb, $sitepress_settings, $sitepress, $iclsettings;

[138] Fix | Delete

[139] Fix | Delete

if(!$force && defined('WPML_FORCE_UPDATES')) {

[140] Fix | Delete

$force = WPML_FORCE_UPDATES;

[141] Fix | Delete

}

[142] Fix | Delete

[143] Fix | Delete

if($force || (get_option('icl_sitepress_version') && version_compare(get_option('icl_sitepress_version'), $version, '<' ))){

[144] Fix | Delete

$upg_file = WPML_PLUGIN_PATH . '/inc/upgrade-functions/upgrade-' . $version . '.php';

[145] Fix | Delete

if(file_exists($upg_file) && is_readable($upg_file)){

[146] Fix | Delete

if(!defined('WPML_DOING_UPGRADE')){

[147] Fix | Delete

define('WPML_DOING_UPGRADE', true);

[148] Fix | Delete

}

[149] Fix | Delete

include_once $upg_file;

[150] Fix | Delete

}

[151] Fix | Delete

}

[152] Fix | Delete

}

[153] Fix | Delete

[154] Fix | Delete

function icl_plugin_too_old(){

[155] Fix | Delete

?>

[156] Fix | Delete

<div class="error message">

[157] Fix | Delete

<p><?php

[158] Fix | Delete

printf(__("<strong>WPML notice:</strong> Upgrades to this version are only supported from versions %s and above. To upgrade from version %s, first, download <a%s>2.0.4</a>, do the DB upgrade and then go to this version.", 'sitepress'),

[159] Fix | Delete

'1.7.0', get_option('icl_sitepress_version'), ' href="http://downloads.wordpress.org/plugin/sitepress-multilingual-cms.2.0.4.zip"'); ?></p>

[160] Fix | Delete

</div>

[161] Fix | Delete

<?php

[162] Fix | Delete

[163] Fix | Delete

}

[164] Fix | Delete

[165] Fix | Delete

function icl_table_column_exists( $table_name, $column_name ) {

[166] Fix | Delete

global $wpdb;

[167] Fix | Delete

[168] Fix | Delete

$query = "

[169] Fix | Delete

SELECT count(*) FROM information_schema.COLUMNS

[170] Fix | Delete

WHERE COLUMN_NAME = %s AND TABLE_NAME = %s AND TABLE_SCHEMA = %s

[171] Fix | Delete

";

[172] Fix | Delete

$args = array( $column_name, $wpdb->prefix . $table_name, DB_NAME );

[173] Fix | Delete

$sql = $wpdb->prepare( $query, $args );

[174] Fix | Delete

$column_exists = $wpdb->get_var( $sql );

[175] Fix | Delete

[176] Fix | Delete

return (bool) $column_exists;

[177] Fix | Delete

}

[178] Fix | Delete

[179] Fix | Delete

function icl_table_index_exists( $table_name, $index_name ) {

[180] Fix | Delete

global $wpdb;

[181] Fix | Delete

[182] Fix | Delete

$query = "

[183] Fix | Delete

SELECT count(*) FROM information_schema.STATISTICS

[184] Fix | Delete

WHERE INDEX_NAME = %s AND TABLE_NAME = %s AND TABLE_SCHEMA = %s;

[185] Fix | Delete

";

[186] Fix | Delete

$args = array( $index_name, $wpdb->prefix . $table_name, DB_NAME );

[187] Fix | Delete

$sql = $wpdb->prepare( $query, $args );

[188] Fix | Delete

$column_exists = $wpdb->get_var( $sql );

[189] Fix | Delete

[190] Fix | Delete

return (bool) $column_exists;

[191] Fix | Delete

}

[192] Fix | Delete

[193] Fix | Delete

function icl_alter_table_columns( $table_name, $column_definitions ) {

[194] Fix | Delete

global $wpdb;

[195] Fix | Delete

[196] Fix | Delete

$result = false;

[197] Fix | Delete

[198] Fix | Delete

if ( ! is_array( $column_definitions ) ) {

[199] Fix | Delete

$column_definitions = array( $column_definitions );

[200] Fix | Delete

}

[201] Fix | Delete

[202] Fix | Delete

$query = "ALTER TABLE `" . $wpdb->prefix . $table_name . "` ";

[203] Fix | Delete

$args = array();

[204] Fix | Delete

[205] Fix | Delete

$counter = 0;

[206] Fix | Delete

[207] Fix | Delete

$query_parts = array();

[208] Fix | Delete

foreach ( $column_definitions as $column_definition ) {

[209] Fix | Delete

[210] Fix | Delete

if ( isset( $column_definition[ 'action' ] ) && $column_definition[ 'action' ] == 'ADD' ) {

[211] Fix | Delete

$required_keys = array(

[212] Fix | Delete

'action',

[213] Fix | Delete

'name',

[214] Fix | Delete

'type',

[215] Fix | Delete

);

[216] Fix | Delete

} else {

[217] Fix | Delete

$required_keys = array(

[218] Fix | Delete

'action',

[219] Fix | Delete

'name',

[220] Fix | Delete

);

[221] Fix | Delete

}

[222] Fix | Delete

[223] Fix | Delete

if ( icl_array_has_required_keys( $column_definition, $required_keys ) ) {

[224] Fix | Delete

[225] Fix | Delete

if ( $counter > 0 ) {

[226] Fix | Delete

$query_parts[ ] = ",";

[227] Fix | Delete

}

[228] Fix | Delete

$query_parts[ ] = $column_definition[ 'action' ];

[229] Fix | Delete

$query_parts[ ] = "`" . $column_definition[ 'name' ] . "`";

[230] Fix | Delete

if ( isset( $column_definition[ 'type' ] ) ) {

[231] Fix | Delete

$query_parts[ ] = $column_definition[ 'type' ];

[232] Fix | Delete

}

[233] Fix | Delete

if ( isset( $column_definition[ 'charset' ] ) ) {

[234] Fix | Delete

$query_parts[ ] = 'CHARACTER SET ' . $column_definition[ 'charset' ];

[235] Fix | Delete

}

[236] Fix | Delete

if ( isset( $column_definition[ 'null' ] ) ) {

[237] Fix | Delete

$query_parts[ ] = $column_definition[ 'null' ] ? 'NULL' : 'NOT NULL';

[238] Fix | Delete

}

[239] Fix | Delete

if ( isset( $column_definition[ 'default' ] ) ) {

[240] Fix | Delete

$query_parts[ ] = 'DEFAULT %s';

[241] Fix | Delete

$args[ ] = $column_definition[ 'default' ];

[242] Fix | Delete

}

[243] Fix | Delete

if ( isset( $column_definition[ 'after' ] ) ) {

[244] Fix | Delete

$query_parts[ ] = 'AFTER `' . $column_definition[ 'after' ] . '`';

[245] Fix | Delete

}

[246] Fix | Delete

$counter ++;

[247] Fix | Delete

} else {

[248] Fix | Delete

$args = array();

[249] Fix | Delete

break;

[250] Fix | Delete

}

[251] Fix | Delete

}

[252] Fix | Delete

[253] Fix | Delete

if ( $query_parts ) {

[254] Fix | Delete

$query .= implode( ' ', $query_parts );

[255] Fix | Delete

if ( sizeof( $args ) > 0 ) {

[256] Fix | Delete

$sql = $wpdb->prepare( $query, $args );

[257] Fix | Delete

} else {

[258] Fix | Delete

$sql = $query;

[259] Fix | Delete

}

[260] Fix | Delete

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

[261] Fix | Delete

}

[262] Fix | Delete

[263] Fix | Delete

return $result;

[264] Fix | Delete

}

[265] Fix | Delete

[266] Fix | Delete

function icl_drop_table_index( $table_name, $index_name ) {

[267] Fix | Delete

global $wpdb;

[268] Fix | Delete

[269] Fix | Delete

$query = "ALTER TABLE `" . $wpdb->prefix . $table_name . "` ";

[270] Fix | Delete

$query .= "DROP INDEX `" . $index_name . "`;";

[271] Fix | Delete

[272] Fix | Delete

return $wpdb->query( $query );

[273] Fix | Delete

}

[274] Fix | Delete

[275] Fix | Delete

function icl_create_table_index( $table_name, $index_definition ) {

[276] Fix | Delete

global $wpdb;

[277] Fix | Delete

[278] Fix | Delete

$result = false;

[279] Fix | Delete

[280] Fix | Delete

$required_keys = array(

[281] Fix | Delete

'name',

[282] Fix | Delete

'columns',

[283] Fix | Delete

);

[284] Fix | Delete

[285] Fix | Delete

if ( icl_array_has_required_keys( $index_definition, $required_keys ) && $index_definition[ 'columns' ] ) {

[286] Fix | Delete

[287] Fix | Delete

$query = "ALTER TABLE `" . $wpdb->prefix . $table_name . "` ";

[288] Fix | Delete

$query .= "ADD ";

[289] Fix | Delete

[290] Fix | Delete

if ( isset( $index_definition[ 'choice' ] ) ) {

[291] Fix | Delete

$query .= $index_definition[ 'choice' ] . " ";

[292] Fix | Delete

}

[293] Fix | Delete

[294] Fix | Delete

$query .= "`" . $index_definition[ 'name' ] . "` ";

[295] Fix | Delete

[296] Fix | Delete

$query .= '(`' . implode( '`, `', $index_definition[ 'columns' ] ) . '`) ';

[297] Fix | Delete

[298] Fix | Delete

if ( isset( $index_definition[ 'type' ] ) ) {

[299] Fix | Delete

$query .= 'USING ' . $index_definition[ 'type' ] . " ";

[300] Fix | Delete

}

[301] Fix | Delete

[302] Fix | Delete

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

[303] Fix | Delete

}

[304] Fix | Delete

[305] Fix | Delete

return $result;

[306] Fix | Delete

}

[307] Fix | Delete

[308] Fix | Delete

/**

[309] Fix | Delete

* @param $array

[310] Fix | Delete

* @param $required_keys

[311] Fix | Delete

*

[312] Fix | Delete

* @return bool

[313] Fix | Delete

*/

[314] Fix | Delete

function icl_array_has_required_keys( $array, $required_keys ) {

[315] Fix | Delete

return count( array_intersect_key( array_flip( $required_keys ), $array ) ) === count( $required_keys );

[316] Fix | Delete

}

[317] Fix | Delete