Scripts/Icecrown Citadel

* The Lich King

3 files changed, 301 insertions, 0 deletions

diff --git a/sql/updates/world/2011_10_05_01_world_instance_misc.sql b/sql/updates/world/2011_10_05_01_world_instance_misc.sql
new file mode 100644
index 00000000000..656cdd575d2
--- /dev/null
+++ b/sql/updates/world/2011_10_05_01_world_instance_misc.sql
@@ -0,0 +1,201 @@
+DELETE FROM `creature_text` WHERE `entry` IN (36597,38995,38579,36823,39217);
+INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES
+(36597,0,0,'So the Light''s vaunted justice has finally arrived? Shall I lay down Frostmourne and throw myself at your mercy, Fordring?',14,0,0,0,0,17349,'The Lich King - SAY_LK_INTRO_1'),
+(36597,1,0,'You''ll learn of that first hand. When my work is complete, you will beg for mercy -- and I will deny you. Your anguished cries will be testament to my unbridled power...',14,0,0,22,0,17350,'The Lich King - SAY_LK_INTRO_2'),
+(36597,2,0,'I''ll keep you alive to witness the end, Fordring. I would not want the Light''s greatest champion to miss seeing this wretched world remade in my image.',14,0,0,0,0,17351,'The Lich King - SAY_LK_INTRO_3'),
+(36597,3,0,'Come then champions, feed me your rage!',14,0,0,0,0,0,'The Lich King - SAY_LK_AGGRO'),
+(36597,4,0,'I will freeze you from within until all that remains is an icy husk!',14,0,0,0,0,17369,'The Lich King - SAY_LK_REMORSELESS_WINTER'),
+(36597,5,0,'Watch as the world around you collapses!',14,0,0,0,0,17370,'The Lich King - SAY_LK_QUAKE'),
+(36597,6,0,'Val''kyr, your master calls!',14,0,0,0,0,17373,'The Lich King - SAY_LK_SUMMON_VALKYR'),
+(36597,7,0,'Frostmourne hungers...',14,0,0,0,0,17366,'The Lich King - SAY_LK_HARVEST_SOUL'),
+(36597,8,0,'Argh... Frostmourne, obey me!',14,0,0,0,0,17367,'The Lich King - SAY_LK_FROSTMOURNE_ESCAPE'),
+(36597,9,0,'Frostmourne feeds on the soul of your fallen ally!',14,0,0,0,0,17368,'The Lich King - SAY_LK_FROSTMOURNE_KILL'),
+(36597,10,0,'Hope wanes!',14,0,0,0,0,17363,'The Lich King - SAY_LK_KILL'),
+(36597,10,1,'The end has come!',14,0,0,0,0,17364,'The Lich King - SAY_LK_KILL'),
+(36597,11,0,'Face now your tragic end!',14,0,0,0,0,17365,'The Lich King - SAY_LK_BERSERK'),
+(36597,12,0,'%s begins to cast Defile!',41,0,0,0,0,0,'The Lich King - EMOTE_DEFILE_WARNING'),
+(36597,13,0,'|TInterface\\Icons\\ability_creature_disease_02.blp:16|tYou have been infected by |cFFCF00FFNecrotic Plague!|r',42,0,0,0,0,0,'The Lich King - EMOTE_NECROTIC_PLAGUE_WARNING'),
+(36597,14,0,'No questions remain unanswered. No doubts linger. You ARE Azeroth''s greatest champions. You overcame every challenge I laid before you. My mightiest servants have fallen before your relentless onslaught... your unbridled fury...',14,0,0,0,0,17353,'The Lich King - SAY_LK_OUTRO_1'),
+(36597,15,0,'Is it truly the righteousness that drives you? I wonder...',14,0,0,0,0,17354,'The Lich King - SAY_LK_OUTRO_2'),
+(36597,16,0,'You trained them well, Fordring. You delivered the greatest fighting force this world has ever known... right into my hands -- exactly as I intended. You shall be rewarded for your unwitting sacrifice.',14,0,0,0,0,17355,'The Lich King - SAY_LK_OUTRO_3'),
+(36597,17,0,'Watch now as I raise them from the dead to become masters of the Scourge. They will shroud this world in chaos and destruction. Azeroth''s fall will come at their hands -- and you will be the first to die.',14,0,0,0,0,17356,'The Lich King - SAY_LK_OUTRO_4'),
+(36597,18,0,'I delight in the irony...',14,0,0,0,0,17357,'The Lich King - SAY_LK_OUTRO_5'),
+(36597,19,0,'Impossible...',14,0,0,0,0,17358,'The Lich King - SAY_LK_OUTRO_6'),
+(36597,20,0,'Now I stand, the lion before the lambs... and they do not fear.',14,0,0,0,0,17361,'The Lich King - SAY_LK_OUTRO_7'),
+(36597,21,0,'They cannot fear.',14,0,0,0,0,17362,'The Lich King - SAY_LK_OUTRO_8'),
+(38995,0,0,'We''ll grant you a swift death, Arthas. More than can be said for the thousands you''ve tortured and slain.',14,0,0,0,0,17390,'Highlord Tirion Fordring - SAY_TIRION_INTRO_1'),
+(38995,1,0,'So be it. Champions, attack!',14,0,0,0,0,17391,'Highlord Tirion Fordring - SAY_TIRION_INTRO_2'),
+(38995,2,0,'LIGHT, GRANT ME ONE FINAL BLESSING. GIVE ME THE STRENGTH... TO SHATTER THESE BONDS!',14,0,0,0,0,17392,'Highlord Tirion Fordring - SAY_TIRION_OUTRO_1'),
+(38995,3,0,'No more, Arthas! No more lives will be consumed by your hatred!',14,0,0,0,0,17393,'Highlord Tirion Fordring - SAY_TIRION_OUTRO_2'),
+(38579,0,0,'Free at last! It is over, my son. This is the moment of reckoning.',14,0,0,1,0,17397,'Terenas Menethil - SAY_TERENAS_OUTRO_1'),
+(38579,1,0,'Rise up, champions of the Light!',14,0,0,0,0,17398,'Terenas Menethil - SAY_TERENAS_OUTRO_2'),
+(36823,0,0,'You have come to bring Arthas to justice? To see the Lich King destroyed?',14,0,0,0,0,17394,'Terenas Menethil - SAY_TERENAS_INTRO_1'),
+(36823,1,0,'First, you must escape Frostmourne''s hold, or be damned as I am; trapped within this cursed blade for all eternity.',14,0,0,0,0,17395,'Terenas Menethil - SAY_TERENAS_INTRO_2'),
+(36823,2,0,'Aid me in destroying these tortured souls! Together we will loosen Frostmourne''s hold and weaken the Lich King from within!',14,0,0,0,0,17396,'Terenas Menethil - SAY_TERENAS_INTRO_3'),
+(39217,0,0,'You have come to bring Arthas to justice? To see the Lich King destroyed?',14,0,0,0,0,17394,'Terenas Menethil - SAY_TERENAS_INTRO_1'),
+(39217,1,0,'First, you must escape Frostmourne''s hold, or be damned as I am; trapped within this cursed blade for all eternity.',14,0,0,0,0,17395,'Terenas Menethil - SAY_TERENAS_INTRO_2');
+
+-- Text corrections
+DELETE FROM `creature_text` WHERE `entry`=36627 AND `groupid` IN (4,9);
+DELETE FROM `creature_text` WHERE `entry`=36678 AND `groupid`=9;
+INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES
+(36627,4,0,'|TInterface\\Icons\\spell_shadow_unstableaffliction_2.blp:16|t%s begins to cast |cFFFF0000Unstable Ooze Explosion!|r',41,0,0,0,0,0,'Rotface - EMOTE_UNSTABLE_EXPLOSION'),
+(36627,9,0,'|TInterface\\Icons\\ability_creature_disease_02.blp:16|tYou have |cFF00FF00Mutated Infection!|r',42,0,0,0,0,0,'Rotface - EMOTE_MUTATED_INFECTION'),
+(36678,9,0,'|TInterface\\Icons\\inv_misc_herb_evergreenmoss.blp:16|t%s cast |cFF00FF00Malleable Goo!|r',41,0,0,0,0,0,'Professor Putricide - EMOTE_MALLEABLE_GOO');
+
+UPDATE `creature_template` SET `speed_walk`=2,`speed_run`=1.71429,`exp`=2,`minlevel`=83,`maxlevel`=83,`faction_A`=974,`faction_H`=974,`unit_flags`=768,`dynamicflags`=0,`equipment_id`=2425,`baseattacktime`=1500 WHERE `entry` IN (36597,39166,39167,39168); -- The Lich King
+UPDATE `creature_template` SET `exp`=2,`unit_class`=2 WHERE `entry`=38995; -- Highlord Tirion Fordring
+UPDATE `creature_template` SET `speed_walk`=1.2,`speed_run`=0.428571,`exp`=2,`minlevel`=80,`maxlevel`=80,`faction_A`=14,`faction_H`=14,`dynamicflags`=0 WHERE `entry` IN (36633,39305,39306,39307); -- Ice Sphere
+UPDATE `creature_template` SET `speed_walk`=2,`speed_run`=1.42857,`exp`=2,`minlevel`=83,`maxlevel`=83,`faction_A`=14,`faction_H`=14,`dynamicflags`=0 WHERE `entry`=36701; -- Raging Spirit
+UPDATE `creature_template` SET `speed_walk`=1.2,`speed_run`=0.428571,`exp`=2,`minlevel`=80,`maxlevel`=80,`faction_A`=14,`faction_H`=14,`dynamicflags`=0,`unit_flags`=33554944 WHERE `entry`=38757; -- Defile
+UPDATE `creature_template` SET `minlevel`=80,`maxlevel`=80,`exp`=2,`faction_A`=14,`faction_H`=14,`speed_walk`=2,`speed_run`=1.71429,`unit_flags`=33554944,`dynamicflags`=0,`VehicleId`=532,`InhabitType`=1|4 WHERE `entry` IN (36609,39120,39121,39122); -- Val'kyr Shadowguard
+UPDATE `creature_template` SET `speed_walk`=2,`speed_run`=1.71429,`exp`=2,`minlevel`=83,`maxlevel`=83,`faction_A`=35,`faction_H`=35,`unit_flags`=33554944,`dynamicflags`=0,`VehicleId`=531,`InhabitType`=1|4,`flags_extra`=0 WHERE `entry`=36598; -- Strangulate Vehicle
+UPDATE `creature_template` SET `speed_walk`=1.2,`speed_run`=0.428571,`exp`=2,`minlevel`=80,`maxlevel`=80,`faction_A`=14,`faction_H`=14,`unit_flags`=33554944,`dynamicflags`=0,`flags_extra`=128 WHERE `entry`=38584; -- Frostmourne Trigger
+UPDATE `creature_template` SET `speed_walk`=2.8,`speed_run`=1,`exp`=2,`minlevel`=80,`maxlevel`=80,`faction_A`=14,`faction_H`=14,`unit_flags`=32832,`dynamicflags`=0,`flags_extra`=256,`InhabitType`=1|4 WHERE `entry` IN (37799,39284,39285,39286); -- Vile Spirit
+UPDATE `creature_template` SET `speed_walk`=1,`speed_run`=1,`exp`=2,`minlevel`=80,`maxlevel`=80,`faction_A`=1665,`faction_H`=1665,`unit_flags`=32832,`dynamicflags`=0,`flags_extra`=0,`equipment_id`=2475 WHERE `entry` IN (36823,38579,39217); -- Terenas Menethil
+UPDATE `creature_template` SET `flags_extra`=`flags_extra`|128 WHERE `entry`=24648; -- Invisible Stalker (Scale x2)
+UPDATE `creature_template` SET `difficulty_entry_1`=39287,`difficulty_entry_2`=39288,`difficulty_entry_3`=39289 WHERE `entry`=39190; -- Wicked Spirit
+UPDATE `creature_template` SET `speed_walk`=2.8,`speed_run`=1,`exp`=2,`minlevel`=80,`maxlevel`=80,`faction_A`=14,`faction_H`=14,`unit_flags`=32832,`dynamicflags`=0,`flags_extra`=256,`InhabitType`=1|4 WHERE `entry` IN (39190,39287,39288,39289); -- Wicked Spirit
+UPDATE `creature_template` SET `exp`=2,`minlevel`=83,`maxlevel`=83,`faction_A`=14,`faction_H`=14,`dynamicflags`=0,`flags_extra`=256 WHERE `entry`=36824; -- Spirit Warden
+UPDATE `creature_template` SET `exp`=2,`minlevel`=83,`maxlevel`=83,`faction_A`=14,`faction_H`=14,`dynamicflags`=0,`flags_extra`=128 WHERE `entry`=39137; -- Shadow Trap
+UPDATE `creature_template` SET `exp`=2,`minlevel`=80,`maxlevel`=80,`faction_A`=14,`faction_H`=14,`InhabitType`=1|4,`flags_extra`=`flags_extra`|128 WHERE `entry`=39189; -- Spirit Bomb
+
+-- HACK, Unit::_IsValidAttackTarget returns false because of UNIT_FLAG_OOC_NOT_ATTACKABLE flag
+UPDATE `creature_template` SET `unit_flags`=0x02000000 WHERE `entry`=36171;
+
+UPDATE `creature_model_info` SET `combat_reach`=5.5 WHERE `modelid`=30721; -- The Lich King
+UPDATE `creature_model_info` SET `gender`=0 WHERE `modelid`=31286; -- Highlord Tirion Fordring
+
+DELETE FROM `creature` WHERE `guid`=202865;
+DELETE FROM `creature_addon` WHERE `guid`=150211;
+INSERT INTO `creature_addon` (`guid`,`bytes1`,`auras`) VALUES
+(150211,1,'72846 73220 73878'); -- The Lich King
+
+DELETE FROM `creature_template_addon` WHERE `entry` IN (39137,36609,39120,39121,39122,36598,37799,39284,39285,39286,39190,39287,39288,39289,36823,38579,39217,39189);
+INSERT INTO `creature_template_addon` (`entry`,`bytes1`,`auras`) VALUES
+(39137,0,'73530'),
+(36609,50331648,''), -- Val'kyr Shadowguard
+(39120,50331648,''), -- Val'kyr Shadowguard
+(39121,50331648,''), -- Val'kyr Shadowguard
+(39122,50331648,''), -- Val'kyr Shadowguard
+(36598,50331648,''), -- Strangulate Vehicle
+(37799,50331648,''), -- Vile Spirit
+(39284,50331648,''), -- Vile Spirit
+(39285,50331648,''), -- Vile Spirit
+(39286,50331648,''), -- Vile Spirit
+(39190,50331648,''), -- Wicked Spirit
+(39287,50331648,''), -- Wicked Spirit
+(39288,50331648,''), -- Wicked Spirit
+(39289,50331648,''), -- Wicked Spirit
+(36823,0,'72372'), -- Terenas Menethil
+(38579,0,'72372'), -- Terenas Menethil
+(39217,0,'72372'), -- Terenas Menethil
+(39189,0,'73572'); -- Spirit Bomb
+
+UPDATE `gameobject` SET `rotation3`=1,`animprogress`=255,`spawntimesecs`=604800 WHERE `guid` IN (100056,100061,100064);
+UPDATE `gameobject` SET `rotation2`=1,`animprogress`=255,`spawntimesecs`=604800 WHERE `guid` IN (100057,100058,100059,100060,100062);
+UPDATE `gameobject` SET `rotation3`=1,`animprogress`=255,`spawntimesecs`=-604800 WHERE `guid`=100063;
+
+UPDATE `gameobject_template` SET `faction`=1375,`flags`=32 WHERE `entry`=202438; -- Lavaman Pillars (Unchained)
+UPDATE `gameobject_template` SET `faction`=1375,`flags`=32 WHERE `entry`=202188; -- Doodad_Icecrown_ThroneFrostyWind01
+UPDATE `gameobject_template` SET `faction`=1375,`flags`=32 WHERE `entry`=202189; -- Doodad_Icecrown_ThroneFrostyEdge01
+
+DELETE FROM `gameobject` WHERE `id`=202438;
+INSERT INTO `gameobject` (`guid`,`id`,`map`,`spawnMask`,`position_x`,`position_y`,`position_z`,`rotation3`,`spawntimesecs`,`animprogress`,`state`) VALUES
+(100488,202438,631,15,425.0885,-2123.311,858.6748,1,-604800,255,1);
+
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry` IN (71614,70338,73785,73786,73787,68981,74270,74271,74272,72262,71440,76379,74086,72595,73650,72679,74318,74319,74320,73028,74321,74322,74323,73582,71809,71811,72431,72405,72429,73159);
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES
+(13,0,71614,0,18,1,38995,0,0, '', 'Ice Lock - target Highlord Tirion Fordring'),
+(13,0,70338,0,18,1,0,0,0, '', 'Necrotic Plague - target player'),
+(13,0,70338,0,18,1,37698,0,0, '', 'Necrotic Plague - target Shambling Horror'),
+(13,0,70338,0,18,1,37695,0,0, '', 'Necrotic Plague - target Drudge Ghoul'),
+(13,0,73785,0,18,1,0,0,0, '', 'Necrotic Plague - target player'),
+(13,0,73785,0,18,1,37698,0,0, '', 'Necrotic Plague - target Shambling Horror'),
+(13,0,73785,0,18,1,37695,0,0, '', 'Necrotic Plague - target Drudge Ghoul'),
+(13,0,73786,0,18,1,0,0,0, '', 'Necrotic Plague - target player'),
+(13,0,73786,0,18,1,37698,0,0, '', 'Necrotic Plague - target Shambling Horror'),
+(13,0,73786,0,18,1,37695,0,0, '', 'Necrotic Plague - target Drudge Ghoul'),
+(13,0,73787,0,18,1,0,0,0, '', 'Necrotic Plague - target player'),
+(13,0,73787,0,18,1,37698,0,0, '', 'Necrotic Plague - target Shambling Horror'),
+(13,0,73787,0,18,1,37695,0,0, '', 'Necrotic Plague - target Drudge Ghoul'),
+(13,0,68981,0,18,0,202141,0,0, '', 'Remorseless Winter - target Doodad_IceShard_standing02'),
+(13,0,68981,0,18,0,202142,0,0, '', 'Remorseless Winter - target Doodad_IceShard_standing01'),
+(13,0,68981,0,18,0,202143,0,0, '', 'Remorseless Winter - target Doodad_IceShard_standing03'),
+(13,0,68981,0,18,0,202144,0,0, '', 'Remorseless Winter - target Doodad_IceShard_standing04'),
+(13,0,74270,0,18,0,202141,0,0, '', 'Remorseless Winter - target Doodad_IceShard_standing02'),
+(13,0,74270,0,18,0,202142,0,0, '', 'Remorseless Winter - target Doodad_IceShard_standing01'),
+(13,0,74270,0,18,0,202143,0,0, '', 'Remorseless Winter - target Doodad_IceShard_standing03'),
+(13,0,74270,0,18,0,202144,0,0, '', 'Remorseless Winter - target Doodad_IceShard_standing04'),
+(13,0,74271,0,18,0,202141,0,0, '', 'Remorseless Winter - target Doodad_IceShard_standing02'),
+(13,0,74271,0,18,0,202142,0,0, '', 'Remorseless Winter - target Doodad_IceShard_standing01'),
+(13,0,74271,0,18,0,202143,0,0, '', 'Remorseless Winter - target Doodad_IceShard_standing03'),
+(13,0,74271,0,18,0,202144,0,0, '', 'Remorseless Winter - target Doodad_IceShard_standing04'),
+(13,0,74272,0,18,0,202141,0,0, '', 'Remorseless Winter - target Doodad_IceShard_standing02'),
+(13,0,74272,0,18,0,202142,0,0, '', 'Remorseless Winter - target Doodad_IceShard_standing01'),
+(13,0,74272,0,18,0,202143,0,0, '', 'Remorseless Winter - target Doodad_IceShard_standing03'),
+(13,0,74272,0,18,0,202144,0,0, '', 'Remorseless Winter - target Doodad_IceShard_standing04'),
+(13,0,72262,0,18,1,22515,0,0, '', 'Quake - target World Trigger'),
+(13,0,71440,0,18,1,36597,0,0, '', 'Harvest Soul - target The Lich King'),
+(13,0,76379,0,18,1,36597,0,0, '', 'Harvest Soul - target The Lich King'),
+(13,0,74086,0,18,1,0,0,0, '', 'Destroy Soul - target player'),
+(13,0,72595,0,18,1,0,0,0, '', 'Restore Soul - target player'),
+(13,0,73650,0,18,1,0,0,0, '', 'Restore Soul - target player'),
+(13,0,72679,0,18,1,36597,0,0, '', 'Harvested Soul - target The Lich King'),
+(13,0,74318,0,18,1,36597,0,0, '', 'Harvested Soul - target The Lich King'),
+(13,0,74319,0,18,1,36597,0,0, '', 'Harvested Soul - target The Lich King'),
+(13,0,74320,0,18,1,36597,0,0, '', 'Harvested Soul - target The Lich King'),
+(13,0,73028,0,18,1,36597,0,0, '', 'Harvested Soul - target The Lich King'),
+(13,0,74321,0,18,1,36597,0,0, '', 'Harvested Soul - target The Lich King'),
+(13,0,73650,0,18,1,36597,0,0, '', 'Harvested Soul - target The Lich King'),
+(13,0,74323,0,18,1,36597,0,0, '', 'Harvested Soul - target The Lich King'),
+(13,0,73582,0,18,1,39190,0,0, '', 'Trigger Vile Spirit (Inside, Heroic) - target Wicked Spirit'),
+(13,0,71809,0,18,1,36597,0,0, '', 'Jump - target The Lich King'),
+(13,0,71811,0,18,1,36597,0,0, '', 'Jump - target The Lich King'),
+(13,0,72431,0,18,1,0,0,0, '', 'Jump - target player'),
+(13,0,72405,0,18,1,38995,0,0, '', 'Broken Frostmourne - target Highlord Tirion Fordring'),
+(13,0,72429,0,18,1,0,0,0, '', 'Mass Resurrection - target player'),
+(13,0,73159,0,18,1,0,0,0, '', 'Play Movie - target player');
+
+DELETE FROM `spell_target_position` WHERE `id` IN (70860,72546,73655);
+INSERT INTO `spell_target_position` (`id`,`target_map`,`target_position_x`,`target_position_y`,`target_position_z`,`target_orientation`) VALUES
+(70860,631,529.302,-2124.49, 840.857,3.1765), -- Frozen Throne Teleport
+(72546,631,514.000,-2523.00,1050.990,3.1765), -- Harvest Soul (normal mode)
+(73655,631,495.708,-2523.76,1050.990,3.1765); -- Harvest Soul (heroic mode)
+
+DELETE FROM `spell_area` WHERE `spell`=74276;
+INSERT INTO `spell_area` (`spell`,`area`,`autocast`) VALUES
+(74276,4910,1); -- In Frostmourne Room
+
+DELETE FROM `disables` WHERE `entry` IN (12825,13246,13247,13244,13245,13342,13309,13362,13311,12823,13163,13164,13243,12764,12909,12826,13103,13136,13137,13138,12818) AND `sourceType`=4;
+DELETE FROM `achievement_criteria_data` WHERE `criteria_id` IN (12825,13246,13247,13244,13245,13342,13309,13362,13311,12823,13163,13164,13243,12764,12909,12826,13103,13136,13137,13138,12818);
+INSERT INTO `achievement_criteria_data` (`criteria_id`,`type`,`value1`,`value2`,`ScriptName`) VALUES
+(12825,12,2,0,''), -- Bane of the Fallen King
+(13246,11,0,0,'achievement_been_waiting_long_time'), -- Been Waiting a Long Time for This (10 player)
+(13246,12,0,0,''), -- Been Waiting a Long Time for This (10 player)
+(13247,11,0,0,'achievement_been_waiting_long_time'), -- Been Waiting a Long Time for This (10 player) Heroic
+(13247,12,2,0,''), -- Been Waiting a Long Time for This (10 player) Heroic
+(13244,11,0,0,'achievement_been_waiting_long_time'), -- Been Waiting a Long Time for This (25 player)
+(13244,12,1,0,''), -- Been Waiting a Long Time for This (25 player)
+(13245,11,0,0,'achievement_been_waiting_long_time'), -- Been Waiting a Long Time for This (25 player) Heroic
+(13245,12,3,0,''), -- Been Waiting a Long Time for This (25 player) Heroic
+(13342,12,0,0,''), -- Lich King 10-player bosses killed
+(13309,12,0,0,''), -- Lich King 10-player raids completed (final boss killed)
+(13362,12,1,0,''), -- Lich King 25-player bosses killed
+(13311,12,1,0,''), -- Lich King 25-player raids completed (final boss killed)
+(12823,11,0,0,'achievement_neck_deep_in_vile'), -- Neck-Deep in Vile (10 player)
+(12823,12,0,0,''), -- Neck-Deep in Vile (10 player)
+(13163,11,0,0,'achievement_neck_deep_in_vile'), -- Neck-Deep in Vile (10 player) Heroic
+(13163,12,2,0,''), -- Neck-Deep in Vile (10 player) Heroic
+(13164,11,0,0,'achievement_neck_deep_in_vile'), -- Neck-Deep in Vile (25 player)
+(13164,12,1,0,''), -- Neck-Deep in Vile (25 player)
+(13243,11,0,0,'achievement_neck_deep_in_vile'), -- Neck-Deep in Vile (25 player) Heroic
+(13243,12,3,0,''), -- Neck-Deep in Vile (25 player) Heroic
+(12764,12,0,0,''), -- The Frozen Throne (10 player)
+(12909,12,1,0,''), -- The Frozen Throne (25 player)
+(12826,12,3,0,''), -- The Light of Dawn
+(13103,12,0,0,''), -- Victories over the Lich King (Icecrown 10 player)
+(13136,12,1,0,''), -- Victories over the Lich King (Icecrown 25 player)
+(13137,12,2,0,''), -- Victories over the Lich King (Heroic Icecrown 10 player)
+(13138,12,3,0,''), -- Victories over the Lich King (Heroic Icecrown 25 player)
+(12818,12,3,0,''); -- Realm First! Fall of the Lich King
diff --git a/sql/updates/world/2011_10_05_01_world_scriptname.sql b/sql/updates/world/2011_10_05_01_world_scriptname.sql
new file mode 100644
index 00000000000..742d74f4029
--- /dev/null
+++ b/sql/updates/world/2011_10_05_01_world_scriptname.sql
@@ -0,0 +1,10 @@
+UPDATE `creature_template` SET `ScriptName`='boss_the_lich_king' WHERE `entry`=36597;
+UPDATE `creature_template` SET `ScriptName`='npc_tirion_fordring_tft' WHERE `entry`=38995;
+UPDATE `creature_template` SET `ScriptName`='npc_shambling_horror_icc' WHERE `entry`=37698;
+UPDATE `creature_template` SET `ScriptName`='npc_raging_spirit' WHERE `entry`=36701;
+UPDATE `creature_template` SET `ScriptName`='npc_valkyr_shadowguard' WHERE `entry`=36609;
+UPDATE `creature_template` SET `ScriptName`='npc_strangulate_vehicle' WHERE `entry`=36598;
+UPDATE `creature_template` SET `ScriptName`='npc_terenas_menethil' WHERE `entry` IN (36823,38579,39217); -- not difficulty_entries
+UPDATE `creature_template` SET `ScriptName`='npc_spirit_warden' WHERE `entry`=36824;
+UPDATE `creature_template` SET `ScriptName`='npc_spirit_bomb' WHERE `entry`=39189;
+UPDATE `creature_template` SET `ScriptName`='npc_broken_frostmourne' WHERE `entry`=38584;
diff --git a/sql/updates/world/2011_10_05_01_world_spell_script_names.sql b/sql/updates/world/2011_10_05_01_world_spell_script_names.sql
new file mode 100644
index 00000000000..03d4b649e78
--- /dev/null
+++ b/sql/updates/world/2011_10_05_01_world_spell_script_names.sql
@@ -0,0 +1,90 @@
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_the_lich_king_infest';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_the_lich_king_necrotic_plague';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_the_lich_king_necrotic_plague_jump';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_the_lich_king_shadow_trap_visual';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_the_lich_king_shadow_trap_periodic';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_the_lich_king_quake';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_the_lich_king_ice_burst_target_search';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_the_lich_king_raging_spirit';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_the_lich_king_defile';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_the_lich_king_summon_into_air';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_the_lich_king_soul_reaper';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_the_lich_king_valkyr_target_search';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_the_lich_king_eject_all_passengers';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_the_lich_king_cast_back_to_caster';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_the_lich_king_life_siphon';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_the_lich_king_vile_spirits';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_the_lich_king_vile_spirits_visual';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_the_lich_king_vile_spirit_move_target_search';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_the_lich_king_vile_spirit_damage_target_search';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_the_lich_king_harvest_soul';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_the_lich_king_lights_favor';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_the_lich_king_soul_rip';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_the_lich_king_restore_soul';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_the_lich_king_in_frostmourne_room';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_the_lich_king_summon_spirit_bomb';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_the_lich_king_trigger_vile_spirit';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_the_lich_king_jump';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_the_lich_king_jump_remove_aura';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_the_lich_king_mass_resurrection';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_the_lich_king_play_movie';
+INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES
+(70541,'spell_the_lich_king_infest'),
+(73779,'spell_the_lich_king_infest'),
+(73780,'spell_the_lich_king_infest'),
+(73781,'spell_the_lich_king_infest'),
+(70337,'spell_the_lich_king_necrotic_plague'),
+(73912,'spell_the_lich_king_necrotic_plague'),
+(73913,'spell_the_lich_king_necrotic_plague'),
+(73914,'spell_the_lich_king_necrotic_plague'),
+(70338,'spell_the_lich_king_necrotic_plague_jump'),
+(73785,'spell_the_lich_king_necrotic_plague_jump'),
+(73786,'spell_the_lich_king_necrotic_plague_jump'),
+(73787,'spell_the_lich_king_necrotic_plague_jump'),
+(73530,'spell_the_lich_king_shadow_trap_visual'),
+(74282,'spell_the_lich_king_shadow_trap_periodic'),
+(72262,'spell_the_lich_king_quake'),
+(69110,'spell_the_lich_king_ice_burst_target_search'),
+(69200,'spell_the_lich_king_raging_spirit'),
+(72754,'spell_the_lich_king_defile'),
+(73708,'spell_the_lich_king_defile'),
+(73709,'spell_the_lich_king_defile'),
+(73710,'spell_the_lich_king_defile'),
+(69037,'spell_the_lich_king_summon_into_air'),
+(70497,'spell_the_lich_king_summon_into_air'),
+(73579,'spell_the_lich_king_summon_into_air'),
+(74300,'spell_the_lich_king_summon_into_air'),
+(69409,'spell_the_lich_king_soul_reaper'),
+(73797,'spell_the_lich_king_soul_reaper'),
+(73798,'spell_the_lich_king_soul_reaper'),
+(73799,'spell_the_lich_king_soul_reaper'),
+(69030,'spell_the_lich_king_valkyr_target_search'),
+(68576,'spell_the_lich_king_eject_all_passengers'),
+(74445,'spell_the_lich_king_cast_back_to_caster'),
+(68984,'spell_the_lich_king_cast_back_to_caster'),
+(73488,'spell_the_lich_king_life_siphon'),
+(73782,'spell_the_lich_king_life_siphon'),
+(73783,'spell_the_lich_king_life_siphon'),
+(73784,'spell_the_lich_king_life_siphon'),
+(70498,'spell_the_lich_king_vile_spirits'),
+(70499,'spell_the_lich_king_vile_spirits_visual'),
+(70501,'spell_the_lich_king_vile_spirit_move_target_search'),
+(70534,'spell_the_lich_king_vile_spirit_damage_target_search'),
+(68980,'spell_the_lich_king_harvest_soul'),
+(74325,'spell_the_lich_king_harvest_soul'),
+(74296,'spell_the_lich_king_harvest_soul'),
+(74297,'spell_the_lich_king_harvest_soul'),
+(69382,'spell_the_lich_king_lights_favor'),
+(69397,'spell_the_lich_king_soul_rip'),
+(72595,'spell_the_lich_king_restore_soul'),
+(73650,'spell_the_lich_king_restore_soul'),
+(74276,'spell_the_lich_king_in_frostmourne_room'),
+(74302,'spell_the_lich_king_summon_spirit_bomb'),
+(74341,'spell_the_lich_king_summon_spirit_bomb'),
+(74342,'spell_the_lich_king_summon_spirit_bomb'),
+(74343,'spell_the_lich_king_summon_spirit_bomb'),
+(73582,'spell_the_lich_king_trigger_vile_spirit'),
+(71811,'spell_the_lich_king_jump'),
+(72431,'spell_the_lich_king_jump_remove_aura'),
+(72429,'spell_the_lich_king_mass_resurrection'),
+(73159,'spell_the_lich_king_play_movie');