wpdb = $wpdb; } public function run() { $this->wpdb->query( "DROP TABLE IF EXISTS `{$this->wpdb->prefix}icl_string_pages`" ); $this->wpdb->query( "DROP TABLE IF EXISTS `{$this->wpdb->prefix}icl_string_urls`" ); $charset_collate = $this->get_charset_collate(); $language_data = $this->get_language_charset_and_collation(); $language_data = 'CHARACTER SET ' . $language_data['charset'] . ' COLLATE ' . $language_data['collation']; $this->icl_string_urls_sql = sprintf( $this->icl_string_urls_sql, $this->wpdb->prefix, $language_data ); $this->icl_string_urls_sql .= $charset_collate; $result = $this->wpdb->query( $this->icl_string_urls_sql ); if ( $result ) { $this->icl_string_pages_sql = sprintf( $this->icl_string_pages_sql, $this->wpdb->prefix ); $this->icl_string_pages_sql .= $charset_collate; $result = $this->wpdb->query( $this->icl_string_pages_sql ); } return false !== $result; } public function run_ajax() { return $this->run(); } public function run_frontend() { } /** * @return string */ public static function get_command_id() { return __CLASS__ . '_2.4.2_1'; } /** * @return string */ private function get_charset_collate() { $charset_collate = ''; if ( method_exists( $this->wpdb, 'has_cap' ) && $this->wpdb->has_cap( 'collation' ) ) { $charset_collate = $this->wpdb->get_charset_collate(); } return $charset_collate; } private function get_language_charset_and_collation() { $data = null; $column_data = $this->wpdb->get_results( "SELECT * FROM INFORMATION_SCHEMA.COLUMNS where TABLE_NAME='{$this->wpdb->prefix}icl_strings' AND TABLE_SCHEMA='{$this->wpdb->dbname}' "); foreach ( $column_data as $column ) { if ( 'language' === $column->COLUMN_NAME ) { $data['collation'] = $column->COLLATION_NAME; $data['charset'] = $column->CHARACTER_SET_NAME; } } return $data; } }