From 488765e38cf20b81b5e6056f30d5ec2ddf0a032c Mon Sep 17 00:00:00 2001 From: =?utf8?q?Rapha=C3=ABl=20Barrois?= Date: Wed, 23 Jun 2010 00:01:52 +0200 Subject: [PATCH] Fix error on quicksearching on promos MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit Signed-off-by: Raphaël Barrois --- classes/userfilter.php | 6 ++++++ 1 file changed, 6 insertions(+) diff --git a/classes/userfilter.php b/classes/userfilter.php index 20696a0..18bdadd 100644 --- a/classes/userfilter.php +++ b/classes/userfilter.php @@ -1420,6 +1420,12 @@ class UFO_Score extends UserFilterOrder { $toks = $uf->getNameTokens(); $scores = array(); + + // If there weren't any sort tokens, we shouldn't sort by score, sort by NULL instead + if (count($toks) == 0) { + return 'NULL'; + } + foreach ($toks as $sub => $token) { $scores[] = XDB::format('SUM(' . $sub . '.score + IF (' . $sub . '.token = {?}, 5, 0) )', $token); } -- 2.1.4