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

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

Назад
<?php /** * @package wpml-core / function icl_reset_language_data() { global $wpdb, $sitepress; $active = $wpdb->get_col( "SELECT code FROM {$wpdb->prefix}icl_languages WHERE active = 1" ); $wpdb->query( "TRUNCATE TABLE `{$wpdb->prefix}icl_languages`" ); SitePress_Setup::fill_languages(); $wpdb->query( "TRUNCATE TABLE `{$wpdb->prefix}icl_languages_translations`" ); SitePress_Setup::fill_languages_translations(); $wpdb->query( "TRUNCATE TABLE `{$wpdb->prefix}icl_flags`" ); SitePress_Setup::fill_flags(); // restore active $wpdb->query( "UPDATE {$wpdb->prefix}icl_languages SET active=1 WHERE code IN(" . wpml_prepare_in( $active ) . ')' ); $wpdb->update( $wpdb->prefix . 'icl_flags', array( 'from_template' => 0 ), null ); $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; } $file = wpml_get_flag_file_name( $code ); $wpdb->insert( $wpdb->prefix . 'icl_flags', array( 'lang_code' => $code, 'flag' => $file, 'from_template' => 0, ) ); } $last_default_language = $sitepress !== null ? $sitepress->get_default_language() : 'en'; if ( ! in_array( $last_default_language, $codes ) ) { $allowed_langs = array_intersect( array_keys( $sitepress->get_active_languages() ), $codes ); $sitepress->set_default_language( array_pop( $allowed_langs ) ); } icl_cache_clear(); do_action( 'wpml_translation_update', array( 'type' => 'reset' ) ); } function icl_sitepress_activate() { global $wpdb; $charset_collate = SitePress_Setup::get_charset_collate(); try { SitePress_Setup::fill_languages(); SitePress_Setup::fill_languages_translations(); SitePress_Setup::fill_flags(); // translations $table_name = $wpdb->prefix . 'icl_translations'; $found_table = (string) $wpdb->get_var( "SHOW TABLES LIKE '{$table_name}'" ); if ( 0 !== strcasecmp( $found_table, $table_name ) ) { $sql = " CREATE TABLE IF NOT EXISTS `{$table_name}` ( `translation_id` BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY , `element_type` VARCHAR( 60 ) NOT NULL DEFAULT 'post_post', `element_id` BIGINT NULL DEFAULT NULL , `trid` BIGINT NOT NULL , `language_code` VARCHAR( 7 ) NOT NULL, `source_language_code` VARCHAR( 7 ), UNIQUE KEY `el_type_id` (`element_type`,`element_id`), UNIQUE KEY `trid_lang` (`trid`,`language_code`), KEY `trid` (`trid`), KEY `id_type_language` (`element_id`, `element_type`, `language_code`) ) {$charset_collate}"; if ( $wpdb->query( $sql ) === false ) { throw new Exception( $wpdb->last_error ); } } // translation_status table $table_name = $wpdb->prefix . 'icl_translation_status'; $found_table = (string) $wpdb->get_var( "SHOW TABLES LIKE '{$table_name}'" ); if ( 0 !== strcasecmp( $found_table, $table_name ) ) { $sql = " CREATE TABLE IF NOT EXISTS `{$table_name}` ( `rid` bigint(20) NOT NULL AUTO_INCREMENT, `translation_id` bigint(20) NOT NULL, `status` tinyint(4) NOT NULL, `translator_id` bigint(20) NOT NULL, `needs_update` tinyint(4) NOT NULL, `md5` varchar(32) NOT NULL, `translation_service` varchar(16) NOT NULL, `batch_id` int DEFAULT 0 NOT NULL, `translation_package` longtext NOT NULL, `timestamp` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, `links_fixed` tinyint(4) NOT NULL DEFAULT 0, `_prevstate` longtext, `uuid` varchar(36) NULL, `tp_id` INT NULL DEFAULT NULL, `tp_revision` INT NOT NULL DEFAULT 1, `ts_status` TEXT NULL DEFAULT NULL, `review_status` ENUM('NEEDS_REVIEW', 'EDITING', 'ACCEPTED'), `ate_comm_retry_count` INT(11) UNSIGNED DEFAULT 0, PRIMARY KEY (`rid`), UNIQUE KEY `translation_id` (`translation_id`) ) {$charset_collate} "; if ( $wpdb->query( $sql ) === false ) { throw new Exception( $wpdb->last_error ); } } // translation jobs $table_name = $wpdb->prefix . 'icl_translate_job'; $found_table = (string) $wpdb->get_var( "SHOW TABLES LIKE '{$table_name}'" ); if ( 0 !== strcasecmp( $found_table, $table_name ) ) { $sql = " CREATE TABLE IF NOT EXISTS `{$table_name}` ( `job_id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY , `rid` BIGINT UNSIGNED NOT NULL , `translator_id` INT UNSIGNED NOT NULL , `translated` TINYINT UNSIGNED NOT NULL DEFAULT 0, `manager_id` INT UNSIGNED NOT NULL , `revision` INT UNSIGNED NULL, `title` VARCHAR(160) NULL, `deadline_date` DATETIME NULL, `completed_date` DATETIME NULL, `editor` VARCHAR(16) NULL, `editor_job_id` BIGINT(20) UNSIGNED NULL, `edit_timestamp` INT(11) UNSIGNED NULL, `automatic` TINYINT UNSIGNED NOT NULL DEFAULT 0, INDEX ( `rid` , `translator_id` ) ) {$charset_collate} "; if ( $wpdb->query( $sql ) === false ) { throw new Exception( $wpdb->last_error ); } } // translate table $table_name = $wpdb->prefix . 'icl_translate'; $found_table = (string) $wpdb->get_var( "SHOW TABLES LIKE '{$table_name}'" ); if ( 0 !== strcasecmp( $found_table, $table_name ) ) { $sql = " CREATE TABLE IF NOT EXISTS `{$table_name}` ( `tid` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY , `job_id` BIGINT UNSIGNED NOT NULL , `content_id` BIGINT UNSIGNED NOT NULL , `timestamp` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP , `field_type` VARCHAR( 160 ) NOT NULL , `field_wrap_tag` VARCHAR( 16 ) NOT NULL , `field_format` VARCHAR( 16 ) NOT NULL , `field_translate` TINYINT NOT NULL , `field_data` longtext NOT NULL , `field_data_translated` longtext NOT NULL , `field_finished` TINYINT NOT NULL DEFAULT 0, INDEX ( `job_id` ) ) {$charset_collate} "; if ( $wpdb->query( $sql ) === false ) { throw new Exception( $wpdb->last_error ); } } // batches table $table_name = $wpdb->prefix . 'icl_translation_batches'; $found_table = (string) $wpdb->get_var( "SHOW TABLES LIKE '{$table_name}'" ); if ( 0 !== strcasecmp( $found_table, $table_name ) ) { $sql = " CREATE TABLE IF NOT EXISTS {$wpdb->prefix}icl_translation_batches ( `id` int(11) NOT NULL AUTO_INCREMENT, `batch_name` text NOT NULL, `tp_id` int NULL, `ts_url` text NULL, `last_update` DATETIME NULL, PRIMARY KEY (`id`) ) {$charset_collate} "; if ( $wpdb->query( $sql ) === false ) { throw new Exception( $wpdb->last_error ); } } // languages locale file names $table_name = $wpdb->prefix . 'icl_locale_map'; $found_table = (string) $wpdb->get_var( "SHOW TABLES LIKE '{$table_name}'" ); if ( 0 !== strcasecmp( $found_table, $table_name ) ) { $sql = " CREATE TABLE IF NOT EXISTS `{$table_name}` ( `code` VARCHAR( 7 ) NOT NULL , `locale` VARCHAR( 35 ) NOT NULL , PRIMARY KEY (`code` ,`locale`) ) {$charset_collate}"; if ( $wpdb->query( $sql ) === false ) { throw new Exception( $wpdb->last_error ); } } / general string translation / $translation_priority_default = __( 'Optional', 'sitepress' ); $table_name = $wpdb->prefix . 'icl_strings'; $found_table = (string) $wpdb->get_var( "SHOW TABLES LIKE '{$table_name}'" ); if ( 0 !== strcasecmp( $found_table, $table_name ) ) { $sql = " CREATE TABLE IF NOT EXISTS `{$table_name}` ( `id` bigint(20) unsigned NOT NULL auto_increment, `language` varchar(7) NOT NULL, `context` varchar(" . WPML_STRING_TABLE_NAME_CONTEXT_LENGTH . ') NOT NULL, `name` varchar(' . WPML_STRING_TABLE_NAME_CONTEXT_LENGTH . ") NOT NULL, `value` longtext NOT NULL, `string_package_id` BIGINT unsigned NULL, `location` BIGINT unsigned NULL, `wrap_tag` VARCHAR( 16 ) NOT NULL, `type` VARCHAR(40) NOT NULL DEFAULT 'LINE', `title` VARCHAR(160) NULL, `status` TINYINT NOT NULL, `gettext_context` TEXT NOT NULL, `domain_name_context_md5` VARCHAR(32) NOT NULL, `translation_priority` varchar(160) NOT NULL, `word_count` int unsigned NULL, PRIMARY KEY (`id`), UNIQUE KEY `uc_domain_name_context_md5` (`domain_name_context_md5`), KEY `language_context` (`language`, `context`), KEY `icl_strings_name` (`name` ASC), KEY `icl_strings_translation_priority` ( `translation_priority` ASC ), KEY `context` ( `context` ) ) {$charset_collate} "; if ( $wpdb->query( $sql ) === false ) { throw new Exception( $wpdb->last_error ); } } $table_name = $wpdb->prefix . 'icl_string_translations'; $found_table = (string) $wpdb->get_var( "SHOW TABLES LIKE '{$table_name}'" ); if ( 0 !== strcasecmp( $found_table, $table_name ) ) { $sql = " CREATE TABLE IF NOT EXISTS `{$table_name}` ( `id` bigint(20) unsigned NOT NULL auto_increment, `string_id` bigint(20) unsigned NOT NULL, `language` varchar(10) NOT NULL, `status` tinyint(4) NOT NULL, `value` longtext NULL DEFAULT NULL, `mo_string` longtext NULL DEFAULT NULL, `translator_id` bigint(20) unsigned DEFAULT NULL, `translation_service` varchar(16) DEFAULT '' NOT NULL, `batch_id` int DEFAULT 0 NOT NULL, `translation_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `string_language` (`string_id`,`language`) ) {$charset_collate}"; if ( $wpdb->query( $sql ) === false ) { throw new Exception( $wpdb->last_error ); } } $table_name = $wpdb->prefix . 'icl_string_status'; $found_table = (string) $wpdb->get_var( "SHOW TABLES LIKE '{$table_name}'" ); if ( 0 !== strcasecmp( $found_table, $table_name ) ) { $sql = " CREATE TABLE IF NOT EXISTS `{$table_name}` ( `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY , `rid` BIGINT NOT NULL , `string_translation_id` BIGINT NOT NULL , `timestamp` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP , `md5` VARCHAR( 32 ) NOT NULL, INDEX ( `string_translation_id` ) ) {$charset_collate}"; if ( $wpdb->query( $sql ) === false ) { throw new Exception( $wpdb->last_error ); } } $table_name = $wpdb->prefix . 'icl_string_positions'; $found_table = (string) $wpdb->get_var( "SHOW TABLES LIKE '{$table_name}'" ); if ( 0 !== strcasecmp( $found_table, $table_name ) ) { $sql = " CREATE TABLE IF NOT EXISTS `{$table_name}` ( `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY , `string_id` BIGINT NOT NULL , `kind` TINYINT, `position_in_page` VARCHAR( 255 ) NOT NULL, INDEX ( `string_id` ) ) {$charset_collate}"; if ( $wpdb->query( $sql ) === false ) { throw new Exception( $wpdb->last_error ); } } // message status table $table_name = $wpdb->prefix . 'icl_message_status'; $found_table = (string) $wpdb->get_var( "SHOW TABLES LIKE '{$table_name}'" ); if ( 0 !== strcasecmp( $found_table, $table_name ) ) { $sql = " CREATE TABLE IF NOT EXISTS `{$table_name}` ( `id` bigint(20) unsigned NOT NULL auto_increment, `rid` bigint(20) unsigned NOT NULL, `object_id` bigint(20) unsigned NOT NULL, `from_language` varchar(10) NOT NULL, `to_language` varchar(10) NOT NULL, `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP, `md5` varchar(32) NOT NULL, `object_type` varchar(64) NOT NULL, `status` smallint(6) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `rid` (`rid`), KEY `object_id` (`object_id`) ) {$charset_collate}"; if ( $wpdb->query( $sql ) === false ) { throw new Exception( $wpdb->last_error ); } } / string translation - start / $icl_translation_sql = " CREATE TABLE IF NOT EXISTS {$wpdb->prefix}icl_core_status ( `id` BIGINT NOT NULL auto_increment, `rid` BIGINT NOT NULL, `module` VARCHAR( 16 ) NOT NULL , `origin` VARCHAR( 64 ) NOT NULL , `target` VARCHAR( 64 ) NOT NULL , `status` SMALLINT NOT NULL, `tp_revision` INT NOT NULL DEFAULT 1, `ts_status` TEXT NULL DEFAULT NULL, PRIMARY KEY ( `id` ) , INDEX ( `rid` ) ) {$charset_collate} "; if ( $wpdb->query( $icl_translation_sql ) === false ) { throw new Exception( $wpdb->last_error ); } $icl_translation_sql = " CREATE TABLE IF NOT EXISTS `{$wpdb->prefix}icl_content_status` ( `rid` BIGINT NOT NULL , `nid` BIGINT NOT NULL , `timestamp` DATETIME NOT NULL , `md5` VARCHAR( 32 ) NOT NULL , PRIMARY KEY ( `rid` ) , INDEX ( `nid` ) ) {$charset_collate} "; if ( $wpdb->query( $icl_translation_sql ) === false ) { throw new Exception( $wpdb->last_error ); } $icl_translation_sql = " CREATE TABLE IF NOT EXISTS `{$wpdb->prefix}icl_node` ( `nid` BIGINT NOT NULL , `md5` VARCHAR( 32 ) NOT NULL , `links_fixed` TINYINT NOT NULL DEFAULT 0, PRIMARY KEY ( `nid` ) ) {$charset_collate} "; if ( $wpdb->query( $icl_translation_sql ) === false ) { throw new Exception( $wpdb->last_error ); } $icl_translation_sql = " CREATE TABLE IF NOT EXISTS `{$wpdb->prefix}icl_reminders` ( `id` BIGINT NOT NULL , `message` TEXT NOT NULL , `url` TEXT NOT NULL , `can_delete` TINYINT NOT NULL , `show` TINYINT NOT NULL , PRIMARY KEY ( `id` ) ) {$charset_collate} "; if ( $wpdb->query( $icl_translation_sql ) === false ) { throw new Exception( $wpdb->last_error ); } } catch ( Exception $e ) { trigger_error( $e->getMessage(), E_USER_ERROR ); exit; } // don't set the new version if a multi-step upgrade is in progress if ( ! defined( 'ICL_MULTI_STEP_UPGRADE' ) ) { delete_option( 'icl_sitepress_version' ); add_option( 'icl_sitepress_version', ICL_SITEPRESS_VERSION, '', true ); } $iclsettings = get_option( 'icl_sitepress_settings' ); if ( $iclsettings === false ) { $short_v = implode( '.', array_slice( explode( '.', ICL_SITEPRESS_VERSION ), 0, 3 ) ); $settings = array( 'hide_upgrade_notice' => $short_v, 'translated_document_status_sync' => 1, ); add_option( 'icl_sitepress_settings', $settings, '', true ); } else { // reset ajx_health_flag $iclsettings['ajx_health_checked'] = 0; $iclsettings['just_reactivated'] = 1; update_option( 'icl_sitepress_settings', $iclsettings ); } // Set new caps for all administrator role wpml_enable_capabilities(); repair_el_type_collate(); do_action( 'wpml_activated' ); } function icl_sitepress_deactivate() { wp_clear_scheduled_hook( 'update_wpml_config_index' ); require_once WPML_PLUGIN_PATH . '/inc/cache.php'; icl_cache_clear(); do_action( 'wpml_deactivated' ); } function icl_enable_capabilities() { global $wp_roles; if ( ! isset( $wp_roles ) \|\| ! is_object( $wp_roles ) ) { $wp_roles = new WP_Roles(); } $iclsettings = get_option( 'icl_sitepress_settings' ); $icl_capabilities = icl_sitepress_get_capabilities(); // Set WPML capabilities to all roles with cap:"". $roles = $wp_roles->get_names(); foreach ( $roles as $current_role => $role_name ) { if ( isset( $wp_roles->roles[ $current_role ]['capabilities']['manage_options'] ) ) { $role = get_role( $current_role ); if ( isset( $role ) && is_object( $role ) ) { for ( $i = 0, $caps_limit = count( $icl_capabilities ); $i < $caps_limit; $i ++ ) { if ( ! isset( $wp_roles->roles[ $current_role ]['capabilities'][ $icl_capabilities[ $i ] ] ) ) { $role->add_cap( $icl_capabilities[ $i ] ); } } } } } $user_admins = get_users( array( 'role' => 'administrator', ) ); if ( is_multisite() ) { $super_admins = get_super_admins(); foreach ( $super_admins as $admin ) { $super_admin = new WP_User( $admin ); if ( ! in_array( $super_admin, $user_admins, true ) ) { $user_admins[] = $super_admin; } } } foreach ( $user_admins as $user ) { if ( $user->exists() ) { for ( $i = 0, $caps_limit = count( $icl_capabilities ); $i < $caps_limit; $i ++ ) { $user->add_cap( $icl_capabilities[ $i ] ); } } } $iclsettings['icl_capabilities_verified'] = true; update_option( 'icl_sitepress_settings', $iclsettings ); } /* * Fires at plugins_loaded action, to call icl_enable_capabilities(). * https://onthegosystems.myjetbrains.com/youtrack/issue/wpmlcore-5695 / function wpml_enable_capabilities() { global $sitepress_settings; /* * In case of multisite, in network activation, * including of pluggable.php before muplugins_loaded event trigger errors - * we postpone executing of icl_enable_capabilities to after plugins_loaded event. * * In other cases we include pluggable.php earlier than in wp-settings.php */ if ( ! did_action( 'muplugins_loaded' ) ) { add_action( 'plugins_loaded', 'wpml_enable_capabilities' ); } else { if ( ! function_exists( 'get_user_by' ) ) { require ABSPATH . WPINC . '/pluggable.php'; } icl_enable_capabilities(); $sitepress_settings = get_option( 'icl_sitepress_settings' ); } }

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