mariadb – MySQL Cast to TINYINT

I’m trying to cast a string data to a TINYINT data but I’m getting below error.

SELECT CAST('100' as TINYINT);

> 1064 - 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 'TINYINT)' at line 1

Casting to INT works fine.

SELECT CAST('100' as INT);

Any body can help me?

dnd 5e – Multiclass Paladin + Pact Magic = What paladin spells can I prepare and cast?

I’m sure this has been asked somewhere already, but I couldn’t find it.

Let’s say I’m Paladin 5 / Warlock 7. https://www.dndbeyond.com/sources/basic-rules/customization-options#Spellcasting

When I choose what Paladin spells I know, I consider myself as a single-classed Paladin 5, which would have 2nd level spell slots, so I can know 2nd level Paladin spells.

Spells Known and Prepared. You determine what spells you know and can
prepare for each class individually, as if you were a single-classed
member of that class.

When I consider what spell slots I actually have, I look on the multiclass spellcaster table, and see that I only have 1st level Paladin spell slots.

Spell Slots. You determine your available spell slots by adding
together all your levels in the bard, cleric, druid, sorcerer, and
wizard classes, and half your levels (rounded down) in the paladin and
ranger classes. Use this total to determine your spell slots by
consulting the Multiclass Spellcaster table.

So, if I want to cast one of those 2nd level Paladin spells, I’ll need to use one of my 4th level spell slots from Warlock.

Is all of that correct?

dnd 3.5e – How does the spell Siphon work for a caster who is both spontaneous and able to cast prepared spells?

The description of the 3rd-level Sor/Wiz spell siphon (trans) (Complete Scoundrel 103) makes no mention of any restrictions on what spells it can replace due to the source of the siphon spell’s casting. That is, the spell doesn’t seem to care if it were cast as a prepared spell or if it were cast without preparation. Instead, the description says that the siphon spell effect can replace only expended arcane prepared spells (like those of a wizard) and expended arcane spell slots of a caster that casts spells without preparation (like those of a bard or sorcerer).

Further, with the spell’s description including tightly knit language that accommodates casters whose spells are both prepared and not prepared, it seems reasonable to allow a multiclass caster who’s capable of both kinds of casting to pick to allocate the spell’s effect appropriately however she wants. For example, I’d have no problem in my campaign allowing a sorcerer/wizard to cast the spell siphon and use appropriately the effect to replace expended prepared spells, expended spell slots, or both in some combination.

Were the spell to check the caster’s magic style—with or without preparation—, activating a wand of siphon would be complicated as the spell’s effect would then possibly be contingent upon the creator of the wand of siphon instead of the effect being contingent upon the spell itself. Under such a reading, a typical wand of siphon would default to creation by a wizard—as that would give it the lowest caster level—, so a sorcerer could still activate such a wand but receive no benefit. That’d be weird and would perhaps make the siphon spell unique among 3.5‘s official spells.

dnd 5e – Can you cast Speak With Dead on dead undead?

The spell’s text says No: you can’t speak to the undead

A plain English reading of the rules is more persuasive than unofficial tweets.

You grant the semblance of life and intelligence to a corpse of your
choice within range, allowing it to answer the questions you pose. The
corpse must still have a mouth and can’t be undead.
The spell fails if
the corpse was the target of this spell within the last 10 days.

Note that it does not say “can’t be an undead creature.”
You have a zombie’s corpse.
A zombie is undead.
The corpse can’t be undead for this spell to work.
It says so right on the tin.

There is another problem with your example. Zombies can’t speak, even though they can understand the languages that they knew in life. But, if you use a vampire spawn and your BBEG was a vampire, they can speak the languages they knew in life but the spell still fails.

Why?

The corpse must still have a mouth and can’t be undead.

That’s pretty unambiguous.

There is a related Q&A where the accepted answer is that Speak with Dead does not work on skeletons, but, as that looks also like an interpretation of some rules that overlap in a particular way, I’ll not call it gospel. (Though I agree with the conclusion).

Rules as Fun

If you are the DM and you would prefer that any corpse, to include an undead’s corpse, is affected by the spell then by all means do that. Make sure the players are aware that you find that to be a more satisfying application of this spell. (I don’t see this as being a significant change vis a vis power of the spell-it already has sufficient limitations).

You can have some fun with this…
Cleric asks zombie corpse: “Where did the vampire go?” and the Zombie replies “Braaaains … “

dnd 5e – Does making an attack with a previously cast Spiritual Weapon spell cause the Invisibility spell to end?

Invisibility states:

The spell ends for a target that attacks or casts a spell.

and Spiritual Weapon states:

you can make a melee spell attack against a creature within 5 feet of the weapon.
(…)
As a bonus action on your turn, you can move the weapon up to 20 feet and repeat the attack against a creature within 5 feet of it.

Since using Spiritual Weapon involves making an attack it breaks Invisibility.

Furthermore you can look to the rule in the section “Making an Attack” (PHB, page 194):

If there’s ever any question whether something you’re doing counts as an attack, the rule is simple: if you’re making an attack roll, you’re making an attack.

How to Cast or Stream all Playback Audio from Android device to a desktop Pc

