unreal 4 – How can I add these bones to my meta human? Or is there a way I can make virtual bones count when retargetting?

Paid for animations thinking they would be fine and they mostly are but… the hands are using these IK bones that I do not have. Is there a way I can add the bones to my meta skeleton within unreal? I tried creating virtual bones but they dont seem to come up in the retarget manager 🙁 Also, I can only seem to add one virtual bone to the root whereas both the foot and hand IK root bones are parented to the root bone here.

enter image description here

Any help would be massively appreciated!

POSTGRESQL – GROUP BY with count and column

I have a view with 3 column (item task day)
Basically, day have task and task have item

I want to able show how many days is item appear and how many task is item appear

i.e item a appear in 3 days

Thanks in advance for the help

dnd 5e – Does use of a Fireball Necklace count as ‘casting a spell’?

RAW, no and no

In the DMG’s section on magic items, there is the main heading “Activating an Item” (p.141). That tells us (emphasis mine)

Activating some magic items requires a user to do
something special
, such as holding the item and uttering
a command word. The description of each item category
or individual item details how an item is activated.
Certain items use one or more of the following rules for
their activation.
If an item requires an action to activate, that action
isn’t a function of the Use an Item action…

The “following rules” refer to the four subsequent subsections, “Command Word”, “Consumables”, “Spells”, and “Charges”. It is thus expected that using a magic item will require the user to do at least one of of the four ‘special’ things, but we can also expect that the magic item description will tell us which one(s) are required.

The “Spells” subsection says

Some magic items allow the user to cast a spell from
the item…Many
items, such as potions, bypass the casting of a spell
and confer the spell’s effects, with their usual duration.

So, we are told twice that only some magic items require casting a spell to use them, and told once that many items do not.

The description of the necklace of fireballs says

You can use an action to detach a bead and throw it up to 60 feet away. When it reaches the end of its trajectory, the bead detonates as a 3rd-level fireball spell (save DC 15).

From this description, we note three things:

  1. Nowhere does it say that you need to cast a spell; this is similar to a potion in that a spell effect is achieved without a spell having been cast.
  2. It does say that you need to use an action.
  3. It says that you must detach a bead to use it (which permanently removes it from the necklace). Thus, of the four possible ‘special’ somethings, the beads are being activated as consumables.

Some items are used up when they are activated. A
potion or an elixir must be swallowed, or an oil applied
to the body. The writing vanishes from a scroll when it is
read. Once used, a consumable item loses its magic.

It is clear that the bead is activated by being “used up”, and not by having you cast a spell. Assuming that you must cast a spell when the necklace description does not make reference to you doing so, makes no more sense then assuming the necklace has a command word when none is mentioned, either.

This answers Magical Ambush; you are not casting a spell, so you do not get to use Magical Ambush.

Whether or not using the necklace ends your invisibility is a little more complicated. Clearly you are not casting a spell – but are you making an attack? Unfortunately, there is no explicit definition in the rules of what making an attack means. We are told that if you are making an attack roll, then you are making an attack – but that doesn’t tell us everything that might constitute an attack, for example, Grapple and Shove. The current understanding is that an “attack” is anything that requires an attack roll or which explicitly says it is an attack. Throwing a bead, or casting a fireball for that matter, are neither of these, and thus are not attacks. Your invisibility would be maintained.

“Count” from unspecified starting points in google sheets

I’m a baseball coach creating a google sheet to help track pitches and results for my college guys during games so they can see a lot of different information. See attached picture.

I’d like the chart to autofill the “count” column. Not sure how to do that with unspecified starting and ending points. Also, the count will only ever be up to 3-2. Even if there is another foul ball, the count still stays at 3-2. After an end of the at bat “result” (such as “line hit” or “BB”) is selected, I’d like the count to reset to “0-0” and a new “At Bat” is listed. Again, not at all certain if this is even possible without definite starting and ending points.

I could also reformat the cells to be a single cell and have it just be text that populates the cell. Not sure if that would be any easier/better to deal with only one cell instead of two.

Thanks for your help.

Picture

postgresql – Cumulate count between date with 0 when there are records for a given day

