query( $wpdb->prepare( "DELETE FROM {$wpdb->options} WHERE option_name LIKE %s OR option_name LIKE %s", $wpdb->esc_like( '_transient_' . $cwp_ai_prefix ) . '%', $wpdb->esc_like( '_transient_timeout_' . $cwp_ai_prefix ) . '%' ) ); // phpcs:ignore WordPress.DB.DirectDatabaseQuery } foreach ( array( 'events', 'knowledge', 'messages', 'leads', 'reports' ) as $cwp_ai_table ) { $wpdb->query( $wpdb->prepare( 'DROP TABLE IF EXISTS %i', $wpdb->prefix . 'cwp_ai_' . $cwp_ai_table ) ); // phpcs:ignore WordPress.DB.DirectDatabaseQuery, WordPress.DB.PreparedSQL.InterpolatedNotPrepared, WordPress.DB.DirectDatabaseSchemaChange.SchemaChange }