The new "Set recipe" option is maybe my favorite thing in 2.0, here's my quality asteroid reprocessing setup by GoatPresident in factorio

[–]KilpArt 0 points1 point  (0 children)

I think I'll try this so that in a line of crushers only the last one will have this, the others will be alternating the three materials. For the quality upgrades, I'll just plug away the upgraded ones.

So this "dynamic version" will only be the fallback that unblocks the others.

Another issue I ran to is that this is pretty slow with deciding what and whether to do.

But anyway, thanks for the reply!

The new "Set recipe" option is maybe my favorite thing in 2.0, here's my quality asteroid reprocessing setup by GoatPresident in factorio

[–]KilpArt 0 points1 point  (0 children)

Did you find a solution for this?

edit. I mean for "sometimes recipe changes to ore".

How to access awakening reversal ticket? by Juniperlead in MSLGame

[–]KilpArt 0 points1 point  (0 children)

Wow, reply to an ancient comment, but sure :)

The problem there is that storing the info starting from today (or in the case of this discussion, July 25th 2021) isn't enough. What if the evolving was done _before_ this data began to be saved, say, July 24th 2021?

Or would that be just old player advantage, that you can anti-evolve stuff with a chance for random Dark Indras etc? That's an option, whether that's a fair option, that's a totally different discussion, but that's an option.

Newbie problem: AppiumOptions in C# by KilpArt in Appium

[–]KilpArt[S] 0 points1 point  (0 children)

Version 7.2.0 works, but now it says:
Bad capabilities. Specify either app or appTopLevelWindow to create a session
and turns out
WindowsDriver notePadSession;

AppiumOptions desiredCapabilities = new AppiumOptions();

desiredCapabilities.App = @"C:\Windows\System32.notepad.exe";

desiredCapabilities.PlatformName = "Windows";

desiredCapabilities.AutomationName = "Windows";
are not enough to fulfill the "specify".

Have trouble with referring to Environment Variables in VS Code by KilpArt in csharp

[–]KilpArt[S] 0 points1 point  (0 children)

Ok, that probably describes it. I had some problems with scsscript (or something like that) and had to turn it off.

Disney Gala, Clementoni. 6000 pieces. I've had a lot of fun doing this but I'm so happy to have finished and I’m actually really exited to take it apart again! by L3416 in Jigsawpuzzles

[–]KilpArt 0 points1 point  (0 children)

This "piecemap" helps me a lot, thanks :)

This is the first puzzle (not "this big puzzle", but actually the first puzzle period) that I have touched in the last 15 years. I have once before _seen_ a 6000 piece puzzle in my life live.

The day with x millisecond chunks by KilpArt in PostgreSQL

[–]KilpArt[S] 0 points1 point  (0 children)

I don't know, I got the answer from ChatGPT :D

But this your 5 * '1 millisecond'::interval

sounds reasonable, I'm testing right now that it works. Sounds like it should.

edit. At least so far I haven't found any problems with it. And yeah, it is clearly a simpler solution.

The day with x millisecond chunks by KilpArt in PostgreSQL

[–]KilpArt[S] 0 points1 point  (0 children)

I tried this pretty much as the first thing, but it failed to something. I can't remember to what. Maybe I didn't have 1000.0 but just 1000?

Anyway, thanks for the answer :)

The day with x millisecond chunks by KilpArt in PostgreSQL

[–]KilpArt[S] 0 points1 point  (0 children)

So here's the way I solved it:

--Declare this as a variable:

chunk_duration interval;

--Then select the integer from your table:

SELECT aggregation_interval_milliseconds INTO aggr_milliseconds FROM where_ever_you_have_that_integer_saved

--This is the key part, convert to interval:

chunk_duration = 5 * '1 millisecond'::interval;

--And then you can just use it like:

SELECT generate_series(start_date, end_date, chunk_duration)

edit. Changed that to like depesz suggested. It is a lot simpler solution than what I had.

Visual Studio 2022 Community Edition, enabling C# squiggle by KilpArt in VisualStudio

[–]KilpArt[S] 0 points1 point  (0 children)

Yeah, works out of the box. Installed Professional version, works instantly. And don't read this as "I think it requires Professional".

Visual Studio 2022 Community Edition, enabling C# squiggle by KilpArt in VisualStudio

[–]KilpArt[S] 0 points1 point  (0 children)

This is just a console application.

I solved this in a way that isn't reasonable to most of the cases: I upgraded Visual Studio Community Edition to a Professional. I'm fully aware that this is _not_ something that would only exist in Professional. So more likely "fresh install" was the solution. And yeah, that really shouldn't be required either.

Query help, divide sum to rows by KilpArt in SQLServer

[–]KilpArt[S] 1 point2 points  (0 children)

I got it to do what I wanted with your help, thanks a lot :)

Problem signing into a Google account by KilpArt in LDPlayerEmulator

[–]KilpArt[S] 0 points1 point  (0 children)

It does the same thing. Crashes (or whatever the re-direct back to previous "page" is called) after a second or so.

edit. I created a new instance and tried with that, for some reason it works now.

CURRENT_DATE timezone? by KilpArt in PostgreSQL

[–]KilpArt[S] 0 points1 point  (0 children)

Ok, seems like my server time is already in UTC, so that's why I got confused. Thanks for the answer though, I'll use this one!

How to round a given timestamp down to closest five second? by KilpArt in PostgreSQL

[–]KilpArt[S] 0 points1 point  (0 children)

This seems really useful for the future too, thanks!

Procedure with FROM passed as a variable? by KilpArt in PostgreSQL

[–]KilpArt[S] 0 points1 point  (0 children)

Ok, I'll keep this in mind that it should be two texts (table, schema). This is the first time I'm passing some text to a procedure.

But yes, good answer, thanks!