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_deleteStats($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(); }
// Delete stats for this banner phpAds_deleteStats($bannerid); // Return to campaign statistics Header("Location: stats-campaign-banners.php?clientid=" . $clientid . "&campaignid=" . $campaignid); } elseif (isset($campaignid) && $campaignid != '') { // Get all banners for this client $idresult = phpAds_dbQuery(" SELECT\n\t\t\t\t\t\t\t\tbannerid\n\t\t\t\t\t\t\t FROM\n\t\t\t\t\t\t\t \t" . $phpAds_config['tbl_banners'] . "\n\t\t\t\t\t\t\t WHERE\n\t\t\t\t\t\t\t\tclientid = '{$campaignid}'\n\t\t \t\t\t\t "); // Loop to all banners for this client while ($row = phpAds_dbFetchArray($idresult)) { // Delete stats for the banner phpAds_deleteStats($row['bannerid']); } // Return to campaign statistics Header("Location: stats-client-campaigns.php?clientid=" . $clientid); } elseif (isset($clientid) && $clientid != '') { // Get all banners for this client $idresult = phpAds_dbQuery("\n\t\tSELECT\n\t\t\tb.bannerid\n\t\tFROM\n\t\t\t" . $phpAds_config['tbl_banners'] . " AS b,\n\t\t\t" . $phpAds_config['tbl_clients'] . " AS c\n\t\tWHERE\n\t\t\tc.parent = {$clientid} AND\n\t\t\tc.clientid = b.clientid\n\t"); // Loop to all banners for this client while ($row = phpAds_dbFetchArray($idresult)) { // Delete stats for the banner phpAds_deleteStats($row['bannerid']); } // Return to campaign statistics Header("Location: stats-global-client.php"); } elseif (isset($all) && $all == 'tr' . 'ue') { phpAds_dbQuery("DELETE FROM " . $phpAds_config['tbl_adviews']) or phpAds_sqlDie(); phpAds_dbQuery("DELETE FROM " . $phpAds_config['tbl_adclicks']) or phpAds_sqlDie(); phpAds_dbQuery("DELETE FROM " . $phpAds_config['tbl_adstats']) or phpAds_sqlDie(); // Return to campaign statistics Header("Location: stats-global-client.php"); }