|

|

|

<?php
// ClanSphere 2010 - www.clansphere.net
// $Id$

$cs_lang = cs_translate('news');
$data = array();
$data2 = array();
$cs_post = cs_post('where');
$cs_get = cs_get('where');

require_once 'mods/categories/functions.php';

$cat_id = empty($cs_get['where']) ? 0 : $cs_get['where'];
if (!empty($cs_post['where'])) $cat_id = $cs_post['where'];

$cs_option = cs_sql_option(__FILE__, 'news');
$abcode = explode(",", $cs_option['abcode']);

$where = "nws.news_public = 1 AND cat.categories_access <= " . $account['access_news'];
if(!empty($cat_id)) {
$cat_where = 'categories_subid = ' . $cat_id;
$categories = cs_sql_select(__FILE__,'categories','categories_id',$cat_where,0,0,0);
if(!empty($categories)) {
$where .= " AND (cat.categories_id = '" . $cat_id . "'";
for($a=0; $a<count($categories); $a++) {
$where .= " OR cat.categories_id = '" . $categories[$a]['categories_id'] . "'";
}
$where .= ")";
}
else {
$where .= " AND cat.categories_id = '" . $cat_id . "'";
}

}
$start = empty($_REQUEST['start']) ? 0 : (int)$_REQUEST['start'];

$data['cats']['dropdown'] = cs_categories_dropdown2('news', $cat_id,0,'where');
$data['news']['facebook'] = cs_html_fb(urlencode('http://'.$_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI']));

$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, $cs_option['max_recent']);

$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,';
$select .= ' nws.news_pictures AS news_pictures, nws.users_id AS users_id, usr.users_nick AS users_nick, usr.users_active AS users_active, usr.users_delete AS users_delete, nws.categories_id AS ';
$select .= 'categories_id, cat.categories_picture AS categories_picture, cat.categories_name AS categories_name, nws.news_mirror AS news_mirror, nws.news_mirror_name AS news_mirror_name, nws.news_readmore AS news_readmore, nws.news_readmore_active AS news_readmore_active';
$order = 'news_attached DESC, news_time DESC';
$cs_news = cs_sql_select(__FILE__, $from, $select, $where, $order, $start, $cs_option['max_recent']);
$cs_newslist = cs_sql_select(__FILE__, $from, $select, $where, $order, $start, 4);

$newslist_loop = count($cs_newslist);

for($run2 = 0; $run2 < $newslist_loop; $run2++) {
$cs_newslist[$run2]['newslist_headline'] = cs_secure($cs_newslist[$run2]['news_headline']);
$cs_newslist[$run2]['newslist_time'] = cs_date('unix', $cs_newslist[$run2]['news_time'], 0);
$cs_newslist[$run2]['comm'] = cs_url('news', 'view', 'id=' . $cs_newslist[$run2]['news_id'] . '&amp;start=' . $start . '#com' . $cs_news_com_count);
}

if($cs_option['max_recent'] == '1') {
$anews = array();
array_push($anews,$cs_news);
unset($cs_news);
$cs_news = $anews;
$news_loop = 1;
}
else {
$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'], 0);
$cs_news[$run]['facebook'] = cs_html_fb(cs_url('news', 'view', 'id=' . $cs_news[$run]['news_id']));

if(empty($cs_news[$run]['news_readmore_active'])) {
$cs_news[$run]['news_readmore'] = '';
$cs_news[$run]['if']['readmore'] = false;
$cs_news[$run]['news_text'] = cs_secure($cs_news[$run]['news_text'], $abcode[0], $abcode[1], $abcode[2], $abcode[3], $abcode[4]);
}
else {
$cs_news[$run]['news_readmore'] = cs_secure($cs_news[$run]['news_readmore'], $abcode[0], $abcode[1], $abcode[2], $abcode[3], $abcode[4]);
$cs_news[$run]['if']['readmore'] = true;
$cs_news[$run]['news_text'] = '';
}

$cs_user = cs_secure($cs_news[$run]['users_nick']);
$cs_news[$run]['users_link'] = cs_user($cs_news[$run]['users_id'],$cs_news[$run]['users_nick' ], $cs_news[$run]['users_active'], $cs_news[$run]['users_delete']);
$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', 'id=' . $cs_news[$run]['news_id'] . '&amp;start=' . $start . '#com' . $cs_news_com_count);
$cs_news[$run]['comm'] = cs_url('news', 'view', 'id=' . $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'];

$cs_news[$run]['pictures'] = '';
if(!empty($cs_news[$run]['news_pictures'])) {
$news_pics = explode("\n", $cs_news[$run]['news_pictures']);
foreach ($news_pics as $pic) {
$link = cs_html_img('uploads/news/picture-' . $pic);
$path = $cs_main['php_self']['dirname'];
$cs_news[$run]['pictures'] .= cs_html_img('uploads/news/picture-' . $pic);
}
}

$cs_news[$run]['if']['show'] = false;

if(!empty($cs_news[$run]['news_mirror'])) {
$cs_news[$run]['if']['show'] = true;

$temp_mirror = explode("\n", $cs_news[$run]['news_mirror']);
$temp_mirror_name = explode("\n", $cs_news[$run]['news_mirror_name']);

$tpl_run = 0;
for($run_mirror=1; $run_mirror < count($temp_mirror); $run_mirror++) {
$num = $run_mirror;

if($run_mirror == (count($temp_mirror) - 1)) {
$cs_news[$run]['mirror'][$tpl_run]['dot'] = '';
}
elseif(!empty($run_mirror)) {
$cs_news[$run]['mirror'][$tpl_run]['dot'] = ' - ';
}
else {
$cs_news[$run]['mirror'][$tpl_run]['dot'] = ' - ';
}
$url = strpos($temp_mirror[$run_mirror],'://') === false ? 'http://' . $temp_mirror[$run_mirror] : $temp_mirror[$run_mirror];
$cs_news[$run]['mirror'][$tpl_run]['news_mirror'] = cs_html_link($url,$temp_mirror_name[$run_mirror]);
$tpl_run++;
}
}
}

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

|

|

|

|

|

|

Greetz Swifter

Wenn du dich klein, nutzlos, beleidigt und depressiv fühlst, denke immer daran: Du warst einmal das schnellste und erfolgreichste Spermium deiner Gruppe!

|