Campaign Zone.php:
<?php // $Revision: 2.0.2.4 $
/************************************************************************/
/* 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 ('listorder', 'orderdirection', 'submit', 'includezone');
// 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_ZoneCampaign."
") or phpAds_sqlDie();
while ($row = phpAds_dbFetchArray($res))
$previouszone[$row['zoneid']] = (phpAds_IsCampaignInZone ($campaignid, $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_ToggleCampaignInZone ($campaignid, $key);
}
}
Header("Location: campaign-banners.php?clientid=".$clientid."&campaignid=".$campaignid);
exit;
}
/*********************************************************/
/* Get preferences */
/*********************************************************/
if (!isset($listorder))
{
if (isset($Session['prefs']['campaign-zone.php']['listorder']))
$listorder = $Session['prefs']['campaign-zone.php']['listorder'];
else
$listorder = '';
}
if (!isset($orderdirection))
{
if (isset($Session['prefs']['campaign-zone.php']['orderdirection']))
$orderdirection = $Session['prefs']['campaign-zone.php']['orderdirection'];
else
$orderdirection = '';
}
/*********************************************************/
/* HTML framework */
/*********************************************************/
if (isset($Session['prefs']['client-campaigns.php'][$clientid]['listorder']))
$navorder = $Session['prefs']['client-campaigns.php'][$clientid]['listorder'];
else
$navorder = '';
if (isset($Session['prefs']['client-campaigns.php'][$clientid]['orderdirection']))
$navdirection = $Session['prefs']['client-campaigns.php'][$clientid]['orderdirection'];
else
$navdirection = '';
// Get other campaigns
$res = phpAds_dbQuery("
SELECT
*
FROM
".$phpAds_config['tbl_clients']."
WHERE
parent = ".$clientid."
".phpAds_getListOrder ($navorder, $navdirection)."
");
while ($row = phpAds_dbFetchArray($res))
{
phpAds_PageContext (
phpAds_buildClientName ($row['clientid'], $row['clientname']),
"campaign-zone.php?clientid=".$clientid."&campaignid=".$row['clientid'],
$campaignid == $row['clientid']
);
}
phpAds_PageShortcut($strClientProperties, 'client-edit.php?clientid='.$clientid, 'images/icon-client.gif');
phpAds_PageShortcut($strCampaignHistory, 'stats-campaign-history.php?clientid='.$clientid.'&campaignid='.$campaignid, 'images/icon-statistics.gif');
$extra = "<form action='campaign-modify.php'>";
$extra .= "<input type='hidden' name='clientid' value='$clientid'>";
$extra .= "<input type='hidden' name='campaignid' value='$campaignid'>";
$extra .= "<input type='hidden' name='returnurl' value='campaign-banners.php'>";
$extra .= "<br><br>";
$extra .= "<b>$strModifyCampaign</b><br>";
$extra .= "<img src='images/break.gif' height='1' width='160' vspace='4'><br>";
$extra .= "<img src='images/icon-move-campaign.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 IS NULL AND clientid != ".phpAds_getParentID ($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' 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='campaign-delete.php?clientid=".$clientid."&campaignid=".$campaignid."&returnurl=client-index.php'".phpAds_DelConfirm($strConfirmDeleteCampaign).">$strDelete</a><br>";
$extra .= "</form>";
phpAds_PageHeader("4.1.3.3", $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'> <b>".phpAds_getClientName($campaignid)."</b><br><br><br>";
phpAds_ShowSections(array("4.1.3.2", "4.1.3.3", "4.1.3.4"));
/*********************************************************/
/* Main code */
/*********************************************************/
$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;
}
$res = phpAds_dbQuery("
SELECT
zoneid,
affiliateid,
zonename,
description,
width,
height,
what,
delivery
FROM
".$phpAds_config['tbl_zones']."
WHERE
zonetype = ".phpAds_ZoneCampaign."
".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_IsCampaignInZone ($campaignid, $row['zoneid'], $row['what']));
$affiliates[$row['affiliateid']]['zones'][$row['zoneid']] = $row;
}
}
$tabindex = 1;
echo "<br><br>";
echo "<table border='0' width='100%' cellpadding='0' cellspacing='0'>";
echo "<form name='zones' action='campaign-zone.php' method='post'>";
echo "<input type='hidden' name='clientid' value='".$clientid."'>";
echo "<input type='hidden' name='campaignid' value='".$campaignid."'>";
echo "<tr height='25'>";
echo '<td height="25" width="40%"><b> <a href="campaign-zone.php?clientid='.$clientid.'&campaignid='.$campaignid.'&listorder=name">'.$GLOBALS['strName'].'</a>';
if (($listorder == "name") || ($listorder == ""))
{
if (($orderdirection == "") || ($orderdirection == "down"))
{
echo ' <a href="campaign-zone.php?clientid='.$clientid.'&campaignid='.$campaignid.'&orderdirection=up">';
echo '<img src="images/caret-ds.gif" border="0" alt="" title="">';
}
else
{
echo ' <a href="campaign-zone.php?clientid='.$clientid.'&campaignid='.$campaignid.'&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="campaign-zone.php?clientid='.$clientid.'&campaignid='.$campaignid.'&listorder=id">'.$GLOBALS['strID'].'</a>';
if ($listorder == "id")
{
if (($orderdirection == "") || ($orderdirection == "down"))
{
echo ' <a href="campaign-zone.php?clientid='.$clientid.'&campaignid='.$campaignid.'&orderdirection=up">';
echo '<img src="images/caret-ds.gif" border="0" alt="" title="">';
}
else
{
echo ' <a href="campaign-zone.php?clientid='.$clientid.'&campaignid='.$campaignid.'&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 (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++)."'>";
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['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++)."'> ";
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 " ".$strNoZonesToLinkToCampaign;
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."] = ".count($affiliates[$akey]['zones']).";\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']['campaign-zone.php']['listorder'] = $listorder;
$Session['prefs']['campaign-zone.php']['orderdirection'] = $orderdirection;
phpAds_SessionDataStore();
/*********************************************************/
/* HTML framework */
/*********************************************************/
phpAds_PageFooter();
?>
Other Ad Management Scripts:
