function phpAds_DeleteBanner($bannerid)
{
global $phpAds_config;
// Cleanup webserver stored image
$res = phpAds_dbQuery("\n\t\tSELECT\n\t\t\tstoragetype, filename\n\t\tFROM\n\t\t\t" . $phpAds_config['tbl_banners'] . "\n\t\tWHERE\n\t\t\tbannerid = '{$bannerid}'\n\t") or phpAds_sqlDie();
if ($row = phpAds_dbFetchArray($res)) {
if (($row['storagetype'] == 'web' || $row['storagetype'] == 'sql') && $row['filename'] != '') {
phpAds_ImageDelete($row['storagetype'], $row['filename']);
}
}
// Delete banner
$res = phpAds_dbQuery("\n\t\tDELETE FROM\n\t\t\t" . $phpAds_config['tbl_banners'] . "\n\t\tWHERE\n\t\t\tbannerid = '{$bannerid}'\n\t\t") or phpAds_sqlDie();
// Delete banner ACLs
$res = phpAds_dbQuery("\n\t\tDELETE FROM\n\t\t\t" . $phpAds_config['tbl_acls'] . "\n\t\tWHERE\n\t\t\tbannerid = '{$bannerid}'\n\t\t") or phpAds_sqlDie();
// Delete statistics for this banner
phpAds_deleteStatsByBannerID($bannerid);
}
function phpAds_DeleteCampaign($campaignid)
{
global $phpAds_config;
// Delete Campaign
$res = phpAds_dbQuery("\n\t\tDELETE FROM\n\t\t\t" . $phpAds_config['tbl_clients'] . "\n\t\tWHERE\n\t\t\tclientid = '{$campaignid}'\n\t") or phpAds_sqlDie();
// Loop through each banner
$res_banners = phpAds_dbQuery("\n\t\tSELECT\n\t\t\tbannerid,\n\t\t\tstoragetype,\n\t\t\tfilename\n\t\tFROM\n\t\t\t" . $phpAds_config['tbl_banners'] . "\n\t\tWHERE\n\t\t\tclientid = '{$campaignid}'\n\t") 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("\n\t\t\tDELETE FROM\n\t\t\t\t" . $phpAds_config['tbl_acls'] . "\n\t\t\tWHERE\n\t\t\t\tbannerid = " . $row['bannerid'] . "\n\t\t") or phpAds_sqlDie();
// Delete stats for each banner
phpAds_deleteStats($row['bannerid']);
}
// Delete Banners
phpAds_dbQuery("\n\t\tDELETE FROM\n\t\t\t" . $phpAds_config['tbl_banners'] . "\n\t\tWHERE\n\t\t\tclientid = '{$campaignid}'\n\t") or phpAds_sqlDie();
}
// Require the initialisation file
require_once '../../init.php';
// Required files
require_once MAX_PATH . '/lib/OA/Dal.php';
require_once MAX_PATH . '/www/admin/config.php';
require_once MAX_PATH . '/www/admin/lib-banner.inc.php';
require_once MAX_PATH . '/www/admin/lib-storage.inc.php';
// Security check
OA_Permission::enforceAccount(OA_ACCOUNT_ADMIN);
/*-------------------------------------------------------*/
/* Main code */
/*-------------------------------------------------------*/
$doBanners = OA_Dal::factoryDO('banners');
$doBanners->storagetype = 'sql';
$doBanners->find();
while ($doBanners->fetch()) {
// Get the filename
$filename = $doBanners->filename;
// Copy the file
$buffer = phpAds_ImageRetrieve('sql', $filename);
$doBanners->filename = phpAds_ImageStore('web', $filename, $buffer);
// TODO: Would be nice if we gave some indication to the user of success or failure!
if ($doBanners->filename != false) {
phpAds_ImageDelete('sql', $filename);
$doBannersClone = clone $doBanners;
$doBannersClone->imageurl = '';
$doBannersClone->storagetype = 'web';
$doBannersClone->update();
}
}
Header("Location: maintenance-storage.php");
/**
* A method to delete the banner file.
*
* @param string $storageType The storage type of the banner to delete
* @param string $fileName The name of the banner file to be deleted
*/
function deleteBannerFile($storageType, $fileName)
{
if ($storageType == 'web') {
$doBanner = OA_Dal::factoryDO('banners');
$doBanner->filename = $fileName;
$doBanner->find();
// If there is only a banner using the same file delete the file
if ($doBanner->getRowCount() == 1) {
phpAds_ImageDelete($storageType, $fileName);
}
} else {
phpAds_ImageDelete($storageType, $fileName);
}
}
$final['pluginversion'] >= 3 &&
phpAds_SWFInfo($uploaded['buffer']))
{
$edit_swf = true;
}
}
else
$final['pluginversion'] = 0;
*/
// Store the file
$final['alt_filename'] = phpAds_ImageStore($storagetype, $final['alt_filename'], $uploadedalt['buffer']);
//$final['alt_imageurl'] = $phpAds_config['type_web_url'].'/'.$final['filename'];
$final['alt_imageurl'] = '{image_url_prefix}/' . $final['alt_filename'];
// Cleanup existing image, if it exists
if (isset($current['alt_filename']) && $current['alt_filename'] != '' && $current['alt_filename'] != $final['alt_filename']) {
phpAds_ImageDelete($current['storagetype'], $current['alt_filename']);
}
}
if (!isset($bannerid) || $bannerid == '0' || $bannerid == '') {
// New banner set html template
$final['htmltemplate'] = phpAds_getBannerTemplate($final['contenttype']);
} elseif ($final['contenttype'] != $current['contenttype']) {
// Check if the contenttype has changed, if true change html template
$final['htmltemplate'] = phpAds_getBannerTemplate($final['contenttype']);
} else {
// Use existing html template
$final['htmltemplate'] = stripslashes($current['htmltemplate']);
}
// Set remaining properties
$final['alt'] = phpAds_htmlQuotes($alt);
$final['status'] = $status;
/* Main code */
/*********************************************************/
if (isset($clientid) && $clientid != '') {
// Delete Client
$res = phpAds_dbQuery("\n\t\tDELETE FROM\n\t\t\t" . $phpAds_config['tbl_clients'] . "\n\t\tWHERE\n\t\t\tclientid = '{$clientid}'\n\t\t") or phpAds_sqlDie();
// Loop thourgh each campaign
$res_campaign = phpAds_dbQuery("\n\t\tSELECT\n\t\t\tclientid\n\t\tFROM\n\t\t\t" . $phpAds_config['tbl_clients'] . "\n\t\tWHERE\n\t\t\tparent = {$clientid}\n\t\t") or phpAds_sqlDie();
while ($row_campaign = phpAds_dbFetchArray($res_campaign)) {
// Delete Campaign
$res = phpAds_dbQuery("\n\t\t\tDELETE FROM\n\t\t\t\t" . $phpAds_config['tbl_clients'] . "\n\t\t\tWHERE\n\t\t\t\tclientid = " . $row_campaign['clientid'] . "\n\t\t\t") or phpAds_sqlDie();
// Loop through each banner
$res_banners = phpAds_dbQuery("\n\t\t\tSELECT\n\t\t\t\tbannerid,\n\t\t\t\tstoragetype,\n\t\t\t\tfilename\n\t\t\tFROM\n\t\t\t\t" . $phpAds_config['tbl_banners'] . "\n\t\t\tWHERE\n\t\t\t\tclientid = " . $row_campaign['clientid'] . "\n\t\t\t") 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("\n\t\t\t\tDELETE FROM\n\t\t\t\t\t" . $phpAds_config['tbl_acls'] . "\n\t\t\t\tWHERE\n\t\t\t\t\tbannerid = " . $row['bannerid'] . "\n\t\t\t\t") or phpAds_sqlDie();
// Delete stats for each banner
phpAds_deleteStats($row['bannerid']);
}
// Delete Banners
phpAds_dbQuery("\n\t\t\tDELETE FROM\n\t\t\t\t" . $phpAds_config['tbl_banners'] . "\n\t\t\tWHERE\n\t\t\t\tclientid = " . $row_campaign['clientid'] . "\n\t\t\t") or phpAds_sqlDie();
}
}
// Rebuild priorities
phpAds_PriorityCalculate();
// Rebuild cache
if (!defined('LIBVIEWCACHE_INCLUDED')) {
include phpAds_path . '/libraries/deliverycache/cache-' . $phpAds_config['delivery_caching'] . '.inc.php';
if (isset($clientid) && $clientid != '') {
// Loop through each campaign
$res_campaign = phpAds_dbQuery("SELECT campaignid" . " FROM " . $phpAds_config['tbl_campaigns'] . " WHERE clientid=" . $clientid) or phpAds_sqlDie();
while ($row_campaign = phpAds_dbFetchArray($res_campaign)) {
$campaignid = $row_campaign['campaignid'];
// Delete Campaign/Tracker links
$res = phpAds_dbQuery("DELETE FROM " . $phpAds_config['tbl_campaigns_trackers'] . " WHERE campaignid=" . $campaignid) or phpAds_sqlDie();
// Delete Conversions Logged to this Campaign
$res = phpAds_dbQuery("DELETE FROM " . $phpAds_config['tbl_conversionlog'] . " WHERE campaignid=" . $campaignid) or phpAds_sqlDie();
// Loop through each banner
$res_banners = phpAds_dbQuery("SELECT" . " bannerid" . ",storagetype" . ",filename" . " FROM " . $phpAds_config['tbl_banners'] . " WHERE campaignid=" . $row_campaign['campaignid'] . "\n\t\t\t") or phpAds_sqlDie();
while ($row_banners = phpAds_dbFetchArray($res_banners)) {
$bannerid = $row_banners['bannerid'];
// Cleanup stored images for each banner
if (($row_banners['storagetype'] == 'web' || $row_banners['storagetype'] == 'sql') && $row_banners['filename'] != '') {
phpAds_ImageDelete($row_banners['storagetype'], $row_banners['filename']);
}
// Delete Banner ACLs
phpAds_dbQuery("DELETE FROM " . $phpAds_config['tbl_acls'] . " WHERE bannerid=" . $bannerid) or phpAds_sqlDie();
// Delete stats for each banner
phpAds_deleteStatsByBannerID($bannerid);
}
// Delete Banners
phpAds_dbQuery("DELETE FROM " . $phpAds_config['tbl_banners'] . " WHERE campaignid=" . $campaignid) or phpAds_sqlDie();
}
// Loop through each tracker
$res_tracker = phpAds_dbQuery("SELECT trackerid" . " FROM " . $phpAds_config['tbl_trackers'] . " WHERE clientid=" . $clientid) or phpAds_sqlDie();
while ($row_tracker = phpAds_dbFetchArray($res_tracker)) {
$trackerid = $row_tracker['trackerid'];
// Delete Campaign/Tracker links
$res = phpAds_dbQuery("DELETE FROM " . $phpAds_config['tbl_campaigns_trackers'] . " WHERE trackerid=" . $trackerid) or phpAds_sqlDie();
