function phpAds_DeleteTracker($trackerid) { global $phpAds_config; // Delete Campaign $res = phpAds_dbQuery("DELETE FROM " . $phpAds_config['tbl_trackers'] . " WHERE trackerid=" . $trackerid) or phpAds_sqlDie(); // Delete Campaign/Tracker links $res = phpAds_dbQuery("DELETE FROM " . $phpAds_config['tbl_campaigns_trackers'] . " WHERE trackerid=" . $trackerid) or phpAds_sqlDie(); // Delete Conversions Logged to this Tracker $res = phpAds_dbQuery("DELETE FROM " . $phpAds_config['tbl_conversionlog'] . " WHERE trackerid=" . $trackerid) or phpAds_sqlDie(); // Delete stats for each banner phpAds_deleteStatsByTrackerID($trackerid); }
// 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(); // Delete stats for each tracker phpAds_deleteStatsByTrackerID($trackerid); } // Delete Clients $res = phpAds_dbQuery("DELETE FROM " . $phpAds_config['tbl_clients'] . " WHERE clientid=" . $clientid) or phpAds_sqlDie(); // Delete Campaigns $res = phpAds_dbQuery("DELETE FROM " . $phpAds_config['tbl_campaigns'] . " WHERE clientid=" . $clientid) or phpAds_sqlDie(); // Delete Trackers $res = phpAds_dbQuery("DELETE FROM " . $phpAds_config['tbl_trackers'] . " WHERE clientid=" . $clientid) 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'; } phpAds_cacheDelete();