API tools faq
paste
Advertisement
Guest User

EmuCoach AHBot SQL

a guest
Apr 19th, 2015
256
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 10.66 KB | None | 0 0
raw download clone embed print report
  1. -- Character database if worldserver is crashing at the end
  2. CREATE TABLE `auctionhousebot` (
  3. `auctionhouse` INT(11) NOT NULL DEFAULT '0' COMMENT 'mapID of the auctionhouse.',
  4. `name` CHAR(25) NULL DEFAULT NULL COMMENT 'Text name of the auctionhouse.',
  5. `minitems` INT(11) NULL DEFAULT '0' COMMENT 'This is the minimum number of items you want to keep
  6.  
  7. in the auction house. a 0 here will make it the same as the maximum.',
  8. `maxitems` INT(11) NULL DEFAULT '0' COMMENT 'This is the number of items you want to keep in the
  9.  
  10. auction house.',
  11. `percentgreytradegoods` INT(11) NULL DEFAULT '0' COMMENT 'Sets the percentage of the Grey Trade
  12.  
  13. Goods auction items',
  14. `percentwhitetradegoods` INT(11) NULL DEFAULT '27' COMMENT 'Sets the percentage of the White Trade
  15.  
  16. Goods auction items',
  17. `percentgreentradegoods` INT(11) NULL DEFAULT '12' COMMENT 'Sets the percentage of the Green Trade
  18.  
  19. Goods auction items',
  20. `percentbluetradegoods` INT(11) NULL DEFAULT '10' COMMENT 'Sets the percentage of the Blue Trade
  21.  
  22. Goods auction items',
  23. `percentpurpletradegoods` INT(11) NULL DEFAULT '1' COMMENT 'Sets the percentage of the Purple Trade
  24.  
  25. Goods auction items',
  26. `percentorangetradegoods` INT(11) NULL DEFAULT '0' COMMENT 'Sets the percentage of the Orange Trade
  27.  
  28. Goods auction items',
  29. `percentyellowtradegoods` INT(11) NULL DEFAULT '0' COMMENT 'Sets the percentage of the Yellow Trade
  30.  
  31. Goods auction items',
  32. `percentgreyitems` INT(11) NULL DEFAULT '0' COMMENT 'Sets the percentage of the non trade Grey
  33.  
  34. auction items',
  35. `percentwhiteitems` INT(11) NULL DEFAULT '10' COMMENT 'Sets the percentage of the non trade White
  36.  
  37. auction items',
  38. `percentgreenitems` INT(11) NULL DEFAULT '30' COMMENT 'Sets the percentage of the non trade Green
  39.  
  40. auction items',
  41. `percentblueitems` INT(11) NULL DEFAULT '8' COMMENT 'Sets the percentage of the non trade Blue
  42.  
  43. auction items',
  44. `percentpurpleitems` INT(11) NULL DEFAULT '2' COMMENT 'Sets the percentage of the non trade Purple
  45.  
  46. auction items',
  47. `percentorangeitems` INT(11) NULL DEFAULT '0' COMMENT 'Sets the percentage of the non trade Orange
  48.  
  49. auction items',
  50. `percentyellowitems` INT(11) NULL DEFAULT '0' COMMENT 'Sets the percentage of the non trade Yellow
  51.  
  52. auction items',
  53. `minpricegrey` INT(11) NULL DEFAULT '100' COMMENT 'Minimum price of Grey items (percentage).',
  54. `maxpricegrey` INT(11) NULL DEFAULT '150' COMMENT 'Maximum price of Grey items (percentage).',
  55. `minpricewhite` INT(11) NULL DEFAULT '150' COMMENT 'Minimum price of White items (percentage).',
  56. `maxpricewhite` INT(11) NULL DEFAULT '250' COMMENT 'Maximum price of White items (percentage).',
  57. `minpricegreen` INT(11) NULL DEFAULT '800' COMMENT 'Minimum price of Green items (percentage).',
  58. `maxpricegreen` INT(11) NULL DEFAULT '1400' COMMENT 'Maximum price of Green items (percentage).',
  59. `minpriceblue` INT(11) NULL DEFAULT '1250' COMMENT 'Minimum price of Blue items (percentage).',
  60. `maxpriceblue` INT(11) NULL DEFAULT '1750' COMMENT 'Maximum price of Blue items (percentage).',
  61. `minpricepurple` INT(11) NULL DEFAULT '2250' COMMENT 'Minimum price of Purple items (percentage).',
  62. `maxpricepurple` INT(11) NULL DEFAULT '4550' COMMENT 'Maximum price of Purple items (percentage).',
  63. `minpriceorange` INT(11) NULL DEFAULT '3250' COMMENT 'Minimum price of Orange items (percentage).',
  64. `maxpriceorange` INT(11) NULL DEFAULT '5550' COMMENT 'Maximum price of Orange items (percentage).',
  65. `minpriceyellow` INT(11) NULL DEFAULT '5250' COMMENT 'Minimum price of Yellow items (percentage).',
  66. `maxpriceyellow` INT(11) NULL DEFAULT '6550' COMMENT 'Maximum price of Yellow items (percentage).',
  67. `minbidpricegrey` INT(11) NULL DEFAULT '70' COMMENT 'Starting bid price of Grey items as a
  68.  
  69. percentage of the randomly chosen buyout price. Default: 70',
  70. `maxbidpricegrey` INT(11) NULL DEFAULT '100' COMMENT 'Starting bid price of Grey items as a
  71.  
  72. percentage of the randomly chosen buyout price. Default: 100',
  73. `minbidpricewhite` INT(11) NULL DEFAULT '70' COMMENT 'Starting bid price of White items as a
  74.  
  75. percentage of the randomly chosen buyout price. Default: 70',
  76. `maxbidpricewhite` INT(11) NULL DEFAULT '100' COMMENT 'Starting bid price of White items as a
  77.  
  78. percentage of the randomly chosen buyout price. Default: 100',
  79. `minbidpricegreen` INT(11) NULL DEFAULT '80' COMMENT 'Starting bid price of Green items as a
  80.  
  81. percentage of the randomly chosen buyout price. Default: 80',
  82. `maxbidpricegreen` INT(11) NULL DEFAULT '100' COMMENT 'Starting bid price of Green items as a
  83.  
  84. percentage of the randomly chosen buyout price. Default: 100',
  85. `minbidpriceblue` INT(11) NULL DEFAULT '75' COMMENT 'Starting bid price of Blue items as a
  86.  
  87. percentage of the randomly chosen buyout price. Default: 75',
  88. `maxbidpriceblue` INT(11) NULL DEFAULT '100' COMMENT 'Starting bid price of Blue items as a
  89.  
  90. percentage of the randomly chosen buyout price. Default: 100',
  91. `minbidpricepurple` INT(11) NULL DEFAULT '80' COMMENT 'Starting bid price of Purple items as a
  92.  
  93. percentage of the randomly chosen buyout price. Default: 80',
  94. `maxbidpricepurple` INT(11) NULL DEFAULT '100' COMMENT 'Starting bid price of Purple items as a
  95.  
  96. percentage of the randomly chosen buyout price. Default: 100',
  97. `minbidpriceorange` INT(11) NULL DEFAULT '80' COMMENT 'Starting bid price of Orange items as a
  98.  
  99. percentage of the randomly chosen buyout price. Default: 80',
  100. `maxbidpriceorange` INT(11) NULL DEFAULT '100' COMMENT 'Starting bid price of Orange items as a
  101.  
  102. percentage of the randomly chosen buyout price. Default: 100',
  103. `minbidpriceyellow` INT(11) NULL DEFAULT '80' COMMENT 'Starting bid price of Yellow items as a
  104.  
  105. percentage of the randomly chosen buyout price. Default: 80',
  106. `maxbidpriceyellow` INT(11) NULL DEFAULT '100' COMMENT 'Starting bid price of Yellow items as a
  107.  
  108. percentage of the randomly chosen buyout price. Default: 100',
  109. `maxstackgrey` INT(11) NULL DEFAULT '0' COMMENT 'Stack size limits for item qualities - a value of
  110.  
  111. 0 will disable a maximum stack size for that quality, which will allow the bot to create items in stack
  112.  
  113. as large as the item allows.',
  114. `maxstackwhite` INT(11) NULL DEFAULT '0' COMMENT 'Stack size limits for item qualities - a value of
  115.  
  116. 0 will disable a maximum stack size for that quality, which will allow the bot to create items in stack
  117.  
  118. as large as the item allows.',
  119. `maxstackgreen` INT(11) NULL DEFAULT '0' COMMENT 'Stack size limits for item qualities - a value of
  120.  
  121. 0 will disable a maximum stack size for that quality, which will allow the bot to create items in stack
  122.  
  123. as large as the item allows.',
  124. `maxstackblue` INT(11) NULL DEFAULT '0' COMMENT 'Stack size limits for item qualities - a value of
  125.  
  126. 0 will disable a maximum stack size for that quality, which will allow the bot to create items in stack
  127.  
  128. as large as the item allows.',
  129. `maxstackpurple` INT(11) NULL DEFAULT '0' COMMENT 'Stack size limits for item qualities - a value
  130.  
  131. of 0 will disable a maximum stack size for that quality, which will allow the bot to create items in
  132.  
  133. stack as large as the item allows.',
  134. `maxstackorange` INT(11) NULL DEFAULT '0' COMMENT 'Stack size limits for item qualities - a value
  135.  
  136. of 0 will disable a maximum stack size for that quality, which will allow the bot to create items in
  137.  
  138. stack as large as the item allows.',
  139. `maxstackyellow` INT(11) NULL DEFAULT '0' COMMENT 'Stack size limits for item qualities - a value
  140.  
  141. of 0 will disable a maximum stack size for that quality, which will allow the bot to create items in
  142.  
  143. stack as large as the item allows.',
  144. `buyerpricegrey` INT(11) NULL DEFAULT '1' COMMENT 'Multiplier to vendorprice when buying grey items
  145.  
  146. from auctionhouse',
  147. `buyerpricewhite` INT(11) NULL DEFAULT '3' COMMENT 'Multiplier to vendorprice when buying white
  148.  
  149. items from auctionhouse',
  150. `buyerpricegreen` INT(11) NULL DEFAULT '5' COMMENT 'Multiplier to vendorprice when buying green
  151.  
  152. items from auctionhouse',
  153. `buyerpriceblue` INT(11) NULL DEFAULT '12' COMMENT 'Multiplier to vendorprice when buying blue
  154.  
  155. items from auctionhouse',
  156. `buyerpricepurple` INT(11) NULL DEFAULT '15' COMMENT 'Multiplier to vendorprice when buying purple
  157.  
  158. items from auctionhouse',
  159. `buyerpriceorange` INT(11) NULL DEFAULT '20' COMMENT 'Multiplier to vendorprice when buying orange
  160.  
  161. items from auctionhouse',
  162. `buyerpriceyellow` INT(11) NULL DEFAULT '22' COMMENT 'Multiplier to vendorprice when buying yellow
  163.  
  164. items from auctionhouse',
  165. `buyerbiddinginterval` INT(11) NULL DEFAULT '1' COMMENT 'Interval how frequently AHB bids on each
  166.  
  167. AH. Time in minutes',
  168. `buyerbidsperinterval` INT(11) NULL DEFAULT '1' COMMENT 'number of bids to put in per bidding
  169.  
  170. interval',
  171. PRIMARY KEY (`auctionhouse`)
  172. )
  173. ENGINE=InnoDB
  174. ROW_FORMAT=DEFAULT;
  175.  
  176. insert into `auctionhousebot`
  177.  
  178. (`auctionhouse`,`name`,`minitems`,`maxitems`,`percentgreytradegoods`,`percentwhitetradegoods`,`percentg
  179.  
  180. reentradegoods`,`percentbluetradegoods`,`percentpurpletradegoods`,`percentorangetradegoods`,`percentyel
  181.  
  182. lowtradegoods`,`percentgreyitems`,`percentwhiteitems`,`percentgreenitems`,`percentblueitems`,`percentpu
  183.  
  184. rpleitems`,`percentorangeitems`,`percentyellowitems`,`minpricegrey`,`maxpricegrey`,`minpricewhite`,`max
  185.  
  186. pricewhite`,`minpricegreen`,`maxpricegreen`,`minpriceblue`,`maxpriceblue`,`minpricepurple`,`maxpricepur
  187.  
  188. ple`,`minpriceorange`,`maxpriceorange`,`minpriceyellow`,`maxpriceyellow`,`minbidpricegrey`,`maxbidprice
  189.  
  190. grey`,`minbidpricewhite`,`maxbidpricewhite`,`minbidpricegreen`,`maxbidpricegreen`,`minbidpriceblue`,`ma
  191.  
  192. xbidpriceblue`,`minbidpricepurple`,`maxbidpricepurple`,`minbidpriceorange`,`maxbidpriceorange`,`minbidp
  193.  
  194. riceyellow`,`maxbidpriceyellow`,`maxstackgrey`,`maxstackwhite`,`maxstackgreen`,`maxstackblue`,`maxstack
  195.  
  196. purple`,`maxstackorange`,`maxstackyellow`,`buyerpricegrey`,`buyerpricewhite`,`buyerpricegreen`,`buyerpr
  197.  
  198. iceblue`,`buyerpricepurple`,`buyerpriceorange`,`buyerpriceyellow`,`buyerbiddinginterval`,`buyerbidsperi
  199.  
  200. nterval`) values
  201. (2,'Alliance',250,250,0,27,12,10,1,0,0,0,10,30,8,2,0,0,100,150,150,250,800,1400,1250,1750,2250,4550,325
  202.  
  203. 0,5550,5250,6550,70,100,70,100,80,100,75,100,80,100,80,100,80,100,0,0,3,2,1,1,1,1,3,5,12,15,20,22,1,1),
  204. (6,'Horde',250,250,0,27,12,10,1,0,0,0,10,30,8,2,0,0,100,150,150,250,800,1400,1250,1750,2250,4550,3250,5
  205.  
  206. 550,5250,6550,70,100,70,100,80,100,75,100,80,100,80,100,80,100,0,0,3,2,1,1,1,1,3,5,12,15,20,22,1,1),
  207. (7,'Neutral',250,250,0,27,12,10,1,0,0,0,10,30,8,2,0,0,100,150,150,250,800,1400,1250,1750,2250,4550,3250
  208.  
  209. ,5550,5250,6550,70,100,70,100,80,100,75,100,80,100,80,100,80,100,0,0,3,2,1,1,1,1,3,5,12,15,20,22
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!