Forum BigDB global ranking - finding player position

Discussion and help relating to the PlayerIO database solution, BigDB.

global ranking - finding player position

Postby Pawel Wozniak » December 15th, 2016, 12:23 pm

I have - lets say - 100k player objects. Each contains field "xp". Is it possible to get player position in all ther player context?

Something like sql query: select count(*) ... where XP > myXP
Pawel Wozniak
Paid Member
 
Posts: 96
Joined: October 14th, 2012, 10:47 pm

Re: global ranking - finding player position

Postby Henrik » December 15th, 2016, 5:18 pm

No, this is not possible using BigDB.

From the Yahoo days there's OneScore though: https://playerio.com/documentation/refe ... t.onescore

It never officially launched back then, and it's not really battle-tested, but it should do what you want. Consider it a beta feature.

It's definitely something we intend to get to and refresh and officially launch, we just need to get some more highly anticipated features out through the pipeline first. :-)
Henrik
.IO
 
Posts: 1822
Joined: January 4th, 2010, 1:53 pm

Re: global ranking - finding player position

Postby Pawel Wozniak » December 19th, 2016, 4:34 pm

I`ve just tested OneScore from the server side and:
1) it is weird that onescore is a Room property not a Player
2) percentiles are working as expected and documented but TopRank returns opposite numbers to expected - from a 5 players group, player with highest score (100th percentile) returns 5th position and the one with lowest score returns 1st position.
Pawel Wozniak
Paid Member
 
Posts: 96
Joined: October 14th, 2012, 10:47 pm

Re: global ranking - finding player position

Postby Henrik » December 28th, 2016, 2:29 am

Thanks for your feedback, we'll keep this in mind when we get to refreshing OneScore.

OneScore recalculates every hour or so, did the top ranking change with time, or was it consistently wrong?
Henrik
.IO
 
Posts: 1822
Joined: January 4th, 2010, 1:53 pm

Re: global ranking - finding player position

Postby Pawel Wozniak » January 22nd, 2017, 12:39 am

Looks like it is is consistently wrong.

One thing else I`ve found is that old oneScore records are missing, are they outdated?
Pawel Wozniak
Paid Member
 
Posts: 96
Joined: October 14th, 2012, 10:47 pm

Re: global ranking - finding player position

Postby plyoung » April 11th, 2017, 5:38 pm

it is weird that onescore is a Room property not a Player


This is throwing me off too. Does it mean OneScore is not usable server side yet cause I can see no way how I can load the score of a ssecific player on the server.

I was going to use OneScore to store the player's TrueSkill but if I can't do this server side then it is not really useful. I am not trusting the client with it.

Thanks for your feedback, we'll keep this in mind when we get to refreshing OneScore.


Seems TopRank can't be changed? Could such an option be added?
I assume score lowest is 0?

How about adding support for TrueSkill? :p
plyoung
 
Posts: 4
Joined: April 9th, 2017, 10:04 am


Return to BigDB