Menu
News
All News
Dungeons & Dragons
Level Up: Advanced 5th Edition
Pathfinder
Starfinder
Warhammer
2d20 System
Year Zero Engine
Industry News
Reviews
Dragon 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 Next
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
*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!
Twitch
YouTube
Facebook (EN Publishing)
Facebook (EN World)
Twitter
Instagram
TikTok
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
*TTRPGs General
*Pathfinder & Starfinder
EN Publishing
*Geek Talk & Media
Search forums
Chat/Discord
Menu
Log in
Register
Install the app
Install
The
VOIDRUNNER'S CODEX
is LIVE! Explore new worlds, fight oppressive empires, fend off fearsome aliens, and wield deadly psionics with this comprehensive boxed set expansion for 5E and A5E!
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="Pielorinho" data-source="post: 1118525" data-attributes="member: 259"><p>Thanks! I'll actually qualify it even further, though: my suggestions are for a single character <em>with only one spellcasting class</em>.</p><p></p><p>This may be cheesy, but given the amount of space on computers, it wouldn't be too silly to have a different database for each PC, even for each spellcasting cast of a PC.</p><p></p><p>The alternative would be to add coding to the database allowing the user to track multiple PCs and multiple classes within a single PC. While such a thing would be fantastic, it would make the coding a lot more difficult. Given that I'm almost entirely self-taught on Access, I'm pretty sure that such a project would be beyond my reach <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":)" title="Smile :)" loading="lazy" data-shortname=":)" />.</p><p></p><p>However, by adding in one additional table and a couple fields in the existing table, I think you could make it a very useful tool for tracking spells for a single PC. Imagine having your laptop at the gaming table when you're faced by a creature with spell resistance. You filter the spell form for spells you have prepared that do not have "Target: Personal" and do not allow for Spell Resistance, and voila! You have a customized spell list for the combat. Or when you fight fighters, filter for spells that do not have "Fort" in the saving throw field. Or filter for spells with the "Fire" descriptor when fighting white dragons. It would be grand.</p><p> </p><p>Edit: It might be interesting to see the architecture of the database. For example, which aspects have you separated out into different tables? It occurs to me that spell level information ought to be in a different table, with a third table describing a many-to-many relationship between them. That would allow for some very sweet queries later on. Same thing with spell descriptors. Were both separated out, it would be simple to search for all Druid Fire spells of fourth or lower level, for example.</p><p></p><p>Daniel</p></blockquote><p></p>
[QUOTE="Pielorinho, post: 1118525, member: 259"] Thanks! I'll actually qualify it even further, though: my suggestions are for a single character [i]with only one spellcasting class[/i]. This may be cheesy, but given the amount of space on computers, it wouldn't be too silly to have a different database for each PC, even for each spellcasting cast of a PC. The alternative would be to add coding to the database allowing the user to track multiple PCs and multiple classes within a single PC. While such a thing would be fantastic, it would make the coding a lot more difficult. Given that I'm almost entirely self-taught on Access, I'm pretty sure that such a project would be beyond my reach :). However, by adding in one additional table and a couple fields in the existing table, I think you could make it a very useful tool for tracking spells for a single PC. Imagine having your laptop at the gaming table when you're faced by a creature with spell resistance. You filter the spell form for spells you have prepared that do not have "Target: Personal" and do not allow for Spell Resistance, and voila! You have a customized spell list for the combat. Or when you fight fighters, filter for spells that do not have "Fort" in the saving throw field. Or filter for spells with the "Fire" descriptor when fighting white dragons. It would be grand. Edit: It might be interesting to see the architecture of the database. For example, which aspects have you separated out into different tables? It occurs to me that spell level information ought to be in a different table, with a third table describing a many-to-many relationship between them. That would allow for some very sweet queries later on. Same thing with spell descriptors. Were both separated out, it would be simple to search for all Druid Fire spells of fourth or lower level, for example. Daniel [/QUOTE]
Insert quotes…
Verification
Post reply
Community
General Tabletop Discussion
*Geek Talk & Media
SRD Spells Database 3.5
Top