Implement overloading of SpellEffect.dbc. Fix quest 25464.

From 8cbb425323143978e23a7ae6e3c9b20e016cccfe Mon Sep 17 00:00:00 2001
From: Wyran Wyrm <[email protected]>
Date: Fri, 15 Feb 2013 13:20:42 +0100
Subject: [PATCH] Implement overloading of SpellEffect.dbc from database. Also
 fix quest 25464.

---
 .../world/2013_02_15_01_world_spelleffect_dbc.sql  | 37 ++++++++++++++++++++++
 src/server/game/DataStores/DBCStores.cpp           |  2 +-
 src/server/game/DataStores/DBCfmt.h                |  2 ++
 3 files changed, 40 insertions(+), 1 deletion(-)
 create mode 100644 sql/updates/world/2013_02_15_01_world_spelleffect_dbc.sql

diff --git a/sql/updates/world/2013_02_15_01_world_spelleffect_dbc.sql b/sql/updates/world/2013_02_15_01_world_spelleffect_dbc.sql
new file mode 100644
index 0000000..3b891ad
--- /dev/null
+++ b/sql/updates/world/2013_02_15_01_world_spelleffect_dbc.sql
@@ -0,0 +1,37 @@
+-- Add spelleffect_dbc table, matching fields from SpellEffect.dbc.
+-- Author: Wyran.
+
+DROP TABLE IF EXISTS spelleffect_dbc;
+
+CREATE TABLE `spelleffect_dbc` (
+   `Id` int (10),
+   `Effect` int (10),
+   `EffectValueMultiplier` float ,
+   `EffectApplyAuraName` int (10),
+   `EffectAmplitude` int (10),
+   `EffectBasePoints` int (10),
+   `EffectBonusMultiplier` float ,
+   `EffectDamageMultiplier` float ,
+   `EffectChainTarget` int (10),
+   `EffectDieSides` int (10),
+   `EffectItemType` int (10),
+   `EffectMechanic` int (10),
+   `EffectMiscValue` int (10),
+   `EffectMiscValueB` int (10),
+   `EffectPointsPerComboPoint` float ,
+   `EffectRadiusIndex` int (10),
+   `EffectRadiusMaxIndex` int (10),
+   `EffectRealPointsPerLevel` float ,
+   `EffectSpellClassMask1` int (10),
+   `EffectSpellClassMask2` int (10),
+   `EffectSpellClassMask3` int (10),
+   `EffectTriggerSpell` int (10),
+   `EffectImplicitTargetA` int (10),
+   `EffectImplicitTargetB` int (10),
+   `EffectSpellId` int (10),
+   `EffectIndex` int (10),
+   `Comment` text
+);
+
+INSERT INTO `spelleffect_dbc` (`Id`, `Effect`, `EffectValueMultiplier`, `EffectApplyAuraName`, `EffectAmplitude`, `EffectBasePoints`, `EffectBonusMultiplier`, `EffectDamageMultiplier`, `EffectChainTarget`, `EffectDieSides`, `EffectItemType`, `EffectMechanic`, `EffectMiscValue`, `EffectMiscValueB`, `EffectPointsPerComboPoint`, `EffectRadiusIndex`, `EffectRadiusMaxIndex`, `EffectRealPointsPerLevel`, `EffectSpellClassMask1`, `EffectSpellClassMask2`, `EffectSpellClassMask3`, `EffectTriggerSpell`, `EffectImplicitTargetA`, `EffectImplicitTargetB`, `EffectSpellId`, `EffectIndex`, `Comment`) VALUES
+('1000000','90','0','0','0','0','0','1','0','0','0','0','40334','0','0','0','0','0','0','0','0','0','2','0','75193','0','Kill credit for quest 25464.');
diff --git a/src/server/game/DataStores/DBCStores.cpp b/src/server/game/DataStores/DBCStores.cpp
index abaa16e..8ea5b3b 100644
--- a/src/server/game/DataStores/DBCStores.cpp
+++ b/src/server/game/DataStores/DBCStores.cpp
@@ -517,7 +517,7 @@ void LoadDBCStores(const std::string& dataPath)
     LoadDBC(availableDbcLocales, bad_dbc_files, sSpellAuraRestrictionsStore,  dbcPath,"SpellAuraRestrictions.dbc");//14545
     LoadDBC(availableDbcLocales, bad_dbc_files, sSpellCastingRequirementsStore, dbcPath,"SpellCastingRequirements.dbc");//14545
     LoadDBC(availableDbcLocales, bad_dbc_files, sSpellCategoriesStore,        dbcPath,"SpellCategories.dbc");//14545
-    LoadDBC(availableDbcLocales, bad_dbc_files, sSpellEffectStore,            dbcPath,"SpellEffect.dbc");//14545
+    LoadDBC(availableDbcLocales, bad_dbc_files, sSpellEffectStore,            dbcPath,"SpellEffect.dbc", &CustomSpellEffectEntryfmt, &CustomSpellEffectEntryIndex);//14545
     LoadDBC(availableDbcLocales, bad_dbc_files, sSpellCastTimesStore,         dbcPath, "SpellCastTimes.dbc");//14545
     LoadDBC(availableDbcLocales, bad_dbc_files, sSpellDifficultyStore,        dbcPath, "SpellDifficulty.dbc", &CustomSpellDifficultyfmt, &CustomSpellDifficultyIndex);//14545
     LoadDBC(availableDbcLocales, bad_dbc_files, sSpellDurationStore,          dbcPath, "SpellDuration.dbc");//14545
diff --git a/src/server/game/DataStores/DBCfmt.h b/src/server/game/DataStores/DBCfmt.h
index 66c519e..5547dda 100644
--- a/src/server/game/DataStores/DBCfmt.h
+++ b/src/server/game/DataStores/DBCfmt.h
@@ -124,6 +124,8 @@ const std::string CustomSpellDifficultyfmt = "ppppp";
 const std::string CustomSpellDifficultyIndex = "id";
 char const SpellDurationfmt[] = "niii";
 char const SpellEffectEntryfmt[] = "nifiiiffiiiiiifiifiiiiiiiix";
+const std::string CustomSpellEffectEntryfmt = "ppppppppppppppppppppppppppa";
+const std::string CustomSpellEffectEntryIndex = "Id";
 char const SpellEntryfmt[] = "niiiiiiiiiiiiiiifiiiissxxiixxifiiiiiiixiiiiiiiix";
 const std::string CustomSpellEntryfmt = "pppppppppppppppppppppaaaappaapppppppppappppppppa";
 const std::string CustomSpellEntryIndex = "Id";
--
1.8.0.msysgit.0