function Plugin_ZonehistoryExecute($zoneid, $delimiter = ",")
{
global $phpAds_config, $date_format;
global $strZone, $strTotal, $strDay, $strViews, $strClicks, $strCTRShort;
header("Content-type: application/csv\nContent-Disposition: \"inline; filename=zonehistory.csv\"");
$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\tzoneid = '" . $zoneid . "'\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 $strZone . ": " . strip_tags(phpAds_getZoneName($zoneid)) . "\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_ZonehistoryExecute($zoneid, $delimiter = ",", $quotes = "")
{
global $phpAds_config, $date_format;
global $strZone, $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\tWHERE\n\t\t\t\tzoneid = '" . $zoneid . "'\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\tWHERE\n\t\t\t\tzoneid = '" . $zoneid . "'\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\tWHERE\n\t\t\t\tzoneid = '" . $zoneid . "'\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 . $strZone . ": " . strip_tags(phpAds_getZoneName($zoneid, false)) . $quotes . "\n\n";
echo $quotes . $strDay . $quotes . $delimiter . $quotes . $strViews . $quotes;
echo $delimiter . $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";
}
}
while ($row = phpAds_dbFetchArray($res)) {
phpAds_PageContext(phpAds_getBannerName($row['bannerid']), "stats-linkedbanner-history.php?affiliateid=" . $affiliateid . "&zoneid=" . $zoneid . "&bannerid=" . $row['bannerid'], $bannerid == $row['bannerid']);
}
phpAds_PageShortcut($strAffiliateProperties, 'affiliate-edit.php?affiliateid=' . $affiliateid, 'images/icon-affiliate.gif');
phpAds_PageShortcut($strZoneProperties, 'zone-edit.php?affiliateid=' . $affiliateid . '&zoneid=' . $zoneid, 'images/icon-zone.gif');
phpAds_PageShortcut($strIncludedBanners, 'zone-include.php?affiliateid=' . $affiliateid . '&zoneid=' . $zoneid, 'images/icon-zone-linked.gif');
phpAds_PageHeader("2.4.2.2.1");
echo "<img src='images/icon-affiliate.gif' align='absmiddle'> " . phpAds_getAffiliateName($affiliateid);
echo " <img src='images/" . $phpAds_TextDirection . "/caret-rs.gif'> ";
echo "<img src='images/icon-zone.gif' align='absmiddle'> " . phpAds_getZoneName($zoneid);
echo " <img src='images/" . $phpAds_TextDirection . "/caret-rs.gif'> ";
echo "<img src='images/icon-zone-linked.gif' align='absmiddle'> <b>" . phpAds_getBannerName($bannerid) . "</b><br><br><br>";
phpAds_ShowSections(array("2.4.2.2.1"));
} else {
phpAds_PageHeader("1.1.2.1");
echo "<img src='images/icon-zone.gif' align='absmiddle'> " . phpAds_getZoneName($zoneid);
echo " <img src='images/" . $phpAds_TextDirection . "/caret-rs.gif'> ";
echo "<img src='images/icon-zone-linked.gif' align='absmiddle'> <b>" . phpAds_getBannerName($bannerid) . "</b><br><br><br>";
phpAds_ShowSections(array("1.1.2.1"));
}
/*********************************************************/
/* Main code */
/*********************************************************/
$lib_history_where = "zoneid = " . $zoneid . " AND bannerid = " . $bannerid;
$lib_history_params = array('affiliateid' => $affiliateid, 'zoneid' => $zoneid, 'bannerid' => $bannerid);
include "lib-history.inc.php";
/*********************************************************/
/* HTML framework */
/*********************************************************/
phpAds_PageFooter();
if (phpAds_isUser(phpAds_Admin)) {
$res = phpAds_dbQuery("\n\t\tSELECT\n\t\t\t*\n\t\tFROM\n\t\t\t" . $phpAds_config['tbl_zones'] . "\n\t\tWHERE\n\t\t\taffiliateid = '" . $affiliateid . "'\n\t") or phpAds_sqlDie();
while ($row = phpAds_dbFetchArray($res)) {
phpAds_PageContext(phpAds_buildZoneName($row['zoneid'], $row['zonename']), "stats-zone-linkedbanners.php?affiliateid=" . $affiliateid . "&zoneid=" . $row['zoneid'], $zoneid == $row['zoneid']);
}
phpAds_PageShortcut($strAffiliateProperties, 'affiliate-edit.php?affiliateid=' . $affiliateid, 'images/icon-affiliate.gif');
phpAds_PageShortcut($strZoneProperties, 'zone-edit.php?affiliateid=' . $affiliateid . '&zoneid=' . $zoneid, 'images/icon-zone.gif');
phpAds_PageShortcut($strIncludedBanners, 'zone-include.php?affiliateid=' . $affiliateid . '&zoneid=' . $zoneid, 'images/icon-zone-linked.gif');
phpAds_PageHeader("2.4.2.2");
echo "<img src='images/icon-affiliate.gif' align='absmiddle'> " . phpAds_getAffiliateName($affiliateid);
echo " <img src='images/" . $phpAds_TextDirection . "/caret-rs.gif'> ";
echo "<img src='images/icon-zone.gif' align='absmiddle'> <b>" . phpAds_getZoneName($zoneid) . "</b><br><br><br>";
phpAds_ShowSections(array("2.4.2.1", "2.4.2.2"));
} else {
phpAds_PageHeader("1.1.2");
echo "<img src='images/icon-zone.gif' align='absmiddle'> <b>" . phpAds_getZoneName($zoneid) . "</b><br><br><br>";
phpAds_ShowSections(array("1.1.1", "1.1.2"));
}
/*********************************************************/
/* Main code */
/*********************************************************/
$totalviews = 0;
$totalclicks = 0;
// Get the zone information
$res_stats = phpAds_dbQuery("\n\tSELECT\n\t\twhat\n\tFROM \n\t\t" . $phpAds_config['tbl_zones'] . "\n\tWHERE\n\t\tzoneid = '" . $zoneid . "'\n");
if ($row_zone = phpAds_dbFetchArray($res_stats)) {
$zone = $row_zone;
// Check period range
if ($period_range['start_month'] == 0 || $period_range['start_day'] == 0 || $period_range['start_year'] == 0) {
$period_begin = 0;
$period_range['start_day'] = $period_range['start_month'] = $period_range['start_year'] = 0;
