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')";