Oops, this was not for that skin

[platal.git] / htdocs / webredirect.php

diff --git a/htdocs/webredirect.php b/htdocs/webredirect.php
index 68f7541..fd83b8d 100644 (file)
--- a/htdocs/webredirect.php
+++ b/htdocs/webredirect.php
@@ -21,12 +21,16 @@
 
 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'))
-          WHERE  al.alias = {?}", $username);
+      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);
 
 if ($url = $res->fetchOneCell()) {
     $url = preg_replace('@/+$@', '', $url);
@@ -51,4 +55,5 @@ header("HTTP/1.0 404 Not Found");
     <hr>
     <address>Apache Server at www.carva.org Port 80</address>
   </body>
-</html>
+// vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8:
+?>