Menu
News
All News
Dungeons & Dragons
Level Up: Advanced 5th Edition
Pathfinder
Starfinder
Warhammer
2d20 System
Year Zero Engine
Industry News
Reviews
Dragon Reflections
White Dwarf Reflections
Columns
Weekly Digests
Weekly News Digest
Freebies, Sales & Bundles
RPG Print News
RPG Crowdfunding News
Game Content
ENterplanetary DimENsions
Mythological Figures
Opinion
Worlds of Design
Peregrine's Nest
RPG Evolution
Other Columns
From the Freelancing Frontline
Monster ENcyclopedia
WotC/TSR Alumni Look Back
4 Hours w/RSD (Ryan Dancey)
The Road to 3E (Jonathan Tweet)
Greenwood's Realms (Ed Greenwood)
Drawmij's TSR (Jim Ward)
Community
Forums & Topics
Forum List
Latest Posts
Forum list
*Dungeons & Dragons
Level Up: Advanced 5th Edition
D&D Older Editions, OSR, & D&D Variants
*TTRPGs General
*Pathfinder & Starfinder
EN Publishing
*Geek Talk & Media
Search forums
Chat/Discord
Resources
Wiki
Pages
Latest activity
Media
New media
New comments
Search media
Downloads
Latest reviews
Search resources
EN Publishing
Store
EN5ider
Adventures in ZEITGEIST
Awfully Cheerful Engine
What's OLD is NEW
Judge Dredd & The Worlds Of 2000AD
War of the Burning Sky
Level Up: Advanced 5E
Events & Releases
Upcoming Events
Private Events
Featured Events
Socials!
EN Publishing
Twitter
BlueSky
Facebook
Instagram
EN World
BlueSky
YouTube
Facebook
Twitter
Twitch
Podcast
Features
Top 5 RPGs Compiled Charts 2004-Present
Adventure Game Industry Market Research Summary (RPGs) V1.0
Ryan Dancey: Acquiring TSR
Q&A With Gary Gygax
D&D Rules FAQs
TSR, WotC, & Paizo: A Comparative History
D&D Pronunciation Guide
Million Dollar TTRPG Kickstarters
Tabletop RPG Podcast Hall of Fame
Eric Noah's Unofficial D&D 3rd Edition News
D&D in the Mainstream
D&D & RPG History
About Morrus
Log in
Register
What's new
Search
Search
Search titles only
By:
Forums & Topics
Forum List
Latest Posts
Forum list
*Dungeons & Dragons
Level Up: Advanced 5th Edition
D&D Older Editions, OSR, & D&D Variants
*TTRPGs General
*Pathfinder & Starfinder
EN Publishing
*Geek Talk & Media
Search forums
Chat/Discord
Menu
Log in
Register
Install the app
Install
Upgrade your account to a Community Supporter account and remove most of the site ads.
Community
General Tabletop Discussion
*Geek Talk & Media
SRD Spells Database 3.5
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="javapadawan" data-source="post: 1120409" data-attributes="member: 1444"><p>Thanks Pielorinho! I'm a big fan of using as few tables as possible. <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=":)" /></p><p></p><p></p><p></p><p>My orginal intent was partly to try to keep any attributes that the user might conceivably want to add to, edit or remove, in the attribute table. Although not necessarily a common occurence, I figured adding new subschools, possibly for custom homebrew spells, or alternative campaign settings, might be a feature users would be interested in. I think a couple new subschools were added in 3.5, like Scrying, for example. Also, there are a very small number of spells that do have more than one subschool. I'm not sure about 3.5, but in 3.0 the spell Gate was listed as having both Creation and Calling as subschools.</p><p></p><p>I put Source in there for much the same reason. In 3.0 spells like Eagle's Splendor appeared both in Tome & Blood and in the Forgotten Realms Campaign Setting, and I wanted to have separate records for both. This was because I have a sorting feature which allows a user to "turn off" certain sourcebooks so that spells from those books don't show up when searching, but I wanted them to still be able to see the spell if it also existed in a source they had "turned on".</p><p></p><p>School on the other hand is mostly in there for data quality reasons. See, I also plan to use the attributes as drop down list options when creating new spells. This should help reduce data entry errors which might cause the spell search to behave in unexpected ways, such as mistyping Abjuration as Ajburation when entering a spell, and then wondering why that spell doesn't show up when searching for all Abjuration spells. </p><p></p><p></p><p></p><p>Yeah, I agree. I'd been kind of wavering as to whether or not to include components in the attribute table, but as you mentioned, it would make searching easier, and Silveras brought up a good point earlier in this thread about sources like the Book of Vile Darkness having new types of components. Good call.</p><p></p><p></p><p></p><p>You've got it exactly right. And I like the idea of adding the component description to the value field... It might not be necessary, but it would definitely be a nice touch. That would give me the ability to add something like a "Generate Shopping List" option to a wizard's spellbook that would list all necessary components for his or her spells. Again, not everyone would find such a thing useful, but I definitely think it would be cool. Thanks for the idea!</p></blockquote><p></p>
[QUOTE="javapadawan, post: 1120409, member: 1444"] Thanks Pielorinho! I'm a big fan of using as few tables as possible. :) My orginal intent was partly to try to keep any attributes that the user might conceivably want to add to, edit or remove, in the attribute table. Although not necessarily a common occurence, I figured adding new subschools, possibly for custom homebrew spells, or alternative campaign settings, might be a feature users would be interested in. I think a couple new subschools were added in 3.5, like Scrying, for example. Also, there are a very small number of spells that do have more than one subschool. I'm not sure about 3.5, but in 3.0 the spell Gate was listed as having both Creation and Calling as subschools. I put Source in there for much the same reason. In 3.0 spells like Eagle's Splendor appeared both in Tome & Blood and in the Forgotten Realms Campaign Setting, and I wanted to have separate records for both. This was because I have a sorting feature which allows a user to "turn off" certain sourcebooks so that spells from those books don't show up when searching, but I wanted them to still be able to see the spell if it also existed in a source they had "turned on". School on the other hand is mostly in there for data quality reasons. See, I also plan to use the attributes as drop down list options when creating new spells. This should help reduce data entry errors which might cause the spell search to behave in unexpected ways, such as mistyping Abjuration as Ajburation when entering a spell, and then wondering why that spell doesn't show up when searching for all Abjuration spells. Yeah, I agree. I'd been kind of wavering as to whether or not to include components in the attribute table, but as you mentioned, it would make searching easier, and Silveras brought up a good point earlier in this thread about sources like the Book of Vile Darkness having new types of components. Good call. You've got it exactly right. And I like the idea of adding the component description to the value field... It might not be necessary, but it would definitely be a nice touch. That would give me the ability to add something like a "Generate Shopping List" option to a wizard's spellbook that would list all necessary components for his or her spells. Again, not everyone would find such a thing useful, but I definitely think it would be cool. Thanks for the idea! [/QUOTE]
Insert quotes…
Verification
Post reply
Community
General Tabletop Discussion
*Geek Talk & Media
SRD Spells Database 3.5
Top