DB/Azsuna: Added spawns for Illidari Stand and Faronaar

Closes #28439

1 files changed, 341 insertions, 0 deletions

diff --git a/sql/updates/world/master/2022_11_04_00_world.sql b/sql/updates/world/master/2022_11_04_00_world.sql
new file mode 100644
index 00000000000..62b807bfd94
--- /dev/null
+++ b/sql/updates/world/master/2022_11_04_00_world.sql
@@ -0,0 +1,341 @@
+SET @CGUID := 651367;
+SET @OGUID := 400393;
+SET @NPCTEXTID := 560006;
+
+SET @PATH := (@CGUID+48) * 10;
+SET @PATH2:= (@CGUID+82) * 10;
+SET @PATH3:= (@CGUID+11) * 10;
+SET @PATH4:= (@CGUID+26) * 10;
+SET @PATH5:= (@CGUID+17) * 10;
+
+DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+100;
+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, 91629, 1220, 7334, 7364, '0', '0', 0, 0, 1, -119.706596374511718, 6856.42431640625, 24.539459228515625, 4.719357013702392578, 7200, 0, 0, 29423, 0, 0, 0, 0, 0, 46366),
+(@CGUID+1, 101943, 1220, 7334, 7364, '0', '0', 0, 0, 1, -254.170135498046875, 7020.68994140625, 5.046155929565429687, 5.730144500732421875, 7200, 0, 0, 3923, 0, 0, 0, 0, 0, 46366),
+(@CGUID+2, 86969, 1220, 7334, 7364, '0', '0', 0, 0, 1, -161.262161254882812, 6976.7099609375, 6.23937225341796875, 2.198951959609985351, 7200, 0, 0, 15692, 0, 0, 0, 0, 0, 46366),
+(@CGUID+3, 90241, 1220, 7334, 7362, '0', '0', 0, 0, 0, -160.574661254882812, 7028.6005859375, 0.777826189994812011, 5.196426868438720703, 7200, 0, 0, 3923, 0, 0, 0, 0, 0, 46366),
+(@CGUID+4, 93556, 1220, 7334, 7364, '0', '0', 0, 0, 0, -249.94792, 7042.1475, 20.999844, 3.144028902053833007, 7200, 10, 0, 3923, 0, 0, 0, 0, 0, 46366), -- Cyclic movement waypoints NYI
+(@CGUID+5, 90241, 1220, 7334, 7364, '0', '0', 0, 0, 0, -125.036460876464843, 7092.9287109375, 4.290858268737792968, 4.813736438751220703, 7200, 0, 0, 3923, 0, 0, 0, 0, 0, 46366),
+(@CGUID+6, 90472, 1220, 7334, 7364, '0', '0', 0, 0, 0, -154.1875, 6963.83154296875, 8.352264404296875, 2.011160612106323242, 7200, 0, 0, 3923, 0, 0, 0, 0, 0, 46366),
+(@CGUID+7, 86969, 1220, 7334, 7364, '0', '0', 0, 0, 0, -28.4670143127441406, 6939.48974609375, 16.46723175048828125, 2.429181098937988281, 7200, 0, 0, 15692, 0, 0, 0, 0, 0, 46366),
+(@CGUID+8, 101943, 1220, 7334, 7364, '0', '0', 0, 0, 1, -190.524307250976562, 7081.939453125, 0.215867787599563598, 6.062908649444580078, 7200, 0, 0, 3923, 0, 0, 0, 0, 0, 46366),
+(@CGUID+9, 89278, 1220, 7334, 7364, '0', '0', 0, 0, 1, -138.366317749023437, 7022.25537109375, 0.356038421392440795, 2.057244777679443359, 7200, 0, 0, 15692, 0, 0, 0, 0, 0, 46366),
+(@CGUID+10, 114110, 1220, 7334, 7364, '0', '0', 0, 0, 0, -143.33160400390625, 7015.7890625, 0.356038421392440795, 0.943202197551727294, 7200, 0, 0, 15692, 0, 0, 0, 0, 0, 46366),
+(@CGUID+11, 90241, 1220, 7334, 7364, '0', '0', 0, 0, 0, -115.3802, 7097.582, 0.6316093, 4.021164417266845703, 7200, 10, 0, 3923, 0, 2, 0, 0, 0, 46366),
+(@CGUID+12, 101946, 1220, 7334, 7364, '0', '0', 0, 0, 0, -159.883682250976562, 6968.90087890625, 7.553019523620605468, 5.787972927093505859, 7200, 0, 0, 3923, 0, 0, 0, 0, 0, 46366),
+(@CGUID+13, 86969, 1220, 7334, 7364, '0', '0', 0, 0, 1, -94.5538177490234375, 7057.291015625, 0.484673380851745605, 1.435394763946533203, 7200, 0, 0, 15692, 0, 0, 0, 0, 0, 46366),
+(@CGUID+14, 101942, 1220, 7334, 7364, '0', '0', 0, 0, 0, -137.838546752929687, 6984.259765625, 13.76237678527832031, 1.793703436851501464, 7200, 0, 0, 3923, 0, 0, 0, 0, 0, 46366),
+(@CGUID+15, 86969, 1220, 7334, 7364, '0', '0', 0, 0, 1, -237.53472900390625, 7042.92724609375, 3.487080812454223632, 2.11955881118774414, 7200, 0, 0, 15692, 0, 0, 0, 0, 0, 46366),
+(@CGUID+16, 101944, 1220, 7334, 7364, '0', '0', 0, 0, 0, -149.826385498046875, 7021.36962890625, 0.356038421392440795, 2.795562744140625, 7200, 0, 0, 3923, 0, 0, 0, 0, 0, 46366),
+(@CGUID+17, 90230, 1220, 7334, 7364, '0', '0', 0, 0, 1, -198.866317749023437, 7071.791015625, 0.353793859481811523, 1.349283456802368164, 7200, 10, 0, 4708, 0, 2, 0, 0, 0, 46366),
+(@CGUID+18, 101943, 1220, 7334, 7364, '0', '0', 0, 0, 1, -255.935760498046875, 7029.00244140625, 4.327521800994873046, 6.00265359878540039, 7200, 0, 0, 3923, 0, 0, 0, 0, 0, 46366),
+(@CGUID+19, 101945, 1220, 7334, 7364, '0', '0', 0, 0, 0, -187.546875, 6998.08837890625, 1.356508135795593261, 5.704200267791748046, 7200, 0, 0, 3923, 0, 0, 0, 0, 0, 46366),
+(@CGUID+20, 114110, 1220, 7334, 7364, '0', '0', 0, 0, 0, -231.392364501953125, 7037.7275390625, 3.515675783157348632, 5.841028213500976562, 7200, 0, 0, 15692, 0, 0, 0, 0, 0, 46366),
+(@CGUID+21, 114109, 1220, 7334, 7364, '0', '0', 0, 0, 0, -105.263893127441406, 7015.11376953125, 9.502870559692382812, 1.88655245304107666, 7200, 0, 0, 15692, 0, 0, 0, 0, 0, 46366),
+(@CGUID+22, 91629, 1220, 7334, 7364, '0', '0', 0, 0, 1, -63.0434036254882812, 6963.8837890625, 15.61006355285644531, 4.375405311584472656, 7200, 0, 0, 29423, 0, 0, 0, 0, 0, 46366),
+(@CGUID+23, 86969, 1220, 7334, 7364, '0', '0', 0, 0, 1, -167.708984375, 7077.47119140625, 3.864780187606811523, 1.626374483108520507, 7200, 0, 0, 15692, 0, 0, 0, 0, 0, 46366),
+(@CGUID+24, 101945, 1220, 7334, 7364, '0', '0', 0, 0, 0, -191.786453247070312, 6994.8974609375, 1.489687919616699218, 4.130480289459228515, 7200, 0, 0, 3923, 0, 0, 0, 0, 0, 46366),
+(@CGUID+25, 91629, 1220, 7334, 7364, '0', '0', 0, 0, 1, -13.6302080154418945, 6997.65869140625, 16.20730400085449218, 0.975415766239166259, 7200, 0, 0, 29423, 0, 0, 0, 0, 0, 46366),
+(@CGUID+26, 90241, 1220, 7334, 7364, '0', '0', 0, 0, 0, -160.4792, 7107.105, -0.3179791, 4.077411651611328125, 7200, 10, 0, 3923, 0, 2, 0, 0, 0, 46366),
+(@CGUID+27, 86969, 1220, 7334, 7364, '0', '0', 0, 0, 1, -136.708328247070312, 7022.900390625, 0.356038421392440795, 1.712857365608215332, 7200, 0, 0, 15692, 0, 0, 0, 0, 0, 46366),
+(@CGUID+28, 101943, 1220, 7334, 7364, '0', '0', 0, 0, 1, -168.279510498046875, 7101.6953125, 0.058572020381689071, 5.166181564331054687, 7200, 0, 0, 3923, 0, 0, 0, 0, 0, 46366),
+(@CGUID+29, 86969, 1220, 7334, 7364, '0', '0', 0, 0, 1, -123.171882629394531, 7006.01025390625, 5.279543399810791015, 1.457709550857543945, 7200, 0, 0, 15692, 0, 0, 0, 0, 0, 46366),
+(@CGUID+30, 101946, 1220, 7334, 7364, '0', '0', 0, 0, 0, -139.902786254882812, 7018.1025390625, 0.356038421392440795, 3.562463760375976562, 7200, 0, 0, 3923, 0, 0, 0, 0, 0, 46366),
+(@CGUID+31, 90241, 1220, 7334, 7364, '0', '0', 0, 0, 0, -218.33160400390625, 6984.69970703125, 2.626282930374145507, 0.159291118383407592, 7200, 0, 0, 3923, 0, 0, 0, 0, 0, 46366),
+(@CGUID+32, 101945, 1220, 7334, 7364, '0', '0', 0, 0, 0, -146.975692749023437, 7063.28564453125, 1.191849708557128906, 3.385095119476318359, 7200, 0, 0, 3923, 0, 0, 0, 0, 0, 46366),
+(@CGUID+33, 114109, 1220, 7334, 7364, '0', '0', 0, 0, 0, -145.404510498046875, 7060.52587890625, 1.229215383529663085, 2.368582963943481445, 7200, 0, 0, 15692, 0, 0, 0, 0, 0, 46366),
+(@CGUID+34, 101946, 1220, 7334, 7364, '0', '0', 0, 0, 0, -163.880203247070312, 6985.1162109375, 4.339728832244873046, 2.992022037506103515, 7200, 0, 0, 3923, 0, 0, 0, 0, 0, 46366),
+(@CGUID+35, 86969, 1220, 7334, 7364, '0', '0', 0, 0, 1, -141.33160400390625, 6991.37744140625, 7.192618846893310546, 1.780180931091308593, 7200, 0, 0, 15692, 0, 0, 0, 0, 0, 46366),
+(@CGUID+36, 89278, 1220, 7334, 7364, '0', '0', 0, 0, 0, -27.9114589691162109, 6942.5546875, 16.46762275695800781, 3.413798093795776367, 7200, 0, 0, 15692, 0, 0, 0, 0, 0, 46366),
+(@CGUID+37, 101942, 1220, 7334, 7364, '0', '0', 0, 0, 0, -105.90625, 7007.99658203125, 15.31316566467285156, 1.801617860794067382, 7200, 0, 0, 3923, 0, 0, 0, 0, 0, 46366),
+(@CGUID+38, 114109, 1220, 7334, 7364, '0', '0', 0, 0, 0, -99.1215286254882812, 7046.51416015625, 0.386210203170776367, 0.341125369071960449, 7200, 0, 0, 15692, 0, 0, 0, 0, 0, 46366),
+(@CGUID+39, 101946, 1220, 7334, 7364, '0', '0', 0, 0, 0, -99.8975677490234375, 7047.59228515625, 0.392480254173278808, 4.037448883056640625, 7200, 0, 0, 3923, 0, 0, 0, 0, 0, 46366),
+(@CGUID+40, 101945, 1220, 7334, 7364, '0', '0', 0, 0, 0, -148.083328247070312, 7061.58349609375, 1.497244596481323242, 4.863125801086425781, 7200, 0, 0, 3923, 0, 0, 0, 0, 0, 46366),
+(@CGUID+41, 89278, 1220, 7334, 7364, '0', '0', 0, 0, 1, -121.519096374511718, 7006.046875, 4.59091949462890625, 2.247623443603515625, 7200, 0, 0, 15692, 0, 0, 0, 0, 0, 46366),
+(@CGUID+42, 93556, 1220, 7334, 7364, '0', '0', 0, 0, 0, -96.44097, 7065.1353, 18.400755, 5.977463245391845703, 7200, 10, 0, 3923, 0, 0, 0, 0, 0, 46366), -- Cyclic movement waypoints NYI
+(@CGUID+43, 90241, 1220, 7334, 7364, '0', '0', 0, 0, 0, -218.744796752929687, 7026.29248046875, 4.782213211059570312, 5.196426868438720703, 7200, 0, 0, 3923, 0, 0, 0, 0, 0, 46366),
+(@CGUID+44, 90230, 1220, 7334, 7364, '0', '0', 0, 0, 1, -144.204864501953125, 7057.8662109375, 1.090842843055725097, 4.793518543243408203, 7200, 0, 0, 4708, 0, 0, 0, 0, 0, 46366),
+(@CGUID+45, 101946, 1220, 7334, 7364, '0', '0', 0, 0, 0, -144.61285400390625, 7064.42529296875, 0.706783592700958251, 4.863125801086425781, 7200, 0, 0, 3923, 0, 0, 0, 0, 0, 46366),
+(@CGUID+46, 90230, 1220, 7334, 7362, '0', '0', 0, 0, 1, -154.56597900390625, 7119.93603515625, 3.025842666625976562, 4.996253013610839843, 7200, 0, 0, 4708, 0, 0, 0, 0, 0, 46366),
+(@CGUID+47, 93556, 1220, 7334, 7364, '0', '0', 0, 0, 0, -164.08333, 7036.282, 17.085796, 5.515166282653808593, 7200, 10, 0, 3923, 0, 2, 0, 0, 0, 46366), -- Cyclic movement waypoints NYI
+(@CGUID+48, 91629, 1220, 7334, 7364, '0', '0', 0, 0, 1, -69.71066, 6933.52, 15.75721, 6.26853799819946289, 7200, 10, 0, 29423, 0, 2, 0, 0, 0, 46366),
+(@CGUID+49, 89639, 1220, 7334, 7364, '0', '0', 0, 0, 0, -66.0121536254882812, 6990.54345703125, 20.09235572814941406, 4.632546424865722656, 7200, 0, 0, 3923, 0, 0, 0, 0, 0, 46366),
+(@CGUID+50, 101943, 1220, 7334, 7362, '0', '0', 0, 0, 1, -188.960067749023437, 7142.28564453125, 2.638201713562011718, 5.009999752044677734, 7200, 0, 0, 3923, 0, 0, 0, 0, 0, 46366),
+(@CGUID+51, 88110, 1220, 7334, 7364, '0', '0', 0, 0, 1, -120.324653625488281, 6892.69287109375, 16.64319992065429687, 6.1561279296875, 7200, 0, 0, 281565, 0, 0, 0, 0, 0, 46366),
+(@CGUID+52, 101946, 1220, 7334, 7364, '0', '0', 0, 0, 0, -201.751739501953125, 7001.94189453125, 4.475363731384277343, 5.715639591217041015, 7200, 0, 0, 3923, 0, 0, 0, 0, 0, 46366),
+(@CGUID+53, 91629, 1220, 7334, 7364, '0', '0', 0, 0, 1, -13.6302080154418945, 6997.65869140625, 16.20730400085449218, 0.975415766239166259, 7200, 0, 0, 29423, 0, 0, 0, 0, 0, 46366),
+(@CGUID+54, 90241, 1220, 7334, 7364, '0', '0', 0, 0, 0, -116.739593505859375, 7043.056640625, 3.909649610519409179, 4.561187267303466796, 7200, 0, 0, 3923, 0, 0, 0, 0, 0, 46366),
+(@CGUID+55, 86969, 1220, 7334, 7364, '0', '0', 0, 0, 1, -102.678817749023437, 7011.9765625, 9.390178680419921875, 1.503866314888000488, 7200, 0, 0, 15692, 0, 0, 0, 0, 0, 46366),
+(@CGUID+56, 101946, 1220, 7334, 7364, '0', '0', 0, 0, 0, -105.302093505859375, 7040, 0.402382969856262207, 4.029429912567138671, 7200, 0, 0, 3923, 0, 0, 0, 0, 0, 46366),
+(@CGUID+57, 114110, 1220, 7334, 7364, '0', '0', 0, 0, 0, -164.208328247070312, 6982.75244140625, 4.969631195068359375, 2.697113275527954101, 7200, 0, 0, 15692, 0, 0, 0, 0, 0, 46366),
+(@CGUID+58, 101946, 1220, 7334, 7364, '0', '0', 0, 0, 0, -174.883682250976562, 7013.330078125, 0.356038421392440795, 0.738861024379730224, 7200, 0, 0, 3923, 0, 0, 0, 0, 0, 46366),
+(@CGUID+59, 114814, 1220, 7334, 7364, '0', '0', 0, 0, 1, -127.083984375, 6959.759765625, 10.22009754180908203, 2.43846750259399414, 7200, 0, 0, 15692, 0, 0, 0, 0, 0, 46366),
+(@CGUID+60, 86969, 1220, 7334, 7364, '0', '0', 0, 0, 0, -35.3975715637207031, 6941.7880859375, 16.44537544250488281, 0.782978951930999755, 7200, 0, 0, 15692, 0, 0, 0, 0, 0, 46366),
+(@CGUID+61, 89278, 1220, 7334, 7364, '0', '0', 0, 0, 1, -163.329864501953125, 6973.923828125, 6.412470340728759765, 2.697113275527954101, 7200, 0, 0, 15692, 0, 0, 0, 0, 0, 46366),
+(@CGUID+62, 93556, 1220, 7334, 7364, '0', '0', 0, 0, 0, -143.8489, 7086.4253, 46.995647, 0.045072555541992187, 7200, 10, 0, 3923, 0, 0, 0, 0, 0, 46366), -- Cyclic movement waypoints NYI
+(@CGUID+63, 93556, 1220, 7334, 7362, '0', '0', 0, 0, 0, -217.34549, 7059.085, 60.09742, 5.777190685272216796, 7200, 10, 0, 3923, 0, 0, 0, 0, 0, 46366), -- Cyclic movement waypoints NYI
+(@CGUID+64, 101946, 1220, 7334, 7364, '0', '0', 0, 0, 0, -139.993057250976562, 7013.22119140625, 0.356036543846130371, 5.752692222595214843, 7200, 0, 0, 3923, 0, 0, 0, 0, 0, 46366),
+(@CGUID+65, 89278, 1220, 7334, 7364, '0', '0', 0, 0, 1, -107.411460876464843, 7011.83154296875, 9.8451995849609375, 1.651541709899902343, 7200, 0, 0, 15692, 0, 0, 0, 0, 0, 46366),
+(@CGUID+66, 91629, 1220, 7334, 7364, '0', '0', 0, 0, 1, -13.6302080154418945, 6997.65869140625, 16.20730400085449218, 0.975415766239166259, 7200, 0, 0, 29423, 0, 0, 0, 0, 0, 46366),
+(@CGUID+67, 114109, 1220, 7334, 7364, '0', '0', 0, 0, 0, -144.277786254882812, 6994.20654296875, 6.45587778091430664, 2.88969588279724121, 7200, 0, 0, 15692, 0, 0, 0, 0, 0, 46366),
+(@CGUID+68, 101944, 1220, 7334, 7364, '0', '0', 0, 0, 0, -144.463546752929687, 7011.1865234375, 0.356038421392440795, 2.456390619277954101, 7200, 0, 0, 3923, 0, 0, 0, 0, 0, 46366),
+(@CGUID+69, 93619, 1220, 7334, 7364, '0', '0', 0, 0, 0, -122.756942749023437, 7069.8505859375, -1.07904779911041259, 5.806659221649169921, 7200, 0, 0, 5885, 0, 0, 0, 0, 0, 46366),
+(@CGUID+70, 89278, 1220, 7334, 7364, '0', '0', 0, 0, 1, -143.83160400390625, 6989.8916015625, 6.986639976501464843, 2.112378120422363281, 7200, 0, 0, 15692, 0, 0, 0, 0, 0, 46366),
+(@CGUID+71, 89640, 1220, 7334, 7364, '0', '0', 0, 0, 1, -89.1440963745117187, 6951.3583984375, 14.18726158142089843, 4.626760005950927734, 7200, 0, 0, 3923, 0, 0, 0, 0, 0, 46366),
+(@CGUID+72, 110903, 1220, 7334, 7364, '0', '0', 0, 0, 0, 488.861114501953125, 5670.74755859375, 71.942352294921875, 0, 7200, 0, 0, 392300, 0, 0, 0, 0, 0, 46366),
+(@CGUID+73, 93619, 1220, 7334, 7364, '0', '0', 0, 0, 0, -222.449661254882812, 7076.78662109375, -0.0839317962527275, 5.502653121948242187, 7200, 0, 0, 5885, 0, 0, 0, 0, 0, 46366),
+(@CGUID+74, 114109, 1220, 7334, 7364, '0', '0', 0, 0, 0, -191.421875, 6993.2744140625, 0.967502295970916748, 0.751223385334014892, 7200, 0, 0, 15692, 0, 0, 0, 0, 0, 46366),
+(@CGUID+75, 93556, 1220, 7334, 7364, '0', '0', 0, 0, 0, -188.89236, 7104.471, 39.899586, 2.079339981079101562, 7200, 10, 0, 3923, 0, 0, 0, 0, 0, 46366), -- Cyclic movement waypoints NYI
+(@CGUID+76, 101945, 1220, 7334, 7364, '0', '0', 0, 0, 0, -145.397567749023437, 6970.69873046875, 8.206768989562988281, 5.146622657775878906, 7200, 0, 0, 3923, 0, 0, 0, 0, 0, 46366),
+(@CGUID+77, 89278, 1220, 7334, 7364, '0', '0', 0, 0, 1, -33.7141990661621093, 6944.30126953125, 16.18113327026367187, 5.418959617614746093, 7200, 10, 0, 15692, 0, 0, 0, 0, 0, 46366), -- Smart/Dynamic Waypoints NYI
+(@CGUID+78, 90317, 1220, 7334, 7364, '0', '0', 0, 0, 1, -109.786460876464843, 6988.10498046875, 12.19747638702392578, 2.402194738388061523, 7200, 0, 0, 43153, 0, 0, 0, 0, 0, 46366),
+(@CGUID+79, 91629, 1220, 7334, 7364, '0', '0', 0, 0, 1, -13.6302080154418945, 6997.65869140625, 16.20730400085449218, 0.975415766239166259, 7200, 0, 0, 29423, 0, 0, 0, 0, 0, 46366),
+(@CGUID+80, 101945, 1220, 7334, 7364, '0', '0', 0, 0, 0, -144.979171752929687, 7020.5556640625, 0.356038421392440795, 0.609704077243804931, 7200, 0, 0, 3923, 0, 0, 0, 0, 0, 46366),
+(@CGUID+81, 91629, 1220, 7334, 7364, '0', '0', 0, 0, 1, -13.6302080154418945, 6997.65869140625, 16.20730400085449218, 0.975415766239166259, 7200, 0, 0, 29423, 0, 0, 0, 0, 0, 46366),
+(@CGUID+82, 86969, 1220, 7334, 7364, '0', '0', 0, 0, 1, -104.4115, 7015.07, 9.364746, 4.167835712432861328, 7200, 10, 0, 15692, 0, 2, 0, 0, 0, 46366),
+(@CGUID+83, 110903, 1220, 7334, 7364, '0', '0', 0, 0, 0, 494.791656494140625, 5670.17724609375, 72.68473052978515625, 3.648639917373657226, 7200, 0, 0, 392300, 0, 0, 0, 0, 0, 46366),
+(@CGUID+84, 114110, 1220, 7334, 7364, '0', '0', 0, 0, 0, -144.107635498046875, 7016.1484375, 0.356038421392440795, 2.511880159378051757, 7200, 0, 0, 15692, 0, 0, 0, 0, 0, 46366),
+(@CGUID+85, 93622, 1220, 7334, 7364, '0', '0', 0, 0, 0, -156.559036254882812, 7154.37841796875, 9.300958633422851562, 4.90847635269165039, 7200, 0, 0, 156920, 7670, 0, 0, 0, 0, 46366),
+(@CGUID+86, 91629, 1220, 7334, 7364, '0', '0', 0, 0, 1, -83.0710220336914062, 6917.70556640625, 15.0019073486328125, 0.228408202528953552, 7200, 10, 0, 29423, 0, 0, 0, 0, 0, 46366),
+(@CGUID+87, 101946, 1220, 7334, 7364, '0', '0', 0, 0, 0, -166.340286254882812, 6984.07470703125, 4.43399810791015625, 6.062327384948730468, 7200, 0, 0, 3923, 0, 0, 0, 0, 0, 46366),
+(@CGUID+88, 89278, 1220, 7334, 7364, '0', '0', 0, 0, 0, -36.5190963745117187, 6945.9287109375, 16.44197463989257812, 6.175286769866943359, 7200, 0, 0, 15692, 0, 0, 0, 0, 0, 46366),
+(@CGUID+89, 101945, 1220, 7334, 7364, '0', '0', 0, 0, 0, -146.755203247070312, 7016.0791015625, 0.356038421392440795, 4.863125801086425781, 7200, 0, 0, 3923, 0, 0, 0, 0, 0, 46366),
+(@CGUID+90, 89278, 1220, 7334, 7364, '0', '0', 0, 0, 0, -34.2395820617675781, 6939.07373046875, 16.48068618774414062, 1.208884954452514648, 7200, 0, 0, 15692, 0, 0, 0, 0, 0, 46366),
+(@CGUID+91, 89278, 1220, 7334, 7364, '0', '0', 0, 0, 1, -159.26910400390625, 6978.46875, 6.188448905944824218, 2.382307291030883789, 7200, 0, 0, 15692, 0, 0, 0, 0, 0, 46366),
+(@CGUID+92, 93556, 1220, 7334, 7364, '0', '0', 0, 0, 0, -252.5573, 7102.672, 20.383596, 5.255422115325927734, 7200, 10, 0, 3923, 0, 0, 0, 0, 0, 46366), -- Cyclic movement waypoints NYI
+(@CGUID+93, 91629, 1220, 7334, 7364, '0', '0', 0, 0, 1, -13.6302080154418945, 6997.65869140625, 16.20730400085449218, 0.975415766239166259, 7200, 0, 0, 29423, 0, 0, 0, 0, 0, 46366),
+(@CGUID+94, 101943, 1220, 7334, 7364, '0', '0', 0, 0, 1, -98.0590286254882812, 7102.2197265625, 0.172246307134628295, 4.763774871826171875, 7200, 0, 0, 3923, 0, 0, 0, 0, 0, 46366),
+(@CGUID+95, 101943, 1220, 7334, 7364, '0', '0', 0, 0, 1, -103.154518127441406, 7101.77880859375, 0.172246307134628295, 4.528980255126953125, 7200, 0, 0, 3923, 0, 0, 0, 0, 0, 46366),
+(@CGUID+96, 101943, 1220, 7334, 7362, '0', '0', 0, 0, 1, -246.755203247070312, 7109.953125, 4.30916595458984375, 5.114465713500976562, 7200, 0, 0, 3923, 0, 0, 0, 0, 0, 46366),
+(@CGUID+97, 101943, 1220, 7334, 7362, '0', '0', 0, 0, 1, -253.026046752929687, 7113.58837890625, 5.587430953979492187, 4.509237289428710937, 7200, 0, 0, 3923, 0, 0, 0, 0, 0, 46366),
+(@CGUID+98, 90241, 1220, 7334, 7362, '0', '0', 0, 0, 0, -288.868072509765625, 7088.8681640625, 2.745197057723999023, 5.888378620147705078, 7200, 0, 0, 3923, 0, 0, 0, 0, 0, 46366),
+(@CGUID+99, 90230, 1220, 7334, 7362, '0', '0', 0, 0, 1, -205.465286254882812, 7124.6943359375, 1.943464517593383789, 4.726717948913574218, 7200, 0, 0, 4708, 0, 0, 0, 0, 0, 46366),
+(@CGUID+100, 90230, 1220, 7334, 7362, '0', '0', 0, 0, 1, -230.973953247070312, 7117.87255859375, 5.078034877777099609, 5.013012886047363281, 7200, 0, 0, 4708, 0, 0, 0, 0, 0, 46366);
+
+DELETE FROM `creature_addon` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+100;
+INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES
+(@CGUID+0, 0, 0, 0, 257, 333, 0, 0, 0, 0, '18950'),
+(@CGUID+2, 0, 0, 0, 1, 505, 0, 0, 0, 0, '222589'),
+(@CGUID+4, 0, 0, 50331648, 1, 0, 0, 0, 0, 3, ''),
+(@CGUID+6, 0, 0, 262144, 1, 0, 0, 0, 0, 0, '159474'),
+(@CGUID+7, 0, 0, 3, 1, 0, 0, 0, 0, 0, '222589'),
+(@CGUID+9, 0, 0, 0, 1, 505, 0, 0, 0, 0, '222589'),
+(@CGUID+10, 0, 0, 262144, 1, 0, 0, 0, 0, 0, '222589 159474'),
+(@CGUID+11, @PATH3, 0, 0, 1, 0, 0, 0, 0, 0, ''),
+(@CGUID+12, 0, 0, 262144, 1, 0, 0, 0, 0, 0, '159474'),
+(@CGUID+13, 0, 0, 0, 1, 505, 0, 0, 0, 0, '222589'),
+(@CGUID+14, 0, 0, 0, 1, 0, 0, 0, 0, 3, ''),
+(@CGUID+15, 0, 0, 0, 1, 505, 0, 0, 0, 0, '222589'),
+(@CGUID+16, 0, 0, 262144, 1, 0, 0, 0, 0, 0, '159474'),
+(@CGUID+17, @PATH5, 0, 0, 1, 0, 0, 0, 0, 0, ''),
+(@CGUID+19, 0, 0, 262144, 1, 0, 0, 0, 0, 0, '159474'),
+(@CGUID+20, 0, 0, 262144, 1, 0, 0, 0, 0, 0, '222589 159474'),
+(@CGUID+21, 0, 0, 262144, 1, 0, 0, 0, 0, 0, '222589 159474'),
+(@CGUID+22, 0, 0, 0, 257, 333, 0, 0, 0, 0, '18950'),
+(@CGUID+23, 0, 0, 0, 1, 505, 0, 0, 0, 0, '222589'),
+(@CGUID+24, 0, 0, 262144, 1, 0, 0, 0, 0, 0, '159474'),
+(@CGUID+26, @PATH4, 0, 0, 1, 0, 0, 0, 0, 0, ''),
+(@CGUID+27, 0, 0, 0, 1, 505, 0, 0, 0, 0, '222589'),
+(@CGUID+29, 0, 0, 0, 1, 505, 0, 0, 0, 0, '222589'),
+(@CGUID+30, 0, 0, 262144, 1, 0, 0, 0, 0, 0, '159474'),
+(@CGUID+32, 0, 0, 262144, 1, 0, 0, 0, 0, 0, '159474'),
+(@CGUID+33, 0, 0, 262144, 1, 0, 0, 0, 0, 0, '222589 159474'),
+(@CGUID+34, 0, 0, 262144, 1, 0, 0, 0, 0, 0, '159474'),
+(@CGUID+35, 0, 0, 0, 1, 505, 0, 0, 0, 0, '222589'),
+(@CGUID+36, 0, 0, 3, 1, 0, 0, 0, 0, 0, '222589'),
+(@CGUID+37, 0, 0, 0, 1, 0, 0, 0, 0, 3, ''),
+(@CGUID+38, 0, 0, 262144, 1, 0, 0, 0, 0, 0, '222589 159474'),
+(@CGUID+39, 0, 0, 262144, 1, 0, 0, 0, 0, 0, '159474'),
+(@CGUID+40, 0, 0, 262144, 1, 0, 0, 0, 0, 0, '159474'),
+(@CGUID+41, 0, 0, 0, 1, 505, 0, 0, 0, 0, '222589'),
+(@CGUID+42, 0, 0, 50331648, 1, 0, 0, 0, 0, 3, ''),
+(@CGUID+45, 0, 0, 262144, 1, 0, 0, 0, 0, 0, '159474'),
+(@CGUID+47, 0, 0, 50331648, 1, 0, 0, 0, 0, 3, ''),
+(@CGUID+48, @PATH, 65445, 0, 257, 0, 0, 0, 0, 0, '18950'),
+(@CGUID+51, 0, 0, 0, 1, 333, 0, 0, 0, 0, '42459'),
+(@CGUID+52, 0, 0, 262144, 1, 0, 0, 0, 0, 0, '159474'),
+(@CGUID+53, 0, 0, 50331648, 1, 0, 0, 0, 0, 3, ''),
+(@CGUID+55, 0, 0, 0, 1, 505, 0, 0, 0, 0, '222589'),
+(@CGUID+56, 0, 0, 262144, 1, 0, 0, 0, 0, 0, '159474'),
+(@CGUID+57, 0, 0, 262144, 1, 0, 0, 0, 0, 0, '222589 159474'),
+(@CGUID+58, 0, 0, 262144, 1, 0, 0, 0, 0, 0, '159474'),
+(@CGUID+59, 0, 0, 0, 1, 333, 0, 0, 0, 0, '222589'),
+(@CGUID+60, 0, 0, 3, 1, 0, 0, 0, 0, 0, '222589'), 
+(@CGUID+61, 0, 0, 0, 1, 505, 0, 0, 0, 0, '222589'),
+(@CGUID+62, 0, 0, 50331648, 1, 0, 0, 0, 0, 3, ''),
+(@CGUID+63, 0, 0, 50331648, 1, 0, 0, 0, 0, 3, ''),
+(@CGUID+64, 0, 0, 262144, 1, 0, 0, 0, 0, 0, '159474'),
+(@CGUID+65, 0, 0, 0, 1, 505, 0, 0, 0, 0, '222589'),
+(@CGUID+66, 0, 0, 0, 257, 333, 0, 0, 0, 0, '99203 18950'),
+(@CGUID+67, 0, 0, 262144, 1, 0, 0, 0, 0, 0, '222589 159474'),
+(@CGUID+68, 0, 0, 262144, 1, 0, 0, 0, 0, 0, '159474'),
+(@CGUID+69, 0, 0, 0, 1, 0, 0, 0, 0, 4, ''),
+(@CGUID+70, 0, 0, 0, 1, 505, 0, 0, 0, 0, '222589'),
+(@CGUID+71, 0, 0, 0, 1, 572, 0, 0, 0, 0, ''),
+(@CGUID+72, 0, 0, 0, 1, 0, 0, 0, 0, 5, ''),
+(@CGUID+73, 0, 0, 0, 1, 0, 0, 0, 0, 4, ''),
+(@CGUID+74, 0, 0, 262144, 1, 0, 0, 0, 0, 0, '222589 159474'),
+(@CGUID+75, 0, 0, 50331648, 1, 0, 0, 0, 0, 3, ''),
+(@CGUID+76, 0, 0, 262144, 1, 0, 0, 0, 0, 0, '159474'),
+(@CGUID+77, 0, 0, 0, 0, 0, 0, 0, 0, 0, '222589'),
+(@CGUID+78, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
+(@CGUID+80, 0, 0, 262144, 1, 0, 0, 0, 0, 0, '159474'),
+(@CGUID+82, @PATH2, 0, 0, 1, 0, 0, 0, 0, 0, '222589'),
+(@CGUID+83, 0, 0, 0, 1, 0, 0, 0, 0, 5, ''),
+(@CGUID+84, 0, 0, 262144, 1, 0, 0, 0, 0, 0, '222589 159474'),
+(@CGUID+85, 0, 0, 0, 1, 0, 0, 0, 0, 4, '218517'),
+(@CGUID+86, 0, 65445, 0, 257, 0, 0, 0, 0, 0, '18950'),
+(@CGUID+87, 0, 0, 262144, 1, 0, 0, 0, 0, 0, '159474'),
+(@CGUID+88, 0, 0, 3, 1, 0, 0, 0, 0, 0, '222589'),
+(@CGUID+89, 0, 0, 262144, 1, 0, 0, 0, 0, 0, '159474'),
+(@CGUID+90, 0, 0, 3, 1, 0, 0, 0, 0, 0, '222589'),
+(@CGUID+91, 0, 0, 0, 1, 505, 0, 0, 0, 0, '222589'),
+(@CGUID+92, 0, 0, 50331648, 1, 0, 0, 0, 0, 3, '');
+
+DELETE FROM `creature_formations` WHERE `leaderGUID` = @CGUID+48;
+INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES
+(@CGUID+48, @CGUID+48, 0, 0, 515, 0, 0),
+(@CGUID+48, @CGUID+86, 3, 300, 515, 0, 0);
+
+DELETE FROM `creature_template_movement` WHERE `CreatureId`=93556;
+INSERT INTO `creature_template_movement` (`CreatureId`, `Ground`, `Swim`, `Flight`, `Rooted`, `Chase`, `Random`, `InteractionPauseTimer`)
+VALUES (93556, 0, 0, 1, 0, 0, 0, NULL);
+
+UPDATE `creature_template` SET `unit_flags3` = 16777216 WHERE `entry` = 101942;
+UPDATE `creature_template` SET `gossip_menu_id` = 17058 WHERE `entry` = 90317;
+UPDATE `creature_template` SET `gossip_menu_id` = 18068 WHERE `entry` = 89640;
+UPDATE `creature_template` SET `gossip_menu_id` = 18069 WHERE `entry` = 89639;
+
+DELETE FROM `creature_template_addon` WHERE `entry` IN (89639, 101943, 90241, 90230);
+INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES
+(89639, 0, 0, 0, 1, 0, 0, 0, 0, 0, ''),
+(101943, 0, 0, 0, 1, 0, 0, 0, 0, 0, ''),
+(90241, 0, 0, 0, 1, 0, 0, 0, 0, 0, ''),
+(90230, 0, 0, 0, 1, 0, 0, 0, 0, 0, '');
+
+DELETE FROM `waypoint_data` WHERE `id`= @PATH;
+INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `move_type`) VALUES
+(@PATH, 0, -66.36979, 6937.867, 16.11394, 1),
+(@PATH, 1, -65.48611, 6946.044, 15.48894, 1),
+(@PATH, 2, -69.71181, 6955.099, 15.11963, 1),
+(@PATH, 3, -79.52257, 6962.229, 14.31714, 1),
+(@PATH, 4, -88.77431, 6965.894, 13.17237, 1),
+(@PATH, 5, -107.4063, 6969.273, 12.21759, 1),
+(@PATH, 6, -122.8333, 6968.214, 10.49298, 1),
+(@PATH, 7, -133.6493, 6963.251, 9.265392, 1),
+(@PATH, 8, -133.3142, 6950.871, 10.47413, 1),
+(@PATH, 9, -122.6944, 6942.978, 12.14124, 1),
+(@PATH, 10, -116.5938, 6935.606, 13.14124, 1),
+(@PATH, 11, -109.7274, 6926.427, 13.65741, 1),
+(@PATH, 12, -103.3594, 6918.713, 14.38715, 1),
+(@PATH, 13, -92.5625, 6915.499, 14.46761, 1),
+(@PATH, 14, -82.03472, 6917.953, 15.01497, 1),
+(@PATH, 15, -74.38541, 6922.613, 15.41609, 1),
+(@PATH, 16, -69.35243, 6929.085, 15.76497, 1);
+
+DELETE FROM `waypoint_data` WHERE `id`= @PATH2;
+INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `move_type`) VALUES
+(@PATH2, 0, -104.4115, 7015.07, 9.364746, 1),
+(@PATH2, 1, -163.9688, 6979.245, 5.636425, 1);
+
+DELETE FROM `waypoint_data` WHERE `id`= @PATH3;
+INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`) VALUES
+(@PATH3, 0, -115.3802, 7097.582, 0.6316093, 37084),
+(@PATH3, 1, -124.7691, 7094.671, 3.811175, 0),
+(@PATH3, 2, -131.191, 7090.704, 4.869036, 0),
+(@PATH3, 3, -134.6406, 7086.471, 5.645648, 12838),
+(@PATH3, 4, -131.191, 7090.704, 4.869036, 0),
+(@PATH3, 5, -124.7691, 7094.671, 3.811175, 0);
+
+DELETE FROM `waypoint_data` WHERE `id`= @PATH4;
+INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`) VALUES
+(@PATH4, 0, -160.4792, 7107.105, -0.3179791, 0),
+(@PATH4, 1, -153.0903, 7107.567, 0.1607807, 0),
+(@PATH4, 2, -146.7604, 7109.211, 1.581313, 0),
+(@PATH4, 3, -142.309, 7112.944, 1.55519, 0),
+(@PATH4, 4, -135.8056, 7116.519, 1.547499, 0),
+(@PATH4, 5, -131.4688, 7115.854, 2.093764, 50360),
+(@PATH4, 6, -142.309, 7112.944, 1.55519, 0),
+(@PATH4, 7, -146.7604, 7109.211, 1.581313, 0),
+(@PATH4, 8, -153.0903, 7107.567, 0.1607807, 0),
+(@PATH4, 9, -160.4792, 7107.105, -0.3179791, 0),
+(@PATH4, 10, -168.7153, 7105.702, -0.06750643, 0),
+(@PATH4, 11, -177.1632, 7101.863, 0.3074936, 0),
+(@PATH4, 12, -184.9792, 7096.21, 0.1772802, 0),
+(@PATH4, 13, -190.0347, 7089.348, 0.1772802, 11364),
+(@PATH4, 14, -184.9792, 7096.21, 0.1772802, 0),
+(@PATH4, 15, -177.1632, 7101.863, 0.3074936, 0),
+(@PATH4, 16, -168.7153, 7105.702, -0.06750643, 0);
+
+DELETE FROM `waypoint_data` WHERE `id`= @PATH5;
+INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`) VALUES
+(@PATH5, 0, -200.0139, 7066.683, 0.6621672, 0),
+(@PATH5, 1, -199.3021, 7057.803, 1.052117, 0),
+(@PATH5, 2, -202.342, 7042.708, 0.4654284, 0),
+(@PATH5, 3, -203.8629, 7038.132, 3.40387, 0),
+(@PATH5, 4, -206.6997, 7031.48, 5.589512, 17754),
+(@PATH5, 5, -203.9155, 7038.008, 3.440195, 0),
+(@PATH5, 6, -202.342, 7042.708, 0.4654284, 0),
+(@PATH5, 7, -199.2691, 7049.087, 1.779412, 0),
+(@PATH5, 8, -199.3021, 7057.803, 1.052117, 0),
+(@PATH5, 9, -200.0139, 7066.683, 0.6621672, 0),
+(@PATH5, 10, -198.8663, 7071.791, 0.3537939, 16772);
+
+DELETE FROM `npc_text` WHERE `ID` BETWEEN @NPCTEXTID+0 AND @NPCTEXTID+2;
+INSERT INTO `npc_text` (`ID`, `Probability0`, `Probability1`, `Probability2`, `Probability3`, `Probability4`, `Probability5`, `Probability6`, `Probability7`, `BroadcastTextId0`, `BroadcastTextId1`, `BroadcastTextId2`, `BroadcastTextId3`, `BroadcastTextId4`, `BroadcastTextId5`, `BroadcastTextId6`, `BroadcastTextId7`, `VerifiedBuild`) VALUES
+(@NPCTEXTID+0, 1, 0, 0, 0, 0, 0, 0, 0, 121767, 0, 0, 0, 0, 0, 0, 0, 46366),
+(@NPCTEXTID+1, 1, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 46366),
+(@NPCTEXTID+2, 1, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 46366);
+
+DELETE FROM `gossip_menu` WHERE (`MenuID`=17058 AND `TextID`=@NPCTEXTID+0) OR (`MenuID`=18068 AND `TextID`=@NPCTEXTID+1) OR (`MenuID`=18069 AND `TextID`=@NPCTEXTID+2);
+INSERT INTO `gossip_menu` (`MenuID`, `TextID`, `VerifiedBuild`) VALUES
+(17058, @NPCTEXTID+0, 46366), -- 90317
+(18068, @NPCTEXTID+1, 46366), -- 89640
+(18069, @NPCTEXTID+2, 46366); -- 89639
+
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+26;
+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, 246352, 1220, 7334, 7364, '0', '0', 0, -195.486114501953125, 7081.525390625, 0.132534459233283996, 5.341781139373779296, 0, 0, -0.45351219177246093, 0.891250073909759521, 7200, 255, 1, 46366),
+(@OGUID+1, 253551, 1220, 7334, 7364, '0', '0', 0, -106.520843505859375, 6954.3037109375, 12.47725868225097656, 3.324855327606201171, 0.003552913665771484, -0.00253200531005859, -0.99579620361328125, 0.091492816805839538, 7200, 255, 1, 46366),
+(@OGUID+2, 253548, 1220, 7334, 7364, '0', '0', 0, -92.4444427490234375, 6949.9755859375, 13.99384498596191406, 1.099556207656860351, -0.04976701736450195, 0.015744209289550781, 0.522936820983886718, 0.850771665573120117, 7200, 255, 1, 46366),
+(@OGUID+3, 253549, 1220, 7334, 7364, '0', '0', 0, -89.4305572509765625, 6949.40185546875, 14.08954429626464843, 4.878195762634277343, -0.0013289451599121, -0.01806354522705078, -0.64589881896972656, 0.763208091259002685, 7200, 255, 1, 46366),
+(@OGUID+4, 254279, 1220, 7334, 7364, '0', '0', 0, -123.701393127441406, 6855.24853515625, 24.51584625244140625, 4.511676311492919921, -0.02310800552368164, -0.00266742706298828, -0.7743387222290039, 0.632343649864196777, 7200, 255, 1, 46366),
+(@OGUID+5, 253552, 1220, 7334, 7364, '0', '0', 0, -106.967018127441406, 6952.578125, 12.55732440948486328, 5.61123514175415039, 0, 0, -0.32968997955322265, 0.944089233875274658, 7200, 255, 1, 46366),
+(@OGUID+6, 255795, 1220, 7334, 7364, '0', '0', 0, -64.9739608764648437, 6966.93603515625, 15.38535785675048828, 4.127703666687011718, 0, 0, -0.8808908462524414, 0.473319470882415771, 7200, 255, 1, 46366),
+(@OGUID+7, 253564, 1220, 7334, 7364, '0', '0', 0, -132.897567749023437, 6937.55908203125, 12.4097146987915039, 3.490667104721069335, 0, 0, -0.98480701446533203, 0.173652306199073791, 7200, 255, 1, 46366),
+(@OGUID+8, 239970, 1220, 7334, 7364, '0', '0', 0, -95.657989501953125, 6983.31103515625, 13.64953422546386718, 3.58614659309387207, 0, 0, -0.97539806365966796, 0.220451012253761291, 7200, 255, 1, 46366),
+(@OGUID+9, 246285, 1220, 7334, 7364, '0', '0', 0, -100.489593505859375, 7105.25341796875, 0.0889129638671875, 3.814753055572509765, 0, 0, -0.94388961791992187, 0.330261081457138061, 7200, 255, 1, 46366),
+(@OGUID+10, 239452, 1220, 7334, 7364, '0', '0', 0, -235.427078247070312, 7038.73779296875, 3.501537561416625976, 2.047666072845458984, 0, 0, 0.854107856750488281, 0.52009594440460205, 7200, 255, 1, 46366),
+(@OGUID+11, 239970, 1220, 7334, 7364, '0', '0', 0, -86.25, 6981.9755859375, 15.39867877960205078, 3.58614659309387207, 0, 0, -0.97539806365966796, 0.220451012253761291, 7200, 255, 1, 46366),
+(@OGUID+12, 246352, 1220, 7334, 7364, '0', '0', 0, -248.751739501953125, 7112.7421875, 4.914931297302246093, 5.341781139373779296, 0, 0, -0.45351219177246093, 0.891250073909759521, 7200, 255, 1, 46366),
+(@OGUID+13, 239332, 1220, 7334, 7364, '0', '0', 0, -163.918411254882812, 6917.2646484375, 12.65213489532470703, 5.339580535888671875, 0, 0, -0.45449256896972656, 0.890750527381896972, 7200, 255, 1, 46366),
+(@OGUID+14, 239338, 1220, 7334, 7364, '0', '0', 0, -158.890625, 6893.83056640625, 14.7916107177734375, 1.327823400497436523, 0, 0, 0.616202354431152343, 0.787587881088256835, 7200, 255, 1, 46366),
+(@OGUID+15, 237017, 1220, 7334, 7364, '0', '0', 0, -157.633682250976562, 6904.8671875, 13.32248973846435546, 5.305594921112060546, 0, 0, -0.46956253051757812, 0.882899224758148193, 7200, 255, 1, 46366),
+(@OGUID+16, 239456, 1220, 7334, 7364, '0', '0', 0, -54.9027786254882812, 7005.19873046875, 34.59968948364257812, 3.785145521163940429, 0, 0, -0.94867515563964843, 0.316252201795578002, 7200, 255, 1, 46366),
+(@OGUID+17, 246352, 1220, 7334, 7364, '0', '0', 0, -257.65277099609375, 7023.94287109375, 4.751971721649169921, 5.90987253189086914, 0, 0, -0.18557453155517578, 0.98263019323348999, 7200, 255, 1, 46366),
+(@OGUID+18, 251769, 1220, 7334, 7364, '0', '0', 0, -156.559036254882812, 7154.38037109375, 0.778647959232330322, 5.059690475463867187, 0, 0, -0.57429885864257812, 0.818645715713500976, 7200, 255, 1, 46366),
+(@OGUID+19, 253549, 1220, 7334, 7364, '0', '0', 0, -89.4305572509765625, 6949.40185546875, 14.08954429626464843, 4.878195762634277343, -0.0013289451599121, -0.01806354522705078, -0.64589881896972656, 0.763208091259002685, 7200, 255, 1, 46366),
+(@OGUID+20, 246352, 1220, 7334, 7364, '0', '0', 0, -163.64410400390625, 7102.19287109375, -0.21480107307434082, 0.645103991031646728, 0, 0, 0.316987991333007812, 0.948429524898529052, 7200, 255, 1, 46366),
+(@OGUID+21, 246352, 1220, 7334, 7364, '0', '0', 0, -100.489593505859375, 7105.25341796875, 0.0889129638671875, 3.814753055572509765, 0, 0, -0.94388961791992187, 0.330261081457138061, 7200, 255, 1, 46366),
+(@OGUID+22, 239984, 1220, 7334, 7364, '0', '0', 0, -168.274307250976562, 7074.22216796875, 3.75162506103515625, 1.505763411521911621, 0, 0, 0.683744430541992187, 0.729721605777740478, 7200, 255, 1, 46366),
+(@OGUID+23, 241859, 1220, 7334, 7364, '0', '0', 0, -154.390625, 6964.64404296875, 8.100642204284667968, 5.222336769104003906, 0.316813468933105468, 0.526314735412597656, -0.40389060974121093, 0.677860200405120849, 7200, 255, 1, 46366),
+(@OGUID+24, 239985, 1220, 7334, 7364, '0', '0', 0, -97.2274322509765625, 7052.6474609375, 0.26029244065284729, 0.776014506816864013, 0, 0, 0.378344535827636718, 0.925664842128753662, 7200, 255, 1, 46366),
+(@OGUID+25, 246285, 1220, 7334, 7364, '0', '0', 0, -195.486114501953125, 7081.525390625, 0.132534459233283996, 4.446521759033203125, 0, 0, -0.79458999633789062, 0.607146382331848144, 7200, 255, 1, 46366),
+(@OGUID+26, 240291, 1220, 7334, 7364, '0', '0', 0, -105.600692749023437, 7007.0546875, 9.621527671813964843, 1.880708217620849609, 0, 0, 0.807766914367675781, 0.58950197696685791, 7200, 255, 0, 46366);
+
+DELETE FROM `gameobject_template_addon` WHERE `entry` IN (251769, 241859, 240291, 239985, 239984, 246352, 237017, 239338, 239332, 239452, 246285, 239970);
+INSERT INTO `gameobject_template_addon` (`entry`, `faction`, `flags`, `WorldEffectID`, `AIAnimKitID`) VALUES
+(251769, 0, 32, 0, 0),
+(241859, 114, 0, 0, 0),
+(240291, 114, 32, 0, 0),
+(239985, 0, 262176, 0, 0),
+(239984, 0, 262176, 0, 0),
+(246352, 114, 8192, 0, 0),
+(237017, 0, 262144, 0, 0),
+(239338, 0, 262144, 0, 0),
+(239332, 0, 262144, 0, 0),
+(239452, 0, 262176, 0, 0),
+(246285, 114, 8192, 0, 0),
+(239970, 114, 0, 0, 0);
+
+UPDATE `gameobject_template` SET `ContentTuningId` = 331 WHERE `entry` IN (239984, 239985, 240291, 251769, 239452);