<?php
/**
 * Uninstall cleanup: remove options, custom tables, transients and post meta.
 *
 * All work runs inside a prefixed function so no unprefixed globals are
 * introduced at file scope.
 *
 * @package AICitare
 */

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

/**
 * Remove every trace of the plugin from the database.
 *
 * @return void
 */
function aicitare_uninstall_cleanup() {
	global $wpdb;

	$aicitare_options = array(
		'aicitare_pages',
		'aicitare_fixed',
		'aicitare_bots',
		'aicitare_settings',
		'aicitare_history',
		'aicitare_page_hist',
		'aicitare_gsc',
		'aicitare_docker_cutoff',
		'aicitare_citations_live',
		'aicitare_vis_checked',
		'aicitare_engine_status',
		'aicitare_answers',
		'aicitare_vis_history',
		'aicitare_competitors',
		'aicitare_share',
		'aicitare_discovered',
		'aicitare_prompts',
		'aicitare_db_ver',
	);
	foreach ( $aicitare_options as $aicitare_opt ) {
		delete_option( $aicitare_opt );
	}

	// Drop custom tables.
	foreach ( array( 'aicitare_bot_hits', 'aicitare_logs', 'aicitare_ai_refs' ) as $aicitare_suffix ) {
		$aicitare_table = $wpdb->prefix . $aicitare_suffix;
		$wpdb->query( "DROP TABLE IF EXISTS {$aicitare_table}" ); // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQL.InterpolatedNotPrepared, WordPress.DB.DirectDatabaseQuery.SchemaChange, PluginCheck.Security.DirectDB.UnescapedDBParameter -- one-time uninstall cleanup; table name is $wpdb->prefix + a hardcoded literal.
	}

	// Remove link-check transients (aicitare_lnk2_*).
	$wpdb->query( "DELETE FROM {$wpdb->options} WHERE option_name LIKE '\_transient\_aicitare_lnk2\_%' OR option_name LIKE '\_transient\_timeout\_aicitare_lnk2\_%'" ); // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, PluginCheck.Security.DirectDB.UnescapedDBParameter

	// Remove per-post meta the plugin created.
	$aicitare_meta_keys = array(
		'_aicitare_import_source',
		'_aicitare_rephrase_source',
		'_aicitare_faq',
		'_aicitare_pros',
		'_aicitare_cons',
		'_aicitare_table',
		'_aicitare_rating',
		'_aicitare_rating_count',
		'_aicitare_reviewer',
		'_aicitare_price',
		'_aicitare_currency',
	);
	foreach ( $aicitare_meta_keys as $aicitare_meta_key ) {
		delete_post_meta_by_key( $aicitare_meta_key );
	}
}

aicitare_uninstall_cleanup();