What exactly are the sources from which you can copy spells into a Book of Shadows?

The Book of Ancient Secrets invocation says (PHB p. 110):

On your adventures, you can add other ritual spells to your Book of Shadows. When you find such a spell, you can add it to the book if the spell’s level is equal to or less than half your warlock level (rounded up) and if you can spare the time to transcribe the spell. For each level of the spell, the transcription process takes 2 hours and costs 50 gp for the rare inks needed to inscribe it.

The top answer to this question suggests that you can copy any spells that have the (ritual) tag that you find in a wizard’s spellbook or in the ritual book of someone with the Ritual Caster feat. This other question suggests that you can also copy from a scroll, including non-wizard spell scrolls with the (ritual) tag. Are there any other sources?

I’m looking for either a rules/Sage Advice/similar citation on how this works, or failing that, personal experience regarding the effect of allowing or disallowing certain sources. (Also I realize this is technically a list question, but there should be a single correct answer that is short, well-constrained, and static barring a major rules change.)

How to send data from local host to Online server [closed]

I working on a project which is saved data on local host when internet connection not connect , if internet connection available when these all data on local host automatically send to Online server. I unable to coding for it. Also we use php and MySQL in back-end. If another language is simple for doing it please tell me……

Thanks in advance…

Does an Artificer’s Magic Item Savant and a multiclassed Thief Rogue’s Use Magic Device allow them to benefit from a Rod of the Pact Keeper?

The Artificer’s Magic Item Savant feature states the following:

At 14th level, your skill with magic items deepens more:
• You can attune to up to five magic items at once.
• You ignore all class, race, spell, and level requirements on attuning to or using a magic item.

The Thief Rogue’s Use Magic Device feature states the following:

By 13th level, you have learned enough about the workings of magic that you can improvise the use of items even when they are not intended for you. You ignore all class, race, and level requirements on the use of magic items.

Rod of the Pact Keeper states the following:

While holding this rod, you gain a +1 bonus to spell attack rolls and to the saving throw DCs of your warlock spells.

In addition, you can regain one warlock spell slot as an action while holding the rod. You can’t use this property again until you finish a long rest.

Since these features allow an Artificer or a multiclassed Thief Rogue to ignore “class” requirements when using a Rod of the Pact Keeper, would they ignore all instances of “Warlock” in the text and benefit from the general bonus to spell attack rolls and saving throw DCs, and be able to regain one spell slot?

Related questions:
1. What requirements does the Artificers Magic Item Savant feature ignore?
2. Does an Artificer's Magic Item Savant and a Thief Rogue's Use Magic Device allow them to benefit from a Holy Avenger's 30-foot aura?

Does an Artificer’s Magic Item Savant and a Thief Rogue’s Use Magic Device allow them to benefit from a Holy Avenger’s 30-foot aura?

The Artificer’s Magic Item Savant feature states the following:

At 14th level, your skill with magic items deepens more:
• You can attune to up to five magic items at once.
• You ignore all class, race, spell, and level requirements on attuning to or using a magic item.

The Thief Rogue’s Use Magic Device feature states the following:

By 13th level, you have learned enough about the workings of magic that you can improvise the use of items even when they are not intended for you. You ignore all class, race, and level requirements on the use of magic items.

Holy Avenger states the following:

While you hold the drawn sword, it creates an aura in a 10-foot radius around you. You and all creatures friendly to you in the aura have advantage on saving throws against spells and other magical effects. If you have 17 or more levels in the paladin class, the radius of the aura increases to 30 feet.

Since these features allow an Artificer or Thief Rogue to ignore “class” requirements when using the Holy Avenger, would they gain the benefit of the 30-foot aura?

Furthermore, since they also ignore “level” requirements when using the Holy Avenger, can they benefit from the 30-foot aura at 14th and 13th level, respectively?

Related questions:
1. What requirements does the Artificers Magic Item Savant feature ignore?
2.

How do I join getting one row from the left table, no matter how many matches i get from the right table?

I have two tables – one is a data table and the other is a mapping table. I want to join them together, but only preserve the data from the right table. However, it is possible that the match table may contains multiple records that match to a single record in the right table. I cannot use a DISTINCT because there may be identical rows in the right table, and I want to preserve the same number of rows from the right-table in the result set.

Here is a sample of the data I am working with:

       DataTable                           MappingTable +-----+-----+-----+-----+           +------+------+------+------+ | ID1 | ID2 | ID3 | ID1 |           | ID1  | ID2  | ID3  | ID1  | +-----+-----+-----+-----+           +------+------+------+------+ |  1  |  1  |  1  |  1  |           |  1   | NULL | NULL | NULL | |  1  |  1  |  1  |  1  |           | NULL | NULL | NULL |  1   | |  2  |  1  |  1  |  1  |           |  3   |  3   | NULL | NULL | |  3  |  1  |  1  |  3  |           +------+------+------+------+ |  4  |  1  |  1  |  4  | |  2  |  2  |  1  |  1  | |  3  |  2  |  1  |  3  | |  3  |  3  |  1  |  3  | |  2  |  1  |  0  |  1  | |  2  |  1  |  0  |  1  | |  4  |  3  |  2  |  3  | +-----+-----+-----+-----+ 

