aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorShocker <none@none>2010-09-02 17:37:32 +0300
committerShocker <none@none>2010-09-02 17:37:32 +0300
commit661cd04c272c78650d3f20d2d4292e7cc9099f1d (patch)
tree5756e0df3417dd7bb43bf2495f4dd45e58a38e3a
parent0e865c9f72b6db21e17995a8420d5c13fd34248e (diff)
Remove auctionhousebot from base too
--HG-- branch : trunk
-rw-r--r--sql/base/characters_database.sql74
1 files changed, 0 insertions, 74 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index d0e9503b701..ef9bbcc81b7 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -207,80 +207,6 @@ LOCK TABLES `auctionhouse` WRITE;
UNLOCK TABLES;
--
--- Table structure for table `auctionhousebot`
---
-
-DROP TABLE IF EXISTS `auctionhousebot`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `auctionhousebot` (
- `auctionhouse` int(11) NOT NULL default '0' COMMENT 'mapID of the auctionhouse.',
- `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.',
- `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',
- `percentbluetradegoods` int(11) default '10' COMMENT 'Sets the percentage of the Blue Trade Goods auction items',
- `percentpurpletradegoods` int(11) default '1' COMMENT 'Sets the percentage of the Purple Trade Goods auction items',
- `percentorangetradegoods` int(11) default '0' COMMENT 'Sets the percentage of the Orange Trade Goods auction items',
- `percentyellowtradegoods` int(11) default '0' COMMENT 'Sets the percentage of the Yellow Trade Goods auction items',
- `percentgreyitems` int(11) default '0' COMMENT 'Sets the percentage of the non trade Grey auction items',
- `percentwhiteitems` int(11) default '10' COMMENT 'Sets the percentage of the non trade White auction items',
- `percentgreenitems` int(11) default '30' COMMENT 'Sets the percentage of the non trade Green auction items',
- `percentblueitems` int(11) default '8' COMMENT 'Sets the percentage of the non trade Blue auction items',
- `percentpurpleitems` int(11) default '2' COMMENT 'Sets the percentage of the non trade Purple auction items',
- `percentorangeitems` int(11) default '0' COMMENT 'Sets the percentage of the non trade Orange auction items',
- `percentyellowitems` int(11) default '0' COMMENT 'Sets the percentage of the non trade Yellow auction items',
- `minpricegrey` int(11) default '100' COMMENT 'Minimum price of Grey items (percentage).',
- `maxpricegrey` int(11) default '150' COMMENT 'Maximum price of Grey items (percentage).',
- `minpricewhite` int(11) default '150' COMMENT 'Minimum price of White items (percentage).',
- `maxpricewhite` int(11) default '250' COMMENT 'Maximum price of White items (percentage).',
- `minpricegreen` int(11) default '800' COMMENT 'Minimum price of Green items (percentage).',
- `maxpricegreen` int(11) default '1400' COMMENT 'Maximum price of Green items (percentage).',
- `minpriceblue` int(11) default '1250' COMMENT 'Minimum price of Blue items (percentage).',
- `maxpriceblue` int(11) default '1750' COMMENT 'Maximum price of Blue items (percentage).',
- `minpricepurple` int(11) default '2250' COMMENT 'Minimum price of Purple items (percentage).',
- `maxpricepurple` int(11) default '4550' COMMENT 'Maximum price of Purple items (percentage).',
- `minpriceorange` int(11) default '3250' COMMENT 'Minimum price of Orange items (percentage).',
- `maxpriceorange` int(11) default '5550' COMMENT 'Maximum price of Orange items (percentage).',
- `minpriceyellow` int(11) default '5250' COMMENT 'Minimum price of Yellow items (percentage).',
- `maxpriceyellow` int(11) default '6550' COMMENT 'Maximum price of Yellow items (percentage).',
- `minbidpricegrey` int(11) default '70' COMMENT 'Starting bid price of Grey items as a percentage of the randomly chosen buyout price. Default: 70',
- `maxbidpricegrey` int(11) default '100' COMMENT 'Starting bid price of Grey items as a percentage of the randomly chosen buyout price. Default: 100',
- `minbidpricewhite` int(11) default '70' COMMENT 'Starting bid price of White items as a percentage of the randomly chosen buyout price. Default: 70',
- `maxbidpricewhite` int(11) default '100' COMMENT 'Starting bid price of White items as a percentage of the randomly chosen buyout price. Default: 100',
- `minbidpricegreen` int(11) default '80' COMMENT 'Starting bid price of Green items as a percentage of the randomly chosen buyout price. Default: 80',
- `maxbidpricegreen` int(11) default '100' COMMENT 'Starting bid price of Green items as a percentage of the randomly chosen buyout price. Default: 100',
- `minbidpriceblue` int(11) default '75' COMMENT 'Starting bid price of Blue items as a percentage of the randomly chosen buyout price. Default: 75',
- `maxbidpriceblue` int(11) default '100' COMMENT 'Starting bid price of Blue items as a percentage of the randomly chosen buyout price. Default: 100',
- `minbidpricepurple` int(11) default '80' COMMENT 'Starting bid price of Purple items as a percentage of the randomly chosen buyout price. Default: 80',
- `maxbidpricepurple` int(11) default '100' COMMENT 'Starting bid price of Purple items as a percentage of the randomly chosen buyout price. Default: 100',
- `minbidpriceorange` int(11) default '80' COMMENT 'Starting bid price of Orange items as a percentage of the randomly chosen buyout price. Default: 80',
- `maxbidpriceorange` int(11) default '100' COMMENT 'Starting bid price of Orange items as a percentage of the randomly chosen buyout price. Default: 100',
- `minbidpriceyellow` int(11) default '80' COMMENT 'Starting bid price of Yellow items as a percentage of the randomly chosen buyout price. Default: 80',
- `maxbidpriceyellow` int(11) default '100' COMMENT 'Starting bid price of Yellow items as a percentage of the randomly chosen buyout price. Default: 100',
- `maxstackgrey` int(11) default '0' COMMENT '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) default '0' COMMENT '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) default '0' COMMENT '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) default '0' COMMENT '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) default '0' COMMENT '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) default '0' COMMENT '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) default '0' COMMENT '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) default '1' COMMENT 'Multiplier to vendorprice when buying grey items from auctionhouse',
- `buyerpricewhite` int(11) default '3' COMMENT 'Multiplier to vendorprice when buying white items from auctionhouse',
- `buyerpricegreen` int(11) default '5' COMMENT 'Multiplier to vendorprice when buying green items from auctionhouse',
- `buyerpriceblue` int(11) default '12' COMMENT 'Multiplier to vendorprice when buying blue items from auctionhouse',
- `buyerpricepurple` int(11) default '15' COMMENT 'Multiplier to vendorprice when buying purple items from auctionhouse',
- `buyerpriceorange` int(11) default '20' COMMENT 'Multiplier to vendorprice when buying orange items from auctionhouse',
- `buyerpriceyellow` int(11) default '22' COMMENT 'Multiplier to vendorprice when buying yellow items from auctionhouse',
- `buyerbiddinginterval` int(11) default '1' COMMENT 'Interval how frequently AHB bids on each AH. Time in minutes',
- `buyerbidsperinterval` int(11) default '1' COMMENT 'number of bids to put in per bidding interval',
- PRIMARY KEY (`auctionhouse`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
-- Dumping data for table `auctionhousebot`
--