From abc500104714c566322605f3864c42c516fb42d6 Mon Sep 17 00:00:00 2001 From: =?utf8?q?St=C3=A9phane=20Jacob?= Date: Wed, 24 Dec 2008 17:34:45 +0100 Subject: [PATCH] Fixes email in the minifiche. --- include/userset.inc.php | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) diff --git a/include/userset.inc.php b/include/userset.inc.php index ebd37dd..f725210 100644 --- a/include/userset.inc.php +++ b/include/userset.inc.php @@ -173,6 +173,7 @@ class MinificheView extends MultipageView { global $globals; return "u.user_id AS id, u.*, d.promo_display, + CONCAT(a.alias, '@{$globals->mail->domain}') AS bestemail, u.perms != 'pending' AS inscrit, u.perms != 'pending' AS wasinscrit, u.deces != 0 AS dcd, u.deces, u.matricule_ax, @@ -201,7 +202,8 @@ class MinificheView extends MultipageView public function joins() { - return "LEFT JOIN profile_job AS j ON (j.uid = u.user_id".(S::logged() ? "" : " AND j.pub = 'public'").") + return "LEFT JOIN aliases AS a ON (u.user_id = a.id AND FIND_IN_SET('bestalias', a.flags)) + LEFT JOIN profile_job AS j ON (j.uid = u.user_id".(S::logged() ? "" : " AND j.pub = 'public'").") LEFT JOIN profile_job_enum AS je ON (je.id = j.jobid) LEFT JOIN profile_job_sector_enum AS es ON (j.sectorid = es.id) LEFT JOIN fonctions_def AS ef ON (j.functionid = ef.id) -- 2.1.4