| @@ -27,19 +27,19 @@ | ||
| 27 | 27 | * @param array $args |
| 28 | 28 | * @return bool true if success / false if failed |
| 29 | 29 | */ |
| 30 | 30 | public function add_language( $args ) { |
| 31 | - $errors = $this->validate_lang( $args ); | |
| 32 | - if ( $errors->get_error_code() ) { // Using has_errors() would be more meaningful but is available only since WP 5.0 | |
| 33 | - return $errors; | |
| 31 | + if ( ! $this->validate_lang( $args ) ) { | |
| 32 | + return false; | |
| 34 | 33 | } |
| 35 | 34 | |
| 36 | 35 | // First the language taxonomy |
| 37 | - $description = maybe_serialize( array( 'locale' => $args['locale'], 'rtl' => (int) $args['rtl'], 'flag_code' => empty( $args['flag'] ) ? '' : $args['flag'] ) ); | |
| 36 | + $description = serialize( array( 'locale' => $args['locale'], 'rtl' => (int) $args['rtl'], 'flag_code' => empty( $args['flag'] ) ? '' : $args['flag'] ) ); | |
| 38 | 37 | $r = wp_insert_term( $args['name'], 'language', array( 'slug' => $args['slug'], 'description' => $description ) ); |
| 39 | 38 | if ( is_wp_error( $r ) ) { |
| 40 | 39 | // Avoid an ugly fatal error if something went wrong ( reported once in the forum ) |
| 41 | - return new WP_Error( 'pll_add_language', __( 'Impossible to add the language.', 'polylang' ) ); | |
| 40 | + add_settings_error( 'general', 'pll_add_language', __( 'Impossible to add the language.', 'polylang' ) ); | |
| 41 | + return false; | |
| 42 | 42 | } |
| 43 | 43 | wp_update_term( (int) $r['term_id'], 'language', array( 'term_group' => (int) $args['term_group'] ) ); // can't set the term group directly in wp_insert_term |
| 44 | 44 | |
| 45 | 45 | // The term_language taxonomy |
| @@ -45,9 +45,9 @@ | ||
| 45 | 45 | // The term_language taxonomy |
| 46 | 46 | // Don't want shared terms so use a different slug |
| 47 | 47 | wp_insert_term( $args['name'], 'term_language', array( 'slug' => 'pll_' . $args['slug'] ) ); |
| 48 | 48 | |
| 49 | - $this->clean_languages_cache(); // Update the languages list now ! | |
| 49 | + $this->clean_languages_cache(); // Udpate the languages list now ! | |
| 50 | 50 | |
| 51 | 51 | if ( ! isset( $this->options['default_lang'] ) ) { |
| 52 | 52 | // If this is the first language created, set it as default language |
| 53 | 53 | $this->options['default_lang'] = $args['slug']; |
| @@ -73,8 +73,10 @@ | ||
| 73 | 73 | do_action( 'pll_add_language', $args ); |
| 74 | 74 | |
| 75 | 75 | $this->clean_languages_cache(); // Again to set add mo_id in the cached languages list |
| 76 | 76 | flush_rewrite_rules(); // Refresh rewrite rules |
| 77 | + | |
| 78 | + add_settings_error( 'general', 'pll_languages_created', __( 'Language added.', 'polylang' ), 'updated' ); | |
| 77 | 79 | return true; |
| 78 | 80 | } |
| 79 | 81 | |
| 80 | 82 | /** |
| @@ -87,9 +89,9 @@ | ||
| 87 | 89 | public function delete_language( $lang_id ) { |
| 88 | 90 | $lang = $this->get_language( (int) $lang_id ); |
| 89 | 91 | |
| 90 | 92 | if ( empty( $lang ) ) { |
| 91 | - return false; | |
| 93 | + return; | |
| 92 | 94 | } |
| 93 | 95 | |
| 94 | 96 | // Oops ! we are deleting the default language... |
| 95 | 97 | // Need to do this before loosing the information for default category translations |
| @@ -124,9 +126,9 @@ | ||
| 124 | 126 | |
| 125 | 127 | // Delete menus locations |
| 126 | 128 | if ( ! empty( $this->options['nav_menus'] ) ) { |
| 127 | 129 | foreach ( $this->options['nav_menus'] as $theme => $locations ) { |
| 128 | - foreach ( array_keys( $locations ) as $location ) { | |
| 130 | + foreach ( $locations as $location => $languages ) { | |
| 129 | 131 | unset( $this->options['nav_menus'][ $theme ][ $location ][ $lang->slug ] ); |
| 130 | 132 | } |
| 131 | 133 | } |
| 132 | 134 | } |
| @@ -133,9 +135,9 @@ | ||
| 133 | 135 | |
| 134 | 136 | // Delete users options |
| 135 | 137 | foreach ( get_users( array( 'fields' => 'ID' ) ) as $user_id ) { |
| 136 | 138 | delete_user_meta( $user_id, 'pll_filter_content', $lang->slug ); |
| 137 | - delete_user_meta( $user_id, 'description_' . $lang->slug ); | |
| 139 | + delete_user_meta( $user_id, 'description_'.$lang->slug ); | |
| 138 | 140 | } |
| 139 | 141 | |
| 140 | 142 | // Delete the string translations |
| 141 | 143 | $post = wpcom_vip_get_page_by_title( 'polylang_mo_' . $lang->term_id, OBJECT, 'polylang_mo' ); |
| @@ -154,9 +156,9 @@ | ||
| 154 | 156 | $this->clean_languages_cache(); |
| 155 | 157 | |
| 156 | 158 | update_option( 'polylang', $this->options ); |
| 157 | 159 | flush_rewrite_rules(); // refresh rewrite rules |
| 158 | - return true; | |
| 160 | + add_settings_error( 'general', 'pll_languages_deleted', __( 'Language deleted.', 'polylang' ), 'updated' ); | |
| 159 | 161 | } |
| 160 | 162 | |
| 161 | 163 | /** |
| 162 | 164 | * Update language properties |
| @@ -178,12 +180,10 @@ | ||
| 178 | 180 | * @return bool true if success / false if failed |
| 179 | 181 | */ |
| 180 | 182 | public function update_language( $args ) { |
| 181 | 183 | $lang = $this->get_language( (int) $args['lang_id'] ); |
| 182 | - | |
| 183 | - $errors = $this->validate_lang( $args, $lang ); | |
| 184 | - if ( $errors->get_error_code() ) { // Using has_errors() would be more meaningful but is available only since WP 5.0 | |
| 185 | - return $errors; | |
| 184 | + if ( ! $this->validate_lang( $args, $lang ) ) { | |
| 185 | + return false; | |
| 186 | 186 | } |
| 187 | 187 | |
| 188 | 188 | // Update links to this language in posts and terms in case the slug has been modified |
| 189 | 189 | $slug = $args['slug']; |
| @@ -210,9 +210,9 @@ | ||
| 210 | 210 | |
| 211 | 211 | // Update menus locations |
| 212 | 212 | if ( ! empty( $this->options['nav_menus'] ) ) { |
| 213 | 213 | foreach ( $this->options['nav_menus'] as $theme => $locations ) { |
| 214 | - foreach ( array_keys( $locations ) as $location ) { | |
| 214 | + foreach ( $locations as $location => $languages ) { | |
| 215 | 215 | if ( ! empty( $this->options['nav_menus'][ $theme ][ $location ][ $old_slug ] ) ) { |
| 216 | 216 | $this->options['nav_menus'][ $theme ][ $location ][ $slug ] = $this->options['nav_menus'][ $theme ][ $location ][ $old_slug ]; |
| 217 | 217 | unset( $this->options['nav_menus'][ $theme ][ $location ][ $old_slug ] ); |
| 218 | 218 | } |
| @@ -234,9 +234,9 @@ | ||
| 234 | 234 | |
| 235 | 235 | update_option( 'polylang', $this->options ); |
| 236 | 236 | |
| 237 | 237 | // And finally update the language itself |
| 238 | - $description = maybe_serialize( array( 'locale' => $args['locale'], 'rtl' => (int) $args['rtl'], 'flag_code' => empty( $args['flag'] ) ? '' : $args['flag'] ) ); | |
| 238 | + $description = serialize( array( 'locale' => $args['locale'], 'rtl' => (int) $args['rtl'], 'flag_code' => empty( $args['flag'] ) ? '' : $args['flag'] ) ); | |
| 239 | 239 | wp_update_term( (int) $lang->term_id, 'language', array( 'slug' => $slug, 'name' => $args['name'], 'description' => $description, 'term_group' => (int) $args['term_group'] ) ); |
| 240 | 240 | wp_update_term( (int) $lang->tl_term_id, 'term_language', array( 'slug' => 'pll_' . $slug, 'name' => $args['name'] ) ); |
| 241 | 241 | |
| 242 | 242 | /** |
| @@ -249,14 +249,14 @@ | ||
| 249 | 249 | do_action( 'pll_update_language', $args ); |
| 250 | 250 | |
| 251 | 251 | $this->clean_languages_cache(); |
| 252 | 252 | flush_rewrite_rules(); // Refresh rewrite rules |
| 253 | + add_settings_error( 'general', 'pll_languages_updated', __( 'Language updated.', 'polylang' ), 'updated' ); | |
| 253 | 254 | return true; |
| 254 | 255 | } |
| 255 | 256 | |
| 256 | 257 | /** |
| 257 | 258 | * Validates data entered when creating or updating a language |
| 258 | - * | |
| 259 | 259 | * @see PLL_Admin_Model::add_language |
| 260 | 260 | * |
| 261 | 261 | * @since 0.4 |
| 262 | 262 | * |
| @@ -264,47 +264,35 @@ | ||
| 264 | 264 | * @param object $lang optional the language currently updated, the language is created if not set |
| 265 | 265 | * @return bool true if success / false if failed |
| 266 | 266 | */ |
| 267 | 267 | protected function validate_lang( $args, $lang = null ) { |
| 268 | - $errors = new WP_Error(); | |
| 269 | - | |
| 270 | 268 | // Validate locale with the same pattern as WP 4.3. See #28303 |
| 271 | 269 | if ( ! preg_match( '#^[a-z]{2,3}(?:_[A-Z]{2})?(?:_[a-z0-9]+)?$#', $args['locale'], $matches ) ) { |
| 272 | - $errors->add( 'pll_invalid_locale', __( 'Enter a valid WordPress locale', 'polylang' ) ); | |
| 270 | + add_settings_error( 'general', 'pll_invalid_locale', __( 'Enter a valid WordPress locale', 'polylang' ) ); | |
| 273 | 271 | } |
| 274 | 272 | |
| 275 | 273 | // Validate slug characters |
| 276 | 274 | if ( ! preg_match( '#^[a-z_-]+$#', $args['slug'] ) ) { |
| 277 | - $errors->add( 'pll_invalid_slug', __( 'The language code contains invalid characters', 'polylang' ) ); | |
| 275 | + add_settings_error( 'general', 'pll_invalid_slug', __( 'The language code contains invalid characters', 'polylang' ) ); | |
| 278 | 276 | } |
| 279 | 277 | |
| 280 | 278 | // Validate slug is unique |
| 281 | - foreach ( $this->get_languages_list() as $language ) { | |
| 282 | - if ( $language->slug === $args['slug'] && ( null === $lang || ( isset( $lang ) && $lang->term_id != $language->term_id ) ) ) { | |
| 283 | - $errors->add( 'pll_non_unique_slug', __( 'The language code must be unique', 'polylang' ) ); | |
| 284 | - } | |
| 279 | + if ( $this->get_language( $args['slug'] ) && ( null === $lang || ( isset( $lang ) && $lang->slug != $args['slug'] ) ) ) { | |
| 280 | + add_settings_error( 'general', 'pll_non_unique_slug', __( 'The language code must be unique', 'polylang' ) ); | |
| 285 | 281 | } |
| 286 | 282 | |
| 287 | 283 | // Validate name |
| 288 | 284 | // No need to sanitize it as wp_insert_term will do it for us |
| 289 | 285 | if ( empty( $args['name'] ) ) { |
| 290 | - $errors->add( 'pll_invalid_name', __( 'The language must have a name', 'polylang' ) ); | |
| 286 | + add_settings_error( 'general', 'pll_invalid_name', __( 'The language must have a name', 'polylang' ) ); | |
| 291 | 287 | } |
| 292 | 288 | |
| 293 | 289 | // Validate flag |
| 294 | 290 | if ( ! empty( $args['flag'] ) && ! file_exists( POLYLANG_DIR . '/flags/' . $args['flag'] . '.png' ) ) { |
| 295 | - $flag = PLL_Language::get_flag_informations( $args['flag'] ); | |
| 296 | - | |
| 297 | - if ( ! empty( $flag['url'] ) ) { | |
| 298 | - $response = function_exists( 'vip_safe_wp_remote_get' ) ? vip_safe_wp_remote_get( esc_url_raw( $flag['url'] ) ) : wp_remote_get( esc_url_raw( $flag['url'] ) ); | |
| 299 | - } | |
| 300 | - | |
| 301 | - if ( empty( $response ) || is_wp_error( $response ) || 200 !== wp_remote_retrieve_response_code( $response ) ) { | |
| 302 | - $errors->add( 'pll_invalid_flag', __( 'The flag does not exist', 'polylang' ) ); | |
| 303 | - } | |
| 291 | + add_settings_error( 'general', 'pll_invalid_flag', __( 'The flag does not exist', 'polylang' ) ); | |
| 304 | 292 | } |
| 305 | 293 | |
| 306 | - return $errors; | |
| 294 | + return get_settings_errors() ? false : true; | |
| 307 | 295 | } |
| 308 | 296 | |
| 309 | 297 | /** |
| 310 | 298 | * Used to set the language of posts or terms in mass |
| @@ -317,12 +305,11 @@ | ||
| 317 | 305 | */ |
| 318 | 306 | public function set_language_in_mass( $type, $ids, $lang ) { |
| 319 | 307 | global $wpdb; |
| 320 | 308 | |
| 321 | - $ids = array_map( 'intval', $ids ); | |
| 322 | - $lang = $this->get_language( $lang ); | |
| 323 | - $tt_id = 'term' === $type ? $lang->tl_term_taxonomy_id : $lang->term_taxonomy_id; | |
| 324 | - $values = array(); | |
| 309 | + $ids = array_map( 'intval', $ids ); | |
| 310 | + $lang = $this->get_language( $lang ); | |
| 311 | + $tt_id = 'term' == $type ? $lang->tl_term_taxonomy_id : $lang->term_taxonomy_id; | |
| 325 | 312 | |
| 326 | 313 | foreach ( $ids as $id ) { |
| 327 | 314 | $values[] = $wpdb->prepare( '( %d, %d )', $id, $tt_id ); |
| 328 | 315 | } |
| @@ -327,17 +314,14 @@ | ||
| 327 | 314 | $values[] = $wpdb->prepare( '( %d, %d )', $id, $tt_id ); |
| 328 | 315 | } |
| 329 | 316 | |
| 330 | 317 | if ( ! empty( $values ) ) { |
| 331 | - // PHPCS:ignore WordPress.DB.PreparedSQL.NotPrepared | |
| 332 | - $wpdb->query( "INSERT INTO {$wpdb->term_relationships} ( object_id, term_taxonomy_id ) VALUES " . implode( ',', array_unique( $values ) ) ); | |
| 318 | + $values = array_unique( $values ); | |
| 319 | + $wpdb->query( "INSERT INTO $wpdb->term_relationships ( object_id, term_taxonomy_id ) VALUES " . implode( ',', $values ) ); | |
| 333 | 320 | $lang->update_count(); // Updating term count is mandatory ( thanks to AndyDeGroo ) |
| 334 | 321 | } |
| 335 | 322 | |
| 336 | - if ( 'term' === $type ) { | |
| 337 | - clean_term_cache( $ids, 'term_language' ); | |
| 338 | - $translations = array(); | |
| 339 | - | |
| 323 | + if ( 'term' == $type ) { | |
| 340 | 324 | foreach ( $ids as $id ) { |
| 341 | 325 | $translations[] = array( $lang->slug => $id ); |
| 342 | 326 | } |
| 343 | 327 | |
| @@ -343,10 +327,8 @@ | ||
| 343 | 327 | |
| 344 | 328 | if ( ! empty( $translations ) ) { |
| 345 | 329 | $this->set_translation_in_mass( 'term', $translations ); |
| 346 | 330 | } |
| 347 | - } else { | |
| 348 | - clean_term_cache( $ids, 'language' ); | |
| 349 | 331 | } |
| 350 | 332 | } |
| 351 | 333 | |
| 352 | 334 | /** |
| @@ -359,53 +341,42 @@ | ||
| 359 | 341 | */ |
| 360 | 342 | public function set_translation_in_mass( $type, $translations ) { |
| 361 | 343 | global $wpdb; |
| 362 | 344 | |
| 363 | - $taxonomy = $type . '_translations'; | |
| 364 | - $terms = array(); | |
| 365 | - $slugs = array(); | |
| 366 | - $description = array(); | |
| 367 | - $count = array(); | |
| 368 | - | |
| 369 | 345 | foreach ( $translations as $t ) { |
| 370 | 346 | $term = uniqid( 'pll_' ); // the term name |
| 371 | - $terms[] = $wpdb->prepare( '( %s, %s )', $term, $term ); | |
| 372 | - $slugs[] = $wpdb->prepare( '%s', $term ); | |
| 373 | - $description[ $term ] = maybe_serialize( $t ); | |
| 347 | + $terms[] = $wpdb->prepare( '( "%1$s", "%1$s" )', $term ); | |
| 348 | + $slugs[] = $wpdb->prepare( '"%s"', $term ); | |
| 349 | + $description[ $term ] = serialize( $t ); | |
| 374 | 350 | $count[ $term ] = count( $t ); |
| 375 | 351 | } |
| 376 | 352 | |
| 377 | 353 | // Insert terms |
| 378 | 354 | if ( ! empty( $terms ) ) { |
| 379 | - // PHPCS:ignore WordPress.DB.PreparedSQL.NotPrepared | |
| 380 | - $wpdb->query( "INSERT INTO {$wpdb->terms} ( slug, name ) VALUES " . implode( ',', array_unique( $terms ) ) ); | |
| 355 | + $terms = array_unique( $terms ); | |
| 356 | + $wpdb->query( "INSERT INTO $wpdb->terms ( slug, name ) VALUES " . implode( ',', $terms ) ); | |
| 381 | 357 | } |
| 382 | 358 | |
| 383 | 359 | // Get all terms with their term_id |
| 384 | - // PHPCS:ignore WordPress.DB.PreparedSQL.NotPrepared | |
| 385 | - $terms = $wpdb->get_results( "SELECT term_id, slug FROM {$wpdb->terms} WHERE slug IN ( " . implode( ',', $slugs ) . ' )' ); | |
| 386 | - $term_ids = array(); | |
| 387 | - $tts = array(); | |
| 360 | + $terms = $wpdb->get_results( "SELECT term_id, slug FROM $wpdb->terms WHERE slug IN ( " . implode( ',', $slugs ) . " )" ); | |
| 388 | 361 | |
| 389 | 362 | // Prepare terms taxonomy relationship |
| 390 | 363 | foreach ( $terms as $term ) { |
| 391 | - $term_ids[] = $term->term_id; | |
| 392 | - $tts[] = $wpdb->prepare( '( %d, %s, %s, %d )', $term->term_id, $taxonomy, $description[ $term->slug ], $count[ $term->slug ] ); | |
| 364 | + $tts[] = $wpdb->prepare( '( %d, "%s", "%s", %d )', $term->term_id, $type . '_translations', $description[ $term->slug ], $count[ $term->slug ] ); | |
| 393 | 365 | } |
| 394 | 366 | |
| 395 | 367 | // Insert term_taxonomy |
| 396 | 368 | if ( ! empty( $tts ) ) { |
| 397 | - // PHPCS:ignore WordPress.DB.PreparedSQL.NotPrepared | |
| 398 | - $wpdb->query( "INSERT INTO {$wpdb->term_taxonomy} ( term_id, taxonomy, description, count ) VALUES " . implode( ',', array_unique( $tts ) ) ); | |
| 369 | + $tts = array_unique( $tts ); | |
| 370 | + $wpdb->query( "INSERT INTO $wpdb->term_taxonomy ( term_id, taxonomy, description, count ) VALUES " . implode( ',', $tts ) ); | |
| 399 | 371 | } |
| 400 | 372 | |
| 401 | 373 | // Get all terms with term_taxonomy_id |
| 402 | - $terms = get_terms( $taxonomy, array( 'hide_empty' => false ) ); | |
| 403 | - $trs = array(); | |
| 374 | + $terms = get_terms( $type . '_translations', array( 'hide_empty' => false ) ); | |
| 404 | 375 | |
| 405 | 376 | // Prepare objects relationships |
| 406 | 377 | foreach ( $terms as $term ) { |
| 407 | - $t = maybe_unserialize( $term->description ); | |
| 378 | + $t = unserialize( $term->description ); | |
| 408 | 379 | if ( in_array( $t, $translations ) ) { |
| 409 | 380 | foreach ( $t as $object_id ) { |
| 410 | 381 | if ( ! empty( $object_id ) ) { |
| 411 | 382 | $trs[] = $wpdb->prepare( '( %d, %d )', $object_id, $term->term_taxonomy_id ); |
| @@ -415,72 +386,40 @@ | ||
| 415 | 386 | } |
| 416 | 387 | |
| 417 | 388 | // Insert term_relationships |
| 418 | 389 | if ( ! empty( $trs ) ) { |
| 419 | - // PHPCS:ignore WordPress.DB.PreparedSQL.NotPrepared | |
| 420 | - $wpdb->query( "INSERT INTO {$wpdb->term_relationships} ( object_id, term_taxonomy_id ) VALUES " . implode( ',', $trs ) ); | |
| 390 | + $wpdb->query( "INSERT INTO $wpdb->term_relationships ( object_id, term_taxonomy_id ) VALUES " . implode( ',', $trs ) ); | |
| 421 | 391 | $trs = array_unique( $trs ); |
| 422 | 392 | } |
| 423 | - | |
| 424 | - clean_term_cache( $term_ids, $taxonomy ); | |
| 425 | 393 | } |
| 426 | 394 | |
| 427 | 395 | /** |
| 428 | - * Returns untranslated posts and terms ids ( used in settings ) | |
| 396 | + * Returns unstranslated posts and terms ids ( used in settings ) | |
| 429 | 397 | * |
| 430 | 398 | * @since 0.9 |
| 431 | - * @since 2.2.6 Add the $limit argument | |
| 432 | 399 | * |
| 433 | - * @param in $limit Max number of posts or terms to return. Defaults to -1 (no limit). | |
| 434 | - * @return array Array made of an array of post ids and an array of term ids | |
| 400 | + * @return array array made of an array of post ids and an array of term ids | |
| 435 | 401 | */ |
| 436 | - public function get_objects_with_no_lang( $limit = -1 ) { | |
| 437 | - global $wpdb; | |
| 402 | + public function get_objects_with_no_lang() { | |
| 403 | + $posts = get_posts( array( | |
| 404 | + 'numberposts' => -1, | |
| 405 | + 'nopaging' => true, | |
| 406 | + 'post_type' => $this->get_translated_post_types(), | |
| 407 | + 'post_status' => 'any', | |
| 408 | + 'fields' => 'ids', | |
| 409 | + 'tax_query' => array( array( | |
| 410 | + 'taxonomy' => 'language', | |
| 411 | + 'terms' => $this->get_languages_list( array( 'fields' => 'term_id' ) ), | |
| 412 | + 'operator' => 'NOT IN', | |
| 413 | + ) ) | |
| 414 | + ) ); | |
| 438 | 415 | |
| 439 | - /** | |
| 440 | - * Filters the max number of posts or terms to return when searching objects with no language | |
| 441 | - * This filter can be used to decrease the memory usage in case the number of objects | |
| 442 | - * without language is too big. Using a negative value is equivalent to have no limit. | |
| 443 | - * | |
| 444 | - * @since 2.2.6 | |
| 445 | - * | |
| 446 | - * @param int $limit Max number of posts or terms to retrieve from the database | |
| 447 | - */ | |
| 448 | - $limit = (int) apply_filters( 'get_objects_with_no_lang_limit', $limit ); | |
| 416 | + $terms = get_terms( $this->get_translated_taxonomies(), array( 'get' => 'all', 'fields' => 'ids' ) ); | |
| 417 | + $groups = $this->get_languages_list( array( 'fields' => 'tl_term_id' ) ); | |
| 418 | + $tr_terms = get_objects_in_term( $groups, 'term_language' ); | |
| 419 | + $terms = array_unique( array_diff( $terms, $tr_terms ) ); // array_unique to avoid duplicates if a term is in more than one taxonomy | |
| 420 | + $terms = array_map( 'intval', $terms ); | |
| 449 | 421 | |
| 450 | - $posts = get_posts( | |
| 451 | - array( | |
| 452 | - 'numberposts' => $limit, | |
| 453 | - 'nopaging' => $limit <= 0, | |
| 454 | - 'post_type' => $this->get_translated_post_types(), | |
| 455 | - 'post_status' => 'any', | |
| 456 | - 'fields' => 'ids', | |
| 457 | - 'tax_query' => array( | |
| 458 | - array( | |
| 459 | - 'taxonomy' => 'language', | |
| 460 | - 'terms' => $this->get_languages_list( array( 'fields' => 'term_id' ) ), | |
| 461 | - 'operator' => 'NOT IN', | |
| 462 | - ), | |
| 463 | - ), | |
| 464 | - ) | |
| 465 | - ); | |
| 466 | - | |
| 467 | - // PHPCS:disable WordPress.DB.PreparedSQL | |
| 468 | - $terms = $wpdb->get_col( | |
| 469 | - sprintf( | |
| 470 | - "SELECT {$wpdb->term_taxonomy}.term_id FROM {$wpdb->term_taxonomy} | |
| 471 | - WHERE taxonomy IN ('%s') | |
| 472 | - AND {$wpdb->term_taxonomy}.term_id NOT IN ( | |
| 473 | - SELECT object_id FROM {$wpdb->term_relationships} WHERE term_taxonomy_id IN (%s) | |
| 474 | - ) | |
| 475 | - %s", | |
| 476 | - implode( "','", array_map( 'esc_sql', $this->get_translated_taxonomies() ) ), | |
| 477 | - implode( ',', array_map( 'intval', $this->get_languages_list( array( 'fields' => 'tl_term_taxonomy_id' ) ) ) ), | |
| 478 | - $limit > 0 ? "LIMIT {$limit}" : '' | |
| 479 | - ) | |
| 480 | - ); | |
| 481 | - // PHPCS:enable | |
| 482 | - | |
| 483 | 422 | /** |
| 484 | 423 | * Filter the list of untranslated posts ids and terms ids |
| 485 | 424 | * |
| 486 | 425 | * @since 0.9 |
| @@ -495,22 +434,17 @@ | ||
| 495 | 434 | * |
| 496 | 435 | * @since 0.5 |
| 497 | 436 | * |
| 498 | 437 | * @param string $old_slug the old language slug |
| 499 | - * @param string $new_slug optional, the new language slug, if not set it means the correspondent has been deleted | |
| 438 | + * @param string $new_slug optional, the new language slug, if not set it means the correspondant has been deleted | |
| 500 | 439 | */ |
| 501 | 440 | public function update_translations( $old_slug, $new_slug = '' ) { |
| 502 | 441 | global $wpdb; |
| 503 | 442 | |
| 504 | - $terms = get_terms( array( 'post_translations', 'term_translations' ) ); | |
| 505 | - $term_ids = array(); | |
| 506 | - $dr = array(); | |
| 507 | - $dt = array(); | |
| 508 | - $ut = array(); | |
| 443 | + $terms = get_terms( array( 'post_translations', 'term_translations' ) ); | |
| 509 | 444 | |
| 510 | 445 | foreach ( $terms as $term ) { |
| 511 | - $term_ids[ $term->taxonomy ][] = $term->term_id; | |
| 512 | - $tr = maybe_unserialize( $term->description ); | |
| 446 | + $tr = unserialize( $term->description ); | |
| 513 | 447 | if ( ! empty( $tr[ $old_slug ] ) ) { |
| 514 | 448 | if ( $new_slug ) { |
| 515 | 449 | $tr[ $new_slug ] = $tr[ $old_slug ]; // Suppress this for delete |
| 516 | 450 | } else { |
| @@ -522,9 +456,9 @@ | ||
| 522 | 456 | if ( empty( $tr ) || 1 == count( $tr ) ) { |
| 523 | 457 | $dt['t'][] = (int) $term->term_id; |
| 524 | 458 | $dt['tt'][] = (int) $term->term_taxonomy_id; |
| 525 | 459 | } else { |
| 526 | - $ut['case'][] = $wpdb->prepare( 'WHEN %d THEN %s', $term->term_id, maybe_serialize( $tr ) ); | |
| 460 | + $ut['case'][] = $wpdb->prepare( 'WHEN %d THEN %s', $term->term_id, serialize( $tr ) ); | |
| 527 | 461 | $ut['in'][] = (int) $term->term_id; |
| 528 | 462 | } |
| 529 | 463 | } |
| 530 | 464 | } |
| @@ -530,38 +464,32 @@ | ||
| 530 | 464 | } |
| 531 | 465 | |
| 532 | 466 | // Delete relationships |
| 533 | 467 | if ( ! empty( $dr ) ) { |
| 534 | - // PHPCS:disable WordPress.DB.PreparedSQL.NotPrepared | |
| 535 | - $wpdb->query( | |
| 536 | - "DELETE FROM $wpdb->term_relationships | |
| 537 | - WHERE object_id IN ( " . implode( ',', $dr['id'] ) . ' ) | |
| 538 | - AND term_taxonomy_id IN ( ' . implode( ',', $dr['tt'] ) . ' )' | |
| 539 | - ); | |
| 540 | - // PHPCS:enable | |
| 468 | + $wpdb->query( " | |
| 469 | + DELETE FROM $wpdb->term_relationships | |
| 470 | + WHERE object_id IN ( " . implode( ',', $dr['id'] ) . " ) | |
| 471 | + AND term_taxonomy_id IN ( " . implode( ',', $dr['tt'] ) . " ) | |
| 472 | + " ); | |
| 541 | 473 | } |
| 542 | 474 | |
| 543 | 475 | // Delete terms |
| 544 | 476 | if ( ! empty( $dt ) ) { |
| 545 | - $wpdb->query( "DELETE FROM $wpdb->terms WHERE term_id IN ( " . implode( ',', $dt['t'] ) . ' )' ); // PHPCS:ignore WordPress.DB.PreparedSQL.NotPrepared | |
| 546 | - $wpdb->query( "DELETE FROM $wpdb->term_taxonomy WHERE term_taxonomy_id IN ( " . implode( ',', $dt['tt'] ) . ' )' ); // PHPCS:ignore WordPress.DB.PreparedSQL.NotPrepared | |
| 477 | + $wpdb->query( "DELETE FROM $wpdb->terms WHERE term_id IN ( " . implode( ',', $dt['t'] ) . " ) " ); | |
| 478 | + $wpdb->query( "DELETE FROM $wpdb->term_taxonomy WHERE term_taxonomy_id IN ( " . implode( ',', $dt['tt'] ) . " ) " ); | |
| 547 | 479 | } |
| 548 | 480 | |
| 549 | 481 | // Update terms |
| 550 | 482 | if ( ! empty( $ut ) ) { |
| 551 | - // PHPCS:disable WordPress.DB.PreparedSQL.NotPrepared | |
| 552 | - $wpdb->query( | |
| 553 | - "UPDATE $wpdb->term_taxonomy | |
| 554 | - SET description = ( CASE term_id " . implode( ' ', $ut['case'] ) . ' END ) | |
| 555 | - WHERE term_id IN ( ' . implode( ',', $ut['in'] ) . ' )' | |
| 556 | - ); | |
| 557 | - // PHPCS:enable | |
| 483 | + $wpdb->query( " | |
| 484 | + UPDATE $wpdb->term_taxonomy | |
| 485 | + SET description = ( CASE term_id " . implode( ' ', $ut['case'] ) . " END ) | |
| 486 | + WHERE term_id IN ( " . implode( ',', $ut['in'] ) . " ) | |
| 487 | + " ); | |
| 558 | 488 | } |
| 559 | 489 | |
| 560 | - if ( ! empty( $term_ids ) ) { | |
| 561 | - foreach ( $term_ids as $taxonomy => $ids ) { | |
| 562 | - clean_term_cache( $ids, $taxonomy ); | |
| 563 | - } | |
| 490 | + foreach ( $terms as $term ) { | |
| 491 | + clean_term_cache( $term->term_id, $term->taxonomy ); | |
| 564 | 492 | } |
| 565 | 493 | } |
| 566 | 494 | |
| 567 | 495 | /** |
| @@ -575,10 +503,8 @@ | ||
| 575 | 503 | public function update_default_lang( $slug ) { |
| 576 | 504 | // The nav menus stored in theme locations should be in the default language |
| 577 | 505 | $theme = get_stylesheet(); |
| 578 | 506 | if ( ! empty( $this->options['nav_menus'][ $theme ] ) ) { |
| 579 | - $menus = array(); | |
| 580 | - | |
| 581 | 507 | foreach ( $this->options['nav_menus'][ $theme ] as $key => $loc ) { |
| 582 | 508 | $menus[ $key ] = empty( $loc[ $slug ] ) ? 0 : $loc[ $slug ]; |
| 583 | 509 | } |
| 584 | 510 | set_theme_mod( 'nav_menu_locations', $menus ); |
