From 715f410fb7fdebe1c22401cb749ad57eae637040 Mon Sep 17 00:00:00 2001 From: Chaz Brown Date: Fri, 5 Jun 2009 21:12:12 -0400 Subject: Fix AHBot to calculate the deposit for auctions so it can be used to check the code for figuring deposit amount on a wide range of items. Fix ahbotoptions command so it works from the server console again. change commented out lines in GetAuctionDeposit so they display in debug loglevel. Min/Max Time settings replaced with a function that selects 12 24 and 48 randomly as the auction times. Backport from TC2 --HG-- branch : trunk --- sql/characters.sql | 2 -- sql/updates/1556_characters_ahbot.sql | 3 +++ 2 files changed, 3 insertions(+), 2 deletions(-) create mode 100644 sql/updates/1556_characters_ahbot.sql (limited to 'sql') diff --git a/sql/characters.sql b/sql/characters.sql index c2233b7e282..bcb2b449c0f 100644 --- a/sql/characters.sql +++ b/sql/characters.sql @@ -132,8 +132,6 @@ CREATE TABLE `auctionhousebot` ( `name` char(25) default NULL COMMENT 'Text name of the auctionhouse.', `minitems` int(11) default '0' COMMENT '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) default '0' COMMENT 'This is the number of items you want to keep in the auction house.', - `mintime` int(11) default '8' COMMENT 'Sets the minimum number of hours for an auction.', - `maxtime` int(11) default '24' COMMENT 'Sets the maximum number of hours for an auction.', `percentgreytradegoods` int(11) default '0' COMMENT 'Sets the percentage of the Grey Trade Goods auction items', `percentwhitetradegoods` int(11) default '27' COMMENT 'Sets the percentage of the White Trade Goods auction items', `percentgreentradegoods` int(11) default '12' COMMENT 'Sets the percentage of the Green Trade Goods auction items', diff --git a/sql/updates/1556_characters_ahbot.sql b/sql/updates/1556_characters_ahbot.sql new file mode 100644 index 00000000000..85c0b14bac4 --- /dev/null +++ b/sql/updates/1556_characters_ahbot.sql @@ -0,0 +1,3 @@ +ALTER TABLE `auctionhousebot` + DROP COLUMN `minTime`, + DROP COLUMN `maxTime`; -- cgit v1.2.3