Burning Crusade Progress Page Part 2

This entry builds off my previous entry for building a Burning Crusade Progress Page. The first entry covered how to pull the data, this entry will cover the display.

Once the guild import page is created and scheduled to run on some frequency, you can move on to building your display page. The basic idea behind the progress page is that certain levels of reputation with specific factions should give you keys to unlock heroic dungeons and even Karazhan.

Again, we will start out with some variables that can be easily changed to control what is displayed later on.

The heroicFactions variable will be an important part of the code below and with it in a list, it should be easy enough to add to or convert to other languages if needed. There is an additional table needed to accomplish this page. It is a lookup table to provide class names. Here is the schema and data.

CREATE TABLE `wow_roster_classes` (
  `classID` tinyint(3) unsigned NOT NULL default '0',
  `className` varchar(20) NOT NULL default '',
  KEY `classID` (`classID`)
);

INSERT INTO `wow_roster_classes` (`classID`, `className`) VALUES 
(1, 'Warrior'),
(2, 'Paladin'),
(3, 'Hunter'),
(4, 'Rogue'),
(5, 'Priest'),
(7, 'Shaman'),
(8, 'Mage'),
(9, 'Warlock'),
(11, 'Druid');

Next up are the two queries that will be used to show the heroic dungeon progress and Karazhan progress. There is also a support function that will be used to format the reputation.

The key to the heroic query is the faction being one of the factions defined in heroicFactions and having a reputation greater then 21000. When reputation is greater then 21000, the character is Revered with the faction which opens up the option to buy the heroic dungeon key from the faction's quartermaster. This is the best method as the armory data does not list inventory so there is no way to just find out who has the key in their inventory. For the Karazhan query, the focus is on The Violet Eye reputation and the reputation being greater then 1850 which is how much reputation should be gained by time the key fragment quest has been completed. Now that we have our data sets, lets get to the display.

The heroic keyable characters uses a Query of Queries in the loop to pull a specific faction one by one and display the characters. I used some simple display tags but it could always be spruced up with an ordered list or table. The Karazhan Keyed characters just uses the queryTheVioletEye created earlier for the display. Notice the use of the FormatReputation function for displaying the reputation in a more user friendly format.

With that, you now have a Burning Crusade progress page that can be used to find guild mates to attempt the heroic dungeons and for raid leaders to find out who is keyed and ready to start Karazhan. Have fun.