Skip to content

Instantly share code, notes, and snippets.

@ctfaddict

ctfaddict/figure9 Secret

Created Apr 24, 2014
Embed
What would you like to do?
scorebot_production=# select t.name, count(*), count(*) * 19 as flags_lost
from availabilities a, instances i, teams t
where a.instance_id = i.id and i.team_id = t.id and a.status != 0
group by t.name
order by count(*) desc;
name | count | flags_lost
-------------------------------+-------+------------
Robot Mafia | 339 | 6441
clgt | 253 | 4807
[Technopandas] | 232 | 4408
shell corp | 213 | 4047
pwningyeti | 208 | 3952
WOWHacker-BI0S | 201 | 3819
Samurai | 198 | 3762
pwnies | 189 | 3591
The European Nopsled Team | 170 | 3230
APT8 | 167 | 3173
sutegoma2 | 153 | 2907
shellphish | 121 | 2299
9447 | 113 | 2147
raon_ASRT | 101 | 1919
men in black hats | 86 | 1634
routards | 85 | 1615
blue lotus | 76 | 1444
Alternatives | 71 | 1349
PPP | 65 | 1235
more smoked leet chicken | 50 | 950
Legitimate Business Syndicate | 16 | 304
(21 rows)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment