search

Looking4Group / L4G_Core

Looking4Group Core
http://looking4group.eu
GNU General Public License v2.0
37 stars 69 forks source link

Sunwell Plateau #511

Open Xadras opened 9 years ago

Xadras commented 9 years ago

Complete Raid Overhaul for Sunwell Plateau with Focus on Complete Groups, AIs, NPC-Values, Linking, Movement, Immunities, Visuals and Texts.

ToDo:

KALECGOS
Kalecgos Dragonkin 2,8m 6200 armor
Sathrovarr the Corruptor Demon 2,8m 6200 armor

BRUTALLUS
Brutallus Demon 10,4m 7700 armor

FELMYST
Felmyst Undead 6,84m 6200 armor
Trash Undead

EREDAR TWINS
Lady Sacrolash Demon 2,92m 6200 armor
Grand Warlock Alythess Demon 2,92m 6200 armor

M´URU
M´uru not specified 2,81m 7700 armor
Entropius Demon 2,20m 7700 armor
Trash Demon/Humanoid

KIL´JAEDEN
Kil´jaeden Demon 13,3m 6200 armor
Trash Demon/Humanoid

MGT npc sunwell_mage_guard has spell which throws weapon, lookup equipment_template and spell for reference to fix this.

http://wowwiki.wikia.com/wiki/Patch_2.4.1_(undocumented_changes)

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

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

Xadras commented 8 years ago

Recheck: https://github.com/hellground-tbc/database/commit/67ca174dfbe0da0cfc041657e466a60020cae02a

Sources:

http://www.engadget.com/2008/04/19/ready-check-brutallus/

http://www.wowhuntershall.com/2012/05/28/how-to-solo-sunwell-plateau-narrated-hunter-guides/

https://www.wowhead.com/forums&topic=31069#p307687 - aggro range

Trash Farming: https://www.youtube.com/watch?v=GF3JB1eRGzo , https://www.youtube.com/watch?v=V-Ol6dZJ6So , https://www.youtube.com/watch?v=dZ8dJJ8zxao , https://www.youtube.com/watch?v=nN5c8_Qbon0 Nerfed , https://www.youtube.com/watch?v=b1WZZbB1kmk , https://www.youtube.com/watch?v=qxwhSubX4dI

https://www.youtube.com/watch?v=DxjwaK4cAJA - pretty good for reviewing

Gauntlet: https://www.youtube.com/watch?v=gW8LaAYeImU

https://www.youtube.com/watch?v=i1AhdY8M0ic&feature=youtu.be&t=31s

Brutallus:

https://www.youtube.com/watch?v=xaEhUR4s8Jg

https://www.youtube.com/watch?v=izrg76UXXQM

Felmyst:

https://web.archive.org/web/20080921051619/http://elitistjerks.com/f15/t24304-felmyst/p4/

M'uru:

http://wowwiki.wikia.com/wiki/M%27uru_(tactics)?oldid=1522758 http://wowwiki.wikia.com/wiki/M%27uru_(tactics)?oldid=1393317

https://www.youtube.com/watch?v=6SYpwIcqKFs https://www.youtube.com/watch?v=9PfJhJe8nZI https://www.youtube.com/watch?v=YU-0ClpgLco https://www.youtube.com/watch?v=Em_UaJG5om0 https://www.youtube.com/watch?v=epO0Nk9HUKs

Kil'jaeden: https://www.youtube.com/watch?v=J_HyiKQKNJs https://www.youtube.com/watch?v=k-ap-fz027s

http://wowwiki.wikia.com/wiki/Sunwell_Plateau

http://wow.gamepedia.com/Sunwell_Plateau

http://www.wowhead.com/zone=4075/sunwell-plateau

-- ====================================

UPDATE creature_template SET minhealth='10000',maxhealth='10000' WHERE entry IN (66704);

DELETE FROM creature_addon WHERE guid IN (42593); INSERT INTO creature_addon VALUES (42593,0,0,0,0,4097,13,0,''); UPDATE creature_addon SET emote='13' WHERE guid IN (42596); -- nicht swp betreffend -- dev land ausräumen kb auf errors -- UPDATE creature SET map='530',position_x='-1864',position_y='5050',position_z='-12',orientation='4.4017' WHERE guid IN (45532); -- UPDATE creature SET map='530',position_x='-1874',position_y='5055',position_z='-12',orientation='4.4017' WHERE guid IN (1800314); -- UPDATE creature SET map='530',position_x='-1884',position_y='5065',position_z='-12',orientation='4.4017' WHERE guid IN (1334878); -- UPDATE creature SET map='530',position_x='-1894',position_y='5060',position_z='-12',orientation='4.4017' WHERE guid IN (679332); -- UPDATE creature SET map='530',position_x='-1904',position_y='5070',position_z='-12',orientation='4.4017' WHERE guid IN (282481); -- UPDATE creature SET map='530',position_x='-1914',position_y='5075',position_z='-12',orientation='4.4017' WHERE guid IN (529506); -- port dev land to shattrath -- UPDATE creature SET map='530',position_x='-1925',position_y='5554',position_z='-12,4280',orientation='5.1792' WHERE map IN (451);


Recheck for Kiljaeden

Shadow spike - Shadow Spike: 28 second channel. Bombards randomly targeted raid members with Shadow Spikes that function like Void Reaver's orbs, floating towards the target's position upon the moment of cast and exploding. The explosion inflicts 5100 to 6900 Shadow damage to all characters within 8 yards, and places a debuff that reduces all healing effects by 50% by 10 seconds. Resistable. }}}

//Second spell : // http://old.wowhead.com/spell=46589, instant, casts every 3 sec: (spell 46680 - Effect: Apply Aura: Periodically trigger spell Interval: 3 seconds) Work!

//Third spell : // http://old.wowhead.com/spell=45885 After the shadow spike came the target, it {{{ Inflicts 5100 to 6900% Shadow damage to an enemy and leaves it wounded, reducing the effectiveness of any healing by 50% for 10 sec. }}} How it works on blizzlike: inflicts to an enemy 5100 to 6900% Shadow damage, reducing the effectiveness of any healing by 50% for 10 sec. How it works on oregoncore: spell show only animation of blast, where shadow spike will arrive. Damage and debuff not appear (effect not works)

As a result, Kil'jaeden casts shadow spike(46680), loops on channeling spell(46680), and does not use Effect of second spell.

Sory for my english = Thank you for your attention!

Xadras commented 9 years ago 

-- https://github.com/Looking4Group/L4G_Core/issues/511
-- ===============
-- Sunwell Plateau
-- ===============

-- ======================================================
-- Texts & Scripts
-- ======================================================

