<?

use function PHPSTORM_META\type;
require_once('../sql_into.php'); 

function getUserIP(){
	$client = @$_SERVER['HTTP_CLIENT_IP'];
	$forward = @$_SERVER['HTTP_X_FORWARDED_FOR'];
	$remote = $_SERVER['REMOTE_ADDR'];
	if(filter_var($client, FILTER_VALIDATE_IP)){
		$ip = $client;
	}
	elseif(filter_var($forward, FILTER_VALIDATE_IP)){
		$ip = $forward;
	}
	else{
		$ip = $remote;
	}
	return $ip;
}
$user_ip = getUserIP();

$result = json_decode(file_get_contents("http://ipinfo.io/".$user_ip."/json"));
$hostname = $result->hostname;
$city = $result->city;
$region = $result->region;
$country = $result->country;
$loc = $result->loc;
$org = $result->org;
$timezone = $result->timezone;
$readme = $result->readme;
$region_city="{$country}_{$city}";

$mysql=new MySQL();
if($mysql===false)
	die();

$SN = CheckSQLCmd($_POST['SN']);
$Anatomy = CheckSQLCmd($_POST['Anatomy']);
$Anatomy_2 = CheckSQLCmd($_POST['Anatomy_Fullver']);
$CTRender = CheckSQLCmd($_POST['CTRender']);
$CTRender_2 = CheckSQLCmd($_POST['CTRender_Fullver']);
$Embryo = CheckSQLCmd($_POST['EmbryoAnatomy']);
$Embryo_2 = CheckSQLCmd($_POST['EmbryoAnatomy_Fullver']);
$Animal = CheckSQLCmd($_POST['AnimalAnatomy']);
$Animal_2 = CheckSQLCmd($_POST['AnimalAnatomy_Fullver']);
$MainUI = CheckSQLCmd($_POST['MainUI']);
$Radiology = CheckSQLCmd($_POST['Radiology']);
$Pathviewer = CheckSQLCmd($_POST['Pathology']);




if(empty($region_city))
	$region_city='';
if(empty($user_ip))
	$user_ip='';

if (!empty($SN)  && !empty($Anatomy) && !empty($Anatomy_2)) 
{
	$sql="UPDATE Anatomy_User SET Client_Ver=? ,Full_Version=? ,IP=? ,Language=? WHERE SN=?";
	$result=$mysql->sql_execute($sql,array($Anatomy,$Anatomy_2,$user_ip,$region_city,$SN));
}
if(!empty($SN) && !empty($Animal) && !empty($Animal_2)){
	$sql="UPDATE Animal_DataUser SET Version=? ,Full_Version=? ,IP=? ,Language=? WHERE SN=?";
	$result=$mysql->sql_execute($sql,array($Animal,$Animal_2,$user_ip,$region_city,$SN));
}
if(!empty($SN) && !empty($Embryo) && !empty($Embryo_2)){
	$sql="UPDATE Embryo_DataUser SET Version=? ,Full_Version=? ,IP=? ,Language=? WHERE SN=?";
	$result=$mysql->sql_execute($sql,array($Embryo,$Embryo_2,$user_ip,$region_city,$SN));
}
if(!empty($SN) && !empty($CTRender) && !empty($CTRender_2)){
	$sql="UPDATE CTRender_DataUser SET Version=? ,Full_Version=? ,IP=? ,Language=? WHERE SN=?";
	$result=$mysql->sql_execute($sql,array($CTRender,$CTRender_2,$user_ip,$region_city,$SN));
}
if(!empty($SN) && !empty($MainUI)){
	$sql="UPDATE AsclepiusMainUI_User SET Version=? ,IP=? ,Language=? WHERE SN=?";
	$result=$mysql->sql_execute($sql,array($MainUI,$user_ip,$region_city,$SN));
}
if(!empty($SN) && !empty($MainUI)){
	$sql="UPDATE AsclepiusMainUI_User SET Client_Ver=? ,IP=? ,Language=? WHERE SN=?";
	$result=$mysql->sql_execute($sql,array($MainUI,$user_ip,$region_city,$SN));
}
if(!empty($SN) && !empty($Pathviewer)){
	$sql="UPDATE Pathology_User SET Version=? ,IP=? ,Language=? WHERE SN=?";
	$result=$mysql->sql_execute($sql,array($Pathviewer,$user_ip,$region_city,$SN));
}
if(!empty($SN) && !empty($Pathviewer)){
	$sql="UPDATE Radiology_User SET Version=? ,IP=? ,Language=? WHERE SN=?";
	$result=$mysql->sql_execute($sql,array($Radiology,$user_ip,$region_city,$SN));

}
$mysql->sql_unset();
	
?>