projects
/
koha.git
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
| inline |
side by side
(parent:
2efc5fa
)
Bug 3289 - Fixed bad conditional check that made news items not show up until the...
author
Liz Rea
<lrea@nekls.org>
Thu, 4 Jun 2009 16:22:00 +0000
(11:22 -0500)
committer
Galen 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
patch
|
blob
|
history
diff --git
a/C4/NewsChannels.pm
b/C4/NewsChannels.pm
index
136cc5c
..
8cf1ff6
100644
(file)
--- 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?