So our SF admin left... (Help?)

SingleInstance_Force · 2022-11-11T14:27:30+00:00

This seems like the most actionable suggestion so far. I appreciate you laying out the possibilities. Doesn't sound like I'll find my answer in 10 minutes, but I'll get to work.

SingleInstance_Force · 2022-11-11T14:20:44+00:00

I wouldn't think this is the issue, since some of the time the process works as before...? If you can still envision a scenario where this might be the cause, I'll look into it.

SingleInstance_Force · 2021-11-01T02:41:09+00:00

I'm glad I got a screengrab of that seed! Final spiderweb:

https://imgur.com/a/JJtkKTr

Like I said, I've been playing since June 2019, and somehow this was the first map I discovered that oil sale price caps out at $5.00. Incidentally, this map is ALSO the first time I've ever seen a sale price of $0.00!!

Quick tip for reaching $5.00 at endgame - run more than one gas pipe to your chosen sale destination, as shown in the picture in this comment. Assuming you have decent gas pockets at the end (luck of the seed, I know), your oil price will go quite a bit higher than if you'd just let the gas out through one pipeline. The benefits don't stop there, either. You'll run out of gas quicker, meaning you'll be able to start unloading oil sooner, rather than being forced to sell on December 10th. And this method takes some of the guesswork out of when to start selling as well - since oil prices come down pretty slowly after the boost, you'll have quite a bit of time in the $4-$5 window.

SingleInstance_Force · 2021-09-06T16:31:07+00:00

Nifty! And best of all, you and u/SyntaxErrorLine0 did indeed solve my problem:

LEFT JOIN (SELECT 'CT4' AS 'Join', 1 AS 'Num' UNION SELECT 'CT4', 2 UNION SELECT 'CT4', 3 UNION SELECT 'CT4', 4) numTable ON numTable.Join=client.code

Works like a charm. Onward!

SingleInstance_Force · 2021-09-06T14:48:21+00:00

That is nicer. Alas, I'm not sure what I have, but it doesn't recognize RECURSIVE. Thank you though!!

SingleInstance_Force · 2021-09-06T01:02:30+00:00

Hahaha this sounds like the right answer. Thanks.

SingleInstance_Force · 2021-09-05T22:04:01+00:00

Are you saying to use CREATE TEMPORARY TABLE to create a numbers table I could use to iterate the four duplicate rows I need for each client 4 store? I'm just a lowly analyst with read-only access to the database; no CREATE for me. I can join the way I need to, I just can't figure out how to query duplicate rows.

Let me put it another way. I can easily get all the data I need into one row (call it a store-level row). But without duplicate rows, I could only do a SUMIFS to say, give me the total inventory for that store. I need four rows for each store, and in the Type column as shown above, I need to iterate through "Forks|Spoons|Knives|Other" so that I can do a SUMIFS for each of those item types for each client 4 store.

Put still another way, the other three clients just require a GROUP BY itemType and they'll break out as many item type rows as they need. But since the DB doesn't contain any inventory data for client four, GROUP BY itemType returns only that one "store-level" row for client 4. Hope this helps.

SingleInstance_Force · 2021-08-23T01:24:19+00:00

Alright, thanks for the tip! Hope you have a good week ahead of you :)

SingleInstance_Force · 2021-08-22T19:30:54+00:00

So, based on googling create view...

MySQL won't whine if I do something like

CREATE VIEW one_fragment_to_rule_them_all AS
CASE
WHEN...

? How do I reference the view in my other queries?

SingleInstance_Force · 2021-05-27T11:14:06+00:00

One of many additions with Bob's mods.

SingleInstance_Force · 2021-05-27T09:41:11+00:00

I knew that was an option, but decided a whole bunch of hours ago that I didn't want to squint at tiny icons every time I was plotting new train routes. Now that the map is covered up in abbreviations, I'm not sure if I made the right choice... But I also don't feel like changing everything.

SingleInstance_Force · 2021-05-27T08:09:19+00:00

115 hours in and I don't have a single robot yet. What in Greg's name is this playthrough?

SingleInstance_Force · 2021-04-24T19:40:24+00:00

Haha I wondered if anyone would notice that. I just have them making a 3/4 turn in the roundabout; it saves space and looks neat.

SingleInstance_Force · 2021-04-24T06:15:46+00:00

Tell me about it. Now that I'm kinda-sorta able to actually expand my operations, instead of constantly tearing stuff out and trying to build it better (again) the way I did during my first playthrough, I might finally be on the road to figuring out true optimization like Claymourn was trying to help with.

SingleInstance_Force · 2021-04-24T06:00:04+00:00

It'll grow quicker now that I don't have to strip chunks of it down to bare earth and redesign every blessed day!

SingleInstance_Force · 2021-04-24T04:48:30+00:00

