Terokkar Forest, Blade's Edge Mountains

#!sql

-- https://github.com/Looking4Group/L4G_Core/issues/2064
-- Skettis & Ogri'la
-- ======================================================
-- Texts & Scripts
-- ======================================================
--
UPDATE `creature_ai_texts` SET `content_default`='bares her fangs and hisses menacingly at those around her.' WHERE `entry` = '-236';
UPDATE `creature_ai_texts` SET `content_default`='focuses on $N.' WHERE `entry` = '-237';
--
-- ======================================================
-- NPC Research
-- ======================================================
--
-- Mountain Colossus 21844
UPDATE `creature_template` SET `mindmg`='1140',`maxdmg`='1366',`flags_extra`=`flags_extra`|'536870912',`mingold`=0,`maxgold`=0,`AIName`='EventAI' WHERE `entry` = '21844'; -- 401 853 -- 2,280 - 2,732
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = '21844';
INSERT INTO `creature_ai_scripts` VALUES
('2184401','21844','9','0','100','1','0','8','15000','20000','11','15548','0','1','0','0','0','0','0','0','0','0','Mountain Colossus - Cast Thunderclap'),
('2184402','21844','2','0','100','0','50','0','0','0','12','22390','1','30000','11','18210','0','7','0','0','0','0','Mountain Colossus - Summon Mountain Shardling and Reduce Scale at 50% HP');
--
-- Mountain Shardling 22390
UPDATE `creature_template` SET `mindmg`='141',`maxdmg`='182' WHERE `entry` = '22390'; -- 20 61 -- 141 - 182
--
-- Skettis Surger 21728
UPDATE `creature_template` SET `mindmg`='260',`maxdmg`='311',`dmgschool`='4 ',`resistance4`='-1',`flags_extra`=`flags_extra`|'536870912' WHERE `entry` = '21728'; -- 91 194 0 0 -- 519 622
DELETE FROM `creature_onkill_reputation` WHERE `creature_id` = '21728';
-- INSERT INTO `creature_onkill_reputation` VALUES
-- (21728,1031,0,7,0,10,0,0,0,0);
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = '21728';
INSERT INTO `creature_ai_scripts` VALUES
('2172801','21728','9','0','100','1','0','45','2500','4800','11','32011','1','0','0','0','0','0','0','0','0','0','Skettis Surger - Cast Water Bolt');
--
-- Talonsworn Forest-Rager 23029
UPDATE `creature_template` SET `armor`='7238',`speed`='1.48',`mindmg`='837',`maxdmg`='843',`resistance3`='-1',`flags_extra`=`flags_extra`|'536870912' WHERE `entry` = '23029'; -- 207 213 0 0 -- 837 - 843
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = '23029';
INSERT INTO `creature_ai_scripts` VALUES
('2302901','23029','9','0','100','1','0','8','12000','16000','11','15548','0','1','0','0','0','0','0','0','0','0','Talonsworn Forest-Rager - Cast Thunderclap');
DELETE FROM `creature_loot_template` WHERE `entry`=23029 AND `item`=25; -- 23029    25  0,5 0   1   1   0   0   0 maybe no reference loot template 

-- Talonpriest Ishaal 23066
UPDATE `creature` SET `spawntimesecs`='180' WHERE `id` = 23066;
UPDATE `creature_template` SET `minhealth`='11000',`maxhealth`='11000',`armor`='6100',`speed`='1.20',`mingold`='1400',`maxgold`='1500',`AIName`='EventAI' WHERE `entry` = '23066'; -- 5500 6450 1 0 0
UPDATE `creature_template_addon` SET `auras`='37411 0 22917 0 22917 1' WHERE `entry` = 23066; 
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = '23066';
INSERT INTO `creature_ai_scripts` VALUES
('2306600','23066','4','0','100','0','0','0','0','0','28','0','37411','0','0','0','0','0','0','0','0','0','Talonpriest Ishaal - Cancel Skettis Corrupted Ghosts on Aggro'),
('2306601','23066','2','0','100','1','75','0','8000','12000','11','17843','0','0','0','0','0','0','0','0','0','0','Talonpriest Ishaal - Cast Flash Heal'),
('2306602','23066','9','0','100','1','0','5','8000','12000','11','11918','1','32','0','0','0','0','0','0','0','0','Talonpriest Ishaal - Cast Poison'),
('2306603','23066','2','0','100','1','90','0','6000','9000','11','12160','0','32','0','0','0','0','0','0','0','0','Talonpriest Ishaal - Cast Rejuvenation'),
('2306604','23066','9','0','100','1','0','30','6000','9000','11','15654','4','32','0','0','0','0','0','0','0','0','Talonpriest Ishaal - Cast Shadow Word Pain'),
('2306605','23066','4','0','25','0','0','0','0','0','1','-1241','0','0','0','0','0','0','0','0','0','0','Talonpriest Ishaal - Say on Aggro'),
('2306606','23066','6','0','25','0','0','0','0','0','1','-1242','0','0','0','0','0','0','0','0','0','0','Talonpriest Ishaal - Say on Death'),
('2306607','23066','7','0','100','0','0','0','0','0','11','37411','0','7','0','0','0','0','0','0','0','0','Talonpriest Ishaal - Cast Skettis Corrupted Ghosts on Evade');

-- Talonpriest Skizzik 23067
UPDATE `creature` SET `spawntimesecs`='180' WHERE `id` = 23067;
UPDATE `creature_template` SET `minhealth`='10000',`maxhealth`='10000',`armor`='6100',`speed`='1.20',`AIName`='EventAI',`equipment_id`='1034' WHERE `entry` = '23067'; -- 5000 6450 1 1035
UPDATE `creature_template_addon` SET `auras`='37411 0 22917 0 22917 1' WHERE `entry` = 23067; 
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = '23067';
INSERT INTO `creature_ai_scripts` VALUES
('2306700','23067','4','0','100','0','0','0','0','0','28','0','37411','0','0','0','0','0','0','0','0','0','Talonpriest Skizzik - Cancel Skettis Corrupted Ghosts on Aggro'),
('2306701','23067','9','0','100','1','0','20','2000','4000','11','17165','1','0','0','0','0','0','0','0','0','0','Talonpriest Skizzik - Cast Mind Flay'),
('2306702','23067','9','0','100','1','0','5','8000','12000','11','11918','0','1','0','0','0','0','0','0','0','0','Talonpriest Skizzik - Cast Psychic Scream'),
('2306703','23067','4','0','25','0','0','0','0','0','1','-1241','0','0','0','0','0','0','0','0','0','0','Talonpriest Skizzik - Say on Aggro'),
('2306704','23067','6','0','25','0','0','0','0','0','1','-1242','0','0','0','0','0','0','0','0','0','0','Talonpriest Skizzik - Say on Death'),
('2306705','23067','7','0','100','0','0','0','0','0','11','37411','0','7','0','0','0','0','0','0','0','0','Talonpriest Skizzik - Cast Skettis Corrupted Ghosts on Evade');

-- Talonpriest Zellek 23068
UPDATE `creature` SET `spawntimesecs`='180' WHERE `id` = 23068;
UPDATE `creature_template` SET `minhealth`='12000',`maxhealth`='12000',`armor`='6100',`speed`='1.20',`mingold`='1400',`maxgold`='1500',`AIName`='EventAI',`equipment_id`='464' WHERE `entry` = '23068'; -- 6000 7000 1.24 469/499/503/509/516/520/560/758
UPDATE `creature_template_addon` SET `auras`='37411 0 22917 0 22917 1' WHERE `entry` = 23068; 
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = '23068';
INSERT INTO `creature_ai_scripts` VALUES
('2306800','23068','4','0','100','0','0','0','0','0','28','0','37411','0','0','0','0','0','0','0','0','0','Talonpriest Zellek - Cancel Skettis Corrupted Ghosts on Aggro'),
('2306801','23068','9','0','100','1','0','30','7000','9000','11','32863','4','32','0','0','0','0','0','0','0','0','Talonpriest Zellek - Cast Seed of Corruption'),
('2306802','23068','9','0','100','1','0','5','8000','12000','11','15652','1','0','0','0','0','0','0','0','0','0','Talonpriest Zellek - Cast Head Smash'),
('2306803','23068','9','0','100','1','0','20','4000','6000','11','17173','1','0','0','0','0','0','0','0','0','0','Talonpriest Zellek - Cast Drain Life'),
('2306804','23068','4','0','25','0','0','0','0','0','1','-1241','0','0','0','0','0','0','0','0','0','0','Talonpriest Zellek - Say on Aggro'),
('2306805','23068','6','0','25','0','0','0','0','0','1','-1242','0','0','0','0','0','0','0','0','0','0','Talonpriest Zellek - Say on Death'),
('2306806','23068','7','0','100','0','0','0','0','0','11','37411','0','7','0','0','0','0','0','0','0','0','Talonpriest Zellek - Cast Skettis Corrupted Ghosts on Evade');

-- Skettis Soulcaller 21911
UPDATE `creature` SET `spawntimesecs` = 300 WHERE `id` = 21911;
-- UPDATE `creature_template` SET WHERE `entry` = '21911';
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = '21911';
INSERT INTO `creature_ai_scripts` VALUES
('2191101','21911','9','0','100','1','0','40','3000','4000','11','20298','1','0','0','0','0','0','0','0','0','0','Skettis Soulcaller - Cast Shadow Bolt'),
('2191102','21911','9','0','100','1','0','30','13000','18000','11','38663','1','0','0','0','0','0','0','0','0','0','Skettis Soulcaller - Cast Slow'),
('2191103','21911','2','0','100','0','30','0','0','0','11','5137','1','0','0','0','0','0','0','0','0','0','Skettis Soulcaller - Cast Call of the Grave at 30% HP');
--
-- Skettis Windwalker 21649
-- UPDATE `creature_template` SET WHERE `entry` = '21649';
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = '21649';
INSERT INTO `creature_ai_scripts` VALUES
('2164901','21649','9','0','100','1','0','40','2500','3800','11','13901','1','0','0','0','0','0','0','0','0','0','Skettis Windwalker - Cast Arcane Bolt'),
('2164902','21649','0','0','100','1','4000','6500','14000','18000','11','40578','4','32','0','0','0','0','0','0','0','0','Skettis Windwalker - Cast Cast Cyclone'),
('2164903','21649','14','0','100','1','2000','40','10000','15000','11','34110','6','0','0','0','0','0','0','0','0','0','Skettis Windwalker - Cast Shadow Mend on Friendlies');
--
-- Skettis Wing Guard 21644
UPDATE `creature_template` SET `equipment_id`='8038' WHERE `entry` = '21644'; -- 1359
DELETE FROM `creature_equip_template` WHERE `entry` = '8038';
INSERT INTO `creature_equip_template` VALUES
(8038,8528,0,0,33490946,0,0,256,0,0);
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = '21644';
INSERT INTO `creature_ai_scripts` VALUES
('2164401','21644','4','0','8','0','0','0','0','0','1','-9200','-9201','-9202','0','0','0','0','0','0','0','0','Skettis Wing Guard - Say on Aggro'),
('2164402','21644','9','0','100','1','0','8','9000','14000','11','13730','0','0','0','0','0','0','0','0','0','0','Skettis Wing Guard - Cast Demoralizing Shout'),
('2164403','21644','0','0','100','1','4000','7000','7000','12000','11','35321','4','32','0','0','0','0','0','0','0','0','Skettis Wing Guard - Cast Gushing Wound'),
('2164404','21644','0','0','100','1','6000','9000','11000','16000','11','40546','0','0','0','0','0','0','0','0','0','0','Skettis Wing Guard - Cast Retaliation'),
('2164405','21644','2','0','100','0','30','0','0','0','11','8599','0','1','1','-106','0','0','0','0','0','0','Skettis Wing Guard - Cast Enrage at 30% HP'),
('2164406','21644','6','0','4','0','0','0','0','0','1','-9203','0','0','0','0','0','0','0','0','0','0','Skettis Wing Guard - Say on Death');

