Tag: specific

I would like to know if there is a plugin or how to do it, so that a site on that multisite network on a specific date

I have a network of sites (multisite), where I rent a site (plans), I would like to know if there is a plugin or how to do it, so that a site on that multisite network on a specific date.

For example:

1 customer rented a website for 2 months.

I want who on the last day of these 2 months, the site goes down with a message (expiration, canceled, contact us to activate).

Can someone help me?

Can Dispel Magic be used on a specific magical effect without removing other spells?

During tonight’s game, the party’s wizard became confused because of a failed save against Yeenoghu’s flail, which had the effect of:

The target must succeed on a DC17 Wisdom saving throw or be affected by the confusion spell until the start of Yeenoghu’s next turn.

The wizard was in this position because they’d had multiple buff spells placed on them like Shapechange, Haste, and something else.

However, being confused was a big problem that the party decided needed to go. So the cleric cast Dispel Magic with the intent to just target the magical effect of confusion caused by Yeenoghu.

Dispel Magic says:

Choose one creature, object, or magical effect within range. Any spell of 3rd level or lower on the target ends. For each spell of 4th level or higher on the target, make an ability check using your spellcasting ability. The DC equals 10 + the spell’s level. On a successful check, the spell ends.

With this in mind, the question I have is two-fold.

First all, is the confusion effect targetable by dispel magic? It seems like it should be because the effect is described to be like a specific spell’s effect.

Secondly, if the cleric casts dispel magic on the wizard to end the confusion, can they do so without risking removing all of the other buff spells?

Can Seeming disguise a mummy as a specific human? (D&D 5E) [duplicate]

Background for the question: in my campaign, I have a Mummy being controlled by a group that includes an Illusionist. I need to make the Mummy appear as if he is a certain human NPC. I know I could use True Polymorph, but I don’t want to have to have to make the controlling Illusionist that high of a level.

My question: Would the 5th level spell Seeming accomplish what I am trying to do? I do not need the Mummy to speak or really do anything other than sit there and look like a human. The text for the spell says that it changes the targets appearance; would this be adequate or would I need to use True Polymorph?

How to force mathematica to take derivatives in a specific way?

I am attempting to take some derivatives of some Lagrange planetary equations. In this I have two types of anomaly which have derivatives that are found geometrically. I’m trying to force mathematica to use the results of these derivatives. I realize that to do this I have defined the derivatives. To get Mathematica to be happy I unprotect D before doing so. Heres my code for that:

Unprotect[D];  D[f, e] := (a/r + (\[Mu]*a)/((\[Mu]*a)^(1/2)*(1 - e^2)^(1/2))^2)*Sin[f]  Unprotect[D];  D[f, M] := (1 + e*Cos[f])^2/(1 - e^2)^(3/2)

Okay so this is all well. When I evaluate D[f,M] or D[f,e] it seems to work correctly; however when I take the derivatives of other functions derivatives don’t follow those rules I set above. For example, I made up a simple function to check this:

In[58]:= abc [a, e, i, f, c] := e*f*Sin[f]  In[59]:= D[abc[a, e, i, f, c], e]  Out[59]= f Sin[f]

Uh oh. So my question is how do I get mathematica to match the derivatives I want?

Thanks for all your help

Procedure to truncate the desired table after a specific time does not work properly,”SYSDATE” and the “SYSTEM CLOCK” show different hours!

I wrote a procedure as you can see below:

create or replace procedure truncate_test is         hour_part char(40);     begin    <*** Other Parts***>                         select to_char(sysdate, 'HH24') into hour_part from dual; -- Check the time here      if (hour_part >= 16) then     execute immediate 'truncate table cust_modern_channel_branch';   end if;     <*** Other Parts***>  end;

