D20PFSRD Spell Filters


Product Discussion

The Exchange

Seen these yet? Thank Denny Edwards for this snazzy contribution to the site!

Alchemist Spell Filter Page
Antipaladin Spell Filter Page
Bard Spell Filter Page
Cleric Spell Filter Page
Druid Spell Filter Page
Magus Spell Filter Page
Witch Spell Filter Page

The rest of the spell list pages are coming soon, as well as other big indexy-type pages (like the Traits page for example!)

The Exchange

Woot! And now the Summoner Spell Filter Page is live too! Denny's kicking butt!

Dark Archive

don't forget your old friend Spell DB [sniff]
download as excel and sort to your heart's content


And to think I built this huge tree of organized bookmarks in my browser for everything my witch can do just two nights ago...
This will definitely be handy for GMing and future characters, but I invested far too much time the other night building that thing to scrap it. Thanks for the links. Black dotted.

The Exchange

chopswil wrote:

don't forget your old friend Spell DB [sniff]

download as excel as sort to your heart's content

Oh your DB's are still getting HEAVY use Mike!

Dark Archive

d20pfsrd.com wrote:
chopswil wrote:

don't forget your old friend Spell DB [sniff]

download as excel and sort to your heart's content
Oh your DB's are still getting HEAVY use Mike!

:)

updated monthly FYI


d20pfsrd.com wrote:
chopswil wrote:

don't forget your old friend Spell DB [sniff]

download as excel as sort to your heart's content
Oh your DB's are still getting HEAVY use Mike!

Indeed the spell db may end up being the saving grace of a new alternate class by super genius games (The Mosaic Mage).

The Exchange

Kolokotroni wrote:
Indeed the spell db may end up being the saving grace of a new alternate class by super genius games (The Mosaic Mage).

I haven't seen that one yet. How does the Spells DB help out in that case?

The Exchange

Paladin Spell Filter Page is now up also.


d20pfsrd.com wrote:
Kolokotroni wrote:
Indeed the spell db may end up being the saving grace of a new alternate class by super genius games (The Mosaic Mage).
I haven't seen that one yet. How does the Spells DB help out in that case?

It is an alternate Wizard class that divides the wizard into 5 colors(Red, White, Black, Blue and Yellow. Each color has a couple special abilties to choose form sort of like talants or oracle mysteries, but the big draw is each color has a set of schools/subschools. Every spell in that school or subschool is in their list regardless of its normal list. So a Black Mage has Illusion(shadow). Every Illusion spell with the shadow subschool is on their list. The Red Mage has every evocation spell without an energy type OR with fire energy type.

There is no existing useful list that will help a player pick through the available spells in any book. I havent looked at it closely before now, but it seems to me the spell db will be a massive help in tackling spell lists for the 5 color mages.

The Exchange

Ranger Spell Filter Page is now up also.

@Kolokotroni: Ok, I see. Yeah then that would be helpful. The Spell Filter pages we've just added might work too. Try both and use whichever works best :)

The Exchange

Sorcerer/Wizard Spell Filter Page is now up also. Woot Woot!


chopswil wrote:

don't forget your old friend Spell DB [sniff]

download as excel and sort to your heart's content

Thank you for the great work on the Spell DB. It's especially useful if you need more advanced filtering/sorting options.

Dark Archive

x93edwards wrote:
chopswil wrote:

don't forget your old friend Spell DB [sniff]

download as excel and sort to your heart's content
Thank you for the great work on the Spell DB. It's especially useful if you need more advanced filtering/sorting options.

you're welcome!!

If any one ever wants the create table statements for my sql server DB tables just let me know (chopswil at comcast dot net); for those of you who want to make these real DBs...


Might it be possible to add a filter for ranges? I know I was looking to narrow down a list of touch spells best used in cooperation with Reach Spell, and the filters as they stand currently don't have that capability.

Liberty's Edge

While I love the d20pfsrd spell filters, they don't have some of the functionality I would really love to see... namely the ability to sort non-Sorcerer/Wizard spells by school and the ability to sort by descriptors and/or subschools.

The Spell DB is a possibility for this kind of thiing, but it is rather flawed in its execution purely because it just goes off the written entry than accessing a true database. To find mind-affecting spells I have to sort by mind-affecting (twice--it has two entries for some reason), mind-affecting curse, mind-affecting evil, mind affecting sonic... and so on. There's just some weirdness with the entries that makes it not particularly useful for fine searches.

Dark Archive

Alice Margatroid wrote:


The Spell DB is a possibility for this kind of thiing, but it is rather flawed in its execution purely because it just goes off the written entry than accessing a true database. To find mind-affecting spells I have to sort by mind-affecting (twice--it has two entries for some reason), mind-affecting curse, mind-affecting evil, mind affecting sonic... and so on. There's just some weirdness with the entries that makes it not particularly useful for fine searches.

1) it is a true DB, SQL Server, but the google doc is the only way I've found to distribute it

2) the data in it is what Paizo writes, I change it only for errata or a fubar on my part

3) If you'd like the real DB let me know and I'll send you the backup file, chopswil at comcast dot net, because you're correct you can only do so much with filters as opposed to sql statements


Pathfinder Rulebook Subscriber
chopswil wrote:

1) it is a true DB, SQL Server, but the google doc is the only way I've found to distribute it

2) the data in it is what Paizo writes, I change it only for errata or a fubar on my part

3) If you'd like the real DB let me know and I'll send you the backup file, chopswil at comcast dot net, because you're correct you can only do so much with filters as opposed to sql statements

I think part of the issue is that there is a lot of "dirt" in the columns... as in, dirty data. I've wanted to try to clean those up for a long time but its a pretty big task.

Dark Archive

jreyst wrote:
chopswil wrote:

1) it is a true DB, SQL Server, but the google doc is the only way I've found to distribute it

2) the data in it is what Paizo writes, I change it only for errata or a fubar on my part

3) If you'd like the real DB let me know and I'll send you the backup file, chopswil at comcast dot net, because you're correct you can only do so much with filters as opposed to sql statements

I think part of the issue is that there is a lot of "dirt" in the columns... as in, dirty data. I've wanted to try to clean those up for a long time but its a pretty big task.

I'm open to ways of "cleaning up" the data and issues that people find

Dark Archive

Spell DB updated with new fields
all spell descriptors have their own fields for searching 1 if it exists 0 if not

also cleaned up descriptor text for "language dependent" and "mind affecting"

let me know if you find anything

The Exchange

WOOT WOOT! Thanks Mike!

Community / Forums / Pathfinder / Pathfinder First Edition / Third-Party Pathfinder RPG Products / Product Discussion / D20PFSRD Spell Filters All Messageboards

Want to post a reply? Sign in.
Recent threads in Product Discussion