<?

function getCountryCode()
{
	$ip = getUserIP();
	
	$ipnum = sprintf("%u", ip2long($ip));
	
	$db_host = "localhost";
	$db_name = "copa_groupon";
	$db_username = "havasdig_usrAR";
	$db_pass = "pwdAR";
	
	$con = mysql_connect($db_host,$db_username,$db_pass);
	
	if (!$con){
		error_log("Mysql Connection Error:".mysql_error()."\n", 3, "mysql_error.log");
		$res_json['mes'] = 'Mysql Connection error';
		echo json_encode($res_json);
		die('Could not connect: ' . mysql_error());
	}else{
		mysql_select_db($db_name, $con);
	}
	
	$result = mysql_query("SELECT * FROM ip_country WHERE (begin_ip <= '".$ip."') AND (end_ip >= '".$ip."') AND (begin_num <= '".$ipnum."') AND (end_num >= '".$ipnum."')");
	if(mysql_num_rows($result)){
		$r = mysql_fetch_array($result);
		$datareturn = array();
		$datareturn['country']=$r['country'];
		$datareturn['country_code']=$r['countryAbr'];
		$datareturn['ip']=$ip;
		$datareturn['ip_num']=$ipnum;
		return $datareturn;
	}else{
		return "GS";
	}
}

function getUserIP()
{
	if(!empty($_SERVER['HTTP_CLIENT_IP']) ){
		$ip = $_SERVER['HTTP_CLIENT_IP'];
	}elseif(!empty($_SERVER['HTTP_X_FORWARDED_FOR'])){
		$ip = $_SERVER['HTTP_X_FORWARDED_FOR'];
	} else {
		$ip = $_SERVER['REMOTE_ADDR'];
	}
	return $ip;
}

?>