In this tutorial I go over how to create custom items, and how to import them into your database,
This is something relatively easy and can be done by noobs,
You will need a program called Navicat Lite: [Only registered and activated users can see links. ]
Steps:
1.
Go to the site [Only registered and activated users can see links. ] and click on create. You can create any of the items listed, but in this guide I'll be showing you how to create a weapon. Choose a name and put it in the name input box and you can also put a quote if you want. Then, pick what item quality you want your weapon to be.
2. Picking a Display ID and Entry ID:
The display id is the model you want your weapon to be. For example, if you want your weapon to look like the Bloodvenom Blade you would put 64536 in the display id entry box. Click the DisplayID link for a complete list of display id's. Alternately, you can go to thottbot.com or wowhead.com. For my weapon I will use the display id 53563. The entry id is the id used to spawn the weapon and put it in shops. It must be different from all other items. The first unused entry id is 51546 so use 51546 for your first item, 51547 for your next, and so on.
3. The Rest of the Info:
The rest is just self-explanatory, just fill out what info it tells you to (keep the item bonuses on easy mode for now, I will go over how to use advanced mode in a later guide). Your final product will look something like this:
Step 3 continued: Click download and then ArcEmu > v2801 (or ArcEmu < v2801 for older versions). Save it to your desktop.
4. Importing your item into your Database:
Start your MySQL server and Navicat Lite. In Navicat Lite, go to file - New Connection - MySQL. Name the connection anything and put "ascent" without quotes for the password. Don't touch anything else and hit ok. Your connection should show up on the left panel. Double-click it and you should see the databases Character, information_schema, logon, mysql, and world. Double-click on world and then right click world and click Execute Batch File... Navigate to your desktop and click your sql file. Hit start and if you see 1 queries completed successfully then your in the clear.
5. Getting your item in-game:
To get your item in-game through a command you need to have gm access. Type .char additem <entry id of custom item here>. In this case, we would type .char additem 51546. The item should be added into your inventory. Congratulations, you've just made - and added to your server - your very own custom item!
In a future tutorial I will be going over how to add your item to a vendor and how to use the advanced item bonus editor. (which is not hard at all to figure it so try it yourself!)



LinkBack URL
About LinkBacks


Reply With Quote




Bookmarks