Our PFS sessiontracker


Pathfinder Society

401 to 450 of 526 << first < prev | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | next > last >>
The Exchange 3/5

1 person marked this as a favorite.
Someone said wrote:

Don't you know? That is the next database project to be coded in Netherlands: "The Free Time Finder." You type in your name and your schedule and it manufactures an hour of free time plus stroopwafels for you.

Hmm

Is this on Kickstarter? This is the best idea ever. Indiegogo? Please. Gofundme? Can I just start sending money to you?

I do have an in with the Waffle Queen if you can handle the time part.

Nordic Waffles

Hey, you're right, we should have waffles at Skalcon. I'll look into it.

4/5 5/5

Nordic waffles are not stroopwafels!

Scarab Sages Venture-Lieutenant, Netherlands—Utrecht aka Maglok

2 people marked this as a favorite.

*looks up from coding8 hm, stroopwafels!?

Starfinder can wait a bit right?

Scarab Sages 5/5 5/5 Venture-Captain, Netherlands aka Woran

1 person marked this as a favorite.

STROOPWAFELS!!!!!

Scarab Sages Venture-Lieutenant, Netherlands—Utrecht aka Maglok

Dear peeps, is '#1-01 The Commencement' supposed to be a evergreen?

Grand Lodge

Pathfinder Starfinder Adventure Path, Starfinder Society Subscriber
Simon Kort wrote:
Dear peeps, is '#1-01 The Commencement' supposed to be a evergreen?

Yes.

1-02 and 1-03 are not (and level 1-4)

Scarab Sages Venture-Lieutenant, Netherlands—Utrecht aka Maglok

1 person marked this as a favorite.

So I was messing with the search query (it is the last thing I need to update before SFS is in the tracker) and I figured I'd show a little peek under the hood.

This is a average query if you try to find a session with 3 players:

Quote:

SELECT `Scenario`.*,

