dnd 5e – Would the dimension trigger or circumvent a mental prison?

After failing the backup roll for mental prison, the target is subject, among others, to this:

If the target is out of illusion, launch a melee attack
through her, or reaches a part of her body through it, the target
takes 10d10 points of psychic damage and the spell ends. (XGtE 161)

If, under this effect, the target launches dimension doorwhat would happen? Would it count as being "out of illusion" by the spell? Is the illusion, being in their head, following them? Would it be different if someone else throws dimension door on them?

Virtual Reality – Prevent detaching objects from the hand when the controller trigger is released in Unity SteamVR

I use SteamVR's Player Prefab for Unity.
To pick up objects, I use the Throwable script that uses the controller trigger to pick it up and exit it to launch it.

Is there a way to prevent object detachment when the controller trigger is released?

If so, how can I force detachment with code?

postgresql – How to filter hstore where values ​​are not null in a trigger?

The easiest way to explain the question is to use an audit trigger.

However, during insertion, it records all values, including NULL values. I want to filter the null values ​​in the hstore(NEW.*). What is the easiest / fastest way to proceed?

Source: https://github.com/2ndQuadrant/audit-trigger/blob/master/audit.sql#L134

audit_row.row_data = hstore(NEW.*) - excluded_cols;

This obviously does not work but hopefully explains what the answer will look like.

audit_row.row_data = hstore(hstore(NEW.*) FILTER (WHERE value IS NOT NULL)) - excluded_cols;

The preference will be to answer which does not use a function created by the user, for example. use only postgres functions / operators.

This is for> = PostgreSQL v11

Note: Responses must use hstore, do not json or jsonb. You can suggest another way with json or jsonbbut the main answer has to use hstore.

dnd 5th – Do forced moves trigger the effects of the Prismatic Wall spell?

The prismatic wall spell says:

When a creature tries to reach or cross the wall …

A forced creature across the wall (by any means) is not "tempted to … pass through the wall".

Is he thus immune to its effects?

Trigger a link if it is wrapped in a label

I have a problem when a modal does not fire if it is encapsulated in a label.
In my example, if you click on the "normal" font style part, the link is triggered correctly. If you click in the place where the italics appear, it will not be.
Ideas?
JS

