X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=bin%2Flists.rpc.py;h=9ed42d81df165ea6368ee10ca40c4fe13ff31475;hb=23ba40c466e05d369cd9e2a96107f38e309b767a;hp=5a559cdd59134a35c612a89989c869f105a97d32;hpb=00ca0ad5370df5be4a0272364fb16a4385ffabfe;p=platal.git diff --git a/bin/lists.rpc.py b/bin/lists.rpc.py index 5a559cd..9ed42d8 100755 --- a/bin/lists.rpc.py +++ b/bin/lists.rpc.py @@ -196,7 +196,7 @@ def to_forlife(email): if ( fqdn == PLATAL_DOMAIN ) or ( fqdn == PLATAL_DOMAIN2 ): res = mysql_fetchone("""SELECT CONCAT(f.alias, '@%s'), a.full_name FROM accounts AS a - INNER JOIN aliases AS f ON (f.uid = a.uid AND f.type = 'a_vie') + INNER JOIN aliases AS f ON (f.uid = a.uid AND f.type = 'a_vie') INNER JOIN aliases AS aa ON (aa.uid = a.uid AND aa.alias = '%s' AND a.type != 'homonyme') WHERE a.state = 'active'