Файловый менеджер

Файловый менеджер - Редактировать - /var/www/xthruster/html/wp-content/plugins/sitepress-multilingual-cms/inc/setup/sitepress-setup.class.php

Назад
<?php class SitePress_Setup { static function setup_complete() { global $sitepress; return $sitepress->get_setting( 'setup_complete' ); } static function languages_complete() { return self::active_languages_complete() && self::languages_table_is_complete(); } private static function active_languages_complete() { static $result = null; if ( $result === null ) { global $sitepress; $result = $sitepress && 1 < count( $sitepress->get_active_languages() ); } return $result; } /** * @return array / private static function get_languages_codes() { static $languages_codes = array(); if ( ! $languages_codes ) { $languages_codes = icl_get_languages_codes(); } return $languages_codes; } /* * @return array / private static function get_languages_names() { static $languages_names = array(); if ( ! $languages_names ) { $languages_names = icl_get_languages_names(); } return $languages_names; } private static function get_languages_names_count() { return count( self::get_languages_names() ); } static function get_charset_collate() { static $charset_collate = null; if ( $charset_collate == null ) { $charset_collate = ''; global $wpdb; if ( method_exists( $wpdb, 'has_cap' ) && $wpdb->has_cap( 'collation' ) ) { $schema = wpml_get_upgrade_schema(); $charset = $schema->get_default_charset(); $collate = $schema->get_default_collate(); if ( $charset ) { $charset_collate = "DEFAULT CHARACTER SET $charset"; } if ( $collate ) { $charset_collate .= " COLLATE $collate"; } } } return $charset_collate; } private static function create_languages() { $sql = "( `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY , `code` VARCHAR( 7 ) NOT NULL , `english_name` VARCHAR( 128 ) NOT NULL , `major` TINYINT NOT NULL DEFAULT '0', `active` TINYINT NOT NULL , `default_locale` VARCHAR( 35 ), `tag` VARCHAR( 35 ), `encode_url` TINYINT( 1 ) NOT NULL DEFAULT 0, `country` VARCHAR(10) NULL DEFAULT NULL, UNIQUE KEY `code` (`code`), UNIQUE KEY `english_name` (`english_name`) ) "; return self::create_table( 'icl_languages', $sql ); } static function languages_table_is_complete() { global $wpdb; $table_name = $wpdb->prefix . 'icl_languages'; $sql = "SELECT count(id) FROM {$table_name}"; $records_count = $wpdb->get_var( $sql ); $languages_names_count = self::get_languages_names_count(); if ( $records_count < $languages_names_count ) { return false; } $languages_codes = self::get_languages_codes(); $language_pairs = self::get_language_translations(); foreach ( self::get_languages_names() as $lang => $val ) { foreach ( $val['tr'] as $k => $display ) { $k = self::fix_language_name( $k ); $code = $languages_codes[ $lang ]; if ( ! array_key_exists( $code, $language_pairs ) \|\| ! in_array( $languages_codes[ $k ], $language_pairs[ $code ], true ) ) { return false; } } } return true; } /* * @param string $language_name * * @return string */ protected static function fix_language_name( $language_name ) { if ( strpos( $language_name, 'Norwegian Bokm' ) === 0 ) { $language_name = 'Norwegian Bokmål'; } return $language_name; } private static function get_language_translations() { $result = array(); global $wpdb; $table_name = $wpdb->prefix . 'icl_languages_translations'; $sql = "SELECT language_code, display_language_code FROM {$table_name}"; $rowset = $wpdb->get_results( $sql ); if ( is_array( $rowset ) ) { foreach ( $rowset as $row ) { $result[ $row->language_code ][] = $row->display_language_code; } } return $result; } static function fill_languages() { global $wpdb, $sitepress; $languages_codes = icl_get_languages_codes(); $lang_locales = icl_get_languages_locales(); $table_name = $wpdb->prefix . 'icl_languages'; if ( ! self::create_languages() ) { return false; } if ( ! self::languages_table_is_complete() ) { // First truncate the table $active_languages = ( $sitepress !== null && $sitepress->is_setup_complete() ) ? $sitepress->get_active_languages() : array(); $wpdb->hide_errors(); $sql = 'TRUNCATE ' . $table_name; $truncate_result = $wpdb->query( $sql ); $wpdb->show_errors(); if ( false !== $truncate_result ) { foreach ( self::get_languages_names() as $key => $val ) { $language_code = $languages_codes[ $key ]; $default_locale = isset( $lang_locales[ $language_code ] ) ? $lang_locales[ $language_code ] : ''; $language_tag = strtolower( str_replace( '_', '-', $language_code ) ); $args = array( 'english_name' => $key, 'code' => $language_code, 'major' => $val['major'], 'active' => isset( $active_languages[ $language_code ] ) ? 1 : 0, 'default_locale' => $default_locale, 'tag' => $language_tag, ); if ( $wpdb->insert( $table_name, $args ) === false ) { return false; } } } } return true; } private static function create_languages_translations() { $sql = '(`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY , `language_code` VARCHAR( 7 ) NOT NULL , `display_language_code` VARCHAR( 7 ) NOT NULL , `name` VARCHAR( 255 ) NOT NULL, UNIQUE(`language_code`, `display_language_code`) )'; return self::create_table( 'icl_languages_translations', $sql ); } static function fill_languages_translations() { global $wpdb; $languages_codes = icl_get_languages_codes(); $table_name = $wpdb->prefix . 'icl_languages_translations'; if ( ! self::create_languages_translations() ) { return false; } if ( ! self::languages_table_is_complete() ) { // First truncate the table $wpdb->hide_errors(); $sql = 'TRUNCATE ' . $table_name; $truncate_result = $wpdb->query( $sql ); $wpdb->show_errors(); if ( false !== $truncate_result ) { $index = 1; $insert_sql_parts = array(); $languages = self::get_languages_names(); if ( $languages ) { foreach ( $languages as $lang => $val ) { foreach ( $val['tr'] as $k => $display ) { $k = self::fix_language_name( $k ); if ( ! trim( $display ) ) { $display = $lang; } $inserts_language_data = array( 'id' => $index, 'language_code' => $languages_codes[ $lang ], 'display_language_code' => $languages_codes[ $k ], 'name' => $display, ); $insert_sql_parts[] = $wpdb->prepare( '(%d, %s, %s, %s)', $inserts_language_data ); $index ++; } } $insert_sql = implode( ",\n", $insert_sql_parts ); $insert_sql = "INSERT INTO {$table_name} (id, language_code, display_language_code, name) VALUES " . $insert_sql; if ( $wpdb->query( $insert_sql ) === false ) { return false; } } } } return true; } private static function create_table( $name, $table_sql ) { global $wpdb; $table_name = $wpdb->prefix . $name; $found_table = (string) $wpdb->get_var( "SHOW TABLES LIKE '{$table_name}'" ); return 0 === strcasecmp( $found_table, $table_name ) \|\| ( $wpdb->query( sprintf( 'CREATE TABLE IF NOT EXISTS `%s` ', $table_name ) . $table_sql . ' ' . self::get_charset_collate() ) !== false ); } private static function create_flags() { $sql = "(`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY , `lang_code` VARCHAR( 10 ) NOT NULL , `flag` VARCHAR( 32 ) NOT NULL , `from_template` TINYINT NOT NULL DEFAULT '0', UNIQUE (`lang_code`) )"; return self::create_table( 'icl_flags', $sql ); } public static function fill_flags() { global $wpdb; if ( self::create_flags() === false ) { return; } $codes = $wpdb->get_col( "SELECT code FROM {$wpdb->prefix}icl_languages" ); foreach ( $codes as $code ) { if ( ! $code \|\| $wpdb->get_var( $wpdb->prepare( "SELECT lang_code FROM {$wpdb->prefix}icl_flags WHERE lang_code = %s ", $code ) ) ) { continue; } $code_parts = explode( '-', $code ); if ( file_exists( WPML_PLUGIN_PATH . '/res/flags/nil.svg' ) ) { $file = 'nil.svg'; } else { $file = 'nil.png'; } if ( file_exists( WPML_PLUGIN_PATH . '/res/flags/' . $code . '.svg' ) ) { $file = $code . '.svg'; } elseif ( file_exists( WPML_PLUGIN_PATH . '/res/flags/' . $code_parts[0] . '.svg' ) ) { $file = $code_parts[0] . '.svg'; } elseif ( file_exists( WPML_PLUGIN_PATH . '/res/flags/' . $code . '.png' ) ) { $file = $code . '.png'; } elseif ( file_exists( WPML_PLUGIN_PATH . '/res/flags/' . $code_parts[0] . '.png' ) ) { $file = $code_parts[0] . '.png'; } $wpdb->insert( $wpdb->prefix . 'icl_flags', array( 'lang_code' => $code, 'flag' => $file, 'from_template' => 0, ) ); } } public static function insert_default_category( $lang_code ) { global $sitepress; $default_language = $sitepress->get_default_language(); if ( $lang_code === $default_language ) { return; } // Get default categories. $default_categories = $sitepress->get_setting( 'default_categories', array() ); if ( isset( $default_categories[ $lang_code ] ) ) { return; } $sitepress->switch_locale( $lang_code ); $tr_cat = __( 'Uncategorized', 'sitepress' ); $tr_cat = $tr_cat === 'Uncategorized' && $lang_code !== 'en' ? 'Uncategorized @' . $lang_code : $tr_cat; $tr_term = term_exists( $tr_cat, 'category' ); $sitepress->switch_locale(); // check if the term already exists if ( $tr_term !== 0 && $tr_term !== null ) { $tmp = get_term( (int) $tr_term['term_taxonomy_id'], 'category', ARRAY_A ); } else { $tmp = wp_insert_term( $tr_cat, 'category' ); } // add it to settings['default_categories'] $default_categories[ $lang_code ] = $tmp['term_taxonomy_id']; $sitepress->set_default_categories( $default_categories ); // update translations table $default_category_trid = $sitepress->get_element_trid( get_option( 'default_category' ), 'tax_category' ); $sitepress->set_element_language_details( $tmp['term_taxonomy_id'], 'tax_category', $default_category_trid, $lang_code, $default_language ); } }

| ver. 1.4 | Github | . | PHP 7.4.3-4ubuntu2.24 | Генерация страницы: 0 | proxy | phpinfo | Настройка