[3.5] SRD Spell & Monster Data in MySQL and pseudo-XML format

[Gilwen]

Um, do you have a different copy of the D20SRD(3.5)? I just took a look, and i don't see any of the data you just said you're adding (there is, as Cyberknight says, simply no base attack/grapple entry for the xorn, frex). So, either you're using the rules to extrapolate the numbers from what *is* in the D20SRD (in which case, it's perfectly legal OGC--but it'd still be nice to have it flagged--and you've then created a new work so don't forget to update your Section 15), or you have a copy of the D&D MM, and you got the numbers out of there (in which case, it is *not* legit OGC, and it *definitely* should be flagged).

Am i misunderstanding what you did?

The numbers for the Xorn can be extrapolated from the SRD. As for the reach values unless they were taken from another monster in the SRD they can't be included if you want to release this under the OGL. I'll see if I can get ahold of Andy at wizards to see if this info will be included.

Also, woodelf is correct, if you do release this under the OGL it will technically be a different product because of the changes made to the Xorn so section 15 would have to be updated. Unless of course WOTC does update the SRD with this info.

Bryan

 

[andargor]

Am i misunderstanding what you did?

I extrapolated from the rules in the SRD. I don't own a MM.

This is also true for the Wyvern Zombie and the Gray Render Zombie, I used the values for the base monsters.

I'm uploading an update in a few minutes, with an OGC license. Please tell me if it looks ok.

Andargor

 

[andargor]

Changes uploaded. I made a single zip for the spells and monsters.

• Changes as discussed above
• Added Animals (I had forgotten to include the file, oops!)
• Added the OGC license.
• References for each item is now in the SQL data (it was only previously included in the XML data)
• Miscellaneous other fixes

Andargor

 

[Gilwen]

Changes uploaded. I made a single zip for the spells and monsters.

• Changes as discussed above
• Added Animals (I had forgotten to include the file, oops!)
• Added the OGC license.
• References for each item is now in the SQL data (it was only previously included in the XML data)
• Miscellaneous other fixes

Andargor

Cool. I'll have to download the fixes. Keep in mind if you want to incorporate other OGC material in the future in these files you can't include a reference and distribute it under the OGL. For instance if you add an OGC spell from the "Super Dooper Spellbook", you can't have Super Dooper Spellbook listed as a reference or you can't say from Malhavoc press or whatever.

Bryan

 

[Gilwen]

Here is what I recieved from Andy in an email today.

Hello Bryan,

I checked the SRD against the Monster Manual to find the missing information for you, but it turns out most of these omissions originated in the MM. Which means I didn't screw up too much, but also means I don't have that many answers to send you.

The Xorn's Base Attack/Grapple line was left out of the Monster Manual. The zombie wyvern and gray render's space and reach was my mistake: the zombie wyvern is 10ft/5ft and the zombie gray render is 10ft/10ft. Monstrous centipedes are missing this information in the MM. Monstrous scorpions are missing this in the MM.

Assuming that the missing data was unintentional (and I can't see how it could be anything else) it'll all be added back when I get official errata from R&D. And obviously the mistakes that are my fault will be corrected. I'll forward this information to R&D in case they weren't aware of the omissions.

Thanks for bringing this to my attention.


Andy Smith
Publishing/d20 Licensing
Wizards of the Coast, Inc.



-----Original Message-----
From: Bryan Gillispie [mailto:bryang@macc.edu]
Sent: Thursday, August 14, 2003 9:15 AM
To: Smith, Andrew
Subject: RSRD omissions


Mr. Smith,

Looking through the RSRD I found a few creatures that had entries omitted.

The Xorn had it's base attack and grapple entries left out.
The Wyvern Zombie and Gray Render Zombie had their space and reach left out. The Monstrous Centipedes had their treasure and alignment left out. The Monstrous Scorpions (tiny, small and medium) had their treasure left out.

Were those items meant to be omitted? I am in the process of creating material under the OGL that will contain these creatures and didn't know if the RSRD would be updated with the missing information or if I need to create or extrapolate the information from the other creatures in the RSRD.

BTW great job on the RSRD files. They are MUCH easier to view than the 3.0 files!

Thank you,

Bryan Gillispie

 

[woodelf]

I extrapolated from the rules in the SRD. I don't own a MM.

Gotcha. I'm not familiar enough with monsters in D&D, nor with that section of the D20SRD (i've read most of the rules and classes stuff, some of the spells, almost no monsters or magic items), to know how hard extrapolating the missing data would be, much less how to do it.

 

