Staying in Colombia beyond the initially estimated duration, but less than 90 days

Coming from Ecuador to Colombia, I declared at the .EC exit and .CO immigration offices that I was planning to stay in Colombia for a month.

I’m really liking Colombia and would like to extend my stay to 2 months. Do I need to do/declare anything?

The visa (rather stamp) in my passport doesn’t have any visible duration on it (just what appears to be a signature scribble). 2 months is still well short of the 90 consecutive days period. Could I get in trouble (e.g. pay fines) when I leave that I overstayed that estimated duration, e.g. if they made an electronic record in they system?

What happens to the secret message at the end of the duration of the Illusory Script spell?

The illusory script spell allows one to hide a secret written message that either appears unintelligible or appears to be an unrelated message to anyone other than the intended recipient(s). The spell explains clearly what happens if the spell is dispelled:

Should the spell be dispelled, the original script and the illusion both disappear.

This is certainly a handy security feature: dispelling the illusion won’t reveal your secret message to snooping spellcaster. However, the spell is less clear about what happens at the end of the 10-day duration. A spell that ends due to reaching its duration is not “dispelled”, so the above clause would not apply directly. The only reference to the spell’s duration is in the first sentence:

You write on parchment, paper, or some other suitable writing material and imbue it with a potent illusion that lasts for the duration.

So, what happens when the duration of illusory script elapses? Do the illusory script and the real message both disappear, as when the spell is dispelled, thus ensuring that no one other than the intended recipient(s) can ever read the message (without truesight)? Or does the illusion disappear, leaving the real message plainly readable by anyone?

Gamer Identity Logo/Avatar – 3 Day Duration – $30 PayPal

Hi guys, I'm running another contest, this will run for 3 days and end on Sunday night.

Name: Neverside
Colors: Cyberpunk, Vaporwave colors, you can google cyberpunk colors or look at the Farcry 3 Blood Dragon poster for colors
Style: This will mainly just be used as an avatar for forums and chat rooms. I mainly play FPS games so I would like something like the letter "N" in the shape of a crosshair and maybe Neverside spelled out above, below or incorporated into…

Gamer Identity Logo/Avatar – 3 Day Duration – $ 30 PayPal

How does the aura boon work with instantaneous duration boons?

The Aura boon says:

Choose a single bane or boon which uses the same attribute that you used to invoke Aura. The maximum power level for the chosen bane or boon is one-half the power level of your aura.

The duration for aura is ‘Sustain Persists’, meaning that it only continues you use a minor action each turn to keep it active.

However, heal has a duration of ‘instantaneous’, so regularly healing only applies once. Would it apply multiple times if was used with aura?

It gets even more confusing when the regeneration boon is introduced, as that has a duration of ‘sustain persists’ and has an effect like heal, so it would be pretty useless as an aura if an aura of healing worked multiple times.

Can I maintain the same flash pulse duration but increase light with multiple flash units?

I own a Yongnuo YN-560 III speedlite, and I found out that it lets me freeze motion (for example, a water splash) at 1/16 of its power. However, the amount of light at 1/16 is not enough to properly light the scene I’m shooting.

Is it possible to increase the amount of light by using more speedlites, while maintaining the same flash duration?

What is the time duration for obtaining a short stay scientist VISA for France?

I wish to apply for a short stay VISA for France as a scientist and for this, my host institution is providing me with a protocole d’accueil document. In how many days, after the submission of protocole d’accueil and other necessary documents at the French consulate in my country, will the VISA be sanctioned?

How to search Google Maps for locations near another by travel duration?

I want to search for say pizza near 123 Main Street. I can do that (https://www.google.com/maps/search/pizza/@39.827726,-88.9411735,13z/data=!3m1!4b1), but I want the view to also allow me to enter a start location and in one search result area show me how long it takes to get to each one. I don’t want to have to click each result and then get directions – this is so tedious because you’ve gotta open tons of new tabs and middle clicking doesn’t work on Google Maps. Distance is interesting, but if the 2 mile trip requires travel through terrible traffic it’s not as good as the 6 mile trip with no traffic.

I want a “search for things near an address and include travel duration from that address directly in the results.”

sql – rolling sum till it reaches certain value and calculate duration

I have a requirement where I need to know when the sum(value) reaches certain point and calculate duration. Below is the sample table.

create table sample (dt timestamp, value real); insert into sample values (‘2019-01-20 00:29:43+00 ‘,0.2948),(‘2019-01-20 00:35:06+00 ‘,0.2948),(‘2019-01-20 00:35:50+00 ‘,0.2948), (‘2019-01-20 00:36:32+00 ‘,0.2948),(‘2019-01-20 00:37:20+00 ‘,0.2948),(‘2019-01-20 00:41:30+00 ‘,0.4261), (‘2019-01-20 00:42:28+00 ‘,0.4261),(‘2019-01-20 00:43:14+00 ‘,0.4261),(‘2019-01-20 00:44:18+00 ‘,0.4261);

select * from sample order by dt; dt | value
———————+——–

2019-01-20 00:29:43 | 0.2948

2019-01-20 00:35:06 | 0.2948

2019-01-20 00:35:50 | 0.2948

2019-01-20 00:36:32 | 0.2948

2019-01-20 00:37:20 | 0.2948

2019-01-20 00:41:30 | 0.4261

2019-01-20 00:42:28 | 0.4261

2019-01-20 00:43:14 | 0.4261

2019-01-20 00:44:18 | 0.4261

Now my requirement is to calculate cumulative sum of next records to see when the sum(value) reaches above 1.0 (it can be 1 records or n number of records) and once I find that point, I need to calculate time difference between current record and record where sum(value) reaches 1.

Essentially I want output in below format.

     dt         | value | sum(value)| time_at_sum(value)_1| Duration 

———————+——–+——————————————

2019-01-20 00:29:43| 0.29 | 1.01 | 2019-01-20 00:35:50 | 00:06:07

2019-01-20 00:35:06| 0.31 | 1.31 | 2019-01-20 00:37:20 | 00:02:14

2019-01-20 00:35:50| 0.41 | 1.00 | 2019-01-20 00:37:20 | 00:01:30

2019-01-20 00:36:32| 0.26 | 1.01 | 2019-01-20 00:41:30 | 00:04:58

2019-01-20 00:37:20| 0.33 | 1.10 | 2019-01-20 00:42:28 | 00:05:08

2019-01-20 00:41:30| 0.42 | 1.29 | 2019-01-20 00:43:14 | 00:01:44

2019-01-20 00:42:28| 0.35 | 1.12 | 2019-01-20 00:44:18 | 00:01:50

2019-01-20 00:43:14| 0.52 | NULL | – | –

2019-01-20 00:44:18| 0.25 | NULL | – | –

Anyone has ideas or pointers on how to deal with above requirement?