DELETE FROM `script_texts` WHERE `entry` BETWEEN -1580070 AND -1580066;
INSERT INTO `script_texts` (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`, `sound`, `type`, `language`, `emote`, `comment`) VALUES ('-1580070', 'Drain the girl! Drain her power until there is nothing but a vacant shell!', NULL, NULL, 'Entzieht dem Mädchen die Kraft! Entzieht sie ihr, bis sie nichts weiter als eine leere Hülle ist!', NULL, NULL, NULL, NULL, NULL, '12499', '6', '0', '0', 'KJ - SAY_KJ_OFFCOMBAT5');
INSERT INTO `script_texts` (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`, `sound`, `type`, `language`, `emote`, `comment`) VALUES ('-1580069', 'Fail me and suffer for eternity!', NULL, NULL, 'Enttäuscht mich und ihr werdet in alle Ewigkeit leiden!', NULL, NULL, NULL, NULL, NULL, '12498', '6', '0', '0', 'KJ - SAY_KJ_OFFCOMBAT4');
INSERT INTO `script_texts` (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`, `sound`, `type`, `language`, `emote`, `comment`) VALUES ('-1580068', 'I have waited long enough!', NULL, NULL, 'Ich habe lange genug gewartet!', NULL, NULL, NULL, NULL, NULL, '12497', '6', '0', '0', 'KJ - SAY_KJ_OFFCOMBAT3');
INSERT INTO `script_texts` (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`, `sound`, `type`, `language`, `emote`, `comment`) VALUES ('-1580067', 'Stay on task! Do not waste time!', NULL, NULL, 'Bleibt bei der Sache, verliert keine Zeit!', NULL, NULL, NULL, NULL, NULL, '12496', '6', '0', '0', 'KJ - SAY_KJ_OFFCOMBAT2');
INSERT INTO `script_texts` (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`, `sound`, `type`, `language`, `emote`, `comment`) VALUES ('-1580066', 'All my plans have led to this!', NULL, NULL, 'Dies ist der Zweck all meiner Pläne!', NULL, NULL, NULL, NULL, NULL, '12495', '6', '0', '0', 'KJ - SAY_KJ_OFFCOMBAT1');

-- Shadowsword Vanquisher yells: Intruders! Do not let them into the Sanctum!

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

-- 44457 45075

DELETE FROM `creature` WHERE `guid` IN (4248546,259913,42593,48521,45572,7122151,51857,140024,14940078,44465,55063,44468,44148,44268,23267,42589,43769,44049,44328,44390,44420,44464,44948,45489,55064,55375,56332,56333,100050,140024,14940078);
INSERT INTO `creature` (`guid`,`id`, `map`, `spawnMask`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `MovementType`) VALUES (45572,25507,580,1,1761.8767,1082.1558,17.4186,3.8831,7200,0,0);
INSERT INTO `creature` VALUES (42593, 25369, 580, 1, 0, 0, 1757.44, 995.046, 16.0957, 0.715585, 7200, 0, 0, 240000, 0, 0, 0);
INSERT INTO `creature` VALUES (48521, 2010, 1, 1, 6801, 1, 9884.34, 1580.37, 1285.29, 0.087266, 7200, 0, 0, 137, 0, 0, 0);
INSERT INTO `creature` VALUES (23267, 7799, 1, 1, 6882, 0, -7205.06, -3827.29, 8.6442, 0.174533, 7200, 0, 0, 3000, 0, 0, 0);
-- INSERT INTO `creature` VALUES (23267, 25483, 580, 1, 0, 2208, 1790.47, 576.777, 52.2462, 4.28585, 7200, 0, 0, 190000, 30694, 0, 0);
INSERT INTO `creature` VALUES (42589, 25370, 580, 1, 0, 0, 1656.33, 1053.61, 16.069, 4.55531, 7200, 0, 0, 240000, 0, 0, 0);
INSERT INTO `creature` VALUES (43769, 25373, 580, 1, 0, 2209, 1626.43, 590.699, 84.9696, 2.77077, 7200, 0, 0, 190000, 30694, 0, 0);
INSERT INTO `creature` VALUES (44049, 25483, 580, 1, 0, 2208, 1706.86, 502.682, 85.2734, 3.30483, 7200, 0, 0, 190000, 30694, 0, 0);
INSERT INTO `creature` VALUES (44328, 25597, 580, 1, 0, 0, 1853.52, 687.853, 32.0322, 2.02292, 7200, 0, 0, 200000, 323100, 0, 0);
INSERT INTO `creature` VALUES (44390, 25486, 580, 1, 0, 2210, 1691.28, 508.229, 85.2733, 5.45681, 7200, 0, 0, 550000, 0, 0, 0);
INSERT INTO `creature` VALUES (44420, 25486, 580, 1, 0, 2210, 1702.57, 509.6, 85.2732, 4.34548, 7200, 0, 0, 550000, 0, 0, 0);
INSERT INTO `creature` VALUES (44464, 25486, 580, 1, 0, 2210, 1767.12, 495.657, 74.1535, 2.18956, 7200, 0, 0, 550000, 0, 0, 0);
INSERT INTO `creature` VALUES (44948, 25486, 580, 1, 0, 2210, 1777.35, 500.853, 74.1503, 2.45659, 7200, 0, 0, 550000, 0, 0, 0);
INSERT INTO `creature` VALUES (45489, 25506, 580, 1, 0, 2207, 1695.3, 493.935, 85.2734, 1.15127, 7200, 0, 0, 190000, 30694, 0, 0);
INSERT INTO `creature` VALUES (55064, 25507, 580, 1, 0, 0, 1772.7, 1081.99, 17.8621, 4.67748, 7200, 0, 0, 550000, 0, 0, 0);
INSERT INTO `creature` VALUES (55375, 25597, 580, 1, 0, 0, 1837.5394, 468.2720, 32.0315, 0.8781, 7200, 0, 0, 230000, 0, 0, 0);
INSERT INTO `creature` VALUES (56332, 25608, 580, 1, 0, 0, 1698.45, 628.03, 28.1989, 0.331613, 7200, 0, 0, 1, 0, 0, 0);
-- INSERT INTO `creature` VALUES (56333, 25608, 580, 1, 0, 0, 1698.9, 627.877, 27.6233, 0.034907, 7200, 0, 0, 1, 0, 0, 0);
INSERT INTO `creature` VALUES (44148, 25484, 580, 1, 0, 2206, 1787.6, 649.55, 34.5243, 5.87296, 7200, 8, 0, 7200, 0, 0, 1);
INSERT INTO `creature` VALUES (44268, 25484, 580, 0, 0, 2206, 1776.02, 540.351, 62.0931, 4.74886, 7200, 5, 0, 7200, 0, 0, 1);
INSERT INTO `creature` VALUES (51857, 26560, 530, 1, 0, 0, 13012.7, -6910.98, 9.58312, 2.48128, 600, 0, 0, 69860, 0, 0, 0);
INSERT INTO `creature` VALUES (44465, 25597, 580, 1, 0, 0, 1834.33, 698.825, 32.0323, 6.20674, 604800, 0, 0, 200000, 323100, 0, 0);
INSERT INTO `creature` VALUES (44468, 25588, 580, 1, 0, 0, 1684.7, 614.42, 28.058, 0.698392, 604800, 0, 0, 190000, 0, 0, 0);
INSERT INTO `creature` VALUES (55063, 25588, 580, 1, 0, 0, 1682.95, 637.75, 27.9231, 5.71709, 604800, 0, 0, 190000, 0, 0, 0); -- maybe additional 25508
INSERT INTO `creature` VALUES (259913, 25315, 580, 1, 0, 0, 1698.61, 628.414, 27.7395, 3.99799, 604800, 0, 0, 12600000, 2000000, 0, 0);

-- maybe adjust
-- INSERT INTO `creature` VALUES (54815, 25358, 580, 1, 0, 0, 1458.17, 501.295, 60.0833, 2.93215, 604800, 0, 0, 1, 0, 0, 0);
-- INSERT INTO `creature` VALUES (54814, 25357, 580, 1, 0, 0, 1468.38, 730.267, 60.0833, 5.07891, 604800, 0, 0, 1, 0, 0, 0);

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

-- World Trigger 19871 (Brutallus Icewall)
UPDATE `creature_template` SET `InhabitType` = 7 WHERE `entry` = 19871;
-- UPDATE creature_template SET ScriptName = "brutallus_intro_trigger", modelid_A = 18783, modelid_H = 15435, flags_extra = 2 WHERE entry = 19871;

-- Shattered Sun Riftwaker 26289

-- Shattered Sun Soldier 26259

-- Lady Liadrin <Blood Knight Matriarch> 26247

-- Prophet Velen 26246

-- Anveena 26046

-- Anveena Marker 26057

-- ============

-- Black Rat (2110) - NSR    

-- Infernal (22203) - NSR -- 251 - 501

-- Kalecgos 24844- mob_mgt_kalecgos
-- UPDATE creature_template SET WHERE entry = 24844;

-- Madrigosa (24895) - NSR
UPDATE creature_template SET `minlevel` = 73, `maxlevel` = 73 WHERE entry = 24895; -- 1

-- REPLACE INTO spell_script_target VALUES (44884, 1, 24895);

-- Demonic Vapor (Trail) 25267
-- REPLACE INTO spell_linked_spell VALUES (45410, 45400, 0, "Summon Blazing Dead when summoning Vapor Trail");

-- Unyielding Dead 25268 -- 1,500 - 2,500

-- Dancing Flames (25305)- npc_dancing_flames

-- Sunblade Cabalist 25363- mob_sunblade_cabalist
-- http://db.looking4group.eu/?npc=25363
-- https://wowwiki.fandom.com/wiki/Sunblade_Cabalist
UPDATE `creature` SET `spawndist`='0',`spawntimesecs`='7200' WHERE `id` = 25363;
UPDATE `creature` SET `id`='25363' WHERE `guid` = 54837;
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='4900', `maxdmg`='10500',`attackpower`='0',`armor`='5950',`mechanic_immune_mask`='82456547' WHERE `entry` = 25363; -- 4,900 - 10,500
-- UPDATE creature_template SET mechanic_immune_mask=365572067 WHERE entry = 25363;

-- Sunblade Arch Mage 25367- mob_sunblade_arch_mage
-- https://wowwiki.fandom.com/wiki/Sunblade_Arch_Mage?direction=next&oldid=1305680
-- http://db.looking4group.eu/?npc=25367
UPDATE `creature` SET `spawndist`='0',`spawntimesecs`='7200' WHERE `id` = 25367;
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='7846', `maxdmg`='17731',`attackpower`='0',`armor`='5950',`mechanic_immune_mask`='97136611' WHERE `entry` = '25367'; -- 6,720 - 12,320
-- UPDATE creature_template SET mechanic_immune_mask=365572067 WHERE entry = 25367;

-- Sunblade Slayer 25368- mob_sunblade_slayer
-- http://db.looking4group.eu/?npc=25368
-- https://wowwiki.fandom.com/wiki/Sunblade_Slayer
UPDATE `creature` SET `spawndist`='0',`spawntimesecs`='7200' WHERE `id` = 25368;
UPDATE `creature_template` SET `mindmg`='14960', `maxdmg`='20240',`attackpower`='0',`minrangedmg`='14960', `maxrangedmg`='20240',`minhealth`='250000', `maxhealth`='250000',`armor`='6800',`mechanic_immune_mask`='113913827',`speed`='1.48',`flags_extra`='65536' WHERE `entry`= '25368'; -- 7,700 - 14,700
UPDATE creature_template SET mechanic_immune_mask=936001535 WHERE entry = 25368;

-- Sunblade Vindicator 25369- mob_sunblade_vindicator
-- http://db.looking4group.eu/?npc=25369
-- https://wowwiki.fandom.com/wiki/Sunblade_Vindicator
UPDATE `creature` SET `spawndist`='0',`spawntimesecs`='7200' WHERE `id` = 25369;
UPDATE `creature` SET `id`='25369' WHERE `guid` IN (43439,43654,54858);
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='9600', `maxdmg`='32000',`attackpower`='0',`armor`='6800',`mechanic_immune_mask`='650854387' WHERE `entry` = '25369'; -- 9,100 - 21,000
UPDATE creature_template SET mechanic_immune_mask=365572067 WHERE entry = 25369;

-- Sunblade Dusk Priest 25370- mob_sunblade_dusk_priest
-- http://db.looking4group.eu/?npc=25370
-- https://wowwiki.fandom.com/wiki/Sunblade_Dusk_Priest
UPDATE `creature` SET `spawndist`='0',`spawntimesecs`='7200' WHERE `id` = 25370;
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='6300', `maxdmg`='10640',`attackpower`='0',`minhealth`='190000', `maxhealth`='190000',`armor`='5950',`mechanic_immune_mask`='116010979' WHERE `entry` = 25370; -- 6,300 - 10,640
-- UPDATE creature_template SET mechanic_immune_mask=365572067 WHERE entry = 25370;

-- Sunblade Dawn Priest 25371- mob_sunblade_dawn_priest
-- http://db.looking4group.eu/?npc=25371
-- https://wowwiki.fandom.com/wiki/Sunblade_Dawn_Priest
UPDATE `creature` SET `spawndist`='0',`spawntimesecs`='7200' WHERE `id` = 25371;
UPDATE `creature` SET `id`='25371' WHERE `guid` = 42573;
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='4900', `maxdmg`='10500',`attackpower`='0',`armor`='5950',`mechanic_immune_mask`='82446307' WHERE `entry` = '25371'; -- 4,900 - 10,500
UPDATE creature_template SET mechanic_immune_mask=365572067 WHERE entry = 25371;

-- Sunblade Scout 25372- mob_sunblade_scout
-- http://db.looking4group.eu/?npc=25372
-- https://wowwiki.fandom.com/wiki/Sunblade_Scout
UPDATE `creature` SET `spawndist`='0',`spawntimesecs`='7200' WHERE `id` = 25372;
UPDATE `creature_template` SET `mindmg`='2400', `maxdmg`='6400',`attackpower`='0',`armor`='6800',`mechanic_immune_mask`='652951379',
`speed`='1.48',`flags_extra`='65536' WHERE `entry` = 25372; -- 3,500 - 6,300
UPDATE creature_template SET mechanic_immune_mask=936001535 WHERE entry = 25372; 

-- Shadowsword Soulbinder 25373 -- 5,000 - 7,000
-- https://wowwiki.fandom.com/wiki/Shadowsword_Soulbinder

-- Shadowsword Manafiend 25483 -- 4,600 - 5,600
-- https://wowwiki.fandom.com/wiki/Shadowsword_Manafiend

-- Shadowsword Assassin 25484 -- 6,500 - 9,000
-- https://wowwiki.fandom.com/wiki/Shadowsword_Assassin
UPDATE `creature` SET `spawndist`='5',`MovementType`='1' WHERE `id` = 25484;

-- Shadowsword Deathbringer 25485 -- 4,100 - 5,500
-- https://wowwiki.fandom.com/wiki/Shadowsword_Deathbringer

-- Gauntlet Imp Trigger 25848- npc_gauntlet_imp_trigger
-- Respawntimer

-- Shadowsword Vanquisher 25486- mob_shadowsword_vanquisher
-- https://wowwiki.fandom.com/wiki/Shadowsword_Vanquisher
UPDATE `creature` SET `spawntimesecs` = 7200 WHERE `id` = 25486;
UPDATE `creature_template` SET `armor` = 7100, `speed` = 1.48, `mindmg` = 15000, `maxdmg` = 30000, `lootid` = 25486, `mechanic_immune_mask` = 650854399, `flags_extra` = 65536 WHERE `entry` = 25486; -- 5150 1 -- 7,500 - 12,000
UPDATE `creature_template_addon` SET `auras` = '45769 0 45769 1 18950 0 18950 1' WHERE `entry` = 25486;

-- Shadowsword Lifeshaper 25506 -- 4,600 - 5,600
-- https://wowwiki.fandom.com/wiki/Shadowsword_Lifeshaper

-- Sunblade Protector 25507- mob_sunblade_protector
-- http://db.looking4group.eu/?npc=25507
-- https://wowwiki.fandom.com/wiki/Sunblade_Protector
UPDATE `creature` SET `spawndist`='0',`spawntimesecs`='7200' WHERE `id` = 25507;
UPDATE `creature_template` SET `mindmg`='16000', `maxdmg`='32000',`attackpower`='0',`armor`='7400',`mechanic_immune_mask`='650870783',`speed`='1.48',`flags_extra`='65536' WHERE `entry` = 25507; -- 13,125 - 24,625
UPDATE `creature_template_addon` SET `auras`='18950 0 18950 1 45769 0 45769 1' WHERE `entry` = 25507;
UPDATE creature_template SET mechanic_immune_mask=936001535 WHERE entry = 25507;

-- Shadowsword Guardian 25508 -- 5,250 - 7,750
-- http://www.wowhead.com/npc=25508/shadowsword-guardian
-- https://wowwiki.fandom.com/wiki/Shadowsword_Guardian?direction=next&oldid=1474559
UPDATE `creature` SET `spawntimesecs` = 7200 WHERE `id` = 25508;
UPDATE `creature_template` SET `speed` = 1.48, `mindmg` = 20000, `maxdmg` = 40000, `mechanic_immune_mask` = 936001535, `flags_extra` = 65536 WHERE `entry` = 25508; -- 1 375 2875 1

-- Priestess of Torment 25509 -- 5,500 - 9,700
-- https://wowwiki.fandom.com/wiki/Priestess_of_Torment

-- Painbringer 25591 -- 7,500 - 13,000
-- https://wowwiki.fandom.com/wiki/Painbringer_(NPC)?direction=next&oldid=2066349
UPDATE `creature` SET `id` = 25591, `curhealth` = 240000 WHERE `guid` = 55476; 

-- Doomfire Destroyer 25592 -- 6,500 - 13,000
-- https://wowwiki.fandom.com/wiki/Doomfire_Destroyer

-- Apocalypse Guard 25593 -- 14,775 - 17,575
-- https://wowwiki.fandom.com/wiki/Apocalypse_Guard
-- https://www.wowhead.com/npc=25593/apocalypse-guard#comments

-- Chaos Gazer 25595 -- 7,500 - 10,000
-- https://wowwiki.fandom.com/wiki/Chaos_Gazer

-- Oblivion Mage 25597 -- 3,000 - 5,000
-- https://wowwiki.fandom.com/wiki/Oblivion_Mage
UPDATE `creature` SET `id` = 25597, `curhealth` = 230000 WHERE `guid` = 55352;

-- Cataclysm Hound 25599 -- 11,500 - 16,000
-- https://wowwiki.fandom.com/wiki/Cataclysm_Hound

-- Vindicator Moorba 25632- NSR

-- Captain Selana 25638- npc_captain_selana

-- Anchorite Elbadon 25639

-- Neophyte Narama 25644- NSR

-- Shattered Sun Soldier 25661

-- Armageddon Target 25735

-- Shadowsword Commander 25837 -- 17,500 - 20,500

-- Volatile Fiend 25851 -- 1,500 - 2,500
-- https://wowwiki.fandom.com/wiki/Volatile_Fiend
-- https://www.wowhead.com/npc=25851/volatile-fiend#comments

-- Singularity 25855- npc_singularity
-- Should be visible? or is this the trigger and another npc makes the visual
-- http://www.wowhead.com/npc=25855/singularity#comments
-- UPDATE `creature_template` SET `speed`='1',`unit_flags`='33816580' WHERE `entry` = 25855;

-- Blazing Infernal 25860
-- https://wowwiki.fandom.com/wiki/Blazing_Infernal

-- Felguard Slayer 25864
-- https://wowwiki.fandom.com/wiki/Felguard_Slayer

-- Sunblade Dragonhawk 25867
-- http://db.looking4group.eu/?npc=25867
-- https://wowwiki.fandom.com/wiki/Sunblade_Dragonhawk
UPDATE `creature` SET `spawndist`='0',`spawntimesecs`='7200' WHERE `id` = 25867;
UPDATE `creature_template` SET `mindmg`='3500', `maxdmg`='9100',`attackpower`='0',`armor`='6800',`mechanic_immune_mask`='109053415' WHERE `entry` = 25867; -- 3,500 - 9,100
UPDATE `creature_template` SET `speed`='1.48',`lootid`='25593',`mingold`='9000',`maxgold`='11000' WHERE `entry` = 25867;
UPDATE `creature_ai_scripts` SET `event_param3`='5000',`event_param4`='10000' WHERE `id` = 2586701;
UPDATE creature_template SET mechanic_immune_mask=902442479 WHERE entry = 25867;

-- Doomfire Shard 25948 -- 2,000 - 3,500
-- https://wowwiki.fandom.com/wiki/Doomfire_Shard
-- https://www.wowhead.com/npc=25948/doomfire-shard#comments:i|mode=n25

-- Anveena 26046

-- Fire Fiend 26101
-- http://www.wowhead.com/npc=26101/fire-fiend#english-comments
UPDATE creature_template SET `mechanic_immune_mask`='615057398',`mindmg`='235',`maxdmg`='285',`attackpower`='0' WHERE entry = 26101; -- 250-300 on cloth -- 910 - 1,540

-- Prophet Velen 26246- NSR

-- Lady Liadrin 26247- NSR

-- Shattered Sun Soldier 26259- NSR

-- Shattered Sun Riftwaker 26289- NSR

-- Fel Crystal Spell Target 25953
UPDATE `creature_template` SET `scale` = 1, `InhabitType` = 7 WHERE `entry` = 25953;

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

-- Kalecgos 24850- boss_kalecgos
UPDATE `creature_template` SET `armor`='6200',`speed`='2.00',`attackpower`='0',`unit_flags`='32832', `minhealth`='3785367', `maxhealth`='3785367',`mingold`='0',`maxgold`='0',`mindmg`='16000',`maxdmg`='25600',`attackpower`='0' WHERE `entry`= 24850;

-- Sathrovarr the Corruptor 24892- boss_sathrovarr
UPDATE `creature_template` SET `armor`='6200',`speed`='2.00',`attackpower`='0',`unit_flags`='32832', `minhealth`='2785367', `maxhealth`='2785367',`mindmg`='19200',`maxdmg`='25600',`attackpower`='0' WHERE `entry`= 24892;

-- Kalecgos 24891- boss_kalecgos_humanoid
UPDATE `creature_template` SET `armor`='6200',`speed`='2.00',`attackpower`='0',`unit_flags`='32832', `minhealth`='1000000', `maxhealth`='1000000',`mechanic_immune_mask`='653213695' WHERE `entry` = 24891;

-- =====================

-- Brutallus 24882- boss_brutallus
UPDATE `creature_template` SET `armor`='7700',`speed`='2.00',`mindmg`='12800',`maxdmg`='28800',`attackpower`='0',`unit_flags`='32832' WHERE entry = 24882;

-- =====================

24895, -- Madrigosa

-- Felmyst 25038- boss_felmyst
UPDATE `creature_template` SET `armor`='6200',`minhealth`='7004780', `maxhealth`='7004780' WHERE entry = 25038;

-- DELETE FROM spell_linked_spell WHERE spell_effect = 45665;
-- REPLACE INTO spell_linked_spell VALUES (45661, 44883, 1, "Encapsulate");

-- Skeletons etc

-- =====================

-- Lady Sacrolash 25165- boss_sacrolash
-- http://wowwiki.wikia.com/wiki/Eredar_Twins?oldid=1596953
-- `minhealth`='2883250', `maxhealth`='2883250',
-- UPDATE `creature_template` SET `armor`='6200', `speed` = 2, mingold` = 1250000 , `maxgold` = 1250000 WHERE `entry` = 25165; -- 1.75 9500 12500 -- 17,750 - 20,750
-- UPDATE `creature_equip_template` SET `equipmodel3` = 36080, `equipinfo3` = 33492994, `equipslot3` = 25 WHERE `entry` = 3000;

-- Grand Warlock Alythess 25166- boss_alythess
-- http://wowwiki.wikia.com/wiki/Eredar_Twins?oldid=1596953
-- `minhealth`='2883250', `maxhealth`='2883250',
-- UPDATE `creature_template` SET `armor`='6200',`mingold` = 1250000 , `maxgold` = 1250000 WHERE entry = 25166; -- 18,250 - 22,250

-- =====================

-- M'uru 25741- boss_muru
-- http://wowwiki.wikia.com/wiki/M%27uru_(tactics)
UPDATE `creature_template` SET `minhealth`='2731428', `maxhealth`='2731428', `armor`='7700' WHERE entry = 25741; -- 5,000 - 7,000

-- Entropius 25840- boss_entropius
UPDATE `creature_template` SET `minhealth`='2928571', `maxhealth`='2928571', `armor`='7700' WHERE entry = 25840; -- 8,000 - 12,000

-- Shadowsword Fury Mage 25799
-- https://wowwiki.fandom.com/wiki/Shadowsword_Fury_Mage
-- http://www.wowhead.com/npc=25799, http://wowwiki.wikia.com/wiki/Shadowsword_Fury_Mage , http://wow.gamepedia.com/Shadowsword_Fury_Mage
UPDATE `creature_template` SET `armor` = 5700 WHERE `entry` = 25799; -- 12,000 - 15,000

-- Shadowsword Berserker 25798
-- https://wowwiki.fandom.com/wiki/Shadowsword_Berserker
-- http://www.wowhead.com/npc=25798 http://wowwiki.wikia.com/wiki/Shadowsword_Berserker , http://wow.gamepedia.com/Shadowsword_Berserker
-- UPDATE `creature_template` SET `armor` = 7100 WHERE `entry` = 25798; -- 13,625 - 16,125

-- Void Sentinal 25772
-- https://wowwiki.fandom.com/wiki/Void_Sentinel
-- http://www.wowhead.com/npc=25772, http://wowwiki.wikia.com/wiki/Void_Sentinel , http://wow.gamepedia.com/Void_Sentinel
-- UPDATE `creature_template` SET `armor` = 6800, `dmgschool` = 5 WHERE `entry` = 25772; -- 28,375 - 33,375

-- Void Sentinal Summoner 25782
UPDATE creature_template SET `MinLevel` = 70, `MaxLevel` = 70, `Faction_A`=114, `Faction_H` = 114, `MinHealth` = 6602, `MaxHealth` = 6602, `mindmg` = 252, `maxdmg` = 357, `minrangedmg` = 215, `maxrangedmg` = 320, `unit_flags` = `unit_flags`|33554688, `armor` = 6792, `attackpower` = 304, `rangedattackpower` = 44 WHERE `entry` = 25782;

-- Void Spawn 25824 -- 1,988 - 2,588
--https://wowwiki.fandom.com/wiki/Void_Spawn

-- Dark Fiend 25744

-- Darkness 25879- npc_darkness

-- =====================

-- Kil'jaeden <The Deceiver> 25315- boss_kiljaeden
-- http://wowwiki.wikia.com/wiki/Kil%27jaeden_(tactics)?direction=next&oldid=1385293
UPDATE `creature_template` SET `armor`= 6200, `mindmg` = 5000, `maxdmg` = 10000, `flags_extra` = 1077936129 WHERE `entry` = 25315; -- 5300 250 7250 -- 11,500 - 18,500
UPDATE `creature_model_info` SET `bounding_radius` = 12, `combat_reach` = 12 WHERE `modelid` = 23200; -- 0 0

-- Hand of the Deceiver 25588- mob_hand_of_the_deceiver
UPDATE `creature` SET `spawntimesecs` = 7200 WHERE `id` = 25588;
UPDATE `creature_template` SET `minlevel` = 71, `maxlevel` = 72, `minhealth` = 205000, `maxhealth` = 205000, `minmana` = 100000, `maxmana` = 100000, `armor` = 5900, `speed` = 1.71, `scale` = 1.10, `mindmg` = 4000, `maxdmg` = 6000, `equipment_id` = 25588, `mechanic_immune_mask` = 619386619, `flags_extra` = 1078001664 WHERE `entry` = 25588; -- 70 190000 0 4800 500 2500
DELETE FROM `creature_template_addon` WHERE `entry` = 25588;
INSERT INTO `creature_template_addon` VALUES (25588, 0, 0, 0, 0, 0, 0, 0, '45769 0 45769 1');
DELETE FROM `item_template` WHERE `entry` = 35220;
INSERT INTO `item_template` VALUES (35220, 2, 10, -1, 'Monster - Staff, Sunwell D02', 47994, 0, 0, 0, 0, 1, 1, 1, 14, 2, 17, -1, -1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2000, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, 0, '', 0, 0, 0, 0, 0, 2, 2, 0, 0, 0, 20, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 13329);
DELETE FROM `creature_equip_template` WHERE `entry` = 25588;
INSERT INTO `creature_equip_template` VALUES (25588, 47994, 0, 0, 50268674, 0, 0, 529, 0, 0);

-- Orb Target 25640
UPDATE `creature_template` SET `modelid_A` = 11686, `unit_flags` = 33554432 WHERE `entry` = 25640;

-- Kil'jaeden 25608- mob_kiljaeden_controller
UPDATE `creature_template` SET `faction_A` = 14, `faction_H` = 14, `unit_flags` = 33555206, `flags_extra` = 128 WHERE `entry` = 25608; -- 114 0

-- Felfire Portal 25603- (mob_felfire_portal)
UPDATE `creature_template` SET `minlevel` = 72, `maxlevel` = 72, `minhealth` = 100000, `maxhealth` = 100000, `faction_A` = 14, `faction_H` = 14, `unit_flags` = 33554694, `AIName` = 'EventAI' WHERE `entry` = 25603;
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 25603;
INSERT INTO `creature_ai_scripts` VALUES ('2560301','25603','11','0','100','2','0','0','0','0','11','46464','0','0','0','0','0','0','0','0','0','0','Felfire Portal - Cast Summon Felfire Fiend on Spawn');
INSERT INTO `creature_ai_scripts` VALUES (2560302, 25603, 0, 0, 100, 3, 2000, 2000, 2000, 2000, 39, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Felfire Portal - Call for Help');

-- Volatile Felfire Fiend 25598- mob_volatile_felfire_fiend
-- https://wowwiki.fandom.com/wiki/Volatile_Felfire_Fiend
-- https://www.wowhead.com/npc=25598/volatile-felfire-fiend#comments
UPDATE `creature_template` SET `speed` = 1.20, `mindmg` = 1000, `maxdmg` = 4000, `baseattacktime` = 1400 WHERE `entry` = 25598; -- 500 3000
DELETE FROM `creature_template_addon` WHERE `entry` = 25598;
INSERT INTO `creature_template_addon` VALUES (25598, 0, 0, 0, 0, 0, 0, 0, '45769 0 45769 1');

-- Sinister Reflection 25708- REQUIRES C++ SCRIPTING (PART OF BOSS EVENT)
-- name etc xD 
UPDATE `creature_template` SET `armor`= 5475 WHERE entry = 25708;

-- Shield Orb 25502- 

-- Kalecgos 25319- boss_kalecgos_kj

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

-- ===========
-- General
-- ===========

UPDATE `creature` SET `MovementType`='0',`spawndist`='0' WHERE `guid` IN (48161,48195,48392,48359,48398,48393,53026,48373,48395);
UPDATE `creature` SET `spawndist`='0' WHERE `guid` IN (48397,48194,48396);
UPDATE `creature_addon` SET `path_id`='0' WHERE `guid` IN (48161,48195,48392,48359,48398,48393,53026,48373,48395);

-- =============

SET @GUID := 44148;
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,NULL);
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, 1790.2312, 649.8289, 34.2081,5000,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 1781.5915, 631.7940, 39.1183,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 1784.1307, 610.8291, 45.1837,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 1792.1534, 599.5014, 50.6986,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 1804.3690, 592.4429, 50.7100,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 1817.9945, 590.1019, 50.6082,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 1842.6851, 601.7351, 40.8516,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 1851.8585, 627.3681, 34.2080,5000,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 1842.6851, 601.7351, 40.8516,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 1817.9945, 590.1019, 50.6082,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 1804.3690, 592.4429, 50.7100,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 1792.1534, 599.5014, 50.6986,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 1784.1307, 610.8291, 45.1837,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 1781.5915, 631.7940, 39.1183,0,0,0,100,0);

