You must provide a user identifier!
"); exit(); } } $categoryId = $HTTP_POST_VARS['categoryId']; if ($categoryId == null) { $categoryId = $HTTP_GET_VARS['categoryId']; if ($categoryId == null) { printError($scriptName, $startTime, "RegisterItem", "

You must provide a category identifier !

"); exit(); } } $name = $HTTP_POST_VARS['name']; if ($name == null) { $name = $HTTP_GET_VARS['name']; if ($name == null) { printError($scriptName, $startTime, "RegisterItem", "

You must provide an item name !

"); exit(); } } $initialPrice = $HTTP_POST_VARS['initialPrice']; if ($initialPrice == null) { $initialPrice = $HTTP_GET_VARS['initialPrice']; if ($initialPrice == null) { printError($scriptName, $startTime, "RegisterItem", "

You must provide an initial price !

"); exit(); } } $reservePrice = $HTTP_POST_VARS['reservePrice']; if ($reservePrice == null) { $reservePrice = $HTTP_GET_VARS['reservePrice']; if ($reservePrice == null) { printError($scriptName, $startTime, "RegisterItem", "

You must provide a reserve price !

"); exit(); } } $buyNow = $HTTP_POST_VARS['buyNow']; if ($buyNow == null) { $buyNow = $HTTP_GET_VARS['buyNow']; if ($buyNow == null) { printError($scriptName, $startTime, "RegisterItem", "

You must provide a Buy Now price !

"); exit(); } } $duration = $HTTP_POST_VARS['duration']; if ($duration == null) { $duration = $HTTP_GET_VARS['duration']; if ($duration == null) { printError($scriptName, $startTime, "RegisterItem", "

You must provide a duration !

"); exit(); } } $qty = $HTTP_POST_VARS['quantity']; if ($qty == null) { $qty = $HTTP_GET_VARS['quantity']; if ($qty == null) { printError($scriptName, $startTime, "RegisterItem", "

You must provide a quantity !

"); exit(); } } $description = $HTTP_POST_VARS['description']; if ($description == null) { $description = $HTTP_GET_VARS['description']; if ($description == null) $description = "No description"; } getDatabaseLink($link); beginRW($link); // Add item to database $start = virtualTimeSQL(); $end = date("Y-m-d H:i:s", virtualTime() + 86400*$duration); $result = sql_query("INSERT INTO items VALUES ($ID_DEFAULT, \"$name\", \"$description\", $initialPrice, $qty, $reservePrice, $buyNow, 0, 0, \"$start\", \"$end\", $userId, $categoryId) RETURNING id", $link) or die("ERROR: Failed to insert new item in database. MySQL reports '".sql_error()."' while querying 'INSERT INTO items VALUES (NULL, \"$name\", \"$description\", $initialPrice, $quantity, $reservePrice, $buyNow, \"$start\", \"$end\", $userId, $categoryId)'"); $itemIdRow = pg_fetch_assoc($result); $itemId = $itemIdRow["id"]; txcache_inval("items", "id", $itemId); txcache_inval("items", "category", $categoryId); txcache_inval("items", "seller", $userId); $userRow = getUser($link, $userId); $regionId = $userRow["region"]; $result = sql_query("INSERT INTO items_by_rc VALUES ($itemId, $regionId, $categoryId, \"$end\")", $link) or die("ERROR: Failed to insert new item in items_by_rc"); txcache_inval("itemsrc", "rc", $regionId."-".$categoryId); commit($link); printHTMLheader("RUBiS: Selling $name"); print("

Your Item has been successfully registered.


\n"); print("RUBiS has stored the following information about your item:

\n"); print("\n"); print("
Name$name\n"); print("
Description$description\n"); print("
Initial price$initialPrice\n"); print("
ReservePrice$reservePrice\n"); print("
Buy Now$buyNow\n"); print("
Quantity$qty\n"); print("
Duration$duration\n"); print("
\n"); print("
The following information has been automatically generated by RUBiS:
\n"); print("\n"); print("
User id$userId\n"); print("
Category id$categoryId\n"); print("
\n"); sql_close($link); printHTMLfooter($scriptName, $startTime); ?>