Elemental

DELETE FROM `db_spellvisualeffectname_12340` WHERE `ID`=230000;
INSERT INTO `db_spellvisualeffectname_12340` VALUES (230000, 'Wave: Fire', 'spells\\Missile_Wave_Fire.mdx', 1, 0.5, 0.01, 100);
DELETE FROM `dbc_spellvisual` WHERE `ID`=230000;
INSERT INTO `dbc_spellvisual` VALUES (230000, 0, 0, 0, 230000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
DELETE FROM `db_spellvisualkit_12340` WHERE `ID`=230000;
INSERT INTO `db_spellvisualkit_12340` VALUES (230000, -1, -1, 0, 0, 230000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, -1, -1, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
DELETE FROM `dbc_spellvisual` WHERE `ID`=892112;
INSERT INTO `dbc_spellvisual` (`ID`, `PrecastKit`, `CastKit`, `ImpactKit`, `StateKit`, `StateDoneKit`, `ChannelKit`, `HasMissile`, `MissileModel`, `MissilePathType`, `MissileDestinationAttachment`, `MissileSound`, `AnimEventSoundID`, `Flags`, `CasterImpactKit`, `TargetImpactKit`, `MissileAttachment`, `MissileFollowGroundHeight`, `MissileFollowGroundDropSpeed`, `MissileFollowGroundApproach`, `MissileFollowGroundFlags`, `MissileMotion`, `MissileTargetingKit`, `InstantAreaKit`, `ImpactAreaKit`, `PersistentAreaKit`, `MissileCastOffsetX`, `MissileCastOffsetY`, `MissileCastOffsetZ`, `MissileImpactOffsetX`, `MissileImpactOffsetY`, `MissileImpactOffsetZ`) VALUES (892112, 0, 892112, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 7550, 0, 0, 0, 0, 0, 0, 0);
DELETE FROM `db_spellvisualkit_12340` WHERE `ID`=892112;
INSERT INTO `db_spellvisualkit_12340` (`ID`, `StartAnimID`, `AnimID`, `HeadEffect`, `ChestEffect`, `BaseEffect`, `LeftHandEffect`, `RightHandEffect`, `BreathEffect`, `LeftWeaponEffect`, `RightWeaponEffect`, `SpecialEffect_1`, `SpecialEffect_2`, `SpecialEffect_3`, `WorldEffect`, `SoundID`, `ShakeID`, `CharProc_1`, `CharProc_2`, `CharProc_3`, `CharProc_4`, `CharParamZero_1`, `CharParamZero_2`, `CharParamZero_3`, `CharParamZero_4`, `CharParamOne_1`, `CharParamOne_2`, `CharParamOne_3`, `CharParamOne_4`, `CharParamTwo_1`, `CharParamTwo_2`, `CharParamTwo_3`, `CharParamTwo_4`, `CharParamThree_1`, `CharParamThree_2`, `CharParamThree_3`, `CharParamThree_4`, `Flags`) VALUES (892112, -1, 181, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 12126, 0, -1, -1, -1, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);