2 |
$ref = $HTTP_SERVER_VARS["HTTP_REFERER"]; |
$ref = $HTTP_SERVER_VARS["HTTP_REFERER"]; |
3 |
$idx = strpos($ref, "?"); |
$idx = strpos($ref, "?"); |
4 |
if (!($idx === false)) $ref = substr($ref, 0, $idx); |
if (!($idx === false)) $ref = substr($ref, 0, $idx); |
5 |
|
$idx = strpos($ref, "#"); |
6 |
|
if (!($idx === false)) $ref = substr($ref, 0, $idx); |
7 |
$tgt = $HTTP_SERVER_VARS["SERVER_NAME"]."/".$HTTP_SERVER_VARS["REQUEST_URI"]; |
$tgt = $HTTP_SERVER_VARS["SERVER_NAME"]."/".$HTTP_SERVER_VARS["REQUEST_URI"]; |
8 |
$idx = strpos($tgt, "?"); |
$idx = strpos($tgt, "?"); |
9 |
if (!($idx === false)) $tgt = substr($tgt, 0, $idx); |
if (!($idx === false)) $tgt = substr($tgt, 0, $idx); |
10 |
|
$idx = strpos($tgt, "#"); |
11 |
|
if (!($idx === false)) $tgt = substr($tgt, 0, $idx); |
12 |
$ref = ereg_replace('index\.([A-Za-z0-9]+)$', '', $ref); |
$ref = ereg_replace('index\.([A-Za-z0-9]+)$', '', $ref); |
13 |
$tgt = ereg_replace('index\.([A-Za-z0-9]+)$', '', $tgt); |
$tgt = ereg_replace('index\.([A-Za-z0-9]+)$', '', $tgt); |
14 |
if ($ref && $tgt) { |
if ($ref && $tgt) { |
19 |
if ($sth->execute()) $row = $sth->fetchrow_array(); |
if ($sth->execute()) $row = $sth->fetchrow_array(); |
20 |
$sth->finish(); |
$sth->finish(); |
21 |
} |
} |
22 |
if ($row) $sql = "UPDATE tracker SET count = count + 1 WHERE (referer = '$ref') AND (target = '$tgt')"; |
if ($row) $sql = "UPDATE tracker SET count = count + 1, t_change = NOW() WHERE (referer = '$ref') AND (target = '$tgt')"; |
23 |
else $sql = "INSERT INTO tracker (referer, target, count) VALUES ('$ref', '$tgt', 1)"; |
else $sql = "INSERT INTO tracker (referer, target, count, time, t_change) VALUES ('$ref', '$tgt', 1, NOW(), NOW())"; |
24 |
$dbh->dbh_do($sql); |
$dbh->dbh_do($sql); |
25 |
$dbh->disconnect(); |
$dbh->disconnect(); |
26 |
} |
} |