UPDATE `creature` SET `position_x`='1855.7766', `position_y`='499.2117', `position_z`='82.9058', `orientation`='5.5927' WHERE `guid` = 172355;
UPDATE `creature` SET `position_x`='1866.3587', `position_y`='490.4679', `position_z`='82.9058', `orientation`='2.4511' WHERE `guid` = 172143;
UPDATE `creature` SET `position_x`='1857.3665', `position_y`='489.9987', `position_z`='82.9058', `orientation`='0.8803' WHERE `guid` = 171882;

UPDATE `creature` SET `spawndist` = 5, `MovementType` = 1 WHERE `id` = 2110 AND `map` = 580;

UPDATE `creature` SET `position_x`='1783.8576', `position_y`='999.1840', `position_z`='16.6678', `orientation`='3.8213' WHERE `guid` = 45572;

UPDATE `creature` SET `position_x`='1659.6955', `position_y`='1050.7530', `position_z`='15.9860',`orientation`='4.2728',`spawndist`='0',`MovementType`='0' WHERE `guid` = 54858;
UPDATE `creature` SET `position_x`='1650.0476', `position_y`='1049.2513', `position_z`='15.9880',`orientation`='0.1658',`spawndist`='0',`MovementType`='0' WHERE `guid` = 54988;
UPDATE `creature` SET `position_x`='1651.3247', `position_y`='1048.0362', `position_z`='15.9895',`orientation`='0.4054',`spawndist`='0',`MovementType`='0' WHERE `guid` = 56686;
UPDATE `creature` SET `position_x`='1656.2410', `position_y`='1045.3950', `position_z`='15.9861',`orientation`='1.4853',`spawndist`='0',`MovementType`='0' WHERE `guid` = 43661;
UPDATE `creature` SET `position_x`='1748.3822', `position_y`='1058.1184', `position_z`='15.9857',`orientation`='4.4737',`spawndist`='0',`MovementType`='0' WHERE `guid` = 54818;

