*Some better check of well-fed buff. Source: Mangos

--HG--
branch : trunk

3 files changed, 21 insertions, 2 deletions

diff --git a/sql/FULL/world_spell_full.sql b/sql/FULL/world_spell_full.sql
index 27a833b40d9..3a9d13eca74 100644
--- a/sql/FULL/world_spell_full.sql
+++ b/sql/FULL/world_spell_full.sql
@@ -1971,7 +1971,14 @@ INSERT INTO `spell_elixir` (`entry`, `mask`) VALUES
 (60345, 0x1),
 (60346, 0x1),
 (60347, 0x2),
-(62380, 0x3);
+(62380, 0x3),
+(18191,0x10),
+(18192,0x10),
+(18193,0x10),
+(18194,0x10),
+(18222,0x10),
+(22730,0x10),
+(25661,0x10);
 
 -- --------
 -- Death Knight
diff --git a/sql/characters.sql b/sql/characters.sql
index aa37e0021f8..ac92557d07d 100644
--- a/sql/characters.sql
+++ b/sql/characters.sql
@@ -23,7 +23,7 @@
 
 DROP TABLE IF EXISTS `character_db_version`;
 CREATE TABLE `character_db_version` (
-  `required_8339_02_characters_character_battleground_data` bit(1) default NULL
+  `required_8397_03_characters_character_spell` bit(1) default NULL
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Last applied sql update to DB';
 
 --
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);