Skip to content

Instantly share code, notes, and snippets.

View Noxville's full-sized avatar
🎮
esports

Ben Steenhuisen Noxville

🎮
esports
View GitHub Profile
@Noxville
Noxville / pros.sql
Created July 13, 2021 16:52
pros in ability draft
nickname | steam_id | wins | losses | games
----------------+-----------+------+--------+-------
PrettyHaw | 89166519 | 153 | 155 | 308
杀神AK丷 | 121926807 | 148 | 107 | 255
NMSL | 114427877 | 102 | 112 | 214
ZeroPerfect | 149970561 | 67 | 71 | 138
川果 | 102856993 | 66 | 65 | 131
Eresloco | 102732874 | 43 | 68 | 111
. | 111886687 | 55 | 52 | 107
pandaman | 112127585 | 34 | 40 | 74
name | avg_duration | num_games
-----------------------------------------------------------------------+-----------------------+-----------
World Cyber Arena | 2905.5625000000000000 | 32
Wild Cards East | 2576.4117647058823529 | 34
Esports Champion League | 2547.6379310344827586 | 58
World Cyber Arena 2017 Europe Qualifiers | 2529.8095238095238095 | 105
Wild Cards West | 2527.8285714285714286 | 35
Red Bull Battle Grounds: Dota 2 | 2525.3815789473684211 | 76
Dota Pit League Season 2 Ticket | 2523.8372093023255814 | 129
ASUS ROG DreamLeague Season 2 | 2523.1686746
Emrakul, the Promised End
Death's Shadow
Liliana, the Last Hope
Chalice of the Void
Dark Confidant
Ulamog, the Ceaseless Hunger
All Is Dust
Platinum Emperion
Ugin, the Spirit Dragon
Nahiri, the Harbinger
4x Emrakul, The Aoens Torn
4x Riverglide Pathway
4x Tarmogoyf
4x Wrenn and Six
4x Skyclave Apparition
4x Karn, the Great Creator
4x Dryad of the Ilysian Grove
4x Amulet of Vigor
4x Utopia Sprawl
4x Heliod, Sun-Crowned
@Noxville
Noxville / may_3rd_order
Created May 23, 2021 08:11
3rd order for may 2021
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
3x Great Whale (Urza's Saga) - R - English - EX 27,95 EUR
2x Radiant, Archangel (Urza's Legacy) - R - English - EX 13,52 EUR
2x Phelddagrif (Alliances) - R - English - NM 24,27 EUR
2x Great Whale (Urza's Saga) - R - English - EX 28,22 EUR
2x Corpse Dance (Tempest) - R - English - EX 26,21 EUR
1x Academy Rector (Urza's Destiny) - R - English - EX 90,00 EUR
1x Corpse Dance (Tempest) - R - English - NM 35,00 EUR
1x Palinchron (Urza's Legacy) - R - English - NM 80,00 EUR
2x Phelddagrif (Alliances) - R - English - EX 22,50 EUR
@Noxville
Noxville / may.txt
Created May 11, 2021 16:27
may mtg acquisitions
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
4x Ensnaring Bridge (Double Masters) - M - English - NM 19,99 EUR
4x Blood Moon (Double Masters) - R - English - NM 10,99 EUR
4x Callous Bloodmage (Strixhaven: School of Mages: Extras) - R - En... 0,67 EUR
3x Damping Sphere (Dominaria) - U - English - NM 1,49 EUR
8x Negate (V.1) [Playset] (Mystical Archive) - U - English - NM 0,49 EUR
4x Expressive Iteration (Strixhaven: School of Mages) - U - English... 0,35 EUR
4x Inquisition of Kozilek (V.1) (Mystical Archive) - R - English - NM 3,25 EUR
2x Shock (V.1) [Playset] (Mystical Archive) - U - English - NM 0,49 EUR
2x Duress (V.1) [Playset] (Mystical Archive) - U - English - NM 0,49 EUR
@Noxville
Noxville / dpc_simulation_2020_2021.py
Last active April 5, 2021 17:10
Simulation of the DPC 2020-2021
import random
def g(a, b):
_ = [a, b]
random.shuffle(_)
return _
def apply_major(points, regions):
playoffs, groups, wc = [], [], []
for region in regions:
@Noxville
Noxville / gist:df5c0d537f58783d507e0ece034fa187
Created January 20, 2021 04:27
example_sequence_scraper.groovy
package gg.abilitydraft
import com.fasterxml.jackson.databind.JsonNode
import com.fasterxml.jackson.databind.node.ArrayNode
import com.google.common.util.concurrent.RateLimiter
import grails.core.GrailsApplication
import grails.gorm.transactions.Transactional
import java.lang.reflect.Array
@Noxville
Noxville / diffed_out.txt
Last active January 10, 2021 03:07
diff output purchasing shard
updated CDOTAPlayer 18
--- changed property m_iCursor.0000 from 439 to 373
--- changed property m_iCursor.0001 from 137 to 259
--- changed property m_iShopPanel from 12 to 15
updated CDOTAGamerulesProxy 152
--- changed property m_pGameRules.m_fGameTime from 2188.132 to 2188.199
--- changed property m_pGameRules.m_iNetTimeOfDay from 19543 to 19550
--- changed property m_pGameRules.m_iFoWFrameNumber from 11 to 12
updated CDOTAFogOfWarTempViewers 161
--- changed property m_TempViewerInfo.0012.m_nGridX from 30 to 31
{
"index": 139,
"serial": 121,
"handle": 1982603,
"dtClass": {
"serializer": {
"id": {
"name": "CDOTA_PlayerResource",
"version": 0
},