/**
* Returns the list of websites ID associated with a URL.
*
* @param string $url
* @return array list of websites ID
*/
public function getSitesIdFromSiteUrl( $url )
{
$url = $this->removeTrailingSlash($url);
list($url, $urlBis) = $this->getNormalizedUrls($url);
if(Piwik::isUserIsSuperUser())
{
$ids = Zend_Registry::get('db')->fetchAll(
'SELECT idsite
FROM ' . Piwik_Common::prefixTable('site') . '
WHERE (main_url = ? OR main_url = ?) ' .
'UNION
SELECT idsite
FROM ' . Piwik_Common::prefixTable('site_url') . '
WHERE (url = ? OR url = ?) ', array($url, $urlBis, $url, $urlBis));
}
else
{
$login = Piwik::getCurrentUserLogin();
$ids = Zend_Registry::get('db')->fetchAll(
'SELECT idsite
FROM ' . Piwik_Common::prefixTable('site') . '
WHERE (main_url = ? OR main_url = ?)' .
'AND idsite IN (' . Piwik_Access::getSqlAccessSite('idsite') . ') ' .
'UNION
SELECT idsite
FROM ' . Piwik_Common::prefixTable('site_url') . '
WHERE (url = ? OR url = ?)' .
'AND idsite IN (' . Piwik_Access::getSqlAccessSite('idsite') . ')',
array($url, $urlBis, $login, $url, $urlBis, $login));
}
return $ids;
}
