<? 
   #global $_SERVER['DOCUMENT_ROOT'], $style;
$DOCUMENT_ROOT = $_SERVER['DOCUMENT_ROOT'];   
include($DOCUMENT_ROOT.'/tinclude.php');


if (isset($_GET['time'])) {
   $time=$_GET['time'];
} else {
 unset($time);
}

if (isset($_GET['v'])) {
   $v=$_GET['v'];
} else {
   unset($v); 
}

if (isset($_GET['ff1005'])) {
   $ff1005=$_GET['ff1005'];
} else {
   unset($ff1005); 
}

if (isset($_GET['ff1006'])) {
   $ff1006=$_GET['ff1006'];
} else {
   unset($ff1006); 
}

if (isset($_GET['eml'])) {
   $eml=$_GET['eml'];
} else {
   unset($eml); 
}


echo "OK!\n\r";
   // Make connections, etc. 
   init();
   
   if (!isset($v)) {
      header('HTTP/1.1 204 No Response', true, 204);
      die("\n\r\n\rINVALID EMAIL FORMAT(TYPE A) - CHECK FOR ACCIDENTAL SPACES IN YOUR EMAIL ADDRESS");
   }

   $time = $time+1;
   $time = $time-1;
   $v = $v-1;
   $v = $v+1;

   if (isset($kff1005)) {
     $longitude = $kff1005;
     $longitude = $longitude+1;
     $longitude = $longitude-1;
   } else {
     $longitude = 0;
   }

   if (isset($kff1006)) {
     $latitude = $kff1006;
     $latitude = $latitude+1;
     $latitude = $latitude-1;
   } else {
     $latitude = 0;
   }


   $data = $QUERY_STRING;  

   if (!isset($eml)) {
      $eml = '';
   }

   if ($v == 0) {
      header('HTTP/1.1 204 No Response', true, 204);
      die("\n\r\n\rINVALID EMAIL FORMAT(TYPE B) - CHECK FOR ACCIDENTAL SPACES IN YOUR EMAIL ADDRESS");
   }


// 10512000000 = 4 months


#         $resultset = mysql_qw($db, 'INSERT DELAYED INTO log (v, session, id, time, longitude, latitude, data,email) VALUES (?,?,?,?,?,?,?,?)', $v,$session,$id,$time,$longitude,$latitude,$data,$eml);

         $dbb = mysql_pconnect('127.0.0.1:3307', $conf['user'], $conf['pass']) or $dbb = 'none';

if ($dbb == 'none') {
$block = TRUE;
         $dbb = mysql_pconnect('127.0.0.1:3306', $conf['user'], $conf['pass']) or $dbb = 'none';
   $fh = fopen("/home/ihawkins/public_html/misc/templog.sql","a+");
   if (flock($fh, LOCK_EX, $block)) {
      fwrite($fh, "INSERT DELAYED INTO log (v, session, id, time, longitude, latitude, data,email) VALUES (".  mysql_real_escape_string($v).",'".  mysql_real_escape_string($session)."','".   mysql_real_escape_string($id)."',".  mysql_real_escape_string($time).",". mysql_real_escape_string($longitude).",". mysql_real_escape_string($latitude).",'". mysql_real_escape_string($data)."','". mysql_real_escape_string($eml).'\')'.";\n");
      fflush($fh);
      flock($fh, LOCK_UN);
   }
   fclose($fh);


 //echo "OK!\n\r";
} else {
         mysql_select_db('torque', $dbb);

         $resultset = mysql_qw($dbb, 'INSERT DELAYED INTO log (v, session, id, time, longitude, latitude, data,email) VALUES (?,?,?,?,?,?,?,?)', $v,$session,$id,$time,$longitude,$latitude,$data,$eml);

//echo "OK!\n\r";
         # Housekeeping
if (rand(0,3500) > 3455) {
         #$resultset = mysql_qw($dbb, 'DELETE FROM log where session="0" LIMIT 500');
         #$resultset = mysql_qw($dbb, 'DELETE FROM log where time < (UNIX_TIMESTAMP()*1000)-61556952000 LIMIT 950');
}

if (file_exists("/home/ihawkins/public_html/misc/templog.sql")) {
   $block = FALSE;

      $fh = fopen("/home/ihawkins/public_html/misc/templog.sql","r+");
      if (flock($fh, LOCK_EX | LOCK_NB)) {
        
      while ( ($line = fgets($fh)) !== false) {
	 $check = strtolower($line);
         if (strpos("   ".$check,"update ") > 0) {
		continue;
         } else {  
            $resultset = mysql_qw($dbb, $line);
         }
       }
        ftruncate($fh, 0);
        unlink("/home/ihawkins/public_html/misc/templog.sql"); 
        flock($fh, LOCK_UN);
      }
      fclose($fh);


}

# extra test db
#         $dbb = mysql_pconnect('127.0.0.1:3309', 'root', '') or $dbb = 'none';
#if ($dbb != 'none') {
#         mysql_select_db('torque', $dbb);
#         $resultset = mysql_qw($dbb, 'INSERT DELAYED INTO log (v, session, id, time, longitude, latitude, data,email) VALUES (?,?,?,?,?,?,?,?)', $v,$session,$id,$time,$longitude,$latitude,$data,$eml);
#}


}

  ?>