<?
// ############################################################
// # StatIt                                                   #
// ############################################################
// # by Helge Orthmann                                        #
// # Contact: otter@otterware.de                              #
// # Homepage: http://www.otterware.de                        #
// ############################################################
// # Leave this header in this file !                         #
// ############################################################
if($id=="" || $id<"0" || $id>"99999") exit;
$abspath = dirname(__FILE__);
require "$abspath/config.php";
if(!isset($refer)) $refer = $HTTP_REFERER;
$mysql = mysql_pconnect ("$mysqlhost", "$mysqllogin", "$mysqlpassword");
if($mysql != false) $mydb = mysql_select_db ("$mysqldb");
require "_functions.inc.php";
// Nur ausführen, wenn Datenbankverbindung und wenn kein Reload , keine geblockte IP und kein geblockter Server
if($mydb != false && $server_error != 1 && $ip_error != 1 && $ipblock_error != 1)
{
	$host = gethostbyaddr($ipaddr);
	if($host == $ipaddr) $host = "?";
	$lang1 = $HTTP_ACCEPT_LANGUAGE; 
	$lang1 = str_replace (",", "-", $lang1);
	$lang2 = explode (";", $lang1);
	$lang = $lang2[0];
	if(!$lang) $lang = "?";
	// löschen vom letzten Monat ############################
	$SQLT = mysql_query("SELECT aktmonth FROM st_stat");
	$AKTM = mysql_fetch_array($SQLT);
	if($AKTM[aktmonth]!=$month1) mysql_query("DELETE FROM st_day WHERE ID='$id'");
	// Tabelle day #######################################
	$SQL1 = mysql_query("SELECT * FROM st_day where day='$day1' AND ID='$id'");
	if (mysql_fetch_row($SQL1)) mysql_query("UPDATE st_day SET hits = hits + 1 WHERE day='$day1' AND ID='$id'");
	else mysql_query("INSERT INTO st_day SET ID='$id',day='$day1',hits='1'");
	// Tabelle wday ######################################
	in_table("st_wday","wday",$wday);
	// Tabelle hour ######################################
	in_table("st_hour","hour",$hour1);
	// Tabelle month #####################################
	//in_table("st_month","month",$month1);
	$SQL9 = mysql_query("SELECT * FROM st_month where month='$month1' AND year='$year' AND ID='$id'");
	if (mysql_fetch_row($SQL9)) mysql_query("UPDATE st_month SET hits = hits + 1 WHERE month='$month1' AND year='$year' AND ID='$id'");
	else mysql_query("INSERT INTO st_month SET ID='$id',month='$month1',year='$year',hits='1'");
	//mysql_query("DELETE FROM st_month WHERE month='$lastyearm' WHERE ID='$id'");
	// Total ##############################################
	$SQL = mysql_query("SELECT * FROM st_stat where ID='$id'");
	if (mysql_fetch_row($SQL)) mysql_query("UPDATE st_stat SET aktmonth='$month1', total = total + 1 WHERE ID='$id'");
	else mysql_query("INSERT INTO st_stat SET ID='$id',aktmonth='$month1',total='1'");
	// cookie ############################################
	if(!isset($PHPStatIt))
	{
		setcookie ("PHPStatIt", "$day2.$month2.$year", time()+31536000);
		mysql_query("UPDATE st_stat SET uni = uni + 1 WHERE ID='$id'");
	}
	// Top tag und Top Monat###############################
	$SQL3 = mysql_query("SELECT tophitsd,tophitsm FROM st_stat WHERE ID='$id'");
	$TOPH = mysql_fetch_row($SQL3);
	$SQL4 = mysql_query("SELECT hits FROM st_day WHERE day='$day1' AND ID='$id'");
	$MAXD = mysql_fetch_row($SQL4);
	$SQLT3 = mysql_query("SELECT hits FROM st_month WHERE month='$month1' AND ID='$id'");
	$MAXM = mysql_fetch_row($SQLT3);
	if($MAXD[0]>=$TOPH[0]) mysql_query("UPDATE st_stat SET topday='$aktday', tophitsd='$MAXD[0]' WHERE ID='$id'");
	if($MAXM[0]>=$TOPH[1]) mysql_query("UPDATE st_stat SET topmonth='$aktmonth', tophitsm='$MAXM[0]' WHERE ID='$id'");
	// JavaScript #########################################
	if($njs=="1") mysql_query("UPDATE st_stat SET nojavascript = nojavascript + 1 WHERE ID='$id'");
	else mysql_query("UPDATE st_stat SET javascript = javascript + 1 WHERE ID='$id'");
	// browser ############################################
	if( eregi("(opera) ([0-9]{1,2}.[0-9]{1,3}){0,1}",$HTTP_USER_AGENT,$regs) || eregi("(opera/)([0-9]{1,2}.[0-9]{1,3}){0,1}",$HTTP_USER_AGENT,$regs)){$browser = "Opera $regs[2]";}
	else if( eregi("(konqueror)/([0-9]{1,2}.[0-9]{1,3})",$HTTP_USER_AGENT,$regs) ){$browser = "Konqueror $regs[2]";}
	else if( eregi("(omniweb/)([0-9]{1,2}.[0-9]{1,3})",$HTTP_USER_AGENT,$regs) ){$browser = "OmniWeb $regs[2]";} 
	else if( eregi("(webtv/)([0-9]{1,2}.[0-9]{1,3})",$HTTP_USER_AGENT,$regs) ){$browser = "WebTV $regs[2]";}
	else if( eregi("(lynx)/([0-9]{1,2}.[0-9]{1,2}.[0-9]{1,2})",$HTTP_USER_AGENT,$regs) ){$browser = "Lynx $regs[2]";}
	else if( eregi("(links) \(([0-9]{1,2}.[0-9]{1,3})",$HTTP_USER_AGENT,$regs) ){$browser = "Links $regs[2]";}
	else if( eregi("(msie) ([0-9]{1,2}.[0-9]{1,3})",$HTTP_USER_AGENT,$regs) ){$browser = "MSIE $regs[2]";}
	else if( eregi("(netscape6)/(6.[0-9]{1,3})",$HTTP_USER_AGENT,$regs) ){$browser = "Netscape $regs[2]";}
	else if( eregi("mozilla/5",$HTTP_USER_AGENT) ){$browser = "Netscape";}
	else if( eregi("(mozilla)/([0-9]{1,2}.[0-9]{1,3})",$HTTP_USER_AGENT,$regs) ){$browser = "Netscape $regs[2]";}
	else if( eregi("w3m",$HTTP_USER_AGENT) ){$browser = "w3m";}
	else{$browser = "?";}
	in_table("st_browser","browser",$browser);
	// Robots #############################################
/*	if($browser=="?")
	{
		include("_robots.inc.php");
		$robots = get_bot();
		if($robots!="") in_table("st_robots","robots",$robots);
	}*/
	// system #############################################
	if(eregi("linux",$HTTP_USER_AGENT)){$system = "Linux";}
	else if(eregi("win32",$HTTP_USER_AGENT)){$system = "Windows";}
	else if(eregi("Win 9x 4.90",$HTTP_USER_AGENT)){$system = "Windows Me";}
    	else if(eregi("windows 2000",$HTTP_USER_AGENT) || eregi("(windows nt)( ){0,1}(5.0)",$HTTP_USER_AGENT) ){$system = "Windows 2000";}
    	else if(eregi("(windows nt)( ){0,1}(5.1)",$HTTP_USER_AGENT) ){$system = "Windows XP";}
	else if( (eregi("(win)([0-9]{2})",$HTTP_USER_AGENT,$regs)) || (eregi("(windows) ([0-9]{2})",$HTTP_USER_AGENT,$regs)) ){$system = "Windows $regs[2]";}
	else if(eregi("(winnt)([0-9]{1,2}.[0-9]{1,2}){0,1}",$HTTP_USER_AGENT,$regs) ){$system = "Windows NT $regs[2]";}
	else if(eregi("(windows nt)( ){0,1}([0-9]{1,2}.[0-9]{1,2}){0,1}",$HTTP_USER_AGENT,$regs) ){$system = "Windows NT $regs[3]";}
	else if(eregi("mac",$HTTP_USER_AGENT)){$system = "Macintosh";}
	else if(eregi("(sunos) ([0-9]{1,2}.[0-9]{1,2}){0,1}",$HTTP_USER_AGENT,$regs)){$system = "SunOS $regs[2]";}
	else if(eregi("(beos) r([0-9]{1,2}.[0-9]{1,2}){0,1}",$HTTP_USER_AGENT,$regs)){$system = "BeOS $regs[2]";}
	else if(eregi("freebsd",$HTTP_USER_AGENT)){$system = "FreeBSD";}
	else if(eregi("openbsd",$HTTP_USER_AGENT)){$system = "OpenBSD";}
	else if(eregi("irix",$HTTP_USER_AGENT)){$system = "IRIX";}
	else if(eregi("os/2",$HTTP_USER_AGENT)){$system = "OS/2";}
	else if(eregi("plan9",$HTTP_USER_AGENT)){$system = "Plan9";}
	else if(eregi("unix",$HTTP_USER_AGENT) || eregi("hp-ux",$HTTP_USER_AGENT) || eregi("X11",$HTTP_USER_AGENT) ){$system = "Unix";}
	else if(eregi("osf",$HTTP_USER_AGENT)){$system = "OSF";}
	else{$system = "?";}
	in_table("st_system","system",$system);
	// prüfen, ob referer mit oder ohne http:// und gewinnen der tld
	if($refer)
	{
		$referer = explode ("/", $refer);
		if($referer[0] == "http:")
		{
			if(strpos ($referer[2], ".") == false || $referer[2]=="127.0.0.1")
			{
				$linkit = 0;
			}else
			{
				$dom1 = strstr ($referer[2], "www.");
				if($dom1==false) $domainname = $referer[2];
				else $domainname = substr ($dom1, 4);
				$linkit = 1;
			}
		}else if($referer[0] == "file:" || $referer[0] == "news:")
		{
			$linkit = 0;
		}else
		{
			$refer1 = "http://$refer";
			$refer = $refer1;
			if(strpos ($referer[0], ".") == false || $referer[0]=="127.0.0.1")
			{
				$linkit = 0;
			}else
			{
				$dom1 = strstr ($referer[0], 'www.');
				if($dom1==false) $domainname = $referer[0];
				else $domainname = substr ($dom1, 4);
				$linkit = 1;
			}
		}
		if($linkit=="1")
		{
			$domainname1 = explode (".", $domainname);
			$anzahl1 = count($domainname1) - 1;
			$domainname = $domainname1[$anzahl1-1].".".$domainname1[$anzahl1];
			// Tabelle referer ########################
			in_table("st_referer","referer",$domainname);
		}
	}else $refer = "-";
	// Tabelle $country #######################
	if($host != "?" && $host!="localhost" && $host!="127.0.0.1")
	{
		$hostname = explode (".", $host);
		$anzahl = count($hostname) - 1;
		$land = $hostname[$anzahl];
		$land = strtolower($land);
		if($land)
		{
			$SQL5 = mysql_query("SELECT * FROM st_tld where tld='$land' AND ID='$id'");
			if (mysql_fetch_row($SQL5)) mysql_query("UPDATE st_tld SET hits = hits + 1 WHERE tld='$land' AND ID='$id'");
			else
			{
				$SQL8 = mysql_query("SELECT kontinent FROM st_listdomains WHERE domain='$land'");
				$KONTINENT = mysql_fetch_array($SQL8);
				if(mysql_num_rows($SQL8)=="0") $KONTINENT[kontinent]="UNB";
				mysql_query("INSERT INTO st_tld VALUES('$id','$land','$KONTINENT[kontinent]','1')");
			}
		}
		$host1 = $hostname[$anzahl-1].".".$hostname[$anzahl];
		if($counthost[$id]=="on") in_table("st_host","host",$host1);
	}
	// Tabelle last ###########################
	$SQL6 = mysql_query("SELECT count(*) FROM st_last WHERE ID='$id'");
	$hits = mysql_fetch_row($SQL6);
	if($hits[0] >= $numlast[$id])
	{
		$anz = $hits[0] - $numlast[$id];
		$t = 0;
		$SQL7 = mysql_query("SELECT time,IP FROM st_last WHERE ID='$id' ORDER BY time ASC");
		while ($messages=mysql_fetch_row($SQL7)) 
		{
			mysql_query("DELETE FROM st_last WHERE time='$messages[0]' AND IP='$messages[1]' AND ID='$id'");
			if($t == $anz) break;
			$t++;
		}
	}
	mysql_query("INSERT INTO st_last VALUES('$id','$time','$ipaddr','$host','$lang','$browser','$system','$refer','$linkit')");
	// suchengine
	include("_search.inc.php");
	$sdomain = explode (".", $domainname);
	$sdomain = $sdomain[0];
	if($suche[$sdomain])
	{
		if(eregi("&$suche[$sdomain]",$refer)) $ssuche = explode ("&$suche[$sdomain]", $refer);
		else if(eregi("\?$suche[$sdomain]",$refer)) $ssuche = explode ("?$suche[$sdomain]", $refer);
		$ssuche = explode ("&", $ssuche[1]);
		$ssuche = $ssuche[0];
		$ssuche = strtolower($ssuche);
		$ssuche = urldecode ($ssuche);
		in_table("st_search","search",$domainname);
		if($ssuche!="")in_table("st_query","query",$ssuche);
	}
	// resolution ##############################################
	if($sw > "0") in_table("st_resolution","resolution",$sw);
	// colors
	if($sc > "0") in_table("st_colors","colors",$sc);
}
mysql_close ($mysql);
?>