Open Xadras opened 8 years ago
http://www.wowhead.com/npc=18697/chief-engineer-lorthander , http://wowwiki.wikia.com/wiki/Chief_Engineer_Lorthander
https://bitbucket.org/Caboon/playcore-official/commits/c557dece1d70d1f2049ff7922644162cb4d9bfdd
https://bitbucket.org/Caboon/playcore-official/commits/b59b6190c42ad8891a3d9bb3120edbd0842cb625
https://bitbucket.org/Caboon/playcore-official/commits/e6bc5a479f495c4a717d8decd939b781e9d2a091
https://bitbucket.org/Caboon/playcore-official/commits/4ada73d7f399d4605f7d032af3710a0d7ff06273
Placeholder
#!sql
-- https://github.com/Looking4Group/L4G_Core/issues/605
-- Netherstorm
-- ======================================================
-- Texts & Scripts
-- ======================================================
-- -9500 - -9599
DELETE FROM `creature_ai_texts` WHERE `entry` BETWEEN -9509 AND -9500;
-- INSERT INTO `creature_ai_texts` VALUES
-- (-9500,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'NethersturmPlatzhalter');
-- ======================================================
-- Spawns & Pooling
-- ======================================================
DELETE FROM `creature` WHERE `guid` = 74414;
INSERT INTO `creature` VALUES
(74414,21233,530,1,0,0,4307.9560,3402.4519,152.2247,4.3812,300,0,0,1,0,0,0);
-- Apex Crumbler should be summoned while fighting with Apex http://www.wowhead.com/?npc=21328#comments, script will follow
DELETE FROM creature WHERE id = 21328;
-- missing banker and smith and commercial blizzard npcs
DELETE FROM `creature` WHERE `guid` IN ('75955','75960','75962','75973');
INSERT INTO `creature` VALUES
(75955,28343,530,1,0,0,2959.0070,3679.3813,144.1191,1.4519,25,0,0,0,0,0,0),
(75960,28344,530,1,0,0,3063.1926,3677.0954,142.6685,4.0290,25,0,0,0,0,0,0),
(75962,29093,0,1,0,0,-8807.0009,638.9830,94.2290,3.7030,25,0,0,0,0,0,0),
(75973,29095,0,1,0,0,1584.4161,201.3631,-43.1023,1.9019,25,0,0,0,0,0,0);
-- ======================================================
-- NPC Research
-- ======================================================
-- Chief Engineer Lorthander 18697
UPDATE `creature_template` SET `speed`='1.48',`mechanic_immune_mask`='753866751' WHERE `entry` = 18697; -- rare elite immunities
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 18697;
INSERT INTO `creature_ai_scripts` VALUES
('1869701','18697','1','0','100','0','0','0','0','0','21','1','0','0','22','0','0','0','0','0','0','0','Chief Engineer Lorthander - Start Combat Movement and Set Phase to 0 on Spawn'),
('1869702','18697','4','0','100','0','0','0','0','0','11','38204','1','0','23','1','0','0','0','0','0','0','Chief Engineer Lorthander - Cast Arcane Bolt and Set Phase 1 on Aggro'),
('1869703','18697','9','13','100','1','0','40','1000','2500','11','38204','1','0','0','0','0','0','0','0','0','0','Chief Engineer Lorthander - Cast Arcane Bolt (Phase 1)'),
('1869704','18697','3','13','100','0','7','0','0','0','21','1','0','0','23','1','0','0','0','0','0','0','Chief Engineer Lorthander - Start Combat Movement and Set Phase 2 when Mana is at 7% (Phase 1)'),
('1869705','18697','9','13','100','0','35','80','0','0','21','1','0','0','0','0','0','0','0','0','0','0','Chief Engineer Lorthander - Start Combat Movement at 35 Yards (Phase 1)'),
('1869706','18697','9','13','100','0','5','15','0','0','21','1','0','0','0','0','0','0','0','0','0','0','Chief Engineer Lorthander - Start Combat Movement at 15 Yards (Phase 1)'),
('1869707','18697','9','13','100','0','0','5','0','0','21','1','0','0','0','0','0','0','0','0','0','0','Chief Engineer Lorthander - Start Combat Movement Below 5 Yards (Phase 1)'),
('1869708','18697','3','11','100','1','100','15','1000','1000','23','-1','0','0','0','0','0','0','0','0','0','0','Chief Engineer Lorthander - Set Phase 1 when Mana is above 15% (Phase 2)'),
('1869709','18697','9','0','100','1','0','30','10000','15000','11','36843','1','47','0','0','0','0','0','0','0','0','Chief Engineer Lorthander - Cast Slow'),
('1869710','18697','0','0','100','1','6000','12000','8000','16000','11','38898','0','7','0','0','0','0','0','0','0','0','Chief Engineer Lorthander - Cast Arcane Unlocking'),
('1869711','18697','2','0','100','0','15','0','0','0','22','3','0','0','0','0','0','0','0','0','0','0','Chief Engineer Lorthander - Set Phase 3 at 15% HP'),
('1869712','18697','2','7','100','0','15','0','0','0','21','1','0','0','25','0','0','0','1','-47','0','0','Chief Engineer Lorthander - Start Combat Movement and Flee at 15% HP (Phase 3)'),
('1869713','18697','7','0','100','0','0','0','0','0','22','0','0','0','0','0','0','0','0','0','0','0','Chief Engineer Lorthander - Set Phase to 0 on Evade'),
('1869714','18697','1','0','100','1','5000','10000','300000','600000','1','-18697','-18698','0','0','0','0','0','0','0','0','0','Chief Engineer Lorthander phrases');
-- Ian Drake 29093
UPDATE `creature_template` SET `minlevel`='35',`maxlevel`='35',`minhealth`='1337',`maxhealth`='1337',`faction_A`='12',`faction_H`='12',`flags_extra`='2',`npcflag`='3' WHERE `entry` = 29093;
-- Edward Cairn 29095
UPDATE `creature_template` SET `minlevel`='35',`maxlevel`='35',`minhealth`='1337',`maxhealth`='1337',`faction_A`='68',`faction_H`='68',`flags_extra`='2',`npcflag`='3' WHERE `entry` = 29095;
-- Blazzle 28344
UPDATE `creature_template` SET `minlevel`='65',`maxlevel`='67',`minhealth`='4747',`maxhealth`='4747',`faction_A`='35',`faction_H`='35',`flags_extra`='2',`npcflag`='4225',`equipment_id`='8028' WHERE `entry` = 28344;
DELETE FROM `creature_equip_template` WHERE `entry` = 8028;
INSERT INTO `creature_equip_template` VALUES
(8028,8576,0,0,218235906,0,0,3,0,0);
INSERT IGNORE INTO `npc_vendor` VALUES
(28344,18567,0,0,0),
(28344,3857,0,0,0),
(28344,3466,0,0,0),
(28344,2880,0,0,0),
(28344,2901,0,0,0),
(28344,5956,0,0,0);
-- Meeda 28343
UPDATE `creature_template` SET `minlevel`='65',`maxlevel`='67',`minhealth`='3820',`maxhealth`='3820',`minmana`='2790',`maxmana`='2933',`faction_A`='35',`faction_H`='35',`flags_extra`='2',`npcflag`='131073' WHERE `entry` = 28343;
-- Mageslayer 18866
UPDATE `creature_template` SET `dmgschool`='6' WHERE `Entry`='18866';
-- Mana Seeker 18867
UPDATE `creature_template` SET `dmgschool`='6' WHERE `Entry`='18867';
-- Mana Beast 21267
UPDATE `creature_template` SET `dmgschool`='6' WHERE `Entry`='21267';
-- Porfus the Gem Gorger 20783
UPDATE `creature_template` SET `mindmg`='567',`maxdmg`='673',`baseattacktime`='1400',`mechanic_immune_mask`='1073692671' WHERE `entry` = 20783;
-- Armbreaker Huffaz 20784
UPDATE `creature_template` SET `mindmg`='567',`maxdmg`='673',`baseattacktime`='1400',`mechanic_immune_mask`='1073692671' WHERE `entry` = 20784;
-- Fel Tinkerer Zortan 20785
UPDATE `creature_template` SET `mindmg`='567',`maxdmg`='673',`baseattacktime`='1400',`mechanic_immune_mask`='1073692671' WHERE `entry` = 20785;
-- Gul'bor 20786
UPDATE `creature_template` SET `mindmg`='567',`maxdmg`='673',`baseattacktime`='1400',`mechanic_immune_mask`='1073692671' WHERE `entry` = 20786;
-- Forgosh 20788
UPDATE `creature_template` SET `mindmg`='567',`maxdmg`='673',`baseattacktime`='1400',`mechanic_immune_mask`='1073692671' WHERE `entry` = 20788;
-- Wrathbringer Laz-tarash 20789
UPDATE `creature_template` SET `mindmg`='567',`maxdmg`='673',`baseattacktime`='1400',`mechanic_immune_mask`='1073692671' WHERE `entry` = 20789;
-- Malevus the Mad 20790
UPDATE `creature_template` SET `mindmg`='525',`maxdmg`='624',`baseattacktime`='1400',`mechanic_immune_mask`='1073692671' WHERE `entry` = 20790;
-- Netherstorm Trigger
UPDATE `creature_template` SET `Inhabittype`='7' WHERE `entry` = 19656;
-- Void Conduit 20899
UPDATE `creature_template` SET `inhabittype`='7' WHERE `entry` = 20899;
-- spell spawned npc 21267
DELETE FROM `creature` WHERE `id` = 21267;
-- 19421
UPDATE `creature_template` SET `inhabittype`='7' WHERE `entry` = 19421;
-- Nether Anomaly
UPDATE `creature_template` SET `faction_A`='1772',`faction_H`='1772' WHERE `entry` = 19686;
-- Nether Beast
UPDATE `creature_template` SET `faction_A`='1772',`faction_H`='1772' WHERE `entry` = 19731;
-- Summoner Kanthin 19657
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 19657;
INSERT INTO `creature_ai_scripts` VALUES
('1965701','19657','4','0','100','0','0','0','0','0','22','1','0','0','0','0','0','0','0','0','0','0','Summoner Kanthin - Set Phase 1 on Aggro'),
('1965702','19657','9','5','100','1','0','40','3400','4800','11','19816','1','0','0','0','0','0','0','0','0','0','Summoner Kanthin - Cast Fireball (Phase 1)'),
('1965703','19657','3','5','100','0','7','0','0','0','22','2','0','0','0','0','0','0','0','0','0','0','Summoner Kanthin - Set Phase 2 when Mana is at 7% (Phase 1)'),
('1965704','19657','3','3','100','1','100','15','1000','1000','22','1','0','0','0','0','0','0','0','0','0','0','Summoner Kanthin - Set Phase 1 when Mana is above 15% (Phase 2)'),
('1965705','19657','9','0','100','1','0','8','12000','16000','11','11831','0','0','0','0','0','0','0','0','0','0','Summoner Kanthin - Cast Frost Nova'),
('1965706','19657','0','0','100','1','10000','14000','18000','21000','11','17273','4','0','0','0','0','0','0','0','0','0','Summoner Kanthin - Cast Pyroblast'),
('1965707','19657','7','0','100','0','0','0','0','0','22','0','0','0','0','0','0','0','0','0','0','0','Summoner Kanthin - Set Phase to 0 on Evade');
-- Area 52 Death Machine 21976
UPDATE `creature_template` SET `faction_A` = 1806, `faction_H` = 1806, `mindmg` = 1000, `maxdmg` = 2000, `flags_extra` = 0 WHERE `entry` = 21976; -- 35 2
-- ======================================================
-- Visuals & Positioning & Movement
-- ======================================================
UPDATE creature SET orientation = 6.10875 WHERE guid = 71046; -- orientation that the wp´s look better
UPDATE `creature` SET `position_x`='2960.0898', `position_y`='2648.5124', `position_z`='116.7493', `orientation`='2.1016',`spawndist`='15',`movementtype`='1' WHERE `guid` = 67734;
UPDATE `creature` SET `movementtype`='0',`spawndist`='0' WHERE `guid` IN ('70090','70091');
-- ======================================================
-- Linking
-- ======================================================
-- ======================================================
-- Respawn
-- ======================================================
-- ======================================================
-- Gameobjects
-- ======================================================
-- ======================================================
-- Loot & Miscellaneous
-- ======================================================
Complete Zone Overhaul for Netherstorm with Focus on Complete Groups, AIs, NPC-Values, Linking, Movement, Immunities, Visuals and Texts.
ToDo:
[ ] Recheck: 18855,20134,19779,20135,20139,20248,21267,18852,19453,18853,19686
[ ] Hauptmann Arathyn
[ ] Import https://github.com/cmangos/tbc-db/commit/9f28c559b155a9ac9a560f499f757017b20bd227