<?php
/**
 * Uninstall AHA Mail SMTP
 * 
 * This file is executed when the plugin is deleted via the WordPress admin.
 * It removes all plugin data from the database.
 */

// Prevent direct access
if (!defined('WP_UNINSTALL_PLUGIN')) {
    exit;
}

// Remove all plugin options
$options_to_delete = array(
    'aha_mail_smtp_smtp_host',
    'aha_mail_smtp_smtp_port',
    'aha_mail_smtp_smtp_encryption',
    'aha_mail_smtp_smtp_auth',
    'aha_mail_smtp_smtp_username',
    'aha_mail_smtp_smtp_password',
    'aha_mail_smtp_from_email',
    'aha_mail_smtp_from_name',
    'aha_mail_smtp_force_from',
    'aha_mail_smtp_force_from_email',
    'aha_mail_smtp_force_from_name',
    'aha_mail_smtp_reply_to_email',
    'aha_mail_smtp_return_path',
    'aha_mail_smtp_enable_logging',
    'aha_mail_smtp_debug_mode',
    'aha_mail_smtp_provider',
    'aha_mail_smtp_connection_mode',
    'aha_mail_smtp_api_key',
    'aha_mail_smtp_api_secret',
    'aha_mail_smtp_api_domain',
    'aha_mail_smtp_api_region',
    'aha_mail_smtp_client_id',
    'aha_mail_smtp_client_secret',
    'aha_mail_smtp_oauth_access_token',
    'aha_mail_smtp_oauth_refresh_token',
    'aha_mail_smtp_oauth_provider',
    'aha_mail_smtp_oauth_expires_at',
    'aha_mail_smtp_wizard_completed',
    'aha_mail_smtp_wizard_skipped',
    'aha_mail_smtp_security_logs'
);

foreach ($options_to_delete as $option) {
    delete_option($option);
    
    // For multisite, also delete from each site
    if (is_multisite()) {
        delete_site_option($option);
    }
}

// Drop email logs table
global $wpdb;

$table_name = $wpdb->prefix . 'aha_mail_smtp_logs';
$wpdb->query("DROP TABLE IF EXISTS $table_name");

// For multisite, drop table from each site
if (is_multisite()) {
    $sites = get_sites();
    foreach ($sites as $site) {
        switch_to_blog($site->blog_id);
        $table_name = $wpdb->prefix . 'aha_mail_smtp_logs';
        $wpdb->query("DROP TABLE IF EXISTS $table_name");
        restore_current_blog();
    }
}

// Clear any scheduled events
wp_clear_scheduled_hook('aha_mail_smtp_cleanup_logs');

// Clear any transients
$wpdb->query("DELETE FROM {$wpdb->options} WHERE option_name LIKE '_transient_aha_mail_smtp_%'");
$wpdb->query("DELETE FROM {$wpdb->options} WHERE option_name LIKE '_transient_timeout_aha_mail_smtp_%'");

// For multisite, clear transients from each site
if (is_multisite()) {
    $sites = get_sites();
    foreach ($sites as $site) {
        switch_to_blog($site->blog_id);
        $wpdb->query("DELETE FROM {$wpdb->options} WHERE option_name LIKE '_transient_aha_mail_smtp_%'");
        $wpdb->query("DELETE FROM {$wpdb->options} WHERE option_name LIKE '_transient_timeout_aha_mail_smtp_%'");
        restore_current_blog();
    }
}