Viewing file:  stats-global-client.php (27.42 KB) -rwxr-xr-x
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php // $Revision: 1.4 $
/************************************************************************/
/* 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");
// Security check
phpAds_checkAccess(phpAds_Admin+phpAds_Client);
/*********************************************************/
/* HTML framework */
/*********************************************************/
if (phpAds_isUser(phpAds_Admin))
{
$extra = '';
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;
if ($verboseviews > 0 || $verboseclicks > 0)
{
// Show link to verbose stats convertor
$extra .= "<br><br>
<table cellspacing='0' cellpadding='1' width='140' bgcolor='#000088'><tr><td>
<table cellpadding='4' cellspacing='0' bgcolor='#FFFFFF'><tr>
<td valign='top'><img src='images/info-w.gif' vspace='absmiddle'></td>
<td valign='top'><b>Alert:</b><br>
You have enabled the compact statistics, but your old statistics are still
in verbose format. Do you want to convert your verbose statistics to the
new compact format?<br><br>
<a href='stats-convert.php?command=frame' target='_new' onClick=\"return openWindow('stats-convert.php?command=frame','','status=yes,scrollbars=yes,resizable=yes,width=400,height=500');\">
<img src='images/".$phpAds_TextDirection."/icon-update.gif' border='0' align='absmiddle'> Convert</a>
</td>
</tr></table>
</td></tr></table>";
}
}
phpAds_PageHeader("2.1", $extra);
phpAds_ShowSections(array("2.1", "2.4", "2.3", "2.2"));
}
if (phpAds_isUser(phpAds_Client))
{
phpAds_PageHeader("1.1");
phpAds_ShowSections(array("1.1", "1.2"));
}
echo "<br><br>";
/*********************************************************/
/* Get preferences */
/*********************************************************/
if (!isset($listorder))
{
if (isset($Session['prefs']['stats-global-client.php']['listorder']))
$listorder = $Session['prefs']['stats-global-client.php']['listorder'];
else
$listorder = '';
}
if (!isset($orderdirection))
{
if (isset($Session['prefs']['stats-global-client.php']['orderdirection']))
$orderdirection = $Session['prefs']['stats-global-client.php']['orderdirection'];
else
$orderdirection = '';
}
if (isset($Session['prefs']['stats-global-client.php']['nodes']))
$node_array = explode (",", $Session['prefs']['stats-global-client.php']['nodes']);
else
$node_array = array();
/*********************************************************/
/* Main code */
/*********************************************************/
if (phpAds_isUser(phpAds_Client) && $phpAds_config['client_welcome'])
{
// Show welcome message
if (!empty($phpAds_client_welcome_msg))
echo $phpAds_client_welcome_msg;
else
{
include('templates/welcome.html');
}
echo "<br><br>";
}
// Get clients & campaign and build the tree
if (phpAds_isUser(phpAds_Admin))
{
$res_clients = phpAds_dbQuery("
SELECT
*
FROM
".$phpAds_config['tbl_clients']."
".phpAds_getListOrder ($listorder, $orderdirection)."
") or phpAds_sqlDie();
}
else
{
$res_clients = phpAds_dbQuery("
SELECT
*
FROM
".$phpAds_config['tbl_clients']."
WHERE
clientid = ".phpAds_getUserID()." OR
parent = ".phpAds_getUserID()."
".phpAds_getListOrder ($listorder, $orderdirection)."
") or phpAds_sqlDie();
}
while ($row_clients = phpAds_dbFetchArray($res_clients))
{
if ($row_clients['parent'] == 0)
{
$clients[$row_clients['clientid']] = $row_clients;
$clients[$row_clients['clientid']]['expand'] = 0;
}
else
{
$campaigns[$row_clients['clientid']] = $row_clients;
$campaigns[$row_clients['clientid']]['expand'] = 0;
}
}
// Get the banners for each campaign
$res_banners = phpAds_dbQuery("
SELECT
bannerid,
clientid,
alt,
description,
active,
storagetype
FROM
".$phpAds_config['tbl_banners']."
".phpAds_getBannerListOrder ($listorder, $orderdirection)."
") or phpAds_sqlDie();
while ($row_banners = phpAds_dbFetchArray($res_banners))
{
if (isset($campaigns[$row_banners['clientid']]))
{
$banners[$row_banners['bannerid']] = $row_banners;
$banners[$row_banners['bannerid']]['clicks'] = 0;
$banners[$row_banners['bannerid']]['views'] = 0;
}
}
// Get the adviews/clicks for each banner
if ($phpAds_config['compact_stats'])
{
$res_stats = phpAds_dbQuery("
SELECT
s.bannerid as bannerid,
b.clientid as clientid,
sum(s.views) as views,
sum(s.clicks) as clicks
FROM
".$phpAds_config['tbl_adstats']." as s,
".$phpAds_config['tbl_banners']." as b
WHERE
b.bannerid = s.bannerid
GROUP BY
s.bannerid
") or phpAds_sqlDie();
while ($row_stats = phpAds_dbFetchArray($res_stats))
{
if (isset($banners[$row_stats['bannerid']]))
{
$banners[$row_stats['bannerid']]['clicks'] = $row_stats['clicks'];
$banners[$row_stats['bannerid']]['views'] = $row_stats['views'];
}
}
}
else
{
$res_stats = phpAds_dbQuery("
SELECT
v.bannerid as bannerid,
b.clientid as clientid,
count(v.bannerid) as views
FROM
".$phpAds_config['tbl_adviews']." as v,
".$phpAds_config['tbl_banners']." as b
WHERE
b.bannerid = v.bannerid
GROUP BY
v.bannerid
") or phpAds_sqlDie();
while ($row_stats = phpAds_dbFetchArray($res_stats))
{
if (isset($banners[$row_stats['bannerid']]))
{
$banners[$row_stats['bannerid']]['views'] = $row_stats['views'];
$banners[$row_stats['bannerid']]['clicks'] = 0;
}
}
$res_stats = phpAds_dbQuery("
SELECT
c.bannerid as bannerid,
b.clientid as clientid,
count(c.bannerid) as clicks
FROM
".$phpAds_config['tbl_adclicks']." as c,
".$phpAds_config['tbl_banners']." as b
WHERE
b.bannerid = c.bannerid
GROUP BY
c.bannerid
") or phpAds_sqlDie();
while ($row_stats = phpAds_dbFetchArray($res_stats))
{
if (isset($banners[$row_stats['bannerid']]))
{
$banners[$row_stats['bannerid']]['clicks'] = $row_stats['clicks'];
}
}
}
// Add ID found in expand to expanded nodes
if (isset($expand) && $expand != '')
$node_array[] = $expand;
$node_array_size = sizeof($node_array);
for ($i=0; $i < $node_array_size;$i++)
{
if (isset($collapse) && $collapse == $node_array[$i])
unset ($node_array[$i]);
else
{
if (isset($clients[$node_array[$i]]))
$clients[$node_array[$i]]['expand'] = 1;
if (isset($campaigns[$node_array[$i]]))
$campaigns[$node_array[$i]]['expand'] = 1;
}
}
// Build Tree
if (isset($banners) && is_array($banners) && count($banners) > 0)
{
// Add banner to campaigns
for (reset($banners);$bkey=key($banners);next($banners))
$campaigns[$banners[$bkey]['clientid']]['banners'][$bkey] = $banners[$bkey];
unset ($banners);
}
if (isset($campaigns) && is_array($campaigns) && count($campaigns) > 0)
{
for (reset($campaigns);$ckey=key($campaigns);next($campaigns))
$clients[$campaigns[$ckey]['parent']]['campaigns'][$ckey] = $campaigns[$ckey];
unset ($campaigns);
}
if (isset($clients) && is_array($clients) && count($clients) > 0)
{
// Calculate statistics for clients
for (reset($clients);$key=key($clients);next($clients))
{
$clientviews = 0;
$clientclicks = 0;
if (isset($clients[$key]['campaigns']) && sizeof ($clients[$key]['campaigns']) > 0)
{
$campaigns = $clients[$key]['campaigns'];
// Calculate statistics for campaigns
for (reset($campaigns);$ckey=key($campaigns);next($campaigns))
{
$campaignviews = 0;
$campaignclicks = 0;
if (isset($campaigns[$ckey]['banners']) && sizeof ($campaigns[$ckey]['banners']) > 0)
{
$banners = $campaigns[$ckey]['banners'];
for (reset($banners);$bkey=key($banners);next($banners))
{
$campaignviews += $banners[$bkey]['views'];
$campaignclicks += $banners[$bkey]['clicks'];
}
}
$clientviews += $campaignviews;
$clientclicks += $campaignclicks;
$clients[$key]['campaigns'][$ckey]['views'] = $campaignviews;
$clients[$key]['campaigns'][$ckey]['clicks'] = $campaignclicks;
}
}
$clients[$key]['clicks'] = $clientclicks;
$clients[$key]['views'] = $clientviews;
}
unset ($campaigns);
unset ($banners);
}
if (phpAds_isUser(phpAds_Admin))
{
// Information for the Administrator
echo "<table border='0' width='100%' cellpadding='0' cellspacing='0'>";
echo "<tr height='25'>";
echo '<td height="25" width="40%"><b> <a href="stats-global-client.php?listorder=name">'.$GLOBALS['strName'].'</a>';
if (($listorder == "name") || ($listorder == ""))
{
if (($orderdirection == "") || ($orderdirection == "down"))
{
echo ' <a href="stats-global-client.php?orderdirection=up">';
echo '<img src="images/caret-ds.gif" border="0" alt="" title="">';
}
else
{
echo ' <a href="stats-global-client.php?orderdirection=down">';
echo '<img src="images/caret-u.gif" border="0" alt="" title="">';
}
echo '</a>';
}
echo '</b></td>';
echo '<td height="25"><b><a href="stats-global-client.php?listorder=id">'.$GLOBALS['strID'].'</a>';
if ($listorder == "id")
{
if (($orderdirection == "") || ($orderdirection == "down"))
{
echo ' <a href="stats-global-client.php?orderdirection=up">';
echo '<img src="images/caret-ds.gif" border="0" alt="" title="">';
}
else
{
echo ' <a href="stats-global-client.php?orderdirection=down">';
echo '<img src="images/caret-u.gif" border="0" alt="" title="">';
}
echo '</a>';
}
echo '</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>";
if (!isset($clients) || !is_array($clients) || count($clients) == 0)
{
echo "<tr height='25' bgcolor='#F6F6F6'><td height='25' colspan='5'>";
echo " ".$strNoStats;
echo "</td></tr>";
echo "<td colspan='5' bgcolor='#888888'><img src='images/break.gif' height='1' width='100%'></td>";
}
else
{
$i=0;
for (reset($clients);$key=key($clients);next($clients))
{
$client = $clients[$key];
echo "<tr height='25' ".($i%2==0?"bgcolor='#F6F6F6'":"").">";
// Icon & name
echo "<td height='25'>";
if (isset($client['campaigns']))
{
if ($client['expand'] == '1')
echo " <a href='stats-global-client.php?collapse=".$client['clientid']."'><img src='images/triangle-d.gif' align='absmiddle' border='0'></a> ";
else
echo " <a href='stats-global-client.php?expand=".$client['clientid']."'><img src='images/".$phpAds_TextDirection."/triangle-l.gif' align='absmiddle' border='0'></a> ";
}
else
echo " <img src='images/spacer.gif' height='16' width='16'> ";
echo "<img src='images/icon-client.gif' align='absmiddle'> ";
echo "<a href='stats-client-history.php?clientid=".$client['clientid']."'>".$client['clientname']."</a>";
echo "</td>";
// ID
echo "<td height='25'>".$client['clientid']."</td>";
// Button 1
echo "<td height='25' align='right'>".$client['views']."</td>";
// Empty
echo "<td height='25' align='right'>".$client['clicks']."</td>";
// Button 3
echo "<td height='25' align='right'>".phpAds_buildCTR($client['views'], $client['clicks'])." </td>";
if (isset($client['campaigns']) && sizeof ($client['campaigns']) > 0 && $client['expand'] == '1')
{
$campaigns = $client['campaigns'];
for (reset($campaigns);$ckey=key($campaigns);next($campaigns))
{
// Divider
echo "<tr height='1'>";
echo "<td ".($i%2==0?"bgcolor='#F6F6F6'":"")."><img src='images/spacer.gif' width='1' height='1'></td>";
echo "<td colspan='5' bgcolor='#888888'><img src='images/break-l.gif' height='1' width='100%'></td>";
echo "</tr>";
// Icon & name
echo "<tr height='25' ".($i%2==0?"bgcolor='#F6F6F6'":"")."><td height='25'>";
echo " ";
if (isset($campaigns[$ckey]['banners']))
{
if ($campaigns[$ckey]['expand'] == '1')
echo "<a href='stats-global-client.php?collapse=".$campaigns[$ckey]['clientid']."'><img src='images/triangle-d.gif' align='absmiddle' border='0'></a> ";
else
echo "<a href='stats-global-client.php?expand=".$campaigns[$ckey]['clientid']."'><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'> ";
if ($campaigns[$ckey]['active'] == 't')
echo "<img src='images/icon-campaign.gif' align='absmiddle'> ";
else
echo "<img src='images/icon-campaign-d.gif' align='absmiddle'> ";
echo "<a href='stats-campaign-history.php?clientid=".$client['clientid']."&campaignid=".$campaigns[$ckey]['clientid']."'>".$campaigns[$ckey]['clientname']."</td>";
echo "</td>";
// ID
echo "<td height='25'>".$campaigns[$ckey]['clientid']."</td>";
// Button 1
echo "<td height='25' align='right'>".$campaigns[$ckey]['views']."</td>";
// Button 2
echo "<td height='25' align='right'>".$campaigns[$ckey]['clicks']."</td>";
// Button 3
echo "<td height='25' align='right'>".phpAds_buildCTR($campaigns[$ckey]['views'], $campaigns[$ckey]['clicks'])." </td>";
if ($campaigns[$ckey]['expand'] == '1' && isset($campaigns[$ckey]['banners']))
{
$banners = $campaigns[$ckey]['banners'];
for (reset($banners);$bkey=key($banners);next($banners))
{
$name = $strUntitled;
if (isset($banners[$bkey]['alt']) && $banners[$bkey]['alt'] != '') $name = $banners[$bkey]['alt'];
if (isset($banners[$bkey]['description']) && $banners[$bkey]['description'] != '') $name = $banners[$bkey]['description'];
$name = phpAds_breakString ($name, '30');
// Divider
echo "<tr height='1'>";
echo "<td ".($i%2==0?"bgcolor='#F6F6F6'":"")."><img src='images/spacer.gif' width='1' height='1'></td>";
echo "<td colspan='4' bgcolor='#888888'><img src='images/break-l.gif' height='1' width='100%'></td>";
echo "</tr>";
// Icon & name
echo "<tr height='25' ".($i%2==0?"bgcolor='#F6F6F6'":"").">";
echo "<td height='25'> ";
if ($banners[$bkey]['active'] == 't' && $campaigns[$ckey]['active'] == 't')
{
if ($banners[$bkey]['storagetype'] == 'html')
echo "<img src='images/icon-banner-html.gif' align='absmiddle'>";
elseif ($banners[$bkey]['storagetype'] == 'url')
echo "<img src='images/icon-banner-url.gif' align='absmiddle'>";
else
echo "<img src='images/icon-banner-stored.gif' align='absmiddle'>";
}
else
{
if ($banners[$bkey]['storagetype'] == 'html')
echo "<img src='images/icon-banner-html-d.gif' align='absmiddle'>";
elseif ($banners[$bkey]['storagetype'] == 'url')
echo "<img src='images/icon-banner-url-d.gif' align='absmiddle'>";
else
echo "<img src='images/icon-banner-stored-d.gif' align='absmiddle'>";
}
echo " <a href='stats-banner-history.php?clientid=".$client['clientid']."&campaignid=".$campaigns[$ckey]['clientid']."&bannerid=".$banners[$bkey]['bannerid']."'>".$name."</a></td>";
// ID
echo "<td height='25'>".$banners[$bkey]['bannerid']."</td>";
// Empty
echo "<td height='25' align='right'>".$banners[$bkey]['views']."</td>";
// Button 2
echo "<td height='25' align='right'>".$banners[$bkey]['clicks']."</td>";
// Button 1
echo "<td height='25' align='right'>".phpAds_buildCTR($banners[$bkey]['views'], $banners[$bkey]['clicks'])." </td>";
}
}
}
}
if (isset ($client['banners']) && sizeof($client['banners']) > 0)
{
// Divider
echo "<tr height='1'><td colspan='1'></td><td colspan='3' 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'>$strBannersWithoutCampaign</td>";
echo "<td height='25'> - </td>";
echo "<td> </td>";
echo "<td> </td>";
echo "<td> </td>";
echo "</tr>";
}
echo "<tr height='1'><td colspan='5' bgcolor='#888888'><img src='images/break.gif' height='1' width='100%'></td></tr>";
$i++;
}
}
echo "</table>";
echo "<br><br><br><br>";
echo "<table width='100%' border='0' align='center' cellspacing='0' cellpadding='0'>";
echo "<tr><td height='25' colspan='4'><b>$strStats</b></td></tr>";
echo "<tr height='1'><td colspan='4' bgcolor='#888888'><img src='images/break.gif' height='1' width='100%'></td></tr>";
// stats today
$adviews = (int)phpAds_totalViews("", "day");
$adclicks = (int)phpAds_totalClicks("", "day");
$ctr = phpAds_buildCTR($adviews, $adclicks);
echo "<tr><td height='25'>$strToday</td>";
echo "<td height='25'>$strViews: <b>$adviews</b></td>";
echo "<td height='25'>$strClicks: <b>$adclicks</b></td>";
echo "<td height='25'>$strCTRShort: <b>$ctr</b></td></tr>";
echo "<tr height='1'><td colspan='4' bgcolor='#888888'><img src='images/break-el.gif' height='1' width='100%'></td></tr>";
// stats this week
$adviews = (int)phpAds_totalViews("", "week");
$adclicks = (int)phpAds_totalClicks("", "week");
$ctr = phpAds_buildCTR($adviews, $adclicks);
echo "<tr><td height='25'>$strLast7Days</td>";
echo "<td height='25'>$strViews: <b>$adviews</b></td>";
echo "<td height='25'>$strClicks: <b>$adclicks</b></td>";
echo "<td height='25'>$strCTRShort: <b>$ctr</b></td></tr>";
echo "<tr height='1'><td colspan='4' bgcolor='#888888'><img src='images/break-el.gif' height='1' width='100%'></td></tr>";
// stats this month
$adviews = (int)phpAds_totalViews("", "month");
$adclicks = (int)phpAds_totalClicks("", "month");
$ctr = phpAds_buildCTR($adviews, $adclicks);
echo "<tr><td height='25'>$strThisMonth</td>";
echo "<td height='25'>$strViews: <b>$adviews</b></td>";
echo "<td height='25'>$strClicks: <b>$adclicks</b></td>";
echo "<td height='25'>$strCTRShort: <b>$ctr</b></td></tr>";
echo "<tr height='1'><td colspan='4' bgcolor='#888888'><img src='images/break-el.gif' height='1' width='100%'></td></tr>";
// overall stats
$adviews = (int)phpAds_totalViews();
$adclicks = (int)phpAds_totalClicks();
$ctr = phpAds_buildCTR($adviews, $adclicks);
echo "<tr><td height='25'>$strOverall</td>";
echo "<td height='25'>$strViews: <b>$adviews</b></td>";
echo "<td height='25'>$strClicks: <b>$adclicks</b></td>";
echo "<td height='25'>$strCTRShort: <b>$ctr</b></td></tr>";
echo "<tr height='1'><td colspan='4' bgcolor='#888888'><img src='images/break.gif' height='1' width='100%'></td></tr>";
echo "<tr height='25'><td colspan='4' height='25'>";
echo "<img src='images/".$phpAds_TextDirection."/icon-undo.gif' align='absmiddle'> <a href='stats-reset.php?all=true'".phpAds_DelConfirm($strConfirmResetStats).">$strResetStats</a> ";
echo "</td></tr>";
echo "</table>";
}
else
{
// Information for the client
$client = $clients[phpAds_getUserID()];
if (isset($client['campaigns']) && sizeof ($client['campaigns']) > 0)
{
echo "<table border='0' width='100%' cellpadding='0' cellspacing='0'>";
echo "<tr height='25'>";
echo "<td height='25' width='40%'><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>";
$i=0;
$campaigns = $client['campaigns'];
for (reset($campaigns);$ckey=key($campaigns);next($campaigns))
{
// Icon & name
echo "<tr height='25' ".($i%2==0?"bgcolor='#F6F6F6'":"")."><td height='25'>";
echo " ";
if (isset($campaigns[$ckey]['banners']))
{
if ($campaigns[$ckey]['expand'] == '1')
echo "<a href='stats-global-client.php?collapse=".$campaigns[$ckey]['clientid']."'><img src='images/triangle-d.gif' align='absmiddle' border='0'></a> ";
else
echo "<a href='stats-global-client.php?expand=".$campaigns[$ckey]['clientid']."'><img src='images/".$phpAds_TextDirection."/triangle-l.gif' align='absmiddle' border='0'></a> ";
}
else
echo "<img src='images/spacer.gif' height='16' width='16'> ";
if ($campaigns[$ckey]['active'] == 't')
echo "<img src='images/icon-campaign.gif' align='absmiddle'> ";
else
echo "<img src='images/icon-campaign-d.gif' align='absmiddle'> ";
echo "<a href='stats-campaign-banners.php?clientid=".$client['clientid']."&campaignid=".$campaigns[$ckey]['clientid']."'>".$campaigns[$ckey]['clientname']."</td>";
echo "</td>";
// ID
echo "<td height='25'>".$campaigns[$ckey]['clientid']."</td>";
// Button 1
echo "<td height='25' align='right'>".$campaigns[$ckey]['views']."</td>";
// Button 2
echo "<td height='25' align='right'>".$campaigns[$ckey]['clicks']."</td>";
// Button 3
echo "<td height='25' align='right'>".phpAds_buildCTR($campaigns[$ckey]['views'], $campaigns[$ckey]['clicks'])." </td>";
if ($campaigns[$ckey]['expand'] == '1' && isset($campaigns[$ckey]['banners']))
{
$banners = $campaigns[$ckey]['banners'];
for (reset($banners);$bkey=key($banners);next($banners))
{
$name = $strUntitled;
if (isset($banners[$bkey]['alt']) && $banners[$bkey]['alt'] != '') $name = $banners[$bkey]['alt'];
if (isset($banners[$bkey]['description']) && $banners[$bkey]['description'] != '') $name = $banners[$bkey]['description'];
$name = phpAds_breakString ($name, '30');
// Divider
echo "<tr height='1'>";
echo "<td ".($i%2==0?"bgcolor='#F6F6F6'":"")."><img src='images/spacer.gif' width='1' height='1'></td>";
echo "<td colspan='4' bgcolor='#888888'><img src='images/break-l.gif' height='1' width='100%'></td>";
echo "</tr>";
// Icon & name
echo "<tr height='25' ".($i%2==0?"bgcolor='#F6F6F6'":"").">";
echo "<td height='25'> ";
if ($banners[$bkey]['active'] == 't' && $campaigns[$ckey]['active'] == 't')
{
if ($banners[$bkey]['format'] == 'html')
echo "<img src='images/icon-banner-html.gif' align='absmiddle'>";
elseif ($banners[$bkey]['format'] == 'url')
echo "<img src='images/icon-banner-url.gif' align='absmiddle'>";
else
echo "<img src='images/icon-banner-stored.gif' align='absmiddle'>";
}
else
{
if ($banners[$bkey]['format'] == 'html')
echo "<img src='images/icon-banner-html-d.gif' align='absmiddle'>";
elseif ($banners[$bkey]['format'] == 'url')
echo "<img src='images/icon-banner-url-d.gif' align='absmiddle'>";
else
echo "<img src='images/icon-banner-stored-d.gif' align='absmiddle'>";
}
echo " <a href='stats-banner-history.php?clientid=".$client['clientid']."&campaignid=".$campaigns[$ckey]['clientid']."&bannerid=".$banners[$bkey]['bannerid']."'>".$name."</a></td>";
// ID
echo "<td height='25'>".$banners[$bkey]['bannerid']."</td>";
// Empty
echo "<td height='25' align='right'>".$banners[$bkey]['views']."</td>";
// Button 2
echo "<td height='25' align='right'>".$banners[$bkey]['clicks']."</td>";
// Button 1
echo "<td height='25' align='right'>".phpAds_buildCTR($banners[$bkey]['views'], $banners[$bkey]['clicks'])." </td>";
}
}
if (isset ($client['banners']) && sizeof($client['banners']) > 0)
{
// Divider
echo "<tr height='1'><td colspan='1'></td><td colspan='3' 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'>$strBannersWithoutCampaign</td>";
echo "<td height='25'> - </td>";
echo "<td> </td>";
echo "<td> </td>";
echo "<td> </td>";
echo "</tr>";
}
echo "<tr height='1'><td colspan='5' bgcolor='#888888'><img src='images/break.gif' height='1' width='100%'></td></tr>";
$i++;
}
echo "</table>";
echo "<br><br><br><br>";
}
}
echo "<br><br>";
/*********************************************************/
/* Store preferences */
/*********************************************************/
$Session['prefs']['stats-global-client.php']['listorder'] = $listorder;
$Session['prefs']['stats-global-client.php']['orderdirection'] = $orderdirection;
$Session['prefs']['stats-global-client.php']['nodes'] = implode (",", $node_array);
phpAds_SessionDataStore();
/*********************************************************/
/* HTML framework */
/*********************************************************/
phpAds_PageFooter();
?>
|