|
| 1 person marked this as a favorite. |
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.
Hey, you're right, we should have waffles at Skalcon. I'll look into it.
|
| 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:
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!
|
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?
|
|
| 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. :)
|
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!
|
|
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).
:)
|
|
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.
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!
|
|
| 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.
|
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
|
|
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.
|
|
@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. :)
|
|
| 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!
Venture-Lieutenant, Netherlands—Leiden
|
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.
|
Regional Venture-Coordinator, Baltic
|
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.