Code: Select all
<?php
session_start();
include 'C:\wamp\www\php website\config\connect.php';
include 'C:\wamp\www\php website\config\session.php';
$username = $_SESSION['username'];
$id = $_SESSION['houseid'];
$housename = $_SESSION['housename'];
$housemap = $_SESSION['housemap'];
$houseowner = $_SESSION['houseowner'];
$housestorage = $_SESSION['housestorage'];
$playerinfo="SELECT * from users where username='$username'";
$playerinfo2=mysql_query($playerinfo) or die("Could not get user stats");
$playerinfo3=mysql_fetch_array($playerinfo2);
$houseinfo="SELECT * from housing where id=$id";
$houseinfo2=mysql_query($houseinfo) or die("Could not get house stats");
$houseinfo3=mysql_fetch_array($houseinfo2);
$putmoney = $_POST['addmoney'];
$playermoney = $playerinfo3['money'];
$storage = $houseinfo3['storage'];
$playerid = $_SESSION['playerid'];
if(isset($_SESSION['username'])) {
if($putmoney > $playerinfo['money']) {
echo "<center>You Don't Have That Much Money!<br /></center>";
} elseif($putmoney <= 0) {
echo "<center>You Can't Put In Money Less Then 0 or Equal To 0!!<br /></center>";
} elseif($putmoney = "") {
echo "<center>Please type in the amount of money you want to store!<br /><center>";
}else {
$playermoney = $playermoney - $putmoney;
$storage = $storage + $putmoney;
mysql_query("UPDATE users SET money='$playermoney'
WHERE username='$username'");
mysql_query("UPDATE housing SET storage='$storage'
WHERE id=$id");
echo "<center><br /><br /><br /><br />". $putmoney ." gold was added into your house storage!<br />";
}
}
?>
<html>
<LINK REL=StyleSheet HREF="style.css" TYPE="text/css" MEDIA=screen>
<head>
<title>Add Money To House<title>
</head>
<body>
<center><a href="playerhouse.php">Back To Your House</a></center>
</body>
</html>Code: Select all
mysql_query("UPDATE users SET money='$playermoney'
WHERE username='$username'");~baseball435
