From c55cca6e75640408308e98f66b59dd015d7e1da1 Mon Sep 17 00:00:00 2001
From: x2003bruneau <x2003bruneau@839d8a87-29fc-0310-9880-83ba4fa771e5>
Date: Fri, 27 Apr 2007 14:30:31 +0000
Subject: [PATCH] Fix xnet aliases deletion

git-svn-id: svn+ssh://murphy/home/svn/platal/trunk@1737 839d8a87-29fc-0310-9880-83ba4fa771e5
---
 modules/xnetlists.php | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/modules/xnetlists.php b/modules/xnetlists.php
index a892132..db9710b 100644
--- a/modules/xnetlists.php
+++ b/modules/xnetlists.php
@@ -91,9 +91,9 @@ class XnetListsModule extends ListsModule
             // prevent group admin from erasing aliases from other groups
             $alias = substr($alias, 0, strpos($alias, '@')).'@'.$globals->asso('mail_domain');
             XDB::query(
-                    'DELETE FROM  x4dat.virtual_redirect, x4dat.virtual
+                    'DELETE FROM  r, v
                            USING  x4dat.virtual AS v
-                       LEFT JOIN  x4dat.virtual_redirect USING(vid)
+                       LEFT JOIN  x4dat.virtual_redirect AS r USING(vid)
                            WHERE  v.alias={?}', $alias);
             $page->trig(Post::v('del_alias')." supprimé !");
         }
-- 
2.1.4