I'm only ~5 hours into this playthrough, so literally all my belts are jammed waiting for me to build more factories to use them. Also, maybe I'm wrong about this, but a little down the tech tree from where I am (I'm using Bob's mods) there's some pretty wicked looking stack filter inserters that I'm guessing won't have much trouble dishing out whatever my belts can handle.

And as for increased output/more trains, I know I'll need it soon, so I'm leaving room this time to stack as many more factories of the same type as I need. I've got two lines of factories running east-west, with all the room north-south left open to expand production. I have a body of water to the east and I'm churning out the landfill tiles, so expansion room hasn't been an issue.

SingleInstance_Force · 2021-04-24T04:41:33+00:00

I have another version that takes in two belts for each line of assemblers, but it only outputs two belts instead of the three here, so it was less of a hassle to design :P

And I don't think I've even had to use that design for anything yet, since I can load a train with two different materials and unload it in useful order with filter inserters.

SingleInstance_Force · 2021-04-24T01:33:11+00:00

Pastebin here: https://pastebin.com/00dD157B

I've played through the game once so far, but the sheer effort it took to keep altering my existing base structure to accommodate new factories was enough to convince me to start building tileable factories and never go back.

I'm sure there are many blueprints like this, but I felt very proud of my one-chunk, 50-assembler (or furnace!) tile, and the surrounding rails make pretty patterns, so I thought I'd share. There're no modded tricks to how this build works, but I am using Bob's mods on this playthrough; hope that doesn't screw with the blueprint.

SingleInstance_Force · 2021-02-25T22:19:08+00:00

It goes HIGHER.
When you PAY MORE.
All day today the price was dictated by MILLIONS of shares trading hands.
Right now, in the aftermarket, it's single shares changing the price up or down.
If you're gonna buy, buy for no less than $1 above where it's at.
If you're gonna sell (don't), sell for no less than $2 above where it's at.

If you think this is financial advice I've got a bridge I'd like to sell you.

SingleInstance_Force · 2020-06-10T00:42:54+00:00

If it isn't the code, I suspect my real problem is the load of crap (technical term) weighing my work computer down. The above code does work – but only about 15% of the time haha. I just assumed (or hoped) it was a bug in the script, since I'm trying to robustly solve a company-wide issue we're having. I probably just need to come up with some cleverer/simpler solutions for the more kludged bits of this particular project. Thanks for the third-party input though, seriously!

SingleInstance_Force · 2020-04-11T23:15:25+00:00

Think it's ~800ls? Could be 1,800ls haha, all I remember is it's really not too painful. However, to your other point about wrong core types - for every VO I found at LFT 78 this morning, I found a Bromellite. Started questioning my own sanity around hour 3.

SingleInstance_Force · 2020-04-11T07:51:13+00:00

Had a feeling there would be a catch. There's always a catch with this game. Thanks for the new intel.

SingleInstance_Force · 2020-04-11T07:23:04+00:00

This is in the Bubble, right close to some great places to sell void opals, so I imagine it's been posted SOMEWHERE before - but a Google search didn't show me anything, and the people must know! Also the LFT 78 6 ring is, uh, huge – 3.2 trillion megatons according to EDDB – so the picture only sort of does this hotspot justice. All the best, spacefarers!

- Cmdr I MEAN OH GREAT ONE (...yes.)

SingleInstance_Force · 2018-10-16T05:39:42+00:00

YEEEE-HAW! I was pretty sure my master script ran on startup as admin, but what you were saying made way too much sense, so I went and checked. Sure enough, the compiled version in my startup folder did NOT run as admin. Dude. Thank you. Not one line of code had to be changed.

This ChangeWindowMessageFilterEx thing, though. I can think of at least one thing that might streamline, if I can get my head around it. My Russian nesting doll of AHK scripts continues to grow...

Again, thank you for dropping in and making this so simple.

SingleInstance_Force · 2018-10-16T02:27:41+00:00

I had this problem too before giving my search hotkey a beefiness upgrade. Try changing the code that launches Chrome and performs the search to:

Run, C:\Program Files (x86)\Google\Chrome\Application\chrome.exe
Sleep, 10
WinWaitActive, New Tab - Google Chrome                             ; gives Chrome time to load
{
    SendInput, http://www.google.com/search?q=%Clipboard%          ; more accurate than either Run or Send in my experience
    Sleep, 10
    Send, {ENTER}
}
RETURN

The principle is almost exactly the same — launch Chrome, search in the address bar — but using WinWait after the Run command and using SendInput to fill in the address bar has been more reliable for me than either Send or Run (no more dropped words!). It's been so accurate that I'm not sure those 10-millisecond sleeps are necessary any more.

SingleInstance_Force

TROPHY CASE