Combine multiple 301 redirects

I need to combine multiple redirects via my .htaccess in WordPress for future site migration and re-launch:

  • Domain change
  • Force HTTPS
  • Force www
  • URL structure changes (important to keep juice here)

I’m wondering if there’s any order this is preferably done? Page to page redirects before or after domain and HTTPS+www? Does it matter? And is the below code correct?

RewriteEngine On  # Force HTTPS, WWW URLs, and change of domain RewriteCond %{HTTP_HOST} ^(www\.)?olddomain\.com$   [NC] RewriteRule ^ https://www.newdomain.com%{REQUEST_URI} [L,NE,R=301]  RewriteCond %{HTTPS} off RewriteRule ^ https://%{HTTP_HOST}%{REQUEST_URI} [L,NE,R=301]  ## 301 Redirects # Page to Page Redirect 301 pages/page-name https://www.newdomain.com/page-name Redirect 301 collections/products/product-1 https://www.newdomain.com/product/product-1  # BEGIN WordPress  RewriteEngine On RewriteRule .* - [E=HTTP_AUTHORIZATION:%{HTTP:Authorization}] RewriteBase / RewriteRule ^index\.php$   - [L] RewriteCond %{REQUEST_FILENAME} !-f RewriteCond %{REQUEST_FILENAME} !-d RewriteRule . /index.php [L]  # END WordPress 

Combine duplicate rows on column1 sum column2

I have the following data.

Id      ParentId    ProductId   Quantity 215236  19297       16300319    60 215221  19297       16314611    6 215234  19297       16314670    1    <- Duplicate productid 215235  19297       16314670    2    <- Duplicate productid 215195  19297       16314697    20 215205  19297       16321820    75 215216  19297       16329252    10 215233  19297       16331834    9 215224  19297       16519280    40 

Selecting unique records is easy. Or grouping the data on ProductId is also possible. I need a result that only contains a unique Product Id with the same parentid and the quantities summed up.

The result should look like this.

Id      ParentId    ProductId   Quantity 215236  19297       16300319    60 215221  19297       16314611    6 215234  19297       16314670    3 215195  19297       16314697    20 215205  19297       16321820    75 215216  19297       16329252    10 215233  19297       16331834    9 215224  19297       16519280    40 

The quantities of the duplicates

215234  19297       16314670    1    <- Duplicate productid 215235  19297       16314670    2    <- Duplicate productid 

should result in

215234  19297       16314670    3 

Does only the “Thug” variant combine with the “Sneak Attack Fighter” Variant?

Unearthed Arcana lists the two Fighter variants "Thug" and what is commonly referred to as "Sneak Attack Fighter". I have been reading in forums here and there that you can combine the "Sneak Attack Fighter" with other Fighter variants, but the Unearthed Arcana entry for the "Sneak Attack Fighter" reads:

This variant can also be combined with the thug variant.

As far as I know variants are not mixed such as archetypes might do in Pathfinder. Am I correct to assume that by raw you do not mix class variants?

Can I combine Martial Arts and Horde Breaker?

Can I use the martial arts feature on the second attack granted by horde breaker?

I.e., hit the first target with a weapon, use martial arts to unarmed strike, then use hoard breaker to jump to the second target and repeat?

I know I can’t use Horde Breaker multiple times, perhaps I was unclear in that. My question is, does Horde Breaker give me another full attack round thus allowing me to use Martial Arts again in that attack’s bonus round?

Postgres Combine Summed Values from 2 Queries / Tables into Single Row

Say I had the following 2 queries, summing values from separate tables.

I would like the sum of recorded time

SELECT      SUM(minutes) as recorded_minutes,     SUM(hours) as recorded_hours FROM recorded_time WHERE     project_id = 1 

To be combined with the sum of budgeted time in a single row

SELECT      SUM(minutes) as budgeted_minutes,     SUM(hours) as budgeted_hours FROM budgeted_time WHERE     project_id = 1 

Is it possible to do this in a single query?

Can I combine effects of 19 Deathwines?

Let’s say that I am a level 10 Arcanist. I cast Deathwine two times to affect 20 potions of Cure Light Wounds, costing 1000 gp. Then, "the first necromancy spell you cast within the next minute is cast at a higher caster level", so I spend the first 9 rounds using both my Move and Standard actions to drink those Deathwines. On the 10th round, I use my Move action to drink the 19th Deathwine, and then cast a Necromancy spell with a +19 bonus to its caster level.

Since the bonuses to caster level is untyped, those bonuses should stack.

On the other hand, this sounds like really cheap cheese, allowing e.g. a level 5 Cleric to easily create an 18-HD Necrocraft if enough gold is available. Also, the spell doesn’t explicitly say that the bonuses stack.

So, how does it work?

Do the Tunnel Fighter UA fighting style and the Polearm Master feat combine to grant indefinite opportunity attacks?


Here’s the scenario:

The character in question has both the Tunnel Fighter fighting style from Unearthed Arcana: Light, Dark, Underdark!, which says:

You excel at defending narrow passages, doorways, and other tight spaces. As a bonus action, you can enter a defensive stance that lasts until the start of your next turn. While in your defensive stance, you can make opportunity attacks without using your reaction, and you can use your reaction to make a melee attack against a creature that moves more than 5ft while within your reach.

As well as the Polearm Master feat (PHB, p. 168), the second bullet point of which says:

While you are wielding a glaive, halberd, pike, or quarterstaff, other creatures provoke an opportunity attack from you when they enter your reach.

Assuming you hit every target that enters your reach (10 feet, unless you’re using a quarterstaff), could you essentially take out a stampede of kobolds who have no ranged weapons? (Or some other instance of lots of easy-to-hit targets rushing at the player.)

Am I correct in assuming this means all approaching targets are attacked once as they enter my reach? Am I missing something that says otherwise in this scenario?

This combination seems really good to protect the rest of the group from a swarm of enemies and to abuse choke points. It’s almost too good against weaker enemies.

Can I combine 2 UnrealEngine forks?

I am using Daz Gen 8 characters and clothes in my project.

After I read this I decided to use a fork of UE4 which uses Dual Quaternion Skinning.

Basically if you use Daz characters under UE4, they going to distort better if you use DQS, which UE4 doesn’t support by default.
You can get the DQS modded engine from here.

I compiled it and I managed to get all my stuff from my original project to a DQS one.

No problem.

But I also need a soft body and a clothing solution in the project.

4.25 has a clothing solution and it does work fine, but there is no soft body, that I know about…

So there are a few options:

  1. Vico Dynamics from the Marketplace
  2. using a Flex branch of UE4
  3. if you know any more please please let me know

Tested Vico, and it works fine for simple meshes, up to 20k poligons. Over that the editor becomes unresponsive… But this works with my modded DQS engine.

The latest version of an UE4 branch with Flex is 4.22. I could get this compiled and running.

I would like to know if I can merge the 2 repositiories (4.22 DQS and Flex) into one, and source build it… What software or workflow do you recommend to do merge these big branches of UE4? I guess there will be quite a few conflicts, because Flex distorts the mesh in it’s own way, so does the DQS version of Unreal…