<?php
/**
 * Remove the plugin's configuration and temporary per-user scan state.
 *
 * Existing media remains valid and is never removed on uninstall.
 */

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

delete_option( 'uploadally_options' );
delete_metadata( 'post', 0, '_uploadally_browser_upload_review', '', true );
delete_metadata( 'post', 0, '_uploadally_upload_receipt', '', true );
delete_metadata( 'user', 0, '_uploadally_unused_media_scan', '', true );
delete_metadata( 'user', 0, '_uploadally_unused_media_candidates', '', true );
delete_metadata( 'user', 0, '_uploadally_unused_media_reference_files', '', true );

global $wpdb;
$wpdb->query( // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- One-time removal of this plugin's transient/lock rows during uninstall; no cached result is reused.
	$wpdb->prepare(
		"DELETE FROM {$wpdb->options} WHERE option_name LIKE %s OR option_name LIKE %s",
		$wpdb->esc_like( '_transient__uploadally_library_scan_' ) . '%',
		$wpdb->esc_like( '_transient_timeout__uploadally_library_scan_' ) . '%'
	)
); // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.PreparedSQL.InterpolatedNotPrepared

$uploadally_review_prefix = $wpdb->esc_like( 'uploadally_review_lock_' ) . '%';
$uploadally_conversion_prefix = $wpdb->esc_like( 'uploadally_conversion_lock_' ) . '%';
$wpdb->query( $wpdb->prepare( "DELETE FROM {$wpdb->options} WHERE option_name LIKE %s OR option_name LIKE %s", $uploadally_review_prefix, $uploadally_conversion_prefix ) ); // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQL.InterpolatedNotPrepared -- One-time removal of this plugin's transient/lock rows during uninstall; no cached result is reused.