aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--sql/updates/4524_world_spell_elixir.sql32
1 files changed, 32 insertions, 0 deletions
diff --git a/sql/updates/4524_world_spell_elixir.sql b/sql/updates/4524_world_spell_elixir.sql
new file mode 100644
index 00000000000..dc48a4af91b
--- /dev/null
+++ b/sql/updates/4524_world_spell_elixir.sql
@@ -0,0 +1,32 @@
+DELETE FROM `spell_elixir` WHERE `entry` IN
+(
+ 54452, 60340, 60345, 60341, 60344,
+ 60346, 54494, 53748, 53749, 53746,
+ 60343, 53751, 53764, 60347, 53763,
+ 53747, 53760, 54212, 53758, 53755,
+ 53752, 62380
+);
+
+INSERT INTO `spell_elixir` (`entry`, `mask`) VALUES
+(54452, 0x1),
+(60340, 0x1),
+(60345, 0x1),
+(60341, 0x1),
+(60344, 0x1),
+(60346, 0x1),
+(54494, 0x1),
+(53748, 0x1),
+(53749, 0x1),
+(53746, 0x1),
+(60343, 0x2),
+(53751, 0x2),
+(53764, 0x2),
+(60347, 0x2),
+(53763, 0x2),
+(53747, 0x2),
+(53760, 0x3),
+(54212, 0x3),
+(53758, 0x3),
+(53755, 0x3),
+(53752, 0x3),
+(62380, 0x3);