diff options
Diffstat (limited to 'sql')
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'); |