<?php

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

global $wpdb;

$x_pixel_options = array(
	'x_pixel_id',
	'x_pixel_capi_token',
	'x_pixel_event_purchase',
	'x_pixel_event_add_to_cart',
	'x_pixel_event_checkout',
	'x_pixel_event_content_view',
);
foreach ( $x_pixel_options as $x_pixel_option ) {
	delete_option( $x_pixel_option );
}

delete_transient( 'x_pixel_activated' );
$wpdb->query(
	$wpdb->prepare(
		"DELETE FROM {$wpdb->options} WHERE option_name LIKE %s OR option_name LIKE %s",
		$wpdb->esc_like( '_transient_x_pixel_' ) . '%',
		$wpdb->esc_like( '_transient_timeout_x_pixel_' ) . '%'
	)
);

$x_pixel_meta_keys = array(
	'_x_pixel_purchase_sent',
	'_x_pixel_purchase_browser_sent',
	'_x_pixel_twclid',
	'_x_pixel_user_agent',
);
foreach ( $x_pixel_meta_keys as $x_pixel_meta_key ) {
	delete_metadata( 'post', 0, $x_pixel_meta_key, '', true );
}

$x_pixel_meta_like = '%' . $wpdb->esc_like( '_x_pixel_' ) . '%';

if ( $wpdb->get_var( $wpdb->prepare( 'SHOW TABLES LIKE %s', $wpdb->prefix . 'wc_orders_meta' ) ) === $wpdb->prefix . 'wc_orders_meta' ) {
	$wpdb->query( $wpdb->prepare( "DELETE FROM {$wpdb->prefix}wc_orders_meta WHERE meta_key LIKE %s", $x_pixel_meta_like ) );
}
if ( $wpdb->get_var( $wpdb->prepare( 'SHOW TABLES LIKE %s', $wpdb->prefix . 'edd_ordermeta' ) ) === $wpdb->prefix . 'edd_ordermeta' ) {
	$wpdb->query( $wpdb->prepare( "DELETE FROM {$wpdb->prefix}edd_ordermeta WHERE meta_key LIKE %s", $x_pixel_meta_like ) );
}
if ( $wpdb->get_var( $wpdb->prepare( 'SHOW TABLES LIKE %s', $wpdb->prefix . 'wpsc_purchasemeta' ) ) === $wpdb->prefix . 'wpsc_purchasemeta' ) {
	$wpdb->query( $wpdb->prepare( "DELETE FROM {$wpdb->prefix}wpsc_purchasemeta WHERE meta_key LIKE %s", $x_pixel_meta_like ) );
}

wp_cache_flush();