I have my Nokia 6 always next to my desk, and I’m using a desktop PC Windows 10 i7 64x
32gb ram and also running Voicemeeter, I use my desktop for everything, I can control all my devices from my desktop and I want to be able to listen any playback audio from my mobile device into my desktop audio system…

I don’t need to cast the mic audio to my PC, just the playback audio
I’m not talking about streaming music either.

Anyone can help? Please thank you

dnd 5e – Why can’t you cast 2 leveled spells per turn

So I was just informed by my DM that I couldn’t cast cure Wounds and Healing Word in the same turn he. Then showed me why in the bonus action word textbox and I was wondering why can’t you cast 2 leveled spells. If one is a bonus action and ones an action what’s the flavor reason.

dnd 3.5e – What do I roll to cast a summon with pre-determined base attack bonus?

I am playing a warlock in my current campaign and I selected earthen grasp for one of the invocations. Earthen grasp comes with its own base attack bonus:

Earthen Grasp:

Treat the arm as a Medium creature, with a base attack bonus equal to
your caster level and a Strength of 14 +2 per three caster levels (16
at 3rd level, 18 at 6th level, and so on).

Looking at this, it doesn’t seem to require any sort of roll since the strength bonus is always pre-determined. In that case, what would I need to roll in order to summon/cast an earthen grasp?

dnd 5e – Can the Shield spell be cast in response to being hit by an invisible enemy?

Let’s say I have a PC with the shield spell. I’m not surprised, and an invisible enemy hits me with an attack. My DM has not yet told me the attack roll number, so I am in a position to cast shield if I choose to.

However, the enemy is invisible, so would I be able to cast shield in response to an attacker I can’t see? Let’s assume the attacker is permanently invisible, like they’re using the greater invisibility spell. On the one hand, the shield spell simply says:

1 Reaction*
* – which you take when you are hit by an attack or targeted by the magic missile spell

There’s no mention of needing to see the creature.

On the other hand, it seems wrong to me that I can react to an attack I can’t see coming.

Are there any rules I’ve missed that would prevent the shield spell from being cast in this scenario?

dnd 5e – Does the extra damage from Booming Blade stack if the spell is cast twice on the same target?

It’s complicated; I suggest asking your GM

Both booming blade spells are still around, just not active

The Player’s Handbook has a section “Combining Magical Effects” which states:

The effects of different spells add together while the durations of those spells overlap. The effects of the same spell cast multiple times don’t combine, however. Instead, the most potent effect–such as the highest bonus–from those castings applies while their durations overlap, or the most recent effect applies if the castings are equally potent and their durations overlap.

We can establish from this that if somebody affected by multiple instances of booming blade, both instances are still around, just not necessarily active. We also see that only the most potent of the castings has any effects at a given time.


Is damage an effect of a spell? I personally say that it is.

This is an important question because if damage is not an effect of a spell, then simultaneous instances of damage can occur since nothing is preventing them from overlapping.

I address this question somewhat in my own answer to the following question:

To reiterate here though, one could certainly argue that damage is not an effect of a spell (people have done exactly that), however I personally believe that damage is an effect of the spell. I base some of this on the Dungeon Master’s Guide errata (direct download) which added the “Combining Game Effects” section (emphasis mine):

Different game features can affect a target at the same time. But when two or more game features have the same name, only the effects of one of them—the most potent one—apply while the durations of the effects overlap. For example, if a target is ignited by a fire elemental’s Fire Form trait, the ongoing fire damage doesn’t increase if the burning target is subjected to that trait again. (…)

The Fire Elemental’s Fire Form trait states:

(…) The first time it enters a creature’s space on a turn, that creature takes 5 (1d10) fire damage and catches fire; until someone takes an action to douse the fire, the creature takes 5 (1d10) fire damage at the start of each of its turns.

Here we see damage that just happens at the start of one’s turn and if multiple instances of this damaging effect are on a creature, only one occurs. The damage does not stack, which leads me to believe that damage is an effect of a spell, and so the damage from both castings of booming blade would not both occur at once.


Do both instances of booming blade even activate when you move? Ask your GM.

The following question exists and provides some insight into this question:

The current answers there both state the target in question only needs to make one saving throw because only the effects of one instance of the spell will be active at any given moment. They also state that should one of the castings end, the other will remain and its effects will become active.

Unfortunately that doesn’t address the issue here since booming blade states:

(…) If the target willingly moves before then, it immediately takes 1d8 thunder damage, and the spell ends. (…)

Here’s the problem, is the spell ending an effect of the spell? In other words, does the inactive casting also end when the target moves? Can that second casting even register or respond to the fact that you moved given that it is inactive? I honestly have no idea and have asked this as its own question. That said, as far as I’m aware, there are two possibilities:

  1. Both instances end at the same time

    The target will take either 1d8 if damage is an effect of a spell and 2d8 if damage is not an effect of a spell and both spells will end.

  2. Only one instance ends at a time

    The target will take 1d8 damage and that casting will end meaning the target will still have the other casting around and that casting will now become active. Thus if the target moves again they will take another 1d8 damage from the second casting which will then end.


In summary, the target either takes 2d8 damage at once and both spells ends, takes 1d8 damage and both spells end, or takes 1d8 damage and only one spell ends and they will take another 1d8 damage should they continue moving further.