How could one write a Postgresql query that gives both daily and cumulative counts without gaps? E.g. if there is no data for a given day, it would show 0 as a daily count for that that day and the same cumulative sum as the previous day?

I think I’d need GENERATE_SERIES, but I don’t know how to do it. I’m also not entirely sure if order by day asc rows between unbounded preceding and current row would work correctly always, but maybe not the biggest issue here.

I have tried to craft the query with PARTITION BY and

Let’s say I write a table and add data such as

create table test
(
    id int4 NOT NULL GENERATED ALWAYS AS IDENTITY,  
    data int4,  
    created_at timestamptz NOT NULL DEFAULT now()
);

insert into test(data, created_at) values(1, '2021-04-01');
insert into test(data, created_at) values(2, '2021-04-01');
insert into test(data, created_at) values(3, '2021-04-02');
insert into test(data, created_at) values(4, '2021-04-03');
insert into test(data, created_at) values(5, '2021-04-05');
insert into test(data, created_at) values(6, '2021-04-07');

and then create a queries such as

SELECT
  created_at as "Date",
  count(1) as "Daily count"
FROM test
WHERE created_at >= '2021-04-01'
  AND created_at <= '2021-04-30'
GROUP BY 1

giving

Date Daily count
2021-04-01 00:00:00 2
2021-04-02 00:00:00 1
2021-04-03 00:00:00 1
2021-04-05 00:00:00 1
2021-04-07 00:00:00 1
with data as (
  select
    date_trunc('day', created_at) as day,
    count(1)
  from test
  group by 1
)
select
  day,
  running_total(count) over (order by day asc rows between unbounded preceding and current row)
from data
day running_total
2021-04-01 00:00:00 2
2021-04-02 00:00:00 3
2021-04-03 00:00:00 4
2021-04-05 00:00:00 5
2021-04-07 00:00:00 6

But as noted, how could these two be combined without gaps on daily values? Somehow it feels I get close but bump into some (syntax) problem. Maybe those two queries are the simplest and cleanest examples of what I’m thinking.

views – How can I exclude the shown node without reducing the row count?

I have a view block for related content in which I’ve configured a contextual filter (“Content ID from URL”) such that, when displaying the block on a node, that node node is excluded from the view. However, in cases where the current node is captured in the view, the total row count is reduced (in my case, from 3 rows to 2 rows) per the exclusion. In other words, the filter doesn’t simply filter out node when making the query, it removes the node from the query result (so far as I understand the process).

Is there a way to configure the view so that excluding the current node does not reduce the overall row count? I tried ordering the the contextual filters so that that the node exclusion occurs first, but this doesn’t have any effect on the result.

c++ – Count the number of arithmetic progressions within a sequence

I have some problems with code for my classes. Even though it works correctly, I run out of time for half of the examples. Here’s the task (I really did my best trying to translate it):

You have a permutation of numbers 1,2,…,n for some n. All consecutive numbers of permutations together create sequence a₁, a₂, a₊. Your task is to count how many arithmetic substrings of length 3 are present.

Input: In first line there is a number n (1 <= n <= 200 000). In the second line there is n numbers a₁, a₂, a₊ representing our permutation.

Output: The program needs to print out amount of arithmetic substrings of length 3 for permutations from entry. You can assume that the result won’t be bigger than 1 000 000.

NOTE: arithmetic substrings most likely stand for arithmetic progression or something like that

#include <iostream>
using namespace std;

int main() 
{
    int input_length;
    cin >> input_length;
    int correct_sequences = 0;
    
    bool* whether_itroduced = new bool(input_length + 1){0}; // true - if number was already introduced and false otherwise.
    
    
    for (int i = 0; i < input_length; i++)
    {
        int a;
        cin >> a;
        whether_itroduced(a) = true;
        int range = min(input_length - a, a - 1); // max or min number that may be in the subsequence e.g. if introduced number a = 3, and all numbers are six, max range is 2 (3 - 2 = 1 and 3 + 2 = 5, so the longest possible subsequence is 1, 3, 5)
        
        for (int r = range * -1; r <= range; r++) // r - there is a formula used to count arithmetic sequences -> an-1 = a1-r, an = a1, an+1 = a1+r, I have no idea how to explain it
        {
            if (r == 0) continue; // r cannot be 0
            
            if (whether_itroduced(a - r) && !whether_itroduced(a + r))
            correct_sequences++;
            
        }
    }
    cout << correct_sequences;
}

