PHP cs_pages函数代码示例

// 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');

// 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']);

    $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 = "users_id = '" . $account['users_id'] . "'";
$and_user = " AND users_id = '" . $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&amp;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;

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 {

                $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 . '&amp;cat_id=' . $cat_id . '&amp;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 . '&amp;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 : '';

$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$
$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');