All pastes #734112 Raw Edit

Jemand

public php v1 · immutable
·published 2007-10-12 12:05 UTC
rendered paste body
function site_statistic () {	if (!array_key_exists('ilchCMSstati',$_SESSION)) {		$_SESSION['ilchCMSstati'] = 'geloggt';	  $d = date('j');		$m = date('n');		$y = date('Y');		$ip = getip();		$ergResul = db_result(db_query("SELECT COUNT(ip) FROM prefix_stats WHERE ip = '".$ip."' AND `day` = ".$d." AND mon = ".$m." AND yar = ".$y ),0);		debug ( $ergResul.'#statistic res' );		if ( $ergResul == 0 ) {		  $os = site_statistic_get_os($_SERVER['HTTP_USER_AGENT']);		  $br = site_statistic_get_browser($_SERVER['HTTP_USER_AGENT']);		  $wt = date('w');		  $st = date('G');		  $ur = ( isset ($_SERVER['HTTP_REFERER']) ? site_statistic_get_referer($_SERVER['HTTP_REFERER']) : '' );		  db_query("INSERT INTO prefix_stats (wtag,stunde,`day`,mon,yar,os,browser,ip,ref)			VALUES(".$wt.",".$st.",".$d.",".$m.",".$y.",'".$os."','".$br."','".$ip."','".$ur."')");				  $dc = ( strlen ($d) == 1 ? '0'.$d : $d );			$mc = ( strlen ($m) == 1 ? '0'.$m : $m );		  $cdate = $y.'-'.$mc.'-'.$dc;			$query = "SELECT COUNT(date) FROM `prefix_counter` WHERE `date` = '".$cdate."'";		  if ( db_result(db_query($query),0) == 0 ) {		    db_query('INSERT INTO `prefix_counter` VALUES ( "'.$cdate.'" , "1" ) ' );		  } else {		    db_query('UPDATE `prefix_counter` SET `count` = `count` +1 WHERE `date` = "'.$cdate.'"');		  }	  }  }}