script is pulling more then they have....

Posted on 16th Feb 2014 07:03 pm by admin

I have this script for my game where they can change there race. This will cost them 2,500 points. However in our database points are called crystals.

If the person has 500 points, and the script takes 2,500 it will put them at -2,000 points. I need the script to tell them they dont have enough points and then not change there race because they dont have enough to do so. However im not to sure on how I would write it.

This is the race change script im editing, can anyone explain how to write this to do what I need:

Code: function conf_race_change()
{
global $ir,$c,$userid,$h;
if($ir['race'] == "Pirate") { $r="Ninja"; } else { $r="Pirate"; }
print "Switching your race will cost 2,500 points. Are you sure you want to become a $r?<br />
<a href='preferences.php?action=racechange2'>Yes</a> | <a href='preferences.php'>No</a>";
}
function do_race_change()
{
global $db,$ir,$c,$userid,$h;
if($ir['race'] == "Pirate") { $r="Ninja"; } else { $r="Pirate"; }
$db->query("UPDATE users SET race='$r' WHERE userid=$userid");
$db->query("UPDATE users SET crystals=crystals-2500 WHERE userid=$userid");
print "Success, you are now $r!<br />
<a href='preferences.php'>Back</a>";
}

Your Answer:

Login to answer

Other forums

Check Digits and extracting digits
I think I can figure out the code for this but I am having a very hard time getting past the first s

problem when runing a funciton
I am trying to connect to database using a funciton in a functions.php

<?php
funct

PHP loop
Okay so I have several "articles" stored in a mysql database and am attempting to echo tho

getting a website's source code as a variable? How?
Hey guys, is there any way for me to get the source code of a website as a variable for me to work w

Secure pages Sessions vs. Cookies & session_destroy() help
Im new here and new to PHP, I hope you can help me with some questions.

Im writing my web ap

pspell
using pspell, is it possible to get words that would be best in the current phrase?

For examp

Help with usergroups? prolly really quick
So were coding our own forums for a game system we made an we have the users level setup but now I n

Get to know your fellow coder
I think it's time we got personal around here. There's a lot of code swapping and a few members kno

'grab_files', multiple extension?
hey guys,

can anyone suggest a way to make to following line of code look for files with more

Socket Server
In my following socket server, I am trying to listen to a connection through port 12345 in my web br