Campaign Delete.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-storage.inc.php");
require ("lib-zones.inc.php");
require ("lib-statistics.inc.php");
require ("../libraries/lib-priority.inc.php");
// Register input variables
phpAds_registerGlobal ('returnurl');
// Security check
phpAds_checkAccess(phpAds_Admin);
/*********************************************************/
/* Main code */
/*********************************************************/
function phpAds_DeleteCampaign($campaignid)
{
global $phpAds_config;
// Loop through each banner
$res_banners = phpAds_dbQuery("
SELECT
bannerid,
storagetype,
filename
FROM
".$phpAds_config['tbl_banners']."
WHERE
clientid = '$campaignid'
") or phpAds_sqlDie();
while ($row = phpAds_dbFetchArray($res_banners))
{
// Cleanup stored images for each banner
if (($row['storagetype'] == 'web' || $row['storagetype'] == 'sql') && $row['filename'] != '')
phpAds_ImageDelete ($row['storagetype'], $row['filename']);
// Delete stats for each banner
phpAds_deleteStats($row['bannerid']);
}
// Delete Campaign
$res = phpAds_dbQuery("
DELETE FROM
".$phpAds_config['tbl_clients']."
WHERE
clientid = '$campaignid'
") or phpAds_sqlDie();
}
if (isset($campaignid) && $campaignid != '')
{
// Campaign is specified, delete only this campaign
phpAds_DeleteCampaign($campaignid);
}
elseif (isset($clientid) && $clientid != '')
{
// No campaign specified, delete all campaigns for this client
$res_campaigns = phpAds_dbQuery("
SELECT
clientid
FROM
".$phpAds_config['tbl_clients']."
WHERE
parent = ".$clientid."
");
while ($row = phpAds_dbFetchArray($res_campaigns))
{
phpAds_DeleteCampaign($row['clientid']);
}
}
// Rebuild priorities
phpAds_PriorityCalculate ();
// Rebuild cache
if (!defined('LIBVIEWCACHE_INCLUDED'))
include (phpAds_path.'/libraries/deliverycache/cache-'.$phpAds_config['delivery_caching'].'.inc.php');
phpAds_cacheDelete();
if (!isset($returnurl) && $returnurl == '')
$returnurl = 'client-campaigns.php';
// Prevent HTTP response splitting
if (strpos($returnurl, "\r\n") === false)
{
$url = stripslashes($returnurl);
header ("Location: ".$returnurl."?clientid=".$clientid);
}
?>
Other Ad Management Scripts:
