);" onmouseout="RemoveLight('CntClick',<?php
echo $Row['Position'];
?>
);">
<p class=ReportColumn><B>
<a href="<?php
echo getURL("paid_constructor", "CurrentId[{$GroupBy}]=" . $Row['Obj']->ID . $Get, "report");
?>
">
<span title="<?php
echo htmlspecialchars(urldecode(stripslashes($Row['Name'])));
?>
">
<?php
if ($GroupBy == "CampRef") {
echo RefCut(htmlspecialchars(urldecode(stripslashes($Row['Name'])), 40));
} else {
echo htmlspecialchars(urldecode(stripslashes($Row['Name'])));
}
?>
</span></a></B>
<?php
if ($GroupBy == "CampRef") {
?>
[<a href="<?php
echo htmlspecialchars($Row['Name']);
?>
" target=_blank>^</a>]
<?php
}
$Query = "\n\t\tSELECT \n\t\tS_LOG.ID,\n\t\tDATE_ADD(S_LOG.STAMP, INTERVAL '" . $nsUser->TZ . "' HOUR) AS STAMP,\n\t\tS_LOG.VISITOR_ID,\n\t\tS_LOG.SITE_ID,\n\t\tI.IP AS LAST_IP,\n\t\tS.HOST AS SITE,\n\t\tK.KEYWORD,\n\t\tH.HOST AS REF_DOMAIN,\n\t\tSP.PATH AS LPAGE,\n\t\tQ.QUERY_STRING,\n\t\tSH.HOST AS SITE_HOST,\n\t\tCV.NAME AS VISITOR_NAME\n\n\t\tFROM " . PFX . "_tracker_" . $CpId . "_stat_log S_LOG\n\n\t\tINNER JOIN " . PFX . "_tracker_referer_set RS\n\t\t\tON RS.ID=S_LOG.REFERER_SET\n\t\tINNER JOIN " . PFX . "_tracker_host H\n\t\t\tON H.ID=RS.HOST_ID\n\t\tINNER JOIN " . PFX . "_tracker_site S\n\t\t\tON S.ID=S_LOG.SITE_ID\n\t\tINNER JOIN " . PFX . "_tracker_visitor V\n\t\t\tON V.ID=S_LOG.VISITOR_ID\n\t\tINNER JOIN " . PFX . "_tracker_keyword K\n\t\t\tON K.ID=RS.NATURAL_KEY\n\t\tINNER JOIN " . PFX . "_tracker_site_page SP\n\t\t\tON SP.ID=S_LOG.PAGE_ID\n\t\tLEFT JOIN " . PFX . "_tracker_client_visitor CV \n\t\t\tON CV.VISITOR_ID=S_LOG.VISITOR_ID AND CV.COMPANY_ID={$CpId}\n\t\tLEFT JOIN " . PFX . "_tracker_ip I\n\t\t\tON I.ID=S_LOG.IP_ID\n\t\tLEFT JOIN " . PFX . "_tracker_query Q\n\t\t\tON Q.ID=S_LOG.QUERY_ID\n\t\tLEFT JOIN " . PFX . "_tracker_site_host SH\n\t\t\tON SH.ID=S_LOG.SITE_HOST_ID\n\t\t{$WhereStr}\n\t\t{$FilterStr}\n\t\tORDER BY S_LOG.STAMP {$UserOrder}\t\t\n\t\tLIMIT " . $Pages->PageStart . ", " . $Pages->Limit . "\n\t";
$Sql = new Query($Query, "ARR");
while ($Row = $Sql->Row()) {
if (!$SiteId) {
$Row['LPAGE'] = $Row['SITE_HOST'] . $Row['LPAGE'];
}
$Row['LAST_IP'] = htmlspecialchars($Row['LAST_IP']);
$Row['VISITOR_NAME'] = htmlspecialchars(stripslashes($Row['VISITOR_NAME']));
if ($Row['VISITOR_NAME']) {
$Row['LAST_IP'] = $Row['VISITOR_NAME'] . " (" . $Row['LAST_IP'] . ")";
}
$Row['KEYWORD'] = htmlspecialchars($Row['KEYWORD']);
if ($Row['QUERY_STRING']) {
$Row['LPAGE'] = $Row['LPAGE'] . "?" . $Row['QUERY_STRING'];
}
$Row['PATH1'] = RefCut(htmlspecialchars($Row['LPAGE']), 50);
$Row['PATH1_title'] = $Row['LPAGE'];
$Row['LPAGE'] = urldecode($Row['LPAGE']);
if (!$Row['LAST_IP']) {
$Row['LAST_IP'] = "^";
}
$Row['LAST_IP_title'] = $Lang['VisPaths'];
$Row['STAMP_title'] = $Lang['PathsForDay'];
$Row['LAST_IP_link'] = getURL("visitor_path", "AllSites={$AllSites}&VisId=" . $Row['VISITOR_ID'] . "&SiteId=" . $Row['SITE_ID'] . "&ViewDate={$ViewDate}", "report");
$LogArr[] = $Row;
}
$FldNames['STAMP'] = $Lang['Time'];
$FldNames['LAST_IP'] = $Lang['IP'];
$FldNames['PATH1'] = $Lang['Page'];
$FldNames['KEYWORD'] = $Lang['Key'];
$FldNames['REF_DOMAIN'] = $Lang['RefDomain'];
