2 files changed, 128 insertions, 109 deletions
diff --git a/sql/FULL/world_spell_full.sql b/sql/FULL/world_spell_full.sql
index c675d9f86bc..550ec360dd3 100644
--- a/sql/FULL/world_spell_full.sql
+++ b/sql/FULL/world_spell_full.sql
@@ -1790,6 +1790,134 @@ INSERT INTO `spell_bonus_data` (`entry`, `direct_bonus`, `dot_bonus`, `ap_bonus`
 (61491, -1, -1, 0.12, -1, 'Warrior - Intercept');
 
 -- --------
+-- SPELL ELIXIR
+-- --------
+
+TRUNCATE TABLE `spell_elixir`;
+INSERT INTO `spell_elixir` (`entry`, `mask`) VALUES
+(673, 0x2),
+(2367, 0x1),
+(2374, 0x1),
+(2378, 0x2),
+(2380, 0x2),
+(3160, 0x1),
+(3164, 0x1),
+(3166, 0x2),
+(3219, 0x2),
+(3220, 0x2),
+(3222, 0x2),
+(3223, 0x2),
+(3593, 0x2),
+(7844, 0x1),
+(8212, 0x1),
+(10667, 0x1),
+(10668, 0x2),
+(10669, 0x1),
+(10692, 0x2),
+(10693, 0x2),
+(11319, 0x2),
+(11328, 0x1),
+(11334, 0x1),
+(11348, 0x2),
+(11349, 0x2),
+(11364, 0x2),
+(11371, 0x2),
+(11390, 0x1),
+(11396, 0x2),
+(11405, 0x1),
+(11406, 0x1),
+(11474, 0x1),
+(15231, 0x2),
+(15233, 0x2),
+(16321, 0x2),
+(16322, 0x1),
+(16323, 0x1),
+(16325, 0x2),
+(16326, 0x2),
+(16327, 0x2),
+(16329, 0x1),
+(17038, 0x1),
+(17535, 0x2),
+(17537, 0x1),
+(17538, 0x1),
+(17539, 0x1),
+(17624, 0x3),
+(17626, 0x3),
+(17627, 0x3),
+(17628, 0x3),
+(17629, 0x3),
+(21920, 0x1),
+(24361, 0x2),
+(24363, 0x2),
+(24382, 0x2),
+(24383, 0x2),
+(24417, 0x2),
+(26276, 0x1),
+(27652, 0x2),
+(27653, 0x2),
+(28486, 0x1),
+(28488, 0x1),
+(28490, 0x1),
+(28491, 0x1),
+(28493, 0x1),
+(28497, 0x1),
+(28501, 0x1),
+(28502, 0x2),
+(28503, 0x1),
+(28509, 0x2),
+(28514, 0x2),
+(28518, 0x3),
+(28519, 0x3),
+(28520, 0x3),
+(28521, 0x3),
+(28540, 0x3),
+(29348, 0x2),
+(33720, 0x1),
+(33721, 0x1),
+(33726, 0x1),
+(38954, 0x1),
+(39625, 0x2),
+(39626, 0x2),
+(39627, 0x2),
+(39628, 0x2),
+(40567, 0x7),
+(40568, 0x7),
+(40572, 0x7),
+(40573, 0x7),
+(40575, 0x7),
+(40576, 0x7),
+(41608, 0xB),
+(41609, 0xB),
+(41610, 0xB),
+(41611, 0xB),
+(42735, 0x3),
+(45373, 0x1),
+(46837, 0xB),
+(46839, 0xB),
+(53746, 0x1),
+(53747, 0x2),
+(53748, 0x1),
+(53749, 0x1),
+(53751, 0x2),
+(53752, 0x3),
+(53755, 0x3),
+(53758, 0x3),
+(53760, 0x3),
+(53763, 0x2),
+(53764, 0x2),
+(54212, 0x3),
+(54452, 0x1),
+(54494, 0x1),
+(60340, 0x1),
+(60341, 0x1),
+(60343, 0x2),
+(60344, 0x1),
+(60345, 0x1),
+(60346, 0x1),
+(60347, 0x2),
+(62380, 0x3);
+
+-- --------
 -- SPELL AFFECT
 -- --------
 
diff --git a/sql/world.sql b/sql/world.sql
index 4f302a08aa0..e65f1acc018 100644
--- a/sql/world.sql
+++ b/sql/world.sql
@@ -13764,115 +13764,6 @@ CREATE TABLE `spell_elixir` (
 SET character_set_client = @saved_cs_client;
 
 --
--- Dumping data for table `spell_elixir`
---
-
-LOCK TABLES `spell_elixir` WRITE;
-/*!40000 ALTER TABLE `spell_elixir` DISABLE KEYS */;
-INSERT INTO `spell_elixir` VALUES
-(673,2),
-(2367,1),
-(2374,1),
-(2378,2),
-(2380,2),
-(3160,1),
-(3164,1),
-(3166,2),
-(3219,2),
-(3220,2),
-(3222,2),
-(3223,2),
-(3593,2),
-(7844,1),
-(8212,1),
-(10667,1),
-(10668,2),
-(10669,1),
-(10692,2),
-(10693,2),
-(11319,2),
-(11328,1),
-(11334,1),
-(11348,2),
-(11349,2),
-(11364,2),
-(11371,2),
-(11390,1),
-(11396,2),
-(11405,1),
-(11406,1),
-(11474,1),
-(15231,2),
-(15233,2),
-(16321,2),
-(16322,1),
-(16323,1),
-(16325,2),
-(16326,2),
-(16327,2),
-(16329,1),
-(17038,1),
-(17535,2),
-(17537,1),
-(17538,1),
-(17539,1),
-(17624,3),
-(17626,3),
-(17627,3),
-(17628,3),
-(17629,3),
-(21920,1),
-(24361,2),
-(24363,2),
-(24382,2),
-(24383,2),
-(24417,2),
-(26276,1),
-(27652,2),
-(27653,2),
-(28486,1),
-(28488,1),
-(28490,1),
-(28491,1),
-(28493,1),
-(28497,1),
-(28501,1),
-(28502,2),
-(28503,1),
-(28509,2),
-(28514,2),
-(28518,3),
-(28519,3),
-(28520,3),
-(28521,3),
-(28540,3),
-(29348,2),
-(33720,1),
-(33721,1),
-(33726,1),
-(38954,1),
-(39625,2),
-(39626,2),
-(39627,2),
-(39628,2),
-(40567,7),
-(40568,7),
-(40572,7),
-(40573,7),
-(40575,7),
-(40576,7),
-(41608,11),
-(41609,11),
-(41610,11),
-(41611,11),
-(42735,3),
-(45373,1),
-(46837,11),
-(46839,11);
-/*!40000 ALTER TABLE `spell_elixir` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
 -- Table structure for table `spell_enchant_proc_data`
 --