Abbi

I suspect this won't be of use to anyone who isn't us, but on the off-chance:

http://www.wildlyinept.org/ci/index.php/membership (demo)
http://www.wildlyinept.org/ci.tar.gz (code)

It's a cheap and easy web app to track who's attuned to what. It uses SMF (Simple Machines Forum) for authentication; if you were a PHP ween, you could hack your own authentication mechanism in, but it'd be a bit of effort. As written, your SMF admins can edit anyone's entry; normal users can only edit their own entry. You can sort on any column by clicking the column name, it has a field for your spec, etc. Should be pretty self-evident how it works.

There's a README inside the tarball. Among other things, it mentions that you need:

* A working SMF installation.
* A MySQL database. It'll work with other databases but may need some changes.
* Understanding of MySQL.
* Understanding of how to edit PHP code.
* Understanding of how to edit HTML (for the templates).

It's a semi-technical install; it will not work for you out of the box, but the tuning is within range of anyone who knows how to create MySQL databases and modify constants in PHP.

The core framework is Code Igniter, which I heartily recommend to anyone doing PHP web apps.

 

Copernicus

I know that a lot of people/guilds used http://battlechicken.org/keys/ to organize their keys. I do like yours more though, because I can customize it for my purposes and keep it hosted and backed up on the guild's website. Thank you for the framework.

There's also this thread here which talked briefly about keying and webapps - http://forums.elitistjerks.com/viewt...p?id=10091&p=1

 

Abbi

I like Battlechicken, but I find it always slows things down when I have to tell everyone "OK, go create another account over there." So I figured, hey, might as well.

And man, I'm a space case. I read that thread but for some reason I remembered it as being over at Fires of Heaven, and I've been looking over there all morning so I could post a pointer. No, the two forums look nothing alike. No, the two forums are completely different in tone. No, I haven't had my coffee.

 

Abbi

Update: I added a distinction between character names and user names, and added some code to color-code names based on SMF member groups. I have not updated the download package; about halfway through I realized I needed to cover some legal stuff in order to redistribute the CI code, and then I wound up wanting to rewrite the README to cover upgrades. Being perfectionist about distributions sucks. I'll finish up the packaging and post again this weekend.

 

Ragnor

On a similar note, does anyone know of an in game mod that lets you track where you are in terms of keying/attunement and what stuff you can do next? I came back from Holiday in Egypt like 1-2 months after the xpac was launched and I'm still catching up.

 

Celandro

It's been awhile since I ran a guild website, and I am no longer associated with the project, but I am very proud to have worked on the wowroster project. It collects all sorts of character information including recipes, keys and has various addons that made it very easy to see who has what recipes and who has what keys. There is authentication and all sorts of useful stuff these days.

I did a quick check and it looks like its still being updated and I would suspect would be the easiest way to track this kind of stuff and anything else in the future.

http://wowprofilers.com/

Sorry if this seems like a plug but I'm pretty sure a lot of people don't know that this exists.

 

Drelegon

We're using the in game comment field and guild information tab for a legend for heroic/instance keys.

In the past we had just first names or 'Alt of <name>' in that field so we had room to add...

'------ (Name)' for no keys or 'HCATSK (Name)' for all keys.

Legend
H = Hellfire Citadel
C = Coilfang
A = Auch
T = Cavern's of Time
S = Sha'tar (Tempest Keep instances)
K = Karazhan

If somebody is keyed for Coilfang and Karazhan their comment would be -C---K (Name). Makes it pretty easy to sort in game by the comment and then you can figure out who you can /w to try and get a group together. As we add SSC and TK we'll just need to add another couple of fields at the end.