From e1594f65e1e9349e4e63bc455e6810ae4c474ec4 Mon Sep 17 00:00:00 2001 From: Florent Bruneau Date: Mon, 22 Oct 2007 20:16:42 +0200 Subject: [PATCH] Fix the edition of event subscription for non member Signed-off-by: Florent Bruneau --- modules/xnetgrp.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/modules/xnetgrp.php b/modules/xnetgrp.php index 12f86c9..d9700ad 100644 --- a/modules/xnetgrp.php +++ b/modules/xnetgrp.php @@ -54,12 +54,12 @@ function get_infos($email) u.prenom, b.alias, CONCAT(b.alias, '@m4x.org') AS email, CONCAT(b.alias, '@polytechnique.org') AS email2, - m.perms='admin' AS perms, m.origine, + m.perms = 'admin' AS perms, m.origine, FIND_IN_SET('femme', u.flags) AS sexe FROM auth_user_md5 AS u INNER JOIN aliases AS a ON ( u.user_id = a.id AND a.type != 'homonyme' ) INNER JOIN aliases AS b ON ( u.user_id = b.id AND b.type = 'a_vie' ) - INNER JOIN groupex.membres AS m ON ( m.uid = u.user_id AND asso_id={?}) + LEFT JOIN groupex.membres AS m ON ( m.uid = u.user_id AND asso_id={?}) WHERE a.alias = {?} AND u.user_id < 50000", $globals->asso('id'), $mbox); return $res->fetchOneAssoc(); } -- 2.1.4