<?php

if( getenv('HTTP_X_FORWARDED_FOR') != '' )
{
	$client_ip = ( !empty($HTTP_SERVER_VARS['REMOTE_ADDR']) ) ? $HTTP_SERVER_VARS['REMOTE_ADDR'] : ( ( !empty($HTTP_ENV_VARS['REMOTE_ADDR']) ) ? $HTTP_ENV_VARS['REMOTE_ADDR'] : $REMOTE_ADDR );

	if ( preg_match("/^([0-9]+\.[0-9]+\.[0-9]+\.[0-9]+)/", getenv('HTTP_X_FORWARDED_FOR'), $ip_list) )
        {
	$private_ip = array('/^0\./', '/^127\.0\.0\.1/', '/^192\.168\..*/', '/^172\.16\..*/', '/^10..*/', '/^224..*/', '/^240..*/');
        	$client_ip = preg_replace($private_ip, $client_ip, $ip_list[1]);
        }
}
else
{
	$client_ip = ( !empty($HTTP_SERVER_VARS['REMOTE_ADDR']) ) ? $HTTP_SERVER_VARS['REMOTE_ADDR'] : ( ( !empty($HTTP_ENV_VARS['REMOTE_ADDR']) ) ? $HTTP_ENV_VARS['REMOTE_ADDR'] : $REMOTE_ADDR );
}

	$httprefer=getenv ("HTTP_REFERER");
	$server_name=getenv ("SERVER_NAME");
	$request_file=getenv ("REQUEST_URI");
	$request_uri="http://".$server_name.$request_file;
	$rm_host=$client_ip;
	$httpagent = getenv ("HTTP_USER_AGENT");
	$today = date("D M j Y g:i:s a T"); 

	function mailer($httprefer,$server_name,$request_uri,$rm_host,$today,$httpagent)
	{
		$message =
"Team:

There was some problem in getting price of the product. Please see the details below.
Date          : $today
Server        : $server_name
Not Found URL : $request_uri
Refered From  : $httprefer
Remote Address: $rm_host
User Agent    : $httpagent

Please check and fix the issue as soon as possible.

Regards,
Web Admin";

		$subject="ISSUE - Pricing - $server_name";
		$headers = "From:noreply@adventnet.com\n";
		$to = "webmaster-notify@adventnet.com";	
		mail($to,$subject,$message,$headers);
	}

	function convertIPtoNum($client_ip)
	{
		$ip = $client_ip;
		$ipnumst=explode(".",$ip);
		$ipnum = 16777216 * $ipnumst[0] + 65536 * $ipnumst[1] + 256 * $ipnumst[2] + $ipnumst[3];
		return $ipnum;
	}
	
	$showprice=true;
	$pid = ( !empty($HTTP_POST_VARS['pid']) ) ? $HTTP_POST_VARS['pid'] : ((!empty($HTTP_GET_VARS['pid']))?$HTTP_GET_VARS['pid']:'');
	$imagename = ( !empty($HTTP_POST_VARS['imagename']) ) ? $HTTP_POST_VARS['imagename'] : ((!empty($HTTP_GET_VARS['imagename']))?$HTTP_GET_VARS['imagename']:'');
	$imagesrc = ( !empty($HTTP_POST_VARS['imagesrc']) ) ? $HTTP_POST_VARS['imagesrc'] : ((!empty($HTTP_GET_VARS['imagesrc']))?$HTTP_GET_VARS['imagesrc']:'');
	$s = ( !empty($HTTP_POST_VARS['s']) ) ? $HTTP_POST_VARS['s'] : ((!empty($HTTP_GET_VARS['s']))?$HTTP_GET_VARS['s']:'');
	$g = ( !empty($HTTP_POST_VARS['g']) ) ? $HTTP_POST_VARS['g'] : ((!empty($HTTP_GET_VARS['g']))?$HTTP_GET_VARS['g']:'');
	$price="";
	$convertedip=convertIPtoNum($client_ip);
	$dbserver = "localhost";
	$myuser = "root";
	$mypass = "";
	$sdbname = "SalesDB";
	$ipdbname = "ip_registry";
	$idlink = mysql_connect($dbserver, $myuser, $mypass);
	if(!$idlink)
		mailer($httprefer,$server_name,$request_uri,$rm_host,$today,$httpagent);

	mysql_select_db($ipdbname);
	$correctip=mysql_query("SELECT code FROM ip_map where ip_from <= $convertedip AND ip_to >= $convertedip and (code='CN' or code='JP' or code='KR' or code='ID' or code='TW')");
	if(mysql_num_rows($correctip) != 0)
		$showprice=false;

	if(!$showprice && $imagename!="" && $imagesrc!="" )
	{
		echo "setTimeout(\"document.$imagename.src='$imagesrc'\",0);";
	}
	else if($showprice && $pid != "")
	{
		if($g != "")
		{
			$gstr=explode(",",$g);
			$gpid=explode(",",$pid);
			for($j=0;$j<count($gpid);$j++)
			{
				 $arrg[$gpid[$j]]=$gstr[$j];
			}
		}

		mysql_select_db($sdbname);
		$dbprice=mysql_query("select ProductID,min(CostPerDevSeat) from Product where ProductID in ($pid) group by ProductID;");
		if(mysql_num_rows($dbprice) != 0)
		{
			$i=0;
			while($lfile=mysql_fetch_array($dbprice))
			{
				$pid=$lfile[0];
				$price=$lfile[1];
				if($g!="")
				{
					if($arrg[$pid]=="yes")
						$outstr="starts @ $$price";
					else
						$outstr="&nbsp;$$price";
					echo "document.getElementById('$pid').innerHTML = '$outstr';";
				}
				else
				{
					if($s=="yes")
						$outstr="starts @ $$price";
					else 
						$outstr="&nbsp;$$price";
					echo "document.writeln('$outstr');";
				 }
			}		
		}
		else
			mailer($httprefer,$server_name,$request_uri,$rm_host,$today,$httpagent);
	}
	mysql_close();
?>