SRD 3.5 XML and MySQL Database

[andargor]

MySQL and XML data from the D&D 3.5 SRD, with full text. Includes Epic and Psionic data with the XPH errata.

This was extracted directly from the RSRD, and is what I used to do my stuff.

Currently included:

* Classes
* Feats
* Monsters
* Powers
* Skills
* Spells

http://www.andargor.com/

There is no pretense at a "good" XML format, it is mainly a flat format suitable for databases. But it makes parsing easier. Some fields actually have HTML in them, but it's well-formed XML as well.

Enjoy!

Andargor

 

[The_lurkeR]

Just wanted to say thanks for the great work!

 

[mojo1701]

Just wanted to say thanks for the great work!

Ditto.

 

[Astos]

Once again, thanks kindly for sharing your work, Andargor.

Do you plan to add equipment or magic items? Those're the only things missing to be able to construct a very clickable character sheet web page.

You've done a lot to make all your databases. Do you have any projects that you use them in? I've always wanted to create some big dynamic web-thing with them but I use them a lot for ad-hoc querying on spells and monsters.

 

[andargor]

Once again, thanks kindly for sharing your work, Andargor.

Do you plan to add equipment or magic items? Those're the only things missing to be able to construct a very clickable character sheet web page.

You've done a lot to make all your databases. Do you have any projects that you use them in? I've always wanted to create some big dynamic web-thing with them but I use them a lot for ad-hoc querying on spells and monsters.

Yes, I was considering what to do with equipment and items. I can put the stock items readily enough, but all the building blocks for magic items are a bit daunting since they each follow their own rules. They'd require a whole slew of tables.

I was perhaps thinking of simply dumping all the tables in the SRD into individual small tables. Still thinking about it.

Yes, I do have projects for an XML based character generator. Once I get all the data extracted, I will break down the XML further into useable data. This "medium resolution" extract is database friendly, whereas XML is not, and is a stepping stone.

Andargor

 

[barsoomcore]

Andragor, that's AMAZING. This is incredibly useful.

I'm going to have HOURS of fruitless programming ahead of me. It's free entertainment!

Seriously, this is a major contribution to our community. Thank you so much.

 

[andargor]

Version 1.1 released, with Equipment and Items

Do you plan to add equipment or magic items? Those're the only things missing to be able to construct a very clickable character sheet web page.

You want equipment and items? You got equipment and items!

Version 1.1 has basic equipment and magic, psionic and epic items, including artifacts.

Note that scrolls, potions and wands don't have caster levels included, as the SRD pricing is... off sometimes, and it's hard to reverse-engineer the CL. But using the normal formulas, you can reconstitute them easily enough.

And you are all very welcome! It's my pleasure to provide you the means to waste many hours!

Andargor

 

[barsoomcore]

Helpful hint: none of the <stat_block> elements in the "monster.xml" file in "srd35-db-v1.1" contain any Initiative bonuses.

 

[andargor]

Helpful hint: none of the <stat_block> elements in the "monster.xml" file in "srd35-db-v1.1" contain any Initiative bonuses.

Riiight.

The stat blocks are experimental for now, I admit. Some with a lot of "and" and "or" combinations in the Full Attack entry don't come out right.

I'm still toying with different formats right now. I'll look at it for the next update, there are some other problems I'd like to fix, like short descriptions for all the seplls and powers (well, those that have one), and a stray anchor tag in the full_text field.

Andargor

 

[barsoomcore]

I'm working on automating the addition of Initiative bonuses to the <stat_block> elements; do you want me to send a file containing them when I'm done?