[geeklog-cvs] geeklog: Fixed error when sorting by date/hits (bug #0001129)

[geeklog-cvs at lists.geeklog.net]

changeset 7897:ca092e871b04
url:  http://project.geeklog.net/cgi-bin/hgwebdir.cgi/geeklog/rev/ca092e871b04
user: Sami Barakat <sami at sbarakat.co.uk>
date: Sun Apr 25 20:03:59 2010 +0100
description:
Fixed error when sorting by date/hits (bug #0001129)

diffstat:

 plugins/staticpages/functions.inc |  2 +-
 system/classes/search.class.php   |  6 +++---
 2 files changed, 4 insertions(+), 4 deletions(-)

diffs (42 lines):

diff -r 7a72cb046113 -r ca092e871b04 plugins/staticpages/functions.inc
--- a/plugins/staticpages/functions.inc	Sat Apr 24 19:28:28 2010 +0200
+++ b/plugins/staticpages/functions.inc	Sun Apr 25 20:03:59 2010 +0100
@@ -786,7 +786,7 @@
 
     // Search static page comments
     $sql = "SELECT c.cid AS id, c.title AS title, c.comment AS description, ";
-    $sql .= "UNIX_TIMESTAMP(c.date) AS date, c.uid AS uid, ";
+    $sql .= "UNIX_TIMESTAMP(c.date) AS date, c.uid AS uid, '0' AS hits, ";
 
     // MSSQL has a problem when concatenating numeric values
     if ($_DB_dbms == 'mssql') {
diff -r 7a72cb046113 -r ca092e871b04 system/classes/search.class.php
--- a/system/classes/search.class.php	Sat Apr 24 19:28:28 2010 +0200
+++ b/system/classes/search.class.php	Sun Apr 25 20:03:59 2010 +0100
@@ -2,7 +2,7 @@
 
 /* Reminder: always indent with 4 spaces (no tabs). */
 // +---------------------------------------------------------------------------+
-// | Geeklog 1.6                                                               |
+// | Geeklog 1.7                                                               |
 // +---------------------------------------------------------------------------+
 // | search.class.php                                                          |
 // |                                                                           |
@@ -12,7 +12,7 @@
 // |                                                                           |
 // | Authors: Tony Bibbs       - tony AT geeklog DOT net                       |
 // |          Dirk Haun        - dirk AT haun-online DOT de                    |
-// |          Sami Barakat     - s.m.barakat AT gmail DOT com                  |
+// |          Sami Barakat     - sami AT sbarakat DOT co DOT uk                |
 // +---------------------------------------------------------------------------+
 // |                                                                           |
 // | This program is free software; you can redistribute it and/or             |
@@ -355,7 +355,7 @@
 
         // Search Story Comments
         $sql = 'SELECT c.cid AS id, c.title AS title, c.comment AS description, ';
-        $sql .= 'UNIX_TIMESTAMP(c.date) AS date, c.uid AS uid, ';
+        $sql .= 'UNIX_TIMESTAMP(c.date) AS date, c.uid AS uid, \'0\' AS hits, ';
 
         // MSSQL has a problem when concatenating numeric values
         if ($_DB_dbms == 'mssql') {