"99999") exit; $abspath = dirname(__FILE__); require "$abspath/config.php"; if(!isset($refer)) $refer = $_SERVER['HTTP_REFERER']; $mysql = mysql_pconnect ("$mysqlhost", "$mysqllogin", "$mysqlpassword"); if($mysql != false) $mydb = mysql_select_db ("$mysqldb"); require "_functions.inc.php"; // Only execute if the following conditions are met: // - must be connected to database // - "reload" not disabled in config.php // - no IP-blocks in config.php // - no Server-blocks in config.php if($mydb != false && $server_error != 1 && $ip_error != 1 && $ipblock_error != 1){ $host = gethostbyaddr($ipaddr); if($host == $ipaddr) $host = "?"; $lang1 = $_SERVER['HTTP_ACCEPT_LANGUAGE']; $lang1 = str_replace (",", "-", $lang1); $lang2 = explode (";", $lang1); $lang = $lang2[0]; if(!$lang) $lang = "?"; // Delete last Month ############################ $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'"); // Table 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'"); // Table wday ###################################### in_table("st_wday","wday",$wday); // Table hour ###################################### in_table("st_hour","hour",$hour1); // Table 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 Day & Top Month ############################### $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}",$_SERVER['HTTP_USER_AGENT'],$regs) || eregi("(opera/)([0-9]{1,2}.[0-9]{1,3}){0,1}",$_SERVER['HTTP_USER_AGENT'],$regs)){$browser = "Opera $regs[2]";} else if( eregi("(konqueror)/([0-9]{1,2}.[0-9]{1,3})",$_SERVER['HTTP_USER_AGENT'],$regs) ){$browser = "Konqueror $regs[2]";} else if( eregi("(omniweb/)([0-9]{1,2}.[0-9]{1,3})",$_SERVER['HTTP_USER_AGENT'],$regs) ){$browser = "OmniWeb $regs[2]";} else if( eregi("(webtv/)([0-9]{1,2}.[0-9]{1,3})",$_SERVER['HTTP_USER_AGENT'],$regs) ){$browser = "WebTV $regs[2]";} else if( eregi("(lynx)/([0-9]{1,2}.[0-9]{1,2}.[0-9]{1,2})",$_SERVER['HTTP_USER_AGENT'],$regs) ){$browser = "Lynx $regs[2]";} else if( eregi("(links) \(([0-9]{1,2}.[0-9]{1,3})",$_SERVER['HTTP_USER_AGENT'],$regs) ){$browser = "Links $regs[2]";} else if( eregi("(msie) ([0-9]{1,2}.[0-9]{1,3})",$_SERVER['HTTP_USER_AGENT'],$regs) ){$browser = "MSIE $regs[2]";} else if( eregi("(netscape6)/(6.[0-9]{1,3})",$_SERVER['HTTP_USER_AGENT'],$regs) ){$browser = "Netscape $regs[2]";} else if( eregi("mozilla/5",$_SERVER['HTTP_USER_AGENT']) ){$browser = "Netscape";} else if( eregi("(mozilla)/([0-9]{1,2}.[0-9]{1,3})",$_SERVER['HTTP_USER_AGENT'],$regs) ){$browser = "Netscape $regs[2]";} else if( eregi("w3m",$_SERVER['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",$_SERVER['HTTP_USER_AGENT'])){$system = "Linux";} else if(eregi("win32",$_SERVER['HTTP_USER_AGENT'])){$system = "Windows";} else if(eregi("Win 9x 4.90",$_SERVER['HTTP_USER_AGENT'])){$system = "Windows Me";} else if(eregi("windows 2000",$_SERVER['HTTP_USER_AGENT']) || eregi("(windows nt)( ){0,1}(5.0)",$_SERVER['HTTP_USER_AGENT']) ){$system = "Windows 2000";} else if(eregi("(windows nt)( ){0,1}(5.1)",$_SERVER['HTTP_USER_AGENT']) ){$system = "Windows XP";} else if( (eregi("(win)([0-9]{2})",$_SERVER['HTTP_USER_AGENT'],$regs)) || (eregi("(windows) ([0-9]{2})",$_SERVER['HTTP_USER_AGENT'],$regs)) ){$system = "Windows $regs[2]";} else if(eregi("(winnt)([0-9]{1,2}.[0-9]{1,2}){0,1}",$_SERVER['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}",$_SERVER['HTTP_USER_AGENT'],$regs) ){$system = "Windows NT $regs[3]";} else if(eregi("mac",$_SERVER['HTTP_USER_AGENT'])){$system = "Macintosh";} else if(eregi("(sunos) ([0-9]{1,2}.[0-9]{1,2}){0,1}",$_SERVER['HTTP_USER_AGENT'],$regs)){$system = "SunOS $regs[2]";} else if(eregi("(beos) r([0-9]{1,2}.[0-9]{1,2}){0,1}",$_SERVER['HTTP_USER_AGENT'],$regs)){$system = "BeOS $regs[2]";} else if(eregi("freebsd",$_SERVER['HTTP_USER_AGENT'])){$system = "FreeBSD";} else if(eregi("openbsd",$_SERVER['HTTP_USER_AGENT'])){$system = "OpenBSD";} else if(eregi("irix",$_SERVER['HTTP_USER_AGENT'])){$system = "IRIX";} else if(eregi("os/2",$_SERVER['HTTP_USER_AGENT'])){$system = "OS/2";} else if(eregi("plan9",$_SERVER['HTTP_USER_AGENT'])){$system = "Plan9";} else if(eregi("unix",$_SERVER['HTTP_USER_AGENT']) || eregi("hp-ux",$_SERVER['HTTP_USER_AGENT']) || eregi("X11",$_SERVER['HTTP_USER_AGENT']) ){$system = "Unix";} else if(eregi("osf",$_SERVER['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"){ /* disabled for better referrer specifier $domainname1 = explode (".", $domainname); $anzahl1 = count($domainname1) - 1; $domainname = $domainname1[$anzahl1-1].".".$domainname1[$anzahl1]; */ // Table referer ######################## in_table("st_referer","referer",$domainname); } } else $refer = "-"; // Table $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); } // Table 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')"); // Searchengine include("_search.inc.php"); $sdomain = explode (".", $domainname); $sdomain = $sdomain[0]; if($searchengines[$sdomain]){ if(eregi("&$searchengines[$sdomain]",$refer)) $SEsearch = explode ("&$searchengines[$sdomain]", $refer); else if(eregi("\?$searchengines[$sdomain]",$refer)) $SEsearch = explode ("?$searchengines[$sdomain]", $refer); $SEsearch = explode ("&", $SEsearch[1]); $SEsearch = $SEsearch[0]; $SEsearch = strtolower($SEsearch); $SEsearch = urldecode ($SEsearch); in_table("st_search","search",$domainname); if($SEsearch!="")in_table("st_query","query",$SEsearch); } // resolution ############################################## if( !is_numeric( $sw ) ) $sw = 0; if($sw > "0") in_table($id,"st_resolution","resolution",$sw); // colors if( !is_numeric( $sc ) ) $sc = 0; if($sc > "0") in_table($id,"st_colors","colors",$sc); } mysql_close ($mysql); ?>