Upgrade your account to a Community Supporter account and remove most of the site ads.

Reply to thread

Message: <blockquote data-quote="spacemonkey" data-source="post: 1126405" data-attributes="member: 13180">This is along the lines of what I am moving to with my spells database (in MySQL).  Right now I have it set up with many-many relationships for the spell levels and such, but I am thinking that there will not be an easy way for a user to input new types; that's why I like how Java has it set up here (waves to JavaPadawan - its your datamonkey, Sam <img src="https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f609.png" class="smilie smilie--emoji" loading="lazy" width="64" height="64" alt=";)" title="Wink    ;)"  data-smilie="2"data-shortname=";)" />)I would definitely separate the component 'cost' field from the 'type/desc' field.  Cheap or lazy spellcasters need a way to search for the '0gp' components so they never have to buy or keep track of any <img src="https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f609.png" class="smilie smilie--emoji" loading="lazy" width="64" height="64" alt=";)" title="Wink    ;)"  data-smilie="2"data-shortname=";)" />I would also agree that subschools need to be able to be modified; I've had need of this already for a custom setting I'm working on.  I would almost venture to say the same of Schools, but I lean toward making things as customizable as I can.  To give you an example, what if one were to put in the Sovereign Stone spells along with the SRD spells?  SovStone spells are quite different, but with a customizable system such as the one described above, it should be possible.  You would need to put new Schools in though, I believe (I don't think that the spell disciplines they have in that system would fit under subschools, but I don't have my book in front of me, so I could be wrong).Combine this with attributes for what schools a class has access to, and you can easily combine a couple of different magic systems in one DB.  (for instance, you add entries for Sor/Wiz to have access to all the standard schools, but an Elemental mage would only have access to the SovStone schools)Somewhat ambitious perhaps, but does anyone see any problems with that sort of an arrangement?</blockquote>

Verification