<?
// -----------------------------------------------------------------------------------
//  LevelTen Hit Counter
//  v3.15 r6 (12/15/03)
//
//  Copyright (c) 2003 LevelTen Design, Division of Lorentz Consulting Group, LLC
//
//  For license use of this script see:
//  http://www.leveltendesign.com/legal/EULA_L10HC.php
// -----------------------------------------------------------------------------------

$pathToImg = "./";

if($_GET['acct'] != '') {
	$acct = $_GET['acct'];	
} else {
	$acct = '.';
}
$acct = $dataDir.$acct;
$acctCk = ($acct == '.') ? '' : $acct;

$acct = "."; //temp

require("$acct/L10HC_AcctParams.php");

require("L10_LIB.php");
require("L10_LIB_DB.php");
require("L10HC_LIB.php");

$vID = 0;
$vIP = getenv("REMOTE_ADDR");

$sessionType = 0; //0=in session,1=intraday session,2=unique session,3=new visitor
$sessionTypeInit = 0;
$reload = 0;
$success = 0; //0=not yet,1=yes from pagehit,2=yes-this hit the first time
$successPrev = 0;
$conversion = 0; //0=not yet,1=yes from pagehit,2=yes-this hit the first time
$conversionPrev = 0;
$pgIDStart = 0;
$refIDStart = 0;
$sessionTypeInit = 3;
$dateStart = '0000-00-01';
$pgIDLastHit = 0;
$dateOfLastHit = '0000-00-01';
$timeOnLastPg = 0;
$trackByIP = 1;
$updateYday = 0;

purgeActiveSessions();
//
// validating HTTP_Referer
//
$httpRef = getenv('HTTP_REFERER');
if($httpRef == '') {
	$httpRef = $_GET['pg'];
}
$httpReq = 0;
if(substr($httpRef,0,7) == "http://") {
	$httpRef = substr($httpRef,7);
	$httpReq = 1;
} elseif((substr($httpRef,0,8) == "https://")) {
	$httpRef = substr($httpRef,8);
	$httpReq = 1;
}

if(!$httpReq && !$allowLocalFiles && ($_GET[lfor] != '1')) {
	log_event("Blocked local file. Request from: $httpRef");
	returnHitImage(1);
	exit;
}
if((count(validDoms) > 0) && ($_GET[dvor] != '1')) {
	$t1 = explode("/",$httpRef);
	$t = 0;
	for($i=0;$i<count($validDoms);$i++) {
		if(preg_match("/$validDoms[$i]\$/i",$t1[0])) {			
			$t = 1;
			break;
		}
	}
	if(!$t) {
		log_event("Blocked invalid domain. Request from: $httpRef");
		returnHitImage(1);
		exit;
	}
}

$vKey = $vIP;
parseCookies();
if($blockBrowser || ($_COOKIE['L10HC_BB'] == '1')) {
	log_event("Blocked by browser. Request from: $httpRef");
	returnHitImage(1);
	exit;
}
if(in_array($vIP,$blockIPs)) {
	log_event("Blocked by IP. Request from: $vIP");
	returnHitImage(1);
	exit;
}

$statsHits[$curDate] = array('date'=>$curDate,'hits'=>0,'entries'=>0,'entriesUnique'=>0,'entriesNew'=>0,'conversionsUnique'=>0,'conversionsNew'=>0,'successesUnique'=>0,'successesNew'=>0,'timeOnVisit'=>0,'tallied'=>0);
$statsHits[$ydayDate] = array('date'=>$ydayDate,'hits'=>0,'entries'=>0,'entriesUnique'=>0,'entriesNew'=>0,'conversionsUnique'=>0,'conversionsNew'=>0,'successesUnique'=>0,'successesNew'=>0,'timeOnVisit'=>0,'tallied'=>0);


//
// page & ref var processing
//
$pg = getenv('HTTP_REFERER');
if(strlen($_GET['cPg']) > 0) {
	$pg = '`'.$_GET['cPg'].'`/';
} elseif(strlen($_GET['pg']) > 0) {
	$pg = $_GET['pg'];
}
if($pg == "") {
	$pg = '[Unknown]/';
} else {
	if(substr($pg,0,7) == "http://") {
		$pg = substr($pg,7);
	} elseif((substr($pg,0,8) == "https://")) {
		$pg = substr($pg,8);
	}	
	if(($removePageWWW > 0) && (substr($pg,0,4) == "www.")) {
		$pg = substr($pg,4);
	}
}

list($pg,$pgQuery) = explode("?",$pg,2);
$pgE = explode('/',$pg);
$pgDom = array_shift($pgE);
if(substr($pgDom,0,1) != '[' && substr($pgDom,0,1) != '`') {
	$pgDom = strtolower($pgDom);
}
$pgPN = implode('/',$pgE);
$pgPN = preg_replace("/$indexPage/i","",$pgPN);
$pgPN = str_replace("&","%26",$pgPN);

$ref = "";
$refType = "";

if(strlen($pgQuery) > 0) {
	$pgQuery = str_replace("%26","&",$pgQuery);
	$pgQuery = str_replace("%20"," ",$pgQuery);
	$ta = explode("&",$pgQuery);
	for($i=0;$i<count($ta);$i++) {
		$tb = explode("=",$ta[$i]);
		if(strtolower($tb[0]) == $customRefTag) {
			$ref = '`'.$tb[1].'`/';
			array_splice($ta,$i,1);
			$i--;
		} elseif (strtolower($tb[0]) == $customRefTypeTag) {	
			$refType = '`'.$tb[1].'`';
			array_splice($ta,$i,1);
			$i--;
		} else {
			$a = 0;
			foreach($queryStrFilters as $b) {
				if($b == $tb[0]) {
					$a = 1;
					break;
				}
			}
			if(($a && !$removeQueryStr) || (!$a && $removeQueryStr)) {
				array_splice($ta,$i,1);
				$i--;
			}
		}
	}
	if((count($ta) > 1) || (strlen($ta[0]) > 0)) {
		$pgPN = $pgPN."?".implode("%26",$ta);
	}
}
if($lowercasePage > 0) {
	$pgPN = strtolower($pgPN);
}

