Wiki:EQ2 Database Layouts
Unfortunately, with the eq2.zam.com revamp, these tables are no longer even remotely accurate. The Raw Dump tab on each db page can be useful for finding the db field names, but if you cannot find it or are not sure it is working correctly, please contact Bludwyng and I will help.
The following tables define the EverQuest II db tables that can be referenced using the Database Access Functions.
| Contents [hide] |
EverQuest II
quests
| Field | Type(length) | Description |
|---|---|---|
| created | datetime | Date and Time this quest db record was first created |
| updated | datetime | Date and Time this quest db record was last modified |
| id | smallint(6) | A unique number, assigned sequentially by the system at the time the quest is added to the database. |
| quest_name | varchar(255) | The title of this quest exactly as it appears in-game. If the quest name ends in a Question Mark (?), the question mark must be omitted. |
| quest_type | list | A value in the following list: Access Quest, Catalog, City Task, Collection, Hallmark, Heritage, Language, Lore and Legend, Miscellaneous, Prestige, Signature, Deity, Betrayal, Citizenship, Tradeskill, or null |
| recommended_level | smallint(6) | |
| rating | tinyint(4) | |
| experience | tinyint(4) | |
| description | text | Obsolete! Use wiki instead! |
| statuspoints | int(11) | |
| repeatable | tinyint(4) | If this field is NOT null,the quest is repeatable. |
| picture | text | full path to an image on our server (without http://eq2.allakhazam.com) or a filename expected to reside in /images/quests (an extension of .jpg is assumed if not provided) |
| submitted | varchar(100) | |
| coin | varchar(25) | |
| heroic | tinyint(4) | If this field is NOT null, the quest is Heroic |
| epic | tinyint(4) | If this field is NOT null, the quest is Epic |
| statuspointsmax | int(10) unsigned | |
| obsolete | tinyint(3) unsigned | If this field is NOT null, the quest is Obsolete |
| isBeta | tinyint(3) unsigned | If this field is NOT null, the quest is Beta and will NOT be displayed in ANY way except to admins. |
items
| Field | Type(length) | Description |
|---|---|---|
| created | datetime | Date and Time this item db record was first created |
| updated | datetime | Date and Time this item db record was last modified |
| id | int(11) | A unique number, assigned sequentially by the system at the time the item is added to the database. |
| name | varchar(120) | The name of this item exactly as it appears in-game. |
| type | list | A value in the following list: Armor, Avatar, Charm, Container, Drink, Food, House Item, Knowledge, Miscellaneous, Mount, Poison, Quest Starter, Scroll, Weapon, Adornment, Symbol, Collection, Ammo, Jewelry, Potion, SHield, Sales Container or null |
| recipe_comp_type | varchar(50) | |
| weapon_type | list | A value in the following list: Main Hand, One-Hand, Two-Hand, Ranged, Off Hand |
| skill | list | A value in the following list: Bow, Buckler, Chain Armor, Cloth Armor, Crushing, Leather Armor, Magic Afinity, Piercing, Plate Armor, Poisoning, Round Shield, Slashing, Symbols, Thrown Weapon, Tower Shield or null |
| charges | tinyint(4) | If this is a charm, how many charges does it have? 0=unlimited |
| lore | tinyint(4) | If this is not NULL, this item is flagged as Lore |
| notrade | tinyint(4) | If this is not NULL, this item is flagged as NOTRADE |
| attuneable | tinyint(4) | If this is not NULL, this item is flagged as ATTUNEABLE |
| storebought | tinyint(4) | If this is not NULL, this item can be bought from merchants |
| harvested | tinyint(4) | If this is not NULL, this item is harvested from resource nodes |
| temporary | tinyint(4) | If this is not NULL, this item is flagged as TEMPORARY |
| quest | tinyint(4) | If this is not NULL, this item is obtained as a quest reward |
| questcomponent | tinyint(4) | If this is not NULL, this item is obtained and is used during a quest |
| shieldfactor | smallint(6) | Protection |
| ac | smallint(6) | Mitigation |
| wt | float | Weight |
| mindmg | smallint(6) | Minimum Damage |
| maxdmg | smallint(6) | Maximum Damage |
| dmgrating | float | Damage Rating |
| delay | float | Delay |
| range | smallint(6) | Range (in meters) |
| capacity | tinyint(4) | For containers, this is the number of slots |
| weightreduction | tinyint(4) | Amount of weight reduction (for containers) as a percentage |
| agi | tinyint(4) | Amount of boost to Agility |
| int | tinyint(4) | Amount of boost to Intelligence |
| sta | tinyint(4) | Amount of boost to Stamina |
| str | tinyint(4) | Amount of boost to Strength |
| wis | tinyint(4) | Amount of boost to Wisdom |
| svmen | smallint(6) | Amount of boost to Resistance to Mental Damage |
| svcold | smallint(6) | Amount of boost to Resistance to Cold Damage |
| svdis | smallint(6) | Amount of boost to Resistance to Disease Damage |
| svfire | smallint(6) | Amount of boost to Resistance to Heat Damage |
| svmag | smallint(6) | Amount of boost to Resistance to Magic Damage |
| svpoi | smallint(6) | Amount of boost to Resistance to Poison Damage |
| svdv | smallint(6) | Amount of boost to Resistance to Divine Damage |
| health | smallint(6) | Amount of boost to Health Pool |
| power | smallint(6) | Amount of boost to Power Pool |
| required | smallint(6) | Required level to use |
| recommended | smallint(6) | Recommended level (not used) |
| description | text | |
| rarity | list | A value in the following list: Handcrafted, Treasured, Legendary, Fabled, Mythical, Mastercrafted, Uncommon or null |
| food_level | tinyint(4) | |
| satiation | list | A value in the following list: Average, Superior, High or null |
| duration | smallint(6) | How many minutes does the food or drink last? |
| image | text | full path to an image on our server (without http://eq2.allakhazam.com) or a filename expected to reside in /images/quests (an extension of .jpg is assumed if not provided) |
| submitted | varchar(100) | |
| skillmod | varchar(80) | |
| rentreduction | smallint(6) | If this field is NOT null, the quest is Heroic |
| effect1 | varchar(200) | |
| effecttype1 | list | A value in the list: Activatable, Permanent, Proc, Reactive Proc |
| effect2 | varchar(200) | |
| effecttype2 | list | A value in the list: Activatable, Permanent, Proc, Reactive Proc |
| level | int(11) | Minimum level to use this item? |
| novalue | tinyint(4) | |
| maxrange | smallint(6) | |
| ornate | tinyint(4) | If NOT null, this item is flagged as ORNATE |
| foodduration | varchar(22) | How long the food or drink lasts (text) |
| isBeta | tinyint(3) unsigned | If this field is NOT null, the quest is Beta and will NOT be displayed in ANY way except to admins. |
mobs
zones
objects
abilities
|
Category: EverQuest II
This page last modified 2009-05-14 11:52:10.
© 2024 Fanbyte LLC