Get the Desktop App for Battle.net Now
- All your games in 1 place
- Log in once
- Automatic game updates
Since I started leading a raid, I have been making spreadsheets to keep track of which players have which achievements towards the raid meta achievement ("Glory of the x") and I got tired of making them. I have spent the past few weeks learning PHP/MySQL and browsing these great forums for ideas, and the beta version of the site is finally ready.
I am gathering guild name, region, realm name, and toon name information from users, and then performing API queries on those toons. I store all of the data in MySQL, then I compare the known achievement values (like 6175 = Holding Hands) with the toon's JSON API data to figure out who has what achievements. The resultant info is then displayed in an easy-to-read chart and cached for further usage (and can be refreshed by the user).
The biggest problem with the site is the raw amount of work it takes to gather the icon images for each achievement, which is why only Dragon Soul has images and the other raid metas are text (for now). I already have all of the Pandaria raid meta info programmed in as well, in preparation for MoP's release.
Let me know if you have any questions on how anything is done, comments, or feedback (positive or negative). Thanks for looking!
P.S. - All of my guilds/groups are on Azgalor-US if you want to browse a guild without programming one in yourself.
Edited by Madsushi on 6/8/2012 10:08 AM PDT
many sites have the images that you can download and use on your site ... example
tho these are only for what is live on servers now ..
he has icons for 5.0.1
thus making your life easyer..
some astetic changes you may wana consider...
have a dropdown for each "meta' raid at the top so visiters dont have to use the back button
maybe even have the ability to select other guilds on the same server
just some sugestions tho its an interesting use for watching raid progress but seems really slugish for the amount of data thats loaded ...
Thanks for the tips on the images, I am sorting through them now.
A drop-down on the results page is a good idea, shouldn't be too difficult to implement. I'll see about adding that.
I agree that it's slow, I did some in-depth testing today and it looks like it's how I'm doing the achievement checks that is slowing me down (700-800ms to check ~10 characters). I am working on a way to skip all of that.
Threats of violence. We take these seriously and will alert the proper authorities.
Posts containing personal information about other players. This includes physical addresses, e-mail addresses, phone numbers, and inappropriate photos and/or videos.
Harassing or discriminatory language. This will not be tolerated.