$players = array(); while (list($player) = mysql_fetch_row($queryPlayers)) { $players[$player] = 0; } $queryItems = mysql_query("SELECT * FROM WA_Items"); while (list($id, $name, $damage, $player, $quantity) = mysql_fetch_row($queryItems)) { $cost = $quantity * ($costPerItemPerDay / $numberOfChecksPerDay); $players[$player] += $cost; } foreach ($players as $p => $v) { $account = new EconAccount($p, $useMySQLiConomy, $iConTableName); $account->spend($v, $useMySQLiConomy, $iConTableName); } //Stored in mail box $queryPlayers = mysql_query("SELECT DISTINCT player FROM WA_Mail"); $players = array(); while (list($player) = mysql_fetch_row($queryPlayers)) { $players[$player] = 0; } $queryItems = mysql_query("SELECT * FROM WA_Mail"); while (list($id, $name, $damage, $player, $quantity) = mysql_fetch_row($queryItems)) { $cost = $quantity * ($costPerItemPerDay / $numberOfChecksPerDay); $players[$player] += $cost; } foreach ($players as $p => $v) { $account = new EconAccount($p, $useMySQLiConomy, $iConTableName); $account->spend($v, $useMySQLiConomy, $iConTableName); } $next = $now + 86400 / $numberOfChecksPerDay; $insert = mysql_query("INSERT INTO WA_StorageCheck (time) VALUES ({$next})"); }
$sellPrice = $sellPricePerQuantity / $sellQuantity; } if (is_numeric($sellPrice)) { if (is_numeric($sellQuantity) && $sellQuantity >= 0) { $sellQuantity = round($sellQuantity); if ($item->quantity >= $sellQuantity) { if ($isAdmin) { if ($chargeAdmins) { $itemFee = $item->marketprice / 100 * $auctionFee * $sellQuantity; } else { $itemFee = 0; } if ($player->money >= $itemFee) { $item->changeQuantity(0 - $sellQuantity); $timeNow = time(); $player->spend($itemFee, $useMySQLiConomy, $iConTableName); $itemQuery = mysql_query("INSERT INTO WA_Auctions (name, damage, player, quantity, price, created, allowBids, currentBid, currentWinner) VALUES ('{$item->name}', '{$item->damage}', '{$item->owner}', '{$sellQuantity}', '{$sellPrice}', '{$timeNow}', '{$allowBids}', '{$minBid}', '{$item->owner}')"); $queryLatestAuction = mysql_query("SELECT id FROM WA_Auctions ORDER BY id DESC"); list($latestId) = mysql_fetch_row($queryLatestAuction); if ($item->quantity == 0) { $item->delete(); } if ($useTwitter == true) { try { $twitter = new Twitter($consumerKey, $consumerSecret, $accessToken, $accessTokenSecret); if ($sellQuantity == 0) { $twitQuant = "Infinite"; } else { $twitQuant = $sellQuantity; } $twitter->send('[WA] Auction Created: ' . $user . ' is selling ' . $twitQuant . ' x ' . $itemFullName . ' for ' . $currencyPrefix . $sellPrice . $currencyPostfix . ' each. At ' . date("H:i:s") . ' #webauction');
} $toDelete = false; $totalPrice = round($auction->price * $buyQuantity, 2); $numberLeft = $auction->quantity - $buyQuantity; if ($numberLeft < 0 && $auction->quantity > 0) { $_SESSION['error'] = $lang['purchaseItem']['too_many_quantity']; header("Location: ../index.php"); } else { if ($totalPrice < 0.01) { $_SESSION['error'] = $lang['purchaseItem']['too_low_minprice']; header("Location: ../index.php"); } if ($player->money >= $totalPrice) { if ($user != $auction->owner) { $timeNow = time(); $player->spend($totalPrice, $useMySQLiConomy, $iConTableName); $owner->earn($totalPrice, $useMySQLiConomy, $iConTableName); $alertQuery = mysql_query("INSERT INTO WA_SaleAlerts (seller, quantity, price, buyer, item) VALUES ('{$auction->owner}', '{$buyQuantity}', '{$auction->price}', '{$user}', '{$auction->fullname}')"); if ($sendPurchaceToMail) { $maxStack = getItemMaxStack($auction->name, $auction->damage); while ($buyQuantity > $maxStack) { $buyQuantity -= $maxStack; $itemQuery = mysql_query("INSERT INTO WA_Mail (name, damage, player, quantity) VALUES ('{$auction->name}', '{$auction->damage}', '{$user}', '{$maxStack}')"); $queryLatestAuction = mysql_query("SELECT id FROM WA_Mail ORDER BY id DESC"); list($latestId) = mysql_fetch_row($queryLatestAuction); $queryEnchantLinks = mysql_query("SELECT enchId FROM WA_EnchantLinks WHERE itemId='{$auction->id}' AND itemTableId=1"); while (list($enchId) = mysql_fetch_row($queryEnchantLinks)) { $queryEnchants = mysql_query("SELECT * FROM WA_EnchantLinks WHERE itemId='{$auction->id}' AND itemTableId ='1'"); while (list($idk, $enchIdk, $tableIdk, $itemIdk) = mysql_fetch_row($queryEnchants)) { $updateEnch = mysql_query("INSERT INTO WA_EnchantLinks (enchId, itemTableId, itemId) VALUES ('{$enchIdk}', '2', '{$latestId}')"); }