From eb10b859d1bf6394b2fd91fc52f6b8e1cf806924 Mon Sep 17 00:00:00 2001 From: Steve Sutton Date: Mon, 9 Sep 2013 13:10:53 +0000 Subject: [PATCH] Take out soundex Remove the normal search for member soundex query. --- Toolkit/Members/SearchQueryGenerator.php | 15 +-------------- 1 file changed, 1 insertion(+), 14 deletions(-) diff --git a/Toolkit/Members/SearchQueryGenerator.php b/Toolkit/Members/SearchQueryGenerator.php index 5d5ae8e..720f6d7 100644 --- a/Toolkit/Members/SearchQueryGenerator.php +++ b/Toolkit/Members/SearchQueryGenerator.php @@ -205,20 +205,7 @@ class Toolkit_Members_SearchQueryGenerator $spaceName = urldecode($memberName); $sanitizedNoSpaceName = $dbh->quote($noSpaceName); $sanitizedSpaceName = $dbh->quote($spaceName); - $params[] = " - ( - ( regexp_replace(member_name, '[^[:alnum:]]', '', 'g') ~* $sanitizedNoSpaceName - OR metaphone(member_name, 4) = metaphone($sanitizedSpaceName, 4) - ) - OR ( - m.member_id = emn.mid - AND ( - $sanitizedNoSpaceName ~* regexp_replace(emn.part, '[^[:alnum:]]', '', 'g') - OR (metaphone($sanitizedSpaceName, 4) = metaphone(emn.part, 4)) - ) - AND char_length(emn.part) > 1 - ) - )"; + $params[] = "member_name ilike " . $dbh->quote('%'.$memberName.'%'); } // Using controlled cities and a search was performed on a city -- 2.17.1