I'm using a coupon modification for vbulletin and this is the function:
Code: Select all
$coupon_value = $vbulletin->db->query_first("
SELECT couponvalue, couponname
FROM " . TABLE_PREFIX . "coupons
WHERE TO_DAYS(couponvalidto) - TO_DAYS(CURDATE()) > 0
AND nouses > 0
AND couponid = '$couponid'
AND validfor LIKE '%$subscriptionid%'
");
$newvalue = floatval($coupon_value['couponvalue']);
$coupon_name = $coupon_value['couponname'];
$value = vb_number_format(($value - $newvalue), 2);
}
return $value;Code: Select all
$newvalue = floatval($coupon_value['couponvalue']);Thanks for your help.
