API tools faq
paste
STARRHELD

Untitled

STARRHELD
Mar 17th, 2017
126
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 31.23 KB | None | 0 0
raw download clone embed print report
  1. SET @cguid:=5005755;
  2. DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+53;
  3. INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES
  4. (@CGUID+0, 25419, 571, 1, 1, 0, 0, 4419.61, 5952.447, 57.03477, 1.121153, 120, 0, 0, 0, 0, 0, 0, 0, 0), -- 25419 (Area: -1)
  5. (@CGUID+1, 25419, 571, 1, 1, 0, 0, 4448.788, 5916.716, 57.72005, 5.721869, 120, 0, 0, 0, 0, 0, 0, 0, 0), -- 25419 (Area: -1)
  6. (@CGUID+2, 25419, 571, 1, 1, 0, 0, 4448.035, 5957.813, 57.98078, 1.14177, 120, 0, 0, 0, 0, 0, 0, 0, 0), -- 25419 (Area: -1)
  7. (@CGUID+3, 25419, 571, 1, 1, 0, 0, 4461.483, 5886.482, 61.893, 3.48094, 120, 0, 0, 0, 0, 0, 0, 0, 0), -- 25419 (Area: -1)
  8. (@CGUID+4, 25419, 571, 1, 1, 0, 0, 4413.073, 5904.856, 56.37568, 4.019106, 120, 0, 0, 0, 0, 0, 0, 0, 0), -- 25419 (Area: -1)
  9. (@CGUID+5, 25419, 571, 1, 1, 0, 0, 4382.702, 5905.957, 55.72123, 2.909203, 120, 0, 0, 0, 0, 0, 0, 0, 0), -- 25419 (Area: -1)
  10. (@CGUID+6, 25419, 571, 1, 1, 0, 0, 4421.654, 5896.283, 55.94137, 4.782922, 120, 0, 0, 0, 0, 0, 0, 0, 0), -- 25419 (Area: -1)
  11. (@CGUID+7, 25419, 571, 1, 1, 0, 0, 4348.286, 5917.032, 60.72934, 5.387158, 120, 0, 0, 0, 0, 0, 0, 0, 0), -- 25419 (Area: 4134)
  12. (@CGUID+8, 25419, 571, 1, 1, 0, 0, 4451.888, 5851.77, 69.95783, 6.034452, 120, 0, 0, 0, 0, 0, 0, 0, 0), -- 25419 (Area: 4134)
  13. (@CGUID+9, 25417, 571, 1, 1, 0, 0, 4393.225, 5881.099, 55.97466, 4.578428, 120, 0, 0, 0, 0, 0, 0, 0, 0), -- 25417 (Area: 4134)
  14. (@CGUID+10, 25419, 571, 1, 1, 0, 0, 4386.144, 5881.497, 55.75355, 3.575644, 120, 0, 0, 0, 0, 0, 0, 0, 0), -- 25419 (Area: 4134)
  15. (@CGUID+11, 25419, 571, 1, 1, 0, 0, 4384.099, 5850.214, 69.215, 0.3004377, 120, 0, 0, 0, 0, 0, 0, 0, 0), -- 25419 (Area: 4134)
  16. (@CGUID+12, 25419, 571, 1, 1, 0, 0, 4320.845, 5906.834, 57.5699, 5.094295, 120, 0, 0, 0, 0, 0, 0, 0, 0), -- 25419 (Area: 4134)
  17. (@CGUID+13, 25419, 571, 1, 1, 0, 0, 4343.608, 5851.565, 56.67913, 1.960553, 120, 0, 0, 0, 0, 0, 0, 0, 0), -- 25419 (Area: 4134)
  18. (@CGUID+14, 25417, 571, 1, 1, 0, 0, 4313.515, 5889.598, 56.97303, 0.8698314, 120, 0, 0, 0, 0, 0, 0, 0, 0), -- 25417 (Area: 4134)
  19. (@CGUID+15, 25419, 571, 1, 1, 0, 0, 4344.71, 5882.019, 56.23266, 5.41927, 120, 0, 0, 0, 0, 0, 0, 0, 0), -- 25419 (Area: 4134)
  20. (@CGUID+16, 25419, 571, 1, 1, 0, 0, 4315.075, 5880.785, 56.03077, 1.569275, 120, 0, 0, 0, 0, 0, 0, 0, 0), -- 25419 (Area: 4134)
  21. (@CGUID+17, 25419, 571, 1, 1, 0, 0, 4284.087, 5915.679, 57.39619, 2.622871, 120, 0, 0, 0, 0, 0, 0, 0, 0), -- 25419 (Area: 4134)
  22. (@CGUID+18, 25419, 571, 1, 1, 0, 0, 4386.544, 5815.437, 71.95725, 5.795134, 120, 0, 0, 0, 0, 0, 0, 0, 0), -- 25419 (Area: 4134)
  23. (@CGUID+19, 25419, 571, 1, 1, 0, 0, 4315.096, 5840.36, 58.56625, 5.083281, 120, 0, 0, 0, 0, 0, 0, 0, 0), -- 25419 (Area: 4134)
  24. (@CGUID+20, 25419, 571, 1, 1, 0, 0, 4285.949, 5883.651, 58.90496, 0.1985445, 120, 0, 0, 0, 0, 0, 0, 0, 0), -- 25419 (Area: 4134)
  25. (@CGUID+21, 25417, 571, 1, 1, 0, 0, 4417.659, 5814.049, 73.62916, 2.305409, 120, 0, 0, 0, 0, 0, 0, 0, 0), -- 25417 (Area: 4134)
  26. (@CGUID+22, 25419, 571, 1, 1, 0, 0, 4347.293, 5797.105, 70.4449, 3.9803, 120, 0, 0, 0, 0, 0, 0, 0, 0), -- 25419 (Area: 4134)
  27. (@CGUID+23, 25417, 571, 1, 1, 0, 0, 4287.359, 5808.424, 65.015, 1.333162, 120, 0, 0, 0, 0, 0, 0, 0, 0), -- 25417 (Area: 4134)
  28. (@CGUID+24, 25419, 571, 1, 1, 0, 0, 4315.808, 5817.751, 63.17729, 1.716837, 120, 0, 0, 0, 0, 0, 0, 0, 0), -- 25419 (Area: 4134)
  29. (@CGUID+25, 25419, 571, 1, 1, 0, 0, 4295.346, 5844.404, 59.16083, 5.644846, 120, 0, 0, 0, 0, 0, 0, 0, 0), -- 25419 (Area: 4134)
  30. (@CGUID+26, 25417, 571, 1, 1, 0, 0, 4313.68, 5790.48, 68.38795, 3.758053, 120, 0, 0, 0, 0, 0, 0, 0, 0), -- 25417 (Area: 4134)
  31. (@CGUID+27, 25417, 571, 1, 1, 0, 0, 4306.196, 5755.188, 74.17075, 0.4614642, 120, 0, 0, 0, 0, 0, 0, 0, 0), -- 25417 (Area: 4134)
  32. (@CGUID+28, 25417, 571, 1, 1, 0, 0, 4285.329, 5785.763, 69.6144, 6.263107, 120, 0, 0, 0, 0, 0, 0, 0, 0), -- 25417 (Area: 4134)
  33. (@CGUID+29, 25417, 571, 1, 1, 0, 0, 4380.976, 5786.691, 76.09017, 5.706718, 120, 0, 0, 0, 0, 0, 0, 0, 0), -- 25417 (Area: 4134)
  34. (@CGUID+30, 25417, 571, 1, 1, 0, 0, 4345.296, 5780.17, 74.79289, 2.769791, 120, 0, 0, 0, 0, 0, 0, 0, 0), -- 25417 (Area: 4134)
  35. (@CGUID+31, 25417, 571, 1, 1, 0, 0, 4380.676, 5750.541, 81.36572, 2.86511, 120, 0, 0, 0, 0, 0, 0, 0, 0), -- 25417 (Area: 4134)
  36. (@CGUID+32, 25417, 571, 1, 1, 0, 0, 4277.169, 5757.782, 68.8129, 0.09976582, 120, 0, 0, 0, 0, 0, 0, 0, 0), -- 25417 (Area: 4134)
  37. (@CGUID+33, 25417, 571, 1, 1, 0, 0, 4350.86, 5749.646, 82.05293, 4.125741, 120, 0, 0, 0, 0, 0, 0, 0, 0), -- 25417 (Area: 4134)
  38. (@CGUID+34, 25419, 571, 1, 1, 0, 0, 4411.514, 5790.069, 76.78316, 3.849571, 120, 0, 0, 0, 0, 0, 0, 0, 0), -- 25419 (Area: 4134)
  39. (@CGUID+35, 25417, 571, 1, 1, 0, 0, 4413.009, 5788.343, 77.10886, 5.096886, 120, 0, 0, 0, 0, 0, 0, 0, 0), -- 25417 (Area: 4134)
  40. (@CGUID+36, 25417, 571, 1, 1, 0, 0, 4351.502, 5714.72, 86.44733, 4.789735, 120, 0, 0, 0, 0, 0, 0, 0, 0), -- 25417 (Area: 4134)
  41. (@CGUID+37, 25417, 571, 1, 1, 0, 0, 4373.826, 5713.223, 85.16576, 3.343639, 120, 0, 0, 0, 0, 0, 0, 0, 0), -- 25417 (Area: 4134)
  42. (@CGUID+38, 25417, 571, 1, 1, 0, 0, 4317.503, 5711.320, 89.224, 4.042527, 120, 0, 0, 0, 0, 0, 0, 0, 0), -- 25417 (Area: 4133)
  43. (@CGUID+39, 25417, 571, 1, 1, 0, 0, 4250.292, 5746.842, 66.42384, 1.142227, 120, 0, 0, 0, 0, 0, 0, 0, 0), -- 25417 (Area: 4133)
  44. (@CGUID+40, 25417, 571, 1, 1, 0, 0, 4309.887, 5676.108, 92.774, 5.29737, 120, 0, 0, 0, 0, 0, 0, 0, 0), -- 25417 (Area: 4133)
  45. (@CGUID+41, 25417, 571, 1, 1, 0, 0, 4315.956, 5653.785, 94.06521, 3.442963, 120, 0, 0, 0, 0, 0, 0, 0, 0), -- 25417 (Area: 4133)
  46. (@CGUID+42, 25417, 571, 1, 1, 0, 0, 4255.53, 5709.95, 56.70618, 2.291923, 120, 0, 0, 0, 0, 0, 0, 0, 0), -- 25417 (Area: 4133)
  47. (@CGUID+43, 25417, 571, 1, 1, 0, 0, 4242.124, 5780.734, 66.33765, 3.578308, 120, 0, 0, 0, 0, 0, 0, 0, 0), -- 25417 (Area: 4133)
  48. (@CGUID+44, 25417, 571, 1, 1, 0, 0, 4218.904, 5751.581, 65.40733, 1.580321, 120, 0, 0, 0, 0, 0, 0, 0, 0), -- 25417 (Area: 4133)
  49. (@CGUID+45, 25419, 571, 1, 1, 0, 0, 4420.043, 5841.368, 67.582, 1.580321, 120, 0, 0, 0, 0, 0, 0, 0, 0), -- 25417 (Area: 4133)
  50. -- water eles
  51. (@CGUID+46, 25419, 571, 1, 1, 0, 0, 4456.091, 5874.284, 64.093, 1.580321, 120, 0, 0, 0, 0, 0, 0, 0, 0), -- 25417 (Area: 4133)
  52. (@CGUID+47, 25419, 571, 1, 1, 0, 0, 4456.091, 5874.284, 64.093, 1.580321, 120, 0, 0, 0, 0, 0, 0, 0, 0), -- 25417 (Area: 4133)
  53. (@CGUID+48, 25419, 571, 1, 1, 0, 0, 4325.170, 5855.809, 57.569, 1.580321, 120, 0, 0, 0, 0, 0, 0, 0, 0), -- 25417 (Area: 4133)
  54. (@CGUID+49, 25419, 571, 1, 1, 0, 0, 4325.170, 5855.809, 57.569, 1.580321, 120, 0, 0, 0, 0, 0, 0, 0, 0), -- 25417 (Area: 4133)
  55. -- fire eles
  56. (@CGUID+50, 25417, 571, 1, 1, 0, 0, 4348.101, 5731.171, 83.638, 1.580321, 120, 0, 0, 0, 0, 0, 0, 0, 0), -- 25417 (Area: 4133)
  57. (@CGUID+51, 25417, 571, 1, 1, 0, 0, 4348.101, 5731.171, 83.638, 1.580321, 120, 0, 0, 0, 0, 0, 0, 0, 0), -- 25417 (Area: 4133)
  58. (@CGUID+52, 25417, 571, 1, 1, 0, 0, 4348.101, 5731.171, 83.638, 1.580321, 120, 0, 0, 0, 0, 0, 0, 0, 0), -- 25417 (Area: 4133)
  59. (@CGUID+53, 25417, 571, 1, 1, 0, 0, 4348.101, 5731.171, 83.638, 1.580321, 120, 0, 0, 0, 0, 0, 0, 0, 0); -- 25417 (Area: 4133)
  60.  
  61. DELETE FROM `creature_addon` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+53;
  62. INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES
  63. (@CGUID+0, 0, 0, 0, 1, 0, ''), -- 25415
  64. (@CGUID+1, 0, 0, 0, 1, 0, ''), -- 25419
  65. (@CGUID+2, 0, 0, 0, 1, 0, ''), -- 25419
  66. (@CGUID+3, 0, 0, 0, 1, 0, ''), -- 25419
  67. (@CGUID+4, 0, 0, 0, 1, 0, ''), -- 25419
  68. (@CGUID+5, 0, 0, 0, 1, 0, ''), -- 25419
  69. (@CGUID+6, 0, 0, 0, 1, 0, ''), -- 25418
  70. (@CGUID+7, 0, 0, 0, 1, 0, ''), -- 25419
  71. (@CGUID+8, 0, 0, 0, 1, 0, ''), -- 25419
  72. (@CGUID+9, 0, 0, 0, 1, 0, ''), -- 25419
  73. (@CGUID+10, 0, 0, 0, 1, 0, ''), -- 25419
  74. (@CGUID+11, 0, 0, 0, 1, 0, ''), -- 25417
  75. (@CGUID+12, 0, 0, 0, 1, 0, ''), -- 25419
  76. (@CGUID+13, 0, 0, 0, 1, 0, ''), -- 25419
  77. (@CGUID+14, 0, 0, 0, 1, 0, ''), -- 25419
  78. (@CGUID+15, 0, 0, 0, 1, 0, ''), -- 25419
  79. (@CGUID+16, 0, 0, 0, 1, 0, ''), -- 25417
  80. (@CGUID+17, 0, 0, 0, 1, 0, ''), -- 25419
  81. (@CGUID+18, 0, 0, 0, 1, 0, ''), -- 25419
  82. (@CGUID+19, 0, 0, 0, 1, 0, ''), -- 25419
  83. (@CGUID+20, 0, 0, 0, 1, 0, ''), -- 25419
  84. (@CGUID+21, 0, 0, 0, 1, 0, ''), -- 25419
  85. (@CGUID+22, 0, 0, 0, 1, 0, ''), -- 25419
  86. (@CGUID+23, 0, 0, 0, 1, 0, ''), -- 25417
  87. (@CGUID+24, 0, 0, 0, 1, 0, ''), -- 25419
  88. (@CGUID+25, 0, 0, 0, 1, 0, ''), -- 25417
  89. (@CGUID+26, 0, 0, 0, 1, 0, ''), -- 25419
  90. (@CGUID+27, 0, 0, 0, 1, 0, ''), -- 25419
  91. (@CGUID+28, 0, 0, 0, 1, 0, ''), -- 25417
  92. (@CGUID+29, 0, 0, 0, 1, 0, ''), -- 25417
  93. (@CGUID+30, 0, 0, 0, 1, 0, ''), -- 25417
  94. (@CGUID+31, 0, 0, 0, 1, 0, ''), -- 25417
  95. (@CGUID+32, 0, 0, 0, 1, 0, ''), -- 25417
  96. (@CGUID+33, 0, 0, 0, 1, 0, ''), -- 31685
  97. (@CGUID+34, 0, 0, 0, 1, 0, ''), -- 25417
  98. (@CGUID+35, 0, 0, 0, 1, 0, ''), -- 25417
  99. (@CGUID+36, 0, 0, 0, 1, 0, ''), -- 25417
  100. (@CGUID+37, 0, 0, 0, 1, 0, ''), -- 25419
  101. (@CGUID+38, 0, 0, 0, 1, 0, ''), -- 25417
  102. (@CGUID+39, 0, 0, 0, 1, 0, ''), -- 25417
  103. (@CGUID+40, 0, 0, 0, 1, 0, ''), -- 25417
  104. (@CGUID+41, 0, 0, 0, 1, 0, ''), -- 25417
  105. (@CGUID+42, 0, 0, 0, 1, 0, ''), -- 25417
  106. (@CGUID+43, 0, 0, 0, 1, 0, ''), -- 25417
  107. (@CGUID+44, 0, 0, 0, 1, 0, ''), -- 25417
  108. (@CGUID+45, 0, 0, 0, 1, 0, ''), -- 25417
  109. (@CGUID+46, 0, 0, 0, 1, 0, ''), -- 25417
  110. (@CGUID+47, 0, 0, 0, 1, 0, ''), -- 25417
  111. (@CGUID+48, 0, 0, 0, 1, 0, ''), -- 25416
  112. (@CGUID+49, 0, 0, 0, 1, 0, ''), -- 24613
  113. (@CGUID+50, 0, 0, 0, 1, 0, ''), -- 24613
  114. (@CGUID+51, 0, 0, 0, 1, 0, ''), -- 24613
  115. (@CGUID+52, 0, 0, 0, 1, 0, ''), -- 24614
  116. (@CGUID+53, 0, 0, 0, 1, 0, ''); -- 31685
  117.  
  118. UPDATE `creature` SET `spawntimesecs` = 300 , `spawndist` = 10 , `curhealth` = 1 , `MovementType` = 1 WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+53;
  119. UPDATE `creature` SET `spawntimesecs` = 300 , `spawndist` = 4 , `curhealth` = 1 , `MovementType` = 1 WHERE `guid` = @CGUID+11;
  120.  
  121. -- delete water eles
  122. DELETE FROM `creature` WHERE `guid` BETWEEN 102648 AND 102652;
  123. DELETE FROM `creature` WHERE `guid` BETWEEN 102661 AND 102666;
  124. DELETE FROM `creature` WHERE `guid` IN (102645, 102626);
  125. DELETE FROM `creature_addon` WHERE `guid` BETWEEN 102648 AND 102652;
  126. DELETE FROM `creature_addon` WHERE `guid` BETWEEN 102661 AND 102666;
  127. DELETE FROM `creature_addon` WHERE `guid` IN (102645, 102626);
  128.  
  129. UPDATE `creature` SET `position_x` = 4309.695 , `position_y` = 5633.367 , `position_z` = 94.87403 , `orientation` = 1.413717 WHERE `guid` = 200013;
  130.  
  131. -- air eles
  132. UPDATE `creature` SET `spawndist` = 10 WHERE `guid` BETWEEN 102437 AND 102442;
  133. UPDATE `creature` SET `spawndist` = 10 WHERE `guid` BETWEEN 102471 AND 102485;
  134. UPDATE `creature` SET `spawndist` = 10 WHERE `guid` = 102452;
  135.  
  136.  
  137.  
  138.  
  139.  
  140. -- Pathing for Enraged Tempest Entry: 25415 'TDB FORMAT'
  141. SET @NPC := 102479;
  142. SET @PATH := @NPC * 10;
  143. UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4582.429,`position_y`=5916.411,`position_z`=56.099 WHERE `guid`=@NPC;
  144. DELETE FROM `creature_addon` WHERE `guid`=@NPC;
  145. INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, '');
  146. DELETE FROM `waypoint_data` WHERE `id`=@PATH;
  147. INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
  148. (@PATH,1,4582.429,5916.411,56.099,0,0,0,0,100,0), -- 20:25:05
  149. (@PATH,2,4567.213,5933.478,62.72065,0,0,0,0,100,0), -- 20:25:16
  150. (@PATH,3,4550.817,5949.297,68.55141,0,0,0,0,100,0), -- 20:25:25
  151. (@PATH,4,4542.173,5982.366,71.99318,0,0,0,0,100,0), -- 20:25:36
  152. (@PATH,5,4563.726,6018.92,78.21175,0,0,0,0,100,0), -- 20:25:51
  153. (@PATH,6,4586.041,6047.054,81.09695,0,0,0,0,100,0), -- 20:26:09
  154. (@PATH,7,4606.639,6079.772,79.38864,0,0,0,0,100,0), -- 20:26:23
  155. (@PATH,8,4602.986,6101.729,78.74768,0,0,0,0,100,0), -- 20:26:37
  156. (@PATH,9,4582.914,6126.627,81.2157,0,0,0,0,100,0), -- 20:26:49
  157. (@PATH,10,4556.886,6142.86,81.20538,0,0,0,0,100,0), -- 20:27:03
  158. (@PATH,11,4572.895,6134.833,81.22743,0,0,0,0,100,0), -- 20:27:16
  159. (@PATH,12,4600.353,6109.119,78.72827,0,0,0,0,100,0), -- 20:27:26
  160. (@PATH,13,4604.147,6095.896,79.12968,0,0,0,0,100,0), -- 20:27:39
  161. (@PATH,14,4600.552,6070.209,81.15663,0,0,0,0,100,0), -- 20:27:52
  162. (@PATH,15,4570.93,6028.483,79.49257,0,0,0,0,100,0), -- 20:28:07
  163. (@PATH,16,4542.822,5986.35,72.76584,0,0,0,0,100,0), -- 20:28:19
  164. (@PATH,17,4550.624,5951.442,69.22236,0,0,0,0,100,0), -- 20:28:38
  165. (@PATH,18,4564.791,5935.697,64.15934,0,0,0,0,100,0), -- 20:28:54
  166. (@PATH,19,4582.332,5916.214,55.95428,0,0,0,0,100,0); -- 20:29:03
  167.  
  168.  
  169.  
  170. -- Pathing for Enraged Tempest Entry: 25415 'TDB FORMAT'
  171. SET @NPC := 102473;
  172. SET @PATH := @NPC * 10;
  173. UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4497.891,`position_y`=6137.541,`position_z`=80.16054 WHERE `guid`=@NPC;
  174. DELETE FROM `creature_addon` WHERE `guid`=@NPC;
  175. INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, '');
  176. DELETE FROM `waypoint_data` WHERE `id`=@PATH;
  177. INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
  178. (@PATH,1,4497.891,6137.541,80.16054,0,0,0,0,100,0), -- 20:26:22
  179. (@PATH,2,4497.828,6131.405,79.64149,0,0,0,0,100,0), -- 20:26:30
  180. (@PATH,3,4499.488,6112.93,80.19643,0,0,0,0,100,0), -- 20:26:35
  181. (@PATH,4,4491.456,6088.593,78.08659,0,0,0,0,100,0), -- 20:26:45
  182. (@PATH,5,4505.488,6055.596,76.68158,0,0,0,0,100,0), -- 20:26:52
  183. (@PATH,6,4491.953,6023.114,67.60138,0,0,0,0,100,0), -- 20:27:07
  184. (@PATH,7,4514.078,5986.287,68.74522,0,0,0,0,100,0), -- 20:27:21
  185. (@PATH,8,4500.425,5965.788,63.89717,0,0,0,0,100,0), -- 20:27:39
  186. (@PATH,9,4503.254,5931.495,61.60934,0,0,0,0,100,0), -- 20:27:57
  187. (@PATH,10,4489.393,5948.091,63.07407,0,0,0,0,100,0), -- 20:28:15
  188. (@PATH,11,4513.931,5982.552,67.93922,0,0,0,0,100,0), -- 20:28:30
  189. (@PATH,12,4494.02,6016.712,67.46692,0,0,0,0,100,0), -- 20:28:48
  190. (@PATH,13,4501.351,6044.861,75.96799,0,0,0,0,100,0), -- 20:29:05
  191. (@PATH,14,4492.195,6082.638,77.78274,0,0,0,0,100,0), -- 20:29:21
  192. (@PATH,15,4500.411,6098.807,79.48975,0,0,0,0,100,0), -- 20:29:35
  193. (@PATH,16,4498.477,6122.489,79.74394,0,0,0,0,100,0), -- 20:29:41
  194. (@PATH,17,4497.76,6137.652,80.19916,0,0,0,0,100,0); -- 20:29:51
  195.  
  196. -- paths water eles
  197.  
  198. SET @NPC := @CGUID+46;
  199. SET @PATH := @NPC * 10;
  200. UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4456.091,`position_y`=5874.284,`position_z`=64.093 WHERE `guid`=@NPC;
  201. DELETE FROM `creature_addon` WHERE `guid`=@NPC;
  202. INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, '');
  203. DELETE FROM `waypoint_data` WHERE `id`=@PATH;
  204. INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
  205. (@PATH,1,4456.091,5874.284,64.093,0,0,1,0,100,0), -- 20:26:22
  206. (@PATH,2,4418.135,5826.952,70.059,0,0,1,0,100,0), -- 20:26:30
  207. (@PATH,3,4364.599,5757.606,80.218,0,0,1,0,100,0), -- 20:26:35
  208. (@PATH,4,4312.593,5704.205,90.690,0,0,1,0,100,0), -- 20:26:45
  209. (@PATH,5,4309.625,5638.164,94.449,0,0,1,0,100,0), -- 20:26:45
  210. (@PATH,6,4312.593,5704.205,90.690,0,0,1,0,100,0), -- 20:26:45
  211. (@PATH,7,4364.599,5757.606,80.218,0,0,1,0,100,0), -- 20:26:35
  212. (@PATH,8,4418.135,5826.952,70.059,0,0,1,0,100,0), -- 20:26:30
  213. (@PATH,9,4456.091,5874.284,64.093,0,0,1,0,100,0); -- 20:26:22
  214.  
  215. SET @NPC := @CGUID+47;
  216. SET @PATH := @NPC * 10;
  217. UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4408.679,`position_y`=5920.878,`position_z`=55.669 WHERE `guid`=@NPC;
  218. DELETE FROM `creature_addon` WHERE `guid`=@NPC;
  219. INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, '');
  220. DELETE FROM `waypoint_data` WHERE `id`=@PATH;
  221. INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
  222. (@PATH,1,4408.679,5920.878,55.669,0,0,1,0,100,0), -- 20:26:22
  223. (@PATH,2,4453.867,5900.081,59.354,0,0,1,0,100,0), -- 20:26:22
  224. (@PATH,3,4456.091,5874.284,64.093,0,0,1,0,100,0), -- 20:26:22
  225. (@PATH,4,4418.135,5826.952,70.059,0,0,1,0,100,0), -- 20:26:30
  226. (@PATH,5,4364.599,5757.606,80.218,0,0,1,0,100,0), -- 20:26:35
  227. (@PATH,6,4312.593,5704.205,90.690,0,0,1,0,100,0), -- 20:26:45
  228. (@PATH,7,4309.625,5638.164,94.449,0,0,1,0,100,0), -- 20:26:45
  229. (@PATH,8,4312.593,5704.205,90.690,0,0,1,0,100,0), -- 20:26:45
  230. (@PATH,9,4364.599,5757.606,80.218,0,0,1,0,100,0), -- 20:26:35
  231. (@PATH,10,4418.135,5826.952,70.059,0,0,1,0,100,0), -- 20:26:30
  232. (@PATH,11,4456.091,5874.284,64.093,0,0,1,0,100,0), -- 20:26:22
  233. (@PATH,12,4453.867,5900.081,59.354,0,0,1,0,100,0), -- 20:26:22
  234. (@PATH,13,4408.679,5920.878,55.669,0,0,1,0,100,0); -- 20:26:22
  235.  
  236. SET @NPC := @CGUID+48;
  237. SET @PATH := @NPC * 10;
  238. UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4325.170,`position_y`=5855.809,`position_z`=57.569 WHERE `guid`=@NPC;
  239. DELETE FROM `creature_addon` WHERE `guid`=@NPC;
  240. INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, '');
  241. DELETE FROM `waypoint_data` WHERE `id`=@PATH;
  242. INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
  243. (@PATH,1,4325.170,5855.809,57.569,0,0,1,0,100,0), -- 20:26:22
  244. (@PATH,2,4331.969,5789.342,70.842,0,0,1,0,100,0), -- 20:26:30
  245. (@PATH,3,4340.155,5758.681,79.466,0,0,1,0,100,0), -- 20:26:35
  246. (@PATH,4,4312.593,5704.205,90.690,0,0,1,0,100,0), -- 20:26:45
  247. (@PATH,5,4309.625,5638.164,94.449,0,0,1,0,100,0), -- 20:26:45
  248. (@PATH,6,4312.593,5704.205,90.690,0,0,1,0,100,0), -- 20:26:45
  249. (@PATH,7,4340.155,5758.681,79.466,0,0,1,0,100,0), -- 20:26:35
  250. (@PATH,8,4331.969,5789.342,70.842,0,0,1,0,100,0), -- 20:26:30
  251. (@PATH,9,4325.170,5855.809,57.569,0,0,1,0,100,0); -- 20:26:22
  252.  
  253.  
  254. SET @NPC := @CGUID+49;
  255. SET @PATH := @NPC * 10;
  256. UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4370.834,`position_y`=5889.521,`position_z`=55.853 WHERE `guid`=@NPC;
  257. DELETE FROM `creature_addon` WHERE `guid`=@NPC;
  258. INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, '');
  259. DELETE FROM `waypoint_data` WHERE `id`=@PATH;
  260. INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
  261. (@PATH,1,4370.834,5889.521,55.853,0,0,1,0,100,0), -- 20:26:22
  262. (@PATH,2,4325.170,5855.809,57.569,0,0,1,0,100,0), -- 20:26:22
  263. (@PATH,3,4331.969,5789.342,70.842,0,0,1,0,100,0), -- 20:26:30
  264. (@PATH,4,4340.155,5758.681,79.466,0,0,1,0,100,0), -- 20:26:35
  265. (@PATH,5,4312.593,5704.205,90.690,0,0,1,0,100,0), -- 20:26:45
  266. (@PATH,6,4309.625,5638.164,94.449,0,0,1,0,100,0), -- 20:26:45
  267. (@PATH,7,4312.593,5704.205,90.690,0,0,1,0,100,0), -- 20:26:45
  268. (@PATH,8,4340.155,5758.681,79.466,0,0,1,0,100,0), -- 20:26:35
  269. (@PATH,9,4331.969,5789.342,70.842,0,0,1,0,100,0), -- 20:26:30
  270. (@PATH,10,4325.170,5855.809,57.569,0,0,1,0,100,0); -- 20:26:22
  271.  
  272.  
  273. SET @NPC := @CGUID+34;
  274. SET @PATH := @NPC * 10;
  275. UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4400.289,`position_y`=5853.771,`position_z`=64.700 WHERE `guid`=@NPC;
  276. DELETE FROM `creature_addon` WHERE `guid`=@NPC;
  277. INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, '');
  278. DELETE FROM `waypoint_data` WHERE `id`=@PATH;
  279. INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
  280. (@PATH,1,4400.289,5853.771,64.700,0,0,1,0,100,0), -- 20:26:22
  281. (@PATH,2,4406.379,5794.868,75.189,0,0,1,0,100,0), -- 20:26:30
  282. (@PATH,3,4364.599,5757.606,80.218,0,0,1,0,100,0), -- 20:26:35
  283. (@PATH,4,4312.593,5704.205,90.690,0,0,1,0,100,0), -- 20:26:45
  284. (@PATH,5,4309.625,5638.164,94.449,0,0,1,0,100,0), -- 20:26:45
  285. (@PATH,6,4312.593,5704.205,90.690,0,0,1,0,100,0), -- 20:26:45
  286. (@PATH,7,4364.599,5757.606,80.218,0,0,1,0,100,0), -- 20:26:35
  287. (@PATH,8,4406.379,5794.868,75.189,0,0,1,0,100,0), -- 20:26:30
  288. (@PATH,9,4400.289,5853.771,64.700,0,0,1,0,100,0); -- 20:26:22
  289.  
  290. SET @NPC := @CGUID+19;
  291. SET @PATH := @NPC * 10;
  292. UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4325.170,`position_y`=5855.809,`position_z`=57.569 WHERE `guid`=@NPC;
  293. DELETE FROM `creature_addon` WHERE `guid`=@NPC;
  294. INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, '');
  295. DELETE FROM `waypoint_data` WHERE `id`=@PATH;
  296. INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
  297. (@PATH,1,4325.170,5855.809,57.569,0,0,1,0,100,0), -- 20:26:22
  298. (@PATH,2,4301.863,5794.378,67.805,0,0,1,0,100,0), -- 20:26:30
  299. (@PATH,3,4340.155,5758.681,79.466,0,0,1,0,100,0), -- 20:26:35
  300. (@PATH,4,4312.593,5704.205,90.690,0,0,1,0,100,0), -- 20:26:45
  301. (@PATH,5,4309.625,5638.164,94.449,0,0,1,0,100,0), -- 20:26:45
  302. (@PATH,6,4312.593,5704.205,90.690,0,0,1,0,100,0), -- 20:26:45
  303. (@PATH,7,4340.155,5758.681,79.466,0,0,1,0,100,0), -- 20:26:35
  304. (@PATH,8,4301.863,5794.378,67.805,0,0,1,0,100,0), -- 20:26:30
  305. (@PATH,9,4325.170,5855.809,57.569,0,0,1,0,100,0); -- 20:26:22
  306.  
  307. -- fire eles paths
  308.  
  309. SET @NPC := @CGUID+50;
  310. SET @PATH := @NPC * 10;
  311. UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4309.625,`position_y`=5638.164,`position_z`=94.449 WHERE `guid`=@NPC;
  312. DELETE FROM `creature_addon` WHERE `guid`=@NPC;
  313. INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, '');
  314. DELETE FROM `waypoint_data` WHERE `id`=@PATH;
  315. INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
  316. (@PATH,1,4309.625,5638.164,94.449,0,0,1,0,100,0), -- 20:26:45
  317. (@PATH,2,4312.593,5704.205,90.690,0,0,1,0,100,0), -- 20:26:45
  318. (@PATH,3,4364.599,5757.606,80.218,0,0,1,0,100,0), -- 20:26:35
  319. (@PATH,4,4418.135,5826.952,70.059,0,0,1,0,100,0), -- 20:26:30
  320. (@PATH,5,4456.091,5874.284,64.093,0,0,1,0,100,0), -- 20:26:22
  321. (@PATH,6,4453.867,5900.081,59.354,0,0,1,0,100,0), -- 20:26:22
  322. (@PATH,7,4408.679,5920.878,55.669,0,0,1,0,100,0), -- 20:26:22
  323. (@PATH,8,4453.867,5900.081,59.354,0,0,1,0,100,0), -- 20:26:22
  324. (@PATH,9,4456.091,5874.284,64.093,0,0,1,0,100,0), -- 20:26:22
  325. (@PATH,10,4418.135,5826.952,70.059,0,0,1,0,100,0), -- 20:26:30
  326. (@PATH,11,4364.599,5757.606,80.218,0,0,1,0,100,0), -- 20:26:35
  327. (@PATH,12,4312.593,5704.205,90.690,0,0,1,0,100,0), -- 20:26:45
  328. (@PATH,13,4309.625,5638.164,94.449,0,0,1,0,100,0); -- 20:26:45
  329.  
  330.  
  331. SET @NPC := @CGUID+51;
  332. SET @PATH := @NPC * 10;
  333. UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4347.967,`position_y`=5730.564,`position_z`=83.739 WHERE `guid`=@NPC;
  334. DELETE FROM `creature_addon` WHERE `guid`=@NPC;
  335. INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, '');
  336. DELETE FROM `waypoint_data` WHERE `id`=@PATH;
  337. INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
  338. (@PATH,1,4347.967,5730.564,83.739,0,0,1,0,100,0), -- 20:26:35
  339. (@PATH,2,4364.599,5757.606,80.218,0,0,1,0,100,0), -- 20:26:35
  340. (@PATH,3,4418.135,5826.952,70.059,0,0,1,0,100,0), -- 20:26:30
  341. (@PATH,4,4456.091,5874.284,64.093,0,0,1,0,100,0), -- 20:26:22
  342. (@PATH,5,4453.867,5900.081,59.354,0,0,1,0,100,0), -- 20:26:22
  343. (@PATH,6,4408.679,5920.878,55.669,0,0,1,0,100,0), -- 20:26:22
  344. (@PATH,7,4453.867,5900.081,59.354,0,0,1,0,100,0), -- 20:26:22
  345. (@PATH,8,4456.091,5874.284,64.093,0,0,1,0,100,0), -- 20:26:22
  346. (@PATH,9,4418.135,5826.952,70.059,0,0,1,0,100,0), -- 20:26:30
  347. (@PATH,10,4364.599,5757.606,80.218,0,0,1,0,100,0), -- 20:26:35
  348. (@PATH,11,4347.967,5730.564,83.739,0,0,1,0,100,0); -- 20:26:35
  349.  
  350.  
  351. SET @NPC := 102601;
  352. SET @PATH := @NPC * 10;
  353. UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4400.118,`position_y`=5793.260,`position_z`=75.037 WHERE `guid`=@NPC;
  354. DELETE FROM `creature_addon` WHERE `guid`=@NPC;
  355. INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, '');
  356. DELETE FROM `waypoint_data` WHERE `id`=@PATH;
  357. INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
  358. (@PATH,1,4400.118,5793.260,75.037,0,0,1,0,100,0), -- 20:26:35
  359. (@PATH,2,4400.289,5853.771,64.700,0,0,1,0,100,0), -- 20:26:22
  360. (@PATH,3,4456.091,5874.284,64.093,0,0,1,0,100,0), -- 20:26:22
  361. (@PATH,4,4453.867,5900.081,59.354,0,0,1,0,100,0), -- 20:26:22
  362. (@PATH,5,4391.264,5878.812,55.666,0,0,1,0,100,0), -- 20:26:22
  363. (@PATH,6,4356.525,5896.896,56.012,0,0,1,0,100,0), -- 20:26:22
  364. (@PATH,7,4391.264,5878.812,55.666,0,0,1,0,100,0), -- 20:26:22
  365. (@PATH,8,4453.867,5900.081,59.354,0,0,1,0,100,0), -- 20:26:22
  366. (@PATH,9,4456.091,5874.284,64.093,0,0,1,0,100,0), -- 20:26:22
  367. (@PATH,10,4400.289,5853.771,64.700,0,0,1,0,100,0), -- 20:26:22
  368. (@PATH,11,4400.118,5793.260,75.037,0,0,1,0,100,0); -- 20:26:35
  369.  
  370.  
  371. SET @NPC := @CGUID+52;
  372. SET @PATH := @NPC * 10;
  373. UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4309.625,`position_y`=5638.164,`position_z`=94.449 WHERE `guid`=@NPC;
  374. DELETE FROM `creature_addon` WHERE `guid`=@NPC;
  375. INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, '');
  376. DELETE FROM `waypoint_data` WHERE `id`=@PATH;
  377. INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
  378. (@PATH,1,4309.625,5638.164,94.449,0,0,1,0,100,0), -- 20:26:45
  379. (@PATH,2,4312.593,5704.205,90.690,0,0,1,0,100,0), -- 20:26:45
  380. (@PATH,3,4347.967,5730.564,83.739,0,0,1,0,100,0), -- 20:26:35
  381. (@PATH,4,4340.155,5758.681,79.466,0,0,1,0,100,0), -- 20:26:35
  382. (@PATH,5,4331.969,5789.342,70.842,0,0,1,0,100,0), -- 20:26:30
  383. (@PATH,6,4325.170,5855.809,57.569,0,0,1,0,100,0), -- 20:26:22
  384. (@PATH,7,4356.525,5896.896,56.012,0,0,1,0,100,0), -- 20:26:22
  385. (@PATH,8,4325.170,5855.809,57.569,0,0,1,0,100,0), -- 20:26:22
  386. (@PATH,9,4331.969,5789.342,70.842,0,0,1,0,100,0), -- 20:26:30
  387. (@PATH,10,4340.155,5758.681,79.466,0,0,1,0,100,0), -- 20:26:35
  388. (@PATH,11,4347.967,5730.564,83.739,0,0,1,0,100,0), -- 20:26:35
  389. (@PATH,12,4312.593,5704.205,90.690,0,0,1,0,100,0), -- 20:26:45
  390. (@PATH,13,4309.625,5638.164,94.449,0,0,1,0,100,0); -- 20:26:45
  391.  
  392.  
  393.  
  394. SET @NPC := @CGUID+53;
  395. SET @PATH := @NPC * 10;
  396. UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4347.967,`position_y`=5730.564,`position_z`=83.739 WHERE `guid`=@NPC;
  397. DELETE FROM `creature_addon` WHERE `guid`=@NPC;
  398. INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, '');
  399. DELETE FROM `waypoint_data` WHERE `id`=@PATH;
  400. INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
  401. (@PATH,1,4347.967,5730.564,83.739,0,0,1,0,100,0), -- 20:26:35
  402. (@PATH,2,4340.155,5758.681,79.466,0,0,1,0,100,0), -- 20:26:35
  403. (@PATH,3,4331.969,5789.342,70.842,0,0,1,0,100,0), -- 20:26:30
  404. (@PATH,4,4325.170,5855.809,57.569,0,0,1,0,100,0), -- 20:26:22
  405. (@PATH,5,4356.525,5896.896,56.012,0,0,1,0,100,0), -- 20:26:22
  406. (@PATH,6,4325.170,5855.809,57.569,0,0,1,0,100,0), -- 20:26:22
  407. (@PATH,7,4331.969,5789.342,70.842,0,0,1,0,100,0), -- 20:26:30
  408. (@PATH,8,4340.155,5758.681,79.466,0,0,1,0,100,0), -- 20:26:35
  409. (@PATH,9,4347.967,5730.564,83.739,0,0,1,0,100,0); -- 20:26:35
  410.  
  411.  
  412. SET @NPC := 102600;
  413. SET @PATH := @NPC * 10;
  414. UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4319.603,`position_y`=5784.604,`position_z`=69.714 WHERE `guid`=@NPC;
  415. DELETE FROM `creature_addon` WHERE `guid`=@NPC;
  416. INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, '');
  417. DELETE FROM `waypoint_data` WHERE `id`=@PATH;
  418. INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
  419. (@PATH,1,4319.603,5784.604,69.714,0,0,1,0,100,0), -- 20:26:35
  420. (@PATH,2,4325.170,5855.809,57.569,0,0,1,0,100,0), -- 20:26:22
  421. (@PATH,3,4356.525,5896.896,56.012,0,0,1,0,100,0), -- 20:26:22
  422. (@PATH,4,4325.170,5855.809,57.569,0,0,1,0,100,0), -- 20:26:22
  423. (@PATH,5,4319.603,5784.604,69.714,0,0,1,0,100,0);
  424.  
  425. -- Boiling Spirit SAI
  426. SET @ENTRY := 25419;
  427. UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
  428. DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0;
  429. INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES
  430. (@ENTRY,0,0,0,0,0,100,0,3000,5000,15000,20000,11,50206,0,0,0,0,0,2,0,0,0,0,0,0,0,"Boiling Spirit - In Combat - Cast 'Scalding Steam'");
  431.  
  432. -- Raging Boiler SAI
  433. SET @ENTRY := 25417;
  434. UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
  435. DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0;
  436. INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES
  437. (@ENTRY,0,0,0,0,0,100,0,3000,5000,15000,20000,11,50207,0,0,0,0,0,2,0,0,0,0,0,0,0,"Raging Boiler - In Combat - Cast 'Boiling Blood'");
  438.  
  439. UPDATE `creature_template` SET `dmg_multiplier` = 1.2 WHERE `entry` = 25417;
  440.  
  441. -- Enraged Tempest SAI
  442. SET @ENTRY := 25415;
  443. UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
  444. DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0;
  445. INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES
  446. (@ENTRY,0,0,0,2,0,100,0,0,50,120000,120000,11,50420,0,0,0,0,0,1,0,0,0,0,0,0,0,"Enraged Tempest - Between 0-50% Health - Cast 'Enrage'"),
  447. (@ENTRY,0,1,0,6,0,100,0,0,0,0,0,11,50215,0,0,0,0,0,1,0,0,0,0,0,0,0,"Enraged Tempest - On Just Died - Cast 'Zephyr'");
  448.  
  449. -- Raging Boiler Crystallized Fire
  450. DELETE FROM `creature_loot_template` WHERE (entry = 25417) AND (item IN (37702));
  451. INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
  452. (25417, 37702, 19, 1, 0, 1, 2);
  453.  
  454. -- Boiling Spirit Crystallized Water
  455. DELETE FROM `creature_loot_template` WHERE (entry = 25419) AND (item IN (37705));
  456. INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
  457. (25419, 37705, 20, 1, 0, 1, 2);
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
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!