In Pathfinder 2, is non-physical damage calculated separately from physical damage for a single attack?

One of the players in my game is playing a dragon instinct barbarian. The GM is calculating the elemental damage separately from the weapon damage for resistance purposes (i.e. an axe attack deals 8 slashing and 4 cold, which is broken into two different damage groups.) Is this correct, or should this be counted as a single group (12 damage)?

Draconic Rage (Instinct Ability) While raging, you can increase the additional damage from Rage from 2 to 4 and change its damage type to match that of your dragon’s breath weapon instead of the damage type for your weapon or unarmed attack. If you do this, your Rage action gains the arcane and evocation traits, as well as the trait matching the damage type.

Dragon Instinct: https://2e.aonprd.com/Instincts.aspx?ID=2

Any way to create sitemap for Single Page Website?

I am facing issue on indexing my Single Page Website. Anyway to create a dynamic sitemap for Single Page website. My site about affiliate marketing. Have multiple categories & pages & we update almost 200 post daily. When we use any xml sitemap generator or screening frog software there showing only 1 page which is my domain. I know why showing one link only. Because we used single page framework. Just wanted to know anyway to create sitemap for categories and stores? or latest post.

Does the Beast Master’s Primal Companion feature allows the beast to take two Actions in a single turn?

I watched a video from Dungeon Dudes on YouTube where they rated the Ranger subclasses. Around the 23:18 mark, they mentioned that the new Beast Master’s Primal Companion feature from Tasha’s Cauldron of Everything can allow the Ranger to forgo one of their attacks to allow the Beast to take the Attack action, on top of the action that they can make using the Ranger’s bonus action. The Primal Companion feature description says the following:

Primal Companion

[…]
In combat the beast acts during your turn. It can move and use its reaction on its own, but the only action it takes is the Dodge action, unless you take a bonus action on your turn to command it to take another action. That action can be one in its stat block or some other action. You can also sacrifice one of your attacks when you take the Attack action to command the beast to take the Attack action. If you are incapacitated, the beast can take any action of its choice, not just Dodge.
[…]

As far as I know, a creature can only take one action on their turn. Is this a specific ruling for the Primal Companion since it doesn’t have its own turn because "it acts on your [the Ranger’s] turn?" Also does this mean that the Ranger can break up their movement, actions, and bonus actions with the Beast’s on their turn, essentially controlling two characters freely? In the video, Monty mentioned that a level 11 Beast Master Ranger can make one attack and have the beast attack four times which is crazy in my opinion.

Split data across multiple rows in a single statement

I have data in table like

Customer Invoice No Date Value Paid Balance
ABC 1 01/12/2020 25 0 25
ABC 2 01/12/2020 50 0 50
XYZ 3 02/12/2020 200 0 200
XYZ 4 04/12/2020 100 0 100
ABC 5 04/12/2020 500 0 500

Now I received amounts for customers as below

ABC 540 XYZ 210

ABC XYZ
540 210

After receiving the amounts my table should like this

Customer Invoice No Date Value Paid Balance
ABC 1 01/12/2020 25 25 0
ABC 2 01/12/2020 50 50 0
XYZ 3 02/12/2020 200 200 0
XYZ 4 04/12/2020 100 10 90
ABC 5 04/12/2020 500 465 35

I got some clues but this works only for date based values but I need customer and date based.

Any help will be appreciated

pg_restore importing single table to a file

I have a backup in directory format taken with pg_dump.

When I try to export single table from this dump with the command:

pg_restore -Fd mydirectory -t sometable > table.sql  

I get the error :

pg_restore: error: one of -d/--dbname and -f/--file must be specified. 

When I read the document if no -d parameter passed pg_restore should print the output to stdout.

What I am missing?

Cross Domain Tracking with Multiple GA UA Properties, Single GTM Container

I have a client who wants to route page views into separate GA Properties based off a returnUrl UTM. I am trying to configure this in one tag using one GTM container. I know that using cookies for Analytics is changing rapidly and I am having trouble getting everything set up.

Here’s how I have it configured currently:

returnUrl Trigger: enter image description here

That trigger fires a Page View tag configured like so: enter image description here

GTM Preview Fires Everything Correctly, and the Tracking Values are correct: enter image description here

I have added the original domain to Referral Exclusion Lists on each GA Property for the returnUrl domains. But I am not getting page views.

Google Tag Assistant is giving an error of "No HTTP response detected" for the Analytics UA-ID (which is correct).

