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