From 7757efd6c4bf3542c57efa4b248de641b39a7003 Mon Sep 17 00:00:00 2001 From: =?utf8?q?St=C3=A9phane=20Jacob?= Date: Fri, 20 May 2011 10:02:39 +0200 Subject: [PATCH] Addresses components list should only contain home components. MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit Signed-off-by: Stéphane Jacob --- modules/search.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/modules/search.php b/modules/search.php index 9d7301a..1dc226c 100644 --- a/modules/search.php +++ b/modules/search.php @@ -323,7 +323,7 @@ class SearchModule extends PLModule INNER JOIN profile_addresses_components AS pac2 ON (pac1.pid = pac2.pid AND pac1.jobid = pac2.jobid AND pac1.id = pac2.id AND pac1.groupid = pac2.groupid AND pac1.type = pac2.type) INNER JOIN profile_addresses_components_enum AS pace2 ON (pac2.component_id = pace2.id AND FIND_IN_SET({?}, pace2.types)) - WHERE pace2.id = {?} AND FIND_IN_SET({?}, pace1.types) + WHERE pace2.id = {?} AND FIND_IN_SET({?}, pace1.types) AND pac1.type = 'home' GROUP BY pace1.long_name", Env::v('previous'), Env::v('value'), $type); break; -- 2.1.4