$visit_ip = mysql_real_escape_string($_SERVER['REMOTE_ADDR']); $visit_date = date("Y-m-d"); $visit_time = date("H:i:s"); $visit_agent = mysql_real_escape_string($_SERVER['HTTP_USER_AGENT']); if($_SESSION['ip_session']){ $visit_session = "N"; } else { $qry_s = "insert visit_sum_session (visit_count,visit_date) values (1,'$visit_date')"; $rst_s = mysql_query($qry_s,$db); if(!$rst_s){ $qry_s1 = "update visit_sum_session set visit_count=visit_count+1 where visit_date = '$visit_date'"; $rst_s1 = mysql_query($qry_s1,$db); } $visit_session = "Y"; $_SESSION['ip_session'] = $visit_ip; } $qry_s2 = "select visit_id from visit where visit_date='$visit_date' and visit_ip='$visit_ip'"; $rst_s2 = mysql_query($qry_s2,$db); $row_s2 = mysql_fetch_row($rst_s2); if(!$row_s2[0]){ $qry_s = "insert visit_sum_ip (visit_count,visit_date) values (1,'$visit_date')"; $rst_s = mysql_query($qry_s,$db); if(!$rst_s){ $qry_s1 = "update visit_sum_ip set visit_count=visit_count+1 where visit_date = '$visit_date'"; $rst_s1 = mysql_query($qry_s1,$db); } } $qry_v = "insert into visit(visit_ip,visit_date,visit_time,visit_agent,visit_session) values('$visit_ip','$visit_date','$visit_time','$visit_agent','$visit_session')"; $rst_v = mysql_query($qry_v,$db); if($rst_v){ $qry_s = "insert visit_sum (visit_count,visit_date) values (1,'$visit_date')"; $rst_s = mysql_query($qry_s,$db); if(!$rst_s){ $qry_s1 = "update visit_sum set visit_count=visit_count+1 where visit_date = '$visit_date'"; $rst_s1 = mysql_query($qry_s1,$db); } } ?>