This procedure is a part of an ETL which runs everyday.The aim of this part of the procedure is to check the time and if it’s after 4:00 PM in the afternoon, it truncates the table (ETL might reach the truncate part at different hours). I’m using this query to extract the hour part of sysdate select to_char(sysdate, 'HH24'). The problem is that this query select sysdate from dual returns this 3:28:43 PM (I’ve omitted the date part) so the above query returns 15, but the system clock (bottom right corner) shows 4:08 PM !!So I’m expecting that the procedure truncates my table when I execute it cause it’s 4:08 PM but sysdate is showing a different time and nothing happens! why is this happening? Why the sysdate and system clock shows different hours?

Thanks in advance

Can a Homunculus freely take a bonus action granted to it by a specific rule such as a spell?

After the errata / Tasha’s, we know that you can use your character’s bonus action to command a Homunculus to use a Spell Storing Item. I think we also know that a Homunculus can freely maintain Concentration on a spell cast from the Item, as Concentration requires no action.

Let’s say the Item contains Heat Metal. The Heat Metal spell lets the caster take a bonus action on subsequent turns to re-inflict damage (and disadvantage) on the target.

Can the Homunculus take this bonus action without being commanded by the character?

The Homunculus description in Tasha’s states that

it can move and use its reaction on its own, but the only action it takes on its turn is the Dodge action, unless you take a bonus action on your turn to command it to take another action. That action can be one in its stat block or some other action.

Note that nothing is said about its ability to take a bonus action, probably because the ability to take a bonus action is granted by specific circumstances (e.g., dual wielding light weapons), class features (e.g., Defensive Field), feats (e.g., Crossbow Expert), and spells (e.g., Heat Metal).

Absent anything more specific in the Homunculus description, one could argue that the specific language from Heat Metal lets the Homunculus take a bonus action at will. On the other hand, one could also argue that a "bonus action" is a subcategory of "action" — however, I don’t think such an argument holds water, because while some bonus actions replicate actions (like weapon attacks), others do not (like Defensive Field), suggesting that "bonus action" is a separate category of game mechanic.

PostgreSQL. Consequently select results according with specific filters

I have a table with users.

User (that uses this programm) can select users by applying different filters. A filters must be applying immediatelly to reduce search time in final SELECT and no wasting time.

Currently my code looking like this (Python, not sure that this is working, not tested yet).

The question:

  1. How to applying a filters immediatelly as I get a user input?
  2. How to put/pass all actions related to filtering to DB?
if only_with_photo:     cursor.execute('SELECT tg_user_id FROM suers WHERE photo IS NOT NULL')     users_with_photo = cursor.fetchall() if only_with_country:     cursor.execute('SELECT tg_user_id FROM suers WHERE country IS NOT NULL')     users_with_country = cursor.fetchall() if only_with_city:     cursor.execute('SELECT tg_user_id FROM suers WHERE city IS NOT NULL')     users_with_city = cursor.fetchall()          cursor.execute('SELECT tg_user_id FROM users WHERE tg_user_id IN (users_with_photo) AND tg_user_id                              IN (users_with_country ) AND tg_user_id IN (users_with_city) )

Tasks: perform this queries inside psql without using Python or another language?

I tried:

  1. CASE sql = 'SELECT (CASE only_with_photo = 1 THEN (SELECT tg_user_id FROM users WHERE country IS NOT NULL)' --Subrequest returns more that one result
  2. Variables /set only_with_photo := (SELECT tg_user_id FROM users WHERE birthdate IS NOT NULL); --Syntax just now working

Chances of specific sequence in X amount of dice?

So after fumbling around in AnyDice for awhile, I’m struggling to find a solution. Here’s what I’m looking for:

  • What are the chances of rolling a specific number that matches a specific sequence in order in multiple dice?
  • For example, in Xd6, I’m trying to figure out what that chances of rolling a 5+, THEN a 4+ in the remaining dice (as long as I get a 5+ first), then a 3+ in the remaining dice (as long as I get the 5+ and 4+ previously).
  • Bonus cookies and many thanks to you if your function allows me to easily change the numbers I’m looking for (like if I’m trying to find a 4+, 2+,5+ in that order)

Basically, a player rolls Xd6 and tries to match their different specific number sets, like 3+, 3+, 2+ or 1, 2, 3, exactly or 4+, 2, 6