aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorChaz Brown <iamparadox@netscape.net>2009-08-18 00:06:11 -0400
committerChaz Brown <iamparadox@netscape.net>2009-08-18 00:06:11 -0400
commit1a5da7583830556eba62291c81c9cbb038e51e6f (patch)
treecc9d2af1f4755282fb04c755c35579ccf60f5266 /sql/updates
parent1992df8e89daa989ffeef6b6fd771da9c9dde72d (diff)
AHBot - Fix maxstack DB option to correctly set stacks to a random choice between 1 and the maxstack setting of the item, instead of 1. - Thanks T`lexii for pointing this out
--HG-- branch : trunk
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/5177_characters.sql8
1 files changed, 8 insertions, 0 deletions
diff --git a/sql/updates/5177_characters.sql b/sql/updates/5177_characters.sql
new file mode 100644
index 00000000000..6b8f85ac527
--- /dev/null
+++ b/sql/updates/5177_characters.sql
@@ -0,0 +1,8 @@
+ALTER TABLE `auctionhousebot`
+ CHANGE COLUMN `maxstackgrey` `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.',
+ CHANGE COLUMN `maxstackwhite` `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.',
+ CHANGE COLUMN `maxstackgreen` `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.',
+ CHANGE COLUMN `maxstackblue` `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.',
+ CHANGE COLUMN `maxstackpurple` `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.',
+ CHANGE COLUMN `maxstackorange` `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.',
+ CHANGE COLUMN `maxstackyellow` `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.';