example input: 5 1 5 4 2 3

correct output: 2 // {1,2,3} and {5,4,3}

example input: 5 1 2 3 4 5

correct output: 4 // {1,2,3} {2,3,4} {3,4,5} {1,3,5}

example input: 10 1 5 9 7 4 3 6 10 2 8

correct output: 4 // {4,3,2} {1,5,9} {5,4,3} {4,6,8}

I need to somehow come up with another algorithm that is less than quadratic in time. I can’t really see all of the inputs and correct outputs, but I know that the biggest ‘n’ number is about 32000, so it’s most likely that I run out of time because of the algorithm. Do you have any ideas about how can I improve it and make it work faster? Thanks for help!

dnd 3.5e – Does the same attribute modifier necessarily count as the same source when adjudicating stacking rules?

the SRD says this about stacking:

Stacking

In most cases, modifiers to a given check or roll stack (combine for a cumulative effect) if they come from different sources and have different types (or no type at all), but do not stack if they have the same type or come from the same source (such as the same spell cast twice in succession). If the modifiers to a particular roll do not stack, only the best bonus and worst penalty applies. Dodge bonuses and circumstance bonuses however, do stack with one another unless otherwise specified.

(emphasis mine).

Does the same attribute modifier necessarily count as the same source?

Case A: for example, would the Wisdom modifier melee bonus damage from the epic prestige class Perfected One (Epic Level Handbook) stack with the Wisdom modifier bonus damage of the Shiba Protector prestige class (Oriental Adventures)?

Case B: would the bonus type make a difference? As an abstract example, would adding the Charisma modifier as a sacred bonus to reflex saving throws from class feature A and a the Charisma modifier as an insight bonus to reflex saving throws from class feature B stack?

Case C: would the kind of enabler matter? For example, if we had the Gauntlets of Heartfelt Blows (adds the Charisma modifier as bonus fire damage to melee attacks) and an imaginary class feature that adds the Charisma modifier to damage – would they stack?

python – How to count a a filtered result in Django?

I’m so far able to get a QuerySet of what I want, but I can’t however include the .count() statement in there. I do know I could use len(students) here but I’d like to stick to the Django ORM.

student_count = Student.objects.filter(last_online__range=( last week, this week))

How to do it?

pathfinder 1e – Do a Witchguard Ranger’s patron spells count as divine or arcane?

Divine, but that might be a mistake or a cut corner

Nothing in the ability says that you cast your patron spells any differently from your other ranger spells; it just says you add those spells to your spell list. Since your ranger spells are otherwise divine, these spells are too.

On the other hand, the ability describes itself as “A witchguard learn[ing] something of arcane magic from the witches he defends.” So it might be that this was a mistake, and the intent was that these spells count as arcane. However, since a ranger typically wears light armor, arcane spell failure would be a problem if those spells became arcane. They could waive ASF for those spells, à la bard, but then maybe that becomes a lot of text to describe this ability, when it really doesn’t matter very much. The differences between arcane and divine spells are very few, and the biggest one—arcane spell failure—is one you’d expect to have waived for a ranger. So you could spend a whole lot of page space explaining that the spells are arcane, but they don’t trigger arcane spell failure, and therefore… what? There’s no particular difference at that point, so why spend that space? So my guess is they just didn’t bother because it wasn’t worth the effort, but they “should” be arcane, in some sense.

If you are looking to qualify for something that requires arcane spells, I would just ask your GM if you can take it. Most of the time, there’s no real reason for such things to be limited to arcane spells in the first place, and I, for one, would rarely have a problem allowing it even for characters that are unambiguously divine. For these witchguard rangers, who know “something of arcane magic,” I’d be quite surprised if any GM objected.