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: 1135497" data-attributes="member: 1444">I agree. And in that case, it does seem as though it would be best to keep School as an attribute.I think an errata field is a good idea. In addition to a date field though, it might also be helpful to have a source field. This way you'd know that a particular piece of errata came from Sage Advice, from an official WotC errata document, from a reprinting of the spell in a later sourcebook, etc. It would be easy enough to add these fields to the spell table, though as you mentioned, if a spell was errata'd more than once you'd lose the original record of that... unless errata was stored in another table. (For someone who dislikes adding extra tables, I sure seem to be suggesting a lot of them, don't I? <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=";)" /> ) What if you had something like this:spell_has_errata----------------spell_has_errata_id (AutoNumber)spell_id (Number, foreign key : spell)errata (Memo)source (Text)date (Date or Text, text could allow an exact date or a general date, like 5/05/2003 vs. 5/2003)The drawback of this is that we'd need to do an outer join to pull back both spells that have errata and those that don't, but the upside is that no matter how many times a spell is errata'd, we would have access to not only the original text of the spell but also each subsequent change. Additionally, there may be those who don't like the errata and would rather use a spell as originally written, or might just be curious as to how much has changed over the course of a spell's life. Overkill? Heh, maybe. But all this could be transparent to the end user. When printing out the spell description for viewing, we could just append the errata to the end of the long description, prefixed by the source and date, looking something like this:...This spell does blah blah blah to all creatures within a fifty foot radius.ERRATA: Sage Advice, May 2003This spell does blah blah blah to all living creatures within a fifty foot radius.ERRATA: PHB v3.5 Official Errata, July 15, 2003This spell does blah blah blah to all living creatures within a sixty foot radius....To paraphrase a popular commercial series...Adding a Verified checkbox to the spell table: Good idea.Adding a Verified date field to the spell table: Great idea.Getting your players to do the work for you: Priceless. <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=":)" /></blockquote>

Verification