Inventory Trouble

[Strats]

I have added a couple of things to my inventory and most of it works.

But I got a users shops mod and for some reason when I try to add an item to my shops I get this message.

This item still belongs to your gang, you can't sell it

I Did have a gang armoury but I deleted it so that option should not be there.

Can someone take a look and spot what's wrong.

I'm a bit :?

 

<?php
include "globals.php";
$used=array();
$q=$db->query("SELECT * FROM inventory WHERE inv_userid=$userid");
while ( $r=mysql_fetch_array($q) ) {
if ( ! in_array ( $r['inv_id'], $used ) )
{
$currdel=array();
$used[] =$r['inv_id'];
$currdel[]=$r['inv_id'];
$amount=$r['inv_qty'];
//grab sellers others
$q2=$db->query("SELECT * FROM inventory WHERE inv_userid=$userid AND inv_itemid = {$r['inv_itemid']} AND inv_id != {$r['inv_id']}");
while ( $r2 = mysql_fetch_array($q2) ) {
$used[]=$r2['inv_id'];
$currdel[]=$r2['inv_id'];
$amount+=$r2['inv_qty'];
}
//if($userid == 1)
//print "DEBUG: DELETE FROM inventory WHERE inv_id IN(".implode(",",$currdel).")
";
$db->query("DELETE FROM inventory WHERE inv_id IN(".implode(",",$currdel).")");
//if($userid == 1)
//print "DEBUG: INSERT INTO inventory VALUES('', {$r['inv_itemid']}, $userid, $amount)
";
$db->query("INSERT INTO inventory VALUES('', {$r['inv_itemid']}, $userid, $amount)");

}
}


$q=$db->query("SELECT * FROM items WHERE itmid IN({$ir['equip_primary']}, {$ir['equip_secondary']}, {$ir['equip_armor']})");
print "<h3>Equipped Items</h3><hr />";
while($r=$db->fetch_row($q))
{
$equip[$r['itmid']]=$r;
}
print "<table width='75%' cellspacing='1' class='table'>
<tr>
<th>Primary Move</th>
<td>";
if($equip[$ir['equip_primary']]['itmid'])
{
print $equip[$ir['equip_primary']]['itmname']."</td><td>[url='unequip.php?type=equip_primary']Unequip Move[/url]</td>";
}
else
{
print "None equipped.</td><td> </td>";
}
print "</tr>
<tr>
<th>Secondary Move</th>
<td>";
if($equip[$ir['equip_secondary']]['itmid'])
{
print $equip[$ir['equip_secondary']]['itmname']."</td><td>[url='unequip.php?type=equip_secondary']Unequip Move[/url]</td>";
}
else
{
print "None equipped.</td><td> </td>";
}
print "</tr>
<tr>
<th>Armor</th>
<td>";
if($equip[$ir['equip_armor']]['itmid'])
{
print $equip[$ir['equip_armor']]['itmname']."</td><td>[url='unequip.php?type=equip_armor']Unequip Item[/url]</td>";
}
else
{
print "None equipped.</td><td> </td>";
}
print "</tr>
</table><hr />
<h3>Inventory</h3><hr />";
$inv=$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_userid={$userid} ORDER BY i.itmtype ASC, i.itmname ASC");
if ($db->num_rows($inv) == 0)
{
print "[b]You have no items![/b]";
}
else
{
print "[b]Your items are listed below.[/b]

<table width=100% class=\"table\" border=\"0\" cellspacing=\"1\">
<tr>
<td class=\"h\">Item</td>
<td class=\"h\">Sell Value</td>
<td class=\"h\">Total Sell Value</td>
<td class=\"h\">Links</td>
</tr>";
$lt="";
while($i=$db->fetch_row($inv))
{
if($lt!=$i['itmtypename'])
{
$lt=$i['itmtypename'];
print "\n<tr><td colspan=4>[b]{$lt}[/b]</td></tr>";
}
if($i['weapon'])
{
 $i['itmname']="<font color='red'>*</font>".$i['itmname'];
}
if($i['armor'])
{
 $i['itmname']="<font color='green'>*</font>".$i['itmname'];
}
print "<tr><td>{$i['itmname']}";
if ($i['inv_qty'] > 1)
{
print " x{$i['inv_qty']}";
}
print "</td><td>\${$i['itmsellprice']}</td><td>";
print "$".($i['itmsellprice']*$i['inv_qty']);
print "</td><td>[[url='iteminfo.php?ID={$i[']Info[/url]] [[url='itemsend.php?ID={$i[']Send[/url]] [[url='itemsell.php?ID={$i[']Sell[/url]] [[url='imadd.php?ID={$i[']Add To Market[/url]]"; 
$usershop=$db->query("select * from usershops where userid=$userid");
if(mysql_num_rows($usershop)!=0)
{
$addtoshop="[[url='addtoshop.php?ID={$i[']Put in Shop[/url]]";
}
print"$addtoshop";
if($i['effect1_on'] || $i['effect2_on'] || $i['effect3_on']) {
print " [[url='itemuse.php?ID={$i[']Use[/url]]";
}
if($i['weapon'])
{
print " [[url='equip_weapon.php?ID={$i[']Equip as Weapon[/url]]";
}
if($i['armor'])
{
print " [[url='equip_armor.php?ID={$i[']Equip as Armor[/url]]";
}
print "</td></tr>";
}
print "</table>";
print "[size="1"][b]NB:[/b] Items with a small red [/size]<font color='red'>*</font>[size="1"] next to their name can be used as weapons in combat.

Items with a small green [/size]<font color='green'>*</font>[size="1"] next to their name can be used as armor in combat.[/size]";
}
$h->endpage();
?>

[Lithium]

Re: Inventory Trouble

The issue here seems to be in the file that adds the items to shops not on the inventory one ;)

Also, if you had that mod, it seems to me that you haven't deleted the mysql bits that belong to the mod you removed!

[Strats]

Re: Inventory Trouble

Lol I was sure I had taken from the Inventory.

It's all sorted now :)