<?php
error_reporting(0);
@session_start();
include("config.php");

$pname=$_POST[pname];
$oname=$_POST[oname];
$mobile=$_POST[mobile];
$url=$_POST[url];
$area=$_POST[area];
$published=$_POST[published];

$trial =$_POST['trial']; 
if($trial=='Lifetime'){   
 $expiry_date =$_POST['trial']; 
   } else {
	   $trial =$_POST['trial']; 
 $date =  date ( 'Y-m-d' );
$newdate = strtotime ( $trial , 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 vendors SET 
		                   vendor_name ='$oname',
		                 contact='$mobile',
		           	     published='%s',   
				            trialperiod='%s',
							days='$trial',
							subdomain_url='$url' ,
                              area='$area',
							  petrolpump_name='$pname'
							",$published,$expiry_date); 
							 	
				
		if(!($resi=mysql_query($query_insert))){echo $query_insert.mysql_error(); exit;}
							
		header("Location:add-vendor.php?flag=dn");
		exit;
	}
$id= $_POST[id];
if($id!="")
{
          $query_up=sprintf("UPDATE vendors SET 
		    vendor_name ='$oname',
		                 contact='$mobile',
		           	     published='%s',   
				            trialperiod='%s',
							days='$trial',
							subdomain_url='$url' ,
                              area='$area',
							  petrolpump_name='$pname' WHERE id='%d' ",$published,$expiry_date,$id);
		   if(!($resu=mysql_query($query_up))){echo $query_up.mysql_error(); exit;}
   
	
		
	
		header("Location:vendor-list.php?flag=up");
		exit;
		
		}

?>