Fix the edition of event subscription for non member

[platal.git] / htdocs / webredirect.php

diff --git a/htdocs/webredirect.php b/htdocs/webredirect.php
index dfecc26..d5ef547 100644 (file)
--- a/htdocs/webredirect.php
+++ b/htdocs/webredirect.php
@@ -24,13 +24,11 @@ require_once dirname(__FILE__).'/../include/xorg.inc.php';
 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);