<?php
/**
 * Removes everything the plugin stored.
 *
 * @package KnowScapes_AI_Client
 */

defined( 'WP_UNINSTALL_PLUGIN' ) || exit;

/**
 * Delete the plugin's options, its counter table and every transient it
 * created, for one site.
 *
 * Transients are deleted through the API first so an external object cache
 * (Redis, Memcached) is cleared too, then any rows left in the options table are
 * removed for installations that store transients there.
 *
 * @return void
 */
function knowscapes_ai_client_uninstall_site() {
	global $wpdb;

	delete_option( 'knowscapes_ai_client_settings' );
	delete_option( 'knowscapes_ai_client_rate_schema' );
	delete_transient( 'knowscapes_ai_client_request_throttle' );

	// The rate-limit counters (since 2.3.1).
	// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.DirectDatabaseQuery.SchemaChange -- Removing the plugin's own table on uninstall.
	$wpdb->query( $wpdb->prepare( 'DROP TABLE IF EXISTS %i', $wpdb->prefix . 'knowscapes_ai_client_rate' ) );

	$like_transient = $wpdb->esc_like( '_transient_knowscapes_ai_client_' ) . '%';

	// phpcs:disable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching
	$names = $wpdb->get_col(
		$wpdb->prepare(
			"SELECT option_name FROM {$wpdb->options} WHERE option_name LIKE %s",
			$like_transient
		)
	);

	// Go through the API so an external object cache drops them as well.
	if ( is_array( $names ) ) {
		foreach ( $names as $option_name ) {
			delete_transient( substr( $option_name, strlen( '_transient_' ) ) );
		}
	}

	// Sweep up anything the API left behind, including orphaned timeout rows.
	$wpdb->query(
		$wpdb->prepare(
			"DELETE FROM {$wpdb->options} WHERE option_name LIKE %s OR option_name LIKE %s",
			$like_transient,
			$wpdb->esc_like( '_transient_timeout_knowscapes_ai_client_' ) . '%'
		)
	);
	// phpcs:enable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching
}

if ( is_multisite() ) {
	// A network uninstall has to clear every site, not just the current one.
	$knowscapes_ai_client_site_ids = get_sites(
		array(
			'fields'                 => 'ids',
			'number'                 => 0,
			'update_site_meta_cache' => false,
		)
	);

	foreach ( $knowscapes_ai_client_site_ids as $knowscapes_ai_client_site_id ) {
		switch_to_blog( $knowscapes_ai_client_site_id );
		knowscapes_ai_client_uninstall_site();
		restore_current_blog();
	}
} else {
	knowscapes_ai_client_uninstall_site();
}