Below is the join I am using. I wrote a custom function to handle the NULL-matching behavior, which I am including here as well.

SELECT * FROM DataTable P JOIN MappingTable M ON dbo.fNullMatchCheckIntS(P.ID1,M.ID1,0,1) = 1     AND dbo.fNullMatchCheckIntS(P.ID2,M.ID2,0,1) = 1     AND dbo.fNullMatchCheckIntS(P.ID3,M.ID3,0,1) = 1     AND dbo.fNullMatchCheckIntS(P.ID4,M.ID4,0,1) = 1 

CREATE FUNCTION dbo.fNullMatchCheckIntS (     @Value1 INT     ,@Value2 INT     ,@AutoMatchIfValue1IsNull BIT     ,@AutoMatchIfValue2IsNull BIT )     RETURNS BIT AS  BEGIN      DECLARE @Result BIT = 0      SELECT         @AutoMatchIfValue1IsNull = ISNULL(@AutoMatchIfValue1IsNull,0)         ,@AutoMatchIfValue2IsNull = ISNULL(@AutoMatchIfValue2IsNull,0)      IF         (@AutoMatchIfValue1IsNull = 1 AND @Value1 IS NULL)         OR (@AutoMatchIfValue2IsNull = 1 AND @Value2 IS NULL)         OR @Value1 = @Value2         OR (@Value1 IS NULL AND @Value2 IS NULL)     BEGIN         SET @Result = 1     END      RETURN @Result END 

The problem with the way the join works is that the first two rows in the DataTable match on the first two rows in the MappingTable, giving me four identical records in the result, but I only want 2. I know that I could add an identity column to the DataTable and then use DISTINCT or PARTITION to get the result I am looking for, but I would like to avoid that route if possible.

EDIT: I figured out a way to do this using EXISTS, but it looks a little ugly in my opinion. Still interested in other answers if anyone has an idea. Thanks!

SELECT * FROM DataTable D WHERE EXISTS (     SELECT D.ID1, D.ID2, D.ID3, D.ID4     FROM MappingTable M      WHERE dbo.fNullMatchCheckIntS(D.ID1,M.ID1,0,1) = 1         AND dbo.fNullMatchCheckIntS(D.ID2,M.ID2,0,1) = 1         AND dbo.fNullMatchCheckIntS(D.ID3,M.ID3,0,1) = 1         AND dbo.fNullMatchCheckIntS(D.ID4,M.ID4,0,1) = 1 ) 

If I learn Chill Touch from the Death Cleric’s Reaper ability, does it count as a Cleric cantrip?

The first level feature of the Death Cleric, called Reaper, does the following:

At 1st level, you learn one necromancy cantrip of your choice from any spell list.

If the Death Cleric takes Chill Touch from the Sorcerer/Wizard/Warlock spell list, does Chill Touch become a Cleric cantrip that uses WIS as the spellcasting ability?

What’s the maximum amount of lines from Sunbeam possible within a single round?

I noticed that sunbeam allows you to to create multiple lines within a single turn. What’s the maximum possible amount of sunbeam lines able to be created by a single caster within one turn?

For reference, the spell has a casting time of 1 action and states:

A beam of brilliant light flashes out from your hand in a 5-foot-wide, 60-foot-long line. Each creature in the line must make a Constitution saving throw. On a failed save, a creature takes 6d8 radiant damage and is blinded until your next turn. On a successful save, it takes half as much damage and isn’t blinded by this spell. Undead and oozes have disadvantage on this saving throw.

You can create a new line of radiance as your action on any turn until the spell ends.

Rules

  • Level 20 Character, any combination of multi-classing allowed
  • Only official material published by WOTC in book form is allowed. No Unearthed Arcana
  • Setup is allowed, including any magical items present in the Dungeon Master’s Guide or any other source-book. Items only present in campaign books are not allowed.
  • You may have 4 allies at level 20
  • Simulacrum is allowed

Does input type=”file” selection support url ( upload from web ) ? -html

I wonder can I use the option of input type=”file” in html to upload from url ( web/ftp etc. ) ? Is there option to it? To more explain, I want to select zip file with url and uoload it to website.Which operating systems support it? How can do it on linux,mac and windows 10? I talking about the option on the link:

<input type="file">: How to Use This HTML Value