Can a simulacrum be healed by any means other the ‘complex process’ outlined in the spell?

Inspired by another discussion of Simulacra – can a simulacrum actually heal via any method other than the ‘complex process’ outlined in the spell? Or is that process simply another option? What if the copied creature type has Fast Healing, or Regeneration? Do Cure Wounds spells function on the simulacra? Is the simulacrum actually even a creature?

Can the alarm spell be detected by mundane means such as a normal perception check?

The alarm spell in the players handbook reads as follows:

You set an alarm against unwanted intrusion. Choose a door, a window, or an area within range that is no larger than a 20-foot cube. Until the spell ends, an alarm alerts you whenever a Tiny or larger creature touches or enters the warded area. When you cast the spell, you can designate creatures that won’t set off the alarm. You also choose whether the alarm is mental or audible. A mental alarm alerts you with a ping in your mind if you are within 1 mile of the warded area. This ping awakens you if you are sleeping. An audible alarm produces the sound of a hand bell for 10 seconds within 60 feet

Are there any examples in officially published modules or rulings, errata etc. that indicate whether the alarm spell is visible via a perception check vs the spells DC or whether the spell is invisible and must be detected through a spell such as detect magic or find traps?

Does flying while polymorphed into a flying creature count as flying by magical means for the purposes of blizzards?

Icewind Dale is a nasty place, where blizzards frequently turn the frozen wastes into an untraversable nightmare. One of the rules for blizzards included in Icewind Dale: Rime of the Frostmaiden makes flying nearly impossible:

The wind extinguishes open flames, disperses fog, erases tracks in the snow, and makes flying by nonmagical means nearly impossible. A creature falls at the end of its turn if it is flying by nonmagical means and can’t hover.

Suppose I use polymorph to change into a giant eagle. Does flying as this giant eagle count as flying by magical means?

ERROR 1064 (42000): You have an error in your SQL syntax – Cannot understand what the error means

I’m trying to import an SQL db, exported from another place. I have the SQL create script. I am not sure what might be going wrong…

My mariadb version is

select version(); +----------------+ | version()      | +----------------+ | 10.5.8-MariaDB | +----------------+ 1 row in set (0.000 sec) 

Table create script:

-- phpMyAdmin SQL Dump -- version 5.0.4 -- -- -- Host: db -- Generation Time: Jan 04, 2021 at 05:59 PM -- Server version: 8.0.22 -- PHP Version: 7.4.11  SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00";   /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */;  -- -- Database: `mytestdb` -- CREATE DATABASE IF NOT EXISTS `mytestdb` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci; USE `mytestdb`;  -- --------------------------------------------------------  -- -- Table structure for table `categories` --  DROP TABLE IF EXISTS `categories`; CREATE TABLE `categories` (   `id` int NOT NULL,   `category` varchar(100) GENERATED ALWAYS AS (json_unquote(json_extract(`json`,_utf8mb4'$  .category'))) VIRTUAL NOT NULL,   `popular` enum('true','false') GENERATED ALWAYS AS (json_unquote(json_extract(`json`,_utf8mb4'$  .popular'))) VIRTUAL NOT NULL,   `imageUrl` varchar(255) GENERATED ALWAYS AS (json_unquote(json_extract(`json`,_utf8mb4'$  .imageUrl'))) VIRTUAL NOT NULL,   `json` json NOT NULL,   `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; 


ERROR 1064 (42000) at line 33: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'NOT NULL,   `popular` enum('true','false') GENERATED ALWAYS AS (json_unquote(...' at line 3 

What means of resurrection does Implosion prevent?

This new (and therefore spoiler-filled) strip of The Order of the Stick makes the claim that Implosion has been used to prevent resurrection, presumably from the party’s Wizard’s access to Limited Wish. This got me thinking, what means of resurrection does Implosion actually prevent?

At first I thought that it might prevent Raise Dead and not Resurrection, but I’ve recently noticed that Implosion’s text is not explicit about whether or not it destroys bodies.

What does the notation $ [ i \neq k ] $ means?

I can’t figure out what the notation $ [x \neq k ]$ means. Here’s a bit of context:

The formula is: $ Pr[A_i^k = 1] = \frac{[i\neq k]}{|k-i| + 1} = \begin{cases} \frac{1}{k-i+1} \text{ if } i \lt k \ 0 \text { if } i = k \ \frac{1}{i-k+1} \text{ if } i \gt k \end{cases}$

and is part of a chapter where the average expected time of operations of a randomised treap are proved.

$ A_i^k$ is an indicator variable defined as $ [ x_i \text{ is a proper ancestor of }x_k ]$ where $ x_n$ is the node with the $ n$ -th smallest search key. That probability comes up because $ \text{depth}(x_k) = \sum_{i=1}^{n} A_i^k$ and $ \mathbf{E}[\text{depth}(x_k)] = \sum_{i=1}^nPr[A_i^k = 1]$ .

I have no access to the pages that explain the notation since I’m studying from a pdf of a few pages taken from a book.

What is the reason to use the Heal skill assuming that other means of healing are not prohibited?

Reading the description of the Heal skill in Pathfinder and comparing its outcomes to other ways of healing, such as wands, channel positive energy etc., I have found that skill useless. The only benefit seems to be a relatively low to non-existent cost per use and unlimited amount of uses per day.

For a party of adventurers, this seems quite useless due to the amount of time spent to achieve certain results — the adventurers don’t have unlimited time. But, being new to the system, I want to hear if there is something beyond my current level of understanding.

Does the Heal skill have any real benefit over magical methods of healing?

This question has attracted many answers based on what is essentially a house rule:

  • Wealth by level being severely cut, even compared to the “low fantasy” threshold
  • The Heal skill being able to solve more problems than listed in the book
  • Access to magic items being drastically cut
  • Etc.

Such answers might be OK and might propose interesting house rules, but please, tell that your answer is based on a house rule if it is! Many of those rules turn Pathfinder in an entirely different game with a completely different balance.

Is there any means of restoring Spiritual Damage?

Is there any means through which to heal or negate Sacrifice (or Spiritual Damage)?

In the books it is a concept that is listed in a few places but it doesn’t seem to ever be fully defined as what it is, the following are the ones I know of:

Vital Sacrifice

Characters recover sacrificed Life Points at a rate of 10 per day, independently of the character’s natural Regeneration or any healing spells he might employ.

Anima – Beyond Fantasy Pg.145

Spiritual Damage

The Attacks this creature makes against its enemies’ bodies weaken their very resolve to continue living. The damage the creature causes heals at the rate of a Sacrifice at best (i.e., 10 LP per day).

Those Who Walked Amongst Us Pg. 179