function takeover_other_bidders($caveID, $playerID) { global $db; // get winner's data $winner = Player::getPlayer($playerID, true); $sql = $db->prepare("SELECT *\n FROM Cave_takeover\n WHERE caveID = :caveID\n AND playerID != :playerID"); $sql->bindValue('caveID', $caveID); $sql->bindValue('playerID', $playerID); if (!$sql->execute()) { echo "ERROR (takeover_other_bidders):"; exit(1); } // message the other bidders, that this cave was transfered to the winner while ($row = $sql->fetch(PDO::FETCH_ASSOC)) { takeover_send_failed_completely($row['playerID'], $row, $winner); } $sql->closeCursor(); }
function takeover_other_bidders($caveID, $playerID) { global $db; $query = "SELECT * FROM Cave_takeover WHERE caveID = {$caveID} AND playerID != {$playerID}"; $db_result = $db->query($query); if (!$db_result) { echo "ERROR (takeover_other_bidders): {$query}\n" . mysql_error(); exit(1); } // get winner's data $winner = getPlayerByID($playerID); // message the other bidders, that this cave was transfered to the winner while ($row = $db_result->nextrow(MYSQL_ASSOC)) { takeover_send_failed_completely($row['playerID'], $row, $winner); } }