diff options
| author | cash <cash.costello@gmail.com> | 2012-06-21 20:00:52 -0400 |
|---|---|---|
| committer | cash <cash.costello@gmail.com> | 2012-06-21 20:00:52 -0400 |
| commit | c4262b93dd12de7d8b04533b261c39e4ce8ccf8c (patch) | |
| tree | eae146bd5211899df65138e290e0f78afb687a37 | |
| parent | 2826dc077c405ee0b63713d989983085ff230ac3 (diff) | |
| download | elgg-c4262b93dd12de7d8b04533b261c39e4ce8ccf8c.tar.gz elgg-c4262b93dd12de7d8b04533b261c39e4ce8ccf8c.tar.bz2 | |
Fixes #4165 livesearch now returns people based on last names
| -rw-r--r-- | engine/lib/input.php | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/engine/lib/input.php b/engine/lib/input.php index dda8211b6..6d1646e1a 100644 --- a/engine/lib/input.php +++ b/engine/lib/input.php @@ -283,7 +283,7 @@ function input_livesearch_page_handler($page) { WHERE e.guid = ue.guid AND e.enabled = 'yes' AND ue.banned = 'no' - AND (ue.name LIKE '$q%' OR ue.username LIKE '$q%') + AND (ue.name LIKE '$q%' OR ue.name LIKE '% $q%' OR ue.username LIKE '$q%') LIMIT $limit "; @@ -333,7 +333,7 @@ function input_livesearch_page_handler($page) { WHERE e.guid = ge.guid AND e.enabled = 'yes' $owner_where - AND (ge.name LIKE '$q%' OR ge.description LIKE '%$q%') + AND (ge.name LIKE '$q%' OR ge.name LIKE '% $q%' OR ge.description LIKE '% $q%') LIMIT $limit "; if ($entities = get_data($query)) { @@ -379,7 +379,7 @@ function input_livesearch_page_handler($page) { AND e.guid = ue.guid AND e.enabled = 'yes' AND ue.banned = 'no' - AND (ue.name LIKE '$q%' OR ue.username LIKE '$q%') + AND (ue.name LIKE '$q%' OR ue.name LIKE '% $q%' OR ue.username LIKE '$q%') LIMIT $limit "; |