// ClanSphere 2010 - www.clansphere.net
// $Id$
$cs_lang = cs_translate('users');
$five_min = cs_time() - 300;
$select = 'users_id, users_nick, users_country, users_active, users_invisible, users_picture';
$invisible = $account['access_users'] > 4 ? '' : " AND users_invisible = '0'";
$upcome = "users_laston > " . $five_min . " AND users_active = '1'" . $invisible;
$order = 'users_laston DESC';
$cs_users = cs_sql_select(__FILE__, 'users', $select, $upcome, $order, 0, 8);
$data = array();
if (empty($cs_users)) {
$data['lang']['no_users'] = $cs_lang['no_data'];
echo cs_subtemplate(__FILE__, $data, 'users', 'no_users');
} else {
$count_users = count($cs_users);
for ($run = 0; $run < $count_users; $run++) {
if (!empty($cs_users[$run]['users_picture'])) {
$data['users'][$run]['picture'] = 'uploads/users/' . $cs_users[$run]['users_picture'];
} else {
$data['users'][$run]['picture'] = 'symbols/users/no_pic.png';
}
if (empty($invisible) and !empty($cs_users[$run]['users_invisible'])) {
$data['users'][$run]['nick'] = cs_html_italic(1) . $cs_users[$run]['users_nick'] . cs_html_italic(0);
} else {
$data['users'][$run]['nick'] = $cs_users[$run]['users_nick'];
}
$data['users'][$run]['url'] = cs_url('users', 'view', 'id=' . $cs_users[$run]['users_id']);
}
echo cs_subtemplate(__FILE__, $data, 'users', 'navonline_pic');
}
if (in_array('users_jabber', $hidden)) {
$content = empty($allow) ? '--' : cs_html_italic(1) . $content . cs_html_italic(0);
}
$data['users']['jabber'] = empty($cs_user['users_jabber']) ? '--' : $content;
$cs_user['users_skype'] = cs_secure($cs_user['users_skype']);
$content = cs_html_link('skype:' . $cs_user['users_skype'] . '?userinfo', $cs_user['users_skype']);
$skype_url = 'http://mystatus.skype.com/smallicon/' . $cs_user['users_skype'];
$content .= ' ' . cs_html_img($skype_url, '16', '16');
if (in_array('users_skype', $hidden)) {
$content = empty($allow) ? '--' : cs_html_italic(1) . $content . cs_html_italic(0);
}
$data['users']['skype'] = empty($cs_user['users_skype']) ? '--' : $content;
$content = cs_secure($cs_user['users_phone']);
if (in_array('users_phone', $hidden)) {
$content = empty($allow) ? '--' : cs_html_italic(1) . $content . cs_html_italic(0);
}
$data['users']['phone'] = empty($cs_user['users_phone']) ? '--' : $content;
$content = cs_secure($cs_user['users_mobile']);
if (in_array('users_mobile', $hidden)) {
$content = empty($allow) ? '--' : cs_html_italic(1) . $content . cs_html_italic(0);
}
$data['users']['mobile'] = empty($cs_user['users_mobile']) ? '--' : $content;
$data['users']['info'] = empty($cs_user['users_info']) ? ' ' : cs_secure($cs_user['users_info'], 1, 1);
/* Users View Update */
/* $users_view['users_view'] = $cs_user['users_view'] + 1;
$users_cells = array_keys($users_view);
$users_save = array_values($users_view);
cs_sql_update(__FILE__,'users',$users_cells,$users_save,$cs_user['users_id']);
$data['users']['view'] = $users_view['users_view'];*/
echo cs_subtemplate(__FILE__, $data, 'users', 'view');
}
if (!empty($surname) and !empty($name)) {
$data['eventguests'][$run]['name'] = $surname . ', ' . $name;
} elseif (!empty($surname) or !empty($name)) {
$data['eventguests'][$run]['name'] = $surname . $name;
} else {
$data['eventguests'][$run]['name'] = '';
}
if (empty($cs_eventguests[$run]['eventguests_phone'])) {
if (in_array('users_phone', $hidden)) {
$cs_eventguests[$run]['eventguests_phone'] = empty($allow) ? '' : cs_html_italic(1) . $cs_eventguests[$run]['users_phone'] . cs_html_italic(0);
} elseif (!empty($allow)) {
$cs_eventguests[$run]['eventguests_phone'] = $cs_eventguests[$run]['users_phone'];
}
}
if (empty($cs_eventguests[$run]['eventguests_mobile'])) {
if (in_array('users_mobile', $hidden)) {
$cs_eventguests[$run]['eventguests_mobile'] = empty($allow) ? '' : cs_html_italic(1) . $cs_eventguests[$run]['users_mobile'] . cs_html_italic(0);
} elseif (!empty($allow)) {
$cs_eventguests[$run]['eventguests_mobile'] = $cs_eventguests[$run]['users_mobile'];
}
}
$data['eventguests'][$run]['user'] = empty($cs_eventguests[$run]['users_id']) ? '-' : cs_user($cs_eventguests[$run]['users_id'], $cs_eventguests[$run]['users_nick'], $cs_eventguests[$run]['users_active'], $cs_eventguests[$run]['users_delete']);
$data['eventguests'][$run]['since'] = cs_date('unix', $cs_eventguests[$run]['eventguests_since']);
$data['eventguests'][$run]['phone'] = empty($cs_eventguests[$run]['eventguests_phone']) ? ' ' : cs_html_img('symbols/' . $cs_main['img_path'] . '/16/linphone.' . $cs_main['img_ext'], 16, 16, 'title="' . $cs_eventguests[$run]['eventguests_phone'] . '"');
$data['eventguests'][$run]['mobile'] = empty($cs_eventguests[$run]['eventguests_mobile']) ? ' ' : cs_html_img('symbols/' . $cs_main['img_path'] . '/16/sms_protocol.' . $cs_main['img_ext'], 16, 16, 'title="' . $cs_eventguests[$run]['eventguests_mobile'] . '"');
$data['eventguests'][$run]['status'] = $cs_lang['status_' . $cs_eventguests[$run]['eventguests_status']];
$data['eventguests'][$run]['notice'] = empty($cs_eventguests[$run]['eventguests_notice']) ? ' ' : cs_icon('txt', 16, $cs_lang['notice']);
$data['eventguests'][$run]['edit'] = cs_link(cs_icon('edit', 16, $cs_lang['edit']), 'events', 'guestsadm', 'id=' . $cs_eventguests[$run]['eventguests_id'], 0, $cs_lang['edit']);
$data['eventguests'][$run]['remove'] = cs_link(cs_icon('editdelete', 16, $cs_lang['remove']), 'events', 'guestsdel', 'id=' . $cs_eventguests[$run]['eventguests_id'], 0, $cs_lang['remove']);
}
echo cs_subtemplate(__FILE__, $data, 'events', 'guests');
$data['if']['moderator'] = true;
$f_user = "******" . $userid . "'";
$boardmod = cs_sql_select(__FILE__, 'boardmods', 'categories_id, users_id', $f_user);
$f_cat = "categories_id = '" . $boardmod['categories_id'] . "'";
$bm_cat = cs_sql_select(__FILE__, 'categories', 'categories_id, categories_name', $f_cat);
$data['thread_desc']['boardmod'] = $bm_cat['categories_name'];
} else {
$data['if']['no_moderator'] = true;
$data['thread_desc']['users_rank'] = getUserRank($count_com[$userid], $ranks);
$data['thread_desc']['users_title'] = getRankTitle($count_com[$userid], $ranks);
}
$data['thread_desc']['avatar'] = getUserAvatar($data['thread']['users_avatar']);
$content = cs_secure($data['thread']['users_place']);
$hidden = explode(',', $data['thread']['users_hidden']);
if (in_array('users_place', $hidden)) {
$content = ($account['access_users'] > 4 or $data['thread']['users_id'] == $account['users_id']) ? cs_html_italic(1) . $content . cs_html_italic(0) : '';
}
$data['thread_desc']['place'] = empty($content) ? '' : $cs_lang['place'] . ': ' . $content;
$data['thread_desc']['posts'] = $count_com[$userid];
$data['thread_desc']['date'] = cs_date('unix', $data['thread']['threads_time'], 1);
$data['thread_desc']['text'] = cs_secure($data['thread']['threads_text'], 1, 1);
//Files Start
if (!empty($loop_files)) {
$data['if']['thread_desc_files'] = true;
$check_files = 0;
for ($run = 0; $run < $loop_files; $run++) {
if ($cs_thread_files[$run]['comments_id'] == 0) {
$check_files++;
}
}
if (!empty($check_files)) {
$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']);
$hidden = explode(',', $cs_users[$run]['users_hidden']);
if (in_array('users_place', $hidden)) {
$content = ($account['access_users'] > 4 or $cs_users[$run]['users_id'] == $account['users_id']) ? cs_html_italic(1) . $content . cs_html_italic(0) : '';
}
$cs_users[$run]['place'] = $content;
$cs_users[$run]['laston'] = cs_date('unix', $cs_users[$run]['users_laston']);
$cs_users[$run]['page'] = cs_userstatus($cs_users[$run]['users_laston'], $cs_users[$run]['users_invisible']);
}
$data['users'] = $cs_users;
echo cs_subtemplate(__FILE__, $data, 'users', 'list');
if (in_array('users_mobile', $hidden)) {
$cs_eventguests[$run]['eventguests_mobile'] = empty($allow) ? '' : cs_html_italic(1) . $cs_eventguests[$run]['users_mobile'] . cs_html_italic(0);
} elseif (!empty($allow)) {
$cs_eventguests[$run]['eventguests_mobile'] = $cs_eventguests[$run]['users_mobile'];
}
}
$age = $cs_eventguests[$run]['eventguests_age'];
if (!empty($cs_eventguests[$run]['users_age'])) {
$birth = explode('-', $cs_eventguests[$run]['users_age']);
$age = cs_datereal('Y') - $birth[0];
if (cs_datereal('m') <= $birth[1]) {
$age--;
}
if (cs_datereal('d') >= $birth[2] and cs_datereal('m') == $birth[1]) {
$age++;
}
if (in_array('users_age', $hidden)) {
$age = empty($allow) ? '' : cs_html_italic(1) . $age . cs_html_italic(0);
}
}
$data['eventguests'][$run]['number'] = $run + 1;
$data['eventguests'][$run]['surname'] = $surname;
$data['eventguests'][$run]['name'] = $name;
$data['eventguests'][$run]['age'] = empty($age) ? '' : $age;
$data['eventguests'][$run]['notice'] = cs_secure($cs_eventguests[$run]['eventguests_notice']);
$data['eventguests'][$run]['user'] = empty($cs_eventguests[$run]['users_id']) ? '-' : cs_user($cs_eventguests[$run]['users_id'], $cs_eventguests[$run]['users_nick'], $cs_eventguests[$run]['users_active'], $cs_eventguests[$run]['users_delete']);
$data['eventguests'][$run]['status'] = $cs_lang['status_' . $cs_eventguests[$run]['eventguests_status']];
$data['eventguests'][$run]['phone'] = empty($cs_eventguests[$run]['eventguests_phone']) ? ' ' : cs_icon('linphone') . $cs_eventguests[$run]['eventguests_phone'];
$data['eventguests'][$run]['mobile'] = empty($cs_eventguests[$run]['eventguests_mobile']) ? ' ' : cs_icon('sms_protocol') . $cs_eventguests[$run]['eventguests_mobile'];
}
echo cs_subtemplate(__FILE__, $data, 'events', 'guestsprint');
function cs_comments_view($com_fid, $mod, $action, $sum, $asc = true, $limit = 0)
{
$cs_lang = cs_translate('comments');
$options = cs_sql_option(__FILE__, 'comments');
global $account, $cs_main;
$class = 'leftb';
$start = isset($_REQUEST['start']) ? $_REQUEST['start'] : 0;
settype($start, 'integer');
settype($com_fid, 'integer');
settype($asc, 'boolean');
settype($limit, 'integer');
$data['comments']['sum'] = $sum;
$data['comments']['message'] = cs_getmsg();
$data['comments']['pages'] = cs_pages($mod, $action, $sum, $start, $com_fid);
if ($mod == 'board' and !empty($sum)) {
$data['if']['form'] = TRUE;
} else {
$data['if']['form'] = FALSE;
}
$where = "comments_mod = '" . cs_sql_escape($mod) . "' AND comments_fid = '" . $com_fid . "'";
$from = 'comments com LEFT JOIN {pre}_users usr ON com.users_id = usr.users_id ';
$select = 'com.comments_id AS comments_id, com.comments_ip AS comments_ip, com.comments_guestnick AS comments_guestnick, com.comments_time AS comments_time, com.comments_text AS comments_text, com.comments_edit AS comments_edit, com.users_id AS users_id, usr.users_nick as users_nick, usr.users_laston as users_laston, usr.users_place AS users_place, usr.users_country AS users_country, usr.users_avatar AS users_avatar, usr.users_hidden AS users_hidden, usr.users_active AS users_active, usr.users_delete AS users_delete, usr.users_invisible AS users_invisible';
$order = $asc == true ? 'comments_id ASC' : 'comments_id DESC';
$limit = !empty($limit) ? $limit : $account['users_limit'];
$cs_com = cs_sql_select(__FILE__, $from, $select, $where, $order, $start, $limit);
$com_loop = count($cs_com);
for ($run = 0; $run < $com_loop; $run++) {
$class = $class == 'leftb' ? 'leftc' : 'leftb';
$current = $start + $run + 1;
$com[$run]['class'] = $class;
if (empty($cs_com[$run]['users_id'])) {
$com[$run]['if']['guest'] = TRUE;
$com[$run]['if']['user'] = FALSE;
$com[$run]['guestnick'] = cs_secure($cs_com[$run]['comments_guestnick']);
} else {
$com[$run]['if']['guest'] = FALSE;
$com[$run]['if']['user'] = TRUE;
$src = 'symbols/countries/' . $cs_com[$run]['users_country'] . '.png';
$com[$run]['flag'] = cs_html_img($src, 11, 16);
$com[$run]['user'] = cs_user($cs_com[$run]['users_id'], $cs_com[$run]['users_nick'], $cs_com[$run]['users_active'], $cs_com[$run]['users_delete']);
$com[$run]['status'] = cs_userstatus($cs_com[$run]['users_laston'], $cs_com[$run]['users_invisible']);
$com[$run]['laston'] = !empty($cs_com[$run]['users_invisible']) ? '--' : cs_date('unix', $cs_com[$run]['users_laston']);
$com_place = cs_secure($cs_com[$run]['users_place']);
$hidden = explode(',', $cs_com[$run]['users_hidden']);
if (in_array('users_place', $hidden)) {
$com_place = ($account['access_users'] > 4 or $cs_com[$run]['users_id'] == $account['users_id']) ? cs_html_italic(1) . $com_place . cs_html_italic(0) : '';
}
$com[$run]['avatar'] = empty($options['show_avatar']) || empty($cs_com[$run]['users_avatar']) ? '' : cs_html_img('uploads/board/' . $cs_com[$run]['users_avatar']);
$users_place = empty($com_place);
$com[$run]['place'] = !empty($users_place) ? '-' : $cs_com[$run]['users_place'];
$who = "users_id = " . (int) $cs_com[$run]['users_id'];
$count_user_com = cs_sql_count(__FILE__, 'comments', $who);
$com[$run]['posts'] = $count_user_com;
}
$com[$run]['comments_time'] = cs_date('unix', $cs_com[$run]['comments_time'], 1);
$com[$run]['run'] = $asc == true ? $run + 1 : $com_loop - $run;
$com[$run]['current'] = $current;
$com[$run]['comments_text'] = cs_secure($cs_com[$run]['comments_text'], 1, 1);
if (!empty($cs_com[$run]['comments_edit'])) {
$edits = explode('/', $cs_com[$run]['comments_edit']);
$euser = cs_user($edits[0], $edits[1]);
$com[$run]['comments_edit'] = cs_html_br(3);
$com[$run]['comments_edit'] .= cs_html_italic(1);
$com[$run]['comments_edit'] .= sprintf($cs_lang['lastcom'], $euser, cs_date('unix', $edits[2], 1), $edits[3]);
$com[$run]['comments_edit'] .= cs_html_italic(0);
} else {
$com[$run]['comments_edit'] = '';
}
if ($mod == 'board') {
$com[$run]['if']['quote_board'] = TRUE;
$com[$run]['fid'] = $com_fid;
$com[$run]['id'] = $cs_com[$run]['comments_id'];
} else {
$com[$run]['if']['quote_board'] = FALSE;
}
if (!empty($account['users_id']) and $mod != 'board') {
$com[$run]['if']['edit_delete'] = TRUE;
$img_quote = cs_icon('xchat', 16, $cs_lang['quote']);
$com[$run]['edit_delete'] = cs_link($img_quote, $mod, 'com_create', 'id=' . $cs_com[$run]['comments_id'], 0, $cs_lang['quote']);
if ($cs_com[$run]['users_id'] == $account['users_id'] or $account['access_comments'] >= 4) {
$img_edit = cs_icon('edit', 16, $cs_lang['edit']);
$com[$run]['edit_delete'] .= cs_link($img_edit, $mod, 'com_edit', 'id=' . $cs_com[$run]['comments_id'], 0, $cs_lang['edit']);
}
if ($account['access_comments'] >= 5) {
$img_del = cs_icon('editdelete', 16, $cs_lang['remove']);
$com[$run]['edit_delete'] .= cs_link($img_del, $mod, 'com_remove', 'id=' . $cs_com[$run]['comments_id'], 0, $cs_lang['remove']);
}
} else {
$com[$run]['if']['edit_delete'] = FALSE;
}
}
$data['if']['bottom_pages'] = $sum > $com_loop ? TRUE : FALSE;
$data['fquote']['icon'] = 'symbols/' . $cs_main['img_path'] . '/16/xchat.' . $cs_main['img_ext'];
$data['com'] = !empty($com) ? $com : '';
echo cs_subtemplate(__FILE__, $data, 'comments', 'com_view');
}
function checkLastEdit($string, $cs_lang, $offset = 0)
{
$sub_result = explode('/', $string);
//Eigentlich w�rde ne Zahl oder Bool reichen, aber damit kann ich die Daten weiterverwenden
if (empty($offset)) {
$result = cs_html_italic(1);
$result .= $cs_lang['last_edit_by'];
$result .= ' ' . cs_user($sub_result[0], $sub_result[1]);
$result .= ' ' . $cs_lang['at'];
$result .= ' ' . cs_date('unix', $sub_result[2], 1);
$result .= ' (' . $sub_result[3] . 'x ' . $cs_lang['overall_edit'] . ')';
$result .= cs_html_italic(0);
return $result;
} else {
return $sub_result;
}
}
// ClanSphere 2010 - www.clansphere.net
// $Id$
$cs_lang = cs_translate('users');
$data = array();
$select = 'users_id, users_nick, users_name, users_surname, users_picture, users_country, users_register, users_active, users_hidden';
$data['users'] = cs_sql_select(__FILE__, 'users', $select, 'users_active = 1 AND users_delete = 0', '{random}', 0, 1);
$data['users']['picture'] = empty($data['users']['users_picture']) ? $cs_lang['nopic'] : cs_html_img('uploads/users/' . $data['users']['users_picture']);
$data['users']['nick'] = cs_user($data['users']['users_id'], $data['users']['users_nick'], $data['users']['users_active']);
$data['users']['flag'] = cs_html_img('symbols/countries/' . $data['users']['users_country'] . '.png', 11, 16);
$data['users']['since'] = cs_date('unix', $data['users']['users_register'], 0, 1);
$hidden = explode(',', $data['users']['users_hidden']);
$allow = 0;
if ($data['users']['users_id'] == $account['users_id'] or $account['access_users'] > 4) {
$allow = 1;
}
$name = cs_secure($data['users']['users_name']);
if (in_array('users_name', $hidden)) {
$name = empty($allow) ? '' : cs_html_italic(1) . $name . cs_html_italic(0);
}
$surname = cs_secure($data['users']['users_surname']);
if (in_array('users_surname', $hidden)) {
$surname = empty($allow) ? '' : cs_html_italic(1) . $surname . cs_html_italic(0);
}
if (empty($name) && empty($surname)) {
$name = $cs_lang['noname'];
$surname = '';
}
$data['users']['name'] = $name;
$data['users']['surname'] = $surname;
echo cs_subtemplate(__FILE__, $data, 'users', 'navrand');
$cs_lang = cs_translate('users');
$select = 'users_email, users_register, users_laston, users_hidden, users_active, users_invisible';
$cs_user = cs_sql_select(__FILE__, 'users', $select, "users_id = '" . $account['users_id'] . "'");
$hidden = explode(',', $cs_user['users_hidden']);
$data['head']['mod'] = $cs_lang['mod_name'];
$data['head']['action'] = $cs_lang['home'];
$data['head']['body_text'] = $cs_lang['home_info'];
echo cs_subtemplate(__FILE__, $data, 'users', 'head');
if ($cs_user['users_invisible'] == 1) {
$if_invis = ' (' . $cs_lang['invisible'] . ')';
} else {
$if_invis = '';
}
$data['users']['link'] = cs_user($account['users_id'], $account['users_nick'], $cs_user['users_active']) . $if_invis;
$data['lang']['getmsg'] = cs_getmsg();
if (in_array('users_email', $hidden)) {
$cs_user['users_email'] = cs_html_italic(1) . $cs_user['users_email'] . cs_html_italic(0);
}
$data['users']['email'] = empty($cs_user['users_email']) ? '--' : $cs_user['users_email'];
$data['users']['register'] = cs_date('unix', $cs_user['users_register'], 1);
$data['users']['laston'] = cs_date('unix', $cs_user['users_laston'], 1);
$data['users']['access_name'] = cs_secure($account['access_name']);
echo cs_subtemplate(__FILE__, $data, 'users', 'home');
$plugins = cs_checkdirs('mods', 'users/home');
ksort($plugins);
foreach ($plugins as $mod) {
$acc_dir = 'access_' . $mod['dir'];
if (array_key_exists($acc_dir, $account) and $account[$acc_dir] >= $mod['show']['users/home']) {
include_once 'mods/' . $mod['dir'] . '/users_home.php';
}
}
