API tools faq
paste
Advertisement
Guest User

Deathknell pooled spawns.

a guest
Mar 13th, 2015
68
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 22.99 KB | None | 0 0
raw download clone embed print report
  1. -- Deathknell conversion to dynamic pooling
  2.  
  3. -- Add pools to pool template
  4. DELETE FROM `pool_template` WHERE entry BETWEEN 100000 AND 100035;
  5. INSERT INTO `pool_template` VALUES
  6. (100008,0,1,'Calvin Montague (Auto)'),
  7. (100007,3,7,'Scarlet convert/initiates (statics) - 7'),
  8. (100006,0,1,'Samuel Fipps (AUTO)'),
  9. (100000,20,40,'Ghouls, Zombies and Rattlecage (AUTO-83)'),
  10. (100001,15,30,'Duskbat and Young Scavenger (AUTO-58)'),
  11. (100002,10,20,'Mangy bat and Ragged Scav (AUTO-40)'),
  12. (100003,8,12,'Scarlet convert/initiates (roaming) - 26'),
  13. (100004,8,16,'Young Nightweb spider (AUTO-30)'),
  14. (100005,8,16,'Nightweb spider (AUTO-27)'),
  15. (100012,0,1,'Meven Korgal (AUTO)'),
  16. (100009,0,1,'Karrel Grayves (AUTO)'),
  17. (100010,0,1,'Daniel Ulfman (AUTO)'),
  18. (100011,0,1,'Stephen Bhartec (AUTO)'),
  19. (100013,0,1,'Deathguard Randolph (AUTO)'),
  20. (100014,0,1,'Deathguard Bartrand (AUTO)'),
  21. (100015,0,1,'Deathguard Phillip (AUTO)'),
  22. (100016,0,1,'Marquell Ebonwood (AUTO)'),
  23. (100017,0,1,'Joshua Kien (AUTO)'),
  24. (100018,0,1,'Archibald Kava (AUTO)'),
  25. (100019,0,1,'David Trias (AUTO)'),
  26. (100020,0,1,'Dannal Stern (AUTO)'),
  27. (100021,0,1,'Deathguard Saltain'),
  28. (100022,0,1,'Blacksmith Rand'),
  29. (100023,0,1,'Harold Raims'),
  30. (100024,0,1,'Deathguard Oliver'),
  31. (100025,0,1,'Venya Marthand'),
  32. (100026,0,1,'Maxmillion'),
  33. (100027,0,1,'Kayla Smithe'),
  34. (100028,0,1,'Shadow Priest Sarvis'),
  35. (100029,0,1,'Novice Elreth'),
  36. (100030,0,1,'Isabella'),
  37. (100031,0,1,'Dark Cleric Duesten'),
  38. (100032,0,1,'Undertaker Mordo'),
  39. (100033,3,5,'Deathguard Elite'),
  40. (100034,0,2,'Spirit Healer'),
  41. (100035,0,1,'Executor Arren');
  42.  
  43. -- Add creatures into pool
  44. DELETE FROM `pool_creature_info` WHERE pool_id BETWEEN 100000 AND 100035;
  45. INSERT INTO `pool_creature_info` VALUES
  46. (100000,1501,0,40,1,1,10973,0,180,0,0,10,0,42,0,1,0,0,0),
  47. (100000,1502,0,40,1,1,829,0,180,0,0,5,0,42,0,1,0,0,0),
  48. (100000,1890,0,20,1,1,11400,1,180,0,0,5,0,55,0,1,0,0,0),
  49. (100001,1512,0,0,1,1,4732,0,180,0,0,10,0,42,0,1,0,0,0),
  50. (100001,1508,0,0,1,1,447,0,180,0,0,5,0,42,0,1,0,0,0),
  51. (100002,1509,0,0,1,1,604,0,180,0,0,5,0,55,0,1,0,0,0),
  52. (100002,1513,0,0,1,1,9535,0,180,0,0,10,0,71,0,1,0,0,0),
  53. (100003,1506,0,80,1,1,2403,1,180,0,0,10,0,71,0,1,0,0,0),
  54. (100003,1507,0,20,1,1,2478,1,180,0,0,10,0,67,174,1,0,0,0),
  55. (100004,1504,0,0,1,1,513,0,180,0,0,5,0,55,0,1,0,0,0),
  56. (100005,1505,0,0,1,1,30,0,180,0,0,5,0,71,0,1,0,0,0),
  57. (100006,1919,0,0,1,1,10977,1,90,0,0,5,0,102,0,1,0,0,0),
  58. (100007,1506,0,50,1,1,2403,1,180,0,0,0,0,71,0,0,0,0,0),
  59. (100007,1507,0,50,1,1,2467,1,180,0,0,0,0,67,174,0,0,0,0),
  60. (100008,6784,0,0,1,1,5509,1,90,0,0,0,0,102,0,0,0,0,0),
  61. (100009,1918,0,0,1,1,569,1,90,0,0,5,0,71,0,1,0,0,0),
  62. (100010,1917,0,0,1,1,3668,1,90,0,0,5,0,55,0,1,0,0,0),
  63. (100011,1916,0,0,1,1,11405,1,90,0,0,0,0,71,0,0,0,0,0),
  64. (100012,1667,0,0,1,1,3531,1,90,0,0,0,0,102,0,0,0,0,0),
  65. (100013,1736,0,0,1,1,1590,1,90,0,0,0,0,11828,0,0,0,0,0),
  66. (100014,1741,0,0,1,1,1587,1,90,0,0,2,0,7048,0,1,0,0,0),
  67. (100015,1739,0,0,1,1,1589,1,90,0,0,0,0,11828,0,2,0,0,0),
  68. (100016,2315,0,0,1,1,1594,0,90,0,0,0,0,102,0,2,0,0,0),
  69. (100017,2115,0,0,1,1,1577,1,90,0,0,0,0,102,0,0,0,0,0),
  70. (100018,2113,0,0,1,1,1574,1,90,0,0,0,0,102,0,0,0,0,0),
  71. (100019,2122,0,0,1,1,1580,1,90,0,0,0,0,102,0,0,0,0,0),
  72. (100020,2119,0,0,1,1,1578,1,90,0,0,0,0,102,0,0,0,0,0),
  73. (100021,1740,0,0,1,1,3523,1,90,0,0,5,0,274,0,1,0,0,0),
  74. (100022,2116,0,0,1,1,1575,1,90,0,0,0,0,102,0,0,0,0,0),
  75. (100023,2117,0,0,1,1,1576,1,90,0,0,0,0,102,0,0,0,0,0),
  76. (100024,1737,0,0,1,1,1588,1,90,0,0,0,0,11828,0,2,0,0,0),
  77. (100025,5667,0,0,1,1,3944,1,90,0,0,0,0,198,0,0,0,0,0),
  78. (100026,2126,0,0,1,1,1581,1,90,0,0,0,0,102,0,0,0,0,0),
  79. (100027,5749,0,0,1,1,4175,1,90,0,0,0,0,178,382,0,0,0,0),
  80. (100028,1569,0,0,1,1,1584,1,90,0,0,0,0,102,0,0,0,0,0),
  81. (100029,1661,0,0,1,1,1593,1,90,0,0,0,0,71,0,0,0,0,0),
  82. (100030,2124,0,0,1,1,1592,1,90,0,0,0,0,102,0,0,0,0,0),
  83. (100031,2123,0,0,1,1,1579,1,90,0,0,0,0,102,0,0,0,0,0),
  84. (100032,1568,0,0,1,1,1582,1,90,0,0,0,0,102,0,0,0,0,0),
  85. (100033,7980,0,0,1,1,14369,1,90,0,0,0,0,21270,0,0,0,0,0),
  86. (100034,6491,0,0,1,1,0,0,180,0,0,0,0,4120,0,0,0,0,0),
  87. (100035,1570,0,0,1,1,1583,1,90,0,0,0,0,102,0,0,0,0,0);
  88.  
  89. -- Add spawn points
  90. DELETE FROM `pool_spawns` WHERE pool_id BETWEEN 100000 AND 100035;
  91. INSERT INTO `pool_spawns`-- Move data from creature_addon to creature_template_addon
  92. DELETE FROM `creature_template_addon` WHERE entry IN
  93. (
  94.     1501, 1502, 1506, 1507, 1568, 1569, 1570, 1661, 1667, 1736, 1737,
  95.     1739, 1740, 1741, 1916, 1917, 1918, 1919, 2113, 2115, 2116, 2117,
  96.     2119, 2122, 2123, 2124, 2126, 2315, 5667, 5749, 6784
  97. );
  98.  
  99. INSERT INTO `creature_template_addon` VALUES
  100. (1501, 0, 0, 0, 4097, 0, NULL),
  101. (1502, 0, 0, 0, 4097, 0, NULL),
  102. (1506, 0, 0, 0, 4097, 0, NULL),
  103. (1507, 0, 0, 0, 4097, 0, 12544),
  104. (1568, 0, 0, 0, 4097, 0, NULL),
  105. (1569, 0, 0, 0, 4097, 0, NULL),
  106. (1570, 0, 0, 0, 4097, 0, NULL),
  107. (1661, 0, 0, 0, 4097, 0, NULL),
  108. (1667, 0, 0, 0, 4097, 0, NULL),
  109. (1736, 0, 0, 0, 4097, 0, 18950),
  110. (1737, 287060, 0, 0, 4097, 0, 18950),
  111. (1739, 287050, 0, 0, 0, 0, NULL),
  112. (1740, 0, 0, 0, 4097, 0, NULL),
  113. (1741, 0, 0, 0, 4097, 0, 18950),
  114. (1916, 0, 0, 0, 4097, 0, NULL),
  115. (1917, 0, 0, 0, 4097, 0, NULL),
  116. (1918, 0, 0, 0, 4097, 0, NULL),
  117. (1919, 0, 0, 0, 4097, 0, NULL),
  118. (2113, 0, 0, 0, 4097, 0, NULL),
  119. (2115, 0, 0, 0, 4097, 0, NULL),
  120. (2116, 0, 0, 0, 4097, 0, NULL),
  121. (2117, 0, 0, 0, 4097, 0, NULL),
  122. (2119, 0, 0, 0, 4097, 0, NULL),
  123. (2122, 0, 0, 0, 4097, 0, NULL),
  124. (2123, 0, 0, 0, 4097, 0, NULL),
  125. (2124, 0, 0, 0, 4097, 0, NULL),
  126. (2126, 0, 0, 0, 4097, 0, NULL),
  127. (2315, 319160, 0, 0, 0, 0, NULL),
  128. (5667, 0, 0, 0, 4097, 0, NULL),
  129. (5749, 0, 0, 0, 4097, 0, NULL),
  130. (6784, 0, 0, 0, 4097, 0, NULL);
  131.  
  132. -- Remove old creatures
  133. DELETE FROM creature WHERE guid IN
  134. (
  135.     29883, 29884, 37868, 37869, 37870, 37871, 38330, 38331, 41905, 41906, 41975, 41976, 42014, 42015, 42016, 42047,
  136.     42048, 42075, 42076, 43923, 44518, 44524, 44526, 44537, 44641, 44680, 44684, 44686, 44688, 44695, 44696, 44697,
  137.     44698, 44721, 44725, 44727, 44735, 44779, 44788, 44791, 44801, 44808, 44818, 44823, 44827, 44830, 44831, 44833,
  138.     44839, 44840, 44842, 44845, 44846, 44847, 44849, 44850, 44851, 44854, 44856, 44857, 44858, 44859, 44860, 44861,
  139.     44926, 44927, 44930, 44935, 44936, 44941, 44942, 44956, 44958, 44960, 44961, 44962, 44963, 44965, 44967, 44969,
  140.     44971, 44974, 44979, 29807, 29808, 35241, 35242, 35244, 38314, 38315, 38316, 38317, 39035, 39036, 39037, 39038,
  141.     41897, 41898, 41899, 41900, 41901, 41902, 41903, 41904, 41973, 41974, 44533, 44534, 44535, 44669, 44678, 44705,
  142.     44706, 44711, 44712, 44714, 44716, 44717, 44718, 44719, 44722, 44724, 44728, 44729, 44730, 44731, 44732, 44733,
  143.     44803, 44805, 44806, 44810, 44813, 44815, 44816, 44821, 44825, 44829, 44835, 44844, 44848, 30064, 30065, 30070,
  144.     30071, 30072, 38039, 38040, 38052, 38396, 38397, 38398, 38399, 41776, 41808, 41825, 41935, 43921, 44499, 44500,
  145.     44501, 44502, 44503, 44504, 44505, 44523, 44527, 44528, 44529, 44530, 44531, 44532, 44538, 44541, 44543, 44544,
  146.     44702, 44703, 44708, 44710, 44713, 29809, 29810, 29811, 29812, 29879, 29881, 35247, 37702, 38318, 38319, 38320,
  147.     38321, 38322, 38323, 38324, 38325, 39541, 40168, 44507, 44509, 44510, 44514, 44515, 44928, 44940, 44945, 44949,
  148.     44954, 44957, 44964, 44975, 44976, 44980, 32030, 32031, 32032, 32033, 38256, 38258, 38259, 38260, 38261, 38449,
  149.     38454, 38455, 38456, 44477, 44478, 44479, 44560, 44689, 44690, 44692, 44707, 44709, 44866, 44867, 44883, 44884,
  150.     44886, 44887, 44888, 44889, 29894, 29895, 29896, 37872, 37873, 37874, 37876, 38332, 38333, 38334, 44484, 44485,
  151.     44699, 44700, 44701, 44890, 44891, 44892, 44893, 44896, 44897, 44902, 44903, 44905, 44907, 44911, 44914, 44715,
  152.     28493, 44670, 28441, 28442, 44986, 28711, 28498, 28705, 31916, 28461, 28468, 28466, 28464, 28708, 28462, 28465,
  153.     28706, 28492, 28467, 28460, 29804, 29806, 28463, 28469, 29803, 28707, 28709, 28710, 28712, 28713, 40547, 10011,
  154.     29805
  155. );
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!