[Jai Kel]

Export error?

INSERT INTO monsters35 VALUES (185,'Giant','Frost Giant','Large','Giant','Cold','14d8+70 (133 hp)','-1','40 ft. (8 squares)','21 (-1 size, -1 Dex, +9 natural, +4 chain shirt) touch 8, flat-footed 21','+10','+23','Greataxe +18 melee (3d6+13/x3) or slam +18 melee (1d4+9) or rock +9 ranged (2d6+9)','Huge greataxe +18/+13 melee (3d6+13/x3) or 2 slams +18 melee (1d4+9) or rock +9 ranged (2d6+9)','10 ft.','10 ft.','Rock throwing','Immunity to cold, low-light vision, rock catching, vulnerability to fire','Fort +14, Ref +3, Will +6','Str 29, Dex 9, Con 21, Int 10, Wis 14, Cha 11','Climb +13, Craft (any one) +6, Intimidate +6, Jump +17, Spot +12','Cleave, Great Cleave, Improved Overrun, Improved Sunder, Power Attack','Cold mountains','Solitary, gang (2-5), band (6-9 plus 35% noncombatants plus 1 adept or cleric of 1st or 2nd level), hunting/raiding party (6-9 plus 35% noncombatants plus 1 adept or sorcerer of 3rd-5th level plus 2-4 winter wolves and 2-3 ogres), or tribe (21-30 plus 1 a','9','Standard','Often chaotic evil','By character class','+4','RSRD MONSTERS (G)');


The part that is bad is the following:

or tribe (21-30 plus 1 a'

This should be:

or tribe (21–30 plus 1 adept, cleric, or sorcerer of 6th or 7th level plus 12–30 winter wolves, 12–22 ogres, and 1–2 young white dragons)'

Did that column run out of character space or something?

 

[Jai Kel]

Hmmm... This one also got cut off:

INSERT INTO monsters35 VALUES (34,'Demon','Balor','Large','Outsider','Chaotic, Extraplanar, Evil','20d8+200 (290 hp)','+11','40 ft. (8 squares), fly 90 ft. (good)','35 (-1 size, +7 Dex, +19 natural), touch 16, flat-footed 28','+20','+36','+1 vorpal longsword +33 melee (2d6+8/19-20)','+1 vorpal longsword +31/+26/+21/+16 melee (2d6+8/19-20) and +1 flaming whip +30/+25 melee (1d4+4 plus 1d6 fire plus entangle); or 2 slams +31 melee (1d10+7)','10 ft.','10 ft. (20 ft. with +1 flaming whip)','Death throes, entangle, spell-like abilities, summon demon, vorpal sword','Damage reduction 15/cold iron and good, darkvision 60 ft., flaming body, immunity to electricity, fire, and poison, resistance to acid 10 and cold 10, spell resistance 28, telepathy 100 ft., true seeing','Fort +22, Ref +19, Will +19','Str 35, Dex 25, Con 31, Int 24, Wis 24, Cha 26','Bluff +31, Concentration +33, Diplomacy +35, Disguise +8 (+10 acting), Hide +26, Intimidate +33, Knowledge (any two) +30, Listen +38, Move Silently +30, Search +30, Sense Motive +30, Spellcraft +30 (+32 scrolls), Spot +38, Survival +7 (+9 following tracks','Cleave, Improved Initiative, Improved Two-Weapon Fighting, Power Attack, Quicken Spell-Like Ability (telekinesis), Two-Weapon Fighting, Weapon Focus (longsword)','A chaotic evil-aligned plane','Solitary or troupe (1 balor, 1 marilith, and 2-5 hezrous)','20','Standard coins; double goods; standard items, plus +1 vorpal greatsword and +1 flaming whip','Always chaotic evil','21-30 HD (Large); 31-60 HD (Huge)','-','RSRD MONSTERS (D-De)');

Survival +7 (+9 following tracks'

should be:

Survival +7 (+9 following tracks), Use Magic Device
+31 (+33 scrolls)'

 

[andargor]

Hmmm... This one also got cut off:

Looks like VARCHAR(255) was a bad choice.

I'm changing the fields to TEXT. I hope it doesn't hurt conversions to Access.

Upload soon.

Andargor

 

[Jai Kel]

Yep, 255 just wasn't enough space. I have run into several other columns that have also been cut off.