noamK-2

/**
 * Fix corrupted page builder package strings (wrong name and/or duplicates).
 *
 * @see https://onthegosystems.myjetbrains.com/youtrack/issue/wpmlcore-6913
 */
function wpmlcore_6913_fix_corrupted_package_strings() {
	global $wpdb;

	// Will collect all package string with a wrong name.
	$allCorrupted = wpml_collect( $wpdb->get_results(
		"SELECT
			s1.id,
			s1.string_package_id,
			s1.value,
			s1.name,
			s2.id AS duplicate_of_valid_id
		FROM {$wpdb->prefix}icl_strings AS s1
		LEFT JOIN {$wpdb->prefix}icl_strings AS s2 ON s2.name = MD5(s1.value)
		WHERE s1.string_package_id IS NOT NULL
			AND s1.name <> MD5(s1.value)
		ORDER BY s1.id"
	) )->keyBy( 'id' );

	if ( ! $allCorrupted->count() ) {
		return;
	}

	// duplicated string of a valid one => to delete
	$duplicatesOfNonCorrupted = $allCorrupted->filter( function( $string ) { return (bool) $string->duplicate_of_valid_id; } );
	// duplicated string with no valid one => keep the latest version and remove the other duplicates
	$corruptedDuplicates = $allCorrupted->diffKeys( $duplicatesOfNonCorrupted );

	// We'll keep the highest string id only
	$duplicatesToKeepAsUnique = $corruptedDuplicates
		->reduce( function( \WPML\Collect\Support\Collection $carry, $string ) {
			// Duplicated value/package_id will be overwritten.
			$key = md5( $string->string_package_id . $string->value );
			$carry->put( $key, $string );

			return $carry;
		}, wpml_collect() )
		->keyBy( 'id' );

	$duplicatesToDelete = $corruptedDuplicates->diffKeys( $duplicatesToKeepAsUnique );
	$stringIdsToDelete  = $duplicatesOfNonCorrupted->merge( $duplicatesToDelete )->pluck( 'id' )->toArray();

	if ( $stringIdsToDelete ) {
		wpml_unregister_string_multi( $stringIdsToDelete );
	}

	if ( $duplicatesToKeepAsUnique->count() ) {
		$wpdb->query(
			"UPDATE {$wpdb->prefix}icl_strings
		SET
			name = MD5(value),
			domain_name_context_md5 = MD5(CONCAT(context,MD5(value),gettext_context))
		WHERE id IN(" . $duplicatesToKeepAsUnique->implode( 'id', ',' ) . ")"
		);
	}
}
add_action( 'admin_footer', 'wpmlcore_6913_fix_corrupted_package_strings' );