I have a spell, feat, item, deity, domains, etc database. Many of them are searchable at http://www.imarvintpa.com/dndlive/index.php
I have full texts for all spells and feats that are listed. Basic details on most items, some full text.
The spell search engine is good at finding complex questions, like all fire descriptor spell level 5 and higher with no somatic components.
Check it out sometime!
IMarv
Spell database http://www.imarvintpa.com/dndlive/index.php
Moderators: dorpond, trevor, Azhrei
- IMarvinTPA
- Dragon
- Posts: 467
- Joined: Mon Sep 11, 2006 10:12 am
- Contact:
- IMarvinTPA
- Dragon
- Posts: 467
- Joined: Mon Sep 11, 2006 10:12 am
- Contact:
I've had that phrase there since late 2004, I haven't had any problems so far. I also don't post the entire spell descriptions and the like. I generally show less than Crystal Keep or something close.
I've ask and have been denied the hope of selling full access subscriptions. So they are aware that I exist. Maybe someday I'll ask again.
IMarv
I've ask and have been denied the hope of selling full access subscriptions. So they are aware that I exist. Maybe someday I'll ask again.
IMarv
- IMarvinTPA
- Dragon
- Posts: 467
- Joined: Mon Sep 11, 2006 10:12 am
- Contact:
It was MS Access, but I moved it to mySQL a while back.
Here's the spell table. I have a good number of others, but I'm not feeling that right now.
IMarv
Here's the spell table. I have a good number of others, but I'm not feeling that right now.
Code: Select all
CREATE TABLE `spell` (
`Name` varchar(50) default NULL,
`Id` int(11) NOT NULL default '0',
`School` varchar(20) default NULL,
`Subschool` varchar(20) default NULL,
`descriptor` varchar(255) default NULL,
`levels` varchar(255) default NULL,
`Components` varchar(255) default NULL,
`CastingTime` varchar(50) default NULL,
`Range` varchar(50) default NULL,
`EffectType` varchar(100) default NULL,
`Effect` varchar(255) default NULL,
`Duration` varchar(100) default NULL,
`SavingThrow` varchar(100) default NULL,
`Resistance` varchar(50) default NULL,
`ShortDescription` varchar(255) default NULL,
`LongDescription` text,
`Sources` varchar(255) default NULL,
`Materials` varchar(255) default NULL,
`Focus` varchar(255) default NULL,
`Somatic_Comp` tinyint(4) default NULL,
`Verbal_Comp` tinyint(4) default NULL,
`Material_Comp` tinyint(4) default NULL,
`Focus_Comp` tinyint(4) default NULL,
`DivineFocus_Comp` tinyint(4) default NULL,
`XP_Comp` tinyint(4) default NULL,
`XP_Cost` varchar(255) default NULL,
`Expensive_Focus` tinyint(4) default '0',
`Expensive_Material` tinyint(4) default '0',
`Recharge` varchar(50) default NULL,
`Corrupt_Flag` tinyint(4) default NULL,
`Demon_Flag` tinyint(4) default NULL,
`Devil_Flag` tinyint(4) default NULL,
`Disease_Flag` tinyint(4) default NULL,
`Drug_Flag` tinyint(4) default NULL,
`Fiend_Flag` tinyint(4) default NULL,
`Location_Flag` tinyint(4) default NULL,
`Soul_Flag` tinyint(4) default NULL,
`Undead_Flag` tinyint(4) default NULL,
`Abstinence_Flag` tinyint(4) default NULL,
`Archon_Flag` tinyint(4) default NULL,
`Celestial_Flag` tinyint(4) default NULL,
`Eladrin_Flag` tinyint(4) default NULL,
`Guardinal_Flag` tinyint(4) default NULL,
`Sacrifice_Flag` tinyint(4) default NULL,
`MediumDescription` varchar(255) default NULL,
`Added` datetime default NULL,
`Breath_Flag` tinyint(4) default NULL,
`Grayhawk_Cat` varchar(50) default NULL,
`last_upd_dt` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`Coldfire_flag` int(1) default NULL,
`Frostfell_flag` int(1) default '0',
`sortname` varchar(50) default NULL,
`AddedBy` varchar(30) default NULL,
`UpdatedBy` varchar(30) default NULL,
`Editor_Notes` text,
`Flavor_Desc` text,
`School2` varchar(20) default NULL,
PRIMARY KEY (`Id`),
UNIQUE KEY `UK_Name` (`Name`),
KEY `RPGASpell` (`Grayhawk_Cat`),
KEY `SourceBookSpell` (`Sources`),
KEY `spell_sortname` (`sortname`)
)