From ab9fe2c98b2c7284b098812448c9729ef3b472e4 Mon Sep 17 00:00:00 2001 From: x2003bruneau Date: Thu, 28 Jun 2007 21:30:00 +0000 Subject: [PATCH] Backport r1867 xnetevents.php | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) git-svn-id: svn+ssh://murphy/home/svn/platal/trunk@1868 839d8a87-29fc-0310-9880-83ba4fa771e5 --- modules/xnetevents.php | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) diff --git a/modules/xnetevents.php b/modules/xnetevents.php index 08478fe..db91a51 100644 --- a/modules/xnetevents.php +++ b/modules/xnetevents.php @@ -625,10 +625,12 @@ class XnetEventsModule extends PLModule IF(m.origine = 'X', a.alias, m.email) AS email FROM groupex.evenements_participants AS p INNER JOIN groupex.membres AS m USING(uid) + LEFT JOIN groupex.evenements_participants AS p2 ON (p2.uid = m.uid AND p2.eid = p.eid + AND p2.nb != 0) LEFT JOIN auth_user_md5 AS u ON (u.user_id = m.uid) LEFT JOIN aliases AS a ON (a.id = u.user_id AND a.type = 'a_vie') - WHERE p.eid = {?} AND nb = 0 - GROUP BY p.uid + WHERE p.eid = {?} AND p2.eid IS NULL + GROUP BY m.uid ORDER BY nom, prenom, promo", $evt['eid']); $page->assign('absents', $absents); -- 2.1.4