<?php
// ClanSphere 2010 - www.clansphere.net
// $Id$
$cs_lang = cs_translate('count');
$start = empty($_REQUEST['start']) ? 0 : $_REQUEST['start'];
$cs_sort[1] = 'count_time DESC';
$cs_sort[2] = 'count_time ASC';
$cs_sort[3] = 'count_id DESC';
$cs_sort[4] = 'count_id ASC';
$sort = empty($_REQUEST['sort']) ? 1 : $_REQUEST['sort'];
$order = $cs_sort[$sort];
$counter_count = cs_sql_count(__FILE__, 'count');
$data = array();
$data['head']['counter_count'] = $counter_count;
$data['head']['counter_pages'] = cs_pages('count', 'manage', $counter_count, $start);
$data['head']['message'] = cs_getmsg();
$data['sort']['count_time'] = cs_sort('count', 'manage', $start, 0, 1, $sort);
$data['sort']['count_id'] = cs_sort('count', 'manage', $start, 0, 3, $sort);
$cs_counter = cs_sql_select(__FILE__, 'count', '*', 0, $order, $start, $account['users_limit']);
$count_loop = count($cs_counter);
$data['count'] = array();
for ($run = 0; $run < $count_loop; $run++) {
$data['count'][$run]['count_id'] = $cs_counter[$run]['count_id'];
$data['count'][$run]['count_ip'] = $cs_counter[$run]['count_ip'];
$data['count'][$run]['count_locate'] = $cs_counter[$run]['count_location'];
$data['count'][$run]['count_time'] = cs_date('unix', $cs_counter[$run]['count_time'], 1);
}
echo cs_subtemplate(__FILE__, $data, 'count', 'manage');
$order = $cs_sort[$sort];
$user_gb = empty($_POST['user_gb']) ? 0 : $_POST['user_gb'];
if (empty($user_gb)) {
$user_gb = empty($_GET['user_gb']) ? 0 : $_GET['user_gb'];
}
if (!empty($user_gb)) {
$where = "users_nick = '" . cs_sql_escape($user_gb) . "'";
$cs_user = cs_sql_select(__FILE__, 'users', 'users_id', $where);
$id = $cs_user['users_id'];
}
$where = "gbook_users_id ='" . $id . "'";
$gbook_count = cs_sql_count(__FILE__, 'gbook', $where);
$data['head']['count'] = $gbook_count;
$data['head']['pages'] = cs_pages('gbook', 'manage', $gbook_count, $start, $id, $sort);
$data['head']['user_gb'] = empty($user_gb) ? '' : $user_gb;
$data['head']['getmsg'] = cs_getmsg();
$data['sort']['email'] = cs_sort('gbook', 'manage', $start, $id, 3, $sort);
$data['sort']['time'] = cs_sort('gbook', 'manage', $start, $id, 1, $sort);
$from = 'gbook gbk LEFT JOIN {pre}_users usr ON gbk.users_id = usr.users_id';
$select = 'gbk.gbook_id AS gbook_id, gbk.users_id AS users_id, gbk.gbook_time AS gbook_time, gbk.gbook_nick AS gbook_nick, ';
$select .= 'gbk.gbook_email AS gbook_email, gbk.gbook_lock AS gbook_lock, gbk.gbook_ip AS gbook_ip, ';
$select .= 'usr.users_nick AS users_nick, usr.users_email AS users_email';
$cs_gbook = cs_sql_select(__FILE__, $from, $select, $where, $order, $start, $account['users_limit']);
$gbook_loop = count($cs_gbook);
for ($run = 0; $run < $gbook_loop; $run++) {
if ($cs_gbook[$run]['users_id'] > 0) {
$gbook[$run]['nick'] = cs_secure($cs_gbook[$run]['users_nick']);
$gbook[$run]['email'] = cs_secure($cs_gbook[$run]['users_email']);
} else {
$gbook[$run]['nick'] = cs_secure($cs_gbook[$run]['gbook_nick']);
$gbook[$run]['email'] = cs_secure($cs_gbook[$run]['gbook_email']);
<?php
// ClanSphere 2010 - www.clansphere.net
// $Id$
$cs_lang = cs_translate('banners');
$start = empty($_REQUEST['start']) ? 0 : $_REQUEST['start'];
$cs_sort[1] = 'banners_name DESC';
$cs_sort[2] = 'banners_name ASC';
$cs_sort[3] = 'banners_order DESC';
$cs_sort[4] = 'banners_order ASC';
$sort = empty($_REQUEST['sort']) ? 2 : $_REQUEST['sort'];
$order = $cs_sort[$sort];
$banners_count = cs_sql_count(__FILE__, 'banners');
$data['count']['all'] = $banners_count;
$data['pages']['list'] = cs_pages('banners', 'manage', $banners_count, $start, 0, $sort);
$data['lang']['getmsg'] = cs_getmsg();
$select = 'banners_id, banners_name, banners_order';
$cs_banners = cs_sql_select(__FILE__, 'banners', $select, 0, $order, $start, $account['users_limit']);
$banners_loop = count($cs_banners);
$data['sort']['name'] = cs_sort('banners', 'manage', $start, 0, 1, $sort);
$data['sort']['order'] = cs_sort('banners', 'manage', $start, 0, 3, $sort);
if (empty($banners_loop)) {
$data['banners'] = '';
}
for ($run = 0; $run < $banners_loop; $run++) {
$data['banners'][$run]['name'] = cs_secure($cs_banners[$run]['banners_name']);
$data['banners'][$run]['order'] = cs_secure($cs_banners[$run]['banners_order']);
$data['banners'][$run]['edit'] = cs_url('banners', 'edit', 'id=' . $cs_banners[$run]['banners_id']);
$data['banners'][$run]['remove'] = cs_url('banners', 'remove', 'id=' . $cs_banners[$run]['banners_id']);
}
echo cs_subtemplate(__FILE__, $data, 'banners', 'manage');
$medalsuser_id = cs_sql_escape($_GET['delete']);
cs_sql_delete(__FILE__, 'medalsuser', $medalsuser_id);
cs_redirect($cs_lang['del_true'], 'medals', 'user', 'where=' . $medals_id);
}
$start = empty($_GET['start']) ? 0 : $_GET['start'];
$cs_sort[1] = 'md.medalsuser_date DESC';
$cs_sort[2] = 'md.medalsuser_date ASC';
$cs_sort[3] = 'usr.users_nick DESC';
$cs_sort[4] = 'usr.users_nick ASC';
$sort = empty($_GET['sort']) ? 1 : $_GET['sort'];
$order = $cs_sort[$sort];
$tables = 'medalsuser md LEFT JOIN {pre}_users usr ON usr.users_id = md.users_id';
$cells = 'usr.users_nick AS users_nick, md.users_id AS users_id, usr.users_active AS users_active, usr.users_delete AS users_delete, ';
$cells .= 'md.medals_id AS medals_id, md.medalsuser_date AS medalsuser_date, md.medalsuser_id AS medalsuser_id';
$where = 'medals_id = ' . $medals_id . '';
$data['medals_user'] = array();
$data['medals_user'] = cs_sql_select(__FILE__, $tables, $cells, $where, $order, $start, $account['users_limit']);
$data['count']['medals_user'] = count($data['medals_user']);
$data['count']['all_medals_user'] = cs_sql_count(__FILE__, 'medalsuser', $where);
$data['sort']['date'] = cs_sort('medals', 'user', $start, $medals_id, 1, $sort);
$data['sort']['users_nick'] = cs_sort('medals', 'user', $start, $medals_id, 3, $sort);
$data['pages']['list'] = cs_pages('medals', 'user', $data['count']['all_medals_user'], $start, $medals_id, $sort);
for ($i = 0; $i < $data['count']['medals_user']; $i++) {
$data['medals_user'][$i]['user'] = cs_user($data['medals_user'][$i]['users_id'], $data['medals_user'][$i]['users_nick'], $data['medals_user'][$i]['users_active'], $data['medals_user'][$i]['users_delete']);
$data['medals_user'][$i]['remove_url'] = cs_url('medals', 'user', 'where=' . $data['medals_user'][$i]['medals_id'] . '&delete=' . $data['medals_user'][$i]['medalsuser_id']);
$data['medals_user'][$i]['medals_date'] = cs_date('unix', $data['medals_user'][$i]['medalsuser_date'], 1);
}
$data['medals']['id'] = $medals_id;
$data['message']['medals'] = cs_getmsg();
$data['form']['dirname'] = $cs_main['php_self']['dirname'];
echo cs_subtemplate(__FILE__, $data, 'medals', 'user');
$data['wars'] = $cs_rounds;
$cs_wars = cs_sql_select(__FILE__, 'wars', 'games_id', "wars_id = '" . $wars_id . "'");
$cs_maps = cs_sql_select(__FILE__, 'maps', 'maps_name, maps_id', "games_id = '" . $cs_wars['games_id'] . "'", 'maps_name', 0, 0);
$i = 0;
if (!empty($cs_maps)) {
foreach ($cs_maps as $map) {
$sel = $map['maps_id'] == $cs_rounds['maps_id'] ? 1 : 0;
$data['map'][$i]['sel'] = cs_html_option($map['maps_name'], $map['maps_id'], $sel);
$i++;
}
}
$data['wars']['new_map'] = $new_map;
$data['abcode']['smileys'] = cs_abcode_smileys('rounds_description');
$data['abcode']['features'] = cs_abcode_features('rounds_description');
$data['wars']['id'] = $wars_id;
$data['get']['msg'] = cs_getmsg();
$tables = 'rounds rnd LEFT JOIN {pre}_maps mps ON rnd.maps_id = mps.maps_id';
$cells = 'rnd.rounds_id AS rounds_id, rnd.rounds_score1 AS rounds_score1, ';
$cells .= 'rnd.rounds_score2 AS rounds_score2, mps.maps_name AS maps_name, ';
$cells .= 'rnd.rounds_order AS rounds_order';
$sort = 'rnd.rounds_order ASC, rnd.rounds_id ASC';
$cs_rounds = cs_sql_select(__FILE__, $tables, $cells, 'rnd.wars_id = \'' . $wars_id . '\'', $sort, 0, 0);
$count = count($cs_rounds);
if (!empty($cs_rounds)) {
$data['if']['rounds'] = true;
$img_up = cs_html_img('symbols/clansphere/up_arrow.png');
$img_down = cs_html_img('symbols/clansphere/down_arrow.png');
$run = 0;
$run2 = 0;
foreach ($cs_rounds as $round) {
$run2++;
<?php
// ClanSphere 2010 - www.clansphere.net
// $Id$
$cs_lang = cs_translate('wars');
$wars['if']['squadmember'] = FALSE;
$wars_id = empty($_REQUEST['where']) ? (int) $_GET['id'] : (int) $_REQUEST['where'];
$cells = 'games_id, categories_id, clans_id, wars_opponents, squads_id, wars_status, wars_players1, wars_players2, ';
$cells .= 'wars_score1, wars_score2, wars_url, wars_pictures, wars_report, wars_report2, wars_date, wars_status, wars_close';
$cs_wars = cs_sql_select(__FILE__, 'wars', $cells, "wars_id = '" . $wars_id . "'");
$wars['head']['topline'] = $cs_lang['body_view'];
$wars['lang']['getmsg'] = cs_getmsg();
$gameicon = 'uploads/games/' . $cs_wars['games_id'] . '.gif';
$where = "games_id = '" . $cs_wars['games_id'] . "'";
$cs_game = cs_sql_select(__FILE__, 'games', 'games_name, games_id', $where);
$wars['game']['icon'] = file_exists($gameicon) ? cs_html_img($gameicon) : '';
$wars['game']['link'] = cs_link($cs_game['games_name'], 'games', 'view', 'id=' . $cs_game['games_id']);
$where = "categories_id = '" . $cs_wars['categories_id'] . "'";
$cs_cat = cs_sql_select(__FILE__, 'categories', 'categories_name, categories_id', $where);
$wars['lang']['category'] = $cs_lang['category'];
$wars['category']['link'] = cs_link($cs_cat['categories_name'], 'categories', 'view', 'id=' . $cs_cat['categories_id']);
$where = "clans_id = '" . $cs_wars['clans_id'] . "'";
$cs_clan = cs_sql_select(__FILE__, 'clans', 'clans_name, clans_picture, clans_country, clans_id', $where);
$wars['enemy']['link'] = cs_link(cs_secure($cs_clan['clans_name']), 'clans', 'view', 'id=' . $cs_clan['clans_id']);
$wars['enemy']['logo'] = !empty($cs_clan['clans_picture']) ? cs_html_img('uploads/clans/' . $cs_clan['clans_picture']) : $cs_lang['no_logo'];
if (!empty($cs_wars['wars_opponents'])) {
$wars['wars']['opponents'] = cs_secure($cs_wars['wars_opponents'], 0, 0, 0);
} else {
$wars['wars']['opponents'] = '-';
}
if (!empty($cs_clan['clans_country'])) {
} else {
$data['thread']['prev_empty'] = '';
}
/*if($account['access_id'] >= 5 OR !empty($thread_mods['boardmods_modpanel']))
{
echo ' - ' .cs_link($cs_lang['modpanel'],'board','modpanel','id=' .$id);
}*/
//vorheriges - letztes thema
$data['thread']['categories_link'] = cs_link($data['thread']['categories_name'], 'board', 'list', 'id=' . $data['thread']['categories_id']);
$data['thread']['board_link'] = cs_link(cs_secure($data['thread']['board_name']), 'board', 'listcat', 'id=' . $data['thread']['board_id']);
#$arimportant = array('',$cs_lang['important']);
$important = $data['thread']['threads_important'];
#$data['thread']['abo'] = cs_secure($arimportant[$important],1) . ' ';
$cs_main['page_title'] = $data['thread']['threads_headline'];
$data['thread']['thread_link'] = cs_secure($data['thread']['threads_headline']);
$data['thread']['getmessage'] = cs_getmsg();
$data['thread']['sum'] = $sum;
$data['thread']['pages'] = cs_pages($mod, $action, $sum, $start, $id);
$data['if']['vote'] = false;
$data['if']['vote_result'] = false;
$data['if']['vote_several'] = false;
if (!empty($cs_thread_votes)) {
if ($account['access_board'] >= $cs_thread_votes['boardvotes_access'] or $time_now <= $cs_thread_votes['boardvotes_end']) {
$votes_error = '';
$users_ip = cs_getip();
$users_id = $account['users_id'];
$where = "voted_mod = 'board' AND voted_fid = " . (int) $id . " AND voted_ip = '" . cs_sql_escape($users_ip) . "'";
if ($users_id > 0) {
$where = "voted_mod = 'board' AND voted_fid = " . (int) $id . " AND users_id = " . (int) $users_id;
}
$checkit_userip = cs_sql_count(__FILE__, 'voted', $where);
<?php
// ClanSphere 2010 - www.clansphere.net
// $Id$
$cs_lang = cs_translate('users');
$head = array('mod' => $cs_lang['mod_name'], 'action' => $cs_lang['settings'], 'topline' => $cs_lang['settings_info'], 'message' => cs_getmsg());
$opt_array = array($cs_lang['profile'] => array('file' => 'profile', 'icon' => 'personal', 'name' => $cs_lang['profile'], 'show' => array('users/settings' => 1)), $cs_lang['picture'] => array('file' => 'picture', 'icon' => 'camera_unmount', 'name' => $cs_lang['picture'], 'show' => array('users/settings' => 1)), $cs_lang['password'] => array('file' => 'password', 'icon' => 'password', 'name' => $cs_lang['password'], 'show' => array('users/settings' => 1)), $cs_lang['setup'] => array('file' => 'setup', 'icon' => 'looknfeel', 'name' => $cs_lang['setup'], 'show' => array('users/settings' => 1)), $cs_lang['close'] => array('file' => 'close', 'icon' => 'gpg', 'name' => $cs_lang['close'], 'show' => array('users/settings' => 1)), $cs_lang['avatar'] => array('dir' => 'board', 'file' => 'avatar', 'icon' => 'babelfish', 'name' => $cs_lang['avatar'], 'show' => array('users/settings' => 1)), $cs_lang['signature'] => array('dir' => 'board', 'file' => 'signature', 'icon' => 'colors', 'name' => $cs_lang['signature'], 'show' => array('users/settings' => 1)));
require_once 'mods/clansphere/functions.php';
echo cs_manage('users', 'settings', 'users', 'center', $opt_array, $head);
function cs_comments_view($com_fid, $mod, $action, $sum, $asc = true, $limit = 0)
{
$cs_lang = cs_translate('comments');
$options = cs_sql_option(__FILE__, 'comments');
global $account, $cs_main;
$class = 'leftb';
$start = isset($_REQUEST['start']) ? $_REQUEST['start'] : 0;
settype($start, 'integer');
settype($com_fid, 'integer');
settype($asc, 'boolean');
settype($limit, 'integer');
$data['comments']['sum'] = $sum;
$data['comments']['message'] = cs_getmsg();
$data['comments']['pages'] = cs_pages($mod, $action, $sum, $start, $com_fid);
if ($mod == 'board' and !empty($sum)) {
$data['if']['form'] = TRUE;
} else {
$data['if']['form'] = FALSE;
}
$where = "comments_mod = '" . cs_sql_escape($mod) . "' AND comments_fid = '" . $com_fid . "'";
$from = 'comments com LEFT JOIN {pre}_users usr ON com.users_id = usr.users_id ';
$select = 'com.comments_id AS comments_id, com.comments_ip AS comments_ip, com.comments_guestnick AS comments_guestnick, com.comments_time AS comments_time, com.comments_text AS comments_text, com.comments_edit AS comments_edit, com.users_id AS users_id, usr.users_nick as users_nick, usr.users_laston as users_laston, usr.users_place AS users_place, usr.users_country AS users_country, usr.users_avatar AS users_avatar, usr.users_hidden AS users_hidden, usr.users_active AS users_active, usr.users_delete AS users_delete, usr.users_invisible AS users_invisible';
$order = $asc == true ? 'comments_id ASC' : 'comments_id DESC';
$limit = !empty($limit) ? $limit : $account['users_limit'];
$cs_com = cs_sql_select(__FILE__, $from, $select, $where, $order, $start, $limit);
$com_loop = count($cs_com);
for ($run = 0; $run < $com_loop; $run++) {
$class = $class == 'leftb' ? 'leftc' : 'leftb';
$current = $start + $run + 1;
$com[$run]['class'] = $class;
if (empty($cs_com[$run]['users_id'])) {
$com[$run]['if']['guest'] = TRUE;
$com[$run]['if']['user'] = FALSE;
$com[$run]['guestnick'] = cs_secure($cs_com[$run]['comments_guestnick']);
} else {
$com[$run]['if']['guest'] = FALSE;
$com[$run]['if']['user'] = TRUE;
$src = 'symbols/countries/' . $cs_com[$run]['users_country'] . '.png';
$com[$run]['flag'] = cs_html_img($src, 11, 16);
$com[$run]['user'] = cs_user($cs_com[$run]['users_id'], $cs_com[$run]['users_nick'], $cs_com[$run]['users_active'], $cs_com[$run]['users_delete']);
$com[$run]['status'] = cs_userstatus($cs_com[$run]['users_laston'], $cs_com[$run]['users_invisible']);
$com[$run]['laston'] = !empty($cs_com[$run]['users_invisible']) ? '--' : cs_date('unix', $cs_com[$run]['users_laston']);
$com_place = cs_secure($cs_com[$run]['users_place']);
$hidden = explode(',', $cs_com[$run]['users_hidden']);
if (in_array('users_place', $hidden)) {
$com_place = ($account['access_users'] > 4 or $cs_com[$run]['users_id'] == $account['users_id']) ? cs_html_italic(1) . $com_place . cs_html_italic(0) : '';
}
$com[$run]['avatar'] = empty($options['show_avatar']) || empty($cs_com[$run]['users_avatar']) ? '' : cs_html_img('uploads/board/' . $cs_com[$run]['users_avatar']);
$users_place = empty($com_place);
$com[$run]['place'] = !empty($users_place) ? '-' : $cs_com[$run]['users_place'];
$who = "users_id = " . (int) $cs_com[$run]['users_id'];
$count_user_com = cs_sql_count(__FILE__, 'comments', $who);
$com[$run]['posts'] = $count_user_com;
}
$com[$run]['comments_time'] = cs_date('unix', $cs_com[$run]['comments_time'], 1);
$com[$run]['run'] = $asc == true ? $run + 1 : $com_loop - $run;
$com[$run]['current'] = $current;
$com[$run]['comments_text'] = cs_secure($cs_com[$run]['comments_text'], 1, 1);
if (!empty($cs_com[$run]['comments_edit'])) {
$edits = explode('/', $cs_com[$run]['comments_edit']);
$euser = cs_user($edits[0], $edits[1]);
$com[$run]['comments_edit'] = cs_html_br(3);
$com[$run]['comments_edit'] .= cs_html_italic(1);
$com[$run]['comments_edit'] .= sprintf($cs_lang['lastcom'], $euser, cs_date('unix', $edits[2], 1), $edits[3]);
$com[$run]['comments_edit'] .= cs_html_italic(0);
} else {
$com[$run]['comments_edit'] = '';
}
if ($mod == 'board') {
$com[$run]['if']['quote_board'] = TRUE;
$com[$run]['fid'] = $com_fid;
$com[$run]['id'] = $cs_com[$run]['comments_id'];
} else {
$com[$run]['if']['quote_board'] = FALSE;
}
if (!empty($account['users_id']) and $mod != 'board') {
$com[$run]['if']['edit_delete'] = TRUE;
$img_quote = cs_icon('xchat', 16, $cs_lang['quote']);
$com[$run]['edit_delete'] = cs_link($img_quote, $mod, 'com_create', 'id=' . $cs_com[$run]['comments_id'], 0, $cs_lang['quote']);
if ($cs_com[$run]['users_id'] == $account['users_id'] or $account['access_comments'] >= 4) {
$img_edit = cs_icon('edit', 16, $cs_lang['edit']);
$com[$run]['edit_delete'] .= cs_link($img_edit, $mod, 'com_edit', 'id=' . $cs_com[$run]['comments_id'], 0, $cs_lang['edit']);
}
if ($account['access_comments'] >= 5) {
$img_del = cs_icon('editdelete', 16, $cs_lang['remove']);
$com[$run]['edit_delete'] .= cs_link($img_del, $mod, 'com_remove', 'id=' . $cs_com[$run]['comments_id'], 0, $cs_lang['remove']);
}
} else {
$com[$run]['if']['edit_delete'] = FALSE;
}
}
$data['if']['bottom_pages'] = $sum > $com_loop ? TRUE : FALSE;
$data['fquote']['icon'] = 'symbols/' . $cs_main['img_path'] . '/16/xchat.' . $cs_main['img_ext'];
$data['com'] = !empty($com) ? $com : '';
echo cs_subtemplate(__FILE__, $data, 'comments', 'com_view');
}
// ClanSphere 2010 - www.clansphere.net
// $Id$
$cs_lang = cs_translate('votes');
$start = empty($_REQUEST['start']) ? 0 : $_REQUEST['start'];
$cs_sort[1] = 'votes_start DESC';
$cs_sort[2] = 'votes_start ASC';
$cs_sort[3] = 'votes_end DESC';
$cs_sort[4] = 'votes_end ASC';
$cs_sort[5] = 'votes_question DESC';
$cs_sort[6] = 'votes_question ASC';
$sort = empty($_REQUEST['sort']) ? 3 : $_REQUEST['sort'];
$order = $cs_sort[$sort];
$cs_vote = cs_sql_select(__FILE__, 'votes', '*', 0, $order, $start, $account['users_limit']);
$vote_loop = count($cs_vote);
$cs_vote_tpl['head']['votes_count'] = cs_sql_count(__FILE__, 'votes');
$cs_vote_tpl['head']['pages'] = cs_pages('votes', 'manage', $cs_vote_tpl['head']['votes_count'], $start, 0, $sort);
$cs_vote_tpl['head']['message'] = cs_getmsg();
$cs_vote_tpl['sort']['start'] = cs_sort('votes', 'manage', $start, 0, 1, $sort);
$cs_vote_tpl['sort']['end'] = cs_sort('votes', 'manage', $start, 0, 3, $sort);
$cs_vote_tpl['sort']['question'] = cs_sort('votes', 'manage', $start, 0, 5, $sort);
if (empty($vote_loop)) {
$cs_vote_tpl['votes'] = '';
}
for ($run = 0; $run < $vote_loop; $run++) {
$cs_vote_tpl['votes'][$run]['start'] = cs_date('unix', $cs_vote[$run]['votes_start']);
$cs_vote_tpl['votes'][$run]['end'] = cs_date('unix', $cs_vote[$run]['votes_end']);
$cs_vote_tpl['votes'][$run]['question'] = cs_secure($cs_vote[$run]['votes_question']);
$cs_vote_tpl['votes'][$run]['id'] = $cs_vote[$run]['votes_id'];
}
echo cs_subtemplate(__FILE__, $cs_vote_tpl, 'votes', 'manage');
$tables = 'cups cp LEFT JOIN {pre}_games gms ON cp.games_id = gms.games_id';
$cells = 'cp.cups_name AS cups_name, gms.games_name AS games_name, cp.cups_system AS cups_system,
cp.cups_teams AS cups_teams, cp.cups_text AS cups_text, cp.cups_start AS cups_start, cp.cups_checkin AS cups_checkin,
cp.games_id AS games_id, cp.cups_brackets AS cups_brackets, cp.cups_access AS cups_access, cp.cups_id AS cups_id';
$data['cup'] = cs_sql_select(__FILE__, $tables, $cells, 'cp.cups_id = ' . $cups_id . '');
if (empty($data['cup'])) {
cs_redirect($cs_lang['no_selection'], 'cups', 'list');
}
if ($account['access_cups'] < $data['cup']['cups_access'] || $data['cup']['cups_access'] == 0) {
echo $cs_lang['access_denied'];
return;
}
$data['lang']['max_participants'] = $cs_lang['max_' . $data['cup']['cups_system']];
$data['lang']['registered_participants'] = $cs_lang['registered_' . $data['cup']['cups_system']];
$data['lang']['checkedin_participants'] = $cs_lang['checkedin_' . $data['cup']['cups_system']];
$data['var']['message'] = cs_getmsg();
$data['cup']['system'] = $data['cup']['cups_system'] == CS_CUPS_TYPE_TEAMS ? $cs_lang['team_vs_team'] : $cs_lang['user_vs_user'];
switch ($data['cup']['cups_brackets']) {
default:
case CS_CUPS_SYSTEM_KO:
$data['cup']['kind'] = $cs_lang['ko'];
break;
case CS_CUPS_SYSTEM_LB:
$data['cup']['kind'] = $cs_lang['brackets'];
break;
case CS_CUPS_SYSTEM_KO3RD:
$data['cup']['kind'] = $cs_lang['ko3rd'];
break;
}
$data['cup']['reg'] = cs_sql_count(__FILE__, 'cupsquads', 'cups_id = ' . $cups_id);
$data['cup']['checkedin'] = cs_sql_count(__FILE__, 'cupsquads', 'cupsquads_checkedin = 1 AND cups_id = ' . $cups_id);
<?php
// ClanSphere 2010 - www.clansphere.net
// $Id$
$cs_lang = cs_translate('servers');
$data = array();
$start = empty($_REQUEST['start']) ? 0 : $_REQUEST['start'];
$cs_sort[1] = 'servers_name DESC';
$cs_sort[2] = 'servers_name ASC';
$sort = empty($_REQUEST['sort']) ? 2 : $_REQUEST['sort'];
$order = $cs_sort[$sort];
$server_count = cs_sql_count(__FILE__, 'servers');
$data['server']['count'] = $server_count;
$data['server']['pages'] = cs_pages('servers', 'manage', $server_count, $start, 0, $sort);
$data['server']['sort'] = cs_sort('servers', 'manage', $start, 0, 1, $sort);
$data['server']['headmsg'] = cs_getmsg();
$data['if']['viewfsock'] = false;
if (!fsockopen("udp://127.0.0.1", 1)) {
$data['if']['viewfsock'] = true;
}
$from = "servers serv LEFT JOIN {pre}_games gam ON gam.games_id = serv.games_id";
$select = "serv.servers_id servers_id, serv.servers_name servers_name, serv.servers_class servers_class, gam.games_name games_name, ";
$select .= "serv.servers_stats servers_stats";
$cs_server = cs_sql_select(__FILE__, $from, $select, 0, $order, $start, $account['users_limit']);
if (!empty($cs_server)) {
for ($run = 0; $run < count($cs_server); $run++) {
$server_query_ex = explode(";", $cs_server[$run]['servers_class']);
$cs_server[$run]['servers_class'] = $server_query_ex[0];
$cs_server[$run]['servers_game'] = empty($server_query_ex[1]) ? $server_query_ex[0] : $server_query_ex[1];
$data['servers'][$run]['id'] = $cs_server[$run]['servers_id'];
$data['servers'][$run]['name'] = $cs_server[$run]['servers_name'];
<?php
// ClanSphere 2010 - www.clansphere.net
// $Id$
$cs_lang = cs_translate('options');
$head = array('mod' => $cs_lang['options'], 'action' => $cs_lang['head_roots'], 'topline' => $cs_lang['body_roots'], 'message' => cs_getmsg());
require_once 'mods/clansphere/functions.php';
echo cs_manage('options', 'roots', 'clansphere', 'options', 0, $head);
