From 767025beb3b5fb8465f7ba003a4c182793c73cc5 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Rapha=C3=ABl=20Barrois?= Date: Sun, 14 Feb 2010 01:10:24 +0100 Subject: [PATCH] Fix error in Profile SQL queries MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit Error in the name of joined tables Signed-off-by: Raphaël Barrois --- classes/profile.php | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/classes/profile.php b/classes/profile.php index 177a244..bf06501 100644 --- a/classes/profile.php +++ b/classes/profile.php @@ -346,13 +346,13 @@ class Profile INNER JOIN profile_display AS pd ON (pd.pid = p.pid) INNER JOIN profile_education AS pe ON (pe.uid = p.pid AND FIND_IN_SET(\'primary\', pe.flags)) INNER JOIN profile_name AS pn_f ON (pn_f.pid = p.pid - AND pn_f.typeid = ' . self::getNameTypeId('lastname', true) . ') + AND pn_f.typeid = ' . self::getNameTypeId('firstname', true) . ') INNER JOIN profile_name AS pn_l ON (pn_l.pid = p.pid - AND pn_l.typeid = ' . self::getNameTypeId('firstname', true) . ') + AND pn_l.typeid = ' . self::getNameTypeId('lastname', true) . ') LEFT JOIN profile_name AS pn_uf ON (pn_uf.pid = p.pid - AND pn_uf.typeid = ' . self::getNameTypeId('lastname_ordinary', true) . ') + AND pn_uf.typeid = ' . self::getNameTypeId('firstname_ordinary', true) . ') LEFT JOIN profile_name AS pn_ul ON (pn_ul.pid = p.pid - AND pn_ul.typeid = ' . self::getNameTypeId('firstname_ordinary', true) . ') + AND pn_ul.typeid = ' . self::getNameTypeId('lastname_ordinary', true) . ') LEFT JOIN profile_name AS pn_n ON (pn_n.pid = p.pid AND pn_n.typeid = ' . self::getNameTypeId('nickname', true) . ') LEFT JOIN profile_phones AS pp ON (pp.uid = p.pid AND pp.link_type = \'user\' AND tel_type = \'mobile\') -- 2.1.4