diff options
| author | Aokromes <Aokromes@users.noreply.github.com> | 2017-03-13 23:49:18 +0100 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2017-03-13 23:49:18 +0100 |
| commit | fd0dc53799884590057f1bbcd4bc393b95befd1f (patch) | |
| tree | c86567c42e2c8c0d0bb127ddccc970c20a1b7c53 | |
| parent | 9694d5054644ada08e5230ad9a7f22d22b40288b (diff) | |
DB/Misc: Respawn Wailling Caverns
By Malcrom, cherry pick from https://gitlab.com/trinitycore/TrinityCore_434/commit/bcd8bc3b5f99cf900823d1b6e6ef349b84c836b7
| -rw-r--r-- | sql/updates/world/master/2017_03_13_00_world.sql | 1293 |
1 files changed, 1293 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_03_13_00_world.sql b/sql/updates/world/master/2017_03_13_00_world.sql new file mode 100644 index 00000000000..be567b6949c --- /dev/null +++ b/sql/updates/world/master/2017_03_13_00_world.sql @@ -0,0 +1,1293 @@ +-- Wailing Caverns Respawn for 434 and up + +-- Remove all creature and gameobject spawns from map 43 +DELETE FROM `creature` WHERE `map`=43; +DELETE FROM `creature_addon` WHERE `guid` NOT IN (SELECT `guid` FROM `creature`); +DELETE FROM `gameobject` WHERE `map`=43; +DELETE FROM `gameobject_addon` WHERE `guid` NOT IN (SELECT `guid` FROM `gameobject`); +-- Remove old waypoints +DELETE FROM `waypoint_data` WHERE `id` IN (261970,262280,262290,262390,273680,381160,381170,859630); + +-- Respawn creatures +SET @CGUID := 251356; +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+147; +INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES +(@CGUID+0, 2914, 43, 0, 0, 1, 169, 0, 0, 0, -73.67931, 420.6615, -106.6946, 1.210923, 7200, 8, 0, 0, 0, 1, 0, 0, 0, 23420), -- Snake +(@CGUID+1, 2914, 43, 0, 0, 1, 169, 0, 0, 0, -104.0645, 14.24596, -30.69712, 4.806818, 7200, 8, 0, 0, 0, 1, 0, 0, 0, 23420), -- Snake +(@CGUID+2, 2914, 43, 0, 0, 1, 169, 0, 0, 0, -197.5728, 63.85265, -48.41077, 2.61349, 7200, 8, 0, 0, 0, 1, 0, 0, 0, 23420), -- Snake +(@CGUID+3, 2914, 43, 0, 0, 1, 169, 0, 0, 0, -32.704, 480.416, -53.63947, 2.04279, 7200, 8, 0, 0, 0, 1, 0, 0, 0, 23420), -- Snake +(@CGUID+4, 2914, 43, 0, 0, 1, 169, 0, 0, 0, 24.37071, 504.9776, -59.64296, 4.154537, 7200, 8, 0, 0, 0, 1, 0, 0, 0, 23420), -- Snake +(@CGUID+5, 2914, 43, 0, 0, 1, 169, 0, 0, 0, -28.6394, 403.019, -59.70638, 2.262305, 7200, 8, 0, 0, 0, 1, 0, 0, 0, 23420), -- Snake +(@CGUID+6, 2914, 43, 0, 0, 1, 169, 0, 0, 0, 61.63972, 404.5285, -63.65718, 5.867944, 7200, 8, 0, 0, 0, 1, 0, 0, 0, 23420), -- Snake +(@CGUID+7, 2914, 43, 0, 0, 1, 169, 0, 0, 0, -231.065, -124.8311, -68.73444, 6.069257, 7200, 8, 0, 0, 0, 1, 0, 0, 0, 23420), -- Snake +(@CGUID+8, 2914, 43, 0, 0, 1, 169, 0, 0, 0, -182.1923, -68.40418, -69.04719, 6.069533, 7200, 8, 0, 0, 0, 1, 0, 0, 0, 23420), -- Snake +(@CGUID+9, 2914, 43, 0, 0, 1, 169, 0, 0, 0, -108.3225, 451.0701, -72.35242, 2.667143, 7200, 8, 0, 0, 0, 1, 0, 0, 0, 23420), -- Snake +(@CGUID+10, 2914, 43, 0, 0, 1, 169, 0, 0, 0, -124.0861, 145.0195, -76.96492, 5.858625, 7200, 8, 0, 0, 0, 1, 0, 0, 0, 23420), -- Snake +(@CGUID+11, 2914, 43, 0, 0, 1, 169, 0, 0, 0, 14.8279, 436.269, -79.76627, 1.205349, 7200, 8, 0, 0, 0, 1, 0, 0, 0, 23420), -- Snake +(@CGUID+12, 2914, 43, 0, 0, 1, 169, 0, 0, 0, -159.1989, -23.30539, -79.89922, 4.010309, 7200, 8, 0, 0, 0, 1, 0, 0, 0, 23420), -- Snake +(@CGUID+13, 2914, 43, 0, 0, 1, 169, 0, 0, 0, -223.9117, 32.86727, -82.40759, 3.86912, 7200, 8, 0, 0, 0, 1, 0, 0, 0, 23420), -- Snake +(@CGUID+14, 2914, 43, 0, 0, 1, 169, 0, 0, 0, 24.49306, 201.1626, -85.98705, 3.516943, 7200, 8, 0, 0, 0, 1, 0, 0, 0, 23420), -- Snake +(@CGUID+15, 2914, 43, 0, 0, 1, 169, 0, 0, 0, -4.812744, 288.888, -86.32714, 1.589885, 7200, 8, 0, 0, 0, 1, 0, 0, 0, 23420), -- Snake +(@CGUID+16, 2914, 43, 0, 0, 1, 169, 0, 0, 0, -92.58604, 236.9833, -90.08727, 0.2647751, 7200, 8, 0, 0, 0, 1, 0, 0, 0, 23420), -- Snake +(@CGUID+17, 2914, 43, 0, 0, 1, 169, 0, 0, 0, -49.99936, 140.3356, -91.82742, 3.076107, 7200, 8, 0, 0, 0, 1, 0, 0, 0, 23420), -- Snake +(@CGUID+18, 2914, 43, 0, 0, 1, 169, 0, 0, 0, -48.96162, 261.0597, -92.84341, 3.848345, 7200, 8, 0, 0, 0, 1, 0, 0, 0, 23420), -- Snake +(@CGUID+19, 2914, 43, 0, 0, 1, 169, 0, 0, 0, -54.80602, 207.1797, -95.56145, 0.07834069, 7200, 8, 0, 0, 0, 1, 0, 0, 0, 23420), -- Snake +(@CGUID+20, 2914, 43, 0, 0, 1, 169, 0, 0, 0, -330.8086, 37.66679, -98.90787, 2.155895, 7200, 8, 0, 0, 0, 1, 0, 0, 0, 23420), -- Snake +(@CGUID+21, 3636, 43, 0, 0, 1, 169, 0, 0, 0, -100.2117, 176.6424, -78.26765, 1.682256, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Deviate Ravager +(@CGUID+22, 3636, 43, 0, 0, 1, 169, 0, 0, 0, 12.48172, 219.8981, -84.44294, 4.618538, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Deviate Ravager +(@CGUID+23, 3636, 43, 0, 0, 1, 169, 0, 0, 0, 10.38349, 164.2322, -87.06343, 0.7550651, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Deviate Ravager +(@CGUID+24, 3636, 43, 0, 0, 1, 169, 0, 0, 0, 12.08692, 292.0923, -87.38432, 5.120402, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Deviate Ravager +(@CGUID+25, 3636, 43, 0, 0, 1, 169, 0, 0, 0, -67.0853, 106.0318, -87.97977, 5.541047, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Deviate Ravager +(@CGUID+26, 3636, 43, 0, 0, 1, 169, 0, 0, 0, 35.82772, 173.3852, -88.13145, 3.403509, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Deviate Ravager +(@CGUID+27, 3636, 43, 0, 0, 1, 169, 0, 0, 0, -10.51967, 311.0385, -88.82507, 2.444808, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Deviate Ravager +(@CGUID+28, 3636, 43, 0, 0, 1, 169, 0, 0, 0, 43.68515, 183.6451, -88.84095, 3.549604, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Deviate Ravager +(@CGUID+29, 3636, 43, 0, 0, 1, 169, 0, 0, 0, -71.30095, 131.119, -90.68638, 5.03005, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Deviate Ravager +(@CGUID+30, 3636, 43, 0, 0, 1, 169, 0, 0, 0, 57.49295, 203.9019, -90.92781, 2.43705, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Deviate Ravager +(@CGUID+31, 3636, 43, 0, 0, 1, 169, 0, 0, 0, -72.67171, 215.7663, -93.64778, 3.027206, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Deviate Ravager +(@CGUID+32, 3636, 43, 0, 0, 1, 169, 0, 0, 0, -74.75412, 197.9379, -94.01486, 3.666669, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Deviate Ravager +(@CGUID+33, 3636, 43, 0, 0, 1, 169, 0, 0, 0, -34.86536, 210.588, -96.18216, 0.6998679, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Deviate Ravager +(@CGUID+34, 3636, 43, 0, 0, 1, 169, 0, 0, 0, -35.42626, 199.2598, -96.52907, 4.551266, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Deviate Ravager +(@CGUID+35, 3637, 43, 0, 0, 1, 169, 0, 0, 0, 29.8653, 273.4837, -87.50578, 4.480185, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Deviate Guardian +(@CGUID+36, 3637, 43, 0, 0, 1, 169, 0, 0, 0, 43.29142, 241.8688, -88.39811, 4.364803, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Deviate Guardian +(@CGUID+37, 3637, 43, 0, 0, 1, 169, 0, 0, 0, 7.071762, 309.3661, -88.46037, 4.933427, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Deviate Guardian +(@CGUID+38, 3637, 43, 0, 0, 1, 169, 0, 0, 0, -54.402, 119.2589, -89.68297, 6.011304, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Deviate Guardian +(@CGUID+39, 3637, 43, 0, 0, 1, 169, 0, 0, 0, -24.97285, 96.8386, -90.75201, 4.793438, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Deviate Guardian +(@CGUID+40, 3637, 43, 0, 0, 1, 169, 0, 0, 0, -28.36492, 83.02499, -91.13417, 1.382047, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Deviate Guardian +(@CGUID+41, 3637, 43, 0, 0, 1, 169, 0, 0, 0, -103.4776, 232.4949, -91.19962, 5.038105, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Deviate Guardian +(@CGUID+42, 3637, 43, 0, 0, 1, 169, 0, 0, 0, -107.2633, 240.4962, -92.82172, 4.480357, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Deviate Guardian +(@CGUID+43, 3637, 43, 0, 0, 1, 169, 0, 0, 0, -50.25224, 254.7813, -92.84426, 3.949239, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Deviate Guardian +(@CGUID+44, 3637, 43, 0, 0, 1, 169, 0, 0, 0, -36.71439, 166.5333, -96.11585, 1.055925, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Deviate Guardian +(@CGUID+45, 3640, 43, 0, 0, 1, 169, 0, 0, 0, -28.1643, 264.5858, -103.9536, 5.028664, 7200, 0, 0, 0, 0, 2, 0, 0, 0, 23420), -- Evolving Ectoplasm +(@CGUID+46, 3640, 43, 0, 0, 1, 169, 0, 0, 0, -221.7053, 33.50206, -82.56806, 0.6992227, 7200, 0, 0, 0, 0, 2, 0, 0, 0, 23420), -- Evolving Ectoplasm +(@CGUID+47, 3640, 43, 0, 0, 1, 169, 0, 0, 0, 59.40158, 207.6472, -91.53204, 6.237575, 7200, 0, 0, 0, 0, 2, 0, 0, 0, 23420), -- Evolving Ectoplasm +(@CGUID+48, 3640, 43, 0, 0, 1, 169, 0, 0, 0, -75.84928, 193.6929, -94.17282, 1.155927, 7200, 0, 0, 0, 0, 2, 0, 0, 0, 23420), -- Evolving Ectoplasm +(@CGUID+49, 3640, 43, 0, 0, 1, 169, 0, 0, 0, -37.85418, 156.0181, -94.92673, 1.330037, 7200, 0, 0, 0, 0, 2, 0, 0, 0, 23420), -- Evolving Ectoplasm +(@CGUID+50, 3653, 43, 0, 0, 1, 169, 0, 0, 0, -10.16325, 243.124, -106.2547, 4.822796, 36000, 0, 0, 0, 0, 2, 0, 0, 0, 23420), -- Kresh +(@CGUID+51, 3669, 43, 0, 0, 1, 169, 0, 0, 1, -151.139, 414.367, -72.62946, 0.2792527, 36000, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- Lord Cobrahn <Fanglord> +(@CGUID+52, 3670, 43, 0, 0, 1, 169, 0, 0, 1, -45.4295, 372.129, -60.03519, 0.1919862, 36000, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- Lord Pythas <Fanglord> +(@CGUID+53, 3671, 43, 0, 0, 1, 169, 0, 0, 1, -55.2565, 274.696, -92.76086, 4.694936, 36000, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- Lady Anacondra <Fanglord> +(@CGUID+54, 3673, 43, 0, 0, 1, 169, 0, 0, 1, -121.4593, -23.9338, -28.62341, 2.7089, 36000, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Lord Serpentis <Fanglord> +(@CGUID+55, 3674, 43, 0, 0, 1, 169, 0, 0, 0, -231.4561, -8.972868, -105.6646, 1.198651, 36000, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Skum +(@CGUID+56, 3678, 43, 0, 0, 1, 169, 0, 0, 1, -134.965, 125.402, -78.09447, 3.071779, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- Muyoh <Disciple of Naralex> +(@CGUID+57, 3679, 43, 0, 0, 1, 169, 0, 0, 0, 115.408, 240.017, -94.02106, 3.089233, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- Naralex +(@CGUID+58, 3835, 43, 0, 0, 1, 169, 0, 0, 0, -17.32755, 248.2506, -105.1388, 1.329349, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Biletoad +(@CGUID+59, 3835, 43, 0, 0, 1, 169, 0, 0, 0, -196.6245, 10.72025, -105.3634, 2.7534, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Biletoad +(@CGUID+60, 3835, 43, 0, 0, 1, 169, 0, 0, 0, -68.13896, 366.376, -105.5418, 0.5632124, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Biletoad +(@CGUID+61, 3835, 43, 0, 0, 1, 169, 0, 0, 0, -24.65123, 143.7358, -105.6621, 0.8664265, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Biletoad +(@CGUID+62, 3835, 43, 0, 0, 1, 169, 0, 0, 0, -274.7464, -7.221687, -106.1428, 4.439471, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Biletoad +(@CGUID+63, 3835, 43, 0, 0, 1, 169, 0, 0, 0, -155.1277, 22.66277, -106.1449, 5.703492, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Biletoad +(@CGUID+64, 3835, 43, 0, 0, 1, 169, 0, 0, 0, -153.6687, 54.69098, -106.1783, 1.751566, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Biletoad +(@CGUID+65, 3835, 43, 0, 0, 1, 169, 0, 0, 0, -247.4379, 3.280792, -106.7141, 5.891573, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Biletoad +(@CGUID+66, 3835, 43, 0, 0, 1, 169, 0, 0, 0, -42.1403, 44.5201, -118.6927, 0.6283185, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Biletoad +(@CGUID+67, 3835, 43, 0, 0, 1, 169, 0, 0, 0, -81.80109, 202.8367, -93.29029, 2.421522, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Biletoad +(@CGUID+68, 3840, 43, 0, 0, 1, 169, 0, 0, 1, -352.826, 43.2932, -100.0827, 0.7330383, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- Druid of the Fang +(@CGUID+69, 3840, 43, 0, 0, 1, 169, 0, 0, 1, -352.573, 22.6263, -100.8317, 4.066617, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- Druid of the Fang +(@CGUID+70, 3840, 43, 0, 0, 1, 169, 0, 0, 1, -102.14, -8.77391, -29.11847, 6.038839, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- Druid of the Fang +(@CGUID+71, 3840, 43, 0, 0, 1, 169, 0, 0, 1, -191.7307, 59.28593, -47.87016, 3.144585, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Druid of the Fang +(@CGUID+72, 3840, 43, 0, 0, 1, 169, 0, 0, 1, -28.16513, 482.6865, -53.56472, 4.101688, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Druid of the Fang +(@CGUID+73, 3840, 43, 0, 0, 1, 169, 0, 0, 1, -34.01695, 476.0291, -53.79193, 4.25467, 7200, 0, 0, 0, 0, 2, 0, 0, 0, 23420), -- Druid of the Fang +(@CGUID+74, 3840, 43, 0, 0, 1, 169, 0, 0, 1, 25.1877, 530.925, -56.88427, 5.183628, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- Druid of the Fang +(@CGUID+75, 3840, 43, 0, 0, 1, 169, 0, 0, 1, 17.55117, 514.087, -57.38828, 2.541126, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Druid of the Fang +(@CGUID+76, 3840, 43, 0, 0, 1, 169, 0, 0, 1, -41.57908, 373.6684, -60.11828, 3.351032, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- Druid of the Fang +(@CGUID+77, 3840, 43, 0, 0, 1, 169, 0, 0, 1, -6.437517, 419.7792, -65.78355, 5.138189, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Druid of the Fang +(@CGUID+78, 3840, 43, 0, 0, 1, 169, 0, 0, 1, 39.79415, 472.2027, -66.08891, 3.517632, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Druid of the Fang +(@CGUID+79, 3840, 43, 0, 0, 1, 169, 0, 0, 1, -177.5664, -91.30263, -68.78654, 4.587365, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Druid of the Fang +(@CGUID+80, 3840, 43, 0, 0, 1, 169, 0, 0, 1, -113.844, 458.776, -72.05576, 4.852015, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- Druid of the Fang +(@CGUID+81, 3840, 43, 0, 0, 1, 169, 0, 0, 1, -127.469, 410.479, -72.64197, 1.082104, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- Druid of the Fang +(@CGUID+82, 3840, 43, 0, 0, 1, 169, 0, 0, 1, -106.0412, 446.7015, -72.94868, 5.567612, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Druid of the Fang +(@CGUID+83, 3840, 43, 0, 0, 1, 169, 0, 0, 1, -145.986, -50.8781, -78.39407, 1.466077, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- Druid of the Fang +(@CGUID+84, 3840, 43, 0, 0, 1, 169, 0, 0, 1, -216.3617, 46.49947, -82.26854, 3.43307, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Druid of the Fang +(@CGUID+85, 3840, 43, 0, 0, 1, 169, 0, 0, 1, 29.072, 260.6602, -87.45145, 1.641315, 7200, 0, 0, 0, 0, 2, 0, 0, 0, 23420), -- Druid of the Fang +(@CGUID+86, 3840, 43, 0, 0, 1, 169, 0, 0, 1, -265.864, 43.1378, -87.66426, 4.886922, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- Druid of the Fang +(@CGUID+87, 3840, 43, 0, 0, 1, 169, 0, 0, 1, 46.28596, 207.0079, -88.45377, 3.448321, 7200, 0, 0, 0, 0, 2, 0, 0, 0, 23420), -- Druid of the Fang +(@CGUID+88, 3840, 43, 0, 0, 1, 169, 0, 0, 1, -48.61956, 283.9542, -92.84147, 5.455996, 7200, 0, 0, 0, 0, 2, 0, 0, 0, 23420), -- Druid of the Fang +(@CGUID+89, 5048, 43, 0, 0, 1, 169, 0, 0, 0, -22.78947, 484.3914, -54.69827, 2.562443, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Deviate Adder +(@CGUID+90, 5048, 43, 0, 0, 1, 169, 0, 0, 0, 25.00511, 522.184, -57.39327, 3.258614, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Deviate Adder +(@CGUID+91, 5048, 43, 0, 0, 1, 169, 0, 0, 0, 64.23395, 436.4411, -64.42556, 5.601123, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Deviate Adder +(@CGUID+92, 5048, 43, 0, 0, 1, 169, 0, 0, 0, -81.59805, 472.3564, -67.3652, 3.324751, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Deviate Adder +(@CGUID+93, 5048, 43, 0, 0, 1, 169, 0, 0, 0, -123.5253, 412.012, -72.74917, 1.686077, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Deviate Adder +(@CGUID+94, 5048, 43, 0, 0, 1, 169, 0, 0, 0, -109.1943, 423.3405, -73.58447, 4.469263, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Deviate Adder +(@CGUID+95, 5053, 43, 0, 0, 1, 169, 0, 0, 0, -187.3228, 22.72583, -105.7797, 2.983845, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Deviate Crocolisk +(@CGUID+96, 5053, 43, 0, 0, 1, 169, 0, 0, 0, -161.8033, 50.97922, -106.0229, 1.092331, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Deviate Crocolisk +(@CGUID+97, 5053, 43, 0, 0, 1, 169, 0, 0, 0, -52.01678, 79.91978, -106.1616, 2.579498, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Deviate Crocolisk +(@CGUID+98, 5053, 43, 0, 0, 1, 169, 0, 0, 0, -6.153833, 163.5685, -106.1616, 1.18284, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Deviate Crocolisk +(@CGUID+99, 5053, 43, 0, 0, 1, 169, 0, 0, 0, -13.5063, 155.2692, -106.1616, 1.292537, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Deviate Crocolisk +(@CGUID+100, 5053, 43, 0, 0, 1, 169, 0, 0, 0, -4.852186, 213.672, -106.1616, 5.425306, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Deviate Crocolisk +(@CGUID+101, 5053, 43, 0, 0, 1, 169, 0, 0, 0, -191.9146, -4.470617, -106.1649, 4.16435, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Deviate Crocolisk +(@CGUID+102, 5053, 43, 0, 0, 1, 169, 0, 0, 0, -169.3843, -0.5683166, -106.3034, 3.674854, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Deviate Crocolisk +(@CGUID+103, 5053, 43, 0, 0, 1, 169, 0, 0, 0, -79.10059, 419.7593, -106.3487, 2.244363, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Deviate Crocolisk +(@CGUID+104, 5053, 43, 0, 0, 1, 169, 0, 0, 0, -44.76146, 307.8306, -106.417, 4.041427, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Deviate Crocolisk +(@CGUID+105, 5053, 43, 0, 0, 1, 169, 0, 0, 0, -275.8047, -3.98806, -106.6052, 1.949403, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Deviate Crocolisk +(@CGUID+106, 5053, 43, 0, 0, 1, 169, 0, 0, 0, -154.3737, 24.10921, -106.6483, 3.586392, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Deviate Crocolisk +(@CGUID+107, 5055, 43, 0, 0, 1, 169, 0, 0, 0, -179.6935, 60.28014, -43.99161, 2.54476, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Deviate Lasher +(@CGUID+108, 5055, 43, 0, 0, 1, 169, 0, 0, 0, -186.5182, 61.39632, -46.66034, 4.956359, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Deviate Lasher +(@CGUID+109, 5055, 43, 0, 0, 1, 169, 0, 0, 0, -190.6157, 68.08149, -47.5529, 0.307093, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Deviate Lasher +(@CGUID+110, 5055, 43, 0, 0, 1, 169, 0, 0, 0, -195.1692, 65.3213, -48.08265, 2.713503, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Deviate Lasher +(@CGUID+111, 5055, 43, 0, 0, 1, 169, 0, 0, 0, -154.7486, 64.70844, -75.85052, 0.3552516, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Deviate Lasher +(@CGUID+112, 5055, 43, 0, 0, 1, 169, 0, 0, 0, -159.0344, 73.36934, -76.02182, 1.388302, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Deviate Lasher +(@CGUID+113, 5055, 43, 0, 0, 1, 169, 0, 0, 0, -159.2178, 74.2029, -76.04297, 4.937287, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Deviate Lasher +(@CGUID+114, 5055, 43, 0, 0, 1, 169, 0, 0, 0, -157.4265, -54.60183, -76.47823, 1.916837, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Deviate Lasher +(@CGUID+115, 5055, 43, 0, 0, 1, 169, 0, 0, 0, -160.1721, -47.67885, -78.03413, 1.896472, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Deviate Lasher +(@CGUID+116, 5055, 43, 0, 0, 1, 169, 0, 0, 0, -154.4003, -47.52888, -78.83052, 3.693749, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Deviate Lasher +(@CGUID+117, 5055, 43, 0, 0, 1, 169, 0, 0, 0, -154.5238, -41.75082, -79.90639, 4.228436, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Deviate Lasher +(@CGUID+118, 5056, 43, 0, 0, 1, 169, 0, 0, 0, -182.6078, -100.504, -71.28766, 1.093767, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Deviate Dreadfang +(@CGUID+119, 5755, 43, 0, 0, 1, 169, 0, 0, 0, -9.610677, 497.3225, -55.95895, 5.493893, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Deviate Viper +(@CGUID+120, 5755, 43, 0, 0, 1, 169, 0, 0, 0, -32.12434, 409.9823, -60.0445, 3.401996, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Deviate Viper +(@CGUID+121, 5755, 43, 0, 0, 1, 169, 0, 0, 0, -96.43479, 460.2216, -71.09651, 5.089828, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Deviate Viper +(@CGUID+122, 5755, 43, 0, 0, 1, 169, 0, 0, 0, 5.559616, 453.529, -77.71029, 6.120566, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Deviate Viper +(@CGUID+123, 5755, 43, 0, 0, 1, 169, 0, 0, 0, 12.48394, 442.4933, -79.46635, 1.90527, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Deviate Viper +(@CGUID+124, 5755, 43, 0, 0, 1, 169, 0, 0, 0, 19.11097, 437.5753, -81.63353, 1.427604, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Deviate Viper +(@CGUID+125, 5756, 43, 0, 0, 1, 169, 0, 0, 0, -113.0395, -19.22248, -28.45448, 4.949541, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Deviate Venomwing +(@CGUID+126, 5756, 43, 0, 0, 1, 169, 0, 0, 0, -148.4733, 8.134885, -28.76561, 2.03968, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Deviate Venomwing +(@CGUID+127, 5756, 43, 0, 0, 1, 169, 0, 0, 0, -173.6571, 55.75408, -41.81582, 0.02077551, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Deviate Venomwing +(@CGUID+128, 5756, 43, 0, 0, 1, 169, 0, 0, 0, -193.8146, 42.60534, -48.00163, 5.903528, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Deviate Venomwing +(@CGUID+129, 5761, 43, 0, 0, 1, 169, 0, 0, 0, -345.5748, 22.31182, -101.3851, 2.412089, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Deviate Shambler +(@CGUID+130, 5761, 43, 0, 0, 1, 169, 0, 0, 0, -310.3561, -73.41083, -58.39107, 1.739915, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Deviate Shambler +(@CGUID+131, 5761, 43, 0, 0, 1, 169, 0, 0, 0, -174.2792, -81.2423, -67.73909, 3.629687, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Deviate Shambler +(@CGUID+132, 5761, 43, 0, 0, 1, 169, 0, 0, 0, -185.7246, 84.78967, -79.5341, 3.85371, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Deviate Shambler +(@CGUID+133, 5761, 43, 0, 0, 1, 169, 0, 0, 0, -220.9246, 49.4038, -82.28786, 3.278864, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Deviate Shambler +(@CGUID+134, 5761, 43, 0, 0, 1, 169, 0, 0, 0, -264.4156, 38.49258, -87.5004, 1.166698, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Deviate Shambler +(@CGUID+135, 5761, 43, 0, 0, 1, 169, 0, 0, 0, -334.2695, 51.54135, -97.62621, 5.52335, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Deviate Shambler +(@CGUID+136, 5767, 43, 0, 0, 1, 169, 0, 0, 0, -150.298, 123.82, -75.95126, 3.228859, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- Nalpak <Disciple of Naralex> +(@CGUID+137, 5768, 43, 0, 0, 1, 169, 0, 0, 0, -155.661, 123.652, -75.02277, 0.4712389, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- Ebru <Disciple of Naralex> +(@CGUID+138, 5775, 43, 0, 0, 1, 169, 0, 0, 0, -81.8554, 32.2565, -30.99387, 3.717551, 36000, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- Verdan the Everliving +(@CGUID+139, 8886, 43, 0, 0, 1, 169, 0, 0, 0, -47.47794, 472.0314, -56.04327, 0.0807288, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Deviate Python +(@CGUID+140, 8886, 43, 0, 0, 1, 169, 0, 0, 0, -50.3617, 470.879, -56.48037, 4.18879, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Deviate Python +(@CGUID+141, 8886, 43, 0, 0, 1, 169, 0, 0, 0, 51.6963, 398.9913, -63.01192, 1.3772, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Deviate Python +(@CGUID+142, 8886, 43, 0, 0, 1, 169, 0, 0, 0, 54.37276, 398.5613, -63.34044, 6.060828, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Deviate Python +(@CGUID+143, 8886, 43, 0, 0, 1, 169, 0, 0, 0, 42.58004, 478.3776, -65.894, 0.4434692, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Deviate Python +(@CGUID+144, 8886, 43, 0, 0, 1, 169, 0, 0, 0, 41.13884, 477.613, -65.98799, 0.5059137, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Deviate Python +(@CGUID+145, 8886, 43, 0, 0, 1, 169, 0, 0, 0, -112.0837, 436.561, -72.74306, 3.944444, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Deviate Python +(@CGUID+146, 8886, 43, 0, 0, 1, 169, 0, 0, 0, -111.0837, 437.561, -72.89251, 0, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420), -- Deviate Python +(@CGUID+147, 8886, 43, 0, 0, 1, 169, 0, 0, 0, -107.0723, 438.7996, -73.45597, 0.07906317, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 23420); -- Deviate Python + +-- Pathing for Evolving Ectoplasm Entry: 3640 +SET @NPC := @CGUID+45; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-18.36656,`position_y`=237.1451,`position_z`=-104.6986 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,-18.36656,237.1451,-104.6986,0,0,0,0,100,0), +(@PATH,2,-20.84786,223.9143,-103.5667,0,0,0,0,100,0), +(@PATH,3,-18.64024,211.6221,-100.9711,0,0,0,0,100,0), +(@PATH,4,-19.43174,198.0965,-99.49261,0,0,0,0,100,0), +(@PATH,5,-22.92796,183.2505,-103.7,0,0,0,0,100,0), +(@PATH,6,-20.87972,173.0558,-104.4787,0,0,0,0,100,0), +(@PATH,7,-24.15551,159.7794,-104.7302,0,0,0,0,100,0), +(@PATH,8,-20.87972,173.0558,-104.4787,0,0,0,0,100,0), +(@PATH,9,-22.92796,183.2505,-103.7,0,0,0,0,100,0), +(@PATH,10,-19.43174,198.0965,-99.49261,0,0,0,0,100,0), +(@PATH,11,-18.64024,211.6221,-100.9711,0,0,0,0,100,0), +(@PATH,12,-20.87055,223.7933,-103.529,0,0,0,0,100,0), +(@PATH,13,-18.36656,237.1451,-104.6986,0,0,0,0,100,0), +(@PATH,14,-23.89342,251.5354,-103.8434,0,0,0,0,100,0), +(@PATH,15,-29.10409,267.4575,-103.9182,0,0,0,0,100,0), +(@PATH,16,-23.89342,251.5354,-103.8434,0,0,0,0,100,0); + +-- Pathing for Evolving Ectoplasm Entry: 3640 +SET @NPC := @CGUID+46; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-198.255,`position_y`=72.45628,`position_z`=-82.10934 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,-198.255,72.45628,-82.10934,0,0,0,0,100,0), +(@PATH,2,-182.9165,91.50218,-79.18651,0,0,0,0,100,0), +(@PATH,3,-165.2366,88.79789,-76.27708,0,0,0,0,100,0), +(@PATH,4,-152.1447,67.6943,-75.89945,0,0,0,0,100,0), +(@PATH,5,-144.4762,41.93512,-75.61282,0,0,0,0,100,0), +(@PATH,6,-139.7413,7.651493,-74.07117,0,0,0,0,100,0), +(@PATH,7,-134.5127,-31.89405,-77.03525,0,0,0,0,100,0), +(@PATH,8,-137.0313,-47.70085,-78.75781,0,0,0,0,100,0), +(@PATH,9,-171.5201,-61.79093,-72.31229,0,0,0,0,100,0), +(@PATH,10,-137.0663,-47.92054,-78.71201,0,0,0,0,100,0), +(@PATH,11,-134.5127,-31.89405,-77.03525,0,0,0,0,100,0), +(@PATH,12,-139.7413,7.651493,-74.07117,0,0,0,0,100,0), +(@PATH,13,-144.4762,41.93512,-75.61282,0,0,0,0,100,0), +(@PATH,14,-152.1447,67.6943,-75.89945,0,0,0,0,100,0), +(@PATH,15,-165.2366,88.79789,-76.27708,0,0,0,0,100,0), +(@PATH,16,-182.9165,91.50218,-79.18651,0,0,0,0,100,0), +(@PATH,17,-198.255,72.45628,-82.10934,0,0,0,0,100,0), +(@PATH,18,-196.6794,54.5479,-81.97962,0,0,0,0,100,0), +(@PATH,19,-222.4752,32.85463,-82.51939,0,0,0,0,100,0), +(@PATH,20,-238.2878,45.22714,-83.58209,0,0,0,0,100,0), +(@PATH,21,-265.329,36.07661,-87.61066,0,0,0,0,100,0), +(@PATH,22,-282.8066,36.64764,-89.50124,0,0,0,0,100,0), +(@PATH,23,-293.7619,48.11871,-91.95084,0,0,0,0,100,0), +(@PATH,24,-315.0803,50.34423,-95.0612,0,0,0,0,100,0), +(@PATH,25,-338.2149,53.24298,-98.1432,0,0,0,0,100,0), +(@PATH,26,-352.9296,44.81674,-100.1064,0,0,0,0,100,0), +(@PATH,27,-349.8972,26.99571,-100.726,0,0,0,0,100,0), +(@PATH,28,-338.2655,21.34499,-101.8724,0,0,0,0,100,0), +(@PATH,29,-313.0423,14.40638,-106.1583,0,0,0,0,100,0), +(@PATH,30,-292.9789,13.12129,-105.7609,0,0,0,0,100,0), +(@PATH,31,-313.0423,14.40638,-106.1583,0,0,0,0,100,0), +(@PATH,32,-338.2329,21.33602,-101.8768,0,0,0,0,100,0), +(@PATH,33,-349.8972,26.99571,-100.726,0,0,0,0,100,0), +(@PATH,34,-352.9296,44.81674,-100.1064,0,0,0,0,100,0), +(@PATH,35,-338.2149,53.24298,-98.1432,0,0,0,0,100,0), +(@PATH,36,-315.0803,50.34423,-95.0612,0,0,0,0,100,0), +(@PATH,37,-293.7619,48.11871,-91.95084,0,0,0,0,100,0), +(@PATH,38,-282.8066,36.64764,-89.50124,0,0,0,0,100,0), +(@PATH,39,-265.329,36.07661,-87.61066,0,0,0,0,100,0), +(@PATH,40,-238.2878,45.22714,-83.58209,0,0,0,0,100,0), +(@PATH,41,-222.4752,32.85463,-82.51939,0,0,0,0,100,0), +(@PATH,42,-196.6794,54.5479,-81.97962,0,0,0,0,100,0); + +-- Pathing for Evolving Ectoplasm Entry: 3640 +SET @NPC := @CGUID+47; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=84.90855,`position_y`=216.3137,`position_z`=-93.10664 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,84.90855,216.3137,-93.10664,0,0,0,0,100,0), +(@PATH,2,87.94112,230.6553,-95.38218,0,0,0,0,100,0), +(@PATH,3,97.88228,239.1089,-95.79476,0,0,0,0,100,0), +(@PATH,4,107.4261,237.0739,-95.94029,0,0,0,0,100,0), +(@PATH,5,97.99002,239.0859,-95.76952,0,0,0,0,100,0), +(@PATH,6,87.94112,230.6553,-95.38218,0,0,0,0,100,0), +(@PATH,7,84.90855,216.3137,-93.10664,0,0,0,0,100,0), +(@PATH,8,70.94514,207.1204,-93.16679,0,0,0,0,100,0), +(@PATH,9,47.71502,208.1806,-88.53457,0,0,0,0,100,0), +(@PATH,10,48.6155,217.8021,-88.43818,0,0,0,0,100,0), +(@PATH,11,47.6367,228.4073,-88.0354,0,0,0,0,100,0), +(@PATH,12,48.6155,217.8021,-88.43818,0,0,0,0,100,0), +(@PATH,13,47.71502,208.1806,-88.53457,0,0,0,0,100,0), +(@PATH,14,70.94514,207.1204,-93.16679,0,0,0,0,100,0); + +-- Pathing for Evolving Ectoplasm Entry: 3640 +SET @NPC := @CGUID+48; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-68.15238,`position_y`=203.4326,`position_z`=-93.63982 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,-68.15238,203.4326,-93.63982,0,0,0,0,100,0), +(@PATH,2,-69.96104,212.7071,-93.47763,0,0,0,0,100,0), +(@PATH,3,-78.7136,218.9873,-94.076,0,0,0,0,100,0), +(@PATH,4,-85.66427,225.0372,-93.20435,0,0,0,0,100,0), +(@PATH,5,-100.6683,231.587,-91.4147,0,0,0,0,100,0), +(@PATH,6,-110.2681,230.0052,-90.44129,0,0,0,0,100,0), +(@PATH,7,-111.4426,214.0117,-85.23394,0,0,0,0,100,0), +(@PATH,8,-108.9862,203.9377,-81.96421,0,0,0,0,100,0), +(@PATH,9,-111.4426,214.0117,-85.23394,0,0,0,0,100,0), +(@PATH,10,-110.2681,230.0052,-90.44129,0,0,0,0,100,0), +(@PATH,11,-100.7079,231.5805,-91.42664,0,0,0,0,100,0), +(@PATH,12,-85.83381,225.111,-93.18362,0,0,0,0,100,0), +(@PATH,13,-78.7136,218.9873,-94.076,0,0,0,0,100,0), +(@PATH,14,-69.96104,212.7071,-93.47763,0,0,0,0,100,0), +(@PATH,15,-68.15238,203.4326,-93.63982,0,0,0,0,100,0), +(@PATH,16,-75.29012,194.9624,-94.12358,0,0,0,0,100,0), +(@PATH,17,-79.79214,184.7406,-92.52055,0,0,0,0,100,0), +(@PATH,18,-75.41418,194.6808,-94.18338,0,0,0,0,100,0); + +-- Pathing for Evolving Ectoplasm Entry: 3640 +SET @NPC := @CGUID+49; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-36.70774,`position_y`=192.4791,`position_z`=-96.53302 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,-36.70774,192.4791,-96.53302,0,0,0,0,100,0), +(@PATH,2,-34.87535,209.691,-96.33681,0,0,0,0,100,0), +(@PATH,3,-32.35036,228.2435,-95.00108,0,0,0,0,100,0), +(@PATH,4,-32.65139,242.2984,-93.67757,0,0,0,0,100,0), +(@PATH,5,-39.46074,256.1018,-92.82808,0,0,0,0,100,0), +(@PATH,6,-40.50264,274.8232,-92.45362,0,0,0,0,100,0), +(@PATH,7,-50.13834,288.5907,-92.04959,0,0,0,0,100,0), +(@PATH,8,-57.49891,294.4713,-90.37098,0,0,0,0,100,0), +(@PATH,9,-50.13834,288.5907,-92.04959,0,0,0,0,100,0), +(@PATH,10,-40.50264,274.8232,-92.45362,0,0,0,0,100,0), +(@PATH,11,-39.46074,256.1018,-92.82808,0,0,0,0,100,0), +(@PATH,12,-32.65139,242.2984,-93.67757,0,0,0,0,100,0), +(@PATH,13,-32.35036,228.2435,-95.00108,0,0,0,0,100,0), +(@PATH,14,-34.85421,209.8463,-96.28882,0,0,0,0,100,0), +(@PATH,15,-36.70774,192.4791,-96.53302,0,0,0,0,100,0), +(@PATH,16,-32.68425,177.075,-96.30675,0,0,0,0,100,0), +(@PATH,17,-37.85418,156.0181,-94.92673,0,0,0,0,100,0), +(@PATH,18,-47.68815,140.247,-91.79289,0,0,0,0,100,0), +(@PATH,19,-55.20058,122.0114,-89.65307,0,0,0,0,100,0), +(@PATH,20,-47.68815,140.247,-91.79289,0,0,0,0,100,0), +(@PATH,21,-37.85418,156.0181,-94.92673,0,0,0,0,100,0), +(@PATH,22,-32.68425,177.075,-96.30675,0,0,0,0,100,0); + +-- Pathing for Kresh Entry: 3653 +SET @NPC := @CGUID+50; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-7.588415,`position_y`=198.7583,`position_z`=-106.1616 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,-7.588415,198.7583,-106.1616,0,0,0,0,100,0), +(@PATH,2,-9.523249,177.1504,-106.1616,0,0,0,0,100,0), +(@PATH,3,-15.00114,152.9393,-106.1616,0,0,0,0,100,0), +(@PATH,4,-30.40358,125.223,-106.1616,0,0,0,0,100,0), +(@PATH,5,-47.30081,101.7705,-106.1616,0,0,0,0,100,0), +(@PATH,6,-54.94191,87.54874,-106.1616,0,0,0,0,100,0), +(@PATH,7,-54.95378,80.29885,-106.1616,0,0,0,0,100,0), +(@PATH,8,-62.95473,72.42611,-106.1616,0,0,0,0,100,0), +(@PATH,9,-66.87977,71.69714,-106.1616,0,0,0,0,100,0), +(@PATH,10,-79.25047,72.32791,-106.1616,0,0,0,0,100,0), +(@PATH,11,-91.98399,64.63467,-106.1275,0,0,0,0,100,0), +(@PATH,12,-116.3778,72.32365,-106.3697,0,0,0,0,100,0), +(@PATH,13,-142.6239,70.87032,-105.8755,0,0,0,0,100,0), +(@PATH,14,-156.461,48.08625,-106.641,0,0,0,0,100,0), +(@PATH,15,-154.1038,30.25687,-106.4851,0,0,0,0,100,0), +(@PATH,16,-156.1303,4.531762,-106.0462,0,0,0,0,100,0), +(@PATH,17,-190.1396,-8.973672,-106.2344,0,0,0,0,100,0), +(@PATH,18,-156.1303,4.531762,-106.0462,0,0,0,0,100,0), +(@PATH,19,-154.102,30.24315,-106.3861,0,0,0,0,100,0), +(@PATH,20,-156.461,48.08625,-106.641,0,0,0,0,100,0), +(@PATH,21,-142.6239,70.87032,-105.8755,0,0,0,0,100,0), +(@PATH,22,-116.3778,72.32365,-106.3697,0,0,0,0,100,0), +(@PATH,23,-91.98399,64.63467,-106.1275,0,0,0,0,100,0), +(@PATH,24,-79.25047,72.32791,-106.1616,0,0,0,0,100,0), +(@PATH,25,-66.87977,71.69714,-106.1616,0,0,0,0,100,0), +(@PATH,26,-62.95473,72.42611,-106.1616,0,0,0,0,100,0), +(@PATH,27,-54.95378,80.29885,-106.1616,0,0,0,0,100,0), +(@PATH,28,-54.94191,87.54874,-106.1616,0,0,0,0,100,0), +(@PATH,29,-47.30081,101.7705,-106.1616,0,0,0,0,100,0), +(@PATH,30,-30.40358,125.223,-106.1616,0,0,0,0,100,0), +(@PATH,31,-15.00114,152.9393,-106.1616,0,0,0,0,100,0), +(@PATH,32,-9.523249,177.1504,-106.1616,0,0,0,0,100,0), +(@PATH,33,-7.588415,198.7583,-106.1616,0,0,0,0,100,0), +(@PATH,34,-7.558329,219.6261,-106.1616,0,0,0,0,100,0), +(@PATH,35,-10.38575,245.1311,-106.2873,0,0,0,0,100,0), +(@PATH,36,-18.97365,270.1935,-106.417,0,0,0,0,100,0), +(@PATH,37,-30.55159,288.4883,-106.417,0,0,0,0,100,0), +(@PATH,38,-40.54165,302.8161,-106.417,0,0,0,0,100,0), +(@PATH,39,-57.82487,314.0065,-106.7489,0,0,0,0,100,0), +(@PATH,40,-74.29018,324.0769,-106.1616,0,0,0,0,100,0), +(@PATH,41,-77.92536,332.0374,-106.1616,0,0,0,0,100,0), +(@PATH,42,-71.9985,349.9734,-106.1616,0,0,0,0,100,0), +(@PATH,43,-70.47477,372.0443,-105.1814,0,0,0,0,100,0), +(@PATH,44,-75.42,396.4342,-107.5409,0,0,0,0,100,0), +(@PATH,45,-76.16063,416.5957,-106.7714,0,0,0,0,100,0), +(@PATH,46,-57.21247,427.7058,-105.9699,0,0,0,0,100,0), +(@PATH,47,-76.16063,416.5957,-106.7714,0,0,0,0,100,0), +(@PATH,48,-75.42,396.4342,-107.5409,0,0,0,0,100,0), +(@PATH,49,-70.47477,372.0443,-105.1814,0,0,0,0,100,0), +(@PATH,50,-71.9985,349.9734,-106.1616,0,0,0,0,100,0), +(@PATH,51,-77.92536,332.0374,-106.1616,0,0,0,0,100,0), +(@PATH,52,-74.29018,324.0769,-106.1616,0,0,0,0,100,0), +(@PATH,53,-57.82487,314.0065,-106.7489,0,0,0,0,100,0), +(@PATH,54,-40.54165,302.8161,-106.417,0,0,0,0,100,0), +(@PATH,55,-30.55159,288.4883,-106.417,0,0,0,0,100,0), +(@PATH,56,-18.97365,270.1935,-106.417,0,0,0,0,100,0), +(@PATH,57,-10.38575,245.1311,-106.2873,0,0,0,0,100,0), +(@PATH,58,-7.558329,219.6261,-106.1616,0,0,0,0,100,0); + +-- Pathing for Druid of the Fang Entry: 3840 +SET @NPC := @CGUID+73; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-32.46463,`position_y`=476.5441,`position_z`=-53.67201 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,-32.46463,476.5441,-53.67201,0,0,0,0,100,0), +(@PATH,2,-24.1478,488.4493,-53.94269,0,0,0,0,100,0), +(@PATH,3,-5.499965,498.1107,-56.38233,0,0,0,0,100,0), +(@PATH,4,-3.074491,508.342,-56.23333,0,0,0,0,100,0), +(@PATH,5,9.906947,515.5308,-57.28083,0,0,0,0,100,0), +(@PATH,6,26.01395,525.7491,-57.30517,0,0,0,0,100,0), +(@PATH,7,35.24433,517.2056,-57.97839,0,0,0,0,100,0), +(@PATH,8,25.02376,506.0128,-59.47094,0,0,0,0,100,0), +(@PATH,9,33.44196,499.6694,-61.27732,0,0,0,0,100,0), +(@PATH,10,43.06449,491.576,-63.45752,0,0,0,0,100,0), +(@PATH,11,38.21582,482.055,-65.48444,0,0,0,0,100,0), +(@PATH,12,44.47209,470.8035,-65.7718,0,0,0,0,100,0), +(@PATH,13,50.19913,468.388,-65.08987,0,0,0,0,100,0), +(@PATH,14,54.30805,453.9987,-65.17434,0,0,0,0,100,0), +(@PATH,15,62.7691,439.143,-64.51325,0,0,0,0,100,0), +(@PATH,16,67.46973,425.9555,-64.06583,0,0,0,0,100,0), +(@PATH,17,66.02315,412.1528,-63.72729,0,0,0,0,100,0), +(@PATH,18,67.46973,425.9555,-64.06583,0,0,0,0,100,0), +(@PATH,19,62.7691,439.143,-64.51325,0,0,0,0,100,0), +(@PATH,20,54.44374,453.7604,-65.11059,0,0,0,0,100,0), +(@PATH,21,50.19913,468.388,-65.08987,0,0,0,0,100,0), +(@PATH,22,44.47209,470.8035,-65.7718,0,0,0,0,100,0), +(@PATH,23,38.21582,482.055,-65.48444,0,0,0,0,100,0), +(@PATH,24,43.06449,491.576,-63.45752,0,0,0,0,100,0), +(@PATH,25,33.44196,499.6694,-61.27732,0,0,0,0,100,0), +(@PATH,26,25.02376,506.0128,-59.47094,0,0,0,0,100,0), +(@PATH,27,35.24433,517.2056,-57.97839,0,0,0,0,100,0), +(@PATH,28,26.01395,525.7491,-57.30517,0,0,0,0,100,0), +(@PATH,29,9.906947,515.5308,-57.28083,0,0,0,0,100,0), +(@PATH,30,-2.831895,508.4763,-56.22764,0,0,0,0,100,0), +(@PATH,31,-5.499965,498.1107,-56.38233,0,0,0,0,100,0), +(@PATH,32,-24.1478,488.4493,-53.94269,0,0,0,0,100,0); + +-- Pathing for Druid of the Fang Entry: 3840 +SET @NPC := @CGUID+85; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=5.169512,`position_y`=291.0508,`position_z`=-85.75152 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,5.169512,291.0508,-85.75152,0,0,0,0,100,0), +(@PATH,2,-8.161954,304.6263,-87.90734,0,0,0,0,100,0), +(@PATH,3,-20.91471,312.4147,-88.85575,0,0,0,0,100,0), +(@PATH,4,-30.28955,320.0468,-89.23547,0,0,0,0,100,0), +(@PATH,5,-20.91471,312.4147,-88.85575,0,0,0,0,100,0), +(@PATH,6,-8.161954,304.6263,-87.90734,0,0,0,0,100,0), +(@PATH,7,5.169512,291.0508,-85.75152,0,0,0,0,100,0), +(@PATH,8,14.38359,275.7025,-86.07133,0,0,0,0,100,0), +(@PATH,9,29.0581,260.857,-87.44287,0,0,0,0,100,0), +(@PATH,10,29.99125,247.6462,-87.24267,0,0,0,0,100,0), +(@PATH,11,17.72407,233.4077,-84.95287,0,0,0,0,100,0), +(@PATH,12,13.15497,218.6567,-84.38547,0,0,0,0,100,0), +(@PATH,13,10.08383,211.0842,-84.1092,0,0,0,0,100,0), +(@PATH,14,9.46202,197.3004,-84.0104,0,0,0,0,100,0), +(@PATH,15,10.08383,211.0842,-84.1092,0,0,0,0,100,0), +(@PATH,16,13.15497,218.6567,-84.38547,0,0,0,0,100,0), +(@PATH,17,17.72407,233.4077,-84.95287,0,0,0,0,100,0), +(@PATH,18,29.99125,247.6462,-87.24267,0,0,0,0,100,0), +(@PATH,19,29.0581,260.857,-87.44287,0,0,0,0,100,0), +(@PATH,20,14.5437,275.4358,-86.08146,0,0,0,0,100,0); + +-- Pathing for Druid of the Fang Entry: 3840 +SET @NPC := @CGUID+87; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=11.33223,`position_y`=192.6356,`position_z`=-84.53266 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,11.33223,192.6356,-84.53266,0,0,0,0,100,0), +(@PATH,2,11.13244,182.6476,-85.75266,0,0,0,0,100,0), +(@PATH,3,9.191593,170.5119,-86.65194,0,0,0,0,100,0), +(@PATH,4,2.571104,155.1654,-88.44265,0,0,0,0,100,0), +(@PATH,5,-5.449131,139.8384,-88.20549,0,0,0,0,100,0), +(@PATH,6,-13.89712,121.5487,-89.95511,0,0,0,0,100,0), +(@PATH,7,-26.02917,104.5426,-89.40195,0,0,0,0,100,0), +(@PATH,8,-26.74949,85.73177,-91.53354,0,0,0,0,100,0), +(@PATH,9,-36.48348,69.05029,-88.97927,0,0,0,0,100,0), +(@PATH,10,-26.74949,85.73177,-91.53354,0,0,0,0,100,0), +(@PATH,11,-26.02917,104.5426,-89.40195,0,0,0,0,100,0), +(@PATH,12,-13.89712,121.5487,-89.95511,0,0,0,0,100,0), +(@PATH,13,-5.449131,139.8384,-88.20549,0,0,0,0,100,0), +(@PATH,14,2.571104,155.1654,-88.44265,0,0,0,0,100,0), +(@PATH,15,9.191593,170.5119,-86.65194,0,0,0,0,100,0), +(@PATH,16,11.13244,182.6476,-85.75266,0,0,0,0,100,0), +(@PATH,17,11.32568,192.3082,-84.55685,0,0,0,0,100,0), +(@PATH,18,27.47757,201.0509,-86.20597,0,0,0,0,100,0), +(@PATH,19,46.28596,207.0079,-88.45377,0,0,0,0,100,0), +(@PATH,20,49.9343,220.6015,-88.85638,0,0,0,0,100,0), +(@PATH,21,48.07176,231.7553,-88.50435,0,0,0,0,100,0), +(@PATH,22,49.9343,220.6015,-88.85638,0,0,0,0,100,0), +(@PATH,23,46.28596,207.0079,-88.45377,0,0,0,0,100,0), +(@PATH,24,27.47757,201.0509,-86.20597,0,0,0,0,100,0); + +-- Pathing for Druid of the Fang Entry: 3840 +SET @NPC := @CGUID+88; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-42.78775,`position_y`=270.5079,`position_z`=-92.65298 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,-42.78775,270.5079,-92.65298,0,0,0,0,100,0), +(@PATH,2,-48.4903,264.9264,-92.84426,0,0,0,0,100,0), +(@PATH,3,-55.79019,265.0667,-92.84426,0,0,0,0,100,0), +(@PATH,4,-62.03218,267.4345,-92.84426,0,0,0,0,100,0), +(@PATH,5,-66.74588,272.8432,-92.84426,0,0,0,0,100,0), +(@PATH,6,-64.07108,280.9801,-92.28627,0,0,0,0,100,0), +(@PATH,7,-58.00502,286.4681,-91.88603,0,0,0,0,100,0), +(@PATH,8,-49.98373,285.4374,-92.75809,0,0,0,0,100,0), +(@PATH,9,-43.22366,278.0873,-92.60368,0,0,0,0,100,0); + +-- Pathing for Deviate Adder Entry: 5048 +SET @NPC := @CGUID+94; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-111.2916,`position_y`=414.8848,`position_z`=-73.81985 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,-111.2916,414.8848,-73.81985,0,0,0,0,100,0), +(@PATH,2,-108.9518,424.318,-73.56974,0,0,0,0,100,0), +(@PATH,3,-109.7299,433.3519,-73.07323,0,0,0,0,100,0), +(@PATH,4,-115.2026,442.675,-72.72485,0,0,0,0,100,0), +(@PATH,5,-115.5643,453.1607,-72.57687,0,0,0,0,100,0), +(@PATH,6,-111.2976,460.3633,-71.7826,0,0,0,0,100,0), +(@PATH,7,-99.72679,463.3063,-70.80965,0,0,0,0,100,0), +(@PATH,8,-89.91006,464.2692,-69.85971,0,0,0,0,100,0), +(@PATH,9,-85.32175,470.4025,-68.31042,0,0,0,0,100,0), +(@PATH,10,-85.9609,478.1983,-67.15988,0,0,0,0,100,0), +(@PATH,11,-83.74859,483.9088,-65.77301,0,0,0,0,100,0), +(@PATH,12,-78.70206,488.8036,-63.98124,0,0,0,0,100,0), +(@PATH,13,-70.44627,487.9279,-61.73565,0,0,0,0,100,0), +(@PATH,14,-61.74426,482.549,-59.31838,0,0,0,0,100,0), +(@PATH,15,-55.85901,475.5052,-57.67842,0,0,0,0,100,0), +(@PATH,16,-48.5933,475.1139,-56.20555,0,0,0,0,100,0), +(@PATH,17,-47.66065,464.6244,-56.26297,0,0,0,0,100,0), +(@PATH,18,-48.58491,475.1134,-56.19251,0,0,0,0,100,0), +(@PATH,19,-55.85901,475.5052,-57.67842,0,0,0,0,100,0), +(@PATH,20,-61.58795,482.3619,-59.22224,0,0,0,0,100,0), +(@PATH,21,-70.44627,487.9279,-61.73565,0,0,0,0,100,0), +(@PATH,22,-78.67587,488.8008,-63.90179,0,0,0,0,100,0), +(@PATH,23,-83.74859,483.9088,-65.77301,0,0,0,0,100,0), +(@PATH,24,-85.9609,478.1983,-67.15988,0,0,0,0,100,0), +(@PATH,25,-85.32175,470.4025,-68.31042,0,0,0,0,100,0), +(@PATH,26,-89.91006,464.2692,-69.85971,0,0,0,0,100,0), +(@PATH,27,-99.72679,463.3063,-70.80965,0,0,0,0,100,0), +(@PATH,28,-111.2976,460.3633,-71.7826,0,0,0,0,100,0), +(@PATH,29,-115.5643,453.1607,-72.57687,0,0,0,0,100,0), +(@PATH,30,-115.2026,442.675,-72.72485,0,0,0,0,100,0), +(@PATH,31,-109.7299,433.3519,-73.07323,0,0,0,0,100,0), +(@PATH,32,-108.9518,424.318,-73.56974,0,0,0,0,100,0); + +-- Pathing for Deviate Crocolisk Entry: 5053 +SET @NPC := @CGUID+95; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-206.6254,`position_y`=10.60585,`position_z`=-105.5566 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,-206.6254,10.60585,-105.5566,0,0,0,0,100,0), +(@PATH,2,-221.1983,9.83212,-106.7141,0,0,0,0,100,0), +(@PATH,3,-234.6216,4.162215,-106.7141,0,0,0,0,100,0), +(@PATH,4,-250.7572,2.231966,-106.7141,0,0,0,0,100,0), +(@PATH,5,-268.6693,0.812376,-106.7141,0,0,0,0,100,0), +(@PATH,6,-250.7572,2.231966,-106.7141,0,0,0,0,100,0), +(@PATH,7,-234.6216,4.162215,-106.7141,0,0,0,0,100,0), +(@PATH,8,-221.1983,9.83212,-106.7141,0,0,0,0,100,0), +(@PATH,9,-206.6254,10.60585,-105.5566,0,0,0,0,100,0), +(@PATH,10,-191.4222,23.37792,-105.3295,0,0,0,0,100,0), +(@PATH,11,-177.4257,21.15149,-106.3155,0,0,0,0,100,0), +(@PATH,12,-161.8866,25.5651,-106.7032,0,0,0,0,100,0), +(@PATH,13,-156.922,38.05394,-106.7851,0,0,0,0,100,0), +(@PATH,14,-155.0128,61.50713,-106.325,0,0,0,0,100,0), +(@PATH,15,-143.7498,65.31359,-106.4096,0,0,0,0,100,0), +(@PATH,16,-115.4192,69.97491,-106.5546,0,0,0,0,100,0), +(@PATH,17,-90.62963,61.87006,-106.1344,0,0,0,0,100,0), +(@PATH,18,-82.207,71.23216,-106.1616,0,0,0,0,100,0), +(@PATH,19,-71.12738,72.31783,-106.1616,0,0,0,0,100,0), +(@PATH,20,-65.20048,71.93992,-106.1616,0,0,0,0,100,0), +(@PATH,21,-60.17787,68.83612,-106.1616,0,0,0,0,100,0), +(@PATH,22,-58.55316,55.29606,-107.5062,0,0,0,0,100,0), +(@PATH,23,-60.3446,62.887,-106.1616,0,0,0,0,100,0), +(@PATH,24,-60.26392,73.96214,-106.1616,0,0,0,0,100,0), +(@PATH,25,-46.72487,83.91846,-106.1616,0,0,0,0,100,0), +(@PATH,26,-37.27559,91.71603,-106.1616,0,0,0,0,100,0), +(@PATH,27,-46.72487,83.91846,-106.1616,0,0,0,0,100,0), +(@PATH,28,-60.26392,73.96214,-106.1616,0,0,0,0,100,0), +(@PATH,29,-60.3446,62.887,-106.1616,0,0,0,0,100,0), +(@PATH,30,-58.55316,55.29606,-107.5062,0,0,0,0,100,0), +(@PATH,31,-60.17787,68.83612,-106.1616,0,0,0,0,100,0), +(@PATH,32,-65.20048,71.93992,-106.1616,0,0,0,0,100,0), +(@PATH,33,-71.12738,72.31783,-106.1616,0,0,0,0,100,0), +(@PATH,34,-82.207,71.23216,-106.1616,0,0,0,0,100,0), +(@PATH,35,-90.62963,61.87006,-106.1344,0,0,0,0,100,0), +(@PATH,36,-115.4192,69.97491,-106.5546,0,0,0,0,100,0), +(@PATH,37,-143.7498,65.31359,-106.4096,0,0,0,0,100,0), +(@PATH,38,-155.0128,61.50713,-106.325,0,0,0,0,100,0), +(@PATH,39,-156.922,38.05394,-106.7851,0,0,0,0,100,0), +(@PATH,40,-161.8866,25.5651,-106.7032,0,0,0,0,100,0), +(@PATH,41,-177.4257,21.15149,-106.3155,0,0,0,0,100,0), +(@PATH,42,-191.4222,23.37792,-105.3295,0,0,0,0,100,0); + +-- Pathing for Deviate Crocolisk Entry: 5053 +SET @NPC := @CGUID+98; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-3.781793,`position_y`=181.169,`position_z`=-106.1616 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,-3.781793,181.169,-106.1616,0,0,0,0,100,0), +(@PATH,2,-4.978167,210.3277,-106.1616,0,0,0,0,100,0), +(@PATH,3,0.287006,225.3343,-106.1616,0,0,0,0,100,0), +(@PATH,4,1.611017,241.8943,-106.2834,0,0,0,0,100,0), +(@PATH,5,2.309928,257.5552,-106.417,0,0,0,0,100,0), +(@PATH,6,1.611017,241.8943,-106.2834,0,0,0,0,100,0), +(@PATH,7,0.287006,225.3343,-106.1616,0,0,0,0,100,0), +(@PATH,8,-4.978167,210.3277,-106.1616,0,0,0,0,100,0), +(@PATH,9,-3.781793,181.169,-106.1616,0,0,0,0,100,0), +(@PATH,10,-4.978412,166.4447,-106.1616,0,0,0,0,100,0), +(@PATH,11,-13.56728,145.4279,-106.1616,0,0,0,0,100,0), +(@PATH,12,-42.87572,108.6872,-106.1616,0,0,0,0,100,0), +(@PATH,13,-13.56728,145.4279,-106.1616,0,0,0,0,100,0), +(@PATH,14,-4.978412,166.4447,-106.1616,0,0,0,0,100,0); + +-- Pathing for Deviate Dreadfang Entry: 5056 +SET @NPC := @CGUID+118; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-176.1877,`position_y`=-88.08203,`position_z`=-67.91631 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,-176.1877,-88.08203,-67.91631,0,0,0,0,100,0), +(@PATH,2,-187.2033,-109.3953,-71.78207,0,0,0,0,100,0), +(@PATH,3,-201.4529,-118.7214,-71.34105,0,0,0,0,100,0), +(@PATH,4,-225.1069,-123.6069,-69.40672,0,0,0,0,100,0), +(@PATH,5,-255.9013,-121.0689,-65.43629,0,0,0,0,100,0), +(@PATH,6,-273.5684,-112.3489,-62.61633,0,0,0,0,100,0), +(@PATH,7,-296.2334,-96.033,-58.6269,0,0,0,0,100,0), +(@PATH,8,-309.8578,-79.04319,-57.5718,0,0,0,0,100,0), +(@PATH,9,-313.1153,-57.52527,-59.93277,0,0,0,0,100,0), +(@PATH,10,-300.4608,-24.67885,-60.66897,0,0,0,0,100,0), +(@PATH,11,-293.5971,-8.09445,-58.9239,0,0,0,0,100,0), +(@PATH,12,-300.4608,-24.67885,-60.66897,0,0,0,0,100,0), +(@PATH,13,-313.1153,-57.52527,-59.93277,0,0,0,0,100,0), +(@PATH,14,-309.8578,-79.04319,-57.5718,0,0,0,0,100,0), +(@PATH,15,-296.2334,-96.033,-58.6269,0,0,0,0,100,0), +(@PATH,16,-273.7539,-112.2573,-62.57849,0,0,0,0,100,0), +(@PATH,17,-255.9013,-121.0689,-65.43629,0,0,0,0,100,0), +(@PATH,18,-225.1085,-123.6068,-69.4228,0,0,0,0,100,0), +(@PATH,19,-201.4529,-118.7214,-71.34105,0,0,0,0,100,0), +(@PATH,20,-187.2033,-109.3953,-71.78207,0,0,0,0,100,0); + +-- Pathing for Deviate Viper Entry: 5755 +SET @NPC := @CGUID+123; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=0.22567,`position_y`=451.5172,`position_z`=-75.79546 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,0.22567,451.5172,-75.79546,0,0,0,0,100,0), +(@PATH,2,-1.321356,440.495,-72.40939,0,0,0,0,100,0), +(@PATH,3,5.961649,436.0012,-73.30997,0,0,0,0,100,0), +(@PATH,4,1.582086,423.4031,-68.05251,0,0,0,0,100,0), +(@PATH,5,-7.161927,416.6554,-65.41779,0,0,0,0,100,0), +(@PATH,6,-16.36808,409.7467,-60.83065,0,0,0,0,100,0), +(@PATH,7,-7.161927,416.6554,-65.41779,0,0,0,0,100,0), +(@PATH,8,1.582086,423.4031,-68.05251,0,0,0,0,100,0), +(@PATH,9,5.926599,435.9003,-73.25732,0,0,0,0,100,0), +(@PATH,10,-1.321356,440.495,-72.40939,0,0,0,0,100,0), +(@PATH,11,0.22567,451.5172,-75.79546,0,0,0,0,100,0), +(@PATH,12,7.427598,457.0426,-78.72384,0,0,0,0,100,0), +(@PATH,13,12.76198,441.6107,-79.47758,0,0,0,0,100,0), +(@PATH,14,20.42717,431.4712,-81.619,0,0,0,0,100,0), +(@PATH,15,27.26098,430.4045,-82.7235,0,0,0,0,100,0), +(@PATH,16,32.76506,442.0709,-84.73339,0,0,0,0,100,0), +(@PATH,17,27.29263,459.1882,-86.4822,0,0,0,0,100,0), +(@PATH,18,19.12963,470.929,-87.95515,0,0,0,0,100,0), +(@PATH,19,27.29263,459.1882,-86.4822,0,0,0,0,100,0), +(@PATH,20,32.76506,442.0709,-84.73339,0,0,0,0,100,0), +(@PATH,21,27.26098,430.4045,-82.7235,0,0,0,0,100,0), +(@PATH,22,20.42717,431.4712,-81.619,0,0,0,0,100,0), +(@PATH,23,12.81508,441.5405,-79.48505,0,0,0,0,100,0), +(@PATH,24,7.427598,457.0426,-78.72384,0,0,0,0,100,0); + +-- Pathing for Deviate Venomwing Entry: 5756 +SET @NPC := @CGUID+127; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-163.7872,`position_y`=49.33768,`position_z`=-39.00057 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,-163.7872,49.33768,-39.00057,0,0,0,0,100,0), +(@PATH,2,-155.2846,39.78748,-34.12175,0,0,0,0,100,0), +(@PATH,3,-146.6868,23.65013,-28.54225,0,0,0,0,100,0), +(@PATH,4,-155.1057,39.57315,-33.97281,0,0,0,0,100,0), +(@PATH,5,-163.7872,49.33768,-39.00057,0,0,0,0,100,0), +(@PATH,6,-173.3635,55.76018,-41.71697,0,0,0,0,100,0), +(@PATH,7,-185.7017,55.50381,-46.53663,0,0,0,0,100,0), +(@PATH,8,-194.7153,58.28807,-48.28626,0,0,0,0,100,0), +(@PATH,9,-198.103,66.36266,-48.39162,0,0,0,0,100,0), +(@PATH,10,-183.0872,71.94413,-45.73843,0,0,0,0,100,0), +(@PATH,11,-176.6698,64.31975,-43.26794,0,0,0,0,100,0), +(@PATH,12,-177.1057,56.68771,-43.00938,0,0,0,0,100,0), +(@PATH,13,-188.2681,47.6015,-46.74811,0,0,0,0,100,0), +(@PATH,14,-196.1989,36.33109,-48.84406,0,0,0,0,100,0), +(@PATH,15,-198.5337,44.04536,-48.75875,0,0,0,0,100,0), +(@PATH,16,-201.6038,52.25882,-49.14081,0,0,0,0,100,0), +(@PATH,17,-206.4297,58.07165,-49.4399,0,0,0,0,100,0), +(@PATH,18,-217.497,57.39254,-49.42052,0,0,0,0,100,0), +(@PATH,19,-226.7592,62.48674,-48.90618,0,0,0,0,100,0), +(@PATH,20,-238.8114,58.15538,-50.75982,0,0,0,0,100,0), +(@PATH,21,-259.9211,53.6653,-53.96174,0,0,0,0,100,0), +(@PATH,22,-270.0728,44.26909,-55.39373,0,0,0,0,100,0), +(@PATH,23,-273.9474,26.49651,-59.89263,0,0,0,0,100,0), +(@PATH,24,-281.808,11.17585,-62.61101,0,0,0,0,100,0), +(@PATH,25,-273.9474,26.49651,-59.89263,0,0,0,0,100,0), +(@PATH,26,-270.0728,44.26909,-55.39373,0,0,0,0,100,0), +(@PATH,27,-259.9211,53.6653,-53.96174,0,0,0,0,100,0), +(@PATH,28,-239.0596,58.06616,-50.77961,0,0,0,0,100,0), +(@PATH,29,-226.7592,62.48674,-48.90618,0,0,0,0,100,0), +(@PATH,30,-217.497,57.39254,-49.42052,0,0,0,0,100,0), +(@PATH,31,-206.4297,58.07165,-49.4399,0,0,0,0,100,0), +(@PATH,32,-201.6038,52.25882,-49.14081,0,0,0,0,100,0), +(@PATH,33,-198.5337,44.04536,-48.75875,0,0,0,0,100,0), +(@PATH,34,-196.1989,36.33109,-48.84406,0,0,0,0,100,0), +(@PATH,35,-188.2681,47.6015,-46.74811,0,0,0,0,100,0), +(@PATH,36,-177.1117,56.58348,-43.0666,0,0,0,0,100,0), +(@PATH,37,-176.6698,64.31975,-43.26794,0,0,0,0,100,0), +(@PATH,38,-183.0872,71.94413,-45.73843,0,0,0,0,100,0), +(@PATH,39,-198.103,66.36266,-48.39162,0,0,0,0,100,0), +(@PATH,40,-194.7153,58.28807,-48.28626,0,0,0,0,100,0), +(@PATH,41,-185.8283,55.50118,-46.56746,0,0,0,0,100,0), +(@PATH,42,-173.3635,55.76018,-41.71697,0,0,0,0,100,0); + +-- Pathing for Deviate Shambler Entry: 5761 +SET @NPC := @CGUID+130; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-308.2884,`position_y`=-42.39409,`position_z`=-60.37433 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,-308.2884,-42.39409,-60.37433,0,0,0,0,100,0), +(@PATH,2,-312.6835,-59.78034,-59.84926,0,0,0,0,100,0), +(@PATH,3,-309.0173,-81.25159,-57.37483,0,0,0,0,100,0), +(@PATH,4,-297.2284,-94.57697,-58.52948,0,0,0,0,100,0), +(@PATH,5,-276.5252,-108.8788,-62.09994,0,0,0,0,100,0), +(@PATH,6,-252.9668,-122.41,-65.89957,0,0,0,0,100,0), +(@PATH,7,-225.3321,-124.8758,-69.37584,0,0,0,0,100,0), +(@PATH,8,-199.492,-117.8102,-71.45586,0,0,0,0,100,0), +(@PATH,9,-186.7178,-108.5924,-71.77054,0,0,0,0,100,0), +(@PATH,10,-199.492,-117.8102,-71.45586,0,0,0,0,100,0), +(@PATH,11,-225.0145,-124.7889,-69.40617,0,0,0,0,100,0), +(@PATH,12,-252.9668,-122.41,-65.89957,0,0,0,0,100,0), +(@PATH,13,-276.5252,-108.8788,-62.09994,0,0,0,0,100,0), +(@PATH,14,-297.2284,-94.57697,-58.52948,0,0,0,0,100,0), +(@PATH,15,-309.0121,-81.28205,-57.3719,0,0,0,0,100,0), +(@PATH,16,-312.6835,-59.78034,-59.84926,0,0,0,0,100,0); + +-- Pathing for Deviate Shambler Entry: 5761 +SET @NPC := @CGUID+132; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-212.289,`position_y`=53.3367,`position_z`=-82.23838 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,-212.289,53.3367,-82.23838,0,0,0,0,100,0), +(@PATH,2,-242.9277,42.20808,-84.30939,0,0,0,0,100,0), +(@PATH,3,-258.2727,41.78778,-86.98499,0,0,0,0,100,0), +(@PATH,4,-272.949,31.4811,-88.16415,0,0,0,0,100,0), +(@PATH,5,-289.7175,39.48424,-90.58475,0,0,0,0,100,0), +(@PATH,6,-304.6116,51.02895,-93.40977,0,0,0,0,100,0), +(@PATH,7,-327.5949,50.85315,-96.88831,0,0,0,0,100,0), +(@PATH,8,-342.07,35.42883,-99.2283,0,0,0,0,100,0), +(@PATH,9,-333.4077,21.64386,-103.0577,0,0,0,0,100,0), +(@PATH,10,-342.07,35.42883,-99.2283,0,0,0,0,100,0), +(@PATH,11,-327.5949,50.85315,-96.88831,0,0,0,0,100,0), +(@PATH,12,-304.6116,51.02895,-93.40977,0,0,0,0,100,0), +(@PATH,13,-289.7175,39.48424,-90.58475,0,0,0,0,100,0), +(@PATH,14,-272.949,31.4811,-88.16415,0,0,0,0,100,0), +(@PATH,15,-258.2727,41.78778,-86.98499,0,0,0,0,100,0), +(@PATH,16,-242.9676,42.19359,-84.31452,0,0,0,0,100,0), +(@PATH,17,-212.289,53.3367,-82.23838,0,0,0,0,100,0), +(@PATH,18,-198.659,73.62458,-81.9931,0,0,0,0,100,0), +(@PATH,19,-182.1777,87.85145,-79.25278,0,0,0,0,100,0), +(@PATH,20,-165.3712,82.59031,-75.9784,0,0,0,0,100,0), +(@PATH,21,-155.2452,61.96495,-75.75853,0,0,0,0,100,0), +(@PATH,22,-141.3307,36.76375,-75.19148,0,0,0,0,100,0), +(@PATH,23,-149.5539,5.984205,-74.68463,0,0,0,0,100,0), +(@PATH,24,-157.0373,-17.74129,-78.73101,0,0,0,0,100,0), +(@PATH,25,-142.4641,-38.54217,-78.92719,0,0,0,0,100,0), +(@PATH,26,-157.0373,-17.74129,-78.73101,0,0,0,0,100,0), +(@PATH,27,-149.5539,5.984205,-74.68463,0,0,0,0,100,0), +(@PATH,28,-141.3307,36.76375,-75.19148,0,0,0,0,100,0), +(@PATH,29,-155.2452,61.96495,-75.75853,0,0,0,0,100,0), +(@PATH,30,-165.3712,82.59031,-75.9784,0,0,0,0,100,0), +(@PATH,31,-182.1777,87.85145,-79.25278,0,0,0,0,100,0), +(@PATH,32,-198.659,73.62458,-81.9931,0,0,0,0,100,0); + +-- Add missing creature_template_addon +DELETE FROM `creature_template_addon` WHERE `entry` IN (5767,5768); +INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES +(5767, 0, 0, 1, 1, 0, ''),(5768, 0, 0, 1, 1, 0, ''); + +-- Add missing text +DELETE FROM `creature_text` WHERE `entry` IN (3669,3670,3671,3673,3678) AND `groupid`=0; +INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextId`, `comment`) VALUES +(3669, 0, 0, 'You will never wake the dreamer!', 14, 0, 100, 0, 0, 5785, 6094, 'Lord Cobrahn on Aggro'), +(3670, 0, 0, 'The coils of death will crush you!', 14, 0, 100, 0, 0, 5787, 6095, 'Lord Pythas on Aggro'), +(3671, 0, 0, 'None can stand against the Serpent Lords!', 14, 0, 100, 0, 0, 5786, 6097, 'Lady Anacondra on Aggro'), +(3673, 0, 0, 'I am the serpent king! I can do anything! ', 14, 0, 100, 0, 0, 5788, 6096, 'Lord Serpentis on Aggro'), +(3678, 0, 0, 'At last! Naralex can be awakened! Come aid me, brave adventurers!', 14, 0, 100, 0, 0, 0, 2101, 'Muyoh'); + +-- Deviate Ravager SAI +SET @ENTRY := 3636; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +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 +(@ENTRY,0,0,0,1,0,100,3,0,0,1000,1000,11,3417,0,0,0,0,0,1,0,0,0,0,0,0,0,"Deviate Ravager - Out of Combat - Cast 'Thrash' (No Repeat) (Normal Dungeon)"); + +-- Evolving Ectoplasm SAI +SET @ENTRY := 3640; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (@ENTRY*100,@ENTRY*100+1,@ENTRY*100+2,@ENTRY*100+3) AND `source_type`=9; +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 +(@ENTRY,0,0,0,1,0,100,3,1000,1000,1000,1000,87,@ENTRY*100,@ENTRY*100+1,@ENTRY*100+2,0,0,0,1,0,0,0,0,0,0,0,"Evolving Ectoplasm - Out of Combat - Run Random Script (No Repeat) (Normal Dungeon)"), +(@ENTRY,0,1,0,0,0,100,3,12000,17000,12000,17000,87,@ENTRY*100,@ENTRY*100+1,@ENTRY*100+2,@ENTRY*100+3,0,0,1,0,0,0,0,0,0,0,"Evolving Ectoplasm - In Combat - Run Random Script (No Repeat) (Normal Dungeon)"), +(@ENTRY*100,9,0,0,0,0,100,0,100,100,0,0,28,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Evolving Ectoplasm - Script - Remove All Auras"), +(@ENTRY*100,9,1,0,0,0,100,0,100,100,0,0,11,7940,2,0,0,0,0,1,0,0,0,0,0,0,0,"Evolving Ectoplasm - Script - Cast 'immunity-frost'"), +(@ENTRY*100,9,2,0,0,0,100,0,100,100,0,0,11,7944,2,0,0,0,0,1,0,0,0,0,0,0,0,"Evolving Ectoplasm - Script - Cast 'evolving-ectoplasm-blue'"), +(@ENTRY*100+1,9,0,0,0,0,100,0,100,100,0,0,28,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Evolving Ectoplasm - Script - Remove All Auras"), +(@ENTRY*100+1,9,1,0,0,0,100,0,100,100,0,0,11,7941,2,0,0,0,0,1,0,0,0,0,0,0,0,"Evolving Ectoplasm - Script - Cast 'immunity-nature'"), +(@ENTRY*100+1,9,2,0,0,0,100,0,100,100,0,0,11,7945,2,0,0,0,0,1,0,0,0,0,0,0,0,"Evolving Ectoplasm - Script - Cast 'evolving-ectoplasm-green'"), +(@ENTRY*100+2,9,0,0,0,0,100,0,100,100,0,0,28,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Evolving Ectoplasm - Script - Remove All Auras"), +(@ENTRY*100+2,9,1,0,0,0,100,0,100,100,0,0,11,7942,2,0,0,0,0,1,0,0,0,0,0,0,0,"Evolving Ectoplasm - Script - Cast 'immunity-fire'"), +(@ENTRY*100+2,9,2,0,0,0,100,0,100,100,0,0,11,7943,2,0,0,0,0,1,0,0,0,0,0,0,0,"Evolving Ectoplasm - Script - Cast 'evolving-ectoplasm-red'"), +(@ENTRY*100+3,9,0,0,0,0,100,0,100,100,0,0,28,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Evolving Ectoplasm - Script - Remove All Auras"), +(@ENTRY*100+3,9,1,0,0,0,100,0,100,100,0,0,11,7943,2,0,0,0,0,1,0,0,0,0,0,0,0,"Evolving Ectoplasm - Script - Cast 'evolving-ectoplasm-red'"), +(@ENTRY*100+3,9,2,0,0,0,100,0,100,100,0,0,11,7946,2,0,0,0,0,1,0,0,0,0,0,0,0,"Evolving Ectoplasm - Script - Cast 'evolving-ectoplasm-black'"); + +-- Lord Cobrahn SAI +SET @ENTRY := 3669; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +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 +(@ENTRY,0,0,0,4,0,100,2,0,0,0,0,1,0,0,0,0,0,0,2,0,0,0,0,0,0,0,"Lord Cobrahn - On Aggro - Say 0 (Normal Dungeon)"), +(@ENTRY,0,1,0,6,0,100,2,0,0,0,0,34,1,3,0,0,0,0,1,0,0,0,0,0,0,0,"Lord Cobrahn - On Just Died - Set Instance Data 1 to 3 (Normal Dungeon)"), +(@ENTRY,0,2,0,0,0,80,2,0,0,6000,8000,11,20805,0,0,0,0,0,2,0,0,0,0,0,0,0,"Lord Cobrahn - In Combat - Cast 'Lightning Bolt' (Normal Dungeon)"); + +-- Lord Pythas SAI +SET @ENTRY := 3670; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +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 +(@ENTRY,0,0,0,4,0,100,2,0,0,0,0,1,0,0,0,0,0,0,2,0,0,0,0,0,0,0,"Lord Pythas - On Aggro - Say 0 (Normal Dungeon)"), +(@ENTRY,0,1,0,6,0,100,2,0,0,0,0,34,2,3,0,0,0,0,1,0,0,0,0,0,0,0,"Lord Pythas - On Just Died - Set Instance Data 2 to 3 (Normal Dungeon)"), +(@ENTRY,0,2,0,0,0,80,2,0,0,6000,8000,11,20805,0,0,0,0,0,2,0,0,0,0,0,0,0,"Lord Pythas - In Combat - Cast 'Lightning Bolt' (Normal Dungeon)"), +(@ENTRY,0,3,0,0,0,100,2,6000,8000,12000,30000,11,8147,0,0,0,0,0,2,0,0,0,0,0,0,0,"Lord Pythas - In Combat - Cast 'Thunderclap' (Normal Dungeon)"); + +-- Lady Anacondra SAI +SET @ENTRY := 3671; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +UPDATE `creature_template_addon` SET `bytes1`=0 WHERE `entry`=3671; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +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 +(@ENTRY,0,0,1,1,0,100,3,1000,1000,1000,1000,11,13236,0,0,0,0,0,1,0,0,0,0,0,0,0,"Lady Anacondra - OOC - Cast 'Nature Channeling' (No Repeat) (Normal Dungeon)"), +(@ENTRY,0,1,0,61,0,100,2,0,0,0,0,90,8,0,0,0,0,0,1,0,0,0,0,0,0,0,"Lady Anacondra - OOC - Add bytes_1 8 (Normal Dungeon)"), +(@ENTRY,0,2,3,4,0,100,2,0,0,0,0,92,0,13236,1,0,0,0,1,0,0,0,0,0,0,0,"Lady Anacondra - On Aggro - Remove Aura 'Nature Channeling' (Normal Dungeon)"), +(@ENTRY,0,3,4,61,0,100,2,0,0,0,0,91,8,0,0,0,0,0,1,0,0,0,0,0,0,0,"Lady Anacondra - On Aggro - Remove bytes_1 8 (Normal Dungeon)"), +(@ENTRY,0,4,0,61,0,100,2,0,0,0,0,1,0,0,0,0,0,0,2,0,0,0,0,0,0,0,"Lady Anacondra - On Aggro - Say 0 (Normal Dungeon)"), +(@ENTRY,0,5,0,6,0,100,2,0,0,0,0,34,3,3,0,0,0,0,1,0,0,0,0,0,0,0,"Lady Anacondra - On Just Died - Set Instance Data 3 to 3 (Normal Dungeon)"), +(@ENTRY,0,6,0,0,0,100,2,0,0,3500,5000,11,20295,64,0,0,0,0,2,0,0,0,0,0,0,0,"Lord Pythas - In Combat CMC - Cast 'Lightning Bolt' (Normal Dungeon)"), +(@ENTRY,0,7,0,0,0,100,2,7000,7000,63000,63000,11,8148,0,0,0,0,0,1,0,0,0,0,0,0,0,"Lord Pythas - In Combat - Cast 'Thorns Aura' (Normal Dungeon)"); + +-- Lord Serpentis SAI +SET @ENTRY := 3673; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +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 +(@ENTRY,0,0,0,4,0,100,2,0,0,0,0,1,0,0,0,0,0,0,2,0,0,0,0,0,0,0,"Lord Serpentis - On Aggro - Say 0 (Normal Dungeon)"), +(@ENTRY,0,1,0,6,0,100,2,0,0,0,0,34,4,3,0,0,0,0,1,0,0,0,0,0,0,0,"Lord Serpentis - On Just Died - Set Instance Data 4 to 3 (Normal Dungeon)"); + +-- Skum SAI +SET @ENTRY := 3674; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +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 +(@ENTRY,0,0,0,0,0,80,2,3000,4000,3000,4000,11,6254,0,0,0,0,0,2,0,0,0,0,0,0,0,"Skum - In Combat - Cast 'Chained Bolt' (Normal Dungeon)"); + +-- Druid of the Fang SAI +SET @ENTRY := 3840; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY*100 AND `source_type`=9; +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 +(@ENTRY,0,0,0,4,0,100,2,0,0,0,0,22,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Druid of the Fang - On Aggro - Set Event Phase 1 (Normal Dungeon)"), +(@ENTRY,0,1,0,25,0,100,2,0,0,0,0,22,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Druid of the Fang - On Reset - Set Event Phase 0 (Normal Dungeon)"), +(@ENTRY,0,2,0,0,1,100,2,0,0,3500,4000,11,9532,64,0,0,0,0,2,0,0,0,0,0,0,0,"Druid of the Fang - In Combat CMC - Cast 'Lightning Bolt' (Phase 1) (Normal Dungeon)"), +(@ENTRY,0,3,0,0,1,100,2,37000,37000,24000,26000,80,@ENTRY*100,1,0,0,0,0,1,0,0,0,0,0,0,0,"Druid of the Fang - In Combat - Run Script (Phase 1) (Normal Dungeon)"), +(@ENTRY,0,4,0,0,0,100,2,8000,11000,10000,20000,11,8040,33,0,0,0,0,6,0,0,0,0,0,0,0,"Druid of the Fang - In Combat - Cast 'Druid's Slumber' (Normal Dungeon)"), +(@ENTRY,0,5,0,74,0,100,2,0,40,12000,18000,11,5187,1,0,0,0,0,9,0,0,0,0,0,0,0,"Druid of the Fang - On Friendly Between 0-40% Health - Cast 'Healing Touch' (Normal Dungeon)"), +(@ENTRY*100,9,0,0,0,0,100,0,100,100,0,0,22,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Druid of the Fang - Script - Set Event Phase 0"), +(@ENTRY*100,9,1,0,0,0,100,0,100,100,0,0,21,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Druid of the Fang - Script - Enable Combat Movement"), +(@ENTRY*100,9,2,0,0,0,100,0,100,100,0,0,11,8041,1,0,0,0,0,1,0,0,0,0,0,0,0,"Druid of the Fang - Script - Cast 'Serpent Form'"), +(@ENTRY*100,9,3,0,0,0,100,0,10000,12000,0,0,22,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Druid of the Fang - Script - Set Event Phase 1"); + +-- Druid of the Fang SAI for guids +SET @ENTRY := -251425; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +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 +(@ENTRY,0,0,0,4,0,100,2,0,0,0,0,22,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Druid of the Fang - On Aggro - Set Event Phase 1 (Normal Dungeon)"), +(@ENTRY,0,1,0,25,0,100,2,0,0,0,0,22,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Druid of the Fang - On Reset - Set Event Phase 0 (Normal Dungeon)"), +(@ENTRY,0,2,0,0,1,100,2,0,0,3500,4000,11,9532,64,0,0,0,0,2,0,0,0,0,0,0,0,"Druid of the Fang - In Combat CMC - Cast 'Lightning Bolt' (Phase 1) (Normal Dungeon)"), +(@ENTRY,0,3,0,0,1,100,2,37000,37000,24000,26000,80,384000,1,0,0,0,0,1,0,0,0,0,0,0,0,"Druid of the Fang - In Combat - Run Script (Phase 1) (Normal Dungeon)"), +(@ENTRY,0,4,0,0,0,100,2,8000,11000,10000,20000,11,8040,33,0,0,0,0,6,0,0,0,0,0,0,0,"Druid of the Fang - In Combat - Cast 'Druid's Slumber' (Normal Dungeon)"), +(@ENTRY,0,5,0,74,0,100,2,0,40,12000,18000,11,5187,1,0,0,0,0,9,0,0,0,0,0,0,0,"Druid of the Fang - On Friendly Between 0-40% Health - Cast 'Healing Touch' (Normal Dungeon)"), +(@ENTRY,0,6,7,1,0,100,3,1000,1000,1000,1000,11,13236,0,0,0,0,0,1,0,0,0,0,0,0,0,"Druid of the Fang - OOC - Cast 'Nature Channeling' (No Repeat) (Normal Dungeon)"), +(@ENTRY,0,7,0,61,0,100,2,0,0,0,0,90,8,0,0,0,0,0,1,0,0,0,0,0,0,0,"Druid of the Fang - OOC - Add bytes_1 8 (Normal Dungeon)"), +(@ENTRY,0,8,9,4,0,100,2,0,0,0,0,92,0,13236,1,0,0,0,1,0,0,0,0,0,0,0,"Druid of the Fang - On Aggro - Remove Aura 'Nature Channeling' (Normal Dungeon)"), +(@ENTRY,0,9,0,61,0,100,2,0,0,0,0,91,8,0,0,0,0,0,1,0,0,0,0,0,0,0,"Druid of the Fang - On Aggro - Remove bytes_1 8 (Normal Dungeon)"); + +-- Druid of the Fang SAI for guids +SET @ENTRY := -251426; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +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 +(@ENTRY,0,0,0,4,0,100,2,0,0,0,0,22,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Druid of the Fang - On Aggro - Set Event Phase 1 (Normal Dungeon)"), +(@ENTRY,0,1,0,25,0,100,2,0,0,0,0,22,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Druid of the Fang - On Reset - Set Event Phase 0 (Normal Dungeon)"), +(@ENTRY,0,2,0,0,1,100,2,0,0,3500,4000,11,9532,64,0,0,0,0,2,0,0,0,0,0,0,0,"Druid of the Fang - In Combat CMC - Cast 'Lightning Bolt' (Phase 1) (Normal Dungeon)"), +(@ENTRY,0,3,0,0,1,100,2,37000,37000,24000,26000,80,384000,1,0,0,0,0,1,0,0,0,0,0,0,0,"Druid of the Fang - In Combat - Run Script (Phase 1) (Normal Dungeon)"), +(@ENTRY,0,4,0,0,0,100,2,8000,11000,10000,20000,11,8040,33,0,0,0,0,6,0,0,0,0,0,0,0,"Druid of the Fang - In Combat - Cast 'Druid's Slumber' (Normal Dungeon)"), +(@ENTRY,0,5,0,74,0,100,2,0,40,12000,18000,11,5187,1,0,0,0,0,9,0,0,0,0,0,0,0,"Druid of the Fang - On Friendly Between 0-40% Health - Cast 'Healing Touch' (Normal Dungeon)"), +(@ENTRY,0,6,7,1,0,100,3,1000,1000,1000,1000,11,13236,0,0,0,0,0,1,0,0,0,0,0,0,0,"Druid of the Fang - OOC - Cast 'Nature Channeling' (No Repeat) (Normal Dungeon)"), +(@ENTRY,0,7,0,61,0,100,2,0,0,0,0,90,8,0,0,0,0,0,1,0,0,0,0,0,0,0,"Druid of the Fang - OOC - Add bytes_1 8 (Normal Dungeon)"), +(@ENTRY,0,8,9,4,0,100,2,0,0,0,0,92,0,13236,1,0,0,0,1,0,0,0,0,0,0,0,"Druid of the Fang - On Aggro - Remove Aura 'Nature Channeling' (Normal Dungeon)"), +(@ENTRY,0,9,0,61,0,100,2,0,0,0,0,91,8,0,0,0,0,0,1,0,0,0,0,0,0,0,"Druid of the Fang - On Aggro - Remove bytes_1 8 (Normal Dungeon)"); + +-- Druid of the Fang SAI for guids +SET @ENTRY := -251430; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +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 +(@ENTRY,0,0,0,4,0,100,2,0,0,0,0,22,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Druid of the Fang - On Aggro - Set Event Phase 1 (Normal Dungeon)"), +(@ENTRY,0,1,0,25,0,100,2,0,0,0,0,22,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Druid of the Fang - On Reset - Set Event Phase 0 (Normal Dungeon)"), +(@ENTRY,0,2,0,0,1,100,2,0,0,3500,4000,11,9532,64,0,0,0,0,2,0,0,0,0,0,0,0,"Druid of the Fang - In Combat CMC - Cast 'Lightning Bolt' (Phase 1) (Normal Dungeon)"), +(@ENTRY,0,3,0,0,1,100,2,37000,37000,24000,26000,80,384000,1,0,0,0,0,1,0,0,0,0,0,0,0,"Druid of the Fang - In Combat - Run Script (Phase 1) (Normal Dungeon)"), +(@ENTRY,0,4,0,0,0,100,2,8000,11000,10000,20000,11,8040,33,0,0,0,0,6,0,0,0,0,0,0,0,"Druid of the Fang - In Combat - Cast 'Druid's Slumber' (Normal Dungeon)"), +(@ENTRY,0,5,0,74,0,100,2,0,40,12000,18000,11,5187,1,0,0,0,0,9,0,0,0,0,0,0,0,"Druid of the Fang - On Friendly Between 0-40% Health - Cast 'Healing Touch' (Normal Dungeon)"), +(@ENTRY,0,6,7,1,0,100,3,1000,1000,1000,1000,11,13236,0,0,0,0,0,1,0,0,0,0,0,0,0,"Druid of the Fang - OOC - Cast 'Nature Channeling' (No Repeat) (Normal Dungeon)"), +(@ENTRY,0,7,0,61,0,100,2,0,0,0,0,90,8,0,0,0,0,0,1,0,0,0,0,0,0,0,"Druid of the Fang - OOC - Add bytes_1 8 (Normal Dungeon)"), +(@ENTRY,0,8,9,4,0,100,2,0,0,0,0,92,0,13236,1,0,0,0,1,0,0,0,0,0,0,0,"Druid of the Fang - On Aggro - Remove Aura 'Nature Channeling' (Normal Dungeon)"), +(@ENTRY,0,9,0,61,0,100,2,0,0,0,0,91,8,0,0,0,0,0,1,0,0,0,0,0,0,0,"Druid of the Fang - On Aggro - Remove bytes_1 8 (Normal Dungeon)"); + +-- Druid of the Fang SAI for guids +SET @ENTRY := -251436; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +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 +(@ENTRY,0,0,0,4,0,100,2,0,0,0,0,22,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Druid of the Fang - On Aggro - Set Event Phase 1 (Normal Dungeon)"), +(@ENTRY,0,1,0,25,0,100,2,0,0,0,0,22,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Druid of the Fang - On Reset - Set Event Phase 0 (Normal Dungeon)"), +(@ENTRY,0,2,0,0,1,100,2,0,0,3500,4000,11,9532,64,0,0,0,0,2,0,0,0,0,0,0,0,"Druid of the Fang - In Combat CMC - Cast 'Lightning Bolt' (Phase 1) (Normal Dungeon)"), +(@ENTRY,0,3,0,0,1,100,2,37000,37000,24000,26000,80,384000,1,0,0,0,0,1,0,0,0,0,0,0,0,"Druid of the Fang - In Combat - Run Script (Phase 1) (Normal Dungeon)"), +(@ENTRY,0,4,0,0,0,100,2,8000,11000,10000,20000,11,8040,33,0,0,0,0,6,0,0,0,0,0,0,0,"Druid of the Fang - In Combat - Cast 'Druid's Slumber' (Normal Dungeon)"), +(@ENTRY,0,5,0,74,0,100,2,0,40,12000,18000,11,5187,1,0,0,0,0,9,0,0,0,0,0,0,0,"Druid of the Fang - On Friendly Between 0-40% Health - Cast 'Healing Touch' (Normal Dungeon)"), +(@ENTRY,0,6,7,1,0,100,3,1000,1000,1000,1000,11,13236,0,0,0,0,0,1,0,0,0,0,0,0,0,"Druid of the Fang - OOC - Cast 'Nature Channeling' (No Repeat) (Normal Dungeon)"), +(@ENTRY,0,7,0,61,0,100,2,0,0,0,0,90,8,0,0,0,0,0,1,0,0,0,0,0,0,0,"Druid of the Fang - OOC - Add bytes_1 8 (Normal Dungeon)"), +(@ENTRY,0,8,9,4,0,100,2,0,0,0,0,92,0,13236,1,0,0,0,1,0,0,0,0,0,0,0,"Druid of the Fang - On Aggro - Remove Aura 'Nature Channeling' (Normal Dungeon)"), +(@ENTRY,0,9,0,61,0,100,2,0,0,0,0,91,8,0,0,0,0,0,1,0,0,0,0,0,0,0,"Druid of the Fang - On Aggro - Remove bytes_1 8 (Normal Dungeon)"); + +-- Druid of the Fang SAI for guids +SET @ENTRY := -251437; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +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 +(@ENTRY,0,0,0,4,0,100,2,0,0,0,0,22,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Druid of the Fang - On Aggro - Set Event Phase 1 (Normal Dungeon)"), +(@ENTRY,0,1,0,25,0,100,2,0,0,0,0,22,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Druid of the Fang - On Reset - Set Event Phase 0 (Normal Dungeon)"), +(@ENTRY,0,2,0,0,1,100,2,0,0,3500,4000,11,9532,64,0,0,0,0,2,0,0,0,0,0,0,0,"Druid of the Fang - In Combat CMC - Cast 'Lightning Bolt' (Phase 1) (Normal Dungeon)"), +(@ENTRY,0,3,0,0,1,100,2,37000,37000,24000,26000,80,384000,1,0,0,0,0,1,0,0,0,0,0,0,0,"Druid of the Fang - In Combat - Run Script (Phase 1) (Normal Dungeon)"), +(@ENTRY,0,4,0,0,0,100,2,8000,11000,10000,20000,11,8040,33,0,0,0,0,6,0,0,0,0,0,0,0,"Druid of the Fang - In Combat - Cast 'Druid's Slumber' (Normal Dungeon)"), +(@ENTRY,0,5,0,74,0,100,2,0,40,12000,18000,11,5187,1,0,0,0,0,9,0,0,0,0,0,0,0,"Druid of the Fang - On Friendly Between 0-40% Health - Cast 'Healing Touch' (Normal Dungeon)"), +(@ENTRY,0,6,7,1,0,100,3,1000,1000,1000,1000,11,13236,0,0,0,0,0,1,0,0,0,0,0,0,0,"Druid of the Fang - OOC - Cast 'Nature Channeling' (No Repeat) (Normal Dungeon)"), +(@ENTRY,0,7,0,61,0,100,2,0,0,0,0,90,8,0,0,0,0,0,1,0,0,0,0,0,0,0,"Druid of the Fang - OOC - Add bytes_1 8 (Normal Dungeon)"), +(@ENTRY,0,8,9,4,0,100,2,0,0,0,0,92,0,13236,1,0,0,0,1,0,0,0,0,0,0,0,"Druid of the Fang - On Aggro - Remove Aura 'Nature Channeling' (Normal Dungeon)"), +(@ENTRY,0,9,0,61,0,100,2,0,0,0,0,91,8,0,0,0,0,0,1,0,0,0,0,0,0,0,"Druid of the Fang - On Aggro - Remove bytes_1 8 (Normal Dungeon)"); + +-- Druid of the Fang SAI for guids +SET @ENTRY := -251439; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +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 +(@ENTRY,0,0,0,4,0,100,2,0,0,0,0,22,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Druid of the Fang - On Aggro - Set Event Phase 1 (Normal Dungeon)"), +(@ENTRY,0,1,0,25,0,100,2,0,0,0,0,22,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Druid of the Fang - On Reset - Set Event Phase 0 (Normal Dungeon)"), +(@ENTRY,0,2,0,0,1,100,2,0,0,3500,4000,11,9532,64,0,0,0,0,2,0,0,0,0,0,0,0,"Druid of the Fang - In Combat CMC - Cast 'Lightning Bolt' (Phase 1) (Normal Dungeon)"), +(@ENTRY,0,3,0,0,1,100,2,37000,37000,24000,26000,80,384000,1,0,0,0,0,1,0,0,0,0,0,0,0,"Druid of the Fang - In Combat - Run Script (Phase 1) (Normal Dungeon)"), +(@ENTRY,0,4,0,0,0,100,2,8000,11000,10000,20000,11,8040,33,0,0,0,0,6,0,0,0,0,0,0,0,"Druid of the Fang - In Combat - Cast 'Druid's Slumber' (Normal Dungeon)"), +(@ENTRY,0,5,0,74,0,100,2,0,40,12000,18000,11,5187,1,0,0,0,0,9,0,0,0,0,0,0,0,"Druid of the Fang - On Friendly Between 0-40% Health - Cast 'Healing Touch' (Normal Dungeon)"), +(@ENTRY,0,6,7,1,0,100,3,1000,1000,1000,1000,11,13236,0,0,0,0,0,1,0,0,0,0,0,0,0,"Druid of the Fang - OOC - Cast 'Nature Channeling' (No Repeat) (Normal Dungeon)"), +(@ENTRY,0,7,0,61,0,100,2,0,0,0,0,90,8,0,0,0,0,0,1,0,0,0,0,0,0,0,"Druid of the Fang - OOC - Add bytes_1 8 (Normal Dungeon)"), +(@ENTRY,0,8,9,4,0,100,2,0,0,0,0,92,0,13236,1,0,0,0,1,0,0,0,0,0,0,0,"Druid of the Fang - On Aggro - Remove Aura 'Nature Channeling' (Normal Dungeon)"), +(@ENTRY,0,9,0,61,0,100,2,0,0,0,0,91,8,0,0,0,0,0,1,0,0,0,0,0,0,0,"Druid of the Fang - On Aggro - Remove bytes_1 8 (Normal Dungeon)"); + +-- Druid of the Fang SAI for guids +SET @ENTRY := -251442; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +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 +(@ENTRY,0,0,0,4,0,100,2,0,0,0,0,22,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Druid of the Fang - On Aggro - Set Event Phase 1 (Normal Dungeon)"), +(@ENTRY,0,1,0,25,0,100,2,0,0,0,0,22,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Druid of the Fang - On Reset - Set Event Phase 0 (Normal Dungeon)"), +(@ENTRY,0,2,0,0,1,100,2,0,0,3500,4000,11,9532,64,0,0,0,0,2,0,0,0,0,0,0,0,"Druid of the Fang - In Combat CMC - Cast 'Lightning Bolt' (Phase 1) (Normal Dungeon)"), +(@ENTRY,0,3,0,0,1,100,2,37000,37000,24000,26000,80,384000,1,0,0,0,0,1,0,0,0,0,0,0,0,"Druid of the Fang - In Combat - Run Script (Phase 1) (Normal Dungeon)"), +(@ENTRY,0,4,0,0,0,100,2,8000,11000,10000,20000,11,8040,33,0,0,0,0,6,0,0,0,0,0,0,0,"Druid of the Fang - In Combat - Cast 'Druid's Slumber' (Normal Dungeon)"), +(@ENTRY,0,5,0,74,0,100,2,0,40,12000,18000,11,5187,1,0,0,0,0,9,0,0,0,0,0,0,0,"Druid of the Fang - On Friendly Between 0-40% Health - Cast 'Healing Touch' (Normal Dungeon)"), +(@ENTRY,0,6,7,1,0,100,3,1000,1000,1000,1000,11,13236,0,0,0,0,0,1,0,0,0,0,0,0,0,"Druid of the Fang - OOC - Cast 'Nature Channeling' (No Repeat) (Normal Dungeon)"), +(@ENTRY,0,7,0,61,0,100,2,0,0,0,0,90,8,0,0,0,0,0,1,0,0,0,0,0,0,0,"Druid of the Fang - OOC - Add bytes_1 8 (Normal Dungeon)"), +(@ENTRY,0,8,9,4,0,100,2,0,0,0,0,92,0,13236,1,0,0,0,1,0,0,0,0,0,0,0,"Druid of the Fang - On Aggro - Remove Aura 'Nature Channeling' (Normal Dungeon)"), +(@ENTRY,0,9,0,61,0,100,2,0,0,0,0,91,8,0,0,0,0,0,1,0,0,0,0,0,0,0,"Druid of the Fang - On Aggro - Remove bytes_1 8 (Normal Dungeon)"); + +-- Deviate Adder SAI +SET @ENTRY := 5048; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +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 +(@ENTRY,0,0,0,0,0,100,2,13000,25000,15000,25000,11,744,32,0,0,0,0,2,0,0,0,0,0,0,0,"Deviate Adder - In Combat - Cast 'Poison' (Normal Dungeon)"); + +-- Deviate Crocolisk SAI +SET @ENTRY := 5053; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +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 +(@ENTRY,0,0,0,0,0,100,2,12000,20000,20000,30000,11,3604,0,0,0,0,0,2,0,0,0,0,0,0,0,"Deviate Crocolisk - In Combat - Cast 'Tendon Rip' (Normal Dungeon)"); + +-- Deviate Lasher SAI +SET @ENTRY := 5055; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +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 +(@ENTRY,0,0,0,0,0,100,2,6000,8000,10000,20000,11,7342,0,0,0,0,0,2,0,0,0,0,0,0,0,"Deviate Lasher - In Combat - Cast 'Wide Slash' (Normal Dungeon)"); + +-- Deviate Dreadfang SAI +SET @ENTRY := 5056; +UPDATE `creature_template` SET `AIName`="" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; + +-- Deviate Viper SAI +SET @ENTRY := 5755; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +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 +(@ENTRY,0,0,0,0,0,85,2,9000,13000,9000,13000,11,7947,0,0,0,0,0,2,0,0,0,0,0,0,0,"Deviate Viper - In Combat - Cast 'Localized Toxin' (Normal Dungeon)"); + +-- Deviate Venomwing SAI +SET @ENTRY := 5756; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +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 +(@ENTRY,0,0,0,0,0,100,2,2000,8000,2000,8000,11,7951,0,0,0,0,0,2,0,0,0,0,0,0,0,"Deviate Venomwing - In Combat - Cast 'Toxic Spit' (Normal Dungeon)"); + +-- Deviate Shambler SAI +SET @ENTRY := 5761; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +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 +(@ENTRY,0,0,0,2,0,100,2,0,70,21000,21000,11,7948,0,0,0,0,0,1,0,0,0,0,0,0,0,"Deviate Shambler - Between 0-70% Health - Cast 'Wild Regeneration' (Normal Dungeon)"); + +-- Verdan the Everliving SAI +SET @ENTRY := 5775; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +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 +(@ENTRY,0,0,0,0,0,100,2,20000,35000,20000,35000,11,8142,0,0,0,0,0,1,0,0,0,0,0,0,0,"Verdan the Everliving - In Combat - Cast 'Grasping Vines' (Normal Dungeon)"); + +-- Kresh SAI +SET @ENTRY := 6353; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +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 +(@ENTRY,0,0,0,0,0,100,2,6000,6000,16000,16000,11,80362,0,0,0,0,0,1,0,0,0,0,0,0,0,"Kresh - In Combat - Cast 'Crushing Bite' (Normal Dungeon)"); + +-- Respawn Gameobjects +SET @OGUID := 233555; +SET @TIMER := 60000000; -- Respawn timer in miliseconds +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+57; +INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseId`, `PhaseGroup`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES +(@OGUID+0, 13874, 43, 0, 0, 1, 169, 0, -209.9915, -42.53418, -104.4125, 0.9424766, 0, 0, 0.45399, 0.8910068, @TIMER, 255, 1, 23420), -- Serpentbloom +(@OGUID+1, 13874, 43, 0, 0, 1, 169, 0, -257.5999, -42.18737, -105.6908, 0.9424766, 0, 0, 0.45399, 0.8910068, @TIMER, 255, 1, 23420), -- Serpentbloom +(@OGUID+2, 13874, 43, 0, 0, 1, 169, 0, -198.2067, -29.08564, -105.8529, 0.9424766, 0, 0, 0.45399, 0.8910068, @TIMER, 255, 1, 23420), -- Serpentbloom +(@OGUID+3, 13891, 43, 0, 0, 1, 169, 0, -360.631, 43.2781, -100.909, 4.450591, 0, 0, -0.7933531, 0.6087617, @TIMER, 255, 1, 23420), -- Serpentbloom +(@OGUID+4, 13891, 43, 0, 0, 1, 169, 0, -223.392, -50.9034, -102.96, 3.490667, 0, 0, -0.984807, 0.1736523, @TIMER, 255, 1, 23420), -- Serpentbloom +(@OGUID+5, 13891, 43, 0, 0, 1, 169, 0, -31.3705, 268.373, -103.759, 3.438303, 0, 0, -0.9890156, 0.1478114, @TIMER, 255, 1, 23420), -- Serpentbloom +(@OGUID+6, 13891, 43, 0, 0, 1, 169, 0, -26.18467, 181.7511, -103.9451, 3.438303, 0, 0, -0.9890156, 0.1478114, @TIMER, 255, 1, 23420), -- Serpentbloom +(@OGUID+7, 13891, 43, 0, 0, 1, 169, 0, -232.6624, -48.22968, -104.3854, 0.9424766, 0, 0, 0.45399, 0.8910068, @TIMER, 255, 1, 23420), -- Serpentbloom +(@OGUID+8, 13891, 43, 0, 0, 1, 169, 0, -45.1274, 450.5822, -104.5044, 2.844883, 0, 0, 0.9890156, 0.1478114, @TIMER, 255, 1, 23420), -- Serpentbloom +(@OGUID+9, 13891, 43, 0, 0, 1, 169, 0, -95.8325, 423.05, -106.731, 2.844883, 0, 0, 0.9890156, 0.1478114, @TIMER, 255, 1, 23420), -- Serpentbloom +(@OGUID+10, 13891, 43, 0, 0, 1, 169, 0, -64.4431, 62.0624, -28.4545, 3.926996, 0, 0, -0.9238787, 0.3826855, @TIMER, 255, 1, 23420), -- Serpentbloom +(@OGUID+11, 13891, 43, 0, 0, 1, 169, 0, -111.872, -38.7467, -28.4545, 3.246347, 0, 0, -0.9986286, 0.05235322, @TIMER, 255, 1, 23420), -- Serpentbloom +(@OGUID+12, 13891, 43, 0, 0, 1, 169, 0, -196.059, 29.3717, -50.2278, 0.6457717, 0, 0, 0.3173046, 0.9483237, @TIMER, 255, 1, 23420), -- Serpentbloom +(@OGUID+13, 13891, 43, 0, 0, 1, 169, 0, -35.8711, 463.283, -54.8242, 3.351047, 0, 0, -0.9945211, 0.1045355, @TIMER, 255, 1, 23420), -- Serpentbloom +(@OGUID+14, 13891, 43, 0, 0, 1, 169, 0, 14.86238, 531.1387, -57.17266, 3.351047, 0, 0, -0.9945211, 0.1045355, @TIMER, 255, 1, 23420), -- Serpentbloom +(@OGUID+15, 13891, 43, 0, 0, 1, 169, 0, -34.85458, 368.3858, -59.371, 4.118979, 0, 0, -0.882947, 0.4694727, @TIMER, 255, 1, 23420), -- Serpentbloom +(@OGUID+16, 13891, 43, 0, 0, 1, 169, 0, 55.93252, 389.2216, -60.8304, 1.989672, 0, 0, 0.8386698, 0.5446402, @TIMER, 255, 1, 23420), -- Serpentbloom +(@OGUID+17, 13891, 43, 0, 0, 1, 169, 0, 60.8216, 459.733, -63.9568, 3.665196, 0, 0, -0.9659252, 0.2588213, @TIMER, 255, 1, 23420), -- Serpentbloom +(@OGUID+18, 13891, 43, 0, 0, 1, 169, 0, 3.27935, 411.871, -65.9418, 4.118979, 0, 0, -0.882947, 0.4694727, @TIMER, 255, 1, 23420), -- Serpentbloom +(@OGUID+19, 13891, 43, 0, 0, 1, 169, 0, -177.8481, -101.6885, -71.44215, 3.490667, 0, 0, -0.984807, 0.1736523, @TIMER, 255, 1, 23420), -- Serpentbloom +(@OGUID+20, 13891, 43, 0, 0, 1, 169, 0, -129.738, -52.69162, -76.74907, 3.490667, 0, 0, -0.984807, 0.1736523, @TIMER, 255, 1, 23420), -- Serpentbloom +(@OGUID+21, 13891, 43, 0, 0, 1, 169, 0, -46.0182, 63.2591, -85.972, 2.164206, 0, 0, 0.882947, 0.4694727, @TIMER, 255, 1, 23420), -- Serpentbloom +(@OGUID+22, 13891, 43, 0, 0, 1, 169, 0, 45.9468, 275.327, -89.1026, 4.06662, 0, 0, -0.8949337, 0.4461992, @TIMER, 255, 1, 23420), -- Serpentbloom +(@OGUID+23, 13891, 43, 0, 0, 1, 169, 0, -80.87238, 113.1952, -89.75902, 2.164206, 0, 0, 0.882947, 0.4694727, @TIMER, 255, 1, 23420), -- Serpentbloom +(@OGUID+24, 13891, 43, 0, 0, 1, 169, 0, -70.84341, 286.9297, -89.95477, 4.06662, 0, 0, -0.8949337, 0.4461992, @TIMER, 255, 1, 23420), -- Serpentbloom +(@OGUID+25, 13891, 43, 0, 0, 1, 169, 0, 28.4734, 146.89, -90.4116, 4.502952, 0, 0, -0.7771454, 0.6293211, @TIMER, 255, 1, 23420), -- Serpentbloom +(@OGUID+26, 13891, 43, 0, 0, 1, 169, 0, 75.78042, 200.2757, -92.4961, 4.502952, 0, 0, -0.7771454, 0.6293211, @TIMER, 255, 1, 23420), -- Serpentbloom +(@OGUID+27, 19535, 43, 0, 0, 1, 169, 0, -360.631, 43.2781, -100.909, 4.450591, 0, 0, -0.7933531, 0.6087617, @TIMER, 255, 1, 23420), -- Serpentbloom +(@OGUID+28, 19535, 43, 0, 0, 1, 169, 0, -223.392, -50.9034, -102.96, 3.490667, 0, 0, -0.984807, 0.1736523, @TIMER, 255, 1, 23420), -- Serpentbloom +(@OGUID+29, 19535, 43, 0, 0, 1, 169, 0, -31.3705, 268.373, -103.759, 3.438303, 0, 0, -0.9890156, 0.1478114, @TIMER, 255, 1, 23420), -- Serpentbloom +(@OGUID+30, 19535, 43, 0, 0, 1, 169, 0, -26.18467, 181.7511, -103.9451, 3.438303, 0, 0, -0.9890156, 0.1478114, @TIMER, 255, 1, 23420), -- Serpentbloom +(@OGUID+31, 19535, 43, 0, 0, 1, 169, 0, -232.6624, -48.22968, -104.3854, 0.9424766, 0, 0, 0.45399, 0.8910068, @TIMER, 255, 1, 23420), -- Serpentbloom +(@OGUID+32, 19535, 43, 0, 0, 1, 169, 0, -45.1274, 450.5822, -104.5044, 2.844883, 0, 0, 0.9890156, 0.1478114, @TIMER, 255, 1, 23420), -- Serpentbloom +(@OGUID+33, 19535, 43, 0, 0, 1, 169, 0, -95.8325, 423.05, -106.731, 2.844883, 0, 0, 0.9890156, 0.1478114, @TIMER, 255, 1, 23420), -- Serpentbloom +(@OGUID+34, 19535, 43, 0, 0, 1, 169, 0, -64.4431, 62.0624, -28.4545, 3.926996, 0, 0, -0.9238787, 0.3826855, @TIMER, 255, 1, 23420), -- Serpentbloom +(@OGUID+35, 19535, 43, 0, 0, 1, 169, 0, -111.872, -38.7467, -28.4545, 3.246347, 0, 0, -0.9986286, 0.05235322, @TIMER, 255, 1, 23420), -- Serpentbloom +(@OGUID+36, 19535, 43, 0, 0, 1, 169, 0, -196.059, 29.3717, -50.2278, 0.6457717, 0, 0, 0.3173046, 0.9483237, @TIMER, 255, 1, 23420), -- Serpentbloom +(@OGUID+37, 19535, 43, 0, 0, 1, 169, 0, -35.8711, 463.283, -54.8242, 3.351047, 0, 0, -0.9945211, 0.1045355, @TIMER, 255, 1, 23420), -- Serpentbloom +(@OGUID+38, 19535, 43, 0, 0, 1, 169, 0, 14.86238, 531.1387, -57.17266, 3.351047, 0, 0, -0.9945211, 0.1045355, @TIMER, 255, 1, 23420), -- Serpentbloom +(@OGUID+39, 19535, 43, 0, 0, 1, 169, 0, -34.85458, 368.3858, -59.371, 4.118979, 0, 0, -0.882947, 0.4694727, @TIMER, 255, 1, 23420), -- Serpentbloom +(@OGUID+40, 19535, 43, 0, 0, 1, 169, 0, 55.93252, 389.2216, -60.8304, 1.989672, 0, 0, 0.8386698, 0.5446402, @TIMER, 255, 1, 23420), -- Serpentbloom +(@OGUID+41, 19535, 43, 0, 0, 1, 169, 0, 60.8216, 459.733, -63.9568, 3.665196, 0, 0, -0.9659252, 0.2588213, @TIMER, 255, 1, 23420), -- Serpentbloom +(@OGUID+42, 19535, 43, 0, 0, 1, 169, 0, 3.27935, 411.871, -65.9418, 4.118979, 0, 0, -0.882947, 0.4694727, @TIMER, 255, 1, 23420), -- Serpentbloom +(@OGUID+43, 19535, 43, 0, 0, 1, 169, 0, -177.8481, -101.6885, -71.44215, 3.490667, 0, 0, -0.984807, 0.1736523, @TIMER, 255, 1, 23420), -- Serpentbloom +(@OGUID+44, 19535, 43, 0, 0, 1, 169, 0, -129.738, -52.69162, -76.74907, 3.490667, 0, 0, -0.984807, 0.1736523, @TIMER, 255, 1, 23420), -- Serpentbloom +(@OGUID+45, 19535, 43, 0, 0, 1, 169, 0, -46.0182, 63.2591, -85.972, 2.164206, 0, 0, 0.882947, 0.4694727, @TIMER, 255, 1, 23420), -- Serpentbloom +(@OGUID+46, 19535, 43, 0, 0, 1, 169, 0, 45.9468, 275.327, -89.1026, 4.06662, 0, 0, -0.8949337, 0.4461992, @TIMER, 255, 1, 23420), -- Serpentbloom +(@OGUID+47, 19535, 43, 0, 0, 1, 169, 0, -80.87238, 113.1952, -89.75902, 2.164206, 0, 0, 0.882947, 0.4694727, @TIMER, 255, 1, 23420), -- Serpentbloom +(@OGUID+48, 19535, 43, 0, 0, 1, 169, 0, -70.84341, 286.9297, -89.95477, 4.06662, 0, 0, -0.8949337, 0.4461992, @TIMER, 255, 1, 23420), -- Serpentbloom +(@OGUID+49, 19535, 43, 0, 0, 1, 169, 0, 28.4734, 146.89, -90.4116, 4.502952, 0, 0, -0.7771454, 0.6293211, @TIMER, 255, 1, 23420), -- Serpentbloom +(@OGUID+50, 19535, 43, 0, 0, 1, 169, 0, 75.78042, 200.2757, -92.4961, 4.502952, 0, 0, -0.7771454, 0.6293211, @TIMER, 255, 1, 23420), -- Serpentbloom +(@OGUID+51, 56817, 43, 0, 0, 1, 169, 0, 129.4654, 43.31452, -30.80008, 3.141593, 0, 0, -1, 0, 7200, 255, 1, 23420), -- Campfire +(@OGUID+52, 56818, 43, 0, 0, 1, 169, 0, -350.4899, 23.14318, -100.9907, 3.150867, -0.05369282, 0.0398283, -0.9977598, 0.002477757, 7200, 255, 1, 23420), -- Campfire +(@OGUID+53, 56819, 43, 0, 0, 1, 169, 0, 36.48618, 186.3279, -87.64468, 2.755255, 0.0560317, 0.008135796, 0.9800186, 0.1906773, 7200, 255, 1, 23420), -- Campfire +(@OGUID+54, 56821, 43, 0, 0, 1, 169, 0, -148.8366, -51.45358, -78.26205, 3.140018, -0.02121353, -0.1102934, -0.9936714, 0.001563263, 7200, 255, 1, 23420), -- Campfire +(@OGUID+55, 60393, 43, 0, 0, 1, 169, 0, -228.1162, 40.64894, -82.31574, 3.151592, 0.008464813, 0.02244949, -0.9996986, 0.005190501, 7200, 255, 1, 23420), -- Campfire +(@OGUID+56, 146087, 43, 0, 0, 1, 169, 0, 130.2995, 49.10317, -33.19909, 3.141593, 0, 0, -1, 0, 7200, 255, 1, 23420), -- Bonfire +(@OGUID+57, 146091, 43, 0, 0, 1, 169, 0, -136.9158, 414.7041, -72.73704, 4.428019, -0.02116394, 0.0008745193, -0.8001251, 0.599459, 7200, 255, 1, 23420); -- Bonfire + +-- Wailing Caverns Earthroot herb spawns +SET @OGUID := 233613; +SET @MOTHER := 4300; +SET @LASTGUID := 2; +SET @ACTIVE := 2; -- Max number of active spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID AND @OGUID+@LASTGUID; +INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `PhaseGroup`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES +(@OGUID+0, 1619, 43, 0, 0, 1, 169, 0, -53.0091, 389.589, -61.6968, 5.201083, 0, 0, -0.5150375, 0.8571676, @TIMER, 255, 1, 23420), -- Earthroot +(@OGUID+1, 1619, 43, 0, 0, 1, 169, 0, 47.5179, 517.586, -58.1344, 0.5410506, 0, 0, 0.2672377, 0.9636307, @TIMER, 255, 1, 23420), -- Earthroot +(@OGUID+2, 1619, 43, 0, 0, 1, 169, 0, -121.701, 462.537, -72.2603, 3.647741, 0, 0, -0.9681473, 0.2503814, @TIMER, 255, 1, 23420); -- Earthroot + +-- Add mother pool to pool template +DELETE FROM `pool_template` WHERE `entry`=@MOTHER; +INSERT INTO `pool_template` (`entry`,`max_limit`,`description`) VALUES +(@MOTHER,@ACTIVE, 'Wailing Caverns Earthroot Mother pool'); + +-- Pool Earthroot Spawnpoints +DELETE FROM `pool_gameobject` WHERE `guid` BETWEEN @OGUID AND @OGUID+@LASTGUID; +INSERT INTO `pool_gameobject` (`guid`,`pool_entry`,`chance`,`description`) VALUES +(@OGUID+0,@MOTHER,0, 'Wailing Caverns Earthroot Spawnpoint'), +(@OGUID+1,@MOTHER,0, 'Wailing Caverns Earthroot Spawnpoint'), +(@OGUID+2,@MOTHER,0, 'Wailing Caverns Earthroot Spawnpoint'); + +-- Wailing Caverns Kingsblood herb spawns +SET @OGUID := 233616; +SET @MOTHER := 4301; +SET @LASTGUID := 6; +SET @ACTIVE := 2; -- Max number of active spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID AND @OGUID+@LASTGUID; +INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `PhaseGroup`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES +(@OGUID+0, 1624, 43, 0, 0, 1, 169, 0, -96.1374, 181.974, -78.5475, 3.57793, 0, 0, -0.9762955, 0.2164421, @TIMER, 255, 1, 23420), -- Kingsblood +(@OGUID+1, 1624, 43, 0, 0, 1, 169, 0, -60.23, 298.535, -90.2058, 1.692969, 0, 0, 0.7489557, 0.6626201, @TIMER, 255, 1, 23420), -- Kingsblood +(@OGUID+2, 1624, 43, 0, 0, 1, 169, 0, -51.4081, 367.112, -59.5331, 2.321287, 0, 0, 0.9170599, 0.3987495, @TIMER, 255, 1, 23420), -- Kingsblood +(@OGUID+3, 1624, 43, 0, 0, 1, 169, 0, -78.179, 91.6621, -90.2385, 0.6283169, 0, 0, 0.3090162, 0.9510568, @TIMER, 255, 1, 23420), -- Kingsblood +(@OGUID+4, 1624, 43, 0, 0, 1, 169, 0, -107.223, 254.789, -90.8108, 0.5410506, 0, 0, 0.2672377, 0.9636307, @TIMER, 255, 1, 23420), -- Kingsblood +(@OGUID+5, 1624, 43, 0, 0, 1, 169, 0, -84.2777, 201.452, -92.3064, 3.996807, 0, 0, -0.9099607, 0.4146944, @TIMER, 255, 1, 23420), -- Kingsblood +(@OGUID+6, 1624, 43, 0, 0, 1, 169, 0, 54.5991, 194.487, -90.1453, 5.899214, 0, 0, -0.1908083, 0.9816273, @TIMER, 255, 1, 23420); -- Kingsblood + +-- Add mother pool to pool template +DELETE FROM `pool_template` WHERE `entry`=@MOTHER; +INSERT INTO `pool_template` (`entry`,`max_limit`,`description`) VALUES +(@MOTHER,@ACTIVE, 'Wailing Caverns Kingsblood Mother pool'); + +-- Pool Kingsblood Spawnpoints +DELETE FROM `pool_gameobject` WHERE `guid` BETWEEN @OGUID AND @OGUID+@LASTGUID; +INSERT INTO `pool_gameobject` (`guid`,`pool_entry`,`chance`,`description`) VALUES +(@OGUID+0,@MOTHER,0, 'Wailing Caverns Kingsblood Spawnpoint'), +(@OGUID+1,@MOTHER,0, 'Wailing Caverns Kingsblood Spawnpoint'), +(@OGUID+2,@MOTHER,0, 'Wailing Caverns Kingsblood Spawnpoint'), +(@OGUID+3,@MOTHER,0, 'Wailing Caverns Kingsblood Spawnpoint'), +(@OGUID+4,@MOTHER,0, 'Wailing Caverns Kingsblood Spawnpoint'), +(@OGUID+5,@MOTHER,0, 'Wailing Caverns Kingsblood Spawnpoint'), +(@OGUID+6,@MOTHER,0, 'Wailing Caverns Kingsblood Spawnpoint'); + +-- Wailing Caverns Copper Vein spawns +SET @OGUID := 233623; +SET @MOTHER := 4302; +SET @LASTGUID := 2; +SET @ACTIVE := 1; -- Max number of active spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID AND @OGUID+@LASTGUID; +INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `PhaseGroup`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES +(@OGUID+0, 1731, 43, 0, 0, 1, 169, 0, -12.9076, 366.047, -59.3451, 5.846854, 0, 0, -0.2164392, 0.9762961, @TIMER, 255, 1, 23420), -- Copper Vein +(@OGUID+1, 1731, 43, 0, 0, 1, 169, 0, -161.053, 411.129, -72.5271, 3.019413, 0, 0, 0.9981346, 0.06105176, @TIMER, 255, 1, 23420), -- Copper Vein +(@OGUID+2, 1731, 43, 0, 0, 1, 169, 0, 11.0334, 528.04, -57.3123, 1.256636, 0, 0, 0.5877848, 0.8090174, @TIMER, 255, 1, 23420); -- Copper Vein + +-- Add mother pool to pool template +DELETE FROM `pool_template` WHERE `entry`=@MOTHER; +INSERT INTO `pool_template` (`entry`,`max_limit`,`description`) VALUES +(@MOTHER,@ACTIVE, 'Wailing Caverns Copper Vein Mother pool'); + +-- Pool Copper Vein Spawnpoints +DELETE FROM `pool_gameobject` WHERE `guid` BETWEEN @OGUID AND @OGUID+@LASTGUID; +INSERT INTO `pool_gameobject` (`guid`,`pool_entry`,`chance`,`description`) VALUES +(@OGUID+0,@MOTHER,0, 'Wailing Caverns Copper Vein Spawnpoint'), +(@OGUID+1,@MOTHER,0, 'Wailing Caverns Copper Vein Spawnpoint'), +(@OGUID+2,@MOTHER,0, 'Wailing Caverns Copper Vein Spawnpoint'); + +-- Wailing Caverns Tin / Silver Vein pool +SET @OGUID1 := 233626; +SET @OGUID2 := 233629; +SET @POOL := 4303; +SET @LASTGUID := 2; +SET @MOTHER := 4303; +SET @ACTIVE := 1; -- Max number of active spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID1 AND @OGUID1+@LASTGUID; +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID2 AND @OGUID2+@LASTGUID; +INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `PhaseGroup`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES +(@OGUID1+0, 1732, 43, 0, 0, 1, 169, 0, 45.3749, 529.187, -55.8656, 2.722713, 0, 0, 0.9781475, 0.2079121, @TIMER, 255, 1, 23420), -- Tin Vein +(@OGUID1+1, 1732, 43, 0, 0, 1, 169, 0, -32.2606, 43.5227, -117.543, 2.268925, 0, 0, 0.9063072, 0.4226195, @TIMER, 255, 1, 23420), -- Tin Vein +(@OGUID1+2, 1732, 43, 0, 0, 1, 169, 0, -52.6802, 387.592, -61.6997, 6.178466, 0, 0, -0.05233574, 0.9986296, @TIMER, 255, 1, 23420), -- Tin Vein +(@OGUID2+0, 1733, 43, 0, 0, 1, 169, 0, 45.3749, 529.187, -55.8656, 2.722713, 0, 0, 0.9781475, 0.2079121, @TIMER, 255, 1, 23420), -- Silver Vein +(@OGUID2+1, 1733, 43, 0, 0, 1, 169, 0, -32.2606, 43.5227, -117.543, 2.268925, 0, 0, 0.9063072, 0.4226195, @TIMER, 255, 1, 23420), -- Silver Vein +(@OGUID2+2, 1733, 43, 0, 0, 1, 169, 0, -52.6802, 387.592, -61.6997, 6.178466, 0, 0, -0.05233574, 0.9986296, @TIMER, 255, 1, 23420); -- Silver Vein + +-- Add mother pool to pool template +DELETE FROM `pool_template` WHERE `entry`=@MOTHER; +INSERT INTO `pool_template` (`entry`,`max_limit`,`description`) VALUES +(@MOTHER,@ACTIVE, 'Wailing Caverns Tin / Silver Mother pool'); + +-- Pool Ore Spawnpoints +DELETE FROM `pool_gameobject` WHERE `guid` BETWEEN @OGUID1 AND @OGUID1+@LASTGUID; +DELETE FROM `pool_gameobject` WHERE `guid` BETWEEN @OGUID2 AND @OGUID2+@LASTGUID; +INSERT INTO `pool_gameobject` (`guid`,`pool_entry`,`chance`,`description`) VALUES +(@OGUID1+0,@POOL+0,80, 'Tin Deposit'), +(@OGUID2+0,@POOL+0,20, 'Silver Deposit'), +(@OGUID1+1,@POOL+1,80, 'Tin Deposit'), +(@OGUID2+1,@POOL+1,20, 'Silver Deposit'), +(@OGUID1+2,@POOL+2,80, 'Tin Deposit'), +(@OGUID2+2,@POOL+2,20, 'Silver Deposit'); + +-- Wailing Caverns Liferoot spawns +SET @OGUID := 233632; +SET @MOTHER := 4304; +SET @LASTGUID := 2; +SET @ACTIVE := 1; -- Max number of active spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID AND @OGUID+@LASTGUID; +INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `PhaseGroup`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES +(@OGUID+0, 2041, 43, 0, 0, 1, 169, 0, -15.1086, 190.488, -105.497, 2.303831, 0, 0, 0.9135447, 0.4067384, @TIMER, 255, 1, 23420), -- Liferoot +(@OGUID+1, 2041, 43, 0, 0, 1, 169, 0, -167.482, 43.7933, -105.824, 2.879789, 0, 0, 0.9914446, 0.1305283, @TIMER, 255, 1, 23420), -- Liferoot +(@OGUID+2, 2041, 43, 0, 0, 1, 169, 0, -33.4606, 282.588, -105.51, 6.143561, 0, 0, -0.06975555, 0.9975641, @TIMER, 255, 1, 23420); -- Liferoot + +-- Add mother pool to pool template +DELETE FROM `pool_template` WHERE `entry`=@MOTHER; +INSERT INTO `pool_template` (`entry`,`max_limit`,`description`) VALUES +(@MOTHER,@ACTIVE, 'Wailing Caverns Liferoot Mother pool'); + +-- Pool Liferoot Spawnpoints +DELETE FROM `pool_gameobject` WHERE `guid` BETWEEN @OGUID AND @OGUID+@LASTGUID; +INSERT INTO `pool_gameobject` (`guid`,`pool_entry`,`chance`,`description`) VALUES +(@OGUID+0,@MOTHER,0, 'Wailing Caverns Liferoot Spawnpoint'), +(@OGUID+1,@MOTHER,0, 'Wailing Caverns Liferoot Spawnpoint'), +(@OGUID+2,@MOTHER,0, 'Wailing Caverns Liferoot Spawnpoint'); + +-- Wailing Caverns Large Battered Chest spawns +SET @OGUID := 233635; +SET @MOTHER := 4305; +SET @LASTGUID := 1; +SET @ACTIVE := 1; -- Max number of active spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID AND @OGUID+@LASTGUID; +INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `PhaseGroup`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES +(@OGUID+0, 75293, 43, 0, 0, 1, 169, 0, -49.9295, 370.574, -59.6856, 0.5759573, 0, 0, 0.2840147, 0.9588199, @TIMER, 255, 1, 23420), -- Large Battered Chest +(@OGUID+1, 75293, 43, 0, 0, 1, 169, 0, 29.6232, 531.781, -56.9991, 5.585054, 0, 0, -0.34202, 0.9396927, @TIMER, 255, 1, 23420); -- Large Battered Chest + +-- Add mother pool to pool template +DELETE FROM `pool_template` WHERE `entry`=@MOTHER; +INSERT INTO `pool_template` (`entry`,`max_limit`,`description`) VALUES +(@MOTHER,@ACTIVE, 'Wailing Caverns Large Battered Chest Mother pool'); + +-- Pool Large Battered Chest Spawnpoints +DELETE FROM `pool_gameobject` WHERE `guid` BETWEEN @OGUID AND @OGUID+@LASTGUID; +INSERT INTO `pool_gameobject` (`guid`,`pool_entry`,`chance`,`description`) VALUES +(@OGUID+0,@MOTHER,0, 'Wailing Caverns Large Battered Chest Spawnpoint'), +(@OGUID+1,@MOTHER,0, 'Wailing Caverns Large Battered Chest Spawnpoint'); |