Does Leomund’s Secret Chest last only 60 days reliably, or can this timer be reset?

Leomund’s secret chest is a spell that lets the caster hide a very expensive chest in the Ethereal Plane. However, its drawback is that after 60 days, there is a chance the spell ends. If the spell ends while the chest is in the Ethereal Plane, it’s lost forever.

My question is, where does the 60 day counter start? Is it from the moment of casting, so that you need to re-cast the spell every 60 days? Or do you just need to recall the chest every 60 days to check on its contents?

What is the going rate for forum posters these days?

What is the going rate for forum posters these days?

I need to hire some forum posters to help a new site take off.
What are forum posters charging these days?

Its a mixed forum, no specific niche,
so you can post whatever you want, except porn and adult content.
Travel, vacations, finance, news, anything is ok.

But posts should be distributed between 10-20 accounts at least. All should not be from same account.

What would a forum poster charge for this?

Why is no care put into designing high-quality software these days? [closed]

I have just come back from a nightmare. The nightmare consisted of me having previously installed PostGIS into my PostgreSQL database according to the installation instructions by PostGIS.

This made it live in the “public” schema, with all my stuff, polluting the functions and adding an internal table among mine.

With a lot of trouble, I finally was able to create a “PostGIS” schema, into which I reinstalled PostGIS, then recreated all the columns the “DROP CASCADE” had removed (because they used a PostGIS type).

Now, I started getting errors because internal queries made by PostGIS did not quote the schema, but simply took my “PostGIS” string and turned it into:

... FROM PostGIS.test = blabla 

Since this is invalid syntax, it failed. And I was forced to go through the ordeal of renaming the PostGIS schema into “postgis”, just so that their internal, broken queries would work.

But it doesn’t end there. Now I started getting other errors, because renaming the schema did not change all kinds of internal references, so it would still refer to “PostGIS” even though both the extension and the schema were now “postgis”…

I eventually (today) did it all over again from scratch and again recreated my columns manually and filled them up with all the data.

I see this all the time where software developers cut corners and don’t test their stuff for any other situation than what specifically they use/do, so whenever somebody does things differently (or, as I would call it: correctly!), they (the users) are the ones who suffer because of the developers’ ignorance/laziness.

And yes, I know it’s free software blabla, I didn’t pay for it so they can waste as much of my time and energy as they please, and I can “submit patches” to fix it (because I can’t wait to dig into their internal code and figure out how to make that change to fix their software…), etc. I’ve heard it all many times before. I know the excuses.

The fact remains that not only PostGIS but just about anything I ever use just breaks down immediately in horrible ways unless you use them in an extremely specific manner, and I hate this lack of care to “details”. In this case, I would say it’s a fundamental error to not properly quote identifiers such as schemas, table names and column names, but of course this will fall on deaf ears as any criticism of anything always does, no matter how warranted and serious.

MySQL / MariaDB Get last 7 days summarized and with avarages calculated

currently, I have this table:

