function CheckSettings() { global $DbHost, $DbPort, $DbName, $DbUser, $DbPass, $DbPref, $UpdateNeeded; global $Errors, $Lang, $CLang; $DbHost1 = $DbPort ? $DbHost . ":" . $DbPort : $DbHost; $ID = @mysql_connect($DbHost1, $DbUser, $DbPass); if (!$ID) { $Errors[] = $Lang['ConnectFailed']; return false; } $SelectRes = @mysql_select_db($DbName, $ID); if (!$SelectRes) { $Errors[] = $Lang['SelectFailed']; return false; } $Query = "SELECT * FROM " . $DbPref . "_system_product"; $SelectRes = mysql_query($Query); if ($SelectRes) { $Check = mysql_fetch_row($SelectRes); if (ValidVar($Check[0]) || !mysql_error()) { $Errors[] = $Lang['PfxAlreadyExists']; $UpdateNeeded = true; return false; } } NextStep(); }
function TrackerConsult() { global $nsUser; if (!$nsUser->Logged() || !ValidVar($nsUser->HELP_MODE) || $nsUser->HELP_MODE == 0) { $this->UseConsult = false; return false; } $this->CurrentHelp = "default"; $this->UseConsult = true; $this->Display = "none"; global $_GP, $Db; $DisableContext = ValidVar($_GP['DisableContext']) ? true : false; $DisableHelp = ValidVar($_GP['DisableHelp']) ? true : false; if ($DisableContext) { $Query = "UPDATE " . PFX . "_tracker_user_settings SET HELP_MODE='0' WHERE USER_ID=" . $nsUser->UserId(); $Db->Query($Query); $this->UseConsult = false; $nsUser->HELP_MODE = 0; } if ($DisableHelp) { $Query = "UPDATE " . PFX . "_tracker_user_settings SET HELP_MODE='1' WHERE USER_ID=" . $nsUser->UserId(); $Db->Query($Query); $nsUser->HELP_MODE = 1; } }
function SaveSplitToFile($Id = false, $Filename, $SplitId = false) { global $Db; if (!$Id && !$SplitId) { return false; } $UseStore = $Db->ReturnValue("SELECT USE_STORE FROM " . PFX . "_tracker_config WHERE COMPANY_ID=0"); if (!$UseStore) { return true; } if (!$SplitId) { $SplitId = $Db->ReturnValue("SELECT ID FROM " . PFX . "_tracker_split_test WHERE SUB_ID={$Id}"); } $Query = "\n\t\tSELECT SP.FULL_PATH AS PAGE_PATH\n\t\t\tFROM " . PFX . "_tracker_split_page SP\n\t\t\tINNER JOIN " . PFX . "_tracker_site_page SPA\n\t\t\t\tON SPA.ID=SP.PAGE_ID\n\t\t\tINNER JOIN " . PFX . "_tracker_site S\n\t\t\t\tON S.ID=SPA.SITE_ID\n\t\t\tLEFT JOIN " . PFX . "_tracker_query Q\n\t\t\t\tON Q.ID=SP.QUERY_ID\n\t\t\tWHERE SP.SPLIT_ID={$SplitId}\n\t\t"; $Sql = new Query($Query, "ARR"); $PageArr = array(); while ($Row = $Sql->Row()) { if (!ValidVar($Row['HOST'])) { continue; } if (!$Row['PAGE_PATH']) { $Row['PAGE_PATH'] = "http://" . $Row['HOST'] . $Row['PATH']; if ($Row['QUERY_STRING']) { $Row['PAGE_PATH'] .= "?" . $Row['QUERY_STRING']; } } $PageArr[] = $Row['PAGE_PATH']; } if (!ValidArr($PageArr) || count($PageArr) < 1) { return false; } @clearstatcache(); $f = @fopen("store/{$Filename}", "a+"); if (!@is_writable("store/{$Filename}")) { return false; } if (!$f) { return false; } $Data = @fread($f, @filesize("store/{$Filename}")); if (!$Data) { $DataArr[$SplitId] = $PageArr; } else { $DataArr = @unserialize($Data); if (!ValidArr($DataArr)) { $DataArr = array(); } $DataArr[$SplitId] = $PageArr; } $Data = @serialize($DataArr); @flock($f, LOCK_EX); @ftruncate($f, 0); if (!@fwrite($f, $Data)) { return false; } @flock($f, LOCK_UN); @fclose($f); return true; }
function SendP3P() { $this->P3PSent = true; $Str = GetParam("P3P", "STRVAL"); $Ref = GetParam("P3P_REF", "STRVAL"); if (!ValidVar($Str)) { return; } if (ValidVar($Ref)) { $Ref = "policyref=\"{$Ref}\", "; } else { $Ref = ""; } Header("P3P: {$Ref} CP=\"{$Str}\""); }
function CheckCompany() { global $CompName, $CompDescr, $SiteDomain; global $Errors, $Lang; if (!$CompName) { $Errors[] = $Lang['MustFillCompanyName']; return; } if (!$SiteDomain) { $Errors[] = $Lang['MustFillDomain']; return; } if (!ValidHost($SiteDomain)) { $Errors[] = $Lang['DomainIncorrect']; return; } $Check = @parse_url($SiteDomain); if (is_array($Check) && ValidVar($Check['scheme'])) { $Host = str_replace($Check['scheme'] . "://", "", $SiteDomain); } NextStep(); }
function ExportCsv($DataArr, $Separator = ";", $NamesArr = false, $Expanded = false) { $Export = ""; if (ValidArr($NamesArr)) { foreach ($NamesArr as $i => $Row) { $NamesArr[$i] = CsvPrepare($NamesArr[$i], $Separator); } $Export .= implode($Separator, $NamesArr); $Export .= "\n"; } foreach ($DataArr as $i => $Row) { $TmpArr = array(); foreach ($NamesArr as $Key => $SubRow) { $Str = ""; $KeyArr = array(); $KeyArr = explode("|", $Key); if (!$Expanded) { $KeyArr = array_slice($KeyArr, 0, 1); } for ($z = 0; $z < count($KeyArr); $z++) { if (!ValidVar($KeyArr[$z])) { continue; } if ($z > 0) { $Str .= " ("; } $Str .= $Row[$KeyArr[$z]]; if ($z > 0) { $Str .= ")"; } } $TmpArr[] = CsvPrepare($Str, $Separator); } $Export .= implode($Separator, $TmpArr); $Export .= "\n"; } return $Export; }
<td class="ReportSimpleTd" height="23" ID="Income_<?php echo $Row['Position']; ?> " onmouseover="HighLightRow('Income', <?php echo $Row['Position']; ?> );" onmouseout="RemoveLight('Income',<?php echo $Row['Position']; ?> );" onclick="CheckRowCol('Income',<?php echo $Row['Position']; ?> );" > <p class=ReportColumn><B> <?php if (ValidVar($Row['TotalIncome'])) { echo ShowCost($Row['TotalIncome'], $CurrentCompany->CUR); } ?> </B><br><span class="ReportSubColumn"> </span></p> </td> <?php } ?> <?php if ($nsUser->Columns->ACTIONS && $nsUser->Columns->CONVERSIONS) { ?>
} ?> <tr><td class=ReportSimpleTd2> <input type=checkbox value=1 ID="AddToMy" name="SaveReport[AddToMy]" <?php echo ValidVar($SaveReport['AddToMy']) == 1 ? "checked" : ""; ?> ><label for="AddToMy"> <?php echo $Lang['AddToMy']; ?> </label> </td></tr> <tr><td class=ReportSimpleTd2> <input type=text size=30 name="SaveReport[Name]" value="<?php echo htmlspecialchars(stripslashes(ValidVar($SaveReport['Name']))); ?> "> <?php echo $Lang['ReportName']; ?> </td></tr> <tr><td class=ReportSimpleTd2> <input type=submit value="<?php echo $Lang['Save']; ?> "> </td></tr> </form> </table>
function SaveUserReport(&$Id, $Arr) { global $Db, $Logs, $Lang; extract($Arr); $Name = addslashes(trim(ValidVar($Name))); if (!$Name) { $Logs->Err($Lang['MustFillName']); return; } $Query = "UPDATE " . PFX . "_tracker_user_report SET NAME='{$Name}' WHERE ID={$Id}"; $Db->Query($Query); $Id = false; $Logs->Msg($Lang['RecordUpdated']); }
function UpdateUser($Id, &$Arr) { global $Db, $nsProduct, $Logs, $nsUser, $CurrentCompany, $Lang, $_COOKIE; $EditUser = $Db->Select(GetUserQuery($Id)); extract($Arr); if (!isset($Super)) { $Super = 0; } if (!isset($Demo)) { $Demo = 0; } if (!isset($AdvMode)) { $AdvMode = 0; } if (!isset($ColHits)) { $ColHits = 0; } if (!isset($ColSales)) { $ColSales = 0; } if (!isset($ColActions)) { $ColActions = 0; } if (!isset($ColClicks)) { $ColClicks = 0; } if (!isset($ColROI)) { $ColROI = 0; } if (!isset($ColConv)) { $ColConv = 0; } if (!isset($Graphs)) { $Graphs = 0; } if (!isset($HelpMode)) { $HelpMode = 0; } if (!isset($Enc)) { $Enc = ""; } $Enc = addslashes($Enc); $Login = ToLower($Login); if (CheckSymb_($Login)) { $ErrArr['Login'] = $Lang['SymbErr']; } if (!ValidMail($Email)) { $ErrArr['Email'] = $Lang['MustFillCorr']; } if (!$Name) { $ErrArr['Name'] = $Lang['MustFill']; } if (!$Email) { $ErrArr['Email'] = $Lang['MustFill']; } if (!$Login) { $ErrArr['Login'] = $Lang['MustFill']; } if (strlen($Login) < 3) { $ErrArr['Login'] = $Lang['LoginTooShort']; } if (strlen($Login) > 64) { $ErrArr['Login'] = $Lang['LoginTooLong']; } if (!$Company) { $ErrArr['Company'] = $Lang['CompanyRequired']; } if ($Pass) { if (strlen($Pass) < 3) { $ErrArr['Pass'] = $Lang['PassTooShort']; } if (strlen($Pass) > 64) { $ErrArr['Pass'] = $Lang['PassTooLong']; } if ($Pass != $Pass2) { $ErrArr['Pass2'] = $Lang['PassNotPass2']; } if (CheckSymb_($Pass)) { $ErrArr['Pass'] = $Lang['SymbErr']; } } if ($Login != $EditUser->LOGIN) { $Query = "SELECT ID FROM " . PFX . "_system_user WHERE LOGIN = '******'"; $Check = $Db->Select($Query); if (isset($Check->ID) && ValidId($Check->ID)) { $ErrArr['Login'] = $Lang['LoginExists']; } } if (isset($ErrArr)) { $Logs->Err($Lang['FormErr']); $GLOBALS['ErrArr'] = $ErrArr; return; } if (!$nsUser->ADMIN) { $Company = $nsUser->COMPANY_ID; } if (!$nsUser->ADMIN && !$nsUser->SUPER_USER) { $Super = 0; } if ($nsProduct->LICENSE == 2) { $Company = $CurrentCompany->ID; } if ($nsProduct->LICENSE != 3 || !$nsUser->ADMIN && !$nsUser->SUPER_USER) { $Demo = $EditUser->DEMO; } $Query = "UPDATE " . PFX . "_system_user SET LOGIN = ? , NAME = ?, EMAIL = ? WHERE ID = {$Id}"; $Db->Query($Query, $Login, $Name, $Email); $Query = "UPDATE " . PFX . "_tracker_user SET COMPANY_ID = {$Company} WHERE ID = " . $EditUser->MERCH_ID; $Db->Query($Query); if ($nsUser->UserId() != $EditUser->ID) { $Query = "UPDATE " . PFX . "_tracker_user SET SUPER_USER = '******', DEMO='{$Demo}' WHERE ID = " . $EditUser->MERCH_ID; $Db->Query($Query); } if ($Pass) { $Query = "UPDATE " . PFX . "_system_user SET PWD = '" . md5($Pass) . "' WHERE ID = {$Id}"; $Db->Query($Query); if ($Id == $nsUser->UserId()) { $nsUser->Login($nsUser->UserInfo['LOGIN'], $Pass, ValidVar($_COOKIE[COOKIE_PFX . 'pwd'])); } } if ($Id == $nsUser->UserId()) { if (ValidVar($DefSkin)) { if ($nsUser->USKIN) { $Query = "UPDATE " . PFX . "_system_user2skin SET SKIN='{$DefSkin}' WHERE UID={$Id} AND PROD_ID=" . $nsProduct->ID . ""; } else { $Query = "INSERT INTO " . PFX . "_system_user2skin (UID, PROD_ID, SKIN) VALUES ({$Id}, " . $nsProduct->ID . ", '{$DefSkin}')"; } $Db->Query($Query); } if (ValidVar($DefLang)) { if ($nsUser->ULANG) { $Query = "UPDATE " . PFX . "_system_user2lang SET LANG= '{$DefLang}' WHERE UID={$Id} AND PROD_ID=" . $nsProduct->ID . ""; } else { $Query = "INSERT INTO " . PFX . "_system_user2lang (UID, PROD_ID, LANG) VALUES ({$Id}, " . $nsProduct->ID . ", '{$DefLang}')"; } $Db->Query($Query); } $Query = "UPDATE " . PFX . "_tracker_user_column SET HITS='{$ColHits}', SALES='{$ColSales}', ACTIONS='{$ColActions}', CLICKS='{$ColClicks}', ROI='{$ColROI}', CONVERSIONS='{$ColConv}', GRAPHS='{$Graphs}' WHERE USER_ID={$Id}"; $Db->Query($Query); $Query = "UPDATE " . PFX . "_tracker_user_settings SET ADVANCED_MODE='{$AdvMode}', HELP_MODE='{$HelpMode}', TIMEZONE='{$TZ}', PAGE_ENCODING = '{$Enc}' WHERE USER_ID={$Id}"; $Db->Query($Query); } if (ValidVar($Ignore)) { $nsUser->SetCookie(COOKIE_PFX . 'skip', "1", time() + 60 * 60 * 24 * 10 * 365, "/"); } else { $nsUser->SetCookie(COOKIE_PFX . 'skip', "", time() - 100, "/"); } if (!$nsUser->ADMIN && !$nsUser->SUPER_USER) { $nsProduct->Redir("users", "RUpd=1&EditUid={$Id}"); } $nsProduct->Redir("users", "RUpd=1"); }
function ShowCost($Value = 0, $Arr = false) { global $CurrentCompany; if (!$Arr) { $Arr = ValidVar($CurrentCompany->CUR); } if (!$Arr || !$Arr[0] || !$Value) { return $Value; } if ($Arr[1] == 0) { return $Arr[0] . $Value; } if ($Arr[1] == 1) { return $Value . $Arr[0]; } }
<?php GetFORM(); ?> <input type=hidden name=HostId value=<?php echo $HostId; ?> > <input type=hidden name=EditId value=<?php echo $EditId; ?> > <?php echo $Lang['Template']; ?> : <input type=text name="Templ" value="<?php echo ValidVar($Templ) ? $Templ : ""; ?> "> <input type=submit value="<?php echo $Lang['Search']; ?> "> </form> </td></tr> <tr><td colspan=2> <?php echo $Pages->Dump(); ?> </td></tr> <?php
} } if ($WhereArr[$i]['Mode'] == "Pixel") { $WhereArr[$i]['Name'] = $Lang['ByPixel']; $MetaTitle .= ": " . $Lang['ByPixel']; if (ValidVar($WhereArr[$i]['Id'])) { $WhereArr[$i]['Name2'] = $WhereArr[$i]['Id'] != "-1" ? $WhereArr[$i]['Id'] : $Lang['Undefined']; $MetaTitle .= ": " . ($WhereArr[$i]['Id'] != "-1" ? $WhereArr[$i]['Id'] : $Lang['Undefined']); $Report->WhereArr[] = "V.PIXEL_DEPTH='" . $WhereArr[$i]['Id'] . "'"; $Report->JoinArr[] = "INNER JOIN " . PFX . "_tracker_visitor V ON V.ID=S_LOG.VISITOR_ID"; } } if ($WhereArr[$i]['Mode'] == "Flash") { $WhereArr[$i]['Name'] = $Lang['ByFlash']; $MetaTitle .= ": " . $Lang['ByFlash']; if (ValidVar($WhereArr[$i]['Id'])) { $WhereArr[$i]['Name2'] = $WhereArr[$i]['Id'] != "-1" ? $WhereArr[$i]['Id'] : $Lang['None']; $MetaTitle .= ": " . ($WhereArr[$i]['Id'] != "-1" ? $WhereArr[$i]['Id'] : $Lang['None']); $Report->WhereArr[] = "V.FLASH_VERSION='" . $WhereArr[$i]['Id'] . "'"; $Report->JoinArr[] = "INNER JOIN " . PFX . "_tracker_visitor V ON V.ID=S_LOG.VISITOR_ID"; } } $Get .= "&WhereArr[{$i}][Mode]=" . $WhereArr[$i]['Mode']; $Get .= "&WhereArr[{$i}][Id]=" . $WhereArr[$i]['Id']; if (ValidVar($WhereArr[$i]['OrderTo'])) { $Get .= "&WhereArr[{$i}][OrderTo]=" . $WhereArr[$i]['OrderTo']; } if (ValidVar($WhereArr[$i]['OrderBy'])) { $Get .= "&WhereArr[{$i}][OrderBy]=" . $WhereArr[$i]['OrderBy']; } }
function UpdateAction($Arr, $Id = false) { global $Db, $Logs, $nsProduct, $HostsArr, $SiteId, $CpId, $Site, $Lang; $TPath = ""; $ActionPath = ""; $CodeAction = 0; $SiteHostId = 0; extract($Arr); if (!ValidVar($Name)) { $Logs->Err($Lang['MustFillName']); return; } if (!ValidVar($Templ) && ValidVar($RedirOnly) != 2) { $Logs->Err($Lang['WhatIsAction']); return; } if (ValidVar($RedirOnly) == 1 && !ValidVar($RedirUrl) && !ValidVar($Dynamic)) { $Logs->Err($Lang['RedirUrlRequired']); return; } if (!ValidVar($Active)) { $Active = 0; } if (ValidVar($RedirOnly) == 2) { $CodeAction = 1; } if (!$CodeAction) { $TmpArr = explode("{a}", $Templ); if (ValidArr($TmpArr) && count($TmpArr) > 2) { $Logs->Err($Lang['OnlyOneActionTarget']); return; } $NoPage = false; $TArr = @parse_url($Templ); if (!$TArr) { $Logs->Err($Lang['UnableParseTemplate']); return; } if (isset($TArr['path']) && !isset($TArr['host'])) { //$Path=ToLower($TArr['path']); for ($i = 0; $i < count($HostsArr); $i++) { if (strpos($Path, $HostsArr[$i]) !== false) { $Path = str_replace($HostsArr[$i], "", $Path); $TArr['host'] = $HostsArr[$i]; $TArr['path'] = $Path; break; } } } if (count($TArr) == 1 && substr(ValidVar($TArr['path']), 0, 1) != "/") { if (isset($TArr['path']) && !isset($TArr['query'])) { $TArr['query'] = $TArr['path']; } unset($TArr['path']); $NoPage = 1; } if (isset($TArr['fragment'])) { unset($TArr['fragment']); } if (!$NoPage) { if (!isset($TArr['host'])) { $TArr['host'] = $Site->HOST; } $TArr['host'] = ToLower($TArr['host']); //if (isset($TArr['path'])&&isset($TArr['query'])&&!isset($TArr['host'])) $TArr['host']=$Site->HOST; if (isset($TArr['path']) && substr($TArr['path'], 0, 1) != "/") { $TArr['path'] = "/" . $TArr['path']; } if (!ValidVar($TArr['host']) || !in_array($TArr['host'], $HostsArr)) { //$Logs->Err($Lang['InvalidDomain']);return; $Query = "INSERT INTO " . PFX . "_tracker_site_host (HOST, SITE_ID) VALUES (?, " . $Site->ID . ")"; $Db->Query($Query, $TArr['host']); $NewHostId = $Db->LastInsertId; $HostsArr[] = $TArr['host']; $Site->Hosts[$NewHostId] = $TArr['host']; } if (!ValidVar($TArr['path'])) { $TArr['path'] = "/"; } if (strpos($TArr['path'], "*") === false && strpos($TArr['path'], "{a}") === false && strpos($TArr['path'], ".") === false && $TArr['path'] != "/" && substr($TArr['path'], -1) != "/") { $TArr['path'] .= "/"; } extract($TArr); foreach ($Site->Hosts as $SHId => $SHost) { if ($host == $SHost) { $SiteHostId = $SHId; } } if (strpos($path, "*") === false && strpos($path, "{a}") === false) { $Query = "SELECT ID FROM " . PFX . "_tracker_site_page WHERE SITE_ID={$SiteId} AND PATH='{$path}'"; $PageId = $Db->ReturnValue($Query); if (!ValidId($PageId)) { $Query = "INSERT INTO " . PFX . "_tracker_site_page (SITE_ID, PATH) VALUES ({$SiteId}, '{$path}')"; $Db->Query($Query); $PageId = $Db->LastInsertId; } $ActionPath = $path; if (!ValidId($PageId)) { $Logs->Err($Lang['UnableCreatePage']); return; } } else { if (ValidVar($RedirOnly)) { $Logs->Err($Lang['NoRedirWithPageTemp']); return; } $PageId = 0; $TPath = $path; } if (ValidVar($query)) { $query = "?" . $query; } } else { $PageId = 0; $query = $Templ; if (strpos($query, "?") === false || strpos($query, "?") != 0) { $query = "?" . $query; } } if (ValidVar($RedirOnly) != 1 && ValidVar($RedirOnly) != 2) { $RedirOnly = 0; } if (!ValidVar($RedirUrl)) { $RedirUrl = ""; } if (!ValidVar($ItemVar)) { $ItemVar = ""; } $RedirUrl = urlencode($RedirUrl); $LogInfo = ""; } else { $PageId = 0; $query = ""; $RedirUrl = ""; $TPath = ""; $ItemVar = ""; $RedirOnly = 0; } if (!$Id) { $Query = "INSERT INTO " . PFX . "_tracker_visitor_action (SITE_ID, PAGE_ID, NAME, QUERY, PATH, REDIRECT_URL, REDIRECT_CATCH, ITEM_VAR, ACTIVE, CODE_ACTION, SITE_HOST_ID) VALUES ({$SiteId}, {$PageId}, '{$Name}', '{$query}', '{$TPath}', '{$RedirUrl}', '{$RedirOnly}', '{$ItemVar}', '{$Active}', '{$CodeAction}', '{$SiteHostId}')"; $Db->Query($Query); $EditId = $Db->LastInsertId; $LogInfo = "&RCrt=1"; } else { $Query = "UPDATE " . PFX . "_tracker_visitor_action SET PAGE_ID={$PageId}, NAME='{$Name}', QUERY='{$query}', PATH='{$TPath}', REDIRECT_URL='{$RedirUrl}', REDIRECT_CATCH='{$RedirOnly}', ITEM_VAR='{$ItemVar}', ACTIVE='{$Active}', CODE_ACTION='{$CodeAction}', SITE_HOST_ID='{$SiteHostId}' WHERE ID = {$Id} AND SITE_ID={$SiteId}"; $Db->Query($Query); $EditId = $Id; $LogInfo = "&RUpd=1"; } $WrRes = true; $WrErr = false; if (!$CodeAction) { $UseStore = $Db->ReturnValue("SELECT USE_STORE FROM " . PFX . "_tracker_config WHERE COMPANY_ID=0"); if ($RedirOnly && $UseStore) { $ActionArr['ID'] = $EditId; $ActionArr['PAGE_ID'] = $PageId; $ActionArr['SITE_ID'] = $SiteId; $ActionArr['REDIRECT_URL'] = $RedirUrl; $ActionArr['PATH'] = $ActionPath; $WrRes = false; $WrRes = SaveActionToFile($ActionArr, "redir_action.nodb"); //if (!$WrRes) $WrErr="&WrErr=1"; } } $nsProduct->Redir("actions", "CpId={$CpId}&SiteId={$SiteId}&EditId={$EditId}" . $WrErr . $LogInfo); }
$nsLang->TplInc("inc/user_welcome"); $ProgPath[0]['Name'] = $Lang['Administr']; $ProgPath[0]['Url'] = getURL("admin", "", "admin"); $ProgPath[1]['Name'] = $PageTitle; $ProgPath[1]['Url'] = getURL("base_stat", "", "admin"); $MenuSection = "admin"; $DoOptimize = ValidVar($_GP['DoOptimize']) ? true : false; $EndDate = ValidDate($_GP['EndDate']) ? $_GP['EndDate'] : false; $DoClear = ValidVar($_GP['DoClear']) ? true : false; $ForClient = ValidId($_GP['ForClient']) ? $_GP['ForClient'] : false; $SiteId = ValidId($_GP['SiteId']) ? $_GP['SiteId'] : false; $EndTime = false; if ($EndDate) { $EndTime = $EndDate . " 23:59:59"; } if (!$ForClient && ValidVar($_GP['ForClient']) != "all" && ValidId($CurrentCompany->ID)) { $ForClient = $CurrentCompany->ID; } $ClientsArr = array(); $StatLogArr = array(); $ActionLogArr = array(); $SaleLogArr = array(); $SplitLogArr = array(); $UndefLogArr = array(); $ClickLogArr = array(); $Query = "SELECT C.ID, C.NAME, S.HOST, S.ID AS SITE_ID FROM " . PFX . "_tracker_client C INNER JOIN " . PFX . "_tracker_site S ON S.COMPANY_ID=C.ID ORDER BY C.NAME"; $Sql = new Query($Query); while ($Row = $Sql->Row()) { if (!$nsUser->ADMIN && $Row->ID != $nsUser->COMPANY_ID) { continue; }
echo $TopCodeHelp; ?> </span> <br><IMG SRC="<?php echo FileLink("images/0.gif"); ?> " WIDTH="1" HEIGHT="10" BORDER="0" ALT=""> <textarea rows=9 style="width:100%;font-family:Courier;font-size:14px;border-width:1px; border-style:solid;border-color:#C7C7C7;padding:4px;background:#E5E5E5;color:#000000;" readonly onclick="this.select();"> <?php echo $ResultCode; ?> </textarea> <?php if (ValidVar($CodeComment)) { ?> <IMG SRC="<?php echo FileLink("images/0.gif"); ?> " WIDTH="1" HEIGHT="10" BORDER="0" ALT=""><br><span style="color:#000000"> <?php echo $CodeComment; } ?> </span><br><IMG SRC="<?php echo FileLink("images/0.gif"); ?> " WIDTH="1" HEIGHT="10" BORDER="0" ALT=""> </div>
///////////////////////////////////////////// ///////// prepare any variables $PageTitle = $Lang['Title']; $nsLang->TplInc("inc/user_welcome"); $ProgPath[0]['Name'] = $Lang['Administr']; $ProgPath[0]['Url'] = getURL("admin", "", "admin"); $ProgPath[1]['Name'] = $PageTitle; $ProgPath[1]['Url'] = getURL("ip_ignore", "", "admin"); $MenuSection = "admin"; $NewIp = ValidVar($_GP['NewIp']); $NewIpDescr = ValidVar($_GP['NewIpDescr']); if ($NewIp && !ValidIP($NewIp) && !ValidIpTempl($NewIp)) { $Logs->Err($Lang['WrongIp']); $NewIp = false; } $RemoveIP = ValidVar($_GP['RemoveIP']); if (!ValidArr($RemoveIp)) { $RemoveIp = false; } $MyIP = $_SERVER['REMOTE_ADDR']; ///////////////////////////////////////////// ///////// call any process functions if (!$nsUser->DEMO) { if ($NewIp && ValidIp($NewIp)) { AddNewIp($NewIp, $NewIpDescr); } if ($NewIp && ValidIpTempl($NewIp)) { AddNewIpTempl($NewIp, $NewIpDescr); } if ($RemoveIP) { RemoveIp($RemoveIP);
function VisitorAgent() { global $_SERVER; return ValidVar($_SERVER['HTTP_USER_AGENT']); }
function GetConstPath(&$Arr, $Inx, $Group = true) { global $CpId, $ViewDate, $StartDate, $EndDate, $DatesUsed, $ShowFilter; $URL = "CpId={$CpId}&"; if (!$DatesUsed) { $URL .= "StartDate={$StartDate}&EndDate={$EndDate}&ViewDate={$ViewDate}&ShowFilter={$ShowFilter}&"; } for ($i = 0; $i <= $Inx; $i++) { if ($Inx != $i || !$Group) { $URL .= "WhereArr[{$i}][Mode]=" . $Arr[$i]['Mode'] . "&"; if (isset($Arr[$i]['Id']) && $Arr[$i]['Id'] != "") { $URL .= "WhereArr[{$i}][Id]=" . $Arr[$i]['Id'] . "&"; } } if ($Group) { $URL .= "GroupBy=" . $Arr[$i]['Mode'] . "&"; } if (ValidVar($Arr[$i]['OrderTo'])) { $URL .= "WhereArr[{$i}][OrderTo]=" . $Arr[$i]['OrderTo'] . "&"; } if (ValidVar($Arr[$i]['OrderBy'])) { $URL .= "WhereArr[{$i}][OrderBy]=" . $Arr[$i]['OrderBy'] . "&"; } } return $URL; }
function QueryAllArray($Query, $type = 'OBJ') { global $DbLastQuery; $Db =& $GLOBALS['DBCLASS']; if (func_num_args() > 2) { $Args = func_get_args(); $Query = $Db->PrepareQuery($Query, $Args, 2); } $DbLastQuery = $Query; $Sql = new Query($Query, $type); while ($Row = $Sql->Row()) { $Return[] = $Row; } return ValidVar($Return, null); }
</td></tr> </table> <table class=SubmitTable> <tr><td class=SubmitLeftTd> </td><td class=SubmitRightTd> <input type=submit value="<?php echo $Lang['Save']; ?> "> </td></tr> <?php } elseif (ValidVar($EditArr['Descr'])) { ?> <tr><td class=FormLeftTd> <?php echo $Lang['Title']; ?> </td><td class=FormRightTd> <?php echo stripslashes($EditArr['Descr']); ?> </td></tr> <?php } ?> </form>
function UpdateCampaign($Id, &$Arr) { global $Db, $nsProduct, $Logs, $Lang, $nsUser; extract($Arr); if (!$Name) { $ErrArr['Name'] = $Lang['MustFill']; } if (isset($ErrArr)) { $Logs->Err($Lang['FormErr']); $GLOBALS['ErrArr'] = $ErrArr; return; } $Query = "UPDATE " . PFX . "_tracker_campaign SET NAME = ?, DESCRIPTION = ? WHERE ID = {$Id}"; $Db->Query($Query, $Name, $Descr); if (ValidVar($Watch) == 1 && !CheckGrpWatch($Id, $nsUser->UserId())) { SetGrpWatch($Id, $nsUser->UserId()); } else { RemoveGrpWatch($Id, $nsUser->UserId()); } $nsProduct->Redir("campaign", "RUpd=1"); }
<?php if (ValidVar($MenuSection) == "admin") { ?> <p class=CompName1><?php echo $Lang['Administr']; ?> </p><?php } if (ValidVar($MenuSection) == "my_tracker") { ?> <p class=CompName1><?php echo $Lang['MyTracker']; ?> </p><?php } if (!ValidVar($MenuSection)) { ?> <p><img src="<?php echo FileLink("images/0.gif"); ?> " width="1" height="1" border="0"></p><?php } ?> <?php } ?> </td> </tr></table> </td>
if ($Row['Permit'] == "admin" && !$nsUser->ADMIN) { continue; } if ($Row['Permit'] == "superadmin" && !$nsUser->SUPER_ADMIN) { continue; } } if (ValidVar($Row['PMode'])) { if ($Row['PMode'] == 2 && $nsProduct->LICENSE != 2) { continue; } if ($Row['PMode'] == 3 && $nsProduct->LICENSE != 3) { continue; } } MenuTab($Row['Name'], $Row['URL'], isset($AdditionalSection) && $AdditionalSection == $Row['id'] ? true : false, ValidVar($Row['Img']), ValidVar($Row['ImgW']), ValidVar($Row['ImgH'])); unset($Row); } } } else { ?> <td width=100% class=TabsBorder><p><img src="<?php echo FileLink("images/0.gif"); ?> " width="1" height="27" border="0"></p></td> <?php } ?> </tr>
$IpCnt = 0; if (ValidIp($IP)) { $IpCnt = $Db->ReturnValue("SELECT COUNT(*) FROM " . PFX . "_tracker_ip WHERE IP = '{$IP}'"); if ($IpCnt == 1) { $Query = "\n\t\t\tSELECT V.ID \n\t\t\t\tFROM " . PFX . "_tracker_ip I\n\t\t\t\tINNER JOIN " . PFX . "_tracker_visitor V\n\t\t\t\t\tON V.LAST_IP_ID=I.ID\n\t\t\t\tWHERE IP = '{$IP}' \n\t\t\t\tORDER BY V.ID DESC"; $VisId = $Db->ReturnValue($Query); $nsProduct->Redir("visitor_path", "VisId={$VisId}&SiteId={$SiteId}&CpId={$CpId}", "report"); } if ($IpCnt > 1) { $nsProduct->Redir("visitor_path", "IP={$IP}&SiteId={$SiteId}&CpId={$CpId}", "report"); } if ($IpCnt == 0) { $Logs->Msg(str_replace("{IP}", $IP, $Lang['NoSuchIp'])); } } if (ValidVar($IP) && !ValidIp($IP)) { $Logs->Err($Lang['IpErr']); } $SitesArr = array(); if (!ValidId($SiteId) && !ValidId($CpId)) { $nsProduct->Redir("default"); } if (ValidId($CpId)) { $Query = "SELECT * FROM " . PFX . "_tracker_client WHERE ID = {$CpId}"; $Comp = $Db->Select($Query); $PageTitle = $Comp->NAME; $Query = "SELECT ID, HOST FROM " . PFX . "_tracker_site WHERE COMPANY_ID={$CpId}"; $Sql = new Query($Query); while ($Row = $Sql->Row()) { $SitesArr[] = $Row; }
function ns_my_url() { return 'http' . (strtolower(ValidVar($_SERVER["HTTPS"])) == "on" ? 's' : '') . '://' . $_SERVER['HTTP_HOST'] . $_SERVER['REQUEST_URI']; }
?> <a href="<?php echo getURL("logs", $Get . "&Filter={$Filter}&FilterFor={$FilterFor}&Mode={$Mode}&DeleteId=" . $Row['DELETE_ID'], "report"); ?> " onclick="return confirm('<?php echo $Lang['YouSure']; ?> ');"><IMG SRC="<?php echo FileLink("images/icon_delete.gif"); ?> " WIDTH="11" HEIGHT="11" BORDER="0" ALT=""></a> <?php } ?> <?php if (!ValidVar($Row[$Key])) { echo " "; } ?> </td> <?php } ?> </tr> <tr> <td width="100%" height="1" colspan="<?php echo count($FldNames); ?> " bgcolor="#E1E1E1"> <p><img src="<?php
$DbPort = ValidVar($_REQUEST['DbPort']) ? $_REQUEST['DbPort'] : "3306"; $DbName = ValidVar($_REQUEST['DbName']) ? $_REQUEST['DbName'] : ""; $DbUser = ValidVar($_REQUEST['DbUser']) ? $_REQUEST['DbUser'] : ""; $DbPass = ValidVar($_REQUEST['DbPass']) ? $_REQUEST['DbPass'] : ""; $DbPref = ValidVar($_REQUEST['DbPref']) ? $_REQUEST['DbPref'] : "ns"; $NoPrevStep = true; $AlreadyEx = false; $DbHost1 = $DbPort ? $DbHost . ":" . $DbPort : $DbHost; $ID = @mysql_connect($DbHost1, $DbUser, $DbPass); $SelectRes = @mysql_select_db($DbName, $ID); Set40Mode(); $Query = "SELECT ID FROM " . $DbPref . "_tracker_visitor_agent"; $Res = mysql_query($Query); if ($Res) { $Check = mysql_fetch_row($Res); if (ValidVar($Check[0])) { $AlreadyEx = true; } } if (!$AlreadyEx) { $f = fopen("robots.sql", "r"); $SQL = fread($f, filesize("robots.sql")); fclose($f); $SQL = str_replace("{PREF}", $DbPref, $SQL); $SQL = str_replace("{GRP_ID}", 15, $SQL); $SqlArr = split(";[\n\r]", $SQL); for ($i = 0; $i < count($SqlArr); $i++) { $SqlArr[$i] = trim($SqlArr[$i]); if ($SqlArr[$i] == "") { unset($SqlArr[$i]); }
$Report->WhereArr[] = "V.LAST_RESOLUTION != '' "; if (ValidVar($Filter)) { $Report->WhereArr[] = "V.LAST_RESOLUTION LIKE ('%{$Filter}%')"; } } if (ValidVar($GroupBy) == "Pixel") { $Report->SelectArr[] = "V.PIXEL_DEPTH"; $Report->SelectArr[] = "V.PIXEL_DEPTH AS NAME"; $Report->JoinArr[] = "INNER JOIN " . PFX . "_tracker_visitor V ON V.ID=S_LOG.VISITOR_ID"; $Report->GroupArr[] = "V.PIXEL_DEPTH"; $Report->GrpFld = "PIXEL_DEPTH"; $Report->GrpName = "PIXEL_DEPTH"; $Report->OrderArr[] = "{$DefaultOrderBy} {$OrderTo}"; $Report->WhereArr[] = "V.PIXEL_DEPTH != 0 "; if (ValidVar($Filter)) { $Report->WhereArr[] = "V.PIXEL_DEPTH LIKE ('%{$Filter}%')"; } } if (ValidVar($GroupBy) == "Flash") { $Report->SelectArr[] = "V.FLASH_VERSION"; $Report->SelectArr[] = "V.FLASH_VERSION AS NAME"; $Report->JoinArr[] = "INNER JOIN " . PFX . "_tracker_visitor V ON V.ID=S_LOG.VISITOR_ID"; $Report->GroupArr[] = "V.FLASH_VERSION"; $Report->GrpFld = "FLASH_VERSION"; $Report->GrpName = "FLASH_VERSION"; $Report->OrderArr[] = "{$DefaultOrderBy} {$OrderTo}"; $Report->WhereArr[] = "V.FLASH_VERSION != '' "; if (ValidVar($Filter)) { $Report->WhereArr[] = "V.FLASH_VERSION LIKE ('%{$Filter}%')"; } }
function SaveReport($SaveArr, $WhereArr) { global $Db, $Logs, $nsUser, $nsProduct, $NaturalConstPath, $PaidConstPath, $Lang; if (ValidVar($SaveArr['SaveMode']) == "NATURAL") { $OrderConstPath = $NaturalConstPath; $ConstPath = "natural_constructor"; } if (ValidVar($SaveArr['SaveMode']) == "PAID") { $OrderConstPath = $PaidConstPath; $ConstPath = "paid_constructor"; } if (!ValidVar($SaveArr['Name'])) { $Logs->Err($Lang['NameMustFill']); return; } if (ValidVar($SaveArr['SaveMode']) != "NATURAL" && ValidVar($SaveArr['SaveMode']) != "PAID") { $Logs->Err($Lang['SaveErr1']); return; } if (!ValidVar($SaveArr['GroupBy'])) { $Logs->Err($Lang['SaveErr1']); return; } foreach ($WhereArr as $i => $Row) { if (!isset($OrderConstPath[$Row['Mode']])) { $Logs->Err($Lang['SaveErr1']); return; } } if (ValidVar($SaveArr['ViewDate']) && !ValidDate($SaveArr['ViewDate']) || ValidVar($SaveArr['StartDate']) && !ValidDate($SaveArr['StartDate']) || ValidVar($SaveArr['EndDate']) && !ValidDate($SaveArr['EndDate'])) { $Logs->Err($Lang['ValidDates']); return; } $WhereArrStr = serialize($WhereArr); $CurrentDate = ValidVar($SaveArr['CurrentDate']) ? $SaveArr['CurrentDate'] : 0; $SaveMode = ValidVar($SaveArr['SaveMode']) ? $SaveArr['SaveMode'] : 0; $CpId = ValidVar($SaveArr['CpId']) ? $SaveArr['CpId'] : 0; $GroupBy = ValidVar($SaveArr['GroupBy']) ? $SaveArr['GroupBy'] : false; $DatesUsed = ValidVar($SaveArr['DatesUsed']) ? $SaveArr['DatesUsed'] : false; $ViewDate = ValidVar($SaveArr['ViewDate']) ? $SaveArr['ViewDate'] : false; $StartDate = ValidVar($SaveArr['StartDate']) ? $SaveArr['StartDate'] : false; $EndDate = ValidVar($SaveArr['EndDate']) ? $SaveArr['EndDate'] : false; $Filter = ValidVar($SaveArr['Filter']) ? $SaveArr['Filter'] : false; $Limit = ValidId($SaveArr['Limit']) ? $SaveArr['Limit'] : 0; $ShowAll = ValidVar($SaveArr['ShowAll']) ? $SaveArr['ShowAll'] : 0; $OrderBy = ValidVar($SaveArr['OrderBy']) ? $SaveArr['OrderBy'] : false; $OrderTo = ValidVar($SaveArr['OrderTo']) ? $SaveArr['OrderTo'] : "ASC"; $Name = ValidVar($SaveArr['Name']) ? addslashes($SaveArr['Name']) : false; $UserId = $nsUser->UserId(); $AddToMy = ValidVar($SaveArr['AddToMy']) ? $SaveArr['AddToMy'] : false; $Query = "\n\t\tINSERT INTO " . PFX . "_tracker_user_report \n\t\t\t(CONST_TYPE, COMPANY_ID, NAME, VIEW_DATE, START_DATE, END_DATE, FILTER, PAGE_LIMIT, SHOW_NO_REF, SORT_BY, SORT_ORDER, USE_CURRENT_DATE, GROUP_BY, WHERE_ARR)\n\t\t\tVALUES \n\t\t\t('{$SaveMode}', {$CpId}, '{$Name}', '{$ViewDate}', '{$StartDate}', '{$EndDate}', '{$Filter}', {$Limit}, '{$ShowAll}', '{$OrderBy}', '{$OrderTo}', '{$CurrentDate}', '{$GroupBy}', '{$WhereArrStr}')\n\t\t"; $Db->Query($Query); $NewId = $Db->LastInsertId; if ($AddToMy) { $Query = "INSERT INTO " . PFX . "_tracker_watch (USER_ID, REPORT_ID) VALUES ({$UserId}, {$NewId})"; $Db->Query($Query); } $nsProduct->Redir($ConstPath, "RUpd=1&ConstId={$NewId}&CpId=" . ValidVar($SaveArr['CpId']), "report"); }