guild data linkages to character IDs

As you may have guessed, I'm very fond of open access to databases like this.  I applaud SOE for opening this up, and in a fairly usable way.  

I did find something strange though.

In the guild membership (using XML as an example) I see:

    <members>

      <member dbid="1727531" name="XXX"/>

      <member dbid="2095155" name="YYY"/>

      <member dbid="2171050" name="ZZZ"/>

However, the dbid returned is not a character ID, but rather some other type of ID.  Is there a way to map this from the dbid to the actual character, so I can then look up statistics on that character as well, or must I search the database using a string search query instead?

 

You can access it through its name.first and server name.  For example:

Code:

census.daybreakgames.com/xml/get/eq2/character/?name.first=YourName&locationdata.world=Butcherblock

You can also refer to it by this dbid, but I'm not sure if the database is indexed by that field (if it isn't, then queries will be slow).

EDIT: fixed a few silly mistakes.  Phone + forum posting = bad idea

 

Yea, I know I can search direclty on those fields, but I was hoping for a way to link the character in the member listing directly to the character using its character ID.  That seems like the best way to de-duplicate the data.

Also, of course, guild rankings aren't returned in the guild listing response, but that's another topic.

 

guild rank/status/joined are all in the guild tag in the character collection..  it's missing guild points though

 

Personally, I only poll the guild collection to have the guild-specific info, such as the name of the ranks, and the complete list of character names.  After that, I use a single REST call to poll the character collection for all members who have the same guildid - the result page contains the detail for all guild members, minus those not in the new database because they haven't logged in game since this database went live.  Make sure you c:show only what you actually wants, otherwise this list can get real long when you take into account all achievements, spells, etc...

 

census.daybreakgames.com/xml/get/eq2/character/?dbid=

will search for characters with a matching dbid. Not sure if the dbid in the guild info will match up though.

 

Not sure if last time/date online is character or guild.

current query: [url="census.daybreakgames.com/xml/get/eq2/guild/?name=<GUILDNAMEHERE>&c:resolve=members%28displayname,type.class,type.level,type.status,type.race,type.deity,type.gender,guild.rank,guild.status,secondarytradeskills,tradeskills%29">census.daybreakgames.com/xml/get/eq2/gui...,tradeskills%29[/url]#

Data was listed on old system. Woking on updating site for new Data Feed.

 

The last_update is relative to its parent object.  The link you posted is for the guild object.

You can look at the character last_update timestamp by updating your query with the following...

c:resolve=members<span style="color: #ff0000;">(last_update)

This will include the last_update attribute on the member element.

-dan

 

Thanks that worked great. Here

 

It doesn't appear to work currently, of course I could be doing it wrong. It is certainly trying to do something as the browser continues to behave as if it is waiting on data, as if it beating the DB server to death, don't want to get an IP ban so will just go the char name/location route. The dbid I am using is from [url="census.daybreakgames.com/xml/get/eq2/guild/?id">census.daybreakgames.com/xml/get/eq2/guild/?id[/url]=, tried on 2 characters of mine which pull up fine otherwise.