[Request] Lets play a game of mix-and-match: SpellEffect.db2

[Synric]

Mix-And-Match: Spell.dbc

As I made the other post, I decided that I am actually going to release the full spell.dbc and the related DBCs from Legion to WOTLK, but I do require some assistance. As I mentioned in the Spell post, I haven't nailed down the full column headings for SpellEffect.DB2, so I'm going to attach an SQL table here with the data from SpellEffect.db2, plus the columns I've worked out for sure so far. If y'all can help me nail this table down, I will go ahead and release everything as soon as I'm done writing it all.

Code: [Select]

unk1 = EffectMultipleValue
unk2 = EffectBonusMultiplier
unk3 = EffectChainAmplitude
unk4 =
unk5 = EffectRealPointsPerLevel
unk6 = EffectSpellClassMaskA
unk7 = EffectSpellClassMaskB
unk8 = EffectSpellClassMaskC
unk9 = EffectSpellClassMaskD
unk10 =
unk11 =
unk12 =
unk13 = EffectApplyAuraName? - Either this value or unk22
unk14 = EffectAmplitude
unk15 = EffectBasePoints
unk16 =
unk17 = EffectDieSides
unk18 = EffectItemType
unk19 =
unk20 = EffectMiscValue
unk21 = EffMiscValueB
unk22 = EffectApplyAuraName? - Either this value or unk13
unk23 = EffectRadiusIndex
unk24 = EffectTriggerSpell
unk25 = EffectImplicitTargetA
unk26 = EffectImplicitTargetB
unk27 = SpellIdentifier (Used to be columns Effect1, Effect2, Effect3, now seperate entries, and this where it matches up)
unk28 =

From here it's literally just a case of playing mix and match with WOTLK's spell.dbc.

This link contains spell.dbc for both WOTLK and Legion, as well as spelleffect.db2 and spellmisc.db2 in SQL format.

Note: In WOTLKs spell.dbc there are 3 columns for each of these (effect1, effect2, effect3). In spelleffect these are split into seperate rows. SpellIDIdentifier is the column which tells you where it goes in the list of 3. It looks like at some point they also added a 4th effect, but obviously we wont handle that.