<?php
//
// +----------------------------------------------------------------------+
// |zen-cart Open Source E-commerce                                       |
// +----------------------------------------------------------------------+
// | Copyright (c) 2004-2005 Joshua Dechant                               |
// |                                                                      |   
// | Portions Copyright (c) 2004 The zen-cart developers                  |
// |                                                                      |   
// | http://www.zen-cart.com/index.php                                    |   
// |                                                                      |   
// | Portions Copyright (c) 2003 osCommerce                               |
// +----------------------------------------------------------------------+
// | This source file is subject to version 2.0 of the GPL license,       |
// | that is bundled with this package in the file LICENSE, and is        |
// | available through the world-wide-web at the following url:           |
// | http://www.zen-cart.com/license/2_0.txt.                             |
// | If you did not receive a copy of the zen-cart license and are unable |
// | to obtain it through the world-wide-web, please send a note to       |
// | license@zen-cart.com so we can mail you a copy immediately.          |
// +----------------------------------------------------------------------+
// $Id: header_php.php v2.000 2004-01-23 dreamscape <dechantj@pop.belmont.edu>
//
require(DIR_WS_MODULES . 'require_languages.php');
require_once(DIR_WS_CLASSES . 'news.php');
$article = $db->Execute("select n.news_date_published, 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.article_id = '" . (int)$_GET['article_id'] . "'");
// Look buddy, that article does not exist
if ($article->RecordCount() < 1) {
zen_redirect(zen_href_link(FILENAME_NEWS_INDEX));
}
$date = $article->fields['news_date_published'];
$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('" . $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();
}
$breadcrumb->add(NAVBAR_TITLE, zen_href_link(FILENAME_NEWS_INDEX));
$breadcrumb->add($article->fields['news_article_name'], zen_href_link(FILENAME_NEWS_ARTICLE, 'article_id=' . $_GET['article_id']));
?>