Jump to content
MakeWebGames

Slight Problem! Need Help


Recommended Posts

Hey I Have A Little Problem that i can not quite fix: when i use an item it uses 2! for some strange reason i have checked itemuse.php and there is no problem in there as i can NOT! Release my game if i don't fix this you may understand what i mean But if some one could help it would be greatly appreciated Thank You

Here is my itemuse.php!

<?php
include "globals.php";
$_GET['ID'] = abs((int) $_GET['ID']);
//Food
if(!$_GET['ID'])
{
print "Invalid use of file";
}
else
{
$i=$db->query("SELECT iv.*,i.*,it.* FROM inventory iv LEFT JOIN items i ON iv.inv_itemid=i.itmid LEFT JOIN itemtypes it ON i.itmtype=it.itmtypeid WHERE iv.inv_id={$_GET['ID']} AND iv.inv_userid=$userid");
if(mysql_num_rows($i) == 0)
{
print "Invalid item ID";
}
else
{
$r=$db->fetch_row($i);
if(!$r['effect1_on'] && !$r['effect2_on'] && !$r['effect3_on'])
{
 die("Sorry, this item cannot be used as it has no effect.");
}
if($r['effect1_on'])
{
 $einfo=unserialize($r['effect1']);
 if($einfo['inc_type']=="percent")
 {
   if(in_array($einfo['stat'],array('energy','will','brave','hp')))
   {

     $inc=round($ir['max'.$einfo['stat']]/100*$einfo['inc_amount']);
   }
   else
   {
     $inc=round($ir[$einfo['stat']]/100*$einfo['inc_amount']);
   }
 }
 else
 {
   $inc=$einfo['inc_amount'];
 }
 if($einfo['dir']=="pos")
 {
   if(in_array($einfo['stat'],array('energy','will','brave','hp')))
   {
     $ir[$einfo['stat']]=min($ir[$einfo['stat']]+$inc, $ir['max'.$einfo['stat']]);
   }
   else
   {
     $ir[$einfo['stat']]+=$inc;
   }
 }
 else
 {

     $ir[$einfo['stat']]=max($ir[$einfo['stat']]-$inc, 0);

 }
 $upd=$ir[$einfo['stat']];
 if(in_array($einfo['stat'], array('strength', 'agility', 'guard', 'labour', 'IQ')))
 {
   $db->query("UPDATE `userstats` SET {$einfo['stat']} = '{$upd}' WHERE userid={$userid}");
 }
 else
 {
   $db->query("UPDATE `users` SET {$einfo['stat']} = '{$upd}' WHERE userid={$userid}");
 }
}
if($r['effect2_on'])
{
 $einfo=unserialize($r['effect2']);
 if($einfo['inc_type']=="percent")
 {
   if(in_array($einfo['stat'],array('energy','will','brave','hp')))
   {

     $inc=round($ir['max'.$einfo['stat']]/100*$einfo['inc_amount']);
   }
   else
   {
     $inc=round($ir[$einfo['stat']]/100*$einfo['inc_amount']);
   }
 }
 else
 {
   $inc=$einfo['inc_amount'];
 }
 if($einfo['dir']=="pos")
 {
   if(in_array($einfo['stat'],array('energy','will','brave','hp')))
   {
     $ir[$einfo['stat']]=min($ir[$einfo['stat']]+$inc, $ir['max'.$einfo['stat']]);
   }
   else
   {
     $ir[$einfo['stat']]+=$inc;
   }
 }
 else
 {

     $ir[$einfo['stat']]=max($ir[$einfo['stat']]-$inc, 0);

 }
 $upd=$ir[$einfo['stat']];
 if(in_array($einfo['stat'], array('strength', 'agility', 'guard', 'labour', 'IQ')))
 {
   $db->query("UPDATE `userstats` SET {$einfo['stat']} = '{$upd}' WHERE userid={$userid}");
 }
 else
 {
   $db->query("UPDATE `users` SET {$einfo['stat']} = '{$upd}' WHERE userid={$userid}");
 }
}
if($r['effect3_on'])
{
 $einfo=unserialize($r['effect3']);
 if($einfo['inc_type']=="percent")
 {
   if(in_array($einfo['stat'],array('energy','will','brave','hp')))
   {

     $inc=round($ir['max'.$einfo['stat']]/100*$einfo['inc_amount']);
   }
   else
   {
     $inc=round($ir[$einfo['stat']]/100*$einfo['inc_amount']);
   }
 }
 else
 {
   $inc=$einfo['inc_amount'];
 }
 if($einfo['dir']=="pos")
 {
   if(in_array($einfo['stat'],array('energy','will','brave','hp')))
   {
     $ir[$einfo['stat']]=min($ir[$einfo['stat']]+$inc, $ir['max'.$einfo['stat']]);
   }
   else
   {
     $ir[$einfo['stat']]+=$inc;
   }
 }
 else
 {

     $ir[$einfo['stat']]=max($ir[$einfo['stat']]-$inc, 0);

 }
 $upd=$ir[$einfo['stat']];
 if(in_array($einfo['stat'], array('strength', 'agility', 'guard', 'labour', 'IQ')))
 {
   $db->query("UPDATE `userstats` SET {$einfo['stat']} = '{$upd}' WHERE userid={$userid}");
 }
 else
 {
   $db->query("UPDATE `users` SET {$einfo['stat']} = '{$upd}' WHERE userid={$userid}");
 }
}
print "{$r['itmname']} used successfully!";
item_remove($userid, $r['inv_itemid'], 1);
}
}
$h->endpage();
?>
Link to comment
Share on other sites

