diff options
Diffstat (limited to 'sql')
8 files changed, 108 insertions, 5 deletions
diff --git a/sql/base/world_database.sql b/sql/base/world_database.sql index 70b95dcd23d..5b558c9abcd 100644 --- a/sql/base/world_database.sql +++ b/sql/base/world_database.sql @@ -18200,6 +18200,8 @@ INSERT INTO `spell_linked_spell` (`spell_trigger`,`spell_effect`,`type`,`comment ( 71479, 71482, 1, 'Blood-Queen: Bloodbolt Splash'), ( 71480, 71483, 1, 'Blood-Queen: Bloodbolt Splash'), ( 71952, 70995, 1, 'Blood-Queen: Presence of the Darkfallen'), +( 70117, 70122, 1, 'Sindragosa - Icy Grip'), +( 70157, 69700, 2, 'Sindragosa - Ice Tomb resistance'), -- Isle of Conquest ( 66548, 66550, 0, 'Isle of Conquest (IN>OUT)'), ( 66549, 66551, 0, 'Isle of Conquest (OUT>IN)'), diff --git a/sql/scripts/world_scripts_full.sql b/sql/scripts/world_scripts_full.sql index 79c006f2380..a32a5d1461c 100644 --- a/sql/scripts/world_scripts_full.sql +++ b/sql/scripts/world_scripts_full.sql @@ -9,7 +9,7 @@ UPDATE `gameobject_template` SET `ScriptName`=''; UPDATE `outdoorpvp_template` SET `ScriptName`=''; /* AREA TRIGGERS */ -DELETE FROM `areatrigger_scripts` WHERE `entry` IN (822,5284,5285,5286,5287,4871,4872,4873,5108,5332,5338,5334,5340,5369,5423,5633); +DELETE FROM `areatrigger_scripts` WHERE `entry` IN (822,5284,5285,5286,5287,4871,4872,4873,5108,5332,5338,5334,5340,5369,5423,5633,5604); DELETE FROM `areatrigger_scripts` WHERE `entry` BETWEEN 1726 AND 1740; INSERT INTO `areatrigger_scripts` (`entry`,`ScriptName`) VALUES (822, 'at_map_chamber'), @@ -42,7 +42,8 @@ INSERT INTO `areatrigger_scripts` (`entry`,`ScriptName`) VALUES (1740, 'at_scent_larkorwi'), (5369, 'at_RX_214_repair_o_matic_station'), (5423, 'at_RX_214_repair_o_matic_station'), -(5633, 'at_tyrannus_event_starter'); +(5633, 'at_tyrannus_event_starter'), +(5604, 'at_sindragosa_lair'); /* WORLD BOSS */ UPDATE `creature_template` SET `ScriptName`='boss_ysondre' WHERE `entry`=14887; @@ -863,6 +864,11 @@ UPDATE `creature_template` SET `ScriptName`='npc_kinetic_bomb' WHERE `entry`=384 UPDATE `creature_template` SET `ScriptName`='npc_dark_nucleus' WHERE `entry`=38369; UPDATE `creature_template` SET `ScriptName`='npc_ball_of_flame' WHERE `entry` IN (38332,38451); UPDATE `creature_template` SET `ScriptName`='boss_blood_queen_lana_thel' WHERE `entry`=37955; +UPDATE `creature_template` SET `ScriptName`='boss_sindragosa' WHERE `entry`=36853; +UPDATE `creature_template` SET `ScriptName`='npc_ice_tomb' WHERE `entry`=36980; +UPDATE `creature_template` SET `ScriptName`='npc_spinestalker' WHERE `entry`=37534; +UPDATE `creature_template` SET `ScriptName`='npc_rimefang_icc' WHERE `entry`=37533; +UPDATE `creature_template` SET `ScriptName`='npc_sindragosa_trash' WHERE `entry` IN (37531,37532); /* IRONFORGE */ UPDATE `creature_template` SET `ScriptName`='npc_royal_historian_archesonus' WHERE `entry`=8879; @@ -1755,7 +1761,7 @@ UPDATE `outdoorpvp_template` SET `ScriptName`='outdoorpvp_si' WHERE `TypeId`=5; UPDATE `outdoorpvp_template` SET `ScriptName`='outdoorpvp_ep' WHERE `TypeId`=6; /* ACHIEVEMENTS */ -DELETE FROM `achievement_criteria_data` WHERE `criteria_id` IN (3693,6641,6642,6643,6644,3804,3805,3806,3807,3808,3809,3810,3811,3812,3813,1234,1239,5605,5606,12778,13036,13035,13037,12977,12967,12986,12982,12993,12780,13012,13011,13013,12062,12063,12064,12065,12183,12068,12060,12061) AND `type` IN (0,11); +DELETE FROM `achievement_criteria_data` WHERE `criteria_id` IN (3693,6641,6642,6643,6644,3804,3805,3806,3807,3808,3809,3810,3811,3812,3813,1234,1239,5605,5606,12778,13036,13035,13037,12977,12967,12986,12982,12993,12780,13012,13011,13013,12062,12063,12064,12065,12183,12068,12060,12061,12822,12996,12972,12989) AND `type` IN (0,11); INSERT INTO `achievement_criteria_data` (`criteria_id`,`type`,`value1`,`value2`,`ScriptName`) VALUES (3693,11,0,0, 'achievement_storm_glory'), (6641,11,0,0, 'achievement_school_of_hard_knocks'), @@ -1796,8 +1802,11 @@ INSERT INTO `achievement_criteria_data` (`criteria_id`,`type`,`value1`,`value2`, (12183,11,0,0, 'achievement_bg_ic_glaive_grave'), (12068,11,0,0, 'achievement_bg_ic_mowed_down'), (12060,11,0,0, 'achievement_bg_ic_resource_glut'), -(12061,11,0,0, 'achievement_bg_ic_resource_glut'); - +(12061,11,0,0, 'achievement_bg_ic_resource_glut'), +(12822,11,0,0, 'achievement_all_you_can_eat'), +(12996,11,0,0, 'achievement_all_you_can_eat'), +(12972,11,0,0, 'achievement_all_you_can_eat'), +(12989,11,0,0, 'achievement_all_you_can_eat'); /* SPELLS */ INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES @@ -1989,6 +1998,24 @@ INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES ( 71390, 'spell_blood_queen_pact_of_the_darkfallen'), ( 71340, 'spell_blood_queen_pact_of_the_darkfallen_dmg'), ( 71341, 'spell_blood_queen_pact_of_the_darkfallen_dmg_target'), +( 71357, 'spell_frostwarden_handler_order_whelp'), +( 71350, 'spell_frostwarden_handler_focus_fire'), +( 71376, 'spell_rimefang_icy_blast'), +( 70598, 'spell_sindragosa_s_fury'), +( 69762, 'spell_sindragosa_unchained_magic'), +( 69766, 'spell_sindragosa_instability'), +( 70126, 'spell_sindragosa_frost_beacon'), +( 69712, 'spell_sindragosa_ice_tomb'), +( 69675, 'spell_sindragosa_ice_tomb_dummy'), +( 70157, 'spell_sindragosa_ice_tomb_trap'), +( 69845, 'spell_sindragosa_collision_filter'), +( 71053, 'spell_sindragosa_collision_filter'), +( 71054, 'spell_sindragosa_collision_filter'), +( 71055, 'spell_sindragosa_collision_filter'), +( 70127, 'spell_sindragosa_collision_filter'), +( 72528, 'spell_sindragosa_collision_filter'), +( 72529, 'spell_sindragosa_collision_filter'), +( 72530, 'spell_sindragosa_collision_filter'), -- Isle of Conquest ( 66630, 'spell_gen_gunship_portal'), ( 66637, 'spell_gen_gunship_portal'), diff --git a/sql/updates/world/2011_02_07_0_world_achievement_criteria_data.sql b/sql/updates/world/2011_02_07_0_world_achievement_criteria_data.sql new file mode 100644 index 00000000000..c73e90d161d --- /dev/null +++ b/sql/updates/world/2011_02_07_0_world_achievement_criteria_data.sql @@ -0,0 +1,18 @@ +DELETE FROM `achievement_criteria_data` WHERE `criteria_id` IN (12822,12996,12972,12989,12758,12955,13049,13060,13102,13133,13134,13135); +INSERT INTO `achievement_criteria_data` (`criteria_id`,`type`,`value1`,`value2`,`ScriptName`) VALUES +(12822,11,0,0, 'achievement_all_you_can_eat'), -- All You Can Eat (10 player) +(12822,12,0,0, ''), -- All You Can Eat (10 player) +(12996,11,0,0, 'achievement_all_you_can_eat'), -- All You Can Eat (10 player) Heroic +(12996,12,2,0, ''), -- All You Can Eat (10 player) Heroic +(12972,11,0,0, 'achievement_all_you_can_eat'), -- All You Can Eat (25 player) +(12972,12,1,0, ''), -- All You Can Eat (25 player) +(12989,11,0,0, 'achievement_all_you_can_eat'), -- All You Can Eat (25 player) Heroic +(12989,12,3,0, ''), -- All You Can Eat (25 player) Heroic +(12758,12,0,0, ''), -- The Frostwing Halls (10 player) Sindragosa +(12955,12,1,0, ''), -- The Frostwing Halls (25 player) Sindragosa +(13049,12,2,0, ''), -- Heroic: The Frostwing Halls (10 player) Sindragosa +(13060,12,3,0, ''), -- Heroic: The Frostwing Halls (25 player) Sindragosa +(13102,12,0,0, ''), -- Sindragosa kills (Icecrown 10 player) +(13133,12,1,0, ''), -- Sindragosa kills (Icecrown 25 player) +(13134,12,2,0, ''), -- Sindragosa kills (Heroic Icecrown 10 player) +(13135,12,3,0, ''); -- Sindragosa kills (Heroic Icecrown 25 player) diff --git a/sql/updates/world/2011_02_07_0_world_areatrigger_scripts.sql b/sql/updates/world/2011_02_07_0_world_areatrigger_scripts.sql new file mode 100644 index 00000000000..6fba267fe1b --- /dev/null +++ b/sql/updates/world/2011_02_07_0_world_areatrigger_scripts.sql @@ -0,0 +1,3 @@ +DELETE FROM `areatrigger_scripts` WHERE `entry`=5604; +INSERT INTO `areatrigger_scripts` (`entry`,`ScriptName`) VALUES +(5604,'at_sindragosa_lair'); diff --git a/sql/updates/world/2011_02_07_0_world_creature_text.sql b/sql/updates/world/2011_02_07_0_world_creature_text.sql new file mode 100644 index 00000000000..e4d570bb7fa --- /dev/null +++ b/sql/updates/world/2011_02_07_0_world_creature_text.sql @@ -0,0 +1,14 @@ +DELETE FROM `creature_text` WHERE `entry`=36853; +INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES +(36853,0,0, 'You are fools to have come to this place! The icy winds of Northrend will consume your souls!',1,0,0,0,0,17007, 'Sindragosa - SAY_AGGRO'), +(36853,1,0, 'Suffer, mortals, as your pathetic magic betrays you!',1,0,0,0,0,17014, 'Sindragosa - SAY_UNCHAINED_MAGIC'), +(36853,2,0, '%s prepares to unleash a wave of blistering cold!',3,0,0,0,0,0, 'Sindragosa - EMOTE_WARN_BLISTERING_COLD'), +(36853,3,0, 'Can you feel the cold hand of death upon your heart?',1,0,0,0,0,17013, 'Sindragosa - SAY_BLISTERING_COLD'), +(36853,4,0, 'Aaah! It burns! What sorcery is this?!',1,0,0,0,0,17015, 'Sindragosa - SAY_RESPITE_FOR_A_TORMENTED_SOUL'), +(36853,5,0, 'Your incursion ends here! None shall survive!',1,0,0,0,0,17012, 'Sindragosa - SAY_AIR_PHASE'), +(36853,6,0, 'Now feel my master''s limitless power and despair!',1,0,0,0,0,17016, 'Sindragosa - SAY_PHASE_2'), +(36853,7,0, '%s fires a frozen orb towards $N!',3,0,0,0,0,0, 'Sindragosa - EMOTE_WARN_FROZEN_ORB'), +(36853,8,0, 'Perish!',1,0,0,0,0,17008, 'Sindragosa - SAY_KILL 1'), +(36853,8,1, 'A flaw of mortality...',1,0,0,0,0,17009, 'Sindragosa - SAY_KILL 2'), +(36853,9,0, 'Enough! I tire of these games!',1,0,0,0,0,17011, 'Sindragosa - SAY_BERSERK'), +(36853,10,0, 'Free...at last...',1,0,0,0,0,17010, 'Sindragosa - SAY_DEATH'); diff --git a/sql/updates/world/2011_02_07_0_world_scriptname.sql b/sql/updates/world/2011_02_07_0_world_scriptname.sql new file mode 100644 index 00000000000..d6b290c48ab --- /dev/null +++ b/sql/updates/world/2011_02_07_0_world_scriptname.sql @@ -0,0 +1,5 @@ +UPDATE `creature_template` SET `ScriptName`='boss_sindragosa' WHERE `entry`=36853; +UPDATE `creature_template` SET `ScriptName`='npc_ice_tomb' WHERE `entry`=36980; +UPDATE `creature_template` SET `ScriptName`='npc_spinestalker' WHERE `entry`=37534; +UPDATE `creature_template` SET `ScriptName`='npc_rimefang_icc' WHERE `entry`=37533; +UPDATE `creature_template` SET `ScriptName`='npc_sindragosa_trash' WHERE `entry` IN (37531,37532); diff --git a/sql/updates/world/2011_02_07_0_world_spell_linked_spell.sql b/sql/updates/world/2011_02_07_0_world_spell_linked_spell.sql new file mode 100644 index 00000000000..0839e256fb3 --- /dev/null +++ b/sql/updates/world/2011_02_07_0_world_spell_linked_spell.sql @@ -0,0 +1,4 @@ +DELETE FROM `spell_linked_spell` WHERE `spell_trigger` IN (70117,70157); +INSERT INTO `spell_linked_spell` (`spell_trigger`,`spell_effect`,`type`,`comment`) VALUES +(70117,70122,1, 'Sindragosa - Icy Grip'), +(70157,69700,2, 'Sindragosa - Ice Tomb resistance'); diff --git a/sql/updates/world/2011_02_07_0_world_spell_script_names.sql b/sql/updates/world/2011_02_07_0_world_spell_script_names.sql new file mode 100644 index 00000000000..7fc30c64a07 --- /dev/null +++ b/sql/updates/world/2011_02_07_0_world_spell_script_names.sql @@ -0,0 +1,30 @@ +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_frostwarden_handler_order_whelp'; +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_frostwarden_handler_focus_fire'; +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_rimefang_icy_blast'; +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_sindragosa_s_fury'; +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_sindragosa_unchained_magic'; +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_sindragosa_instability'; +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_sindragosa_frost_beacon'; +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_sindragosa_ice_tomb'; +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_sindragosa_ice_tomb_dummy'; +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_sindragosa_ice_tomb_trap'; +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_sindragosa_collision_filter'; +INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES +(71357,'spell_frostwarden_handler_order_whelp'), +(71350,'spell_frostwarden_handler_focus_fire'), +(71376,'spell_rimefang_icy_blast'), +(70598,'spell_sindragosa_s_fury'), +(69762,'spell_sindragosa_unchained_magic'), +(69766,'spell_sindragosa_instability'), +(70126,'spell_sindragosa_frost_beacon'), +(69712,'spell_sindragosa_ice_tomb'), +(69675,'spell_sindragosa_ice_tomb_dummy'), +(70157,'spell_sindragosa_ice_tomb_trap'), +(69845,'spell_sindragosa_collision_filter'), +(71053,'spell_sindragosa_collision_filter'), +(71054,'spell_sindragosa_collision_filter'), +(71055,'spell_sindragosa_collision_filter'), +(70127,'spell_sindragosa_collision_filter'), +(72528,'spell_sindragosa_collision_filter'), +(72529,'spell_sindragosa_collision_filter'), +(72530,'spell_sindragosa_collision_filter'); |