<?php
// bx clanportal - www.bxcp.com
// $Id: navlist.php 196 2006-08-13 00:53:13Z hajo $

$bx_lang = bx_translate('news','navlist');

$select = 'news_id, news_headline, news_time, news_text';
$public = 'news_public > 0';
$order = 'news_time DESC';
$bx_news = bx_sql_select(__FILE__,'news',$select,$public,$order,0,4);

if(empty($bx_news)) {
echo $bx_lang['no_news'];
}
else {
foreach ($bx_news AS $news) {
echo bx_date('unix',$news['news_time'],1);
echo bx_html_br(1);
$headline = strlen($news['news_headline']) <= 15 ? $news['news_headline'] :
substr($news['news_headline'],0,15) . '...';
$headline = bx_secure($headline);
echo bx_html_br(1);
$text = strlen($news['news_text']) <= 150 ? $news['news_text'] :
substr($news['news_text'],0,150) . '...';

$more = 'id=' . $news['news_id'];
echo bx_link($headline,'news','view',$more,0,bx_secure($news[' news_headline']));
echo bx_html_br(2);
echo bx_link($text,'news','view',$more,0,bx_secure($news['ne ws_text']));
echo bx_html_br(1);

}
}

?>