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 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_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";
}
if ($manual['views'] || $manual['clicks']) {
echo "<tr height='25' " . ($i % 2 == 0 ? "bgcolor='#F6F6F6'" : "") . ">";
echo "<td height='25'> " . $strUnknown . "</td>";
echo "<td height='25'>-</td>";
echo "<td height='25' align='" . $phpAds_TextAlignRight . "'>" . phpAds_formatNumber($manual['views']) . "</td>";
echo "<td height='25' align='" . $phpAds_TextAlignRight . "'>" . phpAds_formatNumber($manual['clicks']) . "</td>";
echo "<td height='25' align='" . $phpAds_TextAlignRight . "'>" . phpAds_buildCTR($manual['views'], $manual['clicks']) . " </td>";
echo "</tr>";
echo "<tr height='1'><td colspan='5' bgcolor='#888888'><img src='images/break.gif' height='1' width='100%'></td></tr>";
}
// Total
echo "<tr height='25'><td height='25'> <b>" . $strTotal . "</b></td>";
echo "<td height='25'> </td>";
echo "<td height='25' align='" . $phpAds_TextAlignRight . "'>" . phpAds_formatNumber($totalviews) . "</td>";
echo "<td height='25' align='" . $phpAds_TextAlignRight . "'>" . phpAds_formatNumber($totalclicks) . "</td>";
echo "<td height='25' align='" . $phpAds_TextAlignRight . "'>" . phpAds_buildCTR($totalviews, $totalclicks) . " </td>";
echo "</tr>";
echo "</table>";
echo "<br><br>";
} else {
echo "<br><div class='errormessage'><img class='errormessage' src='images/info.gif' width='16' height='16' border='0' align='absmiddle'>";
echo $strNoStats . '</div>';
}
/*********************************************************/
/* Store preferences */
/*********************************************************/
$Session['prefs']['stats-banner-affiliates.php']['listorder'] = $listorder;
$Session['prefs']['stats-banner-affiliates.php']['orderdirection'] = $orderdirection;
$Session['prefs']['stats-banner-affiliates.php']['nodes'] = implode(",", $node_array);
phpAds_SessionDataStore();
/*********************************************************/
echo "<td height='25' align='" . $phpAds_TextAlignRight . "'>" . phpAds_buildCTR($banners[$bkey]['clicks'], $banners[$bkey]['conversions']) . "</td>";
}
}
}
}
echo "<tr height='1'><td colspan='7' bgcolor='#888888'><img src='images/break.gif' height='1' width='100%'></td></tr>";
$i++;
}
// Total
echo "<tr height='25' " . ($i % 2 == 0 ? "bgcolor='#F6F6F6'" : "") . "><td height='25'> <b>" . $strTotal . "</b></td>";
echo "<td height='25'> </td>";
echo "<td height='25' align='" . $phpAds_TextAlignRight . "'>" . phpAds_formatNumber($totalviews) . "</td>";
echo "<td height='25' align='" . $phpAds_TextAlignRight . "'>" . phpAds_formatNumber($totalclicks) . "</td>";
echo "<td height='25' align='" . $phpAds_TextAlignRight . "'>" . phpAds_buildCTR($totalviews, $totalclicks) . "</td>";
echo "<td height='25' align='" . $phpAds_TextAlignRight . "'>" . phpAds_formatNumber($totalconversions) . "</td>";
echo "<td height='25' align='" . $phpAds_TextAlignRight . "'>" . phpAds_buildCTR($totalclicks, $totalconversions) . "</td>";
echo "</tr>";
echo "<tr height='1'><td colspan='7' bgcolor='#888888'><img src='images/break.gif' height='1' width='100%'></td></tr>";
echo "<tr><td height='25' colspan='4' align='" . $phpAds_TextAlignLeft . "' nowrap>";
if ($hideinactive == true) {
echo " <img src='images/icon-activate.gif' align='absmiddle' border='0'>";
echo " <a href='stats-global-advertiser.php?period=" . $period . "&hideinactive=0'>" . $strShowAll . "</a>";
echo " | " . $clientshidden . " " . $strInactiveAdvertisersHidden;
} else {
echo " <img src='images/icon-hideinactivate.gif' align='absmiddle' border='0'>";
echo " <a href='stats-global-advertiser.php?period=" . $period . "&hideinactive=1'>" . $strHideInactiveAdvertisers . "</a>";
}
echo "</td><td height='25' colspan='3' align='" . $phpAds_TextAlignRight . "' nowrap>";
echo "<img src='images/triangle-d.gif' align='absmiddle' border='0'>";
echo " <a href='stats-global-advertiser.php?period=" . $period . "&expand=all' accesskey='" . $keyExpandAll . "'>" . $strExpandAll . "</a>";
echo " | ";
function MAX_displayZoneStats($aParams, $pageName, $anonymous, $aNodes, $expand, $listorder, $orderdirection, $hideinactive, $showPublisher, $entityIds)
{
global $phpAds_TextAlignLeft, $phpAds_TextAlignRight, $phpAds_TextDirection;
// Get the icons for all levels (publisher/zone)
$entity = _getEntityString($entityIds);
$publishersHidden = 0;
$aZones = Admin_DA::fromCache('getZonesStats', $aParams);
if (!empty($aZones)) {
echo "\n <br /><br />\n <table border='0' width='100%' cellpadding='0' cellspacing='0'>";
MAX_displayStatsHeader($pageName, $listorder, $orderdirection, $entityIds, $anonymous);
// Variable to determine if the row should be grey or white...
$i = 0;
$totalRequests = 0;
$totalViews = 0;
$totalClicks = 0;
$totalConversions = 0;
// Loop through publishers
MAX_sortArray($aZones, $listorder == 'id' ? 'zone_id' : $listorder, $orderdirection == 'up');
foreach ($aZones as $zoneId => $zone) {
$zoneRequests = phpAds_formatNumber($zone['sum_requests']);
$zoneViews = phpAds_formatNumber($zone['sum_views']);
$zoneClicks = phpAds_formatNumber($zone['sum_clicks']);
$zoneConversions = phpAds_formatNumber($zone['sum_conversions']);
$zoneCtr = phpAds_buildRatioPercentage($zone['sum_clicks'], $zone['sum_views']);
$zoneSr = phpAds_buildRatioPercentage($zone['sum_conversions'], $zone['sum_clicks']);
$zoneActive = true;
$zoneIcon = MAX_getEntityIcon('zone', $zoneActive, $zone['type']);
if (!$hideinactive || $zoneActive) {
$bgcolor = $i++ % 2 == 0 ? " bgcolor='#F6F6F6'" : '';
echo "\n <tr height='25'{$bgcolor}>\n <td> <img src='" . OX::assetPath() . "/images/spacer.gif' height='16' width='16'> \n <img src='{$zoneIcon}' align='absmiddle'> ";
if ($anonymous) {
echo "\n Hidden zone {$zone['id']}";
} else {
echo "\n <a href='stats.php?entity=zone&breakdown=history&affiliateid={$zone['publisher_id']}'>{$zone['name']}</a>";
}
echo "\n </td>";
if ($anonymous) {
echo "\n <td align='{$phpAds_TextAlignRight}'> </td>";
} else {
echo "\n <td align='{$phpAds_TextAlignRight}'>{$zoneId}</td>";
}
echo "\n <td align='{$phpAds_TextAlignRight}'>{$zoneRequests}</td>\n <td align='{$phpAds_TextAlignRight}'>{$zoneViews}</td>\n <td align='{$phpAds_TextAlignRight}'>{$zoneClicks}</td>\n <td align='{$phpAds_TextAlignRight}'>{$zoneCtr}</td>\n <td align='{$phpAds_TextAlignRight}'>{$zoneConversions}</td>\n <td align='{$phpAds_TextAlignRight}'>{$zoneSr}</td>\n </tr>\n <tr height='1'><td colspan='8' bgcolor='#888888'><img src='" . OX::assetPath() . "/images/break.gif' height='1' width='100%'></td></tr>";
} else {
$publishersHidden++;
}
$totalRequests += $zone['sum_requests'];
$totalViews += $zone['sum_views'];
$totalClicks += $zone['sum_clicks'];
$totalConversions += $zone['sum_conversions'];
}
// Total
echo "\n <tr height='25'{$bgcolor}>\n <td> <b>{$GLOBALS['strTotal']}</b></td>\n <td> </td>\n <td align='{$phpAds_TextAlignRight}'>" . phpAds_formatNumber($totalRequests) . "</td>\n <td align='{$phpAds_TextAlignRight}'>" . phpAds_formatNumber($totalViews) . "</td>\n <td align='{$phpAds_TextAlignRight}'>" . phpAds_formatNumber($totalClicks) . "</td>\n <td align='{$phpAds_TextAlignRight}'>" . phpAds_buildCTR($totalViews, $totalClicks) . "</td>\n <td align='{$phpAds_TextAlignRight}'>" . phpAds_formatNumber($totalConversions) . "</td>\n <td align='{$phpAds_TextAlignRight}'>" . phpAds_buildCTR($totalClicks, $totalConversions) . "</td>\n </tr>\n <tr height='1'>\n <td colspan='8' bgcolor='#888888'><img src='" . OX::assetPath() . "/images/break.gif' height='1' width='100%'></td>\n </tr>";
if (!$anonymous) {
echo "\n <tr>\n <td colspan='4' align='{$phpAds_TextAlignLeft}' nowrap>";
if ($hideinactive == true) {
echo " <img src='" . OX::assetPath() . "/images/icon-activate.gif' align='absmiddle' border='0'> <a href='{$pageName}?{$entity}hideinactive=0'>{$GLOBALS['strShowAll']}</a> | {$publishersHidden} {$GLOBALS['strInactivePublishersHidden']}";
} else {
echo " <img src='" . OX::assetPath() . "/images/icon-hideinactivate.gif' align='absmiddle' border='0'> <a href='{$pageName}?{$entity}hideinactive=1'>{$GLOBALS['strHideInactivePublishers']}</a>";
}
echo "\n </td>\n <td colspan='4' align='{$phpAds_TextAlignRight}' nowrap><img src='" . OX::assetPath() . "/images/triangle-d.gif' align='absmiddle' border='0'> <a href='{$pageName}?{$entity}expand=all'>{$GLOBALS['strExpandAll']}</a> | <img src='" . OX::assetPath() . "/images/{$phpAds_TextDirection}/triangle-l.gif' align='absmiddle' border='0'> <a href='{$pageName}?{$entity}expand=none'>{$GLOBALS['strCollapseAll']}</a> </td>\n </tr>\n <tr height='25'>";
if ($showPublisher == 't') {
echo "\n <td colspan='7' align='{$phpAds_TextAlignLeft}' nowrap> <img src='" . OX::assetPath() . "/images/icon-affiliate.gif' align='absmiddle'><a href='{$pageName}?{$entity}showpublisher=f'> Hide parent publisher</a></td>";
} else {
echo "\n <td colspan='7' align='{$phpAds_TextAlignLeft}' nowrap> <img src='" . OX::assetPath() . "/images/icon-affiliate.gif' align='absmiddle'><a href='{$pageName}?{$entity}showpublisher=t'> Show parent publisher</a></td>";
}
echo "\n </tr>";
}
echo "\n </table>\n <br /><br />";
} else {
MAX_displayNoStatsMessage();
}
}
function phpAds_printSourceRow($source_row, $expand_arr, $begin_str)
{
global $anonymous, $campaignid, $clientid, $cnt, $phpAds_TextDirection, $phpAds_TextAlignRight;
$expand = $expand_arr == 'all' || isset($expand_arr[$source_row['path']]) && $expand_arr[$source_row['path']] == 1;
$children_present = isset($source_row['children']) && is_array($source_row['children']) & sizeof($source_row['children']) > 0;
echo "\t\t\t\t<tr height='25' " . ($cnt % 2 == 0 ? "bgcolor='#F6F6F6'" : "") . ">\n";
echo "\t\t\t\t\t<td>";
echo $begin_str;
if ($children_present && !$anonymous) {
if ($expand) {
echo "<a href='stats-banner-sources.php?clientid=" . $clientid . "&campaignid=" . $campaignid . "&collapse=" . $source_row['path'] . "'><img src='images/triangle-d.gif' align='absmiddle' border='0'></a> ";
} else {
echo "<a href='stats-banner-sources.php?clientid=" . $clientid . "&campaignid=" . $campaignid . "&expand=" . $source_row['path'] . "'><img src='images/" . $phpAds_TextDirection . "/triangle-l.gif' align='absmiddle' border='0'></a> ";
}
} else {
echo "<img src='images/spacer.gif' align='absmiddle' width='16' height='16' border='0'>";
}
if ($anonymous) {
echo "(hidden source #" . ($cnt + 1) . ")";
} else {
echo $source_row['name'];
}
echo "</td>\n";
echo "\t\t\t\t\t<td align='" . $phpAds_TextAlignRight . "'>" . phpAds_formatNumber($source_row['views']) . "</td>\n";
echo "\t\t\t\t\t<td align='" . $phpAds_TextAlignRight . "'>" . phpAds_formatNumber($source_row['clicks']) . "</td>\n";
echo "\t\t\t\t\t<td align='" . $phpAds_TextAlignRight . "'>" . phpAds_buildCTR($source_row['views'], $source_row['clicks']) . "</td>";
echo "\t\t\t\t\t<td align='" . $phpAds_TextAlignRight . "'>" . phpAds_formatNumber($source_row['conversions']) . "</td>\n";
echo "\t\t\t\t\t<td align='" . $phpAds_TextAlignRight . "'>" . phpAds_buildCTR($source_row['clicks'], $source_row['conversions']) . " </td>";
echo "\t\t\t\t</tr>\n";
if ($expand && $children_present && !$anonymous) {
$child_source_row = $source_row['children'];
for ($i = 0; $i < sizeof($child_source_row); $i++) {
echo "\t\t\t\t<tr height='1'" . ($cnt % 2 == 0 ? " bgcolor='#F6F6F6'" : "") . "><td><img src='images/spacer.gif' width='100%' height='1' border='0'></td><td colspan='5' bgcolor='#888888'><img src='images/break.gif' height='1' width='100%'></td></tr>\n";
phpAds_printSourceRow($child_source_row[$i], $expand_arr, $begin_str . " ");
}
}
}
echo "<tr><td height='25' bgcolor='{$bgcolor}'> ";
echo $key != '' ? "<img src='images/flags/" . strtolower($key) . ".gif' width='19' height'11'> " . $phpAds_ISO3166[$key] : $strUnknown;
echo "</td>";
echo "<td align='" . $phpAds_TextAlignRight . "' height='25' bgcolor='{$bgcolor}'>" . phpAds_formatNumber($value['views']) . "</td>";
echo "<td align='" . $phpAds_TextAlignRight . "' height='25' bgcolor='{$bgcolor}'>" . phpAds_formatNumber($value['clicks']) . "</td>";
echo "<td align='" . $phpAds_TextAlignRight . "' height='25' bgcolor='{$bgcolor}'>" . phpAds_buildCTR($value['views'], $value['clicks']) . " </td>";
echo "</tr>";
echo "<tr><td height='1' colspan='4' bgcolor='#888888'><img src='images/break.gif' height='1' width='100%'></td></tr>";
$totals['clicks'] += $value['clicks'];
$totals['views'] += $value['views'];
$i++;
}
$bgcolor = "#FFFFFF";
$i % 2 ? 0 : ($bgcolor = "#F6F6F6");
echo "<tr><td height='25' bgcolor='{$bgcolor}'> ";
echo "<b>" . $strTotal . "</b></td>";
echo "<td align='" . $phpAds_TextAlignRight . "' height='25' bgcolor='{$bgcolor}'>" . phpAds_formatNumber($totals['views']) . "</td>";
echo "<td align='" . $phpAds_TextAlignRight . "' height='25' bgcolor='{$bgcolor}'>" . phpAds_formatNumber($totals['clicks']) . "</td>";
echo "<td align='" . $phpAds_TextAlignRight . "' height='25' bgcolor='{$bgcolor}'>" . phpAds_buildCTR($totals['views'], $totals['clicks']) . " </td>";
echo "</tr>";
echo "<tr><td height='1' colspan='4' bgcolor='#888888'><img src='images/break.gif' height='1' width='100%'></td></tr>";
echo "</table>";
}
if ($type == 't') {
$lib_targetstats_where = "clientid > 0";
unset($params);
$lib_targetstats_params['type'] = 't';
$lib_targetstats_misc_stats = true;
include "lib-targetstats.inc.php";
}
echo "<br><br>";
echo "<td height='25'> {$strAverageThisPeriod} (" . $span_this . " " . $title . ")</td>";
echo "<td align='" . $phpAds_TextAlignRight . "' height='25'>" . phpAds_formatNumber($totalviews / $span_this) . "</td>";
echo "<td align='" . $phpAds_TextAlignRight . "' height='25'>" . phpAds_formatNumber($totalclicks / $span_this) . "</td>";
echo "<td align='" . $phpAds_TextAlignRight . "' height='25'></td>";
echo "<td align='" . $phpAds_TextAlignRight . "' height='25'>" . phpAds_formatNumber($totalconversions / $span_this) . "</td>";
echo "<td align='" . $phpAds_TextAlignRight . "' height='25'> </td>";
echo "</tr>";
echo "<tr><td height='1' colspan='6' bgcolor='#888888'><img src='images/break.gif' height='1' width='100%'></td></tr>";
// Total
echo "<tr>";
echo "<td height='25'> <b>{$strTotal}</b></td>";
echo "<td align='" . $phpAds_TextAlignRight . "' height='25'>" . phpAds_formatNumber($totals['views']) . "</td>";
echo "<td align='" . $phpAds_TextAlignRight . "' height='25'>" . phpAds_formatNumber($totals['clicks']) . "</td>";
echo "<td align='" . $phpAds_TextAlignRight . "' height='25'>" . phpAds_buildCTR($totals['views'], $totals['clicks']) . "</td>";
echo "<td align='" . $phpAds_TextAlignRight . "' height='25'>" . phpAds_formatNumber($totals['conversions']) . "</td>";
echo "<td align='" . $phpAds_TextAlignRight . "' height='25'>" . phpAds_buildCTR($totals['clicks'], $totals['conversions']) . " </td>";
echo "</tr>";
echo "<tr><td height='1' colspan='6' bgcolor='#888888'><img src='images/break.gif' height='1' width='100%'></td></tr>";
// Average
echo "<tr>";
echo "<td height='25'> {$strAverage} (" . $span_period . " " . $title . ")</td>";
echo "<td align='" . $phpAds_TextAlignRight . "' height='25'>" . phpAds_formatNumber($span_period ? $totals['views'] / $span_period : 0) . "</td>";
echo "<td align='" . $phpAds_TextAlignRight . "' height='25'>" . phpAds_formatNumber($span_period ? $totals['clicks'] / $span_period : 0) . "</td>";
echo "<td align='" . $phpAds_TextAlignRight . "' height='25'></td>";
echo "<td align='" . $phpAds_TextAlignRight . "' height='25'>" . phpAds_formatNumber($span_period ? $totals['conversions'] / $span_period : 0) . "</td>";
echo "<td align='" . $phpAds_TextAlignRight . "' height='25'> </td>";
echo "</tr>";
echo "<tr><td height='1' colspan='6' bgcolor='#888888'><img src='images/break.gif' height='1' width='100%'></td></tr>";
echo "</table>";
}
if (phpAds_GDImageFormat() != "none") {
function phpAds_printSourceRow($source_row, $sources, $expand_arr, $listorder, $orderdirection, $begin_str)
{
global $anonymous, $campaignid, $clientid, $cnt, $phpAds_TextDirection, $phpAds_TextAlignRight;
$expand = $expand_arr == 'all' || isset($expand_arr['sources/' . $source_row['path']]) && $expand_arr['sources/' . $source_row['path']] == 1;
$children_present = isset($source_row['children']) && is_array($source_row['children']) & sizeof($source_row['children']) > 0;
$checked = '';
for ($i = 0; $i < sizeof($sources); $i++) {
if ($sources[$i] == $source_row['path']) {
$checked = ' checked';
break;
}
}
echo "\t\t\t\t<tr height='25' " . ($cnt % 2 == 0 ? "bgcolor='#F6F6F6'" : "") . ">\n";
echo "\t\t\t\t\t<td><input type='checkbox' name='sources[]' value='" . $source_row['path'] . "'" . $checked . "></td>\n";
echo "\t\t\t\t\t<td>";
echo $begin_str;
if ($children_present && !$anonymous) {
if ($expand) {
echo "<a href='stats-campaign-optimise.php?clientid=" . $clientid . "&campaignid=" . $campaignid . "&collapse=" . urlencode('sources/' . $source_row['path']) . "'><img src='images/triangle-d.gif' align='absmiddle' border='0'></a> ";
} else {
echo "<a href='stats-campaign-optimise.php?clientid=" . $clientid . "&campaignid=" . $campaignid . "&expand=" . urlencode('sources/' . $source_row['path']) . "'><img src='images/" . $phpAds_TextDirection . "/triangle-l.gif' align='absmiddle' border='0'></a> ";
}
} else {
echo "<img src='images/spacer.gif' align='absmiddle' width='16' height='16' border='0'>";
}
if ($anonymous) {
echo "(hidden source #" . ($cnt + 1) . ")";
} else {
echo $source_row['source'];
}
echo "</td>\n";
echo "\t\t\t\t\t<td align='" . $phpAds_TextAlignRight . "'>" . phpAds_formatNumber($source_row['views']) . "</td>\n";
echo "\t\t\t\t\t<td align='" . $phpAds_TextAlignRight . "'>" . phpAds_formatNumber($source_row['clicks']) . "</td>\n";
echo "\t\t\t\t\t<td align='" . $phpAds_TextAlignRight . "'>" . phpAds_buildCTR($source_row['views'], $source_row['clicks']) . "</td>";
echo "\t\t\t\t\t<td align='" . $phpAds_TextAlignRight . "'>" . phpAds_formatNumber($source_row['conversions']) . "</td>\n";
echo "\t\t\t\t\t<td align='" . $phpAds_TextAlignRight . "'>" . phpAds_buildCTR($source_row['clicks'], $source_row['conversions']) . " </td>";
echo "\t\t\t\t</tr>\n";
if ($expand && $children_present && !$anonymous) {
$child_source_row = $source_row['children'];
for ($i = 0; $i < sizeof($child_source_row); $i++) {
phpAds_printTableBreak(7, 2, $cnt % 2 == 0 ? "#F6F6F6" : "");
phpAds_printSourceRow($child_source_row[$i], $sources, $expand_arr, $listorder, $orderdirection, $begin_str . " ");
}
}
}
$total_clicks = 0;
$total_conversions = 0;
phpAds_getSources('', 1);
// Print Totals...
echo "<tr>";
echo "\t<td colspan='8'>TOTAL</td>\n";
echo "</tr>\n";
echo "<tr>";
echo "\t<td> </td>\n";
echo "\t<td> </td>\n";
echo "\t<td> </td>\n";
echo "\t<td>" . $total_views . "</td>\n";
echo "\t<td>" . $total_clicks . "</td>\n";
echo "\t<td>" . $total_conversions . "</td>\n";
echo "\t<td>" . phpAds_buildCTR($total_views, $total_clicks) . "</td>\n";
echo "\t<td>" . phpAds_buildCTR($total_clicks, $total_conversions) . "</td>\n";
echo "</tr>\n";
echo "</table>\n";
}
} else {
echo "No campaign ID selected.";
}
function phpAds_buildBannerWhereClause($bannerids)
{
global $phpAds_config;
$str = ' (';
if (!isset($bannerids) || !is_array($bannerids) || sizeof($bannerids) < 1) {
$str .= "1=0";
} else {
for ($i = 0; $i < sizeof($bannerids); $i++) {
if ($i != 0) {
echo "<td align='" . $phpAds_TextAlignRight . "'>" . phpAds_formatNumber($manual['views']) . "</td>";
echo "<td align='" . $phpAds_TextAlignRight . "'>" . phpAds_formatNumber($manual['clicks']) . "</td>";
echo "<td align='" . $phpAds_TextAlignRight . "'>" . phpAds_buildCTR($manual['views'], $manual['clicks']) . "</td>";
echo "<td align='" . $phpAds_TextAlignRight . "'>" . phpAds_formatNumber($manual['conversions']) . "</td>";
echo "<td align='" . $phpAds_TextAlignRight . "'>" . phpAds_buildCTR($manual['clicks'], $manual['conversions']) . " </td>";
echo "</tr>";
echo "<tr height='1'><td colspan='7' bgcolor='#888888'><img src='images/break.gif' height='1' width='100%'></td></tr>";
}
// Total
echo "<tr height='25'><td height='25'> <b>" . $strTotal . "</b></td>";
echo "<td> </td>";
echo "<td align='" . $phpAds_TextAlignRight . "'>" . phpAds_formatNumber($totalviews) . "</td>";
echo "<td align='" . $phpAds_TextAlignRight . "'>" . phpAds_formatNumber($totalclicks) . "</td>";
echo "<td align='" . $phpAds_TextAlignRight . "'>" . phpAds_buildCTR($totalviews, $totalclicks) . " </td>";
echo "<td align='" . $phpAds_TextAlignRight . "'>" . phpAds_formatNumber($totalconversions) . "</td>";
echo "<td align='" . $phpAds_TextAlignRight . "'>" . phpAds_buildCTR($totalclicks, $totalconversions) . " </td>";
echo "</tr>";
// Break
echo "\t\t\t\t<tr height='1'><td colspan='7' bgcolor='#888888'><img src='images/break.gif' height='1' width='100%'></td></tr>\n";
// Expand / Collapse
echo "\t\t\t\t<tr>\n";
echo "\t\t\t\t\t<td colspan='7' align='" . $phpAds_TextAlignRight . "' nowrap>";
echo "<img src='images/triangle-d.gif' align='absmiddle' border='0'>";
echo " <a href='stats-campaign-affiliates.php?clientid=" . $clientid . "&campaignid=" . $campaignid . "&expand=all' accesskey='" . $keyExpandAll . "'>" . $strExpandAll . "</a>";
echo " | ";
echo "<img src='images/" . $phpAds_TextDirection . "/triangle-l.gif' align='absmiddle' border='0'>";
echo " <a href='stats-campaign-affiliates.php?clientid=" . $clientid . "&campaignid=" . $campaignid . "&expand=none' accesskey='" . $keyCollapseAll . "'>" . $strCollapseAll . "</a>";
echo "</td>\n";
echo "\t\t\t\t</tr>";
echo "</table>";
echo "<br><br>";
function rowPresenter($array, $i = 0, $level = 0, $parent = '', $isClient = false, $id = 0)
{
global $HTTP_SERVER_VARS, $phpAds_TextAlignRight, $phpAds_TextDirection, $hideinactive, $i;
if (is_array($array)) {
foreach ($array as $array) {
if ($array['kind'] == 'campaign' && $array['active'] == 'f' && $hideinactive == '1') {
continue;
}
// Define kind of row and id
$kind = $array['kind'];
$thisID = $array['id'];
// Inserts divider if NOT top level (level > 0)
if ($level > 0) {
echo "<tr " . ($i % 2 == 0 ? "bgcolor='#F6F6F6'" : "") . "height='1'><td><img src='images/spacer.gif' width='1' height='1'></td><td colspan='6' bgcolor='#888888'><img src='images/break-l.gif' height='1' width='100%'></td></tr>";
}
// Sets background color of the row
echo "<tr height='25' " . ($i % 2 == 0 ? "bgcolor='#F6F6F6'" : "") . ">";
// Indents as necesseary
echo "<td height='25'>";
echo "<img src='images/spacer.gif' height='16' width='" . 4 . "'>";
echo "<img src='images/spacer.gif' height='16' width='" . $level * 20 . "'>";
// expanding arrows
if (isset($array['children']) && ($array['anonymous'] == 'f' || !phpAds_isUser(phpAds_Affiliate) && !phpAds_isUser(phpAds_Client))) {
if (isset($array['expand']) && $array['expand'] == '1') {
echo "<a href='" . $HTTP_SERVER_VARS['PHP_SELF'] . "?_id_=" . ($parent != '' ? $parent . "-" : '') . $thisID . "&collapse=1&" . ($isClient ? 'clientid=' . $id : 'affiliateid=' . $id) . "'><img src='images/triangle-d.gif' align='absmiddle' align='absmiddle' border='0'></a>";
} else {
echo "<a href='" . $HTTP_SERVER_VARS['PHP_SELF'] . "?_id_=" . ($parent != '' ? $parent . "-" : '') . $thisID . "&expand=1&" . ($isClient ? 'clientid=' . $id : 'affiliateid=' . $id) . "'><img src='images/" . $phpAds_TextDirection . "/triangle-l.gif' align='absmiddle' border='0'></a>";
}
} else {
echo "<img src='images/spacer.gif' height='16' width='" . 16 . "' align='absmiddle'>";
}
echo "<img src='images/spacer.gif' height='16' width='" . 4 . "'>";
// specific zone stuff
if ($kind == 'zone') {
// icon
if ($array['delivery'] == phpAds_ZoneBanner) {
echo "<img src='images/icon-zone.gif' align='absmiddle'>";
} elseif ($array['delivery'] == phpAds_ZoneInterstitial) {
echo "<img src='images/icon-interstitial.gif' align='absmiddle'>";
} elseif ($array['delivery'] == phpAds_ZonePopup) {
echo "<img src='images/icon-popup.gif' align='absmiddle'>";
} elseif ($array['delivery'] == phpAds_ZoneText) {
echo "<img src='images/icon-textzone.gif' align='absmiddle'>";
}
// spacer between icon and name
echo "<img src='images/spacer.gif' height='16' width='" . 4 . "' align='absmiddle'>";
// name and info
echo "<a href='stats-zone-history.php?affiliateid=" . $array['affiliateid'] . "&zoneid=" . $array['id'] . "'>" . $array['name'] . "</a>";
echo "</td>";
echo "<td height='25'>" . $array['id'] . "</td>";
} else {
if ($kind == 'campaign') {
// check whether the campaign is active
if ($array['active'] == 't') {
echo "<img src='images/icon-campaign.gif' align='absmiddle'>";
} else {
echo "<img src='images/icon-campaign-d.gif' align='absmiddle'>";
}
// spacer between icon and name
echo "<img src='images/spacer.gif' height='16' width='" . 4 . "' align='absmiddle'>";
// get campaign name
$name = '';
if (isset($array['alt']) && $array['alt'] != '') {
$name = $array['alt'];
}
if (isset($array['name']) && $array['name'] != '') {
$name = $array['name'];
}
// check whether we should show the name and id of this banner
if ($array['anonymous'] == 't' && (phpAds_isUser(phpAds_Affiliate) || phpAds_isUser(phpAds_Client))) {
echo "<a href='#'>" . $GLOBALS['strHiddenCampaign'] . "</a></td>";
echo "<td height='25'></td>";
} else {
echo $isClient ? "<a href='stats-campaign-history.php?clientid=" . $id . "&campaignid=" . $array['id'] . "'>" . $name . "</a>" : "<a href='stats-campaign-affiliates.php?clientid=" . $id . "&campaignid=" . $array['id'] . "'>" . $name . "</a>";
echo "</td><td height='25'>" . $array['id'] . "</td>";
}
} else {
if ($kind == 'banner') {
if (ereg('bannerid:' . $array['id'], $array['what'])) {
echo "<img src='images/icon-zone-linked.gif' align='absmiddle'>";
} else {
echo "<img src='images/icon-banner-stored.gif' align='absmiddle'>";
}
// spacer between icon and name
echo "<img src='images/spacer.gif' height='16' width='" . 4 . "' align='absmiddle'>";
if ($isClient) {
echo "<a href='stats-banner-history.php?clientid=" . $id . "&bannerid=" . $array['id'] . "&campaignid=" . phpAds_getBannerParentClientID($array['id']) . "'>" . ($array['anonymous'] == 't' ? "(Hidden Banner)" : phpAds_getBannerName($array['id'], 30, false)) . "</td>";
} else {
$thiszone = explode('-', $parent);
echo "<a href='stats-linkedbanner-history.php?affiliateid=" . $id . "&zoneid=" . $thiszone[0] . "&bannerid=" . $array['id'] . "'>" . ($array['anonymous'] == 't' ? "(Hidden Banner)" : phpAds_getBannerName($array['id'], 30, false)) . "</td>";
}
echo "</td>";
echo "<td height='25'>" . $array['id'] . "</td>";
}
}
}
echo "<td height='25' align='" . $phpAds_TextAlignRight . "'>" . phpAds_formatNumber($array['views']) . "</td>";
echo "<td height='25' align='" . $phpAds_TextAlignRight . "'>" . phpAds_formatNumber($array['clicks']) . "</td>";
echo "<td height='25' align='" . $phpAds_TextAlignRight . "'>" . phpAds_buildCTR($array['views'], $array['clicks']) . "</td>";
echo "<td height='25' align='" . $phpAds_TextAlignRight . "'>" . phpAds_formatNumber($array['conversions']) . "</td>";
echo "<td height='25' align='" . $phpAds_TextAlignRight . "'>" . phpAds_buildCTR($array['clicks'], $array['conversions']) . " </td>";
echo "</tr>";
if ($array['expand'] == TRUE && ($array['anonymous'] != 't' || !phpAds_isUser(phpAds_Affiliate) && !phpAds_isUser(phpAds_Client)) && is_array($array['children'])) {
rowPresenter($array['children'], $i, $level + 1, ($parent != '' ? $parent . "-" : '') . $thisID, $isClient, $id);
}
if ($level == 0) {
echo "<tr height='1'><td colspan='7' bgcolor='#888888'><img src='images/break.gif' height='1' width='100%'></td></tr>";
}
if ($level == 0) {
$i++;
}
}
}
}
if ($row_banners['description'] != '') {
$name = $row_banners['description'];
} elseif ($row_banners['alt'] != '') {
$name = $row_banners['alt'];
} else {
$name = $strUntitled;
}
echo phpAds_breakString($name, '30');
echo "</a>";
echo "</td>";
echo "<td height='25' align='" . $phpAds_TextAlignLeft . "' nowrap>" . $row_banners['bannerid'] . "</td>";
if ($adclicks > 0 || $adviews > 0) {
// Stats
echo "<td height='25' align='" . $phpAds_TextAlignRight . "' nowrap>" . phpAds_formatNumber($adviews) . "</td>";
echo "<td height='25' align='" . $phpAds_TextAlignRight . "' nowrap>" . phpAds_formatNumber($adclicks) . "</td>";
echo "<td height='25' align='" . $phpAds_TextAlignRight . "' nowrap>" . phpAds_buildCTR($adviews, $adclicks) . " </td>";
} else {
echo "<td height='25' align='" . $phpAds_TextAlignRight . "' nowrap>-</td>";
echo "<td height='25' align='" . $phpAds_TextAlignRight . "' nowrap>-</td>";
echo "<td height='25' align='" . $phpAds_TextAlignRight . "' nowrap>- </td>";
}
echo "</tr>";
echo "<tr bgcolor='{$bgcolor}'>";
echo "<td height='1' width='30'><img src='images/spacer.gif' width='1' height='1'></td>";
echo "<td colspan='5'>";
if (ereg("Mozilla/6", $_SERVER['HTTP_USER_AGENT']) || ereg("IE", $_SERVER['HTTP_USER_AGENT'])) {
echo "<div id='banner" . $row_banners['bannerid'] . "' style='display: none;'>";
echo "<table width='100%' cellpadding=0 cellspacing=0 border=0><tr><td align='" . $phpAds_TextAlignLeft . "'>";
echo "<tr><td height='1'><img src='images/break-l.gif' height='1' width='100%' vspace='0'></tr><td>";
echo "<tr><td height='10'> </tr><td>";
echo "<tr><td>";
