Elemental Plateau

[Xadras]

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

---

ToDo:

• [ ]

[Xadras]

Sources:

http://wowwiki.wikia.com/wiki/Raging_Fire-Soul , http://www.wowhead.com/npc=22311 , http://wow.freierbund.de/map_and_guide/314649/Erzuernte_Feuerseele-Bilder.html

http://wow.freierbund.de/map_and_guide/314653/Stuermender_Windfeger.html

http://wow.freierbund.de/map_and_guide/314651

https://redmine.rising-gods.de/issues/16221

http://pandariadps.yolasite.com/resources/nagrand-elemental-plateau.jpg.opt881x550o0,0s881x550.jpg https://www.youtube.com/watch?v=h4E0c4XAflU https://www.youtube.com/watch?v=-YQA7V7-dyE https://www.youtube.com/watch?v=LSxtqQICWzo

[Xadras]

#!sql
-- https://github.com/Looking4Group/L4G_Core/issues/416
-- Elemental Plateau

-- Spawns

-- 16800000 - 16800009
UPDATE `creature` SET `spawndist`=5,`movementtype`=1 WHERE `id` = 22310;
DELETE FROM `creature` WHERE `guid` IN (16800000,16800001);
INSERT INTO `creature` VALUES
(16800000,22310,530,1,0,0,-840.0236,6542.0161,171.1328,5.9890,300,5,0,0,0,0,1),
(16800001,22311,530,1,0,0,-786.2155,6540.7275,173.1196,2.0817,300,5,0,0,0,0,1);

-- 12x Storming Wind-Ripper 22310 (should be 12)
UPDATE `creature_template` SET `armor`='6100',`speed`='1.20',`resistance3`='0', `resistance6` = '-1'  WHERE `entry` = 22310; -- 20
-- DELETE FROM `creature_template_addon` WHERE `entry` = 22310;
-- UPDATE `creature_template_addon` SET `auras`='' WHERE `entry` = 22310;
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 22310;
INSERT INTO `creature_ai_scripts` VALUES
(2231001,22310,0,0,100,1,10000,10000,10000,10000,11,12550,0,33,0,0,0,0,0,0,0,0,'Storming Wind-Ripper - Cast Lightning Shield IC'),
(2231002,22310,1,0,100,1,1000,1000,60000,60000,11,12550,0,1,0,0,0,0,0,0,0,0,'Storming Wind-Ripper - Cast Lightning Shield OOC'),
(2231003,22310,9,0,100,1,0,40,3000,6000,0,0,0,0,11,20295,1,0,0,0,0,0,'Storming Wind-Ripper - Cast Lighting Bolt');

-- 12x Raging Fire-Soul 22311 (should be 8)
UPDATE `creature_template` SET `resistance2` = '-1',`scriptname`='',`flags_extra`=`flags_extra`|'536870912' WHERE `entry` = 22311; -- npc_erzuernte_FeuerseeleAI und mmap disable for reset issues
DELETE FROM `creature_template_addon` WHERE `entry` = 22311;
-- UPDATE `creature_template_addon` SET `auras`='' WHERE `entry` = 22311; -- 29948 0 needs core spellwork to function as proper aura
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 22311;

-- 10x Rumbling Earth-Heart 22313
-- maybe implement movement for two of them
UPDATE `creature_template` SET `speed`='1.20',`AIName`='EventAI' WHERE `entry` = 22313;
UPDATE `creature_template_addon` SET `auras`='34308 0' WHERE `entry` = 22313;
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 22313;
INSERT INTO `creature_ai_scripts` VALUES
(2231301,22313,9,0,100,1,0,5,14000,16000,11,33840,0,0,0,0,0,0,0,0,0,0,'Rumbling Earth-Heart  - Cast Earth Rumble'),
(2231302,22313,2,0,100,0,30,0,0,0,11,8599,0,0,1,-106,0,0,0,0,0,0,'Rumbling Earth-Heart - Casts Enrage at 30% HP');

-- 14x Crashing Wave-Spirit 22309 npc_Wasserelementar (should be 11)
UPDATE `creature_template` SET `speed`='1.20',`resistance4`='0' WHERE `entry` = 22309;
UPDATE `creature_template_addon` SET `auras`='7940 0' WHERE `entry` = 22309;

--  Repositioning
UPDATE `creature` SET `movementtype`='1',`spawndist`='5' WHERE `id` = 22311;
UPDATE `creature` SET `position_x`='-825.3634', `position_y`='6618.4624', `position_z`='175.4391' WHERE `guid` = 78466;
UPDATE `creature` SET `position_x`='-794.4229', `position_y`='6581.7529', `position_z`='171.3957' WHERE `guid` = 78474;
UPDATE `creature` SET `position_x`='-679.4104', `position_y`='6566.6533', `position_z`='170.9530' WHERE `guid` = 78473;
UPDATE `creature` SET `position_x`='-750.3014', `position_y`='6551.8862', `position_z`='170.9357' WHERE `guid` = 78471;
UPDATE `creature` SET `position_x`='-734.3161', `position_y`='6414.8891', `position_z`='171.5525', `orientation`='2.4091' WHERE `guid` = 78459;
UPDATE `creature` SET `position_x`='-769.2809', `position_y`='6468.4375', `position_z`='184.9504', `orientation`='4.8125' WHERE `guid` = 78457;