Banner Zone.php:
<?php // $Revision: 2.0.2.6 $
/************************************************************************/
/* 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");
require ("lib-zones.inc.php");
require ("lib-size.inc.php");
// Register input variables
phpAds_registerGlobal ('submit', 'includezone', 'listorder', 'orderdirection');
// Security check
phpAds_checkAccess(phpAds_Admin);
/*********************************************************/
/* Process submitted form */
/*********************************************************/
if (isset($submit))
{
$previouszone = array();
// Get all zones
$res = phpAds_dbQuery("
SELECT
zoneid,
what
FROM
".$phpAds_config['tbl_zones']."
WHERE
zonetype = ".phpAds_ZoneBanners."
") or phpAds_sqlDie();
while ($row = phpAds_dbFetchArray($res))
$previouszone[$row['zoneid']] = (phpAds_IsBannerInZone ($bannerid, $row['zoneid'], $row['what']));
foreach (array_keys($previouszone) as $key)
{
if (($previouszone[$key] == true && (!isset($includezone[$key]) || $includezone[$key] != 't')) ||
($previouszone[$key] != true && (isset($includezone[$key]) && $includezone[$key] == 't')))
{
phpAds_ToggleBannerInZone ($bannerid, $key);
}
}
}
/*********************************************************/
/* Get preferences */
/*********************************************************/
if (!isset($listorder))
{
if (isset($Session['prefs']['banner-zone.php']['listorder']))
$listorder = $Session['prefs']['banner-zone.php']['listorder'];
else
$listorder = '';
}
if (!isset($orderdirection))
{
if (isset($Session['prefs']['banner-zone.php']['orderdirection']))
$orderdirection = $Session['prefs']['banner-zone.php']['orderdirection'];
else
$orderdirection = '';
}
/*********************************************************/
/* HTML framework */
/*********************************************************/
if (isset($Session['prefs']['campaign-banners.php'][$campaignid]['listorder']))
$navorder = $Session['prefs']['campaign-banners.php'][$campaignid]['listorder'];
else
$navorder = '';
if (isset($Session['prefs']['campaign-banners.php'][$campaignid]['orderdirection']))
$navdirection = $Session['prefs']['campaign-banners.php'][$campaignid]['orderdirection'];
else
$navdirection = '';
// Get other banners
$res = phpAds_dbQuery("
SELECT
*
FROM
".$phpAds_config['tbl_banners']."
WHERE
clientid = '$campaignid'
".phpAds_getBannerListOrder($navorder, $navdirection)."
");
while ($row = phpAds_dbFetchArray($res))
{
phpAds_PageContext (
phpAds_buildBannerName ($row['bannerid'], $row['description'], $row['alt']),
"banner-zone.php?clientid=".$clientid."&campaignid=".$campaignid."&bannerid=".$row['bannerid'],
$bannerid == $row['bannerid']
);
}
phpAds_PageShortcut($strClientProperties, 'client-edit.php?clientid='.$clientid, 'images/icon-client.gif');
phpAds_PageShortcut($strCampaignProperties, 'campaign-edit.php?clientid='.$clientid.'&campaignid='.$campaignid, 'images/icon-campaign.gif');
phpAds_PageShortcut($strBannerHistory, 'stats-banner-history.php?clientid='.$clientid.'&campaignid='.$campaignid.'&bannerid='.$bannerid, 'images/icon-statistics.gif');
$extra = "<form action='banner-modify.php'>";
$extra .= "<input type='hidden' name='clientid' value='$clientid'>";
$extra .= "<input type='hidden' name='campaignid' value='$campaignid'>";
$extra .= "<input type='hidden' name='bannerid' value='$bannerid'>";
$extra .= "<input type='hidden' name='returnurl' value='banner-zone.php'>";
$extra .= "<br><br>";
$extra .= "<b>$strModifyBanner</b><br>";
$extra .= "<img src='images/break.gif' height='1' width='160' vspace='4'><br>";
$extra .= "<img src='images/icon-duplicate-banner.gif' align='absmiddle'> <a href='banner-modify.php?clientid=".$clientid."&campaignid=".$campaignid."&bannerid=".$bannerid."&duplicate=true&returnurl=banner-zone.php'>$strDuplicate</a><br>";
$extra .= "<img src='images/break.gif' height='1' width='160' vspace='4'><br>";
$extra .= "<img src='images/icon-move-banner.gif' align='absmiddle'> $strMoveTo<br>";
$extra .= "<img src='images/spacer.gif' height='1' width='160' vspace='2'><br>";
$extra .= " ";
$extra .= "<select name='moveto' style='width: 110;'>";
$res = phpAds_dbQuery("SELECT * FROM ".$phpAds_config['tbl_clients']." WHERE parent > 0 AND clientid != '".$campaignid."'") or phpAds_sqlDie();
while ($row = phpAds_dbFetchArray($res))
$extra .= "<option value='".$row['clientid']."'>".phpAds_buildClientName($row['clientid'], $row['clientname'])."</option>";
$extra .= "</select> <input type='image' name='moveto' src='images/".$phpAds_TextDirection."/go_blue.gif'><br>";
$extra .= "<img src='images/break.gif' height='1' width='160' vspace='4'><br>";
$extra .= "<img src='images/icon-recycle.gif' align='absmiddle'> <a href='banner-delete.php?clientid=".$clientid."&campaignid=".$campaignid."&bannerid=".$bannerid."&returnurl=campaign-banners.php'".phpAds_DelConfirm($strConfirmDeleteBanner).">$strDelete</a><br>";
$extra .= "</form>";
$sections = array ("4.1.3.4.2", "4.1.3.4.3", "4.1.3.4.6", "4.1.3.4.4");
phpAds_PageHeader("4.1.3.4.4", $extra);
echo "<img src='images/icon-client.gif' align='absmiddle'> ".phpAds_getParentName($campaignid);
echo " <img src='images/".$phpAds_TextDirection."/caret-rs.gif'> ";
echo "<img src='images/icon-campaign.gif' align='absmiddle'> ".phpAds_getClientName($campaignid);
echo " <img src='images/".$phpAds_TextDirection."/caret-rs.gif'> ";
echo "<img src='images/icon-banner-stored.gif' align='absmiddle'> <b>".phpAds_getBannerName($bannerid)."</b><br><br>";
echo phpAds_buildBannerCode($bannerid)."<br><br><br><br>";
phpAds_ShowSections($sections);
/*********************************************************/
/* Main code */
/*********************************************************/
// Get banner info
$res = phpAds_dbQuery ("
SELECT
*
FROM
".$phpAds_config['tbl_banners']."
WHERE
bannerid = '".$bannerid."'
") or phpAds_sqlDie();
$banner = phpAds_dbFetchArray($res);
// Get affiliates
$res = phpAds_dbQuery ("
SELECT
affiliateid,
name
FROM
".$phpAds_config['tbl_affiliates']."
".phpAds_getAffiliateListOrder ($listorder, $orderdirection)."
") or phpAds_sqlDie();
$affiliate_count = phpAds_dbNumRows($res);
while ($row = phpAds_dbFetchArray($res))
{
$affiliates[$row['affiliateid']] = $row;
$affiliates[$row['affiliateid']]['ZoneBanners'] = 0;
$affiliates[$row['affiliateid']]['ZoneCampaigns'] = 0;
}
if ($banner['contenttype'] == 'txt')
{
// Get banner zones
$res = phpAds_dbQuery("
SELECT
zoneid,
affiliateid,
zonename,
description,
width,
height,
what,
zonetype,
delivery
FROM
".$phpAds_config['tbl_zones']."
WHERE
delivery = ".phpAds_ZoneText." AND
zonetype = ".phpAds_ZoneBanners."
".phpAds_getZoneListOrder ($listorder, $orderdirection)."
") or phpAds_sqlDie();
$zone_count = phpAds_dbNumRows($res);
while ($row = phpAds_dbFetchArray($res))
{
if (isset($affiliates[$row['affiliateid']]))
{
$row['linked'] = (phpAds_IsBannerInZone ($bannerid, $row['zoneid'], $row['what']));
$affiliates[$row['affiliateid']]['zones'][$row['zoneid']] = $row;
$affiliates[$row['affiliateid']]['ZoneBanners']++;
}
}
// Get campaign zones
$res = phpAds_dbQuery("
SELECT
zoneid,
affiliateid,
zonename,
description,
width,
height,
what,
zonetype,
delivery
FROM
".$phpAds_config['tbl_zones']."
WHERE
delivery = ".phpAds_ZoneText." AND
zonetype = ".phpAds_ZoneCampaign."
".phpAds_getZoneListOrder ($listorder, $orderdirection)."
") or phpAds_sqlDie();
while ($row = phpAds_dbFetchArray($res))
{
if (isset($affiliates[$row['affiliateid']]))
{
if (phpAds_IsCampaignInZone ($campaignid, $row['zoneid'], $row['what']))
{
$zone_count++;
$row['linked'] = true;
$affiliates[$row['affiliateid']]['zones'][$row['zoneid']] = $row;
$affiliates[$row['affiliateid']]['ZoneCampaigns']++;
}
}
}
}
else
{
// Get banner zones
$res = phpAds_dbQuery("
SELECT
z.zoneid as zoneid,
z.affiliateid as affiliateid,
z.zonename as zonename,
z.description as description,
z.width as width,
z.height as height,
z.what as what,
z.zonetype as zonetype,
z.delivery as delivery
FROM
".$phpAds_config['tbl_zones']." AS z,
".$phpAds_config['tbl_banners']." AS b
WHERE
b.bannerid = $bannerid AND
(z.width = b.width OR z.width = -1) AND
(z.height = b.height OR z.height = -1) AND
z.zonetype = ".phpAds_ZoneBanners." AND
z.delivery != ".phpAds_ZoneText."
".phpAds_getZoneListOrder ($listorder, $orderdirection)."
") or phpAds_sqlDie();
$zone_count = phpAds_dbNumRows($res);
while ($row = phpAds_dbFetchArray($res))
{
if (isset($affiliates[$row['affiliateid']]))
{
$row['linked'] = (phpAds_IsBannerInZone ($bannerid, $row['zoneid'], $row['what']));
$affiliates[$row['affiliateid']]['zones'][$row['zoneid']] = $row;
$affiliates[$row['affiliateid']]['ZoneBanners']++;
}
}
// Get campaign zones
$res = phpAds_dbQuery("
SELECT
zoneid,
affiliateid,
zonename,
description,
width,
height,
what,
zonetype,
delivery
FROM
".$phpAds_config['tbl_zones']."
WHERE
zonetype = ".phpAds_ZoneCampaign."
".phpAds_getZoneListOrder ($listorder, $orderdirection)."
") or phpAds_sqlDie();
while ($row = phpAds_dbFetchArray($res))
{
if (isset($affiliates[$row['affiliateid']]))
{
if (phpAds_IsCampaignInZone ($campaignid, $row['zoneid'], $row['what']))
{
$zone_count++;
$row['linked'] = true;
$affiliates[$row['affiliateid']]['zones'][$row['zoneid']] = $row;
$affiliates[$row['affiliateid']]['ZoneCampaigns']++;
}
}
}
}
$tabindex = 1;
echo "<br><table border='0' width='100%' cellpadding='0' cellspacing='0'>";
echo "<form name='zones' action='banner-zone.php' method='post'>";
echo "<input type='hidden' name='clientid' value='".$clientid."'>";
echo "<input type='hidden' name='campaignid' value='".$campaignid."'>";
echo "<input type='hidden' name='bannerid' value='".$bannerid."'>";
echo "<tr height='25'>";
echo '<td height="25" width="40%"><b> <a href="banner-zone.php?clientid='.$clientid.'&campaignid='.$campaignid.'&bannerid='.$bannerid.'&listorder=name">'.$GLOBALS['strName'].'</a>';
if (($listorder == "name") || ($listorder == ""))
{
if (($orderdirection == "") || ($orderdirection == "down"))
{
echo ' <a href="banner-zone.php?clientid='.$clientid.'&campaignid='.$campaignid.'&bannerid='.$bannerid.'&orderdirection=up">';
echo '<img src="images/caret-ds.gif" border="0" alt="" title="">';
}
else
{
echo ' <a href="banner-zone.php?clientid='.$clientid.'&campaignid='.$campaignid.'&bannerid='.$bannerid.'&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="banner-zone.php?clientid='.$clientid.'&campaignid='.$campaignid.'&bannerid='.$bannerid.'&listorder=id">'.$GLOBALS['strID'].'</a>';
if ($listorder == "id")
{
if (($orderdirection == "") || ($orderdirection == "down"))
{
echo ' <a href="banner-zone.php?clientid='.$clientid.'&campaignid='.$campaignid.'&bannerid='.$bannerid.'&orderdirection=up">';
echo '<img src="images/caret-ds.gif" border="0" alt="" title="">';
}
else
{
echo ' <a href="banner-zone.php?clientid='.$clientid.'&campaignid='.$campaignid.'&bannerid='.$bannerid.'&orderdirection=down">';
echo '<img src="images/caret-u.gif" border="0" alt="" title="">';
}
echo '</a>';
}
echo '</b> </td>';
echo "<td height='25'><b>".$GLOBALS['strDescription']."</b> </td>";
echo "</tr>";
echo "<tr height='1'><td colspan='3' bgcolor='#888888'><img src='images/break.gif' height='1' width='100%'></td></tr>";
if ($zone_count > 0 && $affiliate_count > 0)
{
$i=0;
foreach (array_keys($affiliates) as $akey)
{
$affiliate = $affiliates[$akey];
if (isset($affiliate['zones']))
{
$zones = $affiliate['zones'];
if ($i > 0) echo "<td colspan='3' bgcolor='#888888'><img src='images/break.gif' height='1' width='100%'></td>";
echo "<tr height='25' ".($i%2==0?"bgcolor='#F6F6F6'":"").">";
echo "<td height='25'>";
$zoneslinked = 0;
foreach (array_keys($zones) as $zkey)
if ($zones[$zkey]['linked']) $zoneslinked++;
if ($affiliate['ZoneBanners'] > 0)
{
if (count($zones) == $zoneslinked)
echo " <input name='affiliate[".$affiliate['affiliateid']."]' type='checkbox' value='t' checked ";
else
echo " <input name='affiliate[".$affiliate['affiliateid']."]' type='checkbox' value='t' ";
echo "onClick='toggleZones(".$affiliate['affiliateid'].");' tabindex='".($tabindex++)."'>";
}
else
{
if (count($zones) == $zoneslinked)
echo " <input name='' type='checkbox' value='t' checked disabled>";
else
echo " <input name='' type='checkbox' value='t' disabled>";
}
echo " <img src='images/icon-affiliate.gif' align='absmiddle'> ";
echo "<a href='affiliate-edit.php?affiliateid=".$affiliate['affiliateid']."'>".$affiliate['name']."</a>";
echo " ";
echo "</td>";
// ID
echo "<td height='25'>".$affiliate['affiliateid']."</td>";
// Description
echo "<td height='25'> </td>";
echo "</tr>";
foreach (array_keys($zones) as $zkey)
{
$zone = $zones[$zkey];
echo "<td ".($i%2==0?"bgcolor='#F6F6F6'":"")."><img src='images/spacer.gif' height=1'></td>";
echo "<td colspan='3' bgcolor='#888888'><img src='images/break-l.gif' height='1' width='100%'></td>";
echo "<tr height='25' ".($i%2==0?"bgcolor='#F6F6F6'":"").">";
echo "<td height='25'>";
echo " ";
if ($zone['zonetype'] == phpAds_ZoneBanners)
{
if ($zone['linked'])
echo " <input name='includezone[".$zone['zoneid']."]' id='a".$affiliate['affiliateid']."' type='checkbox' value='t' checked ";
else
echo " <input name='includezone[".$zone['zoneid']."]' id='a".$affiliate['affiliateid']."' type='checkbox' value='t' ";
echo "onClick='toggleAffiliate(".$affiliate['affiliateid'].");' tabindex='".($tabindex++)."'> ";
}
else
{
if ($zone['linked'])
echo " <input name='' id='' type='checkbox' value='t' checked disabled ";
else
echo " <input name='' id='' type='checkbox' value='t' disabled ";
echo "> ";
}
if ($zone['delivery'] == phpAds_ZoneBanner)
echo "<img src='images/icon-zone.gif' align='absmiddle'> ";
elseif ($zone['delivery'] == phpAds_ZoneInterstitial)
echo "<img src='images/icon-interstitial.gif' align='absmiddle'> ";
elseif ($zone['delivery'] == phpAds_ZonePopup)
echo "<img src='images/icon-popup.gif' align='absmiddle'> ";
elseif ($zone['delivery'] == phpAds_ZoneText)
echo "<img src='images/icon-textzone.gif' align='absmiddle'> ";
echo "<a href='zone-edit.php?affiliateid=".$affiliate['affiliateid']."&zoneid=".$zone['zoneid']."'>".$zone['zonename']."</a>";
echo " ";
echo "</td>";
// ID
echo "<td height='25'>".$zone['zoneid']."</td>";
// Description
echo "<td height='25'>".stripslashes($zone['description'])."</td>";
echo "</tr>";
}
$i++;
}
}
echo "<tr height='1'><td colspan='3' bgcolor='#888888'><img src='images/break.gif' height='1' width='100%'></td></tr>";
}
else
{
echo "<tr height='25' bgcolor='#F6F6F6'>";
echo "<td colspan='4'>";
echo " ".$strNoZonesToLink;
echo "</td>";
echo "<tr height='1'><td colspan='3' bgcolor='#888888'><img src='images/break.gif' height='1' width='100%'></td></tr>";
}
echo "</table>";
if (isset($affiliates) && count($affiliates) > 0)
{
echo "<br><br>";
echo "<input type='submit' name='submit' value='$strSaveChanges' tabindex='".($tabindex++)."'>";
}
echo "</form>";
/*********************************************************/
/* Form requirements */
/*********************************************************/
?>
<script language='Javascript'>
<!--
affiliates = new Array();
<?php
if (isset($affiliates) && is_array($affiliates) && count($affiliates))
foreach (array_keys($affiliates) as $akey)
if (isset($affiliates[$akey]['zones']))
echo "\taffiliates[".$akey."] = ".$affiliates[$akey]['ZoneBanners'].";\n";
?>
function toggleAffiliate(affiliateid)
{
var count = 0;
var affiliate;
for (var i=0; i<document.zones.elements.length; i++)
{
if (document.zones.elements[i].name == 'affiliate[' + affiliateid + ']')
affiliate = i;
if (document.zones.elements[i].id == 'a' + affiliateid + '' &&
document.zones.elements[i].checked)
count++;
}
document.zones.elements[affiliate].checked = (count == affiliates[affiliateid]);
}
function toggleZones(affiliateid)
{
var checked
for (var i=0; i<document.zones.elements.length; i++)
{
if (document.zones.elements[i].name == 'affiliate[' + affiliateid + ']')
checked = document.zones.elements[i].checked;
if (document.zones.elements[i].id == 'a' + affiliateid + '')
document.zones.elements[i].checked = checked;
}
}
//-->
</script>
<?php
/*********************************************************/
/* Store preferences */
/*********************************************************/
$Session['prefs']['banner-zone.php']['listorder'] = $listorder;
$Session['prefs']['banner-zone.php']['orderdirection'] = $orderdirection;
phpAds_SessionDataStore();
/*********************************************************/
/* HTML framework */
/*********************************************************/
phpAds_PageFooter();
?>
Other Ad Management Scripts:
