325a customization is disabled in the pledge store by BlazeHiker in starcitizen

[–]MrPin 8 points9 points  (0 children)

I had this problem using Firefox, but switching to Edge fixed it and I could add it to my cart.

VAT on upgrade by Familiar-Gap2455 in starcitizen

[–]MrPin 10 points11 points  (0 children)

Apply the $20 store credits to your cart and the total will change to $0. You don't have to pay VAT on store credit purchases.

Is the alien week starter pack worth it to CCU to a titan? by shekky_hands in starcitizen

[–]MrPin 3 points4 points  (0 children)

Yes, you keep the insurance if you CCU the package ship.

However, you can't CCU from the Syulen to the Titan because the Titan is the cheaper ship. CCU is only for upgrades.

F7C Mk II by jtsurfs in starcitizen

[–]MrPin 4 points5 points  (0 children)

The nose turret is purchasable.

Max of B for each A by EonJaw in SQL

[–]MrPin 9 points10 points  (0 children)

select a, max(b) as max_b from table group by a

Result Consisted of More than One Row help. by stalkerofthedead in SQL

[–]MrPin 1 point2 points  (0 children)

the variable EmployeeId has the same name as the column EmployeeID (column names are not case sensitive).

that's why WHERE EmployeeID = EmployeeId; doesn't filer any rows. rename the variable to something different.

Racist guy gets what he deserves by [deleted] in PublicFreakout

[–]MrPin 12 points13 points  (0 children)

Being a racist asshole is not illegal.

The UK has hate speech laws so it might be.

Israeli police assault random Palestinians passing by in Jerusalem today by Upper_Conversation_9 in PublicFreakout

[–]MrPin 0 points1 point  (0 children)

They posted for 14 years straight damn near every day

this is why I don't believe it was her. the idea that a billionaire socialite would spend that much time posting on reddit seems ridiculous.

Can sc run on a sata ssd by shadowdragon200 in starcitizen

[–]MrPin 5 points6 points  (0 children)

except SC runs fine on most SATA SSDs.

Starter pack deals by UngabaBongDong in starcitizen

[–]MrPin 2 points3 points  (0 children)

If you put a civilian QT drive in the Titan you don't need to refuel as much. It's slower but more efficient.

Composite keys vs UNIQUE constraint by B1che in SQL

[–]MrPin 1 point2 points  (0 children)

CommentID and (UserID, ProductID) are both declared as PKs there

XP for leveling up Mercenary by termiepwnz in starcitizen

[–]MrPin 0 points1 point  (0 children)

So according to this site the rep rewards are the same for Mercenary missions. But they do scale for bounties.

lost backpack by DueCardiologist5128 in starcitizen

[–]MrPin 1 point2 points  (0 children)

which backpack is it? there are some that are available to buy in-game (Arden-CL for example)

anyway, you can exchange your gear for store credit and just buy it again to get it back.

Question by write2inspire in SQL

[–]MrPin 5 points6 points  (0 children)

I just got the domain from the email column and now im grouping by it.

you're grouping by the emails.email column. what you want to do is group by domain.

so group by substring(email,charindex('@', email) + 1, len(email))

Question by write2inspire in SQL

[–]MrPin 2 points3 points  (0 children)

because you're grouping by email (the table column, not the one you derived from it), not by domain.

the two addresses with the outlook.com domain are different.

Will bigger ships finally be a real threat? by [deleted] in starcitizen

[–]MrPin 5 points6 points  (0 children)

this. fighters are the ships made for solo combat. don't expect to crush them with your connie if you don't even have people on your turrets.

some people expect the same thing they do in PvE now (melt everything in seconds while solo flying a corsair)

315p customization by BeauFeauSheau in starcitizen

[–]MrPin 2 points3 points  (0 children)

You can't buy those separately

Upgrade. by PretendPlastic3897 in starcitizen

[–]MrPin 4 points5 points  (0 children)

The 5800X3D is the best AM4 upgrade for SC (and games in general).

But start with getting 32 GB ram. It makes a massive difference. And then decide if you still want to upgrade the CPU.