aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authormegamage <none@none>2009-08-24 19:12:22 -0500
committermegamage <none@none>2009-08-24 19:12:22 -0500
commit8871c2952ae13a814da3f42f72b7f32371a7556a (patch)
treed7898e0bdf235181830aa7e4ec0f5eb3627458ad /sql/updates
parent978d139932955fd8657f396f4774578bdaf337c9 (diff)
*Some better check of well-fed buff. Source: Mangos
--HG-- branch : trunk
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/5352_8399_world_spell_elixir.sql12
1 files changed, 12 insertions, 0 deletions
diff --git a/sql/updates/5352_8399_world_spell_elixir.sql b/sql/updates/5352_8399_world_spell_elixir.sql
new file mode 100644
index 00000000000..64d250c8fe1
--- /dev/null
+++ b/sql/updates/5352_8399_world_spell_elixir.sql
@@ -0,0 +1,12 @@
+-- ALTER TABLE db_version CHANGE COLUMN required_8397_02_mangos_spell_threat required_8399_01_mangos_spell_elixir bit;
+
+-- Well Fed (SPELLFAMILY_POTION)
+DELETE FROM spell_elixir WHERE entry IN (18191, 18192, 18193, 18194, 18222, 22730, 25661);
+INSERT INTO spell_elixir (entry, mask) VALUES
+(18191,0x10),
+(18192,0x10),
+(18193,0x10),
+(18194,0x10),
+(18222,0x10),
+(22730,0x10),
+(25661,0x10);