stuck with php upgrade on a rpg game

[alcapone]

hello there im looking for any help i can get with this i added this part of the script to my attack script were you will steal the other players guns as well as attack if you win when you attack if not they steal your weapons i have it so they show up when you win bu it dont take the guns away from the other player here is what was added

PHP Code:

srand((float)microtime()*100);
 $stolenGlock = 0;$stolenAK47 = 0;$stolenShotgun = 0;$stolenUzi = 0;
 if($your_kills > $his_kills){
  $stolenGlock  = round(($pmp[5]/100)*rand(5, 15), 0);
  $stolenShotgun = round(($pmp[6]/100)*rand(5, 15), 0);
  $stolenUzi  = round(($pmp[7]/100)*rand(5, 15), 0);
  $stolenAK47  = round(($pmp[8]/100)*rand(5, 15), 0);
  
  $query = sprintf("UPDATE %s SET glock=glock+%s, shotgun=shotgun+%s, uzi=uzi+%s, ak47=ak47+%s WHERE id=%s",
       $tab["pimp"], $stolenGlock, $stolenShotgun, $stolenUzi, $stolenAK47, $id);
  mysql_query($query);
 $query = sprintf("UPDATE %s SET glock=glock-%s, shotgun=shotgun-%s, uzi=uzi-%s, ak47=ak47-%s WHERE pimp=%s",
       $tab["pimp"], $stolenGlock, $stolenShotgun, $stolenUzi, $stolenAK47, $pid);
  mysql_query($query);
 }else{
  $stolenGlock  = round(($pimp[16]/100)*rand(5, 15), 0);
  $stolenShotgun = round(($pimp[17]/100)*rand(5, 15), 0);
  $stolenUzi  = round(($pimp[18]/100)*rand(5, 15), 0);
  $stolenAK47  = round(($pimp[19]/100)*rand(5, 15), 0);
  
  $query = sprintf("UPDATE %s SET glock=glock+%s, shotgun=shotgun+%s, uzi=uzi+%s, ak47=ak47+%s WHERE pimp=%s",
       $tab["pimp"], $stolenGlock, $stolenShotgun, $stolenUzi, $stolenAK47, $pid);
  mysql_query($query);
  $query = sprintf("UPDATE %s SET glock=glock-%s, shotgun=shotgun-%s, uzi=uzi-%s, ak47=ak47-%s WHERE id=%s",
       $tab["pimp"], $stolenGlock, $stolenShotgun, $stolenUzi, $stolenAK47, $id);
  mysql_query($query);
 }
 ?> 


now when you attack some one this is what it will say

you killed 1,111 ( 100 thugs 1,011 hitmen 0 bodyguards ) of rocky 's boys in the attack.
your 960 were killed ( 0 thugs 0 hitmen 960 bodyguards )

you ganked $ 80 from rocky 's dead thugs.
you also stole 414 AK47s, 502 glocks, 0 shotguns and 0 uzis

and it will add the guns to me after the attack but it dont take them away from the player i attack
i beleive the problem is some were in the - part of the code any helpwould be great

[jdk]

Make sure $pmp[5], [6], [7], [8] and $pimp[16],[17],[18],[19] match up to the proper fields in your mysql query where you get the values.

The problem is many people are copying a piece of code here or there from other games and sometimes their queries are not in the same order or do not correspond to the same values.

I have had to fix problems like this recently on many games.

Hope this helps.

[alcapone]

i checked that thats all good im really stumped on this one i mean they will add to you if you hit someone but wont take them away you see anything with the code that might not be right

[jdk]

I'll try and look tomorrow. I am going to bed.