[HELP] Vip_points transfer system :)

[Vaulient1]

[LIST=1]
[*][COLOR=#000000]<?php[/COLOR]
[*][COLOR=#000000]        if(isset($_POST['send'])){ // If the form has been submitted.[/COLOR]
[*][COLOR=#000000]       [/COLOR]
[*][COLOR=#000000]        $to = $_POST['to'];[/COLOR]
[*][COLOR=#000000]        $from = $_POST['from'];[/COLOR]
[*][COLOR=#000000]        $amount = $_POST['amount'];[/COLOR]
[*][COLOR=#000000]       [/COLOR]
[*][COLOR=#000000]    $from_sql = "UPDATE users SET vip_points = vip_points - $amount WHERE username='$from'";[/COLOR]
[*][COLOR=#000000]    mysql_query($from_sql);[/COLOR]
[*][COLOR=#000000]    $to_sql = "UPDATE users SET vip_points = vip_points + $amount  WHERE username='$to'";[/COLOR]
[*][COLOR=#000000]    mysql_query($to_sql);[/COLOR]
[*][COLOR=#000000]    }[/COLOR]
[*][COLOR=#000000] [/COLOR]
[*][COLOR=#000000]?>[/COLOR]
[*][COLOR=#000000]<form method="post" action="">[/COLOR]
[*][COLOR=#000000]    <input name="from" type="hidden" value="{username}">[/COLOR]
[*][COLOR=#000000]    Amount: <input name="amount" type="text"><br>[/COLOR]
[*][COLOR=#000000]    To: <input name="to" type="text"><br>[/COLOR]
[*][COLOR=#000000]    <input type="submit" name="send" value="Transfer" />[/COLOR]
[*][COLOR=#000000]</form>

[/COLOR]
Hey guys , thanks for reading my thread , I love you all ^-^ Well you see that php code works efficiently but one problem though , it lets us send how amny vip_points to another user and causing this

You must be registered for see links

you see? -50? Well could anybody of you guys help me to preevent it from deductiong more than 0? Make it to give a warning or a notification saying "you do not have enough shells".
I would be glad if you helped , thank you
[/LIST]

 

[Lotus]

lmao I got this before simple its taking away and adding. command: :shell (username) +50 for Positive Credits, Pixels, Or Shells, For Negative :shell (username) -50

 

[Vaulient1]

That didnt even help a bit , I didnt ask for info , I asked if anybody could fix this to prevent it from decreasing more than 0

 

[Ecko]

Run a query to grab how many points the user who is sending them has:

$query = "SELECT `vip_points` FROM users WHERE username = '$from';
$points = mysql_query($query);

Then an if check to see if the amount is more than what the user has:

if $points > $amount {
echo 'You do not have that many points to transfer.';
} else { run other queries to transfer points.

 

[Vaulient1]

Ahh thank you , but how do I do this , you see im new to this stuff and I really need some guidance. I am sorry if I am irritating.

 

[Ecko]

Ahh thank you , but how do I do this , you see im new to this stuff and I really need some guidance. I am sorry if I am irritating.

I will when I get home from work. Friday is the influx of idiots here.

 

[Vaulient1]

I'm not sure wether you called me an idiot , but ok , thanks though :3

 

[Ecko]

I'm not sure wether you called me an idiot , but ok , thanks though :3

I was referring to the people whose support tickets I've been handling.

For example, Kevin of ameca.org wants to know why he has to have a password for his billing account and a different password for his cPanel...

 

[Vaulient1]

haha ok then

 

[Ecko]

You must be registered for see links

Let me know if that works.

 

[Vaulient1]

Nope bro , it didnt work. Ended in error 505

 

[Ecko]

Error 505? Really?

Inbox me teamviewer details