-
The VOIDRUNNER'S CODEX is coming! Explore new worlds, fight oppressive empires, fend off fearsome aliens, and wield deadly psionics with this comprehensive boxed set expansion for 5E and A5E!
MySQL db?
- Thread starter Fenlock
- Start date
Psionicist
Explorer
Now that'd be useful.
*bump*
*bump*
Chris Tavares
Explorer
Fenlock said:
You want this: http://www.andargor.com/. It's not the full SRD, just the spells and monsters. Also, the XML was a very mechanical translation, and there's a lot of invalid characters, so it won't actually load without some massaging. Still very useful, though.
Last edited:
Fenlock
First Post
bingo! thank you chris.
i found a 3.0 spell version through google.
both the 3.0 and 3.5 version are non-normalized.
im trying to normalize the spell database now and then i'll add the monsters later.
if anyone is interested i'll drop a note when i am done.
it might take some time, since i'm using it to learn mysql at the same time.
/f
i found a 3.0 spell version through google.
both the 3.0 and 3.5 version are non-normalized.
im trying to normalize the spell database now and then i'll add the monsters later.
if anyone is interested i'll drop a note when i am done.
it might take some time, since i'm using it to learn mysql at the same time.
/f
MJEggertson
First Post
That could definitely be used. If you get it normalized, make sure you drop a note...
Psionicist
Explorer
I can probably code a user interface in PHP (search and such) if someone else inserts everything in the database.
Chris Tavares said:
The problems with the XML are the '&' in the source tags. A simple find and replace of '&' for '&' should do the trick, which is what I did to parse the XML file.
With regards to normalisation, my problem was where to stop. I eventually settled on class, domain, level, and school mainly because they were the cleanest to normalise. Categories such as components, saves, etc, had annoying exceptions. I know of another thread elsewhere on these forums that had people doing far more with respect to normalisation, but they have gone silent since. My personal requirement with normalisation was that if it was good enough to reproduce the class/domain spell lists found in the PHB, then it was good enough. I also had a quick PHP thing as well as a test case as I was trying to write a Java based solution.
Additionally, I am grappling with what happened to the 3.5 Monsters as parsed by andargor. They are separated into two tables: statistics and descriptions. As far as I am concerned, this separation doesn't work well as provided. For example, joining the tables in SQL to get a list of all angels isn't very clean and I think there needs to be a parent_monster_type or similar to allow easier joining. I thought briefly about doing this myself, but got distracted by games.
Jeranon said:Additionally, I am grappling with what happened to the 3.5 Monsters as parsed by andargor. They are separated into two tables: statistics and descriptions. As far as I am concerned, this separation doesn't work well as provided. For example, joining the tables in SQL to get a list of all angels isn't very clean and I think there needs to be a parent_monster_type or similar to allow easier joining. I thought briefly about doing this myself, but got distracted by games.
I parsed the monster data into a more normalized format. Its in an Advantage database ( free data viewer http://www.advantagedatabase.com ).
You can download the Monster database by downloading Monster 3.5
http://yoyodyne.virtualave.net/monster35/index.html
(watch the pop-ups
)
