BFH Handwriting Downloads

From Littledamien Wiki
Jump to navigation Jump to search

Verifying download count

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

update order_item_link set download_count = 0 where order_id = [ORDER_ID] and product_id = [PRODUCT_ID];