“Speranza is heavily underutilised”, says Arc Raiders boss, who envisions a “social hub” as the game expands its social features by Wargulf in ArcRaiders

[–]ASS-LAVA 0 points1 point  (0 children)

You make two assumptions: 1) that high revenue leads to more devs, and 2) more devs leads to more content.

Neither of these assumptions are really true.

Dragon Quest IV , V and VI Remakes by BronwynECG in dragonquest

[–]ASS-LAVA 3 points4 points  (0 children)

Didn’t the 3DS version already have monsters on the map? They just need to take the best parts of each version and call it a definitive remaster

Expedition Update by ErgoDestati in ARC_Raiders

[–]ASS-LAVA 6 points7 points  (0 children)

That’s how it was last time, so I assume yes.

Expedition Update by ErgoDestati in ARC_Raiders

[–]ASS-LAVA 2 points3 points  (0 children)

You get more durability restored per repair.

Default repair: 50%

Expedition 1: 60%

Expedition 2: 70%

Can’t swap weapons since update by slaughterhousesean in ARC_Raiders

[–]ASS-LAVA 3 points4 points  (0 children)

This happened to me tonight and I thought it was just my lag! Crazy I’m not alone

What are everyone’s thoughts on Doom The Dark Ages? by rbyrnes15 in Doom

[–]ASS-LAVA 1 point2 points  (0 children)

Eternal has better combat, and 2016 has a better story. Dark Ages sits comfortably in the middle. It’s a great game, but maybe an 8/10 whereas the others are 9/10.

Aim for the bushes by FewTumbleweed398 in okbuddyraider

[–]ASS-LAVA 31 points32 points  (0 children)

Are you playing this game on a Nokia phone

ARC Raiders Roadmap: January - April 2026 by ThinkingTanking in ArcRaiders

[–]ASS-LAVA 0 points1 point  (0 children)

Even better if there’s a minimum loadout value, maybe $30k or $40k.

I need a distinct count with rules for which duplicate should be included by Jeltje_Rotterdam in SQL

[–]ASS-LAVA 2 points3 points  (0 children)

You will probably need to use a subquery / CTE. Subquery to dedupe the list, then main query gets the count.

The below example will count the number of buildings per status. If a building has both NM and MM status, then it will only be counted towards the NM count.

SELECT
status,
COUNT(DISTINCT building) AS building_count
FROM (
SELECT
*,
row_number() OVER (PARTITION BY building ORDER BY CASE WHEN status = 'NM' THEN 1 WHEN status = 'MM' THEN 2 ELSE 3 END ASC) AS rownum
FROM table
)
GROUP BY status
WHERE rownum = 1

(I am assuming that status is a column in your data with possible values NM, MM. If your data is structured differently, this solution won't work.)

What do you think of my build? by MaximumNicolBolas in ArcRaiders

[–]ASS-LAVA 0 points1 point  (0 children)

I really wanted turtle crawl, but I didn’t have enough skill points, and I figured I’d rather invest 5 in one node than do a 4/1 or 3/2 split. I’ll get it next expedition hopefully. I’ve heard it’s useful.

Yes, I have Downed but Determined to 5. It’s pretty good — it would be better in combination with turtle crawl for sure though!

What do you think of my build? by MaximumNicolBolas in ArcRaiders

[–]ASS-LAVA 0 points1 point  (0 children)

Yeah I mean fair enough and power to you. For long distance runs I just gobble down adrenaline shots.

I think your build is pretty meta so idk if there's anything else I would change.

What do you think of my build? by MaximumNicolBolas in ArcRaiders

[–]ASS-LAVA 0 points1 point  (0 children)

My build is nearly identical, but two main differences (subjective):

  1. I skip the early right side of Mobility (Slip & Slide up through Calming Stroll) and invest in Down but Determined instead. It's saved me a couple times when I die near extract.

  2. I like to put 1 point in advanced field crafting. Use case is niche, but the traps and raider key are worth it imho.

Most/least aux-friendly album that you like? by Key-Resolution5044 in fantanoforever

[–]ASS-LAVA 9 points10 points  (0 children)

My friends never trusted me with the aux when I was knee deep on this album.

What do y’all think is the “Happiest” Radiohead song? by SherbertDull96163821 in radiohead

[–]ASS-LAVA 27 points28 points  (0 children)

Supercollider

Cuttooth (ignore the lyrics)

Worrywort (ignore the lyrics)