From ee50bcfccd4884777f9eccd9a3d7b6f5bb781ebe Mon Sep 17 00:00:00 2001 From: Shauren Date: Mon, 25 Apr 2011 21:18:18 +0200 Subject: Core/Spells: Fixed duration of Noblegarden bunny transforms DB/Achievements: Fixed "Hard Boiled" --- sql/updates/world/2011_04_25_00_world_achievement_criteria_data.sql | 4 ++++ sql/updates/world/2011_04_35_00_world_spell_linked_spell.sql | 4 ++++ 2 files changed, 8 insertions(+) create mode 100644 sql/updates/world/2011_04_25_00_world_achievement_criteria_data.sql create mode 100644 sql/updates/world/2011_04_35_00_world_spell_linked_spell.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2011_04_25_00_world_achievement_criteria_data.sql b/sql/updates/world/2011_04_25_00_world_achievement_criteria_data.sql new file mode 100644 index 00000000000..60b8a17858c --- /dev/null +++ b/sql/updates/world/2011_04_25_00_world_achievement_criteria_data.sql @@ -0,0 +1,4 @@ +DELETE FROM `achievement_criteria_data` WHERE `criteria_id`=9118; +INSERT INTO `achievement_criteria_data` (`criteria_id`,`type`,`value1`,`value2`,`ScriptName`) VALUES +(9118,16,181,0, ''), +(9118,6,490,0, ''); diff --git a/sql/updates/world/2011_04_35_00_world_spell_linked_spell.sql b/sql/updates/world/2011_04_35_00_world_spell_linked_spell.sql new file mode 100644 index 00000000000..d9b518810bf --- /dev/null +++ b/sql/updates/world/2011_04_35_00_world_spell_linked_spell.sql @@ -0,0 +1,4 @@ +DELETE FROM `spell_linked_spell` WHERE `spell_effect`=61719; +INSERT INTO `spell_linked_spell` (`spell_trigger`,`spell_effect`,`type`,`comment`) VALUES +(61716,61719,2, 'Rabbit Costume: Lay Egg periodic'), +(61734,61719,2, 'Noblegarden Bunny: Lay Egg periodic'); -- cgit v1.2.3