`authors`.`id` AS `authors.id`,
`authors`.`name` AS `authors.name`,
`authors.j_author_scenario`.`created_at` AS
`authors.j_author_scenario.created_at`,
`authors.j_author_scenario`.`updated_at` AS
`authors.j_author_scenario.updated_at`,
`authors.j_author_scenario`.`author_id` AS
`authors.j_author_scenario.author_id`,
`authors.j_author_scenario`.`scenario_id` AS
`authors.j_author_scenario.scenario_id`,
`players`.`id` AS `players.id`,
`players`.`name` AS `players.name`,
`players`.`pfsnumber` AS `players.pfsnumber`,
`players.played`.`id` AS `players.played.id`,
`players.played`.`scenario_id` AS `players.played.scenario_id`
,
`players.played`.`person_id` AS
`players.played.person_id`,
`players.played`.`pfs` AS `players.played.pfs`,
`players.played`.`core` AS `players.played.core`,
`players.played`.`sfs` AS `players.played.sfs`,
`players.played`.`pfs_gm` AS `players.played.pfs_gm`,
`players.played`.`core_gm` AS `players.played.core_gm`,
`players.played`.`sfs_gm` AS `players.played.sfs_gm`,
`players.played`.`created_at` AS `players.played.created_at`,
`players.played`.`updated_at` AS `players.played.updated_at`,
`players.played`.`deleted_at` AS `players.played.deleted_at`
FROM (SELECT `Scenario`.`id`,
`Scenario`.`name`,
`Scenario`.`description`,
`Scenario`.`type`,
`Scenario`.`season`,
`Scenario`.`number`,
`Scenario`.`tier`,
`Scenario`.`levelrange`,
`Scenario`.`link`,
`Scenario`.`evergreen`,
`Scenario`.`multitable`,
`Scenario`.`game`,
`Scenario`.`archived_at`,
`Scenario`.`created_at`,
`Scenario`.`updated_at`,
`Scenario`.`deleted_at`
FROM `scenarios` AS `Scenario`
WHERE ( ( `Scenario`.`deleted_at` >= CURRENT_TIMESTAMP
OR `Scenario`.`deleted_at` IS NULL )
AND ( `Scenario`.`game` = 'pfs'
AND `Scenario`.`archived_at` IS NULL
AND `Scenario`.`multitable` = 0
AND `Scenario`.`type` IN (
'mod', 'quest', 'ap', 'scenario' )
AND `Scenario`.`id` NOT IN (SELECT `Scenario`.`id`
FROM
`scenarios` AS `Scenario`
INNER JOIN (`j_scenario_person` AS
`players.played`
INNER JOIN `people` AS
`players`
ON `players`.`id`
=
`players.played`.`person_id`
AND ( ( `players.played`.`deleted_at` >=
CURRENT_TIMESTAMP
OR `players.played`.`deleted_at` IS NULL
)
AND `players.played`.pfs IS NOT NULL ) )
ON `Scenario`.`id` = `players.played`.`scenario_id`
AND ( ( `players`.`deleted_at` >= CURRENT_TIMESTAMP
OR `players`.`deleted_at` IS NULL )
AND `players`.`pfsnumber` IN ( 25642, 66024, 710 ) )
WHERE ( `Scenario`.`deleted_at` >= CURRENT_TIMESTAMP
OR `Scenario`.`deleted_at` IS NULL )) ) )
ORDER BY `Scenario`.`season` ASC
LIMIT 0, 15) AS `Scenario`
LEFT OUTER JOIN (`j_author_scenario` AS `authors.j_author_scenario`
INNER JOIN `authors` AS `authors`
ON `authors`.`id` =
`authors.j_author_scenario`.`author_id`)
ON `Scenario`.`id` =
`authors.j_author_scenario`.`scenario_id`
AND ( `authors`.`deleted_at` >= CURRENT_TIMESTAMP
OR `authors`.`deleted_at` IS NULL )
LEFT OUTER JOIN (`j_scenario_person` AS `players.played`
INNER JOIN `people` AS `players`
ON `players`.`id` = `players.played`.`person_id`
AND ( `players.played`.`deleted_at` >=
CURRENT_TIMESTAMP
OR `players.played`.`deleted_at` IS
NULL ))
ON `Scenario`.`id` = `players.played`.`scenario_id`
AND ( ( `players`.`deleted_at` >= CURRENT_TIMESTAMP
OR `players`.`deleted_at` IS NULL )
AND `players`.`pfsnumber` IN (
'25642', '66024', '710' ) )
ORDER BY `Scenario`.`season` ASC;

Apologies for the formatting, I can't find how to make it a monospaced font on the forum. Not a option I guess.

Right back to trying to get the SQL to properly filter SFS and PFS seasons!

4/5 5/5

Simon, you are magnificent!

If I tried really hard I could understand that, I am so glad that I do not have to!

Shadow Lodge 5/5

What witchcraft is this?!

(Thanks for all you do, Simon. ;)

Sovereign Court 4/5 5/5 Venture-Captain, Online—VTT aka Imhrail

Firstly i just want to say thank you for all the work you guys have put into the tracker, its something i've come to depend on for quickly checking what i have and haven't played/run.

I'm not sure if anyone has mentioned it but the module's list seems to organized as parts of The Emerald Spire and intermixed with other modules. Is this intentional or just an unexpected change from working on another part of the tracker?

Scarab Sages Venture-Lieutenant, Netherlands—Utrecht aka Maglok

1 person marked this as a favorite.

Hey,

Just got back from Paizocon UK. :) Was lots of fun.

@Imhrail: It is a 'unintended' side effect. I need to rework the sorting of several queries on the server side. I will try to implement that with the same build of the tracker that implements Starfinder Society tracking.

Managed to talk to Tonya about how to deal with quests. That some are 'in season' and some are not. I am trying to implement those changes in that build as well.

I am aiming to have Starfinder options live before Starfinder goes live, but at least 2 more weeks. :)

Dark Archive Venture-Agent, Ireland—Cork aka Psyblade

Simon Kort wrote:

Hey,

Just got back from Paizocon UK. :) Was lots of fun.

@Imhrail: It is a 'unintended' side effect. I need to rework the sorting of several queries on the server side. I will try to implement that with the same build of the tracker that implements Starfinder Society tracking.

