Store Cart & Purchases
=dbcount("id","downloadcentre","where userid='".$_SESSION['user']['id']."' and thetime>$sevendays and status=0 group by itemid"); ?>
unpaid / =dbcount("id","downloadcentre","where userid='".$_SESSION['user']['id']."' and thetime>$sevendays and status=1 group by itemid"); ?> paid items
=dbresults("name,url,itemid,uid","downloadcentre","where userid='".$_SESSION['user']['id']."' and (status=1 or freesfx=1) and thetime>$sevendays group by itemid order by thetime","
$basketdata=dbarray("SUM(price),transid","downloadcentre","where userid='".$_SESSION['user']['id']."' and freesfx=0 and status=0"); ?>
if (!empty($basketdata)) { ?>
Total $ if (empty($basketdata['SUM(price)'])) { echo "0.00"; } else { echo $basketdata['SUM(price)']; } ?>