/** * Delete a website from the database, given its Id. * * Requires Super User access. * * @param int $idSite */ public static function deleteSite($idSite) { Piwik::checkUserIsSuperUser(); $idSites = Piwik_SitesManager_API::getAllSitesId(); if (!in_array($idSite, $idSites)) { throw new Exception("website id = {$idSite} not found"); } $nbSites = count($idSites); if ($nbSites == 1) { throw new Exception(Piwik_TranslateException("SitesManager_ExceptionDeleteSite")); } $db = Zend_Registry::get('db'); $db->query("DELETE FROM " . Piwik::prefixTable("site") . " \n\t\t\t\t\tWHERE idsite = ?", $idSite); $db->query("DELETE FROM " . Piwik::prefixTable("site_url") . " \n\t\t\t\t\tWHERE idsite = ?", $idSite); $db->query("DELETE FROM " . Piwik::prefixTable("access") . " \n\t\t\t\t\tWHERE idsite = ?", $idSite); Piwik_Common::deleteCacheWebsiteAttributes($idSite); }