CREATE TABLE `plant_data` (     `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,     `plant_id` BIGINT(20) UNSIGNED NOT NULL,     `temperature` DECIMAL(5,1) UNSIGNED NOT NULL,     `light` SMALLINT(5) UNSIGNED NOT NULL,     `created_at` TIMESTAMP NULL DEFAULT NULL,     `updated_at` TIMESTAMP NULL DEFAULT NULL,     PRIMARY KEY (`id`), ) 

with the following example data:

INSERT INTO `plant_data` (`id`, `plant_id`, `temperature`, `light`, `created_at`, `updated_at`) VALUES (1623, 14, 22.2, 35, '2020-02-16 09:00:06', '2020-02-16 09:00:06'); INSERT INTO `plant_data` (`id`, `plant_id`, `temperature`, `light`, `created_at`, `updated_at`) VALUES (1622, 5, 22.8, 33, '2020-02-16 09:00:06', '2020-02-16 09:00:06'); INSERT INTO `plant_data` (`id`, `plant_id`, `temperature`, `light`, `created_at`, `updated_at`) VALUES (1621, 14, 22.8, 36, '2020-02-16 08:00:07', '2020-02-16 08:00:07'); INSERT INTO `plant_data` (`id`, `plant_id`, `temperature`, `light`, `created_at`, `updated_at`) VALUES (1620, 5, 23.3, 33, '2020-02-16 08:00:07', '2020-02-16 08:00:07'); INSERT INTO `plant_data` (`id`, `plant_id`, `temperature`, `light`, `created_at`, `updated_at`) VALUES (1619, 14, 23.1, 36, '2020-02-15 07:00:11', '2020-02-15 07:00:11'); INSERT INTO `plant_data` (`id`, `plant_id`, `temperature`, `light`, `created_at`, `updated_at`) VALUES (1618, 5, 23.8, 34, '2020-02-15 07:00:11', '2020-02-15 07:00:11'); INSERT INTO `plant_data` (`id`, `plant_id`, `temperature`, `light`, `created_at`, `updated_at`) VALUES (1617, 14, 24.4, 38, '2020-02-15 06:00:09', '2020-02-15 06:00:09'); INSERT INTO `plant_data` (`id`, `plant_id`, `temperature`, `light`, `created_at`, `updated_at`) VALUES (1616, 5, 24.6, 34, '2020-02-15 06:00:09', '2020-02-15 06:00:09'); 

I want to get the average values of the last X days as one row for each day. I could do it with X querys for each day like

SELECT plant_id, avg(temperature) FROM plant_data WHERE created_at >= '2020-02-16 00:00:00' AND created_at <= '2020-02-17 00:00:00' GROUP BY plant_id; 

But I want to know, if it is possible to get the data with one query to get a result like this:

+----------+------------------+------------+ | plant_id | avg(temperature) | day        | +----------+------------------+------------+ |        5 |         24.58000 | 2020-02-16 | |       14 |         24.42000 | 2020-02-16 | |        5 |         23.58000 | 2020-02-15 | |       14 |         23.42000 | 2020-02-15 | +----------+------------------+------------+ 

Would be nice if someone has a good idea for doing this to save me query time.

Can You Use Create a System using Glyph of Warding to Cast Teleporation Circle all 365 Days

Just curious if there’s some ingenious way to set up several glyph of warding spells to activate simultaneously. Some of them cast teleportation circle, Some of them to receive glyph of warding and store a casted teleportation circle.

In this way in 365 days you can enjoy a cheap efficient circle with the mats of but a few while exploring?

Suggestions for show how many days? Passing the International Date Line

Little background Let’s say you fly from the United States to Japan and suppose you leave the United States on Tuesday morning. Because you’re travelling west, the time advances slowly thanks to time zones and the speed at which your aeroplane flies. But as soon as you cross the international dateline, it’s suddenly Wednesday.

Below image from google flight, which is +2 means taking 2days gap. this +2 doesn’t make a sense for me.

enter image description here

index links these days

about one year ago option “fetch as google” was removed from search console.

I am using to ping links some websites and sources (rapid indexer) from scrapebox

but i am not successfull

My qusetion is:

How do you index links these days?

How to count number of distinct days from one table using two dates (for range) from another table for each row?

So I have one datatable with three columns: userid, mindate, maxdate. I have another datatable that contains all the login logs for each user.

I need to make a query so that I can sum all the distinct login days from one datatable between the mindate and maxdate from another datatable for each user.

The code I can write until:

SELECT a.*, b.logins FROM ‘usertable’ as a
LEFT JOIN (SELECT user_id, COUNT(DISTINCT(loginday)) from ‘logintable`
GROUP BY user_id) as b
on a.userid = b.user_id;

I just need help adding a ‘where’ statement that can query from b like:
WHERE loginday between a.mindate and a.maxdate.

Thank you!

[ Buying & Selling ] Open Question : BOUGHT A USED CAR FROM AUTONATION TWO DAYS AGO AND HAS MOTOR mount ISSUES, should I return for my money back or fix?

I bought a car two days ago checked it with my husband. After a few days driving I realized there is a vibration that keeps bothering me. The motor mounts ended up being the problem. I spent so much money on the deposit for the car that it’s hard for me to fix it at this point. The car has a 5-day money back guarantee. I have mixed feelings, should I fix it for $ 500 if the car is worth $ 10,000 based on the inspection. I paid $ 8,900 but I feel like the dealer should have taken care of it. FYI it’s in FL, the car is a Lexus RX 330 old model 2004. Dealer said I should have purchased the warranty if I wanted them to fix it. But they didn t disclose the information on the motor mounts that was stated in the INSPECTION DOCS I found later in the hood of the car from August of this year. They did not fix them because of the cost. Can they sell a car like that without letting you know? I feel very shady about this whole situation… I have a mechanic who will fix the 3 motor mounts for $ 300 but I put so much money into the deposit and insurance… dont know if its worth it Dealer said they will not fix it because I did not purchase the warranty but dont they have to disclose any major issues? Also, they have a 5 day money back guarantee so Im thinking thats my only option. The mechanic saw the rest of the car and said everything else is good. Brakes are new and compressor and valves look new, no leaks.

[ Buying & Selling ] Open Question : BOUGHT A USED CAR FROM AUTONATION TWO DAYS AGO AND HAS MOTOR mount ISSUES, should I return for my money back or fix?

I bought a car two days ago checked it with my husband. After a few days driving I realized there is a vibration that keeps bothering me. The motor mounts ended up being the problem. I spent so much money on the deposit for the car that it’s hard for me to fix it at this point. The car has a 5-day money back guarantee. I have mixed feelings, should I fix it for $ 500 if the car is worth $ 10,000 based on the inspection. I paid $ 8,900 but I feel like the dealer should have taken care of it. FYI it’s in FL, the car is a Lexus RX 330 old model 2004. Dealer said I should have purchased the warranty if I wanted them to fix it. But they didn t disclose the information on the motor mounts that was stated in the INSPECTION DOCS I found later in the hood of the car from August of this year. They did not fix them because of the cost. Can they sell a car like that without letting you know? I feel very shady about this whole situation… I have a mechanic who will fix the 3 motor mounts for $ 300 but I put so much money into the deposit and insurance… dont know if its worth it Dealer said they will not fix it because I did not purchase the warranty but dont they have to disclose any major issues? Also, they have a 5 day money back guarantee so Im thinking thats my only option. The mechanic saw the rest of the car and said everything else is good. Brakes are new and compressor and valves look new, no leaks.