Raid Meta - check raid meta achievements

85 Goblin Rogue
5890
http://raidmeta.com

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
Reply Quote
100 Night Elf Hunter
14275
06/08/2012 10:07 AMPosted by Madsushi
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


many sites have the images that you can download and use on your site ... example
http://www.wowroster.net/downloads/?id=4
tho these are only for what is live on servers now ..
http://www.wowinterface.com/downloads/info17710-CleanIcons-Original.html#other
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 ...
Reply Quote
85 Goblin Rogue
5890
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.
Reply Quote
100 Night Elf Hunter
14275
yea its bogging you down...
http://beta.wowroster.net/index.php?p=guild-raid&a=g:3 same basic idea but its 1.4 sec to load all data
Reply Quote

Please report any Code of Conduct violations, including:

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.

Forums Code of Conduct

Report Post # written by

Reason
Explain (256 characters max)

Reported!

[Close]