prefix . 'woocommerce_api_keys'; // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- one-time cleanup on uninstall. if ( $wpdb->get_var( $wpdb->prepare( 'SHOW TABLES LIKE %s', $wpdb->esc_like( $askdolphin_wc_table ) ) ) === $askdolphin_wc_table ) { // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- one-time cleanup on uninstall. $wpdb->query( $wpdb->prepare( 'DELETE FROM %i WHERE key_id = %d AND description LIKE %s', $askdolphin_wc_table, (int) $connection['woocommerce']['key_id'], $wpdb->esc_like( 'AskDolphin' ) . '%' ) ); } } if ( is_array( $connection ) && ! empty( $connection['site_token'] ) ) { $base = defined( 'ASKDOLPHIN_API_BASE' ) ? (string) ASKDOLPHIN_API_BASE : 'https://api.askdolphin.com'; wp_remote_request( untrailingslashit( $base ) . '/api/v2/integrations/wordpress/site', array( 'method' => 'DELETE', 'timeout' => 5, 'blocking' => true, // Must reach the backend; failure is fine, local data is deleted anyway. 'redirection' => 0, 'headers' => array( 'Accept' => 'application/json', 'Authorization' => 'Bearer ' . $connection['site_token'], ), ) ); } foreach ( array( 'askdolphin_widget', 'askdolphin_connection', 'askdolphin_settings', 'askdolphin_flash', 'askdolphin_knowledge', 'askdolphin_sync_queue', 'askdolphin_wc_queue' ) as $option ) { delete_option( $option ); } // Connect transients (askdolphin_connect_{user_id}) and any other askdolphin_ transient. // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- one-time cleanup on uninstall. $wpdb->query( $wpdb->prepare( "DELETE FROM {$wpdb->options} WHERE option_name LIKE %s OR option_name LIKE %s", $wpdb->esc_like( '_transient_askdolphin_' ) . '%', $wpdb->esc_like( '_transient_timeout_askdolphin_' ) . '%' ) ); wp_clear_scheduled_hook( 'askdolphin_status_check' ); wp_clear_scheduled_hook( 'askdolphin_sync_pages' ); wp_clear_scheduled_hook( 'askdolphin_wc_sync_products' ); } if ( is_multisite() ) { $askdolphin_site_ids = get_sites( array( 'fields' => 'ids', 'number' => 0, ) ); foreach ( $askdolphin_site_ids as $askdolphin_site_id ) { switch_to_blog( $askdolphin_site_id ); askdolphin_uninstall_site(); restore_current_blog(); } } else { askdolphin_uninstall_site(); } // User meta is shared by all sites. delete_metadata( 'user', 0, 'askdolphin_notice_dismissed', '', true ); delete_metadata( 'user', 0, 'askdolphin_wc_hint_dismissed', '', true );