Viewing file:  campaign-delete.php (3.22 KB) -rwxr-xr-x
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php // $Revision: 1.12 $
/************************************************************************/
/* phpAdsNew 2 */
/* =========== */
/* */
/* Copyright (c) 2001 by the phpAdsNew developers */
/* http://sourceforge.net/projects/phpadsnew */
/* */
/* 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 ("../lib-priority.inc.php");
// Security check
phpAds_checkAccess(phpAds_Admin);
/*********************************************************/
/* Main code */
/*********************************************************/
function phpAds_DeleteCampaign($campaignid)
{
global $phpAds_config;
// Delete Campaign
$res = phpAds_dbQuery("
DELETE FROM
".$phpAds_config['tbl_clients']."
WHERE
clientid = $campaignid
") or phpAds_sqlDie();
// 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 Banner ACLs
phpAds_dbQuery("
DELETE FROM
".$phpAds_config['tbl_acls']."
WHERE
bannerid = ".$row['bannerid']."
") or phpAds_sqlDie();
// Delete stats for each banner
phpAds_deleteStats($row['bannerid']);
}
// Delete Banners
phpAds_dbQuery("
DELETE FROM
".$phpAds_config['tbl_banners']."
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 zone cache
if ($phpAds_config['zone_cache'])
phpAds_RebuildZoneCache ();
if (!isset($returnurl) && $returnurl == '')
$returnurl = 'client-campaigns.php';
header ("Location: ".$returnurl."?clientid=".$clientid);
?>
|