I’ve seen a lot of different blog posts and tried implementing a few. But I’d like to solve this as quickly and smoothly as possible. I appreciate the help!

Blog posts used:

https://www.simoahava.com/analytics/troubleshooting-cross-domain-tracking-in-google-analytics/

https://www.directom.com/cross-domain-tracking-google-tag-manager/

This post I have looked at but it looks like a lot more Tags / Triggers are involved. Before I bite this off I want to see if there’s a way to save this configuration.

https://www.simoahava.com/analytics/cookieless-tracking-cross-site-iframes/

Thanks for looking!

Does a Spell Gem Reduce the Casting Time of Any Imbued Spell to a Single Action? [duplicate]

In my Out of the Abyss game the party has acquired a spell gem. Their first use of it with a spell they imbued was to cast Prayer of Healing (casting time: 10 minutes) in the middle of a battle with a Demon Queen. I was fine with this, as I remembered the usage time for a Spell Gem being 1 Action.

However, one of the players (a GM himself) said, “That cannot be right, the casting time shouldn’t change.” So we checked exact wording after the session. (And compared it to a Ring of Spell Storing for good measure.)

While holding the gem, you can cast the spell from it as an action if you know the spell or if the spell is on your class’s spell list. Doing so doesn’t require any components and doesn’t require attunement.

(Emphasis mine.)

That seems pretty straightforward. It is limited to casters who would have access to the spell (unlike Ring of Spell Storing), but only a single action. Perhaps Prayer of Healing should not have been allowed to be cast into the gem in the first place?

You can imbue the gem with a spell if you’re attuned to it and it’s empty. To do so, you cast the spell while holding the gem. The spell is stored in the gem instead of having any effect. Casting the spell must require either 1 action or 1 minute or longer, and the spell’s level must be no higher than the gem’s maximum.

(Emphasis mine.)

That seems quite clear that a Prayer of Healing is able to be cast into a Spell Gem. In fact, I believe it means any spell that is not cast as a Reaction or Bonus Action, since I am not aware of any spell with a casting time of more than an Action but less than 1 minute.

This sent the player off to query D&D Beyond for spells they would not normally be able to cast in the middle of a battle, and specifically (because of the thrashing they had just taken) Hallow, Planar Binding, and Glyph of Warding.

That did give me pause when we read it, and made me wonder if RAW were not exactly RAI. But while I might argue that the target would need to be in range for the duration of the initial cast for Planar Binding, I don’t think that’s RAI. And of those three mentioned, I think only Hallow would have had a large impact on the battle they just lost.

So perhaps it is not so destabilizing as I first thought. Do you think RAW are RAI (or did we misinterpret them somehow?)

How to avoid killing player characters due to a single (un)lucky roll?

Especially at low levels, Pathfinder characters can usually be killed easily by a single enemy attack, provided the dice fall in said enemy’s favor. An example:

The PC has a constituion score of 10 (modifier +0) and 8 HP

The enemy is of medium size, has a strength score of 14 (modifier +2) and is wealding a quarterstaff (obviously two-handed, as a quarterstaff is a two-handed weapon)

On a hit, the enemy deals 1d6+3 damage. On a critical hit (×2 for the quarterstaff), they can hence deal up to a maximum of 18 damage, which would kill the PC immediately with a single attack! There is no way for a healer to interfere, the character will die at once.

I believe stats as described above are neither unrealistic for a PC at level 1, nor for an enemy they might encounter. However, I recently ran a one-shot that almost resulted in TPK within 30min due to two critical hits the enemies got in early on, killing two of the PCs and thus changing action economy massively in their favor.

How can I avoid that without pulling off some Deus ex Machina stunt?

To be clear about this: I always make sure in session 0 that everyone knows PC death is possible (and so far players have always agreed to it). But even knowing that, it really puts a damper on everyone’s mood if a character the player possibly spent hours on creating dies in session 1 because of a single attack by a generic enemy.

Simply fudging the enemies rolls is not really a possibility, since I’m using Roll20 for my games at the moment and all players are able to see my rolls (including modifiers) once made. There is the possibility to hide rolls from players (which I sometimes use for opposed checks), but I would prefer not to do that for all attack/damage rolls just to be sure, because that already implies I intend to fudge a roll at some point (which I probably would in said situation, but I’d prefer players not to think about that constantly).

While this question might seem related, the problem at hand is not encounter balance (as pointed out above), but dealing with the risk of a balanced enemy killing a player due to (bad) luck.