How does the Manta Glide trait work during combat?

Consider a Simic Hybrid with the Manta Glide trait:

You have ray-like fins that you can use as wings to slow your fall or allow you to glide. When you fall and aren’t incapacitated, you can subtract up to 100 feet from the fall when calculating falling damage, and you can move up to 2 feet horizontally for every 1 foot you descend.

If the Simic Hybrid were to fall from a 50′ height while not in combat, it could unequivocally move 100′ horizontally as it falls those 50′.

However, I’m unclear what should happen if the Simic Hybrid falls during combat.

Can the the Simic Hybrid move 100′ horizontally while falling 50′ feet even if its speed is less than 100′ or even if it falls during someone else’s turn?
If not, what happens?

I need to concat data from multiple row into one column without changing the structure of actual table during export

enter image description hereI have a table item , in which SKU, size , color is there and product_code is same for parent and child product. when I import product to e-com ,under my parent, child product should be displayed. below is my table format to import. i need to concat column A+B+C matching with column D and get the SKU_config data.

Creating new node entity during presave of another node entity causes SQL Exception sometimes

We have a Donation Record Content type and a Donor content type for a Blood Bank management drupal application. A donor can have any number of donation record.

The system does not explicitly require creating a donor record prior to creating a donation record. It creates a donor record during presave of donation record if the donor reference is not provided in the URL. The system gets the reference from the created donor during presave and updates it in the donation record. Hence we now have a donor with a donation record while the user is saving a donation record.

The problem is that new donor record does not get created all the time. We get SQL Exception: SQLSTATE[42000]: Syntax error or access violation: 1305 SAVEPOINT savepoint_1 does not exist.

Is there any other way to create the donor so that this problem does not occur or am I doing something wrong.

Drupal 7.61 MySQL 5.7.24 OS: Ubuntu 16.04.5 LTS

Trace: 0 /srv/www/www.example.com/public_html/includes/database/database.inc(2227): PDOStatement->execute(Array) 1/srv/www/www.example.com/public_html/includes/database/database.inc(697): DatabaseStatementBase->execute(Array, Array) 2/srv/www/www.example.com/public_html/includes/database/database.inc(1081): DatabaseConnection->query(‘ROLLBACK TO SAV…’) 3/srv/www/www.example.com/public_html/includes/database/database.inc(1989): DatabaseConnection->rollback(‘savepoint_1’) 4 /srv/www/www.example.com/public_html/modules/node/node.module(1197): DatabaseTransaction->rollback() 5/srv/www/www.example.com/public_html/sites/all/modules/entity/entity.module(290): node_save(Object(stdClass)) 6/srv/www/www.example.com/public_html/sites/all/modules/entity/includes/enti…(885): entity_save(‘node’, Object(stdClass)) 7 /srv/www/www.example.com/public_html/sites/all/modules/custom/ji_custom/Ent…(114): EntityDrupalWrapper->save() 8/srv/www/www.example.com/public_html/sites/all/modules/custom/ji_custom/Ent…(226): DonorEntity::createNewDonorFromDonationRecord(Object(EntityDrupalWrapper))

Let user quit web app to native navigation app and get him coming back during a process

(Please edit the title if you have a better one)

Imagine a mobile web app, where the user needs at some point in a process to start a turn by turn navigation and then perform an action in the web app once s/he reached his/her destination.

I see two possibilities:

1. Develop a turn by turn navigation by myself into the web app

For this I would go with mapbox’s API’s.

Advantages:

  • User stays in the app
  • Flow is not interrupted
  • User will more likely perform the needed actions once reaching the destination

Disadvantages:

  • Need to develop the navigation system
  • More expensive (mapbox plans)
  • Even if the custom navigation could have some good quality it will probably not beat googles implementation

2. Open google maps from within the web app

It is actually possible to either just navigate to the google maps website passing some coordinates (android will then automatically open google maps app)or open the app from within the browser for IOS users. But in the other direction I think it’s not possible to navigate back automatically to the web app (browser) when closing a native app.

Advantages:

  • No need to develop nav myself
  • No costs for navigation itself
  • Probably better navigation system

Disadvantages:

  • Styles do not correspond to app
  • User is pulled out the app
  • User may not (come back) finish process as intended
  • One more click on native app (maps) for starting the navigation
  • What if the user does not have the google maps app on his device (I’m not sure if navigation is possible from the google maps website on mobile)?

So I probably missed some more points but I think the decision is already quite difficult to make.

My question is, from a UX point of view, is it acceptable (probably not) to let the user leave the app and hope he will come back or is there another solution which I don’t see?

A solution would be to send a push notification and remember the user to finish the process but push notifications are not really supported on IOS web.

Also one argument why the user could come back, is that he already did a certain amount of action during the process before starting the navigation and he would probably be willing to finish it, but there is still the possibility he would not.

Any help would be greatly appreciated.

iCloud backups from a very old iPhone are not seen during the restore

My sister used to have an iPhone 4 that I used before (she replaced the battery); she’s used it until 2013 or 2014 when the battery was not usable anymore. She’s then used an Android phone for a few years and has just bought an iPhone SE. She wanted to restore it from iCloud but the phone shows “no backups available” once she logs in to her Apple ID account during the initial phone setup.

The iPhone 4 had newest iOS 7 installed, I’m not sure what version the SE has but it may even be 12. Does Apple delete old backups if no one logged into the account for a few years? Or maybe restoring from a backup to iOS 5 versions newer is not possible? Are there any other reasons it may not work?

I’d normally try backing up the iPhone 4 again but I think it doesn’t survive long enough to back up right now, even when connected to external power.

I’d appreciate any help.

Choosing http or https during manual installation of WordPress and database

When you manually install WordPress, somewhere during the process it asks you to select weather your site uses http or https. Why is this? What does it matter? How will your choice translate to changes/a different use of eg your database?
Bc when I installed WP I chose http bc at that time I didn't had an SSL yet. Then I created a few pages, posts and categories. The URLs of these started w/ http.
Then a while later I installed SSL certificate on that domain name and since then pages, posts…

Choosing http or https during manual installation of WordPress and database

Is transit visa required for my journey via Reykjavik (KEF) where there is a date change during transitioning

I have booked a round trip flight ticket of Wow Air which is via Reykjavik (KEF) airport. My layover details are below:

New Delhi -> Toronto    (2 hrs Layover at  Reykjavik  ) Toronto -> New Delhi    (7 hrs Layover at  Reykjavik  )  

My concern is with the return ticket transit visa requirements (if any). I have read in Iceland visa sites and forums that

“Visa required, except for Holders of confirmed onward tickets transiting on the same calendar day”

My Ticket details are below. There will be a date change while transitioning in my onward ticket in the late night flight. Will it create any issue for me: I am an Indian Citizen and Canada PR? Do i need a transit Visa for any part of Journey? Please help.

Departure: Fri, Mar 22, 2019 New Delhi (DEL) 07:00Toronto (YYZ) 18:00 Flight 1: | 11h 50m | WW323 | Operated by: WOW air Layover: 2h 10m | Reykjavik (KEF) Flight 2: | 6h 30m | WW213 | Operated by: WOW air    Return: Wed, Mar 27, 2019 Toronto (YYZ) 19:00New Delhi (DEL) 03:15 + 2 day Flight 1: | 5h 45m | WW214 | Operated by: WOW air Layover: 6h 55m | Reykjavik (KEF) Flight 2: | 10h 5m | WW322 | Operated by: WOW air