private static function queryResultToAdvancedAuctions($result)
{
$liveAuctions = [];
while ($row = $result->fetch_assoc()) {
$auction = new Auction($row);
$auctionId = $auction->getAuctionId();
$bids = self::getAuctionBids($auctionId);
$views = $auction->getViews();
$watches = self::getAuctionWatches($auctionId);
$liveAuction = new AdvancedAuction($auction, $bids, $views, $watches);
$liveAuctions[] = $liveAuction;
}
return $liveAuctions;
}
$auction->setUserId($row['user_id']);
$auction->setCreationTime($row['auction_creation_time']);
$auction->setEndTime($row['auction_end_time']);
$auction->setAuctionEnded($row['auction_ended']);
$auction->setWinnerUserName($row['winner_username']);
}
}
$user_id = $auction->getUserId();
$user_query = mysqli_query($link, "SELECT * FROM users WHERE id={$user_id}");
if ($user_query !== null) {
while ($row = mysqli_fetch_array($user_query)) {
$auction->setSellerUserName($row['username']);
$auction->setSellerDisplayName($row['displayname']);
}
}
$bid_query = mysqli_query($link, "SELECT * FROM bids WHERE auction_id={$auction->getAuctionId()}");
$highest_bid = 0.0;
if ($bid_query !== null) {
while ($row = mysqli_fetch_array($bid_query)) {
if ($highest_bid < $row['bid_amount']) {
$highest_bid = $row['bid_amount'];
}
}
}
$textbook = null;
//Check to see if ISBN 10/13 is set for the textbook being offered for sale (Should either always return a result or have no result)
if (!empty($auction->getISBN()) && $auction->getISBN() !== null) {
$textbook_query = null;
if (strlen($auction->getISBN()) === 10) {
$textbook_query = mysqli_query($link, "SELECT * FROM textbooks WHERE ISBN_v10='ISBN-10:{$auction->getISBN()}'");
} else {