Managed to talk to Tonya about how to deal with quests. That some are 'in season' and some are not. I am trying to implement those changes in that build as well.

I am aiming to have Starfinder options live before Starfinder goes live, but at least 2 more weeks. :)

Awesome news about the starfinder thingy, glad you had a blast at paizocon :D Did Tonya say anything about hiring you to make this a fully paizo thing? :D

Finally...

Congratz to the wonderful news!

Scarab Sages 5/5 Venture-Agent, United Kingdom—England—Thames Valley aka chris manning

the Starfinder scenarios are showing up under PFS season 1?

Grand Lodge 5/5 Regional Venture-Coordinator, Baltic

1 person marked this as a favorite.
Chris Manning wrote:
the Starfinder scenarios are showing up under PFS season 1?

Work in progress, just ignore it for now.

Grand Lodge 5/5 5/55/55/5 Venture-Captain, Online—PbP aka Hmm

I am just happy that they are showing!

Thank you Simon!

Hmm

Scarab Sages Venture-Lieutenant, Netherlands—Utrecht aka Maglok

Yeah the database has them already, it still needs a client patch, which is the one I am working on. :)

Scarab Sages Venture-Lieutenant, Netherlands—Utrecht aka Maglok

Alright if everything is going to work out I am going to update the tracker in the coming hours. It should have starfinder, quests rework, sorting rework and a slew of minor bugs fixed when I am done.

The tracker will not be down, though some functionality might be spotty the coming 6 or so hours. I will post again once I finish deploying (or I decide this is not working and I rollback).

:)

Scarab Sages Venture-Lieutenant, Netherlands—Utrecht aka Maglok

Alright it seems to be up and running!

A note: One small issue I have not been able to fix right now yet is that the 'pathfinder' game will not check itself if you've been on the site before, resulting in you seeing 0 results!

So: If you see 0 results please check the Pathfinder game box (or Starfinder if you're into that).

I will continue to try to fix it, though it is only for clients that've been to the site before.

Oh and let me know if you notice any bugs! I just don't have the time to do a proper testplan, etc. etc. So I do the best I can, but I need some help pointing some bits out.

Dark Archive 4/5

Looks great!

Sovereign Court 4/5 5/5 Venture-Lieutenant, Netherlands—Leiden aka Ascalaphus

Shiny!

2/5 Venture-Agent, Ireland—Dublin aka EJDean

Seems to be an output issue at the moment.

Sending the following parameters:

Quote:


rows:15
page:1
aps:true
game_pfs:true
campaign:pfs
author:Greg A. Vaughan
orderBy:season
order:asc

returns the following JSON

Quote:


{
"count":8,
"rows":[
{
"id":265,
"name":"Carrion Crown: #4 Wake of the Watcher",
"description": // Omitted for brevity
"type":"ap",
"season":"99",
"number":null,
"tier":"9-11",
"levelrange":"09|10|11",
"link":"http://paizo.com/products/btpy8l3e?Pathfinder-Adventure-Path-46-Wake-of-the-Watcher",
"evergreen":false,
"quest":false,
"multitable":false,
"game":"pfs",
"archived_at":null,
"authors":[
{
"id":3,
"name":"Greg A. Vaughan",
"j_author_scenario":{
"author_id":3,
"scenario_id":265
}
}
]
},
{
"id":395,
"name":"Curse of the Crimson Throne: #5 Skeletons of Scarwall",
"description": // Omitted for brevity
"type":"ap",
"season":"99",
"number":null,
"tier":"13-15",
"levelrange":"13|14|15",
"link":"http://paizo.com/products/btpy83yw?Pathfinder-11-Curse-of-the-Crims on-Throne-Chapter-5-Skeletons-of-Scarwall",
"evergreen":false,
"quest":false,
"multitable":false,
"game":"pfs",
"archived_at":null,
"authors":[
{
"id":3,
"name":"Greg A. Vaughan",
"j_author_scenario":{
"author_id":3,
"scenario_id":395
}
}
]
}
]
}

Sending the following parameters only returns three results:

Quote:


rows:15
page:1
levels[]:01
aps:true
game_pfs:true
campaign:pfs
orderBy:season
order:asc

Scarab Sages Venture-Lieutenant, Netherlands—Utrecht aka Maglok

I will look into this, thanks for the really exact debugging info.

Sczarni 3/5

Perform (Happy Dance): 1d20 + 37 ⇒ (12) + 37 = 49

Scarab Sages Venture-Lieutenant, Netherlands—Utrecht aka Maglok

Aight I looked into it. There seems to be an issue when you filter on author. Still trying to fix it.

That said the 2nd example you gave is correct. There are only three AP volumes that are sanctioned for level 1 play.

Silver Crusade 4/5 5/55/55/5 RPG Superstar 2013 Top 8

The module Heroes for Highdelve is sanctioned for PFS play (1-2 chronicle) but does not appear on the list of modules.

Also I'm sure that you are aware but Season 9 doesn't seem to be available. I'm just mentioning it on the off chance that you are not aware.

Thanks again!

Scarab Sages Venture-Lieutenant, Netherlands—Utrecht aka Maglok

1 person marked this as a favorite.

Good points Michael, I will add them monday! :)

