<?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: main_template_vars.php v2.100 2005-02-01 dreamscape <dechantj@pop.belmont.edu>
//
require_once(DIR_WS_CLASSES . 'news.php');
$news_list_by_author_sql=' select n.article_id, nt.news_article_text, n.news_image, 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'] . '\') and n.news_status = \'1\'' . 'order by article_id desc limit 4';
$news = $db->Execute($news_list_by_author_sql);
if ($news->RecordCount() > 0) {
$i = 0;
$article_array = array();
while (!$news->EOF) {
$article_array[$i] = array(
'articleId' => $news->fields['article_id'],
'articleName' => zen_trunc_string($news->fields['news_article_name'],120),
'articletext' => zen_trunc_string($news->fields['news_article_text'],200),
'articleimg' => zen_image(DIR_WS_IMAGES . $news->fields['news_image'], $news->fields['news_image_text'], '400', '300', ' align="right" class="articleImage"'),
);
$i++;
$news->MoveNext();
}	//end while
} else {
$articlesNotFound = true;
}
?>