money.php
Code:
<?php
require_once "config.inc.php";
if(isset($_SESSION[step2]) && isset($_POST[step2])) {
//注册的最后一步
$errorStr = formStep3();
if($errorStr!=null){
require_once('money.html');
}else{
$success="成功给帐号：$_POST[user_name]加入游戏币$_POST[money]DIL";
require_once('success.html');
unset($_SESSION[step2], $_SESSION[step1]);
}}
else {
//注册的第二步
require_once('money.html');
$_SESSION[step2] = 1; }
function formStep3(){
$errors = array();
$errorStr = null;
//查询用户名是否存在
$strSql1="select * from character.dbo.user_character where character_name='$_POST[user_name]'";
$character_odbc = odbc_connect('account','DBUSER','DBPASS');
$character_result=odbc_do($character_odbc,$strSql1);
odbc_fetch_row($character_result);
$character_no=odbc_result($character_result,1);
odbc_close($character_odbc);
if ( $character_no== null) $errors[] = "无此玩家！";
if (strlen($_POST[money])<1) $errors[]="请输入增加的游戏币数";
if(!preg_match("/^[0-9]{1,12}$/i",$_POST[money])) $errors[]="游戏币只能为数字,最少为1位";
if(sizeof($errors)>0){
$errorStr .= "<br><font>";
$errorStr .= "信息输入错误：";
foreach($errors as $error)
$errorStr .= "<li>$error</li>";
$errorStr .= "</font><br><br>";
}else{
$money_query="update character.dbo.user_character set dwMoney=dwMoney+$_POST[money] where character_no='$character_no'";
$dk_money_odbc = odbc_connect('account','DBUSER','PASS');
$dk_money_result=odbc_do($dk_money_odbc,$money_query);
odbc_close($dk_money_odbc);
}
return $errorStr;
}
?>
config.inc.php
Code:
<?php
//开始session
session_start();
//设置不进行本地缓存
header('Expires: '.date('D,d M Y H:i:s',mktime(0,0,0,1,1,2000)).' GMT');
header('Last-Modified:'.gmdate('D,d M Y H:i:s').' GMT');
header('Cache-control: private, no-cache,must-revalidate');
header('Pragma: no-cache');
?>
money.html
Code:
<strong><font size="2">修改游戏币</font></strong><br>
<form method="post" action="money.php">
<?=$errorStr ?>
<input type="hidden" name="step2" value="1">
玩家角色名:
<input type="text" name="user_name" value="">
<br>
游戏币数额:
<input type="text" name="money" value="">
<br>
<br>
<input type="submit" name="Submit4" value="提交">
</form>
success.html
Code:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>sucess...</title>
</head>
<body>
<h1>sucess</h1>
</body>
</html>
