function addDrop($bdd, $monsterID, $characterID)
{
$selectDrop = $bdd->prepare("SELECT * FROM Caranille_Monsters_Drops WHERE Monster_Drop_Monster_ID = ?");
$selectDrop->execute([$monsterID]);
while ($drop = $selectDrop->fetch()) {
$rando = rand(0, 1000);
if ($rando <= $drop['Monster_Drop_Luck']) {
if ($drop['Monster_Drop_Item_Type'] == "item") {
$addItem = $bdd->prepare("INSERT INTO Caranille_Inventory_Items VALUES('', :characterID, :itemID)");
$addItem->execute(array('characterID' => $characterID, 'itemID' => $drop['Monster_Drop_Item_ID']));
$addItem->closeCursor();
}
if ($drop['Monster_Drop_Item_Type'] == "equipment") {
$number = verifyEquipment($bdd, $drop['Monster_Drop_Item_ID'], $characterID);
if ($number <= 0) {
$addEquipment = $bdd->prepare("INSERT INTO Caranille_Inventory_Equipments VALUES('', :characterID, :itemID, '1', '0')");
$addEquipment->execute(array('characterID' => $characterID, 'itemID' => $drop['Monster_Drop_Item_ID']));
$addEquipment->closeCursor();
} else {
updateEquipment($bdd, $characterID, $drop['Monster_Drop_Item_ID']);
}
}
showDrop($bdd, $drop['Monster_Drop_Item_ID'], $drop['Monster_Drop_Item_Type']);
}
}
$selectDrop->closeCursor();
}
<?php
$timeStart = microtime(true);
session_start();
ob_start();
if (empty($_SESSION)) {
exit(header("Location: ../../index.php"));
}
require_once $_SESSION['File_Root'] . '/Kernel/Include.php';
require_once $_SESSION['File_Root'] . '/HTML/Header.php';
require_once 'Functions/SQL.php';
redirectToLogin($accountID, $linkRoot);
redirectToBattle($verifyBattle, $linkRoot);
$equipmentID = htmlspecialchars(addslashes($_POST['EquipmentID']));
$canBePurchased = canBePurchased($bdd, $equipmentID, $characterTownID);
if ($canBePurchased == 1) {
$number = verifyEquipment($bdd, $equipmentID, $characterID);
if ($number <= 0) {
$equipment = newEquipment($bdd, $equipmentID);
addEquipment($bdd, $equipmentID, $characterID);
$gold = $character->getGold() - $equipment->getPurchase();
updateCharacterGold($bdd, $gold, $characterID);
} else {
updateEquipment($bdd, $characterID, $equipmentID);
}
} else {
echo "An error has surved";
}
require_once $_SESSION['File_Root'] . '/HTML/Footer.php';
