I have a tight work schedule and I don't want to program more after that most the time but I am very experienced in web development.
Looking at FFXIDB though, I'm not sure how much help I would be, probably mostly the unix server and sql. I know I can't commit much time but I can at least help answer questions or debug the server if it's having problems.
I see a lot of potential with ffxidb. If managed right it could be the go to resource over wiki's. Wiki's are great in that getting content in is easy, but they have tons of pitfalls (namely that any change has to be done by hand as well).
That leaves two problems for ffxidb:
getting data in and showing it in meaningful ways.
To get data in, we could crowdsource by giving a form page for input. Another option is mass doing it by hand. Both are prone to errors.
Option B and perhaps supplemental would be bots, whether web bots scraping existing sites (though that may anger people who run those sites so maybe not do that without permission), and do just make things to go over dat files and put them in making unique fields for every type of buff and stat finally allowing a site that you can search, sort, filter by job, and any other stat you want for to find the best gear for slot for action easily for example. Obviously just the effects one would be full of tons of unique fields. You could structure it with 3 tables:
One for items, containing the item name, item number, and anything else unique to all items.
One for attributes, which would include a field for type and another for amount. (STR of Blood Pact Ability Delay or any other effect from enchantments to costume to any other text put on the item).
One for combining the item id, with the attribute id and if applicable give the amount of the attribute. Example:
Generic Dagger with an item id of say 10 has +1 agility
this would generate the following:
name: Generic Dagger
notes: Increases AGI (could give mechanics here or even just have another table for letting attributes be commented on. in that case we might go with a more drupal like system where everything is a node and give node ids to everything allowing them to be commented on).
Item Attributes Table:
Anyway, I set up lots of custom dbs before and a setup like that you could write a very powerful search engine over the top of it, and make every single attribute on the view screen clickable, and be a filter on a power search. Since there would be thousands of attributes you'd probably want to have an autocomplete function instead of a dropdown or multi select.
Now I'm just rambling but I always wondered why there wasn't such a strong database like that built for ffxi. I guess the prospect of entering in what like 50,000 items by hand that way would be a chore... and no one ever made a bot to do that over the DAT files or something. Not sure how it'd even be done... possibly OCR if there's no text equivalents.
The last piece after that was in place... would be to get community content on it. Like you go to the wiki's because they have things like testimonials, who it drops from, how hard it was or even just like "man i spent forever getting Maat's cap and it was worth it even tho it's obsolete now!" stuff like that you know... a db site devoid of user comments and user submitted info would be incomplete. So you'd need the whole 9 yards. The hard part would be without scraping wiki's or other sites... it'd take years to accumulate that.
There still would be room however to make things like chrome/firefox plugins that would allow players to use them on bg-wiki and ffxiclopedia and ffxiah that would pull the items from ffxidb and give you links or just fills of info to accentuate their sites. Even just a greasemonkey script if we set up a web api.
The thing is... all that work I just outlined would probably take me like 500 hours. And I don't have near that kind of time. But leaving this in case anyone sees what could be done with ffxidb is pretty great. Wiki's are fine and all but they aren't very powerful if you wish to make reports or have search tools.
I had one more idea too. Figuring out the mechanics of this game is very hard without data and making models based on that data. If we could make a plugin for windower that would let people opt in to share their data it'd be golden. The thing is... that data would have to be complete or it'd be worthless meaning it has to account for the food used, the items used, the job, the race, the subjob, the buffs, the monster, any debuffs on the monster... and as such you'd have to make sure people can only use it if all logs are displayed... or if you just go to the packet level and make sure that you get all the info and parse it out. that too would be like a 300+ hour job. I just think the number of people with time and skills to make stuff like this happen is limited.
I must end with a compliment, you guys do a great great job with all of this and I'm very pleasantly surprised by your ability and acumen. Good job!
Edit 2: sorry for the rant it could be edited much better, my brain can think faster than my fingers keep up and I didn't want to miss anything.