item_template table

The item_template table in the database holds the following information:

1.entry - Holds the unique item ID for each item

2.name - Holds the name for the item

3.type - Holds the type of the item. (string) Currently supported types - misc - a miscellaneous item that does not serve any direct purpose potion - a consumable item that gives a buff weapon - a weapon item that is equippable by the player equipment - an equipment item that is equippable by the player ex: Headpiece, Shoulderpad, etc

4.sub_type - Holds the sub-type of the item. (string) Currently supported sub-types - equipment - Headpiece, Shoulderpad, Necklace, Chestpiece, Bracer, Gloves, Belt, Leggings, Boots

5.armor - The amount of armor this item gives the user

6.health - The amount of health this item gives the user

7.mana - The amount of mana this item gives the user

8.strength - The amount of strength this item gives the user

9.agility - The amount of agility this item gives the user

10.buy_price - The amount of gold the item can be bought for (if for sale at all)

11.sell_price - The amount of gold the item can be sold for from the player

12.min_dmg - the minimum damage if the item is a weapon

13.max_dmg - the maximum damage if the item is a weapon

14.quest_ID - the ID of the quest for which this item is required

15.effect - (only for potions) the ID of the buff in the spell_buffs DB table this item gives on use.