API tools faq
paste
STARRHELD

Untitled

STARRHELD
Mar 18th, 2017
133
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 28.47 KB | None | 0 0
raw download clone embed print report
  1. SET @CGUID:= 5005809;
  2. DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+6;
  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, 25844, 571, 1, 1, 0, 0, 3853.578, 5551.84, 41.41978, 1.832596, 300, 10, 0, 1, 0, 1, 0, 0, 0),
  5. (@CGUID+1, 25844, 571, 1, 1, 0, 0, 3853.578, 5551.84, 41.41978, 1.832596, 300, 10, 0, 1, 0, 1, 0, 0, 0),
  6. (@CGUID+2, 25844, 571, 1, 1, 0, 0, 3853.578, 5551.84, 41.41978, 1.832596, 300, 10, 0, 1, 0, 1, 0, 0, 0),
  7. (@CGUID+3, 25844, 571, 1, 1, 0, 0, 3853.578, 5551.84, 41.41978, 1.832596, 300, 10, 0, 1, 0, 1, 0, 0, 0),
  8. (@CGUID+4, 25839, 571, 1, 1, 0, 0, 2476.456, 5057.068, 3.344, 1.832596, 300, 10, 0, 1, 0, 1, 0, 0, 0),
  9. (@CGUID+5, 25839, 571, 1, 1, 0, 0, 2426.133, 5082.965, 2.476, 1.832596, 300, 10, 0, 1, 0, 1, 0, 0, 0),
  10. (@CGUID+6, 25839, 571, 1, 1, 0, 0, 2424.964, 5065.363, 2.90739, 5.217191, 300, 0, 0, 1, 0, 0, 0, 0, 0);
  11.  
  12.  
  13. DELETE FROM `creature_addon` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+6;
  14. DELETE FROM `creature_addon` WHERE `guid` IN (118361, 132986, 132985, 132984, 118536, 57076);
  15. INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES
  16. (@CGUID+0, 0, 0, 0, 1, 0, ''),
  17. (118536, 0, 0, 0, 1, 69, ''),
  18. (57076, 0, 0, 0, 1, 69, ''),
  19. (118361, 0, 0, 1, 257, 0, ''), -- 25838
  20. (132986, 0, 0, 1, 257, 0, ''), -- 25838
  21. (132985, 0, 0, 1, 257, 0, ''), -- 25838
  22. (132984, 0, 0, 1, 257, 0, ''), -- 25838
  23. (@CGUID+1, 0, 0, 0, 1, 0, ''),
  24. (@CGUID+2, 0, 0, 0, 1, 0, ''),
  25. (@CGUID+3, 0, 0, 0, 1, 0, ''),
  26. (@CGUID+4, 0, 0, 0, 1, 0, ''),
  27. (@CGUID+5, 0, 0, 0, 1, 0, ''),
  28. (@CGUID+6, 0, 0, 0, 1, 69, '');
  29.  
  30. SET @oguid= 4000146;
  31. DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+22;
  32. INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES
  33. (@OGUID+0, 188017, 571, 1, 1, 2781.51, 5183.986, 30.57199, 2.076939, 0, 0, 0.8616285, 0.5075394, 120, 255, 1, 23420), -- 188017 (Area: -1)
  34. (@OGUID+1, 188015, 571, 1, 1, 2753.451, 5168.428, 29.30249, 1.308995, 0, 0, 0.6087608, 0.7933538, 120, 255, 1, 23420), -- 188015 (Area: -1)
  35. (@OGUID+2, 188015, 571, 1, 1, 2757.342, 5158.588, 29.13144, 3.787367, 0, 0, -0.9483232, 0.3173059, 120, 255, 1, 23420), -- 188015 (Area: -1)
  36. (@OGUID+3, 188017, 571, 1, 1, 2767.917, 5151.662, 29.09887, 2.82743, 0, 0, 0.9876881, 0.1564362, 120, 255, 1, 23420), -- 188017 (Area: -1)
  37. (@OGUID+4, 188018, 571, 1, 1, 2694.420, 5227.598, 30.5958, 2.460913, 0, 0, 0.9426413, 0.3338076, 120, 255, 1, 23420), -- 188018 (Area: 4115)
  38. (@OGUID+5, 188017, 571, 1, 1, 2665.056, 5095.626, 22.75492, 3.403396, 0, 0, -0.9914446, 0.1305283, 120, 255, 1, 23420), -- 188017 (Area: 4043)
  39. (@OGUID+6, 188018, 571, 1, 1, 2510.621, 5131.132, 9.380404, 1.151916, 0, 0, 0.5446386, 0.8386708, 120, 255, 1, 23420), -- 188018 (Area: 4115)
  40. (@OGUID+7, 188018, 571, 1, 1, 2556.75, 5047.084, 14.96165, 0.5585039, 0, 0, 0.2756367, 0.9612619, 120, 255, 1, 23420), -- 188018 (Area: 4115)
  41. (@OGUID+8, 188015, 571, 1, 1, 2541.933, 5042.151, 7.475825, 0.9773831, 0, 0, 0.469471, 0.8829479, 120, 255, 1, 23420), -- 188015 (Area: 4115)
  42. (@OGUID+9, 188016, 571, 1, 1, 2635.303, 5176.041, 20.30744, 0.4014249, 0, 0, 0.1993675, 0.9799248, 120, 255, 1, 23420), -- 188016 (Area: 4115)
  43. (@OGUID+10, 188016, 571, 1, 1, 2482.468, 5121.74, 4.919883, 3.839725, 0, 0, -0.9396925, 0.3420205, 120, 255, 1, 23420), -- 188016 (Area: 4115)
  44. (@OGUID+11, 188015, 571, 1, 1, 2513.891, 5019.119, 1.120682, 0.1919852, 0, 0, 0.09584522, 0.9953963, 120, 255, 1, 23420), -- 188015 (Area: 4115)
  45. (@OGUID+12, 188017, 571, 1, 1, 2532.548, 5102.552, 9.438492, 1.256636, 0, 0, 0.5877848, 0.8090174, 120, 255, 1, 23420), -- 188017 (Area: 4115)
  46. (@OGUID+13, 188015, 571, 1, 1, 2654.122, 5106.743, 18.75142, 4.956738, 0, 0, -0.6156607, 0.7880114, 120, 255, 1, 23420), -- 188015 (Area: 4115)
  47. (@OGUID+14, 188018, 571, 1, 1, 2436.552, 5049.992, 2.075295, 0.8377575, 0, 0, 0.4067364, 0.9135455, 120, 255, 1, 23420), -- 188018 (Area: 4115)
  48. (@OGUID+15, 188018, 571, 1, 1, 2434.903, 5064.571, 4.230853, 1.099556, 0, 0, 0.5224981, 0.8526405, 120, 255, 1, 23420), -- 188018 (Area: 4115)
  49. (@OGUID+16, 188017, 571, 1, 1, 2419.396, 5057.665, 1.811486, 2.670348, 0, 0, 0.9723692, 0.2334484, 120, 255, 1, 23420), -- 188017 (Area: 4115)
  50. (@OGUID+17, 188018, 571, 1, 1, 2435.465, 5015.647, 0.215764, 5.567601, 0, 0, -0.3502073, 0.9366722, 120, 255, 1, 23420), -- 188018 (Area: 4115)
  51. (@OGUID+18, 188018, 571, 1, 1, 2656.003, 5168.612, 10.064, 5.567601, 0, 0, -0.3502073, 0.9366722, 120, 255, 1, 23420), -- 188018 (Area: 4115)
  52. (@OGUID+19, 188017, 571, 1, 1, 2756.436, 5185.388, 29.846, 5.567601, 0, 0, -0.3502073, 0.9366722, 120, 255, 1, 23420), -- 188018 (Area: 4115)
  53. (@OGUID+20, 188017, 571, 1, 1, 2527.247, 5024.408, 4.734, 5.567601, 0, 0, -0.3502073, 0.9366722, 120, 255, 1, 23420), -- 188018 (Area: 4115)
  54. (@OGUID+21, 188015, 571, 1, 1, 2497.409, 5127.318, 6.545, 4.956738, 0, 0, -0.6156607, 0.7880114, 120, 255, 1, 23420), -- 188015 (Area: 4115)
  55. (@OGUID+22, 188015, 571, 1, 1, 2671.039, 5122.903, 19.808, 4.956738, 0, 0, -0.6156607, 0.7880114, 120, 255, 1, 23420); -- 188015 (Area: 4115)
  56.  
  57. --
  58. UPDATE `creature_template` SET `lootid` = 25843 , `pickpocketloot` = 25843 WHERE `entry` = 25844;
  59. --
  60.  
  61.  
  62. DELETE FROM `creature` WHERE `guid`  IN (85248, 85247);
  63. DELETE FROM `creature_addon` WHERE `guid` IN (85248, 85247);
  64. UPDATE `creature_template` SET `InhabitType` = 4 WHERE `entry` IN (25819, 25838);
  65. UPDATE `creature_template` SET `speed_walk` = 3.2 , `speed_run` = 3.42 WHERE `entry` = 25838;
  66. --
  67. UPDATE `creature` SET `spawndist` = 0 , `MovementType` = 0 WHERE `guid` IN (118361, 132986, 132985, 132984);
  68. --
  69. UPDATE `creature` SET `position_x` = 2754.554 , `position_y` = 5169.847 , `position_z` = 29.57914 , `orientation` = 4.18879 WHERE `guid` = 118536;
  70. UPDATE `creature` SET `position_x` = 2726.364 , `position_y` = 5150.889 , `position_z` = 30.453 , `spawndist` = 10 WHERE `guid` = 118522;
  71. UPDATE `creature` SET  `spawndist` = 10 , `MovementType` = 1 WHERE `guid` IN (118532, 118535, 118525, 118527, 57075);
  72. UPDATE `creature` SET `position_x` = 2692.392 , `position_y` = 5202.070 , `position_z` = 25.489 , `spawndist` = 10 WHERE `guid` = 118524;
  73. UPDATE `creature` SET `position_x` = 2686.377 , `position_y` = 5174.586 , `position_z` = 19.696 , `spawndist` = 10 WHERE `guid` = 118523;
  74. UPDATE `creature` SET `position_x` = 2674.841 , `position_y` = 5160.432 , `position_z` = 17.059 , `spawndist` = 10 WHERE `guid` = 118529;
  75. UPDATE `creature` SET `position_x` = 2620.165 , `position_y` = 5123.277 , `position_z` = 9.9487 , `spawndist` = 10 WHERE `guid` = 118531;
  76. UPDATE `creature` SET `position_x` = 2580.645 , `position_y` = 5084.428 , `position_z` = 10.180 , `spawndist` = 10 WHERE `guid` = 118528;
  77. UPDATE `creature` SET `position_x` = 2549.910 , `position_y` = 5082.313 , `position_z` = 8.224 , `spawndist` = 10 WHERE `guid` = 118530;
  78. UPDATE `creature` SET `position_x` = 2519.092 , `position_y` = 5087.849 , `position_z` =  6.237 , `spawndist` = 10 , `MovementType` = 1 WHERE `guid` = 57074;
  79. UPDATE `creature` SET `position_x` = 2520.827 , `position_y` = 5053.153 , `position_z` = 5.405 , `spawndist` = 10 WHERE `guid` = 118526;
  80. UPDATE `creature` SET `position_x` = 2502.525 , `position_y` = 5114.396 , `position_z` = 6.096 , `spawndist` = 10 WHERE `guid` = 118534;
  81. UPDATE `creature` SET `position_x` = 2484.534 , `position_y` = 5094.375 , `position_z` =  4.804 , `spawndist` = 10 , `MovementType` = 1 WHERE `guid` = 57073;
  82. UPDATE `creature` SET `position_x` = 2456.032 , `position_y` = 5084.581 , `position_z` =  3.828 , `spawndist` = 10 , `MovementType` = 1 WHERE `guid` = 57077;
  83.  
  84.  
  85. DELETE FROM `pool_template` WHERE `entry` = 202486;
  86. INSERT INTO `pool_template` (`entry`, `max_limit`, `description`) VALUES
  87. (202486,15,'Shipment of Animal Parts (188015, 188016, 188017, 188018)');
  88.  
  89. DELETE FROM `pool_gameobject` WHERE `pool_entry` = 202486;
  90. INSERT INTO `pool_gameobject` (`guid`, `pool_entry`, `chance`, `description`) VALUES
  91. (59010,202486,100,''),
  92. (59011,202486,100,''),
  93. (59012,202486,100,''),
  94. (59013,202486,100,''),
  95. (59014,202486,100,''),
  96. (59022,202486,100,''),
  97. (59030,202486,100,''),
  98. (59031,202486,100,''),
  99. (59032,202486,100,''),
  100. (59033,202486,100,''),
  101. (59044,202486,100,''),
  102. (@OGUID+0,202486,100,''),
  103. (@OGUID+1,202486,100,''),
  104. (@OGUID+2,202486,100,''),
  105. (@OGUID+3,202486,100,''),
  106. (@OGUID+4,202486,100,''),
  107. (@OGUID+5,202486,100,''),
  108. (@OGUID+6,202486,100,''),
  109. (@OGUID+7,202486,100,''),
  110. (@OGUID+8,202486,100,''),
  111. (@OGUID+9,202486,100,''),
  112. (@OGUID+10,202486,100,''),
  113. (@OGUID+11,202486,100,''),
  114. (@OGUID+12,202486,100,''),
  115. (@OGUID+13,202486,100,''),
  116. (@OGUID+14,202486,100,''),
  117. (@OGUID+15,202486,100,''),
  118. (@OGUID+16,202486,100,''),
  119. (@OGUID+17,202486,100,''),
  120. (@OGUID+18,202486,100,''),
  121. (@OGUID+19,202486,100,''),
  122. (@OGUID+20,202486,100,''),
  123. (@OGUID+21,202486,100,''),
  124. (@OGUID+22,202486,100,'');
  125.  
  126. -- Pathing for Northsea Thug Entry: 25843 'TDB FORMAT'
  127. SET @NPC := @CGUID+0;
  128. SET @PATH := @NPC * 10;
  129. UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=2473.529,`position_y`=5107.861,`position_z`=4.367961 WHERE `guid`=@NPC;
  130. DELETE FROM `creature_addon` WHERE `guid`=@NPC;
  131. INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, '');
  132. DELETE FROM `waypoint_data` WHERE `id`=@PATH;
  133. INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
  134. (@PATH,1,2473.529,5107.861,4.367961,0,0,0,0,100,0), -- 18:48:49
  135. (@PATH,2,2470.558,5107.391,4.242625,0,0,0,0,100,0), -- 18:49:06
  136. (@PATH,3,2461.708,5106.034,3.824092,0,0,0,0,100,0), -- 18:49:14
  137. (@PATH,4,2418.503,5094.169,1.535252,0,0,0,0,100,0), -- 18:49:30
  138. (@PATH,5,2409.479,5088.341,1.013388,0,0,0,0,100,0), -- 18:49:40
  139. (@PATH,6,2404.822,5062.293,0.6820298,0,0,0,0,100,0), -- 18:49:52
  140. (@PATH,7,2403.609,5055.485,0.6492624,0,0,0,0,100,0), -- 18:49:58
  141. (@PATH,8,2409.461,5088.335,0.8073668,0,0,0,0,100,0), -- 18:50:01
  142. (@PATH,9,2427.076,5099.731,3.010504,0,0,0,0,100,0), -- 18:50:13
  143. (@PATH,10,2473.415,5107.889,4.57381,0,0,0,0,100,0); -- 18:50:23
  144.  
  145. -- Pathing for Northsea Thug Entry: 25843 'TDB FORMAT'
  146. SET @NPC := @CGUID+1;
  147. SET @PATH := @NPC * 10;
  148. UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=2614.99,`position_y`=5136.841,`position_z`=8.052708 WHERE `guid`=@NPC;
  149. DELETE FROM `creature_addon` WHERE `guid`=@NPC;
  150. INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, '');
  151. DELETE FROM `waypoint_data` WHERE `id`=@PATH;
  152. INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
  153. (@PATH,1,2614.99,5136.841,8.052708,0,0,0,0,100,0), -- 18:45:10
  154. (@PATH,2,2566.325,5109.183,9.590598,0,0,0,0,100,0), -- 18:45:42
  155. (@PATH,3,2558.461,5098.467,8.841568,0,0,0,0,100,0), -- 18:46:11
  156. (@PATH,4,2562.211,5103.217,9.341568,0,0,0,0,100,0), -- 18:46:16
  157. (@PATH,5,2574.785,5115.972,8.749392,0,0,0,0,100,0), -- 18:46:20
  158. (@PATH,6,2583.505,5122.99,8.470507,0,0,0,0,100,0), -- 18:46:26
  159. (@PATH,7,2615.165,5137.012,8.323627,0,0,0,0,100,0); -- 18:46:40
  160.  
  161. -- Pathing for Northsea Thug Entry: 25843 'TDB FORMAT'
  162. SET @NPC := 118780;
  163. SET @PATH := @NPC * 10;
  164. UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=2534.991,`position_y`=5060.937,`position_z`=6.386566 WHERE `guid`=@NPC;
  165. DELETE FROM `creature_addon` WHERE `guid`=@NPC;
  166. INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, '');
  167. DELETE FROM `waypoint_data` WHERE `id`=@PATH;
  168. INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
  169. (@PATH,1,2534.991,5060.937,6.386566,0,0,0,0,100,0), -- 18:46:25
  170. (@PATH,2,2564.617,5060.777,8.522945,0,0,0,0,100,0), -- 18:47:14
  171. (@PATH,3,2537.827,5060.784,6.933267,0,0,0,0,100,0), -- 18:47:23
  172. (@PATH,4,2511.885,5032.508,1.875846,0,0,0,0,100,0), -- 18:47:31
  173. (@PATH,5,2534.991,5060.937,6.386566,0,0,0,0,100,0); -- 18:48:08
  174.  
  175. -- Pathing for Northsea Thug Entry: 25843 'TDB FORMAT'
  176. SET @NPC := @CGUID+2;
  177. SET @PATH := @NPC * 10;
  178. UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=2726.846,`position_y`=5157.48,`position_z`=29.20237 WHERE `guid`=@NPC;
  179. DELETE FROM `creature_addon` WHERE `guid`=@NPC;
  180. INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, '');
  181. DELETE FROM `waypoint_data` WHERE `id`=@PATH;
  182. INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
  183. (@PATH,1,2726.846,5157.48,29.20237,0,0,0,0,100,0), -- 18:43:32
  184. (@PATH,2,2725.999,5169.445,28.43452,0,0,0,0,100,0), -- 18:43:40
  185. (@PATH,3,2745.213,5188.146,29.34911,0,0,0,0,100,0), -- 18:43:48
  186. (@PATH,4,2764.861,5186.779,31.12695,0,0,0,0,100,0), -- 18:43:57
  187. (@PATH,5,2779.527,5184.15,31.1647,0,0,0,0,100,0), -- 18:44:05
  188. (@PATH,6,2770.934,5183.904,31.31997,0,0,0,0,100,0), -- 18:44:16
  189. (@PATH,7,2759.232,5188.905,30.49676,0,0,0,0,100,0), -- 18:44:20
  190. (@PATH,8,2738.329,5184.535,28.90192,0,0,0,0,100,0), -- 18:44:27
  191. (@PATH,9,2724.193,5166.338,28.74817,0,0,0,0,100,0), -- 18:44:36
  192. (@PATH,10,2730.041,5152.918,29.59881,0,0,0,0,100,0), -- 18:44:44
  193. (@PATH,11,2735.207,5145.916,29.63936,0,0,0,0,100,0), -- 18:45:02
  194. (@PATH,12,2752.462,5144.418,28.936,0,3000,0,0,100,0), -- 18:45:05
  195. (@PATH,13,2735.207,5145.916,29.63936,0,0,0,0,100,0), -- 18:45:13
  196. (@PATH,14,2726.846,5157.48,29.20237,0,0,0,0,100,0); -- 18:43:32
  197.  
  198. -- Pathing for Northsea Thug Entry: 25843 'TDB FORMAT'
  199. SET @NPC := @CGUID+3;
  200. SET @PATH := @NPC * 10;
  201. UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=2458.612,`position_y`=5014.241,`position_z`=0.8586578 WHERE `guid`=@NPC;
  202. DELETE FROM `creature_addon` WHERE `guid`=@NPC;
  203. INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, '');
  204. DELETE FROM `waypoint_data` WHERE `id`=@PATH;
  205. INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
  206. (@PATH,1,2458.612,5014.241,0.8586578,0,0,0,0,100,0), -- 19:20:53
  207. (@PATH,2,2442.1,5020.078,0.8570347,0,0,0,0,100,0), -- 19:21:03
  208. (@PATH,3,2417.579,5041.7495,0.485,0,0,0,0,100,0), -- 19:21:18
  209. (@PATH,4,2458.612,5014.241,0.8586578,0,0,0,0,100,0), -- 19:21:38
  210. (@PATH,5,2508.649,5031.743,0.812,0,0,0,0,100,0), -- 19:21:43
  211. (@PATH,6,2458.612,5014.241,0.8586578,0,0,0,0,100,0); -- 19:21:38
  212.  
  213.  
  214. SET @NPC := 132984;
  215. SET @PATH := @NPC * 10;
  216. UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3199.490,`position_y`=5262.276,`position_z`=62.012 WHERE `guid`=@NPC;
  217. DELETE FROM `creature_addon` WHERE `guid`=@NPC;
  218. INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, '');
  219. DELETE FROM `waypoint_data` WHERE `id`=@PATH;
  220. INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
  221. (@PATH,1,3199.490,5262.276,62.012,0,0,0,0,100,0), -- 19:20:53
  222. (@PATH,2,3221.768,5267.935,62.012,0,0,0,0,100,0), -- 19:21:03
  223. (@PATH,3,3219.966,5291.054,62.012,0,0,0,0,100,0), -- 19:21:18
  224. (@PATH,4,3203.099,5300.212,62.012,0,0,0,0,100,0), -- 19:21:38
  225. (@PATH,5,3191.584,5293.197,66.725,0,0,0,0,100,0), -- 19:21:43
  226. (@PATH,6,3191.346,5277.161,62.012,0,0,0,0,100,0); -- 19:21:38
  227.  
  228.  
  229. -- Pathing for Killinger the Den Watcher Entry: 25812 'TDB FORMAT'
  230. SET @NPC := 25812;
  231. SET @PATH := @NPC * 10;
  232. UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3210.462,`position_y`=5293.251,`position_z`=47.92002 WHERE `guid`=@NPC;
  233. DELETE FROM `creature_addon` WHERE `guid`=@NPC;
  234. INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, '');
  235. DELETE FROM `waypoint_data` WHERE `id`=@PATH;
  236. INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
  237. (@PATH,1,3210.462,5293.251,47.92002,0,0,0,0,100,0), -- 19:39:45
  238. (@PATH,2,3203.892,5293.673,47.7849,0,0,0,0,100,0), -- 19:39:48
  239. (@PATH,3,3196.525,5286.239,48.10371,0,0,0,0,100,0), -- 19:39:51
  240. (@PATH,4,3195.811,5278.958,48.11278,0,0,0,0,100,0), -- 19:39:55
  241. (@PATH,5,3202.552,5291.977,47.459,0,0,0,0,100,0), -- 19:39:59
  242. (@PATH,6,3208.634,5268.921,47.66973,0,0,0,0,100,0), -- 19:40:02
  243. (@PATH,7,3218.311,5271.606,47.50952,0,0,0,0,100,0), -- 19:40:06
  244. (@PATH,8,3222.219,5274.076,47.30208,0,0,0,0,100,0), -- 19:40:08
  245. (@PATH,9,3220.476,5281.416,47.43275,0,0,0,0,100,0), -- 19:40:11
  246. (@PATH,10,3216.567,5289.09,47.87889,0,0,0,0,100,0), -- 19:40:14
  247. (@PATH,11,3210.462,5293.251,47.92002,0,0,0,0,100,0); -- 19:39:45
  248.  
  249. -- enforcer
  250. DELETE FROM `creature_text` WHERE `entry` IN (25808, 25809, 25819, 25812, 25811, 25810, 25838) AND `groupid` = 0;
  251. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES
  252. (25808,0,0,' Do you think us fools! You\'re covered in animal blood!',12,0,100,5,4000,0,0,0,''),
  253. (25808,0,1,' BUTCHER! DIE!',12,0,100,5,4000,0,0,0,''),
  254. (25808,0,2,' Calf killer! Murderer! You will pay for this!',12,0,100,5,4000,0,0,0,''),
  255. --
  256. (25809,0,0,' Do you think us fools! You\'re covered in animal blood!',12,0,100,5,4000,0,0,0,''),
  257. (25809,0,1,' BUTCHER! DIE!',12,0,100,5,4000,0,0,0,''),
  258. (25809,0,2,' Calf killer! Murderer! You will pay for this!',12,0,100,5,4000,0,0,0,''),
  259. --
  260. (25812,0,0,' Do you think us fools! You\'re covered in animal blood!',12,0,100,5,4000,0,0,0,''),
  261. (25812,0,1,' BUTCHER! DIE!',12,0,100,5,4000,0,0,0,''),
  262. (25812,0,2,' Calf killer! Murderer! You will pay for this!',12,0,100,5,4000,0,0,0,''),
  263. --
  264. (25811,0,0,' Do you think us fools! You\'re covered in animal blood!',12,0,100,5,4000,0,0,0,''),
  265. (25811,0,1,' BUTCHER! DIE!',12,0,100,5,4000,0,0,0,''),
  266. (25811,0,2,' Calf killer! Murderer! You will pay for this!',12,0,100,5,4000,0,0,0,''),
  267. --
  268. (25810,0,0,' Do you think us fools! You\'re covered in animal blood!',12,0,100,5,4000,0,0,0,''),
  269. (25810,0,1,' BUTCHER! DIE!',12,0,100,5,4000,0,0,0,''),
  270. (25810,0,2,' Calf killer! Murderer! You will pay for this!',12,0,100,5,4000,0,0,0,''),
  271. --
  272. (25838,0,0,' Do you think us fools! You\'re covered in animal blood!',12,0,100,5,4000,0,0,0,''),
  273. (25838,0,1,' BUTCHER! DIE!',12,0,100,5,4000,0,0,0,''),
  274. (25838,0,2,' Calf killer! Murderer! You will pay for this!',12,0,100,5,4000,0,0,0,''),
  275. --
  276. (25819,0,0,' Do you think us fools! You\'re covered in animal blood!',12,0,100,5,4000,0,0,0,''),
  277. (25819,0,1,' BUTCHER! DIE!',12,0,100,5,4000,0,0,0,''),
  278. (25819,0,2,' Calf killer! Murderer! You will pay for this!',12,0,100,5,4000,0,0,0,'');
  279. --
  280.  
  281. -- D.E.H.T.A. Enforcer SAI
  282. SET @ENTRY := 25808;
  283. UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
  284. DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0;
  285. 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
  286. (@ENTRY,0,0,0,4,0,100,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"D.E.H.T.A. Enforcer - On Aggro - Say Line 0"),
  287. (@ENTRY,0,1,0,10,0,100,0,1,20,0,0,49,2,0,0,0,0,0,25,20,1,0,0,0,0,0,"D.E.H.T.A. Enforcer - Within 1-20 Range Out of Combat LoS - Start Attacking");
  288.  
  289.  
  290. DELETE FROM `creature_formations` WHERE `leaderGUID`= 132974;
  291. INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES
  292. (132974,132974,0,0,2,0,0),
  293. (132974,132976,0,0,2,0,0);
  294.  
  295. -- D.E.H.T.A. Enforcer SAI
  296. SET @ENTRY := 25819;
  297. UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
  298. DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0;
  299. 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
  300. (@ENTRY,0,0,0,4,0,100,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"D.E.H.T.A. Enforcer - On Aggro - Say Line 0"),
  301. (@ENTRY,0,1,0,10,0,100,0,1,20,0,0,49,0,0,0,0,0,0,25,20,1,0,0,0,0,0,"D.E.H.T.A. Enforcer - Within 1-20 Range Out of Combat LoS - Start Attacking"),
  302. (@ENTRY,0,2,0,4,0,100,0,0,0,0,0,91,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"D.E.H.T.A. Enforcer - On Aggro - Remove Flag Standstate Sit Down"),
  303. (@ENTRY,0,3,0,25,0,100,0,0,0,0,0,90,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"D.E.H.T.A. Enforcer - On Reset - Set Flag Standstate Sit Down");
  304.  
  305. -- Arch Druid Lathorius SAI
  306. SET @ENTRY := 25809;
  307. UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
  308. DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0;
  309. 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
  310. (@ENTRY,0,0,0,4,0,100,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Arch Druid Lathorius - On Aggro - Say Line 0"),
  311. (@ENTRY,0,1,0,4,0,100,0,0,0,0,0,83,3,0,0,0,0,0,1,0,0,0,0,0,0,0,"Arch Druid Lathorius - On Aggro - Remove Npc Flags Gossip & Questgiver"),
  312. (@ENTRY,0,2,0,10,0,100,0,1,20,0,0,49,0,0,0,0,0,0,25,20,1,0,0,0,0,0,"Arch Druid Lathorius - Within 1-20 Range Out of Combat LoS - Start Attacking"),
  313. (@ENTRY,0,3,0,25,0,100,0,0,0,0,0,81,3,0,0,0,0,0,1,0,0,0,0,0,0,0,"Arch Druid Lathorius - On Reset - Set Npc Flags Gossip & Questgiver");
  314.  
  315. -- Zaza SAI
  316. SET @ENTRY := 25811;
  317. UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
  318. DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0;
  319. 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
  320. (@ENTRY,0,0,0,4,0,100,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Zaza - On Aggro - Say Line 0"),
  321. (@ENTRY,0,1,0,4,0,100,0,0,0,0,0,83,2,0,0,0,0,0,1,0,0,0,0,0,0,0,"Zaza - On Aggro - Remove Npc Flag Questgiver"),
  322. (@ENTRY,0,2,0,10,0,100,0,1,20,0,0,49,0,0,0,0,0,0,25,20,1,0,0,0,0,0,"Zaza - Within 1-20 Range Out of Combat LoS - Start Attacking"),
  323. (@ENTRY,0,3,0,25,0,100,0,0,0,0,0,81,2,0,0,0,0,0,1,0,0,0,0,0,0,0,"Zaza - On Reset - Set Npc Flag Questgiver");
  324. -- Hierophant Cenius SAI
  325. SET @ENTRY := 25810;
  326. UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
  327. DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0;
  328. 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
  329. (@ENTRY,0,0,0,4,0,100,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Hierophant Cenius - On Aggro - Say Line 0"),
  330. (@ENTRY,0,1,0,4,0,100,0,0,0,0,0,83,2,0,0,0,0,0,1,0,0,0,0,0,0,0,"Hierophant Cenius - On Aggro - Remove Npc Flag Questgiver"),
  331. (@ENTRY,0,2,0,10,0,100,0,1,20,0,0,49,0,0,0,0,0,0,25,20,1,0,0,0,0,0,"Hierophant Cenius - Within 1-20 Range Out of Combat LoS - Start Attacking"),
  332. (@ENTRY,0,3,0,25,0,100,0,0,0,0,0,81,2,0,0,0,0,0,1,0,0,0,0,0,0,0,"Hierophant Cenius - On Reset - Set Npc Flag Questgiver");
  333.  
  334. -- Killinger the Den Watcher SAI
  335. SET @ENTRY := 25812;
  336. UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
  337. DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0;
  338. 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
  339. (@ENTRY,0,0,0,4,0,100,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Killinger the Den Watcher - On Aggro - Say Line 0"),
  340. (@ENTRY,0,1,0,4,0,100,0,0,0,0,0,83,2,0,0,0,0,0,1,0,0,0,0,0,0,0,"Killinger the Den Watcher - On Aggro - Remove Npc Flag Questgiver"),
  341. (@ENTRY,0,2,0,10,0,100,0,1,20,0,0,49,0,0,0,0,0,0,25,20,1,0,0,0,0,0,"Killinger the Den Watcher - Within 1-20 Range Out of Combat LoS - Start Attacking"),
  342. (@ENTRY,0,3,0,25,0,100,0,0,0,0,0,81,2,0,0,0,0,0,1,0,0,0,0,0,0,0,"Killinger the Den Watcher - On Reset - Set Npc Flag Questgiver");
  343.  
  344. -- Hierophant Liandra SAI
  345. SET @ENTRY := 25838;
  346. UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
  347. DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0;
  348. 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
  349. (@ENTRY,0,0,0,4,0,100,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Hierophant Liandra - On Aggro - Say Line 0"),
  350. (@ENTRY,0,1,0,4,0,100,0,0,0,0,0,83,2,0,0,0,0,0,1,0,0,0,0,0,0,0,"Hierophant Liandra - On Aggro - Remove Npc Flag Questgiver"),
  351. (@ENTRY,0,2,0,10,0,100,0,1,25,0,0,49,0,0,0,0,0,0,25,25,1,0,0,0,0,0,"Hierophant Liandra - Within 1-25 Range Out of Combat LoS - Start Attacking"),
  352. (@ENTRY,0,3,0,25,0,100,0,0,0,0,0,81,2,0,0,0,0,0,1,0,0,0,0,0,0,0,"Hierophant Liandra - On Reset - Set Npc Flag Questgiver"),
  353. (@ENTRY,0,4,0,4,0,100,0,0,0,0,0,91,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Hierophant Liandra - On Aggro - Remove Flag Standstate Sit Down"),
  354. (@ENTRY,0,5,0,25,0,100,0,0,0,0,0,90,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Hierophant Liandra - On Reset - Set Flag Standstate Sit Down");
  355.  
  356. -- Northsea Mercenary SAI
  357. SET @ENTRY := 25839;
  358. UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
  359. DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0;
  360. 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
  361. (@ENTRY,0,0,0,0,0,100,0,5000,8000,60000,65000,11,5915,0,0,0,0,0,1,0,0,0,0,0,0,0,"Northsea Mercenary - In Combat - Cast 'Crazed'");
  362.  
  363. -- Northsea Thug SAI
  364. SET @ENTRY := 25844;
  365. UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
  366. DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0;
  367. 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
  368. (@ENTRY,0,0,0,0,0,100,0,5000,8000,60000,65000,11,5915,0,0,0,0,0,1,0,0,0,0,0,0,0,"Northsea Thug - In Combat - Cast 'Crazed'");
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!