query('SELECT inv.item_id, inv.quantity, inv.user_id, it.item_name, it.item_rarity, it.item_image FROM '.$db->prefix.'inventory AS inv INNER JOIN '.$db->prefix.'items AS it ON (it.item_id=inv.item_id) ORDER BY item_name') or error('Unable to fetch item list', __FILE__, __LINE__, $db->error()); while ($cur_item = $db->fetch_assoc($result)) if (isset($_POST['throw'])) { $db->query('UPDATE '.$db->prefix.'inventory SET quantity=quantity-1 WHERE item_id='.$cur_item['item_id'].' AND user_id='.$pun_user['id'].' LIMIT 1') or error('Unable to throw away', __FILE__, __LINE__, $db->error()); } if ($cur_item['quantity'] == '1') $db->query('DELETE FROM '.$db->prefix.'inventory WHERE item_id='.$cur_item['item_id'].' AND user_id='.$pun_user['id']) or error('Unable to throw away item.', __FILE__, __LINE__, $db->error()); redirect($_SERVER['REQUEST_URI'], 'You have thrown away your '.$cur_item['item_name']); } ?>

Your inventory

query('SELECT inv.item_id, inv.quantity, it.item_name, it.item_rarity, it.item_image FROM '.$db->prefix.'inventory AS inv INNER JOIN '.$db->prefix.'items AS it ON (it.item_id=inv.item_id) WHERE user_id='.$pun_user['id'].' ORDER BY item_name') or error('Unable to fetch item list', __FILE__, __LINE__, $db->error()); while ($cur_item = $db->fetch_assoc($result)) { ?>
Image Item Name Rarity Quantity Owned Actions
<?php echo pun_htmlspecialchars($cur_item['item_name']) ?>