"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); ?>