From ea78fddb5b46848d8ccba8559f99ef2f674e338a Mon Sep 17 00:00:00 2001
From: Hash9 <hash9@users.sourceforge.net>
Date: Wed, 30 Aug 2006 14:26:11 +0000
Subject: fix articles list

---
 search_lib.php | 8 ++++----
 1 file changed, 4 insertions(+), 4 deletions(-)

(limited to 'search_lib.php')

diff --git a/search_lib.php b/search_lib.php
index c19edeb..8b679c8 100644
--- a/search_lib.php
+++ b/search_lib.php
@@ -1,6 +1,6 @@
 <?php
 /**
- * $Header: /cvsroot/bitweaver/_bit_search/search_lib.php,v 1.24 2006/08/19 17:01:08 hash9 Exp $
+ * $Header: /cvsroot/bitweaver/_bit_search/search_lib.php,v 1.25 2006/08/30 14:26:11 hash9 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.24 2006/08/19 17:01:08 hash9 Exp $
+ * $Id: search_lib.php,v 1.25 2006/08/30 14:26:11 hash9 Exp $
  * @author  Luis Argerich (lrargerich@yahoo.com)
  * @package search
  */
@@ -182,7 +182,7 @@ class SearchLib extends BitBase {
 						lc.`title`,
 						lc.`format_guid`,
 						lc.`content_type_guid`,
-						lch.`hits`,
+						COALESCE(lch.`hits`,0) AS hits,
 						lc.`created`,
 						lc.`last_modified`,
 						lc.`data`,
@@ -205,7 +205,7 @@ class SearchLib extends BitBase {
 						si.`searchword`
 						HAVING si.`searchword` IN (" . $qPlaceHolders1 . ")
 						)>0 $whereSql
-					ORDER BY relivency DESC, lch.`hits` DESC
+					ORDER BY relivency DESC, hits DESC
 					";
 			$querycant = "SELECT
 					COUNT(*)
-- 
cgit v1.3