function cs_abcode_sql($name)
{
global $cs_lang;
$more = "onchange=\"javascript:abc_insert(this.form.cs_sql.options";
$more .= "[this.form.cs_sql.selectedIndex].value + '(',')','" . $name . "');";
$more .= "this.selectedIndex=0\"";
$var = cs_html_select(1, 'cs_sql', $more);
$var .= cs_html_option('SQL', 0);
$var .= cs_html_option('cs_sql_connect', 'cs_sql_connect');
$var .= cs_html_option('cs_sql_count', 'cs_sql_connect');
$var .= cs_html_option('cs_sql_delete', 'cs_sql_delete');
$var .= cs_html_option('cs_sql_escape', 'cs_sql_escape');
$var .= cs_html_option('cs_sql_insert', 'cs_sql_insert');
$var .= cs_html_option('cs_sql_insertid', 'cs_sql_insertid');
$var .= cs_html_option('cs_sql_option', 'cs_sql_option');
$var .= cs_html_option('cs_sql_query', 'cs_sql_query');
$var .= cs_html_option('cs_sql_select', 'cs_sql_select');
$var .= cs_html_option('cs_sql_update', 'cs_sql_update');
$var .= cs_html_option('cs_sql_version', 'cs_sql_version');
$var .= cs_html_select(0);
return $var;
}
}
if ($cs_clans['clans_tagpos'] == '2') {
$data['select']['next'] = 'selected="selected"';
} else {
$data['select']['next'] = '';
}
$el_id = 'country_1';
$onc = "document.getElementById('" . $el_id . "').src='" . $cs_main['php_self']['dirname'] . "symbols/countries/' + this.form.";
$onc .= "clans_country.options[this.form.clans_country.selectedIndex].value + '.png'";
$data['clans']['country'] = cs_html_select(1, 'clans_country', "onchange=\"" . $onc . "\"");
include_once 'lang/' . $account['users_lang'] . '/countries.php';
foreach ($cs_country as $short => $full) {
$short == $cs_clans['clans_country'] ? $sel = 1 : ($sel = 0);
$data['clans']['country'] .= cs_html_option($full, $short, $sel);
}
$data['clans']['country'] .= cs_html_select(0) . ' ' . cs_html_img('symbols/countries/' . $cs_clans['clans_country'] . '.png', 11, 16, 'id="' . $el_id . '"');
$data['clans']['url'] = cs_secure($cs_clans['clans_url']);
$data['clans']['since'] = cs_dateselect('since', 'date', $cs_clans['clans_since']);
$data['clans']['password'] = cs_secure($cs_clans['clans_pwd']);
$data['users']['nick'] = $users_nick;
if (empty($cs_clans['clans_picture'])) {
$data['clans']['pic'] = $cs_lang['nopic'];
} else {
$place = 'uploads/clans/' . $cs_clans['clans_picture'];
$size = getimagesize($cs_main['def_path'] . '/' . $place);
$data['clans']['pic'] = cs_html_img($place, $size[1], $size[0]);
}
$matches[1] = $cs_lang['pic_infos'];
$return_types = '';
foreach ($img_filetypes as $add) {
$return_types .= empty($return_types) ? $add : ', ' . $add;
$data['sel'][$run]['options'] = cs_html_option($mods['name'], $mods['dir'], $sel);
$run++;
}
$data['options']['automatic'] = $data['options']['def_path'] == '1' ? 'selected="selected"' : '';
$data['options']['manual'] = $data['options']['def_path'] == '0' ? 'selected="selected"' : '';
$data['options']['def_path'] = $cs_main['def_path'];
$data['options']['public_1'] = $data['options']['public'] == '1' ? 'checked="checked"' : '';
$data['options']['public_2'] = $data['options']['public'] == '0' ? 'checked="checked"' : '';
$data['options']['admin_1'] = $data['options']['def_admin'] == 'integrated' || empty($data['options']['def_admin']) ? 'checked="checked"' : '';
$data['options']['admin_2'] = $data['options']['def_admin'] == 'separated' ? 'checked="checked"' : '';
$data['options']['sec_remote_1'] = !empty($data['options']['sec_remote']) ? 'checked="checked"' : '';
$data['options']['sec_remote_2'] = empty($data['options']['sec_remote']) ? 'checked="checked"' : '';
$data['options']['timezone_select'] = cs_html_select(1, 'def_timezone');
$timezone = -10;
while ($timezone <= 12) {
$zonename = $timezone >= 0 ? 'UTC +' . $timezone : 'UTC ' . $timezone;
$offset = $timezone * 3600;
$sel = $offset == $data['options']['def_timezone'] ? 1 : 0;
$data['options']['timezone_select'] .= cs_html_option($zonename, $offset, $sel);
$timezone = $timezone + 0.5;
}
$data['options']['timezone_select'] .= cs_html_select(0);
$data['options']['time_1'] = $data['options']['def_dstime'] == 'on' ? 'selected="selected"' : '';
$data['options']['time_0'] = $data['options']['def_dstime'] == 'off' ? 'selected="selected"' : '';
$data['options']['time_auto'] = $data['options']['def_dstime'] == '0' ? 'selected="selected"' : '';
$data['options']['ajax_reload'] = empty($data['options']['ajax_reload']) ? 10 : $data['options']['ajax_reload'];
$data['options']['main_acc3_checked'] = $data['options']['maintenance_access'] == 3 ? 'selected="selected"' : '';
$data['options']['main_acc4_checked'] = $data['options']['maintenance_access'] == 4 ? 'selected="selected"' : '';
$data['options']['main_acc5_checked'] = $data['options']['maintenance_access'] == 5 ? 'selected="selected"' : '';
echo cs_subtemplate(__FILE__, $data, 'clansphere', 'options');
}
$data['lang']['body'] = $errormsg;
}
if (!empty($error) or !isset($_POST['submit'])) {
$data['clans']['name'] = cs_secure($cs_clans['clans_name']);
$data['clans']['short'] = cs_secure($cs_clans['clans_short']);
$data['clans']['tag'] = cs_secure($cs_clans['clans_tag']);
$el_id = 'country_1';
$onc = "document.getElementById('" . $el_id . "').src='" . $cs_main['php_self']['dirname'] . "symbols/countries/' + this.form.";
$onc .= "clans_country.options[this.form.clans_country.selectedIndex].value + '.png'";
$data['clans']['country'] = cs_html_select(1, 'clans_country', "onchange=\"" . $onc . "\"");
include_once 'lang/' . $account['users_lang'] . '/countries.php';
foreach ($cs_country as $short => $full) {
$short == $cs_clans['clans_country'] ? $sel = 1 : ($sel = 0);
$data['clans']['country'] .= cs_html_option($full, $short, $sel);
}
$data['clans']['country'] .= cs_html_select(0) . ' ';
$data['clans']['country'] .= cs_html_img('symbols/countries/' . $cs_clans['clans_country'] . '.png', 11, 16, 'id="' . $el_id . '"');
$data['clans']['url'] = cs_secure($cs_clans['clans_url']);
$data['clans']['since'] = cs_dateselect('since', 'date', $cs_clans['clans_since']);
$data['clans']['pw'] = cs_secure($cs_clans['clans_pwd']);
$data['users']['nick'] = $users_nick;
$matches[1] = $cs_lang['pic_infos'];
$return_types = '';
foreach ($img_filetypes as $add) {
$return_types .= empty($return_types) ? $add : ', ' . $add;
}
$matches[2] = $cs_lang['max_width'] . $op_clans['max_width'] . ' px' . cs_html_br(1);
$matches[2] .= $cs_lang['max_height'] . $op_clans['max_height'] . ' px' . cs_html_br(1);
$matches[2] .= $cs_lang['max_size'] . cs_filesize($op_clans['max_size']) . cs_html_br(1);
$matches[2] .= $cs_lang['filetypes'] . $return_types;
$data['clans']['clip'] = cs_abcode_clip($matches);
foreach ($modules as $mod) {
$acc_dir = 'access_' . $mod['dir'];
if (array_key_exists($acc_dir, $cs_access) and $mod['dir'] != 'clansphere') {
if (!empty($mod['icon'])) {
$data['access'][$run]['icon'] = cs_icon($mod['icon']);
} else {
$data['access'][$run]['icon'] = '';
}
$data['access'][$run]['name'] = cs_link($mod['name'], 'modules', 'view', 'dir=' . $mod['dir']);
$data['access'][$run]['select'] = cs_html_select(1, $acc_dir);
$levels = 0;
while ($levels < 6) {
$cs_access[$acc_dir] == $levels ? $sel = 1 : ($sel = 0);
$data['access'][$run]['select'] .= cs_html_option($levels . ' - ' . $cs_lang['lev_' . $levels], $levels, $sel);
$levels++;
}
$data['access'][$run]['select'] .= cs_html_select(0);
$run++;
}
}
$data['access2']['id'] = $access_id;
$data['if']['warning'] = $access_id < 6 ? 1 : 0;
$data['data']['warning_detail'] = empty($data['if']['warning']) ? '' : $cs_lang['warning_id_' . $access_id];
echo cs_subtemplate(__FILE__, $data, 'access', 'edit');
} else {
$access_cells = array_keys($cs_access);
$access_save = array_values($cs_access);
cs_sql_update(__FILE__, 'access', $access_cells, $access_save, $access_id);
cs_cache_delete('access_' . $access_id);
cs_redirect($cs_lang['changes_done'], 'access');
}
$data['games'][$i]['games_name'] = cs_secure($data['games'][$i]['games_name']);
}
$url = 'uploads/games/' . $cs_fightus['games_id'] . '.gif';
$data['fightus']['games_img'] = cs_html_img($url, 0, 0, 'id="game_1"');
$cid = "squads_own = '1' AND squads_fightus = '0'";
$cs_squads = cs_sql_select(__FILE__, 'squads', 'squads_name, squads_id, squads_own, squads_fightus', $cid, 'squads_name', 0, 0);
$data['fightus']['squad_sel'] = cs_dropdown('squads_id', 'squads_name', $cs_squads, $cs_fightus['squads_id']);
$el_id = 'country_1';
$onc = "document.getElementById('" . $el_id . "').src='" . $cs_main['php_self']['dirname'] . "symbols/countries/' + this.form.";
$onc .= "fightus_country.options[this.form.fightus_country.selectedIndex].value + '.png'";
$data['fightus']['country_sel'] = cs_html_select(1, 'fightus_country', "onchange=\"" . $onc . "\"");
foreach ($cs_country as $short => $full) {
$short == $cs_fightus['fightus_country'] ? $sel = 1 : ($sel = 0);
$data['fightus']['country_sel'] .= cs_html_option($full, $short, $sel);
}
$data['fightus']['country_sel'] .= cs_html_select(0) . ' ';
$url = 'symbols/countries/' . $cs_fightus['fightus_country'] . '.png';
$data['fightus']['country_img'] = cs_html_img($url, 11, 16, 'id="' . $el_id . '"');
$data['fightus']['date_sel'] = cs_dateselect('fight', 'unix', $cs_fightus['fightus_date'], 2000);
$data['fightus']['abcode_smileys'] = cs_abcode_smileys('fightus_more');
$data['fightus']['abcode_features'] = cs_abcode_features('fightus_more');
if (!empty($captcha)) {
$data['if']['captcha'] = TRUE;
$data['fightus']['captcha_img'] = cs_html_img('mods/captcha/generate.php?time=' . cs_time());
}
} elseif (!empty($data['if']['form'])) {
settype($cs_fightus['fightus_icq'], 'integer');
$cs_fightus['fightus_since'] = cs_time();
$fightus_cells = array_keys($cs_fightus);
$fightus_save = array_values($cs_fightus);
cs_sql_insert(__FILE__, 'fightus', $fightus_cells, $fightus_save);
}
$select1 .= cs_html_select(0) . ' ';
$data['data']['w_select'] = $select1;
if (!empty($watermark_id)) {
$url = 'uploads/categories/' . $cs_gallery['gallery_watermark'];
} else {
$url = 'symbols/gallery/nowatermark.png';
}
$data['data']['w_img'] = cs_html_img($url, '', '', 'id="' . $el_id . '"');
$data['data']['w_position'] = cs_html_select(1, 'watermark_pos');
$levels = 1;
while ($levels < 10) {
$watermark_pos == $levels ? $sel = 1 : ($sel = 0);
$data['data']['w_position'] .= cs_html_option($cs_lang['watermark_' . $levels], $levels, $sel);
$levels++;
}
$data['data']['w_position'] .= cs_html_select(0);
$data['data']['w_trans'] = $gallery_watermark_trans;
}
$data['abcode']['smileys'] = cs_abcode_smileys('gallery_description');
$data['abcode']['features'] = cs_abcode_features('gallery_description');
$checked = 'checked="checked"';
$data['check']['gray'] = empty($gray) ? '' : $checked;
echo cs_subtemplate(__FILE__, $data, 'gallery', 'picture_create');
} else {
$cs_gallery['gallery_watermark_pos'] = $watermark_pos;
$cells = array_keys($cs_gallery);
$save = array_values($cs_gallery);
cs_sql_insert(__FILE__, 'gallery', $cells, $save);
cs_redirect($cs_lang['create_done'], 'gallery', 'manage');
}
$data['lang']['manage_options'] = $cs_lang['error_occured'] . $error;
}
$data['dropdown']['def_register'] = cs_html_select(1, 'def_register');
$sel = $data['options']['def_register'] == '0' ? 1 : 0;
$data['dropdown']['def_register'] .= cs_html_option($cs_lang['reg_captcha'], 0, $sel);
$sel = $data['options']['def_register'] == '1' ? 1 : 0;
$data['dropdown']['def_register'] .= cs_html_option($cs_lang['reg_mail'], 1, $sel);
$sel = $data['options']['def_register'] == '2' ? 1 : 0;
$data['dropdown']['def_register'] .= cs_html_option($cs_lang['reg_captcha_mail'], 2, $sel);
$data['dropdown']['def_register'] .= cs_html_select(0);
$sel = empty($data['options']['register']) ? 1 : 0;
$data['options']['register_off'] = cs_html_option($cs_lang['off'], 0, $sel);
$sel = !empty($data['options']['register']) ? 1 : 0;
$data['options']['register_on'] = cs_html_option($cs_lang['on'], 1, $sel);
#nextbirth_time_interval
$data['options']['nextbirth_time_interval'] /= 86400;
$data['dropdown']['nextbirth_time_interval'] = cs_html_select(1, 'nextbirth_time_interval');
$sel = $data['options']['nextbirth_time_interval'] == '3' ? 1 : 0;
$data['dropdown']['nextbirth_time_interval'] .= cs_html_option(3, 3, $sel);
$sel = $data['options']['nextbirth_time_interval'] == '7' ? 1 : 0;
$data['dropdown']['nextbirth_time_interval'] .= cs_html_option(7, 7, $sel);
$sel = $data['options']['nextbirth_time_interval'] == '14' ? 1 : 0;
$data['dropdown']['nextbirth_time_interval'] .= cs_html_option(14, 14, $sel);
$sel = $data['options']['nextbirth_time_interval'] == '30' ? 1 : 0;
$data['dropdown']['nextbirth_time_interval'] .= cs_html_option(30, 30, $sel);
$data['dropdown']['nextbirth_time_interval'] .= cs_html_select(0);
$data['selected']['def_picture'] = empty($data['options']['def_picture']) ? '' : 'checked="checked" ';
$data['login']['nick'] = $data['options']['login'] == 'nick' ? 'selected="selected"' : '';
$data['login']['email'] = $data['options']['login'] == 'email' ? 'selected="selected"' : '';
echo cs_subtemplate(__FILE__, $data, 'users', 'options');
}
$data['head']['pages'] = cs_pages('comments', 'manage', $comments_count, $start, $where, $sort);
$data['head']['mod_dropdown'] = cs_html_select(1, 'where');
$check_sel = empty($where) ? $issel = 0 : ($issel = 1);
$data['head']['mod_dropdown'] .= cs_html_option('----', 0, 0, $issel);
$modules = cs_checkdirs('mods');
foreach ($modules as $mods) {
if (!empty($mods['comments'])) {
if (!empty($where)) {
$mods['dir'] == $where ? $sel = 1 : ($sel = 0);
} else {
$sel = 0;
}
$data['head']['mod_dropdown'] .= cs_html_option($mods['name'], $mods['dir'], $sel);
}
}
$data['head']['mod_dropdown'] .= cs_html_select(0);
$data['head']['getmsg'] = cs_getmsg();
$data['sort']['comments_id'] = cs_sort('comments', 'manage', $start, $where, 1, $sort);
$data['sort']['users_id'] = cs_sort('comments', 'manage', $start, $where, 3, $sort);
$data['sort']['comments_time'] = cs_sort('comments', 'manage', $start, $where, 5, $sort);
$com_where = $mdp . " AND comments_mod != 'board'";
$select = 'comments_id, users_id, comments_time, comments_fid, comments_mod, comments_guestnick';
$data['com'] = cs_sql_select(__FILE__, 'comments', $select, $com_where, $order, $start, $account['users_limit']);
$com_loop = count($data['com']);
for ($run = 0; $run < $com_loop; $run++) {
$id = $data['com'][$run]['comments_id'];
$data['com'][$run]['fid'] = $data['com'][$run]['comments_fid'];
if (!empty($data['com'][$run]['users_id'])) {
$cs_user = cs_sql_select(__FILE__, 'users', 'users_nick, users_active, users_delete', "users_id = '" . $data['com'][$run]['users_id'] . "'");
$data['com'][$run]['user'] = cs_user($data['com'][$run]['users_id'], $cs_user['users_nick'], $cs_user['users_active'], $cs_user['users_delete']);
} else {
function cs_dropdown($name, $list, $array, $select = 0, $key = 0, $def_option = 0)
{
global $cs_main;
$key = empty($key) ? $name : $key;
$var = cs_html_select(1, $name);
if (empty($def_option)) {
$var .= cs_html_option('----', 0, 0);
}
$array = is_array($array) ? $array : array();
foreach ($array as $data) {
$sel = $select == $data[$key] ? 1 : 0;
$content = html_entity_decode($data[$list], ENT_QUOTES, $cs_main['charset']);
$content = htmlentities($content, ENT_QUOTES, $cs_main['charset']);
$var .= cs_html_option($content, $data[$key], $sel);
}
return $var . cs_html_select(0);
}
$cells .= 'usr.users_id AS users_id, usr.users_nick AS users_nick, ';
$cells .= 'usr.users_active AS users_active, usr.users_country AS users_country';
$data['comment'] = cs_sql_select(__FILE__, $tables, $cells, 'comments_id = ' . (int) $comments_id);
$data['comment']['comments_text'] = $_POST['threads_text'];
$data['lang']['errors_here'] = $cs_lang['error_occured'] . $error;
}
$data['abcode']['features'] = cs_abcode_features('threads_text');
$tables = 'categories cat INNER JOIN {pre}_board b ON cat.categories_id = b.categories_id';
$cells = 'cat.categories_name AS categories_name, b.board_name AS board_name, b.board_id AS board_id';
$boards = cs_sql_select(__FILE__, $tables, $cells, 0, 0, 0, 0);
$data['board']['select'] = cs_html_select(1, 'board_id');
$data['board']['select'] .= cs_html_option('----', 0);
foreach ($boards as $board) {
$data['board']['select'] .= cs_html_option($board['categories_name'] . ': ' . $board['board_name'], $board['board_id'], 0);
}
$data['board']['select'] .= cs_html_select(0);
$data['comment']['text'] = cs_secure($data['comment']['comments_text'], 1, 1);
$data['comment']['user'] = cs_user($data['comment']['users_id'], $data['comment']['users_nick'], $data['comment']['users_active']);
$tables = 'comments cms INNER JOIN {pre}_users usr ON cms.users_id = usr.users_id';
$cells = 'usr.users_nick AS users_nick, usr.users_id AS users_id, cms.comments_text AS comments_text, ';
$cells .= 'usr.users_active AS users_active, usr.users_country AS users_country, cms.comments_id AS comments_id';
$cond = "cms.comments_fid = " . (int) $data['comment']['comments_fid'] . " AND comments_mod = 'board' AND cms.comments_id > " . (int) $comments_id;
$data['comments'] = cs_sql_select(__FILE__, $tables, $cells, $cond, 'comments_time', 0, 0);
$comments_count = count($data['comments']);
for ($run = 0; $run < $comments_count; $run++) {
$data['comments'][$run]['user'] = cs_user($data['comments'][$run]['users_id'], $data['comments'][$run]['users_nick'], $data['comments'][$run]['users_active']);
$data['comments'][$run]['comments_text'] = cs_secure($data['comments'][$run]['comments_text'], 1, 1);
$data['comments'][$run]['checked'] = !empty($_POST) && in_array($data['comments'][$run]['comments_id'], $_POST['comments']) ? ' checked="checked"' : '';
}
echo cs_subtemplate(__FILE__, $data, 'board', 'thread_cut');
}
