<?
//set transparent gif
  $obrazek = imagecreatetruecolor(1,1);
  $barva = imagecolorallocate($obrazek,204,153,0);
  imagefilledrectangle($obrazek,0,0,10,10,$barva);
  header('Content-Type: image/png');
  imagepng($obrazek);
  imagedestroy($obrazek);
// další nastavení hlavičky  
  header('Expires: ' . gmdate('D, d M Y H:i:s') . ' GMT'); 
  Header("Cache-Control: no-cache");
  Header("Cache-Control: must-revalidate");

// Nastavení cookie VISIT - unikatní navstevnik / den (cookie plati pouze dnes) 
setcookie('visit', 'PAGEVIEW', mktime(23,59,59, date('m'), date('d'), date('Y')), '/'); 

// VÝSTUP SCRIPT
$document    = $doc_location;
$doc_title   = $doc_title;
$screenres  = $width . "x" . $height;
$colordepth  = $doc_colordepth;
$referer  = $doc_refer;

include "../inc/conn.php";
$no_referer = "cyclop.cz";	// pokud bude $referer obsahovat tuto hodnotu, jedná se o přechod v rámci serveru


// DATUM
$date = date('Y-m-d H:i:s'); // aktualni datum a cas

// IP ADRESA
if(isset($_SERVER['HTTP_X_FORWARDED_FOR'])) {
  $explode_ip = explode(',', $_SERVER['HTTP_X_FORWARDED_FOR']);
  $ip = $explode_ip[0];
} else {
  $ip = $_SERVER['REMOTE_ADDR'];
}

// pokud cookie existuje, nejedna se o visit
// v opacnem pripade zjistime, zda dana IP adresa pristoupila v poslednich 20 minutach (pokud ne, jedna se o visit)
if(isset($_COOKIE['visit'])) {
  $visit = 0;
} else {
  $query = mysql_query("SELECT datum FROM statistika WHERE ip = '$ip' AND DATE_ADD(datum, INTERVAL 20 MINUTE) > NOW() LIMIT 0,1");
  if($result = mysql_fetch_array($query))
    $visit = 0;
 else
    $visit = 1;
    //počítadlo
	$result[1] = MySQL_Query("SELECT * FROM celkem");
	if (MySQL_Num_Rows($result[1])!=0){
		$counter[0] = MySQL_Result($result[1],0)+1;
		MySQL_Query("UPDATE celkem SET Pocet = Pocet+1");
	}else{
		$counter[0] = 1;
		MySQL_Query("INSERT INTO celkem VALUES(1)");
	}
}

// DOMENOVA ADRESA
if(isset($_SERVER['REMOTE_HOST']) and $_SERVER['REMOTE_HOST'] != '') {
  $ip_name = $_SERVER['REMOTE_HOST'];
} else {
  $ip_name = gethostbyaddr($ip);
}

// pokud se nepodarilo IP adresu prevest na domenovou adresu, vlozime do $ip_name "0"
$ip_name = strtolower($ip_name);
if($ip_name == '') $ip_name = 0;
else if(eregi("[[:digit:]]{1,3}\.[[:digit:]]{1,3}\.[[:digit:]]{1,3}\.[[:digit:]]{1,3}", $ip_name)) $ip_name = 0;

// ZEMĚ
$domain = 0;
if($ip_name != '0') {
  // domena nejvyssi urovne je posledni casti domenove adresy
  $explode = explode('.', $ip_name);
  $domain = $explode[count($explode)-1];

  // je domena v databazi ?
  $query = mysql_query("SELECT id FROM domain WHERE code = '$domain'");
  if($result = mysql_fetch_array($query))
    $domain = $result['id'];
  else
    $domain = 0;
}

// OBLAST
// odpovida domenova adresa nejakemu zaznamu v databazi ?
$area = 0;
if($ip_name != '0') {
  $query = mysql_query("SELECT id FROM town WHERE '$ip_name' REGEXP ip_regexp ORDER BY id LIMIT 0,1");
  if ($result = mysql_fetch_array($query))
    $area = $result['id'];
}

