function __construct($idIn)
{
$query = mysql_query("SELECT * FROM WA_Items WHERE id='{$idIn}'");
$itemRow = mysql_fetch_object($query);
$this->id = $itemRow->id;
$this->name = $itemRow->name;
$this->damage = $itemRow->damage;
$this->owner = $itemRow->player;
$this->quantity = $itemRow->quantity;
$this->marketprice = getMarketPrice($this->id, 0);
$this->fullname = getItemName($this->name, $this->damage);
$this->maxstack = getItemMaxStack($this->name);
$queryEnchantLinks = mysql_query("SELECT * FROM WA_EnchantLinks WHERE itemId = '{$this->id}' AND itemTableId = '0'");
$itemEnchantsArray = array();
while (list($idt, $enchIdt, $itemTableIdt, $itemIdt) = mysql_fetch_row($queryEnchantLinks)) {
$eArray = array();
$q = mysql_query("SELECT * FROM WA_Enchantments WHERE id = '{$enchIdt}'");
list($ide, $fullnamee, $namee, $levele) = mysql_fetch_row($q);
$eArray["id"] = $ide;
$eArray["name"] = $namee;
$eArray["level"] = $levele;
$itemEnchantsArray[] = $eArray;
}
$this->enchants = $itemEnchantsArray;
}
<?php
session_start();
if (!isset($_SESSION['User'])) {
header("Location: login.php");
}
$user = $_SESSION['User'];
require 'config.php';
require 'itemInfo.php';
$itemId = mysql_real_escape_string(stripslashes($_GET['id']));
$queryItems = mysql_query("SELECT * FROM WA_Items WHERE id='{$itemId}'");
list($id, $itemName, $itemDamage, $itemOwner, $itemQuantity) = mysql_fetch_row($queryItems);
$maxStack = getItemMaxStack($itemName, $itemDamage);
if ($user == $itemOwner) {
while ($itemQuantity > $maxStack) {
$itemQuantity -= $maxStack;
$itemQuery = mysql_query("INSERT INTO WA_Mail (name, damage, player, quantity) VALUES ('{$itemName}', '{$itemDamage}', '{$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='{$itemId}' AND itemTableId=0");
while (list($enchId) = mysql_fetch_row($queryEnchantLinks)) {
$queryEnchants = mysql_query("SELECT * FROM WA_EnchantLinks WHERE itemId='{$itemId}' AND itemTableId ='0'");
while (list($idk, $enchIdk, $tableIdk, $itemIdk) = mysql_fetch_row($queryEnchants)) {
$updateEnch = mysql_query("INSERT INTO WA_EnchantLinks (enchId, itemTableId, itemId) VALUES ('{$enchIdk}', '2', '{$latestId}')");
}
}
}
if ($itemQuantity > 0) {
$itemQuery = mysql_query("INSERT INTO WA_Mail (name, damage, player, quantity) VALUES ('{$itemName}', '{$itemDamage}', '{$user}', '{$itemQuantity}')");
$queryLatestAuction = mysql_query("SELECT id FROM WA_Mail ORDER BY id DESC");
list($latestId) = mysql_fetch_row($queryLatestAuction);
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}')");
}
}
}
if ($buyQuantity > 0) {
$itemQuery = mysql_query("INSERT INTO WA_Mail (name, damage, player, quantity) VALUES ('{$auction->name}', '{$auction->damage}', '{$user}', '{$buyQuantity}')");
