/** * Get a list of download IDs for a specific item from an order. * * @since 2.7.0 * @param WC_Order_Item $item * @param WC_Order $order * @return array */ public function get_download_ids($item, $order) { global $wpdb; return $wpdb->get_col($wpdb->prepare("SELECT download_id FROM {$wpdb->prefix}woocommerce_downloadable_product_permissions WHERE user_email = %s AND order_key = %s AND product_id = %d ORDER BY permission_id", $order->get_billing_email(), $order->get_order_key(), $item->get_variation_id() ? $item->get_variation_id() : $item->get_product_id())); }