query( 'DROP TABLE IF EXISTS ' . $wpdb->prefix . $table_name ); } // --- 2. Borrar Opciones de la Tabla `wp_options` (Lista Explícita y Completa) --- $options_to_delete = [ // Opciones principales y de configuración 'advaipbl_settings', 'advaipbl_waf_rules', 'advaipbl_blocked_asns', 'advaipbl_whitelisted_asns', 'advaipbl_blocked_user_agents', 'advaipbl_whitelisted_user_agents', 'advaipbl_ips_whitelist', 'advaipbl_honeypot_urls', // Opciones de sistema y estado 'advaipbl_db_version', 'advaipbl_version_installed', 'advaipbl_run_setup_wizard', 'advaipbl_admin_ip_whitelist_trigger', 'advaipbl_usm_sessions_per_page', 'advaipbl_telemetry_notice_dismissed', 'advaipbl_ip_table_migration_complete', 'advaipbl_legacy_options_cleaned', 'advaipbl_autoload_version', 'advaipbl_spamhaus_asn_list', 'advaipbl_spamhaus_last_update', // Opciones de bloqueo (ahora obsoletas, para limpieza de instalaciones antiguas) 'advaipbl_blocked_ips_manual', 'advaipbl_blocked_ips_404', 'advaipbl_blocked_ips_403', 'advaipbl_blocked_ips_login', 'advaipbl_blocked_ips_geoblock', 'advaipbl_blocked_ips_honeypot', 'advaipbl_blocked_ips_user_agent', 'advaipbl_blocked_ips_waf', 'advaipbl_blocked_ips_threat_score', 'advaipbl_blocked_ips_rate_limit', 'advaipbl_blocked_ips_asn', 'advaipbl_blocked_ips_xmlrpc_block', 'advaipbl_ips_bloqueadas_manual', // Alias en español 'advaipbl_ips_bloqueadas_404', 'advaipbl_ips_bloqueadas_403', 'advaipbl_ips_bloqueadas_login', 'advaipbl_ips_bloqueadas_geoblock', 'advaipbl_ips_bloqueadas_honeypot', 'advaipbl_ips_bloqueadas_user_agent', 'advaipbl_ips_bloqueadas_waf', 'advaipbl_ips_bloqueadas_threat_score', 'advaipbl_ips_bloqueadas_rate_limit', 'advaipbl_ips_bloqueadas_asn', 'advaipbl_ips_bloqueadas_xmlrpc_block', // Opciones de legado con prefijo antiguo (con guion) 'advanced-ip-blocker_ips_bloqueadas_404', 'advanced-ip-blocker_ips_bloqueadas_403', 'advanced-ip-blocker_ips_bloqueadas_login', 'advanced-ip-blocker_ips_bloqueadas_honeypot', 'advanced-ip-blocker_ips_bloqueadas_user_agent', 'advanced-ip-blocker_settings', 'advanced-ip-blocker_blocked_user_agents', 'advanced-ip-blocker_whitelisted_user_agents', 'advanced-ip-blocker_ips_whitelist', 'advanced-ip-blocker_ips_bloqueadas_manual', 'advanced-ip-blocker_honeypot_urls', ]; foreach ( $options_to_delete as $option_name ) { delete_option( $option_name ); } // --- 3. Borrar Transients Relacionados --- // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching $wpdb->query( $wpdb->prepare( "DELETE FROM {$wpdb->options} WHERE `option_name` LIKE %s OR `option_name` LIKE %s", $wpdb->esc_like( '_transient_advaipbl_' ) . '%', $wpdb->esc_like( '_transient_timeout_advaipbl_' ) . '%' ) ); // --- 4. Borrar Metadatos de Usuario de 2FA --- // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching $wpdb->query( $wpdb->prepare( "DELETE FROM {$wpdb->usermeta} WHERE `meta_key` LIKE %s", $wpdb->esc_like( '_advaipbl_2fa_' ) . '%' ) ); // --- Borrar Directorio de GeoIP --- $upload_dir = wp_upload_dir(); $geoip_dir = $upload_dir['basedir'] . '/advaipbl_geoip'; if ( is_dir( $geoip_dir ) ) { // phpcs:disable WordPress.WP.AlternativeFunctions function advaipbl_uninstall_recursive_rmdir( $dir ) { $files = array_diff( scandir( $dir ), array( '.', '..' ) ); foreach ( $files as $file ) { ( is_dir( "$dir/$file" ) ) ? advaipbl_uninstall_recursive_rmdir( "$dir/$file" ) : unlink( "$dir/$file" ); } return rmdir( $dir ); } advaipbl_uninstall_recursive_rmdir( $geoip_dir ); // phpcs:enable WordPress.WP.AlternativeFunctions } } // --- Limpiar Tareas de Cron SIEMPRE --- $cron_hooks = [ 'advaipbl_purge_old_logs_event', 'advaipbl_send_summary_email', 'advaipbl_update_spamhaus_list_event', 'advaipbl_send_telemetry_data_event', 'advaipbl_threat_score_decay_event', 'advaipbl_signature_analysis_event', 'advaipbl_update_geoip_db_event', 'advaipbl_cleanup_expired_cache_event' ]; foreach ($cron_hooks as $hook) { wp_clear_scheduled_hook($hook); }