VGChartz Playstation Trophy League

[ghettoglamour]

Arcturus said:

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.

- can your app easily be scaled to track over 100 users?

I would create a new app from scratch. Of course, I already have the code to retreive the trophy data from psnprofiles and I'll be able to recycle a lot of code and sql scripts for stats too. So let that be my worry, I'd develop it with pleasure. As I said, you'll only have to insert new users and new plat difficulties.

I can make a script to insert all the current users and if you have one list of all your plat difficulties I can insert those too before you start.

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

It depends on what you need. Exporting a list to excel that looks like the ones you post here is pretty easy. You'll only need to select the type of list and push one button to export

- how do you get around the CAPTCHA on psnprofiles? I can see this being an issue when updating the trophy stats for 100+ users

Hm, my app wouldn't cause an update on psnprofiles for each account. It just opens the psnprofile page of every user, for example http://psnprofiles.com/GhettoGlamour, and collects all the data from there (HTML source code). As far as I know, as long as the user doesn't make his trophies private, psnprofiles updates every account daily.

If psnprofile doesn't know a certain user, I think everybody can create a profile of that account (I've tried it out with two guys from our league, sorry for that)

You - or me - would have to do add those manually on psnprofiles.

- what sort of enchancements would you make to this thread if your application was used?

Look at the kinda stats I have. I could add some interesting columns to the leaderboards, like % of completion, % platinumed, % of days with earned trophies, etc.

Another thing I'd like would be a "hot games" list where you post which games have been played most per week/month/year/all time, showing how many users, trophies, points, plats,etc. they got in our league.

Another interesting stat would be how many  trophies, points, plats, etc. the whole league gets weekly/monthly/ etc. globally. I could create any list you'd like. What and how often do you wanna post any of these is up to you, of course. Maybe we could start some global challenges like: "let's get 50 plats till end of month"

Maybe you wanna PM me your skype ID so we can talk more comfortably.