VGChartz Playstation Trophy League

[Arcturus]

ghettoglamour said:

Hey Arc. Last year I remember you said that updating the league takes you up to 3 hours weekly.

Is that still so? Because I made a "little" (it's actually pretty big) windows app, which updates my trophies and creates juicy stats of them automatically, from the HTML source of psnprofiles.com.

If you're interested, I could develop a windows app for you which creates all the stats and lists you need for this trophy league - we could also expand it with other stats, graphs and shit.

You would need to insert the users and the plat's difficulties manually, the rest would update automatically- as long as the users don't disable showing off their trophies on public.

You would also need to install some free software (SQL Server Express) and follow some instructions to install and update the app, but we could work that out.

Also, I could take over the thread if you want and update - and enhance it - with my method.

What do you (and the other guys) think?

Pics of my app will follow...

Wow, this is really interesting! And I have so many questions. But first, to answer your question:

Yes, I think it was a little over a year ago when I said it was taking upwards of 3 hours to update the league each week. This was back when collecting everyone's trophy data was done manually. I've since created a basic script to collect and organize everyone's trophy data automatically. However, some parts of the weekly update still require some manual work. The most time consuming part of the update is determining which new platinum trophies have been earned. I have to manually go through people's profiles on psnprofiles and locate the new platinum trophy. If this is the first time this platinum trophy has been earned, then I have to manually look up the difficulty of it from playstationtrophies.org.

As for my questions:
- can your app easily be scaled to track over 100 users?
- how easy would it be to create custom 'reports' from this app and data? (e.g. creating the platinum leaderboard, session leaderboard, busiest member, etc)
- how do you get around the CAPTCHA on psnprofiles? I can see this being an issue when updating the trophy stats for 100+ users
- what sort of enchancements would you make to this thread if your application was used?

Looks really interesting! Thanks.