1 Royal Way
Kansas City, MO 64129
Kansas City Royals";
$strUrl = $_SERVER["REQUEST_URI"];
$arrUrl = explode("/", $strUrl);
$strUrl = $arrUrl[count($arrUrl)-1];
$thetime = date("Y") . date("m") . date("d") . date("H") . date("i") . date("s");
if ((strrpos($strUrl, ".js")===false) && (strrpos($strUrl, ".txt")===false) && (strrpos($strUrl, ".html")===false) && (strrpos($strUrl, ".png")===false) && (strrpos($strUrl, ".jpg")===false) && (strrpos($strUrl, ".php")===false) && (strrpos($strUrl, ".css")===false)) {
//
$updateSQL = "UPDATE page_hits SET hits=hits+1 WHERE ebrochure='$ebrochure'";
$updateHits = mysql_query($updateSQL, $channel1media) or die(mysql_error());
//
/*
$insertSQL = sprintf("INSERT INTO " . $ebrochure . "_tracking (id, `time`, `from`, `url`) VALUES (%s, %s, %s, %s)",
GetSQLValueString($_POST['id'], "int"),
GetSQLValueString($thetime, "text"),
GetSQLValueString($_SERVER['HTTP_REFERER'], "text"),
GetSQLValueString($strUrl, "text"));
$Result1 = mysql_query($insertSQL, $channel1media) or die(mysql_error());
*/
if (strlen($strUrl)>5) {
$arrUrl = explode("?", $strUrl);
$strUrl = $arrUrl[0];
$arrUrl = explode("&", $strUrl);
$strUrl = $arrUrl[0];
$query_eb = "SELECT * FROM " . $ebrochure . "_accounts WHERE purl='$strUrl'";
$eb = mysql_query($query_eb, $channel1media) or die(mysql_error());
$row_eb = mysql_fetch_assoc($eb);
$totalRows_eb = mysql_num_rows($eb);
if ($totalRows_eb > 0) {
$firstname = $row_eb["FirstName"];
$lastname = $row_eb["LastName"];
$isRealPurl = true;
if (strlen($row_eb["Rep"])>1) {
$rep = "
" . rawurldecode($row_eb["Rep"]);
}
$updateSQL = "UPDATE " . $ebrochure . "_accounts SET hits=hits+1 , `lasttime`='$thetime' WHERE `purl`='$strUrl'";
$Result1 = mysql_query($updateSQL, $channel1media) or die(mysql_error());
} else {
$aname = explode(".", $strUrl);
$firstname = str_replace("_", " ", $aname[0]);
if (count($aname)>1) {
$lastname = str_replace("_", " ", $aname[1]);
} else {
$lastname = "";
}
}
}
//
}
?>