[Community] SGRStats.com - Player rankings, achievements and more!

I found a bug with the ranking: When you sort after play time, it sorts after the first digit. For example, 9 hours shows before 80 hours.

Originally Posted by The Lantean Wraith

I found a bug with the ranking: When you sort after play time, it sorts after the first digit. For example, 9 hours shows before 80 hours.

Known issue, I badgered him on IRC regarding that.

Fixed.

Player rankings update

Just a quick note that a new update was pushed online, which makes player rankins a lot more useful and easy to use (also, the "sort by time played" bug which was reported on the Stargate Worlds forum is now fixed).



So don't hesitate and go play with the new goodies (nickname filter, pagination and more) on the player rankins page.

P.S.: Player position aka "rank" is linked to experience points (EXP) value and it does not change when you apply different sorting options (for example, if players rank is #1, it will stay #1, no matter what sorting option or combination of them you use).

http://www.sgrstats.com/news/player-rankings-update/

small bug, since 2.7.3, the ranking isn't refreshing properly, it doesn't update the experience.

Are you sure that is the case?

Because the rankings are updated daily, but the data which you see on the stats page is basically always fresh (only cached for 15 minutes), because it's fetched on demand.

Edit: I've just checked it and in fact, the data is updated correctly (but only once per day - check the bottom of the page to see when the data was last updated).

Thank you for your comment anyway, it's better to over-report then under-report

Thanks for checking

Last night when I stop playing I thought it could take some times to update, but this morning nothing moved, started to freak out not seeing me in the top 10 again lol (yeah, I might be a bit too competitive

Oh an other matter.
How the **** the experience is calculated?! I haven't play as much as some people but I still have quite a good amount of it. Anyone?

Edit: that "profanity" filter is a pain in the .... can it be removed?! you want to say "H ello" to someone, what is wrong with "h ell"? we accept heaven but not its counterpart... that is wrong, very wrong, especially since we have a game with gods in it

Edit: that "profanity" filter is a pain in the .... can it be removed?! you want to say "H ello" to someone, what is wrong with "h ell"? we accept heaven but not its counterpart... that is wrong, very wrong, especially since we have a game with gods in it

!WORD

The xp is calculated by your points u earned ingame killing ppl and capturing interactive points.

Im wondering why delievering the flag on CTF (Piramess) do not give points?!

Originally Posted by B.l.a.c.k.

!WORD

The xp is calculated by your points u earned ingame killing ppl and capturing interactive points.

Im wondering why delievering the flag on CTF (Piramess) do not give points?!

I wonder the same thing,

Kami I have a suggestion. You should allow a feature to group individuals together with their respective clans. So that way you can view how the individuals in your clan rank, and then maybe how your clan ranks against other clans.

Hmm, so this list would be then "connected" to the rankings page?

For example, you would visit the special page, where all the players with a linked account which are shown on the rankings page are listed and you could create a list of players which you want to track?

If yes, then something like this is possible and I will add it to my to-do list.

My to-do list is currently already very long (I kinda close a few tasks every day / week, but open a dozen of new ones ).

Though I can't promise when this will be available, since I'm currently working on the "global" stats (top classes, maps, etc.) features which are quite hard to implement since the API really was not mean to be used this way and it requires a lot of "ugly" code and hacks on my side.

Originally Posted by KamiSLO

Hmm, so this list would be then "connected" to the rankings page?

For example, you would visit the special page, where all the players with a linked account which are shown on the rankings page are listed and you could create a list of players which you want to track?

If yes, then something like this is possible and I will add it to my to-do list.

My to-do list is currently already very long (I kinda close a few tasks every day / week, but open a dozen of new ones ).

Though I can't promise when this will be available, since I'm currently working on the "global" stats (top classes, maps, etc.) features which are quite hard to implement since the API really was not mean to be used this way and it requires a lot of "ugly" code and hacks on my side.

yeah that was the basic idea of what i had, and i hope to see it sometime!

I really like the idea of within clan ranking! Also, is it possible to post amount healed by goa'uld and scientist?

Originally Posted by KamiSLO

Hmm, so this list would be then "connected" to the rankings page?

For example, you would visit the special page, where all the players with a linked account which are shown on the rankings page are listed and you could create a list of players which you want to track?

If yes, then something like this is possible and I will add it to my to-do list.

My to-do list is currently already very long (I kinda close a few tasks every day / week, but open a dozen of new ones ).

Though I can't promise when this will be available, since I'm currently working on the "global" stats (top classes, maps, etc.) features which are quite hard to implement since the API really was not mean to be used this way and it requires a lot of "ugly" code and hacks on my side.

I suspect you are using an SQL database in the background.

If that's the case the easiest thing for the time being would be to add to each user one more row, for the clan. The add to the rankings page show only clan members.
Then all that remains is to pull his clan value and run a query for all users with the same clan value.
Something like this would be probably doable in about an hour (if you are quick even less. )

Originally Posted by magecu

I suspect you are using an SQL database in the background.

No SQL databases just XML parsing.

Originally Posted by magecu

I suspect you are using an SQL database in the background.

If that's the case the easiest thing for the time being would be to add to each user one more row, for the clan. The add to the rankings page show only clan members.
Then all that remains is to pull his clan value and run a query for all users with the same clan value.
Something like this would be probably doable in about an hour (if you are quick even less. )

Most of the stuff sounds simple on paper, but in reality it almost always takes 10x the time and effort

P.S. For the player stats and all the related data, it I use a no-sql (document oriented to be exact) database which is a almost a perfect solution for this kind of data set and problem.

I do use a relational database for other website features like news, articles, etc.

A quick note - top classes page is now available.

I pretty much expected that the first two classes by number of kills will be Ashrak and Scientist, but I wasn't sure about the actual order.

Also it's pretty interesting to see that Jaffa and Soldier and pretty close and not far behind from the Scientist.

In the following week you can also expect a top map and weapon page.

Now we have at least have some kind of proof that Ashrak is overpowered!

P.S. I'm joking so please don't flame me

Cool...but...

how does Jaffa got 0 Headshots!? And Goa´uld...in time i play Goa´uld i simply often aim for the head to fry it...strange though.

Edit: Same bug detected as in the previous list...if u want to sort e.g. by headshot number 4000 comes before 25000.
Edit 2: This bug actually is only on the "headshots" line...on the other lines it works correctly.

Originally Posted by KamiSLO

Most of the stuff sounds simple on paper, but in reality it almost always takes 10x the time and effort

P.S. For the player stats and all the related data, it I use a no-sql (document oriented to be exact) database which is a almost a perfect solution for this kind of data set and problem.

I do use a relational database for other website features like news, articles, etc.

Yeah in that case I can see it taking a lot longer.
I thought you were using a lamp setup with the database being updated regularly, trough a separate processes. Then again I didn't take any time to check on how things are done for the game nor how your site is setup.

Anyway Slow and steady.
You have done a lot as it is.
The rest is just us being greedy.

Amazing work Kami, we're all rooting for you. I think i would have been higher but two weeks without being able to play kinda killed that.

However like someone said earlier having numbered columns on things other than XP would be very useful and would it be possible to add in k/d and accuracy to the columns? atm all it's really showing is a ranking of who has played the most rather than who is best.

It should be sorted out depending on the KDR or maybe Most Kills/Less Deaths. But carefull that a 10-0 guy with KDR of 10 does not beat a 499 - 200 only cause he got the better KDR depending the minor playtime.

Originally Posted by Deus Viator

Amazing work Kami, we're all rooting for you. I think i would have been higher but two weeks without being able to play kinda killed that.

However like someone said earlier having numbered columns on things other than XP would be very useful and would it be possible to add in k/d and accuracy to the columns? atm all it's really showing is a ranking of who has played the most rather than who is best.

Sounds fair, I'll add the K/D ratio then and make the rank depend on this value.

With "numbered columns" you mean that the rank # would change when you apply different filters?

For example, if you sort the table by the time played, #1 player would be the one with the longest time played and so on?

If yes, then this is possible but it will take some time, but I still havent decided how I should do it.

P.S. Sorting by the multiple columns (holding down shift when selecting the columns) should work as well, but apparently it does not.

I will check it out.

Originally Posted by KamiSLO

With "numbered columns" you mean that the rank # would change when you apply different filters?

For example, if you sort the table by the time played, #1 player would be the one with the longest time played and so on?

If yes, then this is possible but it will take some time, but I still havent decided how I should do it.

Yeah thats the kind of thing. Is it not possible to have to # column independant of the rest of the table. e.g. have the column for the # and then the table next to it so that when you sort the table the # column isn't affected at all. I know very little about these things however but it just seems like a shortcut that would make this easier.

i got to be honest, im not a fan of having the rankings be based on K/D ratio, several of the previous top ten, all of whom i considered to be quite good, have now dropped considerably, look at Dr_Jackson was 4th is now 133rd. Also, there are a few people now ranked quite high who have very a low number of total kills and few hours played. personally i think the overall ranks should be based on multiple stats so that is reflects a players overall performance. example equation for this could be combining the two for: (experience * K/D ratio), then the people who have alot of exp, do really know the game very well, and preform very well are ranked high, maybe even divide this total by hours played, so that players who gain exp faster (by doing well in games you do get more exp, there is also a bonus for winning the match, im working of the exact equation) get ranked a higher. however it is done i think the overall ranking should be based on multiple stats to better indicate overall performance.

And just before anyone starts to say im only complaining because i lost a bunch of ranks with this switch, i was 12th using exp i am now 15th with K/D ratio, im one of the 8 people in the old top 20 who is also in the new top 20, more than half cant say the same, which is very significant, this is indication that neither method is good for an overall ranking.

I would agree with that

-.- me no happy now. i miss being ranked 4th... especially since the player now ranked 2nd is a dude who's only played 27.5 hours, PURELY as a sci. i like Zero's ^ idea... especially since i may be "good" but that's because i've spent TIME getting there, even though i still die a lot. just a little perspective... i'm ranked top TEN in everything except K/D ratio... i think that speaks for itself.
in fact, instead of (exp*kill)/(death*time) it could be simplified to exp/time to get just a baseline of how well they've been playing! whattaya think?
EDIT: just did the math on the exp/time with the time in minutes... i got a "skill number" of 12.333, and -Banana|Black- has one of 18.254. of course, it still needs tweaking, Culgan got 14.553

EDIT: okay, here's a formula that might actually work better... Kill*Time/Death. that way, you get the K/D ratio, but it also depends on how long they've been playin; this way you get skill OVER time, not just starting skill *cough*turrets*cough*

ahh so youre foreverzero nice to meet you. about time you posted