RPTools.net

Discussion and Support

Skip to content

It is currently Fri Dec 15, 2017 10:24 pm 






Reply to topic  [ 6 posts ] 

Previous topic | Next topic 

  Print view

Author Message
User avatar  Offline
Dragon
 
Joined: Mon Sep 11, 2006 9:12 am
Posts: 468
 Post subject: Spell database http://www.imarvintpa.com/dndlive/index.php
PostPosted: Thu Oct 12, 2006 7:15 am 
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


Top
 Profile  
 
User avatar  Offline
Great Wyrm
 
Joined: Tue Jun 13, 2006 4:55 pm
Posts: 1801
Location: Oak Harbor, WA
 Post subject:
PostPosted: Thu Oct 12, 2006 8:06 am 
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
-----------
Helm's Deep RPG Network
Infinite Realities - RPG Supplements.
RPGMapShare.com - RPG Maps and Mapping objects.


Top
 Profile  
 
User avatar  Offline
Dragon
 
Joined: Mon Sep 11, 2006 9:12 am
Posts: 468
 Post subject:
PostPosted: Thu Oct 12, 2006 8:18 am 
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


Top
 Profile  
 
User avatar  Offline
Great Wyrm
 
Joined: Tue Jun 13, 2006 4:55 pm
Posts: 1801
Location: Oak Harbor, WA
 Post subject:
PostPosted: Thu Oct 12, 2006 8:36 am 
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
-----------
Helm's Deep RPG Network
Infinite Realities - RPG Supplements.
RPGMapShare.com - RPG Maps and Mapping objects.


Top
 Profile  
 
User avatar  Offline
RPTools Founder
 
Joined: Tue Jan 31, 2006 11:10 am
Posts: 277
Location: Austin, TX
 Post subject:
PostPosted: Thu Oct 12, 2006 6:47 pm 
Cool site Marvin. What kind of database are you storing things in? I would be interested in seeing your table structure.

_________________
~Giliath


Top
 Profile  
 
User avatar  Offline
Dragon
 
Joined: Mon Sep 11, 2006 9:12 am
Posts: 468
 Post subject:
PostPosted: Sat Oct 14, 2006 10:32 am 
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:
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


Top
 Profile  
 
Display posts from previous:  Sort by  
Reply to topic  [ 6 posts ] 

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:

Who is online

In total there are 2 users online :: 0 registered, 0 hidden and 2 guests (based on users active over the past 5 minutes)
Most users ever online was 243 on Sun Nov 04, 2012 6:14 am

Users browsing this forum: No registered users and 2 guests





Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group

Style based on Andreas08 by Andreas Viklund

Style by Elizabeth Shulman