-- Skettis Kaliri 21804
UPDATE `creature_template` SET `speed`='1.125',`inhabittype`='3' WHERE `entry` = '21804'; -- 1.125 3
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = '21804';
INSERT INTO `creature_ai_scripts` VALUES
('2180401','21804','9','0','100','1','0','5','5000','10000','11','5708','1','0','0','0','0','0','0','0','0','0','Skettis Kaliri - Cast Swoop');
DELETE FROM `creature_loot_template` WHERE `entry` = 21804 AND `item` IN (17056,32620,32388);
INSERT INTO `creature_loot_template` VALUES
(21804,17056,10,0,1,1,0,0,0),
(21804,32620,5,0,1,1,0,0,0),
(21804,32388,5,0,1,1,0,0,0);
--
-- Skettis Talonite 21650
UPDATE `creature_template` SET `modelid_H`='17864' WHERE `entry` = '21650'; -- 20817
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = '21650';
INSERT INTO `creature_ai_scripts` VALUES
('2165001','21650','0','0','100','1','1000','1000','1000','1000','21','1','0','0','40','1','0','0','0','0','0','0','Skettis Talonite - Start Movement and Set Melee Weapon Model'),
('2165002','21650','9','0','100','1','5','20','2300','3900','11','10277','1','0','21','0','0','0','40','2','0','0','Skettis Talonite - Cast Throw and Stop Movement and Set Ranged Weapon Model (Phase 1)'), -- 30
('2165003','21650','9','0','100','1','0','5','9000','14000','11','11428','1','0','21','1','0','0','40','1','0','0','Skettis Talonite - Cast Knockdown and Set Melee Weapon Model and Start Movement'),
('2165004','21650','9','0','100','1','0','5','0','0','21','1','0','0','40','1','0','0','0','0','0','0','Skettis Talonite - Start Movement and Set Melee Weapon Model Below 5 Yards'),
('2165005','21650','7','0','100','0','0','0','0','0','21','1','0','0','40','1','0','0','0','0','0','0','Skettis Talonite - Set Melee Weapon Model and Start Movement on Evade'),
('2165006','21650','9','0','100','1','5','20','0','0','21','0','0','0','40','2','0','0','0','0','0','0','Skettis Talonite - Stop Movement and Set Ranged Weapon Model Above 5 Yards');
--
-- Skettis Followers Spawner 21654
UPDATE `creature_template` SET `flags_extra`=2 WHERE `entry` = '21654'; -- 2
--
-- Skettis Sentinel 21912
UPDATE `creature_template` SET `mindmg`='570',`maxdmg`='683',`AIName`='EventAI' WHERE `entry` = '21912'; -- 100 213 -- 570 - 683
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = '21912';
INSERT INTO `creature_ai_scripts` VALUES
('2191201','21912','0','0','100','1','5000','10000','4000','8000','11','30619','1','1','0','0','0','0','0','0','0','0','Skettis Sentinel - Cast Cleave'),
('2191202','21912','9','0','100','1','0','5','8000','12000','11','37577','1','1','0','0','0','0','0','0','0','0','Skettis Sentinel - Cast Debilitating Strike'),
('2191203','21912','2','0','100','0','30','0','0','0','11','23537','0','7','1','-106','0','0','0','0','0','0','Skettis Sentinel - Cast Frenzy');
--
-- Skettis Assassin 23207
UPDATE `creature_template` SET `faction_A`='90',`faction_H`='90',`unit_flags`='0',`mindmg`='85',`maxdmg`='180',`AIName`='EventAI' WHERE `entry` = '23207'; -- 1860 32768 85 180 
UPDATE `creature_template_addon` SET `bytes0`='16908544',`auras`='' WHERE `entry` = '23207'; -- 37411 0
-- DELETE FROM `creature_template_addon` WHERE `entry` = 23207;
-- INSERT INTO `creature_template_addon` VALUES
-- (23207,0,0,0,0,4097,0,0,'37411 0');
DELETE FROM `creature_onkill_reputation` WHERE `creature_id` = 23207;
INSERT INTO `creature_onkill_reputation` VAlUES
(23207,1031,0,7,0,10,0,0,0,0);
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = '23207';
INSERT INTO `creature_ai_scripts` VALUES
('2320701','23207','9','0','100','1','0','30','2000','3000','11','10277','4','1','0','0','0','0','0','0','0','0','Skettis Assassin - Cast Throw');
--
-- Time-Lost Skettis High Priest 21787
UPDATE `creature_template` SET `AIName`='EventAI' WHERE `entry` = '21787'; --
UPDATE `creature_template_addon` SET `auras`='37411 0 16592 0 16592 1' WHERE `entry` = 21787; --  
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = '21787';
INSERT INTO `creature_ai_scripts` VALUES
('2178700','21787','4','0','100','0','0','0','0','0','28','0','37411','0','0','0','0','0','0','0','0','0','Time-Lost Skettis High Priest - Cancel Skettis Corrupted Ghosts on Aggro'),
('2178701','21787','9','0','100','1','0','40','2500','3800','11','9734','1','0','0','0','0','0','0','0','0','0','Time-Lost Skettis High Priest - Cast Holy Smite'),
('2178702','21787','9','0','100','1','0','30','6000','9000','11','11639','4','32','0','0','0','0','0','0','0','0','Time-Lost Skettis High Priest - Cast Shadow Word Pain'),
('2178703','21787','14','0','100','1','2000','40','10000','15000','11','42420','6','0','0','0','0','0','0','0','0','0','Time-Lost Skettis High Priest - Cast Shadow Mend on Friendlies'),
('2178704','21787','7','0','100','0','0','0','0','0','11','37411','0','7','0','0','0','0','0','0','0','0','Time-Lost Skettis High Priest - Cast Skettis Corrupted Ghosts on Evade');
--
-- Skettis Time-Shifter 21652 I think this shouldnt be in
UPDATE `creature_template` SET `AIName`='EventAI' WHERE `entry` = '21652'; --
UPDATE `creature_template_addon` SET `auras`=NULL WHERE `entry` = 21652;
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = '21652';
INSERT INTO `creature_ai_scripts` VALUES
('2165201','21652','0','0','100','1','5000','10000','10000','20000','11','24680','1','0','0','0','0','0','0','0','0','0','Skettis Time-Shifter - Cast Chain Lightning'),
('2165202','21652','9','0','100','1','0','30','8000','12000','11','37589','1','0','0','0','0','0','0','0','0','0','Skettis Time-Shifter - Cast Shriveling Gaze');
--
-- Time-Lost Skettis Reaver 21651
UPDATE `creature_template` SET `AIName`='EventAI' WHERE `entry` = '21651'; --
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = '21651';
INSERT INTO `creature_ai_scripts` VALUES
('2165100','21651','4','0','100','0','0','0','0','0','28','0','37411','0','0','0','0','0','0','0','0','0','Time-Lost Skettis Reaver - Cancel Skettis Corrupted Ghosts on Aggro'),
('2165101','21651','4','0','100','0','0','0','0','0','11','42247','0','1','0','0','0','0','0','0','0','0','Time-Lost Skettis Reaver - Cast Battle Shout on Aggro'),
('2165102','21651','0','0','100','1','5000','10000','4000','8000','11','15496','1','1','0','0','0','0','0','0','0','0','Time-Lost Skettis Reaver - Cast Cleave'),
('2165103','21651','2','0','100','0','30','0','0','0','11','3019','0','7','1','-106','0','0','0','0','0','0','Time-Lost Skettis Reaver - Cast Frenzy'),
('2165104','21651','7','0','100','0','0','0','0','0','11','37411','0','7','0','0','0','0','0','0','0','0','Time-Lost Skettis Reaver - Cast Skettis Corrupted Ghosts on Evade');
--
-- Time-Lost Skettis Worshipper 21763
UPDATE `creature_template` SET `AIName`='EventAI' WHERE `entry` = '21763'; --
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = '21763';
INSERT INTO `creature_ai_scripts` VALUES
('2176300','21763','4','0','100','0','0','0','0','0','28','0','37411','0','0','0','0','0','0','0','0','0','Time-Lost Skettis Worshipper - Cancel Skettis Corrupted Ghosts on Aggro'),
('2176301','21763','0','0','100','1','4000','8000','15000','20000','11','38167','1','0','0','0','0','0','0','0','0','0','Time-Lost Skettis Worshipper - Cast Curse of Blood'),
('2176302','21763','7','0','100','0','0','0','0','0','11','37411','0','7','0','0','0','0','0','0','0','0','Time-Lost Skettis Worshipper - Cast Skettis Corrupted Ghosts on Evade');
-- 
-- Skettis - Invis Raven Stone 22986 -- should be invis for player?

-- Skyguard Prisoner 23383
UPDATE `creature_template` SET `unit_flags` = 32833 WHERE `entry` = 23383;
UPDATE `creature` SET `spawnmask` = 0 WHERE `guid` = 138363; -- cant be used currently

