MySql SRD?


Pathfinder First Edition General Discussion

Sovereign Court

Howdy all! I'm a long-time 3.5E player and author (don't Google it, it's all been Homebrew), now stepping into PF1.0 with my player group.

I've a copy of the 3.5E SRD in MySql that I loaded to query for pretty much anything you can think of in writing and playing adventures.

Is there a PF1.0 SRD MySql Database that I could snag a copy of and load to my server for the same purposes?

And yes, I know about the d20pfsrd website, but I like to do work off-line in my cabin remotely tucked into the wooded mountain where I have no internets or WiFi's or any other connectivity.

Thanks in advance!!!


Your best bet is probably to scrape the Archives of Nethys for the data. You could try to ask the admin of that site for a copy of the database, but I doubt he hands those out.

Dark Archive

9 people marked this as a favorite.

i do the Dbs on d20pfsrd

below are links to the data
this data is just exported from my sql server db to excel
if you want the create table scripts let me know
chopswil at gmail dot com

Feats link
magic item link
spells link
npc link
Bestiary link
affiliations link
PF css link


.


chopswil wrote:

i do the Dbs on d20pfsrd

below are links to the data

Wow, thanks a lot.

Dark Archive

in each DB there is a field called FullText or Full_Text.
this is formatted html data and you can use the PF.css file to get pathfinder styling/look to the html.

steps for html display

1) download the DB excel file and the css file
2) open the DB excel file
3) open a new notepad file
4) in the excel file find and entry you want to see with the paizo pathfinder display
5) scroll to the right until you find a column called either fulltext or full_text (i was not consistent on naming)
6) click on the cell for the fulltext data column and the row of the data item you want.
** side note: rows go across from left to right, columns go up and down and the intersection of the two is a cell, e.g. if you pick row 2 and column K you have picked cell K2
7) in the formula bar you should have the data in the cell you select for fulltext, it should start with <link rel=''stylesheet". click in this formula bar and type Ctl-A, this should select all the text in the cell
8) then do a Ctl-C, this should copy all this text into the clipboard.
9) in your notepad file from step #3 paste this text, Ctl-v. You should see the text from the cell now in notepad.
10) on the Notepad's menu bar click File and then Save As, a save as dialog should popup.
11) **slightly trick part** in the File Name type "Name.html" You need double quotes and both front and end. instead of Name you can put what ever you want. I always name the file whatever is in the name column. for example "Orc Chief.html"
12) make sure you are saving this new html file in the same folder as the css file and click Save
13) go to the folder where the new html file is and double click, it should open in your browser with the pretty paizo styling.

Sovereign Court

Good News Everyone!

Thanks to chopswil, I was able to get the SQL Server Extracts converted over to MySql table creates and inserts and got a database built finally this week. I am now writing views, stored process, and functions on the database to make my life as an author a little easier.

Once I get done, if it is allowed, I'll see if I can create a MySQL transactional extract dump that wraps everything up in case someone else might want to play with it someday.

One thing I did note:

There is no "player" information in these files. No "races", "classes", or "skills" basic data. I've got ALL the monsters, the feats, the spells the magic items, and the afflictions.

Is there anyone, or any way, that that could be made available?

Community / Forums / Pathfinder / Pathfinder First Edition / General Discussion / MySql SRD? All Messageboards

Want to post a reply? Sign in.