Find children whose parents are in the same room

I have two tables ROOMS and CONTACTS. I then have two types of contacts related to each other. Investigator(parent) and Tech(child) . First we assign a Tech to an Investigator. Then assign Investigators to ROOMS. Now we must assign Techs to the room. However I only want the user to see the tech as option IF they are a tech of an Investigator assigned to the room.

Here is what the structure looks likeenter image description here

join_on_tech and join_on_investigator are table occurrences of the same join table.

room_join_contacts is a separate join table than the other join for parent/child

Currently I have a portal set up and and the user is presented with a list of techs via perform find script command. only it shows all techs rather than techs where investigator is in room

how would I go about filtering out techs that do not have an investigator(parent) in the room

Does the spell Rope Trick fail if the rope is longer than the height of the room?

The spell description for rope trick (PHB, pg. 272) states:

You touch a length of rope that is up to 60 feet long. One end of the rope then rises into the air until the whole rope hangs perpendicular to the ground.

What happens if I cast rope trick on a 60 foot rope in a 12 foot high room? The ceiling is not high enough for the whole rope to hang perpendicular to the ground; conceivably, it either stops rising when it hits the ceiling or it begins to pile up on the ceiling until 12 feet of it dangle to the floor. Either way, the rope does not satisfy the bolded condition in the spell description.

Does the spell fail? Do I need to cut down my rope to be less than the height of the room before casting the spell?

Minimize shadows placing light sources on a diagram of a room

I’m a CS student and came upon this problem:

Given a diagram of a room with obstacles in it (like walls or furniture), find the 4 best places to put light sources in it so the room has the most light possible, or you can think of, minimizing the amount of shadow in the room.

In other words, if you have 4 sources of light, which are the best places to put them so your room has maximum light (or minimum shadow).

I’ll append an example of a diagram so the problem can be better understood: example of a diagram

The solution I thought was to find the spot with most light and from there find the second one and so on. But something makes me think that it may exist a configuration which is better that doesn’t need to be the best from the beginning, kinda feels like a special case of the knapsack problem, if so I’d think of implementing a greedy algorithm or using genetic algorithms to give an approximation of the best places.

I’m not sure if it’s a math or a CS problem. I’d be grateful if at least someone points me in the right direction so I can do a better research, thank you very much!

Was the Room of Death ever officially described?

D&D knows Mimics and their relatives, the Lurker and Trapper. They are aberrations that mimicpun intended the floor and ceiling and have been used in conjunction with a stunjelly for years to make a room that lusts for adventurers to eat. Yes the room will eat you. For example in this 2010 Screamsheet blog post, but I am very sure I have seen an older internet page that discussed the to with the stunjelly in exactly the same configuration, and after a quick search I could find Jared [von] Hindman’s 2006 article ranting about 30 years of stupid monsters, including the room of death but labeled as "Trinity of Dungeon Terror". In fact, I used his articles to build a he house filled with monsters that imitate items to try to eat you but that’s besides the point.

Has there ever been an offical Dungeons and Dragons supplement or Dragon Magazine article that employed the idea of the killer room that wants to eat you, consisting of Lurker, Trapper and Stunjelly or monsters that are virtually the same to these?1

1 – a single Greater Mimics doesn’t count. Neither does the house-sized variant unless it’s a Mimic in a Greater Mimic in a House Hunter Mimic. It must be 3 monsters.

Polymorphing into a creature that is larger than the room

If a character has the ability to transform into different creatures (using polymorph or wildshape as examples), what would happen if they shift into a creature larger than the space they are in?

Example: a chartacter is in an 8x8x8 room and turns into an elephant via any shape changing spell/ability.

Would the polymorph or wildshape still take effect?

Would the character take damage and if so how would that be determined?

Would any other creatures in that room take that same amount of damage?

What people/deities and places fall under the SRD and how much wiggle room is there?

So i’m working on an original campaign setting but using 5E rules, and in the core and extended rule books it references things like "the Raven Queen" and the "Shadar Kai", "shadowfell and "fey wilds". none of these are specifically listed on the SRD under the IP lists, but it does mention "specific places". anyway, my ultimate question is, can I used IPs such as Raven Queen, Shadowfell, fey wilds, ect. even in an original campaign setting/world, so long as it’s using 5E rules and if I give credit to WotC? what falls under OGL, SRD, and general use? this question came into discussion by a player, who want’s to be a shadar kai, Raven Queen warlock from the shadowfell, all things that would require me to write them into my campaign setting, and they are arguing that these things being playable, should mean that they can be in the world.

the OGL and SRD are SUPER vague about all these things (obviously trying to give them legal wiggle room to sue whoever they want) does anyone have any further information on what is useable?

Looking for a late 80’s possibly early 90’s D&D adventure based around a bar room brawl

About 20-25 or so years ago our group played a D&D one shot adventure that was entirely based around a bar room brawl. It started out with us in the inn post adventure and then developed over time into a full on brawl, there where a number of events and actions that happened during the night and a large number of NPC’s we could interact with through the adventure.

I know our GM based it on a written adventure potentially published in the late 80’s, think it might have been published in a roleplay or specific D&D magazine, possibly a very early White Dwarf.

The sessions stands out even now as being really good fun and I have been trying to find it in order to run a similar session myself, does anyone know this, or a similair adventure?

Programmatically create a trigger within abnormally shaped room

So I’m trying to create a trigger in each of my rooms. These rooms can be created by players. Basically, I need to know all the objects in a room. These rooms can be shaped in weird and wonderful ways. I’m struggling to figure out how to “fill” an area? The other problem is that some walls are curved.

My current thinking is:

  • Loop over all the walls in a scene. Do 4 raycasts from each side of the wall and see if we hit other walls. If we do, we are likely in a room.

  • From the offset, literally check each node adjacent to that until we fill the room. Once I have this though, Im not sure what to do with it.

How do I create bounds that I can check for collisions with this data?

Does the creature in room 27 of White Plume Mountain use the magic items they have?

Room 27 contains a creature who has some additional items listed as treasure:

Are those items active on the creature (changing some of their stats and giving some additional options)? Or are those not meant to be active/used and to be given as treasure?

If they do use them, does that adjust their CR?

How does crossing Room 7 work in White Plume Mountain?

I am trying to figure out the mechanics of crossing Room 7 of White Plume Mountain.

The image also appears to look different from the map they provide, too.

In all, I’m very confused as to how someone is supposed to cross the room or if it really is more improvisational and asking for checks based on the ideas generated by the party.