diff options
| author | Shauren <shauren.trinity@gmail.com> | 2011-02-15 22:07:40 +0100 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2011-02-15 22:07:40 +0100 |
| commit | 45095bdffb066b231d253cd424ecc36f3764cde5 (patch) | |
| tree | 78934ed44bbb71902c4c070cf550ac8237566649 /sql/updates | |
| parent | 21179288a26f33c780f343d61a18ffb38ff9511f (diff) | |
Scripts/Icecrown Citadel: Added Rotting Frost Giant script
Diffstat (limited to 'sql/updates')
6 files changed, 12 insertions, 2 deletions
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'); |