}
}
if (isset($Session['prefs']['stats-global-advertiser.php']['nodes'])) {
$node_array = explode(",", $Session['prefs']['stats-global-advertiser.php']['nodes']);
} else {
$node_array = array();
}
/*********************************************************/
/* Main code */
/*********************************************************/
// Get clients & campaign and build the tree
if (phpAds_isUser(phpAds_Admin)) {
$res_clients = phpAds_dbQuery("SELECT clientid,clientname" . " FROM " . $phpAds_config['tbl_clients'] . phpAds_getClientListOrder($listorder, $orderdirection)) or phpAds_sqlDie();
$res_campaigns = phpAds_dbQuery("SELECT campaignid,campaignname,clientid,views,clicks,conversions,active" . " FROM " . $phpAds_config['tbl_campaigns'] . phpAds_getCampaignListOrder($listorder, $orderdirection)) or phpAds_sqlDie();
} elseif (phpAds_isUser(phpAds_Agency)) {
$res_clients = phpAds_dbQuery("SELECT clientid,clientname" . " FROM " . $phpAds_config['tbl_clients'] . " WHERE agencyid=" . phpAds_getUserID() . phpAds_getClientListOrder($listorder, $orderdirection)) or phpAds_sqlDie();
$res_campaigns = phpAds_dbQuery("SELECT m.campaignid as campaignid" . ",m.campaignname as campaignname" . ",m.clientid as clientid" . ",m.views as views" . ",m.clicks as clicks" . ",m.conversions as conversions" . ",m.active as active" . " FROM " . $phpAds_config['tbl_campaigns'] . " AS m" . "," . $phpAds_config['tbl_clients'] . " AS c" . " WHERE m.clientid=c.clientid" . " AND c.agencyid=" . phpAds_getUserID() . phpAds_getCampaignListOrder($listorder, $orderdirection)) or phpAds_sqlDie();
}
while ($row_clients = phpAds_dbFetchArray($res_clients)) {
$clients[$row_clients['clientid']] = $row_clients;
$clients[$row_clients['clientid']]['expand'] = 0;
$clients[$row_clients['clientid']]['count'] = 0;
$clients[$row_clients['clientid']]['hideinactive'] = 0;
}
while ($row_campaigns = phpAds_dbFetchArray($res_campaigns)) {
$campaigns[$row_campaigns['campaignid']] = $row_campaigns;
$campaigns[$row_campaigns['campaignid']]['expand'] = 0;
$campaigns[$row_campaigns['campaignid']]['count'] = 0;
}
switch ($period) {
case 't':
$query = "SELECT clientid" . " FROM " . $phpAds_config['tbl_clients'] . " WHERE clientid=" . $clientid . " AND agencyid=" . phpAds_getUserID();
$res = phpAds_dbQuery($query) or phpAds_sqlDie();
if (phpAds_dbNumRows($res) == 0) {
phpAds_PageHeader("2");
phpAds_Die($strAccessDenied, $strNotAdmin);
}
}
}
/*********************************************************/
/* HTML framework */
/*********************************************************/
if (phpAds_isUser(phpAds_Admin) || phpAds_isUser(phpAds_Agency)) {
if (phpAds_isUser(phpAds_Admin)) {
$query = "SELECT clientid,clientname" . " FROM " . $phpAds_config['tbl_clients'] . phpAds_getClientListOrder($navorder, $navdirection);
} elseif (phpAds_isUser(phpAds_Agency)) {
$query = "SELECT clientid,clientname" . " FROM " . $phpAds_config['tbl_clients'] . " WHERE agencyid=" . phpAds_getUserID() . phpAds_getClientListOrder($navorder, $navdirection);
}
$res = phpAds_dbQuery($query) or phpAds_sqlDie();
while ($row = phpAds_dbFetchArray($res)) {
phpAds_PageContext(phpAds_buildName($row['clientid'], $row['clientname']), "stats-advertiser-history.php?clientid=" . $row['clientid'], $clientid == $row['clientid']);
}
phpAds_PageShortcut($strClientProperties, 'advertiser-edit.php?clientid=' . $clientid, 'images/icon-advertiser.gif');
if (phpAds_isUser(phpAds_Admin)) {
$extra = "<br><br><br>";
$extra .= "<b>{$strMaintenance}</b><br>";
$extra .= "<img src='images/break.gif' height='1' width='160' vspace='4'><br>";
$extra .= "<a href='stats-reset.php?clientid={$clientid}'" . phpAds_DelConfirm($strConfirmResetClientStats) . ">";
$extra .= "<img src='images/" . $phpAds_TextDirection . "/icon-undo.gif' align='absmiddle' border='0'> {$strResetStats}</a>";
$extra .= "<br><br>";
}
phpAds_PageHeader("2.1.1", $extra);
if (phpAds_isUser(phpAds_Admin) || phpAds_isUser(phpAds_Agency)) {
if (isset($Session['prefs']['advertiser-index.php']['listorder'])) {
$navorder = $Session['prefs']['advertiser-index.php']['listorder'];
} else {
$navorder = '';
}
if (isset($Session['prefs']['advertiser-index.php']['orderdirection'])) {
$navdirection = $Session['prefs']['advertiser-index.php']['orderdirection'];
} else {
$navdirection = '';
}
// Get other advertisers
if (phpAds_isUser(phpAds_Admin)) {
$query = "SELECT * FROM " . $phpAds_config['tbl_clients'] . phpAds_getClientListOrder($navorder, $navdirection);
} elseif (phpAds_isUser(phpAds_Agency)) {
$query = "SELECT * FROM " . $phpAds_config['tbl_clients'] . " WHERE agencyid=" . $Session['userid'] . phpAds_getClientListOrder($navorder, $navdirection);
}
$res = phpAds_dbQuery($query) or phpAds_sqlDie();
while ($row = phpAds_dbFetchArray($res)) {
phpAds_PageContext(phpAds_buildName($row['clientid'], $row['clientname']), "advertiser-trackers.php?clientid=" . $row['clientid'], $clientid == $row['clientid']);
}
phpAds_PageShortcut($strClientHistory, 'stats-advertiser-history.php?clientid=' . $clientid, 'images/icon-statistics.gif');
phpAds_PageHeader("4.1.4");
echo "\t\t\t\t<img src='images/icon-advertiser.gif' align='absmiddle'> \n";
echo "\t\t\t\t<b>" . phpAds_getClientName($clientid) . "</b>\n";
echo "\t\t\t\t<br><br><br>\n";
phpAds_ShowSections(array("4.1.2", "4.1.3", "4.1.4"));
}
/*********************************************************/
/* Main code */
/*********************************************************/