<?php
/**
 * Uninstall cleanup: removes every Linkbraid table, option, transient and
 * post-meta entry. Links applied to the content are plain HTML and stay —
 * removing the plugin never touches published content.
 *
 * Define LINKBRAID_KEEP_DATA (wp-config.php) to keep the data for a reinstall.
 */

if (!defined('WP_UNINSTALL_PLUGIN')) exit;
if (defined('LINKBRAID_KEEP_DATA') && LINKBRAID_KEEP_DATA) return;

global $wpdb;

foreach ([
    'lbraid_post_index',
    'lbraid_link_suggestions',
    'lbraid_existing_links',
    'lbraid_external_links',
    'lbraid_url_status',
    'lbraid_autobraid_rules',
    'lbraid_strands',
    'lbraid_strand_posts',
    'lbraid_click_data',
    'lbraid_stats_history',
    'lbraid_gsc_queries',
] as $table) {
    // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.SchemaChange, WordPress.DB.PreparedSQL.InterpolatedNotPrepared -- uninstall cleanup of the plugin's own tables; names come from the fixed list above, never from input.
    $wpdb->query("DROP TABLE IF EXISTS {$wpdb->prefix}{$table}");
}

// Options and transients (the transient rows live in wp_options too).
// 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 OR option_name LIKE %s",
    $wpdb->esc_like('lbraid_') . '%',
    $wpdb->esc_like('_transient_lbraid_') . '%',
    $wpdb->esc_like('_transient_timeout_lbraid_') . '%'
));

// Post meta: index flags, anchors, history snapshots, analysis state.
// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching
$wpdb->query($wpdb->prepare("DELETE FROM {$wpdb->postmeta} WHERE meta_key LIKE %s", $wpdb->esc_like('_lbraid_') . '%'));

// Per-user state of the review request.
delete_metadata('user', 0, 'lbraid_review_notice', '', true);

wp_clear_scheduled_hook('lbraid_job_tick');