chopswil's page

Goblin Squad Member. RPG Superstar 6 Season Dedicated Voter, 7 Season Star Voter. Organized Play Member. 2,838 posts. No reviews. 1 list. No wishlists.


RSS

1 to 50 of 2,838 << first < prev | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | next > last >>
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.

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

Dark Archive

2 people marked this as a favorite.

for those who may be interested i've put RA and Lost City of Barakus monsters and stuff into my DBs
I'm currently work on Tsar right now.

links

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

Dark Archive

2 people marked this as a favorite.

a sweet, year long tan

Dark Archive

3 people marked this as a favorite.

Planar AP where the adventure starts and stays in the planes

Dark Archive

if I'm logged into paizo, i get the error
when I'm logged out, no error

this happens on both chrome and firefox

Dark Archive

when i'm logged in and go to https://paizo.com/store/pathfinder/adventures/adventurePath
i get the "you have reached this page due to an error" message

when i'm NOT logged in i have no problems

when i log out after seeing the error and go to the page it works

this happens to me on both firefox and chrome

Dark Archive

Mudfoot wrote:

It's still on PF SRD: here. Click on Open in a new window for best results. Under the skin it may or may not be the same as chopswll linked to.

that's not my DB, they may have used it as a base for removing paizo IP

some DBs there are still mine, like NPC and Magic Items

Dark Archive

J. A. wrote:

Can anyone point me towards a comprehensive monster listing that allows filtering by monster type?

Apparently there used to be something call the Advanced Monster Search on D20PFSRD, but that seems to be long gone. AonPRD has a resource for 2E, but I can’t find a filter-able version for 1E.

Does anything like this still exist?

the Advanced Monster Search used my data

link to the spreadsheets are below
type is a separate field that you can sort on

npc link
Bestiary link

Dark Archive

darth_borehd wrote:
chopswil wrote:

i have all the pregens in the NPC DB

use the css file with the fulltext field to have an html pathfinder styled text

npc https://drive.google.com/open?id=1PkEkEcf4UbzCb-kISnvAvOGWcuDzwvAMaVG25sD1C Qc
PF css https://drive.google.com/open?id=1yVmAcW_o8kEhbLwJGh4vUZ0sIOx2-cVb5EfilmWmj m4

Neither of those links work.

i keep forgetting that paizo message boards adds a space in the links

npc link
PF css link

Dark Archive

i have all the pregens in the NPC DB
use the css file with the fulltext field to have an html pathfinder styled text

npc https://drive.google.com/open?id=1PkEkEcf4UbzCb-kISnvAvOGWcuDzwvAMaVG25sD1C Qc
PF css https://drive.google.com/open?id=1yVmAcW_o8kEhbLwJGh4vUZ0sIOx2-cVb5EfilmWmj m4

Dark Archive

it is with a heavy heart that i need to cancel my Adventure Path subscription and give up my "Adventure Path Charter Subscriber" status

Dark Archive

ah, Gorbacz and Errata threads always a fun combo

Dark Archive

1.7.4 (8/15/2019): "Local Service API" does what exactly?

Dark Archive

from my google docs
downlaod either Bestiary or npc as excel
there is a subtype field, do a wildcard for reptilian
the PF.css file can be used with the full text field to give html with a pathfinder style

Feats https://drive.google.com/open?id=1XqQO21AyE2WtLwW0wSjA9ov74A9tmJmVJjrhPK54J HQ
magic item https://drive.google.com/open?id=1NQhHjDXhvFZkMiu09epBXsVwCI6YENg-AUQhF-v5n tU
spells https://drive.google.com/open?id=1cuwb3QSvWDD7GG5McdvyyRBpqycYuKMRsXgyrvxvL FI
npc https://drive.google.com/open?id=1PkEkEcf4UbzCb-kISnvAvOGWcuDzwvAMaVG25sD1C Qc
Bestiary https://drive.google.com/open?id=1O4SqVx0yvq6P8AH7-aW9jvUs-CQjbu8Gi7-HVDKT0 tw
affiliations https://drive.google.com/open?id=1UZPevl9F50sOeug_-B16o-iT1HjwVUQiEVE_iP8oq Yk
PF css https://drive.google.com/open?id=1yVmAcW_o8kEhbLwJGh4vUZ0sIOx2-cVb5EfilmWmj m4

Dark Archive

ohh, waaaayy at the bottom it says it's been added but not available for download

maybe have messages like this at the top?
i've got a lot's of pdfs in my digital content

Dark Archive

got an email about tyrant's grasp #6 and age of ashes #1 being in my downloads

age of ashes isn't there

Dark Archive

Wanted: hard core planar AP

Dark Archive

as the content expands with more backers, will the Bestiaries expand too?

maybe some kinda of pdf supplement if you don't want to expand the page count/cost of the Bestiaries...

Dark Archive

update to date spell list that you can filter by spell descriptor?
here you go

spells link

