<?php
// ClanSphere 2010 - www.clansphere.net
// $Id$
require_once 'mods/board/functions.php';
$cs_option = cs_sql_option(__FILE__, 'board');
$data = array();
$toplist = toplist_comments(0, $cs_option['max_navtop']);
$data['top'] = '';
if (!empty($toplist)) {
$run = 0;
foreach ($toplist as $user_data) {
$data['top'][$run]['users'] = empty($user_data['users_nick']) ? '' : cs_user($user_data['users_id'], $user_data['users_nick'], $user_data['users_active'], $user_data['users_delete']);
$data['top'][$run]['comments'] = $user_data['num_comments'];
$run++;
}
}
echo cs_subtemplate(__FILE__, $data, 'board', 'navtop');
<?php
// ClanSphere 2010 - www.clansphere.net
// $Id$
$cs_lang = cs_translate('board');
require_once 'mods/board/functions.php';
$data = array();
$data['stats']['topics'] = cs_sql_count(__FILE__, 'threads');
$data['stats']['posts'] = cs_sql_count(__FILE__, 'comments', 'comments_mod = \'board\'');
$data['stats']['users'] = cs_sql_count(__FILE__, 'users', 'users_active = 1 AND users_delete = 0');
$data['stats']['categories'] = cs_sql_count(__FILE__, 'categories', 'categories_mod = \'board\'');
$data['stats']['boards'] = cs_sql_count(__FILE__, 'board');
$data['stats']['users_active'] = cs_sql_count(__FILE__, 'comments', 'comments_mod = \'board\'', 'users_id');
$user = toplist_comments(0, 3);
$data['stats']['toplist'] = '';
if (!empty($user)) {
foreach ($user as $users_data) {
$data['stats']['toplist'] .= empty($users_data['users_nick']) ? '- (' . $users_data['num_comments'] . ' ' . $cs_lang['posts'] . '), ' : cs_user($users_data['users_id'], $users_data['users_nick'], $users_data['users_active'], $users_data['users_delete']) . ' (' . $users_data['num_comments'] . ' ' . $cs_lang['posts'] . '), ';
}
$data['stats']['toplist'] = substr($data['stats']['toplist'], 0, -2);
}
$tables = 'threads t INNER JOIN {pre}_board b ON t.board_id = b.board_id ' . 'AND b.board_access <= \'' . $account['access_board'] . '\' AND b.board_pwd = \'\' ' . 'INNER JOIN {pre}_comments cms ON cms.comments_mod = \'board\' ' . 'AND cms.comments_fid = t.threads_id GROUP BY t.threads_id, t.threads_comments, t.threads_headline';
$cells = 't.threads_id AS threads_id, t.threads_comments AS threads_comments, ';
$cells .= 't.threads_headline AS threads_headline, COUNT(cms.comments_id) AS comments';
$select = cs_sql_select(__FILE__, $tables, $cells, 0, 'comments DESC');
$data['stats']['longest_thread'] = $select['threads_headline'];
$data['stats']['longest_thread_posts'] = $select['comments'];
$data['link']['longest_thread'] = cs_url('board', 'thread', 'where=' . $select['threads_id']);
$data['stats']['average_posts'] = !empty($data['stats']['topics']) ? round($data['stats']['posts'] / $data['stats']['topics'], 2) : 0;
echo cs_subtemplate(__FILE__, $data, 'board', 'stats');
<?php
// ClanSphere 2010 - www.clansphere.net
// $Id$
require_once 'mods/board/functions.php';
$start = empty($_GET['start']) ? 0 : (int) $_GET['start'];
$array_result = array();
$toplist = array();
$cs_ranks = cs_sql_select(__FILE__, 'boardranks', 'boardranks_min, boardranks_name', 0, 'boardranks_min ASC', 0, 0);
$toplist = toplist_comments($start, $account['users_limit']);
$count = cs_sql_count(__FILE__, 'comments', 'comments_mod = \'board\'', 'users_id');
$data = array();
$data['pages']['list'] = cs_pages('board', 'toplist', $count, $start);
$i = 0;
if (!empty($toplist)) {
foreach ($toplist as $users_data) {
if ($users_data['users_id'] != 0) {
//dont list comments of visitors
$data['toplist'][$i]['user'] = empty($users_data['users_nick']) ? '' : cs_user($users_data['users_id'], $users_data['users_nick'], $users_data['users_active'], $users_data['users_delete']);
$data['toplist'][$i]['number'] = $i + $start + 1;
$data['toplist'][$i]['rank'] = cs_secure(getRankTitle($users_data['num_comments'], $cs_ranks));
$data['toplist'][$i]['class'] = $users_data['users_id'] != $account['users_id'] ? 'leftb' : 'leftc';
$data['toplist'][$i]['comments'] = $users_data['num_comments'];
$i++;
}
}
} else {
$data['toplist'] = array();
}
echo cs_subtemplate(__FILE__, $data, 'board', 'toplist');