}
// Get item category and condition id
$ids = QueryOperator::getItemRelatedIds(addslashes($new_auction["itemCategory"]), $new_auction["itemCondition"]);
// Prepare item parameters
$item[] = SessionOperator::getUser()->getUserId();
$item[] = $new_auction["itemName"];
$item[] = $new_auction["itemBrand"];
$item[] = $ids["categoryId"];
$item[] = $ids["conditionId"];
$item[] = $new_auction["itemDescription"];
$item[] = $newImageName;
// Prepare auction parameters
$startTime = date_create($new_auction["startTime"])->format('Y-m-d H:i:s');
$endTime = date_create($new_auction["endTime"])->format('Y-m-d H:i:s');
$auction[] = "";
$auction[] = $new_auction["quantity"];
$auction[] = $new_auction["startPrice"];
$auction[] = $new_auction["reservePrice"];
$auction[] = $startTime;
$auction[] = $endTime;
// Store auction in database
$ids = QueryOperator::addAuction($item, $auction);
// Set event timer
QueryOperator::addAuctionEvent($endTime, SessionOperator::getUser()->getUserId(), $ids["auctionId"]);
// Store image name in database
QueryOperator::uploadImage($ids["itemId"], $newImageName, "items");
// Set feedback session
SessionOperator::setNotification(SessionOperator::CREATED_AUCTION);
// Return to live auctions page
HelperOperator::redirectTo("../views/my_live_auctions_view.php");
}
<?php
require_once "../classes/class.query_operator.php";
$auctionIds = QueryOperator::test();
foreach ($auctionIds as $auctionId) {
QueryOperator::addAuctionEvent($auctionId["endTime"], $auctionId["userId"], $auctionId["auctionId"]);
}
