Indexes Project

[Psithief]

Last update: 28th April, 2013

Index Project

What is it?
It's an index that lets you look up the location of any feat, class, spell, monster etc. so you don't have to trawl through all the books
AND it's an index that will list everything in a category, whether that category be 'Aquatic Outsiders', 'Bard Necromancy spells', 'Vestiges that give bonuses to Diplomacy' or 'The entire index of Complete Adventurer'.

Current status?
Pre-Alpha
Lacking all but the most basic documentation, key features missing.
Newest features:

• Double-click to edit a returned result. Now you can fix errors when you see them.

Developing:

• To be decided

Current System Requirements
Works only on:

• Chrome
• Firefox
• Internet Explorer with the Google Chrome Frame plugin (auto-linked)

Common issues:
It won't work in "Private Browsing Mode"/"Incognito Mode". It's an offline web application, it needs to be able to store data on your computer.
Where do I get it?
Try it here:
Downloadable (847KB archive) (Recommended)
Online version

Online version warning:
The first load may be slow. After that it should be cached in your browser.
Dropbox's web cache will want to throttle the number of requests your browser makes. It may prove impossible to cache the application from Dropbox.

Only looking for the latest data? 2013-04-28
Download the latest data

Individual data files can be found here. (Likely out of date, yet to be automated.)

How do I contribute?
Okay, let's split this into two parts. I'll do the code and everyone else can collaborate to do the "type everything into a spreadsheet and save it as a comma-separated values file (.csv)" boring data entry part.

Collaborate?
Everything that can be imported into the application can be exported again. You can take an entire snapshot of it (JSON format) to share, OR export the data piece by piece in CSV format.

Importing a snapshot will overwrite anything you already have imported though!

What needs doing?
The current aim is to cover all the D&D3.5 default setting books.
Future goals will probably include things like: D&D3 Eberron+ Faerun, D&D3.0, D&D4E, D&D5th

Data needed:

Spells	Items	Soulmelds
Cityscape (pp. 66-68)
Complete Mage (pp. 95-122)	Complete Mage (pp. 125-136)
Dragon Magic (pp. 64-75)	Dragon Magic (pp. 92-97)	Dragon Magic
Fiendish Codex I (pp. 90-96)
Fiendish Codex II (pp. 100-106)
Magic of Incarnum (pp. 98-106)	Magic of Incarnum (pp.108-114)	Magic of Incarnum
Tome of Magic	Tome of Magic
	Magic Item Compendium
	Planar Handbook (pp. 78-84)
	Complete Champion (pp. 131-144)
	Tome of Battle
	Eberron (all the books)

• Base Classes (all restrictions)
• Feats (all prerequisites, types)
• Magic items (see above)
• Prestige Classes (all prerequisites)
• Spells (see above)
• Tome of Magic: Mysteries, Utterances
  

What are the system requirements?
I'm aiming for the following browser support:

• Google Chrome and Chromium
• Mozilla Firefox
• Microsoft Internet Explorers with the Google Chrome Frame plugin installed.
• Opera, once they switch to WebKit.

See current status above for current compatibility.

Where do I report bugs?
At the github project page here

[altpersona]

dndtools.eu has spells, feats, skills, classes.

surreal has almost everything else. (not really but its the bomb)

[sirpercival]

Are you including homebrew, or just published material?  I know captnq and zook1shoe both have spell databases.

[Maat Mons]

ImarvinTPA has several databases.  The spells can be downloaded as a spreadsheet.  Nothing else can be. 

Most of the old Crystal Keep stuff can still be found here. 

This guy has a partial database. 

If you want the Master +0 LA Race List III as a spreadsheet, I can send it to you. 

[kitep]

While you're at it, how about a complete list of magical locations and skill tricks?  You know, because you don't have enough on your plate already   

[Maat Mons]

Here's a pretty good list of magical locations. 

Here's a list of teamwork benefits.  It doesn't include the ones from The Forge of War. 

[nijineko]

the dragondex is pretty useful as well.

[Psithief]

Are you including homebrew, or just published material?

I figure as long as everything can be tied to its source, the user can just select what sources they want to search on.
(Or what category of sources).

It will just be HTML, Javascript, maybe some SVG.
I'm just building the engine to import/export, display, search and sort.
It is an Index engine, though. I'll likely discard parts of sources that contain the entire descriptions.

