Esquoret said: Okay, there's something off about the Platinum Leaderboard. The total plat count column doesn't equal to the sum of the individual common, uncommon, rare, super, ultra columns. For example, it says I have a total of 166 plats. But in the other columns, I got: - Common ~ 32 - Uncommon ~ 73 - Rare ~ 39 - Super ~ 18 - Ultra ~ 6 32 + 73 + 39 + 18 + 6 = 168 (not 166 as it should be at the time of update). I've tried adding the top 5 people on the board, and the same error occurs... I think it's always 2 more than the plat count for some reason. (E.g. HideoK's: 28 + 79 + 45 + 16 + 1 = 169 ... But it should be 167.) Strange. I wonder what's up with that?
|
Lol, we could use a tester as thorough as you in our company! Very good call!
The function BETWEEN, which I use in the SQL Query to determine the category of rarity gets all values within a range, including the ones where I make the cut. So If I have, for example, a 10.00% plat, like The Last of Us and LittleBigPlanet 2 to be very specific, it will be counted as both Rare and Super.
If I use > and <= instead, it works perfectly. Thanks for finding this odd error!
@Arc, this will be fixed in the next version.