From 6ccfd8f28a469616ec72365bec742d8a0c7f41e7 Mon Sep 17 00:00:00 2001 From: =?utf8?q?St=C3=A9phane=20Jacob?= Date: Thu, 19 May 2011 19:32:28 +0200 Subject: [PATCH] Fixes addresses related DirEnum. MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit Signed-off-by: Stéphane Jacob --- classes/direnum.php | 7 ++++++- 1 file changed, 6 insertions(+), 1 deletion(-) diff --git a/classes/direnum.php b/classes/direnum.php index 0cad8f2..0b51cb6 100644 --- a/classes/direnum.php +++ b/classes/direnum.php @@ -602,38 +602,43 @@ class DE_AddressesComponents extends DirEnumeration protected $ac_join = 'INNER JOIN profile_addresses_components ON (profile_addresses_components.component_id = profile_addresses_components_enum.id)'; protected $ac_unique = 'profile_addresses_components.pid'; - protected $ac_where = 'profile_addresses_components.type = \'home\''; } // }}} // {{{ class DE_AddressesComponents extensions class DE_Countries extends DE_AddressesComponents { protected $where = 'WHERE FIND_IN_SET(\'country\', profile_addresses_components_enum.types)'; + protected $ac_where = 'profile_addresses_components.type = \'home\' AND FIND_IN_SET(\'country\', profile_addresses_components_enum.types)'; } class DE_Admnistrativeareas1 extends DE_AddressesComponents { protected $where = 'WHERE FIND_IN_SET(\'admnistrative_area_1\', profile_addresses_components_enum.types)'; + protected $ac_where = 'profile_addresses_components.type = \'home\' AND FIND_IN_SET(\'admnistrative_area_1\', profile_addresses_components_enum.types)'; } class DE_Admnistrativeareas2 extends DE_AddressesComponents { protected $where = 'WHERE FIND_IN_SET(\'admnistrative_area_2\', profile_addresses_components_enum.types)'; + protected $ac_where = 'profile_addresses_components.type = \'home\' AND FIND_IN_SET(\'admnistrative_area_2\', profile_addresses_components_enum.types)'; } class DE_Admnistrativeareas3 extends DE_AddressesComponents { protected $where = 'WHERE FIND_IN_SET(\'admnistrative_area_3\', profile_addresses_components_enum.types)'; + protected $ac_where = 'profile_addresses_components.type = \'home\' AND FIND_IN_SET(\'admnistrative_area_3\', profile_addresses_components_enum.types)'; } class DE_Localities extends DE_AddressesComponents { protected $where = 'WHERE FIND_IN_SET(\'locality\', profile_addresses_components_enum.types)'; + protected $ac_where = 'profile_addresses_components.type = \'home\' AND FIND_IN_SET(\'locality\', profile_addresses_components_enum.types)'; } class DE_Sublocalities extends DE_AddressesComponents { protected $where = 'WHERE FIND_IN_SET(\'sublocality\', profile_addresses_components_enum.types)'; + protected $ac_where = 'profile_addresses_components.type = \'home\' AND FIND_IN_SET(\'sublocality\', profile_addresses_components_enum.types)'; } // }}} -- 2.1.4