1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
| $lstEffects = array('Item_HP_Effect', 'Item_MP_Effect', 'Item_Strength_Effect', 'Item_Magic_Effect', 'Item_Agility_Effect', 'Item_Defense_Effect');
if (isset($_POST['Item'])) {
$Item_Query = $bdd->prepare("SELECT * FROM Caranille_Inventory
JOIN Caranille_Items ON Inventory_Item_ID = Item_ID
WHERE Item_Type = ?
AND Inventory_Account_ID = ?
ORDER BY Item_Name");
echo '<p>' . $Inventory_33 . '</p>';
echo '<table>
<tr>
<td>' . $Inventory_11 . '</td>
<td>' . $Inventory_12 . '</td>
<td>' . $Inventory_14 . '</td>
<td>' . $Inventory_15 . '</td>
<td>' . $Inventory_16 . '</td>
<td>' . $Inventory_17 . '</td>
</tr>';
$arItem_types = ('Health', 'Magic');
foreach ($arItem_types as $item_type) {
$Item_Query->execute(array($item_type, $ID));
while ($Item = $Item_Query->fetch()) {
echo '<tr>
<td>' . htmlspecialchars($Item['Item_Name']). '</td>
<td>' . htmlspecialchars($Item['Item_Description']). '</td>
<td>' . htmlspecialchars($Item['Inventory_Item_Quantity']). '</td>
<td>';
foreach ($lstEffects as $effect_name) {
echo '+' . htmlspecialchars($Item[$effect_name]). '</br>';
}
echo '</td>
<td>
<form method="POST" action="Inventory.php">
<input type="hidden" name="Item_ID" value="' . $Item['Item_ID'] . '">
<input type="hidden" name="Item_Name" value="' . $Item['Item_Name'] . '">
</form>
<form method="POST" action="Inventory.php">
<input type="hidden" name="Inventory_ID" value="' . $Item['Inventory_ID'] . '">
<input type="hidden" name="Item_ID" value="' . $Item['Item_ID'] . '">
<input type="submit" name="Sale" value="' . $Inventory_26 . '"><br /><br />
</form>
</td>
</tr>';
}
$Item_Query->closeCursor();
}
} |