That won't stop anyone from importing more data than I intend.

[awaken_D_M_golem]

Borg286 did the extremely detailed spreadsheet and thread "Complete MacGyver":

BG thread ---> http://brilliantgameologists.com/boards/index.php?topic=11066

Google Spreadsheet ---> https://docs.google.com/spreadsheet/ccc?key=0AqLk5_LGDVGIdEp2RVVjamNsYlNEQjhSclZ3ektRUFE&authkey=CKOgzd0F&hl=en&authkey=CKOgzd0F#gid=0

[SorO_Lost]

*Warning: Finishing this project may provoke propositions of a sexual nature from strangers.*

[Psithief]

Good progress has been made, but I'm short quite a few pieces of data for a comprehensive search. (See first post)

Search rules are as follows:

• Multiple search terms are intersected together. (AND)
• Search terms preceeded with a '+' are instead unioned. (OR)
• Search terms preceeded with a '-' subtract matching results. (AND NOT)
• There is currently no support for grouping, e.g. (this OR that) AND "that other thing"
  

• A data store and a property can be specified as part of the search term. These are separated by colons. (optional)data:(optional)property:searchTerm
  
• If subsequent search terms do not reset the data store/property they will apply to subsequent terms.
• Resetting is achieved by prefixing the term with a colon.
• Whenever the data store is reset the property is also reset.
• To search using multiple words as one term, surround the term in double quotes.
  

Example searches:

Everything	*
Level 1 bard spells that aren't mind-affecting	spells:"bard 1" -mind-affecting
All eldritch essence invocations for warlocks	inv:warlock inv:essence:true
All manoeuvres	man:*
Strike manoeuvres	man:type:strike
Crusader non-stance manoeuvres	man:crus -stance
Large Monstrous humanoids	mon:Large "Monstrous hum"
Creatures with the Good subtype that aren't Outsiders	mon:Good -Outsider
Teamwork Benefits that require both Listen and Spot to learn	team:req:listen spot
Spells in the Sun and Healing domains	+spells:class:Sun +Healing
All spells and powers with the Creation subschool/subdiscipline	:sub:creation
All spells and powers with the Creation subschool/subdiscipline with medium range	:sub:creation :range:medium
Everything in the book 'Complete Adventurer'	:source:cad

Sorting:

• Sorting does not have partial property matching. 'nam' is not a substitute for 'name' and so on.
• Sorts properties left to right with quicksort.
• Sort direction can be inverted for any property be preceeding it with a dash. ('-', not em-dashes or en-dashes).

Here's a pic of the prototype in action:

[bhu]

dndtools.eu has spells, feats, skills, classes.

surreal has almost everything else. (not really but its the bomb)

surreal??

[sirpercival]

The Surrealdex

[Psithief]

Progress update post removed!

[nijineko]

page loads, text can be entered, search triggered, but otherwise does not work on safari, as nothing displays.

[Psithief]

*thumbs up* That's totally expected because Safari is terrible.
http://caniuse.com/#compare=chrome+24,safari+6
Safari does not have IndexedDB.

Should it tell you your browser is not adequate? Of course! but proof-of-concept is way before even alpha, let-alone beta software.
The application will let you know if your browser doesn't meet the requirements.
I can put in the shim that lets one use WebSQL in place of IndexedDB but I will have no way of testing it because I do not have Safari 6.
I had a go at using some shim code but it's not quite good enough.

[Psithief]

Progress:
- magic items from http://chet.kindredcircle.org/ imported.

Problem:
- no magic items from the Magic Item Compendium included.

Solution:
- wait until someone helps out?

[Psithief]

According to the comments in the following blog post, Microsoft is not going to make any attempts to keep IndexedDB up to date. The result is that support for IE10 must be dropped.
Blog post
The Google Chrome Frame plugin will be automatically suggested for any users of 32-bit Internet Explorer.

[nijineko]

i have a master list of almost every psionic power in 3.x d&d official sources. i'm short a few as i got lazy and haven't finished. over 700 main entries.

[Psithief]

Wasn't your list what I used?
It didn't have any page numbers, unfortunately. It was also missing class entries for all the Complete Psionic lists (lurk and mantles).
I put those all in by hand, added psychic rogue's classlist to the powers too.