bank.php

三國好好 子

<?
include 'header.php';

$result = mysql_query ("SELECT * FROM phaos_characters WHERE id = '$PHP_PHAOS_CHARID'");
if ($row = mysql_fetch_array($result)) { $char_loc = $row["location"]; }
$result = mysql_query ("SELECT * FROM phaos_buildings WHERE location = '$char_loc'");
if ($row = mysql_fetch_array($result)) { $shop_id = $row["shop_id"]; }

shop_valid($char_loc, $shop_id); // make sure this requested shop is at the players location

$sql = mysql_query("SELECT gold,bankgold FROM phaos_characters WHERE id='$PHP_PHAOS_CHARID'");
$row = mysql_fetch_assoc($sql);

if(isset($_POST['submit'])) {
	// process bank here
	switch($_POST['R1']) {
		case "deposit":
		if ($_POST['amount'] <= 0) {
			echo"<center>请输入要存多少金币数!</center>";
		} elseif ($_POST['amount'] > $row['gold']) {
			echo"<center>你手上没有这么多金币!</center>";
		} else {
			$newgold = $row['gold'] - $_POST['amount'];
			$newbank = $row['bankgold'] + $_POST['amount'];
			mysql_query("UPDATE phaos_characters SET gold='$newgold', bankgold='$newbank' WHERE id='$PHP_PHAOS_CHARID'");
			echo"<center>你存了 ".number_format($_POST['amount'])." 个金币到你的帐户.</center>";
			$refresh = 1;
		}
		break;
		case "withdraw":
		if ($_POST['amount'] <= 0) {
			echo"<center>请输入要取多少金币数!</center>";
		} elseif ($_POST['amount'] > $row['bankgold']) {
			echo"<center>你没有那么多钱在银行!</center>";
		} else {
			$newgold = $row['gold'] + $_POST['amount'];
			$newbank = $row['bankgold'] - $_POST['amount'];
			mysql_query("UPDATE phaos_characters SET gold='$newgold', bankgold='$newbank' WHERE id='$PHP_PHAOS_CHARID'");
			echo"<center>你从账户上取走 ".number_format($_POST['amount'])." 个金币.</center>";
			$refresh = 1;
		}
		break;
	}
	if ($refresh){
		$sql = mysql_query("SELECT bankgold FROM phaos_characters WHERE id='$PHP_PHAOS_CHARID'");
		$row = mysql_fetch_assoc($sql);
		echo "<script language=\"JavaScript\">
			<!--
			javascript:parent.side_bar.location.reload();
			//-->
			</script>";
	}
	$refresh = 0; //be sure to reset refresh-Status
}

echo '<div align=center><form method="POST" action="bank.php">
	<center><table border="0" cellpadding="3" cellspacing="0" width="35%">
	<tr><td width="100%" colspan="2">&nbsp;</td></tr><tr><td width="100%" colspan="2">
	<p align="center"><b><big>银行</big></b><br></td></tr><tr><td width="100%" colspan="2">
	<p align="center">您的存款: '.number_format($row['bankgold']).'</td></tr><tr><td width="50%"><p align="center">
	<input type="radio" value="deposit" checked name="R1">存款</td><td width="50%"><p align="center">
	<input type="radio" value="withdraw" name="R1">取款</td></tr><tr><td width="100%" colspan="2">
	<p align="center"><input type="text" name="amount" size="20"></td></tr><tr><td width="100%" colspan="2">
	<p align="center"><input type="submit" value="Submit" name="submit"></td></tr></table></center></form>
	</div>';

include "footer.php";
?>