|
Lines 207-213
sub GetNewsToDisplay {
Link Here
|
| 207 |
FROM opac_news |
207 |
FROM opac_news |
| 208 |
LEFT JOIN borrowers on borrowers.borrowernumber = |
208 |
LEFT JOIN borrowers on borrowers.borrowernumber = |
| 209 |
opac_news.borrowernumber |
209 |
opac_news.borrowernumber |
| 210 |
WHERE (}; |
210 |
WHERE }; |
| 211 |
|
211 |
|
| 212 |
if ( defined $id ) { |
212 |
if ( defined $id ) { |
| 213 |
$query .= q{ opac_news.idnew = ? } if defined $id; |
213 |
$query .= q{ opac_news.idnew = ? } if defined $id; |
|
Lines 216-222
sub GetNewsToDisplay {
Link Here
|
| 216 |
|
216 |
|
| 217 |
unless ( defined $time ) { |
217 |
unless ( defined $time ) { |
| 218 |
$query .= q{ AND } if defined $id; |
218 |
$query .= q{ AND } if defined $id; |
| 219 |
$query .= q{ |
219 |
$query .= q{ ( |
| 220 |
expirationdate >= CURRENT_DATE() |
220 |
expirationdate >= CURRENT_DATE() |
| 221 |
OR expirationdate IS NULL |
221 |
OR expirationdate IS NULL |
| 222 |
OR expirationdate = '00-00-0000' |
222 |
OR expirationdate = '00-00-0000' |