Howard Chung

Software engineer. @OpenDota maintainer.

[Howard Chung @howardzchung]

It's recently come to my attention that some people are attempting to impersonate me on Discord. If you receive an unsolicited message from someone claiming to be me, it's probably not.

[Howard Chung @howardzchung]

@Glitch100 Sure, that'd be awesome!

[Howard Chung @howardzchung]

@KaptainKabinets @opendota Thanks, I found the issue. https://t.co/rk2Ix95IEP for details

[Howard Chung @howardzchung]

@KaptainKabinets @opendota link?

[Howard Chung @howardzchung]

@TorteDeLini @DOTABUFF @opendota There are usually between 800,000 and 1.1 million games played per day. This site tracks the breakdown: https://t.co/IFpxkOxv0W

[Howard Chung @howardzchung]

@SirActionSlacks @DOTABUFF Try this filter!

https://t.co/JE8iUEvu2l

[Howard Chung @howardzchung]

@chancewaters @opendota [email protected] and [email protected]

[Howard Chung @howardzchung]

@refleksy @NahazDota @followNoxville @DOTABUFF I think randoming data is in the replay. I'll try to add it soon, although you'd have to query matches individually and count wins yourself

[Howard Chung @howardzchung]

@mattmcleod27 I'll see what I can do to make this less tedious (maybe just adding a menu selector to automate this

[Howard Chung @howardzchung]

@mattmcleod27 The Singapore server has clusters: "151": 5,
"152": 5,
"153": 5,
"154": 5,
"155": 5,
"156": 5,

[Howard Chung @howardzchung]

@mattmcleod27 Then translate the region to english name: https://t.co/MiJ6vateRA

[Howard Chung @howardzchung]

@mattmcleod27 There's a column called "cluster" in the match table. You can look up the region mapping here: https://t.co/knkyrQC3HT

[Howard Chung @howardzchung]

@mattmcleod27 Explorer only includes Premium/Professional leagues.

[Howard Chung @howardzchung]

@mattmcleod27 @NahazDota You can do that with a compound GROUP BY: https://t.co/qGkkzA0N5i (Bulldog/NP is #2!)

[Howard Chung @howardzchung]

@mattmcleod27 You can see the table schema here: https://t.co/dCFZOGIvdQ
There's also an open pull request to add autocomplete support.

[Howard Chung @howardzchung]

@mattmcleod27 @NahazDota A query like: https://t.co/WVbuVRQvwL -- SQL is good to learn to find interesting stats on-the-fly!

[Howard Chung @howardzchung]

@mattmcleod27 @NahazDota If you have any questions about getting some particular data or a feature request you can ask on Discord or GitHub!

[Howard Chung @howardzchung]

@mattmcleod27 @NahazDota The Explorer should able to do hero/player comparison. Hero GPM in 7.02: https://t.co/b4TAEvPBYm

[Howard Chung @howardzchung]

@coffeeFedCode did you end up making something? I'd love to see it!

[Howard Chung @howardzchung]

@martinbohman @opendota There should be a mouseover in the column at the right labeled "AB"