Part 1
Plan your armor set.. What class it will be for, what class spells you want the set to have on it. Find all 8 matching items for the set. Plan the sets item numbers you will use to bring them in game. And a good Name for the set. And don't forget to write down all the display ids of the items for the set to use when to make the SQL. You can view this vid for ideas on sets!
VIDEO 3.3.5 only
Trintycore
Tools you will need!
Mydbceditor
MySQLYog
mpqediten32
Now you are set to start building your set. 1st copy and keep a backup of your itemset.dbc. Then open the itemset.dbc with Mydbceditor and find a 8 peace armor set that you want to model your set from.
Brake down of the columns
1-2 Set ID Number and Name
18 don't touch
19-27 Item ID numbers for the set
28-43 Used for the spell ids that will show up on the armor set as you add them.
44-51 Used to set when the spells activate as you add parts of the set.
52-53 unknown
I would not try to add more spells or armor items to the set than what the set you modeled from has on it. Try at your own risk
Plan your set ID number so as not to overwrite an existing one.
Click on a set you want to model from and at the top of the window click edit. On the drop menu, click on "copy line to" link. In the box popup type your unique ID number and click the OK button.
The new line will be added to the bottom. Rename the armor set in column 1-2. If you have planed your sets Item ID numbers you should now use them to replace the item numbers in column 19-27.
You can use this db to find the spell ids you want your armor to have as you put them on.
Add the spell ID numbers to column 28-43
Save and part 1 is done.
2nd
Open your MYSQLYog and find the item_set_names db and open it.
If you planed your set you should know what item numbers and item names you will be using..
List of InventoryType
helm 1
shoulders 3
chest 5
wrist 9
hands 10
belt 6
legs 7
feet 8
Now its time to make your armor set. You can build a SQL, or go to the item_template with MYSQLYog and inter the info by hand. Or you can use a site like this one.
http://wow-v.com/ If you use this site to make your armor, in the part where you add the set ID , use your unique ID number. It will say when you submit it that the set ID is invalid, but it will work anyway after you complete all the work of running the SQLs into the database and make the patch.
3rd
you will need to make a patch so your armor will show the set item info you made.
Copy the itemset.dbc you edited to your Core DBC folder and mpqediten32 work/DBFilesClient folder and create your patch, add it to your data folder and test it in game.
For Icon changes see Part 2 here
viewtopic.php?f=26&t=7650 Hope you find this useful, thanks for reading!
