diff options
| author | Chaz Brown <iamparadox@netscape.net> | 2009-06-05 21:12:12 -0400 |
|---|---|---|
| committer | Chaz Brown <iamparadox@netscape.net> | 2009-06-05 21:12:12 -0400 |
| commit | 715f410fb7fdebe1c22401cb749ad57eae637040 (patch) | |
| tree | c43f21e862007a5d294cf3da08866176f9ef3541 /sql | |
| parent | a319125b4f49109cf008b5f055cf56cd30a7ed7f (diff) | |
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
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/characters.sql | 2 | ||||
| -rw-r--r-- | sql/updates/1556_characters_ahbot.sql | 3 |
2 files changed, 3 insertions, 2 deletions
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`; |