From 83e0486e59ddf17ef8abc83b57ff459f8b9e1e9c Mon Sep 17 00:00:00 2001 From: Shauren Date: Mon, 30 Jan 2012 12:31:59 +0100 Subject: Scripts/Icecrown Citadel: Professor Putricide will now remove Mutated Plague from players when dying --- sql/updates/world/2012_01_30_01_world_conditions.sql | 3 +++ sql/updates/world/2012_01_30_01_world_spell_script_names.sql | 3 +++ 2 files changed, 6 insertions(+) create mode 100644 sql/updates/world/2012_01_30_01_world_conditions.sql create mode 100644 sql/updates/world/2012_01_30_01_world_spell_script_names.sql (limited to 'sql') diff --git a/sql/updates/world/2012_01_30_01_world_conditions.sql b/sql/updates/world/2012_01_30_01_world_conditions.sql new file mode 100644 index 00000000000..bcaf0af435a --- /dev/null +++ b/sql/updates/world/2012_01_30_01_world_conditions.sql @@ -0,0 +1,3 @@ +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry`=72618; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES +(13,0,72618,0,0,18,1,0,0,0, '', 'Mutated Plague Clear - target players'); diff --git a/sql/updates/world/2012_01_30_01_world_spell_script_names.sql b/sql/updates/world/2012_01_30_01_world_spell_script_names.sql new file mode 100644 index 00000000000..6e4b10094e5 --- /dev/null +++ b/sql/updates/world/2012_01_30_01_world_spell_script_names.sql @@ -0,0 +1,3 @@ +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_putricide_clear_mutated_plague'; +INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES +(72618,'spell_putricide_clear_mutated_plague'); -- cgit v1.2.3