From 0c29750106c4b5175136d20dd4f579de06e3f2ad Mon Sep 17 00:00:00 2001 From: Liz Rea Date: Thu, 4 Jun 2009 11:22:00 -0500 Subject: [PATCH] Bug 3289 - Fixed bad conditional check that made news items not show up until the day after pubdate. Signed-off-by: Galen Charlton --- C4/NewsChannels.pm | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) 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? -- 2.20.1