Shadowmoon Valley - Githubissues

#!sql

-- https://github.com/Looking4Group/L4G_Core/issues/604
-- Schattenmondtal 
-- ======================================================
-- Texts & Scripts
-- ======================================================

DELETE FROM `creature_ai_texts` WHERE `entry` BETWEEN -9699 AND -9600;
INSERT INTO `creature_ai_texts` VALUES
(-9600,'Destroy them! Destroy them all!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, '11980'),
(-9601,'Indeed, the time has come to end this charade.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, '11980'),
(-9602,'Foolish mortals. Did you think that I would not strike you down for your transgressions?', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, '11980'),
(-9603,'Come, mortals, face the lord of fire!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,0,0,'-174 21181'),
(-9604,'You will suffer eternally!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,0,0,'-175 21181'),
(-9605,'Little creature made of flesh, your wish is granted! Death comes for you!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,0,0,'-176 21181');
-- (-9606,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'SchattenmondtalPlatzhalter'),

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

-- Freie GUIDS SMV 84490 84609 84610 84611 84629 84630
-- ab 76200 freie guid 76278 76290 weiter bei 76400

DELETE FROM `creature` WHERE `guid` IN ('84633');
INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES (84633, 17711, 530, 1, 0, 0, -3563.52, 239.978, 43.9253, 1.55885, 432000, 0, 0, 2276400, 0, 0, 2);
INSERT IGNORE INTO `creature_addon` VALUES (84633,551779,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT IGNORE INTO `pool_template` VALUES (30040,1,'Worldboss Spawn Doomwalker');
DELETE FROM `pool_creature` WHERE `pool_entry`='30040';
INSERT IGNORE INTO `pool_creature` VALUES
(17525,30040,50,'Worldboss Spawn Doomwalker'),
(84633,30040,0,'Worldboss Spawn Doomwalker');
--
-- free 70178 - 70181, 70248 - 70254, reuse 70846 - 70849 , 70934 - 70939 , 76719 76720 76721 76722
--
-- 86899 spawned npc
DELETE FROM `creature` WHERE `guid` = '86899';
--
-- summoned
DELETE FROM `creature` WHERE `guid` IN (74167);
--
-- ======================================================
-- NPC Research
-- ======================================================
--
-- Doomwalker 17711
-- 11-15K on tank during enrage without armor debuff
UPDATE `creature_template` SET `flags_extra`='4194305',`mindmg`='12500',`maxdmg`='17144' WHERE `entry` IN ('17711'); -- 5527 11298
--
-- Shadowmoon Darkweaver 22081
UPDATE `creature_template` SET `AIName`='EventAI' WHERE `entry` IN ('22081');
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` IN ('22081');
INSERT INTO `creature_ai_scripts` VALUES
(2208101,22081,1,0,100,1,1000,1000,1800000,1800000,11,38446,0,0,0,0,0,0,0,0,0,0,'Shadowmoon Darkweaver - Casts Dark Summoning on Spawn'),
(2208102,22081,0,0,100,1,8000,10000,8000,10000,11,11962,1,0,0,0,0,0,0,0,0,0,'Shadowmoon Darkweaver - Immolate'),
(2208103,22081,9,0,100,1,0,5,10000,15000,11,35373,0,0,0,0,0,0,0,0,0,0,'Shadowmoon Darkweaver - Shadowfury'),
(2208104,22081,0,0,100,0,0,0,0,0,21,1,0,0,0,0,0,0,0,0,0,0,'Shadowmoon Darkweaver - Start Movement on Aggro'),
(2208105,22081,4,0,100,0,0,0,0,0,11,11962,1,0,22,1,0,0,0,0,0,0,'Shadowmoon Darkweaver - Cast Immolate and Set Phase 1 on Aggro'),
(2208106,22081,0,13,100,1,2000,3000,3000,4000,0,0,0,0,11,9613,1,0,0,0,0,0,'Shadowmoon Darkweaver - Cast Shadow Bolt (Phase 1)'),
(2208107,22081,3,13,100,0,15,0,0,0,21,1,0,0,22,2,0,0,0,0,0,0,'Shadowmoon Darkweaver - Start Movement and Set Phase 2 when Mana is at 15%'),
(2208108,22081,9,13,100,1,25,80,0,0,21,1,0,0,0,0,0,0,0,0,0,0,'Shadowmoon Darkweaver - Start Movement Beyond 25 Yards'),
(2208109,22081,3,11,100,1,100,30,100,100,22,1,0,0,0,0,0,0,0,0,0,0,'Shadowmoon Darkweaver - Set Phase 1 when Mana is above 30% (Phase 2)'),
(2208110,22081,2,0,100,0,15,0,0,0,22,3,0,0,0,0,0,0,0,0,0,0,'Shadowmoon Darkweaver - Set Phase 3 at 15% HP'),
(2208111,22081,2,7,100,0,15,0,0,0,21,1,0,0,25,0,0,0,1,-47,0,0,'Shadowmoon Darkweaver - Start Movement and Flee at 15% HP (Phase 3)'),
(2208112,22081,7,0,100,0,0,0,0,0,22,0,0,0,0,0,0,0,0,0,0,0,'Shadowmoon Darkweaver - On Evade set Phase to 0');
--
-- missing equipment template from tc 322.7 update
UPDATE `creature_template` SET `equipment_id`=8023 WHERE `entry`=21336; -- 2074
DELETE FROM `creature_equip_template` WHERE `entry` IN ('8023');
INSERT INTO `creature_equip_template` VALUES
(8023,5193,0,31338,218171394,0,50266626,1,0,15);
--
-- Nethermine Burster 23285
UPDATE `creature_template` SET `AIName`='EventAI' WHERE `entry` IN ('23285');
DELETE FROM `creature_template_addon` WHERE `entry` IN ('23285');
INSERT INTO `creature_template_addon` VALUES
(23285,0,0,0,0,0,0,0,'29147 0');
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` IN ('23285');
INSERT INTO `creature_ai_scripts` VALUES
(2328501,23285,1,0,100,0,0,0,500,500,11,20567,0,0,18,33554434,0,0,0,0,0,0,'Nethermine Burster - Cast Submerge Visual and Set Unselectable and Unattackable Flags and Start Combat Movement OOC'),
(2328502,23285,4,0,100,0,0,0,0,0,28,0,20567,0,28,0,29147,0,11,37752,0,0,'Nethermine Burster - On Aggro Remove Submerge Visual and Tunnel Bore Passive and Cast Stand'),
(2328503,23285,4,0,100,0,0,0,0,0,21,0,0,0,19,33554434,0,0,22,1,0,0,'Nethermine Burster - On Aggro Prevent Combat Movement Remove Unselectable and Unattackable Flags and Set Phase 1'),
(2328504,23285,0,1,100,1,1000,1000,2100,4500,11,31747,1,0,21,0,0,0,0,0,0,0,'Nethermine Burster - Cast Poison (Phase 1)'),
(2328505,23285,0,1,100,1,10000,20000,45000,50000,11,32738,1,0,0,0,0,0,0,0,0,0,'Nethermine Burster - Phase 1 Cast Bore'),
(2328506,23285,9,0,100,0,20,60,0,0,11,20567,0,0,11,29147,0,0,22,2,0,0,'Nethermine Burster - At 20 - 60 Yards Range Cast Submerge Visual and Tunnel Bore Passive Set Phase 2 (Phase 1)'),
(2328507,23285,9,1,100,0,0,8,0,0,28,0,20567,0,28,0,29147,0,11,37752,0,0,'Nethermine Burster - At 0 - 8 Yards Range Remove Submerge Visual and Tunnel Bore Passive and Cast Stand (Phase 2)'),
(2328508,23285,9,1,100,0,0,8,0,0,21,0,0,0,19,33554434,0,0,22,1,0,0,'Nethermine Burster - At 0 - 8 Yards Range Prevent Combat Movement Remove Unselectable and Unattackable Flags and Set Phase 1 (Phase 2)'),
(2328509,23285,7,0,100,0,0,0,0,0,11,20567,0,0,22,1,0,0,11,29147,0,0,'Nethermine Burster - On Evade Set Phase to 1 Cast Submerge and Set Flag Unattackable'),
(2328510,23285,7,0,100,0,0,0,0,0,14,-100,0,0,18,33554434,0,0,21,1,0,0,'Nethermine Burster - Drop Aggro and Set Unselectable and Unattackable Flags and Start Movement on Evade');
--
-- Felspine the Greater 21897
UPDATE `creature_template` SET `AIName`='EventAI' WHERE `entry` IN ('21897');
DELETE FROM `creature_template_addon` WHERE `entry` IN ('21897'); 
INSERT INTO `creature_template_addon` VALUES
(21897,0,0,0,0,4097,0,0,'36006 0');
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` IN ('21897');
INSERT INTO `creature_ai_scripts` VALUES
(2189701,21897,0,0,100,1,5500,5500,15000,15000,11,37941,0,1,0,0,0,0,0,0,0,0,'Felspine the Greater  - Cast Flaming Wound'),
(2189702,21897,0,0,100,1,8000,8000,10000,18000,11,38356,0,0,0,0,0,0,0,0,0,0,'Felspine the Greater  - Cast Fel Flames');
--
-- Dormant Infernal 21080
UPDATE `creature_template` SET `AIName`='EventAI' WHERE `entry` IN ('21080');
UPDATE `creature_template_addon` SET `auras`='' WHERE `entry` IN ('21080'); -- 12743 0 not in db
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` IN ('21080');
INSERT INTO `creature_ai_scripts` VALUES
('2108001','21080','4','0','100','0','0','0','0','0','3','19759','0','0','28','0','36055','0','0','0','0','0','Dormant Infernal - morph into Newly Crafted Infernal on aggro'),
('2108002','21080','1','0','100','0','0','0','0','0','3','0','0','0','11','36055','0','7','0','0','0','0','Dormant Infernal - demorph on OCC');
--
-- Mistress of the Mines 23149
UPDATE `creature_template` SET `minhealth`='104790',`maxhealth`='104790' WHERE `entry` IN ('23149');
--
-- Dragonmaw Skybreaker
UPDATE `creature_template` SET `InhabitType`='5' WHERE `entry` IN ('22274');
--
-- Illidari Dreadlord 21166
UPDATE `creature_template` SET `AIName`='EventAI',`speed`='1.71',`mindmg`='500',`maxdmg`='700',`mechanic_immune_mask`='936197983' WHERE `entry` IN ('21166');
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` IN ('21166');
INSERT INTO `creature_ai_scripts` VALUES
(2116601,21166,9,0,100,1,0,30,5000,10000,11,17287,1,0,0,0,0,0,0,0,0,0,'Illidari Dreadlord  - Cast Mind Blast'),
(2116602,21166,9,0,100,1,0,5,10000,12000,11,13704,0,0,0,0,0,0,0,0,0,0,'Illidari Dreadlord  - Cast Psychic Scream'),
(2116603,21166,9,0,100,1,0,25,10000,16000,11,12098,4,32,0,0,0,0,0,0,0,0,'Illidari Dreadlord  - Cast Sleep');
--
UPDATE `creature_template` SET `AIName`='EventAI' WHERE `entry` IN ('21287');
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` IN ('21287');
INSERT INTO `creature_ai_scripts` VALUES
(2128701,21287,4,0,100,0,0,0,0,0,21,1,0,0,0,0,0,0,0,0,0,0,'Warbringer Razuun - Stop Movement on Aggro'),
(2128702,21287,4,0,100,0,0,0,0,0,11,38047,1,0,22,1,0,0,0,0,0,0,'Warbringer Razuun - Cast Mind Warp and Set Phase 1 on Aggro'),
(2128703,21287,0,13,100,1,1000,1000,3000,4000,0,0,0,0,11,35913,1,0,0,0,0,0,'Warbringer Razuun - Cast Fel Fireball (Phase 1)'),
(2128704,21287,3,13,100,0,15,0,0,0,21,1,0,0,22,2,0,0,0,0,0,0,'Warbringer Razuun - Start Movement and Set Phase 2 when Mana is at 15%'),
(2128705,21287,9,13,100,1,25,80,0,0,21,1,0,0,0,0,0,0,0,0,0,0,'Warbringer Razuun - Start Movement Beyond 25 Yards'),
(2128706,21287,3,11,100,1,100,30,100,100,22,1,0,0,0,0,0,0,0,0,0,0,'Warbringer Razuun - Set Phase 1 when Mana is above 30% (Phase 2)'),
(2128707,21287,2,0,100,0,15,0,0,0,22,3,0,0,0,0,0,0,0,0,0,0,'Warbringer Razuun - Set Phase 3 at 15% HP'),
(2128708,21287,2,7,100,0,15,0,0,0,21,1,0,0,25,0,0,0,1,-47,0,0,'Warbringer Razuun - Start Movement and Flee at 15% HP (Phase 3)'),
(2128709,21287,7,0,100,0,0,0,0,0,22,0,0,0,0,0,0,0,0,0,0,0,'Warbringer Razuun - On Evade set Phase to 0'),
(2128710,21287,0,0,100,1,8000,10000,4000,8000,11,38047,1,32,0,0,0,0,0,0,0,0,'Warbringer Razuun - Mind Warp');
--
-- ai spawned npc 
DELETE FROM `creature` WHERE `id` IN ('21936');
--
-- Shadow Council Warlock
DELETE FROM `creature_ai_scripts` WHERE `id` IN ('2130214');
INSERT INTO `creature_ai_scripts` VALUES
('2130214','21302','10','0','100','1','1','20','5000','5000','11','38014','0','7','0','0','0','0','0','0','0','0','Shadow Council Warlock - Cast Shadow Council Channel OOC');

-- Legion Fel Cannon
UPDATE `creature_template` SET `AIName`='NULL' WHERE `entry` = 21233;
-- DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 21233;
-- INSERT INTO `creature_ai_scripts` VALUES
-- ('2123301','21233','4','0','100','1','0','0','0','0','20','0','0','0','0','0','0','0','0','0','0','0','Legion Fel Cannon - OOC - Prevent Melee on Aggro'),
-- ('2123302','21233','9','0','100','1','0','40','4500','5000','11','36242','1','0','0','0','0','0','0','0','0','0','Legion Fel Cannon - Combat - Cast Fel Cannon Blast');
-- trigger dummy 21348
DELETE FROM `spell_script_target` WHERE `entry` = '38014';
INSERT INTO `spell_script_target` VALUES (38014,1,21348);
UPDATE `creature` SET `position_z`='184.0000' WHERE `guid` IN ('74746','74747','74748');
--
-- Sunfury Blood Lord 21743
UPDATE `creature_template` SET `AIName`='EventAI' WHERE `entry` = '21743';
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = '21743';
INSERT INTO `creature_ai_scripts` VALUES
(2174301,21743,9,0,100,1,0,5,10000,12000,11,37577,1,0,0,0,0,0,0,0,0,0,'Sunfury Blood Lord  - Debilitating Strike'),
(2174302,21743,0,0,100,1,6000,8000,9500,18000,11,36104,0,0,0,0,0,0,0,0,0,0,'Sunfury Blood Lord  - Torrent of Flames');
--
-- Sunfury Eradicator 21742
UPDATE `creature_template` SET `AIName`='EventAI' WHERE `entry` = '21742';
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = '21742';
INSERT INTO `creature_ai_scripts` VALUES
(2174201,21742,2,0,100,1,25,0,15300,22900,11,17137,0,0,0,0,0,0,0,0,0,0,'Sunfury Eradicator - Cast Healing Touch When Below 25% HP'),
(2174202,21742,9,0,100,1,0,10,10000,12000,11,38008,0,1,0,0,0,0,0,0,0,0,'Sunfury Eradicator  - Seal of Blood');
--
-- Dreadwarden 19744
UPDATE `creature_template` SET `mindmg`='200',`maxdmg`='400',`baseattacktime`='1400',`armor`='4450',`AIName`='EventAI' WHERE `entry` = '19744'; -- 20 61 2000 20
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = '19744';
INSERT INTO `creature_ai_scripts` VALUES
('1974401','19744','9','0','100','1','0','5','6000','12000','11','32736','1','0','0','0','0','0','0','0','0','0','Dreadwarden - Cast Mortal Strike'),
('1974402','19744','9','0','100','1','0','25','10000','12000','11','11443','4','32','0','0','0','0','0','0','0','0','Dreadwarden - Cast Cripple');

-- Illidari Jailor 21520
UPDATE `creature_template` SET `AIName`='EventAI' WHERE `entry` = '21520';
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = '21520';
INSERT INTO `creature_ai_scripts` VALUES
('2152001','21520','9','0','100','1','0','20','14300','28200','11','38051','4','32','0','0','0','0','0','0','0','0','Illidari Jailor - Cast Fel Shackles');

-- Illidari Agonizer 19801
UPDATE `creature_template` SET `AIName`='EventAI' WHERE `entry` = '19801';
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = '19801';
INSERT INTO `creature_ai_scripts` VALUES
('1980101','19801','9','0','100','1','0','30','2400','4200','11','36227','1','0','0','0','0','0','0','0','0','0','Illidari Agonizer - Cast Firebolt');

-- Zandras 21827
UPDATE `creature_template` SET `AIName`='EventAI' WHERE `entry` = '21827';
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = '21827';
INSERT INTO `creature_ai_scripts` VALUES
('2182701','21827','9','0','100','1','0','25','10000','20000','11','38051','4','32','0','0','0','0','0','0','0','0','Illidari Jailor - Cast Fel Shackles');

-- Felboar 21878
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = '21878';
INSERT INTO `creature_ai_scripts` VALUES
('2187801','21878','9','0','100','1','8','25','12000','18000','11','35570','1','0','0','0','0','0','0','0','0','0','Felboar - Cast Charge');

-- flying dummy
UPDATE `creature_template` SET `inhabittype`='5' WHERE `entry` IN ('22317');

DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 21181;
INSERT INTO `creature_ai_scripts` VALUES
('2118101','21181','1','0','100','0','0','0','0','0','11','36329','0','0','1','-9603','-9604','0','0','0','0','0','Cyrukh the Firelord - Cast Cyrukh Fire Kit and Text on Spawn'),
('2118102','21181','4','0','100','0','0','0','0','0','1','-9605','0','0','0','0','0','0','0','0','0','0','Cyrukh the Firelord - Yell on Aggro'),
('2118103','21181','9','0','100','1','0','30','12000','19000','11','39429','4','0','0','0','0','0','0','0','0','0','Cyrukh the Firelord - Cast Fel Flamestrike'),
('2118104','21181','9','0','100','1','0','5','6000','12000','11','18945','1','0','0','0','0','0','0','0','0','0','Cyrukh the Firelord - Cast Knock Away'),
('2118105','21181','0','0','100','1','8000','13000','8000','13000','11','39425','0','0','0','0','0','0','0','0','0','0','Cyrukh the Firelord - Cast Trample'),
('2118106','21181','6','0','100','0','0','0','0','0','11','37235','0','2','0','0','0','0','0','0','0','0','Cyrukh the Firelord - Cast Cyrukh Defeated on Death'),
('2118107','21181','1','0','100','1','15000','15000','0','0','41','0','0','0','0','0','0','0','0','0','0','0','Cyrukh the Firelord - Forced Despawn OOC');

-- complete from trinity update 322.6 
UPDATE `creature_equip_template` SET `equipmodel2`='43792',`equipinfo2`='234948100 ',`equipslot2`='1038' WHERE `entry` = 1654;

UPDATE `creature` SET `spawntimesecs`='86400' WHERE `guid` IN ('1007','78222');
UPDATE `creature_template` SET `mechanic_immune_mask`='753866751' WHERE `entry` IN ('18696','18694'); -- rare elite immunities
DELETE FROM `creature_ai_scripts` WHERE `id` IN ('1869401','1869402','1869403');
INSERT INTO `creature_ai_scripts` VALUES
(1869401,18694,0,0,100,1,8500,8500,15000,15000,11,38932,0,2,0,0,0,0,0,0,0,0,'Collidus the Warp-Watcher - Cast Blink'),
(1869402,18694,0,0,100,1,3500,5500,10000,11000,11,36414,1,3,0,0,0,0,0,0,0,0,'Collidus the Warp-Watcher - Cast Focused Bursts'),
(1869403,18694,9,0,100,1,0,8,15000,16000,11,34322,0,3,0,0,0,0,0,0,0,0,'Collidus the Warp-Watcher - Cast Psychic Scream');
-- immolation aura, spell that works
DELETE FROM `creature_template_addon` WHERE `entry` IN ('18696');
INSERT INTO `creature_template_addon` VALUES
(18696,0,0,0,0,4097,0,0,'39007 0');

-- Summoned Infernal 22203 by Kraator
UPDATE `creature_template` SET `AIName`='EventAI' WHERE `entry` IN ('22203');
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` IN ('22203');
INSERT INTO `creature_ai_scripts` VALUES
(2220301,22203,1,0,100,6,5000,5000,0,0,41,0,0,0,0,0,0,0,0,0,0,0,'Infernal - Despawn after 5sec OOC');

-- Ghostrider of Karabor
UPDATE `creature_template`  SET `type_flags`='0',`unit_flags`='512' WHERE `entry` IN ('21784'); -- 2 0

-- Cleric of Karabor
UPDATE `creature_template`  SET `faction_A`='1822',`faction_H`='1822' WHERE `entry` IN ('21815');
UPDATE `creature_template_addon` SET `bytes0`='0',`auras`='37509 0 37497 0' WHERE `entry` IN ('21815'); -- 16843008 = 16777216 + 65536 + 256
-- 65536 macht unsichtbar? oder aktiviert deaktiviert auras? 2 mal zu addieren hebt wieder auf ka

-- Research 21939,21940

-- ======================================================
-- Visuals & Positioning & Movement
-- ======================================================
-- 
UPDATE `creature` SET `position_x`='-3586.0458', `position_y`='1853.9010', `position_z`='47.2405', `orientation`='2.6142',`spawndist`='0',`movementtype`='0' WHERE `guid` IN ('84940');
UPDATE `creature` SET `position_x`='-3598.1621', `position_y`='1851.8730', `position_z`='47.2406', `orientation`='0.9020',`spawndist`='0',`movementtype`='0' WHERE `guid` IN ('84948');
--
UPDATE `creature` SET `spawndist`='5',`movementtype`='1' WHERE `id` IN ('23169','23285','23324','23326');
--
-- movement 75407 77645
--
SET @GUID := 76415;
SET @POINT := 0;
UPDATE `creature` SET `MovementType`='2',`spawntimesecs`='180' WHERE `guid` = @GUID;
UPDATE `creature` SET `spawntimesecs`='180' WHERE `guid` IN (70887,70888);
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,512,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,-3758.9118,1030.6923,91.1329,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3770.7741,1030.9337,93.7164,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3782.2312,1037.8085,93.8334,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3799.7597,1053.7956,93.4925,10000,0,0,100,0),
--
(@GUID,@POINT := @POINT + 1,-3782.2312,1037.8085,93.8334,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3770.7741,1030.9337,93.7164,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3758.9118,1030.6923,91.1329,0,0,0,100,0),
--
(@GUID,@POINT := @POINT + 1,-3745.7802,1035.9519,89.2109,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3738.2658,1041.3862,88.5053,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3732.8200,1052.4451,86.6530,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3733.6257,1070.4434,87.8530,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3733.3320,1087.5629,86.1342,10000,0,0,100,0),
--
(@GUID,@POINT := @POINT + 1,-3738.4565,1101.2872,86.0334,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3741.7067,1107.7178,84.3930,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3747.8779,1116.7993,79.4853,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3759.1835,1125.7387,78.6744,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3772.1791,1127.6865,81.4655,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3780.3295,1125.0867,83.7786,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3791.5642,1113.0164,84.9287,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3802.5644,1101.6862,84.2388,10000,0,0,100,0),
--
(@GUID,@POINT := @POINT + 1,-3791.5642,1113.0164,84.9287,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3780.3295,1125.0867,83.7786,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3772.1791,1127.6865,81.4655,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3759.1835,1125.7387,78.6744,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3747.8779,1116.7993,79.4853,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3741.7067,1107.7178,84.3930,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3738.4565,1101.2872,86.0334,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3733.3320,1087.5629,86.1342,10000,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3733.6257,1070.4434,87.8530,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3732.8200,1052.4451,86.6530,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3738.2658,1041.3862,88.5053,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,-3745.7802,1035.9519,89.2109,0,0,0,100,0);
--
--
-- ======================================================
-- Linking
-- ======================================================
--
DELETE FROM `creature_formations` WHERE `leaderguid` IN (76415);
INSERT INTO `creature_formations` VALUES
(76415,76415,100,360,2),
(76415,70887,3,0.7,2),
(76415,70888,3,5.5,2);

DELETE FROM `creature_formations` WHERE `memberguid` IN (76085,76084,76083,76082);
DELETE FROM `creature_formations` WHERE `leaderguid` IN (76085,76084,76083,76082);
INSERT INTO `creature_formations` VALUES
(76082,76082,60,360,2),
(76082,76083,5,0,2),

(76084,76084,60,360,2),
(76084,76085,100,0,0);

-- ======================================================
-- Respawn
-- ======================================================

-- ======================================================
-- Gameobjects
-- ======================================================

-- ======================================================
-- Miscellaneous
-- ======================================================

DELETE FROM `creature_addon` WHERE `guid` IN (76348,76349,76351,76353,76355,76356,76358,76359,76360,76362,76363,76364,76365,76366,76368,76369,76371,76372,76373,76374,76376);

--
--
-- Leiche von Ar'tor, Son of Oronok sollte so in der luft schweben mit magical effect unso
UPDATE `creature` SET `curhealth`='0',`curmana`='0',`DeathState`='0',`position_x`='-3795.6413',`position_y`='2595.9692',`position_z`='90.1193',`orientation`='4.9644' WHERE `guid` IN ('84607');
DELETE FROM `creature_addon` WHERE `guid` IN ('84607');
INSERT INTO `creature_addon` VALUES
(84607,0,0,67584,7,4097,65,0,'');
--
-- Shadowmoon Zealot & Shadowmoon Harbinger Ghostrider of Karabor Vhel'kur MELEE ATTACKABLE
UPDATE `creature_template` SET `type_flags`='0' WHERE `entry` IN ('21788','21795','21784','21801');
--
-- Vhel'kur
UPDATE `creature` SET `position_x`='-5044.3710', `position_y`='360.8592', `position_z`='209.7891', `orientation`='3.9687' WHERE `id` IN ('21801');
UPDATE `creature_template` SET `Inhabittype`='5' WHERE `entry` IN ('21801');
--
UPDATE `creature_template_addon` SET `bytes0`='0',`auras`='37509 0 37497 0' WHERE `entry` IN ('21815','21784'); -- 16843008 = 16777216 + 65536 + 256
-- 65536 macht unsichtbar? oder aktiviert deaktiviert auras? 2 mal zu addieren hebt wieder auf ka
DELETE FROM `creature_addon` WHERE `guid` IN (76348,76349,76351,76353,76355,76356,76358,76359,76360,76362,76363,76364,76365,76366,76368,76369,76370,76371,76372,76373,76374,76376);
-- ab 76200 freie guid 76278 76290 weiter bei 76400
--

--
-- movement 76082 erweitern
SET @NPC := 76082;
SET @PATH := @NPC * 10;  
UPDATE `creature` SET `MovementType`='2' WHERE `guid` IN (76082);
UPDATE `creature` SET `MovementType`='0' WHERE `guid` IN (76083);
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@NPC,@PATH,0,16777472,16777216,4097,0,0,'37509 0 37497 0');
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
(@PATH,1,'-3125.6755','797.6018','-22.4501',0,1,0,0,0),
(@PATH,2,'-3147.0263','783.6260','-22.0322',0,1,0,0,0),
(@PATH,3,'-3206.2492','779.5981','-20.1981',0,1,0,0,0),
(@PATH,4,'-3258.0471','782.0344','-19.1112',0,1,0,0,0),
(@PATH,5,'-3299.8872','764.3292','-21.7981',0,1,0,0,0);

--
--
--
--
--
-- totem elementals despawn on evade Issue #351
DELETE FROM `creature_ai_scripts` WHERE `id` IN ('2170603','2142803','2170703','2170802');
INSERT INTO `creature_ai_scripts` VALUES
(2170603,21706,7,0,100,0,0,0,0,0,41,0,0,0,18,33554432,0,0,0,0,0,0,'Corrupted Fire Elemental - Despawn on Evade'),
(2142803,21428,7,0,100,0,0,0,0,0,41,0,0,0,18,33554432,0,0,0,0,0,0,'Corrupted Water Elemental - Despawn on Evade'),
(2170703,21707,7,0,100,0,0,0,0,0,41,0,0,0,18,33554432,0,0,0,0,0,0,'Corrupted Air Elemental - Despawn on Evade'),
(2170802,21708,7,0,100,0,0,0,0,0,41,0,0,0,18,33554432,0,0,0,0,0,0,'Corrupted Earth Elemental - Despawn on Evade');
-- Zorus the Judicator Speed
UPDATE `creature_template` SET `speed`='1.20' WHERE `entry` IN ('21774');
-- set idle
UPDATE `creature` SET `movementtype`='0' WHERE `guid` IN ('76071');
-- Mine der Todesschmiede
UPDATE `creature_template` SET `unit_flags`='4',`mindmg`='0',`maxdmg`='0',`baseattacktime`='0' WHERE `entry` IN ('22315');
--
--
-- vilewing_chimeras waypoints 
DELETE FROM `creature` WHERE `creature`.`guid` = 84490;
DELETE FROM `creature` WHERE `creature`.`guid` = 84611;
DELETE FROM `creature` WHERE `creature`.`guid` = 84609;
DELETE FROM `creature` WHERE `creature`.`guid` = 84610;
DELETE FROM `creature` WHERE `creature`.`guid` = 84629;
DELETE FROM `creature` WHERE `creature`.`guid` = 84630;

UPDATE `creature` SET `position_x` = '-3642.4', `position_y` = '2282.84', `position_z` = '101.388', `MovementType` = '2' WHERE `creature`.`guid` = 84488; 
UPDATE `creature` SET `position_x` = '-3306.02', `position_y` = '2329.37', `position_z` = '83.5418', `MovementType` = '2' WHERE `creature`.`guid` = 84594; 
UPDATE `creature` SET `position_x` = '-3679.03', `position_y` = '1980.17', `position_z` = '95.4007', `MovementType` = '2' WHERE `creature`.`guid` = 84597; 
UPDATE `creature` SET `position_x` = '-3495.38', `position_y` = '2654.51', `position_z` = '85.1497', `MovementType` = '2' WHERE `creature`.`guid` = 84613; 
UPDATE `creature` SET `position_x` = '-3051.69', `position_y` = '1036.49', `position_z` = '18.4269', `MovementType` = '2' WHERE `creature`.`guid` = 84632; 

DELETE FROM `creature_addon` WHERE `creature_addon`.`guid` = 84488;
DELETE FROM `creature_addon` WHERE `creature_addon`.`guid` = 84594;
DELETE FROM `creature_addon` WHERE `creature_addon`.`guid` = 84597;
DELETE FROM `creature_addon` WHERE `creature_addon`.`guid` = 84613;
DELETE FROM `creature_addon` WHERE `creature_addon`.`guid` = 84632;

INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes0`, `bytes1`, `bytes2`, `emote`, `moveflags`, `auras`) VALUES 
('84488', '844880', '0', '0', '0', '1', '0', '0', NULL), 
('84594', '845940', '0', '0', '0', '1', '0', '0', NULL), 
('84597', '845970', '0', '0', '0', '1', '0', '0', NULL), 
('84613', '846130', '0', '0', '0', '1', '0', '0', NULL), 
('84632', '846320', '0', '0', '0', '1', '0', '0', NULL); 

DELETE FROM `waypoint_data` WHERE `waypoint_data`.`id` = 844880;
INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES
(844880, 1, -3669.03, 2270.02, 101.638, 0, 0, 0, 100, 0),
(844880, 2, -3678.18, 2255.65, 102.61, 0, 0, 0, 100, 0),
(844880, 3, -3670.33, 2221.35, 101.971, 0, 0, 0, 100, 0),
(844880, 4, -3643.31, 2194.72, 101.749, 0, 0, 0, 100, 0),
(844880, 5, -3616.06, 2171.17, 100.721, 0, 0, 0, 100, 0),
(844880, 6, -3592.53, 2149.25, 97.388, 0, 0, 0, 100, 0),
(844880, 7, -3565.21, 2111.29, 91.7213, 0, 0, 0, 100, 0),
(844880, 8, -3539.71, 2073.03, 90.7214, 0, 0, 0, 100, 0),
(844880, 9, -3525.45, 2044.54, 86.1101, 0, 0, 0, 100, 0),
(844880, 10, -3525.76, 2011.65, 86.4714, 0, 0, 0, 100, 0),
(844880, 11, -3542.68, 1995.36, 88.4713, 0, 0, 0, 100, 0),
(844880, 12, -3561.44, 2002.94, 85.0268, 0, 0, 0, 100, 0),
(844880, 13, -3575.93, 2019.75, 82.8878, 0, 0, 0, 100, 0),
(844880, 14, -3575.17, 2047.14, 81.3602, 0, 0, 0, 100, 0),
(844880, 15, -3573.45, 2072.32, 84.9157, 0, 0, 0, 100, 0),
(844880, 16, -3564.49, 2102.47, 90.3324, 0, 0, 0, 100, 0),
(844880, 17, -3536.42, 2134.58, 97.9435, 0, 0, 0, 100, 0),
(844880, 18, -3500.94, 2154.61, 104.332, 0, 0, 0, 100, 0),
(844880, 19, -3468.63, 2165.14, 101.999, 0, 0, 0, 100, 0),
(844880, 20, -3451.68, 2176.57, 102.971, 0, 0, 0, 100, 0),
(844880, 21, -3440.87, 2214.56, 102.499, 0, 0, 0, 100, 0),
(844880, 22, -3464.08, 2240.17, 96.1936, 0, 0, 0, 100, 0),
(844880, 23, -3503.83, 2238.95, 96.8879, 0, 0, 0, 100, 0),
(844880, 24, -3532.54, 2227.36, 98.5269, 0, 0, 0, 100, 0),
(844880, 25, -3557.9, 2223.09, 99.7491, 0, 0, 0, 100, 0),
(844880, 26, -3585.39, 2233.09, 100.499, 0, 0, 0, 100, 0),
(844880, 27, -3605.96, 2248.53, 99.888, 0, 0, 0, 100, 0),
(844880, 28, -3615.81, 2270.33, 99.7213, 0, 0, 0, 100, 0),
(844880, 29, -3642.4, 2282.84, 101.388, 0, 0, 0, 100, 0);

DELETE FROM `waypoint_data` WHERE `waypoint_data`.`id` = 845940;
INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES
(845940, 1, -3306.58, 2358.01, 83.9584, 0, 0, 0, 100, 0),
(845940, 2, -3312.28, 2366.84, 84.1251, 0, 0, 0, 100, 0),
(845940, 3, -3339.58, 2384.22, 85.0139, 0, 0, 0, 100, 0),
(845940, 4, -3375.19, 2400.31, 84.7918, 0, 0, 0, 100, 0),
(845940, 5, -3413.53, 2413.8, 83.4028, 0, 0, 0, 100, 0),
(845940, 6, -3449.75, 2447.95, 84.5973, 0, 0, 0, 100, 0),
(845940, 7, -3484.88, 2475.86, 87.4863, 0, 0, 0, 100, 0),
(845940, 8, -3516.8, 2470.34, 88.6529, 0, 0, 0, 100, 0),
(845940, 9, -3551.3, 2449.09, 88.6529, 0, 0, 0, 100, 0),
(845940, 10, -3577.61, 2417.92, 88.6529, 0, 0, 0, 100, 0),
(845940, 11, -3587.22, 2394.96, 88.6529, 0, 0, 0, 100, 0),
(845940, 12, -3578.09, 2358.18, 91.0141, 0, 0, 0, 100, 0),
(845940, 13, -3542.67, 2341.77, 90.7363, 0, 0, 0, 100, 0),
(845940, 14, -3508.3, 2338.78, 88.6529, 0, 0, 0, 100, 0),
(845940, 15, -3480.53, 2321.33, 85.2084, 0, 0, 0, 100, 0),
(845940, 16, -3438.7, 2328.43, 84.014, 0, 0, 0, 100, 0),
(845940, 17, -3402.31, 2319.82, 84.0696, 0, 0, 0, 100, 0),
(845940, 18, -3367.93, 2320.2, 83.4028, 0, 0, 0, 100, 0),
(845940, 19, -3336.19, 2315.69, 83.7084, 0, 0, 0, 100, 0),
(845940, 20, -3306.02, 2329.37, 83.5418, 0, 0, 0, 100, 0);

DELETE FROM `waypoint_data` WHERE `waypoint_data`.`id` = 845970;
INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES
(845970, 1, -3694.72, 1971.45, 97.0395, 0, 0, 0, 100, 0),
(845970, 2, -3698.6, 1961.44, 97.5118, 0, 0, 0, 100, 0),
(845970, 3, -3703.09, 1932.74, 93.0952, 0, 0, 0, 100, 0),
(845970, 4, -3710.8, 1898.88, 95.0673, 0, 0, 0, 100, 0),
(845970, 5, -3706.17, 1855.21, 94.6507, 0, 0, 0, 100, 0),
(845970, 6, -3730.44, 1822.59, 97.1506, 0, 0, 0, 100, 0),
(845970, 7, -3764.35, 1786.2, 103.54, 0, 0, 0, 100, 0),
(845970, 8, -3806.22, 1765.62, 104.623, 0, 0, 0, 100, 0),
(845970, 9, -3831.6, 1734.27, 106.484, 0, 0, 0, 100, 0),
(845970, 10, -3845.84, 1700.6, 104.79, 0, 0, 0, 100, 0),
(845970, 11, -3860.27, 1667.3, 102.984, 0, 0, 0, 100, 0),
(845970, 12, -3878.3, 1634.77, 97.234, 0, 0, 0, 100, 0),
(845970, 13, -3905.48, 1624.4, 96.4007, 0, 0, 0, 100, 0),
(845970, 14, -3934.36, 1629.9, 95.7895, 0, 0, 0, 100, 0),
(845970, 15, -3941.39, 1653.26, 102.401, 0, 0, 0, 100, 0),
(845970, 16, -3933.62, 1681.02, 107.54, 0, 0, 0, 100, 0),
(845970, 17, -3911.21, 1703.6, 110.734, 0, 0, 0, 100, 0),
(845970, 18, -3870.42, 1717.62, 111.429, 0, 0, 0, 100, 0),
(845970, 19, -3851.41, 1733.49, 109.762, 0, 0, 0, 100, 0),
(845970, 20, -3832.47, 1767.41, 108.484, 0, 0, 0, 100, 0),
(845970, 21, -3821.69, 1801.01, 106.762, 0, 0, 0, 100, 0),
(845970, 22, -3804.74, 1833.07, 104.317, 0, 0, 0, 100, 0),
(845970, 23, -3771.97, 1852.2, 103.067, 0, 0, 0, 100, 0),
(845970, 24, -3733.2, 1857.56, 99.8175, 0, 0, 0, 100, 0),
(845970, 25, -3700.39, 1874.68, 91.9285, 0, 0, 0, 100, 0),
(845970, 26, -3669.67, 1899.9, 86.984, 0, 0, 0, 100, 0),
(845970, 27, -3657.47, 1933.84, 83.7894, 0, 0, 0, 100, 0),
(845970, 28, -3665.44, 1967.77, 90.2617, 0, 0, 0, 100, 0),
(845970, 29, -3679.03, 1980.17, 95.4007, 0, 0, 0, 100, 0);

DELETE FROM `waypoint_data` WHERE `waypoint_data`.`id` = 846130;
INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES
(846130, 1, -3513.77, 2667.21, 85.8719, 0, 0, 0, 100, 0),
(846130, 2, -3527.99, 2668.34, 87.3996, 0, 0, 0, 100, 0),
(846130, 3, -3568.94, 2660.98, 87.3718, 0, 0, 0, 100, 0),
(846130, 4, -3605.73, 2631.42, 89.0941, 0, 0, 0, 100, 0),
(846130, 5, -3606.99, 2590.2, 89.0108, 0, 0, 0, 100, 0),
(846130, 6, -3624.85, 2552.97, 89.8441, 0, 0, 0, 100, 0),
(846130, 7, -3632.88, 2523.19, 90.7886, 0, 0, 0, 100, 0),
(846130, 8, -3623.27, 2498.77, 93.4275, 0, 0, 0, 100, 0),
(846130, 9, -3594.59, 2497.11, 91.8164, 0, 0, 0, 100, 0),
(846130, 10, -3571.22, 2522.08, 89.7608, 0, 0, 0, 100, 0),
(846130, 11, -3555.3, 2550.05, 88.2052, 0, 0, 0, 100, 0),
(846130, 12, -3546.01, 2576.07, 86.6774, 0, 0, 0, 100, 0),
(846130, 13, -3533.12, 2604.75, 86.5941, 0, 0, 0, 100, 0),
(846130, 14, -3505.66, 2622.68, 86.0384, 0, 0, 0, 100, 0),
(846130, 15, -3495.38, 2654.51, 85.1497, 0, 0, 0, 100, 0);

DELETE FROM `waypoint_data` WHERE `waypoint_data`.`id` = 846320;
INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES
(846320, 1, -3078.82, 1034.04, 19.2881, 0, 0, 0, 100, 0),
(846320, 2, -3088.5, 1066.14, 25.0936, 0, 0, 0, 100, 0),
(846320, 3, -3087.41, 1099.35, 30.8436, 0, 0, 0, 100, 0),
(846320, 4, -3067.32, 1113.82, 27.6213, 0, 0, 0, 100, 0),
(846320, 5, -3035.01, 1131.8, 22.4825, 0, 0, 0, 100, 0),
(846320, 6, -3022.37, 1165.86, 21.288, 0, 0, 0, 100, 0),
(846320, 7, -3028.65, 1200.96, 24.2047, 0, 0, 0, 100, 0),
(846320, 8, -3053.87, 1219.14, 31.1214, 0, 0, 0, 100, 0),
(846320, 9, -3098.91, 1230.56, 38.8714, 0, 0, 0, 100, 0),
(846320, 10, -3120.39, 1233.38, 42.4825, 0, 0, 0, 100, 0),
(846320, 11, -3155.85, 1240.66, 47.0381, 0, 0, 0, 100, 0),
(846320, 12, -3184.49, 1256.95, 49.177, 0, 0, 0, 100, 0),
(846320, 13, -3200.05, 1273.89, 49.177, 0, 0, 0, 100, 0),
(846320, 14, -3198.47, 1300.31, 47.5659, 0, 0, 0, 100, 0),
(846320, 15, -3180.19, 1312.81, 46.5103, 0, 0, 0, 100, 0),
(846320, 16, -3166.77, 1318.92, 44.5658, 0, 0, 0, 100, 0),
(846320, 17, -3133.76, 1306.83, 33.8992, 0, 0, 0, 100, 0),
(846320, 18, -3107.96, 1267.03, 29.7603, 0, 0, 0, 100, 0),
(846320, 19, -3102.76, 1234.92, 31.5659, 0, 0, 0, 100, 0),
(846320, 20, -3081.74, 1200.23, 34.7603, 0, 0, 0, 100, 0),
(846320, 21, -3064.9, 1171.27, 31.5936, 0, 0, 0, 100, 0),
(846320, 22, -3032.82, 1161.91, 24.9269, 0, 0, 0, 100, 0),
(846320, 23, -2998.29, 1162.48, 17.288, 0, 0, 0, 100, 0),
(846320, 24, -2989.17, 1125.52, 23.2603, 0, 0, 0, 100, 0),
(846320, 25, -3019.7, 1108.53, 28.3714, 0, 0, 0, 100, 0),
(846320, 26, -3030.19, 1069.28, 24.0659, 0, 0, 0, 100, 0),
(846320, 27, -3051.69, 1036.49, 18.4269, 0, 0, 0, 100, 0);

UPDATE `creature` SET `movementtype`='2' WHERE `guid` IN ('84604');
SET @NPC := 84604;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@NPC,@PATH,0,0,0,1,0,0,'');
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
(@PATH,1,'-3599.6838','2076.1064','92.5506',0,0,0,100,0),
(@PATH,2,'-3669.1286','2090.3444','102.6834',0,0,0,100,0),
(@PATH,3,'-3730.5886','2072.4396','103.1668',0,0,0,100,0),
(@PATH,4,'-3738.8093','2000.7200','107.0229',0,0,0,100,0),
(@PATH,5,'-3825.2058','1880.9262','119.2841',0,0,0,100,0),
(@PATH,6,'-3767.8276','1824.7760','106.1014',0,0,0,100,0),
(@PATH,7,'-3706.9865','1851.2696','96.2108',0,0,0,100,0),
(@PATH,8,'-3663.1618','1934.2031','87.0559',0,0,0,100,0),
(@PATH,9,'-3599.0512','1955.2877','80.2601',0,0,0,100,0),
(@PATH,10,'-3574.9699','2053.8500','81.8910',0,0,0,100,0);
--
-- Pathing for Barash the Den Mother Entry: 23269 'ODB FORMAT' 
SET @NPC := 40645;
SET @PATH := @NPC * 10;
UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-5028.414,`position_y`=385.6584,`position_z`=171.0149 WHERE `guid`=@NPC;
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, '');
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
(@PATH,1,-5028.414,385.6584,171.0149,0,1,0,100,0), -- 20:05:15
(@PATH,2,-5037.621,373.1704,171.0173,0,1,0,100,0), -- 20:05:18
(@PATH,3,-5051.44,373.3133,171.0181,0,1,0,100,0), -- 20:05:20
(@PATH,4,-5055.748,366.6401,171.0181,0,1,0,100,0), -- 20:05:21
(@PATH,5,-5058.255,357.087,171.0151,0,1,0,100,0), -- 20:05:23
(@PATH,6,-5055.19,345.9996,170.9724,0,1,0,100,0), -- 20:05:25
(@PATH,7,-5034.827,346.2221,171.0174,0,1,0,100,0), -- 20:05:27
(@PATH,8,-5025.357,353.0934,170.6913,0,1,0,100,0), -- 20:05:31
(@PATH,9,-5019.042,361.9999,170.704,0,1,0,100,0), -- 20:05:33
(@PATH,10,-5018.177,373.4781,170.964,0,1,0,100,0); -- 20:05:34
--
-- Update position Ja'y Nosliw <Skybreaker General> 22433
UPDATE `creature` SET `position_x`=-5144.404, `position_y`=600.9089, `position_z`=82.75489, `orientation`=6.021386 WHERE  `guid`=78787;
--
-- Update position Taskmaster Varkule Dragonbreath 23140
UPDATE `creature` SET `position_x`=-5114.439, `position_y`=588.4843, `position_z`=85.87241, `orientation`=3.036873 WHERE  `guid`=51876;
--
-- Pathing for Arvoar the Rapacious Entry: 23267 'ODB FORMAT' 
SET @NPC := 40619;
SET @PATH := @NPC * 10;
UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-5115.436,`position_y`=144.5614,`position_z`=130.1606 WHERE `guid`=@NPC;
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, '');
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
(@PATH,1,-5115.436,144.5614,130.1606,0,0,0,100,0), -- 07:19:51
(@PATH,2,-5127.696,139.5475,130.1854,0,0,0,100,0), -- 07:19:53
(@PATH,3,-5122.23,120.3736,129.9845,0,0,0,100,0), -- 07:19:56
(@PATH,4,-5117.039,117.6734,129.9086,0,0,0,100,0), -- 07:19:58
(@PATH,5,-5107.681,117.8557,129.8407,0,0,0,100,0), -- 07:19:59
(@PATH,6,-5100.675,122.349,130.0891,0,0,0,100,0), -- 07:20:01
(@PATH,7,-5105.304,139.7458,130.1348,0,0,0,100,0); -- 07:20:04
--
-- Update fly speed of Dragonmaw Skybreakers
UPDATE `waypoint_data` SET `move_type`=1 WHERE  `id` IN (782940, 782970, 782910, 782920, 782930, 782940, 782950, 782960, 782970, 782980, 782990, 783000);
--
INSERT IGNORE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES (69082, 19362, 530, 1, 0, 0, -2966, 2547, 105.3, 5, 300, 0, 0, 14000, 0, 0, 0);
-- Pathing for Kor'kron Defender Entry: 19362 'ODB FORMAT' 
SET @NPC := 69082;
SET @PATH := @NPC * 10;
UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-2973.116,`position_y`=2556.282,`position_z`=105.8032 WHERE `guid`=@NPC;
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, '');
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
(@PATH,1,-2973.116,2556.282,105.8032,0,0,0,100,0), -- 13:50:20
(@PATH,2,-2962.696,2547.778,105.8032,0,0,0,100,0), -- 13:50:24
(@PATH,3,-2953.723,2551.618,105.8032,0,0,0,100,0), -- 13:50:29
(@PATH,4,-2954.077,2563.904,105.8032,0,0,0,100,0), -- 13:50:33
(@PATH,5,-2967.127,2567.316,105.8032,0,0,0,100,0), -- 13:50:38
(@PATH,6,-2968.788,2567.15,105.8032,0,0,0,100,0); -- 13:50:43
-- 0x1C09FC424012E88000001A00019B696A .go -2973.116 2556.282 105.8032
--
INSERT IGNORE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES (69087, 19362, 530, 1, 0, 0, -3097.77, 2510.37, 83.79, 3.559, 300, 0, 0, 14000, 0, 0, 0);
-- Pathing for Kor'kron Defender Entry: 19362 'ODB FORMAT' 
SET @NPC := 69087;
SET @PATH := @NPC * 10;
UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-3089.103,`position_y`=2508.026,`position_z`=83.78547 WHERE `guid`=@NPC;
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, '');
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
(@PATH,1,-3089.103,2508.026,83.78547,0,0,0,100,0), -- 13:47:23
(@PATH,2,-3087.197,2507.859,83.85033,0,0,0,100,0), -- 13:47:23
(@PATH,3,-3081.65,2516.463,84.05411,0,0,0,100,0), -- 13:47:26
(@PATH,4,-3090.028,2524.237,84.04036,0,0,0,100,0), -- 13:47:30
(@PATH,5,-3094.658,2522.566,84.06168,0,0,0,100,0), -- 13:47:33
(@PATH,6,-3096.908,2520.316,83.81168,0,0,0,100,0), -- 13:47:33
(@PATH,7,-3098.908,2518.066,84.06168,0,0,0,100,0), -- 13:47:33
(@PATH,8,-3099.196,2517.561,84.04745,0,0,0,100,0), -- 13:47:37
(@PATH,9,-3097.946,2514.811,84.04745,0,0,0,100,0), -- 13:47:37
(@PATH,10,-3096.946,2512.061,84.04745,0,0,0,100,0); -- 13:47:37
-- 0x1C09FC424012E88000001A00009B6969 .go -3089.103 2508.026 83.78547
--
UPDATE `creature_template_addon` SET `moveflags`='33554432' WHERE `entry` IN ('21153'); -- 256
--
-- dont want to delete 74220 , 74221
-- Pathing for Kor'kron Wyvern Rider Entry: 21153 'ODB FORMAT' 
SET @NPC := 74219;
SET @PATH := @NPC * 10;
UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-3014.283,`position_y`=2567.434,`position_z`=141.6225 WHERE `guid`=@NPC;
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,17722,0,1,0, '');
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
(@PATH,1,-3014.283,2567.434,141.6225,0,1,0,100,0), -- 13:51:11
(@PATH,2,-2997.179,2547.184,141.6225,0,1,0,100,0), -- 13:51:11
(@PATH,3,-2975.056,2527.355,141.6225,0,1,0,100,0), -- 13:51:11
(@PATH,4,-2944.816,2526.003,141.6225,0,1,0,100,0), -- 13:51:11
(@PATH,5,-2925.329,2546.514,141.6225,0,1,0,100,0), -- 13:51:11
(@PATH,6,-2919.246,2565.872,141.6225,0,1,0,100,0), -- 13:51:11
(@PATH,7,-2920.081,2589.365,141.6225,0,1,0,100,0), -- 13:51:11
(@PATH,8,-2931.993,2608.762,141.6225,0,1,0,100,0), -- 13:51:11
(@PATH,9,-2955.626,2618.87,141.6225,0,1,0,100,0), -- 13:51:11
(@PATH,10,-2977.497,2619.666,141.6225,0,1,0,100,0), -- 13:51:11
(@PATH,11,-3014.667,2609.543,141.6225,0,1,0,100,0), -- 13:51:11
(@PATH,12,-3055.036,2590.46,141.6225,0,1,0,100,0), -- 13:51:11
(@PATH,13,-3085.538,2571.631,141.6225,0,1,0,100,0), -- 13:51:11
(@PATH,14,-3114.716,2555.922,141.6225,0,1,0,100,0), -- 13:51:11
(@PATH,15,-3143.012,2552.032,141.6225,0,1,0,100,0), -- 13:51:11
(@PATH,16,-3176.688,2560.458,141.6225,0,1,0,100,0), -- 13:51:11
(@PATH,17,-3190.569,2587.816,141.6225,0,1,0,100,0), -- 13:51:11
(@PATH,18,-3187.101,2615.266,141.6225,0,1,0,100,0), -- 13:51:11
(@PATH,19,-3164.5,2634.338,141.6225,0,1,0,100,0), -- 13:51:11
(@PATH,20,-3137.512,2639.929,141.6225,0,1,0,100,0), -- 13:51:11
(@PATH,21,-3099.443,2633.703,141.6225,0,1,0,100,0), -- 13:51:11
(@PATH,22,-3074.344,2622.916,141.6225,0,1,0,100,0), -- 13:51:11
(@PATH,23,-3057.397,2608.769,141.6225,0,1,0,100,0), -- 13:51:11
(@PATH,24,-3045.574,2592.941,140.8448,0,1,0,100,0), -- 13:51:11
(@PATH,25,-3046.095,2591.678,139.9281,0,1,0,100,0), -- 13:51:11
(@PATH,26,-3028.975,2582.002,141.6225,0,1,0,100,0); -- 13:51:11
-- 0x1C09FC424014A84000001A00001B6969 .go -3014.283 2567.434 141.6225
--
DELETE FROM `creature` WHERE `guid` IN ('69081');
INSERT IGNORE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES (69081, 19362, 530, 1, 0, 0, -2990, 2605, 79, 0, 300, 0, 0, 14000, 0, 0, 0);
DELETE FROM `creature_formations` WHERE `leaderGUID`=69079;
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES
(69079, 69079, 0, 0, 2),
(69079, 69081, 3, 270, 2);
--
-- Pathing for  Entry: Entry: 21801 (Vhel'kur)
SET @NPC := 21801;
SET @GUID := 76114;
SET @PATH := @GUID * 10;
UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-5140.628,`position_y`=537.6068,`position_z`=225.5867 WHERE `guid`=76114;
UPDATE `creature_template` SET  `InhabitType`=4 WHERE  `entry`=@NPC;
DELETE FROM `creature_addon` WHERE `guid`=76114;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES
(76114,@PATH,0,33554432,1,0, '');
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
(@PATH,1,-5140.628,537.6068,225.5867,0,0,0,100,0),
(@PATH,2,-5047.682,660.9525,148.8644,0,0,0,100,0),
(@PATH,3,-5011.98,674.3496,148.8644,0,0,0,100,0),
(@PATH,4,-4981.461,669.827,148.8644,0,0,0,100,0),
(@PATH,5,-4959.014,632.2751,148.8644,0,0,0,100,0),
(@PATH,6,-4943.981,608.1472,148.8644,0,0,0,100,0),
(@PATH,7,-4929.495,593.4562,148.8644,0,0,0,100,0),
(@PATH,8,-4910.322,557.0013,148.8644,0,0,0,100,0),
(@PATH,9,-4886.5,522.941,148.8644,0,0,0,100,0),
(@PATH,10,-4860.481,492.9438,148.8644,0,0,0,100,0),
(@PATH,11,-4853.529,472.7724,148.8644,0,0,0,100,0),
(@PATH,12,-4853.905,449.3954,148.8644,0,0,0,100,0),
(@PATH,13,-4862.35,417.3469,148.8644,0,0,0,100,0),
(@PATH,14,-4904.073,347.1447,148.8644,0,0,0,100,0),
(@PATH,15,-4938.952,289.3222,148.8644,0,0,0,100,0),
(@PATH,16,-4959.224,247.5302,148.8644,0,0,0,100,0),
(@PATH,17,-4971.73,201.8298,148.8644,0,0,0,100,0),
(@PATH,18,-4979.256,156.9421,148.8644,0,0,0,100,0),
(@PATH,19,-4987.867,132.5271,148.8644,0,0,0,100,0),
(@PATH,20,-4998.63,107.5142,148.8644,0,0,0,100,0),
(@PATH,21,-5020.076,73.21224,148.8644,0,0,0,100,0),
(@PATH,22,-5061.159,55.51009,148.8644,0,0,0,100,0),
(@PATH,23,-5077.839,49.82715,148.8644,0,0,0,100,0),
(@PATH,24,-5112.819,49.43273,148.8644,0,0,0,100,0),
(@PATH,25,-5175.664,65.2347,163.3922,0,0,0,100,0),
(@PATH,26,-5198.992,107.9043,173.1977,0,0,0,100,0),
(@PATH,27,-5165.273,219.0713,198.2255,0,0,0,100,0),
(@PATH,28,-5113.013,300.7207,198.2255,0,0,0,100,0),
(@PATH,29,-5109.759,353.3949,226.7533,0,0,0,100,0),
(@PATH,30,-5113.028,378.9975,240.6144,0,0,0,100,0),
(@PATH,31,-5122.197,411.4973,243.2811,0,0,0,100,0);
-- 0x1C39A84240154A4000002100000AE735 .go -5140.628 537.6068 225.5867
--
UPDATE `creature` SET `position_x`='-3367.0195', `position_y`='3059.4582', `position_z`='209.3874', `orientation`='6.1086' WHERE `guid` IN ('70646');
--
UPDATE `creature` SET `position_x`='-4787.4956', `position_y`='1086.1278', `position_z`='-9.7713', `orientation`='0.5321' WHERE `guid` IN ('74007');
--
-- Ashtongue Deathsworn 21701
-- npc_ashtongue_deathsworn
UPDATE `creature` SET `position_x`='-3559.8906', `position_y`='525.5910', `position_z`='17.7077', `orientation`='4.7232',`spawndist`='0',`movementtype`='0' WHERE `guid` BETWEEN 75729 AND 75733;
-- 75729    21701   530 1   0   0   -3720,4 1026,39 56,0397 1,72788 300 0   0   22680   3155    0   0
-- 75730    21701   530 1   0   0   -3732,98    1026,14 56,0439 1,23918 300 0   0   22680   3155    0   0
-- 75731    21701   530 1   0   0   -3718,11    1072,07 56,8812 6,26093 300 5   0   22680   3155    0   1
-- 75732    21701   530 1   0   0   -3743,86    1081    56,8941 5,60251 300 0   0   22680   3155    0   0
-- 75733    21701   530 1   0   0   -3741,17    1079,75 56,8941 2,23402 300 0   0   22680   3155    0   0
--
SET @GUID := 35868;
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,1,-3746.03,562.553,56.2645,0,0,0,100,0),
(@GUID,2,-3727.2,563.095,49.0712,0,0,0,100,0),
(@GUID,3,-3725.34,563.07,48.336,6000,0,0,100,0),
(@GUID,4,-3768.53,562.303,64.0532,0,0,0,100,0), -- 2174301
(@GUID,5,-3783.47,562.37,68.8969,6000,0,0,100,0);
Looking4Group / L4G_Core

Shadowmoon Valley #604
