So... two options here. Attached below is an export containing all of the fixed spells from the spellmod fix patch, plus the 3 new ones (spells 5040 to 5042), as well as only the mobs that needed to be modified to point to these spells. So if your mudrev is based off of the dats linked on these forums you can just import this file. NOTE that the original spells (the modded spells like magic missle, eartfist, etc) are NOT included in this mdb, just the fixed stuff (spells 5000 through 5042).
Another option is to do the following procedure to just update the required fields in your own dats. This option requires Microsoft Access.
- Export all of your mobs to an export file - NOTE: you can choose NOT to enable the option on the NMR export screen regarding resetting various fields. This is irrelevant if you are properly applying your updates via update files. But if you aren't, and are editing the dats directly, then you will not want that option enabled.
- Open the file in Microsoft access
- Go to the "database tools" tab and click on the "visual basic" button.
- Go to insert -> module
- Open the attached sql.txt file linked below and select everything and copy it.
- Paste the copied text below the "Option Compare Database" in the new module in access
- Click the play button on the toolbar
- you should get a message, "done spellmod fix" to know it completed all of the commands
- right-click on the "Module1" that you added on the left-hand side and click "Remove Module1"
- on the prompt to save, answer No.
- close the visual basic window.
- close access.
- back in NMR, import your file back into your dats.
- MAKE SURE YOU HAVE SPELLS 5000 THROUGH 5042 IN YOUR DATS. If you don't have them, you can import them from the mudrev_spellmod_fix file attached here.
- note again the above note. You most likely do not have spells 5040 through 5042 because I just created them today before posting this. so import those 3 spells, at minimum.