diff options
| author | Max Kremmel <xing@synapse.plus.com> | 2006-12-27 07:30:07 +0000 |
|---|---|---|
| committer | Max Kremmel <xing@synapse.plus.com> | 2006-12-27 07:30:07 +0000 |
| commit | 086e1a9e8e3c102469e36ff9e12c3b62aac5212b (patch) | |
| tree | 8c01c8409f28d28bd764c59e24f44f323935052b | |
| parent | 7be1d39d496dded45e0e9f816dec9f3e8d1c7141 (diff) | |
| download | search-086e1a9e8e3c102469e36ff9e12c3b62aac5212b.tar.gz search-086e1a9e8e3c102469e36ff9e12c3b62aac5212b.tar.bz2 search-086e1a9e8e3c102469e36ff9e12c3b62aac5212b.zip | |
put FIRST 1 back in, since i don't know what the hell i'm doing in here
| -rw-r--r-- | search_lib.php | 11 |
1 files changed, 5 insertions, 6 deletions
diff --git a/search_lib.php b/search_lib.php index 8bd45a2..66dbcb0 100644 --- a/search_lib.php +++ b/search_lib.php @@ -1,6 +1,6 @@ <?php /** - * $Header: /cvsroot/bitweaver/_bit_search/search_lib.php,v 1.28 2006/12/26 17:10:46 squareing Exp $ + * $Header: /cvsroot/bitweaver/_bit_search/search_lib.php,v 1.29 2006/12/27 07:30:07 squareing Exp $ * * Copyright (c) 2004 bitweaver.org * Copyright (c) 2003 tikwiki.org @@ -8,7 +8,7 @@ * All Rights Reserved. See copyright.txt for details and a complete list of authors. * Licensed under the GNU LESSER GENERAL PUBLIC LICENSE. See license.txt for details * - * $Id: search_lib.php,v 1.28 2006/12/26 17:10:46 squareing Exp $ + * $Id: search_lib.php,v 1.29 2006/12/27 07:30:07 squareing Exp $ * @author Luis Argerich (lrargerich@yahoo.com) * @package search */ @@ -187,9 +187,9 @@ class SearchLib extends BitBase { lc.`last_modified`, lc.`data`, COALESCE(( - SELECT SUM(i_count) - FROM `" . BIT_DB_PREFIX . "search_index` si - WHERE si.`content_id`=lc.`content_id` AND si.`searchword` IN (" . $qPlaceHolders1 . ") + SELECT FIRST 1 SUM(i_count) + FROM `" . BIT_DB_PREFIX . "search_index` si + WHERE si.`content_id`=lc.`content_id` AND si.`searchword` IN (" . $qPlaceHolders1 . ") ),0) AS relivency $selectSql FROM `" . BIT_DB_PREFIX . "liberty_content` lc @@ -206,7 +206,6 @@ class SearchLib extends BitBase { )>0 $whereSql ORDER BY 9 DESC, 5 DESC "; - //SELECT FIRST 1 SUM(i_count) $querycant = "SELECT COUNT(*) FROM `" . BIT_DB_PREFIX . "liberty_content` lc |