// require(DIR_WS_MODULES . 'require_languages.php'); require_once(DIR_WS_CLASSES . 'news.php'); // Don't show news dates from the future // People are trying to view the future... the universe will be destroyed if we don't stop them! if (isset($_GET['date']) && ($_GET['date'] > date('Y-m-d') || !zen_not_null($_GET['date'])) ) { zen_redirect(zen_href_link(FILENAME_NEWS_INDEX)); } $curren_date = ((!isset($_GET['date'])) ? date('Y-m-d') : $_GET['date']); $date_selector_array = array(); $date_selector = $db->Execute("select news_date_published from " . TABLE_NEWS_ARTICLES . " where news_status = '1' and to_days(news_date_published) <= to_days('" . $curren_date . "') group by news_date_published desc limit 7"); while(!$date_selector->EOF) { $date_selector_array[] = array('date' => $date_selector->fields['news_date_published']); $date_selector->MoveNext(); } $date = ((isset($_GET['date']) && zen_not_null($_GET['date'])) ? $_GET['date'] : $date_selector_array[0]['date']); $breadcrumb->add(NAVBAR_TITLE, zen_href_link(FILENAME_NEWS_INDEX)); if (isset($_GET['date']) && zen_not_null($_GET['date'])) { $breadcrumb->add(zen_date_long($date), zen_href_link(FILENAME_NEWS_INDEX, 'date=' . $date)); } ?>