The Botanica

[Xadras]

Complete Dungeon Overhaul for Botanica with Focus on Complete Groups, AIs, NPC-Values, Linking, Movement, Immunities, Visuals and Texts.

---

ToDo:

• Boss Laj might only have high resistance, no spell school immunitites
• Boss AI: Dorngrin der Hüter , Kommandantin Sarannis
• https://github.com/OregonCore/OregonCore/commit/776a00f28f3bb9cfd2ae7c3c450eaab427591e00
• entry 16346 ai anschauen

---

• [ ] Creatures in Tempest Keep:Botanica, Tempest Keep: Mechanar, and Tempest Keep:Arcatraz no longer respawn as rapidly.

• [ ] Sunseeker Gene-Splicer's Death and Decay now deals significantly less damage and casts less frequently.

• [ ] Mutate Fleshlashers now deal less melee damage.

• [ ] Mutate Horrors and Fear-Shriekers now have less health.

• [ ] Sunseeker Researchers will now cast shocks less frequently.

• [ ] Sunseeker Chemists are now Paladin type instead of Warrior type.

• [ ] The Blue Seedlings in the High Botanist Freywinn encounter now slow players instead of immobilizing them.

• [ ] High Botanist Freywinn will now plant seedlings at a slightly reduced rate.

http://wowwiki.wikia.com/wiki/Patch_2.0.10

---

• [ ] Creatures in Tempest Keep: The Eye, The Arcatraz, The Mechanar, The Botanica all have a chance at dropping health and mana potions that will only function inside the Tempest Keep raid and dungeon instances.

• [ ] Bloodwarder Protector's Crystal Strike may now be dodged and parried.

• [ ] Tempest-Forge Peacekeepers now deal Physical melee damage instead of Arcane, and now longer perform the Arcane Blast ability on Heroic difficulty.

• [ ] The duration of Vial of Poison has been reduced significantly.

• [ ] Greater Frayer's do more damage in Heroic difficulty.

• [ ] Nethervine Reapers and Inciters' damage has been reduced in Heroic difficulty.

• [ ] Thorngrin the Tender's damage has been reduced in Heroic difficulty.

• [ ] Mutate Fleshlasher's damage has bene reduced in Heroic difficulty.

• [ ] The Sunseeker Gene-Splicer's Death & Decay will occur less frequently and the damage has been reduced on Heroic difficulty.

• [ ] Mutate Fear-Shrieker and Mutate Horror hit points are reduced

• [ ] Warp Splinter's Arcane Volley damage has been reduced on Heroic.

• [ ] The Bloodwarder Protector's involved in the fight with the Mutate Horror's and Mutate Fear-Shrieker's in The Botanica no longer remain at 1 health and will properly be killed.

http://wowwiki.wikia.com/wiki/Patch_2.1.0

---

• [ ] The time between casting of Thorgrin the Tender's Hellfire has been increased. 34659,39131
• [ ] The time between casting of Thorgrin the Tender’s Sacrifice has been increased in Heroic Mode.
• [ ] Thorgrin the Tender’s Enrage ability now increases his melee damage by 75% instead of 110%.

http://wowwiki.wikia.com/wiki/Patch_2.2.0

[Xadras]

Placeholder

[Xadras]

Sources:

https://github.com/Schaka/TBC-research/issues/16

http://www.wowhead.com/zone=3847/the-botanica , http://wowwiki.wikia.com/wiki/Botanica , http://wow.gamepedia.com/Botanica

http://www.buffed.de/World-of-Warcraft-Spiel-42971/Guides/WoW-Guide-Botanika-791188/ , http://wow.4fansites.de/dungeons-botanika.php

https://www.youtube.com/watch?v=C_qoQ4ghpL4 - dungeons: The Botanica

https://www.youtube.com/watch?v=l8vVDX23WZE - Feral Tank Druid in Botanica (part 1/5)

https://www.youtube.com/watch?v=u_GDYM369cw - Feral Tank Druid in Botanica (part 2/5)

https://www.youtube.com/watch?v=vAEuuP6RvWs - Feral Tank Druid in Botanica (part 3/5)

https://www.youtube.com/watch?v=Inxi3dF2nLQ - Feral Tank Druid in Botanica (part 4/5)

https://www.youtube.com/watch?v=36vo8EqnipA - Feral Tank Druid in Botanica (part 5/5)

[Xadras]

#!sql

-- https://github.com/Looking4Group/L4G_Core/issues/1541
-- The Botanica

-- Texts & Scripts

