Might have gotten worse...
Did you just run something that updated the trophy counts? I think you only ran a script that counted the # of trophies in the "arcade" group of games. You didn't include the "default", "shooting", "puzzle", "yeti", and "reaction" so I think the totals are off.
Honestly, the problem isn't with the # of high scores/trophies at all. The problem is that somehow we lost all of the scores below the top score. Everyone who has played a game in april has their score saved, and everyone else has "0".
If someone has a high score that was gotten prior to April and someone beats them, that score is lost too.
Is there just 1 scoring table in the system, or is there one table with the high score of each game, and then a secondary child table with all of the scores (including a duplicate of the high score)? If it's 2 tables, I think the second supporting one was likely cleared at some point and has begun building it's data again on or around April 1st... If it's gone, then so be it and we'll just go from there...
Otto
|