<?php
/**
 * Uninstall script for Addon Submission Blocker for Gravityforms
 * 
 * This file is executed when the plugin is deleted via the WordPress admin.
 */

if ( ! defined( 'WP_UNINSTALL_PLUGIN' ) ) {
    exit;
}

global $wpdb;

// Delete all plugin options
// phpcs:ignore WordPress.NamingConventions.PrefixAllGlobals.NonPrefixedVariableFound -- Local variable in uninstall file, not a global
$options = [
    'asbfg_blocked_ips',
    'asbfg_blocked_emails',
    'asbfg_blocked_domains',
    'asbfg_blocked_countries',
    'asbfg_blocked_text',
    'asbfg_custom_ip_message',
    'asbfg_custom_email_message',
    'asbfg_custom_domain_message',
    'asbfg_custom_country_message',
    'asbfg_custom_text_message',
    'asbfg_log_retention_days',
];

// phpcs:ignore WordPress.NamingConventions.PrefixAllGlobals.NonPrefixedVariableFound -- Local variable in uninstall file, not a global
foreach ( $options as $option ) {
    delete_option( $option );
}

// Clear scheduled events
wp_clear_scheduled_hook( 'asbfg_cleanup_old_logs' );

// Delete transients (country cache and rate limiting)
// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- Required for cleanup during uninstall
$wpdb->query( "DELETE FROM {$wpdb->options} WHERE option_name LIKE '_transient_asbfg_%'" );
// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- Required for cleanup during uninstall
$wpdb->query( "DELETE FROM {$wpdb->options} WHERE option_name LIKE '_transient_timeout_asbfg_%'" );

// Drop the logs table
// phpcs:ignore WordPress.NamingConventions.PrefixAllGlobals.NonPrefixedVariableFound -- Local variable in uninstall file, not a global
$table_name = esc_sql( $wpdb->prefix . 'asbfg_blocked_logs' );
// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.DirectDatabaseQuery.SchemaChange, WordPress.DB.PreparedSQL.InterpolatedNotPrepared -- Required for cleanup during uninstall, table name is safe (uses wpdb prefix and esc_sql)
$wpdb->query( "DROP TABLE IF EXISTS {$table_name}" );