<?
if(
	isset($_GET['i']) && 
	isset($_GET['a']) && 
	isset($_GET['v']) && 
	isset($_GET['sn'])  
	)
{
	$inv = "";
	if(isset($_GET['inv'])){$inv=$_GET['inv'];}
	define('db_host','localhost');
	define('db_user','stufimed_user');
	define('db_pass','winda1984');
	define('db_name','stufimed_antrianku');
   
	if (!function_exists('mysqli_init') && !extension_loaded('mysqli')) {
		echo 'We don\'t have mysqli!!!';
		exit();
	} 

	$db = new mysqli(db_host,db_user,db_pass,db_name);
	$Free = false;
 
	if($_GET['v']=="True"){
		$sql="select i from registrasi where i = '".$_GET['i']."'";
		if(!$result = $db->query($sql)){
			die(' query error [' . $db->error . ']');
		}else{
			if(mysqli_num_rows($result)>0){
				$sql="update registrasi set i=?, a=?   where i=?";
				//echo $sql;
				$stmt = $db -> prepare($sql);
				$stmt -> bind_param('sss',$_GET['i'],$_GET['a'],$_GET['i']);
				$stmt -> execute();
				echo "ok";
				exit();
			}
		}
	}else{
		$sql="select sn from registrasi where sn = '".$_GET['sn']."'";
		if(!$result = $db->query($sql)){
			die(' query error [' . $db->error . ']');
		}else{
			if(mysqli_num_rows($result)>0 /*|| $_GET['i']=="StufiMedia"*/){
				$sql="update registrasi set i=?, a=?   where sn=? and v=?";
				//echo $sql;
				$stmt = $db -> prepare($sql);
				$stmt -> bind_param('ssss',$_GET['i'],$_GET['a'],$_GET['sn'],$_GET['v']);
				$stmt -> execute();
				echo "ok";
				exit();
			}else{ $Free=true;}
		}
		
	}
	

	$id=0;
	$sql = "INSERT INTO registrasi(id,i,a,v,sn,inv) VALUES(?,?,?,?,?,?)";
	$stmt = $db -> prepare($sql);
	$stmt -> bind_param('dsssss',$id,$_GET['i'],$_GET['a'],$_GET['v'],$_GET['sn'],$inv);		
	$stmt -> execute();
	echo "ok";
}else{
	header('Location: http://stufimedia.com/antrianku/indexx.html');
}

?>