<?
ini_set('display_errors', 1);
//echo $_GET['url'];
define('ADODB_ASSOC_CASE', 2);
define('DB_TYPE', 'mysql');

define('DB_SERVER', '122.102.52.12');
define('DB_USERNAME', 'webstat');
define('DB_PASSWORD', 'webstatpw');
//define('DB_PASSWORD', 'b3nj0l');
define('DB_NAME', 'webstat');

mysql_connect(DB_SERVER,DB_USERNAME,DB_PASSWORD);
mysql_select_db(DB_NAME);

function geoCheckIP( $ip )
{
    //check, if the provided ip is valid
    if( !filter_var( $ip, FILTER_VALIDATE_IP ) )
    {
        throw new InvalidArgumentException("IP is not valid");
    }

    //contact ip-server
    $response=file_get_contents( 'http://www.netip.de/search?query='.$ip );

    if( empty( $response ) )
    {
        throw new InvalidArgumentException( "Error contacting Geo-IP-Server" );
    }

    //Array containing all regex-patterns necessary to extract ip-geoinfo from page
    $patterns=array();
    $patterns["domain"] = '#Domain: (.*?) #i';
    $patterns["country"] = '#Country: (.*?)&nbsp#i';
    $patterns["state"] = '#State/Region: (.*?)<br#i';
    $patterns["town"] = '#City: (.*?)<br#i';

    $patterns["latitude"] = '#var latitude =(.*?);#i';
    $patterns["longitude"] = '#var longitude =(.*?);#i';
    //var latitude = var longitude = 
    //Array where results will be stored
    $ipInfo=array();

    //check response from ipserver for above patterns
    foreach( $patterns as $key => $pattern )
    {
        //store the result in array

        $ipInfo[$key] = preg_match( $pattern, $response, $value ) && !empty( $value[1] ) ? $value[1] : '*';
    }
    
    $koor = $ipInfo["latitude"]. ",".$ipInfo["longitude"];
    $ipdata = $ipInfo["town"]. ", ".$ipInfo["state"].", ".$ipInfo["country"];

    return $ipdata."||".$koor;
}


if (empty($_GET['impression'])) {	

	if ($_GET['url']) {
	//$location = geoCheckIP($_SERVER['REMOTE_ADDR']);
	$loc = explode("||",$location);
	$sql = "INSERT INTO access_log (postdate,referer_url,target_url,user_agent,ipaddress,location,param1) VALUES (NOW(),'".$_SERVER['HTTP_REFERER']."','".$_GET['url']."','".$_SERVER['HTTP_USER_AGENT']."','".$_SERVER['REMOTE_ADDR']."','".$loc[0]."','".$loc[1]."') ";
	mysql_query($sql);
	header("Location:".$_GET['url']);	
	}

} else {
	if ($_GET['dat']) {
	$rs = explode("|",$_GET['dat']);
	$url = $rs[0];
	$referer = $rs[1];
	$user_agent = $rs[2];
	$ip = $rs[3];
	//echo $_GET['dat'];
	//$location = geoCheckIP($ip);
	$loc = explode("||",$location);
	$sql = "INSERT INTO impression_log (postdate,referer_url,target_url,user_agent,ipaddress,location,param1) VALUES (NOW(),'".$referer."','".$url."','".$user_agent."','".$ip."','".$loc[0]."','".$loc[1]."') ";
	echo $sql;
	mysql_query($sql);
	}
}	
?>