$cat_id = empty($cs_get['cat_id']) ? 0 : $cs_get['cat_id']; if (!empty($cs_post['cat_id'])) { $cat_id = $cs_post['cat_id']; } $start = empty($cs_get['start']) ? 0 : $cs_get['start']; if (!empty($cs_post['start'])) { $start = $cs_post['start']; } require_once 'mods/gallery/functions.php'; $options = cs_sql_option(__FILE__, 'gallery'); $cols = $options['cols']; $rows = $options['rows']; $cols_rows = $account['users_limit']; $access_id = $account['access_usersgallery']; $data['lang']['getmsg'] = cs_getmsg(); $data['data']['addons'] = cs_addons('users', 'view', $id, 'usersgallery'); if (!empty($id)) { if (empty($cat_id)) { $from = 'usersgallery'; $select = 'usersgallery_time, usersgallery_name, usersgallery_titel, usersgallery_download, '; $select .= 'usersgallery_description, usersgallery_id, usersgallery_vote, usersgallery_count, folders_id'; $where = "usersgallery_status = '1' AND usersgallery_access <= '" . $access_id . "' AND users_id = '" . $id . "'"; $order = 'usersgallery_id DESC'; $cs_gallery = cs_sql_select(__FILE__, $from, $select, $where, $order, $start, 0); $gallery_loop = count($cs_gallery); $from = 'folders'; $select = 'folders_id, sub_id, folders_name, folders_picture, folders_text'; $where = "folders_mod='usersgallery' AND users_id='" . $id . "' AND folders_access <= '" . $access_id . "'"; $order = 'folders_name ASC'; $folders = cs_sql_select(__FILE__, $from, $select, $where, $order, '', 0); $folders_loop = count($folders);
$op_squads = cs_sql_option(__FILE__, 'squads'); $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)) {
$cs_user = cs_sql_select(__FILE__, 'users', '*', "users_id = '" . $users_id . "'"); if (empty($cs_user['users_active'])) { $data['head']['action'] = $cs_lang['profile']; $data['head']['body_text'] = $cs_lang['not_active_text']; echo cs_subtemplate(__FILE__, $data, 'users', 'head'); $data['lang']['not_active'] = $cs_lang['not_active']; echo cs_subtemplate(__FILE__, $data, 'users', 'not_active'); } elseif (!empty($cs_user['users_delete'])) { $data['head']['action'] = $cs_lang['profile']; $data['head']['body_text'] = $cs_lang['delete_text']; echo cs_subtemplate(__FILE__, $data, 'users', 'head'); $data['lang']['delete'] = $cs_lang['delete']; echo cs_subtemplate(__FILE__, $data, 'users', 'delete'); } else { $data['head']['action'] = $cs_lang['profile']; $data['head']['body_text'] = cs_addons('users', 'view', $users_id, 'users'); echo cs_subtemplate(__FILE__, $data, 'users', 'head'); $old_nick = cs_sql_select(__FILE__, 'usernicks', 'users_nick', 'users_id = ' . $users_id, 'users_changetime DESC', 0, 1); $data['if']['old_nick'] = false; if (!empty($old_nick)) { $data['if']['old_nick'] = true; $data['users']['old_nick'] = $old_nick['users_nick']; } $data['users']['id'] = $cs_user['users_id']; $data['if']['buddies_active'] = (empty($account['access_buddys']) or $account['access_buddys'] < 2) ? false : true; $hidden = explode(',', $cs_user['users_hidden']); #$allow = $users_id == $account['users_id'] OR $account['access_users'] > 4 ? 1 : 0; $allow = 0; if ($users_id == $account['users_id'] or $account['access_users'] > 4) { $allow = 1; }
<?php $cs_lang = cs_translate('wars'); $users_id = $_REQUEST['id']; $where = empty($_REQUEST['where']) ? $_GET['id'] : $_REQUEST['where']; $data = array(); $data['wars']['see_page'] = cs_addons('users', 'view', $where, 'wars'); $tables = "users usr INNER JOIN {pre}_players ply ON ply.users_id = '" . $users_id . "'"; $cells = 'usr.users_id AS users_id, usr.users_nick AS users_nick, ply.wars_id AS wars_id'; $where = "ply.players_played = '1' AND usr.users_id = '" . $users_id . "'"; $player_wars = cs_sql_select(__FILE__, $tables, $cells, $where, 0, 0, 0); $player_wars_count = count($player_wars); $data['wars']['played'] = $player_wars_count; $data['wars']['win'] = 0; $data['wars']['draw'] = 0; $data['wars']['lost'] = 0; for ($run = 0; $run < $player_wars_count; $run++) { $select2 = 'wars_id, wars_score1, wars_score2, wars_status'; $win = "wars_id = '" . $player_wars[$run]['wars_id'] . "' AND wars_score1 > wars_score2 AND wars_status = 'played'"; $wars_win = cs_sql_select(__FILE__, 'wars', $select2, $win, 0, 0, 0); $data['wars']['win'] = $data['wars']['win'] + count($wars_win); $draw = "wars_id = '" . $player_wars[$run]['wars_id'] . "' AND wars_score1 = wars_score2 AND wars_status = 'played'"; $wars_draw = cs_sql_select(__FILE__, 'wars', $select2, $draw, 0, 0, 0); $data['wars']['draw'] = $data['wars']['draw'] + count($wars_draw); $lost = "wars_id = '" . $player_wars[$run]['wars_id'] . "' AND wars_score1 < wars_score2 AND wars_status = 'played'"; $wars_lost = cs_sql_select(__FILE__, 'wars', $select2, $lost, 0, 0, 0); $data['wars']['lost'] = $data['wars']['lost'] + count($wars_lost); } $data['wars']['win_percent'] = empty($data['wars']['win']) ? 0 : round($data['wars']['win'] / $data['wars']['played'] * 100); $data['wars']['draw_percent'] = empty($data['wars']['draw']) ? 0 : round($data['wars']['draw'] / $data['wars']['played'] * 100); $data['wars']['lost_percent'] = empty($data['wars']['lost']) ? 0 : round($data['wars']['lost'] / $data['wars']['played'] * 100);
<?php $cs_lang = cs_translate('medals'); $data = array(); $users_id = (int) $_GET['id']; $data['users']['addons'] = cs_addons('users', 'view', $users_id, 'medals'); $tables = 'medalsuser mu LEFT JOIN {pre}_medals md ON md.medals_id = mu.medals_id'; $cells = 'mu.users_id AS users_id, md.medals_id AS medals_id, mu.medalsuser_date AS medalsuser_date, mu.medalsuser_id AS medalsuser_id, '; $cells .= 'md.medals_name AS medals_name, md.medals_text AS medals_text, md.medals_extension AS medals_extension'; $data['medalsuser'] = cs_sql_select(__FILE__, $tables, $cells, "mu.users_id = '" . $users_id . "'", 0, 0, 0); $data['count']['medalsuser'] = count($data['medalsuser']); for ($i = 0; $i < $data['count']['medalsuser']; $i++) { $data['medalsuser'][$i]['img_src'] = 'uploads/medals/medal-' . $data['medalsuser'][$i]['medals_id'] . '.' . $data['medalsuser'][$i]['medals_extension']; $data['medalsuser'][$i]['medals_text'] = cs_secure($data['medalsuser'][$i]['medals_text'], 1); $data['medalsuser'][$i]['medals_date'] = cs_date('unix', $data['medalsuser'][$i]['medalsuser_date']); $data['medalsuser'][$i]['medals_name'] = cs_secure($data['medalsuser'][$i]['medals_name']); } echo cs_subtemplate(__FILE__, $data, 'medals', 'users');
// ClanSphere 2010 - www.clansphere.net // $Id$ $cs_lang = cs_translate('computers'); $start = empty($_REQUEST['start']) ? 0 : $_REQUEST['start']; $where = empty($_REQUEST['where']) ? $_GET['id'] : $_REQUEST['where']; settype($where, 'integer'); $cs_sort[1] = 'computers_name DESC'; $cs_sort[2] = 'computers_name ASC'; $cs_sort[3] = 'computers_since ASC'; $cs_sort[4] = 'computers_since DESC'; $sort = empty($_REQUEST['sort']) ? 1 : $_REQUEST['sort']; $order = $cs_sort[$sort]; $cru = "users_id = '" . $where . "'"; $computers_count = cs_sql_count(__FILE__, 'computers', $cru); $data['users']['addons'] = cs_addons('users', 'view', $where, 'computers'); $data['pages']['list'] = cs_pages('computers', 'users', $computers_count, $start, $where, $sort); $data['sort']['name'] = cs_sort('computers', 'users', $start, $where, 1, $sort); $data['sort']['since'] = cs_sort('computers', 'users', $start, $where, 3, $sort); $select = 'computers_name, computers_since, computers_id'; $cs_computers = cs_sql_select(__FILE__, 'computers', $select, $cru, $order, $start, $account['users_limit']); $computers_loop = count($cs_computers); if (empty($computers_loop)) { $data['computers'] = ''; } for ($run = 0; $run < $computers_loop; $run++) { $cs_name = cs_secure($cs_computers[$run]['computers_name']); $data['computers'][$run]['name'] = cs_link($cs_name, 'computers', 'view', 'id=' . $cs_computers[$run]['computers_id']); $data['computers'][$run]['since'] = cs_date('unix', $cs_computers[$run]['computers_since']); } echo cs_subtemplate(__FILE__, $data, 'computers', 'users');
<?php // ClanSphere 2010 - www.clansphere.net // $Id$ $posts = 10; $threads = 10; include 'mods/board/functions.php'; $cs_lang = cs_translate('board'); $user_id = $_GET['id']; settype($user_id, 'integer'); $board_access = $account['access_board']; $where = "users_id = '" . $user_id . "'"; $board_count = cs_sql_count(__FILE__, 'board', $where); $cs_user = cs_sql_select(__FILE__, 'users', 'users_nick, users_register, users_active, users_delete', "users_id = '" . $user_id . "'"); $userposts = getUserPosts($user_id); $data['users']['addons'] = cs_addons('users', 'view', $user_id, 'board'); $cs_ranks = cs_sql_select(__FILE__, 'boardranks', 'boardranks_min, boardranks_name', 0, 'boardranks_min ASC', 0, 0); $data['count']['com'] = $userposts; $since = cs_time() - $cs_user['users_register']; $since = $since <= 86400 ? 1 : $since / 86400; $posts_per_day = $userposts / $since; $data['count_com']['per_day'] = round($posts_per_day, 2) . $cs_lang['posts_per_day']; $data['count']['rank'] = cs_secure(getRankTitle($userposts, $cs_ranks)); $data['last']['com'] = sprintf($cs_lang['last_com'], $posts); $data['last']['thr'] = sprintf($cs_lang['last_thr'], $threads); $from = 'comments cms INNER JOIN {pre}_threads thr ON cms.comments_fid = thr.threads_id '; $from .= 'INNER JOIN {pre}_board frm ON frm.board_id = thr.board_id '; $from .= 'INNER JOIN {pre}_categories cat ON cat.categories_id = frm.categories_id'; $select = 'DISTINCT thr.threads_id AS threads_id, cat.categories_name AS categories_name, '; $select .= 'cat.categories_id AS categories_id, frm.board_name AS board_name, frm.board_id AS board_id, '; $select .= 'thr.threads_headline AS threads_headline, thr.threads_last_time AS threads_last_time, ';
$where = empty($cs_get['id']) ? 0 : $cs_get['id']; if (!empty($cs_post['id'])) { $where = $cs_post['id']; } $start = empty($cs_get['start']) ? 0 : $cs_get['start']; if (!empty($cs_post['start'])) { $start = $cs_post['start']; } if (empty($where)) { $where = empty($cs_get['where']) ? 0 : $cs_get['where']; if (!empty($cs_post['where'])) { $where = $cs_post['where']; } } $gbook_count = cs_sql_count(__FILE__, 'gbook', "gbook_users_id = '" . $where . "' AND gbook_lock = 1"); $data['head']['addons'] = cs_addons('users', 'view', $where, 'gbook'); $data['head']['pages'] = cs_pages('gbook', 'users', $gbook_count, $start, $where); $data['head']['new_entry'] = cs_link($cs_lang['submit'], 'gbook', 'entry', 'id=' . $where); $data['head']['count'] = $gbook_count; $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, '; $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_ip AS gbook_ip, '; $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 = '" . $where . "' AND gbook_lock = 1"; $order = 'gbk.gbook_id DESC'; $cs_gbook = cs_sql_select(__FILE__, $from, $select, $where, $order, $start, $account['users_limit']);