diff options
author | Aqua Deus <95978183+aquadeus@users.noreply.github.com> | 2022-11-17 19:24:37 +0100 |
---|---|---|
committer | Naddley <NaddleyTC@gmail.com> | 2022-11-17 19:24:40 +0100 |
commit | dec28db21910b486f596854fd2836923fdb29461 (patch) | |
tree | 6f2f0d2fad529330ed29307fa77bfe79897c8ae4 /sql | |
parent | 75c06d25da76f0c4f0ea680e6f5ed1bc3bf1d42e (diff) |
DB/Azsuna: Added spawns for Mak'rana
Closes #28521
Diffstat (limited to 'sql')
-rw-r--r-- | sql/updates/world/master/2022_11_17_00_world.sql | 705 |
1 files changed, 705 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_11_17_00_world.sql b/sql/updates/world/master/2022_11_17_00_world.sql new file mode 100644 index 00000000000..12fee088bfb --- /dev/null +++ b/sql/updates/world/master/2022_11_17_00_world.sql @@ -0,0 +1,705 @@ +SET @CGUID := 651669; +SET @OGUID := 400488; + +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+149; +INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES +(@CGUID+0, 101554, 1220, 7334, 7345, '0', 0, 0, 0, 0, -689.13336181640625, 6007.201171875, 1.870394229888916015, 0.562384366989135742, 120, 10, 0, 3923, 0, 1, 0, 0, 0, 46597), -- Spikebacked Scuttler (Area: Mak'rana - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+1, 64806, 1220, 7334, 7345, '0', 0, 0, 0, 0, -783.5057373046875, 5974.02783203125, 2.464088201522827148, 2.328577280044555664, 120, 10, 0, 5, 0, 1, 0, 0, 0, 46597), -- Rapana Whelk (Area: Mak'rana - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+2, 89053, 1220, 7334, 7345, '0', 0, 0, 0, 0, -711.3212, 5985.228, 0.5369594, 1.141662955284118652, 120, 0, 0, 4904, 0, 2, 0, 0, 0, 46597), -- Mak'rana Warrior (Area: Mak'rana - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+3, 89290, 1220, 7334, 7345, '0', 0, 0, 0, 0, -930.6961669921875, 5652.0068359375, 37.20207595825195312, 0.436446815729141235, 120, 0, 0, 3923, 0, 0, 0, 0, 0, 46597), -- Queen's Reprisal Sailor (Area: Mak'rana - Difficulty: 0) (Auras: 178755 - Sea-Brine Toxin) +(@CGUID+4, 97289, 1220, 7334, 7345, '0', 0, 0, 0, 0, -763.97186279296875, 5990.7255859375, 2.011233806610107421, 6.142117023468017578, 120, 10, 0, 27, 0, 1, 0, 0, 0, 46597), -- Juvenile Scuttleback (Area: Mak'rana - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+5, 89053, 1220, 7334, 7345, '0', 0, 0, 0, 0, -744.5399169921875, 5948.4296875, 2.941475391387939453, 1.003609538078308105, 120, 0, 0, 4904, 0, 0, 0, 0, 0, 46597), -- Mak'rana Warrior (Area: Mak'rana - Difficulty: 0) +(@CGUID+6, 89286, 1220, 7334, 7345, '0', 0, 0, 0, 0, -936.05206298828125, 5943.8515625, 3.194363832473754882, 5.762143611907958984, 120, 0, 0, 7846, 2301, 0, 0, 0, 0, 46597), -- Mak'rana Elder (Area: Mak'rana - Difficulty: 0) (Auras: ) +(@CGUID+7, 89053, 1220, 7334, 7345, '0', 0, 0, 0, 0, -709.0643, 5595.479, -2.430486, 1.179183244705200195, 120, 0, 0, 4904, 0, 2, 0, 0, 0, 46597), -- Mak'rana Warrior (Area: Mak'rana - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+8, 64352, 1220, 7334, 7345, '0', 0, 0, 0, 0, -681.49176025390625, 6032.66064453125, 2.816641569137573242, 3.168929815292358398, 120, 10, 0, 5, 0, 1, 0, 0, 0, 46597), -- Rapana Whelk (Area: Mak'rana - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+9, 89290, 1220, 7334, 7345, '0', 0, 0, 0, 0, -708.78125, 5916.7890625, 1.766021490097045898, 3.55776524543762207, 120, 0, 0, 3923, 0, 0, 0, 0, 0, 46597), -- Queen's Reprisal Sailor (Area: Mak'rana - Difficulty: 0) (Auras: 178755 - Sea-Brine Toxin) +(@CGUID+10, 89284, 1220, 7334, 7345, '0', 0, 0, 0, 1, -771.75177001953125, 5977.1416015625, 2.47569441795349121, 2.616752862930297851, 120, 0, 0, 3923, 1534, 0, 0, 0, 0, 46597), -- Bitterbrine Saltcaster (Area: Mak'rana - Difficulty: 0) (Auras: 12550 - Lightning Shield) +(@CGUID+11, 89288, 1220, 7334, 7345, '0', 0, 0, 0, 0, -698.5947265625, 5734.54443359375, 0.352509260177612304, 1.617682695388793945, 120, 10, 0, 1569, 0, 1, 0, 0, 0, 46597), -- Scuttleback Pincher (Area: Mak'rana - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+12, 89288, 1220, 7334, 7345, '0', 0, 0, 0, 0, -754.38726806640625, 6020.60986328125, 1.887940406799316406, 0.351689130067825317, 120, 10, 0, 1569, 0, 1, 0, 0, 0, 46597), -- Scuttleback Pincher (Area: Mak'rana - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+13, 89284, 1220, 7334, 7345, '0', 0, 0, 0, 1, -710.97052001953125, 5916.876953125, 1.920877933502197265, 0.057441189885139465, 120, 0, 0, 3923, 1534, 0, 0, 0, 0, 46597), -- Bitterbrine Saltcaster (Area: Mak'rana - Difficulty: 0) (Auras: 12550 - Lightning Shield) +(@CGUID+14, 89053, 1220, 7334, 7345, '0', 0, 0, 0, 0, -777.06768798828125, 5916.1005859375, 2.8125, 1.409508943557739257, 120, 0, 0, 4904, 0, 0, 0, 0, 0, 46597), -- Mak'rana Warrior (Area: Mak'rana - Difficulty: 0) +(@CGUID+15, 64806, 1220, 7334, 7345, '0', 0, 0, 0, 0, -764.37591552734375, 5911.1484375, 3.006792306900024414, 5.625226497650146484, 120, 10, 0, 5, 0, 1, 0, 0, 0, 46597), -- Rapana Whelk (Area: Mak'rana - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+16, 101554, 1220, 7334, 7345, '0', 0, 0, 0, 0, -652.521484375, 5679.83935546875, 4.565501213073730468, 2.900879383087158203, 120, 0, 0, 3923, 0, 0, 0, 0, 0, 46597), -- Spikebacked Scuttler (Area: Mak'rana - Difficulty: 0) +(@CGUID+17, 89283, 1220, 7334, 7345, '0', 0, 0, 0, 1, -804.04864501953125, 5947.0224609375, 4.397569656372070312, 1.817821025848388671, 120, 0, 0, 3923, 0, 0, 0, 0, 0, 46597), -- Bitterbrine Venomer (Area: Mak'rana - Difficulty: 0) +(@CGUID+18, 89289, 1220, 7334, 7345, '0', 0, 0, 0, 0, -781.234375, 5916.99853515625, 2.846606969833374023, 1.072130560874938964, 120, 0, 0, 3923, 0, 0, 0, 0, 0, 46597), -- Queen's Reprisal Sailor (Area: Mak'rana - Difficulty: 0) (Auras: 178755 - Sea-Brine Toxin) +(@CGUID+19, 89288, 1220, 7334, 7345, '0', 0, 0, 0, 0, -708.25518798828125, 5997.1875, 3.394556999206542968, 5.960509300231933593, 120, 10, 0, 1569, 0, 1, 0, 0, 0, 46597), -- Scuttleback Pincher (Area: Mak'rana - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+20, 89290, 1220, 7334, 7345, '0', 0, 0, 0, 0, -804.37677001953125, 5949.0224609375, 4.439236164093017578, 5.005830287933349609, 120, 0, 0, 3923, 0, 0, 0, 0, 0, 46597), -- Queen's Reprisal Sailor (Area: Mak'rana - Difficulty: 0) (Auras: 178755 - Sea-Brine Toxin) +(@CGUID+21, 89283, 1220, 7334, 7345, '0', 0, 0, 0, 1, -710.07464599609375, 5998.6259765625, 3.009014606475830078, 1.244073867797851562, 120, 0, 0, 3923, 0, 0, 0, 0, 0, 46597), -- Bitterbrine Venomer (Area: Mak'rana - Difficulty: 0) +(@CGUID+22, 97283, 1220, 7334, 7345, '0', 0, 0, 0, 0, -690.22125244140625, 5740.53271484375, 1.549711227416992187, 5.154623985290527343, 120, 10, 0, 1, 0, 1, 0, 0, 0, 46597), -- Juvenile Scuttleback (Area: Mak'rana - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+23, 89289, 1220, 7334, 7345, '0', 0, 0, 0, 0, -693.48614501953125, 5696.36181640625, 3.501497507095336914, 5.049466609954833984, 120, 0, 0, 3923, 0, 0, 0, 0, 0, 46597), -- Queen's Reprisal Sailor (Area: Mak'rana - Difficulty: 0) (Auras: 178755 - Sea-Brine Toxin) +(@CGUID+24, 89284, 1220, 7334, 7345, '0', 0, 0, 0, 1, -738.32989501953125, 5984.50244140625, 0.935957133769989013, 5.280282974243164062, 120, 0, 0, 3923, 1534, 0, 0, 0, 0, 46597), -- Bitterbrine Saltcaster (Area: Mak'rana - Difficulty: 0) (Auras: 12550 - Lightning Shield) +(@CGUID+25, 89288, 1220, 7334, 7345, '0', 0, 0, 0, 0, -769.936279296875, 5989.41748046875, 2.156656980514526367, 2.110044002532958984, 120, 10, 0, 1569, 0, 1, 0, 0, 0, 46597), -- Scuttleback Pincher (Area: Mak'rana - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+26, 89283, 1220, 7334, 7345, '0', 0, 0, 0, 1, -692.58856201171875, 5697.40380859375, 3.774336099624633789, 5.737927436828613281, 120, 0, 0, 3923, 0, 0, 0, 0, 0, 46597), -- Bitterbrine Venomer (Area: Mak'rana - Difficulty: 0) +(@CGUID+27, 101554, 1220, 7334, 7345, '0', 0, 0, 0, 0, -666.025146484375, 5656.81396484375, 2.802095413208007812, 1.656857728958129882, 120, 0, 0, 3923, 0, 0, 0, 0, 0, 46597), -- Spikebacked Scuttler (Area: Mak'rana - Difficulty: 0) +(@CGUID+28, 89288, 1220, 7334, 7345, '0', 0, 0, 0, 0, -749.388671875, 6008.5966796875, 2.041749000549316406, 3.970101356506347656, 120, 10, 0, 1569, 0, 1, 0, 0, 0, 46597), -- Scuttleback Pincher (Area: Mak'rana - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+29, 97289, 1220, 7334, 7345, '0', 0, 0, 0, 0, -800.7266845703125, 5899.96240234375, 2.51340341567993164, 6.198788642883300781, 120, 10, 0, 27, 0, 1, 0, 0, 0, 46597), -- Juvenile Scuttleback (Area: Mak'rana - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+30, 89053, 1220, 7334, 7345, '0', 0, 0, 0, 0, -770.670166015625, 5490.3759765625, -0.55258840322494506, 3.772028446197509765, 120, 0, 0, 4904, 0, 0, 0, 0, 0, 46597), -- Mak'rana Warrior (Area: Mak'rana - Difficulty: 0) +(@CGUID+31, 89289, 1220, 7334, 7345, '0', 0, 0, 0, 0, -913.171875, 5642.4912109375, 32.89356613159179687, 2.341995000839233398, 120, 0, 0, 3923, 0, 0, 0, 0, 0, 46597), -- Queen's Reprisal Sailor (Area: Mak'rana - Difficulty: 0) (Auras: 178755 - Sea-Brine Toxin) +(@CGUID+32, 89283, 1220, 7334, 7345, '0', 0, 0, 0, 1, -686.66668701171875, 5657.2099609375, 4.953171253204345703, 4.081254005432128906, 120, 0, 0, 3923, 0, 0, 0, 0, 0, 46597), -- Bitterbrine Venomer (Area: Mak'rana - Difficulty: 0) +(@CGUID+33, 89053, 1220, 7334, 7345, '0', 0, 0, 0, 0, -950.7327, 5675.124, 34.05275, 4.02970743179321289, 120, 0, 0, 4904, 0, 2, 0, 0, 0, 46597), -- Mak'rana Warrior (Area: Mak'rana - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+34, 101554, 1220, 7334, 7345, '0', 0, 0, 0, 0, -690.636962890625, 5610.40478515625, -2.34518766403198242, 0.549605548381805419, 120, 10, 0, 3923, 0, 1, 0, 0, 0, 46597), -- Spikebacked Scuttler (Area: Mak'rana - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+35, 89284, 1220, 7334, 7345, '0', 0, 0, 0, 1, -710.9479, 5908.113, 1.806597, 1.462139010429382324, 120, 0, 0, 3923, 1534, 2, 0, 0, 0, 46597), -- Bitterbrine Saltcaster (Area: Mak'rana - Difficulty: 0) (Auras: 12550 - Lightning Shield) (possible waypoints or random movement) +(@CGUID+36, 89053, 1220, 7334, 7345, '0', 0, 0, 0, 0, -896.875, 5896.385, -0.3996313, 3.431554079055786132, 120, 0, 0, 4904, 0, 2, 0, 0, 0, 46597), -- Mak'rana Warrior (Area: Mak'rana - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+37, 89284, 1220, 7334, 7345, '0', 0, 0, 0, 1, -743.703125, 5878.24462890625, 4.12906503677368164, 1.946715235710144042, 120, 0, 0, 3923, 1534, 0, 0, 0, 0, 46597), -- Bitterbrine Saltcaster (Area: Mak'rana - Difficulty: 0) (Auras: 12550 - Lightning Shield) +(@CGUID+38, 89288, 1220, 7334, 7345, '0', 0, 0, 0, 0, -827.16656494140625, 5894.4482421875, 0.755686283111572265, 2.408051013946533203, 120, 10, 0, 1569, 0, 1, 0, 0, 0, 46597), -- Scuttleback Pincher (Area: Mak'rana - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+39, 89288, 1220, 7334, 7345, '0', 0, 0, 0, 0, -822.84417724609375, 5884.271484375, 5.111865997314453125, 5.82041168212890625, 120, 10, 0, 1569, 0, 1, 0, 0, 0, 46597), -- Scuttleback Pincher (Area: Mak'rana - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+40, 89290, 1220, 7334, 7345, '0', 0, 0, 0, 0, -744.265625, 5879.64501953125, 4.332378864288330078, 4.708409309387207031, 120, 0, 0, 3923, 0, 0, 0, 0, 0, 46597), -- Queen's Reprisal Sailor (Area: Mak'rana - Difficulty: 0) (Auras: 178755 - Sea-Brine Toxin) +(@CGUID+41, 89289, 1220, 7334, 7345, '0', 0, 0, 0, 0, -799.685791015625, 5868.62255859375, 1.541367530822753906, 6.175427436828613281, 120, 0, 0, 3923, 0, 0, 0, 0, 0, 46597), -- Queen's Reprisal Sailor (Area: Mak'rana - Difficulty: 0) (Auras: 178755 - Sea-Brine Toxin) +(@CGUID+42, 97289, 1220, 7334, 7345, '0', 0, 0, 0, 0, -874.9893798828125, 5950.03466796875, 7.187307357788085937, 1.583783268928527832, 120, 10, 0, 27, 0, 1, 0, 0, 0, 46597), -- Juvenile Scuttleback (Area: Mak'rana - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+43, 89283, 1220, 7334, 7345, '0', 0, 0, 0, 1, -842.73785400390625, 5885.6494140625, 1.684027791023254394, 4.200669288635253906, 120, 0, 0, 3923, 0, 0, 0, 0, 0, 46597), -- Bitterbrine Venomer (Area: Mak'rana - Difficulty: 0) +(@CGUID+44, 109349, 1220, 7334, 7345, '0', 0, 0, 0, 0, -882.7501220703125, 5987.525390625, 11.30401802062988281, 4.235286235809326171, 120, 10, 0, 3923, 0, 1, 0, 0, 0, 46597), -- Veil Shadowrunner (Area: Mak'rana - Difficulty: 0) (Auras: 123169 - Mod Scale 105-110%, 221736 - Aura of Lethargy) (possible waypoints or random movement) +(@CGUID+45, 89053, 1220, 7334, 7345, '0', 0, 0, 0, 0, -795.67535400390625, 5867.384765625, -1.56344759464263916, 2.980122089385986328, 120, 0, 0, 4904, 0, 0, 0, 0, 0, 46597), -- Mak'rana Warrior (Area: Mak'rana - Difficulty: 0) +(@CGUID+46, 109349, 1220, 7334, 7345, '0', 0, 0, 0, 0, -868.86016845703125, 6007.9375, 12.59963321685791015, 3.145498991012573242, 120, 0, 0, 3923, 0, 0, 0, 0, 0, 46597), -- Veil Shadowrunner (Area: Mak'rana - Difficulty: 0) (Auras: 123169 - Mod Scale 105-110%, 221736 - Aura of Lethargy) +(@CGUID+47, 89290, 1220, 7334, 7345, '0', 0, 0, 0, 0, -800.30206298828125, 5867.0087890625, 1.552263259887695312, 0.092810094356536865, 120, 0, 0, 3923, 0, 0, 0, 0, 0, 46597), -- Queen's Reprisal Sailor (Area: Mak'rana - Difficulty: 0) (Auras: 178755 - Sea-Brine Toxin) +(@CGUID+48, 97289, 1220, 7334, 7345, '0', 0, 0, 0, 0, -877.05694580078125, 5915.162109375, -0.38284522294998168, 3.511589527130126953, 120, 10, 0, 27, 0, 1, 0, 0, 0, 46597), -- Juvenile Scuttleback (Area: Mak'rana - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+49, 64806, 1220, 7334, 7345, '0', 0, 0, 0, 0, -847.843017578125, 5874.70849609375, 0.291927754878997802, 5.103049278259277343, 120, 10, 0, 5, 0, 1, 0, 0, 0, 46597), -- Rapana Whelk (Area: Mak'rana - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+50, 89288, 1220, 7334, 7345, '0', 0, 0, 0, 0, -868.19207763671875, 5898.271484375, 1.454474568367004394, 5.77239084243774414, 120, 10, 0, 1569, 0, 1, 0, 0, 0, 46597), -- Scuttleback Pincher (Area: Mak'rana - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+51, 89286, 1220, 7334, 7345, '0', 0, 0, 0, 0, -632.0711669921875, 5799.048828125, -0.41079789400100708, 1.748396635055541992, 120, 0, 0, 7846, 2301, 0, 0, 0, 0, 46597), -- Mak'rana Elder (Area: Mak'rana - Difficulty: 0) (Auras: ) +(@CGUID+52, 89283, 1220, 7334, 7345, '0', 0, 0, 0, 1, -689.30206298828125, 5885.416015625, 0.935246467590332031, 2.786591053009033203, 120, 0, 0, 3923, 0, 0, 0, 0, 0, 46597), -- Bitterbrine Venomer (Area: Mak'rana - Difficulty: 0) +(@CGUID+53, 89288, 1220, 7334, 7345, '0', 0, 0, 0, 0, -718.15081787109375, 5847.2138671875, 2.910126209259033203, 1.860157012939453125, 120, 10, 0, 1569, 0, 1, 0, 0, 0, 46597), -- Scuttleback Pincher (Area: Mak'rana - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+54, 89288, 1220, 7334, 7345, '0', 0, 0, 0, 0, -734.00445556640625, 5832.640625, 4.176388740539550781, 0.785699963569641113, 120, 10, 0, 1569, 0, 1, 0, 0, 0, 46597), -- Scuttleback Pincher (Area: Mak'rana - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+55, 89283, 1220, 7334, 7345, '0', 0, 0, 0, 1, -742.96356201171875, 5831.64404296875, 7.773434162139892578, 4.411362171173095703, 120, 0, 0, 3923, 0, 0, 0, 0, 0, 46597), -- Bitterbrine Venomer (Area: Mak'rana - Difficulty: 0) +(@CGUID+56, 97289, 1220, 7334, 7345, '0', 0, 0, 0, 0, -752.24224853515625, 5821.263671875, 2.891232252120971679, 6.095557689666748046, 120, 10, 0, 27, 0, 1, 0, 0, 0, 46597), -- Juvenile Scuttleback (Area: Mak'rana - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+57, 89283, 1220, 7334, 7345, '0', 0, 0, 0, 1, -808.89410400390625, 5826.296875, 5.809119224548339843, 4.162795543670654296, 120, 0, 0, 3923, 0, 0, 0, 0, 0, 46597), -- Bitterbrine Venomer (Area: Mak'rana - Difficulty: 0) +(@CGUID+58, 64806, 1220, 7334, 7345, '0', 0, 0, 0, 0, -791.72119140625, 5826.22509765625, 7.307182788848876953, 4.981297016143798828, 120, 10, 0, 5, 0, 1, 0, 0, 0, 46597), -- Rapana Whelk (Area: Mak'rana - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+59, 89284, 1220, 7334, 7345, '0', 0, 0, 0, 1, -709.5694580078125, 5843.9052734375, 1.078949570655822753, 4.190789699554443359, 120, 0, 0, 3923, 1534, 0, 0, 0, 0, 46597), -- Bitterbrine Saltcaster (Area: Mak'rana - Difficulty: 0) (Auras: 12550 - Lightning Shield) +(@CGUID+60, 89288, 1220, 7334, 7345, '0', 0, 0, 0, 0, -825.37744140625, 5817.01025390625, 2.437922000885009765, 6.216747283935546875, 120, 10, 0, 1569, 0, 1, 0, 0, 0, 46597), -- Scuttleback Pincher (Area: Mak'rana - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+61, 97283, 1220, 7334, 7345, '0', 0, 0, 0, 0, -725.72467041015625, 5800.99169921875, -1.17716789245605468, 1.036007523536682128, 120, 10, 0, 1, 0, 1, 0, 0, 0, 46597), -- Juvenile Scuttleback (Area: Mak'rana - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+62, 89283, 1220, 7334, 7345, '0', 0, 0, 0, 1, -650.10418701171875, 5873.52978515625, -1.88782143592834472, 2.785151004791259765, 120, 0, 0, 3923, 0, 0, 0, 0, 0, 46597), -- Bitterbrine Venomer (Area: Mak'rana - Difficulty: 0) +(@CGUID+63, 89284, 1220, 7334, 7345, '0', 0, 0, 0, 1, -653.47918701171875, 5852.2724609375, -2.75158119201660156, 1.594843626022338867, 120, 0, 0, 3923, 1534, 0, 0, 0, 0, 46597), -- Bitterbrine Saltcaster (Area: Mak'rana - Difficulty: 0) (Auras: 12550 - Lightning Shield) +(@CGUID+64, 89290, 1220, 7334, 7345, '0', 0, 0, 0, 0, -705.52606201171875, 5794.01318359375, 3.026041507720947265, 5.190982341766357421, 120, 0, 0, 3923, 0, 0, 0, 0, 0, 46597), -- Queen's Reprisal Sailor (Area: Mak'rana - Difficulty: 0) (Auras: 178755 - Sea-Brine Toxin) +(@CGUID+65, 89053, 1220, 7334, 7345, '0', 0, 0, 0, 0, -704.05035400390625, 5791.30126953125, 2.907986164093017578, 1.989509105682373046, 120, 0, 0, 4904, 0, 0, 0, 0, 0, 46597), -- Mak'rana Warrior (Area: Mak'rana - Difficulty: 0) +(@CGUID+66, 89283, 1220, 7334, 7345, '0', 0, 0, 0, 1, -640.171875, 5815.81005859375, -3.92306494712829589, 5.092449188232421875, 120, 0, 0, 3923, 0, 0, 0, 0, 0, 46597), -- Bitterbrine Venomer (Area: Mak'rana - Difficulty: 0) +(@CGUID+67, 89288, 1220, 7334, 7345, '0', 0, 0, 0, 0, -715.6124267578125, 5582.25048828125, -2.43048620223999023, 4.651646614074707031, 120, 0, 0, 1569, 0, 0, 0, 0, 0, 46597), -- Scuttleback Pincher (Area: Mak'rana - Difficulty: 0) +(@CGUID+68, 89289, 1220, 7334, 7345, '0', 0, 0, 0, 0, -637.72393798828125, 5813.07568359375, -4.03988265991210937, 5.02739715576171875, 120, 10, 0, 3923, 0, 0, 0, 0, 0, 46597), -- Queen's Reprisal Sailor (Area: Mak'rana - Difficulty: 0) (Auras: 178755 - Sea-Brine Toxin) (possible waypoints or random movement) +(@CGUID+69, 89283, 1220, 7334, 7345, '0', 0, 0, 0, 1, -625.921875, 5816.36181640625, -4.91310596466064453, 4.428738117218017578, 120, 0, 0, 3923, 0, 0, 0, 0, 0, 46597), -- Bitterbrine Venomer (Area: Mak'rana - Difficulty: 0) +(@CGUID+70, 89290, 1220, 7334, 7345, '0', 0, 0, 0, 0, -627.998291015625, 5815.23291015625, -4.85288667678833007, 4.510309219360351562, 120, 10, 0, 3923, 0, 0, 0, 0, 0, 46597), -- Queen's Reprisal Sailor (Area: Mak'rana - Difficulty: 0) (Auras: 178755 - Sea-Brine Toxin) (possible waypoints or random movement) +(@CGUID+71, 89284, 1220, 7334, 7345, '0', 0, 0, 0, 1, -862.04339599609375, 5839.55908203125, 3.796875, 5.586895465850830078, 120, 0, 0, 3923, 1534, 0, 0, 0, 0, 46597), -- Bitterbrine Saltcaster (Area: Mak'rana - Difficulty: 0) (Auras: 12550 - Lightning Shield) +(@CGUID+72, 89289, 1220, 7334, 7345, '0', 0, 0, 0, 0, -860.87847900390625, 5838.37841796875, 4.029513835906982421, 2.484108209609985351, 120, 0, 0, 3923, 0, 0, 0, 0, 0, 46597), -- Queen's Reprisal Sailor (Area: Mak'rana - Difficulty: 0) (Auras: 178755 - Sea-Brine Toxin) +(@CGUID+73, 89284, 1220, 7334, 7345, '0', 0, 0, 0, 1, -787.8992919921875, 5759.6181640625, 0.013513818383216857, 6.036869525909423828, 120, 0, 0, 3923, 1534, 0, 0, 0, 0, 46597), -- Bitterbrine Saltcaster (Area: Mak'rana - Difficulty: 0) (Auras: 12550 - Lightning Shield) +(@CGUID+74, 89053, 1220, 7334, 7345, '0', 0, 0, 0, 0, -837.2864, 5772.383, 1.892593, 0.032215412706136703, 120, 0, 0, 4904, 0, 2, 0, 0, 0, 46597), -- Mak'rana Warrior (Area: Mak'rana - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+75, 89283, 1220, 7334, 7345, '0', 0, 0, 0, 1, -740.8715, 5852.671, 3.51394, 1.523483157157897949, 120, 0, 0, 3923, 0, 2, 0, 0, 0, 46597), -- Bitterbrine Venomer (Area: Mak'rana - Difficulty: 0) (Auras: 178767 - Cosmetic - Goblin Carrying O_Egg_05) (possible waypoints or random movement) +(@CGUID+76, 89288, 1220, 7334, 7345, '0', 0, 0, 0, 0, -720.66949462890625, 5594.8779296875, -2.09000968933105468, 2.467762947082519531, 120, 0, 0, 1569, 0, 0, 0, 0, 0, 46597), -- Scuttleback Pincher (Area: Mak'rana - Difficulty: 0) +(@CGUID+77, 89284, 1220, 7334, 7345, '0', 0, 0, 0, 1, -876.46527099609375, 5892.61962890625, 4.201501369476318359, 3.269866466522216796, 120, 0, 0, 3923, 1534, 0, 0, 0, 0, 46597), -- Bitterbrine Saltcaster (Area: Mak'rana - Difficulty: 0) (Auras: 12550 - Lightning Shield) +(@CGUID+78, 89290, 1220, 7334, 7345, '0', 0, 0, 0, 0, -878.68402099609375, 5892.43603515625, 4.439236164093017578, 0.204519048333168029, 120, 0, 0, 3923, 0, 0, 0, 0, 0, 46597), -- Queen's Reprisal Sailor (Area: Mak'rana - Difficulty: 0) (Auras: 178755 - Sea-Brine Toxin) +(@CGUID+79, 97289, 1220, 7334, 7345, '0', 0, 0, 0, 0, -890.314453125, 5876.7080078125, 2.600368738174438476, 0.954632163047790527, 120, 0, 0, 27, 0, 0, 0, 0, 0, 46597), -- Juvenile Scuttleback (Area: Mak'rana - Difficulty: 0) +(@CGUID+80, 89053, 1220, 7334, 7345, '0', 0, 0, 0, 0, -893.1632080078125, 5935.734375, 5.794776439666748046, 5.87414407730102539, 120, 0, 0, 4904, 0, 0, 0, 0, 0, 46597), -- Mak'rana Warrior (Area: Mak'rana - Difficulty: 0) +(@CGUID+81, 89288, 1220, 7334, 7345, '0', 0, 0, 0, 0, -883.333984375, 5850, -2, 2.128109216690063476, 120, 10, 0, 1569, 0, 1, 0, 0, 0, 46597), -- Scuttleback Pincher (Area: Mak'rana - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+82, 89284, 1220, 7334, 7345, '0', 0, 0, 0, 1, -912.41143798828125, 5875.9365234375, 0.83506941795349121, 5.6097259521484375, 120, 0, 0, 3923, 1534, 0, 0, 0, 0, 46597), -- Bitterbrine Saltcaster (Area: Mak'rana - Difficulty: 0) (Auras: 12550 - Lightning Shield) +(@CGUID+83, 89283, 1220, 7334, 7345, '0', 0, 0, 0, 1, -919.79168701171875, 5925.9365234375, 6.873458385467529296, 5.92581033706665039, 120, 0, 0, 3923, 0, 0, 0, 0, 0, 46597), -- Bitterbrine Venomer (Area: Mak'rana - Difficulty: 0) +(@CGUID+84, 89290, 1220, 7334, 7345, '0', 0, 0, 0, 0, -909.89581298828125, 5875.986328125, 0.529154539108276367, 6.143156051635742187, 120, 0, 0, 3923, 0, 0, 0, 0, 0, 46597), -- Queen's Reprisal Sailor (Area: Mak'rana - Difficulty: 0) (Auras: 178755 - Sea-Brine Toxin) +(@CGUID+85, 89283, 1220, 7334, 7345, '0', 0, 0, 0, 1, -890.92706298828125, 5801.54443359375, 1.435763955116271972, 3.650206327438354492, 120, 0, 0, 3923, 0, 0, 0, 0, 0, 46597), -- Bitterbrine Venomer (Area: Mak'rana - Difficulty: 0) +(@CGUID+86, 89283, 1220, 7334, 7345, '0', 0, 0, 0, 1, -936.342041015625, 5834.93603515625, 1.461805582046508789, 0.575530409812927246, 120, 0, 0, 3923, 0, 0, 0, 0, 0, 46597), -- Bitterbrine Venomer (Area: Mak'rana - Difficulty: 0) +(@CGUID+87, 64806, 1220, 7334, 7345, '0', 0, 0, 0, 0, -960.4580078125, 5860.5302734375, -1.00087893009185791, 4.046803951263427734, 120, 10, 0, 5, 0, 1, 0, 0, 0, 46597), -- Rapana Whelk (Area: Mak'rana - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+88, 89289, 1220, 7334, 7345, '0', 0, 0, 0, 0, -718.703125, 5626.6943359375, 5.192708492279052734, 1.155155658721923828, 120, 0, 0, 3923, 0, 0, 0, 0, 0, 46597), -- Queen's Reprisal Sailor (Area: Mak'rana - Difficulty: 0) (Auras: 178755 - Sea-Brine Toxin) +(@CGUID+89, 89290, 1220, 7334, 7345, '0', 0, 0, 0, 0, -969.734375, 5848.25, 1.477430582046508789, 2.409798145294189453, 120, 0, 0, 3923, 0, 0, 0, 0, 0, 46597), -- Queen's Reprisal Sailor (Area: Mak'rana - Difficulty: 0) (Auras: 178755 - Sea-Brine Toxin) +(@CGUID+90, 89284, 1220, 7334, 7345, '0', 0, 0, 0, 1, -971.8524169921875, 5850.3896484375, 0.746527791023254394, 5.454261302947998046, 120, 0, 0, 3923, 1534, 0, 0, 0, 0, 46597), -- Bitterbrine Saltcaster (Area: Mak'rana - Difficulty: 0) (Auras: 12550 - Lightning Shield) +(@CGUID+91, 89053, 1220, 7334, 7345, '0', 0, 0, 0, 0, -717.78302001953125, 5629.34912109375, 5.156575679779052734, 4.44174051284790039, 120, 0, 0, 4904, 0, 0, 0, 0, 0, 46597), -- Mak'rana Warrior (Area: Mak'rana - Difficulty: 0) +(@CGUID+92, 97283, 1220, 7334, 7345, '0', 0, 0, 0, 0, -861.775634765625, 5790.21826171875, 2.7660064697265625, 5.591788291931152343, 120, 10, 0, 1, 0, 1, 0, 0, 0, 46597), -- Juvenile Scuttleback (Area: Mak'rana - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+93, 89283, 1220, 7334, 7345, '0', 0, 0, 0, 1, -859.3038330078125, 5776.8583984375, 2.843066692352294921, 2.754482030868530273, 120, 0, 0, 3923, 0, 0, 0, 0, 0, 46597), -- Bitterbrine Venomer (Area: Mak'rana - Difficulty: 0) +(@CGUID+94, 89289, 1220, 7334, 7345, '0', 0, 0, 0, 0, -859.37847900390625, 5779.017578125, 2.843501806259155273, 4.015438079833984375, 120, 0, 0, 3923, 0, 0, 0, 0, 0, 46597), -- Queen's Reprisal Sailor (Area: Mak'rana - Difficulty: 0) (Auras: 178755 - Sea-Brine Toxin) +(@CGUID+95, 55370, 1220, 7334, 7345, '0', 0, 0, 0, 0, -918.1944580078125, 5791.31103515625, -1.58583998680114746, 0, 120, 0, 0, 18771, 2434, 0, 0, 0, 0, 46597), -- General Purpose Bunny ZTO (Area: Mak'rana - Difficulty: 0) (Auras: 180895 - Tide Pool Splash State) +(@CGUID+96, 91113, 1220, 7334, 7345, '0', 0, 0, 0, 0, -919.0086669921875, 5791.5087890625, -0.41551515460014343, 5.841485023498535156, 120, 0, 0, 15692, 0, 0, 0, 0, 0, 46597), -- Tide Behemoth (Area: Mak'rana - Difficulty: 0) +(@CGUID+97, 89288, 1220, 7334, 7345, '0', 0, 0, 0, 0, -943.32440185546875, 5777.91162109375, 1.584132790565490722, 5.819776535034179687, 120, 10, 0, 1569, 0, 1, 0, 0, 0, 46597), -- Scuttleback Pincher (Area: Mak'rana - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+98, 89288, 1220, 7334, 7345, '0', 0, 0, 0, 0, -981.52008056640625, 5821.59716796875, -1.00992488861083984, 1.433596611022949218, 120, 0, 0, 1569, 0, 0, 0, 0, 0, 46597), -- Scuttleback Pincher (Area: Mak'rana - Difficulty: 0) +(@CGUID+99, 97289, 1220, 7334, 7345, '0', 0, 0, 0, 0, -914.1448974609375, 5762.123046875, -0.42225468158721923, 0.312092721462249755, 120, 0, 0, 27, 0, 0, 0, 0, 0, 46597), -- Juvenile Scuttleback (Area: Mak'rana - Difficulty: 0) +(@CGUID+100, 108680, 1220, 7334, 7345, '0', 0, 0, 0, 0, -998.168701171875, 5859.3349609375, 26.02586936950683593, 0.280250757932662963, 120, 0, 0, 27, 0, 0, 0, 0, 0, 46597), -- Tidewater Gull (Area: Mak'rana - Difficulty: 0) -- Cyclic movement NYI +(@CGUID+101, 89283, 1220, 7334, 7345, '0', 0, 0, 0, 1, -970.70831298828125, 5819.38623046875, 2.563421249389648437, 2.268223285675048828, 120, 0, 0, 3923, 0, 0, 0, 0, 0, 46597), -- Bitterbrine Venomer (Area: Mak'rana - Difficulty: 0) +(@CGUID+102, 89289, 1220, 7334, 7345, '0', 0, 0, 0, 0, -716.8367919921875, 5625.5869140625, 5.297284603118896484, 1.903384685516357421, 120, 0, 0, 3923, 0, 0, 0, 0, 0, 46597), -- Queen's Reprisal Sailor (Area: Mak'rana - Difficulty: 0) (Auras: 178755 - Sea-Brine Toxin) +(@CGUID+103, 89286, 1220, 7334, 7345, '0', 0, 0, 0, 0, -916.45831298828125, 5660.62841796875, 36.21204376220703125, 4.335799694061279296, 120, 0, 0, 7846, 2301, 0, 0, 0, 0, 46597), -- Mak'rana Elder (Area: Mak'rana - Difficulty: 0) (Auras: ) +(@CGUID+104, 89053, 1220, 7334, 7345, '0', 0, 0, 0, 0, -1007.9600830078125, 5815.32666015625, 2.52286839485168457, 3.772028446197509765, 120, 0, 0, 4904, 0, 0, 0, 0, 0, 46597), -- Mak'rana Warrior (Area: Mak'rana - Difficulty: 0) +(@CGUID+105, 89288, 1220, 7334, 7345, '0', 0, 0, 0, 0, -791.16943359375, 5533.74267578125, -3.57958149909973144, 3.83758401870727539, 120, 0, 0, 1569, 0, 0, 0, 0, 0, 46597), -- Scuttleback Pincher (Area: Mak'rana - Difficulty: 0) +(@CGUID+106, 89284, 1220, 7334, 7345, '0', 0, 0, 0, 1, -747.97222900390625, 5677.52783203125, 4.826389312744140625, 6.014741420745849609, 120, 0, 0, 3923, 1534, 0, 0, 0, 0, 46597), -- Bitterbrine Saltcaster (Area: Mak'rana - Difficulty: 0) (Auras: 12550 - Lightning Shield) +(@CGUID+107, 89290, 1220, 7334, 7345, '0', 0, 0, 0, 0, -746.19793701171875, 5677.1181640625, 4.712867259979248046, 3.304219007492065429, 120, 0, 0, 3923, 0, 0, 0, 0, 0, 46597), -- Queen's Reprisal Sailor (Area: Mak'rana - Difficulty: 0) (Auras: 178755 - Sea-Brine Toxin) +(@CGUID+108, 89286, 1220, 7334, 7345, '0', 0, 0, 0, 0, -1011.27081298828125, 5672.82568359375, 46.41742706298828125, 0.127581924200057983, 120, 0, 0, 7846, 2301, 0, 0, 0, 0, 46597), -- Mak'rana Elder (Area: Mak'rana - Difficulty: 0) (Auras: ) +(@CGUID+109, 89290, 1220, 7334, 7345, '0', 0, 0, 0, 0, -771.43402099609375, 5581.15185546875, 0.833079993724822998, 5.042244434356689453, 120, 0, 0, 3923, 0, 0, 0, 0, 0, 46597), -- Queen's Reprisal Sailor (Area: Mak'rana - Difficulty: 0) (Auras: 178755 - Sea-Brine Toxin) +(@CGUID+110, 89283, 1220, 7334, 7345, '0', 0, 0, 0, 1, -765.0555419921875, 5621.32666015625, 13.70486068725585937, 0.187268152832984924, 120, 0, 0, 3923, 0, 0, 0, 0, 0, 46597), -- Bitterbrine Venomer (Area: Mak'rana - Difficulty: 0) +(@CGUID+111, 89053, 1220, 7334, 7345, '0', 0, 0, 0, 0, -958.72393798828125, 5750.4365234375, 17.95665359497070312, 0.543665707111358642, 120, 0, 0, 4904, 0, 0, 0, 0, 0, 46597), -- Mak'rana Warrior (Area: Mak'rana - Difficulty: 0) +(@CGUID+112, 89283, 1220, 7334, 7345, '0', 0, 0, 0, 1, -908.0399169921875, 5747.296875, 0.758736133575439453, 2.852177381515502929, 120, 0, 0, 3923, 0, 0, 0, 0, 0, 46597), -- Bitterbrine Venomer (Area: Mak'rana - Difficulty: 0) +(@CGUID+113, 89288, 1220, 7334, 7345, '0', 0, 0, 0, 0, -841.017822265625, 5735.1982421875, -29.8242931365966796, 3.108314990997314453, 120, 10, 0, 1569, 0, 1, 0, 0, 0, 46597), -- Scuttleback Pincher (Area: Mak'rana - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+114, 89288, 1220, 7334, 7345, '0', 0, 0, 0, 0, -839.10699462890625, 5738.9970703125, -28.8247756958007812, 5.506585121154785156, 120, 10, 0, 1569, 0, 1, 0, 0, 0, 46597), -- Scuttleback Pincher (Area: Mak'rana - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+115, 89284, 1220, 7334, 7345, '0', 0, 0, 0, 1, -771.076416015625, 5578.91748046875, 0.353615850210189819, 0.80347144603729248, 120, 0, 0, 3923, 1534, 0, 0, 0, 0, 46597), -- Bitterbrine Saltcaster (Area: Mak'rana - Difficulty: 0) (Auras: 12550 - Lightning Shield) +(@CGUID+116, 97283, 1220, 7334, 7345, '0', 0, 0, 0, 0, -787.329345703125, 5738.80615234375, -0.24820348620414733, 5.658052444458007812, 120, 10, 0, 1, 0, 1, 0, 0, 0, 46597), -- Juvenile Scuttleback (Area: Mak'rana - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+117, 89290, 1220, 7334, 7345, '0', 0, 0, 0, 0, -803.4757080078125, 5706.38818359375, 4.871251583099365234, 2.2546539306640625, 120, 0, 0, 3923, 0, 0, 0, 0, 0, 46597), -- Queen's Reprisal Sailor (Area: Mak'rana - Difficulty: 0) (Auras: 178755 - Sea-Brine Toxin) +(@CGUID+118, 89284, 1220, 7334, 7345, '0', 0, 0, 0, 1, -805.07464599609375, 5707.5615234375, 5.095486164093017578, 4.897623062133789062, 120, 0, 0, 3923, 1534, 0, 0, 0, 0, 46597), -- Bitterbrine Saltcaster (Area: Mak'rana - Difficulty: 0) (Auras: 12550 - Lightning Shield) +(@CGUID+119, 89283, 1220, 7334, 7345, '0', 0, 0, 0, 1, -878.4566, 5814.31, 2.526567, 1.967864871025085449, 120, 0, 0, 3923, 0, 2, 0, 0, 0, 46597), -- Bitterbrine Venomer (Area: Mak'rana - Difficulty: 0) (Auras: 178767 - Cosmetic - Goblin Carrying O_Egg_05) (possible waypoints or random movement) +(@CGUID+120, 89284, 1220, 7334, 7345, '0', 0, 0, 0, 1, -743.97222900390625, 5739.50244140625, 0.895833313465118408, 0.058318965137004852, 120, 0, 0, 3923, 1534, 0, 0, 0, 0, 46597), -- Bitterbrine Saltcaster (Area: Mak'rana - Difficulty: 0) (Auras: 12550 - Lightning Shield) +(@CGUID+121, 89053, 1220, 7334, 7345, '0', 0, 0, 0, 0, -806.2379, 5607.307, 16.60767, 1.793362021446228027, 120, 0, 0, 4904, 0, 2, 0, 0, 0, 46597), -- Mak'rana Warrior (Area: Mak'rana - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+122, 97289, 1220, 7334, 7345, '0', 0, 0, 0, 0, -796.44537353515625, 5667.6484375, -0.68741291761398315, 1.430220246315002441, 120, 10, 0, 27, 0, 1, 0, 0, 0, 46597), -- Juvenile Scuttleback (Area: Mak'rana - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+123, 89053, 1220, 7334, 7345, '0', 0, 0, 0, 0, -899.81768798828125, 5681.5849609375, -11.9665908813476562, 0.645241856575012207, 120, 0, 0, 4904, 0, 0, 0, 0, 0, 46597), -- Mak'rana Warrior (Area: Mak'rana - Difficulty: 0) +(@CGUID+124, 89053, 1220, 7334, 7345, '0', 0, 0, 0, 0, -751.2257080078125, 6010.4599609375, 2.584717750549316406, 1.179183244705200195, 120, 0, 0, 4904, 0, 0, 0, 0, 0, 46597), -- Mak'rana Warrior (Area: Mak'rana - Difficulty: 0) +(@CGUID+125, 89290, 1220, 7334, 7345, '0', 0, 0, 0, 0, -769.39581298828125, 5580.37060546875, 0.329861104488372802, 4.016911983489990234, 120, 0, 0, 3923, 0, 0, 0, 0, 0, 46597), -- Queen's Reprisal Sailor (Area: Mak'rana - Difficulty: 0) (Auras: 178755 - Sea-Brine Toxin) +(@CGUID+126, 89283, 1220, 7334, 7345, '0', 0, 0, 0, 1, -919.7396, 5750.477, 2.387682, 0.391935467720031738, 120, 0, 0, 3923, 0, 2, 0, 0, 0, 46597), -- Bitterbrine Venomer (Area: Mak'rana - Difficulty: 0) (Auras: 178767 - Cosmetic - Goblin Carrying O_Egg_05) (possible waypoints or random movement) +(@CGUID+127, 89053, 1220, 7334, 7345, '0', 0, 0, 0, 0, -933.26739501953125, 5683.9287109375, 34.67984390258789062, 1.5563737154006958, 120, 0, 0, 4904, 0, 0, 0, 0, 0, 46597), -- Mak'rana Warrior (Area: Mak'rana - Difficulty: 0) +(@CGUID+128, 89283, 1220, 7334, 7345, '0', 0, 0, 0, 1, -932.342041015625, 5652.744140625, 37.27951431274414062, 0.308848381042480468, 120, 0, 0, 3923, 0, 0, 0, 0, 0, 46597), -- Bitterbrine Venomer (Area: Mak'rana - Difficulty: 0) +(@CGUID+129, 89283, 1220, 7334, 7345, '0', 0, 0, 0, 1, -914.94097900390625, 5634.93310546875, 33.42534637451171875, 1.414287090301513671, 120, 0, 0, 3923, 0, 0, 0, 0, 0, 46597), -- Bitterbrine Venomer (Area: Mak'rana - Difficulty: 0) +(@CGUID+130, 89288, 1220, 7334, 7345, '0', 0, 0, 0, 0, -973.5474853515625, 5682.73828125, 37.51276397705078125, 2.369030952453613281, 120, 10, 0, 1569, 0, 1, 0, 0, 0, 46597), -- Scuttleback Pincher (Area: Mak'rana - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+131, 89287, 1220, 7334, 7345, '0', 0, 0, 0, 0, -995.36456298828125, 5613.90283203125, 6.573366165161132812, 0.688393175601959228, 120, 0, 0, 15692, 3068, 0, 0, 0, 0, 46597), -- Queen Kraklaa (Area: Mak'rana - Difficulty: 0) (Auras: 179073 - Subdued by Oublion) +(@CGUID+132, 89283, 1220, 7334, 7345, '0', 0, 0, 0, 1, -989.68231201171875, 5668.7275390625, 40.47941970825195312, 3.048778295516967773, 120, 0, 0, 3923, 0, 0, 0, 0, 0, 46597), -- Bitterbrine Venomer (Area: Mak'rana - Difficulty: 0) +(@CGUID+133, 89283, 1220, 7334, 7345, '0', 0, 0, 0, 1, -988.53302001953125, 5689.2255859375, 43.72163009643554687, 3.733400344848632812, 120, 0, 0, 3923, 0, 0, 0, 0, 0, 46597), -- Bitterbrine Venomer (Area: Mak'rana - Difficulty: 0) +(@CGUID+134, 89350, 1220, 7334, 7345, '0', 0, 0, 0, 0, -1001.18402099609375, 5626.03564453125, 6.373262405395507812, 6.191677093505859375, 120, 0, 0, 21577, 3068, 0, 0, 0, 0, 46597), -- Oublion (Area: Mak'rana - Difficulty: 0) +(@CGUID+135, 89289, 1220, 7334, 7345, '0', 0, 0, 0, 0, -993.3125, 5672.9462890625, 41.28996658325195312, 3.576715946197509765, 120, 0, 0, 3923, 0, 0, 0, 0, 0, 46597), -- Queen's Reprisal Sailor (Area: Mak'rana - Difficulty: 0) (Auras: 178755 - Sea-Brine Toxin) +(@CGUID+136, 89288, 1220, 7334, 7345, '0', 0, 0, 0, 0, -884.518310546875, 5621.70703125, 30.29186248779296875, 5.868731021881103515, 120, 10, 0, 1569, 0, 1, 0, 0, 0, 46597), -- Scuttleback Pincher (Area: Mak'rana - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+137, 89290, 1220, 7334, 7345, '0', 0, 0, 0, 0, -1002.3125, 5685.9130859375, 42.28992843627929687, 4.504506111145019531, 120, 0, 0, 3923, 0, 0, 0, 0, 0, 46597), -- Queen's Reprisal Sailor (Area: Mak'rana - Difficulty: 0) (Auras: 178755 - Sea-Brine Toxin) +(@CGUID+138, 89053, 1220, 7334, 7345, '0', 0, 0, 0, 0, -891.015625, 5602.1474609375, 34.0772552490234375, 0.144159033894538879, 120, 0, 0, 4904, 0, 0, 0, 0, 0, 46597), -- Mak'rana Warrior (Area: Mak'rana - Difficulty: 0) +(@CGUID+139, 89283, 1220, 7334, 7345, '0', 0, 0, 0, 1, -877.9913, 5623.479, 30.66024, 2.741885900497436523, 120, 0, 0, 3923, 0, 2, 0, 0, 0, 46597), -- Bitterbrine Venomer (Area: Mak'rana - Difficulty: 0) (Auras: 178767 - Cosmetic - Goblin Carrying O_Egg_05) (possible waypoints or random movement) +(@CGUID+140, 89288, 1220, 7334, 7345, '0', 0, 0, 0, 0, -774.210205078125, 5623.89208984375, 12.15728187561035156, 2.764532089233398437, 120, 10, 0, 1569, 0, 1, 0, 0, 0, 46597), -- Scuttleback Pincher (Area: Mak'rana - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+141, 89290, 1220, 7334, 7345, '0', 0, 0, 0, 0, -921.3125, 5639.98095703125, 35.43055343627929687, 1.457735061645507812, 120, 0, 0, 3923, 0, 0, 0, 0, 0, 46597), -- Queen's Reprisal Sailor (Area: Mak'rana - Difficulty: 0) (Auras: 178755 - Sea-Brine Toxin) +(@CGUID+142, 89053, 1220, 7334, 7345, '0', 0, 0, 0, 0, -837.00518798828125, 5620.02978515625, 24.18575286865234375, 5.886503219604492187, 120, 0, 0, 4904, 0, 0, 0, 0, 0, 46597), -- Mak'rana Warrior (Area: Mak'rana - Difficulty: 0) +(@CGUID+143, 89288, 1220, 7334, 7345, '0', 0, 0, 0, 0, -782.44384765625, 5631.92333984375, 5.522586345672607421, 2.464868068695068359, 120, 10, 0, 1569, 0, 1, 0, 0, 0, 46597), -- Scuttleback Pincher (Area: Mak'rana - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+144, 89288, 1220, 7334, 7345, '0', 0, 0, 0, 0, -835.416015625, 5554.578125, 30.44971084594726562, 0.510599434375762939, 120, 0, 0, 1569, 0, 0, 0, 0, 0, 46597), -- Scuttleback Pincher (Area: Mak'rana - Difficulty: 0) +(@CGUID+145, 89289, 1220, 7334, 7345, '0', 0, 0, 0, 0, -927.045166015625, 5943.916015625, 4.287406444549560546, 2.966041326522827148, 120, 0, 0, 3923, 0, 0, 0, 0, 0, 46597), -- Queen's Reprisal Sailor (Area: Mak'rana - Difficulty: 0) (Auras: 178755 - Sea-Brine Toxin) +(@CGUID+146, 89290, 1220, 7334, 7345, '0', 0, 0, 0, 0, -927.11456298828125, 5940.0927734375, 4.570481777191162109, 2.810237884521484375, 120, 0, 0, 3923, 0, 0, 0, 0, 0, 46597), -- Queen's Reprisal Sailor (Area: Mak'rana - Difficulty: 0) (Auras: 178755 - Sea-Brine Toxin) +(@CGUID+147, 89290, 1220, 7334, 7345, '0', 0, 0, 0, 0, -928.20831298828125, 5936.353515625, 4.751651763916015625, 2.462132453918457031, 120, 0, 0, 3923, 0, 0, 0, 0, 0, 46597), -- Queen's Reprisal Sailor (Area: Mak'rana - Difficulty: 0) (Auras: 178755 - Sea-Brine Toxin) +(@CGUID+148, 89290, 1220, 7334, 7345, '0', 0, 0, 0, 0, -991.57989501953125, 5682.78466796875, 40.85428619384765625, 3.94919896125793457, 120, 0, 0, 3923, 0, 0, 0, 0, 0, 46597), -- Queen's Reprisal Sailor (Area: Mak'rana - Difficulty: 0) (Auras: 178755 - Sea-Brine Toxin) +(@CGUID+149, 89290, 1220, 7334, 7345, '0', 0, 0, 0, 0, -932.9132080078125, 5935.048828125, 4.334166526794433593, 2.237115383148193359, 120, 0, 0, 3923, 0, 0, 0, 0, 0, 46597); -- Queen's Reprisal Sailor (Area: Mak'rana - Difficulty: 0) (Auras: 178755 - Sea-Brine Toxin) + +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+33; +INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES +(@OGUID+0, 239333, 1220, 7334, 7345, '0', 0, 0, -1008.44097900390625, 5682.2041015625, 42.79711532592773437, 0.23249693214893341, 0, 0, 0.115986824035644531, 0.993250727653503417, 120, 255, 1, 46597), -- Forsaken Chest (Area: Mak'rana - Difficulty: 0) +(@OGUID+1, 239419, 1220, 7334, 7345, '0', 0, 0, -856.10589599609375, 5596.65478515625, 29.26606941223144531, 0.828661441802978515, 0, 0, 0.402577400207519531, 0.915385961532592773, 120, 255, 1, 46597), -- Queen's Reprisal Crate (Area: Mak'rana - Difficulty: 0) +(@OGUID+2, 239333, 1220, 7334, 7345, '0', 0, 0, -763.54168701171875, 5621.55712890625, 13.51388931274414062, 3.298953533172607421, 0, 0, -0.99690628051757812, 0.078599251806735992, 120, 255, 1, 46597), -- Forsaken Chest (Area: Mak'rana - Difficulty: 0) +(@OGUID+3, 239419, 1220, 7334, 7345, '0', 0, 0, -687.58331298828125, 5655.8037109375, 4.897569656372070312, 1.045596718788146972, 0, 0, 0.499306678771972656, 0.86642533540725708, 120, 255, 1, 46597), -- Queen's Reprisal Crate (Area: Mak'rana - Difficulty: 0) +(@OGUID+4, 239419, 1220, 7334, 7345, '0', 0, 0, -737.6180419921875, 5983.0859375, 0.852623820304870605, 2.000185966491699218, 0, 0, 0.841521263122558593, 0.540224015712738037, 120, 255, 1, 46597), -- Queen's Reprisal Crate (Area: Mak'rana - Difficulty: 0) +(@OGUID+5, 239419, 1220, 7334, 7345, '0', 0, 0, -996.44793701171875, 5665.55712890625, 42.21326065063476562, 2.572283744812011718, 0, 0, 0.959758758544921875, 0.280825823545455932, 120, 255, 1, 46597), -- Queen's Reprisal Crate (Area: Mak'rana - Difficulty: 0) +(@OGUID+6, 239418, 1220, 7334, 7345, '0', 0, 0, -772.84027099609375, 5977.94091796875, 2.269097328186035156, 5.611649513244628906, 0, 0, -0.32949447631835937, 0.94415748119354248, 120, 255, 1, 46597), -- Sailor's Satchel (Area: Mak'rana - Difficulty: 0) +(@OGUID+7, 233319, 1220, 7334, 7345, '0', 0, 0, -909.13543701171875, 5652.0625, 34.14461135864257812, 1.868109703063964843, 0.25051736831665039, 0.057817459106445312, 0.796632766723632812, 0.547059834003448486, 120, 255, 1, 46597), -- Lobstrok Eggs (Area: Mak'rana - Difficulty: 0) +(@OGUID+8, 233319, 1220, 7334, 7345, '0', 0, 0, -909.61981201171875, 5651.36474609375, 34.24868392944335937, 6.023905277252197265, 0, 0, -0.12927722930908203, 0.991608500480651855, 120, 255, 1, 46597), -- Lobstrok Eggs (Area: Mak'rana - Difficulty: 0) +(@OGUID+9, 233319, 1220, 7334, 7345, '0', 0, 0, -1011.37847900390625, 5682.69775390625, 43.59836959838867187, 3.226389884948730468, -0.08919429779052734, -0.1201028823852539, -0.98732662200927734, 0.052969515323638916, 120, 255, 1, 46597), -- Lobstrok Eggs (Area: Mak'rana - Difficulty: 0) +(@OGUID+10, 233319, 1220, 7334, 7345, '0', 0, 0, -1009.6007080078125, 5681.16650390625, 43.06912612915039062, 5.922206878662109375, 0, 0, -0.17951107025146484, 0.983755946159362792, 120, 255, 1, 46597), -- Lobstrok Eggs (Area: Mak'rana - Difficulty: 0) +(@OGUID+11, 239418, 1220, 7334, 7345, '0', 0, 0, -982.33160400390625, 5639.11962890625, 5.705548286437988281, 1.608236432075500488, 0.074134349822998046, 0.087180137634277343, 0.714921951293945312, 0.689775586128234863, 120, 255, 1, 46597), -- Sailor's Satchel (Area: Mak'rana - Difficulty: 0) +(@OGUID+12, 239333, 1220, 7334, 7345, '0', 0, 0, -843.9149169921875, 5884.0869140625, 1.671875, 0.931358635425567626, 0, 0, 0.449029922485351562, 0.893516719341278076, 120, 255, 1, 46597), -- Forsaken Chest (Area: Mak'rana - Difficulty: 0) +(@OGUID+13, 239418, 1220, 7334, 7345, '0', 0, 0, -710.44793701171875, 5842.9462890625, 1.267361164093017578, 0.785749852657318115, 0, 0, 0.382845878601074218, 0.92381221055984497, 120, 255, 1, 46597), -- Sailor's Satchel (Area: Mak'rana - Difficulty: 0) +(@OGUID+14, 239419, 1220, 7334, 7345, '0', 0, 0, -911.185791015625, 5650.35595703125, 34.24784469604492187, 3.913959026336669921, 0, 0, -0.92635345458984375, 0.376655429601669311, 120, 255, 1, 46597), -- Queen's Reprisal Crate (Area: Mak'rana - Difficulty: 0) +(@OGUID+15, 233319, 1220, 7334, 7345, '0', 0, 0, -645.15277099609375, 5799.36962890625, -3.48672699928283691, 5.316977977752685546, 0, 0, -0.46452999114990234, 0.885557353496551513, 120, 255, 1, 46597), -- Lobstrok Eggs (Area: Mak'rana - Difficulty: 0) +(@OGUID+16, 233319, 1220, 7334, 7345, '0', 0, 0, -643.72222900390625, 5800.25, -3.7309582233428955, 3.818445444107055664, 0, 0, -0.94327831268310546, 0.33200305700302124, 120, 255, 1, 46597), -- Lobstrok Eggs (Area: Mak'rana - Difficulty: 0) +(@OGUID+17, 233319, 1220, 7334, 7345, '0', 0, 0, -643.54864501953125, 5798.265625, -4.05203723907470703, 0.240427747368812561, 0, 0, 0.119924545288085937, 0.992783010005950927, 120, 255, 1, 46597), -- Lobstrok Eggs (Area: Mak'rana - Difficulty: 0) +(@OGUID+18, 239419, 1220, 7334, 7345, '0', 0, 0, -643.3992919921875, 5802.046875, -3.59338045120239257, 2.053319454193115234, 0, 0, 0.855574607849121093, 0.517679512500762939, 120, 255, 1, 46597), -- Queen's Reprisal Crate (Area: Mak'rana - Difficulty: 0) +(@OGUID+19, 239418, 1220, 7334, 7345, '0', 0, 0, -786.076416015625, 5759.1630859375, 0.138351395726203918, 2.968999385833740234, 0, 0, 0.996278762817382812, 0.086189590394496917, 120, 255, 1, 46597), -- Sailor's Satchel (Area: Mak'rana - Difficulty: 0) +(@OGUID+20, 239333, 1220, 7334, 7345, '0', 0, 0, -911.453125, 5875.01318359375, 0.689335346221923828, 5.354240894317626953, -0.03077602386474609, 0.028697013854980468, -0.44712543487548828, 0.893480896949768066, 120, 255, 1, 46597), -- Forsaken Chest (Area: Mak'rana - Difficulty: 0) +(@OGUID+21, 239418, 1220, 7334, 7345, '0', 0, 0, -934.06768798828125, 5949.5400390625, 3.52162337303161621, 5.11746072769165039, 0, 0, -0.5504159927368164, 0.834890544414520263, 120, 255, 1, 46597), -- Sailor's Satchel (Area: Mak'rana - Difficulty: 0) +(@OGUID+22, 233319, 1220, 7334, 7345, '0', 0, 0, -935.36456298828125, 5950.6650390625, 3.613196611404418945, 1.573562502861022949, 0, 0, 0.7080841064453125, 0.706128060817718505, 120, 255, 1, 46597), -- Lobstrok Eggs (Area: Mak'rana - Difficulty: 0) +(@OGUID+23, 233319, 1220, 7334, 7345, '0', 0, 0, -936.7274169921875, 5950.484375, 3.400471925735473632, 6.095520973205566406, 0, 0, -0.09369468688964843, 0.995600998401641845, 120, 255, 1, 46597), -- Lobstrok Eggs (Area: Mak'rana - Difficulty: 0) +(@OGUID+24, 239333, 1220, 7334, 7345, '0', 0, 0, -892.03125, 5800.40283203125, 1.635416626930236816, 0.758235454559326171, 0, 0, 0.370100975036621093, 0.928991496562957763, 120, 255, 1, 46597), -- Forsaken Chest (Area: Mak'rana - Difficulty: 0) +(@OGUID+25, 239333, 1220, 7334, 7345, '0', 0, 0, -804.90972900390625, 5706.06005859375, 5.043402671813964843, 1.703927159309387207, 0, 0, 0.752574920654296875, 0.658506631851196289, 120, 255, 1, 46597), -- Forsaken Chest (Area: Mak'rana - Difficulty: 0) +(@OGUID+26, 239418, 1220, 7334, 7345, '0', 0, 0, -742.25347900390625, 5739.67626953125, 0.872724354267120361, 3.346770048141479492, 0, 0, -0.99474239349365234, 0.102408774197101593, 120, 255, 1, 46597), -- Sailor's Satchel (Area: Mak'rana - Difficulty: 0) +(@OGUID+27, 239419, 1220, 7334, 7345, '0', 0, 0, -934.9461669921875, 5836.14599609375, 1.282808542251586914, 3.851815700531005859, 0, 0, -0.9376077651977539, 0.347694814205169677, 120, 255, 1, 46597), -- Queen's Reprisal Crate (Area: Mak'rana - Difficulty: 0) +(@OGUID+28, 239418, 1220, 7334, 7345, '0', 0, 0, -956.3125, 5741.3681640625, 13.9287288953363895416, 1.479323148727416992, 0, 0, 0.674037933349609375, 0.738696753978729248, 120, 255, 1, 46597), -- Sailor's Satchel (Area: Mak'rana - Difficulty: 0) +(@OGUID+29, 239419, 1220, 7334, 7345, '0', 0, 0, -909.404541015625, 5747.73095703125, 0.648104012012481689, 6.028319358825683593, 0, 0, -0.12708854675292968, 0.991891384124755859, 120, 255, 1, 46597), -- Queen's Reprisal Crate (Area: Mak'rana - Difficulty: 0) +(@OGUID+30, 239418, 1220, 7334, 7345, '0', 0, 0, -861.24652099609375, 5706.666015625, -31.8299732208251953, 1.615506887435913085, 0, 0, 0.722736358642578125, 0.691123843193054199, 120, 255, 1, 46597), -- Sailor's Satchel (Area: Mak'rana - Difficulty: 0) +(@OGUID+31, 239333, 1220, 7334, 7345, '0', 0, 0, -860.484375, 5777.48876953125, 2.76027989387512207, 2.613205671310424804, 0, 0, 0.965303421020507812, 0.261130839586257934, 120, 255, 1, 46597), -- Forsaken Chest (Area: Mak'rana - Difficulty: 0) +(@OGUID+32, 239418, 1220, 7334, 7345, '0', 0, 0, -904.826416015625, 5769.47412109375, -0.5814673900604248, 4.287852287292480468, 0, 0, -0.84020805358886718, 0.542264163494110107, 120, 255, 1, 46597), -- Sailor's Satchel (Area: Mak'rana - Difficulty: 0) +(@OGUID+33, 239333, 1220, 7334, 7345, '0', 0, 0, -971.5242919921875, 5820.28466796875, 2.483617305755615234, 5.443417072296142578, 0, 0, -0.4076547622680664, 0.913136124610900878, 120, 255, 1, 46597); -- Forsaken Chest (Area: Mak'rana - Difficulty: 0) + +DELETE FROM `creature_addon` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+149; +INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(@CGUID+3, 0, 0, 8, 1, 0, 0, 0, 0, 0, '178755'), -- Queen's Reprisal Sailor - 178755 - Sea-Brine Toxin +(@CGUID+6, 0, 0, 0, 1, 0, 947, 0, 0, 3, ''), -- Mak'rana Elder +(@CGUID+9, 0, 0, 8, 1, 0, 0, 0, 0, 0, '178755'), -- Queen's Reprisal Sailor - 178755 - Sea-Brine Toxin +(@CGUID+10, 0, 0, 0, 1, 0, 1320, 0, 0, 0, '12550'), -- Bitterbrine Saltcaster - 12550 - Lightning Shield +(@CGUID+13, 0, 0, 0, 1, 333, 0, 0, 0, 0, '12550'), -- Bitterbrine Saltcaster - 12550 - Lightning Shield +(@CGUID+17, 0, 0, 0, 1, 375, 0, 0, 0, 0, ''), -- Bitterbrine Venomer +(@CGUID+18, 0, 0, 8, 1, 0, 0, 0, 0, 0, '178755'), -- Queen's Reprisal Sailor - 178755 - Sea-Brine Toxin +(@CGUID+20, 0, 0, 8, 1, 0, 0, 0, 0, 0, '178755'), -- Queen's Reprisal Sailor - 178755 - Sea-Brine Toxin +(@CGUID+21, 0, 0, 0, 1, 375, 0, 0, 0, 0, ''), -- Bitterbrine Venomer +(@CGUID+23, 0, 0, 8, 1, 0, 0, 0, 0, 0, '178755'), -- Queen's Reprisal Sailor - 178755 - Sea-Brine Toxin +(@CGUID+24, 0, 0, 0, 1, 0, 1320, 0, 0, 0, '12550'), -- Bitterbrine Saltcaster - 12550 - Lightning Shield +(@CGUID+26, 0, 0, 0, 1, 375, 0, 0, 0, 0, ''), -- Bitterbrine Venomer +(@CGUID+31, 0, 0, 8, 1, 0, 0, 0, 0, 0, '178755'), -- Queen's Reprisal Sailor - 178755 - Sea-Brine Toxin +(@CGUID+32, 0, 0, 0, 1, 0, 1320, 0, 0, 0, ''), -- Bitterbrine Venomer +(@CGUID+37, 0, 0, 0, 1, 333, 0, 0, 0, 0, '12550'), -- Bitterbrine Saltcaster - 12550 - Lightning Shield +(@CGUID+40, 0, 0, 8, 1, 0, 0, 0, 0, 0, '178755'), -- Queen's Reprisal Sailor - 178755 - Sea-Brine Toxin +(@CGUID+41, 0, 0, 8, 1, 0, 0, 0, 0, 0, '178755'), -- Queen's Reprisal Sailor - 178755 - Sea-Brine Toxin +(@CGUID+43, 0, 0, 0, 1, 0, 1320, 0, 0, 0, ''), -- Bitterbrine Venomer +(@CGUID+44, 0, 0, 0, 1, 0, 0, 0, 0, 0, '123169 221736'), -- Veil Shadowrunner - 123169 - Mod Scale 105-110%, 221736 - Aura of Lethargy +(@CGUID+46, 0, 0, 0, 1, 0, 0, 0, 0, 0, '123169 221736'), -- Veil Shadowrunner - 123169 - Mod Scale 105-110%, 221736 - Aura of Lethargy +(@CGUID+47, 0, 0, 8, 1, 0, 0, 0, 0, 0, '178755'), -- Queen's Reprisal Sailor - 178755 - Sea-Brine Toxin +(@CGUID+51, 0, 0, 0, 1, 0, 947, 0, 0, 3, ''), -- Mak'rana Elder +(@CGUID+52, 0, 0, 0, 1, 375, 0, 0, 0, 0, ''), -- Bitterbrine Venomer +(@CGUID+55, 0, 0, 1, 1, 0, 0, 0, 0, 0, ''), -- Bitterbrine Venomer +(@CGUID+57, 0, 0, 0, 1, 0, 1320, 0, 0, 0, ''), -- Bitterbrine Venomer +(@CGUID+59, 0, 0, 0, 1, 0, 1320, 0, 0, 0, '12550'), -- Bitterbrine Saltcaster - 12550 - Lightning Shield +(@CGUID+62, 0, 0, 0, 1, 333, 0, 0, 0, 0, ''), -- Bitterbrine Venomer +(@CGUID+63, 0, 0, 0, 1, 333, 0, 0, 0, 0, '12550'), -- Bitterbrine Saltcaster - 12550 - Lightning Shield +(@CGUID+64, 0, 0, 8, 1, 0, 0, 0, 0, 0, '178755'), -- Queen's Reprisal Sailor - 178755 - Sea-Brine Toxin +(@CGUID+66, 0, 0, 0, 1, 375, 0, 0, 0, 0, ''), -- Bitterbrine Venomer +(@CGUID+68, 0, 0, 0, 1, 0, 1078, 0, 0, 0, '178755'), -- Queen's Reprisal Sailor - 178755 - Sea-Brine Toxin +(@CGUID+69, 0, 0, 0, 1, 333, 0, 0, 0, 0, ''), -- Bitterbrine Venomer +(@CGUID+70, 0, 0, 0, 1, 0, 1078, 0, 0, 0, '178755'), -- Queen's Reprisal Sailor - 178755 - Sea-Brine Toxin +(@CGUID+71, 0, 0, 0, 1, 333, 0, 0, 0, 0, '12550'), -- Bitterbrine Saltcaster - 12550 - Lightning Shield +(@CGUID+72, 0, 0, 8, 1, 0, 0, 0, 0, 0, '178755'), -- Queen's Reprisal Sailor - 178755 - Sea-Brine Toxin +(@CGUID+73, 0, 0, 0, 1, 0, 1320, 0, 0, 0, '12550'), -- Bitterbrine Saltcaster - 12550 - Lightning Shield +(@CGUID+75, 0, 0, 0, 0, 0, 0, 0, 0, 0, '178767'), -- Bitterbrine Venomer - 178767 - Cosmetic - Goblin Carrying O_Egg_05 +(@CGUID+77, 0, 0, 0, 1, 333, 0, 0, 0, 0, '12550'), -- Bitterbrine Saltcaster - 12550 - Lightning Shield +(@CGUID+78, 0, 0, 8, 1, 0, 0, 0, 0, 0, '178755'), -- Queen's Reprisal Sailor - 178755 - Sea-Brine Toxin +(@CGUID+82, 0, 0, 0, 1, 0, 1320, 0, 0, 0, '12550'), -- Bitterbrine Saltcaster - 12550 - Lightning Shield +(@CGUID+83, 0, 0, 0, 1, 375, 0, 0, 0, 0, ''), -- Bitterbrine Venomer +(@CGUID+84, 0, 0, 8, 1, 0, 0, 0, 0, 0, '178755'), -- Queen's Reprisal Sailor - 178755 - Sea-Brine Toxin +(@CGUID+85, 0, 0, 0, 1, 0, 1320, 0, 0, 0, ''), -- Bitterbrine Venomer +(@CGUID+86, 0, 0, 0, 1, 0, 1320, 0, 0, 0, ''), -- Bitterbrine Venomer +(@CGUID+88, 0, 0, 8, 1, 0, 0, 0, 0, 0, '178755'), -- Queen's Reprisal Sailor - 178755 - Sea-Brine Toxin +(@CGUID+89, 0, 0, 8, 1, 0, 0, 0, 0, 0, '178755'), -- Queen's Reprisal Sailor - 178755 - Sea-Brine Toxin +(@CGUID+90, 0, 0, 0, 1, 333, 0, 0, 0, 0, '12550'), -- Bitterbrine Saltcaster - 12550 - Lightning Shield +(@CGUID+93, 0, 0, 0, 1, 0, 1320, 0, 0, 0, ''), -- Bitterbrine Venomer +(@CGUID+94, 0, 0, 8, 1, 0, 0, 0, 0, 0, '178755'), -- Queen's Reprisal Sailor - 178755 - Sea-Brine Toxin +(@CGUID+95, 0, 0, 50331648, 1, 0, 0, 0, 0, 0, '180895'), -- General Purpose Bunny ZTO - 180895 - Tide Pool Splash State +(@CGUID+96, 0, 0, 0, 1, 429, 0, 0, 0, 0, ''), -- Tide Behemoth +(@CGUID+100, 0, 0, 50331648, 1, 0, 0, 0, 0, 0, ''), -- Tidewater Gull +(@CGUID+101, 0, 0, 0, 1, 0, 1320, 0, 0, 0, ''), -- Bitterbrine Venomer +(@CGUID+102, 0, 0, 8, 1, 0, 0, 0, 0, 0, '178755'), -- Queen's Reprisal Sailor - 178755 - Sea-Brine Toxin +(@CGUID+103, 0, 0, 0, 1, 0, 947, 0, 0, 3, ''), -- Mak'rana Elder +(@CGUID+106, 0, 0, 0, 1, 333, 0, 0, 0, 0, '12550'), -- Bitterbrine Saltcaster - 12550 - Lightning Shield +(@CGUID+107, 0, 0, 8, 1, 0, 0, 0, 0, 0, '178755'), -- Queen's Reprisal Sailor - 178755 - Sea-Brine Toxin +(@CGUID+108, 0, 0, 0, 1, 0, 947, 0, 0, 3, ''), -- Mak'rana Elder +(@CGUID+109, 0, 0, 8, 1, 0, 0, 0, 0, 0, '178755'), -- Queen's Reprisal Sailor - 178755 - Sea-Brine Toxin +(@CGUID+110, 0, 0, 0, 1, 0, 1320, 0, 0, 0, ''), -- Bitterbrine Venomer +(@CGUID+112, 0, 0, 0, 1, 0, 1320, 0, 0, 0, ''), -- Bitterbrine Venomer +(@CGUID+115, 0, 0, 0, 1, 333, 0, 0, 0, 0, '12550'), -- Bitterbrine Saltcaster - 12550 - Lightning Shield +(@CGUID+117, 0, 0, 8, 1, 0, 0, 0, 0, 0, '178755'), -- Queen's Reprisal Sailor - 178755 - Sea-Brine Toxin +(@CGUID+118, 0, 0, 0, 1, 0, 1320, 0, 0, 0, '12550'), -- Bitterbrine Saltcaster - 12550 - Lightning Shield +(@CGUID+119, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''), -- Bitterbrine Venomer +(@CGUID+120, 0, 0, 0, 1, 0, 1320, 0, 0, 0, '12550'), -- Bitterbrine Saltcaster - 12550 - Lightning Shield +(@CGUID+125, 0, 0, 8, 1, 0, 0, 0, 0, 0, '178755'), -- Queen's Reprisal Sailor - 178755 - Sea-Brine Toxin +(@CGUID+126, 0, 0, 0, 0, 0, 0, 0, 0, 0, '178767'), -- Bitterbrine Venomer - 178767 - Cosmetic - Goblin Carrying O_Egg_05 +(@CGUID+128, 0, 0, 0, 1, 375, 0, 0, 0, 0, ''), -- Bitterbrine Venomer +(@CGUID+129, 0, 0, 0, 1, 375, 0, 0, 0, 0, ''), -- Bitterbrine Venomer +(@CGUID+131, 0, 0, 0, 1, 0, 0, 0, 0, 0, '179073'), -- Queen Kraklaa - 179073 - Subdued by Oublion +(@CGUID+132, 0, 0, 0, 1, 375, 0, 0, 0, 0, ''), -- Bitterbrine Venomer +(@CGUID+133, 0, 0, 0, 1, 375, 0, 0, 0, 0, ''), -- Bitterbrine Venomer +(@CGUID+135, 0, 0, 0, 1, 0, 1078, 0, 0, 0, '178755'), -- Queen's Reprisal Sailor - 178755 - Sea-Brine Toxin +(@CGUID+137, 0, 0, 0, 1, 0, 1078, 0, 0, 0, '178755'), -- Queen's Reprisal Sailor - 178755 - Sea-Brine Toxin +(@CGUID+139, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''), -- Bitterbrine Venomer +(@CGUID+141, 0, 0, 0, 1, 0, 1078, 0, 0, 0, '178755'), -- Queen's Reprisal Sailor - 178755 - Sea-Brine Toxin +(@CGUID+145, 0, 0, 0, 1, 0, 1078, 0, 0, 0, '178755'), -- Queen's Reprisal Sailor - 178755 - Sea-Brine Toxin +(@CGUID+146, 0, 0, 0, 1, 0, 1078, 0, 0, 0, '178755'), -- Queen's Reprisal Sailor - 178755 - Sea-Brine Toxin +(@CGUID+147, 0, 0, 0, 1, 0, 1078, 0, 0, 0, '178755'), -- Queen's Reprisal Sailor - 178755 - Sea-Brine Toxin +(@CGUID+148, 0, 0, 0, 1, 0, 1078, 0, 0, 0, '178755'), -- Queen's Reprisal Sailor - 178755 - Sea-Brine Toxin +(@CGUID+149, 0, 0, 0, 1, 0, 1078, 0, 0, 0, '178755'); -- Queen's Reprisal Sailor - 178755 - Sea-Brine Toxin + +DELETE FROM `gameobject_template_addon` WHERE `entry` IN (239333 /*Forsaken Chest*/, 239418 /*Sailor's Satchel*/, 239419 /*Queen's Reprisal Crate*/); +INSERT INTO `gameobject_template_addon` (`entry`, `faction`, `flags`, `WorldEffectID`, `AIAnimKitID`) VALUES +(239333, 114, 0, 0, 0), -- Forsaken Chest +(239418, 114, 0, 0, 0), -- Sailor's Satchel +(239419, 114, 0, 0, 0); -- Queen's Reprisal Crate + +UPDATE `creature_template` SET `minlevel`=45, `maxlevel`=45, `VerifiedBuild`=46597 WHERE `entry`=91113; -- Tide Behemoth +UPDATE `creature_template` SET `VerifiedBuild`=46597 WHERE `entry` IN (89053, 89284, 89283, 89286); +UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry` = 89283; +UPDATE `creature_template` SET `npcflag`=16777216, `VerifiedBuild`=46597 WHERE `entry` IN (89289, 89290); -- Queen's Reprisal Sailor + +DELETE FROM `creature_template_movement` WHERE `CreatureId`=108680; +INSERT INTO `creature_template_movement` (`CreatureId`, `Ground`, `Swim`, `Flight`, `Rooted`, `Chase`, `Random`, `InteractionPauseTimer`) VALUES +(108680, 0, 0, 1, 0, 0, 0, NULL); + +UPDATE `gameobject_template` SET `ContentTuningId`=331, `VerifiedBuild`=46597 WHERE `entry`=239333; -- Forsaken Chest +UPDATE `gameobject_template` SET `ContentTuningId`=331, `VerifiedBuild`=46597 WHERE `entry`=239419; -- Queen's Reprisal Crate +UPDATE `gameobject_template` SET `ContentTuningId`=331, `VerifiedBuild`=46597 WHERE `entry`=239418; -- Sailor's Satchel + +-- Path 1 +SET @PATH := (@CGUID+2) * 10; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`) VALUES +(@PATH, 0, -705.4549, 5996.477, 3.680148, 21356), +(@PATH, 1, -731.4393, 5940.023, -0.6807823, 0), +(@PATH, 2, -737.441, 5922.564, -0.3184031, 0), +(@PATH, 3, -738.3976, 5913.636, -0.2729929, 0), +(@PATH, 4, -736.184, 5906.03, -0.1934031, 0), +(@PATH, 5, -730.4653, 5899.643, -0.04573607, 0), +(@PATH, 6, -721.2552, 5896.663, 0.6645911, 17900), +(@PATH, 7, -730.4653, 5899.643, -0.04573607, 0), +(@PATH, 8, -736.184, 5906.03, -0.1934031, 0), +(@PATH, 9, -738.3976, 5913.636, -0.2729929, 0), +(@PATH, 10, -737.441, 5922.564, -0.3184031, 0), +(@PATH, 11, -731.4393, 5940.023, -0.6807823, 0); + +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+2; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES +(@CGUID+2, @PATH, 1); + +-- Path 2 +SET @PATH := (@CGUID+7) * 10; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`) VALUES +(@PATH, 0, -749.3871, 5530.187, -2.520659, 0), +(@PATH, 1, -739.3611, 5550.496, -2.154372, 0), +(@PATH, 2, -731.3524, 5567.174, -2.430486, 0), +(@PATH, 3, -721.1458, 5582.46, -2.430486, 0), +(@PATH, 4, -709.0643, 5595.479, -2.430486, 0), +(@PATH, 5, -691.6719, 5615.546, -2.345188, 0), +(@PATH, 6, -680.4583, 5629.337, -2.345188, 0), +(@PATH, 7, -673.4618, 5641.227, -0.8344452, 403), +(@PATH, 8, -680.4583, 5629.337, -2.345188, 0), +(@PATH, 9, -691.6719, 5615.546, -2.345188, 0), +(@PATH, 10, -709.0643, 5595.479, -2.430486, 0), +(@PATH, 11, -721.1458, 5582.46, -2.430486, 0), +(@PATH, 12, -731.3524, 5567.174, -2.430486, 0), +(@PATH, 13, -739.3611, 5550.496, -2.154372, 0); + +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+7; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES +(@CGUID+7, @PATH, 1); + +-- Path 3 +SET @PATH := (@CGUID+33) * 10; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`) VALUES +(@PATH, 0, -941.3837, 5666.189, 35.43334, 11907), +(@PATH, 1, -950.7327, 5675.124, 34.05275, 0), +(@PATH, 2, -954.4167, 5686.38, 33.13796, 0), +(@PATH, 3, -954.627, 5698.381, 29.38112, 0), +(@PATH, 4, -948.1545, 5717.091, 21.60461, 0), +(@PATH, 5, -944.9462, 5727.056, 15.80187, 0), +(@PATH, 6, -941.2621, 5736.562, 11.54675, 15502), +(@PATH, 7, -944.9462, 5727.056, 15.80187, 0), +(@PATH, 8, -948.1545, 5717.091, 21.60461, 0), +(@PATH, 9, -954.632, 5698.491, 29.3489, 0), +(@PATH, 10, -954.4167, 5686.38, 33.13796, 0), +(@PATH, 11, -950.7327, 5675.124, 34.05275, 0); + +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+33; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES +(@CGUID+33, @PATH, 1); + +-- Path 4 +SET @PATH := (@CGUID+74) * 10; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`) VALUES +(@PATH, 0, -837.2864, 5772.383, 1.892593, 0), +(@PATH, 1, -850.9393, 5777.479, 2.316299, 0), +(@PATH, 2, -857.6702, 5786.155, 2.766006, 0), +(@PATH, 3, -866.5781, 5799.03, 0.5028229, 0), +(@PATH, 4, -870, 5809.013, 2.424272, 0), +(@PATH, 5, -869.8646, 5824.703, 0.9572313, 0), +(@PATH, 6, -860.2222, 5831.23, 2.001877, 0), +(@PATH, 7, -850.441, 5837.338, 2.989163, 0), +(@PATH, 8, -838.0469, 5837.857, 3.169949, 0), +(@PATH, 9, -825.3281, 5838.272, 6.476967, 0), +(@PATH, 10, -808.2309, 5835.865, 6.271767, 0), +(@PATH, 11, -792.6458, 5828.709, 7.000178, 0), +(@PATH, 12, -780.8594, 5817.641, 8.84466, 0), +(@PATH, 13, -771.2239, 5805.802, 4.897761, 0), +(@PATH, 14, -765.3993, 5800.731, 2.135007, 0), +(@PATH, 15, -760.0555, 5794.014, 2.769958, 0), +(@PATH, 16, -754.8143, 5785.927, 1.018859, 0), +(@PATH, 17, -752.7708, 5779.062, 2.676818, 0), +(@PATH, 18, -753.7031, 5770.538, 2.822448, 0), +(@PATH, 19, -756.408, 5762.785, 1.201756, 0), +(@PATH, 20, -759.4271, 5754.825, 2.554539, 0), +(@PATH, 21, -764.8333, 5745.534, 3.551609, 0), +(@PATH, 22, -771.6875, 5735.395, 3.564107, 0), +(@PATH, 23, -782.4688, 5725.542, 1.530599, 0), +(@PATH, 24, -791.9445, 5723.173, 2.062337, 0), +(@PATH, 25, -802.1702, 5730.294, 2.773302, 0), +(@PATH, 26, -805.5886, 5738.339, 2.79014, 0), +(@PATH, 27, -807.7535, 5748.445, 2.276224, 0), +(@PATH, 28, -814.1129, 5759.259, 2.696878, 0), +(@PATH, 29, -825.743, 5767.249, 2.566031, 0); + +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+74; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES +(@CGUID+74, @PATH, 1); + +-- Path 5 +SET @PATH := (@CGUID+36) * 10; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`) VALUES +(@PATH, 0, -829.1528, 5923.822, 1.185637, 19282), +(@PATH, 1, -840.7604, 5920.362, -0.08257359, 0), +(@PATH, 2, -859.0018, 5915.038, -0.3098685, 0), +(@PATH, 3, -877.3368, 5911.103, -0.3898032, 0), +(@PATH, 4, -886.9288, 5905.764, -0.3898032, 0), +(@PATH, 5, -896.875, 5896.385, -0.3996313, 0), +(@PATH, 6, -904.5174, 5889.988, -0.2694329, 0), +(@PATH, 7, -920.5452, 5881.583, -0.747094, 0), +(@PATH, 8, -935.0382, 5870.39, -0.539691, 0), +(@PATH, 9, -946.1285, 5865.261, -1.000879, 0), +(@PATH, 10, -958.8524, 5863.853, -1.026025, 19830), +(@PATH, 11, -946.1285, 5865.261, -1.000879, 0), +(@PATH, 12, -935.0382, 5870.39, -0.539691, 0), +(@PATH, 13, -920.5452, 5881.583, -0.747094, 0), +(@PATH, 14, -904.5174, 5889.988, -0.2694329, 0), +(@PATH, 15, -896.875, 5896.385, -0.3996313, 0), +(@PATH, 16, -886.9288, 5905.764, -0.3898032, 0), +(@PATH, 17, -877.3368, 5911.103, -0.3898032, 0), +(@PATH, 18, -859.0018, 5915.038, -0.3098685, 0), +(@PATH, 19, -840.7604, 5920.362, -0.08257359, 0); + +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+36; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES +(@CGUID+36, @PATH, 1); + +-- Path 6 +SET @PATH := (@CGUID+121) * 10; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`) VALUES +(@PATH, 0, -902.6771, 5633.009, 31.01843, 20051), +(@PATH, 1, -886.5746, 5622.553, 30.20687, 0), +(@PATH, 2, -872.9705, 5616.194, 30.33187, 0), +(@PATH, 3, -857.6563, 5610.085, 28.76065, 0), +(@PATH, 4, -846.7691, 5606.889, 24.9108, 0), +(@PATH, 5, -833.8837, 5606.39, 21.45316, 0), +(@PATH, 6, -817.3611, 5606.979, 18.6803, 0), +(@PATH, 7, -806.2379, 5607.307, 16.60767, 0), +(@PATH, 8, -798.7379, 5611.967, 14.11843, 0), +(@PATH, 9, -792.2257, 5619.803, 11.24477, 0), +(@PATH, 10, -788.6736, 5624.627, 9.337666, 10670), +(@PATH, 11, -792.2257, 5619.803, 11.24477, 0), +(@PATH, 12, -798.7379, 5611.967, 14.11843, 0), +(@PATH, 13, -806.2379, 5607.307, 16.60767, 0), +(@PATH, 14, -817.2383, 5606.984, 18.61389, 0), +(@PATH, 15, -833.8837, 5606.39, 21.45316, 0), +(@PATH, 16, -846.7691, 5606.889, 24.9108, 0), +(@PATH, 17, -857.6563, 5610.085, 28.76065, 0), +(@PATH, 18, -872.9705, 5616.194, 30.33187, 0), +(@PATH, 19, -886.5746, 5622.553, 30.20687, 0); + +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+121; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES +(@CGUID+121, @PATH, 1); + +-- Path 7 +SET @PATH := (@CGUID+35) * 10; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`) VALUES +(@PATH, 0, -710.9479, 5908.113, 1.806597, 0), +(@PATH, 1, -709.3837, 5899.196, 1.714396, 0), +(@PATH, 2, -704.0729, 5885.594, 1.402872, 0), +(@PATH, 3, -704.6371, 5873.015, 3.576456, 0), +(@PATH, 4, -707.1858, 5864.745, 3.134736, 0), +(@PATH, 5, -710.6614, 5850.453, 2.104218, 0), +(@PATH, 6, -710.6077, 5846.178, 1.016693, 18607), +(@PATH, 7, -707.1858, 5864.745, 3.134736, 0), +(@PATH, 8, -704.6371, 5873.015, 3.576456, 0), +(@PATH, 9, -704.0729, 5885.594, 1.402872, 0), +(@PATH, 10, -709.3837, 5899.196, 1.714396, 0), +(@PATH, 11, -710.9297, 5908.064, 1.681597, 0), +(@PATH, 12, -710.3489, 5913.388, 1.627153, 20964); + +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+35; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES +(@CGUID+35, @PATH, 1); + +-- Path 8 +SET @PATH := (@CGUID+126) * 10; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`) VALUES +(@PATH, 0, -919.7396, 5750.477, 2.387682, 0), +(@PATH, 1, -925.0972, 5752.361, 3.739489, 0), +(@PATH, 2, -934.0799, 5748.216, 6.864866, 0), +(@PATH, 3, -942.0139, 5740.617, 10.552, 0), +(@PATH, 4, -948.7598, 5731.916, 14.75158, 0), +(@PATH, 5, -951.1042, 5717.9, 21.72912, 0), +(@PATH, 6, -958.158, 5701.985, 28.68224, 0), +(@PATH, 7, -966.1493, 5690.735, 34.23, 0), +(@PATH, 8, -978.6614, 5681.67, 38.36335, 0), +(@PATH, 9, -985.3004, 5680.057, 39.65998, 0), +(@PATH, 10, -996.7761, 5679.033, 41.91193, 0), +(@PATH, 11, -1003.703, 5679.097, 42.66906, 0), +(@PATH, 12, -1008.368, 5680.698, 43.17431, 2485), +(@PATH, 13, -997.6511, 5677.466, 42.01691, 0), +(@PATH, 14, -985.9184, 5675.889, 39.73151, 0), +(@PATH, 15, -974.4375, 5680.415, 37.60651, 0), +(@PATH, 16, -949.7465, 5690.627, 31.16262, 0), +(@PATH, 17, -934.5434, 5697.93, 28.9153, 0), +(@PATH, 18, -929.3577, 5699.759, 26.35905, 0), +(@PATH, 19, -886.438, 5701.33, -1.98689, 0), +(@PATH, 20, -869.6337, 5709.155, -27.24383, 0), +(@PATH, 21, -867.6754, 5708.102, -30.94896, 12448), +(@PATH, 22, -890.2587, 5725.237, -3.826675, 0), +(@PATH, 23, -903.4827, 5733.878, 1.198351, 0), +(@PATH, 24, -915.4358, 5745.549, 2.19713, 0); + +UPDATE `creature_addon` SET `path_id` = @PATH WHERE `guid`= @CGUID+126; + +DELETE FROM `smart_scripts` WHERE (`entryorguid`= -(@CGUID+126) AND `source_type`= 0) OR (`entryorguid` = ((@CGUID+126) * 100) AND `source_type`= 9) OR (`entryorguid` = (((@CGUID+126) * 100) + 1) 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`, `event_param5`, `event_param_string`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_param4`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES +(-(@CGUID+126), 0, 0, 0, 34, 0, 100, 0, 2, 18, 0, 0, 0, '', 97, 20, 10, 0, 0, 0, 0, 1, 0, 0, 0, 0, -886.438, 5701.33, -1.98689, 0, 'OnMovementInform PathID 18 - Jump To Pos'), +(-(@CGUID+126), 0, 1, 0, 34, 0, 100, 0, 2, 21, 0, 0, 0, '', 80, (@CGUID+126) * 100, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'OnMovementInform PathID 21 - Run Actionlist - to self'), +(-(@CGUID+126), 0, 2, 0, 34, 0, 100, 0, 2, 12, 0, 0, 0, '', 80, ((@CGUID+126) * 100) + 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'OnMovementInform PathID 12 - Run Actionlist 2 - to self'), +(((@CGUID+126) * 100), 9, 0, 0, 0, 0, 100, 0, 2000, 2000, 2000, 2000, 0, '', 5, 69, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'After 2s - Emote 69 - to self'), +(((@CGUID+126) * 100), 9, 1, 0, 0, 0, 100, 0, 9000, 9000, 9000, 9000, 0, '', 11, 178767, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'After 9s - Cast Spell 178767 - to self'), +(((@CGUID+126) * 100), 9, 2, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, '', 5, 27, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'After 0s - Set Emote None - to self'), +((((@CGUID+126) * 100) + 1), 9, 0, 0, 0, 0, 100, 0, 1000, 1000, 1000, 1000, 0, '', 28, 178767, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'After 1s - Remove Spell 178767 - to self'); + +-- Path 9 +SET @PATH := (@CGUID+139) * 10; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`) VALUES +(@PATH, 0, -877.9913, 5623.479, 30.66024, 0), +(@PATH, 1, -863.0746, 5615.439, 30.35611, 0), +(@PATH, 2, -846.309, 5610.038, 24.90689, 0), +(@PATH, 3, -828.1684, 5609.345, 19.87268, 0), +(@PATH, 4, -810.6927, 5609.235, 17.89685, 0), +(@PATH, 5, -803.0434, 5611.29, 15.59436, 0), +(@PATH, 6, -794.6788, 5618.264, 12.25954, 0), +(@PATH, 7, -791.2239, 5624.606, 9.648945, 0), +(@PATH, 8, -787.4809, 5635.446, 4.889604, 0), +(@PATH, 9, -781.6823, 5643.933, 3.690141, 0), +(@PATH, 10, -778.2778, 5651.472, 1.836626, 0), +(@PATH, 11, -777.0313, 5659.531, 2.699419, 0), +(@PATH, 12, -780.7483, 5669.446, 2.970296, 0), +(@PATH, 13, -783.2761, 5678.696, 3.126912, 0), +(@PATH, 14, -789.9167, 5687.983, 3.26827, 0), +(@PATH, 15, -803.2274, 5693.413, 1.165392, 0), +(@PATH, 16, -814.816, 5695.01, 0.9443226, 0), +(@PATH, 17, -821.9323, 5695.971, 0.2285023, 0), +(@PATH, 18, -860.7327, 5711.32, -28.96108, 0), +(@PATH, 19, -861.2327, 5708.261, -31.47515, 18305), +(@PATH, 20, -828.8299, 5701.141, -0.8782938, 0), +(@PATH, 21, -813.4514, 5693.786, 1.019396, 0), +(@PATH, 22, -803.3941, 5691.943, 0.6675892, 0), +(@PATH, 23, -795.5139, 5689.909, 1.453084, 0), +(@PATH, 24, -789.6545, 5686.557, 3.19515, 0), +(@PATH, 25, -783.618, 5678.53, 2.70577, 0), +(@PATH, 26, -778.2621, 5668.851, 3.241536, 0), +(@PATH, 27, -774, 5658.838, 4.029008, 0), +(@PATH, 28, -776.8524, 5648.941, 3.187944, 0), +(@PATH, 29, -781.7379, 5641.378, 4.199541, 0), +(@PATH, 30, -787.618, 5630.611, 7.135518, 0), +(@PATH, 31, -791.0488, 5624.507, 9.669697, 0), +(@PATH, 32, -796.3386, 5617.41, 12.98342, 0), +(@PATH, 33, -801.8212, 5612.098, 15.20691, 0), +(@PATH, 34, -809.2049, 5610.686, 17.6156, 0), +(@PATH, 35, -821.7934, 5610.087, 19.38684, 0), +(@PATH, 36, -835.793, 5610.073, 21.65055, 0), +(@PATH, 37, -851.8542, 5612.029, 27.17118, 0), +(@PATH, 38, -864.7986, 5617.49, 30.56192, 0), +(@PATH, 39, -888.5452, 5631.759, 30.45687, 0), +(@PATH, 40, -900.0139, 5638.772, 30.00711, 0), +(@PATH, 41, -907.9601, 5643.569, 31.70584, 0), +(@PATH, 42, -909.8073, 5646.817, 33.28054, 0), +(@PATH, 43, -909.6667, 5649.215, 34.34378, 2606), +(@PATH, 44, -891.382, 5630.198, 30.45687, 0); + +UPDATE `creature_addon` SET `path_id` = @PATH WHERE `guid`= @CGUID+139; + +DELETE FROM `smart_scripts` WHERE (`entryorguid`= -(@CGUID+139) AND `source_type`= 0) OR (`entryorguid` = ((@CGUID+139) * 100) AND `source_type`= 9) OR (`entryorguid` = (((@CGUID+139) * 100) + 1) 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`, `event_param5`, `event_param_string`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_param4`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES +(-(@CGUID+139), 0, 0, 0, 34, 0, 100, 0, 2, 19, 0, 0, 0, '', 80, ((@CGUID+139) * 100), 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'OnMovementInform PathID 18 - Run Actionlist - to self'), +(-(@CGUID+139), 0, 1, 0, 34, 0, 100, 0, 2, 43, 0, 0, 0, '', 80, (((@CGUID+139) * 100) + 1), 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'OnMovementInform PathID 43 - Run Actionlist 2 - to self'), +(((@CGUID+139) * 100), 9, 0, 0, 0, 0, 100, 0, 2000, 2000, 2000, 2000, 0, '', 5, 69, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'After 2s - Emote 69 - to self'), +(((@CGUID+139) * 100), 9, 1, 0, 0, 0, 100, 0, 15000, 15000, 15000, 15000, 0, '', 11, 178767, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'After 15s - Cast Spell 178767 - to self'), +(((@CGUID+139) * 100), 9, 2, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, '', 5, 27, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'After 0s - Set Emote None - to self'), +((((@CGUID+139) * 100) + 1), 9, 0, 0, 0, 0, 100, 0, 1000, 1000, 1000, 1000, 0, '', 28, 178767, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'After 1s - Remove Spell 178767 - to self'); + +-- Path 10 +SET @PATH := (@CGUID+75) * 10; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`) VALUES +(@PATH, 0, -740.8715, 5852.671, 3.51394, 0), +(@PATH, 1, -727.6771, 5859.932, 2.901337, 0), +(@PATH, 2, -712.0174, 5873.327, 3.920816, 0), +(@PATH, 3, -703.1614, 5885.101, 1.402872, 0), +(@PATH, 4, -692.3264, 5889.488, 1.377628, 0), +(@PATH, 5, -685.007, 5886.338, 0.2002791, 0), +(@PATH, 6, -674.3253, 5882.73, -1.273337, 0), +(@PATH, 7, -664.7813, 5877.177, -1.730422, 0), +(@PATH, 8, -658.9531, 5870.703, -2.080336, 0), +(@PATH, 9, -649.233, 5853.262, -3.605489, 0), +(@PATH, 10, -645.4462, 5840.344, -4.234374, 0), +(@PATH, 11, -644.1736, 5826.344, -4.627909, 0), +(@PATH, 12, -645.6771, 5816.007, -3.798672, 0), +(@PATH, 13, -646.3177, 5804.348, -3.333465, 0), +(@PATH, 14, -645.6233, 5802.457, -3.383649, 3237), +(@PATH, 15, -652.1111, 5824.697, -4.058342, 0), +(@PATH, 16, -649.9672, 5834.221, -3.480206, 0), +(@PATH, 17, -649.4896, 5849.859, -3.658322, 0), +(@PATH, 18, -652.0764, 5862.295, -2.690558, 0), +(@PATH, 19, -660.1233, 5873.917, -1.942676, 0), +(@PATH, 20, -670.1823, 5881.76, -1.291052, 0), +(@PATH, 21, -689.3633, 5888.227, 1.002628, 0), +(@PATH, 22, -702.5608, 5890.822, 1.402872, 0), +(@PATH, 23, -715.2188, 5885.842, 1.277872, 0), +(@PATH, 24, -740.4011, 5872.119, 1.851321, 0), +(@PATH, 25, -747.1719, 5868.071, 1.115603, 0), +(@PATH, 26, -754.592, 5863.632, -0.279029, 0), +(@PATH, 27, -778.3195, 5849.143, -0.5066595, 0), +(@PATH, 28, -787.2049, 5845.677, 1.796685, 0), +(@PATH, 29, -798.5121, 5836.596, 6.306939, 0), +(@PATH, 30, -802, 5825.818, 5.722712, 0), +(@PATH, 31, -806.8403, 5815.661, -0.2453055, 0), +(@PATH, 32, -815.5903, 5804.397, -0.562078, 0), +(@PATH, 33, -827.3195, 5788.706, -0.5130707, 0), +(@PATH, 34, -832.0452, 5773.607, 0.9335846, 0), +(@PATH, 35, -822.5799, 5767.885, 2.611929, 0), +(@PATH, 36, -819.0868, 5759.384, 2.35911, 0), +(@PATH, 37, -822.9948, 5755.285, 0.3450718, 0), +(@PATH, 38, -871.2587, 5709.462, -27.6229, 0), +(@PATH, 39, -872.0226, 5706.003, -30.64598, 13049), +(@PATH, 40, -824.7222, 5751.873, -1.012383, 0), +(@PATH, 41, -811.5972, 5764.45, 2.60264, 0), +(@PATH, 42, -803.4114, 5769.601, -1.013071, 0), +(@PATH, 43, -791.0643, 5773.869, -1.103215, 0), +(@PATH, 44, -771.7396, 5781.844, -1.469425, 0), +(@PATH, 45, -761.584, 5789.956, 1.656799, 0), +(@PATH, 46, -762.4149, 5797.696, 2.781799, 0), +(@PATH, 47, -761.9393, 5807.86, 2.578488, 0), +(@PATH, 48, -754.4028, 5823.327, 4.053464, 0), +(@PATH, 49, -748.4375, 5840.491, 3.51748, 0); + +UPDATE `creature_addon` SET `path_id` = @PATH WHERE `guid`= @CGUID+75; + +DELETE FROM `smart_scripts` WHERE (`entryorguid`= -(@CGUID+75) AND `source_type`= 0) OR (`entryorguid` = ((@CGUID+75) * 100) AND `source_type`= 9) OR (`entryorguid` = (((@CGUID+75) * 100) + 1) 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`, `event_param5`, `event_param_string`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_param4`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES +(-(@CGUID+75), 0, 0, 0, 34, 0, 100, 0, 2, 39, 0, 0, 0, '', 80, ((@CGUID+75) * 100), 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'OnMovementInform PathID 38 - Run Actionlist - to self'), +(-(@CGUID+75), 0, 1, 0, 34, 0, 100, 0, 2, 14, 0, 0, 0, '', 80, (((@CGUID+75) * 100) + 1), 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'OnMovementInform PathID 14 - Run Actionlist 2 - to self'), +(((@CGUID+75) * 100), 9, 0, 0, 0, 0, 100, 0, 2000, 2000, 2000, 2000, 0, '', 5, 69, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'After 2s - Emote 69 - to self'), +(((@CGUID+75) * 100), 9, 1, 0, 0, 0, 100, 0, 10000, 10000, 10000, 10000, 0, '', 11, 178767, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'After 10s - Cast Spell 178767 - to self'), +(((@CGUID+75) * 100), 9, 2, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, '', 5, 27, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'After 0s - Set Emote None - to self'), +((((@CGUID+75) * 100) + 1), 9, 0, 0, 0, 0, 100, 0, 2000, 2000, 2000, 2000, 0, '', 28, 178767, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'After 2s - Remove Spell 178767 - to self'); + +-- Path 11 +SET @PATH := (@CGUID+119) * 10; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`) VALUES +(@PATH, 0, -878.4566, 5814.31, 2.526567, 0), +(@PATH, 1, -879.9636, 5796.124, 0.405226, 0), +(@PATH, 2, -877.0538, 5788.53, 3.845655, 0), +(@PATH, 3, -873.5191, 5773.616, -0.09025741, 0), +(@PATH, 4, -864.082, 5760.694, -2.475533, 0), +(@PATH, 5, -882.9601, 5700.838, -28.12865, 0), +(@PATH, 6, -876.8125, 5698.853, -32.39284, 16381), +(@PATH, 7, -886.5886, 5735.489, -2.034283, 0), +(@PATH, 8, -881.6389, 5750.979, 1.361494, 0), +(@PATH, 9, -880.9879, 5764.43, 2.850508, 0), +(@PATH, 10, -882.3333, 5782.723, 2.545973, 0), +(@PATH, 11, -881.6233, 5803.159, 0.2609422, 0), +(@PATH, 12, -879.1111, 5815.136, 2.27022, 0), +(@PATH, 13, -881.5868, 5827.359, 0.1359422, 0), +(@PATH, 14, -882.8281, 5840.118, -0.9018283, 0), +(@PATH, 15, -888.4827, 5864.444, -1.369846, 0), +(@PATH, 16, -895.1059, 5871.691, 0.5407984, 0), +(@PATH, 17, -893.941, 5882.307, 0.8255885, 0), +(@PATH, 18, -887.8125, 5891.351, 1.501004, 0), +(@PATH, 19, -885.2882, 5910.032, -0.3898032, 0), +(@PATH, 20, -888.3889, 5919.04, 0.8931558, 0), +(@PATH, 21, -895.8854, 5922.314, 2.919035, 0), +(@PATH, 22, -906.4861, 5924.567, 4.414706, 0), +(@PATH, 23, -914.743, 5927.68, 6.251989, 0), +(@PATH, 24, -921.743, 5932.1, 6.040014, 0), +(@PATH, 25, -926.8577, 5937.196, 4.968264, 0), +(@PATH, 26, -930.4063, 5941.932, 3.388224, 0), +(@PATH, 27, -931.8507, 5946.049, 3.620045, 0), +(@PATH, 28, -934.4496, 5948.431, 3.736934, 2733), +(@PATH, 29, -928.0278, 5938.304, 4.468736, 0), +(@PATH, 30, -922.0278, 5932.862, 6.120639, 0), +(@PATH, 31, -913.3108, 5926.341, 5.546624, 0), +(@PATH, 32, -902.3524, 5924.642, 4.063144, 0), +(@PATH, 33, -893.6152, 5922.471, 2.360197, 0), +(@PATH, 34, -886.4896, 5915.094, -0.1996177, 0), +(@PATH, 35, -885.0957, 5901.162, -0.1398032, 0), +(@PATH, 36, -885.9601, 5890.423, 2.678372, 0), +(@PATH, 37, -887.2761, 5878.198, 1.689114, 0), +(@PATH, 38, -885.8577, 5854.108, -2.649631, 0), +(@PATH, 39, -881.8715, 5828.022, 0.1359422, 0); + +UPDATE `creature_addon` SET `path_id` = @PATH WHERE `guid`= @CGUID+119; + +DELETE FROM `smart_scripts` WHERE (`entryorguid`= -(@CGUID+119) AND `source_type`= 0) OR (`entryorguid` = ((@CGUID+119) * 100) AND `source_type`= 9) OR (`entryorguid` = (((@CGUID+119) * 100) + 1) 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`, `event_param5`, `event_param_string`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_param4`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES +(-(@CGUID+119), 0, 0, 0, 34, 0, 100, 0, 2, 6, 0, 0, 0, '', 80, ((@CGUID+119) * 100), 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'OnMovementInform PathID 6 - Run Actionlist - to self'), +(-(@CGUID+119), 0, 1, 0, 34, 0, 100, 0, 2, 28, 0, 0, 0, '', 80, (((@CGUID+119) * 100) + 1), 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'OnMovementInform PathID 28 - Run Actionlist 2 - to self'), +(((@CGUID+119) * 100), 9, 0, 0, 0, 0, 100, 0, 2000, 2000, 2000, 2000, 0, '', 5, 69, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'After 2s - Emote 69 - to self'), +(((@CGUID+119) * 100), 9, 1, 0, 0, 0, 100, 0, 13000, 13000, 13000, 13000, 0, '', 11, 178767, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'After 13s - cast Spell 178767 - to self'), +(((@CGUID+119) * 100), 9, 2, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, '', 5, 27, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'After 0s - Set Emote None - to self'), +((((@CGUID+119) * 100) + 1), 9, 0, 0, 0, 0, 100, 0, 2000, 2000, 2000, 2000, 0, '', 28, 178767, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'After 2s - Remove Spell 178767 - to self'); |