function phpAds_LoadDbConfig($agencyid = 0)
{
global $phpAds_config, $phpAds_settings_information;
if ((!empty($GLOBALS['phpAds_db_link']) || phpAds_dbConnect()) && isset($phpAds_config['tbl_config'])) {
$query = "SELECT *" . " FROM " . $phpAds_config['tbl_config'] . " WHERE agencyid=" . $agencyid;
if ($res = phpAds_dbQuery($query)) {
if ($row = phpAds_dbFetchArray($res, 0)) {
while (list($k, $v) = each($phpAds_settings_information)) {
if (!$v['sql'] || !isset($row[$k])) {
continue;
}
switch ($v['type']) {
case 'boolean':
$row[$k] = $row[$k] == 't';
break;
case 'integer':
$row[$k] = (int) $row[$k];
break;
case 'array':
$row[$k] = unserialize($row[$k]);
break;
case 'float':
$row[$k] = (double) $row[$k];
break;
}
$phpAds_config[$k] = $row[$k];
}
reset($phpAds_settings_information);
return true;
}
}
}
return false;
}
function Plugin_GlobalhistoryExecute($delimiter = ",")
{
global $phpAds_config, $date_format;
global $strGlobalHistory, $strTotal, $strDay, $strViews, $strClicks, $strCTRShort;
header("Content-type: application/csv\nContent-Disposition: \"inline; filename=globalhistory.csv\"");
if (phpAds_isUser(phpAds_Admin)) {
$res_query = "\n\t\tSELECT\n\t\t\tDATE_FORMAT(day, '" . $date_format . "') as day,\n\t\t\tSUM(views) AS adviews,\n\t\t\tSUM(clicks) AS adclicks\n\t\tFROM\n\t\t\t" . $phpAds_config['tbl_adstats'] . "\n\t\tGROUP BY\n\t\t\tday\n\t";
} else {
$res_query = "SELECT\n\t\t\t\t\t\tDATE_FORMAT(s.day, '" . $date_format . "') as day,\n\t\t\t\t\t\tSUM(s.views) AS adviews,\n\t\t\t\t\t\tSUM(s.clicks) AS adclicks\n\t\t\t\t\tFROM\n\t\t\t\t\t\t" . $phpAds_config['tbl_adstats'] . " \tas s,\n\t\t\t\t\t\t" . $phpAds_config['tbl_banners'] . " \tas b,\n\t\t\t\t\t\t" . $phpAds_config['tbl_campaigns'] . " as m,\n\t\t\t\t\t\t" . $phpAds_config['tbl_clients'] . " \tas c\n\t\t\t\t\tWHERE\n\t\t\t\t\t\ts.bannerid \t\t= b.bannerid AND\n\t\t\t\t\t\tb.campaignid \t= m.campaignid AND\n\t\t\t\t\t\tm.clientid \t\t= c.clientid AND\n\t\t\t\t\t\tc.agencyid \t\t= " . phpAds_getUserID() . "\n\t\t\t\t\tGROUP BY\n\t\t\t\t\t\tday";
}
$res_banners = phpAds_dbQuery($res_query) or phpAds_sqlDie();
while ($row_banners = phpAds_dbFetchArray($res_banners)) {
$stats[$row_banners['day']]['views'] = $row_banners['adviews'];
$stats[$row_banners['day']]['clicks'] = $row_banners['adclicks'];
}
echo $strGlobalHistory . "\n\n";
echo $strDay . $delimiter . $strViews . $delimiter . $strClicks . $delimiter . $strCTRShort . "\n";
$totalclicks = 0;
$totalviews = 0;
if (isset($stats) && is_array($stats)) {
for (reset($stats); $key = key($stats); next($stats)) {
$row = array();
//$key = implode('/',array_reverse(split('[-]',$key)));
$row[] = $key;
$row[] = $stats[$key]['views'];
$row[] = $stats[$key]['clicks'];
$row[] = phpAds_buildCTR($stats[$key]['views'], $stats[$key]['clicks']);
echo implode($delimiter, $row) . "\n";
$totalclicks += $stats[$key]['clicks'];
$totalviews += $stats[$key]['views'];
}
}
echo "\n";
echo $strTotal . $delimiter . $totalviews . $delimiter . $totalclicks . $delimiter . phpAds_buildCTR($totalviews, $totalclicks) . "\n";
}
function Plugin_TrackerHistoryExecute($clientid, $start, $end, $delimiter = ",")
{
global $phpAds_config, $date_format;
global $strCampaign, $strTotal, $strDay, $strViews, $strClicks, $strCTRShort;
header("Content-type: application/csv\nContent-Disposition: inline; filename=trackerhistory.csv");
// get all trackers and group them by advertiser and campaign
$res_trackers = phpAds_dbQuery("SELECT\n\t\t\t\t\t\t\t\t\t\ttrackers.trackerid,\n\t\t\t\t\t\t\t\t\t\ttrackers.trackername\n\t\t\t\t\t\t\t\t\tFROM\n\t\t\t\t\t\t\t\t\t\t" . $phpAds_config['tbl_trackers'] . " as trackers\n\t\t\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\t\t\ttrackers.clientid = " . $clientid . "\n\t\t\t\t\t\t\t\t\t");
$trackers = array();
while ($row = phpAds_dbFetchArray($res_trackers)) {
$trackers[$row['trackerid']] = array();
$trackers[$row['trackerid']]['name'] = $row['trackername'];
}
$res_total_conversions = phpAds_dbQuery("SELECT\n\t\t\t\t\t\t\t\t\t\t\ttrackers.trackerid,\n\t\t\t\t\t\t\t\t\t\t\tcount(conversions.conversionid) as hits\n\t\t\t\t\t\t\t\t\t\tFROM\n\t\t\t\t\t\t\t\t\t\t\t" . $phpAds_config['tbl_adconversions'] . " as conversions,\n\t\t\t\t\t\t\t\t\t\t\t" . $phpAds_config['tbl_trackers'] . " as trackers\n\t\t\t\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\t\t\t\ttrackers.trackerid = conversions.trackerid\n\t\t\t\t\t\t\t\t\t\t\tAND trackers.clientid = " . $clientid . "\n\t\t\t\t\t\t\t\t\t\t\tAND conversions.t_stamp >= '" . str_replace("/", "", $start) . "000000'\n\t\t\t\t\t\t\t\t\t\t\tAND conversions.t_stamp <= '" . str_replace("/", "", $end) . "235959'\n\t\t\t\t\t\t\t\t\t\tGROUP BY\n\t\t\t\t\t\t\t\t\t\t\tconversions.trackerid\n\t\t\t\t\t\t\t\t");
while ($row = phpAds_dbFetchArray($res_total_conversions)) {
$trackers[$row['trackerid']]['total_conversions'] = $row['hits'];
}
$res_conversions = phpAds_dbQuery("SELECT\n\t\t\t\t\t\t\t\t\t\t\ttrackers.trackerid,\n\t\t\t\t\t\t\t\t\t\t\tcount(*) as hits\n\t\t\t\t\t\t\t\t\t\tFROM\n\t\t\t\t\t\t\t\t\t\t\t" . $phpAds_config['tbl_conversionlog'] . " as conversions,\n\t\t\t\t\t\t\t\t\t\t\t" . $phpAds_config['tbl_trackers'] . " as trackers\n\t\t\t\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\t\t\t\ttrackers.trackerid = conversions.trackerid\n\t\t\t\t\t\t\t\t\t\t\tAND trackers.clientid = " . $clientid . "\n\t\t\t\t\t\t\t\t\t\t\tAND conversions.t_stamp >= '" . str_replace("/", "", $start) . "000000'\n\t\t\t\t\t\t\t\t\t\t\tAND conversions.t_stamp <= '" . str_replace("/", "", $end) . "235959'\n\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\tGROUP BY\n\t\t\t\t\t\t\t\t\t\t\tconversions.trackerid\n\t\t\t\t\t\t\t\t");
while ($row = phpAds_dbFetchArray($res_conversions)) {
$trackers[$row['trackerid']]['conversions'] = $row['hits'];
}
//echo "<pre>";
//print_r($trackers);
//echo "</pre>";
echo "Client: " . strip_tags(phpAds_getClientName($clientid)) . " - " . $start . " - " . $end . "\n\n";
echo $GLOBALS['strName'] . $delimiter . $GLOBALS['strID'] . $delimiter . "Conversions" . $delimiter . "Total Hits" . "\n";
echo "\n";
foreach ($trackers as $id => $tracker) {
echo $tracker['name'] . $delimiter . $id . $delimiter . $tracker['conversions'] . $delimiter . $tracker['total_conversions'] . $delimiter . "\n";
}
}
function Plugin_AffiliatehistoryExecute($affiliateid, $delimiter = ",")
{
global $phpAds_config, $date_format;
global $strAffiliate, $strTotal, $strDay, $strViews, $strClicks, $strCTRShort;
header("Content-type: application/csv\nContent-Disposition: \"inline; filename=affiliatehistory.csv\"");
$idresult = phpAds_dbQuery("\n\t\tSELECT\n\t\t\tzoneid\n\t\tFROM\n\t\t\t" . $phpAds_config['tbl_zones'] . "\n\t\tWHERE\n\t\t\taffiliateid = '" . $affiliateid . "'\n\t");
while ($row = phpAds_dbFetchArray($idresult)) {
$zoneids[] = "zoneid = " . $row['zoneid'];
}
$res_query = "\n\t\tSELECT\n\t\t\tDATE_FORMAT(day, '" . $date_format . "') as day,\n\t\t\tSUM(views) AS adviews,\n\t\t\tSUM(clicks) AS adclicks\n\t\tFROM\n\t\t\t" . $phpAds_config['tbl_adstats'] . "\n\t\tWHERE\n\t\t\t(" . implode(' OR ', $zoneids) . ")\n\t\tGROUP BY\n\t\t\tday\n\t";
$res_banners = phpAds_dbQuery($res_query) or phpAds_sqlDie();
while ($row_banners = phpAds_dbFetchArray($res_banners)) {
$stats[$row_banners['day']]['views'] = $row_banners['adviews'];
$stats[$row_banners['day']]['clicks'] = $row_banners['adclicks'];
}
echo $strAffiliate . ": " . strip_tags(phpAds_getAffiliateName($affiliateid)) . "\n\n";
echo $strDay . $delimiter . $strViews . $delimiter . $strClicks . $delimiter . $strCTRShort . "\n";
$totalclicks = 0;
$totalviews = 0;
if (isset($stats) && is_array($stats)) {
for (reset($stats); $key = key($stats); next($stats)) {
$row = array();
// $key = implode('/',array_reverse(split('[-]',$key)));
$row[] = $key;
$row[] = $stats[$key]['views'];
$row[] = $stats[$key]['clicks'];
$row[] = phpAds_buildCTR($stats[$key]['views'], $stats[$key]['clicks']);
echo implode($delimiter, $row) . "\n";
$totalclicks += $stats[$key]['clicks'];
$totalviews += $stats[$key]['views'];
}
}
echo "\n";
echo $strTotal . $delimiter . $totalviews . $delimiter . $totalclicks . $delimiter . phpAds_buildCTR($totalviews, $totalclicks) . "\n";
}
function phpAds_getCampaign($query)
{
$campaigns = array();
$res = phpAds_dbQuery($query) or phpAds_sqlDie();
while ($row = phpAds_dbFetchArray($res)) {
$campaigns[$row['campaignid']] = $row;
}
return $campaigns;
}
function Plugin_GlobalhistoryExecute($delimiter = 't', $quotes = '')
{
global $phpAds_config, $date_format;
global $strGlobalHistory, $strTotal, $strDay, $strViews, $strClicks, $strCTRShort;
// Expand delimiter and quotes
if ($delimiter == 't') {
$delimiter = "\t";
}
if ($quotes == '1') {
$quotes = "'";
}
if ($quotes == '2') {
$quotes = '"';
}
header("Content-type: application/csv");
header("Content-Disposition: inline; filename=\"publisherhistory.csv\"");
if ($phpAds_config['compact_stats']) {
$res_query = "\n\t\t\tSELECT\n\t\t\t\tDATE_FORMAT(day, '%Y%m%d') as date,\n\t\t\t\tDATE_FORMAT(day, '{$date_format}') as date_formatted,\n\t\t\t\tSUM(views) AS adviews,\n\t\t\t\tSUM(clicks) AS adclicks\n\t\t\tFROM\n\t\t\t\t" . $phpAds_config['tbl_adstats'] . "\n\t\t\tGROUP BY\n\t\t\t\tday\n\t\t\tORDER BY\n\t\t\t\tdate\n\t\t";
$res_banners = phpAds_dbQuery($res_query) or phpAds_sqlDie();
while ($row_banners = phpAds_dbFetchArray($res_banners)) {
$stats[$row_banners['date_formatted']]['views'] = $row_banners['adviews'];
$stats[$row_banners['date_formatted']]['clicks'] = $row_banners['adclicks'];
}
} else {
$res_query = "\n\t\t\tSELECT\n\t\t\t\tDATE_FORMAT(t_stamp, '%Y%m%d') as date,\n\t\t\t\tDATE_FORMAT(t_stamp, '" . $date_format . "') as date_formatted,\n\t\t\t\tcount(bannerid) as adviews\n\t\t\tFROM\n\t\t\t\t" . $phpAds_config['tbl_adviews'] . "\n\t\t\tGROUP BY\n\t\t\t\tdate, date_formatted\n\t\t\tORDER BY\n\t\t\t\tdate\n\t\t";
$res_banners = phpAds_dbQuery($res_query) or phpAds_sqlDie();
while ($row_banners = phpAds_dbFetchArray($res_banners)) {
$stats[$row_banners['date_formatted']]['views'] = $row_banners['adviews'];
$stats[$row_banners['date_formatted']]['clicks'] = 0;
}
$res_query = "\n\t\t\tSELECT\n\t\t\t\tDATE_FORMAT(t_stamp, '%Y%m%d') as date,\n\t\t\t\tDATE_FORMAT(t_stamp, '" . $date_format . "') as date_formatted,\n\t\t\t\tcount(bannerid) as adclicks\n\t\t\tFROM\n\t\t\t\t" . $phpAds_config['tbl_adclicks'] . "\n\t\t\tGROUP BY\n\t\t\t\tdate, date_formatted\n\t\t\tORDER BY\n\t\t\t\tdate\n\t\t";
$res_banners = phpAds_dbQuery($res_query) or phpAds_sqlDie();
while ($row_banners = phpAds_dbFetchArray($res_banners)) {
$stats[$row_banners['date_formatted']]['clicks'] = $row_banners['adclicks'];
}
}
echo $quotes . $strGlobalHistory . $quotes . "\n\n";
echo $quotes . $strDay . $quotes . $delimiter . $quotes . $strViews . $quotes . $delimiter;
echo $quotes . $strClicks . $quotes . $delimiter . $quotes . $strCTRShort . $quotes . "\n";
$totalclicks = 0;
$totalviews = 0;
if (isset($stats) && is_array($stats)) {
foreach (array_keys($stats) as $key) {
$row = array();
$row[] = $quotes . $key . $quotes;
$row[] = $quotes . $stats[$key]['views'] . $quotes;
$row[] = $quotes . $stats[$key]['clicks'] . $quotes;
$row[] = $quotes . phpAds_buildCTR($stats[$key]['views'], $stats[$key]['clicks']) . $quotes;
echo implode($delimiter, $row) . "\n";
$totalclicks += $stats[$key]['clicks'];
$totalviews += $stats[$key]['views'];
}
}
echo "\n";
echo $quotes . $strTotal . $quotes . $delimiter . $quotes . $totalviews . $quotes . $delimiter;
echo $quotes . $totalclicks . $quotes . $delimiter . $quotes . phpAds_buildCTR($totalviews, $totalclicks) . $quotes . "\n";
}
function phpAds_showBanners()
{
global $phpAds_config;
global $strUntitled, $strName, $strID, $strWeight;
global $strProbability, $strPriority, $strRecalculatePriority;
global $phpAds_TextDirection;
$res = phpAds_dbQuery("\n\t\tSELECT\n\t\t\t*\n\t\tFROM\n\t\t\t" . $phpAds_config['tbl_banners'] . "\n\t\tORDER BY\n\t\t\tpriority DESC\n\t");
$rows = array();
$prioritysum = 0;
while ($tmprow = phpAds_dbFetchArray($res)) {
if ($tmprow['priority']) {
$prioritysum += $tmprow['priority'];
$rows[$tmprow['bannerid']] = $tmprow;
}
}
if (is_array($rows)) {
$i = 0;
// Header
echo "<table width='100%' border='0' align='center' cellspacing='0' cellpadding='0'>";
echo "<tr height='25'>";
echo "<td height='25'><b> " . $strName . "</b></td>";
echo "<td height='25'><b>" . $strID . " </b></td>";
echo "<td height='25'><b>" . $strPriority . "</b></td>";
echo "<td height='25'><b>" . $strProbability . "</b></td>";
echo "</tr>";
echo "<tr height='1'><td colspan='5' bgcolor='#888888'><img src='images/break.gif' height='1' width='100%'></td></tr>";
// Banners
foreach (array_keys($rows) as $key) {
$name = phpAds_getBannerName($rows[$key]['bannerid'], 60, false);
if ($i > 0) {
echo "<tr height='1'><td colspan='5' bgcolor='#888888'><img src='images/break-l.gif' height='1' width='100%'></td></tr>";
}
echo "<tr height='25' " . ($i % 2 == 0 ? "bgcolor='#F6F6F6'" : "") . ">";
echo "<td height='25'>";
echo " ";
// Banner icon
if ($rows[$key]['storagetype'] == 'html') {
echo "<img src='images/icon-banner-html.gif' align='absmiddle'> ";
} elseif ($rows[$key]['storagetype'] == 'url') {
echo "<img src='images/icon-banner-url.gif' align='absmiddle'> ";
} else {
echo "<img src='images/icon-banner-stored.gif' align='absmiddle'> ";
}
// Name
echo $name;
echo "</td>";
echo "<td height='25'>" . $rows[$key]['bannerid'] . "</td>";
echo "<td height='25'>" . $rows[$key]['priority'] . "</td>";
echo "<td height='25'>" . number_format($rows[$key]['priority'] / $prioritysum * 100, $phpAds_config['percentage_decimals']) . "%</td>";
echo "</tr>";
$i++;
}
// Footer
echo "<tr height='1'><td colspan='5' bgcolor='#888888'><img src='images/break.gif' height='1' width='100%'></td></tr>";
echo "</table>";
}
}
function phpAds_MaintenanceSelection($section)
{
global $phpAds_config;
global $phpAds_TextDirection;
global $strChooseSection, $strPriority, $strCache, $strBanners, $strStats, $strStorage, $strMaintenance;
if ($phpAds_config['compact_stats']) {
// Determine left over verbose stats
$viewresult = phpAds_dbQuery("SELECT COUNT(*) AS cnt FROM " . $phpAds_config['tbl_adviews']);
$viewrow = phpAds_dbFetchArray($viewresult);
if (isset($viewrow["cnt"]) && $viewrow["cnt"] != '') {
$verboseviews = $viewrow["cnt"];
} else {
$verboseviews = 0;
}
$clickresult = phpAds_dbQuery("SELECT COUNT(*) AS cnt FROM " . $phpAds_config['tbl_adclicks']);
$clickrow = phpAds_dbFetchArray($viewresult);
if (isset($clickrow["cnt"]) && $clickrow["cnt"] != '') {
$verboseclicks = $clickrow["cnt"];
} else {
$verboseclicks = 0;
}
}
?>
<script language="JavaScript">
<!--
function maintenance_goto_section()
{
s = document.maintenance_selection.section.selectedIndex;
s = document.maintenance_selection.section.options[s].value;
document.location = 'maintenance-' + s + '.php';
}
// -->
</script>
<?php
echo "<table border='0' width='100%' cellpadding='0' cellspacing='0'>";
echo "<tr><form name='maintenance_selection'><td height='35'>";
echo "<b>" . $strChooseSection . ": </b>";
echo "<select name='section' onChange='maintenance_goto_section();'>";
echo "<option value='maintenance'" . ($section == 'maintenance' ? ' selected' : '') . ">" . $strMaintenance . "</option>";
echo "<option value='banners'" . ($section == 'banners' ? ' selected' : '') . ">" . $strBanners . "</option>";
echo "<option value='priority'" . ($section == 'priority' ? ' selected' : '') . ">" . $strPriority . "</option>";
if ($phpAds_config['compact_stats'] && ($verboseviews > 0 || $verboseclicks > 0)) {
echo "<option value='stats'" . ($section == 'stats' ? ' selected' : '') . ">" . $strStats . "</option>";
}
if ($phpAds_config['type_web_allow'] == true && ($phpAds_config['type_web_mode'] == 0 && $phpAds_config['type_web_dir'] != '' || $phpAds_config['type_web_mode'] == 1 && $phpAds_config['type_web_ftp'] != '') && $phpAds_config['type_web_url'] != '') {
echo "<option value='storage'" . ($section == 'storage' ? ' selected' : '') . ">" . $strStorage . "</option>";
}
if ($phpAds_config['delivery_caching'] != 'none') {
echo "<option value='cache'" . ($section == 'zones' ? ' selected' : '') . ">" . $strCache . "</option>";
}
echo "</select> <a href='javascript:void(0)' onClick='maintenance_goto_section();'>";
echo "<img src='images/" . $phpAds_TextDirection . "/go_blue.gif' border='0'></a>";
echo "</td></form></tr>";
echo "</table>";
phpAds_ShowBreak();
}
function phpAds_cacheInfo()
{
global $phpAds_config;
$result = array();
$cacheres = phpAds_dbQuery("SELECT * FROM " . $phpAds_config['tbl_cache']);
while ($cacherow = phpAds_dbFetchArray($cacheres)) {
$result[$cacherow['cacheid']] = strlen($cacherow['content']);
}
return $result;
}
function phpAds_cacheInfo()
{
global $phpAds_config;
$result = array();
$cacheres = phpAds_dbQuery("SELECT cacheid, LENGTH(content) AS len FROM " . $phpAds_config['tbl_cache']);
while ($cacherow = phpAds_dbFetchArray($cacheres)) {
$result[$cacherow['cacheid']] = $cacherow['len'];
}
return $result;
}
function phpAds_getSourceStats($query, $listorder, $orderdirection)
{
$res_stats = phpAds_dbQuery($query) or phpAds_sqlDie();
while ($row_stats = phpAds_dbFetchArray($res_stats)) {
$source = $row_stats['source'];
if (strlen($source) > 0) {
$sources = phpAds_buildSourceArray($sources, $source, '', $row_stats);
}
}
// Sort the array
$ascending = !($orderdirection == 'down' || $orderdirection == '');
phpAds_qsort($sources, $listorder, $ascending);
}
function phpAds_SessionDataFetch()
{
global $phpAds_config;
global $Session;
if (isset($_COOKIE['sessionID']) && preg_match('/^[0-9a-f]+$/D', $_COOKIE['sessionID'])) {
$result = phpAds_dbQuery("SELECT sessiondata FROM " . $phpAds_config['tbl_session'] . " WHERE sessionid='" . addslashes($_COOKIE['sessionID']) . "'" . " AND UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(lastused) < 3600");
if ($row = phpAds_dbFetchArray($result)) {
$Session = unserialize($row['sessiondata']);
// Reset LastUsed, prevent from timing out
phpAds_dbQuery("UPDATE " . $phpAds_config['tbl_session'] . " SET lastused = NOW() WHERE sessionid = '" . addslashes($_COOKIE['sessionID']) . "'");
}
} else {
$_COOKIE['sessionID'] = '';
return False;
}
}
function _getTrackerArray()
{
$conf = $GLOBALS['_MAX']['CONF'];
$where = "c.clientid = t.clientid";
if (OA_Permission::isAccount(OA_ACCOUNT_MANAGER)) {
$where .= " AND c.agencyid = " . OA_Permission::getEntityId();
} elseif (OA_Permission::isAccount(OA_ACCOUNT_ADVERTISER)) {
$where .= " AND t.clientid = " . OA_Permission::getEntityId();
}
$query = "\n SELECT\n c.clientname AS client_name,\n c.clientid AS client_id,\n t.trackername AS tracker_name,\n t.trackerid AS tracker_id\n FROM\n {$conf['table']['trackers']} AS t,\n {$conf['table']['clients']} AS c\n WHERE\n {$where}\n ORDER BY\n c.clientname,t.trackername\n ";
$res = phpAds_dbQuery($query);
while ($row = phpAds_dbFetchArray($res)) {
$trackerArray[$row['tracker_id']] = "<span dir='" . $GLOBALS['phpAds_TextDirection'] . "'>[id" . $row['client_id'] . "] " . $row['client_name'] . " - [id" . $row['tracker_id'] . "] " . $row['tracker_name'] . "</span> ";
}
return $trackerArray;
}
function phpAds_DeleteBanner($bannerid)
{
global $phpAds_config;
// Cleanup webserver stored image
$res = phpAds_dbQuery("\n\t\tSELECT\n\t\t\tstoragetype, filename\n\t\tFROM\n\t\t\t" . $phpAds_config['tbl_banners'] . "\n\t\tWHERE\n\t\t\tbannerid = '{$bannerid}'\n\t") or phpAds_sqlDie();
if ($row = phpAds_dbFetchArray($res)) {
if (($row['storagetype'] == 'web' || $row['storagetype'] == 'sql') && $row['filename'] != '') {
phpAds_ImageDelete($row['storagetype'], $row['filename']);
}
}
// Delete banner
$res = phpAds_dbQuery("\n\t\tDELETE FROM\n\t\t\t" . $phpAds_config['tbl_banners'] . "\n\t\tWHERE\n\t\t\tbannerid = '{$bannerid}'\n\t\t") or phpAds_sqlDie();
// Delete banner ACLs
$res = phpAds_dbQuery("\n\t\tDELETE FROM\n\t\t\t" . $phpAds_config['tbl_acls'] . "\n\t\tWHERE\n\t\t\tbannerid = '{$bannerid}'\n\t\t") or phpAds_sqlDie();
// Delete statistics for this banner
phpAds_deleteStatsByBannerID($bannerid);
}
/**
* @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;
}
function phpAds_fetchJavascriptVariables($trackerid)
{
global $phpAds_config;
include phpAds_path . '/libraries/deliverycache/cache-' . $phpAds_config['delivery_caching'] . '.inc.php';
// Get cache
$cache = phpAds_cacheFetch('what=tracker:' . $trackerid);
if (!$cache) {
$variables_result = phpAds_dbQuery("\n\t\t\t\t\t\t\t\tSELECT \n\t\t\t\t\t\t\t\t\tvariableid,\n\t\t\t\t\t\t\t\t\tname,\n\t\t\t\t\t\t\t\t\tvariabletype\n\t\t\t\t\t\t\t\tFROM \n\t\t\t\t\t\t\t\t\t" . $phpAds_config['tbl_variables'] . "\n\t\t\t\t\t\t\t\tWHERE \n\t\t\t\t\t\t\t\t\ttrackerid='" . $trackerid . "'");
while ($variable = phpAds_dbFetchArray($variables_result)) {
$cache[$variable['variableid']] = array('name' => $variable['name'], 'variabletype' => $variable['variabletype']);
}
if (count(cache) > 0) {
phpAds_cacheStore('what=tracker:' . $trackerid, $cache);
} else {
return;
}
}
return $cache;
}
function phpAds_DeleteCampaign($campaignid)
{
global $phpAds_config;
// Delete Campaign
$res = phpAds_dbQuery("\n\t\tDELETE FROM\n\t\t\t" . $phpAds_config['tbl_clients'] . "\n\t\tWHERE\n\t\t\tclientid = '{$campaignid}'\n\t") or phpAds_sqlDie();
// Loop through each banner
$res_banners = phpAds_dbQuery("\n\t\tSELECT\n\t\t\tbannerid,\n\t\t\tstoragetype,\n\t\t\tfilename\n\t\tFROM\n\t\t\t" . $phpAds_config['tbl_banners'] . "\n\t\tWHERE\n\t\t\tclientid = '{$campaignid}'\n\t") or phpAds_sqlDie();
while ($row = phpAds_dbFetchArray($res_banners)) {
// Cleanup stored images for each banner
if (($row['storagetype'] == 'web' || $row['storagetype'] == 'sql') && $row['filename'] != '') {
phpAds_ImageDelete($row['storagetype'], $row['filename']);
}
// Delete Banner ACLs
phpAds_dbQuery("\n\t\t\tDELETE FROM\n\t\t\t\t" . $phpAds_config['tbl_acls'] . "\n\t\t\tWHERE\n\t\t\t\tbannerid = " . $row['bannerid'] . "\n\t\t") or phpAds_sqlDie();
// Delete stats for each banner
phpAds_deleteStats($row['bannerid']);
}
// Delete Banners
phpAds_dbQuery("\n\t\tDELETE FROM\n\t\t\t" . $phpAds_config['tbl_banners'] . "\n\t\tWHERE\n\t\t\tclientid = '{$campaignid}'\n\t") or phpAds_sqlDie();
}
function phpAds_getSources($name = '', $parent = '')
{
global $phpAds_config;
if (strlen($parent) > 0) {
$n = substr_count($parent, '/') + 2;
$query = "SELECT" . " SUBSTRING_INDEX(SUBSTRING_INDEX(source,'/'," . $n . "),'/',-1) AS source_part" . ",COUNT(*) AS sum_views" . " FROM " . $phpAds_config['tbl_adviews'] . " WHERE source LIKE '" . $parent . "/%'" . " AND t_stamp > DATE_SUB(NOW(), INTERVAL 7 DAY)" . " GROUP BY source_part" . " ORDER BY sum_views DESC";
} else {
$query = "SELECT" . " SUBSTRING_INDEX(source, '/', 1) AS source_part" . ",COUNT(*) AS sum_views" . " FROM " . $phpAds_config['tbl_adviews'] . " WHERE t_stamp > DATE_SUB(NOW(), INTERVAL 7 DAY)" . " GROUP BY source_part" . " ORDER BY sum_views DESC";
}
$source_arr = array();
$res_sources = phpAds_dbQuery($query) or phpAds_sqlDie();
while ($row_sources = phpAds_dbFetchArray($res_sources)) {
$source_arr[] = $row_sources;
//echo "filing source: ".$row_sources['source']."...<br>\n";
//phpAds_buildSourceArrayChildren($source_arr, $row_sources['source']);
}
// Sort the array
//$ascending = !( ($orderdirection == 'down') || ($orderdirection == '') );
//phpAds_sortSources($source_arr, $listorder, $ascending);
return $source_arr;
}
function phpAds_getVerbose($base, $count)
{
global $phpAds_config;
$begin_timestamp = date('YmdHis', phpAds_makeTimestamp($base, $count * 60 * 60 * 24));
$end_timestamp = date('YmdHis', phpAds_makeTimestamp($base, ($count + 1) * 60 * 60 * 24 - 1));
// Get views
$result = phpAds_dbQuery("\n\t\tSELECT\n\t\t\tbannerid,\n\t\t\tzoneid,\n\t\t\tsource,\n\t\t\tHOUR(t_stamp) AS hour,\n\t\t\tCOUNT(*) AS qnt\n\t\tFROM\n\t\t\t" . $phpAds_config['tbl_adviews'] . "\n\t\tWHERE\n\t\t\tt_stamp >= {$begin_timestamp} AND t_stamp <= {$end_timestamp}\n\t\tGROUP BY \n\t\t\tbannerid, zoneid, source, hour\n\t") or phpAds_sqlDie();
while ($row = phpAds_dbFetchArray($result)) {
$stats["'" . $row['bannerid'] . "'"]["'" . $row['zoneid'] . "'"]["'" . $row['hour'] . "'"]["'" . $row['source'] . "'"] = array('views' => $row['qnt'], 'clicks' => 0);
}
// Get clicks
$result = phpAds_dbQuery("\n\t\tSELECT\n\t\t\tbannerid,\n\t\t\tzoneid,\n\t\t\tsource,\n\t\t\tHOUR(t_stamp) AS hour,\n\t\t\tCOUNT(*) AS qnt\n\t\tFROM\n\t\t\t" . $phpAds_config['tbl_adclicks'] . "\n\t\tWHERE\n\t\t\tt_stamp >= {$begin_timestamp} AND t_stamp <= {$end_timestamp}\n\t\tGROUP BY \n\t\t\tbannerid, zoneid, source, hour\n\t") or phpAds_sqlDie();
while ($row = phpAds_dbFetchArray($result)) {
if (isset($stats["'" . $row['bannerid'] . "'"]["'" . $row['zoneid'] . "'"]["'" . $row['hour'] . "'"]["'" . $row['source'] . "'"])) {
$stats["'" . $row['bannerid'] . "'"]["'" . $row['zoneid'] . "'"]["'" . $row['hour'] . "'"]["'" . $row['source'] . "'"]['clicks'] = $row['qnt'];
} else {
$stats["'" . $row['bannerid'] . "'"]["'" . $row['zoneid'] . "'"]["'" . $row['hour'] . "'"]["'" . $row['source'] . "'"] = array('views' => 0, 'clicks' => $row['qnt']);
}
}
if (isset($stats) && count($stats)) {
return $stats;
}
}
echo "<input type='hidden' name='previousactive' value='" . (isset($row["active"]) ? $row["active"] : '') . "'>";
echo "</td></tr></table>";
echo "</td></tr>";
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='submit' name='submit' value='" . $strSaveChanges . "' tabindex='" . $tabindex++ . "'>";
echo "</form>";
/*********************************************************/
/* Form requirements */
/*********************************************************/
// Get unique affiliate
$unique_names = array();
$res = phpAds_dbQuery("SELECT * FROM " . $phpAds_config['tbl_clients'] . " WHERE parent = " . $clientid . " AND clientid != '" . $campaignid . "'");
while ($row = phpAds_dbFetchArray($res)) {
$unique_names[] = $row['clientname'];
}
?>
<script language='JavaScript'>
<!--
phpAds_formSetRequirements('clientname', '<?php
echo addslashes($strName);
?>
', true, 'unique');
phpAds_formSetRequirements('views', '<?php
echo addslashes($strViewsPurchased);
?>
', false, 'number+');
phpAds_formSetRequirements('clicks', '<?php
// Delete stats for this banner
phpAds_deleteStats($bannerid);
// Return to campaign statistics
Header("Location: stats-campaign-banners.php?clientid=" . $clientid . "&campaignid=" . $campaignid);
} elseif (isset($campaignid) && $campaignid != '') {
// Get all banners for this client
$idresult = phpAds_dbQuery(" SELECT\n\t\t\t\t\t\t\t\tbannerid\n\t\t\t\t\t\t\t FROM\n\t\t\t\t\t\t\t \t" . $phpAds_config['tbl_banners'] . "\n\t\t\t\t\t\t\t WHERE\n\t\t\t\t\t\t\t\tclientid = '{$campaignid}'\n\t\t \t\t\t\t ");
// Loop to all banners for this client
while ($row = phpAds_dbFetchArray($idresult)) {
// Delete stats for the banner
phpAds_deleteStats($row['bannerid']);
}
// Return to campaign statistics
Header("Location: stats-client-campaigns.php?clientid=" . $clientid);
} elseif (isset($clientid) && $clientid != '') {
// Get all banners for this client
$idresult = phpAds_dbQuery("\n\t\tSELECT\n\t\t\tb.bannerid\n\t\tFROM\n\t\t\t" . $phpAds_config['tbl_banners'] . " AS b,\n\t\t\t" . $phpAds_config['tbl_clients'] . " AS c\n\t\tWHERE\n\t\t\tc.parent = {$clientid} AND\n\t\t\tc.clientid = b.clientid\n\t");
// Loop to all banners for this client
while ($row = phpAds_dbFetchArray($idresult)) {
// Delete stats for the banner
phpAds_deleteStats($row['bannerid']);
}
// Return to campaign statistics
Header("Location: stats-global-client.php");
} elseif (isset($all) && $all == 'tr' . 'ue') {
phpAds_dbQuery("DELETE FROM " . $phpAds_config['tbl_adviews']) or phpAds_sqlDie();
phpAds_dbQuery("DELETE FROM " . $phpAds_config['tbl_adclicks']) or phpAds_sqlDie();
phpAds_dbQuery("DELETE FROM " . $phpAds_config['tbl_adstats']) or phpAds_sqlDie();
// Return to campaign statistics
Header("Location: stats-global-client.php");
}
header("Location: " . $returnurl . "?affiliateid=" . $moveto . "&zoneid=" . $zoneid);
exit;
}
} elseif (isset($duplicate) && $duplicate == 'true') {
// Duplicate the zone
$res = phpAds_dbQuery("\n\t\t\tSELECT\n\t\t \t\t*\n\t\t\tFROM\n\t\t\t\t" . $phpAds_config['tbl_zones'] . "\n\t\t\tWHERE\n\t\t\t\tzoneid = '" . $zoneid . "'\n\t\t") or phpAds_sqlDie();
if ($row = phpAds_dbFetchArray($res)) {
// Get names
if (ereg("^(.*) \\([0-9]+\\)\$", $row['zonename'], $regs)) {
$basename = $regs[1];
} else {
$basename = $row['zonename'];
}
$names = array();
$res = phpAds_dbQuery("\n\t\t\t\tSELECT\n\t\t\t \t\t*\n\t\t\t\tFROM\n\t\t\t\t\t" . $phpAds_config['tbl_zones'] . "\n\t\t\t") or phpAds_sqlDie();
while ($name = phpAds_dbFetchArray($res)) {
$names[] = $name['zonename'];
}
// Get unique name
$i = 2;
while (in_array($basename . ' (' . $i . ')', $names)) {
$i++;
}
$row['zonename'] = $basename . ' (' . $i . ')';
// Remove bannerid
unset($row['zoneid']);
$values = array();
while (list($name, $value) = each($row)) {
$values[] = $name . " = '" . addslashes($value) . "'";
}
$res = phpAds_dbQuery("\n\t\t \t\tINSERT INTO\n\t\t \t\t\t" . $phpAds_config['tbl_zones'] . "\n\t\t\t\tSET\n\t\t\t\t\t" . implode(", ", $values) . "\n\t \t\t") or phpAds_sqlDie();
$manual['clicks'] += $row_stats['clicks'];
$manual['views'] += $row_stats['views'];
}
}
} else {
$res_stats = phpAds_dbQuery("\n\t\tSELECT\n\t\t\tzoneid,\n\t\t\tcount(*) as views\n\t\tFROM \n\t\t\t" . $phpAds_config['tbl_adviews'] . "\n\t\tWHERE\n\t\t\tbannerid = '" . $bannerid . "'\n\t\tGROUP BY\n\t\t\tzoneid\n\t\t") or phpAds_sqlDie();
while ($row_stats = phpAds_dbFetchArray($res_stats)) {
if (isset($zones[$row_stats['zoneid']])) {
$zones[$row_stats['zoneid']]['views'] = $row_stats['views'];
$zones[$row_stats['zoneid']]['clicks'] = 0;
} else {
$manual['views'] += $row_stats['views'];
}
}
$res_stats = phpAds_dbQuery("\n\t\tSELECT\n\t\t\tzoneid,\n\t\t\tcount(*) as clicks\n\t\tFROM \n\t\t\t" . $phpAds_config['tbl_adclicks'] . "\n\t\tWHERE\n\t\t\tbannerid = '" . $bannerid . "'\n\t\tGROUP BY\n\t\t\tzoneid\n\t\t") or phpAds_sqlDie();
while ($row_stats = phpAds_dbFetchArray($res_stats)) {
if (isset($zones[$row_stats['zoneid']])) {
$zones[$row_stats['zoneid']]['clicks'] = $row_stats['clicks'];
} else {
$manual['clicks'] += $row_stats['clicks'];
}
}
}
// Add ID found in expand to expanded nodes
if (isset($expand) && $expand != '') {
$node_array[] = $expand;
}
for ($i = 0; $i < sizeof($node_array); $i++) {
if (isset($collapse) && $collapse == $node_array[$i]) {
unset($node_array[$i]);
} else {
/* */
/* This program is free software. You can redistribute it and/or modify */
/* it under the terms of the GNU General Public License as published by */
/* the Free Software Foundation; either version 2 of the License. */
/************************************************************************/
// Include required files
require "config.php";
require "lib-banner.inc.php";
require "lib-storage.inc.php";
// Security check
phpAds_checkAccess(phpAds_Admin);
/*********************************************************/
/* Main code */
/*********************************************************/
$res = phpAds_dbQuery("\n\tSELECT\n\t\t*\n\tFROM\n\t\t" . $phpAds_config['tbl_banners'] . "\n");
while ($current = phpAds_dbFetchArray($res)) {
if ($current['storagetype'] == 'sql') {
// Get the filename
$filename = $current['filename'];
// Copy the file
$buffer = phpAds_ImageRetrieve('sql', $filename);
$current['filename'] = phpAds_ImageStore('web', $filename, $buffer);
if ($current['filename'] != false) {
// Delete the original file
phpAds_ImageDelete('sql', $filename);
// Update fields
$current['imageurl'] = '{image_url_prefix}/' . $current['filename'];
$current['storagetype'] = 'web';
// Rebuild banner cache
$current['htmltemplate'] = stripslashes($current['htmltemplate']);
$current['htmlcache'] = addslashes(phpAds_getBannerCache($current));
function days_left($clientid)
{
global $phpAds_config;
global $date_format;
// uses the following language settings:
global $strExpiration, $strNoExpiration, $strDaysLeft, $strEstimated;
// preset return values
$estimated_end = "-";
$days_left = "-";
$description = "";
$absolute = 0;
// Get client record
$client_query = "\n\t\tSELECT\n\t\t\tviews,\n\t\t\tclicks,\n\t\t\texpire,\n\t\t\tDATE_FORMAT(expire, '" . $date_format . "') as expire_f,\n\t\t\tTO_DAYS(expire)-TO_DAYS(NOW()) as days_left\n\t\tFROM\n\t\t\t" . $phpAds_config['tbl_clients'] . "\n\t\tWHERE \n\t\t\tclientid = " . $clientid;
$res_client = phpAds_dbQuery($client_query) or phpAds_sqlDie();
if (phpAds_dbNumRows($res_client) == 1) {
$row_client = phpAds_dbFetchArray($res_client);
// Check if the expiration date is set
if ($row_client['expire'] != '0000-00-00' && $row_client['expire'] != '') {
$expiration[] = array("days_left" => round($row_client["days_left"]), "date" => $row_client["expire_f"], "absolute" => true);
}
if ($row_client["views"] != -1) {
if ($phpAds_config['compact_stats']) {
$view_query = "\n\t \tSELECT\n\t \tSUM(views) as total_views,\n\t MAX(TO_DAYS(day))-TO_DAYS(NOW()) as days_since_last_view,\n\t TO_DAYS(NOW())-MIN(TO_DAYS(day)) as days_since_start\n\t FROM\n\t \t" . $phpAds_config['tbl_banners'] . " AS b\n\t LEFT JOIN " . $phpAds_config['tbl_adstats'] . " AS v USING (bannerid)\n\t WHERE\n\t \tb.clientid = {$clientid}";
} else {
$view_query = "\n\t\t\t\t\tSELECT\n\t\t\t\t\t\tcount(*) as total_views,\n\t\t\t\t\t\tMAX(TO_DAYS(v.t_stamp))-TO_DAYS(NOW()) as days_since_last_view,\n\t\t\t\t\t\tTO_DAYS(NOW())-MIN(TO_DAYS(v.t_stamp)) as days_since_start\n\t\t\t\t\tFROM\n\t\t\t\t\t\t" . $phpAds_config['tbl_adviews'] . " AS v, \n\t\t\t\t\t\t" . $phpAds_config['tbl_banners'] . " AS b \n\t\t\t\t\tWHERE\n\t\t\t\t\t\tb.clientid = {$clientid} \n\t\t\t\t\t\tAND\n\t\t\t\t\t\tb.bannerid = v.bannerid";
}
$res_views = phpAds_dbQuery($view_query) or phpAds_sqlDie();
if (phpAds_dbNumRows($res_views) == 1) {
$row_views = phpAds_dbFetchArray($res_views);
if (!isset($row_views["days_since_start"]) || $row_views["days_since_start"] == '' || $row_views["days_since_start"] == 0 || $row_views["days_since_start"] == null) {
$row_views["days_since_start"] = 1;
}
if (!empty($row_views["total_views"]) && $row_views["total_views"] > 0) {
$days_left = round($row_client["views"] / ($row_views["total_views"] / $row_views["days_since_start"]));
if ($row_client["views"] > 0) {
$estimated_end = strftime($date_format, @mktime(0, 0, 0, date("m"), date("d") + $days_left, date("Y")));
$expiration[] = array("days_left" => $days_left, "date" => $estimated_end, "absolute" => false);
} else {
$estimated_end = strftime($date_format, @mktime(0, 0, 0, date("m"), date("d") - $row_views["days_since_last_view"], date("Y")));
$expiration[] = array("days_left" => 0 - $row_views["days_since_last_view"], "date" => $estimated_end, "absolute" => true);
}
}
}
}
if ($row_client["clicks"] != -1) {
if ($phpAds_config['compact_stats']) {
$click_query = "\n \tSELECT\n \tSUM(clicks) as total_clicks,\n MAX(TO_DAYS(day))-TO_DAYS(NOW()) as days_since_last_click,\n TO_DAYS(NOW())-MIN(TO_DAYS(day)) as days_since_start\n\t\t\t\t\tFROM\n\t\t\t\t\t\t" . $phpAds_config['tbl_adstats'] . "\n\t\t\t\t\t\tLEFT JOIN " . $phpAds_config['tbl_banners'] . " USING (bannerid)\n\t\t\t\t\tWHERE\n\t\t\t\t\t\tclientid = '{$clientid}' AND\n\t\t\t\t\t\tclicks > 0";
} else {
$click_query = "\n\t\t\t\t\tSELECT\n\t\t\t\t\t\tcount(*) as total_clicks,\n\t\t\t\t\t\tMAX(TO_DAYS(c.t_stamp))- TO_DAYS(NOW()) as days_since_last_click,\n\t\t\t\t\t\tTO_DAYS(NOW())-MIN(TO_DAYS(c.t_stamp)) as days_since_start\n\t\t\t\t\tFROM\n\t\t\t\t\t\t" . $phpAds_config['tbl_adclicks'] . " AS c, \n\t\t\t\t\t\t" . $phpAds_config['tbl_banners'] . " AS b \n\t\t\t\t\tWHERE \n\t\t\t\t\t\tb.clientid = {$clientid} AND\n\t\t\t\t\t\tb.bannerid = c.bannerid";
}
$res_clicks = phpAds_dbQuery($click_query) or phpAds_sqlDie();
if (phpAds_dbNumRows($res_clicks) == 1) {
$row_clicks = phpAds_dbFetchArray($res_clicks);
if (!isset($row_clicks["days_since_start"]) || $row_clicks["days_since_start"] == '' || $row_clicks["days_since_start"] == 0 || $row_clicks["days_since_start"] == null) {
$row_clicks["days_since_start"] = 1;
}
if (!empty($row_clicks["total_clicks"]) && $row_clicks["total_clicks"] > 0) {
$days_left = round($row_client["clicks"] / ($row_clicks["total_clicks"] / $row_clicks["days_since_start"]));
if ($row_client["clicks"] > 0) {
$estimated_end = strftime($date_format, @mktime(0, 0, 0, date("m"), date("d") + $days_left, date("Y")));
$expiration[] = array("days_left" => $days_left, "date" => $estimated_end, "absolute" => false);
} else {
$estimated_end = strftime($date_format, @mktime(0, 0, 0, date("m"), date("d") - $row_clicks["days_since_last_view"], date("Y")));
$expiration[] = array("days_left" => 0 - $row_clicks["days_since_last_view"], "date" => $estimated_end, "absolute" => true);
}
}
}
}
}
// Build Return value
if (isset($expiration) && sizeof($expiration) > 0) {
$sooner = $expiration[0];
for ($i = 0; $i < sizeof($expiration); $i++) {
if ($expiration[$i]['days_left'] < $sooner['days_left']) {
$sooner = $expiration[$i];
}
}
if ($sooner['days_left'] < 0) {
$sooner['days_left'] = 0;
}
if ($sooner['absolute']) {
$ret_val[] = $strExpiration . ": " . $sooner['date'] . " (" . $strDaysLeft . ": " . $sooner['days_left'] . ")";
} else {
$ret_val[] = $strEstimated . ": " . $sooner['date'] . " (" . $strDaysLeft . ": " . $sooner['days_left'] . ")";
}
$ret_val[] = $sooner['date'];
$ret_val[] = $sooner['days_left'];
} else {
// Unknown
$ret_val[] = $strExpiration . ": " . $strNoExpiration;
$ret_val[] = '';
$ret_val[] = '';
}
return isset($ret_val) ? $ret_val : false;
}
$extra .= "<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-edit.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 campaignid,campaignname" . " FROM " . $phpAds_config['tbl_campaigns'] . "," . $phpAds_config['tbl_clients'] . " WHERE " . $phpAds_config['tbl_clients'] . ".clientid=" . $phpAds_config['tbl_campaigns'] . ".clientid" . " AND agencyid=" . phpAds_getUserID() . " AND campaignid !=" . $campaignid;
}
$res = phpAds_dbQuery($query) or phpAds_sqlDie();
while ($others = phpAds_dbFetchArray($res)) {
$extra .= "<option value='" . $others['campaignid'] . "'>" . phpAds_buildName($others['campaignid'], $others['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-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>";
phpAds_PageHeader("4.1.3.3.2", $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'> " . 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("4.1.3.3.2", "4.1.3.3.3", "4.1.3.3.6", "4.1.3.3.4"));
} else {
/* */
/* This program is free software. You can redistribute it and/or modify */
/* it under the terms of the GNU General Public License as published by */
/* the Free Software Foundation; either version 2 of the License. */
/************************************************************************/
// Include required files
require "config.php";
require "lib-statistics.inc.php";
// Initialize random generator
mt_srand((double) microtime() * 1000000);
/*********************************************************/
/* Main code */
/*********************************************************/
$res = phpAds_dbQuery("\n\tSELECT\n\t\t*\n\tFROM\n\t\t" . $phpAds_config['tbl_banners'] . "\n\tWHERE\n\t\tbannerid = '{$bannerid}'\n\t") or phpAds_sqlDie();
if ($res) {
$row = phpAds_dbFetchArray($res);
echo "<html><head><title>" . strip_tags(phpAds_buildBannerName($bannerid, $row['description'], $row['alt'])) . "</title>";
echo "<link rel='stylesheet' href='images/" . $phpAds_TextDirection . "/interface.css'></head>";
echo "<body marginheight='0' marginwidth='0' leftmargin='0' topmargin='0' bgcolor='#EFEFEF'>";
echo "<table cellpadding='0' cellspacing='0' border='0'>";
echo "<tr height='32'><td width='32'><img src='images/cropmark-tl.gif' width='32' height='32'></td>";
echo "<td background='images/ruler-top.gif'> </td><td width='32'><img src='images/cropmark-tr.gif' width='32' height='32'></td></tr>";
echo "<tr height='" . $row['height'] . "'><td width='32' background='images/ruler-left.gif'> </td><td bgcolor='#FFFFFF' width='" . $row['width'] . "'>";
if ($row['contenttype'] == 'html') {
$htmlcode = $row['htmlcache'];
// Basic modifications
$htmlcode = str_replace('{url_prefix}', $phpAds_config['url_prefix'], $htmlcode);
$htmlcode = str_replace('{bannerid}', $bannerid, $htmlcode);
$htmlcode = str_replace('{zoneid}', '', $htmlcode);
$htmlcode = str_replace('{source}', '', $htmlcode);
$htmlcode = str_replace('{target}', '_blank', $htmlcode);
// Register input variables
phpAds_registerGlobal('value');
// Security check
phpAds_checkAccess(phpAds_Admin + phpAds_Client);
/*********************************************************/
/* Main code */
/*********************************************************/
if ($value == "t") {
$value = "f";
} else {
$value = "t";
}
if (phpAds_isUser(phpAds_Client)) {
if ($value == 'f' && phpAds_isAllowed(phpAds_DisableBanner) || $value == 't' && phpAds_isAllowed(phpAds_ActivateBanner)) {
$result = phpAds_dbQuery("\n\t\t\tSELECT\n\t\t\t\tclientid\n\t\t\tFROM\n\t\t\t\t" . $phpAds_config['tbl_banners'] . "\n\t\t\tWHERE\n\t\t\t\tbannerid = '{$bannerid}'\n\t\t\t") or phpAds_sqlDie();
$row = phpAds_dbFetchArray($result);
if ($row["clientid"] == '' || phpAds_getUserID() != phpAds_getParentID($row["clientid"])) {
phpAds_PageHeader("1");
phpAds_Die($strAccessDenied, $strNotAdmin);
} else {
$campaignid = $row["clientid"];
$res = phpAds_dbQuery("\n\t\t\t\tUPDATE\n\t\t\t\t\t" . $phpAds_config['tbl_banners'] . "\n\t\t\t\tSET\n\t\t\t\t\tactive = '{$value}'\n\t\t\t\tWHERE\n\t\t\t\t\tbannerid = '{$bannerid}'\n\t\t\t\t") or phpAds_sqlDie();
// Rebuild priorities
phpAds_PriorityCalculate();
// Rebuild cache
if (!defined('LIBVIEWCACHE_INCLUDED')) {
include phpAds_path . '/libraries/deliverycache/cache-' . $phpAds_config['delivery_caching'] . '.inc.php';
}
phpAds_cacheDelete();
Header("Location: stats-campaign-banners.php?clientid=" . $clientid . "&campaignid=" . $campaignid);
}
echo '<img src="images/caret-u.gif" border="0" alt="" title="">';
}
echo '</a>';
}
echo "</b> </td>";
echo "<td height='25'> </td>";
echo "</tr>";
echo "<tr height='1'><td colspan='4' bgcolor='#888888'><img src='images/break.gif' height='1' width='100%'></td></tr>";
if (phpAds_dbNumRows($res_zones) == 0) {
echo "<tr height='25' bgcolor='#F6F6F6'><td height='25' colspan='4'>";
echo " " . $strNoZones;
echo "</td></tr>";
echo "<td colspan='4' bgcolor='#888888'><img src='images/break.gif' height='1' width='100%'></td>";
}
$i = 0;
while ($row_zones = phpAds_dbFetchArray($res_zones)) {
if ($i > 0) {
echo "<td colspan='4' bgcolor='#888888'><img src='images/break.gif' height='1' width='100%'></td>";
}
echo "<tr height='25' " . ($i % 2 == 0 ? "bgcolor='#F6F6F6'" : "") . ">";
echo "<td height='25'> ";
if ($row_zones['what'] != '') {
if ($row_zones['delivery'] == phpAds_ZoneBanner) {
echo "<img src='images/icon-zone.gif' align='absmiddle'> ";
} elseif ($row_zones['delivery'] == phpAds_ZoneInterstitial) {
echo "<img src='images/icon-interstitial.gif' align='absmiddle'> ";
} elseif ($row_zones['delivery'] == phpAds_ZonePopup) {
echo "<img src='images/icon-popup.gif' align='absmiddle'> ";
} elseif ($row_zones['delivery'] == phpAds_ZoneText) {
echo "<img src='images/icon-textzone.gif' align='absmiddle'> ";
}
function phpAds_compileLimitation($bannerid = '')
{
global $phpAds_config;
if ($bannerid == '') {
// Loop through all banners
$res = phpAds_dbQuery("\n\t\t\tSELECT\n\t\t\t\tbannerid\n\t\t\tFROM\n\t\t\t\t" . $phpAds_config['tbl_banners'] . "\n\t\t");
while ($current = phpAds_dbFetchArray($res)) {
phpAds_compileLimitation($current['bannerid']);
}
} else {
// Compile limitation
$res = phpAds_dbQuery("\n\t\t\tSELECT\n\t\t\t\t*\n\t\t\tFROM\n\t\t\t\t" . $phpAds_config['tbl_acls'] . "\n\t\t\tWHERE\n\t\t\t\tbannerid = '" . $bannerid . "'\n\t\t\tORDER BY\n\t\t\t\texecutionorder\n\t\t") or phpAds_sqlDie();
while ($row = phpAds_dbFetchArray($res)) {
$acl[$row['executionorder']]['logical'] = $row['logical'];
$acl[$row['executionorder']]['type'] = $row['type'];
$acl[$row['executionorder']]['comparison'] = $row['comparison'];
$acl[$row['executionorder']]['data'] = addslashes($row['data']);
}
$expression = '';
$i = 0;
if (isset($acl) && count($acl)) {
reset($acl);
while (list($key, ) = each($acl)) {
if ($i > 0) {
$expression .= ' ' . $acl[$key]['logical'] . ' ';
}
switch ($acl[$key]['type']) {
case 'clientip':
$expression .= "phpAds_aclCheckClientIP(\\'" . addslashes($acl[$key]['data']) . "\\', \\'" . $acl[$key]['comparison'] . "\\')";
break;
case 'browser':
$expression .= "phpAds_aclCheckUseragent(\\'" . addslashes($acl[$key]['data']) . "\\', \\'" . $acl[$key]['comparison'] . "\\')";
break;
case 'os':
$expression .= "phpAds_aclCheckUseragent(\\'" . addslashes($acl[$key]['data']) . "\\', \\'" . $acl[$key]['comparison'] . "\\')";
break;
case 'useragent':
$expression .= "phpAds_aclCheckUseragent(\\'" . addslashes($acl[$key]['data']) . "\\', \\'" . $acl[$key]['comparison'] . "\\')";
break;
case 'language':
$expression .= "phpAds_aclCheckLanguage(\\'" . addslashes($acl[$key]['data']) . "\\', \\'" . $acl[$key]['comparison'] . "\\')";
break;
case 'country':
$expression .= "phpAds_aclCheckCountry(\\'" . addslashes($acl[$key]['data']) . "\\', \\'" . $acl[$key]['comparison'] . "\\')";
break;
case 'continent':
$expression .= "phpAds_aclCheckContinent(\\'" . addslashes($acl[$key]['data']) . "\\', \\'" . $acl[$key]['comparison'] . "\\')";
break;
case 'region':
$expression .= "phpAds_aclCheckRegion(\\'" . addslashes($acl[$key]['data']) . "\\', \\'" . $acl[$key]['comparison'] . "\\')";
break;
case 'weekday':
$expression .= "phpAds_aclCheckWeekday(\\'" . addslashes($acl[$key]['data']) . "\\', \\'" . $acl[$key]['comparison'] . "\\')";
break;
case 'domain':
$expression .= "phpAds_aclCheckDomain(\\'" . addslashes($acl[$key]['data']) . "\\', \\'" . $acl[$key]['comparison'] . "\\')";
break;
case 'source':
$expression .= "phpAds_aclCheckSource(\\'" . addslashes($acl[$key]['data']) . "\\', \\'" . $acl[$key]['comparison'] . "\\', \$" . "source)";
break;
case 'time':
$expression .= "phpAds_aclCheckTime(\\'" . addslashes($acl[$key]['data']) . "\\', \\'" . $acl[$key]['comparison'] . "\\')";
break;
case 'date':
$expression .= "phpAds_aclCheckDate(\\'" . addslashes($acl[$key]['data']) . "\\', \\'" . $acl[$key]['comparison'] . "\\')";
break;
case 'referer':
$expression .= "phpAds_aclCheckReferer(\\'" . addslashes($acl[$key]['data']) . "\\', \\'" . $acl[$key]['comparison'] . "\\')";
break;
default:
return 0;
}
$i++;
}
}
if ($expression == '') {
$expression = 'true';
}
$res = phpAds_dbQuery("\n\t\t\tUPDATE\n\t\t\t\t" . $phpAds_config['tbl_banners'] . "\n\t\t\tSET\n\t\t\t\tcompiledlimitation='" . $expression . "'\n\t\t\tWHERE\n\t\t\t\tbannerid='" . $bannerid . "'\n\t\t") or phpAds_sqlDie();
}
}
