aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAokromes <Aokromes@users.noreply.github.com>2015-04-18 15:53:27 +0200
committerDDuarte <dnpd.dd@gmail.com>2015-05-20 00:02:17 +0100
commit14f81865961e5ce796e2091dc24f05f38a44c96d (patch)
treec6e5c1f68bccf7e96350b7b4f3436c1ad0b4232c
parent545a780539fc4635713319c13a4ac8fef3c9052c (diff)
DB/Item: Fix Bobbing apple
By Kilyana, closes #11142 (cherry picked from commit c0f6391a47313d60fc366c82a83d354d672e1cd4)
-rw-r--r--sql/updates/world/2015_05_19_04_world_2015_04_18_05.sql9
1 files changed, 9 insertions, 0 deletions
diff --git a/sql/updates/world/2015_05_19_04_world_2015_04_18_05.sql b/sql/updates/world/2015_05_19_04_world_2015_04_18_05.sql
new file mode 100644
index 00000000000..b61ff01bdfc
--- /dev/null
+++ b/sql/updates/world/2015_05_19_04_world_2015_04_18_05.sql
@@ -0,0 +1,9 @@
+--
+DELETE FROM `spell_linked_spell` WHERE `spell_trigger` IN (-24869, -61874, -71074, -71068, -71073, -71071) AND `spell_effect` = 24870;
+INSERT INTO `spell_linked_spell` (`spell_trigger`,`spell_effect`,`type`,`comment`) VALUES
+(-24869, 24870, 0, 'Bobbing Apple, Bread of the Dead, Winter Veil Cookie'),
+(-61874, 24870, 0, 'Noblegarden Chocolate'),
+(-71074, 24870, 0, 'Buttermilk Delight'),
+(-71068, 24870, 0, 'Sweet Surprise'),
+(-71073, 24870, 0, 'Dark Desire'),
+(-71071, 24870, 0, 'Very Berry Cream');