<?php

 //////////////////////////////////////////////////////////
 //   (C) Wizardry and Steamworks 2013, license: GPLv3   //
 // Please see: http://www.gnu.org/licenses/gpl.html     //
 // for legal details, rights of fair usage and          //
 // the disclaimer and warranty conditions.              //
 //////////////////////////////////////////////////////////

 // Test whether the API key is set.
 if(!isset($_GET['apiKey'])) return;
 // Authentication.
 if($_GET['apiKey'] != '63ddfca327') return;
 // Do we have a visitor?
 if(!isset($_GET['data'])) return;
 $visitor = str_getcsv(base64_decode($_GET['data']));
 // Bail out if the visitor data line is improperly formatted.
 if(count($visitor) != 2) return;
  
 $db = new PDO('sqlite:visitors.sqlite');
 $q = $db->prepare("INSERT INTO visitors(time,name) VALUES(:visitor_time, :visitor_name)");
 try {
  $q->execute(array(':visitor_time' => $visitor[0], ':visitor_name' => $visitor[1]));
 }
 catch(PDOException $e) {
  die($e->getMessage());
 }
 print "VACK";
 return;

?>