function getZones()
{
global $list_filters;
if (OA_Permission::isAccount(OA_ACCOUNT_ADMIN)) {
$aParams = array();
$aPublishers = Admin_DA::getPublishers($aParams);
// set publisher id if list is to be filtered by publisher
if (isset($list_filters['publisher'])) {
$aParams = array('publisher_id' => $list_filters['publisher']);
} else {
// else use all publishers
$aParams = array('publisher_id' => implode(',', array_keys($aPublishers)));
}
if (isset($this->_filter)) {
$aParams['zone_inventory_forecast_type'] = $this->getForecastType();
}
$aZones = Admin_DA::getZones($aParams);
} elseif (OA_Permission::isAccount(OA_ACCOUNT_MANAGER)) {
$aParams = array('agency_id' => OA_Permission::getEntityId());
$aPublishers = Admin_DA::getPublishers($aParams);
// set publisher id if list is to be filtered by publisher
if (isset($list_filters['publisher'])) {
$aParams = array('publisher_id' => $list_filters['publisher']);
} else {
// else use all of this agency's publishers
$aParams = array('publisher_id' => implode(',', array_keys($aPublishers)));
}
if (isset($this->_filter)) {
$aParams['zone_inventory_forecast_type'] = $this->getForecastType();
}
$aZones = Admin_DA::getZones($aParams);
} elseif (OA_Permission::isAccount(OA_ACCOUNT_TRAFFICKER)) {
$aParams = array('publisher_id' => OA_Permission::getEntityId());
$aPublishers = Admin_DA::getPublishers($aParams);
$aParams = array('publisher_id' => implode(',', array_keys($aPublishers)));
if (isset($this->_filter)) {
$aParams['zone_inventory_forecast_type'] = $this->getForecastType();
}
$aZones = Admin_DA::getZones($aParams);
} else {
$aPublishers = array();
$aZones = array();
}
$aZoneArray = array();
foreach ($aPublishers as $publisherId => $aPublisher) {
foreach ($aZones as $zoneId => $aZone) {
if ($aZone['publisher_id'] == $publisherId) {
$aZoneArray[$zoneId] = phpads_buildName($publisherId, MAX_getPublisherName($aPublisher['name'])) . " - " . phpAds_buildName($zoneId, MAX_getZoneName($aZone['name']));
}
}
}
return $aZoneArray;
}
function _getAdvertiserArray($orderBy = null)
{
$conf = $GLOBALS['_MAX']['CONF'];
if (OA_Permission::isAccount(OA_ACCOUNT_ADMIN)) {
$query = "SELECT clientid,clientname" . " FROM " . $conf['table']['prefix'] . $conf['table']['clients'];
} elseif (OA_Permission::isAccount(OA_ACCOUNT_MANAGER)) {
$query = "SELECT clientid,clientname" . " FROM " . $conf['table']['prefix'] . $conf['table']['clients'] . " WHERE agencyid=" . OA_Permission::getEntityId();
} elseif (OA_Permission::isAccount(OA_ACCOUNT_ADVERTISER)) {
$query = "SELECT clientid,clientname" . " FROM " . $conf['table']['prefix'] . $conf['table']['clients'] . " WHERE clientid=" . OA_Permission::getEntityId();
}
$orderBy ? $query .= " ORDER BY {$orderBy} ASC" : 0;
$res = phpAds_dbQuery($query);
while ($row = phpAds_dbFetchArray($res)) {
$clientArray[$row['clientid']] = phpAds_buildName($row['clientid'], $row['clientname']);
}
return $clientArray;
}
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);
echo "<img src='images/icon-advertiser.gif' align='absmiddle'> <b>" . phpAds_getClientName($clientid) . "</b><br><br><br>";
phpAds_ShowSections(array("2.1.1", "2.1.2"));
}
if (phpAds_isUser(phpAds_Client)) {
function setAgencyPageContext($agencyid, $pageName)
{
$doAgency = OA_Dal::factoryDO('agency');
$doAgency->find();
while ($doAgency->fetch()) {
phpAds_PageContext(phpAds_buildName($doAgency->agencyid, $doAgency->name), "{$pageName}?agencyid=" . $doAgency->agencyid, $agencyid == $doAgency->agencyid);
}
}
echo "<img src='images/icon-campaign.gif' align='absmiddle'> <b>" . phpAds_getCampaignName($campaignid) . "</b><br><br><br>";
phpAds_ShowSections(array("1.2.1", "1.2.2", "1.2.3", "1.2.4"));
} else {
phpAds_PageHeader("1");
phpAds_Die($strAccessDenied, $strNotAdmin);
}
}
if (phpAds_isUser(phpAds_Admin) || phpAds_isUser(phpAds_Agency)) {
if (phpAds_isUser(phpAds_Admin)) {
$query = "SELECT campaignid,campaignname" . " FROM " . $phpAds_config['tbl_campaigns'] . " WHERE clientid=" . $clientid . phpAds_getCampaignListOrder($navorder, $navdirection);
} elseif (phpAds_isUser(phpAds_Agency)) {
$query = "SELECT m.campaignid,m.campaignname" . " FROM " . $phpAds_config['tbl_campaigns'] . " AS m" . "," . $phpAds_config['tbl_clients'] . " AS c" . " WHERE m.clientid=c.clientid" . " AND m.clientid=" . $clientid . " AND c.agencyid=" . phpAds_getUserID() . phpAds_getCampaignListOrder($navorder, $navdirection);
}
$res = phpAds_dbQuery($query) or phpAds_sqlDie();
while ($row = phpAds_dbFetchArray($res)) {
phpAds_PageContext(phpAds_buildName($row['campaignid'], $row['campaignname']), "stats-campaign-target.php?clientid=" . $clientid . "&campaignid=" . $row['campaignid'], $campaignid == $row['campaignid']);
}
phpAds_PageShortcut($strClientProperties, 'advertiser-edit.php?clientid=' . $clientid, 'images/icon-advertiser.gif');
phpAds_PageShortcut($strCampaignProperties, 'campaign-edit.php?clientid=' . $clientid . '&campaignid=' . $campaignid, 'images/icon-campaign.gif');
phpAds_PageHeader("2.1.2.4");
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("2.1.2.1", "2.1.2.2", "2.1.2.3", "2.1.2.4", "2.1.2.5"));
}
/*********************************************************/
/* Main code */
/*********************************************************/
$lib_targetstats_params = array('clientid' => $clientid, 'campaignid' => $campaignid);
$lib_targetstats_where = "campaignid = '" . $campaignid . "'";
include "lib-targetstats.inc.php";
echo phpAds_buildBannerCode($bannerid) . "<br><br><br><br>";
phpAds_ShowSections($sections);
} else {
phpAds_PageHeader("1");
phpAds_Die($strAccessDenied, $strNotAdmin);
}
}
if (phpAds_isUser(phpAds_Admin) || phpAds_isUser(phpAds_Agency)) {
if (phpAds_isUser(phpAds_Admin)) {
$query = "SELECT campaignid,campaignname" . " FROM " . $phpAds_config['tbl_campaigns'] . " WHERE clientid = " . $clientid . phpAds_getCampaignListOrder($navorder, $navdirection);
} elseif (phpAds_isUser(phpAds_Agency)) {
$query = "SELECT campaignid,campaignname" . " FROM " . $phpAds_config['tbl_campaigns'] . " WHERE clientid=" . $clientid . " AND agencyid=" . phpAds_getUserID() . phpAds_getCampaignListOrder($navorder, $navdirection);
}
$res = phpAds_dbQuery($query) or phpAds_sqlDie();
while ($row = phpAds_dbFetchArray($res)) {
phpAds_PageContext(phpAds_buildName($row['campaignid'], $row['campaignname']), "stats-banner-sources.php?clientid=" . $clientid . "&campaignid=" . $row['campaignid'], $campaignid == $row['campaignid']);
}
phpAds_PageShortcut($strClientProperties, 'advertiser-edit.php?clientid=' . $clientid, 'images/icon-advertiser.gif');
phpAds_PageShortcut($strCampaignProperties, 'campaign-edit.php?clientid=' . $clientid . '&campaignid=' . $campaignid, 'images/icon-campaign.gif');
phpAds_PageHeader("2.1.2.2.2");
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'> " . 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(array("2.1.2.2.1", "2.1.2.2.2"));
}
/*********************************************************/
/* Main code */
/*********************************************************/
/**
* Generate the HTML option
*
* @return string A string containing html for option
*/
function campaignid()
{
$conf = $GLOBALS['_MAX']['CONF'];
$mi =& $this->maxInvocation;
if ($mi->zone_invocation || OA_Permission::isAccount(OA_ACCOUNT_ADMIN)) {
return null;
}
$option = '';
// Display available campaigns...
$option .= "<tr bgcolor='#F6F6F6'><td width='30'> </td>\n";
$option .= "<td width='200'>" . $GLOBALS['strInvocationCampaignID'] . "</td><td width='370'>\n";
$option .= "<select name='campaignid' style='width:350px;' tabindex='" . $mi->tabindex++ . "'>\n";
$option .= "<option value='0'>-</option>\n";
if (OA_Permission::isAccount(OA_ACCOUNT_ADMIN)) {
$query = "SELECT campaignid,campaignname" . " FROM " . $conf['table']['prefix'] . $conf['table']['campaigns'];
} elseif (OA_Permission::isAccount(OA_ACCOUNT_MANAGER)) {
$query = "SELECT m.campaignid AS campaignid" . ",m.campaignname AS campaignname" . " FROM " . $conf['table']['prefix'] . $conf['table']['campaigns'] . " AS m" . "," . $conf['table']['prefix'] . $conf['table']['clients'] . " AS c" . " WHERE m.clientid=c.clientid" . " AND c.agencyid=" . OA_Permission::getAgencyId();
}
$oDbh = OA_DB::singleton();
$aResult = $oDbh->queryAll($query);
if (PEAR::isError($aResult)) {
$option .= "<option value='0'>'.{$aResult->getUserInfo}().'</option>\n";
} else {
foreach ($aResult as $k => $row) {
$option .= "<option value='" . $row['campaignid'] . "'" . ($mi->campaignid == $row['campaignid'] ? ' selected' : '') . ">";
$option .= phpAds_buildName($row['campaignid'], $row['campaignname']);
$option .= "</option>\n";
}
}
$option .= "</select>\n";
$option .= "</td></tr>";
$option .= "<tr bgcolor='#F6F6F6'><td height='10' colspan='3'> </td></tr>";
$option .= "<tr height='1'><td colspan='3' bgcolor='#888888'><img src='" . OX::assetPath() . "/images/break.gif' height='1' width='100%'></td></tr>";
$option .= "<tr><td height='10' colspan='3'> </td></tr>";
return $option;
}
function phpAds_SendMaintenanceReport($clientid, $first_unixtimestamp, $last_unixtimestamp, $update = true)
{
global $phpAds_config, $phpAds_CharSet, $date_format, $strBanner, $strCampaign, $strViews, $strClicks, $strConversions, $strLinkedTo, $strMailSubject, $strMailHeader, $strMailBannerStats, $strMailFooter, $strMailReportPeriod, $strMailReportPeriodAll, $strLogErrorBanners, $strLogErrorClients, $strLogErrorViews, $strLogErrorClicks, $strLogErrorConversions, $strNoStatsForCampaign, $strNoViewLoggedInInterval, $strNoClickLoggedInInterval, $strNoCampaignLoggedInInterval, $strTotal, $strTotalThisPeriod;
// Convert timestamps to SQL format
$last_sqltimestamp = date("YmdHis", $last_unixtimestamp);
$first_sqltimestamp = date("YmdHis", $first_unixtimestamp);
// Get Client information
$res_client = phpAds_dbQuery("SELECT" . " clientid" . ",clientname" . ",contact" . ",email" . ",language" . ",report" . ",reportinterval" . ",reportlastdate" . ",UNIX_TIMESTAMP(reportlastdate) AS reportlastdate_t" . " FROM " . $phpAds_config['tbl_clients'] . " WHERE clientid=" . $clientid);
if (phpAds_dbNumRows($res_client) > 0) {
$client = phpAds_dbFetchArray($res_client);
// Load client language strings
@(include phpAds_path . '/language/english/default.lang.php');
if ($client['language'] != '') {
$phpAds_config['language'] = $client['language'];
}
if ($phpAds_config['language'] != 'english' && file_exists(phpAds_path . '/language/' . $phpAds_config['language'] . '/default.lang.php')) {
@(include phpAds_path . '/language/' . $phpAds_config['language'] . '/default.lang.php');
}
$active_campaigns = false;
$log = "";
// Fetch all campaigns belonging to client
$res_campaigns = phpAds_dbQuery("SELECT" . " campaignid" . ",campaignname" . ",views" . ",clicks" . ",conversions" . ",expire" . ",UNIX_TIMESTAMP(expire) as expire_st" . ",activate" . ",UNIX_TIMESTAMP(activate) as activate_st" . ",active" . " FROM " . $phpAds_config['tbl_campaigns'] . " WHERE clientid=" . $client['clientid']) or die($strLogErrorClients);
while ($campaign = phpAds_dbFetchArray($res_campaigns)) {
// Fetch all banners belonging to campaign
$res_banners = phpAds_dbQuery("SELECT" . " bannerid" . ",campaignid" . ",URL" . ",active" . ",description" . ",alt" . " FROM " . $phpAds_config['tbl_banners'] . " WHERE campaignid=" . $campaign['campaignid']) or die($strLogErrorBanners);
$active_banners = false;
$log .= "\n" . $strCampaign . " " . strip_tags(phpAds_buildName($campaign['campaignid'], $campaign['campaignname'])) . "\n";
$log .= "=======================================================\n\n";
while ($row_banners = phpAds_dbFetchArray($res_banners)) {
$adviews = phpAds_totalViews($row_banners["bannerid"]);
$client["views_used"] = $adviews;
$adclicks = phpAds_totalClicks($row_banners["bannerid"]);
$campaign["clicks_used"] = $adclicks;
$adconversions = phpAds_totalConversions($row_banners["bannerid"]);
$campaign["conversions_used"] = $adconversions;
if ($adviews > 0 || $adclicks > 0 || $adconversions > 0) {
$log .= $strBanner . " " . strip_tags(phpAds_buildBannerName($row_banners['bannerid'], $row_banners['description'], $row_banners['alt'])) . "\n";
$log .= $strLinkedTo . ": " . $row_banners['URL'] . "\n";
$log .= "-------------------------------------------------------\n";
$active_banner_stats = false;
if ($adviews > 0) {
$log .= $strViews . " (" . $strTotal . "): " . $adviews . "\n";
// Fetch all adviews belonging to banner belonging to client, grouped by day
$res_adviews = phpAds_dbQuery("SELECT" . " SUM(views) as qnt" . ",DATE_FORMAT(day, '{$date_format}') as t_stamp_f" . ",TO_DAYS(day) AS the_day" . " FROM " . $phpAds_config['tbl_adstats'] . " WHERE bannerid=" . $row_banners['bannerid'] . " AND views>0" . " AND UNIX_TIMESTAMP(day)>=" . $first_unixtimestamp . " AND UNIX_TIMESTAMP(day)<" . $last_unixtimestamp . " GROUP BY day" . " ORDER BY day DESC") or die($strLogErrorViews . " " . phpAds_dbError());
if (phpAds_dbNumRows($res_adviews)) {
$total = 0;
while ($row_adviews = phpAds_dbFetchArray($res_adviews)) {
$log .= " " . $row_adviews['t_stamp_f'] . ": " . $row_adviews['qnt'] . "\n";
$total += $row_adviews['qnt'];
}
$log .= $strTotalThisPeriod . ": " . $total . "\n";
$active_banner_stats = true;
} else {
$log .= " " . $strNoViewLoggedInInterval . "\n";
}
}
if ($adclicks > 0) {
// Total adclicks
$log .= "\n" . $strClicks . " (" . $strTotal . "): " . $adclicks . "\n";
// Fetch all adclicks belonging to banner belonging to client, grouped by day
$res_adclicks = phpAds_dbQuery("SELECT" . " SUM(clicks) as qnt" . ",DATE_FORMAT(day, '{$date_format}') as t_stamp_f" . ",TO_DAYS(day) AS the_day" . " FROM " . $phpAds_config['tbl_adstats'] . " WHERE bannerid = " . $row_banners['bannerid'] . " AND clicks>0" . " AND UNIX_TIMESTAMP(day)>=" . $first_unixtimestamp . " AND UNIX_TIMESTAMP(day)<" . $last_unixtimestamp . " GROUP BY day" . " ORDER BY day DESC") or die($strLogErrorClicks . " " . phpAds_dbError());
if (phpAds_dbNumRows($res_adclicks)) {
$total = 0;
while ($row_adclicks = phpAds_dbFetchArray($res_adclicks)) {
$log .= " " . $row_adclicks['t_stamp_f'] . ": " . $row_adclicks['qnt'] . "\n";
$total += $row_adclicks['qnt'];
}
$log .= $strTotalThisPeriod . ": " . $total . "\n";
$active_banner_stats = true;
} else {
$log .= " " . $strNoClickLoggedInInterval . "\n";
}
}
if ($adconversions > 0) {
// Total adconversions
$log .= "\n" . $strConversions . " (" . $strTotal . "): " . $adconversions . "\n";
// Fetch all adclicks belonging to banner belonging to client, grouped by day
$res_adconversions = phpAds_dbQuery("SELECT" . " SUM(conversions) as qnt" . ",DATE_FORMAT(day, '{$date_format}') as t_stamp_f" . ",TO_DAYS(day) AS the_day" . " FROM " . $phpAds_config['tbl_adstats'] . " WHERE bannerid = " . $row_banners['bannerid'] . " AND conversions>0" . " AND UNIX_TIMESTAMP(day)>=" . $first_unixtimestamp . " AND UNIX_TIMESTAMP(day)<" . $last_unixtimestamp . " GROUP BY day" . " ORDER BY day DESC") or die($strLogErrorConversions . " " . phpAds_dbError());
if (phpAds_dbNumRows($res_adconversions)) {
$total = 0;
while ($row_adconversions = phpAds_dbFetchArray($res_adconversions)) {
$log .= " " . $row_adcconversions['t_stamp_f'] . ": " . $row_adconversions['qnt'] . "\n";
$total += $row_adconversions['qnt'];
}
$log .= $strTotalThisPeriod . ": " . $total . "\n";
$active_banner_stats = true;
} else {
$log .= " " . $strNoConversionLoggedInInterval . "\n";
}
}
$log .= "\n\n";
if ($active_banner_stats == true || $active_banner_stats == false && $campaign['active'] == 't') {
$active_banners = true;
}
}
}
if ($active_banners == true) {
$active_campaigns = true;
} else {
$log .= $strNoStatsForCampaign . "\n\n\n";
}
}
// E-mail Stats to active clients
if ($client["email"] != '' && $active_campaigns == true) {
$Subject = $strMailSubject . ": " . $client["clientname"];
$Body = "{$strMailHeader}\n";
$Body .= "{$strMailBannerStats}\n";
if ($first_unixtimestamp == 0) {
$Body .= "{$strMailReportPeriodAll}\n\n";
} else {
$Body .= "{$strMailReportPeriod}\n\n";
}
$Body .= "{$log}\n";
$Body .= "{$strMailFooter}";
$Body = str_replace("{clientname}", $client['clientname'], $Body);
$Body = str_replace("{contact}", $client['contact'], $Body);
$Body = str_replace("{adminfullname}", $phpAds_config['admin_fullname'], $Body);
$Body = str_replace("{startdate}", date(str_replace('%', '', $date_format), $first_unixtimestamp), $Body);
$Body = str_replace("{enddate}", date(str_replace('%', '', $date_format), $last_unixtimestamp), $Body);
if ($phpAds_config['userlog_email']) {
phpAds_userlogAdd(phpAds_actionAdvertiserReportMailed, $client['clientid'], $Subject . "\n\n" . $Body);
}
if (phpAds_sendMail($client['email'], $client['contact'], $Subject, $Body)) {
// Update last run
if ($update == true) {
$res_update = phpAds_dbQuery("UPDATE " . $phpAds_config['tbl_clients'] . " SET reportlastdate=NOW() WHERE clientid=" . $client['clientid']);
}
return true;
}
}
}
return false;
}
function getChannels()
{
global $list_filters;
if (OA_Permission::isAccount(OA_ACCOUNT_ADMIN)) {
// set publisher id if list is to be filtered by publisher
if (isset($list_filters['publisher'])) {
$aParams = array('publisher_id' => $list_filters['publisher']);
// get channels owned by this publisher's agency
$aPublisher = Admin_DA::getPublisher($list_filters['publisher']);
$agencyId = $aPublisher['agency_id'];
if ($agencyId != 0) {
// check that this publisher actually has an agency
$aParams2 = array('agency_id' => $agencyId, 'publisher_id' => 0);
$aAgencyChannels = Admin_DA::getChannels($aParams2);
}
}
$aChannels = Admin_DA::getChannels($aParams);
// add any agency-owned channels
if (isset($aAgencyChannels)) {
foreach ($aAgencyChannels as $channelId => $aAgencyChannel) {
$aChannels[$channelId] = $aAgencyChannel;
}
}
} elseif (OA_Permission::isAccount(OA_ACCOUNT_MANAGER)) {
$aParams = array('agency_id' => OA_Permission::getEntityId());
// set publisher id if list is to be filtered by publisher
if (isset($list_filters['publisher'])) {
$aParams = array('agency_id' => OA_Permission::getEntityId(), 'publisher_id' => $list_filters['publisher']);
}
$aChannels = Admin_DA::getChannels($aParams);
// add agency-owned channels
$aParams = array('agency_id' => OA_Permission::getEntityId(), 'publisher_id' => 0);
$aAgencyChannels = Admin_DA::getChannels($aParams);
foreach ($aAgencyChannels as $channelId => $aAgencyChannel) {
$aChannels[$channelId] = $aAgencyChannel;
}
} elseif (OA_Permission::isAccount(OA_ACCOUNT_TRAFFICKER)) {
$aParams = array('publisher_id' => OA_Permission::getEntityId());
$aPublishers = Admin_DA::getPublishers($aParams);
$aParams = array('publisher_id' => implode(',', array_keys($aPublishers)));
$aChannels = Admin_DA::getChannels($aParams);
// get channels owned by this publisher's agency
$aPublisher = Admin_DA::getPublisher(OA_Permission::getEntityId());
$agencyId = $aPublisher['agency_id'];
if ($agencyId != 0) {
// check that this publisher actually has an agency
$aParams2 = array('agency_id' => $agencyId, 'publisher_id' => 0);
$aAgencyChannels = Admin_DA::getChannels($aParams2);
}
// add agency-owned channels
if (isset($aAgencyChannels)) {
foreach ($aAgencyChannels as $channelId => $aAgencyChannel) {
$aChannels[$channelId] = $aAgencyChannel;
}
}
} else {
$aPublishers = array();
$aChannels = array();
}
// add admin-owned channels
if (OA_Permission::isAccount(OA_ACCOUNT_ADMIN) || OA_Permission::isAccount(OA_ACCOUNT_MANAGER) || OA_Permission::isAccount(OA_ACCOUNT_TRAFFICKER)) {
// add admin-owned channels
$aParams = array('agency_id' => 0, 'publisher_id' => 0);
$aAdminChannels = Admin_DA::getChannels($aParams);
foreach ($aAdminChannels as $channelId => $aAdminChannel) {
$aChannels[$channelId] = $aAdminChannel;
}
}
$aChannelArray = array();
foreach ($aChannels as $channelId => $aChannel) {
$aChannelArray[$channelId] = phpAds_buildName($channelId, $aChannel['name']);
}
return $aChannelArray;
}
$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 */
/*********************************************************/
// Get clients & campaign and build the tree
$res_trackers = phpAds_dbQuery("SELECT *" . " FROM " . $phpAds_config['tbl_trackers'] . " WHERE clientid=" . $clientid . phpAds_getTrackerListOrder($listorder, $orderdirection)) or phpAds_sqlDie();
if (phpAds_isUser(phpAds_Admin) || phpAds_isUser(phpAds_Agency) || phpAds_isAllowed(phpAds_AddTracker)) {
echo "\t\t\t\t<img src='images/icon-tracker-new.gif' border='0' align='absmiddle'>\n";
// Include required files
require "config.php";
require "lib-statistics.inc.php";
require "lib-size.inc.php";
require "lib-zones.inc.php";
require_once 'lib-data-statistics.inc.php';
require_once 'lib-data-campaigns.inc.php';
require_once 'lib-prefs.inc.php';
// Register input variables
phpAds_registerGlobal('campaignid', 'clientid', 'collapse', 'expand', 'keep', 'listorder', 'omit', 'orderdirection');
$page = 'stats-campaign-optimise.php';
// BUILD PAGE HEADER
if (phpAds_isUser(phpAds_Admin)) {
$res = phpAds_dbQuery("SELECT *" . " FROM " . $phpAds_config['tbl_campaigns'] . " WHERE clientid = " . $clientid) or phpAds_sqlDie();
while ($row = phpAds_dbFetchArray($res)) {
phpAds_PageContext(phpAds_buildName($row['campaignid'], $row['campaignname']), $page . "?clientid=" . $clientid . "&campaignid=" . $row['campaignid'], $campaignid == $row['campaignid']);
}
phpAds_PageShortcut($strClientProperties, 'advertiser-edit.php?clientid=' . $clientid, 'images/icon-advertiser.gif');
phpAds_PageShortcut($strCampaignProperties, 'campaign-edit.php?clientid=' . $clientid . '&campaignid=' . $campaignid, 'images/icon-campaign.gif');
phpAds_PageHeader("2.1.2.5");
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("2.1.2.1", "2.1.2.2", "2.1.2.3", "2.1.2.4", "2.1.2.5"));
}
// GET PREFERENCES
if (!isset($listorder)) {
$listorder = phpAds_getPref($page, 'listorder');
}
if (!isset($orderdirection)) {
$orderdirection = phpAds_getPref($page, 'orderdirection');
if ($agencyid != '') {
if (isset($Session['prefs']['agency-index.php']['listorder'])) {
$navorder = $Session['prefs']['agency-index.php']['listorder'];
} else {
$navorder = '';
}
if (isset($Session['prefs']['agency-index.php']['orderdirection'])) {
$navdirection = $Session['prefs']['agency-index.php']['orderdirection'];
} else {
$navdirection = '';
}
$query = "\tSELECT \n\t\t\t\t\t\t*\n\t\t\t\t\tFROM \n\t\t\t\t\t\t" . $phpAds_config['tbl_agency'];
// Get other agencies
$res = phpAds_dbQuery($query) or phpAds_sqlDie();
while ($row = phpAds_dbFetchArray($res)) {
phpAds_PageContext(phpAds_buildName($row['agencyid'], $row['name']), "agency-edit.php?agencyid=" . $row['agencyid'], $agencyid == $row['agencyid']);
}
phpAds_PageHeader("5.5.2");
echo "<img src='images/icon-advertiser.gif' align='absmiddle'> <b>" . phpAds_getAgencyName($agencyid) . "</b><br><br><br>";
phpAds_ShowSections(array("5.5.2"));
// Do not get this information if the page
// is the result of an error message
if (!isset($agency)) {
$res = phpAds_dbQuery("SELECT * FROM " . $phpAds_config['tbl_agency'] . " WHERE agencyid=" . $agencyid) or phpAds_sqlDie();
if (phpAds_dbNumRows($res)) {
$agency = phpAds_dbFetchArray($res);
}
// Set password to default value
if ($agency['password'] != '') {
$agency['password'] = '******';
}
function phpAds_placeInvocationForm($extra = '', $zone_invocation = false)
{
global $HTTP_SERVER_VARS, $block, $blockcampaign, $campaignid, $clientid, $codetype, $delay, $delay_type, $generate, $height, $hostlanguage, $ilayer, $layerstyle, $left, $location, $menubar, $phpAds_config, $phpAds_TextDirection, $popunder, $raw, $refresh, $resizable, $resize, $scrollbars, $source, $status, $submitbutton, $tabindex, $target, $template, $timeout, $toolbars, $top, $transparent, $uniqueid, $what, $width, $withtext, $bannerid;
// Check if affiliate is on the same server
if ($extra != '' && isset($extra['website']) && $extra['website']) {
$server_phpads = parse_url($phpAds_config['url_prefix']);
$server_affilate = parse_url($extra['website']);
$server_same = @gethostbyname($server_phpads['host']) == @gethostbyname($server_affilate['host']);
} else {
$server_same = true;
}
// Hide when integrated in zone-advanced.php
if (!is_array($extra) || !isset($extra['zoneadvanced']) || !$extra['zoneadvanced']) {
echo "<form name='generate' action='" . $HTTP_SERVER_VARS['PHP_SELF'] . "' method='POST'>\n";
}
// Invocation type selection
if (!is_array($extra) || isset($extra['delivery']) && $extra['delivery'] != phpAds_ZoneInterstitial && $extra['delivery'] != phpAds_ZonePopup) {
$allowed['adlayer'] = $phpAds_config['allow_invocation_interstitial'];
$allowed['popup'] = $phpAds_config['allow_invocation_popup'];
$allowed['xmlrpc'] = $phpAds_config['allow_invocation_xmlrpc'];
$allowed['adframe'] = $phpAds_config['allow_invocation_frame'];
$allowed['adjs'] = $phpAds_config['allow_invocation_js'];
$allowed['adview'] = $phpAds_config['allow_invocation_plain'];
$allowed['adviewnocookies'] = $phpAds_config['allow_invocation_plain_nocookies'];
$allowed['local'] = $phpAds_config['allow_invocation_local'];
if (is_array($extra)) {
$allowed['popup'] = false;
}
if (is_array($extra)) {
$allowed['adlayer'] = false;
}
if (is_array($extra) && $server_same == false) {
$allowed['local'] = false;
}
if (is_array($extra) && $server_same == false && ($extra['width'] == '-1' || $extra['height'] == '-1')) {
$allowed['adframe'] = false;
}
if (is_array($extra) && $extra['delivery'] == phpAds_ZoneText) {
// Only allow Javascript and Localmode
// when using text ads
$allowed['adlayer'] = $allowed['popup'] = $allowed['adframe'] = $allowed['adview'] = false;
$allowed['adviewnocookies'] = false;
}
if (!isset($codetype) || $allowed[$codetype] == false) {
while (list($k, $v) = each($allowed)) {
if ($v) {
$codetype = $k;
}
}
}
if (!isset($codetype)) {
$codetype = '';
}
echo "<table border='0' width='100%' cellpadding='0' cellspacing='0'>";
echo "<tr><td height='25' colspan='3'><b>" . $GLOBALS['strChooseInvocationType'] . "</b></td></tr>";
echo "<tr><td height='35'>";
echo "<select name='codetype' onChange=\"this.form.submit()\" accesskey=" . $GLOBALS['keyList'] . " tabindex='" . $tabindex++ . "'>";
if ($allowed['adview']) {
echo "<option value='adview'" . ($codetype == 'adview' ? ' selected' : '') . ">" . $GLOBALS['strInvocationRemote'] . "</option>";
}
if ($allowed['adviewnocookies']) {
echo "<option value='adviewnocookies'" . ($codetype == 'adviewnocookies' ? ' selected' : '') . ">" . $GLOBALS['strInvocationRemoteNoCookies'] . "</option>";
}
if ($allowed['adjs']) {
echo "<option value='adjs'" . ($codetype == 'adjs' ? ' selected' : '') . ">" . $GLOBALS['strInvocationJS'] . "</option>";
}
if ($allowed['adframe']) {
echo "<option value='adframe'" . ($codetype == 'adframe' ? ' selected' : '') . ">" . $GLOBALS['strInvocationIframes'] . "</option>";
}
if ($allowed['xmlrpc']) {
echo "<option value='xmlrpc'" . ($codetype == 'xmlrpc' ? ' selected' : '') . ">" . $GLOBALS['strInvocationXmlRpc'] . "</option>";
}
if ($allowed['popup']) {
echo "<option value='popup'" . ($codetype == 'popup' ? ' selected' : '') . ">" . $GLOBALS['strInvocationPopUp'] . "</option>";
}
if ($allowed['adlayer']) {
echo "<option value='adlayer'" . ($codetype == 'adlayer' ? ' selected' : '') . ">" . $GLOBALS['strInvocationAdLayer'] . "</option>";
}
if ($allowed['local']) {
echo "<option value='local'" . ($codetype == 'local' ? ' selected' : '') . ">" . $GLOBALS['strInvocationLocal'] . "</option>";
}
echo "</select>";
echo " <input type='image' src='images/" . $phpAds_TextDirection . "/go_blue.gif' border='0'>";
echo "</td></tr></table>";
phpAds_ShowBreak();
echo "<br>";
} else {
if ($extra['delivery'] == phpAds_ZoneInterstitial) {
$codetype = 'adlayer';
}
if ($extra['delivery'] == phpAds_ZonePopup) {
$codetype = 'popup';
}
if (!isset($codetype)) {
$codetype = '';
}
}
if ($codetype == 'adlayer') {
if (!isset($layerstyle)) {
$layerstyle = 'geocities';
}
include '../libraries/layerstyles/' . $layerstyle . '/invocation.inc.php';
}
//
if ($codetype != '') {
// Code
if (isset($submitbutton) || isset($generate) && $generate) {
echo "<table border='0' width='550' cellpadding='0' cellspacing='0'>";
echo "<tr><td height='25'><img src='images/icon-generatecode.gif' align='absmiddle'> <b>" . $GLOBALS['strBannercode'] . "</b></td>";
// Show clipboard button only on IE
if (strpos($HTTP_SERVER_VARS['HTTP_USER_AGENT'], 'MSIE') > 0 && strpos($HTTP_SERVER_VARS['HTTP_USER_AGENT'], 'Opera') < 1) {
echo "<td height='25' align='right'><img src='images/icon-clipboard.gif' align='absmiddle'> ";
echo "<a href='javascript:phpAds_CopyClipboard(\"bannercode\");'>" . $GLOBALS['strCopyToClipboard'] . "</a></td></tr>";
} else {
echo "<td> </td>";
}
echo "<tr height='1'><td colspan='2' bgcolor='#888888'><img src='images/break.gif' height='1' width='100%'></td></tr>";
echo "<tr><td colspan='2'><textarea name='bannercode' class='code-gray' rows='6' cols='55' style='width:550;' readonly>" . htmlspecialchars(phpAds_GenerateInvocationCode()) . "</textarea></td></tr>";
echo "</table><br>";
phpAds_ShowBreak();
echo "<br>";
$generated = true;
} else {
$generated = false;
}
// Hide when integrated in zone-advanced.php
if (!(is_array($extra) && isset($extra['zoneadvanced']) && $extra['zoneadvanced'])) {
// Header
//Parameters Section
echo "<table border='0' width='100%' cellpadding='0' cellspacing='0'>";
echo "<tr><td height='25' colspan='3'><img src='images/icon-overview.gif' align='absmiddle'> <b>" . $GLOBALS['strParameters'] . "</b></td></tr>";
echo "<tr height='1'><td width='30'><img src='images/break.gif' height='1' width='30'></td>";
echo "<td width='200'><img src='images/break.gif' height='1' width='200'></td>";
echo "<td width='100%'><img src='images/break.gif' height='1' width='100%'></td></tr>";
echo "<tr" . ($zone_invocation || $codetype == 'adviewnocookies' ? '' : " bgcolor='#F6F6F6'") . "><td height='10' colspan='3'> </td></tr>";
//echo "<tr><td height='10' colspan='3'> </td></tr>";
}
if ($codetype == 'adview') {
$show = array('what' => true, 'clientid' => true, 'campaignid' => true, 'target' => true, 'source' => true);
}
if ($codetype == 'adviewnocookies') {
$show = array('what' => true, 'clientid' => true, 'campaignid' => true, 'target' => true, 'source' => true, 'bannerid' => true);
}
if ($codetype == 'adjs') {
$show = array('what' => true, 'clientid' => true, 'campaignid' => true, 'block' => true, 'target' => true, 'source' => true, 'withtext' => true, 'blockcampaign' => true);
}
if ($codetype == 'adframe') {
$show = array('what' => true, 'clientid' => true, 'campaignid' => true, 'target' => true, 'source' => true, 'refresh' => true, 'size' => true, 'resize' => true, 'transparent' => true, 'ilayer' => true);
}
if ($codetype == 'ad') {
$show = array('what' => true, 'clientid' => true, 'campaignid' => true, 'target' => true, 'source' => true, 'withtext' => true, 'size' => true, 'resize' => true, 'transparent' => true);
}
if ($codetype == 'popup') {
$show = array('what' => true, 'clientid' => true, 'campaignid' => true, 'target' => true, 'source' => true, 'absolute' => true, 'popunder' => true, 'timeout' => true, 'delay' => true, 'windowoptions' => true);
}
if ($codetype == 'adlayer') {
$show = phpAds_getLayerShowVar();
}
if ($codetype == 'xmlrpc') {
$show = array('what' => true, 'clientid' => true, 'campaignid' => true, 'target' => true, 'source' => true, 'withtext' => true, 'template' => true, 'hostlanguage' => true);
}
if ($codetype == 'local') {
$show = array('what' => true, 'clientid' => true, 'campaignid' => true, 'target' => true, 'source' => true, 'withtext' => true, 'block' => true, 'blockcampaign' => true, 'raw' => true);
}
// What
if (!$zone_invocation && isset($show['what']) && $show['what'] == true && $codetype != 'adviewnocookies') {
echo "<tr bgcolor='#F6F6F6'><td width='30'> </td>";
echo "<td width='200' valign='top'>" . $GLOBALS['strInvocationWhat'] . "</td><td width='370'>";
echo "<textarea class='flat' name='what' rows='3' cols='50' style='width:350px;' tabindex='" . $tabindex++ . "'>" . (isset($what) ? stripslashes($what) : '') . "</textarea></td></tr>";
echo "<tr bgcolor='#F6F6F6'><td width='30'><img src='images/spacer.gif' height='1' width='100%'></td>";
echo "<td bgcolor='#F6F6F6' colspan='2'><img src='images/break-l.gif' height='1' width='200' vspace='6'></td></tr>";
}
/* Remove advetiser from direct invocation - not needed
// ClientID
if (!$zone_invocation && isset($show['clientid']) && $show['clientid'] == true)
{
// Display available advertisers...
echo "<tr bgcolor='#F6F6F6'><td width='30'> </td>\n";
echo "<td width='200'>".$GLOBALS['strInvocationClientID']."</td><td width='370'>\n";
echo "<select name='clientid' style='width:350px;' tabindex='".($tabindex++)."'>\n";
echo "<option value='0'>-</option>\n";
$res = phpAds_dbQuery(
"SELECT clientid, clientname".
" FROM ".$phpAds_config['tbl_clients']
) or phpAds_sqlDie();
while ($row = phpAds_dbFetchArray($res))
{
echo "<option value='".$row['clientid']."'".($clientid == $row['clientid'] ? ' selected' : '').">";
echo phpAds_buildName ($row['clientid'], $row['clientname']);
echo "</option>\n";
}
echo "</select>\n";
echo "</td></tr>";
// echo "<tr bgcolor='#F6F6F6'><td height='10' colspan='3'> </td></tr>";
// echo "<tr height='1'><td colspan='3' bgcolor='#888888'><img src='images/break.gif' height='1' width='100%'></td></tr>";
// echo "<tr><td height='10' colspan='3'> </td></tr>";
echo "<tr bgcolor='#F6F6F6'><td width='30'><img src='images/spacer.gif' height='1' width='100%'></td>";
echo "<td bgcolor='#F6F6F6' colspan='2'><img src='images/break-l.gif' height='1' width='200' vspace='6'></td></tr>";
}
*/
// CampaignID
if (!$zone_invocation && isset($show['campaignid']) && $show['campaignid'] == true && $codetype != 'adviewnocookies') {
// Display available campaigns...
echo "<tr bgcolor='#F6F6F6'><td width='30'> </td>\n";
echo "<td width='200'>" . $GLOBALS['strInvocationCampaignID'] . "</td><td width='370'>\n";
echo "<select name='campaignid' style='width:350px;' tabindex='" . $tabindex++ . "'>\n";
echo "<option value='0'>-</option>\n";
if (phpAds_isUser(phpAds_Admin)) {
$query = "SELECT campaignid,campaignname" . " FROM " . $phpAds_config['tbl_campaigns'];
} elseif (phpAds_isUser(phpAds_Agency)) {
$query = "SELECT m.campaignid AS campaignid" . ",m.campaignname AS campaignname" . " FROM " . $phpAds_config['tbl_campaigns'] . " AS m" . "," . $phpAds_config['tbl_clients'] . " AS c" . " WHERE m.clientid=c.clientid" . " AND c.agencyid=" . phpAds_getAgencyID();
}
$res = phpAds_dbQuery($query) or phpAds_sqlDie();
while ($row = phpAds_dbFetchArray($res)) {
echo "<option value='" . $row['campaignid'] . "'" . ($campaignid == $row['campaignid'] ? ' selected' : '') . ">";
echo phpAds_buildName($row['campaignid'], $row['campaignname']);
echo "</option>\n";
}
echo "</select>\n";
echo "</td></tr>";
echo "<tr bgcolor='#F6F6F6'><td height='10' colspan='3'> </td></tr>";
echo "<tr height='1'><td colspan='3' bgcolor='#888888'><img src='images/break.gif' height='1' width='100%'></td></tr>";
echo "<tr><td height='10' colspan='3'> </td></tr>";
}
// BannerID
if (isset($show['bannerid']) && $show['bannerid'] == true) {
echo "<tr><td width='30'> </td>";
echo "<td width='200'>" . $GLOBALS['strInvocationBannerID'] . "</td><td width='370'>";
echo "<input class='flat' type='text' name='bannerid' size='' value='" . (isset($bannerid) ? $bannerid : '') . "' style='width:175px;' tabindex='" . $tabindex++ . "'></td></tr>";
echo "<tr><td width='30'><img src='images/spacer.gif' height='1' width='100%'></td>";
echo "<td colspan='2'><img src='images/break-l.gif' height='1' width='200' vspace='6'></td></tr>";
}
// Target
if (isset($show['target']) && $show['target'] == true) {
echo "<tr><td width='30'> </td>";
echo "<td width='200'>" . $GLOBALS['strInvocationTarget'] . "</td><td width='370'>";
echo "<input class='flat' type='text' name='target' size='' value='" . (isset($target) ? $target : '') . "' style='width:175px;' tabindex='" . $tabindex++ . "'></td></tr>";
echo "<tr><td width='30'><img src='images/spacer.gif' height='1' width='100%'></td>";
}
// Source
if (isset($show['source']) && $show['source'] == true) {
echo "<td colspan='2'><img src='images/break-l.gif' height='1' width='200' vspace='6'></td></tr>";
echo "<tr><td width='30'> </td>";
echo "<td width='200'>" . $GLOBALS['strInvocationSource'] . "</td><td width='370'>";
echo "<input class='flat' type='text' name='source' size='' value='" . (isset($source) ? $source : '') . "' style='width:175px;' tabindex='" . $tabindex++ . "'></td></tr>";
echo "<tr><td width='30'><img src='images/spacer.gif' height='1' width='100%'></td>";
}
// WithText
if (isset($show['withtext']) && $show['withtext'] == true) {
echo "<td colspan='2'><img src='images/break-l.gif' height='1' width='200' vspace='6'></td></tr>";
echo "<tr><td width='30'> </td>";
echo "<td width='200'>" . $GLOBALS['strInvocationWithText'] . "</td>";
echo "<td width='370'><input type='radio' name='withtext' value='1'" . (isset($withtext) && $withtext != 0 ? ' checked' : '') . " tabindex='" . $tabindex++ . "'> " . $GLOBALS['strYes'] . "<br>";
echo "<input type='radio' name='withtext' value='0'" . (!isset($withtext) || $withtext == 0 ? ' checked' : '') . " tabindex='" . $tabindex++ . "'> " . $GLOBALS['strNo'] . "</td>";
echo "</tr>";
echo "<tr><td width='30'><img src='images/spacer.gif' height='1' width='100%'></td>";
}
// refresh
if (isset($show['refresh']) && $show['refresh'] == true) {
echo "<td colspan='2'><img src='images/break-l.gif' height='1' width='200' vspace='6'></td></tr>";
echo "<tr><td width='30'> </td>";
echo "<td width='200'>" . $GLOBALS['strIFrameRefreshAfter'] . "</td><td width='370'>";
echo "<input class='flat' type='text' name='refresh' size='' value='" . (isset($refresh) ? $refresh : '') . "' style='width:175px;' tabindex='" . $tabindex++ . "'> " . $GLOBALS['strAbbrSeconds'] . "</td></tr>";
echo "<tr><td width='30'><img src='images/spacer.gif' height='1' width='100%'></td>";
}
// size
if (!$zone_invocation && isset($show['size']) && $show['size'] == true) {
echo "<td colspan='2'><img src='images/break-l.gif' height='1' width='200' vspace='6'></td></tr>";
echo "<tr><td width='30'> </td>";
echo "<td width='200'>" . $GLOBALS['strFrameSize'] . "</td><td width='370'>";
echo $GLOBALS['strWidth'] . ": <input class='flat' type='text' name='width' size='3' value='" . (isset($width) ? $width : '') . "' tabindex='" . $tabindex++ . "'> ";
echo $GLOBALS['strHeight'] . ": <input class='flat' type='text' name='height' size='3' value='" . (isset($height) ? $height : '') . "' tabindex='" . $tabindex++ . "'>";
echo "</td></tr>";
echo "<tr><td width='30'><img src='images/spacer.gif' height='1' width='100%'></td>";
}
// Resize
if (isset($show['resize']) && $show['resize'] == true) {
// Only show this if affiliate is on the same server
if ($server_same) {
echo "<td colspan='2'><img src='images/break-l.gif' height='1' width='200' vspace='6'></td></tr>";
echo "<tr><td width='30'> </td>";
echo "<td width='200'>" . $GLOBALS['strIframeResizeToBanner'] . "</td>";
echo "<td width='370'><input type='radio' name='resize' value='1'" . (isset($resize) && $resize == 1 ? ' checked' : '') . " tabindex='" . $tabindex++ . "'> " . $GLOBALS['strYes'] . "<br>";
echo "<input type='radio' name='resize' value='0'" . (!isset($resize) || $resize == 0 ? ' checked' : '') . " tabindex='" . $tabindex++ . "'> " . $GLOBALS['strNo'] . "</td>";
echo "</tr>";
echo "<tr><td width='30'><img src='images/spacer.gif' height='1' width='100%'></td>";
} else {
echo "<input type='hidden' name='resize' value='0'>";
}
}
// Transparent
if (isset($show['transparent']) && $show['transparent'] == true) {
echo "<td colspan='2'><img src='images/break-l.gif' height='1' width='200' vspace='6'></td></tr>";
echo "<tr><td width='30'> </td>";
echo "<td width='200'>" . $GLOBALS['strIframeMakeTransparent'] . "</td>";
echo "<td width='370'><input type='radio' name='transparent' value='1'" . (isset($transparent) && $transparent == 1 ? ' checked' : '') . " tabindex='" . $tabindex++ . "'> " . $GLOBALS['strYes'] . "<br>";
echo "<input type='radio' name='transparent' value='0'" . (!isset($transparent) || $transparent == 0 ? ' checked' : '') . " tabindex='" . $tabindex++ . "'> " . $GLOBALS['strNo'] . "</td>";
echo "</tr>";
echo "<tr><td width='30'><img src='images/spacer.gif' height='1' width='100%'></td>";
}
// Netscape 4 ilayer
if (isset($show['ilayer']) && $show['ilayer'] == true) {
echo "<td colspan='2'><img src='images/break-l.gif' height='1' width='200' vspace='6'></td></tr>";
echo "<tr><td width='30'> </td>";
echo "<td width='200'>" . $GLOBALS['strIframeIncludeNetscape4'] . "</td>";
echo "<td width='370'><input type='radio' name='ilayer' value='1'" . (isset($ilayer) && $ilayer == 1 ? ' checked' : '') . " tabindex='" . $tabindex++ . "'> " . $GLOBALS['strYes'] . "<br>";
echo "<input type='radio' name='ilayer' value='0'" . (!isset($ilayer) || $ilayer == 0 ? ' checked' : '') . " tabindex='" . $tabindex++ . "'> " . $GLOBALS['strNo'] . "</td>";
echo "</tr>";
echo "<tr><td width='30'><img src='images/spacer.gif' height='1' width='100%'></td>";
}
// Block
if (isset($show['block']) && $show['block'] == true) {
echo "<td colspan='2'><img src='images/break-l.gif' height='1' width='200' vspace='6'></td></tr>";
echo "<tr><td width='30'> </td>";
echo "<td width='200'>" . $GLOBALS['strInvocationDontShowAgain'] . "</td>";
echo "<td width='370'><input type='radio' name='block' value='1'" . (isset($block) && $block != 0 ? ' checked' : '') . " tabindex='" . $tabindex++ . "'> " . $GLOBALS['strYes'] . "<br>";
echo "<input type='radio' name='block' value='0'" . (!isset($block) || $block == 0 ? ' checked' : '') . " tabindex='" . $tabindex++ . "'> " . $GLOBALS['strNo'] . "</td>";
echo "</tr>";
echo "<tr><td width='30'><img src='images/spacer.gif' height='1' width='100%'></td>";
}
// Blockcampaign
if (isset($show['blockcampaign']) && $show['blockcampaign'] == true) {
echo "<td colspan='2'><img src='images/break-l.gif' height='1' width='200' vspace='6'></td></tr>";
echo "<tr><td width='30'> </td>";
echo "<td width='200'>" . $GLOBALS['strInvocationDontShowAgainCampaign'] . "</td>";
echo "<td width='370'><input type='radio' name='blockcampaign' value='1'" . (isset($blockcampaign) && $blockcampaign != 0 ? ' checked' : '') . " tabindex='" . $tabindex++ . "'> " . $GLOBALS['strYes'] . "<br>";
echo "<input type='radio' name='blockcampaign' value='0'" . (!isset($blockcampaign) || $blockcampaign == 0 ? ' checked' : '') . " tabindex='" . $tabindex++ . "'> " . $GLOBALS['strNo'] . "</td>";
echo "</tr>";
echo "<tr><td width='30'><img src='images/spacer.gif' height='1' width='100%'></td>";
}
// Raw
if (isset($show['raw']) && $show['raw'] == true) {
echo "<td colspan='2'><img src='images/break-l.gif' height='1' width='200' vspace='6'></td></tr>";
echo "<tr><td width='30'> </td>";
echo "<td width='200'>" . $GLOBALS['strInvocationTemplate'] . "</td>";
echo "<td width='370'><input type='radio' name='raw' value='1'" . (isset($raw) && $raw != 0 ? ' checked' : '') . " tabindex='" . $tabindex++ . "'> " . $GLOBALS['strYes'] . "<br>";
echo "<input type='radio' name='raw' value='0'" . (!isset($raw) || $raw == 0 ? ' checked' : '') . " tabindex='" . $tabindex++ . "'> " . $GLOBALS['strNo'] . "</td>";
echo "</tr>";
echo "<tr><td width='30'><img src='images/spacer.gif' height='1' width='100%'></td>";
}
// AdLayer style
if (isset($show['layerstyle']) && $show['layerstyle'] == true) {
$layerstyles = array();
$stylesdir = opendir('../libraries/layerstyles');
while ($stylefile = readdir($stylesdir)) {
if (is_dir('../libraries/layerstyles/' . $stylefile) && file_exists('../libraries/layerstyles/' . $stylefile . '/invocation.inc.php')) {
if (ereg('^[^.]', $stylefile)) {
$layerstyles[$stylefile] = isset($GLOBALS['strAdLayerStyleName'][$stylefile]) ? $GLOBALS['strAdLayerStyleName'][$stylefile] : str_replace("- ", "-", ucwords(str_replace("-", "- ", $stylefile)));
}
}
}
closedir($stylesdir);
asort($layerstyles, SORT_STRING);
echo "<td colspan='2'><img src='images/break-l.gif' height='1' width='200' vspace='6'></td></tr>";
echo "<tr><td width='30'> </td>";
echo "<td width='200'>" . $GLOBALS['strAdLayerStyle'] . "</td><td width='370'>";
echo "<select name='layerstyle' onChange='this.form.submit()' style='width:175px;' tabindex='" . $tabindex++ . "'>";
while (list($k, $v) = each($layerstyles)) {
echo "<option value='{$k}'" . ($layerstyle == $k ? ' selected' : '') . ">{$v}</option>";
}
echo "</select>";
echo "</td></tr>";
echo "<tr><td width='30'><img src='images/spacer.gif' height='1' width='100%'></td>";
}
// popunder
if (isset($show['popunder']) && $show['popunder'] == true) {
echo "<td colspan='2'><img src='images/break-l.gif' height='1' width='200' vspace='6'></td></tr>";
echo "<tr><td width='30'> </td>";
echo "<td width='200'>" . $GLOBALS['strPopUpStyle'] . "</td>";
echo "<td width='370'><input type='radio' name='popunder' value='0'" . (!isset($popunder) || $popunder != '1' ? ' checked' : '') . " tabindex='" . $tabindex++ . "'> " . "<img src='images/icon-popup-over.gif' align='absmiddle'> " . $GLOBALS['strPopUpStylePopUp'] . "<br>";
echo "<input type='radio' name='popunder' value='1'" . (isset($popunder) && $popunder == '1' ? ' checked' : '') . " tabindex='" . $tabindex++ . "'> " . "<img src='images/icon-popup-under.gif' align='absmiddle'> " . $GLOBALS['strPopUpStylePopUnder'] . "</td>";
echo "</tr>";
echo "<tr><td width='30'><img src='images/spacer.gif' height='1' width='100%'></td>";
}
// delay
if (isset($show['delay']) && $show['delay'] == true) {
echo "<td colspan='2'><img src='images/break-l.gif' height='1' width='200' vspace='6'></td></tr>";
echo "<tr><td width='30'> </td>";
echo "<td width='200'>" . $GLOBALS['strPopUpCreateInstance'] . "</td>";
echo "<td width='370'><input type='radio' name='delay_type' value='none'" . (!isset($delay_type) || $delay_type != 'exit' && $delay_type != 'seconds' ? ' checked' : '') . " tabindex='" . $tabindex++ . "'> " . $GLOBALS['strPopUpImmediately'] . "<br>";
echo "<input type='radio' name='delay_type' value='exit'" . (isset($delay_type) && $delay_type == 'exit' ? ' checked' : '') . " tabindex='" . $tabindex++ . "'> " . $GLOBALS['strPopUpOnClose'] . "<br>";
echo "<input type='radio' name='delay_type' value='seconds'" . (isset($delay_type) && $delay_type == 'seconds' ? ' checked' : '') . " tabindex='" . $tabindex++ . "'> " . $GLOBALS['strPopUpAfterSec'] . " " . "<input class='flat' type='text' name='delay' size='' value='" . (isset($delay) ? $delay : '-') . "' style='width:50px;' tabindex='" . $tabindex++ . "'> " . $GLOBALS['strAbbrSeconds'] . "</td>";
echo "</tr>";
echo "<tr><td width='30'><img src='images/spacer.gif' height='1' width='100%'></td>";
}
// absolute
if (isset($show['absolute']) && $show['absolute'] == true) {
echo "<td colspan='2'><img src='images/break-l.gif' height='1' width='200' vspace='6'></td></tr>";
echo "<tr><td width='30'> </td>";
echo "<td width='200'>" . $GLOBALS['strPopUpTop'] . "</td><td width='370'>";
echo "<input class='flat' type='text' name='top' size='' value='" . (isset($top) ? $top : '-') . "' style='width:50px;' tabindex='" . $tabindex++ . "'> " . $GLOBALS['strAbbrPixels'] . "</td></tr>";
echo "<tr><td width='30'> </td>";
echo "<td width='200'>" . $GLOBALS['strPopUpLeft'] . "</td><td width='370'>";
echo "<input class='flat' type='text' name='left' size='' value='" . (isset($left) ? $left : '-') . "' style='width:50px;' tabindex='" . $tabindex++ . "'> " . $GLOBALS['strAbbrPixels'] . "</td></tr>";
echo "<tr><td width='30'><img src='images/spacer.gif' height='1' width='100%'></td>";
}
// timeout
if (isset($show['timeout']) && $show['timeout'] == true) {
echo "<td colspan='2'><img src='images/break-l.gif' height='1' width='200' vspace='6'></td></tr>";
echo "<tr><td width='30'> </td>";
echo "<td width='200'>" . $GLOBALS['strAutoCloseAfter'] . "</td><td width='370'>";
echo "<input class='flat' type='text' name='timeout' size='' value='" . (isset($timeout) ? $timeout : '-') . "' style='width:50px;' tabindex='" . $tabindex++ . "'> " . $GLOBALS['strAbbrSeconds'] . "</td></tr>";
echo "<tr><td width='30'><img src='images/spacer.gif' height='1' width='100%'></td>";
}
// Window options
if (isset($show['windowoptions']) && $show['windowoptions'] == true) {
echo "<td colspan='2'><img src='images/break-l.gif' height='1' width='200' vspace='6'></td></tr>";
echo "<tr><td width='30'> </td><td width='200' valign='top'>" . $GLOBALS['strWindowOptions'] . "</td><td width='370'>";
echo "<table cellpadding='0' cellspacing='0' border='0'>";
echo "<tr><td>" . $GLOBALS['strShowToolbars'] . "</td><td> </td><td>";
echo "<input type='radio' name='toolbars' value='1'" . (isset($toolbars) && $toolbars != 0 ? ' checked' : '') . " tabindex='" . $tabindex++ . "'> " . $GLOBALS['strYes'] . "<br>";
echo "</td><td> </td><td>";
echo "<input type='radio' name='toolbars' value='0'" . (!isset($toolbars) || $toolbars == 0 ? ' checked' : '') . " tabindex='" . $tabindex++ . "'> " . $GLOBALS['strNo'] . "";
echo "</td></tr><tr><td colspan='5'><img src='images/break-l.gif' height='1' width='200' vspace='2'></td></tr>";
echo "<tr><td>" . $GLOBALS['strShowLocation'] . "</td><td> </td><td>";
echo "<input type='radio' name='location' value='1'" . (isset($location) && $location != 0 ? ' checked' : '') . " tabindex='" . $tabindex++ . "'> " . $GLOBALS['strYes'] . "<br>";
echo "</td><td> </td><td>";
echo "<input type='radio' name='location' value='0'" . (!isset($location) || $location == 0 ? ' checked' : '') . " tabindex='" . $tabindex++ . "'> " . $GLOBALS['strNo'] . "";
echo "</td></tr><tr><td colspan='5'><img src='images/break-l.gif' height='1' width='200' vspace='2'></td></tr>";
echo "<tr><td>" . $GLOBALS['strShowMenubar'] . "</td><td> </td><td>";
echo "<input type='radio' name='menubar' value='1'" . (isset($menubar) && $menubar != 0 ? ' checked' : '') . " tabindex='" . $tabindex++ . "'> " . $GLOBALS['strYes'] . "<br>";
echo "</td><td> </td><td>";
echo "<input type='radio' name='menubar' value='0'" . (!isset($menubar) || $menubar == 0 ? ' checked' : '') . " tabindex='" . $tabindex++ . "'> " . $GLOBALS['strNo'] . "";
echo "</td></tr><tr><td colspan='5'><img src='images/break-l.gif' height='1' width='200' vspace='2'></td></tr>";
echo "<tr><td>" . $GLOBALS['strShowStatus'] . "</td><td> </td><td>";
echo "<input type='radio' name='status' value='1'" . (isset($status) && $status != 0 ? ' checked' : '') . " tabindex='" . $tabindex++ . "'> " . $GLOBALS['strYes'] . "<br>";
echo "</td><td> </td><td>";
echo "<input type='radio' name='status' value='0'" . (!isset($status) || $status == 0 ? ' checked' : '') . " tabindex='" . $tabindex++ . "'> " . $GLOBALS['strNo'] . "";
echo "</td></tr><tr><td colspan='5'><img src='images/break-l.gif' height='1' width='200' vspace='2'></td></tr>";
echo "<tr><td>" . $GLOBALS['strWindowResizable'] . "</td><td> </td><td>";
echo "<input type='radio' name='resizable' value='1'" . (isset($resizable) && $resizable != 0 ? ' checked' : '') . " tabindex='" . $tabindex++ . "'> " . $GLOBALS['strYes'] . "<br>";
echo "</td><td> </td><td>";
echo "<input type='radio' name='resizable' value='0'" . (!isset($resizable) || $resizable == 0 ? ' checked' : '') . " tabindex='" . $tabindex++ . "'> " . $GLOBALS['strNo'] . "";
echo "</td></tr><tr><td colspan='5'><img src='images/break-l.gif' height='1' width='200' vspace='2'></td></tr>";
echo "<tr><td>" . $GLOBALS['strShowScrollbars'] . "</td><td> </td><td>";
echo "<input type='radio' name='scrollbars' value='1'" . (isset($scrollbars) && $scrollbars != 0 ? ' checked' : '') . " tabindex='" . $tabindex++ . "'> " . $GLOBALS['strYes'] . "<br>";
echo "</td><td> </td><td>";
echo "<input type='radio' name='scrollbars' value='0'" . (!isset($scrollbars) || $scrollbars == 0 ? ' checked' : '') . " tabindex='" . $tabindex++ . "'> " . $GLOBALS['strNo'] . "";
echo "</td></tr>";
echo "</table>";
echo "</td></tr><tr><td width='30'><img src='images/spacer.gif' height='1' width='100%'></td>";
}
// AdLayer custom code
if (isset($show['layercustom']) && $show['layercustom'] == true) {
phpAds_placeLayerSettings();
}
// Host Language
if (isset($show['hostlanguage']) && $show['hostlanguage'] == true) {
echo "<td colspan='2'><img src='images/break-l.gif' height='1' width='200' vspace='6'></td></tr>";
echo "<tr><td width='30'> </td>";
echo "<td width='200'>" . $GLOBALS['strXmlRpcLanguage'] . "</td><td width='370'>";
echo "<select name='hostlanguage' tabindex='" . $tabindex++ . "'>";
echo "<option value='php'" . ($hostlanguage == 'php' ? ' selected' : '') . ">PHP</option>";
// echo "<option value='php-xmlrpc'".($hostlanguage == 'php-xmlrpc' ? ' selected' : '').">PHP with built in XML-RPC extension</option>";
// echo "<option value='asp'".($hostlanguage == 'asp' ? ' selected' : '').">ASP</option>";
// echo "<option value='jsp'".($hostlanguage == 'jsp' ? ' selected' : '').">JSP</option>";
echo "</select>";
echo "</td></tr>";
echo "<tr><td width='30'><img src='images/spacer.gif' height='1' width='100%'></td>";
}
// Hide when integrated in zone-advanced.php
if (!(is_array($extra) && isset($extra['zoneadvanced']) && $extra['zoneadvanced'])) {
// Footer
echo "<tr><td height='10' colspan='3'> </td></tr>";
echo "<tr height='1'><td colspan='3' bgcolor='#888888'><img src='images/break.gif' height='1' width='100%'></td></tr>";
echo "</table>";
echo "<br><br>";
echo "<input type='hidden' value='" . ($generated ? 1 : 0) . "' name='generate'>";
if ($generated) {
echo "<input type='submit' value='" . $GLOBALS['strRefresh'] . "' name='submitbutton' tabindex='" . $tabindex++ . "'>";
} else {
echo "<input type='submit' value='" . $GLOBALS['strGenerate'] . "' name='submitbutton' tabindex='" . $tabindex++ . "'>";
}
}
}
// Put extra hidden fields
if (is_array($extra)) {
while (list($k, $v) = each($extra)) {
echo "<input type='hidden' value='{$v}' name='{$k}'>";
}
}
// Hide when integrated in zone-advanced.php
if (!is_array($extra) || !isset($extra['zoneadvanced']) || !$extra['zoneadvanced']) {
echo "</form><br><br>";
}
}
$extra .= "<b>{$strModifyBanner}</b><br>";
$extra .= "<img src='images/break.gif' height='1' width='160' vspace='4'><br>";
$extra .= "<img src='images/icon-duplicate-banner.gif' align='absmiddle'> <a href='banner-modify.php?clientid=" . $clientid . "&campaignid=" . $campaignid . "&bannerid=" . $bannerid . "&duplicate=true&returnurl=banner-acl.php'>{$strDuplicate}</a><br>";
$extra .= "<img src='images/break.gif' height='1' width='160' vspace='4'><br>";
$extra .= "<img src='images/icon-move-banner.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 campaignid,campaignname" . " FROM " . $phpAds_config['tbl_campaigns'] . " WHERE campaignid!=" . $campaignid;
} elseif (phpAds_isUser(phpAds_Agency)) {
$query = "SELECT m.campaignid AS campaignid" . ",m.campaignname AS campaignname" . " FROM " . $phpAds_config['tbl_campaigns'] . " AS m" . "," . $phpAds_config['tbl_clients'] . " AS c" . " WHERE m.clientid=c.clientid" . " AND m.campaignid!=" . $campaignid . " AND c.agencyid=" . phpAds_getAgencyID();
}
$res = phpAds_dbQuery($query) or phpAds_sqlDie();
while ($row = phpAds_dbFetchArray($res)) {
$extra .= "<option value='" . $row['campaignid'] . "'>" . phpAds_buildName($row['campaignid'], $row['campaignname']) . "</option>";
}
$extra .= "</select> <input type='image' name='moveto' 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-duplicate-acl.gif' align='absmiddle'> {$strApplyLimitationsTo}<br>";
$extra .= "<img src='images/spacer.gif' height='1' width='160' vspace='2'><br>";
$extra .= " ";
$extra .= "<select name='applyto' style='width: 110;'>";
$res = phpAds_dbQuery("SELECT * FROM " . $phpAds_config['tbl_banners'] . " WHERE bannerid != '" . $bannerid . "' AND campaignid = '" . $campaignid . "'") or phpAds_sqlDie();
while ($row = phpAds_dbFetchArray($res)) {
$extra .= "<option value='" . $row['bannerid'] . "'>" . phpAds_buildBannerName($row['bannerid'], $row['description'], $row['alt']) . "</option>";
}
$extra .= "</select> <input type='image' name='applyto' 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='banner-delete.php?clientid=" . $clientid . "&campaignid=" . $campaignid . "&bannerid=" . $bannerid . "&returnurl=campaign-banners.php'" . phpAds_DelConfirm($strConfirmDeleteBanner) . ">{$strDelete}</a><br>";
$extra .= "</form>";
/**
* A private method to prepare the body of an advertiser's "campaign activated"
* or "campaign deactivated" report email.
*
* @access private
* @param integer $advertiserId The advertiser's ID.
* @param array $acampaign The campaign details.
*/
function _prepareCampaignActivatedDeactivatedEmailBody($aCampaign)
{
// Load the "Campaign" and "Banner" strings, and prepare formatting strings
global $strCampaign, $strBanner;
$strCampaignLength = strlen($strCampaign);
$strBannerLength = strlen($strBanner);
$maxLength = max($strCampaignLength, $strBannerLength);
$strCampaignPrint = '%-' . $maxLength . 's';
$strBannerPrint = ' %-' . ($maxLength - 1) . 's';
// Load remaining strings
global $strLinkedTo;
// Prepare the result
$emailBody = '';
// Add the name of the campaign to the report
$emailBody .= "\n" . sprintf($strCampaignPrint, $strCampaign) . ' ';
$emailBody .= strip_tags(phpAds_buildName($aCampaign['campaignid'], $aCampaign['campaignname'])) . "\n";
// Add a URL link to the stats page of the campaign
$page = 'stats.php?clientid=' . $aCampaign['clientid'] . '&campaignid=' . $aCampaign['campaignid'] . '&statsBreakdown=day&entity=campaign&breakdown=history&period_preset=all_stats&period_start=&period_end=';
$emailBody .= MAX::constructURL(MAX_URL_ADMIN, $page) . "\n";
// Add a nice divider
$emailBody .= "=======================================================\n\n";
// Fetch all ads in the campaign
$doBanners = OA_Dal::factoryDO('banners');
$doBanners->campaignid = $aCampaign['campaignid'];
$doBanners->orderBy('bannerid');
$doBanners->find();
if ($doBanners->getRowCount() > 0) {
while ($doBanners->fetch()) {
$aAd = $doBanners->toArray();
// Add the name of the ad to the report
$emailBody .= sprintf($strBannerPrint, $strBanner) . ' ';
$emailBody .= strip_tags(phpAds_buildBannerName($aAd['bannerid'], $aAd['description'], $aAd['alt'])) . "\n";
// If the ad has a URL, add the URL the add is linked to to the report
if (!empty($aAd['url'])) {
$emailBody .= ' ' . $strLinkedTo . ': ' . $aAd['url'] . "\n";
}
$emailBody .= "\n";
}
}
return $emailBody;
}
$extra .= "\t\t\t\t<input type='hidden' name='returnurl' value='campaign-trackers.php'>" . "\n";
$extra .= "\t\t\t\t<br><br>" . "\n";
$extra .= "\t\t\t\t<b>{$strModifyCampaign}</b><br>" . "\n";
$extra .= "\t\t\t\t<img src='images/break.gif' height='1' width='160' vspace='4'><br>" . "\n";
$extra .= "\t\t\t\t<img src='images/icon-move-campaign.gif' align='absmiddle'> {$strMoveTo}<br>" . "\n";
$extra .= "\t\t\t\t<img src='images/spacer.gif' height='1' width='160' vspace='2'><br>" . "\n";
$extra .= "\t\t\t\t " . "\n";
$extra .= "\t\t\t\t<select name='moveto' style='width: 110;'>" . "\n";
if (phpAds_isUser(phpAds_Admin)) {
$query = "SELECT clientid,clientname" . " FROM " . $phpAds_config['tbl_clients'] . " WHERE clientid!=" . $clientid;
} elseif (phpAds_isUser(phpAds_Agency)) {
$query = "SELECT clientid,clientname" . " FROM " . $phpAds_config['tbl_clients'] . " WHERE clientid!=" . $clientid . " AND agencyid=" . phpAds_getUserID();
}
$res = phpAds_dbQuery($query) or phpAds_sqlDie();
while ($row = phpAds_dbFetchArray($res)) {
$extra .= "\t\t\t\t\t<option value='" . $row['clientid'] . "'>" . phpAds_buildName($row['clientid'], $row['clientname']) . "</option>\n";
}
$extra .= "\t\t\t\t</select> \n";
$extra .= "\t\t\t\t<input type='image' src='images/" . $phpAds_TextDirection . "/go_blue.gif'><br>\n";
$extra .= "\t\t\t\t<img src='images/break.gif' height='1' width='160' vspace='4'><br>\n";
$extra .= "\t\t\t\t<img src='images/icon-recycle.gif' align='absmiddle'>\n";
$extra .= "\t\t\t\t<a href='campaign-delete.php?clientid={$clientid}&campaignid={$campaignid}&returnurl=advertiser-campaigns.php'" . phpAds_DelConfirm($strConfirmDeleteTracker) . ">{$strDelete}</a><br>\n";
$extra .= "\t\t\t\t</form>\n";
phpAds_PageHeader("4.1.3.5", $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"));
}
if (isset($campaignid) && $campaignid != '') {
$res = phpAds_dbQuery("SELECT *" . " FROM " . $phpAds_config['tbl_campaigns'] . " WHERE campaignid=" . $campaignid) or phpAds_sqlDie();
function phpAds_getZoneArray()
{
global $phpAds_config;
if (phpAds_isUser(phpAds_Admin)) {
$query = "SELECT zoneid,zonename" . " FROM " . $phpAds_config['tbl_zones'];
} elseif (phpAds_isUser(phpAds_Agency)) {
$query = "SELECT zoneid,zonename" . " FROM " . $phpAds_config['tbl_zones'] . " AS z" . "," . $phpAds_config['tbl_affiliates'] . " AS a" . " WHERE a.affiliateid=z.affiliateid" . " AND a.agencyid=" . phpAds_getUserID();
} elseif (phpAds_isUser(phpAds_Client)) {
$query = "SELECT zoneid,zonename" . " FROM " . $phpAds_config['tbl_zones'] . " WHERE affiliateid=" . phpAds_getUserID();
}
$res = phpAds_dbQuery($query);
while ($row = phpAds_dbFetchArray($res)) {
$zoneArray[$row['zoneid']] = phpAds_buildName($row['zoneid'], $row['zonename']);
}
return $zoneArray;
}
