if ($date_selector_array[1]['date']) {
$news_footer = $db->Execute("select n.article_id, nt.news_article_name from " . TABLE_NEWS_ARTICLES . " n left join " . TABLE_NEWS_ARTICLES_TEXT . " nt on n.article_id = nt.article_id and nt.language_id = '" . (int)$_SESSION['languages_id'] . "' where n.news_status = '1' and n.news_date_published = '" . $date_selector_array[1]['date'] . "' order by n.sort_order");
if ($news_footer->RecordCount() > 0) {
$news_footer_array = array();
while (!$news_footer->EOF) {
$news_footer_array[] = array(
'link' => zen_href_link(FILENAME_NEWS_ARTICLE, 'article_id=' . $news_footer->fields['article_id']),
'text' => stripslashes($news_footer->fields['news_article_name']),
);
$news_footer->MoveNext();
}
$newsFooterDate = zen_date_long($date_selector_array[1]['date']);
$newsFooterDateURL = zen_href_link(FILENAME_NEWS_INDEX, 'date=' . substr($date_selector_array[1]['date'], 0, 10));
$newsFooter = $news_footer_array;
}
}
if ($date_selector_array[2]['date']) {
$recent_footer_array = array();
for ($i=2; $i<sizeof($date_selector_array); $i++) {
$recent_footer_array[] = array(
'link' => zen_href_link(FILENAME_NEWS_INDEX, 'date=' . substr($date_selector_array[$i]['date'], 0, 10)),
'text' => zen_date_long($date_selector_array[$i]['date']),
);
}
$newsRecentFooter = $recent_footer_array;
}
Bookmarks