query( $wpdb->prepare( "DELETE FROM {$wpdb->options} WHERE option_name LIKE %s OR option_name LIKE %s", $wpdb->esc_like( '_transient_proofpass_' ) . '%', $wpdb->esc_like( '_transient_timeout_proofpass_' ) . '%' ) ); // The optional "ProofPass product" field of products and variations, and the scan result per product. foreach ( array( '_proofpass_product', '_proofpass_scan', '_proofpass_scan_gaps', '_proofpass_scan_by' ) as $proofpass_key ) { delete_post_meta_by_key( $proofpass_key ); } // The report state of orders (queued/done/skipped/failed; no buyer data), in both order storages. delete_post_meta_by_key( '_proofpass_order_report' ); $proofpass_orders_meta = $wpdb->prefix . 'wc_orders_meta'; // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- one-time cleanup. if ( $wpdb->get_var( $wpdb->prepare( 'SHOW TABLES LIKE %s', $proofpass_orders_meta ) ) === $proofpass_orders_meta ) { // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.SlowDBQuery.slow_db_query_meta_key -- one-time cleanup. $wpdb->delete( $proofpass_orders_meta, array( 'meta_key' => '_proofpass_order_report' ), array( '%s' ) ); } // Queued order reports and background refreshes. foreach ( array( 'proofpass_report_order', 'proofpass_refresh' ) as $proofpass_hook ) { if ( function_exists( 'as_unschedule_all_actions' ) ) { as_unschedule_all_actions( $proofpass_hook ); } wp_unschedule_hook( $proofpass_hook ); } } if ( is_multisite() ) { $proofpass_sites = get_sites( array( 'fields' => 'ids', 'number' => 0, ) ); foreach ( $proofpass_sites as $proofpass_site ) { switch_to_blog( (int) $proofpass_site ); proofpass_uninstall_site(); restore_current_blog(); } } else { proofpass_uninstall_site(); } // The dismissed setup notice is user meta, shared by all sites of a network. delete_metadata( 'user', 0, 'proofpass_notice_dismissed', '', true ); // Transients kept in a persistent object cache expire on their own.