<?php
/***************************************************************************
- * Copyright (C) 2003-2007 Polytechnique.org *
+ * Copyright (C) 2003-2008 Polytechnique.org *
* http://opensource.polytechnique.org/ *
* *
* This program is free software; you can redistribute it and/or modify *
global $globals;
list($username, $path) = preg_split('/\//', $_SERVER["REQUEST_URI"], 2, PREG_SPLIT_NO_EMPTY);
$res = XDB::query(
- "SELECT redirecturl
- FROM auth_user_quick AS a
- INNER JOIN aliases AS al ON (al.id = a.user_id AND (al.type='a_vie' OR al.type='alias'))
- LEFT JOIN virtuals_redirect AS vr ON (vr.redirect LIKE CONCAT(al.alias, '@%')
- INNER JOIN virtuals AS v ON (v.vid = vr.vid)
- WHERE al.alias = {?} OR v.alias = CONCAT({?}, '@', {?})
- GROUP BY redirecturl", $username, $username, $globals->mail->alias_dom);
+ "SELECT redirecturl
+ FROM auth_user_quick AS a
+ INNER JOIN aliases AS al ON (al.id = a.user_id AND (al.type='a_vie' OR al.type='alias'))
+ WHERE al.alias = {?}
+ GROUP BY redirecturl", $username);
if ($url = $res->fetchOneCell()) {
$url = preg_replace('@/+$@', '', $url);