Trying to get the players of a specific world

I'm trying to find out how many players are on a given world by faction, the best I can come up with is:

List all the players:

http://census.daybreakgames.com/get/ps2-beta/...amp;c:show=type

And now cross reference all those character IDs one by one with the characters_world:

http://census.daybreakgames.com/get/ps2-beta/...016459737221617

For a start, I only ever get 5000 characters returned from the first URL, and secondly this seem horrendously inefficient!

Am I missing something?

 

I believe this is what you are looking for:

http://census.daybreakgames.com/xml/get/ps2/c...amp;c:limit=100

 

Wow thanks! OK, that's just raised more questions (Due to my ignorance mainly!)

Firstly:

1) What does 'resolve' really do then? It seems to be 'adding' data to the returned records. Without c:resolve=world there's no mention of the world, but then it magically appears with it. I'm now going to consider 'c:resolve' to be 'also list optional data' - let me know if that's not close to actuality!

2) How do I get the characters for a particular server. I've tried:

http://census.daybreakgames.com/get/ps2/chara...&c:limit=10&world_id=10

and

http://census.daybreakgames.com/get/ps2/chara...&c:limit=10&world=10

but they don't really return anything

3) How do I get around the limit on the returned results? It seems that the maximum returned results is 5000. Can I do multiple queries to get the full set?

 

Resolves allow you to bring data from one collection into another where they intersect. The list of PS2 Collections and you can see which resolves are available.

It's really frustrating that Census.soe.com does not allow returning search results with JML. This prevents me from seeing where world_id actually shows up in the tree. I just spent 15 minutes with trial and error and could not find the correct variable path:

• &world_id=18
• &world.id=18
• &world(id)=18
• &world(world_id)=18
• &character.world_id=18
• &character_list.world_id=18
• &character_list.world(world_id)=18
• &character_list.character.world_id=18

and none of them work. So I'm not sure what you'll be able to do here.

You're trying to request more than 5,000 characters at once? No wonder Census is so slow.

Page through the results:

http://census.daybreakgames.com/get/ps2/chara...0&c:count=1

That gives you the first 100 characters starting with record #0. And it tells you a count of the total number of results (3,645,554) so you know how much you need to page through.

 

That's a shame, but at least you've given me some ideas on how to investigate this more myself in the future

Yeah - sorry about that everyone! I knew it probably wasn't right, but my mantra is always 'optimise late' - no point it being fast if it doesn';t work first <img src="/smilies/69934afc394145350659cd7add244ca9.gif" border="0" alt="SMILEY" />

Perfect - I'll be sure to use that, thanks!

 

In your query ([url="http://census.daybreakgames.com/get/ps2/character/?c:resolve=world&c:show=world,type.faction&c:limit=10">http://census.daybreakgames.com/get/ps2/chara...tion&c:limit=10[/url]) you are resolving the world collection, which seems to place world_id into the base character object.   As this is part of the resolved data, it cannot be searched upon. 

As a general rule, if the data does not show unless you resolve it, then you cannot use it to filter the data.  When I get in that situation, I try to filter the base data as best as possible with other parameters and then manually filter the results after I receive them.  Not the best of solutions, but it works.