// ClanSphere 2010 - www.clansphere.net // $Id$ $cs_lang = cs_translate('access'); $start = empty($_REQUEST['start']) ? 0 : $_REQUEST['start']; $cs_sort[1] = 'access_name DESC'; $cs_sort[2] = 'access_name ASC'; $cs_sort[3] = 'access_access DESC'; $cs_sort[4] = 'access_access ASC'; $cs_sort[5] = 'access_clansphere DESC'; $cs_sort[6] = 'access_clansphere ASC'; $sort = empty($_REQUEST['sort']) ? 5 : $_REQUEST['sort']; $order = $cs_sort[$sort]; $access_count = cs_sql_count(__FILE__, 'access'); $data['lang']['create'] = cs_url('access', 'create'); $data['lang']['count'] = $access_count; $data['pages']['list'] = cs_pages('access', 'manage', $access_count, $start, 0, $sort); $select = 'access_id, access_name, access_access, access_clansphere'; $cs_access = cs_sql_select(__FILE__, 'access', $select, 0, $order, $start, $account['users_limit']); $access_loop = count($cs_access); $data['lang']['getmsg'] = cs_getmsg(); $data['sort']['name'] = cs_sort('access', 'manage', $start, 0, 1, $sort); $data['sort']['access'] = cs_sort('access', 'manage', $start, 0, 3, $sort); $data['sort']['clansphere'] = cs_sort('access', 'manage', $start, 0, 5, $sort); $img_edit = cs_icon('edit', 16, $cs_lang['edit']); $img_del = cs_icon('editdelete', 16, $cs_lang['remove']); $img_users = cs_icon('kdmconfig', 16, $cs_lang['remove']); if (empty($access_loop)) { $data['access'] = ''; } for ($run = 0; $run < $access_loop; $run++) { $data['access'][$run]['name'] = cs_secure($cs_access[$run]['access_name']);
// ClanSphere 2010 - www.clansphere.net // $Id$ $cs_lang = cs_translate('gbook'); $start = empty($_GET['start']) ? 0 : $_GET['start']; if (!empty($_GET['unhide'])) { cs_sql_update(__FILE__, 'gbook', array('gbook_lock'), array('1'), (int) $_GET['unhide']); cs_redirect($cs_lang['unhide_done'], 'gbook', 'center'); } if (!empty($_GET['hide'])) { cs_sql_update(__FILE__, 'gbook', array('gbook_lock'), array('0'), (int) $_GET['hide']); cs_redirect($cs_lang['hide_done'], 'gbook', 'center'); } $gbook_count = cs_sql_count(__FILE__, 'gbook', "gbook_users_id = '" . $account['users_id'] . "'"); $data['head']['new_entry'] = cs_link($cs_lang['submit'], 'gbook', 'entry', 'id=' . $account['users_id'] . '&from=center'); $data['head']['count'] = $gbook_count; $data['head']['pages'] = cs_pages('gbook', 'center', $gbook_count, $start); $data['head']['getmsg'] = cs_getmsg(); $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_users_id AS gbook_users_id, '; $select .= 'gbk.gbook_nick AS gbook_nick, gbk.gbook_email AS gbook_email, gbk.gbook_icq AS gbook_icq, '; $select .= 'gbk.gbook_jabber AS gbook_jabber, gbk.gbook_skype AS gbook_skype, gbk.gbook_url AS gbook_url, '; $select .= 'gbk.gbook_town AS gbook_town, gbk.gbook_text AS gbook_text, gbk.gbook_lock AS gbook_lock, '; $select .= 'usr.users_nick AS users_nick, usr.users_place AS users_place, usr.users_icq AS users_icq, '; $select .= 'usr.users_jabber AS users_jabber, usr.users_skype AS users_skype, usr.users_email AS users_email, '; $select .= 'usr.users_url AS users_url, usr.users_hidden AS users_hidden, usr.users_active AS users_active, usr.users_delete AS users_delete'; $where = "gbook_users_id = '" . $account['users_id'] . "'"; $order = 'gbk.gbook_id DESC'; $cs_gbook = cs_sql_select(__FILE__, $from, $select, $where, $order, $start, $account['users_limit']); $gbook_loop = count($cs_gbook); $c = 0; for ($run = 0; $run < $gbook_loop; $run++) {
$start = empty($cs_get['start']) ? 0 : $cs_get['start']; if (!empty($cs_post['start'])) { $start = $cs_post['start']; } $sort = empty($cs_get['sort']) ? 2 : $cs_get['sort']; if (!empty($cs_post['sort'])) { $sort = $cs_post['sort']; } $cs_sort[1] = 'linkus_name DESC'; $cs_sort[2] = 'linkus_name ASC'; $cs_sort[3] = 'linkus_banner DESC'; $cs_sort[4] = 'linkus_banner ASC'; $order = $cs_sort[$sort]; $linkus_count = cs_sql_count(__FILE__, 'linkus'); $data['head']['count'] = $linkus_count; $data['head']['pages'] = cs_pages('linkus', 'manage', $linkus_count, $start, 0, $sort); $data['head']['getmsg'] = cs_getmsg(); $data['sort']['name'] = cs_sort('linkus', 'manage', $start, 0, 1, $sort); $data['sort']['banner'] = cs_sort('linkus', 'manage', $start, 0, 3, $sort); $select = 'linkus_id, linkus_name, linkus_banner'; $data['linkus'] = cs_sql_select(__FILE__, 'linkus', $select, 0, $order, $start, $account['users_limit']); $linkus_loop = count($data['linkus']); for ($run = 0; $run < $linkus_loop; $run++) { $data['linkus'][$run]['name'] = cs_secure($data['linkus'][$run]['linkus_name']); $data['linkus'][$run]['banner'] = cs_secure($data['linkus'][$run]['linkus_banner']); $place = 'uploads/linkus/' . $data['linkus'][$run]['linkus_banner']; $mass = getimagesize($place); $data['linkus'][$run]['mass'] = cs_secure($mass[0] . ' x ' . $mass[1]); $data['linkus'][$run]['id'] = $data['linkus'][$run]['linkus_id']; } echo cs_subtemplate(__FILE__, $data, 'linkus', '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');
<?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');
$categories_id = empty($_REQUEST['where']) ? 0 : $_REQUEST['where']; settype($categories_id, 'integer'); $where = empty($categories_id) ? 0 : "categories_id = '" . $categories_id . "'"; $start = empty($_REQUEST['start']) ? 0 : $_REQUEST['start']; $cs_sort[1] = 'quotes_headline DESC'; $cs_sort[2] = 'quotes_headline ASC'; $cs_sort[3] = 'quotes_time DESC'; $cs_sort[4] = 'quotes_time ASC'; $sort = empty($_REQUEST['sort']) ? 3 : $_REQUEST['sort']; $order = $cs_sort[$sort]; $quotes_count = cs_sql_count(__FILE__, 'quotes', $where); $data = array(); $data['url']['form'] = cs_url('quotes', 'manage'); $data['lang']['all'] = $cs_lang['total'] . ': '; $data['head']['count'] = $quotes_count; $data['head']['pages'] = cs_pages('quotes', 'manage', $quotes_count, $start, $categories_id, $sort); $data['head']['message'] = cs_getmsg(); $quotesmod = "categories_mod = 'quotes'"; $categories_data = cs_sql_select(__FILE__, 'categories', '*', $quotesmod, 'categories_name', 0, 0); $data['head']['dropdown'] = cs_dropdown('where', 'categories_name', $categories_data, $categories_id, 'categories_id'); $from = 'quotes qts LEFT JOIN {pre}_users usr ON qts.users_id = usr.users_id'; $select = 'qts.quotes_headline AS quotes_headline, qts.users_id AS users_id, usr.users_nick AS users_nick, usr.users_active AS users_active, usr.users_delete AS users_delete, qts.quotes_time AS quotes_time, qts.quotes_id AS quotes_id'; $cs_quotes = cs_sql_select(__FILE__, $from, $select, $where, $order, $start, $account['users_limit']); $quotes_loop = count($cs_quotes); $data['sort']['quotes_headline'] = cs_sort('quotes', 'manage', $start, $categories_id, 1, $sort); $data['sort']['quotes_time'] = cs_sort('quotes', 'manage', $start, $categories_id, 3, $sort); for ($run = 0; $run < $quotes_loop; $run++) { $cs_quotes[$run]['quotes_headline'] = cs_secure($cs_quotes[$run]['quotes_headline']); $cs_quotes[$run]['url_edit'] = cs_url('quotes', 'edit', 'id=' . $cs_quotes[$run]['quotes_id']); $cs_quotes[$run]['url_remove'] = cs_url('quotes', 'remove', 'id=' . $cs_quotes[$run]['quotes_id']); $cs_quotes[$run]['url_user'] = cs_user($cs_quotes[$run]['users_id'], $cs_quotes[$run]['users_nick'], $cs_quotes[$run]['users_active'], $cs_quotes[$run]['users_delete']);
// ClanSphere 2010 - www.clansphere.net // $Id$ $cs_lang = cs_translate('board'); $data = array(); $start = empty($_REQUEST['start']) ? 0 : $_REQUEST['start']; $cs_sort[1] = 'boardreport_time DESC'; $cs_sort[2] = 'boardreport_time ASC'; $cs_sort[3] = 'boardreport_done DESC, boardreport_time DESC'; $cs_sort[4] = 'boardreport_done ASC, boardreport_time DESC'; $cs_sort[5] = 'threads_headline DESC'; $cs_sort[6] = 'boardreport_time ASC'; $sort = empty($_REQUEST['sort']) ? 1 : $_REQUEST['sort']; $order = $cs_sort[$sort]; $data['lang']['getmsg'] = cs_getmsg(); $data['head']['boardreport_count'] = cs_sql_count(__FILE__, 'boardreport'); $data['head']['pages'] = cs_pages('board', 'reportlist', $data['head']['boardreport_count'], $start, 0, $sort); $data['sort']['boardreport_time'] = cs_sort('board', 'reportlist', $start, 0, 1, $sort); $data['sort']['boardreport_done'] = cs_sort('board', 'reportlist', $start, 0, 3, $sort); $data['sort']['threads_headline'] = cs_sort('board', 'reportlist', $start, 0, 5, $sort); $from = 'boardreport bdr INNER JOIN {pre}_threads thr ON bdr.threads_id = thr.threads_id'; $select = 'bdr.boardreport_time AS boardreport_time, bdr.boardreport_done AS boardreport_done, bdr.threads_id AS threads_id, thr.threads_headline AS threads_headline, bdr.comments_id AS comments_id'; $cs_report = cs_sql_select(__FILE__, $from, $select, 0, $order, $start, $account['users_limit']); $report_loop = count($cs_report); $data['boardreport'] = array(); for ($run = 0; $run < $report_loop; $run++) { $data['boardreport'][$run]['boardreport_time'] = cs_date('date', $cs_report[$run]['boardreport_time'], 1); $data['boardreport'][$run]['boardreport_done'] = empty($cs_report[$run]['boardreport_done']) ? $cs_lang['no'] : $cs_lang['yes']; $headline = cs_secure($cs_report[$run]['threads_headline']); // $comments_count = empty($cs_report[$run]['comments_id']) ? 0 : cs_sql_count(__FILE__,'comments',"comments_mod = 'board' AND comments_fid = '" . $cs_report[$run]['threads_id'] . "'"); // $goto = floor($comments_count / $account['users_limit']) * $account['users_limit'] . '#com' . $comments_count; $link = cs_link($headline, 'board', 'thread', 'where=' . $cs_report[$run]['threads_id']);
if (!empty($cs_post['start'])) { $start = $cs_post['start']; } $sort = empty($cs_get['sort']) ? 4 : $cs_get['sort']; if (!empty($cs_post['sort'])) { $sort = $cs_post['sort']; } $cs_sort[1] = 'cat.categories_name DESC'; $cs_sort[2] = 'cat.categories_name ASC'; $cs_sort[3] = 'brd.board_name DESC'; $cs_sort[4] = 'brd.board_name ASC'; $order = $cs_sort[$sort]; $where = empty($categories_id) ? 0 : "categories_id = '" . $categories_id . "'"; $board_count = cs_sql_count(__FILE__, 'board', $where); $data['head']['count_attachments'] = cs_sql_count(__FILE__, 'boardfiles'); $data['head']['count_reports'] = cs_sql_count(__FILE__, 'boardreport'); $data['head']['count'] = $board_count; $data['head']['pages'] = cs_pages('board', 'manage', $board_count, $start, $categories_id, $sort); $data['head']['getmsg'] = cs_getmsg(); $data['sort']['name'] = cs_sort('board', 'manage', $start, $categories_id, 3, $sort); $data['sort']['cat'] = cs_sort('board', 'manage', $start, $categories_id, 1, $sort); $from = 'board brd INNER JOIN {pre}_categories cat ON brd.categories_id = cat.categories_id'; $select = 'brd.board_name AS board_name, cat.categories_name AS categories_name, brd.board_id AS board_id'; $data['board'] = cs_sql_select(__FILE__, $from, $select, $where, $order, $start, $account['users_limit']); $board_loop = count($data['board']); for ($run = 0; $run < $board_loop; $run++) { $data['board'][$run]['name'] = cs_secure($data['board'][$run]['board_name']); $data['board'][$run]['cat'] = cs_secure($data['board'][$run]['categories_name']); $data['board'][$run]['id'] = $data['board'][$run]['board_id']; } echo cs_subtemplate(__FILE__, $data, 'board', 'manage');
<?php // ClanSphere 2010 - www.clansphere.net // $Id$ $cs_lang = cs_translate('medals'); $data = array(); $start = empty($_GET['start']) ? 0 : $_GET['start']; $cs_sort[1] = 'medals_name DESC'; $cs_sort[2] = 'medals_name ASC'; $sort = empty($_GET['sort']) ? 1 : $_GET['sort']; $order = $cs_sort[$sort]; $medals_count = cs_sql_count(__FILE__, 'medals'); $data['medals'] = cs_sql_select(__FILE__, 'medals', 'medals_name, medals_id', 0, $order, $start, $account['users_limit']); $data['count']['medals'] = count($data['medals']); $data['sort']['name'] = cs_sort('medals', 'manage', $start, 0, 1, $sort); $data['pages']['list'] = cs_pages('medals', 'manage', $medals_count, $start, 0, $sort); for ($i = 0; $i < $data['count']['medals']; $i++) { $data['medals'][$i]['medals_user'] = cs_sql_count(__FILE__, 'medalsuser', 'medals_id=' . $data['medals'][$i]['medals_id']); $data['medals'][$i]['view_user'] = cs_url('medals', 'user', 'where=' . $data['medals'][$i]['medals_id']); $data['medals'][$i]['count_user'] = $data['medals'][$i]['medals_user']; $data['medals'][$i]['edit_url'] = cs_url('medals', 'edit', 'id=' . $data['medals'][$i]['medals_id']); $data['medals'][$i]['remove_url'] = cs_url('medals', 'remove', 'id=' . $data['medals'][$i]['medals_id']); } $data['message']['medals'] = cs_getmsg(); echo cs_subtemplate(__FILE__, $data, 'medals', 'manage');
// ClanSphere 2010 - www.clansphere.net // $Id$ $cs_lang = cs_translate('static'); $access_id = empty($_REQUEST['where']) ? 0 : $_REQUEST['where']; settype($access_id, 'integer'); $start = empty($_REQUEST['start']) ? 0 : $_REQUEST['start']; $cs_sort[1] = 'static_id DESC'; $cs_sort[2] = 'static_id ASC'; $cs_sort[3] = 'static_title DESC'; $cs_sort[4] = 'static_title ASC'; $sort = empty($_REQUEST['sort']) ? 1 : $_REQUEST['sort']; $order = $cs_sort[$sort]; $where = empty($access_id) ? 0 : "static_access >= '" . $access_id . "'"; $static_count = cs_sql_count(__FILE__, 'static', $where); $data['head']['total'] = $static_count; $data['head']['pages'] = cs_pages('static', 'manage', $static_count, $start, $where, $sort); $data['access'] = array(); for ($levels = 0; $levels < 6; $levels++) { $sel = $access_id == $levels ? 'selected="selected"' : ''; $data['access'][$levels]['level_id'] = $levels; $data['access'][$levels]['level_name'] = $cs_lang['lev_' . $levels]; $data['access'][$levels]['selected'] = $sel; } $data['url']['new_staticpage'] = cs_url('static', 'create'); $data['url']['form'] = cs_url('static', 'manage'); $data['head']['message'] = cs_getmsg(); $data['sort']['id'] = cs_sort('static', 'manage', $start, $access_id, 1, $sort); $data['sort']['title'] = cs_sort('static', 'manage', $start, $access_id, 3, $sort); $select = 'static_id, static_title, static_access'; $cs_static = cs_sql_select(__FILE__, 'static', $select, $where, $order, $start, $account['users_limit']); $static_loop = count($cs_static);
$sort = $cs_post['sort']; } $data['if']['no_kt'] = TRUE; $data['if']['kt'] = FALSE; $cs_sort[1] = 'cash_time DESC'; $cs_sort[2] = 'cash_time ASC'; $cs_sort[3] = 'cash_money DESC'; $cs_sort[4] = 'cash_money ASC'; $cs_sort[5] = 'cash_inout DESC'; $cs_sort[6] = 'cash_inout ASC'; $order = $cs_sort[$sort]; $where_user = "******" . $account['users_id'] . "'"; $and_user = "******" . $account['users_id'] . "'"; $cash_count = cs_sql_count(__FILE__, 'cash', $where_user); $data['head']['count'] = $cash_count; $data['head']['pages'] = cs_pages('cash', 'center', $cash_count, $start, 0, $sort); // Kontodaten $konto = cs_sql_select(__FILE__, 'account', '*', 0, 0, 0); $konto_count = count($konto); if (!empty($konto_count)) { $data['if']['no_kt'] = FALSE; $data['if']['kt'] = TRUE; $data['kt']['account_id'] = cs_secure($konto['account_id'], 0, 0, 0); $data['kt']['account_owner'] = cs_secure($konto['account_owner'], 0, 0, 0); $data['kt']['account_number'] = cs_secure($konto['account_number'], 0, 0, 0); $data['kt']['account_bcn'] = cs_secure($konto['account_bcn'], 0, 0, 0); $data['kt']['account_iban'] = cs_secure($konto['account_iban'], 0, 0, 0); $data['kt']['account_bic'] = cs_secure($konto['account_bic'], 0, 0, 0); $data['kt']['account_bank'] = cs_secure($konto['account_bank'], 0, 0, 0); $data['if']['iban'] = false; $data['if']['bic'] = false;
$cs_sort[3] = 'users_place DESC'; $cs_sort[4] = 'users_place ASC'; $cs_sort[5] = 'users_laston DESC'; $cs_sort[6] = 'users_laston ASC'; $sort = empty($_GET['sort']) ? 2 : (int) $_GET['sort']; $order = $cs_sort[$sort]; //$where = empty($_REQUEST['where']) ? 0 : $_REQUEST['where']; //$mof = empty($where) ? '' : " AND users_sex = '" . cs_sql_escape($where) . "'"; $where = empty($_GET['where']) ? 0 : $_GET['where']; $mof = empty($where) ? '' : " AND users_nick LIKE '" . cs_sql_escape($where) . "%'"; $condition = 'users_delete = 0 AND users_active = 1' . $mof; $users_count = cs_sql_count(__FILE__, 'users', $condition); $data['head']['mod'] = $cs_lang['mod_name']; $data['head']['action'] = $cs_lang['list']; $data['head']['total'] = $users_count; $data['head']['pages'] = cs_pages('users', 'list', $users_count, $start, $where, $sort); $sel_female = $where === 'female' ? 'selected' : ''; $data['head']['sel_female'] = $sel_female; $sel_male = $where === 'male' ? 'selected' : ''; $data['head']['sel_male'] = $sel_male; $data['sort']['nick'] = cs_sort('users', 'list', $start, $where, 1, $sort); $data['sort']['place'] = cs_sort('users', 'list', $start, $where, 3, $sort); $data['sort']['laston'] = cs_sort('users', 'list', $start, $where, 5, $sort); $select = 'users_id, users_nick, users_place, users_laston, users_country, users_hidden, users_active, users_invisible'; $cs_users = cs_sql_select(__FILE__, 'users', $select, $condition, $order, $start, $account['users_limit']); $users_loop = count($cs_users); for ($run = 0; $run < $users_loop; $run++) { $cs_users[$run]['country'] = cs_html_img('symbols/countries/' . $cs_users[$run]['users_country'] . '.png'); $cs_users[$run]['users_id'] = cs_secure($cs_users[$run]['users_id']); $cs_users[$run]['nick'] = cs_user($cs_users[$run]['users_id'], $cs_users[$run]['users_nick'], $cs_users[$run]['users_active']); $content = cs_secure($cs_users[$run]['users_place']);
$start = empty($_REQUEST['start']) ? 0 : $_REQUEST['start']; $where = empty($_REQUEST['where']) ? $_GET['id'] : $_REQUEST['where']; settype($where, 'integer'); $cs_sort[1] = 'clans_name DESC'; $cs_sort[2] = 'clans_name ASC'; $cs_sort[3] = 'squads_name DESC'; $cs_sort[4] = 'squads_name ASC'; $cs_sort[5] = 'members_since DESC'; $cs_sort[6] = 'members_since ASC'; $sort = empty($_REQUEST['sort']) ? 2 : $_REQUEST['sort']; $order = $cs_sort[$sort]; $cru = "users_id = '" . $where . "'"; $clans_count = cs_sql_count(__FILE__, 'members', $cru); $data['lang']['mod_name'] = $cs_lang[$op_clans['label']]; $data['lang']['addons'] = cs_addons('users', 'view', $where, 'clans'); $data['pages']['list'] = cs_pages('clans', 'users', $clans_count, $start, $where, $sort); $select = 'mem.members_task AS members_task, mem.members_since AS members_since, '; $select .= 'sqd.squads_id AS squads_id, sqd.squads_name AS squads_name, '; $select .= 'cln.clans_id AS clans_id, cln.clans_name AS clans_name'; $from = 'members mem INNER JOIN {pre}_squads sqd ON mem.squads_id = sqd.squads_id '; $from .= 'INNER JOIN {pre}_clans cln ON sqd.clans_id = cln.clans_id'; $where2 = "mem.users_id ='" . $where . "'"; $cs_clans = cs_sql_select(__FILE__, $from, $select, $where2, $order, $start, $account['users_limit']); $clans_loop = count($cs_clans); $data['sort']['clans'] = cs_sort('clans', 'users', $start, $where, 1, $sort); $data['lang']['clans'] = $cs_lang[$op_clans['label']]; $data['sort']['squads'] = cs_sort('clans', 'users', $start, $where, 3, $sort); $data['lang']['squads'] = $cs_lang[$op_squads['label']]; $data['sort']['joined'] = cs_sort('clans', 'users', $start, $where, 5, $sort); if (empty($clans_loop)) { $data['clans'] = '';
<?php // ClanSphere 2010 - www.clansphere.net // $Id$ $cs_lang = cs_translate('gbook'); $cs_post = cs_post('start'); $cs_get = cs_get('start'); $start = empty($cs_get['start']) ? 0 : $cs_get['start']; if (!empty($cs_post['start'])) { $start = $cs_post['start']; } $gbook_count = cs_sql_count(__FILE__, 'gbook', "gbook_users_id = '0' AND gbook_lock = '1'"); $data['head']['entry'] = cs_link($cs_lang['submit'], 'gbook', 'entry', 'id=0&from=list'); $data['head']['count'] = $gbook_count; $data['head']['pages'] = cs_pages('gbook', 'list', $gbook_count, $start); $data['head']['getmsg'] = cs_getmsg(); $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_icq AS gbook_icq, gbk.gbook_jabber AS gbook_jabber, gbk.gbook_skype AS gbook_skype, '; $select .= 'gbk.gbook_url AS gbook_url, gbk.gbook_town AS gbook_town, gbk.gbook_text AS gbook_text, gbk.gbook_ip AS gbook_ip, '; $select .= 'usr.users_nick AS users_nick, usr.users_place AS users_place, usr.users_icq AS users_icq, usr.users_jabber AS users_jabber, '; $select .= 'usr.users_skype AS users_skype, usr.users_email AS users_email, usr.users_url AS users_url, usr.users_hidden AS users_hidden, usr.users_active AS users_active, usr.users_delete AS users_delete'; $where = "gbook_users_id = '0' AND gbook_lock = '1'"; $order = 'gbk.gbook_id DESC'; $cs_gbook = cs_sql_select(__FILE__, $from, $select, $where, $order, $start, $account['users_limit']); $gbook_loop = count($cs_gbook); $c = 0; for ($run = 0; $run < $gbook_loop; $run++) { $entry_count = $gbook_count - $start - $c; $c++; $gbook[$run]['entry_count'] = $entry_count;
// ClanSphere 2010 - www.clansphere.net // $Id$ $cs_lang = cs_translate('ranks'); $cs_post = cs_post('start,sort'); $cs_get = cs_get('start,sort'); $data = array(); $start = empty($cs_get['start']) ? 0 : $cs_get['start']; if (!empty($cs_post['start'])) { $start = $cs_post['start']; } $sort = empty($cs_get['sort']) ? 2 : $cs_get['sort']; if (!empty($cs_post['sort'])) { $sort = $cs_post['sort']; } $cs_sort[1] = 'ranks_name DESC'; $cs_sort[2] = 'ranks_name ASC'; $order = $cs_sort[$sort]; $ranks_count = cs_sql_count(__FILE__, 'ranks'); $data['head']['count'] = $ranks_count; $data['head']['pages'] = cs_pages('ranks', 'manage', $ranks_count, $start, 0, $sort); $data['head']['getmsg'] = cs_getmsg(); $data['sort']['name'] = cs_sort('ranks', 'manage', $start, 0, 1, $sort); $select = 'ranks_id, ranks_name'; $data['ranks'] = cs_sql_select(__FILE__, 'ranks', $select, 0, $order, $start, $account['users_limit']); $ranks_loop = count($data['ranks']); for ($run = 0; $run < $ranks_loop; $run++) { $data['ranks'][$run]['name'] = cs_secure($data['ranks'][$run]['ranks_name']); $data['ranks'][$run]['id'] = $data['ranks'][$run]['ranks_id']; } echo cs_subtemplate(__FILE__, $data, 'ranks', 'manage');
if (!empty($cs_post['sort'])) { $sort = $cs_post['sort']; } include_once 'mods/categories/functions.php'; $op_cat = cs_sql_option(__FILE__, 'categories'); $cs_sort[1] = 'categories_name DESC'; $cs_sort[2] = 'categories_name ASC'; $cs_sort[3] = 'categories_url DESC'; $cs_sort[4] = 'categories_url ASC'; $order = 'categories_subid, ' . $cs_sort[$sort]; $where = empty($_REQUEST['where']) ? $op_cat['def_mod'] : $_REQUEST['where']; $mdp = "categories_mod = '" . cs_sql_escape($where) . "'"; $categories_count = cs_sql_count(__FILE__, 'categories', $mdp); $data['where']['mod'] = $where; $data['head']['count'] = $categories_count; $data['head']['pages'] = cs_pages('categories', 'manage', $categories_count, $start, $where, $sort); $run = 0; $modules = cs_checkdirs('mods'); foreach ($modules as $mods) { $check_axx = empty($account['access_' . $mods['dir'] . '']) ? 0 : $account['access_' . $mods['dir'] . '']; if (!empty($mods['categories']) and $check_axx > 2) { $mods['dir'] == $where ? $sel = 1 : ($sel = 0); $data['mod'][$run]['sel'] = cs_html_option($mods['name'], $mods['dir'], $sel); $run++; } } $data['head']['getmsg'] = cs_getmsg(); $data['sort']['name'] = cs_sort('categories', 'manage', $start, $where, 1, $sort); $data['sort']['url'] = cs_sort('categories', 'manage', $start, $where, 3, $sort); $select = 'categories_id, categories_name, categories_url, categories_subid'; $data['cat'] = cs_sql_select(__FILE__, 'categories', $select, $mdp, $order, $start, $account['users_limit']);
$data['rounds'][$max]['name'] = $cs_lang['grand_final']; $i = 1.0; $run = 0; while ($i < $maxrounds) { $j = (int) (2 * $i); $data['lbrounds'][$run]['value'] = $j; $data['lbrounds'][$run]['if']['lbnotselected'] = $lb == 1 && $data['lbrounds'][$run]['value'] == $round ? false : true; $data['lbrounds'][$run]['name'] = $cs_lang['round'] . ' ' . ($j % 2 == 0 ? sprintf('%1.0F', $i) : sprintf('%1.1F', $i)); $i += 0.5; $run++; } break; } $data['vars']['matchcount'] = count($data['matches']); $data['vars']['cups_id'] = $cups_id; $data['pages']['list'] = cs_pages('cups', 'matchlist', $data['vars']['matchcount'], $start, $cups_id, $sort); $data['if']['brackets'] = $system['cups_brackets'] == CS_CUPS_SYSTEM_LB ? true : false; $data['sort']['team1'] = cs_sort('cups', 'matchlist', $start, $cups_id, 1, $sort, 'round=' . $round); $data['sort']['team2'] = cs_sort('cups', 'matchlist', $start, $cups_id, 3, $sort, 'round=' . $round); $data['sort']['bracket'] = cs_sort('cups', 'matchlist', $start, $cups_id, 5, $sort, 'round=' . $round); if ($system['cups_system'] == CS_CUPS_TYPE_USERS) { $data['lang']['team'] = $cs_lang['player']; } $notallowed = array(CS_CUPS_TEAM_UNKNOWN, CS_CUPS_TEAM_BYE); for ($i = 0; $i < $data['vars']['matchcount']; $i++) { $data['matches'][$i]['betlink'] = ''; if (!empty($account['access_bets']) && $account['access_bets'] > 3) { $cupmatch = $data['matches'][$i]; if ($cupmatch['cupmatches_winner'] == CS_CUPS_TEAM_UNKNOWN && !in_array($cupmatch['squad1_id'], $notallowed) && !in_array($cupmatch['squad2_id'], $notallowed) && empty($cupmatch['cupmatches_accepted1']) && empty($cupmatch['cupmatches_accepted2']) && empty($cupmatch['cupmatches_score1']) && empty($cupmatch['cupmatches_score2'])) { $data['matches'][$i]['betlink'] = cs_link(cs_icon('bets'), 'bets', 'create', 'cupmatchid=' . $data['matches'][$i]['cupmatches_id']); }
$start = empty($_REQUEST['start']) ? 0 : $_REQUEST['start']; $cs_sort[1] = 'clans_name DESC'; $cs_sort[2] = 'clans_name ASC'; $cs_sort[3] = 'clans_short DESC'; $cs_sort[4] = 'clans_short ASC'; $sort = empty($_REQUEST['sort']) ? 2 : $_REQUEST['sort']; $order = $cs_sort[$sort]; $data['lang']['getmsg'] = cs_getmsg(); $data['lang']['mod_name'] = $cs_lang[$op_clans['label']]; $own = "users_id = '" . $account['users_id'] . "'"; $clans_count = cs_sql_count(__FILE__, 'clans', $own); $data['lang']['mod_name'] = $cs_lang[$op_clans['label']]; $data['lang']['new'] = cs_link($cs_lang['new_' . $op_clans['label']], 'clans', 'new'); $data['lang']['all'] = $cs_lang['total'] . ': '; $data['lang']['count'] = $clans_count; $data['pages']['list'] = cs_pages('clans', 'center', $clans_count, $start, 0, $sort); $select = 'clans_name, clans_short, clans_id'; $cs_clans = cs_sql_select(__FILE__, 'clans', $select, $own, $order, $start, $account['users_limit']); $clans_loop = count($cs_clans); $data['sort']['name'] = cs_sort('clans', 'center', $start, 0, 1, $sort); $data['sort']['short'] = cs_sort('clans', 'center', $start, 0, 3, $sort); if (empty($clans_loop)) { $data['clans'] = ''; } for ($run = 0; $run < $clans_loop; $run++) { $data['clans'][$run]['name'] = cs_link(cs_secure($cs_clans[$run]['clans_name']), 'clans', 'view', 'id=' . $cs_clans[$run]['clans_id']); $data['clans'][$run]['short'] = cs_secure($cs_clans[$run]['clans_short']); $data['clans'][$run]['edit'] = cs_link(cs_icon('edit', 16, $cs_lang['edit']), 'clans', 'change', 'id=' . $cs_clans[$run]['clans_id'], 0, $cs_lang['edit']); if ($cs_clans[$run]['clans_id'] == 1) { $data['clans'][$run]['remove'] = '-'; } else {
} $sort = empty($cs_get['sort']) ? 2 : $cs_get['sort']; if (!empty($cs_post['sort'])) { $sort = $cs_post['sort']; } $cs_sort[1] = 'sqd.squads_name DESC'; $cs_sort[2] = 'sqd.squads_name ASC'; $cs_sort[3] = 'mem.members_task DESC'; $cs_sort[4] = 'mem.members_task ASC'; $order = $cs_sort[$sort]; $own = "users_id = '" . $account['users_id'] . "'"; $squads_count = cs_sql_count(__FILE__, 'members', $own); $data['head']['mod'] = $cs_lang[$op_squads['label'] . 's']; $data['lang']['new_label'] = $cs_lang['new_' . $op_squads['label']]; $data['head']['count'] = $squads_count; $data['head']['pages'] = cs_pages('squads', 'center', $squads_count, $start, 0, $sort); $data['head']['getmsg'] = cs_getmsg(); $data['lang']['join_label'] = $cs_lang['join_' . $op_squads['label']]; if (!empty($squads_count)) { $data['if']['squad_to_leave'] = TRUE; $data['lang']['leave_label'] = $cs_lang['leave_' . $op_squads['label']]; } $data['sort']['squad_name'] = cs_sort('squads', 'center', $start, 0, 1, $sort); $data['lang']['label'] = $cs_lang[$op_squads['label']]; $data['sort']['members_task'] = cs_sort('squads', 'center', $start, 0, 3, $sort); $select = 'sqd.squads_name AS squads_name, sqd.squads_id AS squads_id, mem.members_task AS members_task, mem.members_admin AS members_admin'; $from = 'members mem INNER JOIN {pre}_squads sqd ON mem.squads_id = sqd.squads_id'; $where = "mem.users_id = '" . $account['users_id'] . "'"; $data['squads'] = cs_sql_select(__FILE__, $from, $select, $where, $order, $start, $account['users_limit']); $squads_loop = count($data['squads']); for ($run = 0; $run < $squads_loop; $run++) {
$cat_1[$run]['folders_img'] = cs_link($cs_lap, 'usersgallery', 'users', $more); $cat_1[$run]['folders_name'] = $folders[$run]['folders_name']; } } $data['cat_1'] = !empty($cat_1) ? $cat_1 : array(); if (!empty($gallery_loop)) { for ($run = 0; $run < $gallery_loop; $run++) { $img[$run]['img'] = $cs_gallery[$run]['usersgallery_id']; $cs_lap = cs_html_img('symbols/gallery/nowatermark.gif', '100', '100'); $num = $start + $run; $img[$run]['link'] = cs_link($cs_lap, 'usersgallery', 'com_view', 'id=' . $id . '&cat_id=' . $cat_id . '&move=' . $num); } } $data['img'] = !empty($img) ? $img : array(); if (!empty($data['cat_1']) or !empty($gallery_loop)) { $data['data']['pages'] = cs_pages('usersgallery', 'users', $gallery_count, $start, 0, 0, $cols_rows, 0, 'cat_id=' . $cat_id . '&id=' . $id); } else { $empty_cat['lang']['empty_cat'] = $cs_lang['empty_cat']; } } if (empty($empty_cat['lang']['empty_cat']) and !empty($cat_id)) { $cat_list_1['0']['cat_list_1'] = '1'; } else { $cat_list_1['0']['cat_list_1'] = ''; } } else { $empty_cat['lang']['empty_cat'] = $cs_lang['no_cat']; } $data['cat'] = !empty($cat) ? $cat : ''; $cat_list['0']['cat_list'] = empty($cat_id) ? '1' : ''; $data['cat_list'] = !empty($cat_list['0']['cat_list']) ? $cat_list : '';
<?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');
$cs_votes_archiv = $cs_votes; $votes_id = $cs_votes[0]['votes_id']; if (!empty($votes_loop)) { $where = "voted_mod = 'votes' AND voted_fid = '" . $votes_id . "' AND voted_ip = '" . cs_sql_escape($users_ip) . "'"; if ($users_id > 0) { $where = "voted_mod = 'votes' AND voted_fid = '" . $votes_id . "' AND users_id = '" . $users_id . "'"; } $checkit_userip = cs_sql_count(__FILE__, 'voted', $where); } $from = 'voted'; $select = 'voted_id, users_id, voted_ip, voted_answer, voted_fid'; $where = "voted_mod = 'votes'"; $cs_voted = cs_sql_select(__FILE__, $from, $select, $where, '', '0', '0'); $voted_loop = count($cs_voted); $data['head']['count'] = $votes_loop; $data['head']['pages'] = cs_pages('votes', 'list', $votes_loop, $start, 0, $sort); $data['head']['getmsg'] = cs_getmsg(); $data['sort']['question'] = cs_sort('votes', 'list', $start, 0, 3, $sort); $data['sort']['ends_on'] = cs_sort('votes', 'list', $start, 0, 1, $sort); $from = 'comments'; $select = 'comments_fid'; $where = "comments_mod = 'votes'"; $cs_comments = cs_sql_select(__FILE__, $from, $select, $where, '', '0', '0'); $comments_loop = count($cs_comments); $com_count = 0; for ($run_2 = 0; $run_2 < $comments_loop; $run_2++) { $comments_fid = $cs_comments[$run_2]['comments_fid']; $votes_id = $cs_votes[0]['votes_id']; if ($comments_fid == $votes_id) { $com_count++; }
<?php // ClanSphere 2010 - www.clansphere.net // $Id$ $cs_lang = cs_translate('games'); $start = empty($_REQUEST['start']) ? 0 : $_REQUEST['start']; $cs_sort[1] = 'games_name DESC'; $cs_sort[2] = 'games_name ASC'; $cs_sort[3] = 'games_usk DESC'; $cs_sort[4] = 'games_usk ASC'; $sort = empty($_REQUEST['sort']) ? 2 : $_REQUEST['sort']; $order = $cs_sort[$sort]; $games_count = cs_sql_count(__FILE__, 'games'); $data['lang']['body'] = sprintf($cs_lang['all'], $games_count); $data['pages']['list'] = cs_pages('games', 'list', $games_count, $start, 0, $sort); $cs_games = cs_sql_select(__FILE__, 'games', '*', 0, $order, $start, $account['users_limit']); $games_loop = count($cs_games); $data['sort']['name'] = cs_sort('games', 'list', $start, 0, 1, $sort); $data['sort']['usk'] = cs_sort('games', 'list', $start, 0, 3, $sort); if (empty($games_loop)) { $data['games'] = ''; } for ($run = 0; $run < $games_loop; $run++) { $data['games'][$run]['name'] = cs_link($cs_games[$run]['games_name'], 'games', 'view', 'id=' . $cs_games[$run]['games_id']); $games_genre = cs_sql_select(__FILE__, 'categories', '*', "categories_id = '" . $cs_games[$run]['categories_id'] . "'"); $data['games'][$run]['genre'] = cs_secure($games_genre['categories_name']); $data['games'][$run]['usk'] = cs_secure($cs_games[$run]['games_usk']); $data['games'][$run]['release'] = empty($cs_games[$run]['games_released']) ? $since2 = '-' : ($since2 = cs_date('date', $cs_games[$run]['games_released'])); } echo cs_subtemplate(__FILE__, $data, 'games', 'list');
<?php // ClanSphere 2010 - www.clansphere.net // $Id$ $data = array(); $cs_lang = cs_translate('maps'); $data['count']['all'] = cs_sql_count(__FILE__, 'maps'); $data['lang']['curr_maps'] = sprintf($cs_lang['curr_maps'], $data['count']['all']); $cs_sort = array(); $cs_sort[1] = 'mp.maps_name ASC'; $cs_sort[2] = 'mp.maps_name DESC'; $cs_sort[3] = 'gm.games_name ASC'; $cs_sort[4] = 'gm.games_name DESC'; $sort = empty($_GET['sort']) ? 1 : (int) $_GET['sort']; $start = empty($_GET['start']) ? 0 : (int) $_GET['start']; $order = $cs_sort[$sort]; $data['pages']['list'] = cs_pages('maps', 'list', $data['count']['all'], $start, 0, $sort); $data['sort']['maps_name'] = cs_sort('maps', 'list', $start, 0, 1, $sort); $data['sort']['games_name'] = cs_sort('maps', 'list', $start, 0, 3, $sort); $tables = 'maps mp INNER JOIN {pre}_games gm ON mp.games_id = gm.games_id'; $cells = 'mp.maps_id AS maps_id, mp.maps_name AS maps_name, mp.games_id AS games_id, gm.games_name AS games_name'; $data['maps'] = cs_sql_select(__FILE__, $tables, $cells, 0, $order, $start, $account['users_limit']); $count_maps = count($data['maps']); for ($run = 0; $run < $count_maps; $run++) { $data['maps'][$run]['maps_name'] = cs_secure($data['maps'][$run]['maps_name']); } echo cs_subtemplate(__FILE__, $data, 'maps', 'list');
} if ($thread['threads_important']) { $icon .= 'important_'; } $data['threads'][$run]['icon'] = cs_html_img('symbols/board/' . $icon . '.png'); if (!empty($thread['threads_important'])) { $data['threads'][$run]['important'] = $cs_lang['important'] . ' '; } else { $data['threads'][$run]['important'] = ''; } $headline = cs_secure($thread['threads_headline']); $data['threads'][$run]['headline'] = cs_link($headline, 'board', 'thread', 'where=' . $thread['threads_id']); if ($thread['threads_comments'] > $account['users_limit']) { $data['threads'][$run]['pages'] = cs_html_br(1); $data['threads'][$run]['pages'] .= $cs_lang['page'] . ' '; $data['threads'][$run]['pages'] .= cs_pages('board', 'thread', $thread['threads_comments'], 0, $thread['threads_id'], 0, 0, 1); } else { $data['threads'][$run]['pages'] = ''; } $data['threads'][$run]['comments'] = $thread['threads_comments']; $data['threads'][$run]['view'] = $thread['threads_view']; if (!empty($thread['threads_last_time'])) { $date = cs_date('unix', $thread['threads_last_time'], 1); $comments = $thread['threads_comments'] == 0 ? 0 : $thread['threads_comments'] - 1; $goto = floor($comments / $account['users_limit']) * $account['users_limit']; $goto .= '#com' . $thread['threads_comments']; $data['threads'][$run]['last'] = cs_link($date, 'board', 'thread', 'where=' . $thread['threads_id'] . '&start=' . $goto); if (!empty($thread['users_id'])) { $data['threads'][$run]['last_user'] = cs_html_br(1); $data['threads'][$run]['last_user'] .= $cs_lang['from'] . ' '; $data['threads'][$run]['last_user'] .= cs_user($thread['users_id'], $thread['users_nick'], $thread['users_active']);
<?php // ClanSphere 2010 - www.clansphere.net // $Id$ $cs_lang = cs_translate('count'); $data = array('count' => array()); $geton = cs_time() - 300; $start = empty($_REQUEST['start']) ? 0 : $_REQUEST['start']; $where = "count_time > '" . $geton . "'"; $counte_online = cs_sql_count(__FILE__, 'count', $where); $data['online']['online'] = $counte_online; $data['head']['pages'] = cs_pages('count', 'online', $counte_online, $start); $cs_counter = cs_sql_select(__FILE__, 'count', 'count_time, count_location', "count_time >= '" . $geton . "'", 'count_id DESC', $start, $account['users_limit']); $counte_loop = count($cs_counter); for ($run = 0; $run < $counte_loop; $run++) { $data['count'][$run]['count_time'] = cs_date('unix', $cs_counter[$run]['count_time'], 1); $data['count'][$run]['count_location'] = cs_secure($cs_counter[$run]['count_location']); } echo cs_subtemplate(__FILE__, $data, 'count', 'online');
$squads_id = empty($_REQUEST['where']) ? 0 : (int) $_REQUEST['where']; $where_count = empty($squads_id) ? 0 : "squads_id = '" . $squads_id . "'"; $where = empty($squads_id) ? 0 : "war.squads_id = '" . $squads_id . "'"; $start = empty($_REQUEST['start']) ? 0 : (int) $_REQUEST['start']; $cs_sort[1] = 'war.wars_date DESC'; $cs_sort[2] = 'war.wars_date ASC'; $cs_sort[3] = 'cln.clans_name DESC'; $cs_sort[4] = 'cln.clans_name ASC'; $cs_sort[5] = 'cat.categories_name DESC'; $cs_sort[6] = 'cat.categories_name ASC'; $sort = empty($_REQUEST['sort']) ? 1 : (int) $_REQUEST['sort']; $order = $cs_sort[$sort]; $wars_count = cs_sql_count(__FILE__, 'wars', $where_count); $data = array(); $data['info']['warcount'] = sprintf($cs_lang['count'], $wars_count); $data['pages']['choice'] = cs_pages('wars', 'list', $wars_count, $start, $squads_id, $sort); $data['url']['form'] = cs_url('wars', 'list'); $cid = "squads_fightus = '0'"; $data['squads'] = cs_sql_select(__FILE__, 'squads', 'squads_name, squads_id', $cid, 'squads_name', 0, 0); $count_squads = count($data['squads']); for ($run = 0; $run < $count_squads; $run++) { $data['squads'][$run]['name'] = cs_secure($data['squads'][$run]['squads_name']); } $data['sort']['date'] = cs_sort('wars', 'list', $start, $squads_id, 1, $sort); $data['sort']['enemy'] = cs_sort('wars', 'list', $start, $squads_id, 3, $sort); $data['sort']['category'] = cs_sort('wars', 'list', $start, $squads_id, 5, $sort); $select = 'war.games_id AS games_id, war.wars_date AS wars_date, war.wars_status AS status, war.clans_id AS clans_id, cln.clans_short AS clans_short, cat.categories_name AS categories_name, war.categories_id AS categories_id, war.wars_score1 AS wars_score1, war.wars_score2 AS wars_score2, war.wars_id AS wars_id'; $from = 'wars war INNER JOIN {pre}_categories cat ON war.categories_id = cat.categories_id '; $from .= 'INNER JOIN {pre}_clans cln ON war.clans_id = cln.clans_id '; $cs_wars = cs_sql_select(__FILE__, $from, $select, $where, $order, $start, $account['users_limit']); $data['wars'] = '';
$cs_sort[8] = 'egt.eventguests_status ASC, egt.eventguests_since DESC'; $sort = empty($_REQUEST['sort']) ? 7 : $_REQUEST['sort']; $order = $cs_sort[$sort]; $data['if']['admin'] = $account['access_events'] >= 5 ? 1 : 0; $columns = 'events_id, events_name, events_time, events_needage, events_guestsmax, events_guestsmin'; $data['events'] = cs_sql_select(__FILE__, 'events', $columns, $where, 0, 0, 1); $data['events']['time'] = cs_date('unix', $data['events']['events_time'], 1); $count_where = "events_id = " . (int) $events_id . " AND eventguests_status = "; $data['count']['status_0'] = cs_sql_count(__FILE__, 'eventguests', $count_where . '0'); $data['count']['status_3'] = cs_sql_count(__FILE__, 'eventguests', $count_where . '3'); $data['count']['status_4'] = cs_sql_count(__FILE__, 'eventguests', $count_where . '4'); $data['count']['status_5'] = cs_sql_count(__FILE__, 'eventguests', $count_where . '5'); $data['count']['status_booked'] = $data['count']['status_4'] + $data['count']['status_5']; $data['count']['status_available'] = $data['events']['events_guestsmax'] - $data['count']['status_booked']; $data['head']['count'] = $data['count']['status_0'] + $data['count']['status_3'] + $data['count']['status_booked']; $data['head']['pages'] = cs_pages('events', 'guests', $data['head']['count'], $start, $events_id, $sort); $data['head']['getmsg'] = cs_getmsg(); $data['sort']['user'] = cs_sort('events', 'guests', $start, $events_id, 1, $sort); $data['sort']['name'] = cs_sort('events', 'guests', $start, $events_id, 3, $sort); $data['sort']['time'] = cs_sort('events', 'guests', $start, $events_id, 5, $sort); $data['sort']['status'] = cs_sort('events', 'guests', $start, $events_id, 7, $sort); $from = 'eventguests egt LEFT JOIN {pre}_users usr ON egt.users_id = usr.users_id'; $select = 'egt.eventguests_name AS eventguests_name, egt.eventguests_surname AS eventguests_surname, ' . 'egt.eventguests_since AS eventguests_since, egt.users_id AS users_id, usr.users_nick AS users_nick, ' . 'usr.users_surname AS users_surname, usr.users_hidden AS users_hidden, usr.users_active AS users_active, ' . 'usr.users_delete AS users_delete, usr.users_name AS users_name, usr.users_phone AS users_phone, ' . 'usr.users_mobile AS users_mobile, egt.eventguests_id AS eventguests_id, egt.eventguests_notice AS eventguests_notice, ' . 'egt.eventguests_phone AS eventguests_phone, egt.eventguests_mobile AS eventguests_mobile, ' . 'egt.eventguests_status AS eventguests_status'; $cs_eventguests = cs_sql_select(__FILE__, $from, $select, $where, $order, $start, $account['users_limit']); $eventguests_loop = count($cs_eventguests); if (empty($eventguests_loop)) { $data['eventguests'] = ''; } for ($run = 0; $run < $eventguests_loop; $run++) { $allow = 0; if ($cs_eventguests[$run]['users_id'] == $account['users_id'] or $account['access_users'] > 4) {
$cs_sort[3] = 'usr.users_email DESC'; $cs_sort[4] = 'usr.users_email ASC'; $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 {
<?php // ClanSphere 2010 - www.clansphere.net // $Id$ $cs_lang = cs_translate('buddys'); $buddy_data = array(); $start = empty($_REQUEST['start']) ? 0 : $_REQUEST['start']; $users_id = $account['users_id']; $buddys_count = cs_sql_count(__FILE__, 'buddys', "users_id = '" . $users_id . "'"); if (!isset($_GET['notice'])) { $buddy_data['if']['manage'] = TRUE; $buddy_data['if']['notice'] = FALSE; $buddy_data['head']['buddys_count'] = $buddys_count; $buddy_data['head']['pages'] = cs_pages('buddys', 'center', $buddys_count, $start); $buddy_data['head']['message'] = cs_getmsg(); $on_now = cs_time() - 300; $from = 'buddys bds INNER JOIN {pre}_users usr ON bds.buddys_user = usr.users_id'; $select = 'bds.buddys_id AS buddys_id, bds.buddys_time AS buddys_time, bds.buddys_user AS '; $select .= 'buddys_user, bds.users_id AS users_id, usr.users_nick AS users_nick, usr.users_active AS users_active, usr.users_delete AS users_delete, usr.users_invisible AS users_invisible, usr.users_country AS users_country, usr.users_laston AS '; $select .= 'users_laston'; $online = "bds.users_id = '" . $users_id . "' AND users_laston > '" . $on_now . "' AND users_invisible = '0'"; $offline = "bds.users_id = '" . $users_id . "' AND users_laston < '" . $on_now . "' AND users_invisible = '0'"; $buddys_off = cs_sql_select(__FILE__, $from, $select, $offline, 'users_nick DESC', 0, 0); $loop_off = count($buddys_off); $buddys_on = cs_sql_select(__FILE__, $from, $select, $online, 'users_nick DESC', 0, 0); $loop_on = count($buddys_on); $buddy_data['buddys_off'] = array(); $buddy_data['buddys_on'] = array(); for ($run = 0; $run < $loop_off; $run++) { $buddy_data['buddys_off'][$run]['users_id'] = $buddys_off[$run]['buddys_user']; $buddy_data['buddys_off'][$run]['users_nick'] = $buddys_off[$run]['users_nick'];