State of the EQ2 Data -- Updated 2013.12.12

Let's try to have an updated thread with the state of all EQ2 data currently available in Census, including known bugs and oversights. Items marked in red are bugged or on our wishlist.

Constants (link)

• Adventure Class List -- provides complete map of archetypes, classes, and subclasses by ID with Alternate Advancement Tree numbers for each.
• Alignments
• Equipment Slot List -- internal and human-readable names (and slot ids in two different numbering schemes) for equipment slots.
• General Spell Property List -- Human-readable names for nearly 100 spell effects.
• Language List -- Master language list with IDs.
• Petkey List -- Beastlord pet types with pet IDs and Beastlord AA IDs.
• Race List -- Master list of races with IDs.
• Reforging Constants List -- Conversion ratios for stats which are either the source or destination of Reforging.
• Skill List -- Distinct list of required skills. Most are not visible in-game, however some are crucial to properly displaying weapon wield type and handedness:
  • Adorning, Axe, Bow, Buckler, Crushing, Dagger, Fists, Focus, Greataxe, Greathammer, Greatspear, Greatsword, Hammer, Kiteshield, Mace, Piercing, Ranged, Rapier, Roundshield, Slashing, Staff, Sword, Thrownweapon, Tinkering, Towershield,
• Tradeskill Class -- Breakdown of tradeskill classes and subclasses.
• Tradeskill Property List -- Decoder for Tradeskill skills.

Items

Item data is the most mature collection in EQ2 Census. Achievements collection in Census...

BUG: Achievement data is exporting with international text strings in Japanese, French, German, and Russian.
BUG: Tears of Veeshan achievements have not been fully exported.​

Spells

Spell data is largely complete, although some values such as Range, Accuracy, and Target are still missing. Spell collection in EQ2 Census...​

Factions

Faction data is complete and contains Faction ID, Name, Category, and Min/Max amounts. Faction collection in EQ2 Census...​

Alternate Advancements

Alternate Advancement data is complete. Alternate Advancement collection in EQ2 Census...​

Marketplace Items

Marketplace data is complete. [url="https://forums.station.sony.com/soe/index.php?threads/eq2-sc-marketplace-data.11500062243/" class="internalLink">More Details...[/url]​

Quests

Quest data is to a point where fan site development can begin. [url="https://forums.station.sony.com/soe/index.php?threads/eq2-quest-and-collection-data.11500062928/" class="internalLink">More Details...[/url]​

BUG: Quest data is missing complex item rewards, conditional item rewards (predicates on itemtables), mysterycrates, etc.
BUG: Quest data is missing minimum level, quest starter, and starting zone information.​

Collections

Collection data is complete. [url="https://forums.station.sony.com/soe/index.php?threads/eq2-quest-and-collection-data.11500062928/" class="internalLink">More Details...[/url]​

Recipes

Recipe data is to a point where fan site development can begin. [url="https://forums.station.sony.com/soe...quest-collection-and-recipe-data.11500062928/" class="internalLink">More Details...[/url]

WISH: Recipes should include Byproducts.
WISH: Recipes could include the Progress required to complete the craft.
NOTE: Recipe components are given by item Name instead of ItemID, so matching tables will be needed.​

Character Misc

Active Quest Journal, Completed Quests, and Known Recipes have been exported in Character_Misc since August.​

BUG: Quest Journal stages are exporting in the current language, ie. German, French, Russian, or Japanese, for those players in other regions. This will make outside display of Quest Journal impossible for these players.​

BUG: The character's progress in completing shiny collections is not exported in character_misc.​

Zones, Spawncamps, NPCs, Treasureclasses, and Item Tables

These are the 5 data types needed to officially support Loot Tables, specifically knowing which NPCs in which zones drop which items and with what frequency/weighting.​

NPC Kill List

WISH: A list of every starred Named (NPC) which the player has killed.​

Server Variables

WISH: In-game Calendar data.
WISH: Hot Zones, Fabled Zones, Daily Double Zones​

 

-reserved-

 

Spells: Some additions we've known for a while but are low priority for just viewing the data. When analyzing the data these become a bit more higher priority.

WISH: The spell data should be the base data, not slightly altered from the export process. This makes any calculations off.

WISH: The AA spell data is just broken. Other then a general idea of what the AA does, the data components are just off by miles. AA spells that do XXXX damage in game are showing min and max values of 1.

WISH: The spell and AA data would be nice if they had a programmatically readable variant of the effects section, so we would not need to parse effect descriptions for details. Or even just attributes on the effects defining details of the effect (type [dmg/buff/debuff/spellTweak], min, variance, duration, etc)