How complex of an object can be created via the Creation spell?

Inspired by this question about creating gunpowder with the Creation spell.

My reading of the spell (and components) would indicate that the spell can only create an item (or multiple items1) but of a single "type". This comes from most of the description using singular form when referring to type.

From the spell description:

You pull wisps of shadow material from the Shadowfell to create a nonliving object of vegetable matter within range: soft goods, rope, wood, or something similar. You can also use this spell to create mineral objects such as stone, crystal, or metal. The object created must be no larger than a 5-foot cube, and the object must be of a form and material that you have seen before.

And the required components:

Components: V, S, M (a tiny piece of matter of the same type of the item you plan to create)

But the linked question tries to create gunpowder; a combination of "a fuel (charcoal), an oxidizer (saltpeter or niter), and a stabilizer (sulfur) to allow for a constant reaction". This is not only multiple types of matter, but different types; some vegetable, some mineral 2.

There is also no mention of the time being different; as in, using the shortest duration of all types used in the creation.

I would think that if the spell was to able to create mixed types it would have very different phrasing.

So is the Creation spell limited to only one type of matter at a time, or can it be a combination of matter/types?

And if it possible to create something with multiple/mixed types, how complex can the item be?

  • Can they mix different elements of the same type like an apple and an orange to create a fruit salad?
  • Can they create a leather coat with a fur lining and metal buttons? Or would they have to create each thing separately and sew them together by hand?
  • How about a metal crown, with cloth padding on the interior and encrusted with gems?
  • They can create iron, but can they also create it fused with carbon to create steel?
  • People could be considered a combination of vegetable matter and minerals. Could a character create a corpse (nonliving object)?

1 I would also think that this creates only a single item (a rope), except for minerals it states "You can also use this spell to create mineral objects…". Otherwise the description sticks to singular object.

2 Admittedly, something like this could be done with multiple castings, each creating a specific type of matter. But the point of the question was do create a complete pile of gunpowder.

Are the monsters in the MM actually following the monster creation rules?

The guidelines for making your own monsters are based around the Monster Statistics by Challenge Rating table on p274. Inspired by this question regarding Animated Armor (MM 19), which is CR1, let’s see where the Armor would be if we made it from scratch…

Defensive CR: The Armor has 33 HP, but step 9 (Damage Vulnerabilities, Resistances and Immunities, DMG 277) has us adjust effective HP based on resistance.

So we start with 33 HP, giving us CR 1/8, which tells us that we’re using the first line of Effective Hit Points Based on Resistances and Immunities, for an x2 multiplier for each Resistance or Immunity.

The Armor has two Immunities, so has 33x2x2 or 132 “effective” hit points. That puts us at CR 5. We then look at its AC of 18, which is 3 higher than the normal 15 for CR 5. That adjusts us up by one, to CR 6.

Offensive CR: It does 10 (2×5) points of damage, for a CR of 1. Its Attack Bonus is +4, which is 1 higher than the normal +3, but doesn’t adjust CR up.

Final CR is the average of the two, or (6+1)/2. That gives us 3.5, which we round against the players, for a final final CR 3.

How is Animated Armor a CR1 challenge? Its only notable disadvantage (from a combat perspective) is its Antimagic Susceptibility, but that has no effect on CR, per DMG 280. What’s knocking it down from CR 3 to CR 1? Or am I horribly misunderstanding how the creation rules work?

Arcane Hierophant Variant: Archivist prestige class creation

I’m planning on creating a prestige class based on the Arcane Hierophant. The Arcane Hierophant however is more wizard/druid bias and since I’m an Archivist I decided to create a variant with the Archivist in mind.

The problem: I can make the prestige class continue the advance of the Archivist’s Dark Knowledge but I’m torn if I should add more class abilities. Is the continued advance of the Dark Knowledge enough? Or should I add more?

The BAB progression will follow the usual Mystic Theurge, same with the reflex, fortitude and will saves. The entry requirements would be two Knowledge skills (arcana and religion), ability to cast 2nd lvl spells (just like AH), and have Dark Knowledge as a class feature. it will have a d4 as its hit point gain, 4 + Int for its skill point gain. No alignment requirement and a +4 BAB to qualify. I’m still playing around some hypothetical abilities like the loremaster’s secrets class feature.

It’s the divine half I want to substitute with the archivist, so the druid part would be replaced by archivist.

JSON Creation Issue

I’m new to PostgreSQL database. Although I’ve good experience on Oracle Database. I’m facing issue while generating JSON from Postgres. I’ve tried to generate the same output but not able to achieve is properly. Can someone please help or guide may be with examples on similar problem. I’ll be very much thankful to you.

"PostgreSQL 12.4 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.3 20140911 (Red Hat 4.8.3-9), 64-bit"

Tables and Sample Data.

