--- inc/tracker.php 2001/09/25 15:38:04 1.2 +++ inc/tracker.php 2001/09/28 23:34:37 1.3 @@ -2,9 +2,13 @@ $ref = $HTTP_SERVER_VARS["HTTP_REFERER"]; $idx = strpos($ref, "?"); if (!($idx === false)) $ref = substr($ref, 0, $idx); + $idx = strpos($ref, "#"); + if (!($idx === false)) $ref = substr($ref, 0, $idx); $tgt = $HTTP_SERVER_VARS["SERVER_NAME"]."/".$HTTP_SERVER_VARS["REQUEST_URI"]; $idx = strpos($tgt, "?"); if (!($idx === false)) $tgt = substr($tgt, 0, $idx); + $idx = strpos($tgt, "#"); + if (!($idx === false)) $tgt = substr($tgt, 0, $idx); $ref = ereg_replace('index\.([A-Za-z0-9]+)$', '', $ref); $tgt = ereg_replace('index\.([A-Za-z0-9]+)$', '', $tgt); if ($ref && $tgt) { @@ -15,8 +19,8 @@ if ($sth->execute()) $row = $sth->fetchrow_array(); $sth->finish(); } - if ($row) $sql = "UPDATE tracker SET count = count + 1 WHERE (referer = '$ref') AND (target = '$tgt')"; - else $sql = "INSERT INTO tracker (referer, target, count) VALUES ('$ref', '$tgt', 1)"; + if ($row) $sql = "UPDATE tracker SET count = count + 1, t_change = NOW() WHERE (referer = '$ref') AND (target = '$tgt')"; + else $sql = "INSERT INTO tracker (referer, target, count, time, t_change) VALUES ('$ref', '$tgt', 1, NOW(), NOW())"; $dbh->dbh_do($sql); $dbh->disconnect(); }