What happens if DM wouldn’t count Grapple and Shove as “an attack”?

This is how Player’s Handbook (p. 194) describes what counts as an attack:

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

There are ambiguous exceptions from this rule though — so-called "special attacks", Grapple and Shove in particular.

This raises additional questions, like Does grappling count as a hit? As a DM, for the sake of clarity and consistency I want to call Grapple just "an action" or "a contest", not "special melee attack". So instead of

you can use the Attack action to make a special melee attack, a grapple

the text of the house rule will be

you can use the Attack action to make an action in combat, a grapple

So does for Shove. This is also consistent with the PHB "Contests in Combat" (emphasis mine):

Battle often involves pitting your prowess against that of your foe. Such a challenge is represented by a contest. This section includes the most common contests that require an action in combat: grappling and shoving a creature. The DM can use these contests as models for improvising others.

So the lowercase "attack" is changed to "action" or "contest". For instance, the next passage in the Grappling description will be "If you’re able to make multiple attacks with the Attack action, this contest replaces one of them". The rest of the rules remains unchanged.

In terms of game mechanics, what consequenses/repercussions this change will have?

How can I use COUNT in the same query with SUM()?

Ok, I have three tables: theater, spectacles and tickets. A theater has one or more spectacles and for a spectacle were sold one or more tickets* So, id_theater is foreign key in TABLE SPECTACLES and id_spectacle is foreign key in TABLE TICKETS. In table TICKETS, I have ticket_price and id_ticket and with count(id_ticket) I calculate the number of tickets sold for spectacles. And each theater has one or more spectacles. The value for spectacles is calculated as: count(tickets.id_ticket) * tickets.ticket_price. After I calculate the value for spectacles, I need to gather the value of spectacles to find the each value of theater and for this I use SUM().

I need to write a query where I need to calculate the total value obtained by each theater and to be sort by value. For this I need to use the SUM() function. I tried so many different options, but I have different errors. When I tried to run this, this error appeared :

SQL Error: ORA-00937: not a single-group group function 
SELECT       theater.id_theater,       SUM(count(tickets.id_ticket) * tickets.id_ticket) total_theater FROM spectacles, theater GROUP BY theater.id_theater ORDER BY total_theater DESC; 

For this problem I must use SUM, but I really don’t know what do to at this point and would appreciate any help.

How Can I Increase Breadcrumb Position Count (Starting From 2)?

In my wordpress functions.php, I have tried increasing locations position count in the breadcrumb from 2 and above in the foreach loop (while leaving out position 1 for Homepage).

Please how can I be able to achieve this? All suggestions are highly appreciated.

Below is what I tried

function zuluma_display_breadLocation($  pid) {     global $  zuluma_theme;     $  ad_country = '';     $  type = '';     $  type = $  zuluma_theme['cat_and_location'];     $  ad_country = wp_get_object_terms($  pid, array('ad_country'), array('orderby' => 'ASC'));     $  all_locations = array();     foreach ($  ad_country as $  ad_count) {         $  country_ads = get_term($  ad_count);         $  inc = 1;         $  item = array(             'term_id' => $  country_ads->term_id,             'location' => $  country_ads->name         );         $  all_locations[] = $  item;     }     $  location_html = '';     if (count($  all_locations) > 0) {         $  limit = count($  all_locations) - 1;         for ($  i = $  limit; $  i >= 0; $  i--) {             if ($  type == 'search') {                 $  sb_search_page = apply_filters('zuluma_language_page_id', $  zuluma_theme['sb_search_page']);                 $  location_html .= '<li itemprop="itemListElement" itemscope itemtype="http://schema.org/ListItem"><a href="' . get_the_permalink($  sb_search_page) . '?country_id=' . $  all_locations[$  i]['term_id'] . '"><span itemprop="name">' . esc_html($  all_locations[$  i]['location']) . '</span></a><meta itemprop="position" content="$  inc++;" /></li>';             } else {                 $  location_html .= '<li><a href="' . get_term_link($  all_locations[$  i]['term_id']) . '">' . esc_html($  all_locations[$  i]['location']) . '</a></li>, ';             }         }     }     return rtrim($  location_html, ', '); } 

The below is what i got when i view the source code

<meta itemprop="position" content="$  inc++;" /> 

How to count near duplicates in a mixed pool using AnyDice?

Following on from this question: How to count duplicates in a mixed pool using AnyDice?

I’m also interested in the much harder question of using AnyDice to look at how much easier some dice mitigation of +/-1 makes getting duplicates (as per the example in that question).

For example, if I rolled 12, 12, 5, 4, 3, 1 the result of how many dice there are that are 1 away from a duplicate would be 3; because 5, 4 and 3 are all 1 away from another result.

How to count duplicates and near duplicates in a mixed pool using AnyDice?

The following question provides a function that answers the question for a single kind of die; How do I count the number of duplicates in anydice?

