diff options
Diffstat (limited to 'sql')
7 files changed, 15 insertions, 3 deletions
diff --git a/sql/scripts/world_scripts_full.sql b/sql/scripts/world_scripts_full.sql index 83e7b601905..8bb02cc045b 100644 --- a/sql/scripts/world_scripts_full.sql +++ b/sql/scripts/world_scripts_full.sql @@ -843,6 +843,7 @@ UPDATE `creature_template` SET `ScriptName`='boss_lady_deathwhisper' WHERE `entr UPDATE `creature_template` SET `ScriptName`='npc_cult_fanatic' WHERE `entry` IN (37890,38009,38135); UPDATE `creature_template` SET `ScriptName`='npc_cult_adherent' WHERE `entry` IN(37949,38010,38136); UPDATE `creature_template` SET `ScriptName`='npc_vengeful_shade' WHERE `entry`=38222; +UPDATE `creature_template` SET `ScriptName`='npc_rotting_frost_giant' WHERE `entry` IN (38490,38494); UPDATE `creature_template` SET `ScriptName`='boss_deathbringer_saurfang' WHERE `entry`=37813; UPDATE `creature_template` SET `ScriptName`='npc_high_overlord_saurfang_icc' WHERE `entry`=37187; UPDATE `creature_template` SET `ScriptName`='npc_muradin_bronzebeard_icc' WHERE `entry`=37200; @@ -1895,6 +1896,7 @@ INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES ( 72495, 'spell_cultist_dark_martyrdom'), ( 72496, 'spell_cultist_dark_martyrdom'), ( 72497, 'spell_cultist_dark_martyrdom'), +( 72864, 'spell_frost_giant_death_plague'), ( 72202, 'spell_deathbringer_blood_link'), ( 72178, 'spell_deathbringer_blood_link_aura'), ( 72371, 'spell_deathbringer_blood_power'), @@ -2073,7 +2075,7 @@ INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES ( 59640, 'spell_item_underbelly_elixir'), ( 71905, 'spell_item_shadowmourne'), ( 67533, 'spell_item_red_rider_air_rifle'), -( 26678,'spell_item_create_heart_candy'), +( 26678, 'spell_item_create_heart_candy'), -- warrior ( 12975, 'spell_warr_last_stand'), ( 59725, 'spell_warr_improved_spell_reflection'), diff --git a/sql/updates/world/2011_02_12_0_world_script_name.sql b/sql/updates/world/2011_02_12_0_world_script_name.sql deleted file mode 100644 index e3861d13dbb..00000000000 --- a/sql/updates/world/2011_02_12_0_world_script_name.sql +++ /dev/null @@ -1,2 +0,0 @@ -DELETE FROM `spell_script_names` WHERE `spell_id`=26678; -INSERT INTO `spell_script_names` VALUES (26678,'spell_item_create_heart_candy');
\ No newline at end of file diff --git a/sql/updates/world/2011_02_12_0_world_spell_script_names.sql b/sql/updates/world/2011_02_12_0_world_spell_script_names.sql new file mode 100644 index 00000000000..39098e1c3de --- /dev/null +++ b/sql/updates/world/2011_02_12_0_world_spell_script_names.sql @@ -0,0 +1,3 @@ +DELETE FROM `spell_script_names` WHERE `spell_id`=26678; +INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES +(26678,'spell_item_create_heart_candy'); diff --git a/sql/updates/world/2011_02_15_3_world_creature_template.sql b/sql/updates/world/2011_02_15_3_world_creature_template.sql new file mode 100644 index 00000000000..cc892b30bf9 --- /dev/null +++ b/sql/updates/world/2011_02_15_3_world_creature_template.sql @@ -0,0 +1 @@ +UPDATE `creature_template` SET `minlevel`=82,`maxlevel`=82,`exp`=2,`unit_class`=1,`faction_A`=16,`faction_H`=16,`baseattacktime`=2000,`unit_flags`=33280,`speed_run`=0.9920629 WHERE `entry`=38494; -- Rotting Frost Giant diff --git a/sql/updates/world/2011_02_15_3_world_creature_text.sql b/sql/updates/world/2011_02_15_3_world_creature_text.sql new file mode 100644 index 00000000000..6642afba9b7 --- /dev/null +++ b/sql/updates/world/2011_02_15_3_world_creature_text.sql @@ -0,0 +1,4 @@ +DELETE FROM `creature_text` WHERE `entry` IN (38490,38494); +INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES +(38490,0,0, '$n is infected with the Death Plague!',3,0,100,25,0,0, 'Rotting Frost Giant - Death Plague'), +(38494,0,0, '$n is infected with the Death Plague!',3,0,100,25,0,0, 'Rotting Frost Giant - Death Plague'); diff --git a/sql/updates/world/2011_02_15_3_world_scriptname.sql b/sql/updates/world/2011_02_15_3_world_scriptname.sql new file mode 100644 index 00000000000..ec7c4f3d483 --- /dev/null +++ b/sql/updates/world/2011_02_15_3_world_scriptname.sql @@ -0,0 +1 @@ +UPDATE `creature_template` SET `ScriptName`='npc_rotting_frost_giant' WHERE `entry` IN (38490,38494); diff --git a/sql/updates/world/2011_02_15_3_world_spell_script_names.sql b/sql/updates/world/2011_02_15_3_world_spell_script_names.sql new file mode 100644 index 00000000000..85c9a11fd50 --- /dev/null +++ b/sql/updates/world/2011_02_15_3_world_spell_script_names.sql @@ -0,0 +1,3 @@ +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_frost_giant_death_plague'; +INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES +(72864,'spell_frost_giant_death_plague'); |