If you've done a bunch of edits to your realm and just want to fix the spells your mobs cast while risking the least amount of work fixing edits, you can use this procedure to only fix the spell record numbers.
If you then want to verify/see the monsters that have been changed (you can do this before too and then comare)...
In microsoft access, open the export file, then go to the create tab => choose "query design" from the toolbar => close the show table pop-up => right-click on the black area in the query and choose "SQL View" => delete everything out and then paste this:
Code: Select all
SELECT Monsters.[Number], Monsters.[Name], Monsters.[Group], Monsters.[Index], Monsters.[Weapon Number], Monsters.[AC], Monsters.[DR], Monsters.[Follow], Monsters.[MR], Monsters.[Experience], Monsters.[Exp Multiplier], Monsters.[Hit Points], Monsters.[HP Regen], Monsters.[Energy], Monsters.[Game Limit], Monsters.[Charm LvL], Monsters.[Charm RES], Monsters.[BS Defense], Monsters.[Active], Monsters.[Type], Monsters.[Undead], Monsters.[Alignment], Monsters.[Gender], Monsters.[Regen Time], Monsters.[Date Killed], Monsters.[Time Killed], Monsters.[Runic], Monsters.[Platinum], Monsters.[Gold], Monsters.[Silver], Monsters.[Copper], Monsters.[Move Msg], Monsters.[Death Msg], Monsters.[Greet Txt], Monsters.[Desc Txt], Monsters.[Talk Txt], Monsters.[Death Spell], Monsters.[Create Spell], Monsters.[Desc 1], Monsters.[Desc 2], Monsters.[Desc 3], Monsters.[Desc 4], Monsters.[Attack Type 0], Monsters.[Attack Accu/Spell 0], Monsters.[Attack % 0], Monsters.[Attack Min Hit/Cast % 0], Monsters.[Attack Max Hit/Cast LVL 0], Monsters.[Attack Hit Msg 0], Monsters.[Attack Dodge Msg 0], Monsters.[Attack Miss Msg 0], Monsters.[Attack Energy 0], Monsters.[Attack Hit Spell 0], Monsters.[Spell Number 0], Monsters.[Spell Cast % 0], Monsters.[Spell Cast LVL 0], Monsters.[Attack Type 1], Monsters.[Attack Accu/Spell 1], Monsters.[Attack % 1], Monsters.[Attack Min Hit/Cast % 1], Monsters.[Attack Max Hit/Cast LVL 1], Monsters.[Attack Hit Msg 1], Monsters.[Attack Dodge Msg 1], Monsters.[Attack Miss Msg 1], Monsters.[Attack Energy 1], Monsters.[Attack Hit Spell 1], Monsters.[Spell Number 1], Monsters.[Spell Cast % 1], Monsters.[Spell Cast LVL 1], Monsters.[Attack Type 2], Monsters.[Attack Accu/Spell 2], Monsters.[Attack % 2], Monsters.[Attack Min Hit/Cast % 2], Monsters.[Attack Max Hit/Cast LVL 2], Monsters.[Attack Hit Msg 2], Monsters.[Attack Dodge Msg 2], Monsters.[Attack Miss Msg 2], Monsters.[Attack Energy 2], Monsters.[Attack Hit Spell 2], Monsters.[Spell Number 2], Monsters.[Spell Cast % 2], Monsters.[Spell Cast LVL 2], Monsters.[Attack Type 3], Monsters.[Attack Accu/Spell 3], Monsters.[Attack % 3], Monsters.[Attack Min Hit/Cast % 3], Monsters.[Attack Max Hit/Cast LVL 3], Monsters.[Attack Hit Msg 3], Monsters.[Attack Dodge Msg 3], Monsters.[Attack Miss Msg 3], Monsters.[Attack Energy 3], Monsters.[Attack Hit Spell 3], Monsters.[Spell Number 3], Monsters.[Spell Cast % 3], Monsters.[Spell Cast LVL 3], Monsters.[Attack Type 4], Monsters.[Attack Accu/Spell 4], Monsters.[Attack % 4], Monsters.[Attack Min Hit/Cast % 4], Monsters.[Attack Max Hit/Cast LVL 4], Monsters.[Attack Hit Msg 4], Monsters.[Attack Dodge Msg 4], Monsters.[Attack Miss Msg 4], Monsters.[Attack Energy 4], Monsters.[Attack Hit Spell 4], Monsters.[Spell Number 4], Monsters.[Spell Cast % 4], Monsters.[Spell Cast LVL 4], Monsters.[Item Number 0], Monsters.[Item Uses 0], Monsters.[Item Drop % 0], Monsters.[Item Number 1], Monsters.[Item Uses 1], Monsters.[Item Drop % 1], Monsters.[Item Number 2], Monsters.[Item Uses 2], Monsters.[Item Drop % 2], Monsters.[Item Number 3], Monsters.[Item Uses 3], Monsters.[Item Drop % 3], Monsters.[Item Number 4], Monsters.[Item Uses 4], Monsters.[Item Drop % 4], Monsters.[Item Number 5], Monsters.[Item Uses 5], Monsters.[Item Drop % 5], Monsters.[Item Number 6], Monsters.[Item Uses 6], Monsters.[Item Drop % 6], Monsters.[Item Number 7], Monsters.[Item Uses 7], Monsters.[Item Drop % 7], Monsters.[Item Number 8], Monsters.[Item Uses 8], Monsters.[Item Drop % 8], Monsters.[Item Number 9], Monsters.[Item Uses 9], Monsters.[Item Drop % 9], Monsters.[Ability 0], Monsters.[Ability Value 0], Monsters.[Ability 1], Monsters.[Ability Value 1], Monsters.[Ability 2], Monsters.[Ability Value 2], Monsters.[Ability 3], Monsters.[Ability Value 3], Monsters.[Ability 4], Monsters.[Ability Value 4], Monsters.[Ability 5], Monsters.[Ability Value 5], Monsters.[Ability 6], Monsters.[Ability Value 6], Monsters.[Ability 7], Monsters.[Ability Value 7], Monsters.[Ability 8], Monsters.[Ability Value 8], Monsters.[Ability 9], Monsters.[Ability Value 9]
FROM Monsters
WHERE (
(((Monsters.[Attack Type 0])=2) AND ((Monsters.[Attack Accu/Spell 0])>=5000 And (Monsters.[Attack Accu/Spell 0])<=5042))
OR (((Monsters.[Attack Type 1])=2) AND ((Monsters.[Attack Accu/Spell 1])>=5000 And (Monsters.[Attack Accu/Spell 1])<=5042))
OR (((Monsters.[Attack Type 2])=2) AND ((Monsters.[Attack Accu/Spell 2])>=5000 And (Monsters.[Attack Accu/Spell 2])<=5042))
OR (((Monsters.[Attack Type 3])=2) AND ((Monsters.[Attack Accu/Spell 3])>=5000 And (Monsters.[Attack Accu/Spell 3])<=5042))
OR (((Monsters.[Attack Type 4])=2) AND ((Monsters.[Attack Accu/Spell 4])>=5000 And (Monsters.[Attack Accu/Spell 4])<=5042))
);
... then click the datasheet view button in the upper-left-hand corner. The resulting mobs will be all of the ones that have a spell they cast in the 5000 to 5042 spell number range.