Revision 861
Added by Matthias over 15 years ago
| view.php | ||
|---|---|---|
| 98 | 98 |
} |
| 99 | 99 |
|
| 100 | 100 |
// Get total number of posts |
| 101 |
$query_total_num = $database->query("SELECT post_id FROM ".TABLE_PREFIX."mod_news_posts WHERE section_id = '$section_id' AND active = '1' AND title != ''$query_extra");
|
|
| 101 |
$t = time(); |
|
| 102 |
$query_total_num = $database->query("SELECT post_id FROM ".TABLE_PREFIX."mod_news_posts WHERE section_id = '$section_id' AND active = '1' AND title != '' $query_extra AND (published_when = '0' OR published_when <= $t) AND (published_until = 0 OR published_until >= $t)");
|
|
| 102 | 103 |
$total_num = $query_total_num->numRows(); |
| 103 | 104 |
|
| 104 | 105 |
// Work-out if we need to add limit code to sql |
Also available in: Unified diff
fixed display issue in news modul