File: admin/site_bans.php $Revision$ Software by: DateMill (http://www.datemill.com) Copyright by: DateMill (http://www.datemill.com) Support at: http://www.datemill.com/forum ******************************************************************************* * See the "docs/licenses/etano.txt" file for license. * ******************************************************************************/ require_once '../includes/common.inc.php'; require_once '../includes/admin_functions.inc.php'; require_once '../includes/logs.inc.php'; allow_dept(DEPT_MODERATOR | DEPT_ADMIN); $tpl = new phemplate('skin/', 'remove_nonjs'); $o = isset($_GET['o']) ? (int) $_GET['o'] : 0; $r = isset($_GET['r']) ? (int) $_GET['r'] : current($accepted_results_per_page); $where = "a.`fk_lk_id_reason`=b.`fk_lk_id` AND b.`skin`='" . get_default_skin_code() . "'"; $from = "`{$dbtable_prefix}site_bans` a,`{$dbtable_prefix}lang_strings` b"; $query = "SELECT count(*) FROM {$from} WHERE {$where}"; if (!($res = @mysql_query($query))) { trigger_error(mysql_error(), E_USER_ERROR); } $totalrows = mysql_result($res, 0, 0); $loop = array(); if (!empty($totalrows)) { if ($o >= $totalrows) { $o = $totalrows - $r; $o = $o >= 0 ? $o : 0; } $config = get_site_option(array('datetime_format'), 'def_user_prefs'); $query = "SELECT a.`ban_id`,a.`ban_type`,a.`what`,b.`lang_value` as `reason`,UNIX_TIMESTAMP(a.`since`) as `since` FROM {$from} WHERE {$where} LIMIT {$o},{$r}"; if (!($res = @mysql_query($query))) {
} $input['access_level'] = !empty($input['access_level']) ? array_sum(array_keys($input['access_level'])) : 0; $input['pcat_name'] = sanitize_and_format_gpc($_POST, 'pcat_name', TYPE_STRING, $__field2format[FIELD_TEXTFIELD], ''); if (!empty($_POST['return'])) { $input['return'] = sanitize_and_format_gpc($_POST, 'return', TYPE_STRING, $__field2format[FIELD_TEXTFIELD] | FORMAT_RUDECODE, ''); $nextpage = $input['return']; } // check for input errors if (empty($input['pcat_name'])) { $error = true; $topass['message']['type'] = MESSAGE_ERROR; $topass['message']['text'] = 'Please enter the category!'; $input['error_pcat_name'] = 'red_border'; } if (!$error) { $default_skin_code = get_default_skin_code(); if (!empty($input['pcat_id'])) { $query = "UPDATE `{$dbtable_prefix}profile_categories` SET "; foreach ($profile_categories_default['defaults'] as $k => $v) { if (isset($input[$k])) { $query .= "`{$k}`='" . $input[$k] . "',"; } } $query = substr($query, 0, -1); $query .= " WHERE `pcat_id`=" . $input['pcat_id']; if (!($res = @mysql_query($query))) { trigger_error(mysql_error(), E_USER_ERROR); } $query = "SELECT `ls_id` FROM `{$dbtable_prefix}lang_strings` WHERE `fk_lk_id`=" . $input['fk_lk_id_pcat'] . " AND `skin`='{$default_skin_code}'"; if (!($res = @mysql_query($query))) { trigger_error(mysql_error(), E_USER_ERROR);
if (!($res = @mysql_query($query))) { trigger_error(mysql_error(), E_USER_ERROR); } $output = $lk_id; break; case 'edit': $query = "UPDATE `{$dbtable_prefix}lang_strings` SET `lang_value`='{$val}' WHERE `fk_lk_id`={$lk_id} AND `skin`='" . get_default_skin_code() . "'"; if (!($res = @mysql_query($query))) { trigger_error(mysql_error(), E_USER_ERROR); } if (!mysql_affected_rows()) { $query = "INSERT IGNORE INTO `{$dbtable_prefix}lang_keys` SET `lk_id`={$lk_id},`lk_type`=" . FIELD_TEXTFIELD . ",`lk_diz`='Field value',`lk_use`=" . LK_FIELD; if (!($res = @mysql_query($query))) { trigger_error(mysql_error(), E_USER_ERROR); } $query = "INSERT IGNORE INTO `{$dbtable_prefix}lang_strings` SET `fk_lk_id`={$lk_id},`lang_value`='{$val}',`skin`='" . get_default_skin_code() . "'"; if (!($res = @mysql_query($query))) { trigger_error(mysql_error(), E_USER_ERROR); } } $output = $lk_id; break; case 'del': $query = "DELETE FROM `{$dbtable_prefix}lang_strings` WHERE `fk_lk_id`={$lk_id}"; if (!($res = @mysql_query($query))) { trigger_error(mysql_error(), E_USER_ERROR); } $query = "DELETE FROM `{$dbtable_prefix}lang_keys` WHERE `lk_id`={$lk_id}"; if (!($res = @mysql_query($query))) { trigger_error(mysql_error(), E_USER_ERROR); }
if (isset($_SESSION['topass']['input'])) { $output = $_SESSION['topass']['input']; // our 'return' here was decoded in the processor $output['return2'] = $output['return']; $output['return'] = rawurlencode($output['return']); } elseif (!empty($_GET['pcat_id'])) { $pcat_id = (int) $_GET['pcat_id']; $query = "SELECT * FROM `{$dbtable_prefix}profile_categories` WHERE `pcat_id`={$pcat_id}"; if (!($res = @mysql_query($query))) { trigger_error(mysql_error(), E_USER_ERROR); } if (mysql_num_rows($res)) { $output = mysql_fetch_assoc($res); } $output['pcat_name'] = ''; $query = "SELECT `lang_value` FROM `{$dbtable_prefix}lang_strings` WHERE `skin`='" . get_default_skin_code() . "' AND `fk_lk_id`=" . $output['fk_lk_id_pcat']; if (!($res = @mysql_query($query))) { trigger_error(mysql_error(), E_USER_ERROR); } if (mysql_num_rows($res)) { $output['pcat_name'] = mysql_result($res, 0, 0); } $output = sanitize_and_format($output, TYPE_STRING, $__field2format[TEXT_DB2EDIT]); } $query = "SELECT `m_value`,`m_name` FROM `{$dbtable_prefix}memberships`"; if (!($res = @mysql_query($query))) { trigger_error(mysql_error(), E_USER_ERROR); } $memberships = array(); while ($rsrow = mysql_fetch_row($res)) { $memberships[$rsrow[0]] = $rsrow[1];
******************************************************************************/ require_once '../includes/common.inc.php'; require_once '../includes/admin_functions.inc.php'; require_once '../includes/tables/site_bans.inc.php'; require_once '../includes/logs.inc.php'; allow_dept(DEPT_MODERATOR | DEPT_ADMIN); $tpl = new phemplate('skin/', 'remove_nonjs'); $output = $site_bans_default['defaults']; if (isset($_SESSION['topass']['input'])) { $output = $_SESSION['topass']['input']; // our 'return' here was decoded in the processor $output['return2'] = $output['return']; $output['return'] = rawurlencode($output['return']); } elseif (!empty($_GET['ban_id'])) { $ban_id = (int) $_GET['ban_id']; $query = "SELECT a.`ban_id`,a.`ban_type`,a.`what`,a.`fk_lk_id_reason`,b.`lang_value` as `reason` FROM `{$dbtable_prefix}site_bans` a,`{$dbtable_prefix}lang_strings` b WHERE a.`ban_id`={$ban_id} AND a.`fk_lk_id_reason`=b.`fk_lk_id` AND b.`skin`='" . get_default_skin_code() . "'"; if (!($res = @mysql_query($query))) { trigger_error(mysql_error(), E_USER_ERROR); } if (mysql_num_rows($res)) { $output = mysql_fetch_assoc($res); $output['reason'] = sanitize_and_format($output['reason'], TYPE_STRING, $__field2format[TEXT_DB2EDIT]); if ($output['ban_type'] == _PUNISH_BANIP_) { $output['what'] = long2ip($output['what']); } } } $output['ban_type'] = vector2radios($accepted_punishments, 'ban_type', $output['ban_type'], array(_PUNISH_ERROR_)); $output['default_skin'] = get_default_skin_name(); if (empty($output['return'])) { $output['return2'] = sanitize_and_format_gpc($_GET, 'return', TYPE_STRING, $__field2format[FIELD_TEXTFIELD], '');
$Revision$ Software by: DateMill (http://www.datemill.com) Copyright by: DateMill (http://www.datemill.com) Support at: http://www.datemill.com/forum ******************************************************************************* * See the "docs/licenses/etano.txt" file for license. * ******************************************************************************/ require_once '../includes/common.inc.php'; require_once '../includes/admin_functions.inc.php'; allow_dept(DEPT_ADMIN); $tpl = new phemplate('skin/', 'remove_nonjs'); $content = ''; if (isset($_GET['s'])) { $skin = sanitize_and_format($_GET['s'], TYPE_STRING, $__field2format[FIELD_TEXTFIELD]); } else { $skin = get_default_skin_code(); } $output['skin'] = $skin; $query = "SELECT * FROM `{$dbtable_prefix}lang_keys` ORDER BY `lk_id` ASC"; if (!($res = @mysql_query($query))) { trigger_error(mysql_error(), E_USER_ERROR); } $i = 0; $loop = array(); $temp = array(); while ($rsrow = mysql_fetch_assoc($res)) { $rsrow['lk'] = empty($rsrow['alt_id_text']) ? $rsrow['lk_id'] : sanitize_and_format($rsrow['alt_id_text'], TYPE_STRING, $__field2format[TEXT_DB2DISPLAY]); $rsrow['save_file'] = empty($rsrow['save_file']) ? 'global.inc.php' : $rsrow['save_file']; $loop[$i] = $rsrow; $loop[$i]['lang_value'] = ''; if ($rsrow['lk_type'] == FIELD_TEXTFIELD) {