DELETE FROM `creature_ai_texts` WHERE `entry` BETWEEN -9849 AND -9848;
INSERT INTO `creature_ai_texts` VALUES
(-9849,'Protect the Botanica at all costs!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,0,0,'-144 17976'),
(-9848,'%s calls for reinforcements!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,2,0,0,'-343 17976 Summon Adds');
-- (-9847,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'BotanicaPlatzhalter'),

DELETE FROM `creature_ai_texts` WHERE `entry` IN (-1292,-1293,-1294,-1295,-1296,-1297,-1298,-1299,-1300,-1301,-1302,-1303,-1304,-1305,-1306,-1307,-1308,-1309,-1310,-1311,-1312,-1313,-1314,-1315,-1316,-1317,-1318,-1319,-1320,-1321,-1322,-1323,-1324,-1325,-1326,-1327,-1328,-1329,-1330,-1331,-1332,-1333,-1334,-1335,-1336,-1337,-1338,-1339,-1340,-1341,-1342,-1343,-1344,-1345,-1346,-1347,-1348,-1349,-1350,-1351,-1352,-1353,-1354,-1355,-1356,-1357,-1358,-1359,-1360,-1361,-1362,-1363,-1364,-1365,-1366,-1367,-1368,-1369,-1370,-1371);
INSERT INTO `creature_ai_texts` (`entry`,`content_default`,`sound`,`type`,`language`,`comment`,`emote`) VALUES
('-1292','Hm, hungry.','0','0','0','18598','0'),
('-1293','So-ngh-thirsty.','0','0','0','18598','0'),
('-1294','Intruders have breached the hatchery! Sound the alarm! Protect the eggs at all costs!','8272','1','0','12557','0'),
('-1295','Foolish mortal, you serve me now!','8273','1','0','12557','0'),
('-1296','The power of the light is truly great and merciful.','0','0','0','14484, 14485','0'),
('-1297','We shall be reunited once more, my love...','0','0','0','14484, 14485','0'),
('-1298','At last, it ends...','0','0','0','14484, 14485','0'),
('-1299','Stranger, find the fallen Prince Menethil and end his reign of terror.','0','0','0','14484, 14485','0'),
('-1300','Should I live through this, I shall make it my life\'s sole ambition to destroy Arthas...','0','0','0','14484, 14485','0'),
('-1301','I won\'t make it... go... go on without me...','0','0','0','14484, 14485','0'),
('-1302','Death take me! I cannot go on! I have nothing left...','0','0','0','14484, 14485','0'),
('-1303',NULL,'0','0','0','LEER','0'),
('-1304','Kill $n!','0','1','0','17994 Call of the Falcon','5'),
-- Please re-use -1303 and -1304
('-1305','The light condemns all who harbor evil.  Now you will die!','0','0','0','Scarlet Monastery','0'),
('-1306','You carry the taint of the scourge.  Prepare to enter the twisting nether.','0','0','0','Scarlet Monastery','0'),
('-1307','There is no escape for you.  The Crusade shall destroy all who carry the scourge\'s taint.','0','0','0','Scarlet Monastery','0'),
('-1308','The Scarlet Crusade shall smite the wicked and drive evil from these lands!','0','0','0','Scarlet Monastery','0'),
('-1309','Do as I say, Fly!','0','0','0','17994','0'),
('-1310','Welcome to flavor country!','0','0','0','11058','0'),
('-1311','Kitten for sale, looking for a good home.','0','0','0','8666','0'),
('-1312','I can\'t believe dad won\'t let me keep your sister.','0','0','0','8666','0'),
('-1313','Can anyone give my adorable, extra little kitty a home?','0','0','0','8666','0'),
('-1314','What does allergic mean anyway? And what does it have to do with either of my kitties?','0','0','0','8666','0'),
('-1315','Will someone please give my little kitten a good home?','0','0','0','8666','0'),
('-1316','Don\'t worry, I\'ll find a good home for ya.','0','0','0','8666','0'),
('-1317','Silithid Creeper lays an egg!','0','2','0','3250','0'),
('-1318','Silithid Creeper Egg begins to crack and open...','0','2','0','5781','0'),
('-1319','Silithid Creeper Egg splits open!','0','2','0','5781','0'),
('-1320','Your pathetic attempt to escape will be short lived, Gorefiend. Let the boy go and submit! Even with your armour and weapons, you cannot defeat the ancients!','0','0','0','21877','0'),
('-1321','What ... have you done...','0','1','0','21877','0'),
('-1322','Pray that the chilling embrace of Teron Gorefiend does not reach out for you...','0','4','0','21788 21795','0'),
('-1323','It is you who have invaded our home. Gorefiend will avenge us!','0','4','0','21788 21795','0'),
('-1324','We will never dissipate, mortal... Our fate is tied to Gorefiend...','0','4','0','21788 21795','0'),
('-1325','We are bound here... eternally. It is the will of Gorefiend.','0','4','0','21788 21795','0'),
('-1326','Gorefiend will have your head, interloper!','0','4','0','21788 21795','0'),
('-1327','%s returns the rude gesture to $n','0','2','0','Jenn/Elly Langston rude','0'),
('-1328','Well hello, $n, what can I get you today?','0','0','0','Jenn/Elly Langston random text','0'),
('-1329','Been a tough day? A nice ale should loosen those worries right up.','0','0','0','Jenn/Elly Langston random text','0'),
('-1330','Do you think I need more pieces of flair?','0','0','0','Jenn Langston random text','0'),
('-1331','What do you fancy, $G sir:miss;?','0','0','0','Jenn Langston random text','0'),
('-1332','Hi, what would you like?','0','0','0','Jenn Langston random text','0'),
('-1333','Look what the cat dragged in. What can I get you, $n?','0','0','0','Jenn Langston random text','0'),
('-1334','Remain strong. Kael\'thas will - error - Lor\'themar will lead you to power and glory!','0','0','0','18103','0'),
('-1335','Maintain order within these walls.','0','0','0','18103','0'),
('-1336','Happiness is mandatory, citizen.','0','0','0','18103','0'),
('-1337','Do not be disheartened. Silvermoon will remain strong through this course of events.','0','0','0','18103','0'),
('-1338','The magister\'s going to kill me...','0','0','0','18230','0'),
('-1339','Argh. They told me those crystals would work properly!','0','0','0','18230','0'),
('-1340','When I catch you, I\'m going to disenchant your components, so help me...','0','0','0','18230','0'),
('-1341','You stay out of the regent lord\'s way! I mean it!','0','0','0','18230','0'),
('-1342','No, no, no! Come back here!','0','0','0','18230','0'),
('-1343',NULL,'0','0','0','LEER','0'),
('-1344',NULL,'0','0','0','LEER','0'),
('-1345',NULL,'0','0','0','LEER','0'),
('-1346',NULL,'0','0','0','LEER','0'),
('-1347',NULL,'0','0','0','LEER','0'),
('-1348',NULL,'0','0','0','LEER','0'),
('-1349','Burn Burn Burn','0','0','12','18109','0'),
('-1350','%s appears very grateful to be free of the koi-koi spirit\'s influence.','0','2','0','21326','34'),
('-1351','AYYAYAAYAA!','0','0','0','22483','0'),
('-1352','AWOOOOGAAAA!','0','0','0','22483','0'),
('-1353','AAAAEEEEEEIIIIIIII!!!!!','0','0','0','22483','0'),
('-1354',NULL,'0','0','0','LEER','0'),
('-1355',NULL,'0','0','0','LEER','0'),
('-1356',NULL,'0','0','0','LEER','0'),
('-1357',NULL,'0','0','0','LEER','0'),
('-1358',NULL,'0','0','0','LEER','0'),
('-1359',NULL,'0','0','0','LEER','0'),
('-1360',NULL,'0','0','0','LEER','0'),
('-1361',NULL,'0','0','0','LEER','0'),
('-1362',NULL,'0','0','0','LEER','0'),
('-1363',NULL,'0','0','0','LEER','0'),
('-1364',NULL,'0','0','0','LEER','0'),
('-1365','I\'ll crush you!','0','0','0','9196','0'),
('-1366','Me smash! You die!','0','0','0','9196','0'),
('-1367','Raaar!!! Me smash $R!','0','0','0','9196','1'),
('-1368','I cannot be destroyed! By the will of Ragnaros, I shall be reborn!','0','0','0','9017','0'),
('-1369','What are you doing? Intruders!!','0','1','0','9476','0'),
('-1370','Intruders in the Manufactory? My constructs will destroy you!','0','0','0','8983','0'),
('-1371','%s gets really dizzy!','0','2','0','9554','0');

UPDATE creature_ai_texts SET content_loc3='Tretet vor. Ich sorge dafür, dass Ihr ordendlich empfangen werdet!' WHERE entry=-34;
UPDATE creature_ai_texts SET content_loc3='Ich bin nicht nur ein einfacher Untergebener.' WHERE entry=-37;
UPDATE creature_ai_texts SET content_loc3='Band\'or shorel\'aran!' WHERE entry=-38;
UPDATE creature_ai_texts SET content_loc3='Wachen! Vernichtet diese Eindringlinge!' WHERE entry=-39;
UPDATE creature_ai_texts SET content_loc3='Ist dies das Ende?' WHERE entry=-40;
UPDATE creature_ai_texts SET content_loc3='Was wird werden...' WHERE entry=-41;
UPDATE creature_ai_texts SET content_loc3='Es wird Zeit, sich uns anzuschließen, $C.' WHERE entry=-42;

DELETE FROM db_script_string WHERE entry IN (2000005550,2000005551,2000005552,2000005553,2000005554,2000005555,2000005556,2000005557,2000005558,2000005559); -- 8298601 8303501 8304901 8304902 8298701 8298702 8298703 8298704
INSERT INTO `db_script_string` (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`) VALUES 
('2000005550','We must not fail our leader!  Kael\'thas will redeem us!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -- yell
('2000005551','Hmm...Frost, Fire, and Arcane defenses respond faster than Batch 7, but Nature defenses remain passive.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -- say
('2000005552','Hmm...',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -- say
('2000005553','Yes. That did the trick.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -- say
('2000005554','...mumble...Petals of Fire...mumble...',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -- say
('2000005555','...mumble mumble...',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -- say
('2000005556','...with the right mixture, perhaps...',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -- say
('2000005557','...thorny vines...mumble...ouch!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -- say
('2000005558','Get out of here, there are too many of them! Escape while you can!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -- yell
('2000005559','Help! Someone help us!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); -- yell

-- waypoint script
DELETE FROM `waypoint_scripts` WHERE `id` IN ('8315101','8299401','8298601','8303501','8303502','8303503','8303504','8303505','8304901','8304902','8304903','8305201','8298701','8298702','8298703','8298704','8307101','8307102','8307103','8307104','8307105','8307106','8307107','8307108','8307109','8307110','8305901','8305902','8305903','8305904');
INSERT INTO `waypoint_scripts` VALUES
(8315101,0,1,66,1,0,0,0,0,0,8315101),
--
(8299401,0,1,378,1,0,0,0,0,0,8299401),
--
(8298601,10000,0,1,0,2000005550,0,0,0,0,8298601), -- yell geht nicht mal say machen
--
(8303501,0,0,0,0,2000005551,0,0,0,0,8303501), -- say
(8303502,0,15,34167,1,0,0,0,0,0,8303502), -- frost
(8303503,0,15,34169,1,0,0,0,0,0,8303503), -- fire
(8303504,0,15,34170,1,0,0,0,0,0,8303504), -- arcane
(8303505,0,15,37788,1,0,0,0,0,0,8303505), -- shadow need shadow dummy spell
--
(8304901,0,0,0,0,2000005552,0,0,0,0,8304901),
(8304902,0,0,0,0,2000005553,0,0,0,0,8304902),
(8304903,0,15,34254,2,19557,0,0,0,0,8304903),
--
(8305201,0,1,1,1,0,0,0,0,0,8305201),
--
(8298701,0,0,0,0,2000005554,0,0,0,0,8298701),
(8298702,0,0,0,0,2000005555,0,0,0,0,8298702),
(8298703,0,0,0,0,2000005556,0,0,0,0,8298703),
(8298704,0,0,0,0,2000005557,0,0,0,0,8298704),
--
(8305901,0,0,0,0,2000005558,0,0,0,0,8305901),
(8305902,0,0,0,0,2000005559,0,0,0,0,8305902),
(8305903,0,15,31261,1,0,0,0,0,0,8305903), -- Feign Death
(8305904,0,22,1,0,0,0,0,0,0,8305904), -- Despawn

-- channelers
(8307101,0,15,34221,2,19555,0,0,0,0,8307101), -- Sunseeker Channeler (Botanica) - Crystal Channel TK Atrium Channel Target'),
(8307102,0,15,34200,2,19511,0,0,0,0,8307102), -- Sunseeker Channeler (Botanica) - Crystal Channel Nethervine Inciter'),
(8307103,0,15,34187,2,19511,0,0,0,0,8307103), -- Sunseeker Channeler (Botanica) - Nethervine Inciter Casts Sunseeker Blessing'), -- 60sec
(8307104,0,15,34187,1,0,0,0,0,0,8307104), -- Sunseeker Channeler (Botanica) - NPC Casts Sunseeker Blessing on Self'), -- 60sec
(8307105,0,15,34173,2,19511,1,0,0,0,8307105), -- Sunseeker Channeler (Botanica) - Nethervine Inciter Casts Sunseeker Blessing'), -- 30sec
(8307106,0,15,34222,1,0,0,0,0,0,8307106), -- Sunseeker Channeler (Botanica) - Cast Sunseeker Blessing AOE'),
(8307107,0,15,34200,2,19512,0,0,0,0,8307107); -- Sunseeker Channeler (Botanica) - Crystal Channel 19512');

-- (8307107,0,15,34173,0,0,0,0,0,0,8307107), -- 34156 brauchts vlt garnicht? 60 / 30sec
-- (8307108,0,15,34173,0,0,0,0,0,0,8307108), -- 34156 brauchts vlt garnicht? 60 / 30sec

-- TARGET SCRIPTS FOR CHANNEL SPELL
-- DELETE FROM dbscripts_on_creature_movement WHERE id IN (8307101,8307102);
-- INSERT INTO dbscripts_on_creature_movement VALUES (8307101,0,15,34221,0,19555,15,1,0,0,0,0,0,0,0,0,'Sunseeker Channeler (Botanica) - Crystal Channel TK Atrium Channel Target');
-- INSERT INTO dbscripts_on_creature_movement VALUES (8307102,0,15,34200,0,19511,83073,17,0,0,0,0,0,0,0,0,'Sunseeker Channeler (Botanica) - Crystal Channel Nethervine Inciter');
-- INSERT INTO dbscripts_on_creature_movement VALUES (8307102,7,15,34187,0,19511,83073,23,0,0,0,0,0,0,0,0,'Sunseeker Channeler (Botanica) - Nethervine Inciter Casts Sunseeker Blessing');
-- SPELL SCRIPT TARGET ENTRIES
-- INSERT IGNORE INTO `spell_script_target` (`entry`, `type`, `targetEntry`) values('34221','1','19505');
-- INSERT IGNORE INTO `spell_script_target` (`entry`, `type`, `targetEntry`) values('34221','1','19555');
-- INSERT IGNORE INTO `spell_script_target` (`entry`, `type`, `targetEntry`) values('34200','1','19511');
DELETE FROM `spell_script_target` WHERE targetentry IN (19505,19555,19511,19512);
INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) values('34221','1','19505');
INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) values('34221','1','19555');
INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) values('34156','1','19555');
INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) values('34200','1','19511');
INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) values('34200','1','19512');
INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) values('34222','1','19511');
INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) values('34222','1','19512');

-- TARGET SCRIPTS FOR CHANNEL SPELL (RIGHT NPC)
-- DELETE FROM dbscripts_on_creature_movement WHERE id IN (8298801,8298802);
-- INSERT INTO dbscripts_on_creature_movement VALUES (8298801,0,15,34221,0,19555,15,1,0,0,0,0,0,0,0,0,'Sunseeker Channeler (Botanica) - Crystal Channel TK Atrium Channel Target');
-- INSERT INTO dbscripts_on_creature_movement VALUES (8298802,2,15,34222,0,0,0,0,0,0,0,0,0,0,0,0,'Sunseeker Channeler (Botanica) - Cast Sunseeker Blessing AOE');
-- INSERT INTO dbscripts_on_creature_movement VALUES (8298802,3,15,34173,0,19512,83085,23,0,0,0,0,0,0,0,0,'Sunseeker Channeler (Botanica) - Nethervine Reaper Casts Sunseeker Blessing');
-- INSERT INTO dbscripts_on_creature_movement VALUES (8298802,3,15,34173,0,19512,83084,23,0,0,0,0,0,0,0,0,'Sunseeker Channeler (Botanica) - Nethervine Reaper Casts Sunseeker Blessing');
-- INSERT INTO dbscripts_on_creature_movement VALUES (8298802,3,15,34173,0,19511,83082,23,0,0,0,0,0,0,0,0,'Sunseeker Channeler (Botanica) - Nethervine Inciter Casts Sunseeker Blessing');
-- INSERT INTO dbscripts_on_creature_movement VALUES (8298802,3,15,34173,0,19511,83083,23,0,0,0,0,0,0,0,0,'Sunseeker Channeler (Botanica) - Nethervine Inciter Casts Sunseeker Blessing');

-- TARGET SCRIPTS FOR CHANNEL SPELL (LEFT NPC)
-- DELETE FROM dbscripts_on_creature_movement WHERE id IN (8307701,8307702);
-- INSERT INTO dbscripts_on_creature_movement VALUES (8307701,0,15,34221,0,19555,15,1,0,0,0,0,0,0,0,0,'Sunseeker Channeler (Botanica) - Crystal Channel TK Atrium Channel Target');
-- INSERT INTO dbscripts_on_creature_movement VALUES (8307702,2,15,34222,0,0,0,0,0,0,0,0,0,0,0,0,'Sunseeker Channeler (Botanica) - Cast Sunseeker Blessing AOE');
-- INSERT INTO dbscripts_on_creature_movement VALUES (8307702,3,15,34173,0,19512,83081,23,0,0,0,0,0,0,0,0,'Sunseeker Channeler (Botanica) - Nethervine Reaper Casts Sunseeker Blessing');
-- INSERT INTO dbscripts_on_creature_movement VALUES (8307702,3,15,34173,0,19512,83079,23,0,0,0,0,0,0,0,0,'Sunseeker Channeler (Botanica) - Nethervine Reaper Casts Sunseeker Blessing');
-- INSERT INTO dbscripts_on_creature_movement VALUES (8307702,3,15,34173,0,19511,83078,23,0,0,0,0,0,0,0,0,'Sunseeker Channeler (Botanica) - Nethervine Inciter Casts Sunseeker Blessing');
-- INSERT INTO dbscripts_on_creature_movement VALUES (8307702,3,15,34173,0,19511,83080,23,0,0,0,0,0,0,0,0,'Sunseeker Channeler (Botanica) - Nethervine Inciter Casts Sunseeker Blessing');

-- ===============
-- Spawns
-- ===============

-- freie guids ab 82900: 82902 82912 82929 82936 82951 82954 82959 82963 82968 82969 82970 82971 82972 82973 für SSC  82999,83067,83089 freie

-- ------------------------------
-- Add Missing Bloodwarder Mender
-- ------------------------------

DELETE FROM creature WHERE guid IN (83137);
DELETE FROM creature_addon WHERE guid IN (83137);
INSERT INTO creature VALUES
(83137,19633,553,3,0,0,6.15941,166.406,-5.54122,1.51584,7200,3,0,14199,21093,0,1);

-- ----------------------------------
-- NPC In Front Of Commander Sarannis
-- ----------------------------------
-- Fix Spawns With Sniff Data (Current Ones Badly Placed Better To Fix All Of The With Sniff Data)
DELETE FROM creature WHERE guid IN (83011,83012,83013,83014,83015,83119,83120,83138,83139);
DELETE FROM creature_addon WHERE guid IN (83011,83012,83013,83014,83015,83119,83120,83138,83139);
INSERT INTO `creature` (`guid`, `id`, `modelid`, `map`, `spawnMask`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `MovementType`) VALUES
(83011, 18404, 0, 553, 3, 149.5653, 281.7874, -4.653852, 1.016146, 7200, 0, 0), -- 18404 (Area: 0) (possible waypoints or random movement)
(83012, 17993, 0, 553, 3, 151.6609, 281.7887, -4.334745, 1.612284, 7200, 0, 0), -- 17993 (Area: 0) (possible waypoints or random movement)
(83013, 17993, 0, 553, 3, 153.7568, 281.7442, -4.008605, 2.176939, 7200, 0, 0), -- 17993 (Area: 0) (possible waypoints or random movement)
(83014, 17993, 0, 553, 3, 165.1652, 295.5352, -4.371663, 3.110243, 7200, 0, 0), -- 17993 (Area: 0) (possible waypoints or random movement)
(83015, 18404, 0, 553, 3, 165.1942, 298.2077, -4.774447, 3.852716, 7200, 0, 0), -- 18404 (Area: 0) (possible waypoints or random movement)
(83119, 17993, 0, 553, 3, 164.9687, 292.9525, -4.00805, 2.373266, 7200, 0, 0), -- 17993 (Area: 0) (possible waypoints or random movement)
(83120, 17993, 0, 553, 3, 161.4033, 285.5994, -3.098177, 1.742907, 7200, 0, 0), -- 17993 (Area: 0) (possible waypoints or random movement)
(83138, 18404, 0, 553, 3, 159.1362, 283.813, -3.272108, 1.297487, 7200, 0, 0), -- 18404 (Area: 0) (possible waypoints or random movement)
(83139, 17993, 0, 553, 3, 163.1084, 287.8988, -3.313203, 2.552928, 7200, 0, 0); -- 17993 (Area: 0) (possible waypoints or random movement)

-- ----------------------------------------------------
-- Centre Group of Researchers After Commander Sarannis
-- ----------------------------------------------------
DELETE FROM creature WHERE guid IN (83140);
INSERT INTO `creature` (`guid`, `id`, `modelid`, `map`, `spawnMask`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `MovementType`) VALUES
(83140, 18421, 17843, 553, 3, 175.8427, 387.1663, -5.303061, 2.234021, 7200, 0, 0); -- 18421 (Area: 0) (possible waypoints or random movement)

-- ------------------------------------------
-- NPC At Entry to Thorngrin the Tenders Room
-- ------------------------------------------
DELETE FROM creature WHERE guid IN (83141,83142,83143,83144,83145);
INSERT INTO `creature` (`guid`, `id`, `modelid`, `map`, `spawnMask`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `MovementType`) VALUES
(83141, 19508, 21338, 553, 3, -16.26085, 482.7058, -5.385756, 3.944444, 7200, 0, 0), -- 19508 (Area: 0) (possible waypoints or random movement)
(83142, 19508, 21339, 553, 3, -17.32133, 485.0991, -5.368748, 2.96706, 7200, 0, 0), -- 19508 (Area: 0) (possible waypoints or random movement)
(83143, 19509, 21333, 553, 3, -15.03868, 479.9812, -5.405121, 1.396263, 7200, 0, 0), -- 19509 (Area: 0) (possible waypoints or random movement)
(83144, 19555, 11686, 553, 3, -18.09245, 509.9142, 1.612676, 3.525565, 7200, 0, 0), -- 19555 (Area: 0) -- TK Atrium Channel Target
(83145, 19555, 11686, 553, 3, -1.838774, 510.5453, 0.6243833, 2.583087, 7200, 0, 0); -- 19555 (Area: 0) -- TK Atrium Channel Target
--
-- TK Atrium Channel Target
DELETE FROM `creature` WHERE `guid` IN (83158,83159);
INSERT INTO `creature` VALUES
(83158,19555,553,3,11686,0,20.1475,600.4174,-8.5,0,7200,0,0,1,0,0,0),
(83159,19555,553,3,11686,0,-10.3903,600.2659,-8.5,0,7200,0,0,1,0,0,0);

DELETE FROM creature WHERE guid IN (83045,83047); -- Delete Too Many Frayers 83044 83037
-- 82999,83059,83060,83067 freie
DELETE FROM creature WHERE guid IN (83045,83047);
INSERT INTO creature VALUES (83045,19512,553,3,0,0,-18.8205,518.483,-6.07107,6.05097,7200,0,0,20958,0,0,0);
INSERT INTO creature VALUES (83047,19511,553,3,0,0,-19.6808,514.978,-5.89398,5.61429,7200,0,0,20958,0,0,0);
--
--
DELETE FROM creature WHERE guid=83089;
DELETE FROM creature_addon WHERE guid=83089;
DELETE FROM waypoint_data WHERE id=83089;
DELETE FROM creature WHERE guid IN (83059,83060,83067); -- Delete Too Many Frayers
--
-- -------------------------------------------------------------
-- Add Missing Gene-Splicer Spawns Laying on Floor in Laj's Room
-- -------------------------------------------------------------

DELETE FROM creature WHERE guid IN (98283,98284,98285,98286,98287,98288,98289,98290,98291,98292,98293,98294);
INSERT INTO `creature` (`guid`, `id`, `modelid`, `map`, `spawnMask`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `DeathState`, `MovementType`) VALUES
(98283, 19507, 21337, 553, 3, -157.6343, 411.7007, -17.61243, 1.27409, 7200, 0, 1, 0), -- 19507 (Area: 0)
(98284, 19507, 21335, 553, 3, -177.2168, 408.9644, -17.60689, 2.076942, 7200, 0, 1, 0), -- 19507 (Area: 0)
(98285, 19507, 21336, 553, 3, -150.5405, 400.3017, -17.75786, 2.75762, 7200, 0, 1, 0), -- 19507 (Area: 0)
(98286, 19507, 21335, 553, 3, -172.6049, 403.9249, -17.61106, 4.747295, 7200, 0, 1, 0), -- 19507 (Area: 0)
(98287, 19507, 21335, 553, 3, -173.2738, 390.1292, -17.60731, 3.508112, 7200, 0, 1, 0), -- 19507 (Area: 0)
(98288, 19507, 21336, 553, 3, -177.0949, 378.2484, -17.60809, 5.183628, 7200, 0, 1, 0), -- 19507 (Area: 0)
(98289, 19507, 21336, 553, 3, -172.3201, 380.3159, -17.61069, 0.8901179, 7200, 0, 1, 0), -- 19507 (Area: 0)
(98290, 19507, 21337, 553, 3, -166.8567, 398.4712, -17.6142, 4.223697, 7200, 0, 1, 0), -- 19507 (Area: 0)
(98291, 19507, 21337, 553, 3, -154.356, 386.3756, -17.72159, 4.433136, 7200, 0, 1, 0), -- 19507 (Area: 0)
(98292, 19507, 21337, 553, 3, -179.9221, 401.1072, -17.60423, 0.4886922, 7200, 0, 1, 0), -- 19507 (Area: 0)
(98293, 19507, 21336, 553, 3, -164.2751, 375.6826, -17.61685, 2.75762, 7200, 0, 1, 0), -- 19507 (Area: 0)
(98294, 19507, 21336, 553, 3, -152.4001, 372.6643, -17.60546, 0.3316126, 7200, 0, 1, 0); -- 19507 (Area: 0)
--
DELETE FROM creature_addon WHERE guid IN (98283,98284,98285,98286,98287,98288,98289,98290,98291,98292,98293,98294);
INSERT INTO creature_addon VALUES 
(98283,'0','0','7','1','0','0','0',NULL),
(98284,'0','0','7','1','0','0','0',NULL),
(98285,'0','0','7','1','0','0','0',NULL),
(98286,'0','0','7','1','0','0','0',NULL),
(98287,'0','0','7','1','0','0','0',NULL),
(98288,'0','0','7','1','0','0','0',NULL),
(98289,'0','0','7','1','0','0','0',NULL),
(98290,'0','0','7','1','0','0','0',NULL),
(98291,'0','0','7','1','0','0','0',NULL),
(98292,'0','0','7','1','0','0','0',NULL),
(98293,'0','0','7','1','0','0','0',NULL),
(98294,'0','0','7','1','0','0','0',NULL);
--
DELETE FROM creature WHERE guid IN (83059,83060); 
-- INSERT INTO creature VALUES (83059,17993,553,0,0,0,-155.507,389.66,-17.7781,2.1041,7200,0,0,16208,3080,0,0); -- not spawned atm event doesnt work
-- INSERT INTO creature VALUES (83060,17993,553,0,0,0,-160.717,374.429,-17.6977,2.19363,7200,0,0,16208,3155,0,0); -- not spawned atm event doesnt work

-- ======================================================
-- NPC Research
-- ======================================================

-- Bloodwarder Protector 17993, 21548
UPDATE `creature_template` SET `modelid_A2`='17775',`modelid_H`='17774',`modelid_H2`='17776',`mindmg`='1369',`maxdmg`='1867',`equipment_id`='8002' WHERE `entry` = 17993; -- 398 896
UPDATE `creature_template` SET `speed`='1.48',`armor`='6800',`mindmg`='4284',`maxdmg`='4336',`equipment_id`='8002' WHERE `entry` = 21548; -- 2103 2207 -- 8,568 - 8,672
DELETE FROM `creature_template_addon` WHERE `entry` IN (17993,21548);
INSERT INTO `creature_template_addon` VALUES
(17993,0,0,512,0,4097,0,0,''),
(21548,0,0,512,0,4097,0,0,'');
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 17993;
INSERT INTO `creature_ai_scripts` VALUES
('1799301','17993','14','0','100','7','1000','25','5000','10000','11','34784','6','39','0','0','0','0','0','0','0','0','Bloodwarder Protector - Cast Intervene on friendly missing Intervene Buff'),
('1799302','17993','0','0','100','7','6600','14100','6000','12000','11','29765','1','1','0','0','0','0','0','0','0','0','Bloodwarder Protector - Cast Crystal Strike'),
('1799303','17993','0','0','100','7','5000','12000','12000','15000','11','35399','0','1','0','0','0','0','0','0','0','0','Bloodwarder Protector - Cast Spell Reflection');
-- ('1799304','17993','2','0','100','6','10','0','0','0','11','7','0','0','0','0','0','0','0','0','0','0','Bloodwarder Protector - Cast Suicide at 10% HP'), Only for Event it seems

-- Tempest-Forge Peacekeeper 18405, 21578
-- 5-6k on heroic elemental dmg prenerf
UPDATE `creature_template` SET `armor`='6800',`maxhealth`='23278',`mindmg`='2054',`maxdmg`='2801',`mechanic_immune_mask`='720327677',`dmgschool`='6' WHERE `entry` = 18405; -- 206 206 0
UPDATE `creature_template` SET `armor`='7700',`maxhealth`='71836',`mindmg`='4857',`maxdmg`='5069',`speed`='1.48',`mechanic_immune_mask`='720327677',`dmgschool`='6' WHERE `entry` = 21578; -- 2270 2693 -- 9,714 - 10,137
DELETE FROM `creature_template_addon` WHERE `entry` IN (18405,21578);
INSERT INTO `creature_template_addon` VALUES
(18405,0,0,512,0,4097,0,0,''),
(21578,0,0,512,0,4097,0,0,'');
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 18405;
INSERT INTO `creature_ai_scripts` VALUES
('1840501','18405','1','0','15','7','30000','120000','120000','240000','1','-9899','-9849','0','0','0','0','0','0','0','0','0','Tempest Forge Peacekeeper - Random Say OOC'),
('1840502','18405','0','0','100','7','4000','8000','12100','21200','11','34785','1','0','0','0','0','0','0','0','0','0','Tempest Forge Peacekeeper - Cast Arcane Volley'),
('1840503','18405','0','0','100','7','5000','7100','7200','14500','11','34791','0','0','0','0','0','0','0','0','0','0','Tempest Forge Peacekeeper - Cast Arcane Explosion'),
('1840504','18405','0','0','100','7','7600','16400','15700','25300','11','34793','1','0','0','0','0','0','0','0','0','0','Tempest Forge Peacekeeper - Cast Arcane Blast');

-- Bloodwarder Greenkeeper 18419, 21546
UPDATE `creature_template` SET `maxhealth`='18000',`modelid_H`='17884',`modelid_A2`='0',`modelid_H2`='0',`speed`='1.48',`mindmg`='1369',`maxdmg`='1867' WHERE `entry` = 18419; -- 398 896
UPDATE `creature_template` SET `modelid_A2`='0',`modelid_H2`='0',`speed`='1.48',`mindmg`='3733',`maxdmg`='4053' WHERE `entry` = 21546; -- 1627 2266
DELETE FROM `creature_template_addon` WHERE `entry` IN (18419,21546);
INSERT INTO `creature_template_addon` VALUES
(18419,0,0,16908544,0,4097,0,0,''),
(21546,0,0,16908544,0,4097,0,0,'');
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 18419;
INSERT INTO `creature_ai_scripts` VALUES
('1841901','18419','9','0','100','7','0','5','5000','10000','11','34800','4','0','0','0','0','0','0','0','0','0','Bloodwarder Greenkeeper - Cast Impending Coma'),
('1841902','18419','9','0','100','3','0','40','4000','8000','11','34798','1','0','0','0','0','0','0','0','0','0','Bloodwarder Greenkeeper (Normal) - Cast Greenkeeper\'s Fury'),
('1841903','18419','9','0','100','5','0','40','2000','5000','11','39121','1','0','0','0','0','0','0','0','0','0','Bloodwarder Greenkeeper (Heroic) - Cast Greenkeeper\'s Fury'),
('1841904','18419','0','0','100','3','4000','8000','7200','16000','11','34797','4','0','0','0','0','0','0','0','0','0','Bloodwarder Greenkeeper (Normal) - Cast Nature Shock'),
('1841905','18419','0','0','100','5','2000','5000','7200','10000','11','39120','4','0','0','0','0','0','0','0','0','0','Bloodwarder Greenkeeper (Heroic) - Cast Nature Shock');

-- Bloodwarder Mender 19633, 21547
UPDATE `creature_template` SET `maxhealth`='16000',`modelid_A`='21331',`modelid_A2`='21332',`modelid_H`='21331',`modelid_H2`='21332',`armor`='5450',`speed`='1.48',`mindmg`='1149',`maxdmg`='1605' WHERE `entry` = 19633; -- 323 779 model 19050 19051 zu groß ka was da abgeht
UPDATE `creature_template` SET `modelid_A`='21331',`modelid_A2`='21332',`modelid_H`='21331',`modelid_H2`='21332',`armor`='5450',`speed`='1.48',`mindmg`='3940',`maxdmg`='4063' WHERE `entry` = 21547; -- 1877 2124
DELETE FROM `creature_template_addon` WHERE `entry` IN (19633,21547);
INSERT INTO `creature_template_addon` VALUES
(19633,0,0,16908544,0,4097,0,0,''),
(21547,0,0,16908544,0,4097,0,0,''); 
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 19633;
INSERT INTO `creature_ai_scripts` VALUES
('1963301','19633','1','0','100','7','1000','1000','1800000','1800000','11','34809','0','0','0','0','0','0','0','0','0','0','Bloodwarder Mender - Cast Holy Fury on Spawn'),
('1963302','19633','9','0','100','3','0','30','10000','14000','11','17194','1','0','0','0','0','0','0','0','0','0','Bloodwarder Mender (Normal) - Cast Mind Blast'),
('1963303','19633','9','0','100','5','0','30','10000','14000','11','17287','1','0','0','0','0','0','0','0','0','0','Bloodwarder Mender (Heroic) - Cast Mind Blast'),
('1963304','19633','14','0','100','3','3600','15','10000','15000','11','35096','6','0','0','0','0','0','0','0','0','0','Bloodwarder Mender (Normal) - Cast Greater Heal on Friendlies'),
('1963305','19633','14','0','100','5','5000','15','10000','15000','11','29564','6','0','0','0','0','0','0','0','0','0','Bloodwarder Mender (Heroic) - Cast Greater Heal on Friendlies'),
('1963306','19633','16','0','100','7','34809','15','7000','14000','11','34809','6','0','0','0','0','0','0','0','0','0','Bloodwarder Mender - Cast Holy Fury on Friendlies'),
('1963307','19633','2','0','100','2','50','0','0','0','11','35096','0','1','0','0','0','0','0','0','0','0','Bloodwarder Mender (Normal) - Cast Greater Heal at 50%'),
('1963308','19633','2','0','100','4','50','0','0','0','11','29564','0','1','0','0','0','0','0','0','0','0','Bloodwarder Mender (Heroic) - Cast Greater Heal at 50%');

-- Bloodwarder Falconer 17994, 21545 
UPDATE `creature_template` SET `modelid_A`='17777',`modelid_A2`='17779',`modelid_H`='17777',`modelid_H2`='17779',`speed`='1.48',`mindmg`='1532',`maxdmg`='2019',`equipment_id`='8013' WHERE `entry` = 17994; -- 467 954
UPDATE `creature_template` SET `modelid_A`='17777',`modelid_A2`='17779',`modelid_H`='17777',`modelid_H2`='17779',`armor`='7100',`speed`='1.48',`mindmg`='4056',`maxdmg`='4361',`equipment_id`='8013' WHERE `entry` = 21545; -- 1799 2409
DELETE FROM `creature_equip_template` WHERE `creature_equip_template`.`entry` = 8013;
INSERT INTO `creature_equip_template` (`entry`, `equipmodel1`, `equipmodel2`, `equipmodel3`, `equipinfo1`, `equipinfo2`, `equipinfo3`, `equipslot1`, `equipslot2`, `equipslot3`) VALUES
(8013,19134,0,0,218169346,0,0,3,0,0);
DELETE FROM `creature_template_addon` WHERE `entry` IN (17994,21545);
INSERT INTO `creature_template_addon` VALUES
(17994,0,0,512,0,4097,0,0,''),
(21545,0,0,512,0,4097,0,0,'');
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 17994;
INSERT INTO `creature_ai_scripts` VALUES
('1799401','17994','4','0','100','6','0','0','0','0','1','-1309','0','0','0','0','0','0','0','0','0','0','Bloodwarder Falconer - Say on Aggro'),
('1799402','17994','0','0','100','7','700','6500','10050','11150','11','34852','8','1','1','-1304','0','0','0','0','0','0','Bloodwarder Falconer - Cast Call of the Falcon'),
('1799403','17994','9','0','100','7','0','5','5000','10000','11','32908','4','32','0','0','0','0','0','0','0','0','Bloodwarder Falconer - Cast Wing Clip'),
('1799404','17994','2','0','100','7','85','0','10000','15000','11','31567','0','1','0','0','0','0','0','0','0','0','Bloodwarder Falconer - Cast Deterrence at 75% HP');

-- Bloodfalcon 18155, 21544
UPDATE `creature_template` SET `mindmg`='1070',`maxdmg`='1408',`equipment_id`='0' WHERE `entry` = 18155; -- 327 665
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='3294',`maxdmg`='3653',`equipment_id`='0' WHERE `entry` = 21544; -- 1377 2096
DELETE FROM `creature_template_addon` WHERE `entry` IN (18155,21544);
INSERT INTO `creature_template_addon` VALUES
(18155,0,0,16908544,0,4097,0,0,''),
(21544,0,0,16908544,0,4097,0,0,'');
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 18155;
INSERT INTO `creature_ai_scripts` VALUES
('1815501','18155','9','0','75','7','8','25','10000','15000','11','32323','1','0','0','0','0','0','0','0','0','0','Bloodfalcon - Cast Charge'),
('1815502','18155','0','0','100','7','6200','7900','10800','12500','11','34856','1','0','0','0','0','0','0','0','0','0','Bloodfalcon - Cast Bloodburn'),
('1815503','18155','0','0','100','7','12500','20100','20100','25300','11','18144','1','0','0','0','0','0','0','0','0','0','Bloodfalcon - Cast Swoop');

-- Bloodwarder Steward 18404, 21549
UPDATE `creature_template` SET `modelid_A`='17813',`modelid_A2`='17816',`modelid_H`='17813',`modelid_H2`='17816',`equipment_id`='1550',`speed`='1.48',`mindmg`='1476',`maxdmg`='2013' WHERE `entry` = 18404; -- 429 966
UPDATE `creature_template` SET `modelid_A`='17813',`modelid_A2`='17816',`modelid_H`='17813',`modelid_H2`='17816',`equipment_id`='1550',`speed`='1.48',`mindmg`='4105',`maxdmg`='4390' WHERE `entry` = 21549; -- 1839 2408
UPDATE `creature_model_info` SET `bounding_radius`='2' WHERE `modelid` IN (17815,17816,17817);
UPDATE `creature_model_info` SET `gender`='1' WHERE `modelid` = 17816;
DELETE FROM `creature_template_addon` WHERE `entry` IN (18404,21549);
INSERT INTO `creature_template_addon` VALUES
(18404,0,0,512,0,4097,0,0,''),
(21549,0,0,512,0,4097,0,0,'');
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 18404;
INSERT INTO `creature_ai_scripts` VALUES
('1840401','18404','0','0','100','7','7000','10000','12000','15000','11','34821','0','0','0','0','0','0','0','0','0','0','Bloodwarder Steward - Cast Arcane Flurry');

-- Sunseeker Botanist 18422, 21570
-- Hmm...
-- The Sunseeker Botanist casts Rejuvenate Plant on her Greater Frayer.
-- Yes. That did the trick.
UPDATE `creature_template` SET `modelid_A`='17819',`modelid_A2`='17820',`modelid_H`='17819',`modelid_H2`='17820',`minlevel`='69',`speed`='1.48',`mindmg`='1421',`maxdmg`='1872' WHERE `entry` = 18422; -- 433 884
UPDATE `creature_template` SET `modelid_A`='17819',`modelid_A2`='17820',`modelid_H`='17819',`modelid_H2`='17820',`minlevel`='70',`armor`='5700',`speed`='1.48',`pickpocketloot`='18422',`mindmg`='3487',`maxdmg`='3831' WHERE `entry` = 21570; -- 1486 2174
DELETE FROM `creature_template_addon` WHERE `entry` IN (18422,21570);
INSERT INTO `creature_template_addon` VALUES
(18422,0,0,16908544,0,4097,0,0,''),
(21570,0,0,16908544,0,4097,0,0,''); 
UPDATE `creature_model_info` SET `bounding_radius`='2' WHERE `modelid` = 17820;
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 18422;
INSERT INTO `creature_ai_scripts` VALUES
('1842201','18422','16','0','100','7','34350','15','16900','27700','11','34350','6','0','0','0','0','0','0','0','0','0','Sunseeker Botanist - Cast Nature\'s Rage on Friendlies on Missing Buff'),
('1842202','18422','0','0','100','3','19300','19300','38600','38600','11','34254','0','0','0','0','0','0','0','0','0','0','Sunseeker Botanist (Normal) - Cast Rejuvenate Plant'),
('1842203','18422','0','0','100','5','19300','19300','38600','38600','11','39126','0','0','0','0','0','0','0','0','0','0','Sunseeker Botanist (Heroic) - Cast Rejuvenate Plant'),
('1842204','18422','14','0','100','3','4000','15','13300','21000','11','27637','6','0','0','0','0','0','0','0','0','0','Sunseeker Botanist (Normal) - Cast Regrowth on Friendlies'),
('1842205','18422','14','0','100','5','5600','15','13300','21000','11','39125','6','0','0','0','0','0','0','0','0','0','Sunseeker Botanist (Heroic) - Cast Regrowth on Friendlies'),
('1842206','18422','2','0','100','3','75','0','13300','21000','11','27637','6','0','0','0','0','0','0','0','0','0','Sunseeker Botanist (Normal) - Cast Regrowth at 75% HP'),
('1842207','18422','2','0','100','5','75','0','13300','21000','11','39125','6','0','0','0','0','0','0','0','0','0','Sunseeker Botanist (Heroic) - Cast Regrowth at 75% HP');
UPDATE `spell_script_target` SET `targetEntry`='19557' WHERE `entry` ='34254'; -- 19554

-- Greater Frayer 19557, 21555
UPDATE `creature_template` SET `armor`='5500',`speed`='1.20',`mindmg`='597',`maxdmg`='786',`AIName`='EventAI' WHERE `entry` = 19557; -- 182 371
UPDATE `creature_template` SET `armor`='6100',`speed`='1.20',`mindmg`='2521',`maxdmg`='2853' WHERE `entry` = 21555; -- 1012 1676
DELETE FROM `creature_template_addon` WHERE `entry` IN (19557,21555);
INSERT INTO `creature_template_addon` VALUES
(19557,0,0,512,0,4097,0,0,''),
(21555,0,0,512,0,4097,0,0,'');
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 19557;
INSERT INTO `creature_ai_scripts` VALUES
('1955701','19557','0','0','100','3','2300','8300','5100','12100','11','34644','1','0','0','0','0','0','0','0','0','0','Greater Frayer (Normal) - Cast Lash'),
('1955702','19557','0','0','100','5','2300','8300','5100','12100','11','39122','1','0','0','0','0','0','0','0','0','0','Greater Frayer (Heroic) - Cast Lash');

-- Sunseeker Researcher 18421, 21577
UPDATE `creature_template` SET `modelid_A2`='17844',`modelid_H2`='17845',`speed`='1.48',`mindmg`='1421',`maxdmg`='1872' WHERE `entry` = 18421; -- 433 884
UPDATE `creature_template` SET `modelid_H`='17842',`armor`='5700',`speed`='1.48',`mindmg`='4162',`maxdmg`='4397' WHERE `entry` = 21577; -- 1905 2375
DELETE FROM `creature_template_addon` WHERE `entry` IN (18421,21577);
INSERT INTO `creature_template_addon` VALUES
(18421,0,0,16908544,0,4097,0,0,''),
(21577,0,0,16908544,0,4097,0,0,'');
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 18421;
INSERT INTO `creature_ai_scripts` VALUES
('1842101','18421','0','0','100','7','2000','7200','7200','14000','11','34352','4','32','0','0','0','0','0','0','0','0','Sunseeker Researcher - Cast Mind Shock'),
('1842102','18421','0','0','100','7','5500','8000','12100','14000','11','34354','4','32','0','0','0','0','0','0','0','0','Sunseeker Researcher - Cast Flame Shock'),
('1842103','18421','0','0','100','7','5000','16900','12100','14000','11','34353','4','32','0','0','0','0','0','0','0','0','Sunseeker Researcher - Cast Frost Shock'),
('1842104','18421','0','0','100','7','3000','5000','2000','5000','11','34355','0','33','0','0','0','0','0','0','0','0','Sunseeker Researcher - Cast Poison Shield'),
('1842105','18421','16','0','100','7','34355','1','2000','5000','11','34355','0','1','0','0','0','0','0','0','0','0','Sunseeker Researcher - Cast Poison Shield on Missing Buff');

-- Sunseeker Chemist 19486, 21572
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='1421',`maxdmg`='1872' WHERE `entry` = 19486; -- 433 884
UPDATE `creature_template` SET `modelid_H`='18925',`speed`='1.48',`armor`='5700',`mindmg`='4047',`maxdmg`='4231' WHERE `entry` = 21572; -- 1886 2253
DELETE FROM `creature_template_addon` WHERE `entry` IN (19486,21572);
INSERT INTO `creature_template_addon` VALUES
(19486,0,0,16908544,0,4097,0,0,''),
(21572,0,0,16908544,0,4097,0,0,''); 
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 19486;
INSERT INTO `creature_ai_scripts` VALUES
('1948601','19486','0','0','100','3','4300','10000','18100','25000','11','34358','4','0','0','0','0','0','0','0','0','0','Sunseeker Chemist (Normal) - Cast Vial of Poison'),
('1948602','19486','0','0','100','5','4300','10000','18100','25000','11','39127','4','0','0','0','0','0','0','0','0','0','Sunseeker Chemist (Heroic) - Cast Vial of Poison'),
('1948603','19486','0','0','100','3','5000','9600','10000','14500','11','34359','0','0','0','0','0','0','0','0','0','0','Sunseeker Chemist (Normal) - Cast Fire Breath Potion'),
('1948604','19486','0','0','100','5','5000','9600','10000','14500','11','39128','0','0','0','0','0','0','0','0','0','0','Sunseeker Chemist (Heroic) - Cast Fire Breath Potion');

-- Sunseeker Geomancer 18420, 21574
UPDATE `creature_template` SET `modelid_A`='17916',`modelid_A2`='17918',`modelid_H`='17916',`modelid_H2`='17918',`speed`='1.48',`mindmg`='1446',`maxdmg`='1904',`equipment_id`='8016',`mechanic_immune_mask`='1039089407' WHERE `entry` = 18420; -- 441 899  
UPDATE `creature_template` SET `modelid_A`='17916',`modelid_A2`='17918',`modelid_H`='17916',`modelid_H2`='17918',`speed`='1.48',`mindmg`='4051',`maxdmg`='4308',`equipment_id`='8016',`mechanic_immune_mask`='1039089407' WHERE `entry` = 21574; -- 1833 2347
DELETE FROM `creature_equip_template` WHERE `entry` = 8016;
INSERT INTO `creature_equip_template` (`entry`, `equipmodel1`, `equipmodel2`, `equipmodel3`, `equipinfo1`, `equipinfo2`, `equipinfo3`, `equipslot1`, `equipslot2`, `equipslot3`) VALUES
(8016,40650,0,0,285346306,0,0,2,0,0);
DELETE FROM `creature_template_addon` WHERE `entry` IN (18420,21574);
INSERT INTO `creature_template_addon` VALUES
(18420,0,0,16908544,0,4097,0,0,''),
(21574,0,0,16908544,0,4097,0,0,''); 
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 18420;
INSERT INTO `creature_ai_scripts` VALUES
('1842001','18420','9','0','100','7','0','8','3600','8000','11','35124','0','0','0','0','0','0','0','0','0','0','Sunseeker Geomancer - Cast Arcane Explosion'),
('1842002','18420','1','0','100','7','1000','1000','12000','12000','11','35265','0','33','0','0','0','0','0','0','0','0','Sunseeker Geomancer - Cast Fire Shield on Missing Buff OOC'),
('1842003','18420','0','0','100','7','5000','10000','10000','20000','11','35265','0','33','0','0','0','0','0','0','0','0','Sunseeker Geomancer - Cast Fire Shield on Missing Buff IC');

-- Frayer 18587, 21552
UPDATE `creature_template` SET `speed`='1.20',`mindmg`='423',`maxdmg`='578',`AIName`='EventAI' WHERE `entry` = 18587; -- 123 278
UPDATE `creature_template` SET `speed`='1.20',`mindmg`='1231',`maxdmg`='1632' WHERE `entry` = 21552; -- 315 1116
DELETE FROM `creature_template_addon` WHERE `entry` IN (18587,21552);
INSERT INTO `creature_template_addon` VALUES
(18587,0,0,16908544,0,4097,0,0,'34201 0'),
(21552,0,0,16908544,0,4097,0,0,'34201 0');
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 18587;
INSERT INTO `creature_ai_scripts` VALUES
('1858701','18587','8','0','100','7','34167','-1','1000','1000','11','34202','0','33','0','0','0','0','0','0','0','0','Frayer - Cast Frost Form on Blizzard SpellHit'), -- -1 = 34167
('1858702','18587','8','0','100','7','34169','-1','1000','1000','11','34203','0','33','0','0','0','0','0','0','0','0','Frayer - Cast Fire Form on Rain of Fire SpellHit'), -- 34169
('1858703','18587','8','0','100','7','34170','-1','1000','1000','11','34204','0','33','0','0','0','0','0','0','0','0','Frayer - Cast Arcane Form on Arcane Explosion SpellHit'), -- 34170
('1858704','18587','8','0','100','7','0','32','1000','1000','11','34205','0','33','0','0','0','0','0','0','0','0','Frayer - Cast Shadow Form on Shadow SpellHit'),
--
('1858705','18587','8','0','100','7','0','16','1000','1000','11','34202','0','33','0','0','0','0','0','0','0','0','Frayer - Cast Frost Form on Frost SpellHit'),
('1858706','18587','8','0','100','7','0','4','1000','1000','11','34203','0','33','0','0','0','0','0','0','0','0','Frayer - Cast Fire Form on Fire SpellHit'),
('1858707','18587','8','0','100','7','0','64','1000','1000','11','34204','0','33','0','0','0','0','0','0','0','0','Frayer - Cast Arcane Form on Arcane SpellHit');

-- port to core?
-- shadow nova increase radius to hit all Frayers
-- UPDATE `dbc_spell` SET `EffectRadiusIndex[0]`='8' WHERE `entry` IN ('34256'); -- 8

-- Nethervine Inciter 19511, 21563
UPDATE `creature_template` SET `mindmg`='1532',`maxdmg`='2019',`equipment_id`='8017',`mechanic_immune_mask`='0' WHERE `entry` = 19511; -- 467 954
UPDATE `creature_template` SET `minlevel`='71',`armor`='7100',`speed`='1.71',`mindmg`='3000',`maxdmg`='4000',`equipment_id`='8017',`mechanic_immune_mask`='1' WHERE `entry` = 21563; -- 1749 2499 4194305
DELETE FROM `creature_template_addon` WHERE `entry` IN (19511,21563);
INSERT INTO `creature_template_addon` VALUES
(19511,0,0,512,0,4097,0,0,''),
(21563,0,0,512,0,4097,0,0,'');
DELETE FROM `creature_equip_template` WHERE `entry` = 8017;
INSERT INTO `creature_equip_template` VALUES
(8017,34111,34111,0,218173186,218173186,0,3,3,0);
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 19511;
INSERT INTO `creature_ai_scripts` VALUES
('1951101','19511','0','0','100','7','4300','5600','5000','10000','11','34615','5','7','0','0','0','0','0','0','0','0','Nethervine Inciter - Cast Mind Numbing Poison'),
('1951102','19511','0','0','100','7','3000','4300','10000','15000','11','34616','4','7','0','0','0','0','0','0','0','0','Nethervine Inciter - Cast Deadly Poison'),
('1951103','19511','9','0','100','7','0','5','20000','25000','11','30621','1','0','0','0','0','0','0','0','0','0','Nethervine Inciter - Cast Kidney Shot'),
('1951104','19511','4','0','100','6','0','0','0','0','11','29651','0','0','0','0','0','0','0','0','0','0','Nethervine Inciter - Casts Dual Wield on Aggro'),
('1951105','19511','8','0','100','7','34222','-1','1000','1000','11','34173','0','7','0','0','0','0','0','0','0','0','Nethervine Inciter - Cast Sunseeker Blessing on Sunseeker Blessing Spellhit');

-- Nethervine Reaper 19512, 21564
UPDATE `creature_template` SET `mindmg`='2019',`maxdmg`='2532',`baseattacktime`='2000',`equipment_id`='1564' WHERE `entry` = N 19512; -- 467 954
UPDATE `creature_template` SET `minlevel`='71',`armor`='7100',`speed`='1.71',`mindmg`='4000',`maxdmg`='5000',`mechanic_immune_mask`='1',`equipment_id`='1564' WHERE `entry` = 21564; -- 1896 2177
DELETE FROM `creature_template_addon` WHERE `entry` IN (19512,21564);
INSERT INTO `creature_template_addon` VALUES
(19512,0,0,512,0,4097,0,0,''),
(21564,0,0,512,0,4097,0,0,'');
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 19512;
INSERT INTO `creature_ai_scripts` VALUES
('1951201','19512','0','0','100','7','4300','8100','4300','8100','11','15284','1','0','0','0','0','0','0','0','0','0','Nethervine Reaper - Cast Cleave'),
('1951202','19512','9','0','100','5','0','30','12000','16000','11','34626','4','32','0','0','0','0','0','0','0','0','Nethervine Reaper (Heroic) - Cast Pale Death'),
('1951203','19512','8','0','100','7','34222','-1','1000','1000','11','34173','0','7','0','0','0','0','0','0','0','0','Nethervine Reaper - Cast Sunseeker Blessing on Sunseeker Blessing Spellhit');

-- Nethervine Trickster 19843, 21565
UPDATE `creature_template` SET `mindmg`='1532',`maxdmg`='2019',`equipment_id`='8018' WHERE `entry` = 19843; -- 467 954
UPDATE `creature_template` SET `minlevel`='71',`armor`='7100',`speed`='1.71',`mindmg`='3000',`maxdmg`='4000',`equipment_id`='8018',`mechanic_immune_mask`='1' WHERE `entry` = 21565; -- 1758 2210
DELETE FROM `creature_equip_template` WHERE `entry` = 8018;
INSERT INTO `creature_equip_template` VALUES
(8018,20273,20273,0,218173186 ,218173186 ,0,3,3,0);
DELETE FROM `creature_template_addon` WHERE `entry` IN (19843,21565);
INSERT INTO `creature_template_addon` VALUES
(19843,0,0,512,0,4097,0,0,''),
(21565,0,0,512,0,4097,0,0,'');
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 19843;
INSERT INTO `creature_ai_scripts` VALUES
('1984301','19843','1','0','100','7','1000','1000','0','0','11','30831','0','33','0','0','0','0','0','0','0','0','Nethervine Trickster - Cast Stealth OOC'),
('1984302','19843','9','0','100','7','0','5','4100','9700','11','34614','1','0','0','0','0','0','0','0','0','0','Nethervine Trickster - Cast Backstab'),
('1984303','19843','7','0','100','6','0','0','0','0','11','30831','0','1','0','0','0','0','0','0','0','0','Nethervine Trickster - Cast Stealth on Evade'),
('1984304','19843','4','0','100','6','0','0','0','0','11','29651','0','0','0','0','0','0','0','0','0','0','Nethervine Trickster - Casts Dual Wield on Aggro'),
('1984305','19843','8','0','100','7','34222','-1','1000','1000','11','34173','0','7','0','0','0','0','0','0','0','0','Nethervine Trickster - Cast Sunseeker Blessing on Sunseeker Blessing Spellhit');

-- Sunseeker Channeler 19505, 21571
UPDATE `creature_template` SET `modelid_A`='17819',`modelid_A2`='21340',`modelid_H`='17819',`modelid_H2`='21340',`armor`='5450',`speed`='1.48',`mindmg`='1310',`maxdmg`='1724', WHERE `entry` = 19505; -- 400 814
UPDATE `creature_template` SET `modelid_A`='17819',`modelid_A2`='21340',`modelid_H`='17819',`modelid_H2`='21340',`armor`='5700',`speed`='1.48',`mindmg`='3685',`maxdmg`='3889', WHERE `entry` = 21571; -- 1690 2098
DELETE FROM `creature_template_addon` WHERE `entry` IN ('19505','21571');
INSERT INTO `creature_template_addon` VALUES
(19505,0,0,16908544,0,4097,0,0,''),
(21571,0,0,16908544,0,4097,0,0,''); 
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` IN ('19505');
INSERT INTO `creature_ai_scripts` VALUES
-- (Sunseeker Blessing is Triggered from Channeling OOC) - REVIEW SNIFF DATA
('1950501','19505','9','0','100','7','0','20','10000','15000','11','34637','4','1','0','0','0','0','0','0','0','0','Sunseeker Channeler - Cast Soul Channel'),
('1950502','19505','0','0','100','7','5000','10000','10000','15000','11','34634','0','39','0','0','0','0','0','0','0','0','Sunseeker Channeler - Cast Sunseeker Aura');
-- ('1950503','19505','1','0','100','7','5000','5000','16500','16500','11','34221','0','7','11','34156','0','7','0','0','0','0','Sunseeker Channeler - Cast Crystal Channel OOC'),
-- ('1950504','19505','1','0','100','7','15200','15200','16500','16500','11','34173','0','7','0','0','0','0','0','0','0','0','Sunseeker Channeler - Cast Sunseeker Blessing');

-- TK Atrium Channel Target 19555
UPDATE `creature_template` SET `inhabittype`='5',`unit_flags`='33554688',`flags_extra`='130' WHERE `entry` = 19555;

-- Sunseeker Herbalist 19508, 21576
UPDATE `creature_template` SET `modelid_A`='17819',`modelid_H`='17819',`modelid_A2`='21338',`modelid_H2`='21338' WHERE `entry` = 19508;
UPDATE `creature_template` SET `modelid_A`='17819',`modelid_H`='17819',`modelid_A2`='21338',`modelid_H2`='21338',`armor`='7100',`speed`='1.71',`mindmg`='5520',`maxdmg`='5864',`baseattacktime`='0',`spell1`='0',`spell2`='0' WHERE `entry` = 21576; -- 1877 2393 s1 22127 s2 39129   -- 8,280 - 8,796
UPDATE `creature_model_info` SET `bounding_radius`='2' WHERE `modelid` IN (21338,21339);
DELETE FROM `creature_template_addon` WHERE `entry` IN (19508,21576);
INSERT INTO `creature_template_addon` VALUES
(19508,0,0,16908544,0,4097,0,0,''),
(21576,0,0,16908544,0,4097,0,0,'');
UPDATE `creature_ai_scripts` SET `action1_param1`='1' WHERE `id` IN (1950801,1950808);
DELETE FROM `creature_ai_scripts` WHERE `id` = 1950811;
INSERT INTO `creature_ai_scripts` VALUES
-- (1950811,19508,2,0,100,6,50,0,0,0,12,19598,1,0,12,19598,1,0,0,0,0,0,'Sunseeker Herbalist - Summon 2 Mutate Fleshlasher at 50% HP');
('1950811','19508','0','0','100','7','12100','19400','24800','27700','11','34247','1','1','11','35428','1','1','0','0','0','0','Sunseeker Herbalist - Summon 2 Mutate Fleshlasher'); -- oder 50% hp 

-- Sunseeker Harvester 19509, 21575
UPDATE `creature_template` SET `modelid_A`='17819',`modelid_A2`='21333',`modelid_H`='17819',`modelid_H2`='21333',`speed`='1.48',`mindmg`='1421',`maxdmg`='1872' WHERE `entry` = 19509; -- 433 884
UPDATE `creature_template` SET `modelid_A`='17819',`modelid_A2`='21333',`modelid_H`='17819',`modelid_H2`='21333',`armor`='5700',`speed`='1.48',`mindmg`='3966',`maxdmg`='4208' WHERE `entry` = 21575; -- 1801 2286
DELETE FROM `creature_template_addon` WHERE `entry` IN (19509,21575);
INSERT INTO `creature_template_addon` VALUES
(19509,0,0,16908544,0,4097,0,0,''),
(21575,0,0,16908544,0,4097,0,0,'');
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 19509;
INSERT INTO `creature_ai_scripts` VALUES
('1950901','19509','0','0','100','7','3100','9700','5400','12700','11','34640','4','32','0','0','0','0','0','0','0','0','Sunseeker Harvester - Cast Wilting Touch'),
('1950902','19509','9','0','100','7','0','20','5000','8000','11','34639','5','32','0','0','0','0','0','0','0','0','Sunseeker Harvester - Cast Polymorph'),
('1950903','19509','9','0','100','7','0','30','8000','12000','11','37823','4','32','0','0','0','0','0','0','0','0','Sunseeker Harvester - Cast Entangling Roots'),
('1950904','19509','0','0','100','7','12100','19400','24800','27700','11','34247','1','1','11','35428','1','1','0','0','0','0','Sunseeker Gene-Splicer - Summon 2 Lasher Beast'); -- oder 50% hp 
-- ('1950904','19509','2','0','100','6','50','0','0','0','12','19598','1','300','12','19598','1','300','0','0','0','0','Sunseeker Harvester - Summon 2 Mutate Fleshlasher Adds on 50% HP');

-- Mutate Fleshlasher 19598, 21561
UPDATE `creature_template` SET `maxhealth`='5300',`armor`='5800',`speed`='1.20',`mindmg`='766',`maxdmg`='1010',`AIName`='EventAI',`mechanic_immune_mask`='283313875' WHERE `entry` = 19598; -- 467 954
UPDATE `creature_template` SET `minlevel`='71',`maxlevel`='71',`armor`='6100',`speed`='1.20',`mechanic_immune_mask`='283313875',`mindmg`='1532',`maxdmg`='2019' WHERE `entry` = 21561; -- -66 421
DELETE FROM `creature_template_addon` WHERE `entry` IN (19598,21561);
INSERT INTO `creature_template_addon` VALUES
(19598,0,0,512,0,4097,0,0,'7743 0'),
(21561,0,0,512,0,4097,0,0,'7743 0');
UPDATE `creature_loot_template` SET `maxcount`='2' WHERE `entry` IN (19598,21561) AND `item` IN (32902,32905); -- 3
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 19598;
INSERT INTO `creature_ai_scripts` VALUES
('1959801','19598','0','0','100','7','7800','12100','6200','12100','11','34351','1','0','0','0','0','0','0','0','0','0','Mutate Fleshlasher - Cast Vicious Bite');

-- Mutate Fleshlasher 25354, heroic?
-- spawned by bloodelves
UPDATE `creature_template` SET `heroic_entry`='0',`maxhealth`='5300',`armor`='5800',`faction_A`='14',`faction_H`='14',`speed`='1.20',`mindmg`='766',`maxdmg`='1010',`baseattacktime`='1400',`AIName`='EventAI',`mechanic_immune_mask`='283313875' WHERE `entry` = 25354;
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 25354;
INSERT INTO `creature_ai_scripts` VALUES
('2535401','25354','0','0','100','7','7800','12100','6200','12100','11','34351','1','0','0','0','0','0','0','0','0','0','Mutate Fleshlasher - Cast Vicious Bite'),
('2535402','25354','7','0','100','6','0','0','0','0','41','0','0','0','0','0','0','0','0','0','0','0','Mutate Fleshlasher - Despawn on Evade');

-- Sunseeker Gene-Splicer 19507, 21573
UPDATE `creature_template` SET `modelid_A`='17819',`modelid_A2`='21335',`modelid_H`='17819',`modelid_H2`='21335',`armor`='5450',`speed`='1.48',`mindmg`='1310',`maxdmg`='1724' WHERE `entry` = 19507; -- model 21336 too 400 814
UPDATE `creature_template` SET `modelid_A`='17819',`modelid_A2`='21335',`modelid_H`='17819',`modelid_H2`='21335',`armor`='5700',`speed`='1.48',`mindmg`='4103',`maxdmg`='4323',`pickpocketloot`='19507',`mechanic_immune_mask`='1' WHERE `entry` = 21573; -- 1887 2326
DELETE FROM `creature_template_addon` WHERE `entry` IN (19507,21573);
INSERT INTO `creature_template_addon` VALUES
(19507,0,0,16908544,0,4097,0,0,''),
(21573,0,0,16908544,0,4097,0,0,'');
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 19507;
INSERT INTO `creature_ai_scripts` VALUES
('1950701','19507','9','0','100','3','0','20','15100','20300','11','34642','4','0','0','0','0','0','0','0','0','0','Sunseeker Gene-Splicer (Normal) - Cast Death and Decay'),
('1950702','19507','9','0','100','5','0','20','10100','20300','11','39347','4','0','0','0','0','0','0','0','0','0','Sunseeker Gene-Splicer (Heroic) - Cast Death and Decay'),
('1950703','19507','0','0','100','7','12100','19400','24800','27700','11','34247','1','1','11','35428','1','1','0','0','0','0','Sunseeker Gene-Splicer - Summon 2 Lasher Beast'); -- oder 50% hp 

-- Mutate Horror 19865, 21562
UPDATE `creature_template` SET `minhealth`='19000',`maxhealth`='20000',`armor`='6800',`mindmg`='515',`maxdmg`='1005',`mechanic_immune_mask`='283313875' WHERE `entry` = 19865; -- 206 206
UPDATE `creature_template` SET `minhealth`='28000',`maxhealth`='29000',`minlevel`='71',`armor`='7100',`speed`='1.71',`mindmg`='3777',`maxdmg`='4021' WHERE `entry` = 21562; -- 1706 2194
DELETE FROM `creature_template_addon` WHERE `entry` IN (19865,21562);
INSERT INTO `creature_template_addon` VALUES
(19865,0,0,512,0,4097,0,0,'7743 0'),
(21562,0,0,512,0,4097,0,0,'7743 0');
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 19865;
INSERT INTO `creature_ai_scripts` VALUES
('1986501','19865','9','0','100','7','0','5','10000','15000','11','34643','1','0','0','0','0','0','0','0','0','0','Mutate Horror - Cast Corrode Armor');

-- Mutate Fear-Shrieker 19513, 21560
UPDATE `creature_template` SET `minhealth`='19000',`maxhealth`='20000',`armor`='6800',`mindmg`='515',`maxdmg`='1005',`mechanic_immune_mask`='283313875' WHERE `entry` = 19513; -- 206 206
UPDATE `creature_template` SET `minhealth`='28000',`maxhealth`='29000',`minlevel`='71',`armor`='7100',`speed`='1.71',`mindmg`='3332',`maxdmg`='3707' WHERE `entry` = 21560; -- 1385 2134
DELETE FROM `creature_template_addon` WHERE `entry` IN (19513,21560);
INSERT INTO `creature_template_addon` VALUES
(19513,0,0,512,0,4097,0,0,'7743 0'),
(21560,0,0,512,0,4097,0,0,'7743 0');
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 19513;
INSERT INTO `creature_ai_scripts` VALUES
('1951301','19513','9','0','100','7','0','10','10000','15000','11','12542','5','33','0','0','0','0','0','0','0','0','Mutate Fear-Shrieker - Cast Fear'); -- should be a casted fear that is interruptable

-- Frayer Wildling 19608, 21554
UPDATE `creature_template` SET `speed`='1.20',`mindmg`='460',`maxdmg`='607',`AIName`='EventAI' WHERE `entry` = 19608; -- 140 287
UPDATE `creature_template` SET `armor`='6792',`speed`='1.20',`mindmg`='1264',`maxdmg`='1503' WHERE `entry` = 21554; -- 453 931
DELETE FROM `creature_template_addon` WHERE `entry` IN (19608,21554);
INSERT INTO `creature_template_addon` VALUES
(19608,0,0,512,0,4097,0,0,''),
(21554,0,0,512,0,4097,0,0,'');
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 19608;
INSERT INTO `creature_ai_scripts` VALUES
('1960801','19608','9','0','100','3','0','5','4100','8300','11','34644','1','0','0','0','0','0','0','0','0','0','Frayer Wildling (Normal) - Cast Lash'),
('1960802','19608','9','0','100','5','0','5','4100','6100','11','39122','1','0','0','0','0','0','0','0','0','0','Frayer Wildling (Heroic) - Cast Lash');

-- ====================
-- Bosses
-- ====================

-- Commander Sarannis 17976, 21551
UPDATE `creature_template` SET `minlevel`='72',`maxlevel`='72',`mindmg`='1983',`maxdmg`='2614',`mechanic_immune_mask`='787431423' WHERE `entry` = 17976;
UPDATE `creature_template` SET `speed`='1.71',`mindmg`='5851',`maxdmg`='6354',`pickpocketloot`='17976',`mechanic_immune_mask`='787431423' WHERE `entry` = 21551;
UPDATE `creature_template` SET `equipment_id`='8005' WHERE `entry` IN (17976,21551);
DELETE FROM `creature_equip_template` WHERE `entry` = 8005;
INSERT INTO `creature_equip_template` (`entry`, `equipmodel1`, `equipmodel2`, `equipmodel3`, `equipinfo1`, `equipinfo2`, `equipinfo3`, `equipslot1`, `equipslot2`, `equipslot3`) VALUES
(8005,43978,0,0,33490690,0,0,781,0,0);
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 17976;
INSERT INTO `creature_ai_scripts` VALUES
-- (Adds Summon Spell: 34803 / Casts - 34810 (NPC: 20083 5 Yards Behind) and 34817 / 34818 / 34819 (NPC: 20078 5 Yards Sides and Front)
('1797601','17976','4','0','100','6','0','0','0','0','1','-34','0','0','0','0','0','0','0','0','0','0','Commander Sarannis - Yell on Aggro'),
('1797602','17976','9','0','100','3','0','10','3800','15300','11','34794','1','0','1','-37','0','0','0','0','0','0','Commander Sarannis (Normal) - Cast Arcane Resonance and Yell'),
('1797603','17976','9','0','100','5','0','10','2800','10900','11','34794','1','0','1','-37','0','0','0','0','0','0','Commander Sarannis (Heroic) - Cast Arcane Resonance and Yell'),
('1797604','17976','0','0','100','7','15200','15200','11000','19200','11','34799','1','1','1','-38','0','0','0','0','0','0','Commander Sarannis - Cast Arcane Devastation on 3 Arcane Resonance Stack and Yell'),
('1797605','17976','2','0','100','2','55','0','0','0','1','-9848','0','0','12','20078','4','1800000','12','19633','4','1800000','Commander Sarannis (Normal) - Emote and Summon Bloodwarder Reservist and Bloodwarder Mender at 55% HP'),
('1797606','17976','2','0','100','2','55','0','0','0','12','20078','4','1800000','12','20078','4','1800000','1','-39','0','0','Commander Sarannis (Normal) - Summon 2 Bloodwarder Reservists and Yell at 55% HP'),
('1797607','17976','2','0','100','2','60','0','0','0','11','34803','0','0','0','0','0','0','0','0','0','0','Commander Sarannis (Normal) - Cast Dummy Spell on 60% HP'),
('1797608','17976','0','0','100','5','30000','30000','60000','60000','1','-9848','0','0','12','20078','4','1800000','12','19633','4','1800000','Commander Sarannis (Heroic) - Emote and Summon Bloodwarder Reservist and Bloodwarder Mender'),
('1797609','17976','0','0','100','5','30000','30000','60000','60000','12','20078','4','1800000','12','20078','4','1800000','1','-39','0','0','Commander Sarannis (Heroic) - Summon 2 Bloodwarder Reservists and Yell'),
('1797610','17976','0','0','100','5','28000','28000','60000','60000','11','34803','0','0','0','0','0','0','0','0','0','0','Commander Sarannis (Heroic) - Cast Dummy Spell befor Summon'),
('1797611','17976','5','0','100','7','0','0','0','0','1','-21','-35','0','0','0','0','0','0','0','0','0','Commander Sarannis - Yell on Player Kill'),
('1797612','17976','6','0','100','6','0','0','0','0','1','-36','0','0','0','0','0','0','0','0','0','0','Commander Sarannis - Yell on Death');

-- 20078 19633 spawned npcs
-- Summoned Bloodwarder Mender same as Bloodwarder Mender
-- Summoned Bloodwarder Reservist 20078, 21569
UPDATE `creature_template` SET `equipment_id`='8014',`modelid_A`='17816',`modelid_A2`='17774',`modelid_H`='17816',`modelid_H2`='17774',`armor`='5500',`speed`='1.20',`mindmg`='507',`maxdmg`='761',`AIName`='EventAI' WHERE `entry` = 20078;
UPDATE `creature_template` SET `equipment_id`='8014',`modelid_A`='17816',`modelid_A2`='17774',`modelid_H`='17816',`modelid_H2`='17774',`armor`='5800',`speed`='1.20',`mindmg`='3294',`maxdmg`='3594' WHERE `entry` = 21569;
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 20078;
INSERT INTO `creature_ai_scripts` VALUES
('2007801','20078','0','0','100','7','12400','16400','8100','16200','11','34820','1','0','0','0','0','0','0','0','0','0','Summoned Bloodwarder Reservist - Cast Arcane Strike');
DELETE FROM `creature_onkill_reputation` WHERE `creature_id` = 20078;
DELETE FROM `creature_equip_template` WHERE `entry` = 8014;
INSERT INTO `creature_equip_template` (`entry`, `equipmodel1`, `equipmodel2`, `equipmodel3`, `equipinfo1`, `equipinfo2`, `equipinfo3`, `equipslot1`, `equipslot2`, `equipslot3`) VALUES
(8014,48061 ,0,0,33490690,0,0,781,0,0);

-- ===

-- High Botanist Freywinn 17975,21558
UPDATE `creature_template` SET `mindmg`='1840',`maxdmg`='2424',`mechanic_immune_mask`='787431423' WHERE `entry` = 17975;  --
UPDATE `creature_template` SET `maxlevel`='72',`speed`='1.71',`mindmg`='5474',`maxdmg`='5934',`pickpocketloot`='17975',`mechanic_immune_mask`='787431423' WHERE `entry` = 21558;
DELETE FROM `creature_template_addon` WHERE `entry` IN (17975,21558);
INSERT INTO `creature_template_addon` VALUES
(17975,0,0,16908544,0,4097,0,0,''),
(21558,0,0,16908544,0,4097,0,0,''); 

-- ===

-- Thorngrin the Tender 17978,21581
UPDATE `creature_template` SET `minlevel`='72',`maxlevel`='72',`mindmg`='2604',`maxdmg`='3429',`mechanic_immune_mask`='787431423',`flags_extra`='536870912' WHERE `entry` = 17978;  -- 
UPDATE `creature_template` SET `maxlevel`='72',`armor`='7400',`speed`='1.71',`mindmg`='5562',`maxdmg`='5963',`pickpocketloot`='17978',`mechanic_immune_mask`='787431423',`flags_extra`='536870913' WHERE `entry` = 21581; -- 

-- Frayer Protector 19953,21553
UPDATE `creature_template` SET `speed`='1.20',`mindmg`='986',`maxdmg`='1300'  WHERE `entry` = 19953; --  300 614
UPDATE `creature_template` SET `speed`='1.20',`mindmg`='2649',`maxdmg`='3033',`baseattacktime`='0'  WHERE `entry` = 21553; -- 778 1353 -- 3974 - 4549
DELETE FROM `creature_template_addon` WHERE `entry` IN (19953,21553); 
INSERT INTO `creature_template_addon` VALUES
(19953,0,0,512,0,4097,0,0,''),
(21553,0,0,512,0,4097,0,0,'');
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 19953;
INSERT INTO `creature_ai_scripts` VALUES
('1995301','19953','1','0','100','6','0','0','0','0','21','1','0','0','20','0','0','0','23','1','0','0','Frayer Protector - Prevent Combat Movement and Prevent Melee and Set Phase 1 on Spawn'),
('1995302','19953','9','5','100','7','5','30','2000','3000','11','34745','4','0','40','2','0','0','0','0','0','0','Frayer Protector - Cast Shoot Thorns and Set Ranged Weapon Model (Phase 1)'),
('1995303','19953','9','5','100','7','30','80','1000','1000','21','1','1','0','20','1','0','0','0','0','0','0','Frayer Protector - Start Combat Movement and Start Melee at 30 Yards (Phase 1)'),
('1995304','19953','9','5','100','7','0','5','1000','1000','21','1','0','0','40','1','0','0','20','1','0','0','Frayer Protector - Start Combat Movement and Set Melee Weapon Model and Start Melee at 5 Yards (Phase 1)'),
('1995305','19953','9','5','100','7','6','25','1000','1000','21','1','1','0','20','0','0','0','0','0','0','0','Frayer Protector - Prevent Combat Movement and Prevent Melee at 25 Yards (Phase 1)'),
('1995306','19953','7','0','100','6','0','0','0','0','41','0','0','0','0','0','0','0','0','0','0','0','Frayer Protector - Despawn on Evade');

-- White Seedling 19958,21583
UPDATE `creature_template` SET `minhealth`='981',`armor`='5800',`speed`='1.20',`mindmg`='500',`maxdmg`='506' WHERE `entry` = 19958; -- 198 204
UPDATE `creature_template` SET `armor`='5800',`mindmg`='1108',`maxdmg`='1393',`baseattacktime`='0' WHERE `entry` = 21583; -- 255 683 -- 1,662 - 2,090
DELETE FROM `creature_template_addon` WHERE `entry` IN (19958,21583); 
INSERT INTO `creature_template_addon` VALUES
(19958,0,0,512,0,4097,0,0,'7940 0'),
(21583,0,0,512,0,4097,0,0,'7940 0');
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 19958;
INSERT INTO `creature_ai_scripts` VALUES
('1995801','19958','9','0','100','7','0','5','500','500','11','34752','1','32','13','-50','1','0','0','0','0','0','White Seedling - Cast Freezing Touch'),
('1995802','19958','7','0','100','6','0','0','0','0','41','0','0','0','0','0','0','0','0','0','0','0','White Seedling - Despawn on Evade');

-- Red Seedling 19964, 21566
UPDATE `creature_template` SET `minhealth`='1014',`maxhealth`='1415',`armor`='5800',`speed`='1.20',`mindmg`='500',`maxdmg`='506' WHERE `entry` = 19964; -- 198 204
UPDATE `creature_template` SET `armor`='5800',`mindmg`='1108',`maxdmg`='1393',`baseattacktime`='0' WHERE `entry` = 21566; -- 255 683
DELETE FROM `creature_template_addon` WHERE `entry` IN (19964,21566); 
INSERT INTO `creature_template_addon` VALUES
(19964,0,0,512,0,4097,0,0,'7942 0'),
(21566,0,0,512,0,4097,0,0,'7942 0');
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 19964;
INSERT INTO `creature_ai_scripts` VALUES
('1996401','19964','9','0','100','7','0','20','2000','4000','11','36339','1','0','0','0','0','0','0','0','0','0','Red Seedling - Cast Fire Blast'),
('1996402','19964','7','0','100','6','0','0','0','0','41','0','0','0','0','0','0','0','0','0','0','0','Red Seedling - Despawn on Evade');

-- Green Seedling 19969, 21557
UPDATE `creature_template` SET `minhealth`='1014',`maxhealth`='1415',`armor`='5800',`speed`='1.20',`mindmg`='500',`maxdmg`='506' WHERE `entry` = 19969; -- 198 204
UPDATE `creature_template` SET `armor`='5800',`mindmg`='1108',`maxdmg`='1393',`baseattacktime`='0' WHERE `entry` = 21557; -- 255 683
DELETE FROM `creature_template_addon` WHERE `entry` IN (19969,21557); 
INSERT INTO `creature_template_addon` VALUES
(19969,0,0,512,0,4097,0,0,'7941 0'),
(21557,0,0,512,0,4097,0,0,'7941 0');
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 19969;
INSERT INTO `creature_ai_scripts` VALUES
('1996901','19969','11','0','100','6','0','0','0','0','11','34757','0','7','0','0','0','0','0','0','0','0','Green Seedling - Cast Toxic Pollen on Spawn'),
('1996902','19969','7','0','100','6','0','0','0','0','41','0','0','0','0','0','0','0','0','0','0','0','Green Seedling - Despawn on Evade');

-- Blue Seedling 19962,21550
UPDATE `creature_template` SET `minhealth`='981',`maxhealth`='1415',`armor`='5800',`speed`='1.20',`mindmg`='500',`maxdmg`='506' WHERE `entry` = 19962; -- 198 204
UPDATE `creature_template` SET `armor`='5800',`mindmg`='1108',`maxdmg`='1393',`baseattacktime`='0' WHERE `entry` = 21550; -- 255 683
DELETE FROM `creature_template_addon` WHERE `entry` IN (19962,21550); 
INSERT INTO `creature_template_addon` VALUES
(19962,0,0,512,0,4097,0,0,'34184 0'),
(21550,0,0,512,0,4097,0,0,'34184 0');
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 19962;
INSERT INTO `creature_ai_scripts` VALUES
('1996201','19962','9','0','100','7','0','10','500','500','11','34782','1','0','13','-50','1','0','0','0','0','0','Blue Seedling - Cast Bind Feet'),
('1996202','19962','7','0','100','6','0','0','0','0','41','0','0','0','0','0','0','0','0','0','0','0','Blue Seedling - Despawn on Evade');

-- ===

-- Laj 17980,21559
UPDATE `creature_template` SET `mindmg`='2552',`maxdmg`='3364',`mechanic_immune_mask`='787431423',`flags_extra`='536870912' WHERE `entry` = 17980;  --
UPDATE `creature_template` SET `maxlevel`='72',`speed`='1.71',`mindmg`='5758',`maxdmg`='6221',`mechanic_immune_mask`='787431423',`flags_extra`='536870913' WHERE `entry` = 21559;

-- ===

-- Warp Splinter 17977,21582
UPDATE `creature_template` SET `armor`='7400',`mindmg`='1578',`maxdmg`='1945',`mechanic_immune_mask`='787431423',`flags_extra`='536870913' WHERE `entry` = 17977;  --
UPDATE `creature_template` SET `minlevel`='72',`maxlevel`='72',`armor`='7400',`speed`='1.48',`mindmg`='6607',`maxdmg`='7199',`skinloot`='80002',`mechanic_immune_mask`='787431423',`flags_extra`='536870913' WHERE `entry` = 21582;
UPDATE `creature_onkill_reputation` SET `MaxStanding1`='7' WHERE `creature_id` IN (17977,21582);

-- Sapling 19949, 21567
UPDATE `creature_template` SET `minlevel`='72',`maxlevel`='72',`faction_A`='14',`faction_H`='14',`speed`='1.20' WHERE `entry` = 19949;
UPDATE `creature_template` SET `armor`='6792' WHERE `entry` = 21567;

-- ===========================
-- Visuals & Movement & Positioning
-- ===========================

-- ------------------------
-- Fix Warp Splinter's Room
-- ------------------------

UPDATE creature SET Spawndist=3, MovementType=1 WHERE id = 19608;

UPDATE `creature` SET `id`='19512' WHERE `guid` = 83082;
UPDATE `creature` SET `id`='19511' WHERE `guid` = 83085;

-- --------------------------
-- Fix Nethervine Trickster's
-- --------------------------
UPDATE creature SET Spawndist=5, MovementType=1 WHERE guid IN (83087,83088);
DELETE FROM waypoint_data WHERE id = 83087;
UPDATE creature SET position_x = '-88.661102', position_y = '547.243958', position_z = '-17.805691', orientation = '0.557306' WHERE guid = '83088';
-- ---------------------
-- Fix Gene-Splicer Room
-- ---------------------
UPDATE creature SET Spawndist=3, MovementType=1 WHERE guid IN (83092,83090,83099,83098,83101,83100);
UPDATE creature SET position_x = '-150.864899', position_y = '525.923035', position_z = '-17.823814', orientation = '3.511526' WHERE guid = '83097';
UPDATE creature SET position_x = '-154.763702', position_y = '529.822021', position_z = '-17.823814', orientation = '4.188539' WHERE guid = '83095';
UPDATE creature SET position_x = '-163.409683', position_y = '504.117920', position_z = '-17.823814', orientation = '4.029104' WHERE guid = '83102';
UPDATE creature SET position_x = '-129.737488', position_y = '504.990234', position_z = '-17.823814', orientation = '3.721230' WHERE guid = '83091';
UPDATE creature SET position_x = '-157.169098', position_y = '471.524658', position_z = '-17.824739', orientation = '1.367393' WHERE guid = '83106';
UPDATE creature SET position_x = '-165.245972', position_y = '472.490967', position_z = '-17.824739', orientation = '1.426298' WHERE guid = '83105';

DELETE FROM creature_addon WHERE guid IN (83095,83097,83096,83091,83093,83094,83104,83103,83102,83141,83142);
INSERT INTO creature_addon (`guid`, `mount`, `bytes1`, `bytes0`, `bytes2`, `emote`, `moveflags`, `auras`) VALUES ('83095','0','0','0','0','69','0',NULL);
INSERT INTO creature_addon (`guid`, `mount`, `bytes1`, `bytes0`, `bytes2`, `emote`, `moveflags`, `auras`) VALUES ('83097','0','0','0','0','69','0',NULL);
INSERT INTO creature_addon (`guid`, `mount`, `bytes1`, `bytes0`, `bytes2`, `emote`, `moveflags`, `auras`) VALUES ('83096','0','0','0','0','69','0',NULL);
INSERT INTO creature_addon (`guid`, `mount`, `bytes1`, `bytes0`, `bytes2`, `emote`, `moveflags`, `auras`) VALUES ('83091','0','0','0','0','69','0',NULL);
INSERT INTO creature_addon (`guid`, `mount`, `bytes1`, `bytes0`, `bytes2`, `emote`, `moveflags`, `auras`) VALUES ('83093','0','0','0','0','69','0',NULL);
INSERT INTO creature_addon (`guid`, `mount`, `bytes1`, `bytes0`, `bytes2`, `emote`, `moveflags`, `auras`) VALUES ('83094','0','0','0','0','69','0',NULL);
INSERT INTO creature_addon (`guid`, `mount`, `bytes1`, `bytes0`, `bytes2`, `emote`, `moveflags`, `auras`) VALUES ('83104','0','0','0','0','69','0',NULL);
INSERT INTO creature_addon (`guid`, `mount`, `bytes1`, `bytes0`, `bytes2`, `emote`, `moveflags`, `auras`) VALUES ('83103','0','0','0','0','69','0',NULL);
INSERT INTO creature_addon (`guid`, `mount`, `bytes1`, `bytes0`, `bytes2`, `emote`, `moveflags`, `auras`) VALUES ('83102','0','0','0','0','69','0',NULL);
INSERT INTO `creature_addon` VALUES
(83141,0,0,16908544,0,4097,69,0,''),
(83142,0,0,16908544,0,4097,69,0,'');
--
-- Move NPC to Correct Locations
UPDATE creature SET position_x = '0.743981', position_y = '504.740265', position_z = '-5.319865', orientation = '2.016919' WHERE guid = '83070';
UPDATE creature SET position_x = '-17.591831', position_y = '505.420837', position_z = '-5.307605', orientation = '2.085249' WHERE guid = '83075';
UPDATE creature SET position_x = '1.367998', position_y = '493.800598', position_z = '-5.412396', orientation = '2.885726' WHERE guid = '83073';
--
-- -----------------------
-- Second Group of Frayers
-- -----------------------
UPDATE creature SET Spawndist=3, MovementType=1 WHERE guid IN (83065,83063,83064,83069,83062,82061,83058,83057,83068,83066);
UPDATE creature SET position_x = '106.104866', position_y = '497.827667', position_z = '-6.854609', orientation = '3.172230' WHERE guid = '83057';
-- --------------------------------------
-- NPC in Front of High Botanist Freywinn
-- --------------------------------------
DELETE FROM creature_addon WHERE guid IN (83052,83053,83055,83051,83049);
INSERT INTO creature_addon (`guid`, `mount`, `bytes1`, `bytes0`, `bytes2`, `emote`, `moveflags`, `auras`) VALUES ('83052','0','0','1','0','0','0',NULL);
INSERT INTO creature_addon (`guid`, `mount`, `bytes1`, `bytes0`, `bytes2`, `emote`, `moveflags`, `auras`) VALUES ('83053','0','0','1','0','0','0',NULL);
INSERT INTO creature_addon (`guid`, `mount`, `bytes1`, `bytes0`, `bytes2`, `emote`, `moveflags`, `auras`) VALUES ('83055','0','0','1','0','0','0',NULL);
INSERT INTO creature_addon (`guid`, `mount`, `bytes1`, `bytes0`, `bytes2`, `emote`, `moveflags`, `auras`) VALUES ('83051','0','0','1','0','69','0',NULL);
INSERT INTO creature_addon (`guid`, `mount`, `bytes1`, `bytes0`, `bytes2`, `emote`, `moveflags`, `auras`) VALUES ('83049','0','0','1','0','0','0',NULL);
--
-- ----------------------
-- First Group of Frayers
-- ----------------------
UPDATE creature SET Spawndist=3, MovementType=1 WHERE guid IN (83043,83044,83046,83042,83040,83039,83041,83036,83037,83038);
UPDATE creature SET position_x = '162.939285', position_y = '433.364624', position_z = '-6.835905', orientation = '1.929722' WHERE guid = '83040';
--
-- --------------------------------------------------
-- Left Group of Researchers After Commander Sarannis
-- --------------------------------------------------
UPDATE creature SET position_x = '159.302002', position_y = '367.640228', position_z = '-5.411332', orientation = '3.524878' WHERE guid = '83018';
DELETE FROM creature_addon WHERE guid IN (83016,83017,83019);
INSERT INTO creature_addon (`guid`, `mount`, `bytes1`, `bytes0`, `bytes2`, `emote`, `moveflags`, `auras`) VALUES ('83016','0','0','0','0','69','0',NULL);
INSERT INTO creature_addon (`guid`, `mount`, `bytes1`, `bytes0`, `bytes2`, `emote`, `moveflags`, `auras`) VALUES ('83019','0','0','0','0','69','0',NULL);
INSERT INTO creature_addon (`guid`, `mount`, `bytes1`, `bytes0`, `bytes2`, `emote`, `moveflags`, `auras`) VALUES ('83017','0','8','0','0','0','0',NULL);
-- ---------------------------------------------------
-- Right Group of Researchers After Commander Sarannis
-- ---------------------------------------------------
DELETE FROM creature_addon WHERE guid IN (83032,83033,83034,83030);
INSERT INTO creature_addon (`guid`, `mount`, `bytes1`, `bytes0`, `bytes2`, `emote`, `moveflags`, `auras`) VALUES ('83032','0','0','1','0','0','0',NULL);
INSERT INTO creature_addon (`guid`, `mount`, `bytes1`, `bytes0`, `bytes2`, `emote`, `moveflags`, `auras`) VALUES ('83033','0','0','1','0','0','0',NULL);
INSERT INTO creature_addon (`guid`, `mount`, `bytes1`, `bytes0`, `bytes2`, `emote`, `moveflags`, `auras`) VALUES ('83034','0','0','1','0','69','0',NULL);
INSERT INTO creature_addon (`guid`, `mount`, `bytes1`, `bytes0`, `bytes2`, `emote`, `moveflags`, `auras`) VALUES ('83030','0','8','0','0','0','0',NULL);
DELETE FROM creature_addon WHERE guid IN (83029,83020,83140);
INSERT INTO creature_addon (`guid`, `mount`, `bytes1`, `bytes0`, `bytes2`, `emote`, `moveflags`, `auras`) VALUES ('83029','0','0','1','0','0','0',NULL);
INSERT INTO creature_addon (`guid`, `mount`, `bytes1`, `bytes0`, `bytes2`, `emote`, `moveflags`, `auras`) VALUES ('83140','0','0','1','0','0','0',NULL);
INSERT INTO creature_addon (`guid`, `mount`, `bytes1`, `bytes0`, `bytes2`, `emote`, `moveflags`, `auras`) VALUES ('83020','0','0','1','0','69','0',NULL);
-- ------------------------------------------------------
-- Far Left Group of Researchers After Commander Sarannis
-- ------------------------------------------------------
UPDATE creature SET position_x = '164.376556', position_y = '408.294800', position_z = '-5.386406', orientation = '2.155144' WHERE guid = '83025';
DELETE FROM creature_addon WHERE guid IN (83028,83048,83021,83024);
INSERT INTO creature_addon (`guid`, `mount`, `bytes1`, `bytes0`, `bytes2`, `emote`, `moveflags`, `auras`) VALUES ('83028','0','0','1','0','0','0',NULL);
INSERT INTO creature_addon (`guid`, `mount`, `bytes1`, `bytes0`, `bytes2`, `emote`, `moveflags`, `auras`) VALUES ('83048','0','0','0','0','69','0',NULL);
INSERT INTO creature_addon (`guid`, `mount`, `bytes1`, `bytes0`, `bytes2`, `emote`, `moveflags`, `auras`) VALUES ('83021','0','0','1','0','69','0',NULL);
INSERT INTO creature_addon (`guid`, `mount`, `bytes1`, `bytes0`, `bytes2`, `emote`, `moveflags`, `auras`) VALUES ('83024','0','8','0','0','0','0',NULL);
--
--
-- 1st boss trash
DELETE FROM `creature_addon` WHERE `guid` IN (83011,83012,83013,83014,83015,83119,83120,83138,83139);
INSERT INTO `creature_addon` VALUES
(83011,0,0,512,0,4097,26,0,''),
(83012,0,0,512,0,4097,26,0,''),
(83013,0,0,512,0,4097,26,0,''),
(83014,0,0,512,0,4097,26,0,''),
(83015,0,0,512,0,4097,26,0,''),
(83119,0,0,512,0,4097,26,0,''),
(83120,0,0,512,0,4097,26,0,''),
(83138,0,0,512,0,4097,26,0,''),
(83139,0,0,512,0,4097,26,0,'');
--
-- -------------------------------------
-- Bloodwarder Falconer and Bloodfalcons
-- -------------------------------------
-- Random Movement for Falconer and BloodFalcons
UPDATE creature SET Spawndist=10, MovementType=1 WHERE guid IN (83008,83009,83010);
UPDATE creature SET Spawndist=3, MovementType=1 WHERE guid = 83007;

UPDATE `creature_model_info` SET `bounding_radius`='2' WHERE `modelid` IN ('17777','17778','17780');
UPDATE `creature_model_info` SET `gender`='0' WHERE `modelid` = 17780;
-- --------------------
-- Bloodwarder Falconer
-- --------------------
-- Random Movement for Remaining BloodFalcons
UPDATE creature SET Spawndist=10, MovementType=1 WHERE guid IN (82996,82997,82998);
-- ------------------------
-- 2 Bloodwarder Protectors
-- ------------------------
DELETE FROM creature_addon WHERE guid IN (83001,83002);
INSERT INTO creature_addon (`guid`, `mount`, `bytes1`, `bytes0`, `bytes2`, `emote`, `moveflags`, `auras`) VALUES ('83001','0','0','4097','0','333','0',NULL);
INSERT INTO creature_addon (`guid`, `mount`, `bytes1`, `bytes0`, `bytes2`, `emote`, `moveflags`, `auras`) VALUES ('83002','0','0','4097','0','333','0',NULL);
-- ------------------------
-- 2 Bloodwarder Protectors
-- ------------------------
DELETE FROM creature_addon WHERE guid IN (83004,83005);
INSERT INTO creature_addon (`guid`, `mount`, `bytes1`, `bytes0`, `bytes2`, `emote`, `moveflags`, `auras`) VALUES ('83004','0','0','4097','0','333','0',NULL);
INSERT INTO creature_addon (`guid`, `mount`, `bytes1`, `bytes0`, `bytes2`, `emote`, `moveflags`, `auras`) VALUES ('83005','0','0','4097','0','333','0',NULL);
--
UPDATE `creature` SET `position_x`='-0.7006', `position_y`='255.0998', `position_z`='-5.4898', `orientation`='1.5881',`spawndist`='0',`movementtype`='0' WHERE `guid` = 83000;
UPDATE `creature_model_info` SET `bounding_radius`='2' WHERE `modelid` IN ('21331','21332');
--
-- ----------------------------------------
-- 2 Green Keepers and One Mender in Middle
-- ----------------------------------------
-- Addon Data
DELETE FROM creature_addon WHERE guid IN (83000,82994,82993);
INSERT INTO creature_addon (`guid`, `mount`, `bytes1`, `bytes0`, `bytes2`, `emote`, `moveflags`, `auras`) VALUES ('82994','0','0','0','0','0','0',NULL);
INSERT INTO creature_addon (`guid`, `mount`, `bytes1`, `bytes0`, `bytes2`, `emote`, `moveflags`, `auras`) VALUES ('82993','0','0','0','0','0','0',NULL);
INSERT INTO creature_addon (`guid`, `mount`, `bytes1`, `bytes0`, `bytes2`, `emote`, `moveflags`, `auras`) VALUES ('83000','0','8','0','0','0','0',NULL);
--
-- ------------------------
-- 2 Bloodwarder Protectors
-- ------------------------
UPDATE creature SET position_x = '-14.725861', position_y = '244.255112', position_z = '-5.214353', orientation = '6.011446' WHERE guid = '82985';
UPDATE creature SET position_x = '12.536785', position_y = '244.131027', position_z = '-5.276653', orientation = '3.282975' WHERE guid = '82991';
DELETE FROM creature_addon WHERE guid IN (82985,82991);
INSERT INTO creature_addon (`guid`, `mount`, `bytes1`, `bytes0`, `bytes2`, `emote`, `moveflags`, `auras`) VALUES ('82985','0','0','1','0','0','0',NULL);
INSERT INTO creature_addon (`guid`, `mount`, `bytes1`, `bytes0`, `bytes2`, `emote`, `moveflags`, `auras`) VALUES ('82991','0','0','1','0','0','0',NULL);
--
DELETE FROM creature_addon WHERE guid IN (82981,82982);
INSERT INTO creature_addon (`guid`, `mount`, `bytes1`, `bytes0`, `bytes2`, `emote`, `moveflags`, `auras`) VALUES ('82981','0','0','0','0','0','0',NULL);
INSERT INTO creature_addon (`guid`, `mount`, `bytes1`, `bytes0`, `bytes2`, `emote`, `moveflags`, `auras`) VALUES ('82982','0','8','0','0','0','0',NULL);
DELETE FROM creature_addon WHERE guid IN (82977,82978);
INSERT INTO creature_addon (`guid`, `mount`, `bytes1`, `bytes0`, `bytes2`, `emote`, `moveflags`, `auras`) VALUES ('82977','0','0','0','0','0','0',NULL);
INSERT INTO creature_addon (`guid`, `mount`, `bytes1`, `bytes0`, `bytes2`, `emote`, `moveflags`, `auras`) VALUES ('82978','0','8','0','0','0','0',NULL);
--
-- ---------------------------------
-- 4 Bloodwarder Protectors At Front
-- ---------------------------------
DELETE FROM creature_addon WHERE guid IN (83152,83151,83154,83155);
INSERT INTO creature_addon (`guid`, `mount`, `bytes1`, `bytes0`, `bytes2`, `emote`, `moveflags`, `auras`) VALUES ('83151','0','0','1','0','333','0',NULL);
INSERT INTO creature_addon (`guid`, `mount`, `bytes1`, `bytes0`, `bytes2`, `emote`, `moveflags`, `auras`) VALUES ('83152','0','0','1','0','333','0',NULL);
INSERT INTO creature_addon (`guid`, `mount`, `bytes1`, `bytes0`, `bytes2`, `emote`, `moveflags`, `auras`) VALUES ('83154','0','0','1','0','333','0',NULL);
INSERT INTO creature_addon (`guid`, `mount`, `bytes1`, `bytes0`, `bytes2`, `emote`, `moveflags`, `auras`) VALUES ('83155','0','0','1','0','333','0',NULL);

UPDATE creature SET position_x = '0.319128', position_y = '93.350929', position_z = '-5.652020', orientation = '4.749768' WHERE guid = '83151';
UPDATE creature SET position_x = '-2.910640', position_y = '93.303818', position_z = '-5.652020', orientation = '4.661018' WHERE guid = '83152';
-- ------------------------
-- 2 Bloodwarder Protectors
-- ------------------------
UPDATE creature SET position_x = '-10.472994', position_y = '160.509964', position_z = '-5.540343', orientation = '4.944090' WHERE guid = '83156';
UPDATE creature SET position_x = '9.051096', position_y = '160.359482', position_z = '-5.540343', orientation = '4.428083' WHERE guid = '82984';
DELETE FROM creature_addon WHERE guid IN (83156,82984);
INSERT INTO creature_addon (`guid`, `mount`, `bytes1`, `bytes0`, `bytes2`, `emote`, `moveflags`, `auras`) VALUES ('83156','0','0','1','0','333','0',NULL);
INSERT INTO creature_addon (`guid`, `mount`, `bytes1`, `bytes0`, `bytes2`, `emote`, `moveflags`, `auras`) VALUES ('82984','0','0','1','0','333','0',NULL);
--
-- -----------------------
-- Bloodwarder Greenkeeper
-- -----------------------
DELETE FROM creature_addon WHERE guid = 83150;
INSERT INTO creature_addon (`guid`, `mount`, `bytes1`, `bytes0`, `bytes2`, `emote`, `moveflags`, `auras`) VALUES ('83150','0','0','0','0','69','0',NULL);

-- ===============
-- Movement
-- ===============

UPDATE creature SET Spawndist=0, MovementType=2 WHERE guid = 83059;
SET @NPC := 83059;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@NPC,@PATH,0,0,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-- (@PATH,1,'XXX','YYY','ZZZ',0,0,0,100,0),
(@PATH,1,'-155.507','389.66','-17.7781','16000',0,0,100,0),
(@PATH,2,'-155.507','389.66','-17.7781',0,0,0,100,0),
(@PATH,3,'-161.64','398.266','-17.734',0,0,0,100,0),
(@PATH,4,'-157.994','405.455','-17.6956',0,0,8305902,100,0),
(@PATH,5,'-164.289','411.495','-17.7221',0,0,0,100,0),
(@PATH,6,'-169.0393','407.6524','-17.69853','60000',0,8305901,100,0),
(@PATH,7,'-169.0393','407.6524','-17.69853','1000',0,8305903,100,0),
(@PATH,8,'-169.0393','407.6524','-17.69853','1000',0,8305904,100,0);

UPDATE creature SET Spawndist=0, MovementType=2 WHERE guid IN (83060);
SET @NPC := 83060;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@NPC,@PATH,0,0,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-- (@PATH,1,'XXX','YYY','ZZZ',0,0,0,100,0),
(@PATH,1,'-160.717','374.429','-17.6977','16000',0,0,100,0),
(@PATH,2,'-160.717','374.429','-17.6977',0,0,0,100,0),
(@PATH,3,'-167.591','389.41','-17.6984',0,0,0,100,0),
(@PATH,4,'-170.008','400.085','-17.696',0,0,0,100,0),
(@PATH,5,'-161.8523','407.7832','-17.69849',0,0,0,100,0),
(@PATH,6,'-163.7475','428.2452','-17.78011','60000',0,8305901,100,0),
(@PATH,7,'-163.7475','428.2452','-17.78011','1000',0,8305903,100,0),
(@PATH,8,'-163.7475','428.2452','-17.78011','1000',0,8305904,100,0);
--
-- -----------------------------------------------------
-- Sunseeker Channelers In Front of Thorngrin the Tender
-- -----------------------------------------------------
-- Right Sunseeker Channeler Pathing
UPDATE creature SET Spawndist=0, MovementType=2 WHERE guid IN (82988);
SET @NPC := 82988;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@NPC,@PATH,0,0,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-- (@PATH,1,'XXX','YYY','ZZZ',0,0,0,100,0),
(@PATH,1,'21.6491','588.464','-17.7652','21337',0,8307101,100,0), -- Channeling 
(@PATH,2,'21.6491','588.464','-17.7652','2000',0,8307104,100,0), -- Cast Sunseeker Blessing 
(@PATH,3,'19.3148','583.8','-17.8192',0,0,0,100,0),
(@PATH,4,'18.6946','574.077','-17.9568','2000',0,8307106,100,0), -- Cast In Middle of Group (2 Sec Delay)
(@PATH,5,'19.3882','583.435','-17.8253',0,0,0,100,0),
(@PATH,6,'21.6491','588.464','-17.7652','5000',0,0,100,0); -- Wait at Channeling Position

-- Left Sunseeker Channeler Pathing
UPDATE creature SET Spawndist=0, MovementType=2 WHERE guid IN (83077);
SET @NPC := 83077;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@NPC,@PATH,0,0,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-- (@PATH,1,'XXX','YYY','ZZZ',0,0,0,100,0),
(@PATH,1,'-11.5331','590.832','-17.7077','21337',0,8307101,100,0), -- Channeling
(@PATH,2,'-11.5331','590.832','-17.7077','2000',0,8307104,100,0), -- Cast Sunseeker Blessing
(@PATH,3,'-3.60459','580.712','-17.8252',0,0,0,100,0),
(@PATH,4,'-5.46937','575.998','-17.8898','2000',0,8307106,100,0), -- Cast In Middle of Group (2 Sec Delay)
(@PATH,5,'-3.59916','581.005','-17.8215',0,0,0,100,0),
(@PATH,6,'-11.5331','590.832','-17.7077','5000',0,0,100,0);  -- Wait at Channeling Position
--
-- -----------------------------------------------------------
-- Nethervine Inciter Pathing in Front of Thorngrin the Tender
-- -----------------------------------------------------------
UPDATE creature SET Spawndist=0, MovementType=2 WHERE guid IN (83086);
SET @NPC := 83086;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@NPC,@PATH,0,0,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-- (@PATH,1,'XXX','YYY','ZZZ',0,0,0,100,0),
(@PATH,1,'-23.5901','562.602','-18.0989',0,0,0,100,0),
(@PATH,2,'-30.229','570.418','-17.9359',0,0,0,100,0),
(@PATH,3,'-23.8211','563.044','-18.0996',0,0,0,100,0),
(@PATH,4,'-16.2925','559.634','-18.1095',0,0,0,100,0),
(@PATH,5,'31.0858','559.317','-18.1989',0,0,0,100,0),
(@PATH,6,'40.6974','562.026','-17.609',0,0,0,100,0),
(@PATH,7,'31.3911','559.043','-18.2044',0,0,0,100,0),
(@PATH,8,'-15.7247','559.729','-18.1073',0,0,0,100,0);

-- ----------------------------------------------------------------------------------
-- Nethervine Inciter and Nethervine Reaper Pathing Around Thorngrin the Tenders Room
-- ----------------------------------------------------------------------------------
UPDATE creature SET Spawndist=0, MovementType=2 WHERE guid IN (83045);
SET @NPC := 83045;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@NPC,@PATH,0,0,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-- (@PATH,1,'XXX','YYY','ZZZ',0,0,0,100,0),
(@PATH,'1','-11.1495','518.438','-5.74976',0,0,0,100,0),
(@PATH,'2','-4.07179','518.313','-5.74221',0,0,0,100,0),
(@PATH,'3','6.70262','522.214','-8.08245',0,0,0,100,0),
(@PATH,'4','17.3582','529.537','-12.428',0,0,0,100,0),
(@PATH,'5','20.4706','535.661','-15.3494',0,0,0,100,0),
(@PATH,'6','20.9221','543.053','-18.4064',0,0,0,100,0),
(@PATH,'7','16.8279','549.014','-18.3111',0,0,0,100,0),
(@PATH,'8','9.84162','550.811','-18.2149',0,0,0,100,0),
(@PATH,'9','-8.74968','551.02','-18.2178',0,0,0,100,0),
(@PATH,'10','-26.358','551.434','-18.2145',0,0,0,100,0),
(@PATH,'11','-36.5401','550.107','-18.263',0,0,0,100,0),
(@PATH,'12','-42.5133','546.936','-18.3103',0,0,0,100,0),
(@PATH,'13','-43.7557','542.668','-18.4038',0,0,0,100,0),
(@PATH,'14','-39.4576','531.936','-14.0649',0,0,0,100,0),
(@PATH,'15','-35.2496','526.307','-10.4672',0,0,0,100,0),
(@PATH,'16','-29.7596','522.783','-8.69191',0,0,0,100,0),
(@PATH,'17','-23.0708','519.459','-6.90383',0,0,0,100,0),
(@PATH,'18','-18.2628','518.513','-5.97764',0,0,0,100,0);
--
-- Sunseeker Channeler that buffs a PAT
UPDATE creature SET Spawndist=0, MovementType=2 WHERE guid IN (83071);
SET @NPC := 83071;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@NPC,@PATH,0,0,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-- (@PATH,1,'XXX','YYY','ZZZ',0,0,0,100,0), 8307101
(@PATH,1,'-7.07519','507.14','-5.29541','10000',0,8307101,100,0), -- Channeling
(@PATH,2,'-7.07519','507.14','-5.29541','2000',0,8307104,100,0), -- Stop Channel by selfcasting 34173
(@PATH,3,'-7.07519','507.14','-5.29541','10000',0,8307102,100,0), -- Channel Nethervine Inciter
(@PATH,4,'-7.07519','507.14','-5.29541','2000',0,8307106,100,0), -- Buff Nethervine Inciter
(@PATH,5,'-7.07519','507.14','-5.29541','9000',0,1011,100,0), -- Emote 11
(@PATH,6,'-7.07519','507.14','-5.29541','0',0,1000,100,0);
--
-- Sunseeker Channeler
UPDATE creature SET Spawndist=0, MovementType=2 WHERE guid IN (83070);
SET @NPC := 83070;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@NPC,@PATH,0,0,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-- (@PATH,1,'XXX','YYY','ZZZ',0,0,0,100,0),
(@PATH,1,'0.743981','504.74','-5.31987','20000',0,8307101,100,0), -- Channeling
(@PATH,2,'0.743981','504.74','-5.31987','25000',0,8307106,100,0); -- Stop Channel by selfcasting 34173
-- (@PATH,3,'0.743981','504.74','-5.31987','1000',0,1011,100,0); -- Emote 11

-- Sunseeker Channeler
UPDATE creature SET Spawndist=0, MovementType=2 WHERE guid IN (83075);
SET @NPC := 83075;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@NPC,@PATH,0,0,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-- (@PATH,1,'XXX','YYY','ZZZ',0,0,0,100,0),
(@PATH,1,'-17.5918','505.421','-5.3076','20000',0,8307101,100,0), -- Channeling
(@PATH,2,'-17.5918','505.421','-5.3076','25000',0,8307106,100,0); -- Stop Channel by selfcasting 34173
-- (@PATH,3,'-17.5918','505.421','-5.3076','1000',0,1011,100,0); -- Emote 11
-- Sunseeker Channeler
UPDATE creature SET Spawndist=0, MovementType=2 WHERE guid IN (83074);
SET @NPC := 83074;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@NPC,@PATH,0,0,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-- (@PATH,1,'XXX','YYY','ZZZ',0,0,0,100,0),
(@PATH,1,'-24.473','507.265','-5.30362','20000',0,8307101,100,0), -- Channeling
(@PATH,2,'-24.473','507.265','-5.30362','25000',0,8307106,100,0); -- Stop Channel by selfcasting 34173
-- (@PATH,3,'-24.473','507.265','-5.30362','1000',0,1011,100,0); -- Emote 11

-- Outside Pathing Nethervine Inciter
UPDATE creature SET Spawndist=0, MovementType=2 WHERE guid IN (83072);
SET @GUID := 83072;
DELETE FROM `creature_addon` WHERE `guid`=@GUID;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@GUID,@GUID,0,0,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id`=@GUID;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-- (@PATH,1,'XXX','YYY','ZZZ',0,0,0,100,0),
(@GUID,1,'-14.2594','491.108','-5.40935',0,0,0,100,0),
(@GUID,2,'-8.55427','483.309','-5.47117',0,0,0,100,0),
(@GUID,3,'2.78195','481.305','-5.58427',0,0,0,100,0),
(@GUID,4, -8.53638, 482.843, -5.4743, 0,0,0,100,0),
(@GUID,5,'-15.5274','491.044','-5.41147',0,0,0,100,0),
(@GUID,6,'-17.9647','501.451','-5.33586',0,0,0,100,0);

-- Inside Pathing Nethervine Inciter
UPDATE creature SET Spawndist=0, MovementType=2 WHERE guid IN (83073);
SET @NPC := 83073;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@NPC,@PATH,0,0,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-- (@PATH,1,'XXX','YYY','ZZZ',0,0,0,100,0),
(@PATH,1,'-4.02644','494.172','-5.3942',0,0,0,100,0),
(@PATH,2,'-9.07605','497.28','-5.36563',0,0,0,100,0),
(@PATH,3,'-13.1972','502.904','-5.32566',0,0,0,100,0),
(@PATH,4,'-11.7771','511.38','-5.33284',12000,0,0,100,0),
(@PATH,5,'-12.8163','503.922','-5.31762',0,0,0,100,0), -- cast trigger spell 34200 
(@PATH,6,'-8.46771','497.311','-5.36527',0,0,0,100,0),
(@PATH,7,'-3.33881','493.658','-5.39807',0,0,0,100,0),
(@PATH,8,'6.10934','493.845','-5.4377',0,0,0,100,0),
(@PATH,9,'15.9986','496.659','-5.46175',0,0,0,100,0),
(@PATH,10,'6.36544','494.456','-5.43269',0,0,0,100,0);
--
-- Sunseeker Geomancer Pathing
UPDATE creature SET Spawndist=0, MovementType=2 WHERE guid IN (83056);
SET @NPC := 83056;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@NPC,@PATH,0,0,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-- (@PATH,1,'XXX','YYY','ZZZ',0,0,0,100,0),
(@PATH,1,'88.4563','495.092','-5.38647','3000',0,0,100,0),
(@PATH,2,'97.2095','493.595','-6.78375',0,0,0,100,0),
(@PATH,3,'102.952','491.174','-6.76313','8000',0,8303502,100,0), -- Cast Frost 
(@PATH,4,'102.952','491.174','-6.76313','8000',0,8303503,100,0), -- Cast Fire
(@PATH,5,'102.952','491.174','-6.76313','2000',0,8303504,100,0), -- cast arcane
(@PATH,6,'102.952','491.174','-6.76313','2000',0,8303504,100,0), -- cast arcane
(@PATH,7,'102.952','491.174','-6.76313','4000',0,8303504,100,0), -- cast arcane
(@PATH,8,'102.952','491.174','-6.76313','6000',0,8303501,100,0), -- say
(@PATH,9,'102.952','491.174','-6.76313','2000',0,0,100,0), -- cast shadow 8303505  when shadow spell found
(@PATH,10,'97.2095','493.595','-6.78375',0,0,0,100,0),
(@PATH,11,'87.5729','495.1206','-5.3864','0',0,0,100,0);
--
-- ----------------------
-- High Botanist Freywinn
-- ----------------------
UPDATE creature SET Spawndist=0, MovementType=2 WHERE guid IN (82987);
SET @NPC := 82987;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@NPC,@PATH,0,16908544,0,4097,69,0,'');
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-- (@PATH,1,'XXX','YYY','ZZZ',0,0,0,100,0),
(@PATH,1,'116.584','455.602','-4.95288',0,0,0,100,0),
(@PATH,2,'115.153','455.568','-4.89346','10000',0,1069,100,0), -- 69
(@PATH,3,'115.153','455.568','-4.89346','0',0,1000,100,0),
(@PATH,4,'115.153','455.568','-4.89346','1666',0,8298701,100,0),
(@PATH,5,'115.153','455.568','-4.89346','1667',0,8298702,100,0),
(@PATH,6,'115.153','455.568','-4.89346','1667',0,8298703,100,0),
(@PATH,7,'115.153','455.568','-4.89346','1667',0,8298704,100,0),
(@PATH,8,'115.153','455.568','-4.89346','1667',0,8298702,100,0),
(@PATH,9,'115.153','455.568','-4.89346','1666',0,1069,100,0),
(@PATH,10,'116.623','455.478','-4.94902',0,0,1000,100,0),
(@PATH,11,'120.628','451.036','-4.92864',0,0,0,100,0),
(@PATH,12,'120.543','449.982','-4.88372','10000',0,1069,100,0),
(@PATH,13,'120.543','449.982','-4.88372','0',0,1000,100,0),
(@PATH,14,'120.543','449.982','-4.88372','1666',0,8298701,100,0),
(@PATH,15,'120.543','449.982','-4.88372','1667',0,8298702,100,0),
(@PATH,16,'120.543','449.982','-4.88372','1667',0,8298703,100,0),
(@PATH,17,'120.543','449.982','-4.88372','1667',0,8298704,100,0),
(@PATH,18,'120.543','449.982','-4.88372','1667',0,8298702,100,0),
(@PATH,19,'120.543','449.982','-4.88372','1666',0,1069,100,0),
(@PATH,20,'120.796','450.93','-4.93171',0,0,1000,100,0);
--
-- Right Sunseeker Botanist
UPDATE creature SET Spawndist=0, MovementType=2 WHERE guid IN (83049);
SET @NPC := 83049;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@NPC,@PATH,0,0,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-- (@PATH,1,'XXX','YYY','ZZZ',0,0,0,100,0),
(@PATH,1,'174.814','495.449','-2.62112','4000',0,8304901,100,0),
(@PATH,2,'174.814','495.449','-2.62112','6000',0,8304903,100,0), -- cast 34254
(@PATH,3,'174.814','495.449','-2.62112','55000',0,8304902,100,0);
--
-- Left Sunseeker Botanist
UPDATE creature SET Spawndist=0, MovementType=2 WHERE guid IN (83055);
SET @NPC := 83055;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@NPC,@PATH,0,0,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-- (@PATH,1,'XXX','YYY','ZZZ',0,0,0,100,0),
(@PATH,1,'159.537','508.659','-2.74336','25000',0,0,100,0), -- Spacer
(@PATH,2,'159.537','508.659','-2.74336','4000',0,8304901,100,0), -- Say 
(@PATH,3,'159.537','508.659','-2.74336','6000',0,8304903,100,0), -- Cast Spell
(@PATH,4,'159.537','508.659','-2.74336','55000',0,8304902,100,0); -- Say
--
-- Sunseeker Researcher Pathing
UPDATE creature SET Spawndist=0, MovementType=2 WHERE guid IN (83052);
SET @NPC := 83052;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@NPC,@PATH,0,0,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-- (@PATH,1,'XXX','YYY','ZZZ',0,0,0,100,0),
(@PATH,1,'164.783','501.235','-2.07282','25000',0,0,100,0),
(@PATH,2,'158.254','492.187','-4.47891',0,0,0,100,0),
(@PATH,3,'136.829','470.648','-1.59932',0,0,0,100,0),
(@PATH,4,'121.211','455.423','-4.88299','5000',0,8305201,100,0), -- emote 1 
(@PATH,5,'121.211','455.423','-4.88299','10000',0,8305201,100,0), -- emote 1
(@PATH,6,'134.158','467.606','-1.69619',0,0,0,100,0),
(@PATH,7,'158.166','491.949','-4.52846',0,0,0,100,0);
--
-- Sunseeker Geomancer Pathing
UPDATE creature SET Spawndist=0, MovementType=2 WHERE guid IN (83035);
SET @NPC := 83035;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@NPC,@PATH,0,0,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-- (@PATH,1,'XXX','YYY','ZZZ',0,0,0,100,0),
(@PATH,1,'162.3120','452.8745','-5.4149',3000,0,0,100,0),
(@PATH,2,'162.23','452.538','-5.41697',0,0,0,100,0),
(@PATH,3,'163.493','446.524','-6.9092',0,0,0,100,0),
(@PATH,4,'163.268','441.86','-6.86923',0,0,0,100,0),
(@PATH,5,'162.006','437.507','-6.83356',0,0,0,100,0),
(@PATH,6,'156.922','435.956','-6.77183','8000',0,8303502,100,0), -- Cast Frost 34167
(@PATH,7,'156.922','435.956','-6.77183','8000',0,8303503,100,0), -- Cast Fire 34169
(@PATH,8,'156.922','435.956','-6.77183','2000',0,8303504,100,0), -- Cast Arcane 34170
(@PATH,9,'156.922','435.956','-6.77183','2000',0,8303504,100,0),  -- Cast Arcane 34170
(@PATH,10,'156.922','435.956','-6.77183','4000',0,8303504,100,0), -- Cast Arcane 34170
(@PATH,11,'156.922','435.956','-6.77183','6000',0,8303501,100,0), -- say 8303501
(@PATH,12,'156.922','435.956','-6.77183','2000',0,0,100,0), -- Cast 8303505 Shadow 
(@PATH,13,'161.566','437.091','-6.82662',0,0,0,100,0),
(@PATH,14,'163.727','441.472','-6.87038',0,0,0,100,0),
(@PATH,15,'163.606','446.25','-6.90634',0,0,0,100,0),
(@PATH,16,'161.4920','454.2147','-5.4148','0',0,0,100,0);
--
-- ---------------------
-- Left Pathing Botanist
-- ---------------------
UPDATE creature SET Spawndist=0, MovementType=2 WHERE guid IN (83022);
SET @NPC := 83022;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@NPC,@PATH,0,0,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-- (@PATH,1,'XXX','YYY','ZZZ',0,0,0,100,0),
(@PATH,1,'153.194','402.43','-5.3864','21000',0,0,100,0),
(@PATH,2,'152.247','399.99','-5.3864',0,0,0,100,0),
(@PATH,3,'153.166','393.779','-5.3864',0,0,0,100,0),
(@PATH,4,'157.038','387.449','-5.3864',0,0,0,100,0),
(@PATH,5,'160.205','378.829','-5.3864',0,0,0,100,0),
(@PATH,6,'159.918','377.573','-5.3864','26000',0,0,100,0),
(@PATH,7,'162.102','381.613','-5.3864',0,0,0,100,0),
(@PATH,8,'161.551','390.539','-5.3864',0,0,0,100,0),
(@PATH,9,'155.869','395.531','-5.3864',0,0,0,100,0),
(@PATH,10,'151.97','399.905','-5.3864',0,0,0,100,0);

-- ----------------------
-- Right Pathing Botanist
-- ----------------------
UPDATE creature SET Spawndist=0, MovementType=2,orientation = '2.16378' WHERE guid IN (83027);
SET @NPC := 83027;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@NPC,@PATH,0,0,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-- (@PATH,1,'XXX','YYY','ZZZ',0,0,0,100,0),

(@PATH,1,'159.904','402.942','-5.3864','26000',0,0,100,0),
(@PATH,2,'161.38','401.344','-5.3864',0,0,0,100,0),
(@PATH,3,'168.674','402.822','-5.3864',0,0,0,100,0),
(@PATH,4,'177.992','404.019','-5.3864',0,0,0,100,0),
(@PATH,5,'182.163','403.591','-5.3864',0,0,0,100,0),
(@PATH,6,'182.889','396.989','-5.3864',0,0,0,100,0),
(@PATH,7,'181.288','388.73','-5.3864',0,0,0,100,0),
(@PATH,8,'188.878','381.951','-5.43289',0,0,0,100,0),
(@PATH,9,'191.392','382.601','-5.44611',0,0,0,100,0),
(@PATH,10,'192.458','383.717','-5.44123','31000',0,0,100,0),
(@PATH,11,'189.689','381.902','-5.43911',0,0,0,100,0),
(@PATH,12,'182.847','387.644','-5.38726',0,0,0,100,0),
(@PATH,13,'182.062','400.955','-5.38726',0,0,0,100,0),
(@PATH,14,'178.353','404.378','-5.38726',0,0,0,100,0),
(@PATH,15,'166.276','401.489','-5.38726',0,0,0,100,0),
(@PATH,16,'161.438','401.543','-5.38726',0,0,0,100,0);
--
-- ------------------
-- Commander Sarannis
-- ------------------
UPDATE creature SET Spawndist=0, MovementType=2 WHERE guid IN (82986);
SET @NPC := 82986;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@NPC,@PATH,0,512,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-- -- (@PATH,1,'XXX','YYY','ZZZ',0,0,0,100,0),
(@PATH,1,'152.491','294.444','-4.6658',0,0,0,100,0), -- Front of Bridge With NPC
(@PATH,2,'120.012','327.677','-4.99033',0,0,0,100,0), -- Back Of Bridge
(@PATH,3,'152.491','294.444','-4.6658',0,0,0,100,0), -- Front of Bridge With NPC
(@PATH,4,'120.012','327.677','-4.99033',0,0,0,100,0), -- Back Of Bridge
(@PATH,5,'152.491','294.444','-4.6658',0,0,0,100,0), -- Front of Bridge With NPC
(@PATH,6,'151.954','283.758','-4.67356','3000',0,8315101,100,0), -- Front of Left NPC and Salute
(@PATH,7,'151.954','283.758','-4.67356','6000',0,8299401,100,0),-- Front of Left NPC and Talk
(@PATH,8,'152.491','294.444','-4.6658',0,0,0,100,0), -- Front of Bridge With NPC
(@PATH,9,'162.800','295.447','-4.80194','3000',0,8315101,100,0), -- Front of Right NPC and Salute
(@PATH,10,'162.800','295.447','-4.80194','6000',0,8299401,100,0), -- Front of Right NPC and Talk
(@PATH,11,'152.491','294.444','-4.6658',0,0,0,100,0), -- Front of Bridge With NPC (Facing To Back)
(@PATH,12,'120.012','327.677','-4.99033',0,0,0,100,0), -- Back Of Bridge
(@PATH,13,'152.491','294.444','-4.6658',0,0,0,100,0), -- Front of Bridge With NPC
(@PATH,14,'120.012','327.677','-4.99033',0,0,0,100,0), -- Back Of Bridge
(@PATH,15,'152.491','294.444','-4.6658',0,0,0,100,0), -- Front of Bridge With NPC
(@PATH,16,'159.540','287.615','-4.10529','3000',0,8315101,100,0), -- Front of Center NPC and Salute
(@PATH,17,'159.540','287.615','-4.10529','6000',0,8299401,100,0), -- Front of Center NPC and Talk
(@PATH,18,'152.491','294.444','-4.6658',0,0,0,100,0), -- Front of Bridge With NPC
(@PATH,19,'151.954','283.758','-4.67356','3000',0,8315101,100,0), -- Front of Left NPC and Salute
(@PATH,20,'151.954','283.758','-4.67356','6000',0,8299401,100,0), -- Front of Left NPC and Talk
(@PATH,21,'152.491','294.444','-4.6658',0,0,0,100,0), -- Front of Bridge With NPC (Facing To Back)
(@PATH,22,'120.012','327.677','-4.99033',0,0,0,100,0), -- Back Of Bridge
(@PATH,23,'152.491','294.444','-4.6658',0,0,0,100,0), -- Front of Bridge With NPC
(@PATH,24,'120.012','327.677','-4.99033',0,0,0,100,0), -- Back Of Bridge
(@PATH,25,'152.491','294.444','-4.6658',0,0,0,100,0), -- Front of Bridge With NPC
(@PATH,26,'162.800','295.447','-4.80194','3000',0,8315101,100,0), -- Front of Right NPC and Salute
(@PATH,27,'162.800','295.447','-4.80194','6000',0,8299401,100,0), -- Front of Right NPC and Talk
(@PATH,28,'152.491','294.444','-4.6658',0,0,0,100,0), -- Front of Bridge With NPC
(@PATH,29,'159.540','287.615','-4.10529','3000',0,8315101,100,0), -- Front of Center NPC and Salute
(@PATH,30,'159.540','287.615','-4.10529','6000',0,8299401,100,0), -- Front of Center NPC and Talk
(@PATH,31,'152.491','294.444','-4.6658',0,0,0,100,0), -- Front of Bridge With NPC (Facing To Back)
(@PATH,32,'120.012','327.677','-4.99033',0,0,0,100,0), -- Back Of Bridge
(@PATH,33,'152.491','294.444','-4.6658',0,0,0,100,0), -- Front of Bridge With NPC
(@PATH,34,'159.540','287.615','-4.10529','0',0,8298601,100,0); -- Front of Center NPC and Yell and Cheer Emote 4
--
-- -----------------------------------
-- Bloodwarder Steward Pathing in Hall
-- -----------------------------------
UPDATE `creature` SET `spawndist`='0',`movementtype`='2' WHERE `guid` IN ('83006');
SET @NPC := 83006;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@NPC,@PATH,0,0,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-- (@PATH,1,'XXX','YYY','ZZZ',0,0,0,100,0),
(@PATH,1,'50.9215','293.818','-5.63032',0,0,0,100,0),
(@PATH,2,'50.4144','282.994','-5.64831',0,0,0,100,0);
--
-- Left Green Keeper
UPDATE `creature` SET `spawndist`='0',`movementtype`='2' WHERE `guid` IN ('82994');
SET @NPC := 82994;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@NPC,@PATH,0,0,0,4097,69,0,'');
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-- (@PATH,1,'XXX','YYY','ZZZ',0,0,0,100,0),
(@PATH,1,'-3.0730','254.8057','-5.4790','22200',0,0,100,0),
(@PATH,2,'-1.3867','253.2512','-5.4943','7000',0,8299401,100,0),
(@PATH,3,'-3.0730','254.8057','-5.4790','30200',0,0,100,0),
(@PATH,4,'-1.3867','253.2512','-5.4943','7000',0,8299401,100,0),
(@PATH,5,'-3.0730','254.8057','-5.4790','16200',0,0,100,0),
(@PATH,6,'-1.3867','253.2512','-5.4943','7000',0,8299401,100,0);
--
-- Right Green Keeper
UPDATE `creature` SET `spawndist`='0',`movementtype`='2' WHERE `guid` IN ('82993');
SET @NPC := 82993;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@NPC,@PATH,0,0,0,4097,69,0,'');
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-- (@PATH,1,'XXX','YYY','ZZZ',0,0,0,100,0),
(@PATH,1,'3.9829','253.1120','-5.4724',21500,0,0,100,0), 
(@PATH,2,'3.4760','252.0930','-5.4791',0,0,0,100,0),
(@PATH,3,'0.4444','252.4552','-5.4943',7000,0,8299401,100,0),
(@PATH,4,'3.9829','253.1120','-5.4724',29500,0,0,100,0), 
(@PATH,5,'3.4760','252.0930','-5.4791',0,0,0,100,0),
(@PATH,6,'0.4444','252.4552','-5.4943',7000,0,8299401,100,0),
(@PATH,7,'3.9829','253.1120','-5.4724',15500,0,0,100,0), 
(@PATH,8,'3.4760','252.0930','-5.4791',0,0,0,100,0),
(@PATH,9,'0.4444','252.4552','-5.4943',7000,0,8299401,100,0),
(@PATH,10,'3.4760','252.0930','-5.4791',0,0,0,100,0);
--
UPDATE `creature` SET `movementtype`='2' WHERE `guid` IN ('82985');
SET @NPC := 82985;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@NPC,@PATH,0,513,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-- (@PATH,1,'XXX','YYY','ZZZ',0,0,0,100,0),
(@PATH,1,'-14.725861','244.255112','-5.214353','8000',0,0,100,0),
(@PATH,2,'-3.16054','243.291','-5.5165',0,0,0,100,0),
(@PATH,3,'-3.54976','215.113','-5.53931',0,0,0,100,0),
(@PATH,4,'-5.031358','214.277512','-5.540350','10000',0,8315101,100,0),
(@PATH,5,'-3.54976','215.113','-5.53931',0,0,0,100,0),
(@PATH,6,'-3.16054','243.291','-5.5165',0,0,0,100,0);
--
--
UPDATE `creature` SET `movementtype`='2' WHERE `guid` IN ('82991');
SET @NPC := 82991;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@NPC,@PATH,0,513,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-- (@PATH,1,'XXX','YYY','ZZZ',0,0,0,100,0),
(@PATH,1,'12.536785','244.131027','-5.276653','8800',0,0,100,0),
(@PATH,2,'2.36405','242.874','-5.51154',0,0,0,100,0),
(@PATH,3,'2.44798','215.308','-5.54035',0,0,0,100,0),
(@PATH,4,'3.941355','214.042435','-5.540350','10000',0,8315101,100,0),
(@PATH,5,'2.44798','215.308','-5.54035',0,0,0,100,0),
(@PATH,6,'2.36405','242.874','-5.51154',0,0,0,100,0);

--
-- -----------------------------
-- Left Bloodwarder Greenkeepers
-- -----------------------------
UPDATE `creature` SET `movementtype`='2' WHERE `guid` IN ('82981');
SET @NPC := 82981;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@NPC,@PATH,0,0,0,4097,69,0,'');
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-- (@PATH,1,'XXX','YYY','ZZZ',0,0,0,100,0),
(@PATH,1,'-19.4848','197.125','-5.54034','29000',0,0,100,0),
(@PATH,2,'-18.3153','195.691','-5.54122',0,0,0,100,0),
(@PATH,3,'-14.4761','195.052','-5.54122',0,0,0,100,0),
(@PATH,4,'-9.28239','198.789','-5.54122',0,0,0,100,0),
(@PATH,5,'-7.14421','203.369','-5.54122',0,0,0,100,0),
(@PATH,6,'-8.27586','203.442','-5.54122','24000',0,0,100,0),
(@PATH,7,'-6.73612','202.567','-5.54122',0,0,0,100,0),
(@PATH,8,'-8.75032','199.727','-5.54122',0,0,0,100,0),
(@PATH,9,'-13.0694','195.498','-5.54122',0,0,0,100,0),
(@PATH,10,'-17.5981','194.664','-5.54122',0,0,0,100,0),
(@PATH,11,'-19.281','195.896','-5.54122',0,0,0,100,0);
--
-- ------------------------------
-- Right Bloodwarder Greenkeepers
-- ------------------------------
UPDATE `creature` SET `movementtype`='2' WHERE `guid` IN ('82977');
SET @NPC := 82977;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@NPC,@PATH,0,0,0,4097,69,0,'');
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-- (@PATH,1,'XXX','YYY','ZZZ',0,0,0,100,0),
(@PATH,1,'13.8952','197.464','-5.54041','18000',0,0,100,0),
(@PATH,2,'15.0475','193.183','-5.54122',0,0,0,100,0),
(@PATH,3,'16.6998','192.651','-5.54122',0,0,0,100,0),
(@PATH,4,'17.8517','192.8757','-5.54122','20000',0,0,100,0),
(@PATH,5,'17.5705','192.439','-5.54122',0,0,0,100,0),
(@PATH,6,'14.347','193.671','-5.54122',0,0,0,100,0),
(@PATH,7,'13.4535','196.095','-5.54122',0,0,0,100,0);
--
-- -------------------------------
-- Third Tempest-Forge Peacekeeper
-- -------------------------------
UPDATE `creature` SET `movementtype`='2' WHERE `guid` IN ('82992');
SET @NPC := 82992;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@NPC,@PATH,0,512,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-- (@PATH,1,'XXX','YYY','ZZZ',0,0,0,100,0),
(@PATH,1,'13.2272','178.591','-5.5404',0,0,0,100,0),
(@PATH,2,'13.7786','193.285','-5.5404',0,0,0,100,0),
(@PATH,3,'9.13868','197.798','-5.5404','5000',0,0,100,0),
(@PATH,4,'-0.635412','203.851','-5.5404',0,0,0,100,0),
(@PATH,5,'-0.660702','223.381','-5.5404',0,0,0,100,0),
(@PATH,6,'-0.571616','247.901','-5.51829',0,0,0,100,0),
(@PATH,7,'-0.697975','222.215','-5.54037','3000',0,0,100,0),
(@PATH,8,'-0.301946','204.186','-5.54037',0,0,0,100,0),
(@PATH,9,'8.68828','198.154','-5.54037',0,0,0,100,0),
(@PATH,10,'13.1168','194.426','-5.54037',0,0,0,100,0);
--
UPDATE `creature` SET `movementtype`='2' WHERE `guid` IN ('82983');
SET @NPC := 82983;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@NPC,@PATH,0,512,0,4097,69,0,'');
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-- (@PATH,1,'XXX','YYY','ZZZ',0,0,0,100,0),
(@PATH,1,'-0.268618','160.028','-5.5395',0,0,1000,100,0),
(@PATH,2,'-4.24328','161.149','-5.5395',0,0,0,100,0),
(@PATH,3,'-6.01467','167.23','-5.5395','34000',0,1068,100,0),
-- evtl nochn waypoint
(@PATH,4,'-3.54166','160.511','-5.5395',0,0,1000,100,0),
(@PATH,5,'2.36906','161.495','-5.5395',0,0,0,100,0),
(@PATH,6,'2.31835','163.18','-5.54038','16000',0,1068,100,0);
-- evtl nochn waypoint
-- (@PATH,1,'XXX','YYY','ZZZ',0,0,0,100,0),
--
UPDATE `creature` SET `movementtype`='2' WHERE `guid` IN ('83151');
SET @NPC := 83151;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@NPC,@PATH,0,512,0,4097,333,0,'');
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-- (@PATH,1,'XXX','YYY','ZZZ',0,0,0,100,0),
(@PATH,1,'0.319128','93.350929','-5.652020',2200,0,8315101,100,0),
(@PATH,2,'0.304653','53.7379','-5.65205',0,0,0,100,0),
(@PATH,3,'0.246856','49.9056','-5.61616',0,0,0,100,0),
(@PATH,4,'1.77807','47.0135','-5.52788',0,0,0,100,0),
(@PATH,5,'2.35202','46.2708','-5.53589',60000,0,0,100,0); -- 8315102 waypoint_script
-- 
UPDATE `creature` SET `movementtype`='2' WHERE `guid` IN ('83152');
SET @NPC := 83152;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@NPC,@PATH,0,512,0,4097,333,0,'');
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-- (@PATH,1,'XXX','YYY','ZZZ',0,0,0,100,0),
(@PATH,1,'-2.910640','93.303818','-5.652020',2190,0,8315101,100,0),
(@PATH,2,'-3.09647','53.6826','-5.65205',0,0,0,100,0),
(@PATH,3,'-2.9898','50.0713','-5.62371',0,0,0,100,0),
(@PATH,4,'-3.98776','46.8545','-5.53157',0,0,0,100,0),
(@PATH,5,'-4.7336','45.9968','-5.55443',59990,0,0,100,0);  -- 8315102 waypoint_script
-- -------------------------------
-- First Tempest-Forge Peacekeeper
-- -------------------------------
UPDATE `creature` SET `movementtype`='2' WHERE `guid` IN ('83153');
SET @NPC := 83153;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@NPC,@PATH,0,512,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-- (@PATH,1,'XXX','YYY','ZZZ',0,0,0,100,0),
(@PATH,1, -1.238058,53.229778,-5.650580,0,0,0,100,0),
(@PATH,2, -1.056883,93.744209,-5.651805,0,0,0,100,0),
(@PATH,3, -0.781224,113.317207,-5.583306,0,0,0,100,0),
(@PATH,4, -1.384052,95.681999,-5.650106,0,0,0,100,0),
(@PATH,5, -1.409816,55.045288,-5.651893,0,0,0,100,0),
(@PATH,6, -1.025726,43.837605,-5.606754,0,0,0,100,0);
--
UPDATE `creature` SET `movementtype`='2' WHERE `guid` IN ('82984');
SET @NPC := 82984;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@NPC,@PATH,0,512,0,4097,333,0,'');
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-- (@PATH,1,'XXX','YYY','ZZZ',0,0,0,100,0),
(@PATH,1,'9.051096','160.359482','-5.540343','2200',0,8315101,100,0),
(@PATH,2,'7.00565','151.863','-5.54034',0,0,0,100,0),
(@PATH,3,'2.13972','149.017','-5.54034',0,0,0,100,0),
(@PATH,4,'2.85909','133.568','-5.54034',0,0,0,100,0),
(@PATH,5,'3.1027','130.1091','-5.5396','10000',0,0,100,0),
(@PATH,6,'2.85909','133.568','-5.54034',0,0,0,100,0),
(@PATH,7,'2.13972','149.017','-5.54034',0,0,0,100,0),
(@PATH,8,'7.00565','151.863','-5.54034',0,0,0,100,0);
--
UPDATE `creature` SET `movementtype`='2' WHERE `guid` IN ('83156');
SET @NPC := 83156;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@NPC,@PATH,0,512,0,4097,333,0,'');
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-- (@PATH,1,'XXX','YYY','ZZZ',0,0,0,100,0),
(@PATH,1,'-10.472994','160.509964','-5.540343','2200',0,8315101,100,0),
(@PATH,2,'-9.05886','151.889','-5.54034',0,0,0,100,0),
(@PATH,3,'-3.30866','147.948','-5.54034',0,0,0,100,0),
(@PATH,4,'-3.96269','134.198','-5.54034',0,0,0,100,0),
(@PATH,5,'-5.29153','130.642','-5.53917','10000',0,0,100,0),
(@PATH,6,'-3.96269','134.198','-5.54034',0,0,0,100,0),
(@PATH,7,'-3.30866','147.948','-5.54034',0,0,0,100,0),
(@PATH,8,'-9.05886','151.889','-5.54034',0,0,0,100,0);

SET @GUID := 83087;
UPDATE `creature` SET `MovementType`='2' WHERE `guid` = @GUID;
DELETE FROM `creature_addon` WHERE `guid` = @GUID;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@GUID,@GUID,0,0,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` VALUES (83087, 1, -56.6067, 566.384, -17.7584, 255, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (83087, 2, -81.0371, 554.711, -17.7842, 255, 0, 0, 100, 0);

-- Respawn
DELETE FROM `creature_linked_respawn` WHERE `guid` IN (83140,83138,83120,83139,83119,82992,83137);
INSERT INTO `creature_linked_respawn` VALUES
-- High Botanist Freywinn
(83140,82987),
-- Commander Sarannis
(83138,82986),
(83120,82986),
(83139,82986),
(83119,82986),
(82992,82986),
(83137,82986);
--
--
--
--
-- 
--
--
--
-- formations
DELETE FROM `creature_formations` WHERE `leaderguid` IN (82991,82985,83141,83142,83143,83049,83050,83051,83053,83054,83055,83021,83024,83025,83028,83048,83029,83020,83140,83030,83031,83032,83033,83034,83016,83017,83018,83019,83115,83116,83117,83118,83110,83111,83113,83114,83107,83108,83109,83112,83105,83106,83095,83096,83097,83098,83099,83090,83091,83092,83093,83094,83100,83101,83102,83103,83104,83045,83047,83074,83075,83070,83071,83057,83058,83061,83062,83063,83064,83065,83066,83068,83069,83056,83046,83044,83043,83042,83041,83040,83039,83038,83037,83036,83035,83155,83154,82984,83156,82980,82981,82982,82979,82978,82977,83000,82993,82994,82995,82996,82997,82998,83001,83002,83004,83005,83006,83007,83008,83009,83010,83026,83027,83023,83022,83119,83014,83015,83138,83139,83120,83011,83012,83013,83130,83131,83132,83133,83134,83135,83136,83146,83147,83148,83149,83119,83120,83121,83122,83123,83123,83124,83125,83126,83127,83128,83129,83137,83150,82983,82988,83082,83083,83084,83085,83077,83078,83079,83080,83081,82984,83152,83151);
DELETE FROM `creature_formations` WHERE `memberguid` IN (82991,82985,83141,83142,83143,83049,83050,83051,83053,83054,83055,83021,83024,83025,83028,83048,83029,83020,83140,83030,83031,83032,83033,83034,83016,83017,83018,83019,83115,83116,83117,83118,83110,83111,83113,83114,83107,83108,83109,83112,83105,83106,83095,83096,83097,83098,83099,83090,83091,83092,83093,83094,83100,83101,83102,83103,83104,83045,83047,83074,83075,83070,83071,83057,83058,83061,83062,83063,83064,83065,83066,83068,83069,83056,83046,83044,83043,83042,83041,83040,83039,83038,83037,83036,83035,83155,83154,82984,83156,82980,82981,82982,82979,82978,82977,83000,82993,82994,82995,82996,82997,82998,83001,83002,83004,83005,83006,83007,83008,83009,83010,83026,83027,83023,83022,83119,83014,83015,83138,83139,83120,83011,83012,83013,83130,83131,83132,83133,83134,83135,83136,83146,83147,83148,83149,83119,83120,83121,83122,83123,83123,83124,83125,83126,83127,83128,83129,83137,83150,82983,82988,83082,83083,83084,83085,83077,83078,83079,83080,83081,82984,83152,83151);
INSERT INTO `creature_formations` VALUES
--
--
--
(83141,83141,100,360,2),
(83141,83142,100,360,2),
(83141,83143,100,360,2),
--
(83051,83051,100,360,2),
(83051,83050,100,360,2),
(83051,83049,100,360,2),
--
(83053,83053,100,360,2),
(83053,83054,100,360,2),
(83053,83055,100,360,2),
--
(83021,83021,100,360,2),
(83021,83024,100,360,2),
(83021,83025,100,360,2),
(83021,83028,100,360,2),
(83021,83048,100,360,2),
--
(83029,83029,100,360,2),
(83029,83020,100,360,2),
(83029,83140,100,360,2),
--
(83030,83030,100,360,2),
(83030,83031,100,360,2),
(83030,83032,100,360,2),
(83030,83033,100,360,2),
(83030,83034,100,360,2),  
--
-- 83077 82988
--
(83016,83016,100,360,2),
(83016,83017,100,360,2),
(83016,83018,100,360,2),
(83016,83019,100,360,2),
--
(83115,83115,100,360,2),
(83115,83116,100,360,2),
(83115,83117,100,360,2),
(83115,83118,100,360,2),
--
(83110,83110,100,360,2),
(83110,83111,100,360,2),
(83110,83113,100,360,2),
(83110,83114,100,360,2),

--
(83107,83107,100,360,2),
(83107,83108,100,360,2),
(83107,83109,100,360,2),
(83107,83112,100,360,2),
--
(83105,83105,100,360,2),
(83105,83106,100,360,2),
--
(83095,83095,100,360,2),
(83095,83096,100,360,2),
(83095,83097,100,360,2),
(83095,83098,100,360,2),
(83095,83099,100,360,2),
--
(83090,83090,100,360,2),
(83090,83091,100,360,2),
(83090,83092,100,360,2),
(83090,83093,100,360,2),
(83090,83094,100,360,2),
--
(83100,83100,100,360,2),
(83100,83101,100,360,2),
(83100,83102,100,360,2),
(83100,83103,100,360,2),
(83100,83104,100,360,2),
--
--
--
--
(83045,83045,100,360,2),
(83045,83047,2,2.1,2),
-- 
(83075,83075,0,0,1),
(83075,83074,0,0,1),
--
(83070,83070,0,0,1),
(83070,83071,0,0,1),
--
(83057,83057,100,360,2),
(83057,83058,100,360,2),
(83057,83061,100,360,2),
(83057,83062,100,360,2),
(83057,83063,100,360,2),
(83057,83064,100,360,2),
(83057,83065,100,360,2),
(83057,83066,100,360,2),
(83057,83068,100,360,2),
(83057,83069,100,360,2),
(83057,83056,100,360,2),
--
(83046,83046,100,360,2),
(83046,83044,100,360,2),
(83046,83043,100,360,2),
(83046,83042,100,360,2),
(83046,83041,100,360,2),
(83046,83040,100,360,2),
(83046,83039,100,360,2),
(83046,83038,100,360,2),
(83046,83037,100,360,2),
(83046,83036,100,360,2),
(83046,83035,100,360,2),
--
(83154,83154,100,360,2),
(83154,83155,100,360,2),
--
(82980,82980,100,360,2),
(82980,82981,100,360,2),
(82980,82982,100,360,2),
--
(82979,82979,100,360,2),
(82979,82978,100,360,2),
(82979,82977,100,360,2),
--
(83000,83000,100,360,2),
(83000,82993,100,360,2),
(83000,82994,100,360,2),
-- 
(82995,82995,100,360,2),
(82995,82996,100,360,2),
(82995,82997,100,360,2),
(82995,82998,100,360,2),
--
(83001,83001,100,360,2),
(83001,83002,100,360,2),
--
(83004,83004,100,360,2),
(83004,83005,100,360,2),
(83004,83006,100,360,2),
--
(83007,83007,100,360,2),
(83007,83008,100,360,2),
(83007,83009,100,360,2),
(83007,83010,100,360,2),
--
(83027,83027,100,360,2),
(83027,83026,3,1,2),
--
(83022,83022,100,360,2),
(83022,83023,3,1,2),
--
(83119,83119,100,360,2),
(83119,83014,100,360,2),
(83119,83015,100,360,2),
--
--
(83138,83138,100,360,2),
(83138,83139,100,360,2),
(83138,83120,100,360,2),
--
--
(83011,83011,100,360,2),
(83011,83012,100,360,2),
(83011,83013,100,360,2),
--
(83131,83131,100,360,2),
(83131,83132,100,360,2),
(83131,83133,100,360,2),
(83131,83134,100,360,2),
(83131,83135,100,360,2),
(83131,83136,100,360,2),
(83131,83146,100,360,2),
(83131,83147,100,360,2),
(83131,83148,100,360,2),
(83131,83149,100,360,2),
--
(83121,83121,100,360,2),
(83121,83122,100,360,2),
(83121,83123,100,360,2),
(83121,83124,100,360,2),
(83121,83125,100,360,2),
(83121,83126,100,360,2),
(83121,83127,100,360,2),
(83121,83128,100,360,2),
(83121,83129,100,360,2),
(83121,83130,100,360,2),

--
(83137,83137,100,360,2),
(83137,83150,100,360,2),
(83137,82983,100,360,2),
--
(83082,83082,100,360,2),
(83082,83083,100,360,2),
(83082,83084,100,360,2),
(83082,83085,100,360,2),
--
(83078,83078,100,360,2),
(83078,83079,100,360,2),
(83078,83080,100,360,2),
(83078,83081,100,360,2),
--
(82991,82991,0,0,1),
(82991,82985,0,0,1),
--
(83156,83156,0,0,1),
(83156,82984,0,0,1),
--
(83152,83152,0,0,1),
(83152,83151,0,0,1);

-- Duyash the Cruel
UPDATE `creature_template` SET `unit_flags`='33090',`flags_extra`='2' WHERE `entry` = 20390;