Viewing file:  stats-zone-linkedbanners.php (8.19 KB) -rwxr-xr-x
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php // $Revision: 1.3 $
/************************************************************************/
/* phpAdsNew 2 */
/* =========== */
/* */
/* Copyright (c) 2001 by the phpAdsNew developers */
/* http://sourceforge.net/projects/phpadsnew */
/* */
/* 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");
require ("lib-size.inc.php");
// Security check
phpAds_checkAccess(phpAds_Admin+phpAds_Affiliate);
/*********************************************************/
/* Affiliate interface security */
/*********************************************************/
if (phpAds_isUser(phpAds_Affiliate))
{
$affiliateid = phpAds_getUserID();
}
/*********************************************************/
/* HTML framework */
/*********************************************************/
if (phpAds_isUser(phpAds_Admin))
{
$res = phpAds_dbQuery("
SELECT
*
FROM
".$phpAds_config['tbl_zones']."
WHERE
affiliateid = ".$affiliateid."
") 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-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("1.1.1", "1.1.2"));
}
/*********************************************************/
/* Main code */
/*********************************************************/
// Get the zone information
$res_stats = phpAds_dbQuery("
SELECT
what
FROM
".$phpAds_config['tbl_zones']."
WHERE
zoneid = ".$zoneid."
");
if ($row_zone = phpAds_dbFetchArray($res_stats))
{
$zone = $row_zone;
// Get the adviews/clicks for each banner
if ($phpAds_config['compact_stats'])
{
$res_stats = phpAds_dbQuery("
SELECT
bannerid,
SUM(views) AS views,
sum(clicks) AS clicks
FROM
".$phpAds_config['tbl_adstats']."
WHERE
zoneid = ".$zoneid."
GROUP BY
zoneid, bannerid
");
while ($row_stats = phpAds_dbFetchArray($res_stats))
{
$linkedbanners[$row_stats['bannerid']]['bannerid'] = $row_stats['bannerid'];
$linkedbanners[$row_stats['bannerid']]['clicks'] = $row_stats['clicks'];
$linkedbanners[$row_stats['bannerid']]['views'] = $row_stats['views'];
}
}
else
{
$res_stats = phpAds_dbQuery("
SELECT
zoneid,
bannerid,
count(bannerid) as views
FROM
".$phpAds_config['tbl_adviews']."
WHERE
zoneid = ".$zoneid."
GROUP BY
zoneid, bannerid
");
while ($row_stats = phpAds_dbFetchArray($res_stats))
{
$linkedbanners[$row_stats['bannerid']]['bannerid'] = $row_stats['bannerid'];
$linkedbanners[$row_stats['bannerid']]['clicks'] = 0;
$linkedbanners[$row_stats['bannerid']]['views'] = $row_stats['views'];
}
$res_stats = phpAds_dbQuery("
SELECT
zoneid,
bannerid,
count(bannerid) as clicks
FROM
".$phpAds_config['tbl_adclicks']."
WHERE
zoneid = ".$zoneid."
GROUP BY
zoneid, bannerid
");
while ($row_stats = phpAds_dbFetchArray($res_stats))
{
$linkedbanners[$row_stats['bannerid']]['bannerid'] = $row_stats['bannerid'];
$linkedbanners[$row_stats['bannerid']]['clicks'] = $row_stats['clicks'];
}
}
}
echo "<br><br>";
echo "<table border='0' width='100%' cellpadding='0' cellspacing='0'>";
echo "<tr height='25'>";
echo '<td height="25"><b> '.$GLOBALS['strName'].'</b></td>';
echo '<td height="25"><b>'.$GLOBALS['strID'].'</b> </td>';
echo "<td height='25' align='right'><b>".$GLOBALS['strViews']."</b></td>";
echo "<td height='25' align='right'><b>".$GLOBALS['strClicks']."</b></td>";
echo "<td height='25' align='right'><b>".$GLOBALS['strCTRShort']."</b> </td>";
echo "</tr>";
echo "<tr height='1'><td colspan='5' bgcolor='#888888'><img src='images/break.gif' height='1' width='100%'></td></tr>";
$totalviews = 0;
$totalclicks = 0;
if (!isset($linkedbanners) || !is_array($linkedbanners) || count($linkedbanners) == 0)
{
echo "<tr height='25' bgcolor='#F6F6F6'><td height='25' colspan='5'>";
echo " ".$strNoLinkedBanners;
echo "</td></tr>";
echo "<td colspan='5' bgcolor='#888888'><img src='images/break.gif' height='1' width='100%'></td>";
}
else
{
$i=0;
for (reset($linkedbanners);$key=key($linkedbanners);next($linkedbanners))
{
$linkedbanner = $linkedbanners[$key];
echo "<tr height='25' ".($i%2==0?"bgcolor='#F6F6F6'":"").">";
// Icon & name
echo "<td height='25'>";
if (ereg ('bannerid:'.$linkedbanner['bannerid'], $zone['what']))
echo " <img src='images/icon-zone-linked.gif' align='absmiddle'> ";
else
echo " <img src='images/icon-banner-stored.gif' align='absmiddle'> ";
echo "<a href='stats-linkedbanner-history.php?affiliateid=".$affiliateid."&zoneid=".$zoneid."&bannerid=".$linkedbanner['bannerid']."'>".phpAds_getBannerName($linkedbanner['bannerid'], 30, false)."</a>";
echo "</td>";
echo "<td height='25'>".$linkedbanner['bannerid']."</td>";
echo "<td height='25' align='right'>".$linkedbanner['views']."</td>";
echo "<td height='25' align='right'>".$linkedbanner['clicks']."</td>";
echo "<td height='25' align='right'>".phpAds_buildCTR($linkedbanner['views'], $linkedbanner['clicks'])." </td>";
echo "</tr>";
echo "<tr height='1'><td colspan='5' bgcolor='#888888'><img src='images/break.gif' height='1' width='100%'></td></tr>";
$i++;
$totalclicks += $linkedbanner['clicks'];
$totalviews += $linkedbanner['views'];
}
// Total
echo "<tr height='25'><td height='25'> <b>".$strTotal."</b></td>";
echo "<td height='25'> </td>";
echo "<td height='25' align='right'>".$totalviews."</td>";
echo "<td height='25' align='right'>".$totalclicks."</td>";
echo "<td height='25' align='right'>".phpAds_buildCTR($totalviews, $totalclicks)." </td>";
echo "</tr>";
//echo "<tr height='1'><td colspan='5' bgcolor='#888888'><img src='images/break.gif' height='1' width='100%'></td></tr>";
}
echo "</table>";
echo "<br><br>";
/*********************************************************/
/* HTML framework */
/*********************************************************/
phpAds_PageFooter();
?>
|