Ok so today im going to show you how to make custom items using ADE (Ascent Database Editor) with mysql.
http://www.mmowned.com/forums/progra...9-05-08-a.html
Link to download ADE.
First make sure my sql is running and launch ADE.
You should get a window like this. Put in your mysql information. Make sure to put world for World Database.
http://i307.photobucket.com/albums/n...der18/ADE1.jpg
Ok once you connect click World DB editor. Click Items tab. Once there click Choose item to find an item ID.
http://i307.photobucket.com/albums/n...der18/ADE2.jpg
Im going to pick thunderfury ID so just type in the item name and wait for the list to come up. Click the item you you want then click choose.
http://i307.photobucket.com/albums/n...der18/ADE3.jpg
Ok once you have chosen your item make sure you change the entry id.DO NOT CHANGE DISPLAY ID this is what your item will look like. You can change the item name if you would like. Ok so im going to leave the sub-class and Quality the same (these change the item to be a mace,fistweapon,etc. or cloth,mail etc. and the quailty changes it to be Epic or Legendary). For allowable races and classes im going to keep the same ( This changes what class and races can use the item anything unticked will be unable to use it). For required level im going to make mine 70 from 60.
http://i307.photobucket.com/albums/n...8/ADE4-1-1.jpg
Ok now to edit the stats. At the bottom there will be a window with a bunch of tabs at the bottom you should be at the stats tab. When you click the name of the stat that it has a drop down window should appear that has all the stats you can add. Be sure to change stat value to what you want the stats to be.
http://i307.photobucket.com/albums/n...der18/ADE5.jpg
Now lets click the weapon tab (skip this step if you are making armor). Ok so if you click on the drop down menu under damage type you will find a list of damage types. Below that there is a section for damage first box is for min damage 2nd is for max. For milliseconds between attacks change what you want your attack speed to be in milliseconds, so if you set your speed at 2500 the weapon speed will be 2.5 speed same for ranged.
http://i307.photobucket.com/albums/n...der18/ADE6.jpg
Ok now lets click the armor tab here we will change the resistances on your item. Also we will change the armor on it and block.
http://i307.photobucket.com/albums/n...der18/ADE7.jpg
Now click on spells tab this is where you can add attack power, spell damage, healing. to seach spell id for spell damage click the ... and type spell damage in the menu. Once you have done that make sure trigger is what you want it. (on equip, use)
http://i307.photobucket.com/albums/n...er18/ADE10.jpg
http://i307.photobucket.com/albums/n...der18/ADE8.jpg
http://i307.photobucket.com/albums/n...der18/ADE9.jpg
Ok click on the socket tab now. Here we can change what socket we want in our item yellow, meta, blue, red and a socket bonus. To find the socket you want click the drop down menu and it will show a list of sockets. Then click the ... by socket bonus and type what you want. im going to seach +10 spell crit.
http://i307.photobucket.com/albums/n...er18/ADE11.jpg
http://i307.photobucket.com/albums/n...er18/ADE12.jpg
The required Tab isnt very importtant unless you are making a reputation item. Im just going to skip to misc tab. Once there you can change what set it belongs to. To do that click on the drop down menu for In set (id) and it will bring up a menu with all the sets ingame. Item position is how it will be displayed when the character is using. So im going to make mine a staff.
http://i307.photobucket.com/albums/n...er18/ADE13.jpg
http://i307.photobucket.com/albums/n...er18/ADE14.jpg
Once you have changed everything to what you want your item to be click on Gen. SQL in the bottom right corner.
http://i307.photobucket.com/albums/n...er18/ADE15.jpg
You will get a pop up saying SQL querys were created just click ok.
http://i307.photobucket.com/albums/n...er18/ADE16.jpg
You will then get two windows one full with text just copy that.
Then you will need to go into your MySQL make sure the world database is clicked paste it into the query window and hit the execute button.
http://i307.photobucket.com/albums/n...er18/ADE17.jpg
http://i307.photobucket.com/albums/n...18/ADE18-1.jpg
Congrats you have made you very own custom item using ADE!
If you get an error saying duplicate key entry, go back and change the entry id and do Gen. SQL and copy and paste that into you query window till you get one that isnt taken already.
If you need help pm me or post a reply.