);" 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'];