CREATE TABLE PARKING_LOT (       PARKING_LOT_ID      NUMERIC(10)      ,PARKING_LOT_NAME    VARCHAR(100) ) ;  CREATE TABLE PARKING_LOT_VEHICLE_CLASS_MAP (       PARKING_LOT_ID       NUMERIC(10)      ,VEHICLE_CLASS_ID     NUMERIC(10)      ,AVAILABLE_SLOT_COUNT NUMERIC(10) ) ;   CREATE TABLE PARKING_SLOT (       PARKING_LOT_ID          NUMERIC(10)      ,VEHICLE_CLASS_ID        NUMERIC(10)      ,PARKING_SLOT_ID         NUMERIC(10)      ,SLOT_OCCUPANCY_STATUS   NUMERIC(10) ) ;   INSERT INTO PARKING_LOT VALUES( 1, 'PARKING 1' ) ; INSERT INTO PARKING_LOT VALUES( 2, 'PARKING 2' ) ;  INSERT INTO PARKING_LOT_VEHICLE_CLASS_MAP VALUES( 1, 1, 10 ) ; INSERT INTO PARKING_LOT_VEHICLE_CLASS_MAP VALUES( 1, 1, 11 ) ; INSERT INTO PARKING_LOT_VEHICLE_CLASS_MAP VALUES( 2, 2, 12 ) ; INSERT INTO PARKING_LOT_VEHICLE_CLASS_MAP VALUES( 2, 2, 13 ) ;  INSERT INTO PARKING_SLOT VALUES( 2, 1, 1, 1 ) ; INSERT INTO PARKING_SLOT VALUES( 2, 1, 2, 1 ) ; INSERT INTO PARKING_SLOT VALUES( 2, 2, 3, 0 ) ; 

Desired Output

{    "ResHeader":{       "ResDate":"09-01-2021 12:38:20",       "ResID":"12345",       "ResName":"Occupancy",       "ResDesc":"Parking Lot Availability and Occupancy Status"    },    "ResDetail":[       {          "ParkingLotID":"1",          "ParkingLotName":"PARKING 1",          "ParkingLotOccupancySummary":[             {                "VehicleClassID":"1",                "AvailableSlotCount":"10"             },             {                "VehicleClassID":"2",                "AvailableSlotCount":"12"             }          ]       },       {          "ParkingLotID":"2",          "ParkingLotName":"PARKING 2",          "ParkingLotOccupancySummary":[             {                "VehicleClassID":"1",                "AvailableSlotCount":"5",                "SlotOccupancyDetails":[                   {                      "SlotID":"1",                      "OccupancyStatus":"1"                   },                   {                      "SlotID":"2",                      "OccupancyStatus":"1"                   }                ]             },             {                "VehicleClassID":"2",                "AvailableSlotCount":"7",                "SlotOccupancyDetails":[                   {                      "SlotID":"3",                      "OccupancyStatus":"0"                   }                ]             }          ]       }    ] } 

What I’m able to achieve till now in bits and pieces

WITH     HEAD AS     (         SELECT json_build_object( 'ResHeader', H ) HeaderData         FROM         (             SELECT                  TO_CHAR(CURRENT_TIMESTAMP, 'YYYY-MM-DD HH24:MI:SS.MS') "ResDate"                 ,1  "ResID"         ) H     ) SELECT * FROM HEAD H  SELECT X.PARKING_LOT_ID, row_to_json(X) FROM (     SELECT VCM.PARKING_LOT_ID, VCM.VEHICLE_CLASS_ID  "VehicleClassID"     FROM PARKING_LOT_VEHICLE_CLASS_MAP2 VCM     LEFT OUTER JOIN PARKING_SLOT2 PS     ON VCM.PARKING_LOT_ID = PS.PARKING_LOT_ID ) X 

Regards Manoj

How to implement multiclassing during character creation? [closed]

Assume I want to have characters defined by classes, archetypes, whatever. And there’s no advancement, or at least sufficiently little advancement that the choices made at chargen always define the character.

But I want to have multiclassing. Or, more exactly, I want to have characters with differing numbers of archetypes without imbalancing them.

So a class/archetype can’t be a package of mostly or entirely good abilities, because adding another class makes a character better. Thus, the first idea I had was to have chargen start with an “average” set of traits, and each class adds a package of advantages and disadvantages. Works numerically, but I know that “disadvantages cost negative points” systems are easily exploitable. That is, players will try to put PCs in situations that take advantage of their strong points. Only if players and their characters had no control over the situation would “disadvantages cost negative points” be balanced. Thus, having more advantages and disadvantages is generally a good thing. I presume it’s for this reason that the Fate versions I’ve seen don’t just give you a pool of points but specify how many skills of what value you must buy in chargen.

So what other options are there?

I recognize that this post is about something very similar, but there’s no answer satisfying my requirements.

From the description, Apocalypse World and its derivatives allow for cross-class abilities, but only through experience rather than at chargen. Other suggestions lean toward full point-buy, but that’s not what I’m talking about. I don’t want complex character generation. And again, I don’t want to add abilities from other classes in play, but to have class combination in chargen.

Creation of failed links and problems with emails?

Hi everyone, I recently made a purchase for a premium list subscription, everything is automatically synced with dropbox. It’s all OK.
Approximately 2 days have passed and I cannot create links, the maximum that I have just created from those lists are only 4 links.
My updated filters to use the premium lists are:
See attached image

Now, yesterday I had had problems with the emails, in the registration panel it said: email verification failed, and when I go to check, see the following image a window appears that said: failed emails

and finally I am seeing a lot of failed registrations in wordpres articles.

In theory I should be creating many links, thanks to the help of the premium lists but something is missing or something is wrong in my configuration, could you help me find that fault?
I would like to see the full potential of GSA at work.

Does anyone know about Halfling creation?

I have been playing tabletop RPGs for a number of years, specifically HackMaster 4E.

At the moment, I am doing some extensive worldbuilding, and even to extent of developing my own creationist theories for the world. I have ideas for how the gods created the Dwarves, Elves, Gnomes, and even Humans. I have not, however, got any clue about how the Halfling creationist theory would work.

I have been researching for a number of weeks, and have turned up empty.

Does anyone have any ideas, or know of where I need to look to continue my research?

Thanks

Ed