function smarty_insert_getUsername()
{
- global $globals;
-
$id = Cookie::i('uid', -1);
$id = S::v('uid', $id);
return '';
}
- if (Cookie::v('domain', 'login') != 'alias') {
+ $domain = Cookie::v('domain', 'login');
+ if ($domain == 'hruid') {
+ return XDB::fetchOneCell('SELECT hruid
+ FROM accounts
+ WHERE uid = {?}',
+ $id);
+ } elseif ($domain == 'alias') {
return XDB::fetchOneCell('SELECT email
- FROM email_source_account AS e
- INNER JOIN email_virtual_domains AS d ON (e.domain = d.id)
- WHERE e.uid = {?} AND d.name = {?} AND FIND_IN_SET(\'bestalias\', e.flags)',
- $id, $globals->mail->domain);
+ FROM email_source_account
+ WHERE uid = {?} AND type = \'alias_aux\'',
+ $id);
} else {
return XDB::fetchOneCell('SELECT email
- FROM email_source_account AS e
- INNER JOIN email_virtual_domains AS d ON (e.domain = d.id)
- WHERE e.uid = {?} AND d.name = {?}',
- $id, $globals->mail->alias_dom);
+ FROM email_source_account
+ WHERE uid = {?} AND type != \'alias_aux\'
+ ORDER BY NOT FIND_IN_SET(\'bestalias\', flags), CHAR_LENGTH(email)',
+ $id);
}
return '';