Gaming Zone > Unreal Tournament 2004

Let's talk about PPR! PPR Changes on Freon 1

<< < (2/7) > >>

Piglet:
Hi Jozz,

The back end code appears to select the average of the last 20 maps in which you played for at least one round:

SELECT AVG('score'/'rounds') AS ppr FROM (SELECT 'score','rounds' FROM gamestats WHERE server_id=us AND player_id=you AND rounds>0 ORDER BY timestamp DESC LIMIT 20 AS t1");

That "rounds > 0" looks bad to me. If you just joined for a very short time at the end of the round and then left when the next round started it would give a low number

I might increase that number of rounds to include only when you've played more rounds....perhaps 3 or 4? More?

Edit: let's try with 4 or more rounds needed to count towards average PPR

Jozz:
Excellent, I knew there was something fishy there, that will fix a lot!
 Kops will have a higher PPR in future for instance  :D

kops:
I get scared if my ppr >3

nyrde:
If the distrubution of the appr over different maps is not normally distributed the median value could result in better results... It would "remove" extremeties from both the low and high end of ppr.

Piglet:
Are you any good with stats?

Here's an extract of score, number of rounds, and player ID across every recorded entry where the player has played at least 4 rounds:

https://hax.miasma.rocks/data.csv

If you can work out a better indicative PPR method than averaging the last 20, please let me know.

..and yes, we've had a 45 round game of freon....

Navigation

[0] Message Index

[#] Next page

[*] Previous page