| @@ -1,11 +1,8 @@ | ||
| 1 | 1 | <?php |
| 2 | -/** | |
| 3 | - * @package Polylang | |
| 4 | - */ | |
| 5 | 2 | |
| 6 | 3 | /** |
| 7 | - * Extends the PLL_Model class with methods needed only in Polylang settings pages. | |
| 4 | + * Extends the PLL_Model class with methods needed only in Polylang settings pages | |
| 8 | 5 | * |
| 9 | 6 | * @since 1.2 |
| 10 | 7 | */ |
| 11 | 8 | class PLL_Admin_Model extends PLL_Model { |
| @@ -11,35 +8,38 @@ | ||
| 11 | 8 | class PLL_Admin_Model extends PLL_Model { |
| 12 | 9 | |
| 13 | 10 | /** |
| 14 | 11 | * Adds a new language |
| 15 | - * and creates a default category for this language. | |
| 12 | + * Creates a default category for this language | |
| 16 | 13 | * |
| 14 | + * List of arguments that $args must contain: | |
| 15 | + * name -> language name ( used only for display ) | |
| 16 | + * slug -> language code ( ideally 2-letters ISO 639-1 language code ) | |
| 17 | + * locale -> WordPress locale. If something wrong is used for the locale, the .mo files will not be loaded... | |
| 18 | + * rtl -> 1 if rtl language, 0 otherwise | |
| 19 | + * term_group -> language order when displayed | |
| 20 | + * | |
| 21 | + * Optional arguments that $args can contain: | |
| 22 | + * no_default_cat -> if set, no default category will be created for this language | |
| 23 | + * flag -> country code, see flags.php | |
| 24 | + * | |
| 17 | 25 | * @since 1.2 |
| 18 | 26 | * |
| 19 | - * @param array $args { | |
| 20 | - * @type string $name Language name ( used only for display ). | |
| 21 | - * @type string $slug Language code ( ideally 2-letters ISO 639-1 language code ). | |
| 22 | - * @type string $locale WordPress locale. If something wrong is used for the locale, the .mo files will not be loaded... | |
| 23 | - * @type int $rtl 1 if rtl language, 0 otherwise. | |
| 24 | - * @type int $term_group Language order when displayed. | |
| 25 | - * @type string $no_default_cat Optional, if set, no default category will be created for this language. | |
| 26 | - * @type string $flag Optional, country code, @see flags.php. | |
| 27 | - * } | |
| 28 | - * @return WP_Error|true true if success / WP_Error if failed. | |
| 27 | + * @param array $args | |
| 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']; |
| @@ -63,36 +63,33 @@ | ||
| 63 | 63 | $mo = new PLL_MO(); |
| 64 | 64 | $mo->export_to_db( $this->get_language( $args['slug'] ) ); |
| 65 | 65 | |
| 66 | 66 | /** |
| 67 | - * Fires when a language is added. | |
| 67 | + * Fires when a language is added | |
| 68 | 68 | * |
| 69 | 69 | * @since 1.9 |
| 70 | 70 | * |
| 71 | - * @param array $args Arguments used to create the language. @see PLL_Admin_Model::add_language(). | |
| 71 | + * @param array $args arguments used to create the language | |
| 72 | 72 | */ |
| 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 | /** |
| 81 | - * Delete a language. | |
| 83 | + * Delete a language | |
| 82 | 84 | * |
| 83 | 85 | * @since 1.2 |
| 84 | 86 | * |
| 85 | - * @param int $lang_id Language term_id. | |
| 86 | - * @return bool | |
| 87 | + * @param int $lang_id language term_id | |
| 87 | 88 | */ |
| 88 | 89 | public function delete_language( $lang_id ) { |
| 89 | 90 | $lang = $this->get_language( (int) $lang_id ); |
| 90 | 91 | |
| 91 | - if ( empty( $lang ) ) { | |
| 92 | - return false; | |
| 93 | - } | |
| 94 | - | |
| 95 | 92 | // Oops ! we are deleting the default language... |
| 96 | 93 | // Need to do this before loosing the information for default category translations |
| 97 | 94 | if ( $this->options['default_lang'] == $lang->slug ) { |
| 98 | 95 | $slugs = $this->get_languages_list( array( 'fields' => 'slug' ) ); |
| @@ -125,9 +122,9 @@ | ||
| 125 | 122 | |
| 126 | 123 | // Delete menus locations |
| 127 | 124 | if ( ! empty( $this->options['nav_menus'] ) ) { |
| 128 | 125 | foreach ( $this->options['nav_menus'] as $theme => $locations ) { |
| 129 | - foreach ( array_keys( $locations ) as $location ) { | |
| 126 | + foreach ( $locations as $location => $languages ) { | |
| 130 | 127 | unset( $this->options['nav_menus'][ $theme ][ $location ][ $lang->slug ] ); |
| 131 | 128 | } |
| 132 | 129 | } |
| 133 | 130 | } |
| @@ -133,15 +130,16 @@ | ||
| 133 | 130 | } |
| 134 | 131 | |
| 135 | 132 | // Delete users options |
| 136 | 133 | foreach ( get_users( array( 'fields' => 'ID' ) ) as $user_id ) { |
| 134 | + delete_user_meta( $user_id, 'user_lang', $lang->locale ); | |
| 137 | 135 | delete_user_meta( $user_id, 'pll_filter_content', $lang->slug ); |
| 138 | - delete_user_meta( $user_id, 'description_' . $lang->slug ); | |
| 136 | + delete_user_meta( $user_id, 'description_'.$lang->slug ); | |
| 139 | 137 | } |
| 140 | 138 | |
| 141 | 139 | // Delete the string translations |
| 142 | 140 | $post = wpcom_vip_get_page_by_title( 'polylang_mo_' . $lang->term_id, OBJECT, 'polylang_mo' ); |
| 143 | - if ( $post instanceof WP_Post ) { | |
| 141 | + if ( ! empty( $post ) ) { | |
| 144 | 142 | wp_delete_post( $post->ID ); |
| 145 | 143 | } |
| 146 | 144 | |
| 147 | 145 | // Delete domain |
| @@ -155,33 +153,34 @@ | ||
| 155 | 153 | $this->clean_languages_cache(); |
| 156 | 154 | |
| 157 | 155 | update_option( 'polylang', $this->options ); |
| 158 | 156 | flush_rewrite_rules(); // refresh rewrite rules |
| 159 | - return true; | |
| 157 | + add_settings_error( 'general', 'pll_languages_deleted', __( 'Language deleted.', 'polylang' ), 'updated' ); | |
| 160 | 158 | } |
| 161 | 159 | |
| 162 | 160 | /** |
| 163 | - * Updates language properties. | |
| 161 | + * Update language properties | |
| 164 | 162 | * |
| 163 | + * List of arguments that $args must contain: | |
| 164 | + * lang_id -> term_id of the language to modify | |
| 165 | + * name -> language name ( used only for display ) | |
| 166 | + * slug -> language code ( ideally 2-letters ISO 639-1 language code | |
| 167 | + * locale -> WordPress locale. If something wrong is used for the locale, the .mo files will not be loaded... | |
| 168 | + * rtl -> 1 if rtl language, 0 otherwise | |
| 169 | + * term_group -> language order when displayed | |
| 170 | + * | |
| 171 | + * Optional arguments that $args can contain: | |
| 172 | + * flag -> country code, see flags.php | |
| 173 | + * | |
| 165 | 174 | * @since 1.2 |
| 166 | 175 | * |
| 167 | - * @param array $args { | |
| 168 | - * @type int $lang_id Id of the language to modify. | |
| 169 | - * @type string $name Language name ( used only for display ). | |
| 170 | - * @type string $slug Language code ( ideally 2-letters ISO 639-1 language code ). | |
| 171 | - * @type string $locale WordPress locale. If something wrong is used for the locale, the .mo files will not be loaded... | |
| 172 | - * @type int $rtl 1 if rtl language, 0 otherwise. | |
| 173 | - * @type int $term_group Language order when displayed. | |
| 174 | - * @type string $flag Optional, country code, @see flags.php. | |
| 175 | - * } | |
| 176 | - * @return WP_Error|true true if success / WP_Error if failed. | |
| 176 | + * @param array $args | |
| 177 | + * @return bool true if success / false if failed | |
| 177 | 178 | */ |
| 178 | 179 | public function update_language( $args ) { |
| 179 | 180 | $lang = $this->get_language( (int) $args['lang_id'] ); |
| 180 | - | |
| 181 | - $errors = $this->validate_lang( $args, $lang ); | |
| 182 | - if ( $errors->get_error_code() ) { // Using has_errors() would be more meaningful but is available only since WP 5.0 | |
| 183 | - return $errors; | |
| 181 | + if ( ! $this->validate_lang( $args, $lang ) ) { | |
| 182 | + return false; | |
| 184 | 183 | } |
| 185 | 184 | |
| 186 | 185 | // Update links to this language in posts and terms in case the slug has been modified |
| 187 | 186 | $slug = $args['slug']; |
| @@ -208,9 +207,9 @@ | ||
| 208 | 207 | |
| 209 | 208 | // Update menus locations |
| 210 | 209 | if ( ! empty( $this->options['nav_menus'] ) ) { |
| 211 | 210 | foreach ( $this->options['nav_menus'] as $theme => $locations ) { |
| 212 | - foreach ( array_keys( $locations ) as $location ) { | |
| 211 | + foreach ( $locations as $location => $languages ) { | |
| 213 | 212 | if ( ! empty( $this->options['nav_menus'][ $theme ][ $location ][ $old_slug ] ) ) { |
| 214 | 213 | $this->options['nav_menus'][ $theme ][ $location ][ $slug ] = $this->options['nav_menus'][ $theme ][ $location ][ $old_slug ]; |
| 215 | 214 | unset( $this->options['nav_menus'][ $theme ][ $location ][ $old_slug ] ); |
| 216 | 215 | } |
| @@ -232,116 +231,94 @@ | ||
| 232 | 231 | |
| 233 | 232 | update_option( 'polylang', $this->options ); |
| 234 | 233 | |
| 235 | 234 | // And finally update the language itself |
| 236 | - $description = maybe_serialize( array( 'locale' => $args['locale'], 'rtl' => (int) $args['rtl'], 'flag_code' => empty( $args['flag'] ) ? '' : $args['flag'] ) ); | |
| 235 | + $description = serialize( array( 'locale' => $args['locale'], 'rtl' => (int) $args['rtl'], 'flag_code' => empty( $args['flag'] ) ? '' : $args['flag'] ) ); | |
| 237 | 236 | wp_update_term( (int) $lang->term_id, 'language', array( 'slug' => $slug, 'name' => $args['name'], 'description' => $description, 'term_group' => (int) $args['term_group'] ) ); |
| 238 | 237 | wp_update_term( (int) $lang->tl_term_id, 'term_language', array( 'slug' => 'pll_' . $slug, 'name' => $args['name'] ) ); |
| 239 | 238 | |
| 240 | 239 | /** |
| 241 | - * Fires when a language is updated. | |
| 240 | + * Fires when a language is added | |
| 242 | 241 | * |
| 243 | 242 | * @since 1.9 |
| 244 | 243 | * |
| 245 | - * @param array $args Arguments used to modify the language. @see PLL_Admin_Model::update_language(). | |
| 244 | + * @param array $args arguments used to modify the language | |
| 246 | 245 | */ |
| 247 | 246 | do_action( 'pll_update_language', $args ); |
| 248 | 247 | |
| 249 | 248 | $this->clean_languages_cache(); |
| 250 | 249 | flush_rewrite_rules(); // Refresh rewrite rules |
| 250 | + add_settings_error( 'general', 'pll_languages_updated', __( 'Language updated.', 'polylang' ), 'updated' ); | |
| 251 | 251 | return true; |
| 252 | 252 | } |
| 253 | 253 | |
| 254 | 254 | /** |
| 255 | - * Validates data entered when creating or updating a language. | |
| 255 | + * Validates data entered when creating or updating a language | |
| 256 | + * @see PLL_Admin_Model::add_language | |
| 256 | 257 | * |
| 257 | - * @see PLL_Admin_Model::add_language(). | |
| 258 | - * | |
| 259 | 258 | * @since 0.4 |
| 260 | 259 | * |
| 261 | - * @param array $args Parameters of {@see PLL_Admin_Model::add_language() or @see PLL_Admin_Model::update_language()}. | |
| 262 | - * @param PLL_Language $lang Optional the language currently updated, the language is created if not set. | |
| 263 | - * @return WP_Error | |
| 260 | + * @param array $args | |
| 261 | + * @param object $lang optional the language currently updated, the language is created if not set | |
| 262 | + * @return bool true if success / false if failed | |
| 264 | 263 | */ |
| 265 | 264 | protected function validate_lang( $args, $lang = null ) { |
| 266 | - $errors = new WP_Error(); | |
| 267 | - | |
| 268 | 265 | // Validate locale with the same pattern as WP 4.3. See #28303 |
| 269 | 266 | if ( ! preg_match( '#^[a-z]{2,3}(?:_[A-Z]{2})?(?:_[a-z0-9]+)?$#', $args['locale'], $matches ) ) { |
| 270 | - $errors->add( 'pll_invalid_locale', __( 'Enter a valid WordPress locale', 'polylang' ) ); | |
| 267 | + add_settings_error( 'general', 'pll_invalid_locale', __( 'Enter a valid WordPress locale', 'polylang' ) ); | |
| 271 | 268 | } |
| 272 | 269 | |
| 273 | 270 | // Validate slug characters |
| 274 | 271 | if ( ! preg_match( '#^[a-z_-]+$#', $args['slug'] ) ) { |
| 275 | - $errors->add( 'pll_invalid_slug', __( 'The language code contains invalid characters', 'polylang' ) ); | |
| 272 | + add_settings_error( 'general', 'pll_invalid_slug', __( 'The language code contains invalid characters', 'polylang' ) ); | |
| 276 | 273 | } |
| 277 | 274 | |
| 278 | 275 | // Validate slug is unique |
| 279 | - foreach ( $this->get_languages_list() as $language ) { | |
| 280 | - if ( $language->slug === $args['slug'] && ( null === $lang || $lang->term_id !== $language->term_id ) ) { | |
| 281 | - $errors->add( 'pll_non_unique_slug', __( 'The language code must be unique', 'polylang' ) ); | |
| 282 | - } | |
| 276 | + if ( $this->get_language( $args['slug'] ) && ( null === $lang || ( isset( $lang ) && $lang->slug != $args['slug'] ) ) ) { | |
| 277 | + add_settings_error( 'general', 'pll_non_unique_slug', __( 'The language code must be unique', 'polylang' ) ); | |
| 283 | 278 | } |
| 284 | 279 | |
| 285 | 280 | // Validate name |
| 286 | 281 | // No need to sanitize it as wp_insert_term will do it for us |
| 287 | 282 | if ( empty( $args['name'] ) ) { |
| 288 | - $errors->add( 'pll_invalid_name', __( 'The language must have a name', 'polylang' ) ); | |
| 283 | + add_settings_error( 'general', 'pll_invalid_name', __( 'The language must have a name', 'polylang' ) ); | |
| 289 | 284 | } |
| 290 | 285 | |
| 291 | 286 | // Validate flag |
| 292 | 287 | if ( ! empty( $args['flag'] ) && ! file_exists( POLYLANG_DIR . '/flags/' . $args['flag'] . '.png' ) ) { |
| 293 | - $flag = PLL_Language::get_flag_informations( $args['flag'] ); | |
| 294 | - | |
| 295 | - if ( ! empty( $flag['url'] ) ) { | |
| 296 | - $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'] ) ); | |
| 297 | - } | |
| 298 | - | |
| 299 | - if ( empty( $response ) || is_wp_error( $response ) || 200 !== wp_remote_retrieve_response_code( $response ) ) { | |
| 300 | - $errors->add( 'pll_invalid_flag', __( 'The flag does not exist', 'polylang' ) ); | |
| 301 | - } | |
| 288 | + add_settings_error( 'general', 'pll_invalid_flag', __( 'The flag does not exist', 'polylang' ) ); | |
| 302 | 289 | } |
| 303 | 290 | |
| 304 | - return $errors; | |
| 291 | + return get_settings_errors() ? false : true; | |
| 305 | 292 | } |
| 306 | 293 | |
| 307 | 294 | /** |
| 308 | - * Assigns a language to posts or terms in mass. | |
| 295 | + * Used to set the language of posts or terms in mass | |
| 309 | 296 | * |
| 310 | 297 | * @since 1.2 |
| 311 | 298 | * |
| 312 | - * @param string $type Either 'post' or 'term'. | |
| 313 | - * @param int[] $ids Array of post ids or term ids. | |
| 314 | - * @param PLL_Language|string $lang Language to assign to the posts or terms. | |
| 315 | - * @return void | |
| 299 | + * @param string $type either 'post' or 'term' | |
| 300 | + * @param array $ids array of post ids or term ids | |
| 301 | + * @param object|string $lang object or slug | |
| 316 | 302 | */ |
| 317 | 303 | public function set_language_in_mass( $type, $ids, $lang ) { |
| 318 | 304 | global $wpdb; |
| 319 | 305 | |
| 306 | + $ids = array_map( 'intval', $ids ); | |
| 320 | 307 | $lang = $this->get_language( $lang ); |
| 308 | + $tt_id = 'term' == $type ? $lang->tl_term_taxonomy_id : $lang->term_taxonomy_id; | |
| 321 | 309 | |
| 322 | - if ( empty( $lang ) ) { | |
| 323 | - return; | |
| 324 | - } | |
| 325 | - | |
| 326 | - $tt_id = 'term' === $type ? $lang->tl_term_taxonomy_id : $lang->term_taxonomy_id; | |
| 327 | - $values = array(); | |
| 328 | - $ids = array_map( 'intval', $ids ); | |
| 329 | - | |
| 330 | 310 | foreach ( $ids as $id ) { |
| 331 | 311 | $values[] = $wpdb->prepare( '( %d, %d )', $id, $tt_id ); |
| 332 | 312 | } |
| 333 | 313 | |
| 334 | 314 | if ( ! empty( $values ) ) { |
| 335 | - // PHPCS:ignore WordPress.DB.PreparedSQL.NotPrepared | |
| 336 | - $wpdb->query( "INSERT INTO {$wpdb->term_relationships} ( object_id, term_taxonomy_id ) VALUES " . implode( ',', array_unique( $values ) ) ); | |
| 315 | + $values = array_unique( $values ); | |
| 316 | + $wpdb->query( "INSERT INTO $wpdb->term_relationships ( object_id, term_taxonomy_id ) VALUES " . implode( ',', $values ) ); | |
| 337 | 317 | $lang->update_count(); // Updating term count is mandatory ( thanks to AndyDeGroo ) |
| 338 | 318 | } |
| 339 | 319 | |
| 340 | - if ( 'term' === $type ) { | |
| 341 | - clean_term_cache( $ids, 'term_language' ); | |
| 342 | - $translations = array(); | |
| 343 | - | |
| 320 | + if ( 'term' == $type ) { | |
| 344 | 321 | foreach ( $ids as $id ) { |
| 345 | 322 | $translations[] = array( $lang->slug => $id ); |
| 346 | 323 | } |
| 347 | 324 | |
| @@ -347,76 +324,60 @@ | ||
| 347 | 324 | |
| 348 | 325 | if ( ! empty( $translations ) ) { |
| 349 | 326 | $this->set_translation_in_mass( 'term', $translations ); |
| 350 | 327 | } |
| 351 | - } else { | |
| 352 | - clean_term_cache( $ids, 'language' ); | |
| 353 | 328 | } |
| 354 | 329 | } |
| 355 | 330 | |
| 356 | 331 | /** |
| 357 | - * Creates translations groups in mass. | |
| 332 | + * Used to create a translations groups in mass | |
| 358 | 333 | * |
| 359 | 334 | * @since 1.6.3 |
| 360 | 335 | * |
| 361 | - * @param string $type Either 'post' or 'term' | |
| 362 | - * @param array $translations Array of translations arrays. | |
| 363 | - * @return void | |
| 336 | + * @param string $type either 'post' or 'term' | |
| 337 | + * @param array $translations array of translations arrays | |
| 364 | 338 | */ |
| 365 | 339 | public function set_translation_in_mass( $type, $translations ) { |
| 366 | 340 | global $wpdb; |
| 367 | 341 | |
| 368 | - $taxonomy = $type . '_translations'; | |
| 369 | - $terms = array(); | |
| 370 | - $slugs = array(); | |
| 371 | - $description = array(); | |
| 372 | - $count = array(); | |
| 373 | - | |
| 374 | 342 | foreach ( $translations as $t ) { |
| 375 | 343 | $term = uniqid( 'pll_' ); // the term name |
| 376 | - $terms[] = $wpdb->prepare( '( %s, %s )', $term, $term ); | |
| 377 | - $slugs[] = $wpdb->prepare( '%s', $term ); | |
| 378 | - $description[ $term ] = maybe_serialize( $t ); | |
| 344 | + $terms[] = $wpdb->prepare( '( "%1$s", "%1$s" )', $term ); | |
| 345 | + $slugs[] = $wpdb->prepare( '"%s"', $term ); | |
| 346 | + $description[ $term ] = serialize( $t ); | |
| 379 | 347 | $count[ $term ] = count( $t ); |
| 380 | 348 | } |
| 381 | 349 | |
| 382 | 350 | // Insert terms |
| 383 | 351 | if ( ! empty( $terms ) ) { |
| 384 | - // PHPCS:ignore WordPress.DB.PreparedSQL.NotPrepared | |
| 385 | - $wpdb->query( "INSERT INTO {$wpdb->terms} ( slug, name ) VALUES " . implode( ',', array_unique( $terms ) ) ); | |
| 352 | + $terms = array_unique( $terms ); | |
| 353 | + $wpdb->query( "INSERT INTO $wpdb->terms ( slug, name ) VALUES " . implode( ',', $terms ) ); | |
| 386 | 354 | } |
| 387 | 355 | |
| 388 | 356 | // Get all terms with their term_id |
| 389 | - // PHPCS:ignore WordPress.DB.PreparedSQL.NotPrepared | |
| 390 | - $terms = $wpdb->get_results( "SELECT term_id, slug FROM {$wpdb->terms} WHERE slug IN ( " . implode( ',', $slugs ) . ' )' ); | |
| 391 | - $term_ids = array(); | |
| 392 | - $tts = array(); | |
| 357 | + $terms = $wpdb->get_results( "SELECT term_id, slug FROM $wpdb->terms WHERE slug IN ( " . implode( ',', $slugs ) . " )" ); | |
| 393 | 358 | |
| 394 | 359 | // Prepare terms taxonomy relationship |
| 395 | 360 | foreach ( $terms as $term ) { |
| 396 | - $term_ids[] = $term->term_id; | |
| 397 | - $tts[] = $wpdb->prepare( '( %d, %s, %s, %d )', $term->term_id, $taxonomy, $description[ $term->slug ], $count[ $term->slug ] ); | |
| 361 | + $tts[] = $wpdb->prepare( '( %d, "%s", "%s", %d )', $term->term_id, $type . '_translations', $description[ $term->slug ], $count[ $term->slug ] ); | |
| 398 | 362 | } |
| 399 | 363 | |
| 400 | 364 | // Insert term_taxonomy |
| 401 | 365 | if ( ! empty( $tts ) ) { |
| 402 | - // PHPCS:ignore WordPress.DB.PreparedSQL.NotPrepared | |
| 403 | - $wpdb->query( "INSERT INTO {$wpdb->term_taxonomy} ( term_id, taxonomy, description, count ) VALUES " . implode( ',', array_unique( $tts ) ) ); | |
| 366 | + $tts = array_unique( $tts ); | |
| 367 | + $wpdb->query( "INSERT INTO $wpdb->term_taxonomy ( term_id, taxonomy, description, count ) VALUES " . implode( ',', $tts ) ); | |
| 404 | 368 | } |
| 405 | 369 | |
| 406 | 370 | // Get all terms with term_taxonomy_id |
| 407 | - $terms = get_terms( $taxonomy, array( 'hide_empty' => false ) ); | |
| 408 | - $trs = array(); | |
| 371 | + $terms = get_terms( $type . '_translations', array( 'hide_empty' => false ) ); | |
| 409 | 372 | |
| 410 | - // Prepare objects relationships. | |
| 411 | - if ( is_array( $terms ) ) { | |
| 412 | - foreach ( $terms as $term ) { | |
| 413 | - $t = maybe_unserialize( $term->description ); | |
| 414 | - if ( in_array( $t, $translations ) ) { | |
| 415 | - foreach ( $t as $object_id ) { | |
| 416 | - if ( ! empty( $object_id ) ) { | |
| 417 | - $trs[] = $wpdb->prepare( '( %d, %d )', $object_id, $term->term_taxonomy_id ); | |
| 418 | - } | |
| 373 | + // Prepare objects relationships | |
| 374 | + foreach ( $terms as $term ) { | |
| 375 | + $t = unserialize( $term->description ); | |
| 376 | + if ( in_array( $t, $translations ) ) { | |
| 377 | + foreach ( $t as $object_id ) { | |
| 378 | + if ( ! empty( $object_id ) ) { | |
| 379 | + $trs[] = $wpdb->prepare( '( %d, %d )', $object_id, $term->term_taxonomy_id ); | |
| 419 | 380 | } |
| 420 | 381 | } |
| 421 | 382 | } |
| 422 | 383 | } |
| @@ -422,126 +383,80 @@ | ||
| 422 | 383 | } |
| 423 | 384 | |
| 424 | 385 | // Insert term_relationships |
| 425 | 386 | if ( ! empty( $trs ) ) { |
| 426 | - // PHPCS:ignore WordPress.DB.PreparedSQL.NotPrepared | |
| 427 | - $wpdb->query( "INSERT INTO {$wpdb->term_relationships} ( object_id, term_taxonomy_id ) VALUES " . implode( ',', $trs ) ); | |
| 387 | + $wpdb->query( "INSERT INTO $wpdb->term_relationships ( object_id, term_taxonomy_id ) VALUES " . implode( ',', $trs ) ); | |
| 428 | 388 | $trs = array_unique( $trs ); |
| 429 | 389 | } |
| 430 | - | |
| 431 | - clean_term_cache( $term_ids, $taxonomy ); | |
| 432 | 390 | } |
| 433 | 391 | |
| 434 | 392 | /** |
| 435 | - * Returns untranslated posts and terms ids ( used in settings ). | |
| 393 | + * Returns unstranslated posts and terms ids ( used in settings ) | |
| 436 | 394 | * |
| 437 | 395 | * @since 0.9 |
| 438 | - * @since 2.2.6 Add the $limit argument. | |
| 439 | 396 | * |
| 440 | - * @param int $limit Max number of posts or terms to return. Defaults to -1 (no limit). | |
| 441 | - * @return array { | |
| 442 | - * Objects without language. | |
| 443 | - * | |
| 444 | - * @type int[] $posts Array of post ids. | |
| 445 | - * @type int[] $terms Array of term ids. | |
| 446 | - * } | |
| 397 | + * @return array array made of an array of post ids and an array of term ids | |
| 447 | 398 | */ |
| 448 | - public function get_objects_with_no_lang( $limit = -1 ) { | |
| 449 | - global $wpdb; | |
| 399 | + public function get_objects_with_no_lang() { | |
| 400 | + $posts = get_posts( array( | |
| 401 | + 'numberposts' => -1, | |
| 402 | + 'nopaging' => true, | |
| 403 | + 'post_type' => $this->get_translated_post_types(), | |
| 404 | + 'post_status' => 'any', | |
| 405 | + 'fields' => 'ids', | |
| 406 | + 'tax_query' => array( array( | |
| 407 | + 'taxonomy' => 'language', | |
| 408 | + 'terms' => $this->get_languages_list( array( 'fields' => 'term_id' ) ), | |
| 409 | + 'operator' => 'NOT IN', | |
| 410 | + ) ) | |
| 411 | + ) ); | |
| 450 | 412 | |
| 451 | - /** | |
| 452 | - * Filters the max number of posts or terms to return when searching objects with no language. | |
| 453 | - * This filter can be used to decrease the memory usage in case the number of objects | |
| 454 | - * without language is too big. Using a negative value is equivalent to have no limit. | |
| 455 | - * | |
| 456 | - * @since 2.2.6 | |
| 457 | - * | |
| 458 | - * @param int $limit Max number of posts or terms to retrieve from the database. | |
| 459 | - */ | |
| 460 | - $limit = (int) apply_filters( 'get_objects_with_no_lang_limit', $limit ); | |
| 413 | + $terms = get_terms( $this->get_translated_taxonomies(), array( 'get' => 'all', 'fields' => 'ids' ) ); | |
| 414 | + $groups = $this->get_languages_list( array( 'fields' => 'tl_term_id' ) ); | |
| 415 | + $tr_terms = get_objects_in_term( $groups, 'term_language' ); | |
| 416 | + $terms = array_unique( array_diff( $terms, $tr_terms ) ); // array_unique to avoid duplicates if a term is in more than one taxonomy | |
| 417 | + $terms = array_map( 'intval', $terms ); | |
| 461 | 418 | |
| 462 | - $posts = get_posts( | |
| 463 | - array( | |
| 464 | - 'numberposts' => $limit, | |
| 465 | - 'nopaging' => $limit <= 0, | |
| 466 | - 'post_type' => $this->get_translated_post_types(), | |
| 467 | - 'post_status' => 'any', | |
| 468 | - 'fields' => 'ids', | |
| 469 | - 'tax_query' => array( | |
| 470 | - array( | |
| 471 | - 'taxonomy' => 'language', | |
| 472 | - 'terms' => $this->get_languages_list( array( 'fields' => 'term_id' ) ), | |
| 473 | - 'operator' => 'NOT IN', | |
| 474 | - ), | |
| 475 | - ), | |
| 476 | - ) | |
| 477 | - ); | |
| 478 | - | |
| 479 | - // PHPCS:disable WordPress.DB.PreparedSQL | |
| 480 | - $terms = $wpdb->get_col( | |
| 481 | - sprintf( | |
| 482 | - "SELECT {$wpdb->term_taxonomy}.term_id FROM {$wpdb->term_taxonomy} | |
| 483 | - WHERE taxonomy IN ('%s') | |
| 484 | - AND {$wpdb->term_taxonomy}.term_id NOT IN ( | |
| 485 | - SELECT object_id FROM {$wpdb->term_relationships} WHERE term_taxonomy_id IN (%s) | |
| 486 | - ) | |
| 487 | - %s", | |
| 488 | - implode( "','", array_map( 'esc_sql', $this->get_translated_taxonomies() ) ), | |
| 489 | - implode( ',', array_map( 'intval', $this->get_languages_list( array( 'fields' => 'tl_term_taxonomy_id' ) ) ) ), | |
| 490 | - $limit > 0 ? "LIMIT {$limit}" : '' | |
| 491 | - ) | |
| 492 | - ); | |
| 493 | - // PHPCS:enable | |
| 494 | - | |
| 495 | 419 | /** |
| 496 | - * Filters the list of untranslated posts ids and terms ids | |
| 420 | + * Filter the list of untranslated posts ids and terms ids | |
| 497 | 421 | * |
| 498 | 422 | * @since 0.9 |
| 499 | 423 | * |
| 500 | - * @param array|false $objects false if no ids found, list of post and/or term ids otherwise. | |
| 424 | + * @param bool|array $objects false if no ids found, list of post and/or term ids otherwise | |
| 501 | 425 | */ |
| 502 | 426 | return apply_filters( 'pll_get_objects_with_no_lang', empty( $posts ) && empty( $terms ) ? false : array( 'posts' => $posts, 'terms' => $terms ) ); |
| 503 | 427 | } |
| 504 | 428 | |
| 505 | 429 | /** |
| 506 | - * Updates the translations when a language slug has been modified in settings | |
| 507 | - * or deletes them when a language is removed. | |
| 430 | + * Used to delete translations or update the translations when a language slug has been modified in settings | |
| 508 | 431 | * |
| 509 | 432 | * @since 0.5 |
| 510 | 433 | * |
| 511 | - * @param string $old_slug The old language slug. | |
| 512 | - * @param string $new_slug Optional, the new language slug, if not set it means that the language has been deleted. | |
| 513 | - * @return void | |
| 434 | + * @param string $old_slug the old language slug | |
| 435 | + * @param string $new_slug optional, the new language slug, if not set it means the correspondant has been deleted | |
| 514 | 436 | */ |
| 515 | 437 | public function update_translations( $old_slug, $new_slug = '' ) { |
| 516 | 438 | global $wpdb; |
| 517 | 439 | |
| 518 | - $terms = get_terms( array( 'post_translations', 'term_translations' ) ); | |
| 519 | - $term_ids = array(); | |
| 520 | - $dr = array(); | |
| 521 | - $dt = array(); | |
| 522 | - $ut = array(); | |
| 440 | + $terms = get_terms( array( 'post_translations', 'term_translations' ) ); | |
| 523 | 441 | |
| 524 | - if ( is_array( $terms ) ) { | |
| 525 | - foreach ( $terms as $term ) { | |
| 526 | - $term_ids[ $term->taxonomy ][] = $term->term_id; | |
| 527 | - $tr = maybe_unserialize( $term->description ); | |
| 528 | - if ( ! empty( $tr[ $old_slug ] ) ) { | |
| 529 | - if ( $new_slug ) { | |
| 530 | - $tr[ $new_slug ] = $tr[ $old_slug ]; // Suppress this for delete | |
| 531 | - } else { | |
| 532 | - $dr['id'][] = (int) $tr[ $old_slug ]; | |
| 533 | - $dr['tt'][] = (int) $term->term_taxonomy_id; | |
| 534 | - } | |
| 535 | - unset( $tr[ $old_slug ] ); | |
| 442 | + foreach ( $terms as $term ) { | |
| 443 | + $tr = unserialize( $term->description ); | |
| 444 | + if ( ! empty( $tr[ $old_slug ] ) ) { | |
| 445 | + if ( $new_slug ) { | |
| 446 | + $tr[ $new_slug ] = $tr[ $old_slug ]; // Suppress this for delete | |
| 447 | + } else { | |
| 448 | + $dr['id'][] = (int) $tr[ $old_slug ]; | |
| 449 | + $dr['tt'][] = (int) $term->term_taxonomy_id; | |
| 450 | + } | |
| 451 | + unset( $tr[ $old_slug ] ); | |
| 536 | 452 | |
| 537 | - if ( empty( $tr ) || 1 == count( $tr ) ) { | |
| 538 | - $dt['t'][] = (int) $term->term_id; | |
| 539 | - $dt['tt'][] = (int) $term->term_taxonomy_id; | |
| 540 | - } else { | |
| 541 | - $ut['case'][] = $wpdb->prepare( 'WHEN %d THEN %s', $term->term_id, maybe_serialize( $tr ) ); | |
| 542 | - $ut['in'][] = (int) $term->term_id; | |
| 543 | - } | |
| 453 | + if ( empty( $tr ) || 1 == count( $tr ) ) { | |
| 454 | + $dt['t'][] = (int) $term->term_id; | |
| 455 | + $dt['tt'][] = (int) $term->term_taxonomy_id; | |
| 456 | + } else { | |
| 457 | + $ut['case'][] = $wpdb->prepare( 'WHEN %d THEN %s', $term->term_id, serialize( $tr ) ); | |
| 458 | + $ut['in'][] = (int) $term->term_id; | |
| 544 | 459 | } |
| 545 | 460 | } |
| 546 | 461 | } |
| 547 | 462 | |
| @@ -546,56 +461,47 @@ | ||
| 546 | 461 | } |
| 547 | 462 | |
| 548 | 463 | // Delete relationships |
| 549 | 464 | if ( ! empty( $dr ) ) { |
| 550 | - // PHPCS:disable WordPress.DB.PreparedSQL.NotPrepared | |
| 551 | - $wpdb->query( | |
| 552 | - "DELETE FROM $wpdb->term_relationships | |
| 553 | - WHERE object_id IN ( " . implode( ',', $dr['id'] ) . ' ) | |
| 554 | - AND term_taxonomy_id IN ( ' . implode( ',', $dr['tt'] ) . ' )' | |
| 555 | - ); | |
| 556 | - // PHPCS:enable | |
| 465 | + $wpdb->query( " | |
| 466 | + DELETE FROM $wpdb->term_relationships | |
| 467 | + WHERE object_id IN ( " . implode( ',', $dr['id'] ) . " ) | |
| 468 | + AND term_taxonomy_id IN ( " . implode( ',', $dr['tt'] ) . " ) | |
| 469 | + " ); | |
| 557 | 470 | } |
| 558 | 471 | |
| 559 | 472 | // Delete terms |
| 560 | 473 | if ( ! empty( $dt ) ) { |
| 561 | - $wpdb->query( "DELETE FROM $wpdb->terms WHERE term_id IN ( " . implode( ',', $dt['t'] ) . ' )' ); // PHPCS:ignore WordPress.DB.PreparedSQL.NotPrepared | |
| 562 | - $wpdb->query( "DELETE FROM $wpdb->term_taxonomy WHERE term_taxonomy_id IN ( " . implode( ',', $dt['tt'] ) . ' )' ); // PHPCS:ignore WordPress.DB.PreparedSQL.NotPrepared | |
| 474 | + $wpdb->query( "DELETE FROM $wpdb->terms WHERE term_id IN ( " . implode( ',', $dt['t'] ) . " ) " ); | |
| 475 | + $wpdb->query( "DELETE FROM $wpdb->term_taxonomy WHERE term_taxonomy_id IN ( " . implode( ',', $dt['tt'] ) . " ) " ); | |
| 563 | 476 | } |
| 564 | 477 | |
| 565 | 478 | // Update terms |
| 566 | 479 | if ( ! empty( $ut ) ) { |
| 567 | - // PHPCS:disable WordPress.DB.PreparedSQL.NotPrepared | |
| 568 | - $wpdb->query( | |
| 569 | - "UPDATE $wpdb->term_taxonomy | |
| 570 | - SET description = ( CASE term_id " . implode( ' ', $ut['case'] ) . ' END ) | |
| 571 | - WHERE term_id IN ( ' . implode( ',', $ut['in'] ) . ' )' | |
| 572 | - ); | |
| 573 | - // PHPCS:enable | |
| 480 | + $wpdb->query( " | |
| 481 | + UPDATE $wpdb->term_taxonomy | |
| 482 | + SET description = ( CASE term_id " . implode( ' ', $ut['case'] ) . " END ) | |
| 483 | + WHERE term_id IN ( " . implode( ',', $ut['in'] ) . " ) | |
| 484 | + " ); | |
| 574 | 485 | } |
| 575 | 486 | |
| 576 | - if ( ! empty( $term_ids ) ) { | |
| 577 | - foreach ( $term_ids as $taxonomy => $ids ) { | |
| 578 | - clean_term_cache( $ids, $taxonomy ); | |
| 579 | - } | |
| 487 | + foreach ( $terms as $term ) { | |
| 488 | + clean_term_cache( $term->term_id, $term->taxonomy ); | |
| 580 | 489 | } |
| 581 | 490 | } |
| 582 | 491 | |
| 583 | 492 | /** |
| 584 | 493 | * Updates the default language |
| 585 | - * taking care to update the default category & the nav menu locations. | |
| 494 | + * taking care to update the default category & the nav menu locations | |
| 586 | 495 | * |
| 587 | 496 | * @since 1.8 |
| 588 | 497 | * |
| 589 | - * @param string $slug New language slug. | |
| 590 | - * @return void | |
| 498 | + * @param string $slug new language slug | |
| 591 | 499 | */ |
| 592 | 500 | public function update_default_lang( $slug ) { |
| 593 | 501 | // The nav menus stored in theme locations should be in the default language |
| 594 | 502 | $theme = get_stylesheet(); |
| 595 | 503 | if ( ! empty( $this->options['nav_menus'][ $theme ] ) ) { |
| 596 | - $menus = array(); | |
| 597 | - | |
| 598 | 504 | foreach ( $this->options['nav_menus'][ $theme ] as $key => $loc ) { |
| 599 | 505 | $menus[ $key ] = empty( $loc[ $slug ] ) ? 0 : $loc[ $slug ]; |
| 600 | 506 | } |
| 601 | 507 | set_theme_mod( 'nav_menu_locations', $menus ); |
