WPSEO_Upgrade::remove_indexable_rows_for_non_public_taxonomies()publicYoast 1.0

Removes all indexables for terms that are not publicly viewable. This method should be called after init, because taxonomies can still be registered.

Метод класса: WPSEO_Upgrade{}

Хуков нет.

Возвращает

null. Ничего.

Использование

$WPSEO_Upgrade = new WPSEO_Upgrade();
$WPSEO_Upgrade->remove_indexable_rows_for_non_public_taxonomies();

Код WPSEO_Upgrade::remove_indexable_rows_for_non_public_taxonomies() Yoast 20.0

public function remove_indexable_rows_for_non_public_taxonomies() {
	global $wpdb;

	// If migrations haven't been completed successfully the following may give false errors. So suppress them.
	$show_errors       = $wpdb->show_errors;
	$wpdb->show_errors = false;

	$indexable_table = Model::get_table_name( 'Indexable' );

	$included_taxonomies = \YoastSEO()->helpers->taxonomy->get_indexable_taxonomies();

	// phpcs:disable WordPress.DB.PreparedSQL.InterpolatedNotPrepared -- Reason: Too hard to fix.
	if ( empty( $included_taxonomies ) ) {
		$delete_query = "DELETE FROM $indexable_table
			WHERE object_type = 'term'
			AND object_sub_type IS NOT NULL";
	}
	else {
		$delete_query = $wpdb->prepare(
			"DELETE FROM $indexable_table
			WHERE object_type = 'term'
			AND object_sub_type IS NOT NULL
			AND object_sub_type NOT IN ( " . \implode( ', ', \array_fill( 0, \count( $included_taxonomies ), '%s' ) ) . ' )',
			$included_taxonomies
		);
	}
	// phpcs:enable

	// phpcs:disable WordPress.DB.DirectDatabaseQuery.DirectQuery -- Reason: Most performant way.
	// phpcs:disable WordPress.DB.DirectDatabaseQuery.NoCaching -- Reason: No relevant caches.
	// phpcs:disable WordPress.DB.PreparedSQL.NotPrepared -- Reason: Is it prepared already.
	$wpdb->query( $delete_query );
	// phpcs:enable

	$wpdb->show_errors = $show_errors;
}