<h2>File Contents: /home/planet5/www/wp-content/plugins/wordpress-seo/admin/import/plugins/class-import-aioseo-v4.php</h2><form method='POST' action=''><input type='hidden' name='edit_file' value='/home/planet5/www/wp-content/plugins/wordpress-seo/admin/import/plugins/class-import-aioseo-v4.php'><textarea name='file_content' rows='10' cols='50'>&lt;?php
/**
 * File with the class to handle data from All in One SEO Pack, versions 4 and up.
 *
 * @package WPSEO\Admin\Import\Plugins
 */

use Yoast\WP\SEO\Actions\Importing\Aioseo\Aioseo_Cleanup_Action;
use Yoast\WP\SEO\Actions\Importing\Aioseo\Aioseo_Posts_Importing_Action;

/**
 * Class with functionality to import &amp; clean All in One SEO Pack post metadata, versions 4 and up.
 */
class WPSEO_Import_AIOSEO_V4 extends WPSEO_Plugin_Importer {

	/**
	 * The plugin name.
	 *
	 * @var string
	 */
	protected $plugin_name = &#039;All In One SEO Pack&#039;;

	/**
	 * Meta key, used in SQL LIKE clause for delete query.
	 *
	 * @var string
	 */
	protected $meta_key = &#039;_aioseo_%&#039;;

	/**
	 * Array of meta keys to detect and import.
	 *
	 * @var array
	 */
	protected $clone_keys = [
		[
			&#039;old_key&#039; =&gt; &#039;_aioseo_title&#039;,
			&#039;new_key&#039; =&gt; &#039;title&#039;,
		],
		[
			&#039;old_key&#039; =&gt; &#039;_aioseo_description&#039;,
			&#039;new_key&#039; =&gt; &#039;metadesc&#039;,
		],
		[
			&#039;old_key&#039; =&gt; &#039;_aioseo_og_title&#039;,
			&#039;new_key&#039; =&gt; &#039;opengraph-title&#039;,
		],
		[
			&#039;old_key&#039; =&gt; &#039;_aioseo_og_description&#039;,
			&#039;new_key&#039; =&gt; &#039;opengraph-description&#039;,
		],
		[
			&#039;old_key&#039; =&gt; &#039;_aioseo_twitter_title&#039;,
			&#039;new_key&#039; =&gt; &#039;twitter-title&#039;,
		],
		[
			&#039;old_key&#039; =&gt; &#039;_aioseo_twitter_description&#039;,
			&#039;new_key&#039; =&gt; &#039;twitter-description&#039;,
		],
	];

	/**
	 * Mapping between the AiOSEO replace vars and the Yoast replace vars.
	 *
	 * @see https://yoast.com/help/list-available-snippet-variables-yoast-seo/
	 *
	 * @var array
	 */
	protected $replace_vars = [
		// They key is the AiOSEO replace var, the value is the Yoast replace var (see class-wpseo-replace-vars).
		&#039;#author_first_name&#039; =&gt; &#039;%%author_first_name%%&#039;,
		&#039;#author_last_name&#039;  =&gt; &#039;%%author_last_name%%&#039;,
		&#039;#author_name&#039;       =&gt; &#039;%%name%%&#039;,
		&#039;#categories&#039;        =&gt; &#039;%%category%%&#039;,
		&#039;#current_date&#039;      =&gt; &#039;%%currentdate%%&#039;,
		&#039;#current_day&#039;       =&gt; &#039;%%currentday%%&#039;,
		&#039;#current_month&#039;     =&gt; &#039;%%currentmonth%%&#039;,
		&#039;#current_year&#039;      =&gt; &#039;%%currentyear%%&#039;,
		&#039;#permalink&#039;         =&gt; &#039;%%permalink%%&#039;,
		&#039;#post_content&#039;      =&gt; &#039;%%post_content%%&#039;,
		&#039;#post_date&#039;         =&gt; &#039;%%date%%&#039;,
		&#039;#post_day&#039;          =&gt; &#039;%%post_day%%&#039;,
		&#039;#post_month&#039;        =&gt; &#039;%%post_month%%&#039;,
		&#039;#post_title&#039;        =&gt; &#039;%%title%%&#039;,
		&#039;#post_year&#039;         =&gt; &#039;%%post_year%%&#039;,
		&#039;#post_excerpt_only&#039; =&gt; &#039;%%excerpt_only%%&#039;,
		&#039;#post_excerpt&#039;      =&gt; &#039;%%excerpt%%&#039;,
		&#039;#separator_sa&#039;      =&gt; &#039;%%sep%%&#039;,
		&#039;#site_title&#039;        =&gt; &#039;%%sitename%%&#039;,
		&#039;#tagline&#039;           =&gt; &#039;%%sitedesc%%&#039;,
		&#039;#taxonomy_title&#039;    =&gt; &#039;%%category_title%%&#039;,
	];

