function cs_log_format($part, $addslashes = 0)
{
global $cs_logs, $cs_main;
$log = '';
if (is_array($cs_logs[$part])) {
foreach ($cs_logs[$part] as $file => $content) {
if (!empty($addslashes)) {
$file = str_replace('\\', '\\\\', $file);
}
$log .= cs_html_big(1) . $file . cs_html_big(0) . cs_html_br(1);
$log .= nl2br(htmlentities($content, ENT_QUOTES, $cs_main['charset']));
}
return $log;
} else {
return '';
}
}
$sqd_loop = count($sqd_data);
for ($run = 0; $run < $sqd_loop; $run++) {
$data['squad'][$run]['selected'] = $sqd_data[$run]['squads_id'] == $squads_id ? ' selected="selected"' : '';
$data['squad'][$run]['id'] = $sqd_data[$run]['squads_id'];
$data['squad'][$run]['name'] = cs_secure($sqd_data[$run]['squads_name']);
}
if (empty($sqd_loop)) {
$data['squad'] = array();
}
$data['lang']['msg'] = !empty($msg) ? $msg : '';
$select = 'mem.members_admin AS members_admin, mem.members_order AS members_order, mem.users_id AS users_id, usr.users_nick AS users_nick, usr.users_delete AS users_delete, usr.users_active AS users_active, mem.members_task, mem.members_id AS members_id';
$from = 'members mem INNER JOIN {pre}_users usr ON mem.users_id = usr.users_id';
$where = "mem.squads_id = '" . $squads_id . "'";
$cs_members = cs_sql_select(__FILE__, $from, $select, $where, $order, 0, 0);
$members_loop = count($cs_members);
$data['sort']['user'] = cs_sort('members', 'center', 0, $squads_id, 1, $sort);
$data['sort']['task'] = cs_sort('members', 'center', 0, $squads_id, 3, $sort);
$img_edit = cs_icon('edit', 16, $cs_lang['edit']);
$img_del = cs_icon('editdelete', 16, $cs_lang['remove']);
if (empty($members_loop)) {
$data['members'] = '';
}
for ($run = 0; $run < $members_loop; $run++) {
$users_nick = cs_user($cs_members[$run]['users_id'], $cs_members[$run]['users_nick'], $cs_members[$run]['users_active'], $cs_members[$run]['users_delete']);
$data['members'][$run]['user'] = empty($cs_members[$run]['members_admin']) ? $users_nick : cs_html_big(1) . $users_nick . cs_html_big(0);
$data['members'][$run]['task'] = cs_secure($cs_members[$run]['members_task']);
$data['members'][$run]['order'] = $cs_members[$run]['members_order'];
$data['members'][$run]['edit'] = cs_link($img_edit, 'members', 'change', 'id=' . $cs_members[$run]['members_id'], 0, $cs_lang['edit']);
$data['members'][$run]['remove'] = cs_link($img_del, 'members', 'center', 'del_id=' . $cs_members[$run]['members_id'], 0, $cs_lang['remove']);
}
echo cs_subtemplate(__FILE__, $data, 'members', 'center');
$select = 'mem.members_admin AS members_admin, mem.members_task AS members_task, mem.members_since AS members_since, ';
$select .= 'mem.users_id AS users_id, usr.users_nick AS users_nick, usr.users_country AS users_country, ';
$select .= 'usr.users_name AS users_name, usr.users_surname AS users_surname, usr.users_sex AS users_sex, ';
$select .= 'usr.users_picture AS users_picture, usr.users_active AS users_active, usr.users_delete AS users_delete, usr.users_hidden AS users_hidden, ';
$select .= 'usr.users_laston AS users_laston, usr.users_invisible AS users_invisible';
$from = 'members mem INNER JOIN {pre}_users usr ON mem.users_id = usr.users_id ';
$where = "mem.squads_id='" . $squads_id . "'";
$order = 'mem.members_order ASC, usr.users_nick ASC';
$data['members'] = cs_sql_select(__FILE__, $from, $select, $where, $order, 0, 0, 0);
$data['squad']['members'] = count($data['members']);
for ($run = 0; $run < $data['squad']['members']; $run++) {
$data['members'][$run]['countrypath'] = 'symbols/countries/' . $data['members'][$run]['users_country'] . '.png';
$data['members'][$run]['country'] = $cs_country[$data['members'][$run]['users_country']];
$data['members'][$run]['members_since'] = empty($data['members'][$run]['members_since']) ? '-' : cs_date('date', $data['members'][$run]['members_since']);
$data['members'][$run]['page'] = cs_userstatus($data['members'][$run]['users_laston'], $data['members'][$run]['users_invisible']);
$users_nick = empty($data['members'][$run]['members_admin']) ? cs_secure($data['members'][$run]['users_nick']) : cs_html_big(1) . cs_secure($data['members'][$run]['users_nick']) . cs_html_big(0);
$nick = $data['squad']['clans_tagpos'] == 1 ? $data['squad']['clans_tag'] . ' ' . $users_nick : $users_nick . ' ' . $data['squad']['clans_tag'];
$data['members'][$run]['users_url'] = cs_user($data['members'][$run]['users_id'], $data['members'][$run]['users_nick'], $data['members'][$run]['users_active'], $data['members'][$run]['users_delete']);
}
//ranks
$data['if']['rank'] = 0;
if (!empty($account['access_ranks'])) {
$cells = 'ranks_id, ranks_name, ranks_url, ranks_img, ranks_code';
$ranks = cs_sql_select(__FILE__, 'ranks', $cells, "squads_id = '" . $squads_id . "'", 'ranks_name', 0, 5);
$ranks_loop = count($ranks);
$data['if']['rank'] = empty($ranks_loop) ? FALSE : TRUE;
for ($run = 0; $run < $ranks_loop; $run++) {
$ranks[$run]['name'] = cs_secure($ranks[$run]['ranks_name']);
$ranks[$run]['picture'] = '';
if (!empty($ranks[$run]['ranks_url']) and $ranks[$run]['ranks_img'] != 'http://') {
$picture = cs_html_img($ranks[$run]['ranks_img']);
$part_cells = 'mem.members_admin AS members_admin, usr.users_nick AS users_nick, usr.users_id AS users_id, usr.users_active AS users_active, usr.users_country AS users_country';
$where = "mem.squads_id = '" . $squads_run['squads_id'] . "'";
$members = cs_sql_select(__FILE__, $part_tab, $part_cells, $where, 'mem.members_order', 0, 0);
if (empty($members)) {
$data['loop']['members'] = '';
$data['stop']['members'] = '';
$data['squads'][$run]['members']['country'] = '';
$data['squads'][$run]['members']['name'] = '';
$data['squads'][$run]['members']['dot'] = '';
} else {
$members_loop = count($members);
for ($run_2 = 0; $run_2 < $members_loop; $run_2++) {
$users_nick = cs_secure($members[$run_2]['users_nick']);
$users_link = cs_user($members[$run_2]['users_id'], $members[$run_2]['users_nick'], $members[$run_2]['users_active']);
if (!empty($members[$run_2]['members_admin'])) {
$users_link = cs_html_big(1) . $users_link . cs_html_big(0);
}
$all = $run_2 == $members_loop - 1 ? '' : ', ';
if (empty($members[$run_2]['users_country'])) {
$country = '-';
} else {
$url = 'symbols/countries/' . $members[$run_2]['users_country'] . '.png';
$country = cs_html_img($url, 11, 16);
}
$data['squads'][$run]['members'][$run_2]['country'] = $country;
$data['squads'][$run]['members'][$run_2]['name'] = $users_link;
$data['squads'][$run]['members'][$run_2]['dot'] = $all;
}
}
$run++;
}
$select .= 'messages_archiv_sender, messages_archiv_receiver, messages_subject';
$where = "messages_id = '" . $messages_id . "'";
$cs_messages = cs_sql_select(__FILE__, 'messages', $select, $where);
if (isset($_POST['agree'])) {
$users_id = $account['users_id'];
if ($cs_messages['users_id'] == $users_id) {
$messages_show_sender = '0';
$messages_archiv_sender = '0';
$messages_cells = array('messages_show_sender', 'messages_archiv_sender');
$messages_content = array($messages_show_sender, $messages_archiv_sender);
cs_sql_update(__FILE__, 'messages', $messages_cells, $messages_content, $messages_id);
}
if ($cs_messages['users_id_to'] == $users_id) {
$messages_show_receiver = '0';
$messages_archiv_receiver = '0';
$messages_cells = array('messages_show_receiver', 'messages_archiv_receiver');
$messages_content = array($messages_show_receiver, $messages_archiv_receiver);
cs_sql_update(__FILE__, 'messages', $messages_cells, $messages_content, $messages_id);
}
if ($cs_messages['messages_show_sender'] == 0 and $cs_messages['messages_archiv_sender'] == 0 and $cs_messages['users_id_to'] == $users_id or $cs_messages['messages_show_receiver'] == 0 and $cs_messages['messages_archiv_receiver'] == 0 and $cs_messages['users_id'] == $users_id) {
cs_sql_delete(__FILE__, 'messages', $messages_id);
}
cs_redirect($cs_lang['del_true'], 'messages', 'center');
}
if (isset($_POST['cancel'])) {
cs_redirect($cs_lang['del_false'], 'messages', 'center');
} elseif ($cs_messages['users_id'] == $account['users_id'] or $cs_messages['users_id_to'] == $account['users_id']) {
$data['head']['body'] = sprintf($cs_lang['msg_rly_rmv'], cs_html_big(1) . cs_secure($cs_messages['messages_subject']) . cs_html_big(0));
$data['messages']['id'] = $messages_id;
echo cs_subtemplate(__FILE__, $data, 'messages', 'remove');
}
$para[2] = nl2br(htmlentities($sql_query, ENT_QUOTES, $cs_main['charset']));
$actions .= cs_abcode_color($para);
$actions .= ' # ' . $info;
$actions .= cs_html_br(1);
}
}
} else {
$error++;
}
if (empty($files['update']['tmp_name'])) {
$data['lang']['body'] = $cs_lang['body_import'];
} elseif (empty($error)) {
$data['lang']['body'] = $cs_lang['update_done'];
} else {
if (!empty($install_sql)) {
$data['lang']['body'] = cs_html_big(1) . $cs_lang['update_error'] . cs_html_big(0) . cs_html_br(1) . $cs_lang['error_inst_sql'];
} else {
$data['lang']['body'] = $cs_lang['update_error'];
}
}
$data['if']['actions'] = empty($actions) ? false : true;
if (!empty($actions)) {
cs_cache_clear();
$cs_lang2 = cs_translate('clansphere');
$data['lang']['cache_cleared'] = $cs_lang2['cache_cleared'];
$data['message']['actions'] = $actions;
}
if (empty($sql_content) or !empty($error)) {
$data['if']['sql_content'] = false;
$data['action']['form'] = cs_url('database', 'import');
$data['import']['sql_text'] = $sql_content;
<?php
// ClanSphere 2010 - www.clansphere.net
// $Id$
$cs_lang = cs_translate('board');
// Statistik Start
$data = array();
$all_threads = cs_sql_count(__FILE__, 'threads');
$all_comment = cs_sql_count(__FILE__, 'comments', "comments_mod = 'board'");
$data['stats']['threads'] = cs_html_big(1) . $all_threads . cs_html_big(0);
$data['stats']['comments'] = cs_html_big(1) . $all_comment . cs_html_big(0);
$select = 'users_id, users_nick, users_register, users_active';
$order = 'users_register DESC';
$cs_users = cs_sql_select(__FILE__, 'users', $select, 'users_delete = 0 AND users_active = 1', $order, 0, 1);
$secure_name = cs_secure($cs_users['users_nick']);
$data['user']['newest'] = cs_user($cs_users['users_id'], $cs_users['users_nick'], $cs_users['users_active']);
// Statistik End
// All Users Start
$data['user']['all'] = cs_sql_count(__FILE__, 'users', 'users_delete = 0 AND users_active = 1');
// All Users End
// Online Users Start
$five_min = cs_time() - 300;
$select = 'users_id, users_nick, users_country, users_active, users_invisible, users_delete';
$upcome = "users_laston > '" . $five_min . "' AND users_invisible = '0'";
$order = 'users_laston DESC';
$users_count = cs_sql_count(__FILE__, 'users', $upcome);
$data['stats']['online'] = sprintf($cs_lang['user_online'], $users_count);
$where = 'count_time > \'' . $five_min . '\'';
$visitor_online = cs_sql_count(__FILE__, 'count', $where) - $users_count;
if ($visitor_online < 0) {
$visitor_online = 0;
