Heres my first Emulating guide ever
Tools-
Ascent Database Editor
For this guide we will just make an example.. let's say a low level one-hand sword.
Making the item
1. Extract/unzip Ascent DB Editor anywhere on your computer and then open it up. And select these settings:
Code:
Host: Your server IP
Username: your SQL username
password: your SQL password
database: ascent
and Check the compatibly Tester
And click proceed.
2. Now put in this information:
Entry ID: 800201 [ The ID you use to spawn the item in yours or someones inventory ]
Class: Weapon[ What sort of item it is. In this case: Weapon ]
Sub-Class: Sword[ This is a weapon yes, but what kind of a weapon ? a Sword. ]
Name: Test sword 1[ Name of the sword ]
Display ID: 13488[ The weapon model/how it looks. I'll tell you later on how to find Display ID's ]
Quality: Rare ( Blue )[ What quality the weapon is.. Poor, good, rare, epic.. and so on. ]
Buy price: Anything you want.[ How much people will buy it, if there will be a vendor selling it. ]
Sell Price: Anything you want. [ How much vendors will buy it for. ]
Item level: 38 [ Basically.. the item level. NOT THE REQUIRED LEVEL. ]
Container slots: 0 [ If this is a bag, this shows how many slots it will have. ]
Stack size: 1 [ How much it can stack up in your inventory. This is a weapon so keep it on 1. ]
Bonding Type: Bind on Equip [ How it will bind to you. ]
3. Now for the tabs
Stats
Here you can add Stamina, critical strike chance or what ever you want. And also set the Durability
for example if i'd like to add +10 stamina on my sword i do this:
Go to "1#" then select "Stamina" as a stat type and type "10" in the Stat value.
and.. lets say 100 in durability.
Easy, just do what you want with the stats and durability.
Weapon
Here you can set the damage of the weapon, and speed. You can also add like holy damage or nature damage.
So I'll select "#1" and then select normal "Damage Type" and set the damage to "41 - 84"
And let's make the "Milliseconds between each strike" ( speed ) to "2200" witch is 2.20 speed.
and no weapon range.. this is a sword, not a ranged weapon.
Armor
We don't need the armor right now since this is a weapon.
And it actually doesn't really need explaining. Simple enough, just basic resistances, armor and block values.
Spells
This is the place where you can add "Chance on hit" things.. but we won't do that right now.
Besides, i my self, never use this tab. So i can't explain it without being 100% sure now can i ?
I'll explain on how to find these spell ID's later on this guide.
Requirements
This is where you can make your item be required to use. For e.x: you can make your item be only allowable to be used by Orc Rogues or only Rogues.. what ever.
This is also where you can set the item Level requirement.
Allowable classes: 1503 [ What classes are allowed to use the item. (This means all classes, but classes that don't have the weapon skill to use it can't use it . ) ]
Allowable Races: 1791 [ What races are allowed to use the item. ( This means all races ) ]
Skill ID: 0 ( No skill ID ) [ I my self am not 100% sure on what this is but I'm guessing it lets your item allowable for people with a special skill or something ]
Skill rank: 0 [ Not sure what this is.. ]
Faction: 0 ( no faction ) [ What faction you need to be in to use it ]
Faction Standing: Hated [ How much reputation you need to have in the faction you chose ( if you chose one ) ]
Required Level: 30 [ What level the player need to be to be able to use the item. ]
Sockets
Here you can add sockets, as in what gems you can add on your weapon or armor.
Socket #1 color: Yellow [4] [ What sort of a gem you can add on the weapon. ]
Let's leave the rest on just "No socket [0]"
Socket Bonus: 0 [ choose a socket bonus if you'd like. ]
Miscellaneous
Alot of crap that is useless and useful.
Here you can add additional text and put the item in some sort of an item set and make it unique or not. And some more stuff
Inventory Type: Weapon [ Not really sure what this is.. ]
In set (ID): No Set [0] [ In what item set it is ]
Starts a quest (ID): 0 [ If the item starts a quest, use this. ]
Item Page: 0 [ Not correctly sure what this is ]
Unique: Unchecked. [ item unique setting and value ]
Item position (visual): One handed sword (on the side) [ Where the weapon is positioned on the player when the weapon is unsheathed ]
Descriotion: Anything you want [ The yellow additional text on the bottom of the item information in-game ]
Alright, the weapon is done.
just click "update" in the lower right corner to save it on your server.
YOU WILL HAVE TO RESTART THE SERVER TO MAKE THE WEAPON APPEAR ON THE SERVER.
Exporting into a .SQL file
1. Go to logging settings in the top corner in the DB editor.
2. Check the "Log Queries, click browse and find a place to put the .sql file on your computer.
3. make a name.. let's say "testsword1.sql" and then click save.
4. Click export. And then there will be a file named "testsword1.sql" in the directory you chose with the Log Queries.
How to find item Spell ID's and Display ID's.
1. go to WoWhead and search for the weapon or armor that you like to make it look like.
2. In the end of the URL on WoW head is the Item ID. Copy it and then go to your DB Editor>items, click "choose item" and put the IP you copied into the "Chosen ID:" slot.
Now it will load up the weapon/armor and if you look in the display ID you will see the display ID used to make the weapon/armor look like that. Copy it and put it on your own item.
The same goes with Spell ID's.