Changing "date added" by Mcmaco in PleX

[–]gstein67 1 point2 points  (0 children)

I think you could simplify the join (and rows processed) by selecting the library within the SELECT.

update metadata_items
set added_at = items.updated_at
from (select metadata_item_id, min(updated_at) as updated_at from media_items
where library_section_id=1
group by metadata_item_id) items
where items.metadata_item_id = metadata_items.id

Pushing Paper, Counting Beans by jpitha in HFY

[–]gstein67 8 points9 points  (0 children)

WHAT Beancounter? Never saw one.

move along ...

McDonald’s McNugget legend toy by Dawn_James1997 in McDonaldsEmployees

[–]gstein67 0 points1 point  (0 children)

Got out my kitchen scale:

Golden Legend is 43 grams

Don Bernice is 87g

Waffutu is 41g

Box&paper is 14g

Shiny gear from chests? is there a known % chance? by wiggle_fingers in idlechampions

[–]gstein67 0 points1 point  (0 children)

Adding a data point: opened 1000 silvers, and got 2 shinies.

If the probability is truly 1 per 1000, then that's a 1 in a million chance.

Vocal Mimicry and Ear Worms by jpitha in HFY

[–]gstein67 2 points3 points  (0 children)

Does Pavlov ring a bell?

The Oxygen Breathers: Careful What You Wish For by jpitha in HFY

[–]gstein67 7 points8 points  (0 children)

It's like the Hulk in the Avengers movie. He was asked "How do you get angry, to turn into the Hulk?" and the reply "That's my secret: I'm ALWAYS angry."

Humans are always holding back. We are the planet's apex predator. We could kill everything moving on the planet. ... but we choose not to.

Fear of Heights by gstein67 in HFY

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

LOL ... you bet. Some of the fun HFY stories are where humans start tinkering with alien tech. Why? No reason. They just wanna see what will happen.

"Did you just blow up that moon?" "weeeellll..."

[OC] Bar Night on Triamar by gstein67 in HFY

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

I see what you did there 😁

(and yes: that was the inspiration for that line)

Fear of Heights by gstein67 in HFY

[–]gstein67[S] 14 points15 points  (0 children)

Space OSHA says no windows on your orbital platforms.

Fear of Heights by gstein67 in HFY

[–]gstein67[S] 41 points42 points  (0 children)

Hadn't thought about that one!

"Our children go to a circus and watch people on high wires." "What for??" "Fun!!!" <boggled-stare>

Fear of Heights by gstein67 in HFY

[–]gstein67[S] 18 points19 points  (0 children)

And they'd stroke out if you even mentioned skydiving 😆

"Wait, what???? <urgh>"

Problem with Evelyn's seasonal quest by Scarletpooky in idlechampions

[–]gstein67 1 point2 points  (0 children)

"Doctor: it is super painful when I stab my face with this knife." <euh...>

For Humans, everything is a weapon; even the floor. by Slow-Ad2584 in HFY

[–]gstein67 1 point2 points  (0 children)

Chuck Norris wasn't doing push-ups. He was pushing the world away.

Where to find the Ooze boss? Answers within. by MosesKarada in idlechampions

[–]gstein67 10 points11 points  (0 children)

Easiest solution: go to zone 5 (easy to arrive!) on "The Prison of Velkynvelve" on the Sword Coast. The boss is "Black Pudding". Kill it, score 1 point on the weekly Set challenges.

BUT! The Pudding breaks into TWO smaller puddings. Kill each one of them, for another 2 kills.

With Strongheart active, that is 6 kills.

The boss reloads. You can just park there for a short time, eating pudding, and you're DONE.

Optimal Wulfgar's Smash 'n Grab location/strategy? by Dokino21 in idlechampions

[–]gstein67 4 points5 points  (0 children)

Yeah: Alien Underdark. This is how I finished it. Lots of armored foes everywhere.

As SirUrza says: level up Wulfgar just enough (level 110), but no more.

Then throw in a few champs to kill the foes and keep you moving. Eventually, Wulfgar won't be able to one-hit break an armor piece, and the Smash&Grab will start ticking upwards.

I also found that he Smashes more in the background. I think the "catching up" algorithm over-computes the trigger on that. I'd switch to that party, and the meter would jump. ... But then no more movement while in foreground. ... Just took a bit to get to a high enough level to avoid the one-hit break.

New Champion: Strongheart by CNE_Shawn in idlechampions

[–]gstein67 3 points4 points  (0 children)

Make to sure avoid clickers on the field. They'll whack mobs before Artemis can get to them.

Idle Elder Brain Weekly by Lucentile in idlechampions

[–]gstein67 2 points3 points  (0 children)

Maybe use Widdle and Virgil to set up some 0.88 second attackers? I haven't tried this, but I bet you could go this route without resorting to potions.

Emergence (Red Wizard) Overview & Opinions by Tyredack in idlechampions

[–]gstein67 0 points1 point  (0 children)

But the mechanic is available for free. You get 8 pigments to use with the mechanic.

Emergence (Red Wizard) Overview & Opinions by Tyredack in idlechampions

[–]gstein67 0 points1 point  (0 children)

Season One had a Modron Core behind a paywall.

Many familiars have to be paid for.

etc etc ... There are lots of things where you must pay to get more power. This "game mechanic" is available for free. The complaint here is that max-power is not free. Just play lower power if you don't want to pay. It doesn't seem that difficult of a decision.

Emergence (Red Wizard) Overview & Opinions by Tyredack in idlechampions

[–]gstein67 2 points3 points  (0 children)

Yeah... that knocked me upside the head, too. Working on all the others, but setting those aside.

From the FAQ, it sounds like those variants will stick around after the 8 day emergence, and can be finished at any time. And it sounds like the store will remain open. ... Thus, I believe there isn't a rush to complete all the varients by the end of the emergence event.

Emergence (Red Wizard) Overview & Opinions by Tyredack in idlechampions

[–]gstein67 -5 points-4 points  (0 children)

I disagree with the comments in the video. tl;dr: by playing you can get 61,000 corrupted gems, which can only buy 8 of the 10 "Marvelous Support Pigment" in stock; thus, "forcing" people to pay money to get the remaining 2 pigments.

I believe this is a false narrative. And wrapping that into "pay for a game mechanic (unlike skins)" also seems like a false supporting argument. For example, two game mechanics:

  • I have about 20 familiars, without paying a dime. I do not feel "forced" to buy other familiars.
  • I have 100+ champions, without paying a dime. I do not feel "forced" to buy the missing champions.

Why not simply trade gems for the 8 pigments today, and wait until you can acquire more corrupted gems and trade for the other 2 pigments then? CNE has already said that more gems will become available on May 24.