query( $wpdb->prepare( "DELETE FROM {$wpdb->options} WHERE option_name LIKE %s OR option_name LIKE %s", $wpdb->esc_like( '_transient_nvivio_' ) . '%', $wpdb->esc_like( '_transient_timeout_nvivio_' ) . '%' ) ); // WooCommerce keeps orders as posts or in its own tables (HPOS); the note is in either. delete_post_meta_by_key( '_nvivio_counted' ); $orders_meta = $wpdb->prefix . 'wc_orders_meta'; // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- checking for WooCommerce's own table. if ( $wpdb->get_var( $wpdb->prepare( 'SHOW TABLES LIKE %s', $orders_meta ) ) === $orders_meta ) { // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- removing the plugin's own note. $wpdb->query( $wpdb->prepare( 'DELETE FROM %i WHERE meta_key = %s', $orders_meta, '_nvivio_counted' ) ); } } if ( is_multisite() ) { foreach ( get_sites( array( 'fields' => 'ids' ) ) as $nvivio_site_id ) { switch_to_blog( (int) $nvivio_site_id ); nvivio_uninstall_site(); restore_current_blog(); } } else { nvivio_uninstall_site(); } // User meta is shared by every site of a network. delete_metadata( 'user', 0, 'nvivio_period', '', true );