UPDATE `creature` SET `position_x`='1612.5780', `position_y`='530.4619', `position_z`='50.5754' WHERE `guid` = 44373;
UPDATE `creature` SET `position_x`='1592.2766', `position_y`='555.1853', `position_z`='50.5758' WHERE `guid` = 44358;
UPDATE `creature` SET `MovementType`='0' WHERE `guid` = 44021;

-- Waypoints für den ersten Beschützer
SET @NPC := 48394;
UPDATE `creature` SET `MovementType` = 2 WHERE guid = @NPC;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes0`, `bytes2`,`auras`) VALUES (@NPC,@PATH,1,0, '18950 0 18950 1 45769 0 45769 1'); 
DELETE FROM `waypoint_data` WHERE `id`=@PATH; -- @PATH = @NPC*10
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
(@PATH,1,1656.17,865.65,14.61,0,0,0,100,0),   
(@PATH,2,1669.06,868.56,14.62,0,0,0,100,0),  
(@PATH,3,1674.43,880.31,14.62,0,0,0,100,0),  
(@PATH,4,1672.44,893.33,14.62,0,0,0,100,0),  
(@PATH,5,1661.19,905.34,14.62,0,0,0,100,0),  
(@PATH,6,1650.49,906.17,14.62,0,0,0,100,0),   
(@PATH,7,1638.08,899.81,14.61,0,0,0,100,0),   
(@PATH,8,1631.89,886.22,14.62,0,0,0,100,0),  
(@PATH,9,1637.74,873.78,14.62,0,0,0,100,0),  
(@PATH,10,1647.58,865.74,14.62,0,0,0,100,0);

-- Waypoints First Scout
SET @NPC := 48372;
UPDATE `creature` SET `MovementType` = 2 WHERE guid = @NPC;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` VALUES (@NPC,@PATH,0,0,0,0,0,0,'18950 0 18950 1 45769 0 45769 1'); 
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,1649.1375,985.2145,15.9867,0,0,0,100,0), 
(@PATH,2,1653.4678,985.2236,15.9867,0,0,0,100,0),
(@PATH,3,1664.0245,984.6853,15.9863,0,0,0,100,0),
(@PATH,4,1672.4881,991.7756,15.9864,0,0,0,100,0),
(@PATH,5,1679.8076,987.9536,15.9864,0,0,0,100,0),
(@PATH,6,1677.4213,980.9716,15.9864,0,0,0,100,0),
(@PATH,7,1666.7958,985.0986,15.9864,0,0,0,100,0), 
(@PATH,8,1653.7952,985.0283,15.9858,0,0,0,100,0),
(@PATH,9,1643.8254,975.4205,15.9863,0,0,0,100,0),
(@PATH,10,1635.3272,976.9647,16.4563,0,0,0,100,0),
(@PATH,11,1637.9610,1005.4556,16.4487,0,0,0,100,0),
(@PATH,12,1650.7630,1026.3789,16.0503,0,0,0,100,0), 
(@PATH,13,1654.3763,1019.1048,15.9858,0,0,0,100,0),
(@PATH,14,1649.9709,1009.2127,15.9858,0,0,0,100,0),
(@PATH,15,1647.8199,995.1337,15.9867,0,0,0,100,0);

