1. I have corrected the e-mail settings so that outgoing e-mails from these forums should be sent now. If you tried to Register or Reset your Password, please try again!
    Dismiss Notice

Creating your own Resolves with C:Join

Discussion in 'Census: EverQuest II' started by Administrator, Dec 14, 2016.

  1. Administrator

    Administrator Administrator Staff Member

    Resolves

    When EQ2 Census launched, we were given just a handful of "Resolves" which is a way to join two different collections together in a query and get the results you want. For instance, joining characters to their guild, or spells to a character. Again there are only a half dozen or so resolves in EQ2 Census, so this is obviously very limited.

    This query brings the guild Honor Among Thieves from the Maj'Dul server, and then populates the Class and Level of each guild member. Note that characters who have switched guilds, been deleted or banned, or who haven't logged in since October 2011 will not be "resolved":

    census.daybreakgames.com/xml/get/eq2/guild/?name=Honor%20Among%20Thieves&world=Maj%27Dul&c:resolve=members(type.class,type.level)

    This query returns the character Bladecinder from the server Maj'Dul (querying the worldID of 604 is more efficient than the worldname of Maj'Dul because the worldID is indexed), and then populates the name, tier_name, and level for each spell that character knows:

    census.daybreakgames.com/xml/get/eq2/character/?locationdata.worldid=604&name.first=Bladecinder&c:show=displayname,type,spell_list&c:resolve=spells(name,tier_name,level)​

    C:Join

    Since there's no way Platform could add all of the Resolves we might ever want to use, they have given us the ability to make our own using c:join. I should warn you that the syntax is devilishly complex and it is very easy to make mistakes. Also because some of the characters used in the query are converted to html entities in Chrome, it is easy to end up with a scrambled URL by copying and pasting repeatedly. Always keep a copy of your good URL somewhere safe.

    As you look at these queries, you may notice something strange. There's a reference to "recipe_detail" or "quest_detail". There is no such field in Census. This seems to be a pseudofield, but it works!

    List of Recipes for a Character with Recipe Name & Bench populated:

    census.daybreakgames.com/json/get/eq2/character_misc/?id=863289273747&c:show=known_recipe_list&c:join=recipe^on:known_recipe_list.id^to:id^inject_at:recipe_detail^show:name'bench

    List of In-Progress Quests for a Character with Quest Name & Level populated:

    census.daybreakgames.com/json/get/eq2/character_misc/1722282572777?c:show=quest_list&c:join=quest^on:quest_list.crc^to:crc^inject_at:quest_detail^show:name'level

    List of Completed Quests for a Character with Quest Name & Level

    census.daybreakgames.com/json/get/eq2/character_misc/1722282572777?c:show=completed_quest_list&c:join=quest^on:completed_quest_list.crc^to:crc^inject_at:quest_detail^show:name'level​
     

Share This Page