Jump to content
Sign in to follow this  
Beffic

Mysql Update

Recommended Posts

So I have a stat point distributor for my game and I cannot seem to get it to work.It keeps returning the value to 0 every time I try to increase my stat points.I have maneuvered this code so much and I cannot figure out why...

<?phpinclude("../../connect.php");include("head.php");?><center><table class="content">  <tr><td>    <?php  $Player=$_COOKIE['player_id'];     if(isset($_POST['distribute'])){     $use=$_POST['use'];     $ammount=$_POST['ammount'];     if($User['StatPoint']<$ammount){      print"You do not have <font color=red>".number_format($ammount)."</font> Stat Points!";     }elseif($use=="health"){      $ammount2=$ammount*2;      mysql_query("UPDATE `Users` SET MaxHealth=MaxHealth+'$ammount2', StatPoint=StatPoint-'$ammount' WHERE ID='$Player'")or die(mysql_error());      print"You raised your Max Health by ".$ammount2."!";     }elseif($use=="energy"){      $ammount2=$ammount*2;      mysql_query("UPDATE `Users` SET MaxEnergy=MaxEnergy+'$ammount2', StatPoint=StatPoint-'$ammount' WHERE ID='$Player'");      print"You raised your Max Energy by ".$ammount2."!";     }elseif($use=="strength"){      mysql_query("UPDATE `Users` SET Strength=Strength+'$ammount', StatPoint=StatPoint-'$ammount' WHERE ID='$Player'");      print"You raised your Strength by ".$ammount."!";     }elseif($use=="wisdom"){      mysql_query("UPDATE `Users` SET Wisdom=Wisdom+'$ammount', StatPoint=StatPoint-'$ammount' WHERE ID='$Player'");      print"You raised your Wisdom by ".$ammount."!";     }elseif($use=="defence"){      mysql_query("UPDATE `Users` SET Defence=Defence+'$ammount', StatPoint=StatPoint-'$ammount' WHERE ID='$Player'");      print"You raised your Defence by ".$ammount."!";     }elseif($use=="dexterity"){      mysql_query("UPDATE `Users` SET Dexterity=Dexterity+'$ammount', StatPoint=StatPoint-'$ammount' WHERE ID='$Player'");      print"You raised your Dexterity by ".$ammount."!";     }elseif($use=="accuracy"){      mysql_query("UPDATE `Users` SET Accuracy=Accuracy+'$ammount', StatPoint=StatPoint-'$ammount' WHERE ID='$Player'");      print"You raised your Accuracy by ".$ammount."!";     }else{      print"No use selected!";     }       }  ?>      <h1>Distribute Stat Points!</h1><br><br>        <p>Here you can distribute your Stat Points gained from Leveling to your User Stats so not everyone will have the same stats all the time. Distribute your way!<br><br>        <?php    print"You have ".number_format($User['StatPoint'])." Stat Points to spend!<br>";    print"<form method=\"post\" action=\"statpointdistributer.php\">Stat Points to use: <input type=\"text\" name\"ammount\"> Use: <select name=\"use\"><option value=\"health\">Max Health X 2</option><option value=\"energy\">Max Energy X 2</option><option value=\"strength\">Strength</option><option value=\"wisdiom\">Wisdom</option><option value=\"defence\">Defence</option><option value=\"dexterity\">Dexterity</option><option value=\"accuracy\">Accuracy</option></select><input type=submit value=\"Distribute\" name=distribute></form>";     ?><br><br>        Would you like to return to your adventure? <a href="index.php">Yes</a>    </p>  </td></tr></table></center>

Share this post


Link to post
Share on other sites

It's kind of hard to follow what's going on, you need to add some debugging statements. Print out the amounts and different variables you're using. It doesn't look like you're setting $User.

Share this post


Link to post
Share on other sites

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.   Paste as plain text instead

  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.

Loading...
Sign in to follow this  

×
×
  • Create New...