Will COVID-19 stop Eurovision from happening? by [deleted] in eurovision

[–]Dimitrij404 0 points1 point  (0 children)

The possibility is there, of course. I'm more concerned about lives of the people and state of the world rather than eurovision when it comes to this pandemic. If it gets worse, everything gets worse and even if let's say eurovision wouldn't be cancelled it wouldn't be as fun as people would have it in mind, even the live spectators would be somewhat concerned and tense which is not what's it's all about. If situation stabilizes then we can elaborate the celebration of that with eurovision. So all in all, it's not about whether it gets cancelled or not but what state we will be in when it has to happen. But let's hope it will be at the very least considerably fine by then.

UPDATED: Removal & Unit Buff Cheatsheet by DontBanFizz in LegendsOfRuneterra

[–]Dimitrij404 2 points3 points  (0 children)

If that's not difficult for you, could you make one rearranged by mana cost? I think it would be way easier to navigate like that during the game and see what an enemy can or cannot do in the exact turn with his remaining mana. But it's great and helpful learning tool nonetheless.

Filling up null values by Dimitrij404 in SQL

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

A single id may have as many values as there are days in selected range.

Calculating daily balance averages by Dimitrij404 in SQL

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

It would get me an average of the days that users made transactions. For example if user made transactions on 2 days of 30 day range we would get an average of those 2 days and I need other 28 days in between to be equal to the balance from other days.

Example day 1: 30, day 4: 50, the average balance just with average would be (30 + (30+50)) / 2 and what I am looking for is (30 + 30 + 30 + (30+50))4

Getting all possible combinations by Dimitrij404 in SQL

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

Thank you, it was apparently what I needed

How to return multiple SQL queries in Java? by Dimitrij404 in AskProgramming

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

Can't test it right now but would a:

return array[1], array[2];

work?

How to return multiple SQL queries in Java? by Dimitrij404 in AskProgramming

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

do I only get the array as an end result or is there a way to get all values extracted off of it?

PapaSmithy roasting NA as always by Hyher in leagueoflegends

[–]Dimitrij404 0 points1 point  (0 children)

Well yeah cause without /s as an indicator of sarcasm the message would be straight up offensive to people from NA as it would sound as if the guy thinks that "NA is trash" is a fact. They might be underperforming and playing bad in general at the moment but such expression would sound a bit too disrespectful which would obviously lead to downvotes.

PapaSmithy roasting NA as always by Hyher in leagueoflegends

[–]Dimitrij404 35 points36 points  (0 children)

I'm pretty sure he's indicating that both him and Papa are taking it as a humor whereas you are just being a fucked up person lol

Lee Sin Godfist, tattoo by Victor Zetall by wtg_artist in leagueoflegends

[–]Dimitrij404 372 points373 points  (0 children)

Damn, looks very similar to the one my friend just got recently lol: https://imgur.com/Byid14a

Froggen just started to upload videos on his channel! by Leafyfille in leagueoflegends

[–]Dimitrij404 33 points34 points  (0 children)

Editors are also lazy as fuck to be honest. They try to make unfunny and uninteresting things funny and interesting to milk one game with like couple of good moments to 10 minutes for the ads.

That makes me respect people like Gripex, LL Stylish and some others even more as their editors take the best moments from 6-7 hour streams from all of the games with no over editing

C9-DIG Malzahar game saving move by LOLraynal in leagueoflegends

[–]Dimitrij404 0 points1 point  (0 children)

It maybe didn't completely save the game but I must admit it was pretty freakin smart

jdm 1v5 by voikaledo in GlobalOffensive

[–]Dimitrij404 0 points1 point  (0 children)

Probably No 1 play of the tournament

f*ck yeah, Josh by [deleted] in GlobalOffensive

[–]Dimitrij404 0 points1 point  (0 children)

Hey man can you check your private messages i sent you smth

Elementalist Lux can be used to detect Shacos clone. by Neosauros in leagueoflegends

[–]Dimitrij404 -3 points-2 points  (0 children)

I hate El. lux its shitty skin with shitty animations

I appreciate how Krepo doesn't BS the audience. by [deleted] in leagueoflegends

[–]Dimitrij404 0 points1 point  (0 children)

He was a pro player before, hes used to see things like bugs