Fyi, I started a Wiki page a few months back that has some info about the structure of the spells_us.txt file
here. The OpenSpell.xml file from
OpenSpell sheds a lot of light as to what fields mean what, even though it is a little out of date. I just did a little cleaning up on it to make it a little easier to read. I would encourage you to contribute any additional findings, so that way we (as a community) don't have to keep reinventing the wheel
I was personally working on a PHP-based spell viewer/possible editor, but because it involves so much, I put it on the back burner. I did however create a PHP script to parse the spells_us.txt file, and insert it into a database table. This at least allows me to get some of the more basic information from the database, like the spell name. The only downside is it required quite a bit of memory to do (somewhere between 128 & 256 MB of memory for the 4.55 MB file) and about 3-5 minutes. Then again, this was also on a pretty low-end server