-- Waypoints Second Scout
SET @NPC := 48160;
UPDATE `creature` SET `MovementType` = 2 WHERE guid = @NPC;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` VALUES (@NPC,@PATH,0,0,0,0,0,0,'18950 0 18950 1 45769 0 45769 1'); 
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,1668.1219,1038.0729,15.9858,0,0,0,100,0),
(@PATH,2,1664.6563,1041.3403,15.9858,0,0,0,100,0),
(@PATH,3,1651.6079,1053.3558,15.9858,0,0,0,100,0),
(@PATH,4,1640.4869,1049.7308,15.9858,0,0,0,100,0),
(@PATH,5,1628.7757,1055.5941,15.9858,0,0,0,100,0),
(@PATH,6,1629.0402,1067.6004,15.9858,0,0,0,100,0),
(@PATH,7,1637.6523,1074.4165,15.9858,0,0,0,100,0),
(@PATH,8,1652.0452,1068.1798,15.9859,0,0,0,100,0),
(@PATH,9,1653.0870,1062.6463,15.9858,0,0,0,100,0),
(@PATH,10,1651.6079,1053.3558,15.9858,0,0,0,100,0),
(@PATH,11,1664.6563,1041.3403,15.9858,0,0,0,100,0),
(@PATH,12,1679.0791,1059.8856,15.9865,0,0,0,100,0),
(@PATH,13,1685.0937,1038.8366,16.4861,0,0,0,100,0),
(@PATH,14,1673.5291,1022.8729,16.6732,0,0,0,100,0);

-- Waypoints Third Scout
SET @NPC := 48162;
UPDATE `creature` SET `MovementType` = 2 WHERE guid = @NPC;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` VALUES (@NPC,@PATH,0,0,0,0,0,0,'18950 0 18950 1 45769 0 45769 1'); 
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,1739.3854,1070.6688,15.9856,0,0,0,100,0),
(@PATH,2,1741.1446,1053.2598,15.9856,0,0,0,100,0),
(@PATH,3,1749.2460,1038.9570,15.9856,0,0,0,100,0),
(@PATH,4,1731.4649,1050.9511,15.9856,0,0,0,100,0);
-- X: 1732,239990 Y: 1063,640015 Z: 15,9856 

