From a9c4624431c771dae24bec2a8fe6ce8585493f0c Mon Sep 17 00:00:00 2001 From: Robert Sesek Date: Sun, 21 Aug 2005 20:45:54 +0000 Subject: [PATCH] r355: Fixed reporter search --- search.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/search.php b/search.php index f49d109..455d37a 100644 --- a/search.php +++ b/search.php @@ -102,7 +102,7 @@ if ($_REQUEST['do'] == 'process') { // force email or name?? make a distinction? // more elegant way to do this? probably - $user = $db->query_first("SELECT * FROM user WHERE email = '" . $bugsys->in['reporter'] . "' OR MATCH (displayname) AGAINST ('" . $bugsys->in['reporter'] . "')"); + $user = $db->query_first("SELECT * FROM user WHERE email LIKE '%" . str_replace('%', '\%', $bugsys->in['reporter']) . "' OR displayname LIKE '%" . str_replace('%', '\%', $bugsys->in['reporter']) . "%'"); if ($user['userid']) { $querybuild['reporter'] = "AND bug.userid = $user[userid] OR comment.userid = $user[userid]"; -- 2.22.5