BFH Handwriting Downloads

Verifying download count

SELECT @order_id := [ORDER_ID];

select p.catno,
p.name,
i.download_token,
i.download_count,
CONCAT(IFNULL(CONCAT(b.first_name, ' '), ''), IFNULL(b.last_name, '')) as customer,
i.product_id
from order_item_link i 
inner join catalog_item p on i.product_id = p.id
inner join cart_order o on i.order_id = o.id
inner join address b on o.billing_id = b.id
where i.order_id = @order_id;

Reseting download count

SELECT @order_id := [ORDER_ID];
SELECT @product_id := [PRODUCT_ID];

update order_item_link set download_count = 0 where order_id = @order_id and product_id = @product_id;

Download link format

/**
  * DOWNLOAD_URI defined in /_config/scripts.php
  * $item namespace BFHHand\Cart\CartItemDownload
  */
<?=DOWNLOAD_URI . $item->downloadCode() ?>

[SERVER_ROOT_URI]/d/[ORDER_ID]-[DOWNLOAD_TOKEN]