0){ $where = "id = ".$db->mySQLSafe($_GET['delete']); $delete = $db->delete($glob['dbprefix']."CubeCart_Coupons", $where, ""); if($delete == TRUE){ $msg = "

".$lang['admin']['coupon_del_success']."

"; } else { $msg = "

".$lang['admin']['coupon_del_fail']."

"; } } elseif(isset($_GET['status'])) { $record["status"] = $db->mySQLSafe($_GET['status']); $where = "id = ".$db->mySQLSafe($_GET['id']); $update = $db->update($glob['dbprefix']."CubeCart_Coupons", $record, $where); if($update == TRUE){ $msg = "

".$lang['admin']['coupon_status_updated']."

"; } else { $msg = "

".$lang['admin']['coupon_status_not_updated']."

"; } } else if(isset($_POST['code']) && !empty($_POST['code'])) { $data['code'] = $db->mySQLSafe($_POST['code']); $data['discount_percent'] = $db->mySQLSafe($_POST['discount_percent']); $data['discount_price'] = $db->mySQLSafe($_POST['discount_price']); $data['expires'] = $db->mySQLSafe($_POST['expires']); $data['allowed_uses'] = $db->mySQLSafe($_POST['allowed_uses']); $data['count'] = $db->mySQLSafe($_POST['count']); $data['desc'] = $db->mySQLSafe($_POST['desc']); if($_POST['id']>0){ $data['id'] = $db->mySQLSafe($_POST['id']); // update $result = $db->update($glob['dbprefix']."CubeCart_Coupons", $data, "id = ".$db->mySQLSafe($_POST['id'])); if($result == TRUE) { $msg = "

".$lang['admin']['coupon_updated_success']."

"; } else { $msg = "

".$lang['admin']['coupon_updated_fail']."

"; } } else { // insert // make sure no duplicate exists $query = "SELECT `id` FROM ".$glob['dbprefix']."CubeCart_Coupons WHERE `code` = ".$db->mySQLSafe($_POST['code']); $exists = $db->select($query); if($exists == true) { $msg = "

".sprintf($lang['admin']['coupon_already_exists'],$_POST['code'])."

"; } else { $result = $db->insert($glob['dbprefix']."CubeCart_Coupons", $data); } if($result == TRUE) { $msg = "

".$lang['admin']['coupon_add_success']."

"; } elseif($exists == false) { $msg = "

".$lang['admin']['coupon_add_fail']."

"; } } } $couponsPerPage = 50; $query = "SELECT * FROM ".$glob['dbprefix']."CubeCart_Coupons"; $results = $db->select($query, $couponsPerPage, $page); $numrows = $db->numrows($query); $pagination = paginate($numrows, $couponsPerPage, $page, "page"); require($glob['adminFolder'].CC_DS."includes".CC_DS."header.inc.php"); ?>

/ href="?_g=products/coupons&edit=" class="txtLink"> href="javascript:decision('','?_g=products/coupons&delete=');" class="txtLink"> href="?_g=products/coupons&id=&status=0" class="txtRed"> href="?_g=products/coupons&id=&status=1" class="txtGreen">

0) { $query = "SELECT * FROM ".$glob['dbprefix']."CubeCart_Coupons WHERE id=".$db->mySQLSafe($_GET['edit']); $coupon = $db->select($query); } ?>

  " />