[PHP]Negative numbers

[caja]

When I do my rebirth I get a problem because it get money from inventory, and if you don't have it put negative number.
How to fix that:s?

      if ($act == 'reborn')
      {
         $id = $_GET["charid"];
         $matchrows = mysql_query("SELECT * FROM characters AS c INNER JOIN accounts AS a ON a.username = c.accountname WHERE c.id = $id AND a.username = '$user'");
         $checkrows = @mysql_num_rows($matchrows);
         if ($checkrows != 0)
         {
            $id = $_GET["charid"];
            $query = mysql_query("SELECT * FROM characters WHERE id = $id");
            $get = @mysql_fetch_array($query);
            $class = $get['class'];
            $lvl = $get['level'];
			$penya = $get['penya'];
            $rebirths = $get['rebirths'];
			$maxrebirths = 50;
            
            if (($lvl == 120) && ($class >= 24) && ($class <= 31) && ($rebirths < $maxrebirths))
            {
               if ($class == 24) { mysql_query("UPDATE characters SET class = 6 WHERE id = $id"); }
               if ($class == 25) { mysql_query("UPDATE characters SET class = 7 WHERE id = $id"); }
               if ($class == 26) { mysql_query("UPDATE characters SET class = 8 WHERE id = $id"); }
               if ($class == 27) { mysql_query("UPDATE characters SET class = 9 WHERE id = $id"); }
               if ($class == 28) { mysql_query("UPDATE characters SET class = 10 WHERE id = $id"); }
               if ($class == 29) { mysql_query("UPDATE characters SET class = 11 WHERE id = $id"); }
               if ($class == 30) { mysql_query("UPDATE characters SET class = 12 WHERE id = $id"); }
               if ($class == 31) { mysql_query("UPDATE characters SET class = 13 WHERE id = $id"); }
               
               mysql_query("UPDATE characters SET level = 60 WHERE id = $id");
               mysql_query("UPDATE characters SET posWorldID = 1 WHERE id = $id");
               mysql_query("UPDATE characters SET posX = 6973 WHERE id = $id");
               mysql_query("UPDATE characters SET posY = 10 WHERE id = $id");
               mysql_query("UPDATE characters SET posZ = 3328 WHERE id = $id");
               mysql_query("UPDATE characters SET rebirths = rebirths + 1 WHERE id = $id");
			   mysql_query("UPDATE characters SET exp = 9421875 WHERE id = $id");
			   mysql_query("UPDATE characters SET penya = $penya - 20000000 WHERE id = $id");
               
               if (mysql_affected_rows() != 0)
               {
                  echo "<center><h3>Character has successfully been reborn!</h3></center>";
               }
               else
               {
                  echo "<center><h3>An error has occured, please try again.</h3></center>";
               }
            }
            else
            {
               echo "<center><h3>Your character can not yet be reborn. You must be level 120 HERO and get 20000000 of penya.</h3></center>";
            }
         }
      }

For example rebirth cost 20mill and if I have 10mill, I get rebirth and too I get -10mill. I want, what if no have money cannot rebirth

 

[shadow-xx]

Add a if statement that will check if the character has 10 mill or more

if you dont know how
> http://tizag.com

 

[jordyvdboom]

If else statement I think.

something like:

if $penya = 20000000{

echo "Character has succesfully been reborn";

}
else{
echo "You don't have enough mesow to rebirth";
}

This is not the exact script but think something in this.

PS: maybe you can try to chance - 20000000 in to -20000000

Cheers,
Jordy

 

[caja]

Thanx it work=)

 

[EliteGM]

Jordy's code will not function perfectly ofcourse.

<?php
    if ($penja >= 20000000)
    {
        echo "Successfully done.";
    }
    else
    {
        echo "Not enough money!";
    }
?>

 

[caja]

EDIT: I solve my problem whit this code

if (($lvl == 120) && ($class >= 24) && ($class <= 31) && ($rebirths < $maxrebirths) && ($penya >= 20000000))

 if (($penya >= '20000000') && ($lvl = '120')){

 

[BBim]

this should work:

if ($act == 'reborn')
      {
         $id = $_GET["charid"];
         $matchrows = mysql_query("SELECT * FROM characters AS c INNER JOIN accounts AS a ON a.username = c.accountname WHERE c.id = $id AND a.username = '$user'");
         $checkrows = @mysql_num_rows($matchrows);
         if ($checkrows != 0)
         {
            $id = $_GET["charid"];
            $query = mysql_query("SELECT * FROM characters WHERE id = $id");
            $get = @mysql_fetch_array($query);
            $class = $get['class'];
            $lvl = $ge\t['level'];
            $penya = $get['penya'];
            $rebirths = $get['rebirths'];
            $maxrebirths = 50;
            if ($penya >= 20000000)
			{
				$penya -= 20000000;
	            if (($lvl == 120) && ($class >= 24) && ($class <= 31) && ($rebirths < $maxrebirths))
	            {
	               if ($class == 24) { mysql_query("UPDATE characters SET class = 6 WHERE id = $id"); }
	               if ($class == 25) { mysql_query("UPDATE characters SET class = 7 WHERE id = $id"); }
	               if ($class == 26) { mysql_query("UPDATE characters SET class = 8 WHERE id = $id"); }
	               if ($class == 27) { mysql_query("UPDATE characters SET class = 9 WHERE id = $id"); }
	               if ($class == 28) { mysql_query("UPDATE characters SET class = 10 WHERE id = $id"); }
	               if ($class == 29) { mysql_query("UPDATE characters SET class = 11 WHERE id = $id"); }
	               if ($class == 30) { mysql_query("UPDATE characters SET class = 12 WHERE id = $id"); }
	               if ($class == 31) { mysql_query("UPDATE characters SET class = 13 WHERE id = $id"); }
	               
	               mysql_query("UPDATE characters SET level = 60 WHERE id = $id");
	               mysql_query("UPDATE characters SET posWorldID = 1 WHERE id = $id");
	               mysql_query("UPDATE characters SET posX = 6973 WHERE id = $id");
	               mysql_query("UPDATE characters SET posY = 10 WHERE id = $id");
	               mysql_query("UPDATE characters SET posZ = 3328 WHERE id = $id");
	               mysql_query("UPDATE characters SET rebirths = rebirths + 1 WHERE id = $id");
	               mysql_query("UPDATE characters SET exp = 9421875 WHERE id = $id");
	               mysql_query("UPDATE characters SET penya = $penya WHERE id = $id");
	               
	               if (mysql_affected_rows() != 0)
	               {
	                  echo "<center><h3>Character has successfully been reborn!</h3></center>";
	               }
	               else
	               {
	                  echo "<center><h3>An error has occured, please try again.</h3></center>";
	               }
	            }
	            else
	            {
	               echo "<center><h3>Your character can not yet be reborn. You must be level 120 HERO.</h3></center>";
	            }
			}
			else
				echo "<center><h3>Not enought money.</h3></center>
         }
      }

 

[jordyvdboom]

Thats more like it indeed