//
// page db processing
//
$sql = "SELECT L10HC_listPg.ID FROM L10HC_listPg,L10HC_listPgDom where (L10HC_listPg.pgDomID = L10HC_listPgDom.ID) AND (L10HC_listPg.pathname = \"$pgPN\") AND (L10HC_listPgDom.dom = \"$pgDom\")";		
$result = db_query($sql,__FILE__,__LINE__);
$row = db_fetch_array($result,__FILE__,__LINE__);
if($row) {
	$pgID = $row['ID'];
} else { // insert new page
	$sql = "SELECT ID FROM L10HC_listPgDom where dom = \"$pgDom\"";		
	$result = db_query($sql,__FILE__,__LINE__);
	
	$row = db_fetch_array($result,__FILE__,__LINE__);
	if($row) {
		$pgDomID = $row['ID'];
	} else {  // insert new pgDom
		$sql = "INSERT INTO L10HC_listPgDom VALUES(NULL,\"$pgDom\")";		
		$result = db_query($sql,__FILE__,__LINE__);
		$pgDomID = db_insert_id();	
	}
	$sql = "INSERT INTO L10HC_listPg VALUES(NULL,$pgDomID,\"$pgPN\")";		
	$result = db_query($sql,__FILE__,__LINE__);
	$pgID = db_insert_id();	
	$sql = "INSERT INTO L10HC_statsPgAT VALUES ($pgID,0,0,0,0,0,0,0,0,0,0)";
	$result = db_query($sql,__FILE__,__LINE__);
}
if($_GET[sa] > 0) {
	$success = 1;
}
//
// check active session record -> if exists, update
//
$sessionType = 3;
$sessionTypeInit = 3;
$pgIDInit = 0;
$refIDInit = 0;
$dateInit = $curDate;

if($trackByIP > 0) {
	$sql = "SELECT * FROM L10HC_recentVisits where vKey=\"$vKey\"";		
	$result = db_query($sql,__FILE__,__LINE__);

	$rVData = db_fetch_array($result,__FILE__,__LINE__);
	if($rVData) {
		$vID = $rVData['vID'];
		$sessionType = 1;
	}
}

if($vID > 0) {
	$sql = "SELECT * FROM L10HC_activeSessions where vID=$vID";		
	$result = db_query($sql,__FILE__,__LINE__);
	
	$row = db_fetch_array($result,__FILE__,__LINE__);
	if($row) {
		$sessionType = 0;
		if($row['pgIDLastHit'] == $pgID) {
			$reload = 1;
		} else {
			$pgIDInit = $row['pgIDInit'];
			$refIDInit = $row['refIDInit'];
			$dateInit = $row['dateInit'];
			$sessionTypeInit = $row['sessionTypeInit'];
			$pgIDLastHit = $row['pgIDLastHit'];
			$dateOfLastHit = $row['dateOfLastHit'];

			$sqlAdd = "";
			if($success == 1){
				$a = $row['path'].",$pgID*";
				if(!$row['success']) {
					$success = 2;
					$sqlAdd .= ",success=1";
				}
			} else {
				$a = $row['path'].",$pgID";
			}
			$timeOnLastPg = $curTime - $row['timeOfLastHit'];
			if($row['times'] != '') {
				$times = $row['times'].",$timeOnLastPg";
			} else {
				$times = "$timeOnLastPg";
			}
			if(!$row['conversion']) {
				$conversion = 2;
				$sqlAdd .= ",conversion=1";
			}	else {
				$conversion = 1;
			}
			if(($row['trackByIP']==1) && ($trackByIP==0) ) {
				$trackByIP = 0;
				$sqlAdd .= ",trackByIP=0";				
				$sql = "UPDATE L10HC_recentVisits SET vKey=\"$vID\" WHERE vID=$vID";
				$result = db_query($sql,__FILE__,__LINE__);
			}

			$sql = "UPDATE L10HC_activeSessions SET pgIDLastHit=$pgID,timeOfLastHit=$curTime,dateOfLastHit=$curDateDB,path=\"$a\",times=\"$times\"$sqlAdd WHERE vID=$vID";	
			$result = db_query($sql,__FILE__,__LINE__);
		}
	} else { // active session not found
		if(!$trackByIP) {
			$sql = "SELECT * FROM L10HC_recentVisits where vID=$vID";		
			$result = db_query($sql,__FILE__,__LINE__);

			$rVData = db_fetch_array($result,__FILE__,__LINE__);
			if($rVData) {
				$sessionType = 1;
			} else {
				$sessionType = 2;
			}
			$sql = "SELECT * FROM L10HC_archiveSessions where vID=$vID ORDER BY date,timeOfDay DESC";		
			$result = db_query($sql,__FILE__,__LINE__);
			
			$row = db_fetch_array($result,__FILE__,__LINE__);
//log_event("returning visitor (cookie): vID=$vID, sesssionType=$sessionType, last visit=".$row['date']." ".$row['timeOfDay']);
		} else {
//log_event("returning visitor (IP): vID=$vID, sesssionType=$sessionType");		
		}

	}
}

