
![]() |

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!)

taepodong |

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.

Kolokotroni |

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.

![]() |

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 :)

![]() |
chopswil wrote:Thank you for the great work on the Spell DB. It's especially useful if you need more advanced filtering/sorting options.don't forget your old friend Spell DB [sniff]
download as excel and sort to your heart's content
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...

![]() |

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.

![]() |
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

jreyst |

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.

![]() |
chopswil wrote: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.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'm open to ways of "cleaning up" the data and issues that people find