<?
$dbh = mysql_connect("rdbms.strato.de", "www.schmaili.com", "1schmaili10");
$query = "use DB44637";
mysql_select_db("DB44637",$dbh);
$res = mysql_query("SELECT * FROM spy WHERE id='$id'");
if(mysql_num_rows($res) == 0)
{
$ip = $REMOTE_ADDR;	
$timestamp = time();

$sql = "insert into spy (id,ip,mail,remote,datum,status) values ('$id','$ip','$mail','$remote','$timestamp',0)";
$resulti = mysql_query($sql,$dbh);

}	
else
{

	
$result3 = mysql_query("SELECT * FROM spy WHERE id='$id'"); 
extract(mysql_fetch_array($result3)); 
mysql_free_result($result3);	
	
	
$ipact = $REMOTE_ADDR;	

$handle = fopen ("http://maxmind.com:8010/b?l=Msm1ijFDFrkL&i=$ipact", "r");
$handle2 = fgets($handle, 4096);
$foo = explode(",",$handle2);
$var1 = $foo[0];
$var2 = $foo[1];
$var3 = $foo[2];

if ($status == "0" and $ipact <> $ip)

{
	

$res4 = mysql_query("SELECT email FROM mails WHERE email='$mail'");
if(mysql_num_rows($res4) == 0)
{
	
$sql2 = "UPDATE spy SET status = '1' where id = '$id'";
$result2 = mysql_query($sql2,$dbh);	
	
	
$inhalt = "
the mail you had sent to $remote was read by the recipient\n\n
	
The recipient seems to be located in:\n
Country: $var1\n
State: $var2\n
City:  $var3	 			
";

mail("$mail",
     "$remote has read the mail",
     "$inhalt",
     "From: notification@schmaili.com");


}
}
}
?>