diff options
| -rw-r--r-- | sql/updates/world/2011_02_20_2_world_instance_icecrown_citadel.sql | 61 |
1 files changed, 61 insertions, 0 deletions
diff --git a/sql/updates/world/2011_02_20_2_world_instance_icecrown_citadel.sql b/sql/updates/world/2011_02_20_2_world_instance_icecrown_citadel.sql new file mode 100644 index 00000000000..1db8c50eae7 --- /dev/null +++ b/sql/updates/world/2011_02_20_2_world_instance_icecrown_citadel.sql @@ -0,0 +1,61 @@ +SET @GUID := 137746; +DELETE FROM `creature` WHERE `guid` BETWEEN @GUID+30 AND @GUID+33; +DELETE FROM `linked_respawn` WHERE `linkedGuid` IN (@GUID+06,@GUID+07) AND `linkType`=0; +INSERT INTO `linked_respawn` (`guid`,`linkedGuid`,`linkType`) VALUES +(@GUID+00,@GUID+06,0), -- Valithria Dreamwalker +(@GUID+01,@GUID+06,0), -- Valithria Dreamwalker +(@GUID+02,@GUID+06,0), -- Risen Archmage +(@GUID+03,@GUID+06,0), -- Risen Archmage +(@GUID+04,@GUID+06,0), -- Risen Archmage +(@GUID+05,@GUID+06,0), -- Risen Archmage +(@GUID+06,@GUID+06,0), -- Green Dragon Combat Trigger +(@GUID+07,@GUID+07,0), -- Sister Svalna +(@GUID+08,@GUID+07,0), -- Ymirjar Frostbinder +(@GUID+09,@GUID+07,0), -- Ymirjar Frostbinder +(@GUID+10,@GUID+07,0), -- Ymirjar Battle-Maiden +(@GUID+11,@GUID+07,0), -- Ymirjar Battle-Maiden +(@GUID+12,@GUID+07,0), -- Ymirjar Battle-Maiden +(@GUID+13,@GUID+07,0), -- Ymirjar Battle-Maiden +(@GUID+14,@GUID+07,0), -- Ymirjar Battle-Maiden +(@GUID+15,@GUID+07,0), -- Ymirjar Battle-Maiden +(@GUID+16,@GUID+07,0), -- Ymirjar Battle-Maiden +(@GUID+17,@GUID+07,0), -- Ymirjar Battle-Maiden +(@GUID+18,@GUID+07,0), -- Ymirjar Warlord +(@GUID+19,@GUID+07,0), -- Ymirjar Warlord +(@GUID+20,@GUID+07,0), -- Ymirjar Warlord +(@GUID+21,@GUID+07,0), -- Ymirjar Warlord +(@GUID+22,@GUID+07,0), -- Ymirjar Huntress +(@GUID+23,@GUID+07,0), -- Ymirjar Huntress +(@GUID+24,@GUID+07,0), -- Ymirjar Huntress +(@GUID+25,@GUID+07,0), -- Ymirjar Huntress +(@GUID+26,@GUID+07,0), -- Ymirjar Huntress +(@GUID+27,@GUID+07,0), -- Ymirjar Huntress +(@GUID+28,@GUID+07,0), -- Ymirjar Deathbringer +(@GUID+29,@GUID+07,0), -- Ymirjar Deathbringer +(151761,@GUID+07,0), -- Captain Arnath +(151762,@GUID+07,0), -- Captain Brandon +(151763,@GUID+07,0), -- Captain Grondel +(151764,@GUID+07,0), -- Captain Rupert +(151767,@GUID+07,0); -- Crok Scourgebane + +SET @EQUIP := 2423; +DELETE FROM `creature_equip_template` WHERE `entry`=@EQUIP; +INSERT INTO `creature_equip_template` (`entry`,`equipentry1`,`equipentry2`,`equipentry3`) VALUES +(@EQUIP+0,45128,0,0), +(@EQUIP+1,47519,0,0), +(@EQUIP+2,45075,0,0), +(@EQUIP+3,48025,0,47521); + +DELETE FROM `creature_template` WHERE `entry` IN (3712202,3712203,3712302,3712303,3712402,3712403,3712502,3712503,3712902,3712903); +UPDATE `creature_template` SET `difficulty_entry_2`=0,`difficulty_entry_3`=0 WHERE `entry`=37122; -- Captain Arnath +UPDATE `creature_template` SET `difficulty_entry_2`=0,`difficulty_entry_3`=0 WHERE `entry`=37123; -- Captain Brandon +UPDATE `creature_template` SET `difficulty_entry_2`=0,`difficulty_entry_3`=0 WHERE `entry`=37124; -- Captain Grondel +UPDATE `creature_template` SET `difficulty_entry_2`=0,`difficulty_entry_3`=0 WHERE `entry`=37125; -- Captain Rupert +UPDATE `creature_template` SET `difficulty_entry_2`=0,`difficulty_entry_3`=0 WHERE `entry`=37129; -- Crok Scourgebane + +UPDATE `creature_template` SET `baseattacktime`=1500,`equipment_id`=@EQUIP+0 WHERE `entry` IN (37122,38298); -- Captain Arnath +UPDATE `creature_template` SET `baseattacktime`=1500,`equipment_id`=@EQUIP+1 WHERE `entry` IN (37123,38299); -- Captain Brandon +UPDATE `creature_template` SET `baseattacktime`=1500,`equipment_id`=@EQUIP+2 WHERE `entry` IN (37124,38303); -- Captain Grondel +UPDATE `creature_template` SET `baseattacktime`=1500,`equipment_id`=@EQUIP+3 WHERE `entry` IN (37125,38304); -- Captain Rupert +UPDATE `creature_template` SET `baseattacktime`=2000,`equipment_id`=2050 WHERE `entry` IN (37129,38000); -- Crok Scourgebane +UPDATE `creature_template` SET `flags_extra`=`flags_extra`|128 WHERE `entry`=38752; -- Green Dragon Combat Trigger |