Banner Append.php:
<?php // $Revision: 1.1.2.9 $
/************************************************************************/
/* 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-invocation.inc.php");
require ("lib-size.inc.php");
require ("lib-append.inc.php");
require ("lib-banner.inc.php");
// Register input variables
phpAds_registerGlobal ('append', 'submitbutton');
phpAds_registerGlobal ('appendtype', 'appendtype_previous', 'appendsave', 'appendselection', 'appendwhat');
// Security check
phpAds_checkAccess(phpAds_Admin);
/*********************************************************/
/* Process submitted form */
/*********************************************************/
if (isset($submitbutton))
{
if (isset($bannerid) && $bannerid != '')
{
// Do not save append until not finished with appending, if present
if (isset($appendsave) && $appendsave)
{
if ($appendtype == phpAds_AppendNone)
{
$append = '';
}
if ($appendtype == phpAds_AppendPopup ||
$appendtype == phpAds_AppendInterstitial)
{
if ($appendselection == phpAds_AppendBanner)
$what = isset($appendwhat[phpAds_AppendBanner]) ? implode (', ', $appendwhat[phpAds_AppendBanner]) : '';
elseif ($appendselection == phpAds_AppendZone)
$what = isset($appendwhat[phpAds_AppendZone]) ? 'zone:'.$appendwhat[phpAds_AppendZone] : 'zone:0';
else
$what = $appendwhat[phpAds_AppendKeyword];
if ($appendtype == phpAds_AppendPopup)
{
$codetype = 'popup';
}
else
{
$codetype = 'adlayer';
if (!isset($layerstyle)) $layerstyle = 'geocities';
include ('../libraries/layerstyles/'.$layerstyle.'/invocation.inc.php');
}
$append = addslashes(phpAds_GenerateInvocationCode());
}
// Update banner
$sqlupdate = array();
$sqlupdate[] = "append='".$append."'";
$sqlupdate[] = "appendtype='".$appendtype."'";
$res = phpAds_dbQuery("
UPDATE
".$phpAds_config['tbl_banners']."
SET
".join(', ', $sqlupdate)."
WHERE
bannerid='".$bannerid."'
") or phpAds_sqlDie();
// Rebuild Banner cache
phpAds_rebuildBannerCache($bannerid);
// Rebuild Cache
if (!defined('LIBVIEWCACHE_INCLUDED')) include (phpAds_path.'/libraries/deliverycache/cache-'.$phpAds_config['delivery_caching'].'.inc.php');
phpAds_cacheDelete();
}
// Do not redirect until not finished with zone appending, if present
if (!isset($appendsave) || $appendsave)
{
header ("Location: banner-zone.php?clientid=".$clientid."&campaignid=".$campaignid."&bannerid=".$bannerid);
exit;
}
}
}
/*********************************************************/
/* 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-append.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.6", $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 */
/*********************************************************/
$res = phpAds_dbQuery("
SELECT
*
FROM
".$phpAds_config['tbl_banners']."
WHERE
bannerid = '".$bannerid."'
") or phpAds_sqlDie();
if (phpAds_dbNumRows($res))
$banner = phpAds_dbFetchArray($res);
$tabindex = 1;
if ($banner['storagetype'] != 'txt')
{
// Header
echo "<form name='appendform' method='post' action='banner-append.php' onSubmit='return phpAds_formSubmit() && phpAds_formCheck(this);'>";
echo "<input type='hidden' name='clientid' value='".(isset($clientid) && $clientid != '' ? $clientid : '')."'>";
echo "<input type='hidden' name='campaignid' value='".(isset($campaignid) && $campaignid != '' ? $campaignid : '')."'>";
echo "<input type='hidden' name='bannerid' value='".(isset($bannerid) && $bannerid != '' ? $bannerid : '')."'>";
echo "<br><table border='0' width='100%' cellpadding='0' cellspacing='0'>";
echo "<tr><td height='25' colspan='3'><b>".$strAppendSettings."</b></td></tr>";
echo "<tr height='1'><td width='30'><img src='images/break.gif' height='1' width='30'></td>";
echo "<td width='200'><img src='images/break.gif' height='1' width='200'></td>";
echo "<td width='100%'><img src='images/break.gif' height='1' width='100%'></td></tr>";
echo "<tr><td height='10' colspan='3'> </td></tr>";
// Get available zones
$available = array();
// Get list of public publishers
$res = phpAds_dbQuery("SELECT * FROM ".$phpAds_config['tbl_affiliates']." WHERE publiczones = 't'");
while ($row = phpAds_dbFetchArray($res))
$available[] = "affiliateid = '".$row['affiliateid']."'";
$available = implode ($available, ' OR ');
// Get public zones
$res = phpAds_dbQuery("SELECT zoneid, zonename, delivery FROM ".$phpAds_config['tbl_zones']." WHERE ".
"(delivery = ".phpAds_ZonePopup." OR delivery = ".phpAds_ZoneInterstitial.
") AND (".$available.") ORDER BY zoneid");
$available = array(phpAds_ZonePopup => array(), phpAds_ZoneInterstitial => array());
while ($row = phpAds_dbFetchArray($res))
$available[$row['delivery']][$row['zoneid']] = phpAds_buildZoneName($row['zoneid'], $row['zonename']);
// Get available zones
$available_banners = array();
// Get campaigns from same advertiser
$res = phpAds_dbQuery("SELECT * FROM ".$phpAds_config['tbl_clients']." WHERE parent = '".$clientid."' AND active = 't'");
while ($row = phpAds_dbFetchArray($res))
$available_banners[] = "clientid = '".$row['clientid']."'";
$available_banners = implode ($available_banners, ' OR ');
// Get banners from same advertiser
$res = phpAds_dbQuery("SELECT bannerid, clientid, description, alt FROM ".$phpAds_config['tbl_banners']." WHERE ".
"active = 't' AND (".$available_banners.") AND bannerid != ".$bannerid." ORDER BY clientid, bannerid");
$available_banners = array();
while ($row = phpAds_dbFetchArray($res))
$available_banners[$row['bannerid']] = phpAds_buildBannerName($row['bannerid'], $row['description'], $row['alt']);
// Determine the candidates for each type
$candidates[phpAds_AppendPopup] = count($available[phpAds_ZonePopup]) + count($available_banners);
$candidates[phpAds_AppendInterstitial] = count($available[phpAds_ZoneInterstitial]) + count($available_banners);
// Determine appendtype
if (!isset($appendtype))
$appendtype = $banner['appendtype'];
if (!isset($appendtype_previous))
$appendtype_previous = '';
echo "<input type='hidden' name='appendtype_previous' value='".$appendtype."'>";
echo "<input type='hidden' name='appendsave' value='1'>";
// Appendtype choices
echo "<tr><td width='30'> </td><td width='200' valign='top'>".$GLOBALS['strAppendType']."</td><td>";
echo "<select name='appendtype' style='width: 200;' onchange='phpAds_formSelectAppendType()' tabindex='".($tabindex++)."'>";
echo "<option value='".phpAds_AppendNone."'".($appendtype == phpAds_AppendNone ? ' selected' : '').">".$GLOBALS['strNone']."</option>";
if ($candidates[phpAds_AppendPopup])
echo "<option value='".phpAds_AppendPopup."'".($appendtype == phpAds_AppendPopup ? ' selected' : '').">".$GLOBALS['strPopup']."</option>";
if ($candidates[phpAds_AppendInterstitial])
echo "<option value='".phpAds_AppendInterstitial."'".($appendtype == phpAds_AppendInterstitial ? ' selected' : '').">".$GLOBALS['strInterstitial']."</option>";
echo "<option value='".phpAds_AppendRaw."'".($appendtype == phpAds_AppendRaw ? ' selected' : '').">".$GLOBALS['strAppendHTMLCode']."</option>";
echo "</select></td></tr>";
// Line
if ($appendtype != phpAds_AppendNone)
{
echo "<tr><td height='10' colspan='3'> </td></tr>";
echo "<tr height='1'><td colspan='3' bgcolor='#888888'><img src='images/break-l.gif' height='1' width='100%'></td></tr>";
echo "<tr><td height='10' colspan='3'> </td></tr>";
}
if ($appendtype == phpAds_AppendPopup ||
$appendtype == phpAds_AppendInterstitial)
{
// Determine available zones
$available_zones = ($appendtype == phpAds_AppendPopup) ? $available[phpAds_ZonePopup] : $available[phpAds_ZoneInterstitial];
// Append zones
if ($appendtype != $appendtype_previous)
{
// Admin chose a different append type or this is the first
// time this page is shown to the admin
if ($appendtype == $banner['appendtype'])
{
// Admin chose the original append type, or this is the
// first time this page is shown to the admin.
// Load all data from the invocation code
$appendvars = phpAds_ParseAppendCode($banner['append']);
$appendwhat = $appendvars[0]['what']; // id's
$appendselection = $appendvars[0]['selection']; // keyword, banner or zone
while (list($k, $v) = each($appendvars[1]))
{
if ($k != 'n' && $k != 'what')
$GLOBALS[$k] = addslashes($v);
}
}
else
{
// Admin chose a different append type from the original
// In this case it is not possible to reuse anything, set to defaults
if (count($available_zones))
{
$appendselection = phpAds_AppendZone;
$appendwhat = '';
}
elseif (count($available_banners))
{
$appendselection = phpAds_AppendBanner;
$appendwhat = array();
}
else
{
$appendselection = phpAds_AppendKeyword;
$appendwhat = '';
}
}
}
else
{
// Admin changed one of the lower options, reuse all of
// info from the submitted form
if ($appendselection == phpAds_AppendBanner)
{
if (isset($appendwhat[$appendselection]))
$appendwhat = $appendwhat[$appendselection];
else
$appendwhat = array();
}
else
{
if (isset($appendwhat[$appendselection]))
$appendwhat = $appendwhat[$appendselection];
else
$appendwhat = '';
}
}
// Header
echo "<tr><td width='30'> </td><td width='200' valign='top'>".$strAppendWhat."</td><td>";
echo "<select name='appendselection' onChange=\"phpAds_formSelectBox(this.options[this.selectedIndex].value);\"";
echo "tabindex='".($tabindex++)."'>";
if (count($available_zones))
{
echo "<option value='".phpAds_AppendZone."'".($appendselection == phpAds_AppendZone ? ' SELECTED' : '').">";
echo $strAppendZone."</option>";
}
if (count($available_banners))
{
echo "<option value='".phpAds_AppendBanner."'".($appendselection == phpAds_AppendBanner ? ' SELECTED' : '').">";
echo $strAppendBanner."</option>";
}
echo "<option value='".phpAds_AppendKeyword."'".($appendselection == phpAds_AppendKeyword ? ' SELECTED' : '').">";
echo $strAppendKeyword."</option>";
echo "</select><br><br>";
// Show all banners
echo "<div class='box' id='box_".phpAds_AppendBanner."'".($appendselection == phpAds_AppendBanner ? '' : ' style="display: none;"').">";
while (list($id, $name) = each ($available_banners))
{
echo "<div class='boxrow'><input tabindex='".($tabindex++)."' ";
echo "type='checkbox' id='banner_".$id."' name='appendwhat[".phpAds_AppendBanner."][]' value='$id'".($appendselection == phpAds_AppendBanner && in_array ($id, $appendwhat) ? ' checked' : '').">";
echo " <img src='images/icon-banner-stored.gif' align='absmiddle'> ".$name;
echo "</div>";
}
echo "</div>";
// Show all zones
echo "<div class='box' id='box_".phpAds_AppendZone."'".($appendselection == phpAds_AppendZone ? '' : ' style="display: none;"').">";
if ($appendselection != phpAds_AppendZone || $appendwhat == '')
{
list($selected, ) = each ($available_zones);
reset($available_zones);
}
else
$selected = $appendwhat;
while (list($id, $name) = each ($available_zones))
{
echo "<div class='boxrow'><input tabindex='".($tabindex++)."' ";
echo "type='radio' id='zone_".$id."' name='appendwhat[".phpAds_AppendZone."]' value='$id'".($id == $selected ? ' checked' : '').">";
if ($appendtype == phpAds_AppendPopup)
echo " <img src='images/icon-popup.gif'>";
else
echo " <img src='images/icon-interstitial.gif'>";
echo " ".$name;
echo "</div>";
}
echo "</div>";
// Show all keywords
echo "<div id='box_".phpAds_AppendKeyword."'".($appendselection == phpAds_AppendKeyword ? '' : ' style="display: none;"').">";
echo "<textarea class='box' name='appendwhat[".phpAds_AppendKeyword."]' tabindex='".($tabindex++)."'>".($appendselection == phpAds_AppendKeyword ? $appendwhat : '')."</textarea>";
echo "</div>";
// Line
echo "<tr><td height='10' colspan='3'> </td></tr>";
echo "<tr height='1'><td colspan='3' bgcolor='#888888'><img src='images/break-l.gif' height='1' width='100%'></td></tr>";
echo "<tr><td height='10' colspan='3'> </td></tr>";
// Invocation options
$extra = array('what' => '',
'delivery' => $appendtype == phpAds_AppendPopup ? phpAds_ZonePopup : phpAds_ZoneInterstitial,
'zoneadvanced' => true
);
phpAds_placeInvocationForm($extra, true);
echo "</td></tr>";
}
elseif ($appendtype == phpAds_AppendRaw)
{
// Regular HTML append
echo "<tr><td width='30'> </td><td width='200' valign='top'>".$strZoneAppend."</td><td>";
echo "<textarea name='append' class='code' rows='15' cols='55' tabindex='".($tabindex++)."'>".htmlspecialchars($banner['append'])."</textarea>";
echo "</td></tr>";
}
// Footer
echo "<tr><td height='10' colspan='3'> </td></tr>";
echo "<tr height='1'><td colspan='3' bgcolor='#888888'><img src='images/break.gif' height='1' width='100%'></td></tr>";
echo "</table><br><br>";
echo "<input type='submit' name='submitbutton' value='".$strSaveChanges."' tabindex='".($tabindex++)."'>";
echo "</form>";
}
else
{
echo "<br><br><div class='errormessage'><img class='errormessage' src='images/info.gif' width='16' height='16' border='0' align='absmiddle'>";
echo $strAppendTextAdNotPossible;
echo "</div>";
}
/*********************************************************/
/* Form requirements */
/*********************************************************/
?>
<script language='JavaScript'>
<!--
// Set the name of the form
formname = 'appendform';
function phpAds_formSelectAppendType()
{
form = findObj(formname);
form.appendsave.value = '0';
form.submit();
}
function phpAds_formSelectAppendDelivery(type)
{
form = findObj(formname);
form.appendsave.value = '0';
form.submit();
}
function phpAds_formSubmit()
{
// Defaults
errors = '';
// Get the type of append
obj = findObj ('appendtype');
appendtype = obj.options[obj.selectedIndex].value;
if (appendtype == <?php echo phpAds_AppendPopup ?> ||
appendtype == <?php echo phpAds_AppendInterstitial ?>)
{
// Get the way banners are appended
obj = findObj ('appendselection');
appendselection = obj.options[obj.selectedIndex].value;
form = findObj(formname);
// Check if a zone is selected
if (appendselection == <?php echo phpAds_AppendZone ?>)
{
checked = false;
for (i=0; i<form.elements.length; i++)
{
if (form.elements.item(i).name == 'appendwhat[<?php echo phpAds_AppendZone ?>]' &&
form.elements.item(i).checked == true)
{
checked = true;
}
}
if (!checked)
errors = '<?php echo $strAppendErrorZone ?>';
}
// Check if one or more banners are selected
if (appendselection == <?php echo phpAds_AppendBanner ?>)
{
checked = false;
for (i=0; i<form.elements.length; i++)
{
if (form.elements.item(i).name == 'appendwhat[<?php echo phpAds_AppendBanner ?>][]' &&
form.elements.item(i).checked == true)
{
checked = true;
}
}
if (!checked)
errors = '<?php echo $strAppendErrorBanner ?>';
}
// Check if there are any keywords specified
if (appendselection == <?php echo phpAds_AppendKeyword ?>)
{
obj = findObj('appendwhat[<?php echo phpAds_AppendKeyword ?>]')
if (obj.value == '')
{
errors = '<?php echo $strAppendErrorKeyword ?>';
}
}
}
if (errors != '')
{
alert (errors + "\n");
return false;
}
return true;
}
function phpAds_formSelectBox(s)
{
// Hide all the boxes
hideLayer(findObj('box_<?php echo phpAds_AppendZone ?>'));
hideLayer(findObj('box_<?php echo phpAds_AppendBanner ?>'));
hideLayer(findObj('box_<?php echo phpAds_AppendKeyword ?>'));
// Show the selected box
showLayer(findObj('box_' + s));
if (s == <?php echo phpAds_AppendKeyword ?>)
{
obj = findObj('appendwhat[<?php echo phpAds_AppendKeyword ?>]')
obj.focus();
}
}
//-->
</script>
<?php
/*********************************************************/
/* HTML framework */
/*********************************************************/
phpAds_PageFooter();
?>
Other Ad Management Scripts:
