session_start();
include "globals.php";
$used=array();
$q=mysql_query("SELECT * FROM inventory WHERE inv_userid=$userid", $c);
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']}", $c);
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).")", $c);
//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)", $c);
print "$amount of item id {$r['inv_itemid']} quantified...
";
}
}
print "[b]<font color='red'>Quantifying Done</font>[/b]
<hr width=50%><center><a href=inventory.php>>Back to your Items</a>
<hr width=50%>";
$h->endpage();
?>