Dark Archive

given the success of Kingmaker, how about doing the same for Legacy of Fire?

"Howl of the Carrion King" was always one of my favorites and maybe now there could be a better ending to the AP...

Dark Archive

Jeff Alvarez wrote:
chopswil wrote:
Rysky wrote:
Yep :3
no, i'm talking about the "Kingmaker 10th Anniversary Campaign"

Hey chopswil, currently the Kingmaker AP only exists as the original releases in 1E. The crowdfunding is our first attempt at compiling the info like we have with Rise of the Runelords and Curse of the Crimson Throne.

The main AP release will be in 2E and then we will have Bestiaries in both 1E and 5E as added support for the 2E version to allow play in those other two systems.

so by "Bestiary" you mean a conversion of the monster/NPC stat blocks in the new "Kingmaker 10th Anniversary Campaign" AP to 1e and not a Bestiary that is new monsters?

Dark Archive

Rysky wrote:
Yep :3

no, i'm talking about the "Kingmaker 10th Anniversary Campaign"

Dark Archive

1 person marked this as a favorite.

is there a pathfinder 1e version of the actual AP itself available?

if there are add-ons and other products in Pathfinder 1e, you would think there wold be a 1e version of the AP.

Dark Archive

search for "Vecna Lives!" and see what people thought about that module

Dark Archive

here is the spell DB that kyle uses for CombatMaanger
use css file in conjunction with the fulltext field to get pathfinder styled html

plenty of stuff to sort on

spells https://drive.google.com/open?id=1cuwb3QSvWDD7GG5McdvyyRBpqycYuKMRsXgyrvxvL FI
PS css https://drive.google.com/open?id=1yVmAcW_o8kEhbLwJGh4vUZ0sIOx2-cVb5EfilmWmj m4

Dark Archive

I was asking more on the rules for the stat block itself

other pathfinder stat blocks have rules on what goes where, but it seems intelligent items do not for the statistics section.

that's what i'm looking for

Dark Archive

magnuskn wrote:
Thanks, man, very very much appreciated! :)

but i'm not going to do any pathfinder 2e, it stops with 1e

Dark Archive

1 person marked this as a favorite.
magnuskn wrote:

Thanks for the update! :)

Can we expect an NPC update for Return of the Runelords and Tyrant's Grasp after Tyrant's Grasp is done? I really appreciate your work (and bought the app for my smartphone months ago).

i do the databases that kyle uses

i've completed Return of the Runelords and i've done the 1st Tyrant's Grasp AP

i'll publish this soon, it's up to kyle to import this data.

I'm also working on Rappan Athuk and plan to do a bunch of other frog god products too

Dark Archive

for intelligent magic items is there a guide for the Statistics part of the stat block?

what's required?

the difference between Senses vs Communication seems a little blurred to me, sometimes it seems telepathy goes in Senses others it's Communication.
what's the distinction?

thanks

Dark Archive

1 person marked this as a favorite.

how about Vudra?

Dark Archive

what would be the equivalent of myconid in pathfinder?

i know there is Myceloid from B3.

i'd prefer a more neutral, whimsical version than an enslave you, eat you kind of version.

Dark Archive

can we get these added, please?

Dark Archive

GRIM HELM p. 64

price 48,000 gp but cost 2,400 gp?

guessing price of 4,800 gp

Dark Archive

Gorbacz wrote:
David knott 242 wrote:
Gorbacz wrote:
It's been what, 5 years and you guys are still bitter about how one adventure in one AP treated a fictional character? Gee, I wonder how do actual real-life slights go down with you.

Well, most real life people who offended me 5 years ago have either gone away and been forgotten by me or have done nicer things since then to improve my opinion of them.

As a fictional character, Iomedae has done neither of those things.

So if I dress up as Iomedae and appear at your doorstep and say that I'm sorry, will that count?

kinda like deadpool and beckham?

Dark Archive

from my spells DB where the phrase "be made permanent" appears

