<?php
/**
 * Uninstall routine.
 *
 * Nothing is removed unless the site owner opted in under Settings.
 *
 * Teardown runs once, on delete, and has to reach rows that core offers no API
 * for (meta by key pattern, the custom statistics table), so the direct queries
 * below are unavoidable. Caching them would be meaningless — the object cache is
 * flushed at the end instead.
 *
 * @package Stunning_Related
 */

defined( 'WP_UNINSTALL_PLUGIN' ) || exit;

global $wpdb;

$srpp_settings = get_option( 'srpp_settings', array() );

if ( empty( $srpp_settings['uninstall_delete'] ) ) {
	return;
}

// phpcs:disable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.DirectDatabaseQuery.SchemaChange, WordPress.DB.PreparedSQL.InterpolatedNotPrepared, PluginCheck.Security.DirectDB.UnescapedDBParameter -- One-time uninstall teardown; see the file header.

// Display rules.
$srpp_ids = $wpdb->get_col(
	$wpdb->prepare( "SELECT ID FROM {$wpdb->posts} WHERE post_type = %s", 'srpp_display' )
);

foreach ( $srpp_ids as $srpp_id ) {
	wp_delete_post( (int) $srpp_id, true );
}

// Cached recommendation lists and per-post overrides.
$wpdb->query(
	$wpdb->prepare(
		"DELETE FROM {$wpdb->postmeta} WHERE meta_key LIKE %s OR meta_key = %s",
		$wpdb->esc_like( '_srpp_rel_' ) . '%',
		'_srpp_override'
	)
);

// Statistics table. The name is built from $wpdb->prefix, never from input.
$srpp_table = $wpdb->prefix . 'srpp_stats';
$wpdb->query( "DROP TABLE IF EXISTS {$srpp_table}" );

// phpcs:enable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.DirectDatabaseQuery.SchemaChange, WordPress.DB.PreparedSQL.InterpolatedNotPrepared, PluginCheck.Security.DirectDB.UnescapedDBParameter

// Options and schedules.
delete_option( 'srpp_settings' );
delete_option( 'srpp_db_version' );
delete_option( 'srpp_cache_version' );
delete_option( 'srpp_seeded' );
delete_option( 'srpp_stats_version' );

wp_clear_scheduled_hook( 'srpp_cleanup_event' );

wp_cache_flush();