<?php
$stat["remote_ip"] = $_SERVER['REMOTE_ADDR'];
$stat["referer"] = isset( $_SERVER["HTTP_REFERER"] ) ? $_SERVER["HTTP_REFERER"] : "";
$url = parse_url( $stat["referer"] );
$stat["keywords"] = _determine_searchterms($url);
$stat["url"] = $_SERVER["SERVER_NAME"].$_SERVER["REQUEST_URI"] ;
$stat["time"] = mktime(date("H"),0,0,date("m"),date("d"),date("Y"));
if($_SERVER["HTTP_USER_AGENT"]){
$zhizhu = is_zhizhu($_SERVER["HTTP_USER_AGENT"],$stat['referer'],$stat['remote_ip']);
}
if($stat["referer"]){ //!$zhizhu
//file_put_contents('pv.txt',$_SERVER["HTTP_USER_AGENT"].$stat["referer"].$stat["url"].$stat["remote_ip"].$str.date('Y-m-d H:i:s',time())."\n",FILE_APPEND );
$sql = "select id from ".T."tongji_ip where ip = '".$stat['remote_ip']."' and time = '".$stat['time']."'";
$data = one_array($sql);
if($data['id'] != ''){
$sql = "select id from ".T."tongji_pv where url = '".$stat['url']."' and time = '".$stat['time']."'";
$mdata = one_array($sql);
if($mdata['id'] != ''){
$sql = "update ".T."tongji_pv set num = num+1 where id = '".$mdata['id']."' and time = '".$stat['time']."'";
$query->query($sql);
}else{
$sql = "insert into ".T."tongji_pv (id,url,num,time) values ('','".$stat['url']."','1','".$stat['time']."')";
$query->query($sql);
}
}else{
$sqlip = "insert into ".T."tongji_ip (id,ip,time) values ('','".$stat['remote_ip']."','".$stat['time']."')";
$query->query($sqlip);
//$sql = "select id from ".T."tongji_pv where url = '".$stat['url']."' and time = '".$stat['time']."'";
//$mdata = one_array($sql);
//if($mdata['id'] != ''){
//$sql = "update ".T."tongji_pv set num = num+1 where id = '".$mdata['id']."' and time = '".$stat['time']."'";
//$query->query($sql);
//}else{
$sql = "insert into ".T."tongji_pv (id,url,num,time) values ('','".$stat['url']."','1','".$stat['time']."')";
$query->query($sql);
//}
}
if($stat['keywords'] != ''){
$key = one_array("select id from ".T."tongji_keywords where keywords = '".$stat['keywords']."' and time = '".$stat['time']."'");
if(strpos($url['host'],'baidu')){
if($key['id'] != ''){
$sql = "update ".T."tongji_keywords set bnum = bnum+1,breferer = '".$stat['referer']."' where keywords = '".$stat['keywords']."' and time = '".$stat['time']."'";
$query->query($sql);
}else{
$sql = "insert into ".T."tongji_keywords (id,keywords,bnum,time,breferer) values ('','".$stat['keywords']."','1','".$stat['time']."','".$stat["referer"]."')";
$query->query($sql);
}
}elseif(strpos($url['host'],'google')){
$stat['keywords'] = iconv("UTF-8","GBK",$stat['keywords']);
if($key['id'] != ''){
$sql = "update ".T."tongji_keywords set gnum = gnum+1,greferer = '".$stat['referer']."' where keywords = '".$stat['keywords']."' and time = '".$stat['time']."'";
$query->query($sql);
}else{
if(strpos($url['query'],'utf-8')){
$stat['keywords'] = iconv("UTF-8","GBK",$stat['keywords']);
}
$sql = "insert into ".T."tongji_keywords (id,keywords,gnum,time,greferer) values ('','".$stat['keywords']."','1','".$stat['time']."','".$stat["referer"]."')";
$query->query($sql);
}
}else{
if($key['id'] != ''){
$sql = "update ".T."tongji_keywords set onum = onum+1,greferer = '".$stat['referer']."' where keywords = '".$stat['keywords']."' and time = '".$stat['time']."'";
$query->query($sql);
}else{
$sql = "insert into ".T."tongji_keywords (id,keywords,onum,time,oreferer) values ('','".$stat['keywords']."','1','".$stat['time']."','".$stat["referer"]."')";
$query->query($sql);
}
}
}
}
function is_zhizhu($agent,$laiyuan,$ip){
$zhizhu = array('baidu','google','bot','spider','yahoo','qq','icafe','alexa','flash','wget','www','modified','nokia','andex','seo','ava','dignet');
foreach ( $zhizhu as $val ) {
if(strpos(strtolower($agent),$val)){
$str = TRUE;
}
}
$spamip = array('222.77.187.107','219.239.88.56','124.115.4.213','77.186.187.124','123.20.154.228','121.11.82.166','l77.186.168.40','59.172.218.74','123.11.50.137','139.82.71.197','139.82.71.197','115.238.55.88','221.11.66.83');
foreach( $spamip as $val ){
if($val == $ip){
$str = TRUE;
}
}
if(strpos('%%'.$ip,'124.115.1')){
$str = TRUE;
}
//file_put_contents('bot.txt',$agent.$ip.date('Y-m-d H:i:s',time()).$str."\n",FILE_APPEND );
return $str;
}
function get_remote_ip()
{
if (!empty($_SERVER["HTTP_CDN_SRC_IP"]) )
{
if (!empty($_SERVER["HTTP_CLIENT_IP"]) )
{
$ip = $_SERVER["HTTP_CLIENT_IP"];
}
else
{
$ip = $_SERVER["REMOTE_ADDR"];
}
$ip = $_SERVER["HTTP_CDN_SRC_IP"];
return $ip;
}
else
{
if ( !empty($_SERVER["HTTP_CLIENT_IP"]) )
{
$ip = $_SERVER["HTTP_CLIENT_IP"];
}
else
{
$ip = $_SERVER["REMOTE_ADDR"];
}
return $ip;
}
}
function _determine_searchterms( $_url ) { //获取url里的关键词
if ( !is_array( $_url ) ) {
$_url = parse_url( $_url );
}
$searchterms = "";
if ( isset( $_url["host"] ) && isset( $_url["query"] ) ) {
$sniffs = array(
array( "/google\./i", "q" ),
array( "/.*/", "wd" ),
array( "/.*/", "word" ),
array( "/.*/", "query" ),
);
foreach ( $sniffs as $sniff ) {
if ( preg_match( $sniff[0], $_url["host"] ) ) {
parse_str( $_url["query"], $q );
if ( isset( $q[ $sniff[1] ] ) ) {
$searchterms = trim( stripslashes(( $q[ $sniff[1] ] ) ) );
break;
}
}
}
}
return $searchterms;
}
?>