$(function () {
  const openModals = ();
  $('.modal-button').click(e => {
    e.preventDefault();
    $(e.target).closest('.modal').add('body').addClass('open');
    openModals.push($($(e.target).attr('href')).show());
  });...
Code (JavaScript):

Trigger a link if it is wrapped in a label

How to trigger without access to the session invalidate the version of the basket

Basic action (for example, basket save rule), I want to invalidate customer/section/load cartVersion forces Magento to recalculate the totals on the cart page for those who apply this rule to their cart.

Ideas how?

How to send an email that does not trigger an automatic reply to Gmail?

I'm trying to send a backup date to a number of recipients, but when I send it to people using Gmail, Gmail's automatic response will fire with RSVP response options. I send e-mail by writing the body in Word and using the mail merge Excel file to send the e-mail. The body is composed of a personalized text and an image. Some of the text asks to update the contact information by clicking on a link to a survey. When I send it to Gmail recipients, the Gmails auto-reply starts and gives the option of automatically replying with "yes, I will attend" or "no, I will attend". I do not want to give this option to recipients because it is not the RSVP. Can I insert something in the body of the email or delete something to delete it and prevent Gmail from giving the automatic answer?

7 – Reminder to send event trigger for non-button items

I was trying to create an interactive form and I was able to associate most of the event triggers with the reminder submission and form rebuild buttons. Code sample:

$form('form_wrapper')('properties')('table_button') = array(
  '#prefix' => '', //check cross browser performance (works in Safari, Chrome, and Firefox)
  '#suffix' => '',
  '#type' => 'submit',
  '#value' => 'Submit',
  '#submit' => array('submit_query'),
  '#id' => 'submit_button',
  '#name' => 'submit_button',
  '#ajax' => array(
    'callback' => 'rebuild_form',
    'wrapper' => 'form_wrapper',
  ),
}

function rebuild_form($form, $form_state) {
  return $form('form_wrapper');
}

function submit_query($form, &$form_state) {
  $create_add_where_out = create_add_where($form, $form_state);
  $form_state('usspd')('submit')('add_where') = $create_add_where_out('add_where');
  $form_state('usspd')('submit')('parameter_li') = $create_add_where_out('parameter_li');
  $form_state('usspd')('page_number') = 1;
  $form_state('usspd_query') = TRUE;
  $form_state('rebuild') = TRUE;
}

However, there are several non-button elements that I would like to be able to trigger a form rebuild. Specifically, I work with drop-down menus and multiple-selection text fields. I use AJAX callbacks to create new form elements with the post-event markup trigger. In addition to violating form validation (where I call $ _POST), there are strange behaviors that make it very frustrating to work with AJAX reminders instead of sending descriptors. For example, whenever I make an AJAX callback that does not also call a send descriptor, submit_query () is called by AJAX by default. Is it possible to trigger a submission reminder without interacting directly with a button? Maybe you have hidden buttons that can be selected with javascript to trigger the reconstruction of the form (Drupal has protections against this behavior)?

Edit1 – It seems that all AJAX callbacks call at least the first submission descriptor (maybe all) created in the form. I am currently trying to add a fill function to call as a send handle. See if this will limit the scope of the unwanted behavior.

Edit2 – The behavior seems to be more like a crushing of the submission handles saved by the form, not just an added behavior.

mysql 5.6 – UPDATE trigger causes blocking

Mysql Version: 5.6

I have a trigger on a table that has a bunch of conditions. But, the trigger makes some selections up. I have dead ends on some.

DELIMITER //
DROP TRIGGER IF EXISTS pieces_after_update;

CREATE TRIGGER pieces_after_update
AFTER UPDATE
   ON pieces FOR EACH ROW
BEGIN
    SET @COMPANYID = (SELECT company_id FROM skus where id = NEW.sku_id);
    SET @CLOSINGSTOCK = (SELECT closing_stock FROM skus_warehouses WHERE sku_id=NEW.sku_id AND warehouse_id=NEW.warehouse_id ORDER BY ID DESC LIMIT 1);
    SET @CLOSINGPENDINGSTOCK = (SELECT closing_pending_stock FROM skus_warehouses WHERE sku_id=NEW.sku_id AND warehouse_id=NEW.warehouse_id ORDER BY ID DESC LIMIT 1);
    IF (@CLOSINGSTOCK IS NULL)
    THEN
        SET @CLOSINGSTOCK=0;
    END IF;

    ##movement from putaway_pending to putaway_done for good stock
    IF (NEW.stock_status_id=4 AND NEW.is_bad_stock=0 AND OLD.stock_status_id=3) 
    THEN        
        INSERT INTO skus_warehouses(sku_id, warehouse_id, company_id, comment, stock_changed_by, closing_stock, closing_pending_stock)
        VALUES(NEW.sku_id, NEW.warehouse_id, @COMPANYID, CONCAT_WS(' - ','Stock Added by putaway of serial no ', NEW.id), 1, @CLOSINGSTOCK+1, @CLOSINGPENDINGSTOCK); 
    END IF; 

    ##movement from putaway_done to blocked for an order/outward entity
    IF(NEW.stock_status_id=5  AND NEW.is_bad_stock=0 AND OLD.stock_status_id=4)
    THEN
        INSERT INTO skus_warehouses(sku_id, warehouse_id, company_id, comment, stock_changed_by, closing_stock, closing_pending_stock)
        VALUES(NEW.sku_id, NEW.warehouse_id, @COMPANYID, CONCAT_WS(' - ','Stock blocked for serial no ', NEW.id, ' for ', NEW.outward_entity_type, ' id ', NEW.outward_entity_id), -1, @CLOSINGSTOCK-1, @CLOSINGPENDINGSTOCK); 
    END  IF;

    ##movement from BLOCKED to PUTAWAY_DONE for an order/outward entity. Unblocking case, needs adjustment entry in SkuW
    IF(NEW.stock_status_id=4  AND OLD.stock_status_id=5 AND NEW.is_bad_stock=0)
    THEN        
        INSERT INTO skus_warehouses(sku_id, warehouse_id, company_id, comment, stock_changed_by, closing_stock, closing_pending_stock)
        VALUES(NEW.sku_id, NEW.warehouse_id, @COMPANYID, CONCAT_WS(' - ','Stock UNblocked for serial no ', NEW.id, ' for ', NEW.outward_entity_type, ' id ', NEW.outward_entity_id), 1, @CLOSINGSTOCK+1, @CLOSINGPENDINGSTOCK); 
    END  IF;  

    ##movement from PUTAWAY_DONE to PICKED (missed BLOCKED) for an order/outward entity
    IF(NEW.stock_status_id=6  AND NEW.is_bad_stock=0 AND OLD.stock_status_id=4)
    THEN
        INSERT INTO skus_warehouses(sku_id, warehouse_id, company_id, comment, stock_changed_by, closing_stock, closing_pending_stock)
        VALUES(NEW.sku_id, NEW.warehouse_id, @COMPANYID, CONCAT_WS(' - ','Stock blocked & picked for serial no ', NEW.id, ' for ', NEW.outward_entity_type, ' id ', NEW.outward_entity_id), -1, @CLOSINGSTOCK-1, @CLOSINGPENDINGSTOCK); 
    END  IF;

    ##movement from PICKED to PUTAWAY_DONE for an order/outward entity. Unpicking case, needs adjustment entry in SkuW
    IF(NEW.stock_status_id=4  AND OLD.stock_status_id=6 AND NEW.is_bad_stock=0)
    THEN        
        INSERT INTO skus_warehouses(sku_id, warehouse_id, company_id, comment, stock_changed_by, closing_stock, closing_pending_stock)
        VALUES(NEW.sku_id, NEW.warehouse_id, @COMPANYID, CONCAT_WS(' - ','Stock Unpicked & Unblocked for serial no ', NEW.id, ' for ', OLD.outward_entity_type, ' id ', OLD.outward_entity_id), 1, @CLOSINGSTOCK+1, @CLOSINGPENDINGSTOCK); 
    END  IF; 

    ##movement from PUTAWAY_DONE/good_stock to PUTAWAY_PENDING/bad_stock
    IF(NEW.is_bad_stock=1 AND OLD.stock_status_id=4 AND NEW.stock_status_id=3)
    THEN
        INSERT INTO skus_warehouses(sku_id, warehouse_id, company_id, comment, stock_changed_by, closing_stock, closing_pending_stock)
        VALUES(NEW.sku_id, NEW.warehouse_id, @COMPANYID, CONCAT_WS(' - ','Stock marked as BADSTOCK for serial no ', NEW.id), -1,@CLOSINGSTOCK-1, @CLOSINGPENDINGSTOCK);
    END IF;

    ##movement from PUTAWAY_DONE to INVALIDATED
    IF(OLD.stock_status_id=4 AND NEW.stock_status_id=10)
    THEN
        INSERT INTO skus_warehouses(sku_id, warehouse_id, company_id, comment, stock_changed_by, closing_stock, closing_pending_stock)
        VALUES(NEW.sku_id, NEW.warehouse_id, @COMPANYID, CONCAT_WS(' - ','Invalidated serial no ', NEW.id), -1,@CLOSINGSTOCK-1, @CLOSINGPENDINGSTOCK);
    END IF;

END; //

I know I get triggers on the trigger because that's what I found in SHOW INNODB ENGINE STATUS

*** (1) TRANSACTION:
TRANSACTION 635520869854, ACTIVE 0 sec fetching rows
mysql tables in use 5, locked 3
LOCK WAIT 1625 lock struct(s), heap size 177704, 7983 row lock(s), undo log entries 1
MySQL thread id 2085967891, OS thread handle 0x2b5e2d4d1700, query id 503500721288 10.0.10.59 primary_db_user Creating sort index
SET @CLOSINGSTOCK = (SELECT closing_stock FROM skus_warehouses WHERE sku_id=NEW.sku_id AND warehouse_id=NEW.warehouse_id ORDER BY ID DESC LIMIT 1)
*** (1) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 139169 page no 7248658 n bits 216 index `PRIMARY` of table `primary_db`.`skus_warehouses` trx id 635520869854 lock_mode X locks rec but not gap waiting
Record lock, heap no 121 PHYSICAL RECORD: n_fields 14; compact format; info bits 0

Table skus_warehouses has 100M + records, but has good indexing. All the queries below (which seem to be deadlocked) end in 0.5 to 1s.

SET @CLOSINGSTOCK = (SELECT closing_stock FROM skus_warehouses WHERE sku_id=NEW.sku_id AND warehouse_id=NEW.warehouse_id ORDER BY ID DESC LIMIT 1)

5th dnd – Do I have an advantage with Riposte when I distance myself from an enemy flanked and I trigger an opportunity attack?

Yes

You flank when adjacent to an enemy:

Flanking the squares. When a creature and at least one of its allies are adjacent to an enemy and on opposite sides or corners of the enemy's space, they flank it.

You are adjacent when you are at hand, and you are at hand at the time of the experiment.

The attack interrupts the movement of the provoking creature and occurs just before it leaves you.

So, yes, if the enemy has a range of 5 feet, you still flank at the time of the opportunity attack this enemy.

Unless otherwise specified by your SM

The standard warning: The 5th edition of D & D empowers the MD in the same way as the 3rd, the 3rd and the 4th. Although rule zero has always been applied, the 5th edition has chosen not to explicitly codify many things. If your DM says you are not, you are not.