Roster missmatch API issue...

Posted this in the PS2 forums and haven't received any help so I thought I'd try here...

Looking for the SOE API master here that can help me with this issue. I have a list of players that show up on the API but not on the actual in game roster. I would like these players removed from my API roster if at all possible.

Outfit: The Forty Deuce
Server: Connery
Players showing on API but are not really in the outfit:
BhigD36
Channing
CrossdressingPRV
Jax123
Jigsaw717
KurosawaSP
roych
Tonsixers
VilyanKVere

If a forum mod could forward my issue to someone that could help with this I would really appreciate it.

 

Please post the URL or URLs where this data is appearing. Or e-mail data-feedback (at) soe.sony.com.

 

Well any API site that displays our roster should show it but here you go:
http://www.planetside-universe.com/outfit-37509488620608321.php?tab=members
http://outfitpoints.com/OutfitDetails/OutfitByID?outfitId=37509488620608321

These players haven't been in the outfit for a very long time(or at least showed up on the roster).

 

So are those characters that quit the game, or left the outfit for another outfit?

In EQ2, characters are listed in the last guild they were in the last time they logged in. So if someone quits the game, they will be shown in a certain guild forever even if they have long since been removed from the guild. It's kind of a problem.

 

Feldon is correct; it appears that members are staying in outfits, even if they have deleted their accounts. Here is an example from the Players site: https://players-stage.planetside2.com/#!/outfits/?outfit=37509488620608321
This is a known issue with the way the game manages outfit members.

 

It would be great on both the EQ2 and PS2 sides to see a monthly cleanup of some sort.

 

Yes please!!!!! Especially for PS2 where API stat gathering fan sites rank outfits on their averages. I have 9 players lowering my averages and they are not even in the outfit. I'm buying a drink at SOE Live to whomever can remedy this!

Louey

 

Also I just noticed the other day I have players on my in game roster that don't show up on the API roster.

 

Any updates on this getting fixed? As the list grows the stats that the fan sites pull for my outfit become more and more inaccurate.

Louey

 

I've emailed the game devs begging for a bug fix and some cleanup. I've also got some census voodoo that might help you in the meantime. The c:join command is new and powerful...it gives the ability to basically do a join (or inner join) against another collection. The url below will join the outfit_member collection to the character collection. The outer:0 at the end tells the system to do an inner join i.e. remove any outfit member rows that don't have a corresponding character row. So it filters out any deleted characters! It is more db queries and processing than a simple query to outfit member, but in the mean time it might solve your issue

http://census.daybreakgames.com/get/ps2/outfi...limit=5000&c:join=character^show:name^outer:0

 

Seems like sites like PSU and Outfitpoints have it all figured out. They use the new API and my rosters match now.