diff options
author | mattab <matthieu.aubry@gmail.com> | 2013-07-31 01:13:56 +0400 |
---|---|---|
committer | mattab <matthieu.aubry@gmail.com> | 2013-07-31 01:13:56 +0400 |
commit | 765be0dc8f92a6d4bb3e678a0c23f2d4b95e0e18 (patch) | |
tree | 3a0ae0e7334250446b687667e4d365af6975e0f4 /plugins/SitesManager/API.php | |
parent | 5104d94f3b2250f766b9c520e2da8da9b4cab2e9 (diff) |
Refs #3741 Resuming PHP Namespaces conversion of Piwik core, mostly finished core/ conversion
Diffstat (limited to 'plugins/SitesManager/API.php')
-rw-r--r-- | plugins/SitesManager/API.php | 31 |
1 files changed, 16 insertions, 15 deletions
diff --git a/plugins/SitesManager/API.php b/plugins/SitesManager/API.php index 47b3e44f1d..3a891fe414 100644 --- a/plugins/SitesManager/API.php +++ b/plugins/SitesManager/API.php @@ -13,6 +13,7 @@ use Piwik\Common; use Piwik\Access; use Piwik\Date; use Piwik\IP; +use Piwik\Db; use Piwik\Url; use Piwik\TaskScheduler; use Piwik\Site; @@ -90,7 +91,7 @@ class Piwik_SitesManager_API Piwik::checkUserIsSuperUser(); $group = trim($group); - $sites = Zend_Registry::get('db')->fetchAll("SELECT * + $sites = \Zend_Registry::get('db')->fetchAll("SELECT * FROM " . Common::prefixTable("site") . " WHERE `group` = ?", $group); return $sites; @@ -105,7 +106,7 @@ class Piwik_SitesManager_API public function getSitesGroups() { Piwik::checkUserIsSuperUser(); - $groups = Zend_Registry::get('db')->fetchAll("SELECT DISTINCT `group` FROM " . Common::prefixTable("site")); + $groups = \Zend_Registry::get('db')->fetchAll("SELECT DISTINCT `group` FROM " . Common::prefixTable("site")); $cleanedGroups = array(); foreach ($groups as $group) { $cleanedGroups[] = $group['group']; @@ -124,7 +125,7 @@ class Piwik_SitesManager_API public function getSiteFromId($idSite) { Piwik::checkUserHasViewAccess($idSite); - $site = Zend_Registry::get('db')->fetchRow("SELECT * + $site = \Zend_Registry::get('db')->fetchRow("SELECT * FROM " . Common::prefixTable("site") . " WHERE idsite = ?", $idSite); return $site; @@ -139,7 +140,7 @@ class Piwik_SitesManager_API */ private function getAliasSiteUrlsFromId($idSite) { - $db = Zend_Registry::get('db'); + $db = \Zend_Registry::get('db'); $result = $db->fetchAll("SELECT url FROM " . Common::prefixTable("site_url") . " WHERE idsite = ?", $idSite); @@ -189,7 +190,7 @@ class Piwik_SitesManager_API public function getAllSites() { Piwik::checkUserIsSuperUser(); - $sites = Zend_Registry::get('db')->fetchAll("SELECT * FROM " . Common::prefixTable("site")); + $sites = \Zend_Registry::get('db')->fetchAll("SELECT * FROM " . Common::prefixTable("site")); $return = array(); foreach ($sites as $site) { $return[$site['idsite']] = $site; @@ -355,7 +356,7 @@ class Piwik_SitesManager_API $limit = "LIMIT " . (int)$limit; } - $db = Zend_Registry::get('db'); + $db = \Zend_Registry::get('db'); $sites = $db->fetchAll("SELECT * FROM " . Common::prefixTable("site") . " WHERE idsite IN (" . implode(", ", $idSites) . ") @@ -384,7 +385,7 @@ class Piwik_SitesManager_API $url = $this->removeTrailingSlash($url); list($url, $urlBis) = $this->getNormalizedUrls($url); if (Piwik::isUserIsSuperUser()) { - $ids = Zend_Registry::get('db')->fetchAll( + $ids = \Zend_Registry::get('db')->fetchAll( 'SELECT idsite FROM ' . Common::prefixTable('site') . ' WHERE (main_url = ? OR main_url = ?) ' . @@ -394,7 +395,7 @@ class Piwik_SitesManager_API WHERE (url = ? OR url = ?) ', array($url, $urlBis, $url, $urlBis)); } else { $login = Piwik::getCurrentUserLogin(); - $ids = Zend_Registry::get('db')->fetchAll( + $ids = \Zend_Registry::get('db')->fetchAll( 'SELECT idsite FROM ' . Common::prefixTable('site') . ' WHERE (main_url = ? OR main_url = ?)' . @@ -422,7 +423,7 @@ class Piwik_SitesManager_API Piwik::checkUserIsSuperUser(); $timezones = Piwik::getArrayFromApiParameter($timezones); $timezones = array_unique($timezones); - $ids = Zend_Registry::get('db')->fetchAll( + $ids = \Zend_Registry::get('db')->fetchAll( 'SELECT idsite FROM ' . Common::prefixTable('site') . ' WHERE timezone IN (' . Common::getSqlStringFieldsArray($timezones) . ') @@ -499,7 +500,7 @@ class Piwik_SitesManager_API } $this->checkValidCurrency($currency); - $db = Zend_Registry::get('db'); + $db = \Zend_Registry::get('db'); $url = $urls[0]; $urls = array_slice($urls, 1); @@ -573,7 +574,7 @@ class Piwik_SitesManager_API throw new Exception(Piwik_TranslateException("SitesManager_ExceptionDeleteSite")); } - $db = Zend_Registry::get('db'); + $db = \Zend_Registry::get('db'); $db->query("DELETE FROM " . Common::prefixTable("site") . " WHERE idsite = ?", $idSite); @@ -1038,7 +1039,7 @@ class Piwik_SitesManager_API $bind['sitesearch_category_parameters'] = $searchCategoryParameters; $bind['name'] = $siteName; - $db = Zend_Registry::get('db'); + $db = \Zend_Registry::get('db'); $db->update(Common::prefixTable("site"), $bind, "idsite = $idSite" @@ -1182,7 +1183,7 @@ class Piwik_SitesManager_API private function insertSiteUrls($idSite, $urls) { if (count($urls) != 0) { - $db = Zend_Registry::get('db'); + $db = \Zend_Registry::get('db'); foreach ($urls as $url) { $db->insert(Common::prefixTable("site_url"), array( 'idsite' => $idSite, @@ -1198,7 +1199,7 @@ class Piwik_SitesManager_API */ private function deleteSiteAliasUrls($idsite) { - $db = Zend_Registry::get('db'); + $db = \Zend_Registry::get('db'); $db->query("DELETE FROM " . Common::prefixTable("site_url") . " WHERE idsite = ?", $idsite); } @@ -1335,7 +1336,7 @@ class Piwik_SitesManager_API } $ids_str .= $id_val; - $db = Zend_Registry::get('db'); + $db = \Zend_Registry::get('db'); $bind = array('%' . $pattern . '%', 'http%' . $pattern . '%'); // Also match the idsite |