[geeklog-cvs] geeklog: Fixed SQL creation for displaying new articles (bug #00...

[geeklog-cvs at lists.geeklog.net]

changeset 7781:be74560f386e
url:  http://project.geeklog.net/cgi-bin/hgwebdir.cgi/geeklog/rev/be74560f386e
user: Dirk Haun <dirk at haun-online.de>
date: Thu Mar 11 13:34:15 2010 +0100
description:
Fixed SQL creation for displaying new articles (bug #0001089)

diffstat:

 public_html/index.php |  17 +++++++++++------
 1 files changed, 11 insertions(+), 6 deletions(-)

diffs (27 lines):

diff -r 0012a888c487 -r be74560f386e public_html/index.php
--- a/public_html/index.php	Thu Mar 11 13:23:05 2010 +0100
+++ b/public_html/index.php	Thu Mar 11 13:34:15 2010 +0100
@@ -301,12 +301,17 @@
 $sql .= COM_getTopicSQL ('AND', 0, 's') . ' ';
 
 if ($newstories) {
-    
-    $sql['mysql'] .= "AND (date >= (date_sub(NOW(), INTERVAL {$_CONF['newstoriesinterval']} SECOND))) ";
-    $sql['pgsql'] .= "AND (date >= (NOW(), INTERVAL '{$_CONF['newstoriesinterval']} SECOND')) ";
-    $sql['pgsql'] .= "AND (date >= (date_sub(NOW(), INTERVAL {$_CONF['newstoriesinterval']} SECOND))) ";
-
-
+    switch ($_DB_dbms) {
+    case 'mysql':
+        $sql .= "AND (date >= (date_sub(NOW(), INTERVAL {$_CONF['newstoriesinterval']} SECOND))) ";
+        break;
+    case 'pgsql':
+        $sql .= "AND (date >= (NOW() + INTERVAL '{$_CONF['newstoriesinterval']} SECOND')) ";
+        break;
+    case 'mssql':
+        $sql .= "AND (date >= (date_sub(NOW(), INTERVAL {$_CONF['newstoriesinterval']} SECOND))) ";
+        break;
+    }
 }
 
 $offset = ($page - 1) * $limit;