/**
* Get domain
*
* @param integer $rootPid Root PID
* @return null|string
*/
public static function getDomain($rootPid)
{
// Fetch domain name
$query = 'SELECT domainName
FROM sys_domain
WHERE hidden = 0 AND pid = ' . (int) $rootPid . '
ORDER BY forced DESC, sorting';
$ret = DatabaseUtility::getOne($query);
return $ret;
}
/**
* Get root setting row
*
* @param integer $rootPid Root Page Id
* @return array
*/
public static function getRootSetting($rootPid = NULL)
{
static $ret = NULL;
if ($ret !== NULL) {
return $ret;
}
if ($rootPid === NULL) {
$rootPid = self::getRootPid();
}
$query = 'SELECT *
FROM tx_metaseo_setting_root
WHERE pid = ' . (int) $rootPid . '
AND deleted = 0
LIMIT 1';
$ret = DatabaseUtility::getRow($query);
return $ret;
}
