<?php
/**
 * Remove AiVisibility SEO-GEO Agent data when WordPress uninstalls the plugin.
 */

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

wp_clear_scheduled_hook('aivisseogeo_process_scan_queue');

foreach (
    array(
        'aiseo_auditor_version',
        'aiseo_business_address',
        'aiseo_business_phone',
        'aiseo_business_email',
        'aiseo_geo_mode',
        'aiseo_ai_profile',
        'aiseo_license_key',
        'aiseo_requests_remaining',
        'aiseo_first_requests_registered',
        'aiseo_first_requests_status',
        'aiseo_seo_strategy',
        'aiseo_strategy_saved',
    ) as $option_name
) {
    delete_option($option_name);
    delete_site_option($option_name);
}

global $wpdb;

$wpdb->query($wpdb->prepare("DELETE FROM {$wpdb->options} WHERE option_name LIKE %s", $wpdb->esc_like('aiseo_') . '%'));
$wpdb->query($wpdb->prepare("DELETE FROM {$wpdb->options} WHERE option_name LIKE %s", $wpdb->esc_like('aivisseogeo_') . '%'));
$wpdb->query($wpdb->prepare("DELETE FROM {$wpdb->options} WHERE option_name LIKE %s", $wpdb->esc_like('_transient_aiseo_') . '%'));
$wpdb->query($wpdb->prepare("DELETE FROM {$wpdb->options} WHERE option_name LIKE %s", $wpdb->esc_like('_transient_timeout_aiseo_') . '%'));
$wpdb->query($wpdb->prepare("DELETE FROM {$wpdb->options} WHERE option_name LIKE %s", $wpdb->esc_like('_transient_aivisseogeo_') . '%'));
$wpdb->query($wpdb->prepare("DELETE FROM {$wpdb->options} WHERE option_name LIKE %s", $wpdb->esc_like('_transient_timeout_aivisseogeo_') . '%'));
$wpdb->query($wpdb->prepare("DELETE FROM {$wpdb->postmeta} WHERE meta_key LIKE %s", $wpdb->esc_like('_aiseo_') . '%'));
$wpdb->query($wpdb->prepare("DELETE FROM {$wpdb->postmeta} WHERE meta_key LIKE %s", $wpdb->esc_like('_aivisseogeo_') . '%'));