-- Hungry Nether Ray 23439
-- misses eating animation on creature kill -> script
UPDATE `creature_template` SET `minlevel`='70',`maxlevel`='70',`minhealth`='7000',`maxhealth`='7000',`armor`='6800',`speed`='1.20',`mindmg`='0',`maxdmg`='0',`flags_extra`=`flags_extra`|'536870912' WHERE `entry` = '23439'; -- 85 180
--
-- Blackwind Sabercat 21723
UPDATE `creature_template` SET `mindmg`='473',`maxdmg`='567',`flags_extra`=`flags_extra`|'536870912' WHERE `entry` ='21723'; -- 83 177 -- 473 - 567
--
-- Monstrous Kaliri 23051
UPDATE `creature_template` SET `speed`='2.0',`inhabittype`='7' WHERE `entry` = '23051'; -- 1 3
DELETE FROM `creature_loot_template` WHERE `entry` = 23051 AND `item` IN (3827,6149,8932,8950,8952,22793,23112,23425);
DELETE FROM `creature_onkill_reputation` WHERE `creature_id` = '23051';
INSERT INTO `creature_onkill_reputation` VALUES
(23051,1031,0,7,0,10,0,0,0,0);
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = '23051';
INSERT INTO `creature_ai_scripts` VALUES
('2305101','23051','9','0','100','1','0','5','11000','14000','11','31553','1','0','0','0','0','0','0','0','0','0','Monstrous Kaliri - Cast Hamstring'),
('2305102','23051','0','0','100','1','7000','9000','17000','20000','11','13738','1','1','0','0','0','0','0','0','0','0','Monstrous Kaliri - Cast Rend'),
('2305103','23051','0','0','100','1','4000','5000','9000','12000','11','5708','0','1','0','0','0','0','0','0','0','0','Monstrous Kaliri - Cast Swoop');
--
-- Sahaak 23363
UPDATE `creature` SET `spawntimesecs`=300 WHERE `guid`= 44252;
-- should be 90 but spell is not changing faction
UPDATE `creature_template` SET `faction_A`=35,`faction_H`=35 WHERE `entry` = 16965;
UPDATE `creature_template` SET `faction_A`=35,`faction_H`=35 WHERE `entry` = 23363;
--
-- Skyguard Windcharger
-- guard_contested
UPDATE `creature_template` SET `mindmg`='800',`maxdmg`='1200',`equipment_id`='1638',`unit_flags`=`unit_flags`|'4096'|'64' WHERE `entry` = 23257; -- 98 209
--
-- Sky Commander Adaris & Severin <Skyguard Medic>
UPDATE `creature_template` SET `flags_extra`='2' WHERE `entry` IN (23038,23042);
--
-- Skyguard Quartermaster 23367
UPDATE `creature_template` SET `armor`='6800',`mindmg`='400',`maxdmg`='800',`flags_extra`='2' WHERE `entry` = '23367'; -- 138 188
--
-- Skyguard Handler Irena 23413
-- UPDATE `creature_template` SET  WHERE `entry` = '';
-- By Oozebull (5,923 – 3·10·36) on 2007/06/01 (Patch 2.1.0)        
-- When you obtain Honored Status with "Sha'tari Skyguard" she will offer a flight to "Skyguard Handler Deesak" ( //www.wowhead.com/?npc=23415 ) in Terokkar Forest.
--
-- Ogri'la Peacekeeper 23115
UPDATE `creature_template` SET `minhealth`='9600',`mindmg`='800',`maxdmg`='1600',`AIName`='EventAI',`equipment_id`='8041' WHERE `entry` = '23115'; -- violet 200 300
DELETE FROM `creature_template_addon` WHERE `entry` = '23115';
INSERT INTO `creature_template_addon` VALUES
(23115,0,0,0,0,4097,0,0,'');
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = '23115';
INSERT INTO `creature_ai_scripts` VALUES
('2311501','23115','9','0','100','1','0','15','16000','24000','11','12024','1','32','0','0','0','0','0','0','0','0','Ogri\'la Peacekeeper - Cast Net');
DELETE FROM `creature_equip_template` WHERE `entry` = '8041';
INSERT INTO `creature_equip_template` VALUES
(8041,40904,0,0,285345026,0,0,1,0,0);
--
-- Torkus 23316
UPDATE `creature_template` SET `equipment_id`='8042' WHERE `entry` = '23316'; --
DELETE FROM `creature_template_addon` WHERE `entry` = '23316';
INSERT INTO `creature_template_addon` VALUES
(23316,0,0,0,0,4097,0,0,'');
DELETE FROM `creature_equip_template` WHERE `entry` = '8042';
INSERT INTO `creature_equip_template` VALUES
(8042,38666,0,0,285346306,0,0,2,0,0);
--
-- Skyguard Scout 22980
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='400',`maxdmg`='600' WHERE `entry` = '22980'; -- 206 206

-- Eggs Visual
UPDATE `gameobject_template` SET `data5`='1' WHERE `entry` = 185549; -- 0 leider nix gebracht

-- Egg Quest Trigger NPC
UPDATE `creature` SET `spawntimesecs`='90' WHERE `id` = 22991;

-- Legion Flak Cannon 23076
UPDATE `creature_template` SET `unit_flags`='6',`dynamicflags`='8' WHERE `entry` = '23076'; -- 4 0
UPDATE `creature_ai_scripts` SET `action2_type`='20' WHERE `id` = 2307601;
--
-- Bombing Run Target Bunny 23118
-- UPDATE `creature_template` SET WHERE `entry` = '23118';
UPDATE `creature_ai_scripts` SET `event_type`='1',`action1_param3`='39' WHERE `id` = 2311801;
--
-- Wrath Speaker 22195
-- UPDATE `creature_template` SET  WHERE `entry` = '22195';
--
-- ===================
-- Bosses
-- ===================

-- Alluvion
UPDATE `creature` SET `position_x`='-3976.1193', `position_y`='3408.7819', `position_z`='263.0965', `orientation`='4.6395',`spawndist`='5',`movementtype`='1' WHERE `id` = '21730';
UPDATE `creature_template` SET `mindmg`='1600',`maxdmg`='2400',`dmgschool`= 4 WHERE `entry` = '21730'; -- 308 628 
UPDATE `creature_ai_scripts` SET `action1_param1`='1' WHERE `id` IN ('2173001','2173006');

-- Darkscreecher Akkarai 23161
UPDATE `creature_template` SET `speed`='1.71',`mindmg`='1070',`maxdmg`='1270',`AIName`='EventAI',`mechanic_immune_mask`='652951539',`flags_extra`='4259840',`equipment_id`='8039' WHERE `entry` = '23161'; --  385 785 -- 2,140 - 2,540
DELETE FROM `creature_equip_template` WHERE `entry` = '8039';
INSERT INTO `creature_equip_template` VALUES
(8039,22147,0,0,50268674,0,0,529,0,0); 
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = '23161';
INSERT INTO `creature_ai_scripts` VALUES
('2316101','23161','4','0','100','0','0','0','0','0','1','-9204','0','0','0','0','0','0','0','0','0','0','Darkscreecher Akkarai - Say on Aggro'),
('2316102','23161','9','0','100','1','0','50','5000','10000','11','40429','1','0','39','5','0','0','0','0','0','0','Darkscreecher Akkarai - Cast Frostbolt'),
('2316103','23161','0','0','100','1','2000','4000','8000','16000','11','40428','4','0','39','5','0','0','0','0','0','0','Darkscreecher Akkarai - Cast Shadow Bolt Volley'),
('2316104','23161','2','0','100','1','75','0','5000','10000','11','38981','0','0','0','0','0','0','0','0','0','0','Darkscreecher Akkarai - Cast Blink'),
('2316105','23161','0','0','100','1','2000','4000','5000','10000','11','15730','4','32','0','0','0','0','0','0','0','0','Darkscreecher Akkarai - Cast Curse of Mending'),
('2316106','23161','9','0','100','1','0','20','8000','12000','11','13341','1','0','0','0','0','0','0','0','0','0','Darkscreecher Akkarai - Cast Fire Blast'),
('2316107','23161','0','0','100','1','12000','12000','12000','12000','11','40427','0','7','1','-9205','0','0','0','0','0','0','Darkscreecher Akkarai - Cast Flock Call and Yell'),
('2316108','23161','0','0','100','1','12000','12000','12000','12000','12','23206','0','20000','12','23206','0','20000','12','23206','0','20000','Darkscreecher Akkarai - Cast Flock Call and Yell'),
('2316109','23161','0','0','100','1','12000','12000','12000','12000','12','23206','0','20000','12','23206','0','20000','12','23206','0','20000','Darkscreecher Akkarai - Cast Flock Call and Yell'),
('2316110','23161','1','0','100','1','20000','20000','1000','1000','41','0','0','0','0','0','0','0','0','0','0','0','Darkscreecher Akkarai - Despawn on OOC Timer');
--
-- Akkarai Hatchling 23206
UPDATE `creature_template` SET `faction_A`='16',`faction_H`='16' WHERE `entry` = '23206'; -- 35
--
-- Karrog 23165
UPDATE `creature_template` SET `speed`='1.71',`mindmg`='2308',`maxdmg`='2741',`unit_flags`='32832',`AIName`='EventAI',`mechanic_immune_mask`='652950515',`flags_extra`='4259840' WHERE `entry` = '23165'; --  829 1695 67141696 -- 4,615 - 5,481
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = '23165';
INSERT INTO `creature_ai_scripts` VALUES
('2316501','23165','4','0','100','0','0','0','0','0','1','-9206','0','0','0','0','0','0','0','0','0','0','Karrog - Say on Aggro'),
('2316502','23165','9','0','100','1','0','5','4000','8000','11','15550','0','7','0','0','0','0','0','0','0','0','Karrog - Cast Trample'), -- 15550 40488
('2316503','23165','0','0','100','1','10000','10000','20000','20000','11','40417','0','7','14','-99','0','0','13','100','4','0','Karrog - Cast Rage'),
('2316504','23165','0','0','100','1','10100','10100','20000','20000','11','40416','4','39','1','-9207','0','0','0','0','0','0','Karrog - Cast Fixated Rage and Emote'),
('2316505','23165','6','0','100','0','0','0','0','0','12','23205','0','10000','12','23205','0','10000','12','23205','0','10000','Karrog - Spawn Karrog Shardling on Death'),
('2316506','23165','1','0','100','1','20000','20000','1000','1000','41','0','0','0','0','0','0','0','0','0','0','0','Karrog - Despawn on OOC Timer');
--
-- Karrog Shardling 23205
-- When Karrog is slain, several shardlings spawn and run around. They can't be targeted, don't attack, and die after a few seconds.
UPDATE `creature_template` SET `faction_A`='35',`faction_H`='35',`unit_flags`='33554432',`AIName`='EventAI',`flags_extra`='2' WHERE `entry` = '23205'; 
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = '23205';
INSERT INTO `creature_ai_scripts` VALUES
('2320501','23205','9','0','100','1','0','5','4000','8000','11','40488','0','7','0','0','0','0','0','0','0','0','Karrog Shardling - Cast Trample');
--
-- Gezzarak the Huntress 23163
UPDATE `creature_template` SET `speed`='1.71',`mindmg`='1442',`maxdmg`='1713',`baseattacktime`='1500',`mechanic_immune_mask`='652950515',`flags_extra`='4194304' WHERE `entry` = '23163'; -- 518 1059 2000 -- 1442 - 1713
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = '23163';
INSERT INTO `creature_ai_scripts` VALUES
('2316301','23163','11','0','100','0','0','0','0','0','1','-236','0','0','0','0','0','0','0','0','0','0','Gezzarak the Huntress - Emote when Spawned'),
('2316302','23163','0','0','100','1','1000','1000','12000','18000','11','40542','1','1','0','0','0','0','0','0','0','0','Gezzarak the Huntress - Cast Warped Armor'),
('2316303','23163','0','0','100','1','4000','7000','9500','15000','11','40434','1','1','0','0','0','0','0','0','0','0','Gezzarak the Huntress - Cast Knock Away'),
('2316304','23163','0','0','100','1','10000','10000','10500','10500','14','-99','0','0','13','100','4','0','1','-237','0','0','Gezzarak the Huntress - Reset Threat and Set Random Threat and Emote'),
('2316305','23163','0','0','100','1','10500','10500','10500','10500','11','40432','1','1','0','0','0','0','0','0','0','0','Gezzarak the Huntress - Cast Warp combo I'),
('2316306','23163','0','0','100','1','11000','11000','10500','10500','11','40542','1','7','11','40433','1','7','0','0','0','0','Gezzarak the Huntress - Cast Warp Rift combo II'),
('2316307','23163','1','0','100','1','20000','20000','1000','1000','41','0','0','0','0','0','0','0','0','0','0','0','Gezzarak the Huntress - Despawn on OOC Timer');
--
-- Vakkiz the Windrager 23162
UPDATE `creature_template` SET `speed`='1.71',`mindmg`='2371',`maxdmg`='2762',`mechanic_immune_mask`='652950515',`flags_extra`='4259840' WHERE `entry` = '23162'; -- 558 1046 -- 2,964 - 3,452
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = '23162';
INSERT INTO `creature_ai_scripts` VALUES
('2316201','23162','11','0','100','0','0','0','0','0','1','-234','0','0','22','1','0','0','0','0','0','0','Vakkiz the Windrager - Emote and Set Phase 1 on Spawn'),
('2316202','23162','0','5','100','1','6500','9500','8500','11500','11','40420','1','1','0','0','0','0','0','0','0','0','Vakkiz the Windrager - Cast Lightning Breath (Phase 1)'),
('2316203','23162','2','5','100','0','40','0','0','0','3','23204','0','0','1','-235','0','0','22','2','0','0','Vakkiz the Windrager - Transform into Bone Form at 40% HP (Phase 1)'),
-- ('2316203','23162','2','5','100','0','40','0','0','0','17','66','21296','0','1','-235','0','0','22','1','0','0','Vakkiz the Windrager - Transform into Bone Form at 40% HP (Phase 1)')
('2316204','23162','0','3','100','1','3000','7000','4000','7000','11','40419','1','1','0','0','0','0','0','0','0','0','Vakkiz the Windrager - Cast Bone Spray (Phase 2)'),
('2316205','23162','6','0','100','0','0','0','0','0','3','0','0','0','0','0','0','0','0','0','0','0','Vakkiz the Windrager - Transform into Serpant Form on Death'),
('2316206','23162','7','0','100','0','0','0','0','0','3','0','0','0','0','0','0','0','0','0','0','0','Vakkiz the Windrager - Transform into Serpant Form on Evade'),
('2316207','23162','1','0','100','1','20000','20000','1000','1000','41','0','0','0','0','0','0','0','0','0','0','0','Vakkiz the Windrager - Despawn on OOC Timer');
--
-- Terok 21838 mob_terokk
UPDATE `creature_template` SET `speed`='1.20',`scale`='1.50',`mindmg`='2884',`maxdmg`='3426',`baseattacktime`='1400',`equipment_id`='8040',`mechanic_immune_mask`='652951551',`flags_extra`='4259840' WHERE `entry` = '21838'; -- 1036 2119 -- 5,768 - 6,851
DELETE FROM `creature_template_addon` WHERE `entry` = '21838';
INSERT INTO `creature_template_addon` VALUES
(21838,0,0,512,0,4097,0,0,'22917 0 22917 1');
DELETE FROM `creature_equip_template` WHERE `entry` = '8040';
INSERT INTO `creature_equip_template` VALUES
(8040,31867,0,0,33490690,0,0,781,0,0);
-- wowhead.com/npc=21838/terokk , http://wowwiki.wikia.com/wiki/Terokk?oldid=833653 , http://wowwiki.wikia.com/wiki/Terokk?direction=next&oldid=1097272
-- Respawn time on Ancient Skull Pile is 15 minutes. 72Elite ~ 220,000 
-- on summon or aggro: Terokk says: Who calls me to this world? The stars are not yet aligned... my powers fail me! You will pay for this! <-- It is a Zone Yell
-- Loot: His loot table consists of random modifier level 70 req boe blues. Unlike most world spawns however, his random modifiers are actually really nice, out of 5 kills have gotten all really nice stuff
-- He hits on plate for around 500-1500 damage
-- ~ 500 reputation with Sha'tari Skyguard ~2.2
-- http://www.wowhead.com/spell=40726/chosen-one say/yell: "Show me how tough you are, <name>!", http://www.wowhead.com/spell=15284/cleave , http://www.wowhead.com/spell=40733/divine-shield
-- http://www.wowhead.com/spell=28747/frenzy , http://www.wowhead.com/spell=40721/shadow-bolt-volley 10-15 seconds for around 1k-1.5k damage, http://www.wowhead.com/spell=40722/will-of-the-arakkoa-god

-- Hawkbane

-- ======================================================
-- Spawns & Pooling
-- ======================================================
--
-- free 79006
--
DELETE FROM `creature` WHERE `guid` BETWEEN 132572 AND 132608; -- 132573 frei
DELETE FROM `creature` WHERE `guid` BETWEEN 132781 AND 132813; 
DELETE FROM `creature` WHERE `guid` BETWEEN 132539 AND 132552;
--
--
-- Bad sniffed Trinity Data
UPDATE `creature` SET `id`='21644',`spawndist`='5',`MovementType`='1',`curhealth`='6896' WHERE `guid` BETWEEN 76677 AND 76696; -- MELEE were 21912 höchstens bei Terok 4 stück oder so
UPDATE `creature` SET `id`='21650',`spawndist`='0',`MovementType`='0',`curhealth`='6896' WHERE `guid` BETWEEN 76774 AND 76794; -- RANGE 21985 machen gar keinen Sinn ALL Patrols
-- UPDATE `creature` SET `id`='' WHERE `guid` IN (); -- CASTER
--
DELETE FROM `creature` WHERE `guid` IN (75622,75481,85687,85692,16777294)
DELETE FROM `creature` WHERE `guid` BETWEEN 100033 AND 100041;
INSERT INTO `creature` VALUES 
(75481, 21644, 530, 1, 0, 0, -3649.21, 3751.41, 303.018, 1.29154, 300, 0, 0, 6986, 0, 0, 0),
(75622, 21652, 530, 1, 0, 0, -3984.33, 3133.34, 363.591, 3.08923, 300, 0, 0, 5744, 3231, 0, 0),
(100033,23207,530,1,0,0,-3386.092041,3598.254639,276.023041,2.9944,300,5,0,9335,0,0,1),
(100034,23207,530,1,0,0,-3396.191650,3585.681641,276.131866,1.9145,300,5,0,9335,0,0,1),
(100035,23207,530,1,0,0,-3399.277832,3614.965820,276.329529,2.4015,300,5,0,9335,0,0,1),
(100036,21654, 530, 1, 0, 0, -3810.7687, 3768.8693, 275.4646, 5.1103, 300, 0, 0, 6986, 0, 0, 0),
(100037,21654, 530, 1, 0, 0, -3923.2890, 3020.4277, 357.6200, 0.9633, 300, 0, 0, 6986, 0, 0, 0),
(100038,23055, 530, 1, 0, 0, 2731.6594, 7146.6059, 364.9397, 2.7457, 300, 0, 0, 6986, 0, 0, 0);

INSERT INTO `creature` VALUES (85687, 23076, 530, 1, 0, 0, 2946.3, 6875.71, 370.04, 3.2148, 300, 0, 0, 22140, 0, 0, 0);
INSERT INTO `creature` VALUES (85692, 23076, 530, 1, 0, 0, 3028.22, 6807.09, 374.075, 5.94641, 300, 0, 0, 22140, 0, 0, 0);
INSERT INTO `creature` VALUES (100039, 23076, 530, 1, 0, 0, 2982.59, 6886.5, 370.082, 0.831123, 300, 0, 0, 22140, 0, 0, 0);
INSERT INTO `creature` VALUES (100040, 23076, 530, 1, 0, 0, 2834.14, 7018.43, 368.459, 5.42992, 300, 0, 0, 21543, 0, 0, 0);
INSERT INTO `creature` VALUES (100041, 23076, 530, 1, 0, 0, 2994.48, 7039.91, 369.42, 5.26077, 300, 0, 0, 22140, 0, 0, 0);

-- 1000XX 23383 npc_skyguard_prisoner
-- 1000XX 23383 npc_skyguard_prisoner two more different paths need + cage + xyz event

--
INSERT INTO `creature` VALUES (132597, 21787, 530, 1, 0, 0, -3981.25, 3134.06, 363.35, 1.11851, 180, 5, 0, 5744, 3231, 0, 1);
INSERT INTO `creature` VALUES (132588, 21787, 530, 1, 0, 0, -3652.21, 3750.04, 302.07, 3.72422, 180, 5, 0, 5744, 3231, 0, 1);
INSERT INTO `creature` VALUES (132589, 21787, 530, 1, 0, 0, -3868.04, 3675.77, 335.904, 5.61996, 180, 0, 0, 5744, 3231, 0, 0);
INSERT INTO `creature` VALUES (132590, 21787, 530, 1, 0, 0, -3856.78, 3784.41, 334.808, 3.27176, 180, 5, 0, 5744, 3231, 0, 1);
INSERT INTO `creature` VALUES (132599, 21787, 530, 1, 0, 0, -4008.98, 3126.44, 362.605, 0.628319, 180, 0, 0, 5744, 3231, 0, 0);
INSERT INTO `creature` VALUES (132608, 21787, 530, 1, 0, 0, -3689.96, 3739.63, 278.505, 2.46821, 180, 5, 0, 5744, 3231, 0, 1);
INSERT INTO `creature` VALUES (132601, 21787, 530, 1, 0, 0, -3888.01, 3080.66, 373.795, 2.35619, 180, 0, 0, 5744, 3231, 0, 0);
INSERT INTO `creature` VALUES (132604, 21787, 530, 1, 0, 0, -3928.49, 3024, 356.789, 3.38834, 180, 5, 0, 5744, 3231, 0, 1);
INSERT INTO `creature` VALUES (132603, 21787, 530, 1, 0, 0, -3905.07, 3118.49, 328.602, 1.05528, 180, 5, 0, 5744, 3231, 0, 1);
INSERT INTO `creature` VALUES (132606, 21787, 530, 1, 0, 0, -3860.19, 3299.72, 274.4, 2.79491, 180, 5, 0, 5744, 3231, 0, 1);
INSERT INTO `creature` VALUES (132600, 21787, 530, 1, 0, 0, -3912.38, 3095.58, 374.718, 5.33981, 180, 5, 0, 5744, 3231, 0, 1);
INSERT INTO `creature` VALUES (132605, 21787, 530, 1, 0, 0, -3823.37, 3332.76, 324.128, 5.96903, 180, 0, 0, 5744, 3231, 0, 0);
INSERT INTO `creature` VALUES (132602, 21787, 530, 1, 0, 0, -3894.91, 3109.16, 374.639, 5.7573, 180, 5, 0, 5744, 3231, 0, 1);
INSERT INTO `creature` VALUES (132572, 21787, 530, 1, 0, 0, -3888.48, 3686.15, 335.73, 0.012985, 180, 0, 0, 5744, 3231, 0, 0);
INSERT INTO `creature` VALUES (132578, 21787, 530, 1, 0, 0, -4172.24, 3180.69, 315.689, 0.797436, 180, 5, 0, 5744, 3231, 0, 1);
INSERT INTO `creature` VALUES (132579, 21787, 530, 1, 0, 0, -4119.26, 3012.94, 344.139, 0.269749, 180, 5, 0, 5744, 3231, 0, 1);
INSERT INTO `creature` VALUES (132575, 21787, 530, 1, 0, 0, -4073.67, 3189.92, 296.58, 5.52521, 180, 5, 0, 5744, 3231, 0, 1);
INSERT INTO `creature` VALUES (132580, 21787, 530, 1, 0, 0, -3689.91, 3322.45, 283.165, 3.8139, 180, 5, 0, 5744, 3231, 0, 1);
INSERT INTO `creature` VALUES (132581, 21787, 530, 1, 0, 0, -3703.61, 3307.41, 312.231, 2.68364, 180, 5, 0, 5744, 3231, 0, 1);
INSERT INTO `creature` VALUES (132607, 21787, 530, 1, 0, 0, -3831.4, 3353.79, 324.05, 3.65661, 180, 5, 0, 5744, 3231, 0, 1);
INSERT INTO `creature` VALUES (132598, 21787, 530, 1, 0, 0, -4065.68, 3273.31, 332.931, 5.70723, 180, 0, 0, 5744, 3231, 0, 0);
INSERT INTO `creature` VALUES (132594, 21787, 530, 1, 0, 0, -3940.65, 3222.22, 334.057, 3.14159, 180, 0, 0, 5744, 3231, 0, 0);
INSERT INTO `creature` VALUES (132595, 21787, 530, 1, 0, 0, -3962.31, 3243.75, 333.492, 2.70791, 180, 5, 0, 5744, 3231, 0, 1);
INSERT INTO `creature` VALUES (132576, 21787, 530, 1, 0, 0, -4096.88, 3018.4, 344.202, 4.29351, 180, 0, 0, 5744, 3231, 0, 0);
INSERT INTO `creature` VALUES (132596, 21787, 530, 1, 0, 0, -4038.8, 3258.21, 332.854, 5.57701, 180, 5, 0, 5744, 3231, 0, 1);
INSERT INTO `creature` VALUES (132584, 21787, 530, 1, 0, 0, -3668.44, 3371.38, 312.609, 3.98343, 180, 5, 0, 5744, 3231, 0, 1);
INSERT INTO `creature` VALUES (132582, 21787, 530, 1, 0, 0, -3668.63, 3395.73, 312.211, 4.53786, 180, 0, 0, 5744, 3231, 0, 0);
INSERT INTO `creature` VALUES (132583, 21787, 530, 1, 0, 0, -3649.2, 3379.72, 312.337, 1.02974, 180, 0, 0, 5744, 3231, 0, 0);
INSERT INTO `creature` VALUES (132585, 21787, 530, 1, 0, 0, -3687.17, 3287.76, 312.312, 2.60054, 180, 0, 0, 5744, 3231, 0, 0);
INSERT INTO `creature` VALUES (132591, 21787, 530, 1, 0, 0, -3705.89, 3787.89, 302.813, 3.03866, 180, 5, 0, 5744, 3231, 0, 1);
INSERT INTO `creature` VALUES (132592, 21787, 530, 1, 0, 0, -3882.73, 3661.17, 335.997, 4.62512, 180, 0, 0, 5744, 3231, 0, 0);
INSERT INTO `creature` VALUES (132593, 21787, 530, 1, 0, 0, -3727.48, 3789.05, 302.126, 5.34071, 180, 0, 0, 5744, 3231, 0, 0);
INSERT INTO `creature` VALUES (132586, 21787, 530, 1, 0, 0, -3707.91, 3807.72, 302.27, 2.58309, 180, 0, 0, 5744, 3231, 0, 0);
INSERT INTO `creature` VALUES (132587, 21787, 530, 1, 0, 0, -3886.83, 3783.83, 334.878, 2.05949, 180, 0, 0, 5744, 3231, 0, 0);
INSERT INTO `creature` VALUES (132577, 21787, 530, 1, 0, 0, -4184.73, 3057.09, 344.165, 3.68932, 180, 5, 0, 5744, 3231, 0, 1);
INSERT INTO `creature` VALUES (132574, 21787, 530, 1, 0, 0, -4153.82, 3042.43, 315.881, 3.34082, 180, 5, 0, 5744, 3231, 0, 1);
--
INSERT INTO `creature` VALUES (132781, 21651, 530, 1, 0, 0, -4147.02, 3048.13, 314.756, 1.7099, 180, 5, 0, 7181, 0, 0, 1);
INSERT INTO `creature` VALUES (132782, 21651, 530, 1, 0, 0, -4112.76, 3033.49, 344.448, 3.15194, 180, 5, 0, 7181, 0, 0, 1);
INSERT INTO `creature` VALUES (132783, 21651, 530, 1, 0, 0, -4098.58, 3014.3, 344.291, 1.13446, 180, 0, 0, 7181, 0, 0, 0);
INSERT INTO `creature` VALUES (132784, 21651, 530, 1, 0, 0, -4176.09, 3038.24, 343.674, 6.17941, 180, 5, 0, 7181, 0, 0, 1);
INSERT INTO `creature` VALUES (132785, 21651, 530, 1, 0, 0, -4201.8, 3048.26, 344.139, 4.2222, 180, 5, 0, 7181, 0, 0, 1);
INSERT INTO `creature` VALUES (132786, 21651, 530, 1, 0, 0, -4176.15, 3186, 315.189, 0.123457, 180, 5, 0, 7181, 0, 0, 1);
INSERT INTO `creature` VALUES (132787, 21651, 530, 1, 0, 0, -3669.3, 3390.64, 312.961, 1.48353, 180, 0, 0, 7181, 0, 0, 0);
INSERT INTO `creature` VALUES (132788, 21651, 530, 1, 0, 0, -3691.59, 3290.75, 312.3, 5.70723, 180, 0, 0, 7181, 0, 0, 0);
INSERT INTO `creature` VALUES (132789, 21651, 530, 1, 0, 0, -3682.13, 3317.18, 311.703, 2.16765, 180, 5, 0, 7181, 0, 0, 1);
INSERT INTO `creature` VALUES (132790, 21651, 530, 1, 0, 0, -3647.5, 3383.45, 312.345, 4.2237, 180, 0, 0, 7181, 0, 0, 0);
INSERT INTO `creature` VALUES (132791, 21651, 530, 1, 0, 0, -3711.1, 3809.29, 302.272, 6.10865, 180, 0, 0, 7181, 0, 0, 0);
INSERT INTO `creature` VALUES (132792, 21651, 530, 1, 0, 0, -3889.44, 3788.59, 334.885, 5.25344, 180, 0, 0, 7181, 0, 0, 0);
INSERT INTO `creature` VALUES (132793, 21651, 530, 1, 0, 0, -3629.73, 3753.23, 302.146, 2.28489, 180, 5, 0, 7181, 0, 0, 1);
INSERT INTO `creature` VALUES (132794, 21651, 530, 1, 0, 0, -3643.24, 3771.67, 301.829, 1.12922, 180, 5, 0, 7181, 0, 0, 1);
INSERT INTO `creature` VALUES (132795, 21651, 530, 1, 0, 0, -3725.2, 3785.74, 302.199, 2.23402, 180, 0, 0, 7181, 0, 0, 0);
INSERT INTO `creature` VALUES (132796, 21651, 530, 1, 0, 0, -3899.41, 3680.73, 335.81, 2.39109, 180, 5, 0, 7181, 0, 0, 1);
INSERT INTO `creature` VALUES (132797, 21651, 530, 1, 0, 0, -3862.81, 3671.75, 335.951, 2.47837, 180, 0, 0, 7181, 0, 0, 0);
INSERT INTO `creature` VALUES (132798, 21651, 530, 1, 0, 0, -3883.7, 3654.49, 336.01, 1.41372, 180, 0, 0, 7181, 0, 0, 0);
INSERT INTO `creature` VALUES (132799, 21651, 530, 1, 0, 0, -3882.21, 3753.61, 334.807, 4.22583, 180, 5, 0, 7181, 0, 0, 1);
INSERT INTO `creature` VALUES (132800, 21651, 530, 1, 0, 0, -4049.61, 3296.16, 332.852, 4.94173, 180, 5, 0, 7181, 0, 0, 1);
INSERT INTO `creature` VALUES (132801, 21651, 530, 1, 0, 0, -4059.92, 3269.66, 332.927, 2.58309, 180, 0, 0, 7181, 0, 0, 0);
INSERT INTO `creature` VALUES (132802, 21651, 530, 1, 0, 0, -3946.89, 3222, 334.047, 0.034907, 180, 0, 0, 7181, 0, 0, 0);
INSERT INTO `creature` VALUES (132803, 21651, 530, 1, 0, 0, -3976.7, 3217.71, 333.824, 5.49841, 180, 5, 0, 7181, 0, 0, 1);
INSERT INTO `creature` VALUES (132804, 21651, 530, 1, 0, 0, -3884.69, 3111.29, 362.534, 3.82302, 180, 5, 0, 7181, 0, 0, 1);
INSERT INTO `creature` VALUES (132805, 21651, 530, 1, 0, 0, -3998.81, 3150.83, 363.331, 6.0169, 180, 5, 0, 7181, 0, 0, 1);
INSERT INTO `creature` VALUES (132806, 21651, 530, 1, 0, 0, -3893.43, 3075.96, 362.592, 3.08923, 180, 0, 0, 7181, 0, 0, 0);
INSERT INTO `creature` VALUES (132807, 21651, 530, 1, 0, 0, -4002.44, 3127.34, 363.567, 3.76991, 180, 0, 0, 7181, 0, 0, 0);
INSERT INTO `creature` VALUES (132808, 21651, 530, 1, 0, 0, -3906.72, 3111.91, 328.477, 1.78354, 180, 5, 0, 7181, 0, 0, 1);
INSERT INTO `creature` VALUES (132809, 21651, 530, 1, 0, 0, -3894.04, 3086.47, 374.747, 5.53269, 180, 0, 0, 7181, 0, 0, 0);
INSERT INTO `creature` VALUES (132810, 21651, 530, 1, 0, 0, -3920.92, 3017.97, 356.789, 4.39217, 180, 5, 0, 7181, 0, 0, 1);
INSERT INTO `creature` VALUES (132811, 21651, 530, 1, 0, 0, -3852.52, 3323.43, 324.054, 1.04193, 180, 5, 0, 7181, 0, 0, 1);
INSERT INTO `creature` VALUES (132812, 21651, 530, 1, 0, 0, -3818.04, 3330.86, 324.138, 2.79253, 180, 0, 0, 7181, 0, 0, 0);
INSERT INTO `creature` VALUES (132813, 21651, 530, 1, 0, 0, -3685.91, 3733.82, 279.505, 4.67674, 180, 5, 0, 7181, 0, 0, 1);
--
INSERT INTO `creature` VALUES (132542, 21763, 530, 1, 0, 0, -4165.78, 3043.88, 314.137, 4.09046, 180, 5, 0, 5744, 3231, 0, 1);
INSERT INTO `creature` VALUES (132544, 21763, 530, 1, 0, 0, -4162.6, 3135.13, 317.82, 1.70399, 180, 5, 0, 5744, 3231, 0, 1);
INSERT INTO `creature` VALUES (132545, 21763, 530, 1, 0, 0, -3676.85, 3323.91, 283.683, 2.6417, 180, 5, 0, 5744, 3231, 0, 1);
INSERT INTO `creature` VALUES (132546, 21763, 530, 1, 0, 0, -3689.46, 3353.99, 283.803, 1.25522, 180, 5, 0, 5744, 3231, 0, 1);
INSERT INTO `creature` VALUES (132543, 21763, 530, 1, 0, 0, -4061.73, 3158.32, 299.835, 2.2989, 180, 5, 0, 5744, 3231, 0, 1);
INSERT INTO `creature` VALUES (132539, 21763, 530, 1, 0, 0, -3955.25, 3120.99, 341.185, 3.06961, 180, 5, 0, 5744, 3231, 0, 1);
INSERT INTO `creature` VALUES (132547, 21763, 530, 1, 0, 0, -4079.7, 3355.62, 284.948, 4.04741, 180, 5, 0, 5744, 3231, 0, 1);
INSERT INTO `creature` VALUES (132540, 21763, 530, 1, 0, 0, -3998.51, 3017.21, 359.422, 4.61651, 180, 5, 0, 5744, 3231, 0, 1);
INSERT INTO `creature` VALUES (132541, 21763, 530, 1, 0, 0, -4075.33, 3114.4, 314.683, 3.89314, 180, 5, 0, 5744, 3231, 0, 1);
INSERT INTO `creature` VALUES (132550, 21763, 530, 1, 0, 0, -3846.77, 3292.91, 274.808, 0.36994, 180, 5, 0, 5744, 3231, 0, 1);
INSERT INTO `creature` VALUES (132548, 21763, 530, 1, 0, 0, -3944.63, 3053.94, 354.48, 5.54064, 180, 5, 0, 5744, 3231, 0, 1);
INSERT INTO `creature` VALUES (132549, 21763, 530, 1, 0, 0, -3917.16, 3059.94, 359.78, 4.43946, 180, 5, 0, 5744, 3231, 0, 1);
INSERT INTO `creature` VALUES (132551, 21763, 530, 1, 0, 0, -3677.84, 3715.54, 277.269, 2.78555, 180, 5, 0, 5744, 3231, 0, 1);
INSERT INTO `creature` VALUES (132552, 21763, 530, 1, 0, 0, -3825.59, 3781.83, 277.049, 2.53055, 180, 5, 0, 5744, 3231, 0, 1);
--
-- only delete for starts
DELETE FROM `creature` WHERE `guid` IN (76131);
--
DELETE FROM `creature` WHERE `guid` IN (58309,75640,75647,75654,16272649,75668,75683,75734,75735,75736);
INSERT INTO `creature` VALUES (58309, 16879, 530, 1, 0, 0, 94.267, 2015.86, 49.3259, 5.91047, 300, 5, 0, 3989, 0, 0, 1);
INSERT INTO `creature` VALUES (75640, 21654, 530, 1, 0, 0, -3688.07, 3736.21, 280.242, 4.20624, 300, 0, 0, 6900, 0, 0, 0);
INSERT INTO `creature` VALUES (75647, 21655, 530, 1, 0, 0, -2073.21, 5325.57, -37.2402, 3.75246, 300, 0, 0, 6600, 0, 0, 0);
INSERT INTO `creature` VALUES (75654, 21657, 530, 1, 0, 0, -3938.61, 876.176, 113.994, 4.27906, 300, 0, 0, 6400, 0, 0, 0);
INSERT INTO `creature` VALUES (75668, 21660, 530, 1, 0, 0, -3016.52, 5405.92, -15.7536, 6.03252, 300, 5, 0, 4422, 2620, 0, 1);
INSERT INTO `creature` VALUES (75683, 21661, 530, 1, 0, 0, -2904.03, 5378.85, -9.34792, 4.72984, 300, 0, 0, 5527, 0, 0, 0);
INSERT INTO `creature` VALUES (75734, 21912, 530, 1, 0, 0, -3777.8046, 3497.4531, 287.0067, 2.4129, 180, 0, 0, 7380, 0, 0, 0);
INSERT INTO `creature` VALUES (75735, 21912, 530, 1, 0, 0, -3778.1572, 3519.8149, 286.5412, 4.0190, 180, 0, 0, 7380, 0, 0, 0);
INSERT INTO `creature` VALUES (75736, 21912, 530, 1, 0, 0, -3799.4816, 3496.8359, 287.0371, 0.8185, 180, 0, 0, 7380, 0, 0, 0);
--
-- Trees 23029 / Giants 21844 Phasing
DELETE FROM `creature` WHERE `guid` IN (133904,133905,133906,1189277,1189278,1189279,1189280);
INSERT INTO `creature` VALUES (1189277, 23029, 530, 1, 0, 0, -3902.27, 3217.01, 307.271, 2.03121, 600, 10, 0, 28564, 0, 0, 2);
INSERT INTO `creature` VALUES (1189278, 23029, 530, 1, 0, 0, -4118.27, 3484.11, 284.092, 0.41561, 600, 15, 0, 28564, 0, 0, 1);
INSERT INTO `creature` VALUES (1189279, 23029, 530, 1, 0, 0, -3642.52, 3392.58, 287.509, 2.34851, 600, 10, 0, 28564, 0, 0, 1);
INSERT INTO `creature` VALUES (1189280, 23029, 530, 1, 0, 0, -3856.31, 3724.59, 283.373, 5.27961, 600, 15, 0, 28564, 0, 0, 1);
INSERT INTO `creature` VALUES (133904, 23029, 530, 1, 0, 0, -3759.1, 3689.65, 278.67, 3.10542, 600, 0, 0, 28564, 0, 0, 2);
INSERT INTO `creature` VALUES (133905, 23029, 530, 1, 0, 0, -4164.4101, 3331.9055, 273.7238, 5.1639, 600, 15, 0, 28564, 0, 0, 1);
INSERT INTO `creature` VALUES (133906, 23029, 530, 1, 0, 0, -4007.9877, 3214.5004, 297.6347, 0.1490, 600, 15, 0, 28564, 0, 0, 1);
--
DELETE FROM `creature` WHERE `id` = 23219;
INSERT INTO `creature` VALUES (79018, 23219, 530, 1, 0, 0, -3440.93, 3488.12, 283.028, 0.891235, 180, 5, 0, 6761, 0, 0, 1);
INSERT INTO `creature` VALUES (79019, 23219, 530, 1, 0, 0, -3583.43, 3482.01, 286.535, 3.30835, 300, 5, 0, 6761, 0, 0, 1);
INSERT INTO `creature` VALUES (79020, 23219, 530, 1, 0, 0, -3607.32, 3445.24, 298.612, 2.93425, 180, 5, 0, 6761, 0, 0, 1);
INSERT INTO `creature` VALUES (129312, 23219, 530, 1, 0, 0, -3634.82, 3379.82, 291.032, 2.71355, 300, 5, 0, 6761, 0, 0, 1);
INSERT INTO `creature` VALUES (129805, 23219, 530, 1, 0, 0, -3608.42, 3723.94, 285.139, 4.66683, 180, 5, 0, 6761, 0, 0, 1);
INSERT INTO `creature` VALUES (129949, 23219, 530, 1, 0, 0, -3802.26, 3697.66, 280.866, 3.49816, 300, 5, 0, 6761, 0, 0, 1);
INSERT INTO `creature` VALUES (130214, 23219, 530, 1, 0, 0, -3836.36, 3730, 286.272, 2.63736, 180, 5, 0, 6761, 0, 0, 1);
INSERT INTO `creature` VALUES (130247, 23219, 530, 1, 0, 0, -3883.67, 3745.63, 292.784, 2.64915, 300, 5, 0, 6761, 0, 0, 1);
INSERT INTO `creature` VALUES (130292, 23219, 530, 1, 0, 0, -3920.27, 3720.06, 297.052, 2.63894, 180, 5, 0, 6761, 0, 0, 1);
INSERT INTO `creature` VALUES (130667, 23219, 530, 1, 0, 0, -3893.73, 3792.24, 292.951, 0.571764, 300, 5, 0, 6761, 0, 0, 1);
INSERT INTO `creature` VALUES (130806, 23219, 530, 1, 0, 0, -3979.55, 3670, 286.215, 4.05029, 180, 5, 0, 6761, 0, 0, 1);
INSERT INTO `creature` VALUES (130882, 23219, 530, 1, 0, 0, -4018.53, 3618.23, 286.898, 0.632237, 300, 5, 0, 6761, 0, 0, 1);
INSERT INTO `creature` VALUES (131584, 23219, 530, 1, 0, 0, -4068.78, 3574.63, 293.435, 4.13511, 180, 5, 0, 6761, 0, 0, 1);
INSERT INTO `creature` VALUES (131598, 23219, 530, 1, 0, 0, -4065.77, 3503.08, 284.04, 4.80192, 300, 5, 0, 6761, 0, 0, 1);
INSERT INTO `creature` VALUES (131638, 23219, 530, 1, 0, 0, -4129.3, 3469.95, 283.585, 3.86022, 180, 5, 0, 6761, 0, 0, 1);
INSERT INTO `creature` VALUES (131922, 23219, 530, 1, 0, 0, -4133.68, 3398.16, 291.372, 1.65011, 300, 5, 0, 6761, 0, 0, 1);
INSERT INTO `creature` VALUES (132294, 23219, 530, 1, 0, 0, -4200.89, 3338.65, 274.523, 6.18422, 180, 5, 0, 6761, 0, 0, 1);
INSERT INTO `creature` VALUES (132849, 23219, 530, 1, 0, 0, -4237.2338, 3102.6035, 328.4243, 2.99799, 300, 5, 0, 6761, 0, 0, 1);
INSERT INTO `creature` VALUES (132850, 23219, 530, 1, 0, 0, -4137.1728, 3287.8635, 290.7980, 2.68416, 180, 5, 0, 6761, 0, 0, 1);
INSERT INTO `creature` VALUES (132851, 23219, 530, 1, 0, 0, -4092.1550, 3599.6467, 316.5168, 2.91249, 300, 5, 0, 6761, 0, 0, 1);
INSERT INTO `creature` VALUES (132852, 23219, 530, 1, 0, 0, -4144.58, 3554.15, 319.213, 5.5717, 180, 5, 0, 6761, 0, 0, 1);
INSERT INTO `creature` VALUES (132853, 23219, 530, 1, 0, 0, -4017.68, 3682.79, 300.721, 5.80542, 300, 5, 0, 6761, 0, 0, 1);
INSERT INTO `creature` VALUES (132854, 23219, 530, 1, 0, 0, -4120.2, 3440.34, 291.884, 4.48779, 180, 5, 0, 6761, 0, 0, 1);
INSERT INTO `creature` VALUES (132855, 23219, 530, 1, 0, 0, -3632.9843, 3463.4431, 282.0582, 0.129198, 300, 5, 0, 6761, 0, 0, 1);
INSERT INTO `creature` VALUES (132856, 23219, 530, 1, 0, 0, -3606.9685, 3667.4157, 278.5224, 1.72623, 180, 5, 0, 6761, 0, 0, 1);
INSERT INTO `creature` VALUES (132857, 23219, 530, 1, 0, 0, -4042.1699, 3589.7790, 286.7981, 6.24117, 300, 5, 0, 6761, 0, 0, 1);

UPDATE `creature` SET `spawntimesecs`= 1800 WHERE `id` = 23029;
DELETE FROM `pool_template` WHERE `entry` = 30047;
INSERT INTO `pool_template` VALUES (30047,5,'Skettis - Mountain Colossus / Talonsworn Forest-Rager');
DELETE FROM `pool_creature` WHERE `pool_entry` = 30047;
INSERT INTO `pool_creature` VALUES
(133900,30047,0,'Skettis - Mountain Colossus / Talonsworn Forest-Rager'),
(133901,30047,0,'Skettis - Mountain Colossus / Talonsworn Forest-Rager'),
(133902,30047,0,'Skettis - Mountain Colossus / Talonsworn Forest-Rager'),
(133903,30047,0,'Skettis - Mountain Colossus / Talonsworn Forest-Rager'),
(133904,30047,0,'Skettis - Mountain Colossus / Talonsworn Forest-Rager'),
(133905,30047,0,'Skettis - Mountain Colossus / Talonsworn Forest-Rager'),
(133906,30047,0,'Skettis - Mountain Colossus / Talonsworn Forest-Rager'),
(1189277,30047,0,'Skettis - Mountain Colossus / Talonsworn Forest-Rager'),
(1189278,30047,0,'Skettis - Mountain Colossus / Talonsworn Forest-Rager'),
(1189279,30047,0,'Skettis - Mountain Colossus / Talonsworn Forest-Rager'),
(1189280,30047,0,'Skettis - Mountain Colossus / Talonsworn Forest-Rager'),
(150577,30047,0,'Skettis - Mountain Colossus / Talonsworn Forest-Rager'),
(150578,30047,0,'Skettis - Mountain Colossus / Talonsworn Forest-Rager'),
(150579,30047,0,'Skettis - Mountain Colossus / Talonsworn Forest-Rager'),
(150580,30047,0,'Skettis - Mountain Colossus / Talonsworn Forest-Rager');

-- ======================================================
-- Linking
-- ======================================================
--
DELETE FROM `creature_formations` WHERE `leaderguid` IN (79023,79025,79028,79027,79026,79024,79010,79012,79001,79002,79003,75944,75611,76161,75612,76160,76794,76159,76793,76158,76792,76157,76791,76156,76790,76154,76788,76153,76787,76152,76786,76151,76785,76150,76784,76149,76783,76148,75610,76147,76782,76146,76781,76145,75609,76144,76779,76143,76780,76142,75608,76141,75607,76140,76778,76139,76777,76138,76776,76137,75606,76136,76775,76135,75605,76134,75604,76133,76774,76132,75603,75536,75538,76155,76789);
DELETE FROM `creature_formations` WHERE `memberguid` IN (79023,79025,79028,79027,79026,79024,79010,79012,79001,79002,79003,75944,75611,76161,75612,76160,76794,76159,76793,76158,76792,76157,76791,76156,76790,76154,76788,76153,76787,76152,76786,76151,76785,76150,76784,76149,76783,76148,75610,76147,76782,76146,76781,76145,75609,76144,76779,76143,76780,76142,75608,76141,75607,76140,76778,76139,76777,76138,76776,76137,75606,76136,76775,76135,75605,76134,75604,76133,76774,76132,75603,75536,75538,76155,76789);
INSERT INTO `creature_formations` VALUES
--
--
--
(79023,79023,100,360,2),
(79023,79025,100,360,2),
--
(79028,79028,100,360,2),
(79028,79027,100,360,2),
--
(79026,79026,100,360,2),
(79026,79024,100,360,2),
--
-- (79001,79001,100,360,2),
-- (79001,79002,5,1,2),
-- (79001,79003,5,5,2),
--
(79010,79010,100,360,2),
(79010,79012,3,0,2),
--
(76132,76132,100,360,2),
(76132,75603,3,0,2),
--
(76133,76133,100,360,2),
(76133,76774,3,0,2),
--
(76134,76134,100,360,2),
(76134,75604,3,0,2),
--
(76135,76135,100,360,2),
(76135,75605,3,0,2),
--
(76136,76136,100,360,2),
(76136,76775,3,0,2),
--
(76137,76137,100,360,2),
(76137,75606,3,0,2),
--
(76138,76138,100,360,2),
(76138,76776,3,0,2),
--
(76139,76139,100,360,2),
(76139,76777,3,0,2),
--
(76140,76140,100,360,2),
(76140,76778,3,0,2),
--
(76141,76141,100,360,2),
(76141,75607,3,0,2),
--
(76142,76142,100,360,2),
(76142,75608,3,0,2),
--
(76143,76143,100,360,2),
(76143,76780,3,0,2),
--
(76144,76144,100,360,2),
(76144,76779,3,0,2),
--
(76145,76145,100,360,2),
(76145,75609,3,0,2),
--
(76146,76146,100,360,2),
(76146,76781,3,0,2),
--
(76147,76147,100,360,2),
(76147,76782,3,0,2),
--
(76148,76148,100,360,2),
(76148,75610,3,0,2),
--
(76149,76149,100,360,2),
(76149,76783,3,0,2),
--
(76150,76150,100,360,2),
(76150,76784,3,0,2),
--
(76151,76151,100,360,2),
(76151,76785,3,0,2),
--
(76152,76152,100,360,2),
(76152,76786,3,0,2),
--
(76153,76153,100,360,2),
(76153,76787,3,0,2),
--
(76154,76154,100,360,2),
(76154,76788,3,0,2),
--
(76155,76155,100,360,2),
(76155,76789,3,0,2),
--
(76156,76156,100,360,2),
(76156,76790,3,0,2),
--
(76157,76157,100,360,2),
(76157,76791,3,0,2),
--
(76158,76158,100,360,2),
(76158,76792,3,0,2),
--
(76159,76159,100,360,2),
(76159,76793,3,0,2),
--
(76160,76160,100,360,2),
(76160,76794,3,0,2),
--
(76161,76161,100,360,2),
(76161,75612,3,0,2),
--
(75944,75944,100,360,2),
(75944,75611,3,0,2),
--
(75536,75536,100,360,2),
(75536,75538,5,1.5,2);
--
--
--
--
-- ======================================================
-- Respawn
-- ======================================================
--
-- No Respawn Linking should be needed as it is outdoors
--
--
--
-- ======================================================
-- Visuals & Positioning & Movement
-- ======================================================
--
UPDATE `creature` SET `MovementType`=0 WHERE `id` = 21650;
UPDATE `creature` SET `id`='21804' WHERE `guid` = '75944';
UPDATE `creature` SET `position_x`='-4063.3823', `position_y`='3268.2243', `position_z`='332.8489', `orientation`='1.5204' WHERE `guid` = '76779';
UPDATE `creature` SET `movementtype`=0 WHERE `guid` IN (79012,79031);
UPDATE `creature` SET `position_x`='-3405.9919', `position_y`='3591.0534', `position_z`='277.3413', `orientation`='3.7411' WHERE `guid` = '79026';
UPDATE `creature` SET `position_x`='-3396.5886', `position_y`='3578.1232', `position_z`='276.4475', `orientation`='3.4662' WHERE `guid` = '79024';
UPDATE `creature` SET `position_x`='-3863.9594', `position_y`='3653.2551', `position_z`='278.2058', `orientation`='2.4098' WHERE `guid` = '75836';
UPDATE `creature` SET `position_x`='-3696.7248', `position_y`='3295.4008', `position_z`='312.2131', `orientation`='4.1192' WHERE `guid` = '157063';
UPDATE `creature` SET `position_x`='-4077.4799', `position_y`='3536.1298', `position_z`='290.0309' WHERE `guid` = '16777199';
UPDATE `creature` SET `position_x`='-3703.9433', `position_y`='3516.1601', `position_z`='261.1755', `orientation`='5.3015',`spawndist`='10',`movementtype`='1' WHERE `guid` = '75946';
UPDATE `creature` SET `id`='21912',`position_x`='-3809.5024', `position_y`='3505.8481', `position_z`='287.0409', `orientation`='0.1005',`spawndist`='0',`movementtype`='0',`spawntimesecs`='180' WHERE `guid` = '75602';
UPDATE `creature` SET `id`='21912',`position_x`='-3789.5825', `position_y`='3528.8469', `position_z`='286.5999', `orientation`='4.7540',`spawndist`='0',`movementtype`='0',`spawntimesecs`='180' WHERE `guid` = '75537';
UPDATE `creature` SET `position_x`='-3768.6557', `position_y`='3509.5625', `position_z`='286.4139', `orientation`='3.2225',`spawndist`='0',`movementtype`='0' WHERE `guid` = '8652354';
UPDATE `creature` SET `position_x`='-3788.1770', `position_y`='3488.0285', `position_z`='286.5588', `orientation`='1.6242',`spawndist`='0',`movementtype`='0' WHERE `guid` = '8652465';
UPDATE `creature` SET `position_x`='-4096.8676', `position_y`='3349.5346', `position_z`='285.6644', `orientation`='0.0290',`spawndist`='0',`movementtype`='0' WHERE `guid` = '75501';
UPDATE `creature` SET `position_x`='-3814.6540', `position_y`='3342.7878', `position_z`='324.0605', `orientation`='0.2041' WHERE `guid` = '27475';
UPDATE `creature` SET `position_x`='-3704.4089', `position_y`='3549.0734', `position_z`='250.5338', `orientation`='5.3131',`spawndist`='10',`movementtype`='1' WHERE `guid` = '75913';
UPDATE `creature` SET `spawndist`='15',`movementtype`='1' WHERE `guid` = '16777196';
UPDATE `creature` SET `position_x`='-4150.3593', `position_y`='3044.8649', `position_z`='316.1768', `orientation`='0.6373' WHERE `guid` = '75642';
UPDATE `creature` SET `position_x`='2329.7089', `position_y`='7296.8896', `position_z`='365.6174', `orientation`='3.4851',`spawndist`='0',`movementtype`='0' WHERE `guid` = '78264'; 
UPDATE `creature` SET `position_x`='2310.1850', `position_y`='7288.6796', `position_z`='365.6169', `orientation`='0.1668',`spawndist`='0',`movementtype`='0' WHERE `guid` = '78265';
UPDATE `creature` SET `position_x`='-3576.7216', `position_y`='3844.5419', `position_z`='322.9037' WHERE `guid` = '86099';
UPDATE `creature` SET `movementtype`='2' WHERE `id` = 23051;
UPDATE `creature` SET `position_x`='-4000.6518', `position_y`='3290.8366', `position_z`='285.0335' WHERE `guid` = '75644';
UPDATE `creature` SET `position_x`='-3941.4345', `position_y`='3584.1330', `position_z`='262.1536' WHERE `guid` = '75923';
UPDATE `creature` SET `position_x`='-3318.7717', `position_y`='3502.4025', `position_z`='270.1961' WHERE `guid` = '75907';
UPDATE `creature` SET `position_x`='-3282.3859', `position_y`='3754.5085', `position_z`='206.1688' WHERE `guid` = '75952';
UPDATE `creature` SET `movementtype`='0',`spawndist`='0' WHERE `guid` IN (79004,79005,79008,79009,79032);
UPDATE `creature` SET `position_x`='-3802.4738', `position_y`='3611.1091', `position_z`='259.7611' WHERE `guid` = '75950';
UPDATE `creature` SET `position_x`=' -3973.139648', `position_y`='3702.9545', `position_z`='293.1340' WHERE `guid` = '75846';
UPDATE `creature` SET `position_x`='-4052.4299', `position_y`='3306.8200', `position_z`='284.3703', `orientation`='1.2779',`spawndist`='0',`movementtype`='0' WHERE `guid` = '75498';
UPDATE `creature` SET `position_x`='-4181.9526', `position_y`='3061.8049', `position_z`='314.2287', `orientation`='5.6683',`spawndist`='0',`movementtype`='0' WHERE `guid` = '75513';
UPDATE `creature` SET `position_x`='-4184.2231', `position_y`='3029.1313', `position_z`='314.2188', `orientation`='0.4179',`spawndist`='0',`movementtype`='0' WHERE `guid` = '76663';
UPDATE `creature` SET `position_x`='-3309.3776', `position_y`='3668.6135', `position_z`='226.7601' WHERE `guid` = '75900';
UPDATE `creature` SET `position_x`='-3957.7778', `position_y`='3248.4855', `position_z`='294.0700', `orientation`='1.5798',`spawndist`='0',`movementtype`='0' WHERE `guid` = '76668';
UPDATE `creature` SET `position_x`='-3923.2751', `position_y`='3117.5781', `position_z`='329.0375', `orientation`='0.4331',`spawndist`='0',`movementtype`='0' WHERE `guid` = '76666';
UPDATE `creature` SET `position_x`='-3947.9072', `position_y`='2991.0852', `position_z`='359.2167', `orientation`='1.2460',`spawndist`='0',`movementtype`='0' WHERE `guid` = '76684';
UPDATE `creature` SET `position_x`='-3988.9843', `position_y`='3031.9885', `position_z`='356.8703', `orientation`='6.0369',`spawndist`='0',`movementtype`='0' WHERE `guid` = '76682';
UPDATE `creature` SET `position_x`='-4195.2827', `position_y`='3170.5644', `position_z`='317.6019', `orientation`='0.6648',`spawndist`='5',`movementtype`='1' WHERE `guid` = '76661';
UPDATE `creature` SET `position_x`='-3957.8037', `position_y`='3248.4633', `position_z`='294.0695', `orientation`='1.6151',`spawndist`='0',`movementtype`='0' WHERE `guid` = '76668';
UPDATE `creature` SET `position_x`='-3690.9189', `position_y`='3778.3767', `position_z`='270.1538', `orientation`='3.6454',`spawndist`='0',`movementtype`='0' WHERE `guid` = '76658';
UPDATE `creature` SET `position_x`='-3951.3366', `position_y`='3306.5402', `position_z`='287.3669', `orientation`='3.6140',`spawndist`='0',`movementtype`='0' WHERE `guid` = '75475';
UPDATE `creature` SET `position_x`='-3957.2329', `position_y`='3317.0698', `position_z`='287.7093', `orientation`='3.5629',`spawndist`='0',`movementtype`='0' WHERE `guid` = '75559';
UPDATE `creature` SET `position_x`='-3874.1015', `position_y`='3475.2094', `position_z`='275.0207', `orientation`='2.1709',`spawndist`='0',`movementtype`='0' WHERE `guid` = '75474';
UPDATE `creature` SET `position_x`='-3880.8913', `position_y`='3469.7612', `position_z`='274.5428', `orientation`='2.1709',`spawndist`='0',`movementtype`='0' WHERE `guid` = '75540';
UPDATE `creature` SET `position_x`='-3905.7983', `position_y`='3470.6750', `position_z`='274.1182', `orientation`='0.2585',`spawndist`='0',`movementtype`='0' WHERE `guid` = '75598';
-- channel trigger
UPDATE `creature` SET `movementtype`=0 WHERE `id` = 22436;
UPDATE `creature` SET `position_x`='2836.6455', `position_y`='7024.2641', `position_z`='368.4468', `orientation`='5.7334' WHERE `guid` = 85659;
UPDATE `gameobject` SET `position_x`='2836.6455', `position_y`='7024.2641', `position_z`='368.4468', `orientation`='5.7334' WHERE `guid` IN (100213,100214); -- one useable
UPDATE `creature` SET `position_x`='1396.8896', `position_y`='7405.3520', `position_z`='367.7672' WHERE `guid` = '71201';
UPDATE `creature` SET `id`='22196',`position_x`='2868.5900', `position_y`='6876.7529', `position_z`='364.3682', `orientation`='1.4025',`spawndist`='0',`movementtype`='0' WHERE `guid` = '77849';
UPDATE `creature` SET `position_x`='3860.7800', `position_y`='5883.7290', `position_z`='266.5476' WHERE `guid` = '78207';
UPDATE `creature` SET `position_x`='4064.6269', `position_y`='5722.4658', `position_z`='267.1163', `spawndist`='5',`movementtype`='1' WHERE `guid` = '78208';
UPDATE `creature` SET `position_x`='4006.2939', `position_y`='5537.3085', `position_z`='267.4615' WHERE `guid` = '78209';
UPDATE `creature` SET `position_x`='3986.0671', `position_y`='5234.5844', `position_z`='265.0721' WHERE `guid` = '78210';
UPDATE `creature` SET `position_x`='4014.5913', `position_y`='4993.4619', `position_z`='268.3882' WHERE `guid` = '78211';
UPDATE `creature` SET `position_x`='3940.2756', `position_y`='4873.3632', `position_z`='267.1611' WHERE `guid` = '78212';
UPDATE `creature` SET `position_x`='4094.4379', `position_y`='5227.4394', `position_z`='265.7415' WHERE `guid` = '78213';
UPDATE `creature` SET `position_x`='3882.9060', `position_y`='5410.5659', `position_z`='267.7539' WHERE `guid` = '78215';
--
--
--
UPDATE `gameobject` SET `position_z`='315.3656' WHERE `guid` = '14731';
-- 
-- Movement Missing for 86119
-- cage opens too late ~ 2secs
--
UPDATE `creature` SET `equipment_id`=1044 WHERE `guid` =79022;
DELETE FROM `creature_addon` WHERE `guid` IN (79022);
INSERT INTO `creature_addon` (`guid`,`emote`) VALUES
(79022,173);

UPDATE `waypoint_data` SET `position_x`='-4092.0080',`position_y`='3001.1174',`position_z`='364.8992' WHERE `id`='861330' AND `point`='5';

SET @GUID := 75536;
SET @POINT := 0;
UPDATE `creature` SET `position_x`='-3803.0900', `position_y`='3514.5300', `position_z`='287.0289', `MovementType`='2' WHERE `guid` = @GUID;
UPDATE `creature` SET `position_x`='-3806.7814', `position_y`='3516.2043', `position_z`='286.9846', `MovementType`='0' WHERE `guid` = 75538;
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
-- (@GUID,@POINT := @POINT + 1,'XXX','YYY','ZZZ',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3796.7573','3518.4677','287.0265',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3792.4211','3514.3876','287.0266',15000,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3796.7573','3518.4677','287.0265',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3809.3400','3522.4257','286.0990',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3824.3867','3531.7805','280.2926',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3841.2998','3532.8195','279.5966',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3857.7272','3531.6713','278.3836',15000,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3841.2998','3532.8195','279.5966',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3824.3867','3531.7805','280.2926',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3809.3400','3522.4257','286.0990',0,0,0,100,0);

SET @GUID := 75944;
SET @POINT := 0;
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` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-- (@GUID,@POINT := @POINT + 1,'XXX','YYY','ZZZ',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3589.6323','3512.4484','280.0510',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3569.4462','3519.0673','276.5340',10000,0,0,100,0);

SET @GUID := 76132;
SET @POINT := 0;
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` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
--  (@GUID,@POINT := @POINT + 1,XXX,YYY,ZZZ,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3607.7175','3625.6892','279.6546',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3589.9111','3605.6538','282.0216',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3572.7539','3599.7592','283.5164',10000,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3589.9111','3605.6538','282.0216',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3607.7175','3625.6892','279.6546',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3618.4323,3657.2731,276.2627,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3622.2363,3678.0275,280.3517,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3639.3457,3697.7158,278.4799,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3652.5812,3706.5185,280.4773,10000,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3639.3457,3697.7158,278.4799,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3622.2363,3678.0275,280.3517,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3618.4323,3657.2731,276.2627,0,0,0,100,0);

SET @GUID := 76133;
SET @POINT := 0;
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` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-- (@GUID,@POINT := @POINT + 1,'XXX','YYY','ZZZ',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3651.2553','3737.5222','299.7284',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3648.7028','3743.6599','302.1699',10000,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3651.2553','3737.5222','299.7284',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3657.4333','3719.9262','283.5418',10000,0,0,100,0);
--
-- (@GUID,@POINT := @POINT + 1,'-3651.2553','3737.5222','299.7284',0,0,0,100,0),
-- (@GUID,@POINT := @POINT + 1,'-3648.7028','3743.6599','302.1699',10000,0,0,100,0),

SET @GUID := 76134;
SET @POINT := 0;
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` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-- (@GUID,@POINT := @POINT + 1,'XXX','YYY','ZZZ',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3660.3317','3711.9047','280.9887',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3679.7448','3713.6281','276.8423',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3695.1425','3718.1118','276.7487',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3721.7800','3737.9921','276.8998',10000,0,0,100,0),
--
(@GUID,@POINT := @POINT + 1,'-3695.1425','3718.1118','276.7487',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3679.7448','3713.6281','276.8423',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3660.3317','3711.9047','280.9887',10000,0,0,100,0);

SET @GUID := 76135;
SET @POINT := 0;
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` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-- (@GUID,@POINT := @POINT + 1,'XXX','YYY','ZZZ',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3632.2663','3747.5729','302.1548',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3627.2556','3755.5544','302.1530',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3629.1401','3766.1528','302.1915',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3636.1682','3771.3542','301.9837',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3648.0905','3770.5578','301.7210',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3655.7341','3760.0029','301.8780',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3651.3090','3748.3068','302.1557',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3640.6662','3745.2268','302.1547',0,0,0,100,0);

SET @GUID := 76136;
SET @POINT := 0;
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` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-- (@GUID,@POINT := @POINT + 1,'XXX','YYY','ZZZ',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3677.4721','3779.6699','294.9278',10000,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3689.9614','3784.6694','297.9328',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3696.3603','3787.0969','301.9469',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3700.5471','3788.8347','302.1655',10000,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3696.3603','3787.0969','301.9469',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3689.9614','3784.6694','297.9328',0,0,0,100,0);

SET @GUID := 76137;
SET @POINT := 0;
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` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-- (@GUID,@POINT := @POINT + 1,'XXX','YYY','ZZZ',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3674.8845','3778.6086','294.9271',10000,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3664.8886','3774.5490','296.7333',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3656.3945','3771.1059','301.0377',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3653.2333','3769.8244','301.4796',10000,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3656.3945','3771.1059','301.0377',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3664.8886','3774.5490','296.7333',0,0,0,100,0);

SET @GUID := 76138;
SET @POINT := 0;
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` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-- (@GUID,@POINT := @POINT + 1,'XXX','YYY','ZZZ',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3725.2639','3805.1945','302.1740',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3715.0000','3809.8286','302.1549',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3704.5224','3805.9748','302.1590',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3699.3330','3796.1025','302.1620',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3708.9895','3781.0773','302.0657',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3722.2326','3785.9960','302.1342',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3728.3073','3797.2780','302.0519',0,0,0,100,0);

SET @GUID := 76139;
SET @POINT := 0;
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` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-- (@GUID,@POINT := @POINT + 1,'XXX','YYY','ZZZ',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3881.3947','3691.3227','335.2796',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3895.5683','3688.0739','335.7033',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3901.1147','3675.0285','335.9219',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3892.3820','3658.4497','335.9185',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3880.2324','3656.1562','335.9237',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3868.5512','3663.4465','335.9206',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3864.6918','3679.1418','335.5505',0,0,0,100,0);

SET @GUID := 76140;
SET @POINT := 0;
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` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-- (@GUID,@POINT := @POINT + 1,'XXX','YYY','ZZZ',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3879.6967','3698.1635','334.6796',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3880.1069','3694.3967','334.9794',10000,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3879.6967','3698.1635','334.6796',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3878.7238','3709.1442','329.9411',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3877.3903','3722.7639','328.1195',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3876.1772','3735.6696','329.8901',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3874.8825','3747.2983','334.8002',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3874.5417','3750.3601','334.8108',10000,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3874.8825','3747.2983','334.8002',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3876.1772','3735.6696','329.8901',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3877.3903','3722.7639','328.1195',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3878.7238','3709.1442','329.9411',0,0,0,100,0);

SET @GUID := 76141;
SET @POINT := 0;
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` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-- (@GUID,@POINT := @POINT + 1,'XXX','YYY','ZZZ',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-4070.8706','3367.9040','286.2124',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-4089.6188','3351.6506','285.5108',10000,0,0,100,0), 
(@GUID,@POINT := @POINT + 1,'-4089.7690','3347.7683','285.5565',0,0,0,100,0), 
(@GUID,@POINT := @POINT + 1,'-4053.3762','3316.0849','283.7596',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-4022.3708','3312.6298','283.7797',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-4006.9489','3296.9951','284.1149',10000,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-4022.3708','3312.6298','283.7797',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-4053.3762','3316.0849','283.7596',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-4089.7690','3347.7683','285.5565',10000,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-4089.6188','3351.6506','285.5108',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-4070.8706','3367.9040','286.2124',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-4069.6916','3393.9104','291.9689',10000,0,0,100,0);

SET @GUID := 76142;
SET @POINT := 0;
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` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-- (@GUID,@POINT := @POINT + 1,'XXX','YYY','ZZZ',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4082.1420,3212.3657,296.2620,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4095.3715,3222.6767,297.8964,10000,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4082.1420,3212.3657,296.2620,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4067.8364,3171.9208,297.5167,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4053.9001,3140.9121,305.5276,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4069.1223,3121.0664,312.1022,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4082.3681,3109.6838,315.6950,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4095.9653,3093.5688,316.6226,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4133.8759,3091.8769,316.0875,10000,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4095.9653,3093.5688,316.6226,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4082.3681,3109.6838,315.6950,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4069.1223,3121.0664,312.1022,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4053.9001,3140.9121,305.5276,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4067.8364,3171.9208,297.5167,0,0,0,100,0);

SET @GUID := 76143;
SET @POINT := 0;
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` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-- (@GUID,@POINT := @POINT + 1,XXX,YYY,ZZZ,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4046.4924,3271.7780,302.6072,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4041.5166,3273.5781,300.8418,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4040.4648,3280.9414,298.3470,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4047.8710,3284.3781,295.7271,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4052.9257,3278.9814,293.3906,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4049.5402,3271.9501,290.9231,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4042.0407,3270.4082,289.9129,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4038.2473,3275.6435,288.8866,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4040.4528,3281.2055,287.4848,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4045.3530,3287.1718,285.9599,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4045.4467,3304.9157,284.3579,10000,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4045.3530,3287.1718,285.9599,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4040.4528,3281.2055,287.4848,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4038.2473,3275.6435,288.8866,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4042.0407,3270.4082,289.9129,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4049.5402,3271.9501,290.9231,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4052.9257,3278.9814,293.3906,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4047.8710,3284.3781,295.7271,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4040.4648,3280.9414,298.3470,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4041.5166,3273.5781,300.8418,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4046.4924,3271.7780,302.6072,0,0,0,100,0),
--
(@GUID,@POINT := @POINT + 1,-4051.9672,3276.0134,305.1397,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4049.5314,3282.9174,307.7628,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4043.1057,3282.8649,309.9990,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4040.7143,3275.3173,312.8827,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4047.0900,3271.7031,315.5224,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4052.1025,3277.6035,318.3749,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4046.6184,3283.4582,321.4704,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4040.9667,3279.3066,324.2240,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4044.5747,3271.9470,327.4771,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4050.5349,3276.0683,330.3311,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4047.8227,3280.6269,331.5653,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4038.4208,3284.3476,334.2866,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4031.9514,3288.8125,332.7937,10000,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4038.4208,3284.3476,334.2866,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4047.8227,3280.6269,331.5653,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4050.5349,3276.0683,330.3311,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4044.5747,3271.9470,327.4771,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4040.9667,3279.3066,324.2240,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4046.6184,3283.4582,321.4704,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4052.1025,3277.6035,318.3749,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4047.0900,3271.7031,315.5224,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4040.7143,3275.3173,312.8827,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4043.1057,3282.8649,309.9990,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4049.5314,3282.9174,307.7628,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4051.9672,3276.0134,305.1397,0,0,0,100,0);

SET @GUID := 76144;
SET @POINT := 0;
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` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-- (@GUID,@POINT := @POINT + 1,XXX,YYY,ZZZ,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4056.6325,3257.6723,332.8552,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4043.7822,3257.3669,332.8514,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4032.3547,3263.0268,332.8521,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4026.0761,3276.5859,332.8530,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4028.9924,3290.6152,332.8147,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4038.7331,3298.6391,332.8569,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4053.0444,3297.4733,332.8558,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4067.2692,3281.1376,332.8544,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4061.2102,3260.3022,332.8567,0,0,0,100,0);

SET @GUID := 76145;
SET @POINT := 0;
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` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-- (@GUID,@POINT := @POINT + 1,XXX,YYY,ZZZ,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4148.1840,3053.6606,313.8669,10000,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4141.9838,3075.2204,314.5924,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4142.9477,3088.6467,316.3494,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4162.6088,3101.2248,320.4024,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4175.3242,3094.8139,323.4396,10000,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4162.6088,3101.2248,320.4024,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4142.9477,3088.6467,316.3494,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4141.9838,3075.2204,314.5924,0,0,0,100,0);

SET @GUID := 76146;
SET @POINT := 0;
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` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-- (@GUID,@POINT := @POINT + 1,XXX,YYY,ZZZ,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3992.2634,3118.9748,362.0521,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4006.3535,3122.3586,362.5860,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4013.4821,3139.1352,362.5400,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4005.6950,3152.0302,362.5394,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3986.8657,3153.7526,362.5492,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3977.7124,3142.3986,362.3548,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3979.7934,3128.3747,361.9855,0,0,0,100,0);

SET @GUID := 76147;
SET @POINT := 0;
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` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-- (@GUID,@POINT := @POINT + 1,XXX,YYY,ZZZ,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3918.6000,3101.8718,373.7373,10000,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3921.7897,3102.6557,373.4275,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3937.1096,3108.9775,363.9919,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3958.1267,3117.2194,358.9802,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3978.0942,3125.3205,361.5982,10000,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3958.1267,3117.2194,358.9802,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3937.1096,3108.9775,363.9919,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3921.7897,3102.6557,373.4275,0,0,0,100,0);

SET @GUID := 76148;
SET @POINT := 0;
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` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-- (@GUID,@POINT := @POINT + 1,XXX,YYY,ZZZ,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3913.6118,3069.4497,361.4145,10000,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3920.2434,3054.2536,358.9647,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3920.6542,3039.6579,356.6729,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3908.1350,3018.9995,356.9975,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3920.1906,3006.0974,357.7107,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3936.6618,3009.8168,356.7970,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3936.5297,3027.0886,356.6640,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3922.7089,3043.1401,356.8446,0,0,0,100,0);

SET @GUID := 76149;
SET @POINT := 0;
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` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-- (@GUID,@POINT := @POINT + 1,XXX,YYY,ZZZ,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3901.2849,3122.5766,366.3114,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3912.6970,3117.0349,362.2665,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3908.9416,3111.6252,362.3618,10000,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3912.6970,3117.0349,362.2665,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3901.2849,3122.5766,366.3114,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3888.1354,3120.7673,372.0219,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3885.8664,3115.3110,372.4953,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3904.0029,3113.7001,373.5544,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3915.7534,3104.7875,373.7326,10000,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3904.0029,3113.7001,373.5544,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3885.8664,3115.3110,372.4953,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3888.1354,3120.7673,372.0219,0,0,0,100,0);

SET @GUID := 76150;
SET @POINT := 0;
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` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-- (@GUID,@POINT := @POINT + 1,XXX,YYY,ZZZ,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3949.3632,3211.3186,333.9672,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3941.5747,3221.7282,333.9717,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3946.1679,3239.7778,333.9500,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3960.1081,3245.1408,333.4772,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3973.6630,3235.3320,333.4299,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3977.3317,3221.4394,333.7941,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3970.6120,3213.0742,333.9678,0,0,0,100,0);

SET @GUID := 76151;
SET @POINT := 0;
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` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-- (@GUID,@POINT := @POINT + 1,XXX,YYY,ZZZ,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3966.1574,3207.9819,333.9740,10000,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3976.5537,3184.9592,341.9073,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3983.0112,3171.7263,352.1168,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3986.3474,3164.4694,359.9381,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3988.2495,3159.7670,362.5448,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3989.9252,3155.6801,362.5521,10000,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3988.2495,3159.7670,362.5448,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3986.3474,3164.4694,359.9381,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3983.0112,3171.7263,352.1168,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3976.5537,3184.9592,341.9073,0,0,0,100,0);

SET @GUID := 76152;
SET @POINT := 0;
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` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-- (@GUID,@POINT := @POINT + 1,XXX,YYY,ZZZ,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3989.6330,3245.9887,327.9317,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3980.3591,3240.3774,332.7280,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3976.8305,3238.2426,333.0341,10000,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3980.3591,3240.3774,332.7280,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3989.6330,3245.9887,327.9317,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4011.3806,3259.1066,327.7716,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4022.7282,3265.8227,332.8598,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4026.2951,3268.0002,332.8559,10000,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4022.7282,3265.8227,332.8598,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-4011.3806,3259.1066,327.7716,0,0,0,100,0);

SET @GUID := 76153;
SET @POINT := 0;
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` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-- (@GUID,@POINT := @POINT + 1,XXX,YYY,ZZZ,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3859.7939,3320.3342,274.3484,10000,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3848.2463,3329.1201,276.9044,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3844.6491,3333.8986,277.8176,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3844.1445,3343.4267,279.5748,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3837.7915,3345.8881,280.8979,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3831.6411,3339.9477,281.9477,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3833.8237,3330.6276,284.2385,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3843.2233,3330.4711,286.9668,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3845.6728,3338.9301,289.4452,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3838.3369,3343.8034,292.0127,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3831.5957,3338.1301,294.7326,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3836.0896,3330.0192,297.6471,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3844.5063,3332.9372,300.4426,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3842.0078,3342.1286,303.5818,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3833.7441,3341.3210,306.3782,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3833.5659,3333.6130,308.9462,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3840.4968,3330.8151,311.6445,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3844.5278,3336.5979,314.2372,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3838.6242,3342.4184,317.3953,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3832.8159,3337.6533,320.2957,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3837.9296,3332.4479,322.5279,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3848.6037,3338.4460,325.4899,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3857.4377,3340.8178,324.0033,10000,0,0,100,0),
--
(@GUID,@POINT := @POINT + 1,-3848.6037,3338.4460,325.4899,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3837.9296,3332.4479,322.5279,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3832.8159,3337.6533,320.2957,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3838.6242,3342.4184,317.3953,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3844.5278,3336.5979,314.2372,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3840.4968,3330.8151,311.6445,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3833.5659,3333.6130,308.9462,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3833.7441,3341.3210,306.3782,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3842.0078,3342.1286,303.5818,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3844.5063,3332.9372,300.4426,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3836.0896,3330.0192,297.6471,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3831.5957,3338.1301,294.7326,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3838.3369,3343.8034,292.0127,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3845.6728,3338.9301,289.4452,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3843.2233,3330.4711,286.9668,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3833.8237,3330.6276,284.2385,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3831.6411,3339.9477,281.9477,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3837.7915,3345.8881,280.8979,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3844.1445,3343.4267,279.5748,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3844.6491,3333.8986,277.8176,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3848.2463,3329.1201,276.9044,0,0,0,100,0);

SET @GUID := 76154;
SET @POINT := 0;
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` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-- (@GUID,@POINT := @POINT + 1,XXX,YYY,ZZZ,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3844.7451,3316.8916,324.0562,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3825.7155,3319.8820,324.0549,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3816.5739,3336.6440,324.0555,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3823.4748,3350.6982,324.0506,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3836.0000,3356.5734,324.0522,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3850.9829,3353.2336,324.0531,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3860.0085,3341.6999,324.0196,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3857.3603,3324.4377,324.0578,0,0,0,100,0);

SET @GUID := 76155;
SET @POINT := 0;
UPDATE `creature` SET `MovementType`='2' WHERE `guid` = @GUID;
UPDATE `creature` SET `MovementType`='0' WHERE `guid` = 76789; 
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
-- (@GUID,@POINT := @POINT + 1,'XXX','YYY','ZZZ',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3845.9987','3371.2717','320.0703',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3844.6748','3362.6198','324.0491',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3843.7277','3357.3283','324.0546',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3844.6748','3362.6198','324.0491',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3845.9987','3371.2717','320.0703',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3848.7512','3389.2575','317.3675',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3850.6586','3400.9860','319.2988',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3852.3786','3411.4313','323.9291',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3853.0122','3415.9819','324.3081',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3850.6586','3400.9860','319.2988',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'-3848.7512','3389.2575','317.3675',0,0,0,100,0);

SET @GUID := 76156;
SET @POINT := 0;
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` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-- (@GUID,@POINT := @POINT + 1,XXX,YYY,ZZZ,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3702.9245,3308.9838,312.2301,10000,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3710.4790,3310.8928,310.1942,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3729.6125,3314.8522,293.6265,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3738.9804,3316.8376,292.2662,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3716.3725,3336.1335,287.7424,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3699.5783,3337.0507,284.7447,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3679.9670,3387.9533,283.2923,10000,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3699.5783,3337.0507,284.7447,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3716.3725,3336.1335,287.7424,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3738.9804,3316.8376,292.2662,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3729.6125,3314.8522,293.6265,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3710.4790,3310.8928,310.1942,0,0,0,100,0);

SET @GUID := 76157;
SET @POINT := 0;
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` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-- (@GUID,@POINT := @POINT + 1,XXX,YYY,ZZZ,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3678.5017,3292.4453,312.2577,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3674.2932,3304.4833,311.8909,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3679.5029,3314.9077,311.7879,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3691.5478,3319.4536,311.9869,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3700.0600,3312.5300,312.2227,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3701.7026,3297.5039,312.2232,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3691.9846,3289.5222,312.2252,0,0,0,100,0);

SET @GUID := 76158;
SET @POINT := 0;
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` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-- (@GUID,@POINT := @POINT + 1,XXX,YYY,ZZZ,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3667.0820,3367.6350,312.2316,10000,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3668.1252,3363.2102,312.0990,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3673.7536,3340.6442,304.9934,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3678.5839,3320.8273,311.1854,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3680.0568,3317.7915,311.5708,10000,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3678.5839,3320.8273,311.1854,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3673.7536,3340.6442,304.9934,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3668.1252,3363.2102,312.0990,0,0,0,100,0);

SET @GUID := 76159;
SET @POINT := 0;
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` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-- (@GUID,@POINT := @POINT + 1,XXX,YYY,ZZZ,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3676.9653,3387.9533,312.1757,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3677.5224,3376.3657,312.1058,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3666.7619,3369.3247,312.2256,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3654.8498,3369.4858,312.2246,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3648.5456,3378.6313,312.2264,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3650.0712,3389.2836,312.2249,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3660.8662,3396.7285,312.0103,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3670.6689,3394.1726,312.0958,0,0,0,100,0);

SET @GUID := 76160;
SET @POINT := 0;
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` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-- (@GUID,@POINT := @POINT + 1,XXX,YYY,ZZZ,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3836.1645,3432.8686,325.1093,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3839.8320,3424.8349,324.9029,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3852.8388,3419.8278,324.6609,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3869.0751,3422.9609,324.6664,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3874.2431,3435.9875,325.1443,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3865.8544,3450.7504,325.1713,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3849.8696,3453.3505,325.1698,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3836.5620,3442.0786,325.1725,0,0,0,100,0);

SET @GUID := 76161;
SET @POINT := 0;
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` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-- (@GUID,@POINT := @POINT + 1,XXX,YYY,ZZZ,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3864.9482,3514.7131,277.8982,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3874.1462,3492.9843,275.5117,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3881.4272,3477.3359,275.2178,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3873.1057,3466.8640,275.4382,10000,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3881.4272,3477.3359,275.2178,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3874.1462,3492.9843,275.5117,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3864.9482,3514.7131,277.8982,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3860.5507,3527.6374,278.3590,10000,0,0,100,0);

SET @GUID := 133904;
SET @POINT := 0;
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` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-- (@GUID,@POINT := @POINT + 1,XXX,YYY,ZZZ,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3783.6682,3687.0048,278.1654,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3818.1137,3685.7531,280.8526,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3847.2243,3676.2475,279.6791,20000,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3818.1137,3685.7531,280.8526,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3783.6682,3687.0048,278.1654,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3759.1000,3689.6499,278.6700,20000,0,0,100,0);

SET @GUID := 1189277;
SET @POINT := 0;
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` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-- (@GUID,@POINT := @POINT + 1,XXX,YYY,ZZZ,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3905.4895,3234.2272,301.3633,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3894.2553,3259.4091,300.9285,20000,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3905.4895,3234.2272,301.3633,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3901.8237,3204.1982,311.9386,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3898.8195,3188.1750,312.2982,20000,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3901.8237,3204.1982,311.9386,0,0,0,100,0);

SET @GUID := 79016;
SET @POINT := 0;
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,1,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
-- (@GUID,@POINT := @POINT + 1,XXX,YYY,ZZZ,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3615.4294,3476.5744,327.4638,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3560.4614,3488.1137,330.6695,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3506.5471,3544.3872,332.0020,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3519.6428,3597.8674,331.4504,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3549.7026,3638.6140,332.9829,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3588.0688,3668.1281,335.4062,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3655.3676,3654.6943,339.1059,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3706.3322,3596.5480,346.9858,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3696.2060,3516.2519,334.7077,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3665.6020,3492.6210,329.3851,0,0,0,100,0);

SET @GUID := 86155;
SET @POINT := 0;
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,1,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
-- (@GUID,@POINT := @POINT + 1,XXX,YYY,ZZZ,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3649.8298,3524.8864,296.1893,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3723.8166,3449.2705,299.3641,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3814.0471,3401.3156,301.4581,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3890.1657,3395.9445,304.3894,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3962.1345,3432.2053,307.1371,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3969.7429,3519.1142,307.2893,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3902.2834,3579.5195,305.8081,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3792.0664,3605.9873,306.7976,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3708.4013,3598.8107,304.6728,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3651.6999,3551.6489,296.6191,0,0,0,100,0);

SET @GUID := 86118;
SET @POINT := 0;
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` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-- (@GUID,@POINT := @POINT + 1,XXX,YYY,ZZZ,0,1,0,100,0),
(@GUID,@POINT := @POINT + 1,-4071.4877,3463.3559,307.8646,0,1,0,100,0),
(@GUID,@POINT := @POINT + 1,-4131.4638,3471.4211,310.5401,0,1,0,100,0),
(@GUID,@POINT := @POINT + 1,-4156.7104,3465.5966,312.2964,0,1,0,100,0),
(@GUID,@POINT := @POINT + 1,-4177.1870,3422.4492,312.9926,0,1,0,100,0),
(@GUID,@POINT := @POINT + 1,-4166.7988,3367.1027,315.7160,0,1,0,100,0),
(@GUID,@POINT := @POINT + 1,-4145.6416,3304.6965,318.8598,0,1,0,100,0),
(@GUID,@POINT := @POINT + 1,-4127.8007,3259.0981,324.9863,0,1,0,100,0),
(@GUID,@POINT := @POINT + 1,-4091.2321,3190.8542,348.2622,0,1,0,100,0),
(@GUID,@POINT := @POINT + 1,-4044.8601,3183.6738,366.5427,0,1,0,100,0),
(@GUID,@POINT := @POINT + 1,-4003.9729,3234.8337,352.8368,0,1,0,100,0),
(@GUID,@POINT := @POINT + 1,-3973.5517,3285.4506,343.1774,0,1,0,100,0),
(@GUID,@POINT := @POINT + 1,-3956.6608,3348.3168,330.3446,0,1,0,100,0),
(@GUID,@POINT := @POINT + 1,-3976.1135,3414.9865,313.4018,0,1,0,100,0),
(@GUID,@POINT := @POINT + 1,-4016.8798,3450.1298,312.3634,0,1,0,100,0);

SET @GUID := 79001;
SET @POINT := 0;
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,21158,16777472,0,4097,0,33555456,'');
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
-- (@GUID,@POINT := @POINT + 1,XXX,YYY,ZZZ,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3306.1340,3617.1394,302.3726,0,1,0,100,0),
(@GUID,@POINT := @POINT + 1,-3291.5568,3666.9091,302.1121,0,1,0,100,0),
(@GUID,@POINT := @POINT + 1,-3270.9726,3714.3964,300.4409,0,1,0,100,0),
(@GUID,@POINT := @POINT + 1,-3199.8100,3757.4670,297.0231,0,1,0,100,0),
(@GUID,@POINT := @POINT + 1,-3128.5698,3795.6940,296.5292,0,1,0,100,0),
(@GUID,@POINT := @POINT + 1,-3071.7033,3850.3103,297.6990,0,1,0,100,0),
(@GUID,@POINT := @POINT + 1,-3080.5012,3912.3686,296.8238,0,1,0,100,0),
(@GUID,@POINT := @POINT + 1,-3137.9794,3961.5136,300.3241,0,1,0,100,0),
(@GUID,@POINT := @POINT + 1,-3223.0932,3956.8759,304.9405,0,1,0,100,0),
(@GUID,@POINT := @POINT + 1,-3300.8303,3900.7932,315.0608,0,1,0,100,0),
(@GUID,@POINT := @POINT + 1,-3339.1618,3805.9025,315.9093,0,1,0,100,0),
(@GUID,@POINT := @POINT + 1,-3339.4553,3741.4326,309.2886,0,1,0,100,0),
(@GUID,@POINT := @POINT + 1,-3348.1252,3682.4101,300.1067,0,1,0,100,0),
(@GUID,@POINT := @POINT + 1,-3362.2343,3653.0695,284.5901,0,1,0,100,0),
(@GUID,@POINT := @POINT + 1,-3365.4606,3648.5197,284.5913,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3365.6577,3644.6259,284.6034,1000,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3357.2758,3630.4907,293.9105,2000,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3329.1887,3603.2333,300.3746,0,0,0,100,0);

UPDATE `creature` SET `position_x`='-3279.1638', `position_y`='3622.6069', `position_z`='305.3377' WHERE `guid` = '79003';
DELETE FROM `creature_addon` WHERE `guid` IN (79002,79003);
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (79002,79001,21158,16777472,0,4097,0,33555456,'');
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (79003,79001,21158,16777472,0,4097,0,33555456,'');
UPDATE `creature` SET `movementtype`='2' WHERE `guid` IN (79002,79003); 

SET @GUID := 75599;
SET @POINT := 0;
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` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-- (@GUID,@POINT := @POINT + 1,XXX,YYY,ZZZ,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3855.0537,3442.7763,364.4711,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3858.0998,3442.0654,364.4652,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3861.9655,3437.7517,364.4921,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3861.9499,3431.9812,364.5126,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3857.4814,3428.3532,364.5036,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3851.4682,3428.1811,364.5166,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3847.4030,3432.8188,364.5093,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3849.4016,3440.6372,364.5042,0,0,0,100,0);

SET @GUID := 86120;
SET @POINT := 0;
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` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-- (@GUID,@POINT := @POINT + 1,XXX,YYY,ZZZ,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3820.2136,3569.1176,294.5442,0,1,0,100,0),
(@GUID,@POINT := @POINT + 1,-3777.4877,3504.3828,303.5247,0,1,0,100,0),
(@GUID,@POINT := @POINT + 1,-3732.4897,3452.7006,307.9561,0,1,0,100,0),
(@GUID,@POINT := @POINT + 1,-3686.8332,3451.7778,310.1673,0,1,0,100,0),
(@GUID,@POINT := @POINT + 1,-3608.2360,3470.6501,316.8722,0,1,0,100,0),
(@GUID,@POINT := @POINT + 1,-3561.0017,3505.7106,313.4443,0,1,0,100,0),
(@GUID,@POINT := @POINT + 1,-3534.2641,3541.0085,310.5031,0,1,0,100,0),
(@GUID,@POINT := @POINT + 1,-3543.2609,3589.5461,312.8757,0,1,0,100,0),
(@GUID,@POINT := @POINT + 1,-3560.8098,3624.6367,309.2609,0,1,0,100,0),
(@GUID,@POINT := @POINT + 1,-3588.5305,3664.1962,306.7961,0,1,0,100,0),
(@GUID,@POINT := @POINT + 1,-3672.4365,3730.8588,306.0436,0,1,0,100,0),
(@GUID,@POINT := @POINT + 1,-3745.7727,3730.3386,311.7840,0,1,0,100,0),
(@GUID,@POINT := @POINT + 1,-3810.6787,3647.8015,302.2104,0,1,0,100,0),
(@GUID,@POINT := @POINT + 1,-3834.4943,3597.2600,296.8573,0,1,0,100,0);

-- ======================================================
-- Gameobjects
-- ======================================================
-- NIEMALS über 20000000
DELETE FROM `gameobject` WHERE `guid` IN (10000000,10000001);
INSERT INTO `gameobject` VALUES
(10000000,185913,530,1,-3687.8542,3735.9958,279.1919,5.4515,0,0,0.461749,0.887011,300,100,1),
(10000001,185913,530,1,-3810.6445,3768.8679,275.4711,5.0923,0,0,0.461749,0.887011,300,100,1);
--
-- Quest Chain Gameobject
UPDATE `gameobject` SET `spawntimesecs`=1 WHERE `guid`=14235; -- 180
UPDATE `gameobject_template` SET `data2`=1 WHERE `entry`=185954; -- 0
--
-- Skull Pile 185913 & Ancient Skull Pile 185928
UPDATE `gameobject` SET `spawntimesecs`='900' WHERE `id` = 185928; -- 180
UPDATE `gameobject` SET `spawntimesecs`='300' WHERE `id` = 185913; -- 180
--
--
--
-- ======================================================
-- Miscellaneous
-- ======================================================
--
-- Terok Loottable
UPDATE `creature_loot_template` SET `ChanceOrQuestChance`='13' WHERE `entry` = 21838 AND `item` IN (31580,31564,31572,31556); -- 0
UPDATE `creature_loot_template` SET `ChanceOrQuestChance`='10' WHERE `entry` = 21838 AND `item` IN (32537,32536,32535,32534); -- 5 5 0 0
UPDATE `creature_loot_template` SET `ChanceOrQuestChance`='4' WHERE `entry` = 21838 AND `item` IN (32540,32541); -- 2 2
UPDATE `creature_loot_template` SET `ChanceOrQuestChance`='4' WHERE `entry` = 21838 AND `item` = 32782; -- 2 ~ 10
--
UPDATE `quest_template` SET `prevquestid`=11098 WHERE `entry` = 11004;
--
-- V'eru 22497
-- UPDATE `creature_template` SET WHERE `entry` = '22497';
DELETE FROM `creature_questrelation` WHERE `id` = 22497;
INSERT INTO `creature_questrelation` VALUES (22497,10984);
--
DELETE FROM `creature_questrelation` WHERE `quest` IN (11065,11066);
-- INSERT INTO `creature_questrelation` VALUES
--
-- (23335,11065),
-- (23335,11066);

-- Yous Have Da Darkrune? 11027
UPDATE `quest_template` SET `SpecialFlags`='1' WHERE `entry` = 11027;
Looking4Group / L4G_Core

Skettis & Ogri'la #2064

Sources:

Terokkar Forest, Blade's Edge Mountains
