Execute("SELECT id,ip,date FROM #__simple_stats WHERE id>1 AND ip = '".$_SERVER['REMOTE_ADDR']."'"); if(!$rs_c || $rs_c->RecordCount()==0) { //fill in the details $u_type=isset($_SESSION['uid'])?$_SESSION['uid']:0; $query = "INSERT INTO #__simple_stats (ip,date,count,uid) VALUES ('".$_SERVER['REMOTE_ADDR']."','$time',0,$u_type)"; $conn->Execute($query); }else if($rs_c && $rsa=$rs_c->GetArray()) { if($rsa[0]['date'] < $time - 60 * 5 ) { $query = "UPDATE #__simple_stats SET date = '$time' WHERE id = ".$rsa[0]['id']; $conn->Execute($query); } } //Total hits $row=$conn->GetRow("SELECT date,count FROM #__simple_stats WHERE id = 1"); //Unique hits today if( date("z",$row['date']) != date("z",$time) ){ $rs_ct=$conn->Execute("SELECT id FROM #__simple_stats"); $this->today_hits=$rs_ct->RecordCount()-1; $conn->Execute("UPDATE #__simple_stats SET date='$time',count=".($row['count']+$rs_ct->RecordCount()-1)." WHERE id = 1 "); $conn->Execute("DELETE FROM #__simple_stats WHERE id > 1 "); } } } $stats = new Stats(); ?>