Re: Slight Problem! Need Help

 

<?phpinclude "globals.php";$_GET['ID'] = abs((int) $_GET['ID']);//Foodif(!$_GET['ID']){print "Invalid use of file";}else{$i=$db->query("SELECT iv.*,i.*,it.* FROM inventory iv LEFT JOIN items i ON iv.inv_itemid=i.itmid LEFT JOIN itemtypes it ON i.itmtype=it.itmtypeid WHERE iv.inv_id={$_GET['ID']} AND iv.inv_userid=$userid");if(mysql_num_rows($i) == 0){print "Invalid item ID";}else{$r=$db->fetch_row($i);if(!$r['effect1_on'] && !$r['effect2_on'] && !$r['effect3_on']){  die("Sorry, this item cannot be used as it has no effect.");}if($r['effect1_on']){  $einfo=unserialize($r['effect1']);  if($einfo['inc_type']=="percent")  {    if(in_array($einfo['stat'],array('energy','will','brave','hp')))    {      $inc=round($ir['max'.$einfo['stat']]/100*$einfo['inc_amount']);    }    else    {      $inc=round($ir[$einfo['stat']]/100*$einfo['inc_amount']);    }  }  else  {    $inc=$einfo['inc_amount'];  }  if($einfo['dir']=="pos")  {    if(in_array($einfo['stat'],array('energy','will','brave','hp')))    {      $ir[$einfo['stat']]=min($ir[$einfo['stat']]+$inc, $ir['max'.$einfo['stat']]);    }    else    {      $ir[$einfo['stat']]+=$inc;    }  }  else  {      $ir[$einfo['stat']]=max($ir[$einfo['stat']]-$inc, 0);  }  $upd=$ir[$einfo['stat']];  if(in_array($einfo['stat'], array('strength', 'agility', 'guard', 'labour', 'IQ')))  {    $db->query("UPDATE `userstats` SET {$einfo['stat']} = '{$upd}' WHERE userid={$userid}");  }  else  {    $db->query("UPDATE `users` SET {$einfo['stat']} = '{$upd}' WHERE userid={$userid}");  }}if($r['effect2_on']){  $einfo=unserialize($r['effect2']);  if($einfo['inc_type']=="percent")  {    if(in_array($einfo['stat'],array('energy','will','brave','hp')))    {      $inc=round($ir['max'.$einfo['stat']]/100*$einfo['inc_amount']);    }    else    {      $inc=round($ir[$einfo['stat']]/100*$einfo['inc_amount']);    }  }  else  {    $inc=$einfo['inc_amount'];  }  if($einfo['dir']=="pos")  {    if(in_array($einfo['stat'],array('energy','will','brave','hp')))    {      $ir[$einfo['stat']]=min($ir[$einfo['stat']]+$inc, $ir['max'.$einfo['stat']]);    }    else    {      $ir[$einfo['stat']]+=$inc;    }  }  else  {      $ir[$einfo['stat']]=max($ir[$einfo['stat']]-$inc, 0);  }  $upd=$ir[$einfo['stat']];  if(in_array($einfo['stat'], array('strength', 'agility', 'guard', 'labour', 'IQ')))  {    $db->query("UPDATE `userstats` SET {$einfo['stat']} = '{$upd}' WHERE userid={$userid}");  }  else  {    $db->query("UPDATE `users` SET {$einfo['stat']} = '{$upd}' WHERE userid={$userid}");  }}if($r['effect3_on']){  $einfo=unserialize($r['effect3']);  if($einfo['inc_type']=="percent")  {    if(in_array($einfo['stat'],array('energy','will','brave','hp')))    {      $inc=round($ir['max'.$einfo['stat']]/100*$einfo['inc_amount']);    }    else    {      $inc=round($ir[$einfo['stat']]/100*$einfo['inc_amount']);    }  }  else  {    $inc=$einfo['inc_amount'];  }  if($einfo['dir']=="pos")  {    if(in_array($einfo['stat'],array('energy','will','brave','hp')))    {      $ir[$einfo['stat']]=min($ir[$einfo['stat']]+$inc, $ir['max'.$einfo['stat']]);    }    else    {      $ir[$einfo['stat']]+=$inc;    }  }  else  {      $ir[$einfo['stat']]=max($ir[$einfo['stat']]-$inc, 0);  }  $upd=$ir[$einfo['stat']];  if(in_array($einfo['stat'], array('strength', 'agility', 'guard', 'labour', 'IQ')))  {    $db->query("UPDATE `userstats` SET {$einfo['stat']} = '{$upd}' WHERE userid={$userid}");  }  else  {    $db->query("UPDATE `users` SET {$einfo['stat']} = '{$upd}' WHERE userid={$userid}");  }}print "{$r['itmname']} used successfully!";}}$h->endpage();?>

soz if it doesnt work

Link to comment
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.

×
×
  • Create New...