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;