/**
* @todo Handle cases where user is not Admin, Agency or Advertiser
*/
function _getPublisherArray($orderBy = null)
{
$conf = $GLOBALS['_MAX']['CONF'];
if (OA_Permission::isAccount(OA_ACCOUNT_ADMIN)) {
$query = "SELECT affiliateid,name" . " FROM " . $conf['table']['prefix'] . $conf['table']['affiliates'];
} elseif (OA_Permission::isAccount(OA_ACCOUNT_MANAGER)) {
$query = "SELECT affiliateid,name" . " FROM " . $conf['table']['prefix'] . $conf['table']['affiliates'] . " WHERE agencyid=" . OA_Permission::getEntityId();
} elseif (OA_Permission::isAccount(OA_ACCOUNT_ADVERTISER)) {
$query = "SELECT affiliateid,name" . " FROM " . $conf['table']['prefix'] . $conf['table']['affiliates'] . " WHERE affiliateid=" . OA_Permission::getEntityId();
}
$orderBy ? $query .= " ORDER BY {$orderBy} ASC" : 0;
$res = phpAds_dbQuery($query);
while ($row = phpAds_dbFetchArray($res)) {
$affiliateArray[$row['affiliateid']] = phpAds_buildAffiliateName($row['affiliateid'], $row['name']);
}
return $affiliateArray;
}
/*********************************************************/
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);
}
/*********************************************************/
$extra .= "<b>{$strModifyZone}</b><br>";
$extra .= "<img src='images/break.gif' height='1' width='160' vspace='4'><br>";
$extra .= "<img src='images/icon-duplicate-zone.gif' align='absmiddle'> <a href='zone-modify.php?affiliateid=" . $affiliateid . "&zoneid=" . $zoneid . "&duplicate=true&returnurl=zone-advanced.php'>{$strDuplicate}</a><br>";
$extra .= "<img src='images/break.gif' height='1' width='160' vspace='4'><br>";
$extra .= "<img src='images/icon-move-zone.gif' align='absmiddle'> {$strMoveTo}<br>";
$extra .= "<img src='images/spacer.gif' height='1' width='160' vspace='2'><br>";
$extra .= " ";
$extra .= "<select name='moveto' style='width: 110;'>";
if (phpAds_isUser(phpAds_Admin)) {
$query = "SELECT affiliateid,name" . " FROM " . $phpAds_config['tbl_affiliates'] . " WHERE affiliateid != " . $affiliateid;
} elseif (phpAds_isUser(phpAds_Agency)) {
$query = "SELECT affiliateid,name" . " FROM " . $phpAds_config['tbl_affiliates'] . " WHERE affiliateid != " . $affiliateid . " AND agencyid=" . phpAds_getUserID();
}
$res = phpAds_dbQuery($query) or phpAds_sqlDie();
while ($row = phpAds_dbFetchArray($res)) {
$extra .= "<option value='" . $row['affiliateid'] . "'>" . phpAds_buildAffiliateName($row['affiliateid'], $row['name']) . "</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='zone-delete.php?affiliateid={$affiliateid}&zoneid={$zoneid}&returnurl=affiliate-zones.php'" . phpAds_DelConfirm($strConfirmDeleteZone) . ">{$strDelete}</a><br>";
$extra .= "</form>";
phpAds_PageHeader("4.2.3.6", $extra);
echo "<img src='images/icon-affiliate.gif' align='absmiddle'> " . phpAds_getAffiliateName($affiliateid);
echo " <img src='images/" . $phpAds_TextDirection . "/caret-rs.gif'> ";
echo "<img src='images/icon-zone.gif' align='absmiddle'> <b>" . phpAds_getZoneName($zoneid) . "</b><br><br><br>";
phpAds_ShowSections(array("4.2.3.2", "4.2.3.6", "4.2.3.3", "4.2.3.4", "4.2.3.5"));
} else {
$sections[] = "2.1.2";
$sections[] = "2.1.6";
if (phpAds_isAllowed(phpAds_LinkBanners)) {
$sections[] = "2.1.3";
/**
* Gets list of other publishers and set a menu page context variable with them
* Can be easily reused across inventory->publishers pages
*
* TODO: Consider reading page name from automatically instead of passing it as a parameter
*
* @static
* @param integer $affiliateid Affiliate ID
* @param string $pageName
* @param string $sortPageName
*/
function setPublisherPageContext($affiliateid, $pageName, $sortPageName = 'website-index.php')
{
$doAffiliates = OA_Dal::factoryDO('affiliates');
$doAffiliates->agencyid = OA_Permission::getAgencyId();
if (OA_Permission::isAccount(OA_ACCOUNT_TRAFFICKER)) {
$doAffiliates->affiliateid = $affiliateid;
}
$doAffiliates->addSessionListOrderBy($sortPageName);
$doAffiliates->find();
while ($doAffiliates->fetch()) {
phpAds_PageContext(phpAds_buildAffiliateName($doAffiliates->affiliateid, $doAffiliates->name), "{$pageName}?affiliateid=" . $doAffiliates->affiliateid, $affiliateid == $doAffiliates->affiliateid);
}
}
phpAds_registerGlobal('period', 'start', 'limit', 'source');
// Security check
phpAds_checkAccess(phpAds_Admin + phpAds_Affiliate);
/*********************************************************/
/* Affiliate interface security */
/*********************************************************/
if (phpAds_isUser(phpAds_Affiliate)) {
$affiliateid = phpAds_getUserID();
}
/*********************************************************/
/* HTML framework */
/*********************************************************/
if (phpAds_isUser(phpAds_Admin)) {
$res = phpAds_dbQuery("\n\t\tSELECT\n\t\t\t*\n\t\tFROM\n\t\t\t" . $phpAds_config['tbl_affiliates'] . "\n\t") or phpAds_sqlDie();
while ($row = phpAds_dbFetchArray($res)) {
phpAds_PageContext(phpAds_buildAffiliateName($row['affiliateid'], $row['name']), "stats-affiliate-history.php?affiliateid=" . $row['affiliateid'], $affiliateid == $row['affiliateid']);
}
phpAds_PageShortcut($strAffiliateProperties, 'affiliate-edit.php?affiliateid=' . $affiliateid, 'images/icon-affiliate.gif');
phpAds_PageHeader("2.4.1");
echo "<img src='images/icon-affiliate.gif' align='absmiddle'> <b>" . phpAds_getAffiliateName($affiliateid) . "</b><br><br><br>";
phpAds_ShowSections(array("2.4.1", "2.4.2"));
} else {
phpAds_PageHeader("1.2");
if ($phpAds_config['client_welcome']) {
echo "<br><br>";
// Show welcome message
if (!empty($phpAds_client_welcome_msg)) {
echo $phpAds_client_welcome_msg;
} else {
include 'templates/welcome-publisher.html';
}
function phpAds_getAffiliateArray()
{
global $phpAds_config;
$res = phpAds_dbQuery("\n\t\tSELECT\n\t\t\t*\n\t\tFROM\n\t\t\t" . $phpAds_config['tbl_affiliates'] . "\n\t");
while ($row = phpAds_dbFetchArray($res)) {
$affiliateArray[$row['affiliateid']] = phpAds_buildAffiliateName($row['affiliateid'], $row['name']);
}
return $affiliateArray;
}
function phpAds_getKeywordsArray()
{
global $phpAds_config;
if (phpAds_isUser(phpAds_Admin)) {
$query = "SELECT affiliateid,name" . " FROM " . $phpAds_config['tbl_affiliates'];
} elseif (phpAds_isUser(phpAds_Agency)) {
$query = "SELECT affiliateid,name" . " FROM " . $phpAds_config['tbl_affiliates'] . " WHERE agencyid=" . phpAds_getUserID();
} elseif (phpAds_isUser(phpAds_Client)) {
$query = "SELECT affiliateid,name" . " FROM " . $phpAds_config['tbl_affiliates'] . " WHERE affiliateid=" . phpAds_getUserID();
}
$res = phpAds_dbQuery($query);
while ($row = phpAds_dbFetchArray($res)) {
$affiliateArray[$row['affiliateid']] = phpAds_buildAffiliateName($row['affiliateid'], $row['name']);
}
return $affiliateArray;
}
