Edit File by line

<?php

[0] Fix | Delete

class SitePress_Setup {

[1] Fix | Delete

static function setup_complete() {

[2] Fix | Delete

global $sitepress;

[3] Fix | Delete

[4] Fix | Delete

return $sitepress->get_setting('setup_complete');

[5] Fix | Delete

}

[6] Fix | Delete

[7] Fix | Delete

static function languages_complete() {

[8] Fix | Delete

return self::active_languages_complete() && self::languages_table_is_complete();

[9] Fix | Delete

}

[10] Fix | Delete

[11] Fix | Delete

private static function active_languages_complete() {

[12] Fix | Delete

static $result = null;

[13] Fix | Delete

[14] Fix | Delete

if ( $result === null ) {

[15] Fix | Delete

global $sitepress;

[16] Fix | Delete

[17] Fix | Delete

$result = $sitepress && 1 < count( $sitepress->get_active_languages() );

[18] Fix | Delete

}

[19] Fix | Delete

[20] Fix | Delete

return $result;

[21] Fix | Delete

}

[22] Fix | Delete

[23] Fix | Delete

/**

[24] Fix | Delete

* @return array

[25] Fix | Delete

[26] Fix | Delete

private static function get_languages_codes() {

[27] Fix | Delete

static $languages_codes = array();

[28] Fix | Delete

if ( ! $languages_codes ) {

[29] Fix | Delete

$languages_codes = icl_get_languages_codes();

[30] Fix | Delete

}

[31] Fix | Delete

[32] Fix | Delete

return $languages_codes;

[33] Fix | Delete

}

[34] Fix | Delete

[35] Fix | Delete

/**

[36] Fix | Delete

* @return array

[37] Fix | Delete

[38] Fix | Delete

private static function get_languages_names() {

[39] Fix | Delete

static $languages_names = array();

[40] Fix | Delete

if ( ! $languages_names ) {

[41] Fix | Delete

$languages_names = icl_get_languages_names();

[42] Fix | Delete

}

[43] Fix | Delete

[44] Fix | Delete

return $languages_names;

[45] Fix | Delete

}

[46] Fix | Delete

[47] Fix | Delete

private static function get_languages_names_count() {

[48] Fix | Delete

return count( self::get_languages_names() );

[49] Fix | Delete

}

[50] Fix | Delete

[51] Fix | Delete

static function get_charset_collate() {

[52] Fix | Delete

static $charset_collate = null;

[53] Fix | Delete

[54] Fix | Delete

if ( $charset_collate == null ) {

[55] Fix | Delete

$charset_collate = '';

[56] Fix | Delete

global $wpdb;

[57] Fix | Delete

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

[58] Fix | Delete

$schema = wpml_get_upgrade_schema();

[59] Fix | Delete

$charset = $schema->get_default_charset();

[60] Fix | Delete

$collate = $schema->get_default_collate();

[61] Fix | Delete

[62] Fix | Delete

if ( $charset ) {

[63] Fix | Delete

$charset_collate = "DEFAULT CHARACTER SET $charset";

[64] Fix | Delete

}

[65] Fix | Delete

[66] Fix | Delete

if ( $collate ) {

[67] Fix | Delete

$charset_collate .= " COLLATE $collate";

[68] Fix | Delete

}

[69] Fix | Delete

}

[70] Fix | Delete

}

[71] Fix | Delete

[72] Fix | Delete

return $charset_collate;

[73] Fix | Delete

}

[74] Fix | Delete

[75] Fix | Delete

private static function create_languages() {

[76] Fix | Delete

$sql = "( `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,

[77] Fix | Delete

`code` VARCHAR( 7 ) NOT NULL ,

[78] Fix | Delete

`english_name` VARCHAR( 128 ) NOT NULL ,

[79] Fix | Delete

`major` TINYINT NOT NULL DEFAULT '0',

[80] Fix | Delete

`active` TINYINT NOT NULL ,

[81] Fix | Delete

`default_locale` VARCHAR( 35 ),

[82] Fix | Delete

`tag` VARCHAR( 35 ),

[83] Fix | Delete

`encode_url` TINYINT( 1 ) NOT NULL DEFAULT 0,

[84] Fix | Delete

UNIQUE KEY `code` (`code`),

[85] Fix | Delete

UNIQUE KEY `english_name` (`english_name`)

[86] Fix | Delete

) ";

[87] Fix | Delete

[88] Fix | Delete

return self::create_table ( 'icl_languages', $sql );

[89] Fix | Delete

}

[90] Fix | Delete

[91] Fix | Delete

static function languages_table_is_complete() {

[92] Fix | Delete

global $wpdb;

[93] Fix | Delete

$table_name = $wpdb->prefix . 'icl_languages';

[94] Fix | Delete

$sql = "SELECT count(id) FROM {$table_name}";

[95] Fix | Delete

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

[96] Fix | Delete

[97] Fix | Delete

$languages_names_count = self::get_languages_names_count();

[98] Fix | Delete

[99] Fix | Delete

if( $records_count < $languages_names_count) return false;

[100] Fix | Delete

[101] Fix | Delete

$languages_codes = self::get_languages_codes();

[102] Fix | Delete

$language_pairs = self::get_language_translations();

[103] Fix | Delete

[104] Fix | Delete

foreach ( self::get_languages_names() as $lang => $val ) {

[105] Fix | Delete

foreach ( $val['tr'] as $k => $display ) {

[106] Fix | Delete

$k = self::fix_language_name( $k );

[107] Fix | Delete

[108] Fix | Delete

$code = $languages_codes[ $lang ];

[109] Fix | Delete

if ( ! array_key_exists( $code, $language_pairs ) || ! in_array( $languages_codes[ $k ], $language_pairs[ $code ], true ) ) {

[110] Fix | Delete

return false;

[111] Fix | Delete

}

[112] Fix | Delete

}

[113] Fix | Delete

}

[114] Fix | Delete

return true;

[115] Fix | Delete

}

[116] Fix | Delete

[117] Fix | Delete

/**

[118] Fix | Delete

* @param string $language_name

[119] Fix | Delete

[120] Fix | Delete

* @return string

[121] Fix | Delete

[122] Fix | Delete

protected static function fix_language_name( $language_name ) {

[123] Fix | Delete

if ( strpos( $language_name, 'Norwegian Bokm' ) === 0 ) {

[124] Fix | Delete

$language_name = 'Norwegian Bokmål';

[125] Fix | Delete

}

[126] Fix | Delete

[127] Fix | Delete

return $language_name;

[128] Fix | Delete

}

[129] Fix | Delete

[130] Fix | Delete

private static function get_language_translations() {

[131] Fix | Delete

$result = array();

[132] Fix | Delete

[133] Fix | Delete

global $wpdb;

[134] Fix | Delete

$table_name = $wpdb->prefix . 'icl_languages_translations';

[135] Fix | Delete

$sql = "SELECT language_code, display_language_code FROM {$table_name}";

[136] Fix | Delete

$rowset = $wpdb->get_results( $sql );

[137] Fix | Delete

[138] Fix | Delete

if ( is_array( $rowset ) ) {

[139] Fix | Delete

foreach ( $rowset as $row ) {

[140] Fix | Delete

$result[ $row->language_code ][] = $row->display_language_code;

[141] Fix | Delete

}

[142] Fix | Delete

}

[143] Fix | Delete

[144] Fix | Delete

return $result;

[145] Fix | Delete

}

[146] Fix | Delete

[147] Fix | Delete

static function fill_languages() {

[148] Fix | Delete

global $wpdb, $sitepress;

[149] Fix | Delete

[150] Fix | Delete

$languages_codes = icl_get_languages_codes();

[151] Fix | Delete

$lang_locales = icl_get_languages_locales();

[152] Fix | Delete

[153] Fix | Delete

$table_name = $wpdb->prefix . 'icl_languages';

[154] Fix | Delete

if ( !self::create_languages() ) {

[155] Fix | Delete

return false;

[156] Fix | Delete

}

[157] Fix | Delete

[158] Fix | Delete

if ( !self::languages_table_is_complete() ) {

[159] Fix | Delete

//First truncate the table

[160] Fix | Delete

$active_languages = ( $sitepress !== null

[161] Fix | Delete

&& $sitepress->is_setup_complete() ) ? $sitepress->get_active_languages() : array();

[162] Fix | Delete

[163] Fix | Delete

$wpdb->hide_errors();

[164] Fix | Delete

[165] Fix | Delete

$sql = "TRUNCATE " . $table_name;

[166] Fix | Delete

[167] Fix | Delete

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

[168] Fix | Delete

[169] Fix | Delete

$wpdb->show_errors();

[170] Fix | Delete

[171] Fix | Delete

if ( false !== $truncate_result ) {

[172] Fix | Delete

foreach ( self::get_languages_names() as $key => $val ) {

[173] Fix | Delete

$language_code = $languages_codes[ $key ];

[174] Fix | Delete

$default_locale = isset( $lang_locales[ $language_code ] ) ? $lang_locales[ $language_code ] : '';

[175] Fix | Delete

[176] Fix | Delete

$language_tag = strtolower( str_replace( '_', '-', $language_code ) );

[177] Fix | Delete

[178] Fix | Delete

$args = array(

[179] Fix | Delete

'english_name' => $key,

[180] Fix | Delete

'code' => $language_code,

[181] Fix | Delete

'major' => $val[ 'major' ],

[182] Fix | Delete

'active' => isset($active_languages[ $language_code ]) ? 1 : 0,

[183] Fix | Delete

'default_locale' => $default_locale,

[184] Fix | Delete

'tag' => $language_tag,

[185] Fix | Delete

);

[186] Fix | Delete

if ( $wpdb->insert( $table_name, $args ) === false) {

[187] Fix | Delete

return false;

[188] Fix | Delete

}

[189] Fix | Delete

}

[190] Fix | Delete

}

[191] Fix | Delete

}

[192] Fix | Delete

[193] Fix | Delete

return true;

[194] Fix | Delete

}

[195] Fix | Delete

[196] Fix | Delete

private static function create_languages_translations() {

[197] Fix | Delete

[198] Fix | Delete

$sql = "(`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,

[199] Fix | Delete

`language_code` VARCHAR( 7 ) NOT NULL ,

[200] Fix | Delete

`display_language_code` VARCHAR( 7 ) NOT NULL ,

[201] Fix | Delete

`name` VARCHAR( 255 ) NOT NULL,

[202] Fix | Delete

UNIQUE(`language_code`, `display_language_code`)

[203] Fix | Delete

)";

[204] Fix | Delete

[205] Fix | Delete

return self::create_table ( 'icl_languages_translations', $sql );

[206] Fix | Delete

}

[207] Fix | Delete

[208] Fix | Delete

static function fill_languages_translations() {

[209] Fix | Delete

global $wpdb;

[210] Fix | Delete

[211] Fix | Delete

$languages_codes = icl_get_languages_codes();

[212] Fix | Delete

[213] Fix | Delete

$table_name = $wpdb->prefix . 'icl_languages_translations';

[214] Fix | Delete

[215] Fix | Delete

if ( !self::create_languages_translations() ) {

[216] Fix | Delete

return false;

[217] Fix | Delete

}

[218] Fix | Delete

[219] Fix | Delete

if ( !self::languages_table_is_complete() ) {

[220] Fix | Delete

[221] Fix | Delete

//First truncate the table

[222] Fix | Delete

$wpdb->hide_errors();

[223] Fix | Delete

[224] Fix | Delete

$sql = "TRUNCATE " . $table_name;

[225] Fix | Delete

[226] Fix | Delete

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

[227] Fix | Delete

[228] Fix | Delete

$wpdb->show_errors();

[229] Fix | Delete

[230] Fix | Delete

if ( false !== $truncate_result ) {

[231] Fix | Delete

$index = 1;

[232] Fix | Delete

[233] Fix | Delete

$insert_sql_parts = array();

[234] Fix | Delete

$languages = self::get_languages_names();

[235] Fix | Delete

if($languages) {

[236] Fix | Delete

foreach ( $languages as $lang => $val ) {

[237] Fix | Delete

foreach ( $val[ 'tr' ] as $k => $display ) {

[238] Fix | Delete

$k = self::fix_language_name( $k );

[239] Fix | Delete

if ( ! trim( $display ) ) {

[240] Fix | Delete

$display = $lang;

[241] Fix | Delete

}

[242] Fix | Delete

[243] Fix | Delete

$inserts_language_data = array(

[244] Fix | Delete

'id' => $index,

[245] Fix | Delete

'language_code' => $languages_codes[ $lang ],

[246] Fix | Delete

'display_language_code' => $languages_codes[ $k ],

[247] Fix | Delete

'name' => $display

[248] Fix | Delete

);

[249] Fix | Delete

[250] Fix | Delete

$insert_sql_parts[] = $wpdb->prepare('(%d, %s, %s, %s)', $inserts_language_data);

[251] Fix | Delete

$index ++;

[252] Fix | Delete

}

[253] Fix | Delete

}

[254] Fix | Delete

[255] Fix | Delete

$insert_sql = implode(",\n", $insert_sql_parts);

[256] Fix | Delete

$insert_sql = "INSERT INTO {$table_name} (id, language_code, display_language_code, name) VALUES "

[257] Fix | Delete

. $insert_sql;

[258] Fix | Delete

[259] Fix | Delete

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

[260] Fix | Delete

return false;

[261] Fix | Delete

}

[262] Fix | Delete

}

[263] Fix | Delete

}

[264] Fix | Delete

}

[265] Fix | Delete

[266] Fix | Delete

return true;

[267] Fix | Delete

}

[268] Fix | Delete

[269] Fix | Delete

private static function create_table($name, $table_sql){

[270] Fix | Delete

global $wpdb;

[271] Fix | Delete

[272] Fix | Delete

$table_name = $wpdb->prefix . $name;

[273] Fix | Delete

[274] Fix | Delete

return 0 === strcasecmp( $wpdb->get_var( "SHOW TABLES LIKE '{$table_name}'" ), $table_name )

[275] Fix | Delete

|| ( $wpdb->query(

[276] Fix | Delete

sprintf("CREATE TABLE IF NOT EXISTS `%s` ", $table_name )

[277] Fix | Delete

. $table_sql . " "

[278] Fix | Delete

. self::get_charset_collate()

[279] Fix | Delete

) !== false );

[280] Fix | Delete

}

[281] Fix | Delete

[282] Fix | Delete

private static function create_flags(){

[283] Fix | Delete

[284] Fix | Delete

$sql = "(`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,

[285] Fix | Delete

`lang_code` VARCHAR( 10 ) NOT NULL ,

[286] Fix | Delete

`flag` VARCHAR( 32 ) NOT NULL ,

[287] Fix | Delete

`from_template` TINYINT NOT NULL DEFAULT '0',

[288] Fix | Delete

UNIQUE (`lang_code`)

[289] Fix | Delete

)";

[290] Fix | Delete

[291] Fix | Delete

return self::create_table('icl_flags', $sql);

[292] Fix | Delete

}

[293] Fix | Delete

[294] Fix | Delete

public static function fill_flags() {

[295] Fix | Delete

global $wpdb;

[296] Fix | Delete

[297] Fix | Delete

if ( self::create_flags () === false ) {

[298] Fix | Delete

return;

[299] Fix | Delete

}

[300] Fix | Delete

[301] Fix | Delete

$codes = $wpdb->get_col ( "SELECT code FROM {$wpdb->prefix}icl_languages" );

[302] Fix | Delete

foreach ( $codes as $code ) {

[303] Fix | Delete

if ( !$code || $wpdb->get_var (

[304] Fix | Delete

$wpdb->prepare (

[305] Fix | Delete

"SELECT lang_code

[306] Fix | Delete

FROM {$wpdb->prefix}icl_flags

[307] Fix | Delete

WHERE lang_code = %s ",

[308] Fix | Delete

$code

[309] Fix | Delete

)

[310] Fix | Delete

)

[311] Fix | Delete

) {

[312] Fix | Delete

continue;

[313] Fix | Delete

}

[314] Fix | Delete

$code_parts = explode( '-', $code );

[315] Fix | Delete

[316] Fix | Delete

$file = 'nil.png';

[317] Fix | Delete

[318] Fix | Delete

if ( file_exists( WPML_PLUGIN_PATH . '/res/flags/' . $code . '.png' ) ) {

[319] Fix | Delete

$file = $code . '.png';

[320] Fix | Delete

} elseif ( file_exists( WPML_PLUGIN_PATH . '/res/flags/' . $code_parts[0] . '.png' ) ) {

[321] Fix | Delete

$file = $code_parts[0] . '.png';

[322] Fix | Delete

}

[323] Fix | Delete

[324] Fix | Delete

$wpdb->insert (

[325] Fix | Delete

$wpdb->prefix . 'icl_flags',

[326] Fix | Delete

array( 'lang_code' => $code, 'flag' => $file, 'from_template' => 0 )

[327] Fix | Delete

);

[328] Fix | Delete

}

[329] Fix | Delete

}

[330] Fix | Delete

[331] Fix | Delete

public static function insert_default_category( $lang_code ) {

[332] Fix | Delete

global $sitepress;

[333] Fix | Delete

[334] Fix | Delete

$default_language = $sitepress->get_default_language();

[335] Fix | Delete

if ( $lang_code === $default_language ) {

[336] Fix | Delete

return;

[337] Fix | Delete

}

[338] Fix | Delete

[339] Fix | Delete

// Get default categories.

[340] Fix | Delete

$default_categories = $sitepress->get_setting ( 'default_categories', array() );

[341] Fix | Delete

if ( isset( $default_categories[ $lang_code ] ) ) {

[342] Fix | Delete

return;

[343] Fix | Delete

}

[344] Fix | Delete

[345] Fix | Delete

$sitepress->switch_locale ( $lang_code );

[346] Fix | Delete

$tr_cat = __ ( 'Uncategorized', 'sitepress' );

[347] Fix | Delete

$tr_cat = $tr_cat === 'Uncategorized' && $lang_code !== 'en' ? 'Uncategorized @' . $lang_code : $tr_cat;

[348] Fix | Delete

$tr_term = term_exists ( $tr_cat, 'category' );

[349] Fix | Delete

$sitepress->switch_locale ();

[350] Fix | Delete

[351] Fix | Delete

// check if the term already exists

[352] Fix | Delete

if ( $tr_term !== 0 && $tr_term !== null ) {

[353] Fix | Delete

$tmp = get_term ( $tr_term[ 'term_taxonomy_id' ], 'category', ARRAY_A );

[354] Fix | Delete

} else {

[355] Fix | Delete

$tmp = wp_insert_term ( $tr_cat, 'category' );

[356] Fix | Delete

}

[357] Fix | Delete

[358] Fix | Delete

// add it to settings['default_categories']

[359] Fix | Delete

$default_categories[ $lang_code ] = $tmp[ 'term_taxonomy_id' ];

[360] Fix | Delete

[361] Fix | Delete

$sitepress->set_default_categories ( $default_categories );

[362] Fix | Delete

[363] Fix | Delete

//update translations table

[364] Fix | Delete

$default_category_trid = $sitepress->get_element_trid (

[365] Fix | Delete

get_option('default_category'),

[366] Fix | Delete

'tax_category'

[367] Fix | Delete

);

[368] Fix | Delete

$sitepress->set_element_language_details (

[369] Fix | Delete

$tmp[ 'term_taxonomy_id' ],

[370] Fix | Delete

'tax_category',

[371] Fix | Delete

$default_category_trid,

[372] Fix | Delete

$lang_code,

[373] Fix | Delete

$default_language

[374] Fix | Delete

);

[375] Fix | Delete

}

[376] Fix | Delete

}

[377] Fix | Delete

[378] Fix | Delete