Auctions

From ArcEmu-Wiki
Jump to: navigation, search

Description

A table that stores auctions.

Contents



auctionId

Auto incremented number - Unique ID identifying an in-game auction


auctionhouse

01 = Alliance
06 = Horde
07 = Neutral

By running this NON-BLIZZLIKE query
UPDATE `auctionhouse` SET `group` = 7 WHERE `id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38);
you will link all auctions houses (ally/horde/neutral).


item

GUID of the sold item (a reference to playeritems table, guid column)


owner

GUID of the character who made the auction (reference to characters table, guid column)


buyout

Buyout price of the item, given in copper


time

Remaining time of the auction in milliseconds


bidder

GUID of the character who is the current highest bidder (reference to characters table, guid column)


bid

The current highest bid, given in copper


deposit

The amount of copper which was required to start the auction


SQL Structure

CREATE TABLE `auctions` (
  `auctionId` int(32) NOT NULL AUTO_INCREMENT,
  `auctionhouse` int(32) DEFAULT NULL,
  `item` bigint(10) DEFAULT NULL,
  `owner` bigint(10) DEFAULT NULL,
  `buyout` int(32) DEFAULT NULL,
  `time` int(32) DEFAULT NULL,
  `bidder` bigint(10) DEFAULT NULL,
  `bid` int(32) DEFAULT NULL,
  `deposit` int(32) DEFAULT NULL,
  PRIMARY KEY (`auctionId`),
  KEY `b` (`auctionhouse`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Personal tools