SRD 3.5 XML and MySQL Database

[barsoomcore]

http://barsoom.hyboria.net/monsters-plus-stat-blocks.zip

Knock yourself out. Should be accurate, but you never know...

 

[andargor]

http://barsoom.hyboria.net/monsters-plus-stat-blocks.zip

Knock yourself out. Should be accurate, but you never know...

Hey, thanks. But what I do is auto-generate the stat blocks from data directly extracted from the SRD. There are some other problems I have to fix, like this entry from the Anaxim:

Atk +43) or electricity ray +35 ranged touch (2d6+12/19-20 (plus 1d6 on critical, spinning blade);

So I change my tool once, and everything else follows I'll have Init fixed at that time too.

Andargor

 

[barsoomcore]

Right. You're all about the tools, I'm all about the data.

I look forward to your updated files.

 

[Chaz]

Good stuff.


Peace

 

[WarRabbit]

Phew! Thanks for the time saver....I was just beginning a project to put all the feats and spells into an Access database and here you went and did all the work and more for me!

 

[andargor]

How does this look for a stat blocks?

Anaxim; CR 22; Medium construct (extraplanar, lawful); HD 38d10; hp 420; Init +7 (Dex); Spd 60 ft., fly 200 ft. (perfect); AC 37 (+7 dex, +20 natural); Base Atk +28; Grp +40; Atk +43 melee (2d6+12/19-20 [plus 1d6 on critical], spinning blade) or +35 ranged touch (electricity ray); Full Atk +43 melee (2d6+12/19-20 [plus 1d6 on critical], 2 spinning blades) and +35 melee (2d6+6, 2 slams) and +35 melee (2d6+6, shocking touch) or +35 ranged touch (10d6 electricity, electricity ray) and +30 ranged (2d6+12, 120 ft. range increment, 6 spikes); Space/Reach 5 ft./5 ft.; SA Rend 4d6+18, sonic blast, spell-like abilities, summon iron golem; SQ Abomination traits, magic immunity, construct traits, fast healing 15, spell resistance 34, damage reduction 10/chaotic and epic and adamantine; AL LN; SV Fort +12, Ref +19, Will +17; Str 35, Dex 25, Con -, Int 10, Wis 20, Cha 20

Skills and Feats: Climb +53, Jump +65; Blind-Fight, Cleave, Devastating Critical (blade), Epic Toughness, Epic Weapon Focus (blade), Great Cleave, Improved Bull Rush, Improved Critical (blade), Improved Initiative, Improved Sunder, Overwhelming Critical (blade), Power Attack, Weapon Focus (blade)

Great wyrm prismatic dragon; CR 66; Colossal+ dragon (light); HD 78d12+2,106; hp 2,613; Init +4; Spd 60 ft., fly 350 ft. (clumsy); AC 106 (-8 size, +27 deflection, +77 natural), touch 29, flat-footed 106; Base Atk +78; Grp +125; Atk +102 melee (8d6+31/19-20, bite); Full Atk +102 melee (8d6+31/19-20, bite) and +102 melee (4d8+15/19-20, 2 claws) and +101 melee (4d6+15/19-20, 2 wings) and +102 melee (4d8+46, tail slap); Space/Reach 30 ft./20 ft. (30 ft. with bite); SA Breath weapon (80 ft. prismatic spray effect, DC 76), crush 8d6+46 (DC 76), frightful presence (DC 76), tail sweep 4d6+46 (DC 76); SQ Blindsense 60 ft., damage reduction 25/epic, darkvision 120 ft., immunity to sleep and paralysis, keen senses, prismatic sphere, prismatic wall, rainbow pattern, spell resistance 86, spells (caster level 38th), sunbeam, sunburst; AL N; SV Fort +68, Ref +41, Will +68; Str 73, Dex 10, Con 65, Int 64, Wis 65, Cha 64

Skills and Feats: Appraise +68, Bluff +68, Concentration +108, Craft (alchemy) +68, Diplomacy +108, Disable Device +68, Escape Artist +81, Gather Information +68, Heal +68, Hide +25, Intimidate +108, Jump +72, Knowledge (all) +108, Listen +110, Move Silently +41, Open Lock +41, Search +108, Sense Motive +108, Spellcraft +68, Spot +110, Survival +68, Tumble +41, Use Magic Device +108 (149 skill points remaining); Alertness, Blind-Fight, Cleave, Combat Reflexes, Empower Spell, Flyby Attack, Great Cleave, Hover, Improved Critical (bite), Improved Critical (claws), Improved Critical (wings), Improved Initiative, Improved Spell Capacity (x4), Improved Sunder, Maximize Spell, Power Attack, Snatch, Spell Knowledge (x3), Weapon Focus (bite), Weapon Focus (claw), Weapon Focus (tail slap), Wingover

Should I include SA/SQ descriptions at the end as well?

Andargor

 

[Vascant]

Let me say, "Full Attack" in the stat block was interesting to code.

I know I used your spell data to pull from and combined with 2 other tables to create the master table I use for spells in my NPC Gen. I checked out the rest of the data and though it might be useful for a kind of "Help Desk" feature, nothing else is usable.


In my NPC Gen, when I first started playing with it a few months ago. I coded a function that extracts the data of your monster.xml into a class and then fires off the stat block builder in the scripting functionality of the application. I have sense build from that frame work with NPCs, all of the data eventually feeds into this same class. *chuckles* Granted now how I usually start building applications but this one has become more into extending the functionality upon itself kind of thing. I think my end hope is to be able to take Monster's as they are push into this class and eventually be able to create a script from it that would allow for the monster to be used as a base race for adding classes too. Then would be able to take a dragon and add sorcerer class to it almost automatically with minimal human interaction.

 

[andargor]

Let me say, "Full Attack" in the stat block was interesting to code.

I know I used your spell data to pull from and combined with 2 other tables to create the master table I use for spells in my NPC Gen. I checked out the rest of the data and though it might be useful for a kind of "Help Desk" feature, nothing else is usable.

Interesting comments, although I admit I don't quite understand what you are saying.

Is there something you'd like to see?

I know the data is not "program friendly" yet, since it's not broken down. But as I've already mentionned I will do that eventually and this is just a first step so that at least it's more easily parsable. Some people have started using it for "shake and bake" web-based reference tools, and it's probably what it's good for at this point.

Andargor

 

[Vascant]

I know the data is not "program friendly" yet, since it's not broken down. But as I've already mentionned I will do that eventually and this is just a first step so that at least it's more easily parsable. Some people have started using it for "shake and bake" web-based reference tools, and it's probably what it's good for at this point.

Andargor

The data I added from other tables deal with such things like availability of a spell and also the type of spell it is, attack, defense, misc and such.

When I started this, I had no idea where you are heading with the data. So I just went with what you did have and created more "Program friendly" data to fit my needs. The monster xml I have not touched much, I think if anything I added consistancy to some of the elements. For what I am doing, I have not answered if XML is the better choice for how my data is to be handled.

 

[barsoomcore]

Should I include SA/SQ descriptions at the end as well?

I say no. The information's in the XML already, no?

There's a lot of "format-y" html code inside the xml that should probably get revisited. There's lots of divs and stuff -- I'd like to see most of that pulled out and rawer html provided.

At least I think that's what I want. I'm at work right now and can't review the xml doc so let me get home, have a look and see.