API tools faq
paste
Advertisement
baric

Demon Fall Ridge sql

baric
Feb 2nd, 2013
582
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 24.73 KB | None | 0 0
raw download clone embed print report
  1. -- missing objects/mobs on Demon Fall Ridge
  2. SET @OGUID := 200200;
  3. DELETE FROM gameobject WHERE guid >= @OGUID+0 AND guid <= @OGUID+3;
  4. INSERT INTO gameobject (guid, id, map, spawnMask, phaseMask, position_x, position_y, position_z, orientation, rotation0, rotation1, rotation2, rotation3, spawntimesecs, animprogress, state) VALUES
  5. (@OGUID+0, 1622 , 1, 1, 1, 1559.646 , -2812.193, 181.5358 , 0 , 0 , 0 , 0 , 1 , 120, 255, 1) , -- Bruiseweed (Area: Demon Fall Ridge),
  6. (@OGUID+1, 1623 , 1, 1, 1, 1599.648 , -3088.057, 89.47401 , 0 , 0 , 0 , 0 , 1 , 120, 255, 1) , -- Wild Steelbloom (Area: Demon Fall Ridge),
  7. (@OGUID+2, 1732 , 1, 1, 1, 1619.236 , -3106.807, 90.91071 , 0 , 0 , 0 , 0 , 1 , 120, 255, 1) , -- Tin Vein (Area: Demon Fall Ridge),
  8. (@OGUID+3, 176784, 1, 1, 1, 1550.686 , -2862.281, 181.7537 , 3.141593 , 0 , 0 , 0 , 1 , 120, 255, 1) ; -- Bonfire (Area: Demon Fall Ridge);
  9.  
  10. SET @CGUID := 523000;
  11.  
  12. DELETE FROM creature WHERE guid >= @CGUID+0 AND guid <= @CGUID+25;
  13. INSERT INTO creature (guid, id, map, spawnMask, phaseMask, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, MovementType) VALUES
  14. (@CGUID+00, 11697, 1, 1, 1, 1377.036 , -2832.29 , 108.1152 , 5.778122 , 120, 10, 1), -- Mannoroc Lasher (Area: Demon Fall Ridge) (waypoints or random movement)
  15. (@CGUID+01, 11697, 1, 1, 1, 1442.845 , -2781.555 , 143.3298 , 3.407407 , 120, 10, 1), -- Mannoroc Lasher (Area: Demon Fall Ridge) (possible waypoints or random movement)
  16. (@CGUID+02, 11697, 1, 1, 1, 1520.548 , -2910.79 , 128.7899 , 0.3708913 , 120, 10, 1), -- Mannoroc Lasher (Area: Demon Fall Ridge) (possible waypoints or random movement)
  17. (@CGUID+03, 11697, 1, 1, 1, 1522.825 , -2851.57 , 182.1475 , 5.156503 , 120, 10, 1), -- Mannoroc Lasher (Area: Demon Fall Ridge) (waypoints or random movement)
  18. (@CGUID+04, 11697, 1, 1, 1, 1538.938 , -2878.932 , 183.4645 , 1.239184 , 120, 0, 0), -- Mannoroc Lasher (Area: Demon Fall Ridge)
  19. (@CGUID+05, 11697, 1, 1, 1, 1544.031 , -2848.745 , 182.5147 , 5.044002 , 120, 0, 0), -- Mannoroc Lasher (Area: Demon Fall Ridge)
  20. (@CGUID+06, 11697, 1, 1, 1, 1544.416 , -2863.002 , 112.0556 , 2.701836 , 120, 10, 1), -- Mannoroc Lasher (Area: Demon Fall Ridge) (possible waypoints or random movement)
  21. (@CGUID+07, 11697, 1, 1, 1, 1563.016 , -2859.155 , 182.2932 , 4.066617 , 120, 0, 0), -- Mannoroc Lasher (Area: Demon Fall Ridge)
  22. (@CGUID+08, 11697, 1, 1, 1, 1581.573 , -2897.424 , 182.3294 , 1.43117 , 120, 0, 0), -- Mannoroc Lasher (Area: Demon Fall Ridge)
  23. (@CGUID+09, 16030, 1, 1, 1, 1625.747 , -3095.011 , 89.12293 , 2.2015 , 120, 10, 1), -- Maggot (Area: Demon Fall Ridge)
  24. (@CGUID+10, 16030, 1, 1, 1, 1636.01 , -3052.925 , 90.07569 , 4.715363 , 120, 10, 1), -- Maggot (Area: Demon Fall Ridge)
  25. (@CGUID+11, 16030, 1, 1, 1, 1647.72 , -3076.708 , 88.33277 , 1.016972 , 120, 10, 1), -- Maggot (Area: Demon Fall Ridge)
  26. (@CGUID+12, 6073 , 1, 1, 1, 1420.36 , -2797 , 153.2968 , 4.158457 , 120, 0, 0), -- Searing Infernal (Area: Demon Fall Ridge)
  27. (@CGUID+13, 6073 , 1, 1, 1, 1451.373 , -2815.769 , 154.2159 , 4.385233 , 120, 0, 0), -- Searing Infernal (Area: Demon Fall Ridge)
  28. (@CGUID+14, 6073 , 1, 1, 1, 1500.756 , -2835.735 , 111.587 , 5.95405 , 120, 0, 0), -- Searing Infernal (Area: Demon Fall Ridge)
  29. (@CGUID+15, 6073 , 1, 1, 1, 1512.830 , -2877.935 , 111.1157 , 2.860 , 120, 0, 0), -- Searing Infernal (Area: Demon Fall Ridge)
  30. (@CGUID+16, 6073 , 1, 1, 1, 1550.406 , -2885.673 , 132.9547 , 4.354227 , 120, 0, 0), -- Searing Infernal (Area: Demon Fall Ridge)
  31. (@CGUID+17, 6073 , 1, 1, 1, 1555.71 , -2901.445 , 182.4397 , 3.857178 , 120, 10, 1), -- Searing Infernal (Area: Demon Fall Ridge)
  32. (@CGUID+18, 6073 , 1, 1, 1, 1566.779 , -2894.126 , 132.5958 , 0.1956479 , 120, 0, 0), -- Searing Infernal (Area: Demon Fall Ridge)
  33. (@CGUID+19, 6073 , 1, 1, 1, 1537.930 , -2823.109 , 181.6067 , 5.282221 , 120, 0, 0), -- Searing Infernal (Area: Demon Fall Ridge)
  34. (@CGUID+20, 6073 , 1, 1, 1, 1583.341 , -2959.558 , 182.2528 , 5.410459 , 120, 0, 0), -- Searing Infernal (Area: Demon Fall Ridge)
  35. (@CGUID+21, 6115 , 1, 1, 1, 1420.313 , -2851.199 , 133.127 , 0.9438578 , 120, 10, 1), -- Roaming Felguard (Area: Demon Fall Ridge) (waypoints or random movement)
  36. (@CGUID+22, 6115 , 1, 1, 1, 1461.483 , -2783.054 , 154.6106 , 4.637331 , 120, 10, 1), -- Roaming Felguard (Area: Demon Fall Ridge) (waypoints or random movement)
  37. (@CGUID+23, 6115 , 1, 1, 1, 1521.961 , -2856.834 , 111.6264 , 4.90235 , 120, 10, 1), -- Roaming Felguard (Area: Demon Fall Ridge) (waypoints or random movement)
  38. (@CGUID+24, 6115 , 1, 1, 1, 1610.802 , -3083.251 , 89.95774 , 1.347837 , 120, 10, 1), -- Roaming Felguard (Area: Demon Fall Ridge) waypoints or random movement)
  39. (@CGUID+25, 6115 , 1, 1, 1, 1611.121 , -2985.179 , 182.0912 , 2.853907 , 120, 10, 1); -- Roaming Felguard (Area: Demon Fall Ridge) (waypoints or random movement)
  40.  
  41. -- reposition to avoid position clash with other mob
  42. UPDATE creature SET position_x = 1553.05, position_y = -2844.765, position_z = 129.70, orientation = 0.6726, MovementType = 0, spawndist = 0 WHERE guid = 20082;
  43.  
  44. -- pathing for Felguard #20872 on
  45. SET @WPID := 208720;
  46. UPDATE creature SET MovementType=2, position_x=1445.667358, position_y=-2785.956299, position_z=144.079132, currentwaypoint=0 WHERE guid = 20872;
  47. DELETE FROM creature_addon WHERE guid = 20872;
  48. INSERT INTO creature_addon (guid, path_id) VALUES (20872, @WPID);
  49. DELETE FROM waypoint_data WHERE id=@WPID;
  50. INSERT INTO waypoint_data (id,point,position_x,position_y,position_z,orientation,delay,move_flag,action,action_chance,wpguid) VALUES
  51. (@WPID, 0, 1445.667358, -2785.956299, 144.079132, 0, 0, 0, 0, 100, 0),
  52. (@WPID, 1, 1450.664429, -2799.601807, 144.581528, 0, 0, 0, 0, 100, 0),
  53. (@WPID, 2, 1457.757935, -2801.675293, 145.510452, 0, 0, 0, 0, 100, 0),
  54. (@WPID, 3, 1467.130493, -2804.867188, 147.879959, 0, 0, 0, 0, 100, 0),
  55. (@WPID, 4, 1476.766113, -2806.016602, 149.540283, 0, 0, 0, 0, 100, 0),
  56. (@WPID, 5, 1478.050537, -2798.385254, 149.963150, 0, 0, 0, 0, 100, 0),
  57. (@WPID, 6, 1473.788696, -2787.377197, 152.504379, 0, 0, 0, 0, 100, 0),
  58. (@WPID, 7, 1468.064453, -2783.520264, 154.801208, 0, 0, 0, 0, 100, 0),
  59. (@WPID, 8, 1460.110718, -2782.338135, 154.570343, 0, 0, 0, 0, 100, 0),
  60. (@WPID, 9, 1466.063477, -2783.569580, 155.144333, 0, 0, 0, 0, 100, 0),
  61. (@WPID, 10, 1473.382202, -2788.681152, 152.407547, 0, 0, 0, 0, 100, 0),
  62. (@WPID, 11, 1477.975464, -2797.371094, 150.017349, 0, 0, 0, 0, 100, 0),
  63. (@WPID, 12, 1473.043457, -2804.988770, 149.482895, 0, 0, 0, 0, 100, 0),
  64. (@WPID, 13, 1465.716309, -2806.197021, 147.414398, 0, 0, 0, 0, 100, 0),
  65. (@WPID, 14, 1457.339355, -2802.397949, 145.514069, 0, 0, 0, 0, 100, 0),
  66. (@WPID, 15, 1450.980835, -2794.119385, 144.331573, 0, 0, 0, 0, 100, 0);
  67.  
  68. -- pathing for Felguard #20874 on
  69. SET @WPID := 208740;
  70. UPDATE creature SET MovementType=2, position_x=1427.127686, position_y=-2794.929199, position_z=153.367630, currentwaypoint=0 WHERE guid = 20874;
  71. DELETE FROM creature_addon WHERE guid = 20874;
  72. INSERT INTO creature_addon (guid, path_id) VALUES (20874, @WPID);
  73. DELETE FROM waypoint_data WHERE id=@WPID;
  74. INSERT INTO waypoint_data (id,point,position_x,position_y,position_z,orientation,delay,move_flag,action,action_chance,wpguid) VALUES
  75. (@WPID, 0, 1427.127686, -2794.929199, 153.367630, 0, 0, 0, 0, 100, 0),
  76. (@WPID, 1, 1434.866943, -2792.607666, 153.983551, 0, 0, 0, 0, 100, 0),
  77. (@WPID, 2, 1439.881104, -2789.645996, 156.961761, 0, 0, 0, 0, 100, 0),
  78. (@WPID, 3, 1446.391846, -2787.082031, 158.247574, 0, 0, 0, 0, 100, 0),
  79. (@WPID, 4, 1452.749390, -2784.158691, 156.516998, 0, 0, 0, 0, 100, 0),
  80. (@WPID, 5, 1461.059204, -2782.987793, 154.608047, 0, 0, 0, 0, 100, 0),
  81. (@WPID, 6, 1459.080078, -2790.694580, 157.111328, 0, 0, 0, 0, 100, 0),
  82. (@WPID, 7, 1457.619629, -2795.229492, 158.473236, 0, 0, 0, 0, 100, 0),
  83. (@WPID, 8, 1455.797607, -2801.988037, 158.055511, 0, 0, 0, 0, 100, 0),
  84. (@WPID, 9, 1453.832642, -2808.706543, 155.066422, 0, 0, 0, 0, 100, 0),
  85. (@WPID, 10, 1451.864258, -2814.851807, 153.940338, 0, 0, 0, 0, 100, 0),
  86. (@WPID, 11, 1453.883789, -2807.040039, 155.886780, 0, 0, 0, 0, 100, 0),
  87. (@WPID, 12, 1457.238525, -2798.087891, 158.691376, 0, 0, 0, 0, 100, 0),
  88. (@WPID, 13, 1459.887451, -2791.610352, 157.409363, 0, 0, 0, 0, 100, 0),
  89. (@WPID, 14, 1461.216431, -2782.308350, 154.564026, 0, 0, 0, 0, 100, 0),
  90. (@WPID, 15, 1450.710571, -2784.914063, 157.356842, 0, 0, 0, 0, 100, 0),
  91. (@WPID, 16, 1444.170044, -2787.408203, 158.144180, 0, 0, 0, 0, 100, 0),
  92. (@WPID, 17, 1434.528687, -2791.566895, 154.061630, 0, 0, 0, 0, 100, 0);
  93.  
  94. -- pathing for Felguard #20876 on
  95. SET @WPID := 208760;
  96. UPDATE creature SET MovementType=2, position_x=1519.061279, position_y=-2911.228271, position_z=128.724503, currentwaypoint=0 WHERE guid = 20876;
  97. DELETE FROM creature_addon WHERE guid = 20876;
  98. INSERT INTO creature_addon (guid, path_id) VALUES (20876, @WPID);
  99. DELETE FROM waypoint_data WHERE id=@WPID;
  100. INSERT INTO waypoint_data (id,point,position_x,position_y,position_z,orientation,delay,move_flag,action,action_chance,wpguid) VALUES
  101. (@WPID, 0, 1519.061279, -2911.228271, 128.724503, 0, 0, 0, 0, 100, 0),
  102. (@WPID, 1, 1520.779297, -2904.444336, 130.019699, 0, 0, 0, 0, 100, 0),
  103. (@WPID, 2, 1523.576782, -2894.323975, 129.760376, 0, 0, 0, 0, 100, 0),
  104. (@WPID, 3, 1525.399658, -2887.565674, 129.650497, 0, 0, 0, 0, 100, 0),
  105. (@WPID, 4, 1527.510254, -2880.891602, 127.859444, 0, 0, 0, 0, 100, 0),
  106. (@WPID, 5, 1530.465454, -2871.784424, 124.707077, 0, 0, 0, 0, 100, 0),
  107. (@WPID, 6, 1534.396240, -2865.125244, 124.945396, 0, 0, 0, 0, 100, 0),
  108. (@WPID, 7, 1541.486206, -2857.385254, 129.325195, 0, 0, 0, 0, 100, 0),
  109. (@WPID, 8, 1546.340820, -2852.342285, 129.804764, 0, 0, 0, 0, 100, 0),
  110. (@WPID, 9, 1551.960815, -2845.879395, 129.609558, 0, 0, 0, 0, 100, 0),
  111. (@WPID, 10, 1547.109009, -2851.705322, 129.800903, 0, 0, 0, 0, 100, 0),
  112. (@WPID, 11, 1542.209229, -2856.704590, 129.541779, 0, 0, 0, 0, 100, 0),
  113. (@WPID, 12, 1534.886353, -2864.229248, 125.346100, 0, 0, 0, 0, 100, 0),
  114. (@WPID, 13, 1530.252686, -2871.376953, 124.679268, 0, 0, 0, 0, 100, 0),
  115. (@WPID, 14, 1528.427368, -2877.171631, 126.128044, 0, 0, 0, 0, 100, 0),
  116. (@WPID, 15, 1525.856323, -2887.348633, 129.625702, 0, 0, 0, 0, 100, 0),
  117. (@WPID, 16, 1523.781738, -2894.034180, 129.770584, 0, 0, 0, 0, 100, 0),
  118. (@WPID, 17, 1521.690063, -2900.714355, 129.564087, 0, 0, 0, 0, 100, 0);
  119.  
  120. -- pathing for Lasher CGUID+0
  121.  
  122. SET @WPID := (@CGUID+0)*10;
  123. UPDATE creature SET MovementType=2, position_x=1377.440918, position_y=-2831.153320, position_z=108.026917, currentwaypoint=0 WHERE guid = @CGUID+0;
  124. DELETE FROM creature_addon WHERE guid = @CGUID+0;
  125. INSERT INTO creature_addon (guid, path_id) VALUES (@CGUID+0, @WPID);
  126. DELETE FROM waypoint_data WHERE id=@WPID;
  127. INSERT INTO waypoint_data (id,point,position_x,position_y,position_z,orientation,delay,move_flag,action,action_chance,wpguid) VALUES
  128. (@WPID, 0, 1377.440918, -2831.153320, 108.026917, 0, 0, 0, 0, 100, 0),
  129. (@WPID, 1, 1382.229004, -2827.563721, 108.826355, 0, 0, 0, 0, 100, 0),
  130. (@WPID, 2, 1391.730957, -2823.097656, 109.964256, 0, 0, 0, 0, 100, 0),
  131. (@WPID, 3, 1403.629517, -2820.422607, 113.992607, 0, 0, 0, 0, 100, 0),
  132. (@WPID, 4, 1414.020630, -2821.883545, 116.552795, 0, 0, 0, 0, 100, 0),
  133. (@WPID, 5, 1425.679565, -2823.227295, 118.282143, 0, 0, 0, 0, 100, 0),
  134. (@WPID, 6, 1437.257935, -2822.140869, 120.388496, 0, 0, 0, 0, 100, 0),
  135. (@WPID, 7, 1444.380127, -2817.184570, 120.541428, 0, 0, 0, 0, 100, 0),
  136. (@WPID, 8, 1439.560669, -2812.109863, 120.442703, 0, 0, 0, 0, 100, 0),
  137. (@WPID, 9, 1429.911133, -2806.321045, 121.627449, 0, 0, 0, 0, 100, 0),
  138. (@WPID, 10, 1420.165527, -2802.415283, 122.528816, 0, 0, 0, 0, 100, 0),
  139. (@WPID, 11, 1406.437866, -2799.521240, 123.336349, 0, 0, 0, 0, 100, 0),
  140. (@WPID, 12, 1408.145020, -2806.980225, 124.640030, 0, 0, 0, 0, 100, 0),
  141. (@WPID, 13, 1411.558472, -2817.519531, 130.557297, 0, 0, 0, 0, 100, 0),
  142. (@WPID, 14, 1414.248291, -2826.448975, 134.029892, 0, 0, 0, 0, 100, 0),
  143. (@WPID, 15, 1416.987061, -2833.898926, 134.158966, 0, 0, 0, 0, 100, 0),
  144. (@WPID, 16, 1418.680298, -2841.623291, 134.089142, 0, 0, 0, 0, 100, 0),
  145. (@WPID, 17, 1417.675415, -2851.522949, 133.205948, 0, 0, 0, 0, 100, 0),
  146. (@WPID, 18, 1419.567261, -2843.880615, 134.064331, 0, 0, 0, 0, 100, 0),
  147. (@WPID, 19, 1418.282349, -2835.081543, 133.903214, 0, 0, 0, 0, 100, 0),
  148. (@WPID, 20, 1413.755615, -2826.055420, 133.871857, 0, 0, 0, 0, 100, 0),
  149. (@WPID, 21, 1410.707886, -2816.007813, 129.677521, 0, 0, 0, 0, 100, 0),
  150. (@WPID, 22, 1407.735840, -2804.345947, 123.423225, 0, 0, 0, 0, 100, 0),
  151. (@WPID, 23, 1411.128418, -2800.364258, 123.362190, 0, 0, 0, 0, 100, 0),
  152. (@WPID, 24, 1423.222046, -2802.809082, 122.215492, 0, 0, 0, 0, 100, 0),
  153. (@WPID, 25, 1432.720093, -2807.233643, 121.249458, 0, 0, 0, 0, 100, 0),
  154. (@WPID, 26, 1442.866333, -2811.426514, 120.474632, 0, 0, 0, 0, 100, 0),
  155. (@WPID, 27, 1442.986938, -2817.752686, 120.496185, 0, 0, 0, 0, 100, 0),
  156. (@WPID, 28, 1432.807739, -2820.319336, 120.214920, 0, 0, 0, 0, 100, 0),
  157. (@WPID, 29, 1422.910767, -2822.051270, 118.090607, 0, 0, 0, 0, 100, 0),
  158. (@WPID, 30, 1411.085083, -2819.568359, 115.681824, 0, 0, 0, 0, 100, 0),
  159. (@WPID, 31, 1400.672852, -2819.333740, 113.069351, 0, 0, 0, 0, 100, 0),
  160. (@WPID, 32, 1392.437012, -2822.626953, 110.105415, 0, 0, 0, 0, 100, 0),
  161. (@WPID, 33, 1381.681763, -2827.953857, 108.544312, 0, 0, 0, 0, 100, 0);
  162.  
  163. -- pathing for Lasher CGUID+3
  164.  
  165. SET @WPID := (@CGUID+3)*10;
  166. UPDATE creature SET MovementType=2, position_x=1525.115723, position_y=-2850.323975, position_z=182.264648, currentwaypoint=0 WHERE guid = @CGUID+3;
  167. DELETE FROM creature_addon WHERE guid = @CGUID+3;
  168. INSERT INTO creature_addon (guid, path_id) VALUES (@CGUID+3, @WPID);
  169. DELETE FROM waypoint_data WHERE id=@WPID;
  170. INSERT INTO waypoint_data (id,point,position_x,position_y,position_z,orientation,delay,move_flag,action,action_chance,wpguid) VALUES
  171. (@WPID, 0, 1525.115723, -2850.323975, 182.264648, 0, 0, 0, 0, 100, 0),
  172. (@WPID, 1, 1531.196411, -2840.045166, 182.315933, 0, 0, 0, 0, 100, 0),
  173. (@WPID, 2, 1540.609741, -2830.145752, 182.035614, 0, 0, 0, 0, 100, 0),
  174. (@WPID, 3, 1550.371094, -2824.623535, 181.914169, 0, 0, 0, 0, 100, 0),
  175. (@WPID, 4, 1560.609863, -2825.602783, 181.713562, 0, 0, 0, 0, 100, 0),
  176. (@WPID, 5, 1573.442139, -2834.195557, 181.620041, 0, 0, 0, 0, 100, 0),
  177. (@WPID, 6, 1573.676636, -2843.122803, 182.236511, 0, 0, 0, 0, 100, 0),
  178. (@WPID, 7, 1575.495605, -2852.658936, 183.287399, 0, 0, 0, 0, 100, 0),
  179. (@WPID, 8, 1573.915161, -2863.642578, 182.804459, 0, 0, 0, 0, 100, 0),
  180. (@WPID, 9, 1568.231201, -2881.090820, 183.118271, 0, 0, 0, 0, 100, 0),
  181. (@WPID, 10, 1558.646729, -2884.779541, 183.471115, 0, 0, 0, 0, 100, 0),
  182. (@WPID, 11, 1549.383301, -2877.014160, 182.969772, 0, 0, 0, 0, 100, 0),
  183. (@WPID, 12, 1541.126465, -2864.694092, 182.265366, 0, 0, 0, 0, 100, 0);
  184.  
  185. -- pathing for Felguard CGUID+21 on
  186. SET @WPID := (@CGUID+21)*10;
  187. UPDATE creature SET MovementType=2, position_x=1418.673340, position_y=-2849.543701, position_z=133.128998, currentwaypoint=0 WHERE guid = @CGUID+21;
  188. DELETE FROM creature_addon WHERE guid = @CGUID+21;
  189. INSERT INTO creature_addon (guid, path_id) VALUES (@CGUID+21, @WPID);
  190. DELETE FROM waypoint_data WHERE id=@WPID;
  191. INSERT INTO waypoint_data (id,point,position_x,position_y,position_z,orientation,delay,move_flag,action,action_chance,wpguid) VALUES
  192. (@WPID, 0, 1418.673340, -2849.543701, 133.128998, 0, 0, 0, 0, 100, 0),
  193. (@WPID, 1, 1419.053223, -2840.867188, 133.872528, 0, 0, 0, 0, 100, 0),
  194. (@WPID, 2, 1416.689941, -2834.154297, 134.137970, 0, 0, 0, 0, 100, 0),
  195. (@WPID, 3, 1414.608398, -2827.471436, 134.225082, 0, 0, 0, 0, 100, 0),
  196. (@WPID, 4, 1412.582764, -2820.770996, 132.077194, 0, 0, 0, 0, 100, 0),
  197. (@WPID, 5, 1409.088867, -2810.655762, 126.843498, 0, 0, 0, 0, 100, 0),
  198. (@WPID, 6, 1411.302002, -2817.291016, 130.399963, 0, 0, 0, 0, 100, 0),
  199. (@WPID, 7, 1413.902222, -2826.605957, 134.035446, 0, 0, 0, 0, 100, 0),
  200. (@WPID, 8, 1416.532471, -2833.090820, 134.308105, 0, 0, 0, 0, 100, 0),
  201. (@WPID, 9, 1418.736084, -2841.765137, 134.127487, 0, 0, 0, 0, 100, 0);
  202.  
  203. -- pathing for Felguard CGUID+22 on
  204. SET @WPID := (@CGUID+22)*10;
  205. UPDATE creature SET MovementType=2, position_x=1461.952393, position_y=-2777.578613, position_z=154.923584, currentwaypoint=0 WHERE guid = @CGUID+22;
  206. DELETE FROM creature_addon WHERE guid = @CGUID+22;
  207. INSERT INTO creature_addon (guid, path_id) VALUES (@CGUID+22, @WPID);
  208. DELETE FROM waypoint_data WHERE id=@WPID;
  209. INSERT INTO waypoint_data (id,point,position_x,position_y,position_z,orientation,delay,move_flag,action,action_chance,wpguid) VALUES
  210. (@WPID, 0, 1461.952393, -2777.578613, 154.923584, 0, 0, 0, 0, 100, 0),
  211. (@WPID, 1, 1465.133545, -2767.573975, 154.857132, 0, 0, 0, 0, 100, 0),
  212. (@WPID, 2, 1472.367310, -2758.643555, 156.072708, 0, 0, 0, 0, 100, 0),
  213. (@WPID, 3, 1482.150879, -2754.233887, 156.292877, 0, 0, 0, 0, 100, 0),
  214. (@WPID, 4, 1493.999512, -2752.110352, 158.143372, 0, 0, 0, 0, 100, 0),
  215. (@WPID, 5, 1497.644165, -2753.630127, 159.105545, 0, 0, 0, 0, 100, 0),
  216. (@WPID, 6, 1500.601318, -2760.660889, 160.422638, 0, 0, 0, 0, 100, 0),
  217. (@WPID, 7, 1501.830933, -2768.006348, 160.797318, 0, 0, 0, 0, 100, 0),
  218. (@WPID, 8, 1503.898804, -2771.084473, 161.295364, 0, 0, 0, 0, 100, 0),
  219. (@WPID, 9, 1509.369507, -2777.201904, 163.673080, 0, 0, 0, 0, 100, 0),
  220. (@WPID, 10, 1512.175049, -2785.971191, 165.083893, 0, 0, 0, 0, 100, 0),
  221. (@WPID, 11, 1513.801514, -2792.097412, 165.634216, 0, 0, 0, 0, 100, 0),
  222. (@WPID, 12, 1518.169800, -2796.058838, 165.138840, 0, 0, 0, 0, 100, 0),
  223. (@WPID, 13, 1524.349854, -2800.773926, 167.720108, 0, 0, 0, 0, 100, 0),
  224. (@WPID, 14, 1525.073975, -2806.124023, 169.219666, 0, 0, 0, 0, 100, 0),
  225. (@WPID, 15, 1522.830933, -2812.213623, 170.961700, 0, 0, 0, 0, 100, 0),
  226. (@WPID, 16, 1511.613159, -2814.369385, 174.126556, 0, 0, 0, 0, 100, 0),
  227. (@WPID, 17, 1510.135620, -2812.832031, 174.583145, 0, 0, 0, 0, 100, 0),
  228. (@WPID, 18, 1507.537842, -2804.130127, 177.219849, 0, 0, 0, 0, 100, 0),
  229. (@WPID, 19, 1510.847778, -2799.395020, 178.859070, 0, 0, 0, 0, 100, 0),
  230. (@WPID, 20, 1516.893555, -2797.346436, 180.676239, 0, 0, 0, 0, 100, 0),
  231. (@WPID, 21, 1522.649170, -2800.572021, 182.535858, 0, 0, 0, 0, 100, 0),
  232. (@WPID, 22, 1524.135986, -2803.739746, 183.545761, 0, 0, 0, 0, 100, 0),
  233. (@WPID, 23, 1525.988403, -2809.307129, 183.373550, 0, 0, 0, 0, 100, 0),
  234. (@WPID, 24, 1531.261963, -2816.573486, 183.528900, 0, 0, 0, 0, 100, 0),
  235. (@WPID, 25, 1525.760620, -2811.326904, 183.373657, 0, 0, 0, 0, 100, 0),
  236. (@WPID, 26, 1524.779297, -2808.985840, 183.373657, 0, 0, 0, 0, 100, 0),
  237. (@WPID, 27, 1523.441772, -2802.632324, 183.127411, 0, 0, 0, 0, 100, 0),
  238. (@WPID, 28, 1517.132202, -2796.257080, 180.712280, 0, 0, 0, 0, 100, 0),
  239. (@WPID, 29, 1513.053223, -2798.000732, 179.479279, 0, 0, 0, 0, 100, 0),
  240. (@WPID, 30, 1507.427002, -2804.455811, 177.126724, 0, 0, 0, 0, 100, 0),
  241. (@WPID, 31, 1508.335205, -2810.697266, 175.403000, 0, 0, 0, 0, 100, 0),
  242. (@WPID, 32, 1511.198853, -2812.709717, 174.371857, 0, 0, 0, 0, 100, 0),
  243. (@WPID, 33, 1517.645874, -2814.697510, 172.516037, 0, 0, 0, 0, 100, 0),
  244. (@WPID, 34, 1522.476196, -2811.204834, 170.816132, 0, 0, 0, 0, 100, 0),
  245. (@WPID, 35, 1524.924316, -2804.578857, 168.840012, 0, 0, 0, 0, 100, 0),
  246. (@WPID, 36, 1522.207397, -2800.135010, 167.209824, 0, 0, 0, 0, 100, 0),
  247. (@WPID, 37, 1515.743164, -2793.846436, 165.489563, 0, 0, 0, 0, 100, 0),
  248. (@WPID, 38, 1513.621826, -2789.284180, 165.761047, 0, 0, 0, 0, 100, 0),
  249. (@WPID, 39, 1511.703735, -2782.553467, 165.049728, 0, 0, 0, 0, 100, 0),
  250. (@WPID, 40, 1509.514526, -2776.442139, 163.672668, 0, 0, 0, 0, 100, 0),
  251. (@WPID, 41, 1504.341187, -2768.239258, 160.875214, 0, 0, 0, 0, 100, 0),
  252. (@WPID, 42, 1499.623779, -2758.871826, 160.065994, 0, 0, 0, 0, 100, 0),
  253. (@WPID, 43, 1492.976929, -2750.636963, 158.080460, 0, 0, 0, 0, 100, 0),
  254. (@WPID, 44, 1487.860107, -2750.589600, 157.576538, 0, 0, 0, 0, 100, 0),
  255. (@WPID, 45, 1478.629761, -2755.590332, 155.843948, 0, 0, 0, 0, 100, 0),
  256. (@WPID, 46, 1469.609863, -2761.452148, 155.947708, 0, 0, 0, 0, 100, 0),
  257. (@WPID, 47, 1465.007324, -2767.513184, 154.872833, 0, 0, 0, 0, 100, 0),
  258. (@WPID, 48, 1462.420410, -2775.385254, 155.379456, 0, 0, 0, 0, 100, 0);
  259.  
  260. -- pathing for Felguard CGUID+23 on
  261. SET @WPID := (@CGUID+23)*10;
  262. UPDATE creature SET MovementType=2, position_x=1529.591064, position_y=-2869.343506, position_z=124.593094, currentwaypoint=0 WHERE guid = @CGUID+23;
  263. DELETE FROM creature_addon WHERE guid = @CGUID+23;
  264. INSERT INTO creature_addon (guid, path_id) VALUES (@CGUID+23, @WPID);
  265. DELETE FROM waypoint_data WHERE id=@WPID;
  266. INSERT INTO waypoint_data (id,point,position_x,position_y,position_z,orientation,delay,move_flag,action,action_chance,wpguid) VALUES
  267. (@WPID, 0, 1529.591064, -2869.343506, 124.593094, 0, 0, 0, 0, 100, 0),
  268. (@WPID, 1, 1521.646606, -2867.309082, 125.010071, 0, 0, 0, 0, 100, 0),
  269. (@WPID, 2, 1513.953125, -2865.164551, 121.647118, 0, 0, 0, 0, 100, 0),
  270. (@WPID, 3, 1505.404785, -2862.673584, 118.801720, 0, 0, 0, 0, 100, 0),
  271. (@WPID, 4, 1503.566650, -2868.243408, 116.714241, 0, 0, 0, 0, 100, 0),
  272. (@WPID, 5, 1502.711060, -2874.966064, 113.316238, 0, 0, 0, 0, 100, 0),
  273. (@WPID, 6, 1512.905396, -2877.691650, 111.030319, 0, 0, 0, 0, 100, 0),
  274. (@WPID, 7, 1521.637085, -2882.186279, 111.867195, 0, 0, 0, 0, 100, 0),
  275. (@WPID, 8, 1529.314087, -2885.161865, 111.463722, 0, 0, 0, 0, 100, 0),
  276. (@WPID, 9, 1539.290527, -2881.081299, 112.201981, 0, 0, 0, 0, 100, 0),
  277. (@WPID, 10, 1543.733276, -2870.510986, 112.591675, 0, 0, 0, 0, 100, 0),
  278. (@WPID, 11, 1538.328125, -2855.836182, 111.515526, 0, 0, 0, 0, 100, 0),
  279. (@WPID, 12, 1527.172241, -2852.837158, 111.962715, 0, 0, 0, 0, 100, 0),
  280. (@WPID, 13, 1519.438599, -2860.600342, 111.478615, 0, 0, 0, 0, 100, 0),
  281. (@WPID, 14, 1511.972412, -2870.450684, 111.600555, 0, 0, 0, 0, 100, 0),
  282. (@WPID, 15, 1507.419556, -2876.432617, 112.032738, 0, 0, 0, 0, 100, 0),
  283. (@WPID, 16, 1504.038330, -2877.903809, 112.833618, 0, 0, 0, 0, 100, 0),
  284. (@WPID, 17, 1502.584595, -2873.350342, 113.795448, 0, 0, 0, 0, 100, 0),
  285. (@WPID, 18, 1505.001221, -2866.783203, 117.746407, 0, 0, 0, 0, 100, 0),
  286. (@WPID, 19, 1506.119873, -2863.151855, 118.807045, 0, 0, 0, 0, 100, 0),
  287. (@WPID, 20, 1513.878296, -2865.620605, 121.673973, 0, 0, 0, 0, 100, 0),
  288. (@WPID, 21, 1527.201050, -2868.420166, 124.730896, 0, 0, 0, 0, 100, 0);
  289.  
  290. -- pathing for Felguard CGUID+24 on
  291. SET @WPID := (@CGUID+24)*10;
  292. UPDATE creature SET MovementType=2, position_x=1682.383301, position_y=-3116.470459, position_z=89.554993, currentwaypoint=0 WHERE guid = @CGUID+24;
  293. DELETE FROM creature_addon WHERE guid = @CGUID+24;
  294. INSERT INTO creature_addon (guid, path_id) VALUES (@CGUID+24, @WPID);
  295. DELETE FROM waypoint_data WHERE id=@WPID;
  296. INSERT INTO waypoint_data (id,point,position_x,position_y,position_z,orientation,delay,move_flag,action,action_chance,wpguid) VALUES
  297. (@WPID, 0, 1682.383301, -3116.470459, 89.554993, 0, 0, 0, 0, 100, 0),
  298. (@WPID, 0, 1674.620605, -3109.400146, 88.976250, 0, 0, 0, 0, 100, 0),
  299. (@WPID, 0, 1658.956787, -3095.415039, 89.265846, 0, 0, 0, 0, 100, 0),
  300. (@WPID, 0, 1653.566772, -3084.082275, 88.686615, 0, 0, 0, 0, 100, 0),
  301. (@WPID, 0, 1646.295532, -3068.169434, 88.805115, 0, 0, 0, 0, 100, 0),
  302. (@WPID, 0, 1636.780884, -3059.662109, 88.973808, 0, 0, 0, 0, 100, 0),
  303. (@WPID, 0, 1624.316528, -3060.500488, 89.142319, 0, 0, 0, 0, 100, 0),
  304. (@WPID, 0, 1617.466064, -3070.297119, 89.184601, 0, 0, 0, 0, 100, 0),
  305. (@WPID, 0, 1617.102051, -3082.547607, 89.317902, 0, 0, 0, 0, 100, 0),
  306. (@WPID, 0, 1627.488770, -3091.394531, 88.658096, 0, 0, 0, 0, 100, 0),
  307. (@WPID, 0, 1637.340332, -3094.989258, 88.381920, 0, 0, 0, 0, 100, 0),
  308. (@WPID, 0, 1650.978027, -3098.081299, 88.389397, 0, 0, 0, 0, 100, 0),
  309. (@WPID, 0, 1665.720093, -3104.706787, 88.814766, 0, 0, 0, 0, 100, 0);
  310.  
  311. -- pathing for Felguard CGUID+25 on
  312. SET @WPID := (@CGUID+25)*10;
  313. UPDATE creature SET MovementType=2, position_x=1606.020386, position_y=-2979.190918, position_z=182.066589, currentwaypoint=0 WHERE guid = @CGUID+25;
  314. DELETE FROM creature_addon WHERE guid = @CGUID+25;
  315. INSERT INTO creature_addon (guid, path_id) VALUES (@CGUID+25, @WPID);
  316. DELETE FROM waypoint_data WHERE id=@WPID;
  317. INSERT INTO waypoint_data (id,point,position_x,position_y,position_z,orientation,delay,move_flag,action,action_chance,wpguid) VALUES
  318. (@WPID, 0, 1606.020386, -2979.190918, 182.066589, 0, 0, 0, 0, 100, 0),
  319. (@WPID, 1, 1592.612793, -2967.980469, 181.734604, 0, 0, 0, 0, 100, 0),
  320. (@WPID, 2, 1584.635986, -2961.699951, 182.099609, 0, 0, 0, 0, 100, 0),
  321. (@WPID, 3, 1576.772339, -2950.720215, 182.331390, 0, 0, 0, 0, 100, 0),
  322. (@WPID, 4, 1570.186157, -2937.653564, 181.647690, 0, 0, 0, 0, 100, 0),
  323. (@WPID, 5, 1569.346313, -2915.366455, 181.606720, 0, 0, 0, 0, 100, 0),
  324. (@WPID, 6, 1567.291138, -2897.670410, 181.974411, 0, 0, 0, 0, 100, 0),
  325. (@WPID, 7, 1561.564575, -2883.124512, 183.536499, 0, 0, 0, 0, 100, 0),
  326. (@WPID, 8, 1554.509888, -2870.604492, 182.784332, 0, 0, 0, 0, 100, 0),
  327. (@WPID, 9, 1559.559570, -2883.650391, 183.535065, 0, 0, 0, 0, 100, 0),
  328. (@WPID, 10, 1565.662109, -2900.051514, 181.913925, 0, 0, 0, 0, 100, 0),
  329. (@WPID, 11, 1570.201538, -2913.283936, 181.571747, 0, 0, 0, 0, 100, 0),
  330. (@WPID, 12, 1573.806274, -2932.618896, 181.725723, 0, 0, 0, 0, 100, 0),
  331. (@WPID, 13, 1579.702026, -2949.056885, 182.503983, 0, 0, 0, 0, 100, 0),
  332. (@WPID, 14, 1586.535400, -2960.601807, 182.164642, 0, 0, 0, 0, 100, 0),
  333. (@WPID, 15, 1595.999878, -2972.899414, 181.872986, 0, 0, 0, 0, 100, 0);
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!