<?php
/**
 * Peakspire Font Loading Optimizer uninstall cleanup.
 *
 * Removes all plugin data: options, transients, and lock rows.
 * Lock rows use raw SQL because their names embed md5 hashes.
 */

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

// Remove the settings option.
delete_option('fsfix_options');

// Remove the HTML-discovery transient (legacy from v1.0.1, may linger).
delete_transient('fsfix_discovered_fonts');

// Remove all per-stylesheet discovery transients and lock rows.
// Transients may live in wp_options or the object cache; cover both paths.
global $wpdb;

// Discovery transients (fsfix_css_*) — may be stored with or without the
// _transient_ prefix depending on the object-cache backend.
// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching -- Uninstall cleanup: bulk-delete of hashed transient names requires a LIKE query; no WP option API supports wildcard deletion.
$wpdb->query(
    "DELETE FROM {$wpdb->options}
     WHERE option_name LIKE '\\_transient\\_fsf\\_css\\_%'
        OR option_name LIKE '\\_transient\\_timeout\\_fsf\\_css\\_%'
        OR option_name LIKE 'fsf\\_css\\_%'"
);

// Stampede locks (fsfix_lock_*) — always in wp_options (add_option).
// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching -- Uninstall cleanup: lock rows embed md5 hashes; wildcard delete is the only correct removal.
$wpdb->query(
    "DELETE FROM {$wpdb->options}
     WHERE option_name LIKE 'fsf\\_lock\\_%'"
);