//
// New Session processing
//
if($sessionType >= 1) {
	if($sessionType == 3) { // new Session
		$sql = "INSERT INTO L10HC_visitors VALUES(NULL)";		
		$result = db_query($sql,__FILE__,__LINE__);
		$vID = db_insert_id();
		$sessionTypeInit = 3;
	}	
	if($sessionType >= 2) {
		$sql = "INSERT INTO L10HC_recentVisits VALUES('$vKey',$vID,0,0,$curDateDB,$sessionTypeInit,$curTime,0,0)";		
		$result = db_query($sql,__FILE__,__LINE__);
		$sessionTypeInit = $sessionType;
	} elseif($sessionType == 1) {
		$sessionTypeInit = $rVData['sessionTypeInit'];
		$pgIDInit = $rVData['pgIDInit'];
		$refIDInit = $rVData['refIDInit'];
		$dateInit = $rVData['dateInit'];
		if($rVData['success']) {
			$successPrev = 1;
		}
		if($rVData['conversion']) {
			$conversionPrev = 1;
		}
		$sql = "UPDATE L10HC_recentVisits SET time=$curTime WHERE vKey='$vKey'";		
		$result = db_query($sql,__FILE__,__LINE__);
	}

//
// Ref processing
//
	if($ref == "") {
		if($_GET[ref] != "") {
			$ref = $_GET[ref];
			if(substr($ref,0,7) == "http://") {
				$ref = substr($ref,7);
			} elseif((substr($ref,0,8) == "https://")) {
				$ref = substr($ref,8);
			}	
			if($removeRefWWW > 0) {
				$ref0 = $ref;
				$ref = preg_replace("/^w{1,3}\./","",$ref);
			}
		} else {
			$ref = '[No Referrer]/';
			$refType = '[Unknown]';
		}
	}
	$a = explode('/',$ref);
	$refDom = array_shift($a);

	$refc = censorRef($refDom);
	if(strlen($refc)) {
		$refDom = "[".$refc."]";
	}
	if(substr($refDom,0,1) != '[' && substr($refDom,0,1) != '`') {
		$refDom = strtolower($refDom);
	}
	$refPN = implode('/',$a);
	//$refPN = str_replace("&","%26",$refPN); ?QA	
	
	$sql = "SELECT L10HC_listRef.ID FROM L10HC_listRef,L10HC_listRefDom where (L10HC_listRef.refDomID = L10HC_listRefDom.ID) AND (L10HC_listRef.pathname = \"$refPN\") AND (L10HC_listRefDom.dom = \"$refDom\")";		
	$result = db_query($sql,__FILE__,__LINE__);
	
	$row = db_fetch_array($result,__FILE__,__LINE__);
	if($row) {
		$refID = $row['ID'];
	} else { // insert new ref
		// search SE L10HC_directory for domain
		$sql = "SELECT parentName,childName,searchKey FROM L10HC_directorySE where dom = \"$refDom\"";		
		$result = db_query($sql,__FILE__,__LINE__);
		
		$row = db_fetch_array($result,__FILE__,__LINE__);
		if($row) {
			$refSE = $row['parentName'];
			if(strlen($row['childName']) > 0) {
				$refSE .= " ".$row['childName'];
			}
			if($row['searchKey'] == "") { // search directory
				$refKW = $refPN;
			} else {
				$refKW = '[Unknown]';
				$a = explode("?",$refPN);
				$a[1] = str_replace("$26","&",$a[1]);
				$b = explode("&",$a[1]);
				for($i=0;$i<count($b);$i++) {
					$c = explode("=",$b[$i]);
					if($c[0] == $row['searchKey']) {
						$refKW = $c[1];
						if($lowercaseKW) {
							$refKW = strtolower($refKW);
						}
						break;
					}
				}
			}			
			if($refType == "") {
				$refType = '[Major SE]';
			}
			$refKW = trim($refKW);
			$refKW = urldecode($refKW);
			$refKW = addslashes($refKW);
			
			$sql = "SELECT ID FROM L10HC_listRefSE where SE = \"$refSE\"";		
			$result = db_query($sql,__FILE__,__LINE__);			
			$row = db_fetch_array($result,__FILE__,__LINE__);
			if($row) {
				$refSEID = $row['ID'];
			} else {  // insert new pgDom
				$sql = "INSERT INTO L10HC_listRefSE VALUES(NULL,\"$refSE\")";		
				$result = db_query($sql,__FILE__,__LINE__);
				$refSEID = db_insert_id();	
			}

			$sql = "SELECT ID FROM L10HC_listRefKW where KW = \"$refKW\"";		
			$result = db_query($sql,__FILE__,__LINE__);			
			$row = db_fetch_array($result,__FILE__,__LINE__);
			if($row) {
				$refKWID = $row['ID'];
			} else {  // insert new pgDom
				$sql = "INSERT INTO L10HC_listRefKW VALUES(NULL,\"$refKW\")";		
				$result = db_query($sql,__FILE__,__LINE__);
				$refKWID = db_insert_id();	
			}
			
		} else {  // insert new pgDom
			$refSEID = 1;
			$refKWID = 1;
			if($refType == "") {
				$refType = '[Site Link]';
			}
		}
	
		$sql = "SELECT ID FROM L10HC_listRefType where type = \"$refType\"";		
		$result = db_query($sql,__FILE__,__LINE__);			
		$row = db_fetch_array($result,__FILE__,__LINE__);
		if($row) {
			$refTypeID = $row['ID'];
		} else {  // insert new pgDom
			$sql = "INSERT INTO L10HC_listRefType VALUES(NULL,\"$refType\")";		
			$result = db_query($sql,__FILE__,__LINE__);
			$refTypeID = db_insert_id();	
		}
	
		$sql = "SELECT ID FROM L10HC_listRefDom where dom = \"$refDom\"";		
		$result = db_query($sql,__FILE__,__LINE__);
		
		$row = db_fetch_array($result,__FILE__,__LINE__);
		if($row) {
			$refDomID = $row['ID'];
		} else {  // insert new refDom
			$sql = "INSERT INTO L10HC_listRefDom VALUES(NULL,\"$refDom\")";		
			$result = db_query($sql,__FILE__,__LINE__);
			$refDomID = db_insert_id();	
		}
		$sql = "INSERT INTO L10HC_listRef VALUES(NULL,$refDomID,\"$refPN\",$refSEID,$refKWID,$refTypeID)";		
		$result = db_query($sql,__FILE__,__LINE__);
		$refID = db_insert_id();	
	}
	
// remote host
	$host = @getHostByAddr($REMOTE_ADDR);	
	$host2 = '';
	$tldID = 1;
	if(empty($host)) {
		$host = $REMOTE_ADDR;
	} else {
		$a = explode(".",$host);
		if(!(preg_match("/^\d+$/",$a[count($a)-2]) && preg_match("/^\d+$/",$a[count($a)-1]))) {
			$host = strtolower($a[count($a)-2]);
			if($host=="com" || $host=="co" || $host=="net" || $host=="org") {
				$host2 = $host.".".strtolower($a[count($a)-1]);
				$host = strtolower($a[count($a)-3]);			
			} else {
				$host2 = strtolower($a[count($a)-1]);
			}

			$sql = "SELECT * FROM L10HC_listTLD WHERE tld=\"".$a[count($a)-1]."\"";	
			$result = db_query($sql,__FILE__,__LINE__);
			$row = db_fetch_array($result,__FILE__,__LINE__);
			if($row) {
				$tldID = $row[ID];
			}
		}
			
	}
	$sql = "SELECT * FROM L10HC_listRemoteHost WHERE host=\"$host\" AND host2=\"$host2\" ";	
	$result = db_query($sql,__FILE__,__LINE__);
	$row = db_fetch_array($result,__FILE__,__LINE__);
	if($row) {
		$hostID = $row[ID];
	} else {
		$sql = "INSERT INTO L10HC_listRemoteHost VALUES (NULL,\"$host\",\"$host2\",$tldID)";
		$result = db_query($sql,__FILE__,__LINE__);
		$hostID = db_insert_id();			
	}
	
	$sql = "SELECT entries FROM L10HC_statsRemoteHost WHERE hostID=$hostID AND date=$curDateDB";	
	$result = db_query($sql,__FILE__,__LINE__);
	$row = db_fetch_array($result,__FILE__,__LINE__);
	if($row) {
		$row[entries]++;
		$sql = "UPDATE L10HC_statsRemoteHost SET entries=".$row[entries]." WHERE  hostID=$hostID AND date=$curDateDB";	
	} else {
		$sql = "INSERT INTO L10HC_statsRemoteHost VALUES ($hostID,$curDateDB,1)";
	}
	$result = db_query($sql,__FILE__,__LINE__);

// Languages
	$a = $_GET['nl'];
	if($a == 'undefined') {
		$a = $_GET['sl'];
	}
	$a = strtolower($a);
	$sql = "SELECT ID,today FROM L10HC_statsExtLang WHERE iKey=\"$a\"";	
	$result = db_query($sql,__FILE__,__LINE__);
	$row = db_fetch_array($result,__FILE__,__LINE__);
	if($row) {
		$langID = $row[ID];
	} else {
		if(strpos($a,"-") > 0) {
			$a = explode("-",$a);
			$sql = "SELECT ID,today FROM L10HC_statsExtLang WHERE iKey=\"$a[0]\"";	
			$result = db_query($sql,__FILE__,__LINE__);
			$row = db_fetch_array($result,__FILE__,__LINE__);
				if($row) {
					$langID = $row[ID];
				} else {
					$langID = 0;
				}
		} else {
			$langID = 1;
		}
		$sql = "SELECT today FROM L10HC_statsExtLang WHERE ID=$langID";	
		$result = db_query($sql,__FILE__,__LINE__);
		$row = db_fetch_array($result,__FILE__,__LINE__);
	}
	$row[today]++;
	$sql = "UPDATE L10HC_statsExtLang SET today=".$row[today]." WHERE  ID=$langID";	
	$result = db_query($sql,__FILE__,__LINE__);
// Browsers, OS
	$osList = array();
	$osIDs = array();
	$os = '[Unknown]';
	
	if($_GET['nn'] == "Microsoft Internet Explorer") {
		$a = explode(";",$_GET['os']);
		$a[1] = preg_replace("/^ /","",$a[1]);
		$browserVer = $a[1];
		$browser = "MSIE";
		$a[2] = preg_replace("/\)$/","",$a[2]);
		$a[2] = preg_replace("/^ /","",$a[2]);
		
		$sql = "SELECT ID,iKey,os FROM L10HC_statsExtOS";
		$result = db_query($sql,__FILE__,__LINE__);
		while($row = db_fetch_array($result,__FILE__,__LINE__)) {
			$osIDs[$row['iKey']] = $row['ID'];
			$osList[$row['iKey']] = $row['os'];
		}
		$os = '[Unknown]';
		$a = explode(";",$_GET['os']);
		for($i=0;$i<count($a);$i++) {
			$a[$i] = preg_replace("/\)$/","",$a[$i]);
			$a[$i] = preg_replace("/^ /","",$a[$i]);
			$a[$i] = preg_replace("/^\(/","",$a[$i]);
			if($osList[$a[$i]]) {
				$os = $osList[$a[$i]];
				break;
			}
		}
	} elseif(($_GET['nn'] == "Netscape") || ($_GET['nn'] == "Konqueror") || ($_GET['nn'] == "Opera")) {

		$a = explode(" ",$_GET['nv']);
		if(($_GET['nn'] == "Netscape") && (strlen($a[0]) >= 5)) {
			$si = strpos($a[0],"Netscape6/");
			if(($si = strpos($a[0],"Netscape6/")) === false) {
				$browserVer = $_GET['nn']." ".substr($a[0],$si+10);	
			} elseif(($si = strpos($a[0],"Netscape/")) === false) {
				$browserVer = $_GET['nn']." ".substr($a[0],$si+9);
			} else {
				$browserVer = "Netscape [version unkown]";
			}
		} else {
			$browserVer = $_GET['nn']." ".$a[0];
		}
		$browser = $_GET['nn'];
		
		$sql = "SELECT ID,iKey,os FROM L10HC_statsExtOS";
		$result = db_query($sql,__FILE__,__LINE__);
		while($row = db_fetch_array($result,__FILE__,__LINE__)) {
			$osIDs[$row['iKey']] = $row['ID'];
			$osList[$row['iKey']] = $row['os'];
		}
		$os = '[Unknown]';
		$a = explode(";",$_GET['os']);
		for($i=0;$i<count($a);$i++) {
			$a[$i] = preg_replace("/\)$/","",$a[$i]);
			$a[$i] = preg_replace("/^ /","",$a[$i]);
			$a[$i] = preg_replace("/^\(/","",$a[$i]);
			if($osList[$a[$i]]) {
				$os = $osList[$a[$i]];
				break;
			}
		}
	} else {
		$browser = '[Unknown]';
		$browserVer = '[Unknown]';
		$os = '[Unknown]';
		
	}
	if($os == '[Unknown]') {
		//log_event("Unknown OS: [os]=".$_GET['os'].", [nn]=".$_GET['nn'].", [nv]=".$_GET['nv']);
	}
	$sql = "SELECT ID,today FROM L10HC_statsExtOS WHERE iKey=\"$os\"";	
	$result = db_query($sql,__FILE__,__LINE__);
	$row = db_fetch_array($result,__FILE__,__LINE__);
	if($row) {
		$osID = $row[ID];
	} else {
		$osID = 1;
		$sql = "SELECT today FROM L10HC_statsExtOS WHERE ID=$osID";	
		$result = db_query($sql,__FILE__,__LINE__);
		$row = db_fetch_array($result,__FILE__,__LINE__);
	}
	$row[today]++;
	$sql = "UPDATE L10HC_statsExtOS SET today=".$row[today]." WHERE  ID=$osID";	
	$result = db_query($sql,__FILE__,__LINE__);
	
	$sql = "SELECT ID,today FROM L10HC_statsExtBrowser WHERE browser=\"$browser\"";	
	$result = db_query($sql,__FILE__,__LINE__);
	$row = db_fetch_array($result,__FILE__,__LINE__);
	if($row) {
		$browserID = $row[ID];
		$row[today]++;
		$sql = "UPDATE L10HC_statsExtBrowser SET today=".$row[today]." WHERE  ID=$browserID";	
		$result = db_query($sql,__FILE__,__LINE__);
	} else {
		$sql = "INSERT INTO L10HC_statsExtBrowser VALUES (NULL,\"$browser\",1,0,0,0)";	
		$result = db_query($sql,__FILE__,__LINE__);
		$browserID = db_insert_id();			
	}
	
	$sql = "SELECT ID,today FROM L10HC_statsExtBrowserV WHERE browserV=\"$browserVer\"";	
	$result = db_query($sql,__FILE__,__LINE__);
	$row = db_fetch_array($result,__FILE__,__LINE__);
	if($row) {
		$browserVerID = $row[ID];
		$row[today]++;
		$sql = "UPDATE L10HC_statsExtBrowserV SET today=".$row[today]." WHERE  ID=$browserVerID";	
		$result = db_query($sql,__FILE__,__LINE__);
	} else {
		$sql = "INSERT INTO L10HC_statsExtBrowserV VALUES (NULL,\"$browserVer\",1,0,0,0)";	
		$result = db_query($sql,__FILE__,__LINE__);
		$browserVerID = db_insert_id();			
	}
// Screen Clrs, Res
	$screenRes = $_GET['sx'].'x'.$_GET['sy'];
	if($screenRes == "x") {
		$screenRes = '[Unknown]';
	}
	$sql = "SELECT ID,today FROM L10HC_statsExtScrnRes WHERE scrnRes=\"$screenRes\"";	
	$result = db_query($sql,__FILE__,__LINE__);
	$row = db_fetch_array($result,__FILE__,__LINE__);
	if($row) {
		$screenResID = $row[ID];
		$row[today]++;
		$sql = "UPDATE L10HC_statsExtScrnRes SET today=".$row[today]." WHERE  ID=$screenResID";	
		$result = db_query($sql,__FILE__,__LINE__);
	} else {
		$sql = "INSERT INTO L10HC_statsExtScrnRes VALUES (NULL,\"$screenRes\",1,0,0,0)";	
		$result = db_query($sql,__FILE__,__LINE__);
		$screenResID = db_insert_id();			
	}

	$screenClrs = $_GET['cd'];
	if($screenClrs == "") {
		$screenClrs = '[Unknown]';
	}
	$sql = "SELECT ID,today FROM L10HC_statsExtScrnClrs WHERE ScrnClrs=\"$screenClrs\"";	
	$result = db_query($sql,__FILE__,__LINE__);
	$row = db_fetch_array($result,__FILE__,__LINE__);
	if($row) {
		$screenClrsID = $row[ID];
		$row[today]++;
		$sql = "UPDATE L10HC_statsExtScrnClrs SET today=".$row[today]." WHERE  ID=$screenClrsID";	
		$result = db_query($sql,__FILE__,__LINE__);
	} else {
		$sql = "INSERT INTO L10HC_statsExtScrnClrs VALUES (NULL,\"$screenClrs\",1,0,0,0)";	
		$result = db_query($sql,__FILE__,__LINE__);
		$screenClrsID = db_insert_id();			
	}
// timezone
	$timezone = $_GET['tz'];	
	if($timezone == "") {
		$timezone == "[Unknown]";
	}
	
	$sql = "SELECT ID,today FROM L10HC_statsExtTimezone WHERE timezone=\"$timezone\"";	
	$result = db_query($sql,__FILE__,__LINE__);
	$row = db_fetch_array($result,__FILE__,__LINE__);
	if($row) {
		$timezoneID = $row[ID];
		$row[today]++;
		$sql = "UPDATE L10HC_statsExtTimezone SET today=".$row[today]." WHERE  ID=$timezoneID";	
		$result = db_query($sql,__FILE__,__LINE__);
	} else {
		$sql = "INSERT INTO L10HC_statsExtTimezone VALUES (NULL,\"$timezone\",1,0,0,0)";	
		$result = db_query($sql,__FILE__,__LINE__);
		$timezoneID = db_insert_id();			
	}
// activeSessions
	if(!$pgIDInit) {$pgIDInit = $pgID;}
	if(!$refIDInit) {$refIDInit = $refID;}
	$sql = "INSERT INTO L10HC_activeSessions VALUES(NULL,$vID,$pgID,$curTime,$curDateDB,\"$pgID\",\"\",$pgIDInit,$refIDInit,$pgID,$refID,$hostID,$langID,$osID,$browserID,$browserVerID,$screenResID,$screenClrsID,$timezoneID,$curTime,\"$dateInit\",$curDateDB,$curToDDB,$sessionTypeInit,$sessionType,$conversionPrev,$successPrev,$trackByIP)";	
	$result = db_query($sql,__FILE__,__LINE__);
// statsRef	
	$sql = "SELECT * FROM L10HC_statsRef WHERE refID = $refID AND date = $curDateDB";	
	$result = db_query($sql,__FILE__,__LINE__);

	$row = db_fetch_array($result,__FILE__,__LINE__);
	if(!$row) {
		$row = array($refID,$curDateDB,0,0,0,0,0,0,0,0);
		$sql = "INSERT INTO L10HC_statsRef VALUES(".implode(",",$row).")";		
		$result = db_query($sql,__FILE__,__LINE__);	
	}
	switch($sessionType) {
		case 3: $row[4]++;
		case 2: $row[3]++;
		case 1: $row[2]++;
	}
	$sql = "UPDATE L10HC_statsRef SET entries=$row[2],entriesUnique=$row[3],entriesNew=$row[4] WHERE refID = $refID AND date = $curDateDB";
	$result = db_query($sql,__FILE__,__LINE__);

	$sql = "SELECT * FROM L10HC_statsRefPg WHERE refID=$refID AND pgID=$pgID AND date=$curDateDB";	
	$result = db_query($sql,__FILE__,__LINE__);
	$row = db_fetch_array($result,__FILE__,__LINE__);
	if(!$row) {
		$row = array($refID,$pgID,$curDateDB,0,0,0,0,0,0,0,0);
		$sql = "INSERT INTO L10HC_statsRefPg VALUES(".implode(",",$row).")";		
		$result = db_query($sql,__FILE__,__LINE__);	
	}
	switch($sessionType) {
		case 3: $row[5]++;
		case 2: $row[4]++;
		case 1: $row[3]++;
	}
	$sql = "UPDATE L10HC_statsRefPg SET entries=$row[3],entriesUnique=$row[4],entriesNew=$row[5] WHERE refID=$refID AND pgID=$pgID AND date = $curDateDB";
	$result = db_query($sql,__FILE__,__LINE__);

	
} 
//
// stats data
//
$sql = "SELECT * FROM L10HC_statsPg WHERE pgID = $pgID AND date = $curDateDB";	
$result = db_query($sql,__FILE__,__LINE__);

