From ede84182b0392b6ff2db10bb95999bcd5009c1c3 Mon Sep 17 00:00:00 2001 From: =?utf8?q?St=C3=A9phane=20Jacob?= Date: Sat, 20 Dec 2008 16:54:57 +0100 Subject: [PATCH] Fixes event creation when there are X that are not in Xorg in the group. --- modules/xnetevents/xnetevents.inc.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/modules/xnetevents/xnetevents.inc.php b/modules/xnetevents/xnetevents.inc.php index 494d664..cae7848 100644 --- a/modules/xnetevents/xnetevents.inc.php +++ b/modules/xnetevents/xnetevents.inc.php @@ -318,7 +318,7 @@ function event_change_shortname(&$page, $eid, $old, $new) $lastid = XDB::insertId(); XDB::execute("INSERT INTO virtual_redirect ( - SELECT {?} AS vid, IF(u.nom IS NULL, m.email, CONCAT(a.alias, {?})) AS redirect + SELECT {?} AS vid, IF(a.alias IS NULL, m.email, CONCAT(a.alias, {?})) AS redirect FROM groupex.membres AS m LEFT JOIN groupex.evenements_participants AS ep ON (ep.uid = m.uid AND ep.eid = {?}) LEFT JOIN auth_user_md5 AS u ON (u.user_id = m.uid) -- 2.1.4