uninstall.php

<?php
/**
 * Plugin uninstall cleanup for Ultimate SEO WP.
 *
 * @package UltimateSEOWP
 */

if (!defined('WP_UNINSTALL_PLUGIN')) {
    exit;
}

/**
 * Remove all plugin data for the current site.
 */
function useo_uninstall_cleanup_site_data() {
    global $wpdb;

    $option_keys = [
        'useo_features',
        'useo_meta_defaults',
        'useo_og_defaults',
        'useo_twitter_defaults',
        'useo_website_profile',
        'useo_sitemap_settings',
        'useo_robots_txt',
        'useo_llms_txt',
        'useo_analysis_settings',
        'useo_indexnow_settings',
        'useo_indexnow_queue',
        'useo_advanced_settings',
        'useo_data_version',
        'useo_license_key',
        'useo_license_status',
        'useo_license_last_check',
        'useo_license_domain',
        'useo_license_error',
        'useo_store_api_base',
        'useo_update_info_cache',
    ];

    foreach ($option_keys as $option_key) {
        delete_option($option_key);
    }

    wp_clear_scheduled_hook('useo_indexnow_process_queue');

    $post_meta_keys = [
        '_useo_title',
        '_useo_description',
        '_useo_target_keyword',
        '_useo_target_keywords',
        '_useo_keyword_synonyms',
        '_useo_internal_links_outbound',
        '_useo_internal_links_inbound',
        '_useo_canonical',
        '_useo_robots',
        '_useo_og_title',
        '_useo_og_description',
        '_useo_og_image',
        '_useo_twitter_title',
        '_useo_twitter_description',
        '_useo_twitter_image',
        '_useo_schema_json',
    ];

    $term_meta_keys = [
        '_useo_title',
        '_useo_description',
        '_useo_canonical',
        '_useo_robots',
        '_useo_og_title',
        '_useo_og_description',
        '_useo_og_image',
        '_useo_twitter_title',
        '_useo_twitter_description',
        '_useo_twitter_image',
    ];

    $post_meta_placeholders = implode(', ', array_fill(0, count($post_meta_keys), '%s'));
    $term_meta_placeholders = implode(', ', array_fill(0, count($term_meta_keys), '%s'));

    // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
    $wpdb->query($wpdb->prepare("DELETE FROM {$wpdb->postmeta} WHERE meta_key IN ({$post_meta_placeholders})", $post_meta_keys));
    // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
    $wpdb->query($wpdb->prepare("DELETE FROM {$wpdb->termmeta} WHERE meta_key IN ({$term_meta_placeholders})", $term_meta_keys));

    // Remove analysis and admin notice transients written by the plugin.
    $wpdb->query("DELETE FROM {$wpdb->options} WHERE option_name LIKE '_transient_useo_analysis_%'");
    $wpdb->query("DELETE FROM {$wpdb->options} WHERE option_name LIKE '_transient_timeout_useo_analysis_%'");
    $wpdb->query("DELETE FROM {$wpdb->options} WHERE option_name LIKE '_transient_useo_license_notice_%'");
    $wpdb->query("DELETE FROM {$wpdb->options} WHERE option_name LIKE '_transient_timeout_useo_license_notice_%'");

    $wpdb->query("DROP TABLE IF EXISTS {$wpdb->prefix}useo_redirects");
    $wpdb->query("DROP TABLE IF EXISTS {$wpdb->prefix}useo_internal_links");
}

if (is_multisite()) {
    $site_ids = get_sites([
        'fields' => 'ids',
        'number' => 0,
    ]);
    $current_blog_id = get_current_blog_id();

    foreach ($site_ids as $site_id) {
        switch_to_blog((int) $site_id);
        useo_uninstall_cleanup_site_data();
    }

    switch_to_blog($current_blog_id);
} else {
    useo_uninstall_cleanup_site_data();
}