Learn About EQ2 Data -- Sunday October 4th, 2015 @ 1pm PDT

This is an archived post...

It’s hard to believe this month marks four years that the EQ2 Census service has been in continuous operation. Over that time, there have been just a handful of EQ2 websites that use the service, including Roster Master, EQ2 Mission, Dragon’s Armory and our own EQ2U. However Daybreak’s generous offer of this data was always intended for anyone who was interested in data analysis, or the building of websites and mobile apps. By comparison, DCUO and PlanetSide 2 each have over a dozen websites and mobile apps leveraging this data.

UPDATE: The livestream started on Sunday October 4th at 1:00pm PDT. That’s 4:00pm EDT, 23:00 BST, and Monday October 5th @ 0:00 CET. It concluded after 1 hour 10 minutes. Thank you very much to those who joined me for this livestream.

This livestream is rather Technical in nature and lays the foundation of how to request EQ2 data through Census calls. A followup stream will build upon this foundation and create a rudimentary Guild Roster website in PHP language.

I’ve edited the 72 minute livestream down, removing a few dull bits, an exploration of a feature which it turns out has been removed (oops!), and also blanking out my misbehaving webcam which displayed static for approximately 5 minutes towards the latter half of the program. I suggest popping out the video (it’s in full 1080p) so that the query calls can be more easily be read…

Conclusion

Thank you once again for tuning into the livecast. If there is anything I can do to assist you in building Census-driven websites and mobile apps for EQ2 or any other game Daybreak supports, please let me know! I’m @EQ2Wire on Twitter, morganfeldon (at) gmail.com on Gmail/Hangouts Chat. I’ll have a followup livecast soon!

 

Example Census Queries

Characters, Items, Spells, Achievements, etc. are things that we had to explore on our own to figure out how to read and handle this data vs, how it looked in-game. We have never gone back and produced documentation on how Characters, Items, Spells, etc. work. This is something I would like to go back and do some day. In the mean time, here are some example queries on how to get started:

• Raw EQ2 Character: http://census.daybreakgames.com/xml....first=Feldon&locationdata.world=Butcherblock

• EQ2 Character with a SHOW filter: http://census.daybreakgames.com/xml...locationdata,quests,guild,account,displayname

• EQ2 Characters with over 6,500 quests completed: http://census.daybreakgames.com/xml/get/eq2/character/?quests.complete=]6500&c:show=displayname,quests&c:limit=50

• EQ2 Character with a Resolve on Item Name & Level: http://census.daybreakgames.com/xml...esolve=equipmentslots(displayname,leveltouse)

• Count of level 95+ EQ2 Characters that are Aerakyn race (id#20 from Constants page): http://census.daybreakgames.com/xml/count/eq2/character/?type.raceid=20&type.level=]95

• Count of EQ2 Characters with Mithril Ring of Amplified Power equipped: http://census.daybreakgames.com/xml/count/eq2/character/?equipmentslot_list.item.id=2955538444

• Guild Roster with AAs, Level, Race, Class, and Deity for each character: http://census.daybreakgames.com/xml/get/eq2/guild/?name=Honor Among Thieves&world=Butcherblock &c:resolve=members(displayname,type.aa_level,type.race,type.deity,type.level,type.class)&c:show=member_list,name,world

• Distinct list of all EQ2 Spell Categories: http://census.daybreakgames.com/xml/get/eq2/spell/?c:distinct=given_by

• Alternate Advancement Tree Info for Monks:
  • TreeIDs: http://census.daybreakgames.com/xml/get/eq2/constants/?c:show=adventureclass_list
    • Monks have all these AA trees: 2, 17, 47, 62, 73, 106, 121, 127, 149, 158
  • Tree #149 (Class Prestige): http://census.daybreakgames.com/xml/get/eq2/alternateadvancement/149
  • The Monk prestige ability “Undeniable Power” has a spellcrc of #378524994
  • Show the versions of this spell if 1-8 points are spent in this AA choice: http://census.daybreakgames.com/xml...24994&c:limit=20&c:show=effect_list,tier,name

• Item named Primeval Hauberk of the Virtuoso: http://census.daybreakgames.com/xml/get/eq2/item/?displayname=Primeval+Hauberk+of+the+Virtuoso

• All Shoulder Items with 1200+ Agility equipable by Monks: http://census.daybreakgames.com/xml/get/eq2/item/?slot_list.name=Shoulders&modifiers.stamina.value=]1200&c:has=typeinfo.classes.monk &c:show=displayname,modifiers.stamina,typeinfo.classes.displayname&c:limit=20

• Items starting with the name “Primeval Hauberk”: http://census.daybreakgames.com/xml...rimeval+Hauberk&c:show=displayname&c:limit=10

• Items starting with the name “Primeval Hauberk” (case-insensitive): http://census.daybreakgames.com/xml...rimeval+hauberk&c:show=displayname&c:limit=10

• Items containing the words Longbow and Bluejacket in the name (case-insensitive): http://census.daybreakgames.com/xml...c:limit=10&c:show=displayname,type,leveltouse

• Level 90 items that have Flurry (first 100 in no particular order): http://census.daybreakgames.com/xml/get/eq2/item/?leveltouse=90&c:has=modifiers.flurry &c:show=displayname,leveltouse,modifiers.flurry&c:limit=100

• Level 90 items that have Flurry (sort from highest to lowest on Flurry): http://census.daybreakgames.com/xml/get/eq2/item/?leveltouse=90&c:has=modifiers.flurry &c:show=displayname,leveltouse,modifiers.flurry&c:limit=10&c:sort=modifiers.flurry:-1