- $res = XDB::query(
- "SELECT a.alias, b.alias
- FROM x4dat.aliases AS a
- LEFT JOIN x4dat.aliases AS b ON (a.id=b.id AND b.type = 'a_vie')
- WHERE a.alias={?} AND a.type!='homonyme'", $member);
- list($alias, $blias) = $res->fetchOneRow();
- $alias = empty($blias) ? $alias : $blias;
- XDB::query(
- "INSERT INTO x4dat.virtual_redirect (vid,redirect)
- SELECT vid, {?}
- FROM x4dat.virtual
- WHERE alias={?}", $alias . "@" . $globals->mail->domain, $new);
+ $user = User::get($member);
+ if ($user != null) {
+ XDB::query(
+ "INSERT INTO x4dat.virtual_redirect (vid, redirect)
+ SELECT vid, {?}
+ FROM x4dat.virtual
+ WHERE alias = {?}", $user->forlifeEmail(), $new);
+ }