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

$cs_lang = cs_translate('board');
$cs_get = cs_get('catid');
$cs_option = cs_sql_option(__FILE__,'board');
require_once 'mods/board/functions.php';

$cs_usertime = cs_sql_select(__FILE__,'users','users_readtime',"users_ id = '" . $account["users_id"] . "'");
$cs_readtime = cs_time() - $cs_usertime['users_readtime'];

$data = array();

$tables = 'threads thr INNER JOIN {pre}_board frm ON frm.board_id = thr.board_id ';
$tables .= 'LEFT JOIN {pre}_read red ON thr.threads_id = red.threads_id AND red.users_id = \''.$account['users_id'].'\'';
$cells = 'thr.threads_headline AS threads_headline, thr.threads_id AS threads_id, ';
$cells .= 'thr.threads_last_time AS threads_last_time, frm.board_name AS board_name, frm.board_id AS board_id';
$cond = 'thr.threads_ghost = 0 AND frm.board_access <= \''.$account['access_board'].'\' AND frm.board_pwd = \'\'';
if(!empty($account['users_id'])) {
$cond .= ' AND thr.threads_last_time > \'' . $cs_readtime . '\' AND (thr.threads_last_time > red.read_since OR red.threads_id IS NULL)';
}
if(!empty($cs_get['catid'])) {
$cond .= ' AND frm.categories_id = ' . $cs_get['catid'];
}
$order = 'thr.threads_last_time DESC';
$data['threads'] = cs_sql_select(__FILE__,$tables,$cells,$cond,$order,0,$cs_option['max_navlis t']);

if(empty($data['threads'])) {
echo $cs_lang['no_new_posts'];
}
else {
$count_threads = count($data['threads']);

for ($run = 0; $run < $count_threads; $run++) {
$data['threads'][$run]['threads_date'] = cs_date('unix',$data['threads'][$run]['threads_last_tim e'],1);
$data['threads'][$run]['threads_headline_short'] = strlen($data['threads'][$run]['threads_headline']) <= $cs_option['max_headline'] ? $data['threads'][$run]['threads_headline'] : cs_substr($data['threads'][$run]['threads_headline'],0,$cs_o ption['max_headline']-2) . '..';
$data['threads'][$run]['threads_headline_short'] = cs_secure($data['threads'][$run]['threads_headline_short']);
$data['threads'][$run]['threads_headline'] = cs_secure($data['threads'][$run]['threads_headline']);
$data['threads'][$run]['new_posts'] = last_comment($data['threads'][$run]['threads_id'], $account["users_id"], $account['users_limit']);
}
echo cs_subtemplate(__FILE__,$data,'board','navlist');
}

|

|

|