@ini_set("memory_limit", "20M");
}
if ($ShowAll == 0) {
$Report->RsNeeded = true;
}
if ($ShowAll == 1) {
$Report->NoRef = true;
}
if ($ShowAll == 2) {
$Report->OnlyNoRef = true;
}
if ($OnlyNatural) {
$Report->JoinArr[] = "LEFT JOIN " . PFX . "_tracker_" . $CpId . "_stat_click S_CLICK ON S_CLICK.LOG_ID = S_LOG.COOKIE_LOG";
$Report->WhereArr[] = "(S_CLICK.ID < 1 OR S_CLICK.ID IS NULL)";
}
$Report->Calculate();
if (ValidVar($Report->StatArr)) {
if (!$GroupBy) {
$Report->Tmp[0] = $Report->StatArr;
$Report->StatArr = $Report->Tmp;
}
if (!$GroupBy && !$WhereArr) {
$Report->StatArr[0]['Name'] = $Lang['Total'];
$GroupBy = "General";
}
// Experimenting with sorting by actions conversion
if ($OrderBy == "ACTCONV" || $OrderBy == "SALECONV" || $OrderBy == "ACTIONCNT" || $OrderBy == "ACTIONUNI" || $OrderBy == "SALECNT" || $OrderBy == "SALEUNI" || $OrderBy == "INCOME") {
usort($Report->StatArr, "SortRows");
if (count($Report->StatArr) > $Limit) {
array_splice($Report->StatArr, $Limit);
}
if ($nsUser->Columns->SALES) {
$NaturalReport->ShowSales = true;
}
$NaturalReport->ViewDate = $Today;
$NaturalReport->CpId = $CurrentCompany->ID;
if ($SitesCnt == 0) {
$NaturalReport->SiteId = -1;
}
$NaturalReport->SelectArr[] = "TS.ID";
$NaturalReport->SelectArr[] = "TS.HOST AS NAME";
$NaturalReport->JoinArr[] = "INNER JOIN " . PFX . "_tracker_site TS ON TS.ID=S_LOG.SITE_ID";
$NaturalReport->GroupArr[] = "TS.ID";
$NaturalReport->GrpFld = "ID";
$NaturalReport->GrpName = "NAME";
$NaturalReport->OrderArr[] = "TS.HOST ASC";
$NaturalReport->Calculate();
if ($nsUser->Columns->CLICKS) {
$PaidReport = new Paid_v2();
$PaidReport->ShowVisitors = true;
$PaidReport->CpId = $CurrentCompany->ID;
if ($SitesCnt == 0) {
$PaidReport->SiteId = -1;
}
$PaidReport->ViewDate = $Today;
$PaidReport->SelectArr[] = "TS.ID";
$PaidReport->SelectArr[] = "TS.HOST AS NAME";
$PaidReport->JoinArr[] = "INNER JOIN " . PFX . "_tracker_site TS ON TS.ID=S_LOG.SITE_ID";
$PaidReport->GroupArr[] = "TS.ID";
$PaidReport->GrpFld = "ID";
$PaidReport->GrpName = "NAME";
$PaidReport->OrderArr[] = "TS.HOST ASC";
