TrinityCore : auctionhousebot (merged)

Field

Type

Attributes

Key

Null

Default

Extra

Comment

auctionhouse

int(11)

signed

PRI

NO

0

mapID of the auctionhouse.

name

char(25)

signed

YES

NULL

Text name of the auctionhouse.

minitems

int(11)

signed

YES

0

This is the minimum number of items you want to keep in the auction house. a 0 here will make it the same as the maximum.

maxitems

int(11)

signed

YES

0

This is the number of items you want to keep in the auction house.

percentgreytradegoods

int(11)

signed

YES

0

Sets the percentage of the Grey Trade Goods auction items

percentwhitetradegoods

int(11)

signed

YES

27

Sets the percentage of the White Trade Goods auction items

percentgreebtradegoods

int(11)

signed

YES

12

Sets the percentage of the Green Trade Goods auction items

percentbluetradegoods

int(11)

signed

YES

10

Sets the percentage of the Blue Trade Goods auction items

percentpurpletradegoods

int(11)

signed

YES

1

Sets the percentage of the Purple Trade Goods auction items

percentorangetradegoods

int(11)

signed

YES

0

Sets the percentage of the Orange Trade Goods auction items

percentyellowtradegoods

int(11)

signed

YES

0

Sets the percentage of the Yellow Trade Goods auction items

percentgreyitems

int(11)

signed

YES

0

Sets the percentage of the non trade Grey auction items

percentwhiteitems

int(11)

signed

YES

10

Sets the percentage of the non trade White auction items

percentgreenitems

int(11)

signed

YES

30

Sets the percentage of the non trade Green auction items

percentblueitems

int(11)

signed

YES

8

Sets the percentage of the non trade Blue auction items

percentpurpleitems

int(11)

signed

YES

2

Sets the percentage of the non trade Purple auction items

percentorangeitems

int(11)

signed

YES

0

Sets the percentage of the non trade Orange auction items

percentyellowitems

int(11)

signed

YES

0

Sets the percentage of the non trade Yellow auction items

minpricegrey

int(11)

signed

YES

100

Minimum price of Grey items (percentage).

maxpricegrey

int(11)

signed

YES

150

Maximum price of Grey items (percentage).

minpricewhite

int(11)

signed

YES

150

Minimum price of White items (percentage).

maxpricewhite

int(11)

signed

YES

250

Maximum price of White items (percentage).

minpricegreen

int(11)

signed

YES

800

Minimum price of Green items (percentage).

maxpricegreen

int(11)

signed

YES

1400

Maximum price of Green items (percentage).

minpriceblue

int(11)

signed

YES

1250

Minimum price of Blue items (percentage).

maxpriceblue

int(11)

signed

YES

1750

Maximum price of Blue items (percentage).

minpricepurple

int(11)

signed

YES

2250

Minimum price of Purple items (percentage).

maxpricepurple

int(11)

signed

YES

4550

Maximum price of Purple items (percentage).

minpriceorange

int(11)

signed

YES

3250

Minimum price of Orange items (percentage).

maxpriceorange

int(11)

signed

YES

5550

Maximum price of Orange items (percentage).

minpriceyellow

int(11)

signed

YES

5250

Minimum price of Yellow items (percentage).

maxpriceyellow

int(11)

signed

YES

6550

Maximum price of Yellow items (percentage).

minbidpricegrey

int(11)

signed

YES

70

Starting bid price of Grey items as a percentage of the randomly chosen buyout price. Default: 70

maxbidpricegrey

int(11)

signed

YES

100

Starting bid price of Grey items as a percentage of the randomly chosen buyout price. Default: 100

minbidpricewhite

int(11)

signed

YES

70

Starting bid price of White items as a percentage of the randomly chosen buyout price. Default: 70

maxbidpricewhite

int(11)

signed

YES

100

Starting bid price of White items as a percentage of the randomly chosen buyout price. Default: 100

minbidpricegreen

int(11)

signed

YES

80

Starting bid price of Green items as a percentage of the randomly chosen buyout price. Default: 80

maxbidpricegreen

int(11)

signed

YES

100

Starting bid price of Green items as a percentage of the randomly chosen buyout price. Default: 100

minbidpriceblue

int(11)

signed

YES

75

Starting bid price of Blue items as a percentage of the randomly chosen buyout price. Default: 75

maxbidpriceblue

int(11)

signed

YES

100

Starting bid price of Blue items as a percentage of the randomly chosen buyout price. Default: 100

minbidpricepurple

int(11)

signed

YES

80

Starting bid price of Purple items as a percentage of the randomly chosen buyout price. Default: 80

maxbidpricepurple

int(11)

signed

YES

100

Starting bid price of Purple items as a percentage of the randomly chosen buyout price. Default: 100

minbidpriceorange

int(11)

signed

YES

80

Starting bid price of Orange items as a percentage of the randomly chosen buyout price. Default: 80

maxbidpriceorange

int(11)

signed

YES

100

Starting bid price of Orange items as a percentage of the randomly chosen buyout price. Default: 100

minbidpriceyellow

int(11)

signed

YES

80

Starting bid price of Yellow items as a percentage of the randomly chosen buyout price. Default: 80

maxbidpriceyellow

int(11)

signed

YES

100

Starting bid price of Yellow items as a percentage of the randomly chosen buyout price. Default: 100

maxstackgrey

int(11)

signed

YES

0

Stack size limits for item qualities - a value of 0 will disable a maximum stack size for that quality, which will allow the bot to create items in stack as large as the item allows.

maxstackwhite

int(11)

signed

YES

0

Stack size limits for item qualities - a value of 0 will disable a maximum stack size for that quality, which will allow the bot to create items in stack as large as the item allows.

maxstackgreen

int(11)

signed

YES

0

Stack size limits for item qualities - a value of 0 will disable a maximum stack size for that quality, which will allow the bot to create items in stack as large as the item allows.

maxstackblue

int(11)

signed

YES

0

Stack size limits for item qualities - a value of 0 will disable a maximum stack size for that quality, which will allow the bot to create items in stack as large as the item allows.

maxstackpurple

int(11)

signed

YES

0

Stack size limits for item qualities - a value of 0 will disable a maximum stack size for that quality, which will allow the bot to create items in stack as large as the item allows.

maxstackorange

int(11)

signed

YES

0

Stack size limits for item qualities - a value of 0 will disable a maximum stack size for that quality, which will allow the bot to create items in stack as large as the item allows.

maxstackyellow

int(11)

signed

YES

0

Stack size limits for item qualities - a value of 0 will disable a maximum stack size for that quality, which will allow the bot to create items in stack as large as the item allows.

buyerpricegrey

int(11)

signed

YES

1

Multiplier to vendorprice when buying grey items from auctionhouse

buyerpricewhite

int(11)

signed

YES

3

Multiplier to vendorprice when buying white items from auctionhouse

buyerpricegreen

int(11)

signed

YES

5

Multiplier to vendorprice when buying green items from auctionhouse

buyerpriceblue

int(11)

signed

YES

12

Multiplier to vendorprice when buying blue items from auctionhouse

buyerpricepurple

int(11)

signed

YES

15

Multiplier to vendorprice when buying purple items from auctionhouse

buyerpriceorange

int(11)

signed

YES

20

Multiplier to vendorprice when buying orange items from auctionhouse

buyerpriceyellow

int(11)

signed

YES

22

Multiplier to vendorprice when buying yellow items from auctionhouse

buyerbiddinginterval

int(11)

signed

YES

1

Interval how frequently AHB bids on each AH. Time in minutes

buyerbidsperinterval

int(11)

signed

YES

1

number of bids to put in per bidding interval