phpAds_PageShortcut($strModifyBannerAcl, 'banner-acl.php?clientid=' . $clientid . '&campaignid=' . $campaignid . '&bannerid=' . $bannerid, 'images/icon-acl.gif');
phpAds_PageHeader("2.1.2.2.2");
echo "<img src='images/icon-client.gif' align='absmiddle'> " . phpAds_getParentName($campaignid);
echo " <img src='images/" . $phpAds_TextDirection . "/caret-rs.gif'> ";
echo "<img src='images/icon-campaign.gif' align='absmiddle'> " . phpAds_getClientName($campaignid);
echo " <img src='images/" . $phpAds_TextDirection . "/caret-rs.gif'> ";
echo "<img src='images/icon-banner-stored.gif' align='absmiddle'> <b>" . phpAds_getBannerName($bannerid) . "</b><br><br>";
echo phpAds_buildBannerCode($bannerid) . "<br><br><br><br>";
phpAds_ShowSections(array("2.1.2.2.1", "2.1.2.2.2"));
/*********************************************************/
/* Main code */
/*********************************************************/
$manual['clicks'] = 0;
$manual['views'] = 0;
// Get affiliates and build the tree
$res_affiliates = phpAds_dbQuery("\n\tSELECT \n\t\taffiliateid, name\n\tFROM \n\t\t" . $phpAds_config['tbl_affiliates'] . "\n\t" . phpAds_getAffiliateListOrder($listorder, $orderdirection) . "\n\t") or phpAds_sqlDie();
while ($row_affiliates = phpAds_dbFetchArray($res_affiliates)) {
$affiliates[$row_affiliates['affiliateid']] = $row_affiliates;
$affiliates[$row_affiliates['affiliateid']]['expand'] = 0;
$affiliates[$row_affiliates['affiliateid']]['count'] = 0;
}
// Get the zones for each affiliate
$res_zones = phpAds_dbQuery("\n\tSELECT \n\t\tzoneid, affiliateid, zonename, delivery, what\n\tFROM \n\t\t" . $phpAds_config['tbl_zones'] . "\n\t\t" . phpAds_getZoneListOrder($listorder, $orderdirection) . "\n\t") or phpAds_sqlDie();
while ($row_zones = phpAds_dbFetchArray($res_zones)) {
if (isset($affiliates[$row_zones['affiliateid']])) {
$zones[$row_zones['zoneid']] = $row_zones;
$affiliates[$row_zones['affiliateid']]['count']++;
$zones[$row_zones['zoneid']]['views'] = 0;
$zones[$row_zones['zoneid']]['clicks'] = 0;
}
}
/*********************************************************/
/* HTML framework */
/*********************************************************/
if (phpAds_isUser(phpAds_Admin)) {
if (isset($Session['prefs']['affiliate-index.php']['listorder'])) {
$navorder = $Session['prefs']['affiliate-index.php']['listorder'];
} else {
$navorder = '';
}
if (isset($Session['prefs']['affiliate-index.php']['orderdirection'])) {
$navdirection = $Session['prefs']['affiliate-index.php']['orderdirection'];
} else {
$navdirection = '';
}
// Get other affiliates
$res = phpAds_dbQuery("\n\t\tSELECT\n\t\t\t*\n\t\tFROM\n\t\t\t" . $phpAds_config['tbl_affiliates'] . "\n\t\t" . phpAds_getAffiliateListOrder($navorder, $navdirection) . "\n\t") or phpAds_sqlDie();
while ($row = phpAds_dbFetchArray($res)) {
phpAds_PageContext(phpAds_buildAffiliateName($row['affiliateid'], $row['name']), "affiliate-zones.php?affiliateid=" . $row['affiliateid'], $affiliateid == $row['affiliateid']);
}
phpAds_PageShortcut($strAffiliateHistory, 'stats-affiliate-history.php?affiliateid=' . $affiliateid, 'images/icon-statistics.gif');
phpAds_PageHeader("4.2.3");
echo "<img src='images/icon-affiliate.gif' align='absmiddle'> <b>" . phpAds_getAffiliateName($affiliateid) . "</b><br><br><br>";
phpAds_ShowSections(array("4.2.2", "4.2.3"));
} else {
$sections[] = "2.1";
if (phpAds_isAllowed(phpAds_ModifyInfo)) {
$sections[] = "2.2";
}
phpAds_PageHeader("2.1");
echo "<img src='images/icon-affiliate.gif' align='absmiddle'> <b>" . phpAds_getAffiliateName($affiliateid) . "</b><br><br><br>";
phpAds_ShowSections($sections);
if (phpAds_isUser(phpAds_Admin) || phpAds_isUser(phpAds_Agency)) {
if (isset($Session['prefs']['affiliate-index.php']['listorder'])) {
$navorder = $Session['prefs']['affiliate-index.php']['listorder'];
} else {
$navorder = '';
}
if (isset($Session['prefs']['affiliate-index.php']['orderdirection'])) {
$navdirection = $Session['prefs']['affiliate-index.php']['orderdirection'];
} else {
$navdirection = '';
}
// Get other affiliates
if (phpAds_isUser(phpAds_Admin)) {
$query = "SELECT * FROM " . $phpAds_config['tbl_affiliates'] . phpAds_getAffiliateListOrder($navorder, $navdirection);
} elseif (phpAds_isUser(phpAds_Affiliate)) {
$query = "SELECT * FROM " . $phpAds_config['tbl_affiliates'] . " WHERE agencyid=" . $Session['userid'] . phpAds_getAffiliateListOrder($navorder, $navdirection);
}
$res = phpAds_dbQuery($query) or phpAds_sqlDie();
while ($row = phpAds_dbFetchArray($res)) {
phpAds_PageContext(phpAds_buildAffiliateName($row['affiliateid'], $row['name']), "affiliate-edit.php?affiliateid=" . $row['affiliateid'], $affiliateid == $row['affiliateid']);
}
phpAds_PageShortcut($strAffiliateHistory, 'stats-affiliate-history.php?affiliateid=' . $affiliateid, 'images/icon-statistics.gif');
phpAds_PageHeader("4.2.2");
echo "<img src='images/icon-affiliate.gif' align='absmiddle'> <b>" . phpAds_getAffiliateName($affiliateid) . "</b><br><br><br>";
phpAds_ShowSections(array("4.2.2", "4.2.3"));
} else {
phpAds_PageHeader("2.2");
echo "<img src='images/icon-affiliate.gif' align='absmiddle'> <b>" . phpAds_getAffiliateName($affiliateid) . "</b><br><br><br>";
phpAds_ShowSections(array("2.1", "2.2"));
}
// Do not get this information if the page
echo "<img src='images/icon-campaign.gif' align='absmiddle'> " . phpAds_getCampaignName($campaignid);
echo " <img src='images/" . $phpAds_TextDirection . "/caret-rs.gif'> ";
echo "<img src='images/icon-banner-stored.gif' align='absmiddle'> <b>" . phpAds_getBannerName($bannerid) . "</b><br><br>";
echo phpAds_buildBannerCode($bannerid) . "<br><br><br><br>";
phpAds_ShowSections($sections);
/*********************************************************/
/* Main code */
/*********************************************************/
// Get banner info
$res = phpAds_dbQuery("SELECT * FROM " . $phpAds_config['tbl_banners'] . " WHERE bannerid=" . $bannerid) or phpAds_sqlDie();
$banner = phpAds_dbFetchArray($res);
// Get affiliates
if (phpAds_isUser(phpAds_Admin)) {
$query = "SELECT affiliateid,name" . " FROM " . $phpAds_config['tbl_affiliates'] . phpAds_getAffiliateListOrder($listorder, $orderdirection);
} elseif (phpAds_isUser(phpAds_Agency)) {
$query = "SELECT affiliateid,name" . " FROM " . $phpAds_config['tbl_affiliates'] . " WHERE agencyid=" . phpAds_getUserID() . phpAds_getAffiliateListOrder($listorder, $orderdirection);
}
$res = phpAds_dbQuery($query) or phpAds_sqlDie();
$affiliate_count = phpAds_dbNumRows($res);
while ($row = phpAds_dbFetchArray($res)) {
$affiliates[$row['affiliateid']] = $row;
$affiliates[$row['affiliateid']]['ZoneBanners'] = 0;
$affiliates[$row['affiliateid']]['ZoneCampaigns'] = 0;
}
if ($banner['contenttype'] == 'txt') {
// Get banner zones
if (phpAds_isUser(phpAds_Admin)) {
$query = " SELECT zoneid,affiliateid,zonename,description,width,height,what,zonetype,delivery" . " FROM " . $phpAds_config['tbl_zones'] . " WHERE delivery=" . phpAds_ZoneText . " AND zonetype = " . phpAds_ZoneBanners . phpAds_getZoneListOrder($listorder, $orderdirection);
} elseif (phpAds_isUser(phpAds_Admin)) {
$query = " SELECT zoneid,affiliateid,zonename,description,width,height,what,zonetype,delivery" . " FROM " . $phpAds_config['tbl_zones'] . "," . $phpAds_config['tbl_affiliates'] . " WHERE " . $phpAds_config['tbl_zones'] . ".affiliateid=" . $phpAds_config['tbl_affiliates'] . ".affiliateid" . " AND " . $phpAds_config['tbl_affiliates'] . ".agencyid=" . phpAds_getUserID() . " AND delivery=" . phpAds_ZoneText . " AND zonetype = " . phpAds_ZoneBanners . phpAds_getZoneListOrder($listorder, $orderdirection);
}
while ($row = phpAds_dbFetchArray($res)) {
$extra .= "<option value='" . $row['clientid'] . "'>" . phpAds_buildName($row['clientid'], $row['clientname']) . "</option>";
}
$extra .= "</select> <input type='image' src='images/" . $phpAds_TextDirection . "/go_blue.gif'><br>";
$extra .= "<img src='images/break.gif' height='1' width='160' vspace='4'><br>";
$extra .= "<img src='images/icon-recycle.gif' align='absmiddle'> <a href='campaign-delete.php?clientid=" . $clientid . "&campaignid=" . $campaignid . "&returnurl=advertiser-index.php'" . phpAds_DelConfirm($strConfirmDeleteCampaign) . ">{$strDelete}</a><br>";
$extra .= "</form>";
phpAds_PageHeader("4.1.3.4", $extra);
echo "<img src='images/icon-advertiser.gif' align='absmiddle'> " . phpAds_getParentClientName($campaignid);
echo " <img src='images/" . $phpAds_TextDirection . "/caret-rs.gif'> ";
echo "<img src='images/icon-campaign.gif' align='absmiddle'> <b>" . phpAds_getCampaignName($campaignid) . "</b><br><br><br>";
phpAds_ShowSections(array("4.1.3.2", "4.1.3.3", "4.1.3.4", "4.1.3.5"));
/*********************************************************/
/* Main code */
/*********************************************************/
$res = phpAds_dbQuery("SELECT affiliateid,name" . " FROM " . $phpAds_config['tbl_affiliates'] . " WHERE agencyid=" . $agencyid . phpAds_getAffiliateListOrder($listorder, $orderdirection)) or phpAds_sqlDie();
$affiliate_count = phpAds_dbNumRows($res);
while ($row = phpAds_dbFetchArray($res)) {
$affiliates[$row['affiliateid']] = $row;
}
$res = phpAds_dbQuery("SELECT z.zoneid,z.affiliateid,z.zonename,z.description,z.width,z.height,z.what,z.delivery" . " FROM " . $phpAds_config['tbl_zones'] . " AS z" . "," . $phpAds_config['tbl_affiliates'] . " AS a" . " WHERE z.affiliateid=a.affiliateid" . " AND agencyid=" . $agencyid . " AND zonetype=" . phpAds_ZoneCampaign . phpAds_getZoneListOrder($listorder, $orderdirection)) or phpAds_sqlDie();
$zone_count = phpAds_dbNumRows($res);
while ($row = phpAds_dbFetchArray($res)) {
if (isset($affiliates[$row['affiliateid']])) {
$row['linked'] = phpAds_IsCampaignInZone($campaignid, $row['zoneid'], $row['what']);
$affiliates[$row['affiliateid']]['zones'][$row['zoneid']] = $row;
}
}
$tabindex = 1;
echo "<br><br>";
echo "<table border='0' width='100%' cellpadding='0' cellspacing='0'>";