//PROHLÍŽEČ
$http_user_agent = strtolower($_SERVER['HTTP_USER_AGENT']);

$query = mysql_query("SELECT id FROM browser WHERE '$http_user_agent' REGEXP browser_regexp ORDER BY id LIMIT 0,1");
if ($result = mysql_fetch_array($query))
  $browser = $result['id'];
else
  $browser = 0;

//PROHLÍŽEČ - nadstavba
$query = mysql_query("SELECT id FROM browser_add_on WHERE '$http_user_agent' REGEXP add_on_regexp ORDER BY id LIMIT 0,1");
if ($result = mysql_fetch_array($query))
  $browser_add_on = $result['id'];
else
  $browser_add_on = 0;

// ROZLISENI 
$resolution = 0; 
if (isset($screenres)) { 
  $query = mysql_query("SELECT id FROM resolution WHERE screenres = '$screenres'"); 
  if ($result = mysql_fetch_array($query)) 
    $resolution = $result['id']; 
}

// BAREVNA HLOUBKA 
$depth = 0; 
if(isset($colordepth)) { 
  $query = mysql_query("SELECT id FROM colordepth WHERE depth = '$colordepth'"); 
  if ($result = mysql_fetch_array($query)) 
    $depth = $result['id']; 
}

// OS
$query = mysql_query("SELECT id FROM os WHERE '$http_user_agent' REGEXP os_regexp ORDER BY id LIMIT 0,1");
if ($result = mysql_fetch_array($query))
  $os = $result['id'];
else
  $os = 0;

// REFERER - odkud prisel navstevnik
//$referer = "Přechod v rámci serveru"; // predpokladame prechod v ramci serveru

if(isset($_GET['doc_refer'])) {
  // rozkoduje URL a prevede na mala pismena
  $http_referer = addslashes(urldecode(strtolower($_GET['doc_refer'])));

  if ($http_referer == '') { // prime volani
    $referer = "Přímé volání";
  
  } elseif (eregi($no_referer, $http_referer)) { // prechod v ramci serveru
    $referer = "Přechod v rámci serveru";

  } else { // navstevnik prisel z cizich stranek
    $url = parse_url($http_referer); // rozdeli URL na casti
    $host = eregi_replace("^www\.", "", $url['host']); // odstrani "www."
    $referer = $host;

// VYHLEDAVACE - jaka fraze byla pouzita pri vyhledavani
$explode = explode('.', $url['host']); // rozdeli adresu serveru na jednotlive casti
$host_domain = $explode[count($explode) - 2] . '.' . $explode[count($explode) - 1]; // domena 2. urovne

// jedna se o vyhledavac?
$query = mysql_query("SELECT * FROM searchengine WHERE server = '$host_domain'");
if($result = mysql_fetch_array($query)) {
  // zjistime pouzitou frazi - pres parametr, ktery vyhledavac pouziva
  $variables = explode('&', $url['query']);
  for($i = 0;$i < count($variables);$i++) {
    $explode = explode('=', $variables[$i]);
    if($explode[0] == $result['variable']) {
      $searchtext = $explode[1]; // fraze pouzita pri vyhledavani
      break;
    }
  }       
  // pokud se podarilo zjistit frazi, zapiseme vse do databaze
  if($searchtext != '') {
    $server = $result['id'];
    // je fraze v databazi ? (pokud ne, pridame ji)
    $query = mysql_query("SELECT id FROM searchtext WHERE query = '$searchtext'");
    if ($result = mysql_fetch_array($query)) {
      $search_id = $result['id'];
    } else {
      $query = mysql_query("INSERT INTO searchtext VALUES ('', '$searchtext')");
      $search_id = mysql_insert_id();
    }
    $query = mysql_query("INSERT INTO searched VALUES ('', '$date', '$server', '$search_id')");
  }
}
}}      
MySQL_Query("INSERT into statistika VALUES ('','$date','$visit','$ip','$ip_name','$domain','$area','$browser','$browser_add_on','$os','$doc_title','$referer','$resolution','$depth')");
?>