API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jun 15th, 2017
57
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 10.62 KB | None | 0 0
raw download clone embed print report
  1. -- Reposition some Undying Aggressors and add some missing
  2. UPDATE `creature` SET `position_x`=2366.67900,`position_y`=6433.56641,`position_z`=42.4940567,`orientation`=6.19591856,`spawndist`=0,`MovementType`=0 WHERE `guid`=118974;
  3. UPDATE `creature` SET `position_x`=2399.64000,`position_y`=6566.68200,`position_z`=430.665230,`orientation`=4.660029 WHERE `guid`=118990;
  4. UPDATE `creature` SET `position_x`=2400.45100,`position_y`=6532.73300,`position_z`=42.3396225,`orientation`=4.64257574 WHERE `guid`=118973;
  5. UPDATE `creature` SET `position_x`=2417.11255,`position_y`=6551.33643,`position_z`=41.3372800,`orientation`=4.677482 WHERE `guid`=118969;
  6. UPDATE `creature` SET `position_x`=2418.29883,`position_y`=6516.80800,`position_z`=42.5228400,`orientation`=4.62512255 WHERE `guid`=118971;
  7. UPDATE `creature` SET `position_x`=2450.653,`position_y`=6516.868,`position_z`=41.80021,`orientation`=4.520403 WHERE `guid`=118987;
  8.  
  9. UPDATE `creature` SET `position_x`=2466.59937,`position_y`=6433.739,`position_z`=42.48786,`orientation`=3.12413931 WHERE `guid`=119022;
  10. UPDATE `creature` SET `position_x`=2466.66943,`position_y`=6483.326,`position_z`=42.3441162,`orientation`=3.281219 WHERE `guid`=118984;
  11. UPDATE `creature` SET `position_x`=2466.67822,`position_y`=6466.48633,`position_z`=41.89767,`orientation`=3.26376557 WHERE `guid`=118983;
  12. UPDATE `creature` SET `position_x`=2466.76685,`position_y`=6449.278,`position_z`=42.60489,`orientation`=3.08923268 WHERE `guid`=118981;
  13. UPDATE `creature` SET `position_x`=2481.85938,`position_y`=6433.35254,`position_z`=42.4175262,`orientation`=3.12413931 WHERE `guid`=118985;
  14. UPDATE `creature` SET `position_x`=2482.61279,`position_y`=6466.825,`position_z`=42.2133865,`orientation`=3.21140575,`spawndist`=0,`MovementType`=0 WHERE `guid`=119010;
  15. UPDATE `creature` SET `position_x`=2482.766,`position_y`=6450.67139,`position_z`=42.45557,`orientation`=3.14159274,`spawndist`=0,`MovementType`=0 WHERE `guid`=119011;
  16. UPDATE `creature` SET `position_x`=2482.90161,`position_y`=6482.99072,`position_z`=42.551033,`orientation`=3.21140575,`spawndist`=0,`MovementType`=0 WHERE `guid`=118986;
  17. UPDATE `creature` SET `position_x`=2499.58643,`position_y`=6450.23535,`position_z`=42.5657158,`orientation`=3.12413931 WHERE `guid`=118982;
  18. UPDATE `creature` SET `position_x`=2500.053,`position_y`=6466.45557,`position_z`=41.81525,`orientation`=3.17649913,`spawndist`=0,`MovementType`=0 WHERE `guid`=119009;
  19. UPDATE `creature` SET `position_x`=2499.80981,`position_y`=6433.27344,`position_z`=43.2907944,`orientation`=3.12413931 WHERE `guid`=119018;
  20. UPDATE `creature` SET `position_x`=2515.60718,`position_y`=6433.24951,`position_z`=43.2397156,`orientation`=3.12413931 WHERE `guid`=119019;
  21. UPDATE `creature` SET `position_x`=2516.99536,`position_y`=6449.49854,`position_z`=42.7077560,`orientation`=3.12413931,`spawndist`=0,`MovementType`=0 WHERE `guid`=119020;
  22.  
  23. -- Pathing for Stitched Warsong Horror
  24. SET @NPC := 118862;
  25. SET @PATH := @NPC*10;
  26. UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=2507.88,`position_y`=6418.43,`position_z`=43.27 WHERE `guid`=@NPC;
  27. DELETE FROM `creature_addon` WHERE `guid`=@NPC;
  28. INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`) VALUES (@NPC,@PATH,1);
  29. DELETE FROM `waypoint_data` WHERE `id`=@PATH;
  30. INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`) VALUES
  31. (@PATH,1,2523.89,6417.38,42.52,0,0,0,100,0),
  32. (@PATH,2,2524.74,6499.83,43.92,0,0,0,100,0),
  33. (@PATH,3,2523.9,6510.75,43.14,0,0,0,100,0),
  34. (@PATH,4,2508.08,6510.36,44.02,0,0,0,100,0),
  35. (@PATH,5,2508.71,6467.03,41.42,0,0,0,100,0),
  36. (@PATH,6,2508.47,6432.56,43.65,0,0,0,100,0),
  37. (@PATH,7,2507.88,6418.43,43.27,0,0,0,100,0);
  38.  
  39. SET @NPC := 118863;
  40. SET @PATH := @NPC*10;
  41. UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=2307.77,`position_y`=6455.49,`position_z`=46.79 WHERE `guid`=@NPC;
  42. DELETE FROM `creature_addon` WHERE `guid`=@NPC;
  43. INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`) VALUES (@NPC,@PATH,1);
  44. DELETE FROM `waypoint_data` WHERE `id`=@PATH;
  45. INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`) VALUES
  46. (@PATH,1,2307.91,6491.59,43.39,0,0,0,100,0),
  47. (@PATH,2,2308.85,6509.85,45.27,0,0,0,100,0),
  48. (@PATH,3,2324.61,6509.74,45.77,0,0,0,100,0),
  49. (@PATH,4,2324.45,6473.96,42.89,0,0,0,100,0),
  50. (@PATH,5,2325.21,6433.98,47.54,0,0,0,100,0),
  51. (@PATH,6,2325.48,6422.98,46.65,0,0,0,100,0),
  52. (@PATH,7,2308.48,6423.61,50.52,0,0,0,100,0),
  53. (@PATH,8,2307.77,6455.49,46.79,0,0,0,100,0);
  54.  
  55. SET @NPC := 118864;
  56. SET @PATH := @NPC*10;
  57. UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=2340.38,`position_y`=6420.04,`position_z`=42.83 WHERE `guid`=@NPC;
  58. DELETE FROM `creature_addon` WHERE `guid`=@NPC;
  59. INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`) VALUES (@NPC,@PATH,1);
  60. DELETE FROM `waypoint_data` WHERE `id`=@PATH;
  61. INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`) VALUES
  62. (@PATH,1,2357.62,6418.95,42.2,0,0,0,100,0),
  63. (@PATH,2,2358.16,6465.06,41.88,0,0,0,100,0),
  64. (@PATH,3,2358.06,6499.06,42.75,0,0,0,100,0),
  65. (@PATH,4,2358.07,6514.53,44.05,0,0,0,100,0),
  66. (@PATH,5,2340.78,6513.75,45.05,0,0,0,100,0),
  67. (@PATH,6,2340.94,6466.1,41.88,0,0,0,100,0),
  68. (@PATH,7,2340.38,6420.04,42.83,0,0,0,100,0);
  69.  
  70. SET @NPC := 118865;
  71. SET @PATH := @NPC*10;
  72. UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=2474.27,`position_y`=6498.79,`position_z`=41.48 WHERE `guid`=@NPC;
  73. DELETE FROM `creature_addon` WHERE `guid`=@NPC;
  74. INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`) VALUES (@NPC,@PATH,1);
  75. DELETE FROM `waypoint_data` WHERE `id`=@PATH;
  76. INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`) VALUES
  77. (@PATH,1,2474.04,6515.55,41.64,0,0,0,100,0),
  78. (@PATH,2,2491.32,6514.84,41.89,0,0,0,100,0),
  79. (@PATH,3,2492.46,6469.62,42.36,0,0,0,100,0),
  80. (@PATH,4,2491.81,6433.18,42.96,0,0,0,100,0),
  81. (@PATH,5,2490.95,6425.04,43.09,0,0,0,100,0),
  82. (@PATH,6,2474.12,6425.03,42.46,0,0,0,100,0),
  83. (@PATH,7,2473.75,6465.1,41.81,0,0,0,100,0),
  84. (@PATH,8,2474.27,6498.79,41.48,0,0,0,100,0);
  85.  
  86. SET @NPC := 118866;
  87. SET @PATH := @NPC*10;
  88. UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=2388.08,`position_y`=6525.89,`position_z`=43.02 WHERE `guid`=@NPC;
  89. DELETE FROM `creature_addon` WHERE `guid`=@NPC;
  90. INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`) VALUES (@NPC,@PATH,1);
  91. DELETE FROM `waypoint_data` WHERE `id`=@PATH;
  92. INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`) VALUES
  93. (@PATH,1,2366.77,6525.89,44.89,0,0,0,100,0),
  94. (@PATH,2,2366.96,6509.74,43.02,0,0,0,100,0),
  95. (@PATH,3,2387.24,6509.87,42.02,0,0,0,100,0),
  96. (@PATH,4,2417.05,6509.81,42.81,0,0,0,100,0),
  97. (@PATH,5,2444.71,6509.83,41.7,0,0,0,100,0),
  98. (@PATH,6,2458.26,6508.64,41.32,0,0,0,100,0),
  99. (@PATH,7,2458.26,6525.38,41.7,0,0,0,100,0),
  100. (@PATH,8,2442.8,6525.75,41.82,0,0,0,100,0),
  101. (@PATH,9,2433.69,6525.66,41.95,0,0,0,100,0),
  102. (@PATH,10,2417.45,6525.55,42.06,0,0,0,100,0),
  103. (@PATH,11,2400,6525.59,42.27,0,0,0,100,0),
  104. (@PATH,12,2388.08,6525.89,43.02,0,0,0,100,0);
  105.  
  106. -- Deleting a creature that shouldn't be spwaned and using its guid for one that should be!
  107. DELETE FROM `creature` WHERE `guid`=107200;
  108. DELETE FROM `creature_addon` WHERE `guid`=107200;
  109. INSERT INTO `creature` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`) VALUES
  110. (107200,25332,571,1,1,0,0,2433.15,6541.23,41.37,5.72313261,120,0,0,1,0,0,2);
  111.  
  112. SET @NPC := 107200;
  113. SET @PATH := @NPC*10;
  114. UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=2433.15,`position_y`=6541.23,`position_z`=41.37 WHERE `guid`=@NPC;
  115. DELETE FROM `creature_addon` WHERE `guid`=@NPC;
  116. INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`) VALUES (@NPC,@PATH,1);
  117. DELETE FROM `waypoint_data` WHERE `id`=@PATH;
  118. INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`) VALUES
  119. (@PATH,1,2400.17,6542.01,42.24,0,0,0,100,0),
  120. (@PATH,2,2366.95,6541.73,43.97,0,0,0,100,0),
  121. (@PATH,3,2366.06,6559.32,41.61,0,0,0,100,0),
  122. (@PATH,4,2399.64,6559.5,43.22,0,0,0,100,0),
  123. (@PATH,5,2464.47,6558.69,40.94,0,0,0,100,0),
  124. (@PATH,6,2463.42,6540.69,41.19,0,0,0,100,0),
  125. (@PATH,7,2433.15,6541.23,41.37,0,0,0,100,0);
  126.  
  127. -- Kel'Thuzad Pathing
  128. SET @ID := 1195; -- Waypoint script id 3 required "Set by Malcrom"
  129. SET @WPSGUID := 777; -- Waypoint Script guid 3 required "Set by Malcrom"
  130. SET @NPC := 107121;
  131. SET @PATH := @NPC*10;
  132. UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@NPC;
  133. DELETE FROM `creature_addon` WHERE `guid`=@NPC;
  134. INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`) VALUES (@NPC,@PATH,1);
  135. DELETE FROM `waypoint_data` WHERE `id`=@PATH;
  136. INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`) VALUES
  137. (@PATH,1,2418.644,6456.104,54.55619,180000,0,@ID,100,0),
  138. (@PATH,2,2418.644,6456.104,54.55619,180000,0,@ID+1,100,0),
  139. (@PATH,3,2418.644,6456.104,54.55619,180000,0,@ID+2,100,0);
  140. DELETE FROM `waypoint_scripts` WHERE `id` IN (@ID,@ID+1,@ID+2);
  141. INSERT INTO `waypoint_scripts` (`id`,`delay`,`command`,`datalong`,`datalong2`,`dataint`,`x`,`y`,`z`,`o`,`guid`) VALUES
  142. (@ID,0,1,30,0,0,0,0,0,1.48722,@WPSGUID),
  143. (@ID+1,1,30,0,0,0,0,0,0,3.267756,@WPSGUID+1),
  144. (@ID+2,1,30,0,0,0,0,0,0,5.84679,@WPSGUID+2);
  145. -- Kel'Thuzad EAI
  146. UPDATE `creature_template` SET `AIName`= 'EventAI' WHERE `entry`=25465;
  147. DELETE FROM `creature_ai_scripts` WHERE `creature_id`=25465;
  148. INSERT INTO `creature_ai_scripts` (`id`,`creature_id`,`event_type`,`event_inverse_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action1_type`,`action1_param1`,`action1_param2`,`action1_param3`,`action2_type`,`action2_param1`,`action2_param2`,`action2_param3`,`action3_type`,`action3_param1`,`action3_param2`,`action3_param3`,`comment`) VALUES
  149. (254650,25465,1,0,100,1,4000,8000,26000,30000,11,50312,0,32,4,8818,0,0,0,0,0,0, 'Cast 50312 on self, Play sound');
  150. -- Spell Condition targets
  151. DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry`=50312;
  152. INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES
  153. (13,0,50312,0,18,1,25333,0,0,0, 'Unholy Fenzy - Undying Aggressor'),
  154. (13,0,50312,0,18,1,25332,0,0,0, 'Unholy Fenzy - Stitched Warsong Horror'),
  155. (13,0,50312,0,18,1,25469,0,0,0, 'Unholy Fenzy - Mindless Aberration');
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!