' . esc_html__( 'Translangated data update', 'translangated' ) . ' – ' . esc_html__( 'Translangated needs to optimize gettext database tables. Translations continue to work while this runs in the background.', 'translangated' ) . '
'; $html .= '' . esc_html__( 'Before starting, we strongly recommend creating a database backup.', 'translangated' ) . '
'; $html .= ''; $html .= '' . esc_html__( 'Translangated data update', 'translangated' ) . ' – ' . esc_html__( 'We need to update your translations database to the latest version.', 'translangated' ) . '
'; $html .= ''; $html .= '' . wp_kses( sprintf( /* translators: %s: URL of the database update page */ __('Database optimization did not complete successfully. We recommend restoring the original database or trying again.', 'translangated'), admin_url('admin.php?page=translangated_update_database') ), array('a' => array( 'href' => array() ) ) ) .'
' . __('Successfully updated database!', 'translangated' ) . '
' . $back_to_settings_button )); wp_die(); }else{ $_REQUEST['translangated_updb_lang'] = $this->settings['translation-languages'][0]; $_REQUEST['translangated_updb_batch'] = 0; $updb_action = sanitize_text_field( $_REQUEST['translangated_updb_action'] ); $update_message_initial = isset( $updates_needed[ $updb_action ]['message_initial'] ) ? $updates_needed[ $updb_action ]['message_initial'] : /* translators: %s: database version number */ __('Updating database to version %s+', 'translangated' ); $update_message_processing = $this->get_updates_processing_message( $updb_action ) ? $this->get_updates_processing_message( $updb_action ) : /* translators: %s: language code */ __('Processing table for language %s...', 'translangated' ); if ($updates_needed[ $updb_action ]['version'] != 0) { $request['progress_message'] .= '' . sprintf( $update_message_initial, $updates_needed[ $updb_action ]['version'] ) . '
'; } $request['progress_message'] .= 'SQL Error: ' . esc_html($this->db->last_error) . '
' . $request['progress_message']; } $query_arguments = array( 'action' => 'translangated_update_database', 'translangated_updb_action' => $request['translangated_updb_action'], 'translangated_updb_lang' => $request['translangated_updb_lang'], 'translangated_updb_batch' => $request['translangated_updb_batch'], 'translangated_updb_extra_params' => isset($request['translangated_updb_extra_params']) ? base64_encode(wp_json_encode($request['translangated_updb_extra_params'])) : base64_encode(wp_json_encode(array())), 'translangated_updb_nonce' => wp_create_nonce('tpupdatedatabase'), 'translangated_update_completed' => 'no', 'progress_message' => $request['progress_message'] ); echo( wp_json_encode( $query_arguments )); wp_die(); } public function stop_and_print_error( $error_message ){ $back_to_settings_button = '' . esc_html__('Back to Translangated Settings', 'translangated' ) . ''; $query_arguments = array( 'translangated_update_completed' => 'yes', 'progress_message' => '' . $error_message . '
' . $back_to_settings_button ); echo( wp_json_encode( $query_arguments )); wp_die(); } /** * Build a structured legacy updater error without allowing the current * action to be marked as completed. * * @param string $operation Description of the failed operation. * * @return array|false */ protected function get_legacy_database_update_error( $operation ) { if ( $this->db->last_error === '' ) { return false; } return array( 'error' => sprintf( /* translators: 1: description of the database operation that failed, 2: SQL error message */ __( 'Update aborted while %1$s. SQL error: %2$s', 'translangated' ), $operation, $this->db->last_error ), ); } /** * Get all originals from the table, trim them and update originals back into table * * @param string $language_code Language code of the table * @param int $inferior_limit Omit first X rows * @param int $batch_size How many rows to query * * @return bool */ public function translangated_updated_database_full_trim_originals_140( $language_code, $inferior_limit, $batch_size ){ if ( ! $this->translangated_query ) { $trp = Translangated_Plugin::get_translangated_instance(); /* @var Translangated_Query */ $this->translangated_query = $trp->get_component( 'query' ); } if ( $language_code == $this->settings['default-language']){ // default language doesn't have a dictionary table return true; } $strings = $this->translangated_query->get_rows_from_location( $language_code, $inferior_limit, $batch_size, array( 'id', 'original' ) ); if ( count( $strings ) == 0 ) { return true; } foreach( $strings as $key => $string ){ $strings[$key]['original'] = translangated_full_trim( $strings[ $key ]['original'] ); } // overwrite original only $this->translangated_query->update_strings( $strings, $language_code, array( 'id', 'original' ) ); return false; } /** * Delete all empty gettext rows * * @param string $language_code Language code of the table * @param int $inferior_limit Omit first X rows * @param int $batch_size How many rows to query * * @return bool */ public function translangated_updated_database_gettext_empty_rows_145( $language_code, $inferior_limit, $batch_size ){ if ( ! $this->translangated_query ) { $trp = Translangated_Plugin::get_translangated_instance(); /* @var Translangated_Query */ $this->translangated_query = $trp->get_component( 'query' ); } $rows_affected = $this->translangated_query->delete_empty_gettext_strings( $language_code, $batch_size ); if ( $rows_affected > 0 ){ return false; }else{ return true; } } /** * Normalize original ids for all dictionary entries * * @param string $language_code Language code of the table * @param int $inferior_limit Omit first X rows * @param int $batch_size How many rows to query * * @return array|bool */ public function translangated_updated_database_original_id_insert_166( $language_code, $inferior_limit, $batch_size ){ if ( ! $this->translangated_query ) { $trp = Translangated_Plugin::get_translangated_instance(); /* @var Translangated_Query */ $this->translangated_query = $trp->get_component( 'query' ); } if ( $this->settings['default-language'] === $language_code ) { return true; } $this->translangated_query->original_ids_insert( $language_code, $inferior_limit, $batch_size ); $error = $this->get_legacy_database_update_error( __( 'inserting original strings', 'translangated' ) ); if ( $error ) { return $error; } $last_id = $this->translangated_query->get_last_id( $this->translangated_query->get_table_name( $language_code, $this->settings['default-language'] ) ); $error = $this->get_legacy_database_update_error( __( 'checking original string insertion progress', 'translangated' ) ); if ( $error ) { return $error; } return ( $inferior_limit + $batch_size ) >= $last_id; } public function translangated_updated_database_original_id_cleanup_166( $language_code, $inferior_limit, $batch_size ){ if ( ! $this->translangated_query ) { $trp = Translangated_Plugin::get_translangated_instance(); /* @var Translangated_Query */ $this->translangated_query = $trp->get_component( 'query' ); } $this->translangated_query->original_ids_cleanup(); $error = $this->get_legacy_database_update_error( __( 'cleaning duplicate original strings', 'translangated' ) ); if ( $error ) { return $error; } return true; } /** * Normalize original ids for all dictionary entries * * @param string $language_code Language code of the table * @param int $inferior_limit Omit first X rows * @param int $batch_size How many rows to query * * @return array|bool */ public function translangated_updated_database_original_id_update_166( $language_code, $inferior_limit, $batch_size ){ if ( ! $this->translangated_query ) { $trp = Translangated_Plugin::get_translangated_instance(); /* @var Translangated_Query */ $this->translangated_query = $trp->get_component( 'query' ); } if ( $this->settings['default-language'] === $language_code ) { return true; } $this->translangated_query->original_ids_reindex( $language_code, $inferior_limit, $batch_size ); $error = $this->get_legacy_database_update_error( __( 'updating original string IDs', 'translangated' ) ); if ( $error ) { return $error; } $last_id = $this->translangated_query->get_last_id( $this->translangated_query->get_table_name( $language_code, $this->settings['default-language'] ) ); $error = $this->get_legacy_database_update_error( __( 'checking original string ID update progress', 'translangated' ) ); if ( $error ) { return $error; } return ( $inferior_limit + $batch_size ) >= $last_id; } public function translangated_prepare_options_for_database_optimization(){ if ( !current_user_can( 'manage_options' ) || !isset( $_GET['translangated_rm_nonce'] ) ) { return; } if ( !wp_verify_nonce( sanitize_text_field( $_GET['translangated_rm_nonce'] ), 'tpremoveduplicaterows' ) ){ exit; } $redirect = false; if(isset( $_GET['translangated_rm_duplicates_gettext'] )){ update_option('translangated_remove_duplicate_gettext_rows', 'no'); $redirect = true; } if(isset( $_GET['translangated_rm_duplicates_dictionary'] )){ update_option('translangated_remove_duplicate_dictionary_rows', 'no'); update_option('translangated_remove_duplicate_untranslated_dictionary_rows', 'no'); $redirect = true; } if ( isset( $_GET['translangated_rm_duplicates_original_strings'] ) ){ $this->translangated_remove_duplicate_original_strings(); $redirect = true; } if ( isset( $_GET['translangated_rm_cdata_original_and_dictionary'])){ update_option('translangated_remove_cdata_original_and_dictionary_rows', 'no'); $redirect = true; } if ( isset( $_GET['translangated_rm_untranslated_links'] ) ){ update_option('translangated_remove_untranslated_links_dictionary_rows', 'no'); $redirect = true; } if ( isset( $_GET['translangated_replace_original_id_null'] ) ){ update_option('translangated_replace_original_id_null', 'no'); $redirect = true; } if ( $redirect ) { $url = add_query_arg( array( 'page' => 'translangated_update_database' ), admin_url( 'admin.php' ) ); wp_safe_redirect( $url ); exit; } } /** * Remove duplicate rows from DB for translangated_dictionary tables. * Removes untranslated strings if there is a translated version. * * Iterates over languages. Each language is iterated in batches of 10 000 * * Not accessible from anywhere else * http://example.com/wp-admin/admin.php?page=translangated_remove_duplicate_rows */ public function translangated_remove_duplicate_rows(){ if ( ! current_user_can( 'manage_options' ) ){ return; } // prepare page structure require_once TRANSLANGATED_PLUGIN_DIR . 'partials/trp-remove-duplicate-rows.php'; } public function enqueue_update_script( $hook ) { if ( $hook === 'admin_page_translangated_update_database' ) { wp_enqueue_script( 'translangated-update-database', TRANSLANGATED_PLUGIN_URL . 'assets/js/trp-update-database.js', array( 'jquery', ), TRANSLANGATED_PLUGIN_VERSION ); } wp_localize_script( 'translangated-update-database', 'translangated_updb_localized ', array( 'admin_ajax_url' => admin_url( 'admin-ajax.php' ), 'nonce' => wp_create_nonce('tpupdatedatabase') ) ); } /** * Add full text index on the dictionary and gettext tables. * Gets executed once after update. */ private function add_full_text_index_to_tables(){ $table_names = $this->translangated_query->get_all_table_names('', array()); $gettext_table_names = $this->translangated_query->get_all_gettext_table_names(); foreach (array_merge($table_names, $gettext_table_names) as $table_name){ $possible_index = $this->db->prepare( 'SHOW INDEX FROM %i WHERE Key_name = %s', $table_name, 'original_fulltext' ); if ($this->db->query($possible_index) === 1){ continue; }; $sql_index = $this->db->prepare( 'CREATE FULLTEXT INDEX original_fulltext ON %i(original);', $table_name ); $this->db->query( $sql_index ); } } /** * Moving some settings from translangated_settings option to translangated_machine_translation_settings * * Upgrade settings from TP version 1.5.8 or earlier to 1.6.2 */ private function upgrade_machine_translation_settings(){ $trp = Translangated_Plugin::get_translangated_instance(); $translangated_settings = $trp->get_component('settings' ); $machine_translation_settings = get_option( 'translangated_machine_translation_settings', false ); $default_machine_translation_settings = $translangated_settings->get_default_translangated_machine_translation_settings(); if ( $machine_translation_settings == false ) { // 1.5.8 did not have any machine_settings so port g-translate-key and g-translate settings if exists $machine_translation_settings = $default_machine_translation_settings; // move the old API key option if (!empty($this->settings['g-translate-key'] ) ) { $machine_translation_settings['google-translate-key'] = $this->settings['g-translate-key']; } // enable machine translation if it was activated before if (!empty($this->settings['g-translate']) && $this->settings['g-translate'] == 'yes'){ $machine_translation_settings['machine-translation'] = 'yes'; } update_option('translangated_machine_translation_settings', $machine_translation_settings); }else{ // targeting 1.5.9 to 1.6.1 where incomplete machine-translation settings may have resulted $machine_translation_settings = array_merge( $default_machine_translation_settings, $machine_translation_settings ); update_option('translangated_machine_translation_settings', $machine_translation_settings); } } /** * */ private function set_force_slash_at_end_of_links(){ $trp = Translangated_Plugin::get_translangated_instance(); $translangated_settings = $trp->get_component('settings' ); $settings = $translangated_settings->get_settings(); if( !empty( $settings['translangated_advanced_settings'] ) && !isset( $settings['translangated_advanced_settings']['force_slash_at_end_of_links'] ) ){ $advanced_settings = $settings['translangated_advanced_settings']; $advanced_settings['force_slash_at_end_of_links'] = 'yes'; update_option('translangated_advanced_settings', $advanced_settings ); } } public function add_iso_code_to_language_code(){ $trp = Translangated_Plugin::get_translangated_instance(); $translangated_settings = $trp->get_component('settings' ); $settings = $translangated_settings->get_settings(); if(isset($settings['translangated_advanced_settings']) && isset($settings['translangated_advanced_settings']['custom_language']) ){ $advanced_settings = $settings['translangated_advanced_settings']; if(!isset($advanced_settings['custom_language']['cuslangcode'])){ $advanced_settings['custom_language']['cuslangcode'] = $advanced_settings['custom_language']['cuslangiso']; } update_option('translangated_advanced_settings', $advanced_settings); } } public function create_opposite_ls_option(){ add_filter('wp_loaded', array($this, 'call_create_menu_entries')); } public function call_create_menu_entries(){ $trp = Translangated_Plugin::get_translangated_instance(); $translangated_settings = $trp->get_component('settings' ); $settings = $translangated_settings->get_settings(); $translangated_settings->create_menu_entries( $settings['publish-languages'] ); } public function translangated_remove_duplicate_original_strings(){ if ( ! $this->translangated_query ) { $trp = Translangated_Plugin::get_translangated_instance(); /* @var Translangated_Query */ $this->translangated_query = $trp->get_component( 'query' ); } $this->translangated_query->rename_originals_table(); $this->translangated_query->check_original_table(); update_option( 'translangated_updated_database_original_id_insert_166', 'no' ); update_option( 'translangated_updated_database_original_id_cleanup_166', 'no' ); update_option( 'translangated_updated_database_original_id_update_166', 'no' ); update_option( 'translangated_regenerate_original_meta_table', 'no' ); update_option( 'translangated_clean_original_meta_table', 'no' ); } public function translangated_regenerate_original_meta_table($language_code, $inferior_limit, $batch_size ){ if ( $language_code != $this->settings['default-language']) { // perform regeneration of original meta table only once return true; } if ( ! $this->translangated_query ) { $trp = Translangated_Plugin::get_translangated_instance(); /* @var Translangated_Query */ $this->translangated_query = $trp->get_component( 'query' ); } $this->translangated_query->regenerate_original_meta_table($inferior_limit, $batch_size); $last_id = $this->db->get_var( $this->db->prepare( 'SELECT MAX(meta_id) FROM %i', $this->translangated_query->get_table_name_for_original_meta() ) ); if ( $last_id < $inferior_limit ){ // reached end of table return true; }else{ // not done. get another batch return false; } } public function translangated_clean_original_meta_table($language_code, $inferior_limit, $batch_size){ if ( $language_code != $this->settings['default-language']) { // perform regeneration of original meta table only once return true; } if ( ! $this->translangated_query ) { $trp = Translangated_Plugin::get_translangated_instance(); /* @var Translangated_Query */ $this->translangated_query = $trp->get_component( 'query' ); } $rows_affected = $this->translangated_query->clean_original_meta( $batch_size ); if ( $rows_affected > 0 ){ return false; }else{ $old_originals_table = get_option( 'translangated_original_strings_table_for_recovery', '' ); if ( !empty ( $old_originals_table) && strpos($old_originals_table, 'translangated_original_strings1') !== false ) { delete_option('translangated_original_strings_table_for_recovery'); $this->translangated_query->drop_table( $old_originals_table ); } return true; } } /** * Normalize original ids for all gettext entries * * @param string $language_code Language code of the table * @param int $inferior_limit Omit first X rows * @param int $batch_size How many rows to query * * @return array|bool */ public function translangated_updated_database_gettext_original_id_insert( $language_code, $inferior_limit, $batch_size ){ if ( ! $this->translangated_query ) { $trp = Translangated_Plugin::get_translangated_instance(); /* @var Translangated_Query */ $this->translangated_query = $trp->get_component( 'query' ); } $gettext_normalization = $this->translangated_query->get_query_component('gettext_normalization'); $gettext_normalization->gettext_original_ids_insert( $language_code, $inferior_limit, $batch_size ); $error = $this->get_legacy_database_update_error( __( 'inserting gettext original strings', 'translangated' ) ); if ( $error ) { return $error; } $last_id = $this->translangated_query->get_last_id( $this->translangated_query->get_gettext_table_name($language_code) ); $error = $this->get_legacy_database_update_error( __( 'checking gettext original insertion progress', 'translangated' ) ); if ( $error ) { return $error; } return ( $inferior_limit + $batch_size ) >= $last_id; } /** * Removes possible duplicates from within gettext_original_strings table * * @param $language_code * @param $inferior_limit * @param $batch_size * @return array|bool */ public function translangated_updated_database_gettext_original_id_cleanup( $language_code, $inferior_limit, $batch_size ){ if ( ! $this->translangated_query ) { $trp = Translangated_Plugin::get_translangated_instance(); /* @var Translangated_Query */ $this->translangated_query = $trp->get_component( 'query' ); } $gettext_normalization = $this->translangated_query->get_query_component('gettext_normalization'); $gettext_normalization->gettext_original_ids_cleanup(); $error = $this->get_legacy_database_update_error( __( 'cleaning duplicate gettext original strings', 'translangated' ) ); if ( $error ) { return $error; } return true; } /** * Normalize original ids for all gettext entries * * @param string $language_code Language code of the table * @param int $inferior_limit Omit first X rows * @param int $batch_size How many rows to query * * @return array|bool */ public function translangated_updated_database_gettext_original_id_update( $language_code, $inferior_limit, $batch_size ){ if ( ! $this->translangated_query ) { $trp = Translangated_Plugin::get_translangated_instance(); /* @var Translangated_Query */ $this->translangated_query = $trp->get_component( 'query' ); } $gettext_normalization = $this->translangated_query->get_query_component('gettext_normalization'); $gettext_normalization->gettext_original_ids_reindex( $language_code, $inferior_limit, $batch_size ); $error = $this->get_legacy_database_update_error( __( 'updating gettext original string IDs', 'translangated' ) ); if ( $error ) { return $error; } $last_id = $this->translangated_query->get_last_id( $this->translangated_query->get_gettext_table_name( $language_code ) ); $error = $this->get_legacy_database_update_error( __( 'checking gettext original string ID update progress', 'translangated' ) ); if ( $error ) { return $error; } return ( $inferior_limit + $batch_size ) >= $last_id; } /** * Run the gettext originals lookup hash migration through the dedicated migration class. * * @param string $language_code Unused. Kept for updater callback signature. * @param int $inferior_limit Unused. This migration resumes by DB state. * @param int $batch_size Number of rows/groups/map entries per batch. * @param array $extra_params Migration phase state. * * @return array|bool * @throws Exception */ public function translangated_updated_database_gettext_original_lookup_hash( $language_code, $inferior_limit, $batch_size, $extra_params = array() ) { if ( ! $this->translangated_query ) { $trp = Translangated_Plugin::get_translangated_instance(); /* @var Translangated_Query */ $this->translangated_query = $trp->get_component( 'query' ); } require_once TRANSLANGATED_PLUGIN_DIR . 'includes/upgrade/gettext-optimization/class-gettext-originals-lookup-hash-migration.php'; $migration = new Translangated_Gettext_Originals_Lookup_Hash_Migration( $this->translangated_query ); return $migration->run( $language_code, $inferior_limit, $batch_size, $extra_params ); } /** * Classify gettext rows into language-file or runtime gettext statuses. * * Rows imported from .po/.mo files use status 4 when their stored * translation matches the active language-file translation. Rows that must * override runtime gettext output use the human-reviewed status 2. Machine * translated rows keep their existing status semantics. * * @param string $language_code * @param int $inferior_limit * @param int $batch_size * @param string $table_name Optional discovered gettext table name. * * @return bool */ public function translangated_updated_database_gettext_runtime_status_update( $language_code, $inferior_limit, $batch_size, $table_name = '' ) { if ( ! $this->translangated_query ) { $trp = Translangated_Plugin::get_translangated_instance(); /* @var Translangated_Query */ $this->translangated_query = $trp->get_component( 'query' ); } $table_name = is_string( $table_name ) && $table_name !== '' ? sanitize_text_field( $table_name ) : sanitize_text_field( $this->translangated_query->get_gettext_table_name( $language_code ) ); $originals_table = sanitize_text_field( $this->translangated_query->get_table_name_for_gettext_original_strings() ); if ( ! $this->translangated_query->table_exists( $table_name ) ) { return true; } $rows = $this->db->get_results( $this->db->prepare( "SELECT tt.id, tt.translated, tt.status, tt.original AS tt_original, tt.domain AS tt_domain, tt.plural_form, ot.original, ot.domain, ot.context, ot.original_plural FROM %i AS tt LEFT JOIN %i AS ot ON tt.original_id = ot.id ORDER BY tt.id LIMIT %d, %d", $table_name, $originals_table, $inferior_limit, $batch_size ), ARRAY_A ); if ( empty( $rows ) ) { return true; } $current_locale = determine_locale(); $switched = switch_to_locale( $language_code ); $language_file_available = $switched || $current_locale === $language_code; $ids_to_human_reviewed_status = array(); $ids_to_language_file_status = array(); foreach ( $rows as $row ) { $new_status = $this->get_migrated_gettext_status( $row, $language_file_available ); if ( $new_status === Translangated_Query::HUMAN_REVIEWED ) { $ids_to_human_reviewed_status[] = (int) $row['id']; } elseif ( $new_status === Translangated_Query::GETTEXT_TRANSLATED_IN_LANGUAGE_FILE ) { $ids_to_language_file_status[] = (int) $row['id']; } } if ( $switched ) { restore_previous_locale(); } $this->update_gettext_statuses( $table_name, $ids_to_human_reviewed_status, Translangated_Query::HUMAN_REVIEWED ); $this->update_gettext_statuses( $table_name, $ids_to_language_file_status, Translangated_Query::GETTEXT_TRANSLATED_IN_LANGUAGE_FILE ); $is_finished = count( $rows ) < $batch_size; return $is_finished; } /** * Decide the migrated gettext status for an existing DB row. * * Empty/untranslated rows and machine translated rows keep their existing * status semantics. Human/file-based rows use status 4 when they match the * active language-file output and status 2 when they must override it. * * @param array $row Gettext row joined with the original gettext table. * @param bool $language_file_available Whether WordPress loaded language files for the target locale. * * @return int|null */ protected function get_migrated_gettext_status( $row, $language_file_available = true ) { if ( empty( $row['translated'] ) || (int) $row['status'] === Translangated_Query::NOT_TRANSLATED ) { return null; } if ( (int) $row['status'] === Translangated_Query::MACHINE_TRANSLATED ) { return Translangated_Query::MACHINE_TRANSLATED; } $original = ! empty( $row['original'] ) ? $row['original'] : $row['tt_original']; $domain = ! empty( $row['domain'] ) ? $row['domain'] : $row['tt_domain']; $context = ! empty( $row['context'] ) ? $row['context'] : 'translangated_context'; $plural_form = isset( $row['plural_form'] ) ? (int) $row['plural_form'] : 0; $original_plural = ! empty( $row['original_plural'] ) ? $row['original_plural'] : null; if ( empty( $original ) || empty( $domain ) ) { return Translangated_Query::HUMAN_REVIEWED; } if ( ! $language_file_available ) { $source_translation = ( ! empty( $original_plural ) && (int) $plural_form > 0 ) ? $original_plural : $original; return ( $row['translated'] !== $source_translation ) ? Translangated_Query::HUMAN_REVIEWED : Translangated_Query::GETTEXT_TRANSLATED_IN_LANGUAGE_FILE; } $mo_translation = $this->get_gettext_language_file_translation( $original, $domain, $context, $plural_form, $original_plural ); return ( $row['translated'] !== $mo_translation ) ? Translangated_Query::HUMAN_REVIEWED : Translangated_Query::GETTEXT_TRANSLATED_IN_LANGUAGE_FILE; } /** * Return the translation WordPress would provide from loaded language files. * * The caller is responsible for switching to the target locale before calling * this method. If no matching entry exists in the language files, WordPress * returns the source string. * * @param string $original Original gettext string. * @param string $domain Text domain. * @param string $context Gettext context or translangated_context placeholder. * @param int $plural_form Plural form index stored by Translangated. * @param string|null $original_plural Original plural string, when available. * * @return string */ protected function get_gettext_language_file_translation( $original, $domain, $context, $plural_form, $original_plural ) { $translations = get_translations_for_domain( $domain ); $context = ( $context === 'translangated_context' ) ? null : $context; if ( ! empty( $original_plural ) ) { $plural_forms = new Translangated_Plural_Forms( $this->settings ); if ( method_exists( $translations, 'translate_entry' ) ) { return $plural_forms->translate_plural( $original, $original_plural, $plural_form, $context, $translations ); } return (int) $plural_form === 0 ? $original : $original_plural; } return $translations->translate( $original, $context ); } /** * Bulk update gettext status for a list of gettext row ids. * * @param string $table_name Gettext table name. * @param array $ids Row ids to update. * @param int $status New gettext status value. * * @return void */ protected function update_gettext_statuses( $table_name, $ids, $status ) { if ( empty( $ids ) ) { return; } $ids = array_map( 'intval', $ids ); $ids = array_filter( $ids ); if ( empty( $ids ) ) { return; } $this->db->query( $this->db->prepare( 'UPDATE %i SET status = %d WHERE id IN (' . implode( ',', array_fill( 0, count( $ids ), '%d' ) ) . ')', array_merge( array( $table_name, (int) $status ), array_values( $ids ) ) ) ); } /** * * Hooked to admin_init */ public function show_notification_about_add_ons_removal(){ //if it's triggered in the frontend we need this include if( !function_exists('is_plugin_active') ) include_once( ABSPATH . 'wp-admin/includes/plugin.php' ); $old_addon_list = array( 'tp-add-on-automatic-language-detection/tp-automatic-language-detection.php', 'tp-add-on-browse-as-other-roles/tp-browse-as-other-role.php', 'tp-add-on-deepl/index.php', 'tp-add-on-extra-languages/tp-extra-languages.php', 'tp-add-on-navigation-based-on-language/tp-navigation-based-on-language.php', 'tp-add-on-seo-pack/tp-seo-pack.php', 'tp-add-on-translator-accounts/index.php', ); foreach( $old_addon_list as $addon_slug ) { if (is_plugin_active($addon_slug)) { $notifications = Translangated_Plugin_Notifications::get_instance(); $notification_id = 'translangated_add_ons_removal'; $message = '' . esc_html__( 'The features of the individual add-on plugins are now included in Translangated. Please deactivate the old add-on plugins.', 'translangated' ) . '
'; //make sure to use the translangated_dismiss_admin_notification arg $message .= '' . esc_html__('Dismiss this notice.', 'translangated') . ''; $notifications->add_notification($notification_id, $message, 'trp-notice trp-narrow notice error is-dismissible', true, array('translangated'), true); break; } } } /** * There is a very unfortunate error where the original_id is NULL for some gettext strings * We have to check is this is the case and create arrays that would help the editor to not get stuck and complete the original_id field. * We do this by getting the id from the wp_translangated_gettext_original_strings and updating the wp_translangated_gettext_current_language table with the original ids. */ public function translangated_replace_original_id_null($language_code, $inferior_limit, $batch_size){ global $wpdb; $db = $wpdb; $dictionary = array(); $gettext_with_null_original_id_array= array(); $original_id_get_ids_sync = array(); $insert_gettext_original_id = array(); if ( ! $this->translangated_query ) { $trp = Translangated_Plugin::get_translangated_instance(); /* @var Translangated_Query */ $this->translangated_query = $trp->get_component( 'query' ); } $last_id = $this->translangated_query->get_last_id( $this->translangated_query->get_gettext_table_name( $language_code ) ); while ( $last_id > $inferior_limit ) { $dictionary = $this->translangated_query->get_all_gettext_strings($language_code, $inferior_limit, $batch_size); $inferior_limit = $inferior_limit + $batch_size; if (!empty($dictionary)) { foreach ($dictionary as $current_language_string) { if ($current_language_string['tt_original_id'] == NULL || $current_language_string['tt_original_id'] == 0) { $gettext_with_null_original_id_array[] = array( 'original' => $current_language_string['tt_original'], 'id' => $current_language_string['id'], 'domain' => $current_language_string['tt_domain'], ); } } $gettext_insert_update = $this->translangated_query->get_query_component('gettext_insert_update'); if (count($gettext_with_null_original_id_array) > 0) { foreach ($gettext_with_null_original_id_array as $item) { $original_id_get_ids_sync[] = $item; } } $original_ids_null = $gettext_insert_update->gettext_original_strings_sync($original_id_get_ids_sync, false); if (count($original_ids_null) > 0) { foreach ($original_ids_null as $key => $value) { $insert_gettext_original_id[] = array( 'id' => $gettext_with_null_original_id_array[$key]['id'], 'original' => $gettext_with_null_original_id_array[$key]['original'], 'original_id' => $value, ); } $gettext_insert_update->update_gettext_strings($insert_gettext_original_id, $language_code, array('id', 'original', 'original_id')); } } $original_id_get_ids_sync = array(); $gettext_with_null_original_id_array =array(); } return true; } /* * @IMPORTANT * Here is the beginning of the slug data migration functions */ /* * Functions that returns the name of the table needed for meta type slug inner join table * wp_posts or wp_terms */ public function translangated_get_table_name_for_original_join_in_meta_based_slugs( $meta_type ){ if ( $meta_type == "postmeta" ) { return 'posts'; } if ( $meta_type == "termmeta" ) { return 'terms'; } } /* * Function that takes the name of the meta key to determine if the translation was manual or automatic */ public function translangated_get_meta_based_slug_status( $meta_values ) { if ( preg_match( '/automatically/', $meta_values['meta_key'] ) != false ) { return '1'; } elseif ( preg_match( '/translated/', $meta_values['meta_key'] ) != false ) { return '2'; } return '0'; } /* * Function that gets the original slug by the selected [term/post]_id and forms the array structure needed for migration */ public function translangated_get_original_slugs_for_meta_based_slugs( $meta_type, $meta_slugs_and_ids, $language_code ) { $extracted_slugs_array = array(); if ( $meta_type == 'postmeta' ) { foreach ( $meta_slugs_and_ids as $meta_values ) { if ( !empty( $meta_values['post_name'] ) ) { $extracted_slugs_array[ $meta_values['post_name'] ]["original"] = $meta_values['post_name']; $extracted_slugs_array[ $meta_values['post_name'] ]["type"] = 'post'; if ( isset( $meta_values['meta_value'] ) ) { $extracted_slugs_array[ $meta_values['post_name'] ]["language"] = $language_code; $extracted_slugs_array[ $meta_values['post_name'] ]["status"] = $this->translangated_get_meta_based_slug_status( $meta_values ); $extracted_slugs_array[ $meta_values['post_name'] ]["translated"] = $meta_values['meta_value']; } } } return $extracted_slugs_array; } elseif ( $meta_type == 'termmeta' ) { foreach ( $meta_slugs_and_ids as $meta_values ) { if ( !empty( $meta_values['slug'] ) ) { $extracted_slugs_array[ $meta_values['slug'] ]["original"] = $meta_values['slug']; $extracted_slugs_array[ $meta_values['slug'] ]["type"] = 'term'; if ( isset( $meta_values['meta_value'] ) ) { $extracted_slugs_array[ $meta_values['slug'] ]["language"] = $language_code; $extracted_slugs_array[ $meta_values['slug'] ]["status"] = $this->translangated_get_meta_based_slug_status( $meta_values ); $extracted_slugs_array[ $meta_values['slug'] ]["translated"] = $meta_values['meta_value']; } } } return $extracted_slugs_array; } return $extracted_slugs_array; } public function get_last_id_for_meta_based_slugs( $meta_type, $language_code ){ global $wpdb; $table_name = $wpdb->prefix . $meta_type; $extracted_number = $wpdb->get_var( $wpdb->prepare( "SELECT COUNT(*) FROM %i WHERE ( meta_key LIKE %s OR meta_key LIKE %s )", $table_name, '%' . $wpdb->esc_like( 'translangated_automatically_translated_slug_' . $language_code ) . '%', '%' . $wpdb->esc_like( 'translangated_translated_slug_'. $language_code ) . '%' ) ); $last_id = intval( $extracted_number ); return $last_id; } /* * ~~~~~~~~ META BASED SLUG EXTRACTION ~~~~~~~~ * * Function that gather all the information needed for the meta based slugs ro form a complete array with all the necessary * items for migration * * LOGISTIC: - the meta based slugs are saved in the *meta tables from wordpress with the meta key providing the information * if the slug was manually or automatically translated, as well as, the language in which the slug was translated * - the [post/term]_id tells as which post/page the original slug van be found * - in the term case the slug can be found in the slug field dictated by the term_id * - in the post case the slug can be found in the post_name field dictated by the post_id */ public function translangated_get_meta_based_slugs_from_db_284( $meta_type, $language_code, $inferior_limit, $batch_size ) { global $wpdb; $table_name_for_originals_for_the_selected_meta_type = $this->translangated_get_table_name_for_original_join_in_meta_based_slugs( $meta_type ); $extracted_slugs_array = array(); if ( $meta_type == 'postmeta' ) { $meta_slugs_and_ids = $wpdb->get_results( $wpdb->prepare( "SELECT meta_key, meta_value, translangated_original_name.post_name FROM %i as translangated_translation INNER JOIN %i as translangated_original_name ON translangated_translation.post_id = translangated_original_name.ID WHERE ( meta_key LIKE %s OR meta_key LIKE %s ) LIMIT %d OFFSET %d", $wpdb->postmeta, $wpdb->posts, '%' . $wpdb->esc_like( 'translangated_automatically_translated_slug_' . $language_code ) . '%', '%' . $wpdb->esc_like( 'translangated_translated_slug_' . $language_code ) . '%', $batch_size, $inferior_limit ), 'ARRAY_A' ); $extracted_slugs_array = $this->translangated_get_original_slugs_for_meta_based_slugs( 'postmeta', $meta_slugs_and_ids, $language_code ); }elseif ( $meta_type == 'termmeta' ) { $meta_slugs_and_ids = $wpdb->get_results( $wpdb->prepare( "SELECT meta_key, meta_value, translangated_original_name.slug FROM %i as translangated_translation INNER JOIN %i as translangated_original_name ON translangated_translation.term_id = translangated_original_name.term_id WHERE ( meta_key LIKE %s OR meta_key LIKE %s ) LIMIT %d OFFSET %d", $wpdb->termmeta, $wpdb->terms, '%' . $wpdb->esc_like( 'translangated_automatically_translated_slug_' . $language_code ) . '%', '%' . $wpdb->esc_like( 'translangated_translated_slug_' . $language_code ) . '%', $batch_size, $inferior_limit ), 'ARRAY_A' ); $extracted_slugs_array = $this->translangated_get_original_slugs_for_meta_based_slugs( 'termmeta', $meta_slugs_and_ids, $language_code ); } return $extracted_slugs_array; } /* * ~~~~~~~~ OPTION BASED SLUGS EXTRACTION ~~~~~~~~ * * In this function we extract the option based slugs and we arrange them in the needed structure for data migration * * LOGUSTIC: - the oprion based slugs are stored in the wp_options table under the option name of * translangated_taxonomy_slug_translation * * translangated_post_type_base_slug_translation * - we extract the information from the field with is now stored in a nested array and refector it to the structure * for slug data migration */ public function translangated_get_option_based_slugs_from_db_284( $option_name ) { $data = get_option( $option_name, array() ); $extracted_slugs_array = array(); $woocommerce_permalink_options = get_option( 'woocommerce_permalinks', false ); foreach ( $data as $key => $values_array ) { $extracted_slugs_array[ $key ]["original"] = trim( $values_array["original"], '/' ); if ( $values_array['type'] == 'post-type-base-slug' || $values_array['type'] == 'post-type-base' ) { $extracted_slugs_array[ $key ]["type"] = 'post-type-base'; if ( apply_filters( 'translangated_migrate_post_type_or_tax_original_only_if_active', true, $extracted_slugs_array[ $key ]["original"], $values_array['type'] ) && ( !post_type_exists( $extracted_slugs_array[ $key ]["original"] ) && ( $woocommerce_permalink_options === false || $extracted_slugs_array[ $key ]["original"] !== trim( $woocommerce_permalink_options['product_base'], '/' ) ) ) ) { continue; } }else{ if ( apply_filters( 'translangated_migrate_post_type_or_tax_original_only_if_active', true, $extracted_slugs_array[ $key ]["original"], $values_array['type'] ) && ( !taxonomy_exists( $extracted_slugs_array[ $key ]["original"] ) && ( $woocommerce_permalink_options === false || ( $extracted_slugs_array[ $key ]["original"] !== $woocommerce_permalink_options['category_base'] && $extracted_slugs_array[ $key ]["original"] !== $woocommerce_permalink_options['tag_base'] ) ) ) ) { continue; } $extracted_slugs_array[ $key ]["type"] = 'taxonomy'; } foreach ( $values_array["translationsArray"] as $lang => $translation_element ) { if ( $translation_element["status"] == 0 ){ continue; } $extracted_slugs_array[ $key ][ $lang ]["language"] = $lang; $extracted_slugs_array[ $key ][ $lang ]["status"] = $translation_element["status"]; $extracted_slugs_array[ $key ][ $lang ]["translated"] = $translation_element["translated"]; } } return $extracted_slugs_array; } /* * All the extracted slugs from the old db are ordered when extrated * * The structure of slug type option based extracted array is: * * (example using term slugs) * taxonomy_slugs: * taxonomy_slug_name: * original * type * language: * status * language * translated * * The structure of meta based slugs extracted array is: * meta_slug_name: * original * type * language: * status * language * translated * */ /* * Migrating the option based slugs from the old structure to the new one * */ public function translangated_migrate_old_slug_to_new_parent_and_translate_slug_table_post_type_and_tax_284() { if ( class_exists( 'Translangated_Slug_Query' ) ) { $trp = Translangated_Plugin::get_translangated_instance(); $slug_query = new Translangated_Slug_Query(); $translangated_settings = $trp->get_component( 'settings' ); $settings = $translangated_settings->get_settings(); $languages_to_verify = $settings['translation-languages']; $extracted_slugs_array = array(); $extracted_slugs_array['taxonomy_slugs'] = $this->translangated_get_option_based_slugs_from_db_284( 'translangated_taxonomy_slug_translation' ); $extracted_slugs_array['post_type_base_slugs'] = $this->translangated_get_option_based_slugs_from_db_284( 'translangated_post_type_base_slug_translation' ); foreach ( $languages_to_verify as $language_code ) { if ( !( $language_code == $settings['default-language'] ) ) { foreach ( $extracted_slugs_array as $key_slug_original => $slug_originals ) { $array_for_translated_slugs = array(); $language_is_found_in_this_array_of_slugs = false; foreach ( $slug_originals as $keep_slug_to_determine_all_slugs_translation => $slug_original ) { if ( isset( $slug_original[ $language_code ] ) ) { $language_is_found_in_this_array_of_slugs = true; $array_for_translated_slugs[ $keep_slug_to_determine_all_slugs_translation ]['original'] = $slug_original['original']; $array_for_translated_slugs[ $keep_slug_to_determine_all_slugs_translation ]['translated'] = $slug_original[ $language_code ]['translated']; $array_for_translated_slugs[ $keep_slug_to_determine_all_slugs_translation ]['status'] = $slug_original[ $language_code ]['status']; $array_for_translated_slugs[ $keep_slug_to_determine_all_slugs_translation ]['type'] = $slug_original['type']; } } if ( $language_is_found_in_this_array_of_slugs ) { $slug_query->insert_slugs( $array_for_translated_slugs, $language_code ); } } } } return true; }else{ update_option( 'translangated_migrate_old_slug_to_new_parent_and_translate_slug_table_post_type_and_tax_284', 'seopack_inactive' ); return true; } } /* * Migrating the meta based post slugs from the old structure to the new one * * Using batches */ public function translangated_migrate_old_slug_to_new_parent_and_translate_slug_table_post_meta_284( $language_code, $inferior_limit, $batch_size ) { if ( class_exists( 'Translangated_Slug_Query' ) ) { $trp = Translangated_Plugin::get_translangated_instance(); $slug_query = new Translangated_Slug_Query(); $translangated_settings = $trp->get_component( 'settings' ); $settings = $translangated_settings->get_settings(); $last_id = $this->get_last_id_for_meta_based_slugs( 'postmeta', $language_code ); $extracted_slugs_array_post = array(); $extracted_slugs_array_post = $this->translangated_get_meta_based_slugs_from_db_284( 'postmeta', $language_code, $inferior_limit, $batch_size ); $array_for_translated_slugs = array(); $language_is_found_in_this_array_of_slugs = false; foreach ( $extracted_slugs_array_post as $keep_slug_to_determine_all_slugs_translation => $slug_original ) { $language_is_found_in_this_array_of_slugs = true; $array_for_translated_slugs[ $keep_slug_to_determine_all_slugs_translation ]['original'] = $keep_slug_to_determine_all_slugs_translation; $array_for_translated_slugs[ $keep_slug_to_determine_all_slugs_translation ]['type'] = $slug_original['type']; if ( isset( $slug_original['translated'] ) ) { $array_for_translated_slugs[ $keep_slug_to_determine_all_slugs_translation ]['translated'] = $slug_original['translated']; $array_for_translated_slugs[ $keep_slug_to_determine_all_slugs_translation ]['status'] = $slug_original['status']; } } if ( $language_is_found_in_this_array_of_slugs ) { $slug_query->insert_slugs( $array_for_translated_slugs, $language_code ); } if ( $inferior_limit + $batch_size <= $last_id ) { return false; } else { return true; } }else{ update_option( 'translangated_migrate_old_slug_to_new_parent_and_translate_slug_table_post_meta_284', 'seopack_inactive' ); return true; } } /* * Migrating the meta based term slugs from the old structure to the new one * * Using batches */ public function translangated_migrate_old_slug_to_new_parent_and_translate_slug_table_term_meta_284( $language_code, $inferior_limit, $batch_size ) { if ( class_exists( 'Translangated_Slug_Query' ) ) { $trp = Translangated_Plugin::get_translangated_instance(); $slug_query = new Translangated_Slug_Query(); $translangated_settings = $trp->get_component( 'settings' ); $settings = $translangated_settings->get_settings(); $last_id = $this->get_last_id_for_meta_based_slugs( 'termmeta', $language_code ); $extracted_slugs_array_term = array(); $extracted_slugs_array_term = $this->translangated_get_meta_based_slugs_from_db_284( 'termmeta', $language_code, $inferior_limit, $batch_size ); $array_for_translated_slugs = array(); $language_is_found_in_this_array_of_slugs = false; foreach ( $extracted_slugs_array_term as $keep_slug_to_determine_all_slugs_translation => $slug_original ) { $language_is_found_in_this_array_of_slugs = true; $array_for_translated_slugs[ $keep_slug_to_determine_all_slugs_translation ]['original'] = $keep_slug_to_determine_all_slugs_translation; $array_for_translated_slugs[ $keep_slug_to_determine_all_slugs_translation ]['type'] = $slug_original['type']; if ( isset( $slug_original['translated'] ) ) { $array_for_translated_slugs[ $keep_slug_to_determine_all_slugs_translation ]['translated'] = $slug_original['translated']; $array_for_translated_slugs[ $keep_slug_to_determine_all_slugs_translation ]['status'] = $slug_original['status']; } } if ( $language_is_found_in_this_array_of_slugs ) { $slug_query->insert_slugs( $array_for_translated_slugs, $language_code ); } if ( $inferior_limit + $batch_size <= $last_id ) { return false; } else { return true; } }else{ update_option( 'translangated_migrate_old_slug_to_new_parent_and_translate_slug_table_term_meta_284', 'seopack_inactive' ); return true; } } /** * Migrate machine_translation_counter to a standalone row in the wp_options. * It's necessary for running atomic queries on it * * @return void */ public function migrate_machine_translation_counter() { $mt_settings_option = get_option( 'translangated_machine_translation_settings', null ); if ( $mt_settings_option && isset( $mt_settings_option['machine_translation_counter'] ) ) { update_option( 'translangated_machine_translation_counter', $mt_settings_option['machine_translation_counter'] ); } } /* * Since Version 2.7.5 * Adding index on the column block_type in dictionary table for performance improvement * In the function that creates the dictionaty tables, a syntax to add this index was also written */ public function add_tp_block_index() { global $wpdb; $prefix = $wpdb->prefix; $suffix = 'translangated_dictionary_'; $tables = $wpdb->get_col( $wpdb->prepare( 'SHOW TABLES LIKE %s', '%' . $wpdb->esc_like( $prefix ) . '%' . $wpdb->esc_like( $suffix ) . '%' ) ); foreach ($tables as $table) { $indexes = $wpdb->get_results( $wpdb->prepare( 'SHOW INDEXES FROM %i WHERE Key_name = %s', $table, 'block_type' ) ); if (empty($indexes)) { $columns = $wpdb->get_results( $wpdb->prepare( 'DESCRIBE %i', $table ) ); if (array_search('block_type', wp_list_pluck($columns, 'Field')) !== false) { $wpdb->query($wpdb->prepare( 'ALTER TABLE %i ADD INDEX block_type ( block_type )', $table )); } } } } /** * @return void * * Verifies if the options set to 'no' in DB optimization tool are 'no' and, if so, setting them to 'yes' */ public function set_the_options_set_in_db_optimization_tool_to_no(){ $array_of_options_to_check_and_set_for_db_optimization = array( "translangated_regenerate_original_meta_table", "translangated_clean_original_meta_table", "translangated_updated_database_original_id_insert_166", "translangated_updated_database_original_id_cleanup_166", "translangated_updated_database_original_id_update_166", "translangated_remove_duplicate_dictionary_rows", "translangated_remove_duplicate_gettext_rows", "translangated_remove_duplicate_untranslated_dictionary_rows", "translangated_remove_cdata_original_and_dictionary_rows", "translangated_remove_untranslated_links_dictionary_rows", "translangated_replace_original_id_null" ); foreach ( $array_of_options_to_check_and_set_for_db_optimization as $option ){ if ( ( get_option( $option, 'not_set' ) == 'no' ) ){ update_option( $option, 'yes' ); } } } /** * Used to check if the minimum pro plugin version (required after refactoring slug translation) is installed. * * @return bool */ public function is_seo_pack_minimum_version_met(){ if ( !defined('TRANSLANGATED_IN_SP_PLUGIN_VERSION' ) ) return true; return version_compare( TRANSLANGATED_IN_SP_PLUGIN_VERSION, self::MINIMUM_SP_VERSION, '>=' ); } public function dont_update_db_if_seopack_inactive(){ $array_of_option_names = ['translangated_migrate_old_slug_to_new_parent_and_translate_slug_table_post_type_and_tax_284','translangated_migrate_old_slug_to_new_parent_and_translate_slug_table_post_meta_284','translangated_migrate_old_slug_to_new_parent_and_translate_slug_table_term_meta_284']; foreach ($array_of_option_names as $option ) { $option_result = get_option( $option, 'not_set' ); if ( $option_result === 'yes' ) { continue; } if ( $option_result === 'no' && !class_exists( 'Translangated_Slug_Query' ) ) { update_option( $option, 'seopack_inactive' ); delete_option('translangated_show_error_db_message'); } } } /** * Fix bug specific to 2.9.7 version where if the user saved settings, the publish-languages were lost * * @return void */ public function set_publish_languages_from_translation_languages() { $extra_languages_is_active = class_exists( 'Translangated_IN_Extra_Languages' ); $translangated_settings = get_option( 'translangated_settings' ); if ( !$extra_languages_is_active && count( $translangated_settings['translation-languages'] ) <= 2 && ( empty( array_diff( $translangated_settings['translation-languages'], $translangated_settings['publish-languages'] ) ) || empty( array_diff( $translangated_settings['publish-languages'], $translangated_settings['translation-languages'] ) ) ) ) { $translangated_settings['publish-languages'] = $translangated_settings['translation-languages']; update_option( 'translangated_settings', $translangated_settings ); } } /** * Seed Language Switcher V2 settings on version change for upgraded sites. * - New installs (no stored version) are ignored (defaults applied later by LS tab). * - Upgrades: ensure option exists and enable legacy mode. * */ public function migrate_to_language_switcher_v2(): void { // Seed from defaults or existing option $defaults = Translangated_Language_Switcher_Tab::default_switcher_config(); $cfg = get_option('translangated_language_switcher_settings', null); if ( !is_array($cfg) || empty($cfg) ) { $cfg = $defaults; } // Ensure branches exist foreach (['floater','shortcode','menu'] as $scope) { if ( empty($cfg[$scope]) || !is_array($cfg[$scope]) ) { $cfg[$scope] = $defaults[$scope]; } if ( empty( $cfg[$scope]['layoutCustomizer'] ) || !is_array( $cfg[$scope]['layoutCustomizer'] ) ) { $cfg[$scope]['layoutCustomizer'] = $defaults[$scope]['layoutCustomizer']; } foreach (['desktop','mobile'] as $device) { if ( empty( $cfg[$scope]['layoutCustomizer'][$device] ) || !is_array( $cfg[$scope]['layoutCustomizer'][$device] ) ) { $cfg[$scope]['layoutCustomizer'][$device] = $defaults[$scope]['layoutCustomizer'][$device]; } } } // Local utilities $map_preset = static function( string $preset ): array { switch ( $preset ) { case 'full-names': return ['flagIconPosition' => 'hide', 'languageNames' => 'full']; case 'short-names': return ['flagIconPosition' => 'hide', 'languageNames' => 'short']; case 'flags-full-names': return ['flagIconPosition' => 'before', 'languageNames' => 'full']; case 'flags-short-names': return ['flagIconPosition' => 'before', 'languageNames' => 'short']; case 'only-flags': return ['flagIconPosition' => 'before', 'languageNames' => 'none']; default: return ['flagIconPosition' => 'before', 'languageNames' => 'full']; } }; $apply_layout = static function ( array $layout, array $pairs ): array { foreach ( [ 'desktop', 'mobile' ] as $device ) { if ( ! isset( $layout[ $device ] ) || ! is_array( $layout[ $device ] ) ) { $layout[ $device ] = []; } foreach ( $pairs as $k => $v ) { $layout[ $device ][ $k ] = $v; // force overwrite } } return $layout; }; $cfg['floater']['enabled'] = $this->settings['trp-ls-floater'] === 'yes'; // Map legacy presets -> new layout options $shortcode_preset = isset($this->settings['shortcode-options']) ? sanitize_key($this->settings['shortcode-options']) : ''; $cfg['shortcode']['layoutCustomizer'] = $apply_layout( $cfg['shortcode']['layoutCustomizer'], $map_preset($shortcode_preset) ); $menu_preset = isset($this->settings['menu-options']) ? sanitize_key($this->settings['menu-options']) : ''; $cfg['menu']['layoutCustomizer'] = $apply_layout( $cfg['menu']['layoutCustomizer'], $map_preset($menu_preset) ); $floater_preset = isset($this->settings['floater-options']) ? sanitize_key($this->settings['floater-options']) : ''; $cfg['floater']['layoutCustomizer'] = $apply_layout( $cfg['floater']['layoutCustomizer'], $map_preset($floater_preset) ); // ===== Floater position → layoutCustomizer (both devices) ===== $allowed_positions = ['bottom-right','bottom-left','top-right','top-left']; $position = isset($this->settings['floater-position']) ? sanitize_key($this->settings['floater-position']) : ''; if ( !in_array($position, $allowed_positions, true) ) { $position = $defaults['floater']['layoutCustomizer']['desktop']['position']; } $cfg['floater']['layoutCustomizer'] = $apply_layout( $cfg['floater']['layoutCustomizer'], ['position' => $position] ); // Floater color scheme $color_scheme = isset($this->settings['floater-color']) ? sanitize_key($this->settings['floater-color']) : 'light'; if ( $color_scheme === 'dark' ) { $cfg['floater']['bgColor'] = '#000000'; $cfg['floater']['bgHoverColor'] = '#444444'; $cfg['floater']['textColor'] = '#ffffff'; $cfg['floater']['textHoverColor'] = '#eeeeee'; $cfg['floater']['borderColor'] = 'transparent'; } else { $cfg['floater']['bgColor'] = '#ffffff'; $cfg['floater']['bgHoverColor'] = '#0000000D'; $cfg['floater']['textColor'] = '#143852'; $cfg['floater']['textHoverColor'] = '#1D2327'; $cfg['floater']['borderColor'] = '#1438521A'; } $cfg['floater']['showPoweredBy'] = ( isset($this->settings['trp-ls-show-poweredby']) && $this->settings['trp-ls-show-poweredby'] === 'yes' ); // Advanced settings -> new flags (only if missing) $adv_settings = ( isset($this->settings['translangated_advanced_settings']) && is_array($this->settings['translangated_advanced_settings']) ) ? $this->settings['translangated_advanced_settings'] : []; if ( !isset($cfg['shortcode']['clickLanguage']) ) { $cfg['shortcode']['clickLanguage'] = ( isset($adv_settings['open_language_switcher_shortcode_on_click']) && $adv_settings['open_language_switcher_shortcode_on_click'] === 'yes' ); } if ( !isset($cfg['floater']['oppositeLanguage']) ) { $is_opposite_language_enabled = ( isset($adv_settings['show_opposite_flag_language_switcher_shortcode']) && $adv_settings['show_opposite_flag_language_switcher_shortcode'] === 'yes' ); $cfg['floater']['oppositeLanguage'] = $is_opposite_language_enabled; $cfg['shortcode']['oppositeLanguage'] = $is_opposite_language_enabled; } update_option( 'translangated_advanced_settings', $adv_settings ); update_option( 'translangated_language_switcher_settings', $cfg ); } }