public static function selectByAlias($strAlias) { global $_CONF; parent::$__object = "Alias"; parent::$__table = "pcms_alias"; $objReturn = NULL; if (!empty($strAlias)) { $strSql = sprintf("SELECT * FROM " . parent::$__table . " WHERE accountId = '%s' AND alias = %s ORDER BY sort", $_CONF['app']['account']->getId(), parent::quote($strAlias)); } $objReturn = parent::select($strSql); return $objReturn; }