name source
Alarm PFRPG Core
Alter River People Of The River
Animate Objects PFRPG Core
Anthropomorphic Animal Ultimate Magic
Appearance Of Life Horror Adventures
Arcane Sight PFRPG Core
Arcane Sight, Greater PFRPG Core
Aura Sight Advanced Class Guide
Cloud Of Seasickness AP 55
Comprehend Languages PFRPG Core
Corpse Lanterns Pathfinder Society Field Guide
Create Mindscape Occult Adventures
Create Mindscape, Greater Occult Adventures
Curse Terrain, Lesser Horror Adventures
Dancing Darkness Blood Of Shadows
Dancing Lantern APG
Dancing Lights PFRPG Core
Darkvision PFRPG Core
Decrepit Disguise Occult Adventures
Detect Magic PFRPG Core
Enchantment Sight Heroes Of The High Court
Enlarge Person PFRPG Core
Ghost Sound PFRPG Core
Gust Of Wind PFRPG Core
Invisibility PFRPG Core
Invisibility Alarm Advanced Class Guide
Loathsome Veil Ultimate Magic
Lost Locale Inner Sea Races
Lost Passage Inner Sea Races
Mage's Private Sanctum PFRPG Core
Magic Fang PFRPG Core
Magic Fang, Greater PFRPG Core
Magic Mouth PFRPG Core
Obscured Script Adventurer's Guide
Permanency PFRPG Core
Phase Door PFRPG Core
Planar Refuge Heroes Of The Wild
Preserve Inner Sea Temples
Prismatic Sphere PFRPG Core
Prismatic Wall PFRPG Core
Read Magic PFRPG Core
Recorporeal Incarnation Inner Sea Intrigue
Reduce Person PFRPG Core
Resistance PFRPG Core
Sanctify Corpse Ultimate Magic
See Invisibility PFRPG Core
Shrink Item PFRPG Core
Solid Fog PFRPG Core
Soul Vault Inner Sea Temples
Speechreader's Sight Heroes Of The High Court
Stinking Cloud PFRPG Core
Stolen Light Pathfinder Society Field Guide
Symbol of Death PFRPG Core
Symbol of Healing Ultimate Magic
Symbol Of Laughter Advanced Class Guide
Symbol of Mirroring Ultimate Magic
Symbol of Revelation Ultimate Magic
Symbol of Scrying Ultimate Magic
Symbol of Slowing Ultimate Magic
Symbol of Strife Ultimate Magic
Symbol Of Striking Ultimate Combat
Symbol of Vulnerability Ultimate Magic
Telepathic Bond PFRPG Core
Teleport Trap Inner Sea World Guide
Teleportation Circle PFRPG Core
Tongues PFRPG Core
Wall Of Fire PFRPG Core
Wall Of Force PFRPG Core
Wall Of Light The Dragon's Demand
Web PFRPG Core
Yellow Sign AP 110

Dark Archive

Cevah wrote:

Linkified:....

/cevah

a lot less messy, thanks ;)

Dark Archive

1 person marked this as a favorite.

links to my DBs
FYI the spell DB has been updated since dec 2017
the css file can be used with the fulltext fields to give you pathfinder styled html

Feats https://drive.google.com/open?id=1XqQO21AyE2WtLwW0wSjA9ov74A9tmJmVJjrhPK54J HQ
magic item https://drive.google.com/open?id=1NQhHjDXhvFZkMiu09epBXsVwCI6YENg-AUQhF-v5n tU
spells https://drive.google.com/open?id=1cuwb3QSvWDD7GG5McdvyyRBpqycYuKMRsXgyrvxvL FI
npc https://drive.google.com/open?id=1PkEkEcf4UbzCb-kISnvAvOGWcuDzwvAMaVG25sD1C Qc
Bestiary https://drive.google.com/open?id=1O4SqVx0yvq6P8AH7-aW9jvUs-CQjbu8Gi7-HVDKT0 tw
affiliations https://drive.google.com/open?id=1UZPevl9F50sOeug_-B16o-iT1HjwVUQiEVE_iP8oq Yk
PF css https://drive.google.com/open?id=1yVmAcW_o8kEhbLwJGh4vUZ0sIOx2-cVb5EfilmWmj m4

Dark Archive

Archimedes The Great wrote:
... That database is a mess though.

which database?

if you're referring to the DBs on d20pfsrd, which i compiled the info for, I'd like to know how they could be better.
Less of a mess as it were.

Dark Archive

i just entered information for my new debit card, totally different from my other one that i have used before for purchases.

how to i now use this new debit card to process my orders?

thanks

Dark Archive

it's time

Dark Archive

and it WAS a trap

Dark Archive

so is "One File Per Chapter" dead?

Dark Archive

thank you
it worked

Dark Archive

the title for my down load has this
No AP Number and plague isn't capitalized

PathfinderAdventurePathRuneplagueReturnOfTheRunelords3Of6PDF-OneFilePerChap ter

Dark Archive

my debit card expired and i just entered a new expiration date, can you re-run it, please?

also, an email saying the payment didn't go though would have been nice

Dark Archive

how are you supposed to login now? it used to be in the upper right hand corner, now nothing

Dark Archive

Zaister wrote:

...

Considering this it's suspiciously quiet with the "I need the player's guide right now, I'm starting this yesterday!" crowd. :-)

...too quite [queue dramatic music]

Dark Archive

1 person marked this as a favorite.
AdamWintle wrote:

I've just been looking for a Pathfinder Bestiary/Monster database/spreadsheet and couldn't find anything online. Did you manage to build anything like this in the end?

I know d20pfsrd.com has all the monsters, but its not exactly a database/spreadsheet app.

I'm a web developer and programmer and would be interested in building something like this. Drop me an email to me@adamwintle.com if you ant to discuss the idea :)

spreadsheet with all the bestiaries and AP monsters

google doc link