SET @NPC := 48397;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` VALUES (@NPC,@PATH,0,0,0,4097,0,0,'18950 0 18950 1 45769 0 45769 1'); 
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,1631.7224,1090.8413,40.5919,0,0,0,100,0),
(@PATH,2,1619.8559,1081.7222,37.8167,0,0,0,100,0),
(@PATH,3,1611.8708,1067.7249,36.2818,0,0,0,100,0),
(@PATH,4,1611.6208,1045.9901,36.3396,0,0,0,100,0),
(@PATH,5,1611.8708,1067.7249,36.2818,0,0,0,100,0),
(@PATH,6,1619.8559,1081.7222,37.8167,0,0,0,100,0),
(@PATH,7,1631.7224,1090.8413,40.5919,0,0,0,100,0),
(@PATH,8,1645.8975,1095.1163,44.3442,0,0,0,100,0),
(@PATH,9,1686.5241,1096.3372,52.7500,0,0,0,100,0),
(@PATH,10,1727.9289,1095.6203,52.7506,0,0,0,100,0),
(@PATH,11,1753.4581,1094.0429,47.9430,0,0,0,100,0),
(@PATH,12,1768.8269,1092.6636,44.6278,0,0,0,100,0),
(@PATH,13,1784.9759,1088.0688,40.4936,0,0,0,100,0),
(@PATH,14,1796.4836,1078.3801,37.7741,0,0,0,100,0),
(@PATH,15,1803.5675,1064.0328,36.2685,0,0,0,100,0),
(@PATH,16,1803.3717,1042.6096,36.3397,0,0,0,100,0),
(@PATH,17,1803.5675,1064.0328,36.2685,0,0,0,100,0),
(@PATH,18,1796.4836,1078.3801,37.7741,0,0,0,100,0),
(@PATH,19,1784.9759,1088.0688,40.4936,0,0,0,100,0),
(@PATH,20,1768.8269,1092.6636,44.6278,0,0,0,100,0),
(@PATH,21,1753.4581,1094.0429,47.9430,0,0,0,100,0),
(@PATH,22,1727.9289,1095.6203,52.7506,0,0,0,100,0),
(@PATH,23,1686.5241,1096.3372,52.7500,0,0,0,100,0),
(@PATH,24,1645.8975,1095.1163,44.3442,0,0,0,100,0);

SET @NPC := 48400;
UPDATE `creature` SET `MovementType` = 2 WHERE guid = @NPC;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes0`, `bytes2`,`auras`) VALUES (@NPC,@PATH,1,0, '18950 0 18950 1 45769 0 45769 1'); 
DELETE FROM `waypoint_data` WHERE `id`=@PATH; -- @PATH = @NPC*10
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-- (@PATH,1,XXX,YYY,ZZZ,0,0,0,100,0),
(@PATH,1,1706.83,1066.14,52.86,0,0,0,100,0),   
(@PATH,2,1706.98,1071.27,52.85,0,0,0,100,0),  
(@PATH,3,1705.25,1011.89,53.00,0,0,0,100,0),  
(@PATH,4,1704.51,969.46,53.06,0,0,0,100,0),  
(@PATH,5,1705.25,1011.89,53.00,0,0,0,100,0); 

-- ======================================================
-- Group Linking
-- ======================================================

DELETE FROM `creature_formations` WHERE `leaderguid` = 44279;
DELETE FROM `creature_formations` WHERE `LeaderGUID` IN (48397) OR `MemberGUID` IN (48397,48161,48392,48195);
INSERT INTO `creature_formations` VALUES
(48397,48397,2,360,2),
(48397,48161,2,2,2),
(48397,48392,2,3,2),
(48397,48195,2,4,2);

