--- inc/tracker.php 2001/09/19 12:23:57 1.1 +++ inc/tracker.php 2001/09/25 15:38:04 1.2 @@ -5,15 +5,19 @@ $tgt = $HTTP_SERVER_VARS["SERVER_NAME"]."/".$HTTP_SERVER_VARS["REQUEST_URI"]; $idx = strpos($tgt, "?"); if (!($idx === false)) $tgt = substr($tgt, 0, $idx); - include("inc/conn.php"); - $sth = $dbh->prepare("SELECT count FROM tracker WHERE (referer = '$ref') AND (target = '$tgt')"); - $row = ""; - if ($sth) { - if ($sth->execute()) $row = $sth->fetchrow_array(); - $sth->finish(); + $ref = ereg_replace('index\.([A-Za-z0-9]+)$', '', $ref); + $tgt = ereg_replace('index\.([A-Za-z0-9]+)$', '', $tgt); + if ($ref && $tgt) { + include("inc/conn.php"); + $sth = $dbh->prepare("SELECT count FROM tracker WHERE (referer = '$ref') AND (target = '$tgt')"); + $row = ""; + if ($sth) { + 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)"; + $dbh->dbh_do($sql); + $dbh->disconnect(); } - 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)"; - $dbh->dbh_do($sql); - $dbh->disconnect(); ?>