I want to count how many duplicates there are in a mixed pool such as 3d12, 2d10, 1d8.

For example, if I rolled 12, 12, 3, 3, 3, 1 the result would be 5; because 5 of the dice have at least one other die that has rolled the same value.

I’m also interested in looking at how much easier some dice mitigation of +/-1 makes getting duplicates. This is probably a much harder question.

For example, if I rolled 12, 12, 5, 4, 3, 1 the result of how many dice there are that are 1 away from a duplicate would be 3; because 5, 4 and 3 are all 1 away from another result.

How to count in relational algebra without aggregate functions?


Find the user who has liked the most posts. Report the user’s id, name and email, and the id of the posts they have liked. If there is a tie, report them all.

The schema:

User(uid, name, website, about, email, phone, photo)  Likes(liker, pid, when)  Likes[liker]  is contained in  User[uid] 

I think I need a "function" NumberOfLikes or similar where I can do something like:

enter image description here

We aren’t allowed to use aggregate functions in this exercise. I assume the way to count in RA is by performing some sort of cross product black magic, but I don’t know how.

Help?

Group by Multiple columns and then count different value of same column

I want to achieve the result which tells me the number of males and females of each disability types in each district. each district can have multiple disabilities.

So far i have reached the following query :

  SELECT    DistrictId,    fb.DisabilityTypeId,    SUM(     CASE WHEN GenderId = 1 THEN 1 ELSE 0 END   ) AS Male,    SUM(     CASE WHEN GenderId = 2 THEN 1 ELSE 0 END   ) AS Female  FROM    Districts d    LEFT OUTER JOIN FormAddresses a ON d.Id = a.DistrictId    INNER JOIN PeopleForms pf ON a.PeopleFormId = pf.Id    INNER JOIN FormBeneficiaries fb ON pf.Id = fb.PeopleFormId    INNER JOIN FormPersonalInfos fp ON pf.Id = fp.PeopleFormId  where    a.IsDeleted = 0    AND pf.FormTypeId = 2    AND d.CityId = 3  GROUP BY    DistrictId,    fp.GenderId,   fb.DisabilityTypeId 

which gives the following result :

DistrictId  |   DisabilityTypeId    |   Male  | Female     1       |       2               |   1     |     0     3       |       2               |   0     |     3     5       |       16              |   1     |     0     5       |       20              |   2     |     0     5       |       20              |   0     |     1     

But i want to achieve the following result :

DistrictId  |   DisabilityTypeId    |   Male  | Female     1       |       2               |   1     |     3     5       |       16              |   1     |     0     5       |       20              |   2     |     1 

i somehow managed to get the expected result, but that with some complex sub-queries in the select clause of each gender which i didnt like and was not sure about the performance.

how can i write an efficient query for the desired result that i want?

Thanks.

Does something count as “dealing damage” if its damage is reduced to zero?

An example of a feature where this sort of thing matters is the Optional Favored Foe feature for the Ranger from Tasha’s Cauldron of Everything (emphasis mine):

[…] The first time on each of your turns that you hit the favored enemy and deal damage to it, including when you mark it, you can increase that damage by 1d4. […]

This clearly means that if you hit with an attack that never deals damage, you would not trigger Favored Foe, but what happens if you hit with an attack that can deal damage but that damage was reduced to zero by either damage reduction, resistance, immunity or some other sort of feature; have you still dealt damage?


This question is different from the following:

  • Does dealing 0 damage to a concentrating spellcaster require a saving throw?

As Constitution saving throws result from a creature taking damage, not from a creature dealing damage.

Does improved grapple count in determinig the CMB when casting while grappled

I’ve always stayed away from grapple & overrun rules, but, this time, i can’t ignore it.

The rules says that

A grappled character who attempts to cast a spell or use a spell-like ability must make a concentration check (DC 10 + grappler’s CMB + spell level, see Concentration)

so does the feat, special abilities, objects granting bonus on the grapple check count against the DC of concentration?

Does the bonus like flanking count?

Does turning around count as moving for triggering Brace?

My fighter took Superior Technique as Fighting Style. This gives me the the Combat Maneuver Brace, from Unearthed Arcana, which says (emphasis mine):

When a creature you can see moves into the reach you have with the melee weapon you’re wielding, you can use your reaction to expend one superiority die and make one attack against the creature, using that weapon. If the attack hits, add the superiority die to the weapon’s damage roll.

The wording of a similar mechanic in the Polearm Master feat differs slightly:

While you are wielding a glaive, halberd, pike, quarterstaff, or spear, other creatures provoke an opportunity attack from you when they enter the reach you have with that weapon.

The word "enter" makes it very clear to me that the opponent needs to enter the reach for the trigger to happen, but "moving into" is less clear to me. It could be that they are semantically the same, but both my DM and I are unsure.

So, for example, if the opponent is already within my reach and it turns around to attack someone else: does turning around count as moving for triggering Brace?