DELETE FROM `creature_formations` WHERE `LeaderGUID` IN (48194) OR `MemberGUID` IN (48194,48398,48359,48393);
INSERT INTO `creature_formations` VALUES
(48194,48194,2,360,2),
(48194,48398,2,2,2),
(48194,48359,2,3,2),
(48194,48393,2,4,2);

DELETE FROM `creature_formations` WHERE `LeaderGUID` IN (48396) OR `MemberGUID` IN (48396,53026,48373,48395);
INSERT INTO `creature_formations` VALUES
(48396,48396,2,360,2),
(48396,53026,2,2,2),
(48396,48373,2,3,2),
(48396,48395,2,4,2);

DELETE FROM `creature_formations` WHERE `MemberGUID` IN (43440,42593,48521,42655,54833,43738,54819,48360);
INSERT INTO `creature_formations` VALUES
(43440,43440,100,360,2),
(43440,42593,100,360,2),
(43440,42655,100,360,2),
(43440,54833,100,360,2),
(43440,43738,100,360,2),
(43440,54819,100,360,2),
(43440,48360,100,360,2);

DELETE FROM `creature_formations` WHERE `MemberGUID` IN (42594,43655,54818,42590,54836,42658,48162);
INSERT INTO `creature_formations` VALUES
(42594,42594,100,360,2),
(42594,43655,100,360,2),
(42594,54818,100,360,2),
(42594,42590,100,360,2),
(42594,54836,100,360,2),
(42594,42658,100,360,2),
(42594,48162,100,360,2);

DELETE FROM `creature_formations` WHERE `MemberGUID` IN (54816,54837,54858,43661,54988,56686,48160);
INSERT INTO `creature_formations` VALUES
(54816,54816,100,360,2),
(54816,54837,100,360,2),
(54816,54858,100,360,2),
(54816,43661,100,360,2),
(54816,54988,100,360,2),
(54816,56686,100,360,2),
(54816,48160,100,360,2);

DELETE FROM `creature_formations` WHERE `MemberGUID` IN (54826,43739,42595,54838,42661,41817,48372);
INSERT INTO `creature_formations` VALUES
(54826,54826,100,360,2),
(54826,43739,100,360,2),
(54826,42595,100,360,2),
(54826,54838,100,360,2),
(54826,42661,100,360,2),
(54826,41817,100,360,2),
(54826,48372,100,360,2);

DELETE FROM `creature_formations` WHERE `MemberGUID` IN (42645,54992,56933,42583,42871,54823,54822);
INSERT INTO `creature_formations` VALUES
(42645,42645,100,360,2),
(42645,54992,100,360,2),
(42645,56933,100,360,2),
(42645,42583,100,360,2),
(42645,42871,100,360,2),
(42645,54823,100,360,2),
(42645,54822,100,360,2);

DELETE FROM `creature_formations` WHERE `MemberGUID` IN (42874,42588,54821,54860,57041,54828,54831);
INSERT INTO `creature_formations` VALUES
(42874,42874,100,360,2),
(42874,42588,100,360,2),
(42874,54821,100,360,2),
(42874,54860,100,360,2),
(42874,57041,100,360,2),
(42874,54828,100,360,2),
(42874,54831,100,360,2);

DELETE FROM `creature_formations` WHERE `MemberGUID` IN (42587,54824,42640,54829,42659,42586);
INSERT INTO `creature_formations` VALUES
(42587,42587,100,360,2),
(42587,54824,100,360,2),
(42587,42640,100,360,2),
(42587,54829,100,360,2),
(42587,42659,100,360,2),
(42587,42586,100,360,2);

DELETE FROM `creature_formations` WHERE `MemberGUID` IN (42592,54825,42657,54835,42660,42591);
INSERT INTO `creature_formations` VALUES
(42592,42592,100,360,2),
(42592,54825,100,360,2),
(42592,42657,100,360,2),
(42592,54835,100,360,2),
(42592,42660,100,360,2),
(42592,42591,100,360,2);

DELETE FROM `creature_formations` WHERE `MemberGUID` IN (42574,54817,42656,54834,43654,42573);
INSERT INTO `creature_formations` VALUES
(42574,42574,100,360,2),
(42574,54817,100,360,2),
(42574,42656,100,360,2),
(42574,54834,100,360,2),
(42574,43654,100,360,2),
(42574,42573,100,360,2);

-- Kanalisieren noch nicht auf Kern
DELETE FROM `creature_formations` WHERE `MemberGUID` IN (43439,54820,42582,42894,54832,42647);
INSERT INTO `creature_formations` VALUES
(43439,43439,100,360,2),
(43439,54820,100,360,2),
(43439,42582,100,360,2),
(43439,42894,100,360,2),
(43439,54832,100,360,2),
(43439,42647,100,360,2);

DELETE FROM `creature_formations` WHERE `MemberGUID` IN (42644,54827,42584,42585,54830,42870);
INSERT INTO `creature_formations` VALUES
(42644,42644,100,360,2),
(42644,54827,100,360,2),
(42644,42584,100,360,2),
(42644,42585,100,360,2),
(42644,54830,100,360,2),
(42644,42870,100,360,2);

DELETE FROM `creature_formations` WHERE `MemberGUID` IN (44021,286016);
INSERT INTO `creature_formations` VALUES
(286016,286016,100,360,2),
(286016,44021,5,2.1,2);

DELETE FROM `creature_formations` WHERE `memberguid` IN (56332,4248546,259913,44468,55063,45514,55105,55422,55421,55352,55134,55476,55375,44050,44059,89032,45516,44458,89032,44024,44421,44061,44079,44175,44239,44279,44358,44373,45106,44408,44023,44407,45516,44458,44465,44328,43742,23267);
DELETE FROM `creature_formations` WHERE `leaderguid` IN (56332,4248546,259913,44468,55063,45514,55105,55422,55421,55352,55134,55476,55375,44050,44059,89032,45516,44458,89032,44024,44421,44061,44079,44175,44239,44279,44358,44373,45106,44408,44023,44407,45516,44458,44465,44328,43742,23267);
INSERT INTO `creature_formations` VALUES

(259913,259913,0,0,2),
(259913,56332,0,0,2),
(259913,44468,0,0,2),
(259913,55063,0,0,2),
(259913,45514,0,0,2),

(55105,55105,0,0,2),
(55105,55422,0,0,2),
(55105,55421,0,0,2),

(55352,55352,0,0,2),
(55352,55134,0,0,2),
(55352,55476,0,0,2),
(55352,55375,0,0,2),

-- (44358,44358,0,0,2),
-- (44358,44373,0,0,2),

(43742,43742,0,0,2),
(43742,44465,0,0,2),
(43742,44328,0,0,2),

-- (44175,44175,0,0,2),
-- (44175,44239,0,0,2),

-- (44079,44079,0,0,2),
-- (44079,44239,0,0,2),

(44059,44059,0,0,2),
(44059,45516,0,0,2),
(44059,44458,0,0,2),
(44059,89032,0,0,2),
(44059,44024,0,0,2),
(44059,44421,0,0,2),

-- (44050,44050,0,0,2),
-- (44050,44061,0,0,2),

(45106,45106,0,0,2),
(45106,44408,0,0,2),
(45106,44023,0,0,2),
(45106,44407,0,0,2);
-- (45106,63716,0,0,2);

-- ======================================================
-- Respawn Linking
-- ======================================================

DELETE FROM `creature_linked_respawn` WHERE `guid` IN (44468,23267,42593,48521,45572,54810,55065,44465,43769);
DELETE FROM `creature_linked_respawn` WHERE `linkedguid` IN (53705,259913);
INSERT INTO `creature_linked_respawn` VALUES

(259913,259913),
(44468,259913),
(55063,259913),
(45514,259913),
(55066,259913),
(48401,259913),

(44465,53705),
(43742,53705),
(44328,53705),
(47769,53705),
(47768,53705),
(47313,53705),
(47608,53705),
(47471,53705),
(47607,53705),
(55370,53705),
(55067,53705),
(55478,53705),
(55477,53705),
(47898,53705),
(47899,53705),
(47044,53705),
(47265,53705),
(47309,53705),
(47153,53705),
(47893,53705),
(47901,53705),
(47454,53705),
(47155,53705),
(48151,53705),
(47154,53705),
(47449,53705),
(55105,53705),
(55421,53705),
(55422,53705),
(55474,53705),
(56331,53705),
(55374,53705),
(55475,53705),
(56329,53705),
(55373,53705),
(55069,53705),
(56330,53705),
(55417,53705),
(55418,53705),
(48402,53705),
(55352,53705),
(55134,53705),
(55476,53705),
(55375,53705),
(55448,53705),
(55419,53705),
(48404,53705),
(48403,53705),
(172355,53705),
(172143,53705),
(171882,53705),
(47884,53705),
(47875,53705),
(47475,53705),
(47897,53705),
(47578,53705),
(47470,53705),
(55423,53705),
(55473,53705),
(53705,53705),

