By using this site, you agree to our Privacy Policy and our Terms of Use. Close

Forums - Sony Discussion - VGChartz Playstation Trophy League

veritaz said:
Thanks for the update Arc. Got 5 plats in 1 week. I need to slow down since I'm actually running out of games to play.

you could always go for games that take longer to play for each trophy, give some other people a chance to be the busiest member for a week :P



Around the Network
Wonktonodi said:
veritaz said:
Thanks for the update Arc. Got 5 plats in 1 week. I need to slow down since I'm actually running out of games to play.

you could always go for games that take longer to play for each trophy, give some other people a chance to be the busiest member for a week :P

I got new shows to watch and gonna try to platinum Just cause 3 I guess. It's a 90+ platinum so that should be enough for a while lol.



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?



My website: Precocious Ragamuffin

Arcturus said:

Looks like I have to post each table in a separate post. If I try to post all tables in a single post VGChartz throws a Fatal SQL error. Not sure what's causing this.

I might try converting each table to a graphic file so that the formatting of the tables comes through better.

Looks good, Arc, I'm glad everything works fine!

Probably the post exceeds the maximum size on the database. Are you still using colored tables on Excel?Try to format them as simple as possible, since the forum won't format it correctly anyway.

Also, the cells are the size the forum wants, so I guess a bigger font would still fit, wanna try raising it a bit?



Game of the year 2017 so far:

5. Resident Evil VII
4. Mario Kart 8 Deluxe
3. Uncharted: The Lost Legacy
2. Horizon Zero Dawn
1. Super Mario Odyssey

Esquoret said:
Wow, just realised that for the Platinum Leaderboard, the system is now:
- Common (1 point)
- Uncommon (2 points)
- Rare (3 points)
- Super (4 points)
- Ultra (5 points)

That's cool, you don't have to manually assign their value anymore. Does that mean that sometimes a plat will also change its value as the rarity changes?

Yes, everything in the league is dynamic. When a member earns a new trophy, the game it belongs to will be updated. The rarity of its trophies will be refreshed and DLC trophies might be added, which might affect the platinum leaderboard and the completion %.

Games with no earned trophies will be automatically refreshed 30 days after the last update.



Game of the year 2017 so far:

5. Resident Evil VII
4. Mario Kart 8 Deluxe
3. Uncharted: The Lost Legacy
2. Horizon Zero Dawn
1. Super Mario Odyssey

Around the Network
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.



Game of the year 2017 so far:

5. Resident Evil VII
4. Mario Kart 8 Deluxe
3. Uncharted: The Lost Legacy
2. Horizon Zero Dawn
1. Super Mario Odyssey

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! =)



My website: Precocious Ragamuffin

Thx for update!



 

Dammit guys, I only have 5 platinums!



Wright said:

Dammit guys, I only have 5 platinums!

Well you don't really have time to waste anyways since Guts is coming for you.