Similarly, perhaps you can program, but are not able to program game code (for some reason?)

That's pretty much what I've been doing the last few months. My primary role thus far on In Country has been to bootstrap support assets. The obvious things are help support websites and forums (Harv does the design mind you), setup team tools like file-repositories, bug trackers, version control systems, wikis for documentation, and so on. On this project I'm trying to take all of this one step further though and I've spent a decent amount of time developing customized applications for the explicit purposes of supporting our more art-centric brethren...

One such tool is what I call 'RefTool', short for 'Reference Tool'. RefTool is stab at trying to create a web based mechanism to archive, tag, annotate, and index digital photographic references. On previous projects, alot of the art references usually ended up being a pile of (hopefully well named) jpegs sitting in a common FTP somewhere. Which is decent, but what if I need a few photos of bridges in Vietnam during the Summer of 1966 in a specific province? Who wants to sort through 1000s of images looking for that specific set of bridges? Well I'm sure someone does, but not me!

With RefTool, assuming someone inserted the imagary and tagged it appropriately, you can pull up photography by date, and of course search it's tags and description. The problem of course at this point is ensuring it gets properly populated and that could be another 'unskilled team member' job on a mod team. So, hence the idea for RefTool was born, and the basics were ready for use shortly after, and it's been updated on occasion to fix or add additional functionality since!