(43769,53687),
-- (XXX,53687),

(42593,53645),
(45572,53645),
(54810,53645),
(55065,53645);

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

-- ======================================================
-- Miscellaneous & Loot
-- ======================================================

-- General Loot Template for Trash after Felmyst
DELETE FROM `creature_loot_template` WHERE `entry` = 25486;
INSERT INTO `creature_loot_template` VALUES (25486, 21877, 29.5, 0, 2, 3, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (25486, 34664, 6, 0, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (25486, 32897, 15, 0, 1, 1, 0, 0, 0);
-- 24000 -- 61 Grey Armor for > 67
INSERT INTO `creature_loot_template` VALUES (25486, 24001, 3, 1, -24001, 1, 0, 0, 0); -- 64 Grey Weapons
INSERT INTO `creature_loot_template` VALUES (25486, 24002, 3, 1, -24002, 1, 0, 0, 0); -- 67 Grey Armor for < 67
-- 24003 -- 60-61 Green Items
-- 24004 -- 60-61 Blue Items
-- 24005 -- 62-63 Green Items
-- 24006 -- 62-63 Blue Items
-- 24007 -- 64-65 Green Items
-- 24008 -- 64-65 Blue Items
-- 24009 -- 66-67 Green Items
-- 24010 -- 66-67 Blue Items
INSERT INTO `creature_loot_template` VALUES (25486, 24011, 1, 1, -24011, 1, 0, 0, 0); -- 68-69 Green Items
INSERT INTO `creature_loot_template` VALUES (25486, 24013, 1, 1, -24013, 1, 0, 0, 0); -- 70 Green Items
INSERT INTO `creature_loot_template` VALUES (25486, 34091, 1, 1, -34091, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (25486, 34092, 1, 1, -34092, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (25486, 34093, 10, 1, -34093, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (25486, 34094, 4, 1, -34094, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (25486, 24012, 0.2, 1, -24012, 1, 0, 0, 0); -- 68-69 Blue Items
INSERT INTO `creature_loot_template` VALUES (25486, 24014, 0.2, 1, -24014, 1, 0, 0, 0); -- 70 Blue Items
INSERT INTO `creature_loot_template` VALUES (25486, 24015, 0.05, 1, -24015, 1, 0, 0, 0); -- 70 Epic Items
-- 24016 -- 55-56 Green Items
-- 24017 -- 55-56 Blue Items
-- 24018 -- 57-58 Green Items
-- 24019 -- 57-58 Blue Items
-- 24020 -- 59-60 Green Items
-- 24021 -- 60 Blue Idols
-- 24022 -- 57-58 Outland Green Items
-- 24023 -- 59 Outland Green Items
-- 24024 -- 46-54 Gray Items
-- usw
-- 24035 -- Pots and Scrolls
INSERT INTO `creature_loot_template` VALUES (25486, 24092, 0.05, 1, -24092, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (25486, 24093, 0.05, 1, -24093, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (25486, 10006, 0.01, 1, -24093, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (25486, 50028, 0.1, 1, -50028, 1, 0, 0, 0);

-- Twins Loot should be the same in 2.4.3
UPDATE `creature_loot_template` SET `maxcount` = 4 WHERE `entry` = 25165 AND `item` = 34085; -- 3
DELETE FROM `creature_loot_template` where `entry` = 25165 AND `item` = 34664;
INSERT INTO `creature_loot_template` VALUES (25165, 34664, 100, 0, 4, 4, 0, 0, 0);

-- Kil'jaeden <The Deceiver> 25315
DELETE FROM `creature_loot_template` WHERE `entry` = 25315;
INSERT INTO `creature_loot_template` VALUES (25315, 29434, 100, 0, 3, 3, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (25315, 34096, 100, 1, -34096, 3, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (25315, 34247, 0, 1, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (25315, 34329, 0, 1, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (25315, 34331, 0, 1, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (25315, 34334, 3, 1, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (25315, 34336, 0, 1, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (25315, 34337, 0, 1, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (25315, 34664, 100, 0, 1, 1, 0, 0, 0);

DELETE FROM `reference_loot_template` WHERE `entry` = 34096;
INSERT INTO `reference_loot_template` VALUES (34096, 34241, 0, 1, 1, 1, 0, 0, 0);
INSERT INTO `reference_loot_template` VALUES (34096, 34242, 0, 1, 1, 1, 0, 0, 0);
INSERT INTO `reference_loot_template` VALUES (34096, 34243, 0, 1, 1, 1, 0, 0, 0);
INSERT INTO `reference_loot_template` VALUES (34096, 34244, 0, 1, 1, 1, 0, 0, 0);
INSERT INTO `reference_loot_template` VALUES (34096, 34245, 0, 1, 1, 1, 0, 0, 0);
INSERT INTO `reference_loot_template` VALUES (34096, 34332, 0, 1, 1, 1, 0, 0, 0);
INSERT INTO `reference_loot_template` VALUES (34096, 34333, 0, 1, 1, 1, 0, 0, 0);
INSERT INTO `reference_loot_template` VALUES (34096, 34339, 0, 1, 1, 1, 0, 0, 0);
INSERT INTO `reference_loot_template` VALUES (34096, 34340, 0, 1, 1, 1, 0, 0, 0);
INSERT INTO `reference_loot_template` VALUES (34096, 34341, 0, 1, 1, 1, 0, 0, 0);
INSERT INTO `reference_loot_template` VALUES (34096, 34342, 0, 1, 1, 1, 0, 0, 0);
INSERT INTO `reference_loot_template` VALUES (34096, 34343, 0, 1, 1, 1, 0, 0, 0);
INSERT INTO `reference_loot_template` VALUES (34096, 34344, 0, 1, 1, 1, 0, 0, 0);
INSERT INTO `reference_loot_template` VALUES (34096, 34345, 0, 1, 1, 1, 0, 0, 0);

-- Madrigosa script target fix Ice Barrier at Brutallus Pre Fight Event
-- not implemented yet
DELETE FROM spell_script_target WHERE entry = 46609;
INSERT INTO spell_script_target (entry,type,targetEntry) VALUES
(46609,1,19871);

-- ==========================
-- Not Sunwell related
UPDATE `creature` SET `position_x`='7764.4116',`position_y`='-2408.6730',`position_z`='488.4534',`orientation`='0.0991' WHERE `guid` IN (42503);
UPDATE `creature` SET `position_x`='2404.6975',`position_y`='937.6764',`position_z`='44.7517',`orientation`='4.2882',`spawndist`='0',`MovementType`='0' WHERE `guid` IN (42725);

UPDATE `creature` SET `position_x`='1603.8244', `position_y`='565.1187', `position_z`='50.5756' WHERE `guid` = '44358';
UPDATE `creature` SET `position_x`='1633.2348', `position_y`='513.7696', `position_z`='50.5756' WHERE `guid` = '44373';
UPDATE `creature` SET `position_x`='1624.9622', `position_y`='611.2280', `position_z`='85.0934' WHERE `guid` = '44239';
UPDATE `creature` SET `position_x`='1603.7121', `position_y`='606.1521', `position_z`='85.1185' WHERE `guid` = '44079';

UPDATE `creature` SET `position_z` = 8.1956 WHERE `guid` IN (62845,62846);

DELETE FROM `creature` WHERE `guid` IN (99651,99652);
INSERT INTO `creature` VALUES (99652, 26120, 547, 3, 0, 0, -98.1029, -230.786, -10.8085, 1.44862, 7200, 0, 0, 1, 0, 0, 0);
INSERT INTO `creature` VALUES (99651, 26121, 547, 3, 0, 0, -69.812, -162.495, -2.30451, 1.71042, 7200, 0, 0, 1, 0, 0, 0);

UPDATE `creature_template` SET `InhabitType` = 7 WHERE `entry` IN (26120,26121,25952);

DELETE FROM `game_event_creature` WHERE `guid` IN (93946,93948);
INSERT INTO `game_event_creature` VALUES
(93946,49),
(93948,49);