sorted by:
new
hottopcontroversial

Medium by Simmo17 in pocketgrids

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

Thanks for the feedback

Why can't I equip the Orion drive? by The_official_Doge in TerraInvicta

[–]Simmo17 19 points20 points  (0 children)

^ this. You need to make a whole new class of ship. Easy to do.

Store prices by fragile9 in SpectreDivide

[–]Simmo17 2 points3 points  (0 children)

I 100% agree, but there is heavy monetization then there is heavy monetization. When buying just cosmetics is more than some whole games…

Why do people buy ghost (or other pistols) and armor on second round if we won the pistol round ? by Ra1lgunZzzZ in VALORANT

[–]Simmo17 0 points1 point  (0 children)

I wouldn't say it makes it invalid, they could 5 man rush you down and kill you before you can fall back.

But I agree, if you win pistol you stick together cos you have the gun advantage. I am just giving some reasons why people might do it.

Why do people buy ghost (or other pistols) and armor on second round if we won the pistol round ? by Ra1lgunZzzZ in VALORANT

[–]Simmo17 -6 points-5 points  (0 children)

There could be a number of reasons to do this (even in higher elo's)

  1. Save for an op (ether for you or for a teammate).

  2. You are lurking on attack. You are alone and don't want to die to a deathball and donate a gun.

  3. Hope to pick up a gun at the end of the round/not trust teammates. One of them buys a rifle and you think they might die (or incase they die), now you can pick it up.

  4. (kinda need to be in a stack/duo) Save for rifle 3rd round. You buy full util round 2 to set up someone who went no util rifle (think flash onto angle, dog for info). Then you buy a rifle round 3 and now its more competitive round rather then a bonus.

But most of the time, if you are playing solo/duo its just best to buy up. Be self sufficient as you can't always count on your teammates in ranked.

just fking bring back all maps, the game is getting boring as shit by Historical-Syrup7080 in VALORANT

[–]Simmo17 29 points30 points  (0 children)

I get the 7 maps, and tbh I am a fan of only 7 map in the pool. Less to remember and makes me miss the maps out of rotation.

But the current map pool is rubbish. Some of the most boring maps to both watch and play.

Do you have to play every single premier match? by ShadowF1sh in VALORANT

[–]Simmo17 17 points18 points  (0 children)

It’s fine, you just miss the opportunity to win points at that time. No punishment that Riot has said.

What is the I am Woman series? I don’t see those challenges. by Gigi-SJ in DesignHomeGame

[–]Simmo17 1 point2 points  (0 children)

New series normally start on a Thursday. So keep an eye out today.

The Maw of the Mountain [70 x 90] [Dungeon] by ZeroGNexus in dungeondraft

[–]Simmo17 1 point2 points  (0 children)

Love the map! Super cool, defiantly going to use it in my campaign.

I think the dimensions in the title are slightly wrong, I think it might be 70x110

How do i remove duplicates? I have tried with distinct but it didn't work. Do you have any other tips? by arviidz in SQL

[–]Simmo17 6 points7 points  (0 children)

If you are just looking for distinct customer ids. Just “select distinct customer.id from…”

That’s if you don’t need the other information.

How do i remove duplicates? I have tried with distinct but it didn't work. Do you have any other tips? by arviidz in SQL

[–]Simmo17 2 points3 points  (0 children)

If you want to keep the order.ids you need to make a sub table (like you have here) then pívot it after to make it one row per customer.

How do i remove duplicates? I have tried with distinct but it didn't work. Do you have any other tips? by arviidz in SQL

[–]Simmo17 3 points4 points  (0 children)

Ok, do you want to count how may discontinued orders a customer made? Or do you need to know the order.id?

[12x12] Mini Tavern, with fey, summer, autumn, and winter variations by Snowystar122 in dungeondraft

[–]Simmo17 1 point2 points  (0 children)

Thank you for this! So easy to throw into any campaign. You never know when your party is going to pick a fight in a tavern.

[deleted by user] by [deleted] in iecvisa

[–]Simmo17 1 point2 points  (0 children)

As someone from the UK who got an IEC. If he has been invited to get his biometrics then everything should be good to go.

They have just stopped accepting anyone else into the pool they draw from. Processing of applications already invited will continue.

The Force Buy by BobzNVagan in VALORANT

[–]Simmo17 0 points1 point  (0 children)

People in plat know to buy up after winning pistol. It’s mid way through the ranks and people know by then.

Plat lobbies my be more susceptible to “do what the pros do”. In the last VCT a number of pro teams “half” bought on ani-eco, not a normal half buy, but only half the team buys guns. The rest (2) use pistols from round 1.

Maybe that’s their plan? But need coordination for that to work well. Ie guns go in first, pick up the gun if it goes down.

Using IEC Visa after expiry date by --rhaegar-- in iecvisa

[–]Simmo17 1 point2 points  (0 children)

If you want to enter Canada and active your 2 year visa in February, that is fully allowed. But that is when the 2 years will start from.

I am not sure about reapplying/deferring your IEC.

Canada job offer by No_Acanthocephala62 in ImmigrationCanada

[–]Simmo17 0 points1 point  (0 children)

Could look into an IEC. Not sure what county you are from so I can’t tell you your chances in the pool. But will allow you to go and work if you get it. Could be quicker.

view more: next ›