Spell database http://www.imarvintpa.com/dndlive/index.php

Links to gaming-related tools and external resources. Feel free to promote your (RPG-related) sites here.

Moderators: dorpond, trevor, Azhrei

Post Reply
User avatar
IMarvinTPA
Dragon
Posts: 467
Joined: Mon Sep 11, 2006 10:12 am
Contact:

Spell database http://www.imarvintpa.com/dndlive/index.php

Post by IMarvinTPA »

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

User avatar
Steel Rat
Great Wyrm
Posts: 1765
Joined: Tue Jun 13, 2006 5:55 pm
Location: Oak Harbor, WA
Contact:

Post by Steel Rat »

Jeez, that's one hell of a search form, lol. Firefox almost choked on it.

I noticed there's an awful lot of "closed content reproduced without permission", seems a dangerous thing to have out there.
Steel Rat
-----------
RPGMapShare.com - RPG Maps and Mapping objects.
Discord Server

User avatar
IMarvinTPA
Dragon
Posts: 467
Joined: Mon Sep 11, 2006 10:12 am
Contact:

Post by IMarvinTPA »

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

User avatar
Steel Rat
Great Wyrm
Posts: 1765
Joined: Tue Jun 13, 2006 5:55 pm
Location: Oak Harbor, WA
Contact:

Post by Steel Rat »

That's cool. I'm guessing this isn't just SRD stuff, since some didn't look familiar (not that I have it all memorized, lol).
Steel Rat
-----------
RPGMapShare.com - RPG Maps and Mapping objects.
Discord Server

User avatar
giliath
RPTools Founder
Posts: 275
Joined: Tue Jan 31, 2006 11:10 am
Location: Austin, TX

Post by giliath »

Cool site Marvin. What kind of database are you storing things in? I would be interested in seeing your table structure.
~Giliath

User avatar
IMarvinTPA
Dragon
Posts: 467
Joined: Mon Sep 11, 2006 10:12 am
Contact:

Post by IMarvinTPA »

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.

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`)
)
IMarv

Post Reply

Return to “Links & External Resources”