Client Index.php:
<?php // $Revision: 2.0.2.7 $
/************************************************************************/
/* phpPgAds */
/* ======== */
/* */
/* Copyright (c) 2001-2005 by the phpPgAds developers */
/* For more information visit: http://phppgads.sourceforge.net */
/* */
/* 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");
// Register input variables
phpAds_registerGlobal ('expand', 'collapse', 'hideinactive', 'listorder', 'orderdirection');
// Security check
phpAds_checkAccess(phpAds_Admin);
/*********************************************************/
/* HTML framework */
/*********************************************************/
phpAds_PageHeader("4.1");
phpAds_ShowSections(array("4.1", "4.2", "4.3"));
/*********************************************************/
/* Get preferences */
/*********************************************************/
if (!isset($hideinactive))
{
if (isset($Session['prefs']['client-index.php']['hideinactive']))
$hideinactive = $Session['prefs']['client-index.php']['hideinactive'];
else
$hideinactive = ($phpAds_config['gui_hide_inactive'] == 't');
}
if (!isset($listorder))
{
if (isset($Session['prefs']['client-index.php']['listorder']))
$listorder = $Session['prefs']['client-index.php']['listorder'];
else
$listorder = '';
}
if (!isset($orderdirection))
{
if (isset($Session['prefs']['client-index.php']['orderdirection']))
$orderdirection = $Session['prefs']['client-index.php']['orderdirection'];
else
$orderdirection = '';
}
if (isset($Session['prefs']['client-index.php']['nodes']))
$node_array = explode (", ", $Session['prefs']['client-index.php']['nodes']);
else
$node_array = array();
/*********************************************************/
/* Main code */
/*********************************************************/
// 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 = ".$Session["clientid"]." OR
parent = ".$Session["clientid"]."
".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;
$clients[$row_clients['clientid']]['count'] = 0;
$clients[$row_clients['clientid']]['hideinactive'] = 0;
}
else
{
$campaigns[$row_clients['clientid']] = $row_clients;
$campaigns[$row_clients['clientid']]['expand'] = 0;
$campaigns[$row_clients['clientid']]['count'] = 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;
$campaigns[$row_banners['clientid']]['count']++;
}
if (isset($clients[$row_banners['clientid']]))
{
$clients[$row_banners['clientid']]['count']++;
}
}
// Add ID found in expand to expanded nodes
if (isset($expand) && $expand != '')
{
switch ($expand)
{
case 'all' : $node_array = array();
if (isset($clients)) while (list($key, ) = each($clients)) $node_array[] = $key;
if (isset($campaigns)) while (list($key, ) = each($campaigns)) $node_array[] = $key;
break;
case 'none': $node_array = array();
break;
default: $node_array[] = $expand;
break;
}
}
$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
$clientshidden = 0;
if (isset($banners) && is_array($banners) && count($banners) > 0)
{
// Add banner to campaigns
reset ($banners);
while (list ($bkey, $banner) = each ($banners))
if ($hideinactive == false || $banner['active'] == 't')
$campaigns[$banner['clientid']]['banners'][$bkey] = $banner;
unset ($banners);
}
if (isset($campaigns) && is_array($campaigns) && count($campaigns) > 0)
{
reset ($campaigns);
while (list ($ckey, $campaign) = each ($campaigns))
{
if (!isset($campaign['banners']))
$campaign['banners'] = array();
if ($hideinactive == false || $campaign['active'] == 't' &&
(count($campaign['banners']) != 0 || count($campaign['banners']) == $campaign['count']))
$clients[$campaign['parent']]['campaigns'][$ckey] = $campaign;
else
$clients[$campaign['parent']]['hideinactive']++;
}
unset ($campaigns);
}
if (isset($clients) && is_array($clients) && count($clients) > 0)
{
reset ($clients);
while (list ($key, $client) = each ($clients))
{
if (!isset($client['campaigns']))
$client['campaigns'] = array();
if (isset($client['campaigns']) && count($client['campaigns']) == 0 && $client['hideinactive'] > 0)
{
$clientshidden++;
unset($clients[$key]);
}
}
}
echo "<img src='images/icon-client-new.gif' border='0' align='absmiddle'> ";
echo "<a href='client-edit.php' accesskey='".$keyAddNew."'>".$strAddClient_Key."</a> ";
phpAds_ShowBreak();
echo "<br><br>";
echo "<table border='0' width='100%' cellpadding='0' cellspacing='0'>";
echo "<tr height='25'>";
echo '<td height="25" width="40%"><b> <a href="client-index.php?listorder=name">'.$GLOBALS['strName'].'</a>';
if (($listorder == "name") || ($listorder == ""))
{
if (($orderdirection == "") || ($orderdirection == "down"))
{
echo ' <a href="client-index.php?orderdirection=up">';
echo '<img src="images/caret-ds.gif" border="0" alt="" title="">';
}
else
{
echo ' <a href="client-index.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="client-index.php?listorder=id">'.$GLOBALS['strID'].'</a>';
if ($listorder == "id")
{
if (($orderdirection == "") || ($orderdirection == "down"))
{
echo ' <a href="client-index.php?orderdirection=up">';
echo '<img src="images/caret-ds.gif" border="0" alt="" title="">';
}
else
{
echo ' <a href="client-index.php?orderdirection=down">';
echo '<img src="images/caret-u.gif" border="0" alt="" title="">';
}
echo '</a>';
}
echo '</b> </td>';
echo "<td height='25'> </td>";
echo "<td height='25'> </td>";
echo "<td height='25'> </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 " ".$strNoClients;
echo "</td></tr>";
echo "<td colspan='5' bgcolor='#888888'><img src='images/break.gif' height='1' width='100%'></td>";
}
else
{
$i=0;
foreach (array_keys($clients) as $key)
{
$client = $clients[$key];
if ($client['parent'] == 0)
{
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='client-index.php?collapse=".$client['clientid']."'><img src='images/triangle-d.gif' align='absmiddle' border='0'></a> ";
else
echo " <a href='client-index.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' align='absmiddle'> ";
echo "<img src='images/icon-client.gif' align='absmiddle'> ";
echo "<a href='client-edit.php?clientid=".$client['clientid']."'>".$client['clientname']."</a>";
echo "</td>";
// ID
echo "<td height='25'>".$client['clientid']."</td>";
// Button 1
echo "<td height='25'>";
if (($client['count'] == 0 && $client['expand'] == '1') || !isset($client['campaigns']))
echo "<a href='campaign-edit.php?clientid=".$client['clientid']."'><img src='images/icon-campaign-new.gif' border='0' align='absmiddle' alt='$strCreate'> $strCreate</a> ";
else
echo " ";
echo "</td>";
// Button 2
echo "<td height='25'>";
echo "<a href='client-campaigns.php?clientid=".$client['clientid']."'><img src='images/icon-overview.gif' border='0' align='absmiddle' alt='$strOverview'> $strOverview</a> ";
echo "</td>";
// Button 3
echo "<td height='25'>";
echo "<a href='client-delete.php?clientid=".$client['clientid']."&returnurl=client-index.php'".phpAds_DelConfirm($strConfirmDeleteClient)."><img src='images/icon-recycle.gif' border='0' align='absmiddle' alt='$strDelete'> $strDelete</a> ";
echo "</td></tr>";
if (isset($client['campaigns']) && sizeof ($client['campaigns']) > 0 && $client['expand'] == '1')
{
$campaigns = $client['campaigns'];
foreach (array_keys($campaigns) as $ckey)
{
// 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='client-index.php?collapse=".$campaigns[$ckey]['clientid']."'><img src='images/triangle-d.gif' align='absmiddle' border='0'></a> ";
else
echo "<a href='client-index.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='campaign-edit.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'>";
if ($campaigns[$ckey]['expand'] == '1' || !isset($campaigns[$ckey]['banners']))
echo "<a href='banner-edit.php?clientid=".$client['clientid']."&campaignid=".$campaigns[$ckey]['clientid']."'><img src='images/icon-banner-new.gif' border='0' align='absmiddle' alt='$strCreate'> $strCreate</a> ";
else
echo " ";
echo "</td>";
// Button 2
echo "<td height='25'>";
echo "<a href='campaign-banners.php?clientid=".$client['clientid']."&campaignid=".$campaigns[$ckey]['clientid']."'><img src='images/icon-overview.gif' border='0' align='absmiddle' alt='$strOverview'> $strOverview</a> ";
echo "</td>";
// Button 3
echo "<td height='25'>";
echo "<a href='campaign-delete.php?clientid=".$client['clientid']."&campaignid=".$campaigns[$ckey]['clientid']."&returnurl=client-index.php'".phpAds_DelConfirm($strConfirmDeleteCampaign)."><img src='images/icon-recycle.gif' border='0' align='absmiddle' alt='$strDelete'> $strDelete</a> ";
echo "</td></tr>";
if ($campaigns[$ckey]['expand'] == '1' && isset($campaigns[$ckey]['banners']))
{
$banners = $campaigns[$ckey]['banners'];
foreach (array_keys($banners) as $bkey)
{
$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'] == 'txt')
echo "<img src='images/icon-banner-text.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'] == 'txt')
echo "<img src='images/icon-banner-text-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='banner-edit.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> </td>";
// Button 2
echo "<td height='25'>";
echo "<a href='banner-acl.php?clientid=".$client['clientid']."&campaignid=".$campaigns[$ckey]['clientid']."&bannerid=".$banners[$bkey]['bannerid']."'><img src='images/icon-acl.gif' border='0' align='absmiddle' alt='$strACL'> $strACL</a> ";
echo "</td>";
// Button 1
echo "<td height='25'>";
echo "<a href='banner-delete.php?clientid=".$client['clientid']."&campaignid=".$campaigns[$ckey]['clientid']."&bannerid=".$banners[$bkey]['bannerid']."&returnurl=client-index.php'".phpAds_DelConfirm($strConfirmDeleteBanner)."><img src='images/icon-recycle.gif' border='0' align='absmiddle' alt='$strDelete'> $strDelete</a> ";
echo "</td></tr>";
}
}
}
}
if ($client['count'] > 0)
{
// 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>";
echo "<tr height='25' ".($i%2==0?"bgcolor='#F6F6F6'":"").">";
echo "<td height='25'> ";
echo "<img src='images/icon-campaign.gif' align='absmiddle'> ";
echo "$strBannersWithoutCampaign</td>";
echo "<td height='25'> - </td>";
echo "<td height='25' colspan='3'>";
echo "<a href='campaign-edit.php?clientid=".$client['clientid']."&move=t'>";
echo "<img src='images/".$phpAds_TextDirection."/icon-update.gif' border='0' align='absmiddle' alt='$strMoveToNewCampaign'> $strMoveToNewCampaign</a> ";
echo "</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 "<tr><td height='25' colspan='3' align='".$phpAds_TextAlignLeft."' nowrap>";
if ($hideinactive == true)
{
echo " <img src='images/icon-activate.gif' align='absmiddle' border='0'>";
echo " <a href='client-index.php?hideinactive=0'>".$strShowAll."</a>";
echo " | ".$clientshidden." ".$strInactiveAdvertisersHidden;
}
else
{
echo " <img src='images/icon-hideinactivate.gif' align='absmiddle' border='0'>";
echo " <a href='client-index.php?hideinactive=1'>".$strHideInactiveAdvertisers."</a>";
}
echo "</td><td height='25' colspan='2' align='".$phpAds_TextAlignRight."' nowrap>";
echo "<img src='images/triangle-d.gif' align='absmiddle' border='0'>";
echo " <a href='client-index.php?expand=all' accesskey='".$keyExpandAll."'>".$strExpandAll."</a>";
echo " | ";
echo "<img src='images/".$phpAds_TextDirection."/triangle-l.gif' align='absmiddle' border='0'>";
echo " <a href='client-index.php?expand=none' accesskey='".$keyCollapseAll."'>".$strCollapseAll."</a> ";
echo "</td></tr>";
echo "</table>";
// total number of clients
$res_clients = phpAds_dbQuery("SELECT count(*) AS count FROM ".$phpAds_config['tbl_clients']." WHERE parent IS NULL") or phpAds_sqlDie();
$res_campaigns = phpAds_dbQuery("SELECT count(*) AS count FROM ".$phpAds_config['tbl_clients']." WHERE parent > 0") or phpAds_sqlDie();
$res_active_campaigns = phpAds_dbQuery("SELECT count(*) AS count FROM ".$phpAds_config['tbl_clients']." WHERE parent > 0 AND active='t'");
$res_total_banners = phpAds_dbQuery("SELECT count(*) AS count FROM ".$phpAds_config['tbl_banners']);
$res_active_banners = phpAds_dbQuery("SELECT count(*) AS count FROM ".$phpAds_config['tbl_banners']." as b, ".$phpAds_config['tbl_clients']." as c WHERE b.clientid=c.clientid AND c.active='t' AND b.active='t'");
echo "<br><br><br><br>";
echo "<table width='100%' border='0' align='center' cellspacing='0' cellpadding='0'>";
echo "<tr><td height='25' colspan='3'> <b>".$strOverall."</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><td height='25'> ".$strTotalBanners.": <b>".phpAds_dbResult($res_total_banners, 0, "count")."</b></td>";
echo "<td height='25'>".$strTotalCampaigns.": <b>".phpAds_dbResult($res_campaigns, 0, "count")."</b></td>";
echo "<td height='25'>".$strTotalClients.": <b>".phpAds_dbResult($res_clients, 0, "count")."</b></td></tr>";
echo "<tr height='1'><td colspan='4' bgcolor='#888888'><img src='images/break-el.gif' height='1' width='100%'></td></tr>";
echo "<tr><td height='25'> ".$strActiveBanners.": <b>".phpAds_dbResult($res_active_banners, 0, "count")."</b></td>";
echo "<td height='25'>".$strActiveCampaigns.": <b>".phpAds_dbResult($res_active_campaigns, 0, "count")."</b></td>";
echo "<td height='25'> </td></tr>";
echo "<tr height='1'><td colspan='3' bgcolor='#888888'><img src='images/break.gif' height='1' width='100%'></td></tr>";
echo "</table>";
echo "<br><br>";
/*********************************************************/
/* Store preferences */
/*********************************************************/
$Session['prefs']['client-index.php']['hideinactive'] = $hideinactive;
$Session['prefs']['client-index.php']['listorder'] = $listorder;
$Session['prefs']['client-index.php']['orderdirection'] = $orderdirection;
$Session['prefs']['client-index.php']['nodes'] = implode (", ", $node_array);
phpAds_SessionDataStore();
/*********************************************************/
/* HTML framework */
/*********************************************************/
phpAds_PageFooter();
?>
Other Ad Management Scripts:
