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

Reply to thread

Message: <blockquote data-quote="javapadawan" data-source="post: 1126661" data-attributes="member: 1444">Hello Sam! <img src="https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png" class="smilie smilie--emoji" loading="lazy" width="64" height="64" alt=":)" title="Smile    :)"  data-smilie="1"data-shortname=":)" />That sounds like a good idea. If I go with the value field in the spell_has_attribute table as a number and add the aforementioned note field as text, it would be simple to keep the component text and any material component value separate. This would also be useful when calculating the cost to create any scrolls/potions/wands etc. from specific spells with an extra gp/xp component cost.The only drawback I see is during user entry of new spells. Trying to parse the information from the user entered long_description, or even the components field would probably be troublesome, unless it's in a specific format. Not sure if many users would want to go through the extra trouble of doing that. Adding them as optional data fields on the spell creation user interface would work though, and leaving them blank could signify no extra costs for the spell being entered.It looks like I'm definitely going to need to redesign the UI for spell entry. <img src="https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png" class="smilie smilie--emoji" loading="lazy" width="64" height="64" alt=":)" title="Smile    :)"  data-smilie="1"data-shortname=":)" />Gotcha. I would like the data model I go with to be flexible enough to account for things like the Sovereign Stone CS, so it looks like I'll be leaving School as an attribute_type after all.Sounds reasonable. I suppose if you wanted to get crazy you could have an attribute_relationship table which mapped out the relationship between not only classes and schools, but also schools and subschools, subschools and descriptors, etc. That's probably overkill though, depending on what you want to do with that information.</blockquote>

Verification