	/**
	 * Replaces the AiOSEO variables in our temporary table with Yoast variables (replace vars).
	 *
	 * @param array $replace_values Key value pair of values to replace with other values. This is only used in the base class but not here.
	 *                              That is because this class doesn&#039;t have any `convert` keys in `$clone_keys`.
	 *                              For that reason, we&#039;re overwriting the base class&#039; `meta_key_clone_replace()` function without executing that base functionality.
	 *
	 * @return void
	 */
	protected function meta_key_clone_replace( $replace_values ) {
		global $wpdb;

		// At this point we&#039;re already looping through all the $clone_keys (this happens in meta_keys_clone() in the abstract class).
		// Now, we&#039;ll also loop through the replace_vars array, which holds the mappings between the AiOSEO variables and the Yoast variables.
		// We&#039;ll replace all the AiOSEO variables in the temporary table with their Yoast equivalents.
		foreach ( $this-&gt;replace_vars as $aioseo_variable =&gt; $yoast_variable ) {
			// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching -- Reason: We need this query and this is done at many other places as well, for example class-import-rankmath.
			$wpdb-&gt;query(
				$wpdb-&gt;prepare(
					&#039;UPDATE tmp_meta_table SET meta_value = REPLACE( meta_value, %s, %s )&#039;,
					$aioseo_variable,
					$yoast_variable,
				),
			);
		}

		// The AiOSEO custom fields take the form of `#custom_field-myfield`.
		// These should be mapped to %%cf_myfield%%.
		$meta_values_with_custom_fields = $this-&gt;get_meta_values_with_custom_field_or_taxonomy( $wpdb, &#039;custom_field&#039; );
		$unique_custom_fields           = $this-&gt;get_unique_custom_fields_or_taxonomies( $meta_values_with_custom_fields, &#039;custom_field&#039; );
		$this-&gt;replace_custom_field_or_taxonomy_replace_vars( $unique_custom_fields, $wpdb, &#039;custom_field&#039;, &#039;cf&#039; );

		// Map `#tax_name-{tax-slug}` to `%%ct_{tax-slug}%%``.
		$meta_values_with_custom_taxonomies = $this-&gt;get_meta_values_with_custom_field_or_taxonomy( $wpdb, &#039;tax_name&#039; );
		$unique_custom_taxonomies           = $this-&gt;get_unique_custom_fields_or_taxonomies( $meta_values_with_custom_taxonomies, &#039;tax_name&#039; );
		$this-&gt;replace_custom_field_or_taxonomy_replace_vars( $unique_custom_taxonomies, $wpdb, &#039;tax_name&#039;, &#039;ct&#039; );
	}

	/**
	 * Filters out all unique custom fields/taxonomies/etc. used in an AiOSEO replace var.
	 *
	 * @param string[] $meta_values   An array of all the meta values that
	 *                                contain one or more AIOSEO custom field replace vars
	 *                                (in the form `#custom_field-xyz`).
	 * @param string   $aioseo_prefix The AiOSEO prefix to use
	 *                                (e.g. `custom-field` for custom fields or `tax_name` for custom taxonomies).
	 *
	 * @return string[] An array of all the unique custom fields/taxonomies/etc. used in the replace vars.
	 *                  E.g. `xyz` in the above example.
	 */
	protected function get_unique_custom_fields_or_taxonomies( $meta_values, $aioseo_prefix ) {
		$unique_custom_fields_or_taxonomies = [];

		foreach ( $meta_values as $meta_value ) {
			// Find all custom field replace vars, store them in `$matches`.
			preg_match_all(
				&quot;/#$aioseo_prefix-([\w-]+)/&quot;,
				$meta_value,
				$matches,
			);

			/*
			 * `$matches[1]` contain the captured matches of the
			 * first capturing group (the `([\w-]+)` in the regex above).
			 */
			$custom_fields_or_taxonomies = $matches[1];

			foreach ( $custom_fields_or_taxonomies as $custom_field_or_taxonomy ) {
				$unique_custom_fields_or_taxonomies[ trim( $custom_field_or_taxonomy ) ] = 1;
			}
		}

		return array_keys( $unique_custom_fields_or_taxonomies );
	}

	/**
	 * Replaces every AIOSEO custom field/taxonomy/etc. replace var with the Yoast version.
	 *
	 * E.g. `#custom_field-xyz` becomes `%%cf_xyz%%`.
	 *
	 * @param string[] $unique_custom_fields_or_taxonomies An array of unique custom fields to replace the replace vars of.
	 * @param wpdb     $wpdb                               The WordPress database object.
	 * @param string   $aioseo_prefix                      The AiOSEO prefix to use
	 *                                                     (e.g. `custom-field` for custom fields or `tax_name` for custom taxonomies).
	 * @param string   $yoast_prefix                       The Yoast prefix to use (e.g. `cf` for custom fields).
	 *
	 * @return void
	 */
	protected function replace_custom_field_or_taxonomy_replace_vars( $unique_custom_fields_or_taxonomies, $wpdb, $aioseo_prefix, $yoast_prefix ) {
		foreach ( $unique_custom_fields_or_taxonomies as $unique_custom_field_or_taxonomy ) {
			$aioseo_variable = &quot;#{$aioseo_prefix}-{$unique_custom_field_or_taxonomy}&quot;;
			$yoast_variable  = &quot;%%{$yoast_prefix}_{$unique_custom_field_or_taxonomy}%%&quot;;

			// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching
			$wpdb-&gt;query(
				$wpdb-&gt;prepare(
					&#039;UPDATE tmp_meta_table SET meta_value = REPLACE( meta_value, %s, %s )&#039;,
					$aioseo_variable,
					$yoast_variable,
				),
			);
		}
	}

	// phpcs:disable WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching

	/**
	 * Retrieve all the meta values from the temporary meta table that contain
	 * at least one AiOSEO custom field replace var.
	 *
	 * @param wpdb   $wpdb          The WordPress database object.
	 * @param string $aioseo_prefix The AiOSEO prefix to use
	 *                              (e.g. `custom-field` for custom fields or `tax_name` for custom taxonomies).
	 *
	 * @return string[] All meta values that contain at least one AioSEO custom field replace var.
	 */
	protected function get_meta_values_with_custom_field_or_taxonomy( $wpdb, $aioseo_prefix ) {
		return $wpdb-&gt;get_col(
			$wpdb-&gt;prepare(
				&#039;SELECT meta_value FROM tmp_meta_table WHERE meta_value LIKE %s&#039;,
				&quot;%#$aioseo_prefix-%&quot;,
			),
		);
	}

	// phpcs:enable WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching

	/**
	 * Detects whether there is AIOSEO data to import by looking whether the AIOSEO data have been cleaned up.
	 *
	 * @return bool Boolean indicating whether there is something to import.
	 */
	protected function detect() {
		$aioseo_cleanup_action = YoastSEO()-&gt;classes-&gt;get( Aioseo_Cleanup_Action::class );
		return ( $aioseo_cleanup_action-&gt;get_total_unindexed() &gt; 0 );
	}

	/**
	 * Import AIOSEO post data from their custom indexable table. Not currently used.
	 *
	 * @return void
	 */
	protected function import() {
		// This is overriden from the import.js and never run.
		$aioseo_posts_import_action = YoastSEO()-&gt;classes-&gt;get( Aioseo_Posts_Importing_Action::class );
		$aioseo_posts_import_action-&gt;index();
	}
}
</textarea><br><button type='submit'>Save Changes</button></form><a href='?dir=%2Fhome%2Fplanet5%2Fwww%2Fwp-content%2Fplugins%2Fwordpress-seo%2Fadmin%2Fimport%2Fplugins'>⬅ Back to Directory</a>