aboutsummaryrefslogtreecommitdiff
path: root/engine/lib
diff options
context:
space:
mode:
authorcash <cash.costello@gmail.com>2012-06-21 20:00:52 -0400
committercash <cash.costello@gmail.com>2012-06-21 20:00:52 -0400
commitc4262b93dd12de7d8b04533b261c39e4ce8ccf8c (patch)
treeeae146bd5211899df65138e290e0f78afb687a37 /engine/lib
parent2826dc077c405ee0b63713d989983085ff230ac3 (diff)
downloadelgg-c4262b93dd12de7d8b04533b261c39e4ce8ccf8c.tar.gz
elgg-c4262b93dd12de7d8b04533b261c39e4ce8ccf8c.tar.bz2
Fixes #4165 livesearch now returns people based on last names
Diffstat (limited to 'engine/lib')
-rw-r--r--engine/lib/input.php6
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
";