How to add a missing spell

[titus4k]

hi,

i have an item which triggers a spell, not yet found at spells112. so i managed to extract the spell from spells.dbc (wow 2.1.3) (using "DBC Tool v2.7b by TRX"), created a sql sequence:

INSERT INTO `spells112` (`Id`, `School`, `Category`, `field4`, `DispelType`, `MechanicsType`, `Attributes`, `AttributesEx`, `Flags3`, `field10`, `field11`, `UNK12`, `UNK13`, `Targets`, `TargetCreatureType`, `RequiresSpellFocus`, `CasterAuraState`, `TargetAuraState`, `CastingTimeIndex`, `RecoveryTime`, `CategoryRecoveryTime`, `InterruptFlags`, `AuraInterruptFlags`, `ChannelInterruptFlags`, `procFlags`, `procChance`, `procCharges`, `maxLevel`, `baseLevel`, `spellLevel`, `DurationIndex`, `powerType`, `manaCost`, `manaCostPerlevel`, `manaPerSecond`, `manaPerSecondPerLevel`, `rangeIndex`, `speed`, `modalNextSpell`, `maxstack`, `Totem1`, `Totem2`, `Reagent1`, `Reagent2`, `Reagent3`, `Reagent4`, `Reagent5`, `Reagent6`, `Reagent7`, `Reagent8`, `ReagentCount1`, `ReagentCount2`, `ReagentCount3`, `ReagentCount4`, `ReagentCount5`, `ReagentCount6`, `ReagentCount7`, `ReagentCount8`, `EquippedItemClass`, `EquippedItemSubClass`, `RequiredItemFlags`, `Effect1`, `Effect2`, `Effect3`, `EffectDieSides1`, `EffectDieSides2`, `EffectDieSides3`, `EffectBaseDice1`, `EffectBaseDice2`, `EffectBaseDice3`, `EffectDicePerLevel1`, `EffectDicePerLevel2`, `EffectDicePerLevel3`, `EffectRealPointsPerLevel1`, `EffectRealPointsPerLevel2`, `EffectRealPointsPerLevel3`, `EffectBasePoints1`, `EffectBasePoints2`, `EffectBasePoints3`, `Effectunk1901`, `Effectunk1902`, `Effectunk1903`, `EffectImplicitTargetA1`, `EffectImplicitTargetA2`, `EffectImplicitTargetA3`, `EffectImplicitTargetB1`, `EffectImplicitTargetB2`, `EffectImplicitTargetB3`, `EffectRadiusIndex1`, `EffectRadiusIndex2`, `EffectRadiusIndex3`, `EffectApplyAuraName1`, `EffectApplyAuraName2`, `EffectApplyAuraName3`, `EffectAmplitude1`, `EffectAmplitude2`, `EffectAmplitude3`, `Effectunknown1`, `Effectunknown2`, `Effectunknown3`, `EffectChainTarget1`, `EffectChainTarget2`, `EffectChainTarget3`, `EffectSpellGroupRelation1`, `EffectSpellGroupRelation2`, `EffectSpellGroupRelation3`, `EffectMiscValue1`, `EffectMiscValue2`, `EffectMiscValue3`, `EffectTriggerSpell1`, `EffectTriggerSpell2`, `EffectTriggerSpell3`, `EffectPointsPerComboPoint1`, `EffectPointsPerComboPoint2`, `EffectPointsPerComboPoint3`, `SpellVisual`, `field114`, `dummy`, `CoSpell`, `spellPriority`, `Name`, `NameAlt1`, `NameAlt2`, `NameAlt3`, `NameAlt4`, `NameAlt5`, `NameAlt6`, `NameAlt7`, `NameFlags`, `Rank`, `RankAlt1`, `RankAlt2`, `RankAlt3`, `RankAlt4`, `RankAlt5`, `RankAlt6`, `RankAlt7`, `RankFlags`, `Description`, `DescriptionAlt1`, `DescriptionAlt2`, `DescriptionAlt3`, `DescriptionAlt4`, `DescriptionAlt5`, `DescriptionAlt6`, `DescriptionAlt7`, `DescriptionFlags`, `BuffDescription`, `BuffDescriptionAlt1`, `BuffDescriptionAlt2`, `BuffDescriptionAlt3`, `BuffDescriptionAlt4`, `BuffDescriptionAlt5`, `BuffDescriptionAlt6`, `BuffDescriptionAlt7`, `buffdescflags`, `ManaCostPercentage`, `unkflags`, `StartRecoveryTime`, `StartRecoveryCategory`, `SpellFamilyName`, `SpellGroupType`, `unkne`, `MaxTargets`, `Spell_Dmg_Type`, `FG`, `FH`, `dmg_multiplier_1`, `dmg_multiplier_2`, `dmg_multiplier_3`, `FL`, `FM`, `FN`) VALUES 
(37830,0,0,0,0,0,33554432,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,20000,0,0,4849664,0,0
101,0,0,0,0,21,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,0,6,0,0,1,0,0,1,0,0,0,0,0,0,0,0,-51,0,0,0,0,0,1,0,0,0,0,0,0,0,0,33,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,
755,0,1521,0,0,1097633,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,4128894,0,0,0,0,0,0,0,0,0,0
0,0,0,0,0,0,4128844,1097660,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,4128894,1097907,0,0,0,
,0,0,0,0,0,0,0,0,0,0,0,4128894,0,0,0,0,0,0,0,0,0,0,0,1065353216,1065353216,10653
3216,0,0,0,0,0,0);

and the result was: "Script line: 2 Column count doesn't match value count at row 1"

ist it hopeless this way? maybe spells112 need to get expaned for 2.1.3 spells (assuming 112 means wow version 1.12).
anyone can help here ?

thanks in advance,

t4k

[MentaL]