From e06d5db3f81d9357329e643b1e3c170d7d47324e Mon Sep 17 00:00:00 2001 From: marcus Date: Wed, 18 Jun 2008 14:40:20 +0000 Subject: Fixes #41: User full text search. See caveats in function search_for_user() git-svn-id: https://code.elgg.org/elgg/trunk@967 36083f99-b078-4883-b0ff-0f9b5a30f544 --- engine/lib/users.php | 21 +++++++++++++++++++++ 1 file changed, 21 insertions(+) (limited to 'engine/lib') diff --git a/engine/lib/users.php b/engine/lib/users.php index 16e7a2c5f..50e9d11ea 100644 --- a/engine/lib/users.php +++ b/engine/lib/users.php @@ -682,6 +682,27 @@ return false; } + + /** + * Searches for a user based on a complete or partial name or username using full text searching. + * + * IMPORTANT NOTE: With MySQL's default setup: + * 1) $criteria must be 4 or more characters long + * 2) If $criteria matches greater than 50% of results NO RESULTS ARE RETURNED! + * + * @param string $criteria The partial or full name or username. + */ + function search_for_user($criteria) + { + global $CONFIG; + + $criteria = sanitise_string($criteria); + $access = get_access_sql_suffix("e"); + + $query = "select e.* from {$CONFIG->dbprefix}entities e join {$CONFIG->dbprefix}users_entity u on e.guid=u.guid where match(u.name,u.username) against ('$criteria') and $access"; + + return get_data($query, "entity_row_to_elggstar"); + } /** * Registers a user, returning false if the username already exists -- cgit v1.2.3