2/5 Venture-Agent, Ireland—Dublin aka EJDean

Simon Kort wrote:

Aight I looked into it. There seems to be an issue when you filter on author. Still trying to fix it.

That said the 2nd example you gave is correct. There are only three AP volumes that are sanctioned for level 1 play.

Ah yes, I realised the other day that most APs' first book has a tier 2–4 chronicle sheet.

Scarab Sages Venture-Lieutenant, Netherlands—Utrecht aka Maglok

5 people marked this as a favorite.

Aight! Heroes for Highdelve added, season 9 options added, first four scenarios added for season 9 (beware: you need to check multitable specials to see the special in the search page).

The bug with author names is quite a nasty one and I am trying to fix it still.

Also about to introduce a option on the filters that selects 'pre-gen' scenarios only.

Grand Lodge 2/5

Hi There...
I went to record my recent GM session for PFS... a running of 9-04.... But this scenario (or 9-05, 9-06 or 9-07) aren't listed.

9-04 and 9-05 are released.
9-06 and 9-07 are announced.

ANy idea what the ETA is for them to be added?

9-04 The Unseen Inclusion
9-05 Call of the Copper Gate
9-06 The Shores of Heaven
9-07 Salvation of the Sages

Scarab Sages Venture-Lieutenant, Netherlands—Utrecht aka Maglok

Odd I did add them. They must not have the correct flag set. I will look into it, gonna try to have that fixed today.

Scarab Sages Venture-Lieutenant, Netherlands—Utrecht aka Maglok

2 people marked this as a favorite.

Alright... so that was totally my bad. I... added the scenarios to a old (very old) database copy. I apparantly never checked to see if they worked on the live site.

They should now be available for reporting and searching!

Thanks Karpana.

5/5 Venture-Agent, Netherlands—Utrecht aka Quentin Coldwater

The tracker seems to be down. I checked here if I missed a post about maintenance, but apparently not.

Scarab Sages Venture-Lieutenant, Netherlands—Utrecht aka Maglok

Yeah this is not planned. I am on it. Server is just fine, so it has to be something else. Will keep posted.

My host did have some maintenance, looking into it.

EDIT: A reboot did it. Still going to look into why it was not working properly, but for now it should be working. Let me know if anything is wrong though.

Scarab Sages Venture-Lieutenant, Netherlands—Utrecht aka Maglok

Just a small update. All new content was added a while ago. If you see anything missing please post or contact me in PM (or email).

I've been really busy, but I intend to code some new features and optimizations in the tracker in a month or so.

Carry on! :)

5/5

I know there was some sort of php or java script thing that would export your play history from paizo and subsequently import it into pfstracker - is that still working (after the format change a few months back), link? I can't find it now.

Grand Lodge 5/5 5/55/55/5 Venture-Captain, Online—PbP aka Hmm

Ooh... I would love that! I keep forgetting to enter scenarios.

