function GetCampTree($ParentId = 0, $CompId = false)
{
if (!ValidId($ParentId)) {
return false;
}
global $Db, $Lang, $nsUser;
if ($CompId) {
$Where = " AND COMPANY_ID={$CompId} ";
} else {
$Where = "";
}
$Query = "SELECT * FROM " . PFX . "_tracker_campaign WHERE PARENT_ID = {$ParentId} AND COMPANY_ID={$CompId} ORDER BY NAME ASC";
$Sql = new Query($Query);
$Sql->ReadSkinConfig();
$CampArr = array();
while ($Row = $Sql->Row()) {
if ($Sql->Position > 0) {
$Row->_UP = true;
} else {
$Row->_UP = false;
}
$Row->_DOWN = true;
$Row->NAME = stripslashes($Row->NAME);
$Row->DESCRIPTION = stripslashes($Row->DESCRIPTION);
$Row->_STYLE = $Sql->_STYLE;
$SubCnt = $Db->CNT(PFX . "_tracker_campaign", "PARENT_ID=" . $Row->ID);
$Row->CHILD_COUNT = $SubCnt > 0 ? $SubCnt : 0;
$Row->_UPLINK = getURL("campaign", "SortId=" . $Row->ID . "&SortTo=Up&ParentId=" . $Row->PARENT_ID);
$Row->_DOWNLINK = getURL("campaign", "SortId=" . $Row->ID . "&SortTo=Down&ParentId=" . $Row->PARENT_ID);
if ($nsUser->Columns->ROI || $nsUser->Columns->CONVERSIONS) {
$Row->Report = new Paid_v2();
$Row->Report->GrpId = $Row->ID;
$Row->Report->CpId = $Row->COMPANY_ID;
$Row->Report->ShowPerClick = true;
$Row->Report->ShowTotalCost = true;
$Row->Report->DisableAll();
if ($nsUser->Columns->ROI) {
$Row->Report->ShowROI = true;
}
if ($nsUser->Columns->CONVERSIONS) {
$Row->Report->ShowActionConv = true;
}
if ($nsUser->Columns->CONVERSIONS) {
$Row->Report->ShowSaleConv = true;
}
$Row->Report->Calculate();
//Dump($Row->Report);
$Row->CampStat =& $Row->Report->CampStat;
}
$Row->_MOVE = true;
$CampArr[$Sql->Position] = $Row;
$PrevRow =& $CampArr[$Sql->Position];
}
$PrevRow->_DOWN = false;
if (count($CampArr) < 1) {
return false;
}
//if (count($CampArr)==1) $PrevRow->_MOVE=false;
return $CampArr;
}
function GetPiecesList()
{
global $Get, $CurrentCompany, $Lang, $nsUser;
$InCampArr = array();
$Query = "\n\t\tSELECT \n\t\t\tTCP.*,\n\t\t\tTST.ID AS SPLIT_TEST\n\t\t\tFROM " . PFX . "_tracker_camp_piece TCP\n\t\t\tINNER JOIN " . PFX . "_tracker_split_test TST\n\t\t\t\tON TST.SUB_ID=TCP.ID\n\t\t\tWHERE TST.COMPANY_ID=" . $CurrentCompany->ID . "\n\t\t\tORDER BY TCP.NAME\n\t";
$Sql = new Query($Query);
$Sql->ReadSkinConfig();
while ($Row = $Sql->Row()) {
if (!$Row->COMPANY_ID) {
continue;
}
$Row->NAME = stripslashes($Row->NAME);
$Row->DESCRIPTION = stripslashes($Row->DESCRIPTION);
$Row->_EDITLINK = getURL("split_test", "EditId=" . $Row->ID);
$Row->_CODELINK = getURL("campaign_link", "SplitId=" . $Row->ID);
$Row->_DELETELINK = getURL("split_test", "DeleteId=" . $Row->ID);
//$Row->_TYPE=$Lang['SplitTest'];
$Row->_STAT_LINK = getURL("split_test", "SplitId=" . $Row->ID, "report");
$Row->Report = new SplitStat_v2();
$Row->Report->SplitId = $Row->ID;
$Row->Report->CpId = $Row->COMPANY_ID;
$Row->Report->DisableAll();
if ($nsUser->Columns->CLICKS) {
$Row->Report->ShowVisitors = true;
}
if ($nsUser->Columns->CONVERSIONS) {
$Row->Report->ShowActionConv = true;
}
if ($nsUser->Columns->CONVERSIONS) {
$Row->Report->ShowSaleConv = true;
}
$Row->Report->Calculate();
$Row->SplitStat =& $Row->Report->SplitStat;
$Row->_STYLE = $Sql->_STYLE;
$InCampArr[$Sql->Position] = $Row;
$PrevRow =& $InCampArr[$Sql->Position];
}
if (count($InCampArr) > 0) {
return $InCampArr;
} else {
return false;
}
}
}
}
/////////////////////////////////////////////
///////// display section here
$IpList = array();
$Query = "SELECT * FROM " . PFX . "_tracker_ip WHERE IGNORED = '1' ORDER BY IP ASC";
$Sql = new Query($Query);
$Sql->ReadSkinConfig();
while ($Row = $Sql->Row()) {
$Row->_STYLE = $Sql->_STYLE;
$Row->TEMPLATE = false;
$IpList[] = $Row;
}
$Query = "SELECT * FROM " . PFX . "_tracker_ip_ignore ORDER BY TEMPLATE ASC";
$Sql = new Query($Query);
$Sql->ReadSkinConfig();
while ($Row = $Sql->Row()) {
$Row->IP = $Row->TEMPLATE;
$Row->_STYLE = $Sql->_STYLE;
$IpList[] = $Row;
}
include $nsTemplate->Inc();
/////////////////////////////////////////////
///////// process functions here
function AddNewIp($IP, $Descr = false)
{
global $Db, $nsProduct;
if (!$Descr) {
$Descr = "";
}
$Query = "SELECT ID FROM " . PFX . "_tracker_ip WHERE IP='{$IP}'";
function GetPiecesList()
{
global $Get, $CampId, $Lang, $nsUser;
$InCampArr = array();
$Query = "\n\t\tSELECT \n\t\t\tTCP.*,\n\t\t\tTSC.ID AS SUB_CAMP,\n\t\t\tTST.ID AS SPLIT_TEST\n\t\t\tFROM " . PFX . "_tracker_camp_piece TCP\n\t\t\t\tLEFT JOIN " . PFX . "_tracker_sub_campaign TSC\n\t\t\t\t\tON TSC.SUB_ID=TCP.ID\n\t\t\t\tLEFT JOIN " . PFX . "_tracker_split_test TST\n\t\t\t\t\tON TST.SUB_ID=TCP.ID\n\t\t\tWHERE CAMPAIGN_ID={$CampId} \n\t\t\tORDER BY TCP.NAME\n\t";
$Sql = new Query($Query);
$Sql->ReadSkinConfig();
$i = 0;
while ($Row = $Sql->Row()) {
$Row->NAME = stripslashes($Row->NAME);
$Row->DESCRIPTION = stripslashes($Row->DESCRIPTION);
if ($Row->SUB_CAMP) {
$Row->_EDITLINK = getURL("sub_camp", "EditId=" . $Row->ID);
$Row->_CODELINK = getURL("campaign_link", "CampId=" . $Row->ID);
$Row->_DELETELINK = getURL("sub_camp", "GrpId={$CampId}&DeleteId=" . $Row->ID);
$Row->_TYPE = $Lang['Campaign'];
$Row->_STAT_LINK = getURL("paid_constructor", "CampId=" . $Row->ID, "report");
$Row->Report = new Paid_v2();
$Row->Report->CampId = $Row->ID;
$Row->Report->CpId = $Row->COMPANY_ID;
$Row->Report->ShowPerClick = true;
$Row->Report->ShowTotalCost = true;
$Row->Report->DisableAll();
if ($nsUser->Columns->ROI) {
$Row->Report->ShowROI = true;
}
if ($nsUser->Columns->CONVERSIONS) {
$Row->Report->ShowActionConv = true;
}
if ($nsUser->Columns->CONVERSIONS) {
$Row->Report->ShowSaleConv = true;
}
$Row->Report->Calculate();
$Row->CampStat =& $Row->Report->CampStat;
}
if ($Row->SPLIT_TEST) {
$Row->_EDITLINK = getURL("split_test", "EditId=" . $Row->ID);
$Row->_CODELINK = getURL("campaign_link", "SplitId=" . $Row->ID);
$Row->_DELETELINK = getURL("split_test", "GrpId={$CampId}&DeleteId=" . $Row->ID);
$Row->_TYPE = $Lang['SplitTest'];
$Row->_STAT_LINK = getURL("split_test", "SplitId=" . $Row->ID, "report");
$Row->Report = new SplitStat_v2();
$Row->Report->SplitId = $Row->ID;
$Row->Report->CpId = $Row->COMPANY_ID;
$Row->Report->DisableAll();
if ($nsUser->Columns->CLICKS) {
$Row->Report->ShowVisitors = true;
}
if ($nsUser->Columns->CONVERSIONS) {
$Row->Report->ShowActionConv = true;
}
if ($nsUser->Columns->CONVERSIONS) {
$Row->Report->ShowSaleConv = true;
}
$Row->Report->Calculate();
$Row->SplitStat =& $Row->Report->SplitStat;
}
if (!$Row->SUB_CAMP && !$Row->SPLIT_TEST) {
continue;
}
$Row->_STYLE = $Sql->_STYLE;
$InCampArr[$i] = $Row;
$PrevRow =& $InCampArr[$i];
$i++;
}
$PrevRow->_DOWN = false;
if (count($InCampArr) > 0) {
return $InCampArr;
} else {
return false;
}
}
function GetSplitPages($Id)
{
$PagesArr = array();
$Query = "\n\t\tSELECT TS.*, SI.HOST, TQ.QUERY_STRING, TSP.ID AS TSP_ID, \n\t\t\tTSP.FULL_PATH\n\t\t\tFROM " . PFX . "_tracker_split_page TSP\n\t\t\tINNER JOIN " . PFX . "_tracker_site_page TS\n\t\t\t\tON TS.ID=TSP.PAGE_ID\n\t\t\tINNER JOIN " . PFX . "_tracker_site SI \n\t\t\t\tON SI.ID = TS.SITE_ID\n\t\t\tLEFT JOIN " . PFX . "_tracker_query TQ\n\t\t\t\tON TQ.ID=TSP.QUERY_ID\n\t\t\tWHERE SPLIT_ID={$Id}\n\t";
$Sql = new Query($Query);
$Sql->ReadSkinConfig();
while ($Row = $Sql->Row()) {
$Row->SCHEME = "";
if ($Row->FULL_PATH) {
$Check = parse_url($Row->FULL_PATH);
$Row->SCHEME = $Check['scheme'] . "://";
$Row->HOST = $Check['host'];
}
$Row->PATH = $Row->SCHEME . $Row->HOST . "<br>" . $Row->PATH;
if ($Row->QUERY_STRING) {
$Row->PATH .= "?" . $Row->QUERY_STRING;
}
$Row->_STYLE = $Sql->_STYLE;
$PagesArr[] = $Row;
}
if (count($PagesArr) > 0) {
return $PagesArr;
} else {
return false;
}
}
function GetHostsList($Id)
{
global $ShowExpand;
$HostsArr = array();
$Query = "SELECT * FROM " . PFX . "_tracker_site WHERE COMPANY_ID = {$Id} ORDER BY HOST";
$Sql = new Query($Query);
$Sql->ReadSkinConfig();
while ($Row = $Sql->Row()) {
$Row->_STYLE = $Sql->_STYLE;
$Row->Hosts = array();
if ($Row->USE_HOSTS) {
$ShowExpand += 1;
}
$Query = "SELECT * FROM " . PFX . "_tracker_site_host WHERE SITE_ID=" . $Row->ID . " ORDER BY HOST";
$SubSql = new Query($Query);
while ($SubRow = $SubSql->Row()) {
$Row->Hosts[] = $SubRow;
}
$HostsArr[] = $Row;
}
if (count($HostsArr) > 0) {
return $HostsArr;
} else {
return false;
}
}
