$node_array = array();
}
/*********************************************************/
/* HTML framework */
/*********************************************************/
if (isset($Session['prefs']['stats-campaign-banners.php']['listorder'])) {
$navorder = $Session['prefs']['stats-campaign-banners.php']['listorder'];
} else {
$navorder = '';
}
if (isset($Session['prefs']['stats-campaign-banners.php']['orderdirection'])) {
$navdirection = $Session['prefs']['stats-campaign-banners.php']['orderdirection'];
} else {
$navdirection = '';
}
$res = phpAds_dbQuery("\n\tSELECT\n\t\t*\n\tFROM\n\t\t" . $phpAds_config['tbl_banners'] . "\n\tWHERE\n\t\tclientid = '{$campaignid}'\n\t" . phpAds_getBannerListOrder($navorder, $navdirection) . "\n") or phpAds_sqlDie();
while ($row = phpAds_dbFetchArray($res)) {
phpAds_PageContext(phpAds_buildBannerName($row['bannerid'], $row['description'], $row['alt']), "stats-banner-affiliates.php?clientid=" . $clientid . "&campaignid=" . $campaignid . "&bannerid=" . $row['bannerid'], $bannerid == $row['bannerid']);
}
phpAds_PageShortcut($strClientProperties, 'client-edit.php?clientid=' . $clientid, 'images/icon-client.gif');
phpAds_PageShortcut($strCampaignProperties, 'campaign-edit.php?clientid=' . $clientid . '&campaignid=' . $campaignid, 'images/icon-campaign.gif');
phpAds_PageShortcut($strBannerProperties, 'banner-edit.php?clientid=' . $clientid . '&campaignid=' . $campaignid . '&bannerid=' . $bannerid, 'images/icon-banner-stored.gif');
phpAds_PageShortcut($strModifyBannerAcl, 'banner-acl.php?clientid=' . $clientid . '&campaignid=' . $campaignid . '&bannerid=' . $bannerid, 'images/icon-acl.gif');
phpAds_PageHeader("2.1.2.2.2");
echo "<img src='images/icon-client.gif' align='absmiddle'> " . phpAds_getParentName($campaignid);
echo " <img src='images/" . $phpAds_TextDirection . "/caret-rs.gif'> ";
echo "<img src='images/icon-campaign.gif' align='absmiddle'> " . phpAds_getClientName($campaignid);
echo " <img src='images/" . $phpAds_TextDirection . "/caret-rs.gif'> ";
echo "<img src='images/icon-banner-stored.gif' align='absmiddle'> <b>" . phpAds_getBannerName($bannerid) . "</b><br><br>";
echo phpAds_buildBannerCode($bannerid) . "<br><br><br><br>";
phpAds_ShowSections(array("2.1.2.2.1", "2.1.2.2.2"));
$limit = " AND day >= " . date('Ymd', $timestamp);
break;
case 'm':
$timestamp = mktime(0, 0, 0, date('m'), 1, date('Y'));
$limit = " AND day >= " . date('Ymd', $timestamp);
break;
default:
$limit = '';
$period = '';
break;
}
// Get the banners for each campaign
if (phpAds_isUser(phpAds_Admin)) {
$query = "SELECT bannerid" . ",campaignid" . ",alt" . ",description" . ",active" . ",storagetype" . " FROM " . $phpAds_config['tbl_banners'] . phpAds_getBannerListOrder($listorder, $orderdirection);
} elseif (phpAds_isUser(phpAds_Agency)) {
$query = "SELECT b.bannerid AS bannerid" . ",b.campaignid AS campaignid" . ",b.alt AS alt" . ",b.description AS description" . ",b.active AS active" . ",b.storagetype AS storagetype" . " FROM " . $phpAds_config['tbl_banners'] . " AS b" . "," . $phpAds_config['tbl_campaigns'] . " AS m" . "," . $phpAds_config['tbl_clients'] . " AS c" . " WHERE b.campaignid=m.campaignid" . " AND m.clientid=c.clientid" . " AND c.agencyid=" . phpAds_getUserID() . phpAds_getBannerListOrder($listorder, $orderdirection);
}
$res_banners = phpAds_dbQuery($query) or phpAds_sqlDie();
while ($row_banners = phpAds_dbFetchArray($res_banners)) {
if (isset($clients[$row_banners['campaignid']])) {
$clients[$row_banners['campaignid']]['count']++;
}
if (isset($campaigns[$row_banners['campaignid']])) {
$banners[$row_banners['bannerid']] = $row_banners;
$banners[$row_banners['bannerid']]['clicks'] = 0;
$banners[$row_banners['bannerid']]['views'] = 0;
$campaigns[$row_banners['campaignid']]['count']++;
}
$res_stats = phpAds_dbQuery("SELECT" . " sum(views) as views" . ",sum(clicks) as clicks" . ",sum(conversions) as conversions" . " FROM " . $phpAds_config['tbl_adstats'] . " WHERE bannerid=" . $row_banners['bannerid'] . $limit) or phpAds_sqlDie();
if ($row_stats = phpAds_dbFetchArray($res_stats)) {
$banners[$row_banners['bannerid']]['clicks'] = $row_stats['clicks'];
function phpAds_getBannerStatsByCampaignID($campaignid, $name = '', $listorder = 'name', $orderdirection = 'up', $omit_arr = null, $path = '')
{
global $phpAds_config;
$query = "SELECT" . " b.bannerid AS bannerid" . ",b.description AS description" . ",b.alt AS alt" . ",SUM(views) AS views" . ",SUM(clicks) AS clicks" . ",SUM(conversions) AS conversions" . ",FORMAT(SUM(clicks)/SUM(views),6) AS ctr" . ",FORMAT(SUM(conversions)/SUM(clicks),6) AS cnvr" . " FROM " . $phpAds_config['tbl_adstats'] . " AS s" . "," . $phpAds_config['tbl_banners'] . " AS b" . " WHERE b.bannerid=s.bannerid" . " AND b.campaignid=" . $campaignid . " GROUP BY bannerid" . phpAds_getBannerListOrder($listorder, $orderdirection);
return phpAds_getBannerStats($query, $name, $omit_arr);
}
$timestamp_begin = mktime(0, 0, 0, 1, 1, date('Y'));
$limit = "day >= " . date('Ymd', $timestamp_begin);
break;
case 'x':
$timestamp_begin = mktime(0, 0, 0, 1, 1, date('Y') - 1);
$timestamp_end = mktime(0, 0, 0, 1, 1, date('Y'));
$limit = "day >= " . date('Ymd', $timestamp_begin) . " AND day < " . date('Ymd', $timestamp_end);
break;
default:
$limit = '';
$period = '';
break;
}
}
// Get the banners for each campaign
$res_banners = phpAds_dbQuery("\n\tSELECT \n\t\tbannerid,\n\t\tclientid,\n\t\talt,\n\t\tdescription,\n\t\tactive,\n\t\tstoragetype\n\tFROM \n\t\t" . $phpAds_config['tbl_banners'] . "\n\t\t" . phpAds_getBannerListOrder($listorder, $orderdirection) . "\n\t") or phpAds_sqlDie();
while ($row_banners = phpAds_dbFetchArray($res_banners)) {
if (isset($clients[$row_banners['clientid']])) {
$clients[$row_banners['clientid']]['count']++;
}
if (isset($campaigns[$row_banners['clientid']])) {
$banners[$row_banners['bannerid']] = $row_banners;
$banners[$row_banners['bannerid']]['clicks'] = 0;
$banners[$row_banners['bannerid']]['views'] = 0;
$campaigns[$row_banners['clientid']]['count']++;
$bannerids[] = $row_banners['bannerid'];
}
}
if (count($bannerids)) {
// Create WHERE clause
$where = $limit ? "WHERE " . $limit : '';
/*********************************************************/
/* HTML framework */
/*********************************************************/
if (isset($Session['prefs']['stats-campaign-banners.php']['listorder'])) {
$navorder = $Session['prefs']['stats-campaign-banners.php']['listorder'];
} else {
$navorder = '';
}
if (isset($Session['prefs']['stats-campaign-banners.php']['orderdirection'])) {
$navdirection = $Session['prefs']['stats-campaign-banners.php']['orderdirection'];
} else {
$navdirection = '';
}
if (phpAds_isUser(phpAds_Client)) {
if (phpAds_getUserID() == phpAds_getCampaignParentClientID($campaignid)) {
$res = phpAds_dbQuery("SELECT *" . " FROM " . $phpAds_config['tbl_banners'] . " WHERE campaignid=" . $campaignid . phpAds_getBannerListOrder($navorder, $navdirection)) or phpAds_sqlDie();
while ($row = phpAds_dbFetchArray($res)) {
phpAds_PageContext(phpAds_buildBannerName($row['bannerid'], $row['description'], $row['alt']), "stats-banner-affiliates.php?clientid=" . $clientid . "&campaignid=" . $campaignid . "&bannerid=" . $row['bannerid'], $bannerid == $row['bannerid']);
}
$sections[] = "1.2.2.1";
if (phpAds_isAllowed(phpAds_ModifyBanner)) {
$sections[] = "1.2.2.2";
}
$sections[] = "1.2.2.4";
phpAds_PageHeader("1.2.2.4");
echo "<img src='images/icon-campaign.gif' align='absmiddle'> " . phpAds_getCampaignName($campaignid);
echo " <img src='images/" . $phpAds_TextDirection . "/caret-rs.gif'> ";
echo "<img src='images/icon-banner-stored.gif' align='absmiddle'> <b>" . phpAds_getBannerName($bannerid) . "</b><br><br>";
echo phpAds_buildBannerCode($bannerid) . "<br><br><br><br>";
phpAds_ShowSections($sections);
} else {