Hmm

5/5

Starfinder Superscriber

Howdy! Thanks for the great tool. I just started using it for Starfinder.

Two notes/issues that I ran into:
1-00: Claim to Salvation is missing.
Quest: Into the Unknown is repeatable/evergreen.

Scarab Sages Venture-Lieutenant, Netherlands—Utrecht aka Maglok

@majuba & HMM: It has never worked yet, but I got a code update from the javascripter. I would need to code the import part of it. It is on my list.

@MikeKn: Claim to Salvation is in there, it is a multitable though. So in the search page you need to check 'include multitable specials' :) As for Into the Unknown, I'll toggle that to Evergreen in a day or two, thanks for that. :)

4/5 5/5

Simon: Claim to Salvation is not a multiparter.

Scarab Sages Venture-Lieutenant, Netherlands—Utrecht aka Maglok

1 person marked this as a favorite.

Some content was added again.

There was also a bit of downtime due to the hosting having a problem. This downtime was at max 2 hours and the tracker is fully back up and running.

4/5 5/5

4 people marked this as a favorite.

We are not saying this enough: your tool is so amazingly useful!

We scrambled this week to make our tables happen and thanks to the tracker it took almost no time to come up with a way to split 8 players between two tables and decide on scenarios.

Thanks!

Sovereign Court 2/5 5/5 Venture-Captain, Mexico—Guadalajara aka KhaozKnight

So I'll ask here because I haven't found a way to do it, is there a way to search for a GM and see only the Scenarios s/he hasn't run?

I'd also like to add my voice to the list of grateful users =)

Scarab Sages Venture-Lieutenant, Netherlands—Utrecht aka Maglok

@Magabeus: no probs! Just don't have as much time to integrate new features lately.

@Ricardo: Hm, not directly. You could, however, just make the GM a player and see... though no that also doesn't add up. Uhm 'no' is the official answer. :) Sorry.

Sovereign Court 2/5 5/5 Venture-Captain, Mexico—Guadalajara aka KhaozKnight

Thanks for the reply Simon! So my google-fu wasn't weak, the answer was nowhere to be found =P

2/5

I'm almost certainly not the first one to request this, but is it possible to have a "Always Show Evergreens" toggle on the search result page?

Knowing how many people played which evergreen helps as a "last resort" for a table full of veterans.

Scarab Sages Venture-Lieutenant, Netherlands—Utrecht aka Maglok

1 person marked this as a favorite.

- Added up to and including scenario 9 for Starfinder.

Going to be adding the Starfinder tag to characters and add the Starfinder factions as options for that soon as well.

@Ricardo: NP, sorry. :)
@SanderJK: Actually not heard that one before I think. The evergreen toggle is not really working properly anyway, so I can keep this in mind when I fix it to make sure it can do what you are asking. Good idea!

Best wishes for 2018 peeps!

Sovereign Court 4/5 5/5 Venture-Lieutenant, Netherlands—Leiden aka Ascalaphus

SanderJK wrote:

I'm almost certainly not the first one to request this, but is it possible to have a "Always Show Evergreens" toggle on the search result page?

Knowing how many people played which evergreen helps as a "last resort" for a table full of veterans.

Yes, it's actually kinda odd to filter them out by default.

Scarab Sages Venture-Lieutenant, Netherlands—Utrecht aka Maglok

I don't filter them out by default, it always includes them by default (or at least it should).

Scarab Sages 5/5 5/5 Venture-Captain, Netherlands aka Woran

It looks like its not working properly. If someone played an evergreen it filters them out as if played like normal content.

Grand Lodge 5/5 Regional Venture-Coordinator, Baltic

Tineke Bolleman wrote:
It looks like its not working properly. If someone played an evergreen it filters them out as if played like normal content.

Actually, that's the way I like it. I can remember everyone can always play evergreens, but I can't remember everyone who already played it and preferably doesn't want to repeat it.

401 to 450 of 526 << first < prev | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | next > last >>
Community / Forums / Organized Play / Pathfinder Society / Our PFS sessiontracker All Messageboards