Creating and Adding Custom Spells - Twigie/vmangos_guides GitHub Wiki
How to add custom spells
Firstly download the tools in the important links section.
Set up the "WoW Spell Editor"
In order to create a new spell in WoW Spell Editor you will need to copy an existing spell, If a spell exists that remotely resembles the one you want to make copy that one, otherwise select a random spell to copy. Once your new spell is copied you will have to go through many fields to get it how you want it. Some of the fields have confusing names use this link to help understand what everything does CMangos Spell Wiki
Once you have completed editing the spell select export at the top menu, then select export dbc's. This will export all the spells into a export folder at the exe's location.
Open Ladiks Mpq Editor, we will use this tool to create a patch with the dbcs we just generated.
Create a new mpq for vanilla/classic, create a folder called DBFilesClient, find the dbcs that the spell editor created and drag them into the folder you create in the mpq editor and thats it.
Copy the mpq file that you created and add it to your clients data folder name patch-3.mpq.
Now that the client has the new spells we need to add them to the data base. When you started WoW Spell Editor you should have decided on a database to store the info. We will use this sql query to get that row and put it into a format that the vmangos db will like.
SQL Query (Had to remove Quotes in order to work with heidisql)
Now add the converted sql into the vmangos spell_template table and you should be set
Delete you WDB cache