continue;
}
$row['price'] = getItemPrice($row['inventoryid'], 0);
$row['sdam'] = getItemStats($row['inventoryid'], "sdam");
$row['pdam'] = getItemStats($row['inventoryid'], "pdam");
$row['bdam'] = getItemStats($row['inventoryid'], "bdam");
$row['adam'] = getItemStats($row['inventoryid'], "adam");
$row['ddam'] = getItemStats($row['inventoryid'], "ddam");
$row['sarm'] = getItemStats($row['inventoryid'], "sarm");
$row['parm'] = getItemStats($row['inventoryid'], "parm");
$row['barm'] = getItemStats($row['inventoryid'], "barm");
$row['aarm'] = getItemStats($row['inventoryid'], "aarm");
$row['darm'] = getItemStats($row['inventoryid'], "darm");
$row['hpreg'] = getItemStats($row['inventoryid'], "hpreg");
$row['mpreg'] = getItemStats($row['inventoryid'], "mpreg");
$row['itemdes'] = getItemDes($row['inventoryid'], 0, 0, 0);
$itemlist[] = $row;
}
if (isset($_GET['order'])) {
if ($_GET['order'] == "des") {
usort($itemlist, 'sort_down');
} else {
usort($itemlist, 'sort_up');
}
}
/*echo "<div class='parchment'><h3>Items for sale:</h3>";
echo "<table><tr><th>Prefix<br><a href='?sort=prefixname&order=up'>↑</a> <a href='?sort=prefixname&order=down'>↓</a></th><th>Base<br><a href='?sort=basename&order=up'>↑</a> <a href='?sort=basename&order=down'>↓</a></th><th>Suffix<br><a href='?sort=suffixname&order=up'>↑</a> <a href='?sort=suffixname&order=down'>↓</a></th><th>For Sale Until<br><a href='?sort=time&order=up'>↑</a> <a href='?sort=time&order=down'>↓</a></th><th>Slot<br><a href='?sort=slot&order=up'>↑</a> <a href='?sort=slot&order=down'>↓</a></th><th>S. Dmg<br><a href='?sort=sdam&order=up'>↑</a> <a href='?sort=sdam&order=down'>↓</a></th><th>P. Dmg<br><a href='?sort=pdam&order=up'>↑</a> <a href='?sort=pdam&order=down'>↓</a></th><th>B. Dmg<br><a href='?sort=bdam&order=up'>↑</a> <a href='?sort=bdam&order=down'>↓</a></th><th>S. Arm<br><a href='?sort=sarm&order=up'>↑</a> <a href='?sort=sarm&order=down'>↓</a></th><th>P. Arm<br><a href='?sort=parm&order=up'>↑</a> <a href='?sort=parm&order=down'>↓</a></th><th>B. Arm<br><a href='?sort=barm&order=up'>↑</a> <a href='?sort=barm&order=down'>↓</a></th><th>HP Regen<br><a href='?sort=hpreg&order=up'>↑</a> <a href='?sort=hpreg&order=down'>↓</a></th><th>MP Regen<br><a href='?sort=mpreg&order=up'>↑</a> <a href='?sort=hpreg&order=down'>↓</a></th><th>Description</th><th>Buy Item<br><a href='?sort=price&order=up'>↑</a> <a href='?sort=price&order=down'>↓</a></th></tr>";
foreach($itemlist as $item => $row) {
echo "<tr><td>" . $row['prefixname'];
if($row['prefixlevel'] > 0) { echo "(" . $row['prefixlevel'] . ")"; }
echo "</td><td>" . $row['basename'] . "(" . $row['baselevel'] . ")</td><td>" . $row['suffixname'];
getAllSlot($id, $hero['dungeonlevel'], 'Legs', 1);
echo "</select></td><td>" . getItemDes(0, $id, 'Legs', 1) . "</td></tr>";
echo "<tr><td>Feet:</td><td><select name='feet' onChange='this.form.submit();'>";
getAllSlot($id, $hero['dungeonlevel'], 'Feet', 1);
echo "</select></td><td>" . getItemDes(0, $id, 'Feet', 1) . "</td></tr>";
echo "</table>";
echo "</form>";
} else {
echo "<br><table>";
echo "<tr><td>Main Hand:</td><td>" . getItemName($id, 'Two Hand', 1, 0, 0, 0, 0, 0, 0) . "</td><td>" . getItemDes(0, $id, 'Two Hand', 1) . "</td></tr>";
echo "<tr><td>Off Hand:</td><td>" . getItemName($id, 'Hand', 2, 0, 0, 0, 0, 0, 0) . "</td><td>" . getItemDes(0, $id, 'Hand', 2) . "</td></tr>";
echo "<tr><td>Head:</td><td>" . getItemName($id, 'Head', 1, 0, 0, 0, 0, 0, 0) . "</td><td>" . getItemDes(0, $id, 'Head', 1) . "</td></tr>";
echo "<tr><td>Torso:</td><td>" . getItemName($id, 'Torso', 1, 0, 0, 0, 0, 0, 0) . "</td><td>" . getItemDes(0, $id, 'Torso', 1) . "</td></tr>";
echo "<tr><td>Arms:</td><td>" . getItemName($id, 'Arms', 1, 0, 0, 0, 0, 0, 0) . "</td><td>" . getItemDes(0, $id, 'Arms', 1) . "</td></tr>";
echo "<tr><td>Legs:</td><td>" . getItemName($id, 'Legs', 1, 0, 0, 0, 0, 0, 0) . "</td><td>" . getItemDes(0, $id, 'Legs', 1) . "</td></tr>";
echo "<tr><td>Feet:</td><td>" . getItemName($id, 'Feet', 1, 0, 0, 0, 0, 0, 0) . "</td><td>" . getItemDes(0, $id, 'Feet', 1) . "</td></tr>";
}
echo "</table></div>";
echo "<form name='attributefrm' id='attributefrm' method='POST' action='profile.php'><input name='attribute' type='hidden' value='' id='attributeID'></form>";
mysqli_close($conn);
function getAllSlot($hero, $level, $slot, $equip)
{
$conn = mysqli_connect("ucfsh.ucfilespace.uc.edu", "piattjd", "curtis1", "piattjd");
/*if($slot == 'Hand' && getItemName($hero, 'Two Hand', 1, 0, 0, 0, 0, 0, 0)) {
echo "<option value=''>N/A</option>";
mysqli_close($conn);
return;
}*/
echo "<option value=''>----------</option>";
if ($slot == 'Two Hand') {
$query = "SELECT * FROM Inventory LEFT JOIN ItemBase ON Inventory.base = ItemBase.baseid Left JOIN ItemPrefix ON Inventory.prefix = ItemPrefix.prefixid LEFT JOIN ItemSuffix ON Inventory.suffix = ItemSuffix.suffixid WHERE Inventory.owner = '{$hero}' AND Inventory.time = '0' AND Inventory.baselevel <= '{$level}' AND (ItemBase.slot = 'Two Hand' OR ItemBase.slot = 'Hand')";
