Clansphere :: FREE Clan Content Management System

|

<?php

$cs_lang = cs_translate('blog');

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

$start = empty($_REQUEST['start']) ? 0 : $_REQUEST['start'];
$cs_sort[1] = 'blog_time DESC';
$cs_sort[2] = 'blog_time ASC';
$cs_sort[3] = 'blog_headline DESC';
$cs_sort[4] = 'blog_headline ASC';
$cs_sort[5] = 'users_name DESC';
$cs_sort[6] = 'users_name ASC';
$sort = empty($_REQUEST['sort']) ? 1 : $_REQUEST['sort'];
$order = $cs_sort[$sort];

$data['lang']['all'] = $cs_lang['total'].':';
$join = 'blog blg INNER JOIN {pre}_categories cat ON blg.categories_id = cat.categories_id INNER JOIN {pre}_users usr ON blg.users_id = usr.users_id';
$data['head']['blog_count'] = cs_sql_count(__FILE__,$join,$where,'blog_id');
$data['head']['pages'] = cs_pages('blog','list',$data['head']['blog_co unt'],$start,$cat_id,$sort);
$data['lang']['category'] = $cs_lang['category'];
$blogmod = "categories_mod = 'blog' AND categories_access <= '" . $account['access_news'] . "'";
$categories_data = cs_sql_select(__FILE__,'categories','*',$blogmod,'categories_name',0,0);
$data['head']['dropdown'] = cs_dropdown('where','categories_name',$categories_data,$cat_ id,'categories_id');
$data['head']['button'] = cs_html_vote('submit',$cs_lang['show'],'submit');

$select = 'blg.blog_text AS blog_text, blg.blog_headline AS blog_headline, blg.blog_time AS blog_time, blg.blog_id AS blog_id, blg.users_id AS users_id, usr.users_nick AS users_nick';
$cs_blog = cs_sql_select(__FILE__,$join,$select,$where,$order,$start,$account['users_l imit']);
$blog_loop = count($cs_blog);

$data['sort']['blog_time'] = cs_sort('blog','list',$start,$cat_id,1,$sort);
$data['lang']['date'] = $cs_lang['date'];
$data['sort']['blog_headline'] = cs_sort('blog','list',$start,$cat_id,3,$sort);
$data['lang']['headline'] = $cs_lang['headline'];
$data['sort']['users_name'] = cs_sort('blog','list',$start,$cat_id,3,$sort);
$data['lang']['creator'] = $cs_lang['creator'];



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

$cs_blog[$run]['blog_time'] = cs_date('unix',$cs_blog[$run]['blog_time'],1,1);
$sec_head = cs_secure($cs_blog[$run]['blog_headline']);
$cs_blog[$run]['blog_headline'] = cs_link($sec_head,'blog','view','id=' . $cs_blog[$run]['blog_id']);
$cs_blog[$run]['users_nick'] = cs_secure($cs_blog[$run]['users_nick']);
$cs_blog[$run]['blog_text'] = cs_secure($cs_blog[$run]['blog_text'],1,1,1,1);
}

$data['blog'] = $cs_blog;
echo cs_subtemplate(__FILE__,$data,'blog','navlist1');

?>

|

27.10.2008 um 11:35 Uhr

18.10.2008 um 20:43 Uhr

14.10.2008 um 11:23 Uhr

13.10.2008 um 22:51 Uhr

13.10.2008 um 12:20 Uhr

|

{loop:blog}
{blog:blog_time}
<br />
<a href="blog.php?mod=blog&action=view&id={blog:blog_id}" title="{blog:blog_headline}"></a>
<br />
{stop:blog}

|

|