Open Xadras opened 8 years ago
https://github.com/Schaka/TBC-research/issues/24
http://www.wowhead.com/zone=2366/the-black-morass , http://wowwiki.wikia.com/wiki/Opening_the_Dark_Portal , http://wow.gamepedia.com/Opening_the_Dark_Portal
https://www.youtube.com/watch?v=lYLdDZrD3DU https://www.youtube.com/watch?v=GxS5jzMWzes&t=89s
#!sql
-- https://github.com/Looking4Group/L4G_Core/issues/640
-- =========
-- The Black Morass
-- =========
-- ======================================================
-- Texts & Scripts
-- ======================================================
DELETE FROM `creature_ai_texts` WHERE `entry` BETWEEN -9879 AND -9875;
INSERT INTO `creature_ai_texts` VALUES
('-9879','Carry on! Victory at all costs!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','1','0','0','17918 on Despawn'),
('-9878','Continue the fight! Do not falter!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','1','0','0','17918 on Despawn'),
('-9877','There is no time to waste!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','0','0','0','17918 on Spawn'),
('-9876','We must hurry!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','0','0','0','17918 on Spawn'),
('-9875','We must use this time wisely!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','0','0','0','17918 on Spawn');
-- ('-9874',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','0','0','0','HDZ2COMMENT'),
-- =============
-- NPCs
-- =============
-- Imprisoned Infinite Dragonspawn 19959, 20739- Visual Npc
-- Infinite Timereaver 21698, 22167
-- Sa'at 20201
UPDATE `creature_template` SET `npcflag`='3' WHERE `entry` = 20201;
-- Time Keeper 17918,20746
UPDATE `creature_template` SET `AIName`='EventAI',`faction_A`='1',`faction_H`='2',`mindmg`='500',`maxdmg`='500',`armor`='5800',`type_flags`='8' WHERE `entry` = 17918;
UPDATE `creature_template` SET `minhealth`='14000',`maxhealth`='14000',`faction_A`='1',`faction_H`='2',`mindmg`='1000',`maxdmg`='1000',`armor`='6800',`type_flags`='8' WHERE `entry` = 20746;
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 17918;
INSERT INTO `creature_ai_scripts` VALUES
(1791801,17918,0,0,100,7,5000,10000,15000,25000,11,31478,0,0,0,0,0,0,0,0,0,0,'Time Keeper - Casts Sand Breath'),
(1791802,17918,11,0,100,6,0,0,0,0,103,10,0,0,1,-9877,-9876,-9875,0,0,0,0,'Time Keeper - Say on Spawn'),
(1791803,17918,1,0,100,6,1000,1000,0,0,103,10,0,0,0,0,0,0,0,0,0,0,'Time Keeper - Startattack OCC'),
(1791804,17918,1,0,100,6,5000,5000,0,0,41,0,0,0,1,-9879,-9878,0,0,0,0,0,'Time Keeper - Despawn after 5sec OOC');
-- Sable Jaguar 18982, 22173
UPDATE `creature_template` SET `faction_A`='14',`faction_H`='14',`speed`='1.20',`armor`='6200',`baseattacktime`='1450',`inhabittype`='3',`mindmg`='433',`maxdmg`='590',`AIName`='EventAI' WHERE `entry` = 18982; -- 84 189
UPDATE `creature_template` SET `faction_A`='14',`faction_H`='14',`armor`='6800',`lootid`='18982',`skinloot`='70065',`mindmg`='588',`maxdmg`='631' WHERE `entry` = 22173; -- 283 326
DELETE FROM `creature_template_addon` WHERE `entry` IN (18982,22173);
INSERT INTO `creature_template_addon` VALUES
(18982,0,0,512,0,4097,0,0,'18950 0 18950 1'),
(22173,0,0,512,0,4097,0,0,'18950 0 18950 1');
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 18982;
INSERT INTO `creature_ai_scripts` VALUES
('1898201','18982','1','0','100','7','1000','1000','0','0','11','22766','0','32','0','0','0','0','0','0','0','0','Sable Jaguar - Cast Sneak');
-- Blackfang Tarantula 18983, 22162
UPDATE `creature_template` SET `faction_A`='14',`faction_H`='14',`speed`='1.20',`armor`='6200',`baseattacktime`='1600',`inhabittype`='3',`mindmg`='433',`maxdmg`='590',`AIName`='EventAI' WHERE `entry` = 18983; -- 126 283 -
UPDATE `creature_template` SET `faction_A`='14',`faction_H`='14',`armor`='6800',`lootid`='18983',`mindmg`='588',`maxdmg`='631' WHERE `entry` = 22162; -- 283 326
DELETE FROM `creature_template_addon` WHERE `entry` IN (18983,22162);
INSERT INTO `creature_template_addon` VALUES
(18983,0,0,512,0,4097,0,0,''),
(22162,0,0,512,0,4097,0,0,'');
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 18983;
INSERT INTO `creature_ai_scripts` VALUES
('1898301','18983','9','0','100','7','0','5','12800','15200','11','34366','4','1','0','0','0','0','0','0','0','0','Blackfang Tarantula - Cast Ebon Poison');
-- Darkwater Crocolisk 17952, 22163
UPDATE `creature_template` SET `faction_A`='14',`faction_H`='14',`speed`='1.20',`armor`='6200',`baseattacktime`='1600',`inhabittype`='3',`mindmg`='433',`maxdmg`='590',`AIName`='EventAI' WHERE `entry` = 20075; -- 126 283
UPDATE `creature_template` SET `faction_A`='14',`faction_H`='14',`armor`='6800',`lootid`='18982',`skinloot`='70065',`mindmg`='588',`maxdmg`='631' WHERE `entry` = 22163; -- 283 326
DELETE FROM `creature_template_addon` WHERE `entry` IN (20075,22163);
INSERT INTO `creature_template_addon` VALUES
(20075,0,0,512,0,4097,0,0,''),
(22163,0,0,512,0,4097,0,0,'');
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 20075;
INSERT INTO `creature_ai_scripts` VALUES
('2007501','20075','9','0','50','7','0','5','6800','9150','11','34370','1','0','0','0','0','0','0','0','0','0','Darkwater Crocolisk - Cast Jagged Tooth Snap');
-- Infinite Whelp 21818, 22169
UPDATE `creature_template` SET `minlevel`='69',`maxlevel`='69',`faction_A`='14',`faction_H`='14',`minhealth`='2400',`maxhealth`='2400',`mindmg`='132',`maxdmg`='174',`baseattacktime`='1200',`armor`='5500',`speed`='1.20' WHERE `entry` = 21818; -- 2445 40 82
UPDATE `creature_template` SET `minhealth`='3400',`maxhealth`='3400',`faction_A`='14',`faction_H`='14',`mindmg`='300',`maxdmg`='482',`armor`='5800' WHERE `entry` = 22169; -- 3114 240 482
DELETE FROM `creature_template_addon` WHERE `entry` IN (21818,22169);
INSERT INTO `creature_template_addon` VALUES
(21818,0,0,512,0,4097,0,0,''),
(22169,0,0,512,0,4097,0,0,'');
-- Infinite Assassin 17835, 20740
UPDATE `creature_template` SET `faction_A`='14',`faction_H`='14',`mindmg`='300',`maxdmg`='500',`baseattacktime`='1400',`armor`='5800',`speed`='1.20' WHERE `entry` = 17835; -- 191 333
UPDATE `creature_template` SET `faction_A`='14',`faction_H`='14',`minhealth`='11800',`maxhealth`='11800',`mindmg`='800',`maxdmg`='1500',`armor`='5800',`speed`='1.20' WHERE `entry` = 20740; -- 10000 520 1200
DELETE FROM `creature_template_addon` WHERE `entry` IN (17835,20740);
INSERT INTO `creature_template_addon` VALUES
(17835,0,0,512,0,4097,0,0,''),
(20740,0,0,512,0,4097,0,0,'');
-- Infinite Executioner 18994, 20742
UPDATE `creature_template` SET `faction_A`='14',`faction_H`='14',`minhealth`='6500',`maxhealth`='6500',`mindmg`='500',`maxdmg`='1000',`baseattacktime`='2000',`armor`='5800',`speed`='1.20',`equipment_id`='2164' WHERE `entry` = 18994; -- 6000 206 206
UPDATE `creature_template` SET `minhealth`='13000',`maxhealth`='13000',`faction_A`='14',`faction_H`='14',`mindmg`='800',`maxdmg`='1600',`armor`='5800',`equipment_id`='2164' WHERE `entry` = 20742; -- 13972 678 1546
DELETE FROM `creature_template_addon` WHERE `entry` IN (18994,20742);
INSERT INTO `creature_template_addon` VALUES
(18994,0,0,512,0,4097,0,0,''),
(20742,0,0,512,0,4097,0,0,'');
-- Infinite Chronomancer 17892, 20741
UPDATE `creature_template` SET `faction_A`='14',`faction_H`='14',`armor`='4450',`speed`='1.20',`mindmg`='200',`maxdmg`='400',`baseattacktime`='1400' WHERE `entry` = 17892; -- 191 333
UPDATE `creature_template` SET `minhealth`='9800',`maxhealth`='9800',`faction_A`='14',`faction_H`='14',`armor`='4450',`mindmg`='600',`maxdmg`='1200' WHERE `entry` = 20741; -- 8300 526 1668
DELETE FROM `creature_template_addon` WHERE `entry` IN (17892,20741);
INSERT INTO `creature_template_addon` VALUES
(17892,0,0,16908544,0,4097,0,0,''),
(20741,0,0,16908544,0,4097,0,0,'');
-- Infinite Vanquisher 18995, 20743
UPDATE `creature_template` SET `faction_A`='14',`faction_H`='14',`minhealth`='5600',`maxhealth`='5600',`armor`='4450',`speed`='1.20',`mindmg`='200',`maxdmg`='400',`baseattacktime`='1400' WHERE `entry` = 18995; -- 5600 206 206
UPDATE `creature_template` SET `minhealth`='11200',`maxhealth`='11200',`faction_A`='14',`faction_H`='14',`armor`='4450',`mindmg`='600',`maxdmg`='1200' WHERE `entry` = 20743; -- 11178 473 1071
DELETE FROM `creature_template_addon` WHERE `entry` IN (18995,20743);
INSERT INTO `creature_template_addon` VALUES
(18995,0,0,16908544,0,4097,0,0,''),
(20743,0,0,16908544,0,4097,0,0,'');
-- Rift Keeper 21104, 22170, 21148, 22171
UPDATE `creature_template` SET `faction_A`='14',`faction_H`='14',`mindmg`='1210',`maxdmg`='1594',`baseattacktime`='1400',`equipment_id`='986',`mechanic_immune_mask`='1039079163' WHERE `entry` = 21104; -- 369 753
UPDATE `creature_template` SET `faction_A`='14',`faction_H`='14',`mindmg`='3491',`maxdmg`='3822',`equipment_id`='986',`mechanic_immune_mask`='1039079163' WHERE `entry` = 22170; -- 1497 2159 -- 6,981 - 7,643
DELETE FROM `creature_template_addon` WHERE `entry` IN (21104,22170);
INSERT INTO `creature_template_addon` VALUES
(21104,0,0,16908544,0,4097,0,0,'18950 0 18950 1'),
(22170,0,0,16908544,0,4097,0,0,'18950 0 18950 1');
-- Rift Lord 17839, 20744, 21140, 22172
-- MS and Thunderclaps for around 1.5K damage on normal
-- On heroic they MS for 5k
UPDATE `creature_template` SET `mindmg`='1303',`maxdmg`='1717',`faction_A`='14',`faction_H`='14',`baseattacktime`='1800',`equipment_id`='1481',`mechanic_immune_mask`='1039079163' WHERE `entry` = 17839; -- 1000 1300
UPDATE `creature_template` SET `mindmg`='4340',`maxdmg`='4710',`faction_A`='14',`faction_H`='14',`baseattacktime`='0',`equipment_id`='1481',`mechanic_immune_mask`='1039079163' WHERE `entry` = 20744; -- 3400 4000 -- 8,680 - 9,419
DELETE FROM `creature_template_addon` WHERE `entry` IN (17839,20744);
INSERT INTO `creature_template_addon` VALUES
(17839,0,0,512,0,4097,0,0,'18950 0 18950 1'),
(20744,0,0,512,0,4097,0,0,'18950 0 18950 1');
-- =================
-- Bosses
-- =================
-- Chrono Lord Deja 17879,20738
UPDATE `creature_template` SET `faction_A`='14',`faction_H`='14',`minlevel`='72',`maxlevel`='72',`mindmg`='1263',`maxdmg`='1663',`speed`='2',`armor`='5950',`rank`='1' WHERE `entry` = 17879; -- 1263 1663 -- 1,894 - 2,495
UPDATE `creature_template` SET `faction_A`='14',`faction_H`='14',`minlevel`='72',`maxlevel`='72',`mindmg`='3877',`maxdmg`='4054',`skinloot`='70066',`speed`='2',`armor`='5950',`rank`='1' WHERE `entry` = 20738; -- 7,754 - 8,107
-- Infinite Chrono-Lord 21697,21712 when Wipe on Boss on Heroic
UPDATE `creature_template` SET `minlevel`='72',`maxlevel`='72',`faction_A`='14',`faction_H`='14',`armor`='5950',`speed`='2',`mindmg`='3877',`maxdmg`='4054',`baseattacktime`='1400',`unit_flags`='0',`skinloot`='70066',`mingold`='0',`maxgold`='0',`rank`='1' WHERE `entry` = 21697; -- 1 -- 7,754 - 8,107
DELETE FROM `creature_template_addon` WHERE `entry` IN (17879,20738,21697);
INSERT INTO `creature_template_addon` VALUES
(17879,0,0,16908544,0,4097,0,0,'18950 0 18950 1'),
(20738,0,0,16908544,0,4097,0,0,'18950 0 18950 1'),
(21697,0,0,16908544,0,4097,0,0,'18950 0 18950 1');
-- Temporus 17880,20745
UPDATE `creature_template` SET `faction_A`='14',`faction_H`='14',`minlevel`='72',`maxlevel`='72',`mindmg`='1191',`maxdmg`='1570',`rank`='1' WHERE `entry` = 17880; -- 1587 2093 -- 2,381 - 3,139
UPDATE `creature_template` SET `faction_A`='14',`faction_H`='14',`minlevel`='72',`maxlevel`='72',`mindmg`='4323',`maxdmg`='4663',`skinloot`='70066',`flags_extra`='65537',`rank`='1' WHERE `entry` = 20745; -- 8,646 - 9,325
DELETE FROM `creature_template_addon` WHERE `entry` IN (17880,20745);
INSERT INTO `creature_template_addon` VALUES
(17880,0,0,512,0,4097,0,0,'18950 0 18950 1'),
(20745,0,0,512,0,4097,0,0,'18950 0 18950 1');
-- Aeonus 17881,20737
UPDATE `creature_template` SET `faction_A`='14',`faction_H`='14',`minlevel`='72',`maxlevel`='72',`mindmg`='1532',`maxdmg`='2019',`rank`='1' WHERE `entry` = 17881; -- 2042 2691 -- 3,063 - 4,037
UPDATE `creature_template` SET `faction_A`='14',`faction_H`='14',`minlevel`='72',`maxlevel`='72',`speed`='2.00',`mindmg`='4963',`maxdmg`='5312',`skinloot`='70066',`rank`='1' WHERE `entry` = 20737; -- 9,926 - 10,623
DELETE FROM `creature_template_addon` WHERE `entry` IN (17881,20737);
INSERT INTO `creature_template_addon` VALUES
(17881,0,0,512,0,4097,0,0,'18950 0 18950 1'),
(20737,0,0,512,0,4097,0,0,'18950 0 18950 1');
Complete Dungeon Overhaul for The Black Morass with Focus on Complete Groups, AIs, NPC-Values, Linking, Movement, Immunities, Visuals and Texts.
ToDo:
https://github.com/Looking4Group/L4G_Core/issues/476
https://github.com/Looking4Group/L4G_Core/issues/561
Final Boss Aeonus (npc=17881) spams some Emote regardless of what happens resulting in Spam. Proof: http://imgur.com/o2esTJ4 (Minor) "Your time is up, slave of the past!"
Second Boss Temporus (npc=17880) also got some yelling issues when fought (minor).
https://github.com/cmangos/tbc-db/commit/72b23825d00145480dd173154e62fe3d63560bfb
[ ] A defeat in the Caverns of Time: Opening of the Dark Portal instance will no longer despawn unlooted bosses with loot.
[ ] Occasionally after players are defeated in the Caverns of Time: Opening of the Dark Portal encounter on Heroic difficulty, the placeholder versions of the bosses that appear in future attempts that day would not spawn. The proper placeholders will now spawn instead of Rift Lords and Rift Keepers.
[ ] Boss creatures in Caverns of Time: Opening of the Dark Portal will now dispel all nearby Time Keepers instead of one at a time.
http://wowwiki.wikia.com/wiki/Patch_2.0.10
http://wowwiki.wikia.com/wiki/Patch_2.1.0
http://wowwiki.wikia.com/wiki/Patch_2.2.0
http://wowwiki.wikia.com/wiki/Patch_2.4.0