total experience points of character

I don't seem to find how I can get the total earned experience for a certain character.
Some of the posts I've read seem to indicate it was a property of the character collection when the api was in beta
(for example: [url="https://forums.station.sony.com/soe/index.php?threads/ps2-beta-vs-ps2-get-character-info.11500062398/#post-11500333684" class="internalLink">https://forums.station.sony.com/soe...-character-info.11500062398/#post-11500333684[/url])
But as far as I can see it isn't anymore?

 

As far as I know, experience = score. You can get the player's "value_forever" score via characters_stat, but it doesn't list total score, only total per class, so you'll have to add those values together yourself
for example: http://census.daybreakgames.com/get/ps2:v2/ch...stat^list:1^inject_at:stats^hide:character_id

 

Thx so much for your response, I would probably have never figured it out lol

I dont really understand join all that well, your example got me a little further though

To further understand the c:join, a few follow up questions:
1) For example not setting list:1 will produce only 1 result, how to know it is a list? Just try it and see, or is there a better way to know?

2) Also how does c:join know how to join? ie. how do I know what is joinable?
Its not because character_id in the query itself, because
http://census.daybreakgames.com/get/ps2:v2/character/?name.first=Frydac&c:join=characters_stat^list:1
works as well, so I'm guessing it tries to match a (random?) field (in this case character_id) from the result of the first query to a field in the 'table' of the join parameter/type?
So when you want to know what is joinable:
<div style="padding-left: 30px">use this to get a list of all the collections:
<div style="padding-left: 30px">http://census.daybreakgames.com/get/ps2:v2/
<div style="padding-left: 30px">Then randomly try
<div style="padding-left: 30px">http://census.daybreakgames.com/get/ps2:v2/characters_stat
<div style="padding-left: 30px">then notice there is a field named character_id that can be matched to a character? Or is there a better way?

3)Wanted to ask this, but figured out how to filter the join list to only entries with stat_name=score:
add "^terms:stat_name=score" to the query

Anyhow, thx again

 

Just FYI, you can do multiple joins at the same level too (i.e. you can get characters_stats and characters_stats_history in the same query).

Here's the query that I'm probably going to be using to get individual character data for the project I am working on. It includes everything I could think of except for events (i.e. killboard), but only does the initial joins (I'm going to use cached data to resolve the related IDs on the static stuff)

• outfit_member_extended
• characters_skills
• characters_stat
• characters_stat_history
• characters_stat_by_faction
• characters_weapon_stat
• characters_weapon_stat_by_faction
• characters_world
• characters_item
• characters_achievement

<span style="text-decoration: underline"><span style="color: #1155cc"><span style="font-size: 15px">http://census.daybreakgames.com/get/ps2:v2/character/5428010618015204433?c:join=outfit_member_extended^inject_atutfit,characters_skill^list:1^inject_at:skills,characters_stat^list:1^inject_at:stats,characters_stat_history^list:1^inject_at:stats_history,characters_stat_by_faction^list:1^inject_at:stats_by_faction,characters_weapon_stat^list:1^inject_at:weapon_stats,characters_weapon_stat_by_faction^list:1^inject_at:weapon_stats_by_faction,characters_world^inject_at:world,characters_item^list:1^inject_at:items,characters_achievement^list:1^inject_at:achievements

 

Just found a slightly easier (and probably better) way to get the total score, by using the historical stats (instead of the by-class stats):
http://census.daybreakgames.com/get/ps2:v2/ch...story^hide:character_id^terms:stat_name=score
(just pull out the "all_time" value from that).

To answer your other questions:

1) The only way to know if it's a list or not is to try it and see, If in doubt, assume it's a list and then modify the query if it isn't. Generally, it's pretty easy to tell which joins will be lists and which ones won't after you've been doing it for a while.

2) if you don't specify the "on" and "to" values in the join, it will just use the primary key of the table that you are adding on. If it doesn't find matching IDs that way, it'll simple return the results without the join (which can be a little frustrating). You can join on any table as long as you can match an id in each table (and they don't have to be named the same). In most cases you won't need to specify the IDs.

For example:
c:join=character^on:character_id^to:character_id

This query gets my character joined with what skills (certs) he has, joined with skill_line, joined with skill_category, joined with skill_set, joined with item based on the "required_item_id" of the skill_set to the "item_id" of the item, and then joined on the item_category of the item (this query may take a while due to all of the joins)
<span style="text-decoration: underline"><span style="color: #1155cc"><span style="font-size: 15px">http://census.daybreakgames.com/get/ps2:v2/character/5428010618015204433?c:join=characters_skill^list:1^inject_at:skills^hide:character_id(skill^inject_at:skill%28skill_line^inject_at:skill_line(skill_category^inject_at:skill_category(skill_set^inject_at:skill_set(item^inject_at:required_item^on:required_item_id^to:item_id(item_category^inject_at:item_category)))))&c:lang=en

 

Oh didn't realize it was in the stat_history. I'm already pulling that info for the playtimes of my outfit members (which seem not all too correct in a lot of cases) in my current 'project' hehe, no need to for further queries then

Thx for that mega query, will analyse it.
Accidentally the next item on my todo-list is to list certain skills from all my outfit colleagues.