$row = db_fetch_array($result,__FILE__,__LINE__);
if(!$row) {
	$row = array($pgID,$curDateDB,0,0,0,0,0,0,0,0,0,0,0,0,0,0);
	$sql = "INSERT INTO L10HC_statsPg VALUES(".implode(",",$row).")";		
	$result = db_query($sql,__FILE__,__LINE__);
} 
if($reload) {
	$row[17]++;
	$sql = "UPDATE L10HC_statsPg SET reloads=$row[17] WHERE pgID = $pgID AND date = $curDateDB";
	$result = db_query($sql,__FILE__,__LINE__);
} else {  //not a reload
	switch($sessionType) {
		case 3: {
			$row[5]++;
			$statsHits[$curDate][entriesNew]++;
		}
		case 2: {
			$row[4]++;
			$statsHits[$curDate][entriesUnique]++;
		}
		case 1: { 
			$row[3]++;
			$statsHits[$curDate][entries]++;
		}
	}
	$row[2]++;	
	$statsHits[$curDate][hits]++;
	$sql = "UPDATE L10HC_statsPg SET hits=$row[2],entries=$row[3],entriesUnique=$row[4],entriesNew=$row[5] WHERE pgID = $pgID AND date = $curDateDB";
	$result = db_query($sql,__FILE__,__LINE__);
	//update time on page for last page
	if($pgIDLastHit > 0) {
		$sql = "SELECT hits,timeOnPg FROM L10HC_statsPg WHERE pgID = $pgIDLastHit AND date = \"$dateOfLastHit\"";	
		$result = db_query($sql,__FILE__,__LINE__);
		$row = db_fetch_array($result,__FILE__,__LINE__);
		$newTime = round(($row['hits']*$row['timeOnPg']+10*$timeOnLastPg)/($row['hits']+1));
		$sql = "UPDATE L10HC_statsPg SET timeOnPg=$newTime WHERE pgID=$pgIDLastHit AND date=\"$dateOfLastHit\"";	
		$result = db_query($sql,__FILE__,__LINE__);
		
		$sql = "SELECT * FROM L10HC_statsPgPg WHERE pgID0=$pgIDLastHit AND pgID1=$pgID AND date=\"$dateOfLastHit\"";	
		$result = db_query($sql,__FILE__,__LINE__);
		$row = db_fetch_array($result,__FILE__,__LINE__);
		if($row) {
			$row['count']++;
			$newTime = round(($row['count']*$row['timeOnPg']+10*$timeOnLastPg)/($row['count']+1));
			$sql = "UPDATE L10HC_statsPgPg SET count=".$row['count'].",timeOnPg=$newTime WHERE pgID0=$pgIDLastHit AND pgID1=$pgID AND date=\"$dateOfLastHit\"";	
		} else {
			$sql = "INSERT INTO L10HC_statsPgPg VALUES ($pgIDLastHit,$pgID,\"$dateOfLastHit\",1,$timeOnLastPg)";
		}
		$result = db_query($sql,__FILE__,__LINE__);
	}
	if(($conversion==2) || ($success==2)) {
		if($dateInit != $curDate) {
			$updateYday = 1;
		}
		$sql = "SELECT * FROM L10HC_statsPg WHERE pgID=$pgIDInit AND date = \"$dateInit\"";	
		$result = db_query($sql,__FILE__,__LINE__);
		$row = db_fetch_array($result,__FILE__,__LINE__);
		if($conversion==2) {
			if($sessionTypeInit==3) { 
				$row['conversionsNew'] ++;
				$statsHits[$dateInit]['conversionsNew']++;
			}
			$row['conversionsUnique'] ++;
			$statsHits[$dateInit]['conversionsUnique']++;
		} 
		if($success==2) {
			if($sessionTypeInit==3) { 
				$row['successesNew'] ++;
				$statsHits[$dateInit]['successesNew']++;
			}
			$row['successesUnique'] ++;
			$statsHits[$dateInit]['successesUnique']++;
		} 
		$sql = "UPDATE L10HC_statsPg SET conversionsNew=".$row['conversionsNew'].",conversionsUnique=".$row['conversionsUnique'].",successesNew=".$row['successesNew'].",successesUnique=".$row['successesUnique']." WHERE pgID=$pgIDInit AND date=\"$dateInit\"";	
		$result = db_query($sql,__FILE__,__LINE__);		
		
		$sql = "SELECT * FROM L10HC_statsRef WHERE refID=$refIDInit AND date = \"$dateInit\"";	
		$result = db_query($sql,__FILE__,__LINE__);
		$row = db_fetch_array($result,__FILE__,__LINE__);
		if($conversion==2) {
			if($sessionTypeInit==3) { 
				$row['conversionsNew'] ++;
			}
			$row['conversionsUnique'] ++;
		} 
		if($success==2) {
			if($sessionTypeInit==3) { 
				$row['successesNew'] ++;
			}
			$row['successesUnique'] ++;
		} 
		
		$sql = "UPDATE L10HC_statsRef SET conversionsNew=".$row['conversionsNew'].",conversionsUnique=".$row['conversionsUnique'].",successesNew=".$row['successesNew'].",successesUnique=".$row['successesUnique']." WHERE refID=$refIDInit AND date=\"$dateInit\"";	
		$result = db_query($sql,__FILE__,__LINE__);		
		
		$sql = "SELECT * FROM L10HC_statsRefPg WHERE refID=$refIDInit AND pgID=$pgIDInit AND date = \"$dateInit\"";	
		$result = db_query($sql,__FILE__,__LINE__);
		$row = db_fetch_array($result,__FILE__,__LINE__);
		if($conversion==2) {
			if($sessionTypeInit==3) { 
				$row['conversionsNew'] ++;
			}
			$row['conversionsUnique'] ++;
		} 
		if($success==2) {
			if($sessionTypeInit==3) { 
				$row['successesNew'] ++;
			}
			$row['successesUnique'] ++;
		} 
		$sql = "UPDATE L10HC_statsRefPg SET conversionsNew=".$row['conversionsNew'].",conversionsUnique=".$row['conversionsUnique'].",successesNew=".$row['successesNew'].",successesUnique=".$row['successesUnique']." WHERE refID=$refIDInit AND pgID=$pgIDInit AND date=\"$dateInit\"";	
		$result = db_query($sql,__FILE__,__LINE__);		

	}
}
// update Period stats
if(!$reload) {
	$sql = "SELECT * FROM L10HC_statsHoD WHERE hr=$curHr AND type=0";
	$result = db_query($sql,__FILE__,__LINE__);		
	$row = db_fetch_array($result,__FILE__,__LINE__);
	if($sessionType > 1) {
		$row[entriesUnique]++;
	}
	$row[hits]++;
	$sql = "UPDATE L10HC_statsHoD SET entriesUnique=$row[entriesUnique],hits=$row[hits] WHERE hr=$curHr AND type=0";
	$result = db_query($sql,__FILE__,__LINE__);	

	$sql = "SELECT * FROM L10HC_statsDoW WHERE day=$curDoW AND type=0";
	$result = db_query($sql,__FILE__,__LINE__);		
	$row = db_fetch_array($result,__FILE__,__LINE__);
	if($sessionType > 1) {
		$row[entriesUnique]++;
	}
	$row[hits]++;
	$sql = "UPDATE L10HC_statsDoW SET entriesUnique=$row[entriesUnique],hits=$row[hits] WHERE day=$curDoW AND type=0";
	$result = db_query($sql,__FILE__,__LINE__);	
	
	$sql = "SELECT * FROM L10HC_statsDoM WHERE day=$curDay AND type=0";
	$result = db_query($sql,__FILE__,__LINE__);		
	$row = db_fetch_array($result,__FILE__,__LINE__);
	if($sessionType > 1) {
		$row[entriesUnique]++;
	}
	$row[hits]++;
	$sql = "UPDATE L10HC_statsDoM SET entriesUnique=$row[entriesUnique],hits=$row[hits] WHERE day=$curDay AND type=0";
	$result = db_query($sql,__FILE__,__LINE__);	

	$sql = "SELECT * FROM L10HC_statsHits WHERE date=$curDateDB OR date=\"$ydayDate\" ORDER BY date DESC";
	$result = db_query($sql,__FILE__,__LINE__);
	$row[$curDate] = db_fetch_array($result,__FILE__,__LINE__);
	$row[$ydayDate] = db_fetch_array($result,__FILE__,__LINE__);
	foreach($statsHits[$curDate] as $k=>$v) {
		$statsHits[$curDate][$k] += $row[$curDate][$k];
	}
	
	$sql = "UPDATE L10HC_statsHits SET hits=".$statsHits[$curDate][hits].",entries=".$statsHits[$curDate][entries].",entriesUnique=".$statsHits[$curDate][entriesUnique].",entriesNew=".$statsHits[$curDate][entriesNew].",conversionsUnique=".$statsHits[$curDate][conversionsUnique].",conversionsNew=".$statsHits[$curDate][conversionsNew].",successesUnique=".$statsHits[$curDate][successesUnique].",successesNew=".$statsHits[$curDate][successesNew]." WHERE date=$curDateDB";	
	$result = db_query($sql,__FILE__,__LINE__);		
	
	if($updateYday) {
		foreach($statsHits[$ydayDate] as $k=>$v) {
			$statsHits[$ydayDate][$k] += $row[$ydayDate][$k];
		}
		$sql = "UPDATE L10HC_statsHits SET hits=".$statsHits[$ydayDate][hits].",entries=".$statsHits[$ydayDate][entries].",entriesUnique=".$statsHits[$ydayDate][entriesUnique].",entriesNew=".$statsHits[$ydayDate][entriesNew].",conversionsUnique=".$statsHits[$ydayDate][conversionsUnique].",conversionsNew=".$statsHits[$ydayDate][conversionsNew].",successesUnique=".$statsHits[$ydayDate][successesUnique].",successesNew=".$statsHits[$ydayDate][successesNew]." WHERE date=$ydayDateDB";	
		$result = db_query($sql,__FILE__,__LINE__);		
	}

// hit counter display data
	if(1==1) {
		$sql = "SELECT * FROM L10HC_statsPgAT WHERE pgID=$pgID OR pgID=0 ORDER BY pgID ASC";
		$result = db_query($sql,__FILE__,__LINE__);
	
		$row[0] = db_fetch_array($result,__FILE__,__LINE__);
		$row[1] = db_fetch_array($result,__FILE__,__LINE__);
		for($i=1;$i<11;$i+=2) {
			$row[0][$i] ++;
			$row[1][$i] ++;
			if($sessionType > 0) {
				$row[0][$i+1] ++;
				$row[1][$i+1] ++;
			}
		}
		$sql = "UPDATE L10HC_statsPgAT SET hits0=".$row[0][1].",entries0=".$row[0][2].",hits1=".$row[0][3].",entries1=".$row[0][4].",hits2=".$row[0][5].",entries2=".$row[0][6].",hits3=".$row[0][7].",entries3=".$row[0][8].",hits4=".$row[0][9].",entries4=".$row[0][10]." WHERE pgID=0";
		$result = db_query($sql,__FILE__,__LINE__);	
		$sql = "UPDATE L10HC_statsPgAT SET hits0=".$row[1][1].",entries0=".$row[1][2].",hits1=".$row[1][3].",entries1=".$row[1][4].",hits2=".$row[1][5].",entries2=".$row[1][6].",hits3=".$row[1][7].",entries3=".$row[1][8].",hits4=".$row[1][9].",entries4=".$row[1][10]." WHERE pgID=$pgID";
		$result = db_query($sql,__FILE__,__LINE__);	
	}
}

returnHitImage();

function returnHitImage($disableCookie=0) {
	global $vID,$startDate,$browserBlock,$cookiePW,$acctCk,$pathToImg;
	
	if(!$disableCookie && $vID>0) {
		setcookie('L10HC'.$acctCk,"$vID|$startDate|$browserBlock|$cookiePW",time()+31536000);
	}
	$name = $pathToImg."L10HC_Img_L.gif";
	$fp = fopen($name, 'rb');

	header("Content-Type: image/gif");
	header("Content-Length: ".filesize($name));

	fpassthru($fp);	
}
?>