[Guide]How to make custom items using ADE (With Pictures)

[uberkiid]

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.

[Dalamar]

Would help if you added a download link for ADE, but nice guide anyway. +2rep.

[florinel76]

hey man i get an error ... it says "incorrect integer value for column mapid at row 1"
thats when i run the code in querry

did i put values bigger than what it is capable ade to create for items ?

[Malaki2030]

Is this ADE version updated to 2.4 ish? I last ADE Version i saw was pretty old...wasn't able to create new items or anything with it cause I kept getting an error.

[xQzme?]

Good guide for ppl who dont know how to use it

[Waffeleisen]

hey man i get an error ... it says "incorrect integer value for column mapid at row 1"
thats when i run the code in querry

did i put values bigger than what it is capable ade to create for items ?

I have the same problem!

Greets

[macintosh]

I couldn't even open the .zip file...said it was corrupted or blocked...then i couldn't even unzip it because it said there were no files inside it

[uberkiid]

hey man i get an error ... it says "incorrect integer value for column mapid at row 1"
thats when i run the code in querry

did i put values bigger than what it is capable ade to create for items ?

post a screen shot of your item your making

I couldn't even open the .zip file...said it was corrupted or blocked...then i couldn't even unzip it because it said there were no files inside it

is working just fine not sure whats wrong

[dragond]

I cannot connect to my mysql it says "Error on connecting three possible ways" WTf//?

[uberkiid]

I cannot connect to my mysql it says "Error on connecting three possible ways" WTf//?

make sure sql is on, make sure you typed passs word in right, make sure you have world as world database