while ($set = RenDB_Fetch_Array($result)) {
//$slist.='<form action="index.php" method="post">';
$slist .= '<form action="index.php?mode=all_set&action=update&set_id=' . $set['set_id'] . '" method="post">';
$crsfix = 3 - $crsfix;
$cr = $color["cell{$crsfix}"];
$slist .= "<tr bgcolor=\"{$cr}\">";
$slist .= "<td><a name=\"set_{$set['set_id']}\">{$set['set_note']}</a></td>";
$slist .= "<td><input type=\"text\" size=\"50\" maxlength=\"1024\" name=\"set_value\" value=\"{$set['set_value']}\"></td>";
$slist .= "<td><input type=\"submit\" value=\"更改\"></td>";
$slist .= '</tr>';
//$slist.='<input type="hidden" name="mode" value="all_set">';
//$slist.='<input type="hidden" name="action" value="update">';
//$slist.='<input type="hidden" name="set_id" value="'.$set['set_id'].'">';
$slist .= "</form>\n";
}
ACP_ShowHeader('参数设置');
eval('echo "' . LoadTemplate('all_set') . '";');
ACP_ShowFooter();
break;
case 'update':
if (!isset($set_id, $set_value)) {
ACP_MessageBox($str['act_err']);
}
$set_value = trim($set_value);
$sql = "UPDATE {$cfg['tb_settings']} SET set_value='{$set_value}' WHERE set_id='{$set_id}' LIMIT 1";
RenDB_Query($sql, true);
ACP_WriteLog("更改设置 ID:{$set_id} 值:{$set_value}");
Header("Location: index.php?mode=all_set&/#set_{$set_id}");
exit;
break;
}
switch ($action) {
case 'list':
ACP_ShowHeader('实用工具');
eval('echo "' . LoadTemplate('tools') . '";');
ACP_ShowFooter();
break;
case 'rebuild_cache':
require_once '../include/cache_func.php';
Rebuild_Global_Cache(true);
ACP_WriteLog('刷新系统缓存');
ACP_MessageBox('系统缓存刷新完毕');
break;
case 'optimize':
$sql = "OPTIMIZE TABLE {$cfg['tb_members']},{$cfg['tb_pms']},{$cfg['tb_newgames']},{$cfg['tb_games']},{$cfg['tb_onlines']},{$cfg['tb_banips']},{$cfg['tb_settings']},{$cfg['tb_chats']},{$cfg['tb_competitions']},{$cfg['tb_groups']},{$cfg['tb_players']}";
RenDB_Query($sql, true);
ACP_WriteLog('整理数据库');
ACP_MessageBox("数据库整理完毕");
break;
case 'pm_batch_del':
if (!isset($dateline)) {
ACP_MessageBox($str['act_err']);
}
$dateline2 = time() - $dateline * 86400;
$sql = "DELETE FROM `{$cfg['tb_pms']}` WHERE sendtime<'{$dateline2}'";
if (isset($keepnewpm)) {
$sql .= " AND isnew=0";
}
RenDB_Query($sql);
if (RenDB_Affected_Rows()) {
ACP_MessageBox('共删掉了' . RenDB_Affected_Rows() . '条短消息');
}
} else {
if ($ban_ip == $userip) {
ACP_MessageBox('不能屏蔽自己的IP');
}
}
require_once '../include/txt_func.php';
$ban_reason = CSubStr($ban_reason, 0, 40);
$sql = "SELECT COUNT(*) FROM `{$cfg['tb_banips']}` WHERE ban_ip='{$ban_ip}'";
$result = RenDB_Query($sql);
if ($row = RenDB_Fetch_Row($result)) {
if ($row[0]) {
ACP_MessageBox($ban_ip . ' 已经在屏蔽列表中');
}
}
$sql = "INSERT INTO `{$cfg['tb_banips']}` SET ban_ip='{$ban_ip}',ban_time='{$nowtime}', ban_reason='{$ban_reason}'";
RenDB_Query($sql);
ACP_WriteLog("屏蔽IP {$ban_ip} ");
Header("Location: index.php?mode=ip_man");
exit;
break;
case 'unban':
if (!isset($ban_ip)) {
ACP_MessageBox($str['act_err']);
}
$sql = "DELETE FROM `{$cfg['tb_banips']}` WHERE ban_ip='{$ban_ip}'";
RenDB_Query($sql, true);
ACP_WriteLog("解禁IP {$ban_ip} ");
Header("Location: index.php?mode=ip_man");
exit;
break;
}
if (In_Names($_COOKIE['admin_name'], $cfg['admins'])) {
$admin_name = $_COOKIE['admin_name'];
$admin_pass = md5($_COOKIE['admin_pass']);
$sql = "SELECT * FROM `{$cfg['tb_members']}` WHERE u_name='{$admin_name}' AND u_pass='******' LIMIT 1";
$result = RenDB_Query($sql);
if (RenDB_Num_Rows($result) == 1) {
$udata = RenDB_Fetch_Array($result);
if ($udata['u_name'] == $admin_name) {
$admin_logged = true;
$udata['fake_name'] = $udata['u_name'];
}
}
}
if (!$admin_logged) {
$udata['fake_name'] = '@' . $userip;
ACP_WriteLog("密码错误 用户名:'{$_COOKIE['admin_name']}'");
}
}
if (!$admin_logged) {
setcookie('admin_name', '', time() - 36000);
setcookie('admin_pass', '', time() - 36000);
eval('echo "' . LoadTemplate('login') . '";');
exit;
}
//检查模块是否存在
if (!isset($mode)) {
$mode = 'main';
}
if (!in_array($mode, $cfg_cp['allmodes'])) {
ACP_MessageBox("模块{$mode}不存在");
}
case 'del':
if (!isset($cp_id)) {
ACP_MessageBox($str['act_err']);
}
$cp_id = intval($cp_id);
$sql = "DELETE FROM `{$cfg['tb_competitions']}` WHERE cp_id='{$cp_id}'";
RenDB_Query($sql, true);
$sql = "DELETE FROM `{$cfg['tb_groups']}` WHERE cp_id='{$cp_id}'";
RenDB_Query($sql, true);
$sql = "DELETE FROM `{$cfg['tb_players']}` WHERE cp_id='{$cp_id}'";
RenDB_Query($sql, true);
$sql = "DELETE FROM `{$cfg['tb_games']}` WHERE cp_id='{$cp_id}' AND mcount=0";
RenDB_Query($sql, true);
$sql = "UPDATE `{$cfg['tb_games']}` SET cp_id=0,group_id=0 WHERE cp_id='{$cp_id}'";
RenDB_Query($sql, true);
ACP_WriteLog("删除比赛 ID:{$cp_id}");
Header("Location: index.php?mode=cp_man");
exit;
break;
/*case 'add':
$sql="INSERT INTO `$cfg[tb_competitions]` SET cp_name='(新的比赛)' ";
$result = RenDB_Query($sql);
if( RenDB_Insert_id())
{
ACP_WriteLog("添加比赛 ID:".RenDB_Insert_id());
Header("Location: index.php?mode=cp_man");
exit();
}
ACP_MessageBox('添加失败');
break;
*/
$banbefore = -1;
} else {
$ban_time *= 60;
$banbefore = $ban_time + $nowtime;
}
$sql = "UPDATE {$cfg['tb_members']} SET ban_before='{$banbefore}' WHERE u_name='{$ban_name}' LIMIT 1";
RenDB_Query($sql, true);
if ($banbefore == -1) {
ACP_WriteLog("冻结账号 {$ban_name} ");
ACP_MessageBox("{$ban_name} 永久冻结");
}
if ($ban_time <= 0) {
ACP_WriteLog("解冻账号 {$ban_name} ");
ACP_MessageBox("{$ban_name} 解冻完毕");
} else {
ACP_WriteLog("冻结账号 {$ban_name} ");
ACP_MessageBox("{$ban_name} 冻结到 " . TimeToDate($banbefore));
}
break;
case 'ed1':
if (!isset($u_name)) {
ACP_MessageBox($str['act_err']);
}
$u_name = trim($u_name);
$sql = "SELECT * FROM `{$cfg['tb_members']}` WHERE u_name='{$u_name}' LIMIT 1";
$result = RenDB_Query($sql);
if (!($mdata = RenDB_Fetch_Array($result))) {
ACP_MessageBox('该用户不存在');
}
if (IN_Names($u_name, $cfg['admins'])) {
$m_stan = '管理员';
