|

|

<?php
// ClanSphere 2007 - www.clansphere.net
// $Id: recent.php 213 2006-08-15 15:27:56Z hajo $

$cs_lang = cs_translate('news');

$news_limit = 2;

$cat_id = empty($_REQUEST['where']) ? 0 : $_REQUEST['where'];
$where = "nws.news_public > 0 AND cat.categories_access <= '" . $account['access_news'] . "'";
if(!empty($cat_id)) {
settype($cat_id,'integer');
$where .= " AND cat.categories_id = '" . $cat_id . "'";
}
$start = empty($_REQUEST['start']) ? 0 : $_REQUEST['start'];

$newsmod = "categories_mod = 'news' AND categories_access <= '" . $account['access_news'] . "'";
$cat_data = cs_sql_select(__FILE__,'categories','*',$newsmod,'categories_name',0,0);
$data['head']['dropdown'] = cs_dropdown('where','categories_name',$cat_data,$cat_id,' categories_id');
$data['head']['button'] = cs_html_vote('submit',$cs_lang['show'],'submit');
$join = 'news nws INNER JOIN {pre}_categories cat ON nws.categories_id = cat.categories_id';
$news_count = cs_sql_count(__FILE__,$join,$where,'news_id');
$data['head']['pages'] = cs_pages('news','recent',$news_count,$start,$cat_id,0,$news_limit);

$from = 'news nws INNER JOIN {pre}_users usr ON nws.users_id = usr.users_id ';
$from .= 'INNER JOIN {pre}_categories cat ON nws.categories_id = cat.categories_id';
$select = 'nws.news_id AS news_id, nws.news_headline AS news_headline, nws.news_time AS news_time, nws.news_text AS news_text, nws.news_pictures AS news_pictures, nws.users_id AS users_id, usr.users_nick AS users_nick, nws.categories_id AS categories_id, cat.categories_picture AS categories_picture, cat.categories_name AS categories_name';
$order = 'news_attached DESC, news_time DESC';
$cs_news = cs_sql_select(__FILE__,$from,$select,$where,$order,$start,$news_limit);
$news_loop = count($cs_news);

for($run = 0; $run < $news_loop; $run++) {

$cs_news[$run]['news_headline'] = cs_secure($cs_news[$run]['news_headline']);
$cs_news[$run]['news_time'] = cs_date('unix',$cs_news[$run]['news_time'],1);
$cs_news[$run]['news_text'] = cs_secure($cs_news[$run]['news_text'],1,1,1,1);
$cs_user = cs_secure($cs_news[$run]['users_nick']);
$cs_news[$run]['users_link'] = cs_link($cs_user,'users','view','id=' . $cs_news[$run]['users_id']);
$where3 = "comments_mod = 'news' AND comments_fid = '" . $cs_news[$run]['news_id'] . "'";
$cs_news[$run]['comments_count'] = cs_sql_count(__FILE__,'comments',$where3);
$start = floor($cs_news[$run]['comments_count'] / ($account['users_limit'] +1)) * $account['users_limit'];
$cs_news_com_count = $cs_news[$run]['comments_count'] - $start;
$cs_news[$run]['comments_link'] = cs_link($cs_lang['comments'],'news','view','i d=' . $cs_news[$run]['news_id'] . '&amp;start=' . $start . '#com' . $cs_news_com_count);
$cs_news[$run]['categories_name'] = cs_secure($cs_news[$run]['categories_name']);

$cs_news[$run]['if']['catimg'] = empty($cs_news[$run]['categories_picture']) ? false : true;
$cs_news[$run]['url_catimg'] = empty($cs_news[$run]['if']['catimg']) ? '' : 'uploads/categories/'.$cs_news[$run]['categories_picture'];

if(!empty($cs_news[$run]['news_pictures'])) {
$cs_news[$run]['news_text'] .= cs_html_hr('100%');
$news_pics = explode("\n",$cs_news[$run]['news_pictures']);
foreach($news_pics AS $pic) {
$link = cs_html_img('uploads/news/thumb-' . $pic);
$cs_news[$run]['news_text'] .= cs_html_link('uploads/news/picture-' . $pic,$link) . ' ';
}
}
}

$data['news'] = $cs_news;
echo cs_subtemplate(__FILE__,$data,'news','recent');

?>

|

|

|

|