From dfcccfc0f277d90e5ef4af1e6b33ef3e1e76d6e2 Mon Sep 17 00:00:00 2001 From: Florent Bruneau Date: Wed, 21 Jan 2009 14:07:21 +0100 Subject: [PATCH] User can have several nicknames. Signed-off-by: Florent Bruneau --- classes/profile.php | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/classes/profile.php b/classes/profile.php index 0f1a796..025521f 100644 --- a/classes/profile.php +++ b/classes/profile.php @@ -51,7 +51,8 @@ class Profile LEFT JOIN profile_name AS pn_uf ON (pn_uf.pid = p.pid AND pn_uf.typeid = ' . self::getNameTypeId('lastname_ordinary', true) . ') LEFT JOIN profile_name AS pn_ul ON (pn_ul.pid = p.pid AND pn_ul.typeid = ' . self::getNameTypeId('firstname_ordinary', true) . ') LEFT JOIN profile_name aS pn_n ON (pn_n.pid = p.pid AND pn_n.typeid = ' . self::getNameTypeId('nickname', true) . ') - WHERE ' . $where); + WHERE ' . $where . ' + GROUP BY p.pid'); if ($res->numRows() != 1) { __autoload('PlUser'); throw new UserNotFoundException(); -- 2.1.4