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