VGChartz Playstation Trophy League

[Esquoret]

ghettoglamour said:

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.

Ah, I see. Great that you're able to identify the issue. Thanks for all the work! =)