From: Liz Rea <lrea@nekls.org>
Date: Thu, 4 Jun 2009 16:22:00 +0000 (-0500)
Subject: Bug 3289 - Fixed bad conditional check that made news items not show up until the... 
X-Git-Tag: n_acq_a_porter~26^2~135
X-Git-Url: http://git.rot13.org/?p=koha.git;a=commitdiff_plain;h=0c29750106c4b5175136d20dd4f579de06e3f2ad

Bug 3289 - Fixed bad conditional check that made news items not show up until the day after pubdate.

Signed-off-by: Galen Charlton <galen.charlton@liblime.com>
---

diff --git a/C4/NewsChannels.pm b/C4/NewsChannels.pm
index 136cc5c282..8cf1ff6d9c 100644
--- a/C4/NewsChannels.pm
+++ b/C4/NewsChannels.pm
@@ -328,11 +328,11 @@ sub GetNewsToDisplay {
      SELECT *,timestamp AS newdate
      FROM   opac_news
      WHERE   (
-        expirationdate > CURRENT_DATE()
+        expirationdate >= CURRENT_DATE()
         OR    expirationdate IS NULL
         OR    expirationdate = '00-00-0000'
       )
-      AND   `timestamp` < CURRENT_DATE()
+      AND   `timestamp` <= CURRENT_DATE()
       AND   lang = ?
       ORDER BY number
     ";				# expirationdate field is NOT in ISO format?