Jump to content

Not updating the Database.


dean7

Recommended Posts

Hey all, I've recently been coding a Bank for my game in which users can desposit there money into. But while coding it I've came though a few errors in which I carn't seem to sort :(

 

<?php
session_start();
include_once ("includes/functions.php");
include ("includes/config.php");
require ("crewtop.php");
logincheck();

ini_set ('display_errors', 1);
error_reporting (E_ALL);

$username = $_SESSION['username'];

$getuser = mysql_query("SELECT * FROM users WHERE username='$username'");
$user = mysql_fetch_object($getuser);

$themembers = mysql_query("SELECT * FROM users WHERE crew = '$user->crew'");
	$ammoutmembers = mysql_num_rows($themembers);

$crew = mysql_query("SELECT * FROM crews WHERE name = '$user->crew'");		
	$crewstuff = mysql_fetch_object($crew);

// Got everything needed....

if ($_POST['desposit']){
$desposit = strip_tags($_POST['desposit']);
if ($desposit > $user->money){ // *** This Line ***
	echo ("You haven't got that much Money to Desposit!");
}elseif ($desposit <= $user->money){
	if  (ereg('[^0-9]',$desposit)){
		echo ("Invalid Numbers Posted!");
		}elseif(!ereg('[^0-9]',$desposit)){
				mysql_query("UPDATE crews SET bank=bank+$desposit WHERE name='$user->crew'");
				mysql_query("UPDATE users SET money=money-$desposit WHERE username='$username'");
					echo ('You successfully Deposited £".number_format($desposit)."!');
			}
	}
}

/* Deposit done - 
	Now Withdraw... */

if ($_POST['withdraw']){
$withdraw = strip_tags($_POST['withdraw']);
if ($withdraw > $crewstuff->bank){ // *** This Line ***
	echo ("You don't have that much Money in the Bank!");
}elseif ($withdraw <= $crewstuff->bank){
			if  (ereg('[^0-9]',$withdraw)){
			echo "Invalid Numbers Posted!";
		}elseif(!ereg('[^0-9]',$withdraw)){
				$leftinbank = $crewstuff->bank - $withdraw;
				mysql_query("UPDATE crews SET bank=bank-$withdraw WHERE name='$user->crew'");
				mysql_query("UPDATE users SET money=money+$withdraw WHERE username='$username'");
				echo ('£".number_format($withdraw)." has been Withdraw from the Crew Bank!');
			}
	}
}	
// Withdraw done!
?>
<html>
<head>
<title>Crew Bank || SD</title>
<link rel="stylesheet" href="style.css" type="text/css">
</head>
<body class='body'>
<form action='' method='POST' name='crewbank'>
<?php

echo ("$username , $user->money");

?>
<?php
	if ($username != $crewstuff->boss || $username != $crewstuff->coowner || $username != $crewstuff->underboss || $username == $crewstuff->recruiter || $username == $crewstuff->recruiterone || $crewstuff->boss == $username || $crewstuff->coowner == $username || $crewstuff->underboss == $username){
?>
<table width='50%' cellpadding='0' cellspacing='0' border='1' class='table' colspan='2' align='center'>
	<tr>
		<td class='header' align='center' colspan='2'>Crew Bank</td>
	</tr>
	<tr>
		<td class='omg' colspan='2' align='center'>You Have <strong>£<?php echo "".number_format($crewstuff->bank).""; ?></strong> in the Crew Bank!</td>
	</tr>	
	<tr>
		<td align='center' width='50%'>Deposit:</td><td align='center' width='50%'><input type='text' name='desposit' class='input' id='desposit'></td>
	</tr>
	<tr>
		<td align='center' colspan='2' align='center'><input type='submit' name='desposit' class='button' id='despositmoney' Value='Deposit!'></td>
	</tr>
	<?php
	} // Boss
	?>
	</table>
	<br />
	<?php
	if ($crewstuff->boss == $username || $crewstuff->coowner == $username || $crewstuff->underboss == $username){
	?>
	<table width='50%' cellpadding='0' cellspacing='0' border='1' class='table' colspan='2' align='center'>
	<tr>
		<td class='header' align='center' colspan='2'>Crew Bank - Withdraw</td>
	</tr>	
	<tr>
		<td class='omg' align='center' colspan='2'>You carn't Withdraw more Money then there is in your Bank!</td>
	</tr>	
	</tr>
	<tr>
		<td align='center' width='50%'>Withdraw:</td><td width='50%' align='center'><input type='text' name='withdraw' class='input' id='withdraw'></td>
	</tr>
	<tr>
		<td align='center' colspan='2' align='center'><input type='submit' name='withdraw' class='button' id='withdrawmoney' Value='Withdraw!'></td>
	</tr>
	</table>
	<?php
	} // Boss .. Underboss
	?>		
</form>
</body>
</html>

 

The two lines with the Comments on " // *** This Line *** " are the parts I've got a problem with.

 

When a User is either despositing or Withdrawing there money it says there isn't enouth Money in the Bank, or that they don't have enouth Money, even when they have enouth.

 

Anyone see why its saying the Error?

 

Thanks in advance :)

 

Link to comment
Share on other sites

yeah, without seeing output it's anyone's guess. what are the values being compared on this line?

 

echo "deposit: $deposit <br />";
echo "user->money: ".$user->money."<br />";
if ($desposit > $user->money)

 

i'd also check your SQL and verify that the queries are actually executing, for example:

 

$sql = "SELECT * FROM users WHERE crew = '$user->crew'";
echo "sql: $sql <br />";
$themembers = mysql_query($sql) or die(mysql_error());

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.