diff options
| author | CiaranG <ciaran@ciarang.com> | 2008-09-14 16:17:44 -0400 |
|---|---|---|
| committer | CiaranG <ciaran@ciarang.com> | 2008-09-14 16:17:44 -0400 |
| commit | 3632a76773dbfc31cf6f99ad831bf13f793871ae (patch) | |
| tree | 85c8a0b54f297bd9e09671b5f7b02a98660da8f3 /actions/peoplesearch.php | |
| parent | b13233fed40ee132779906cfa29e00f8c28631df (diff) | |
PostgreSQL: support for full text searching (notice and people)
darcs-hash:20080914201744-f6e2c-71b2a3aec4c0b91557465323d79645e7eab2bfd1.gz
Diffstat (limited to 'actions/peoplesearch.php')
| -rw-r--r-- | actions/peoplesearch.php | 7 |
1 files changed, 6 insertions, 1 deletions
diff --git a/actions/peoplesearch.php b/actions/peoplesearch.php index adacc0954..4e0ec3f0c 100644 --- a/actions/peoplesearch.php +++ b/actions/peoplesearch.php @@ -39,8 +39,13 @@ class PeoplesearchAction extends SearchAction { # lcase it for comparison $q = strtolower($q); - $profile->whereAdd('MATCH(nickname, fullname, location, bio, homepage) ' . + + if(common_config('db','type')=='mysql') { + $profile->whereAdd('MATCH(nickname, fullname, location, bio, homepage) ' . 'against (\''.addslashes($q).'\')'); + } else { + $profile->whereAdd('textsearch @@ plainto_tsquery(\''.addslashes($q).'\')'); + } # Ask for an extra to see if there's more. |