<?php
error_reporting(0);
@session_start();
include("../config.php");



$crate=$_POST[crate];
 $discount =  $crate/100;

$vid=$_POST[vid];


$edays =$_POST['edays']; 
if($edays=='Lifetime'){   
 $expiry_date =$_POST['edays']; 
   } else {
	   $edays =$_POST['edays']; 
 $date =  date ( 'Y-m-d' );
$newdate = strtotime ( $edays , strtotime ( $date ) ) ;
$expiry_date = date ( 'Y-m-d' , $newdate );
}

$flag = $_REQUEST[flag];
$mode = $_REQUEST[mode];

/***********************************/
$id= $_POST[id];
if($id=="")
{ 
    	 $query_insert=sprintf("Insert INTO commission SET   vid='%s',commrate='%s',discountrs='%s',expired='%s',expired_days='$edays'  ",$vid,$discount,$crate,$expiry_date); 
		if(!($resi=mysql_query($query_insert))){echo $query_insert.mysql_error(); exit;}
							
		header("Location:add-discount.php?flag=dn");
		exit;
}
$id= $_POST[id];
if($id!="")
{
          $query_up=sprintf("UPDATE commission SET 
		  vid='%s',commrate='%s',discountrs='%s',expired='%s',expired_days='$edays'  WHERE id='%d' ",$vid,$discount,$crate,$expiry_date,$id);
		   if(!($resu=mysql_query($query_up))){echo $query_up.mysql_error(); exit;}
   
		
	
		header("Location:add-discount.php?flag=up");
		exit;
		
		}
?>