From 1638fc4e13e1d71eceb1deefe983c7f48d47b8a1 Mon Sep 17 00:00:00 2001
From: Andrew Dolgov <fox@bah.org.ru>
Date: Wed, 7 Oct 2009 15:12:21 +0400
Subject: prefs: rudimentary multiple keyword search

---
 modules/pref-users.php | 12 +++++++++++-
 1 file changed, 11 insertions(+), 1 deletion(-)

(limited to 'modules/pref-users.php')

diff --git a/modules/pref-users.php b/modules/pref-users.php
index 7e38fd5d4..7a878b18f 100644
--- a/modules/pref-users.php
+++ b/modules/pref-users.php
@@ -374,7 +374,17 @@
 			onclick=\"javascript:addUser()\" value=\"".__('Create user')."\"></div>";
 
 		if ($user_search) {
-			$user_search_query = "UPPER(login) LIKE UPPER('%$user_search%') AND";
+
+			$user_search = split(" ", $user_search);
+			$tokens = array();
+
+			foreach ($user_search as $token) {			
+				$token = trim($token);
+				array_push($tokens, "(UPPER(login) LIKE UPPER('%$token%'))");
+			}
+
+			$user_search_query = "(" . join($tokens, " AND ") . ") AND ";
+
 		} else {
 			$user_search_query = "";
 		}
-- 
cgit v1.2.3