Bug 3289 - Fixed bad conditional check that made news items not show up until the...
authorLiz Rea <lrea@nekls.org>
Thu, 4 Jun 2009 16:22:00 +0000 (11:22 -0500)
committerGalen Charlton <galen.charlton@liblime.com>
Fri, 5 Jun 2009 21:53:05 +0000 (16:53 -0500)
Signed-off-by: Galen Charlton <galen.charlton@liblime.com>
C4/NewsChannels.pm

index 136cc5c..8cf1ff6 100644 (file)
@@ -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?