Skip to content

Instantly share code, notes, and snippets.

@ctfaddict

ctfaddict/figure10 Secret

Created Apr 24, 2014
Embed
What would you like to do?
scorebot_production=# select t.name, s.name, count(*), count(*) * 19 as flags_lost
from availabilities a, instances i, teams t, services s
where a.instance_id = i.id and i.team_id = t.id and i.service_id = s.id and a.status != 0
group by t.name, s.name
order by t.name asc, s.name asc;
name | name | count | flags_lost
-------------------------------+----------+-------+------------
9447 | atmail | 17 | 323
9447 | avoir | 30 | 570
9447 | bookworm | 3 | 57
9447 | lonetuna | 32 | 608
9447 | reeses | 25 | 475
9447 | trouver | 6 | 114
Alternatives | atmail | 13 | 247
Alternatives | avoir | 5 | 95
Alternatives | bookworm | 5 | 95
Alternatives | lonetuna | 31 | 589
Alternatives | reeses | 12 | 228
Alternatives | trouver | 5 | 95
APT8 | atmail | 51 | 969
APT8 | avoir | 13 | 247
APT8 | bookworm | 12 | 228
APT8 | lonetuna | 56 | 1064
APT8 | reeses | 23 | 437
APT8 | trouver | 12 | 228
blue lotus | atmail | 9 | 171
blue lotus | avoir | 2 | 38
blue lotus | bookworm | 1 | 19
blue lotus | lonetuna | 40 | 760
blue lotus | reeses | 22 | 418
blue lotus | trouver | 2 | 38
clgt | atmail | 55 | 1045
clgt | avoir | 28 | 532
clgt | bookworm | 19 | 361
clgt | lonetuna | 106 | 2014
clgt | reeses | 19 | 361
clgt | trouver | 26 | 494
Legitimate Business Syndicate | atmail | 1 | 19
Legitimate Business Syndicate | bookworm | 1 | 19
Legitimate Business Syndicate | lonetuna | 14 | 266
men in black hats | atmail | 4 | 76
men in black hats | avoir | 3 | 57
men in black hats | lonetuna | 66 | 1254
men in black hats | reeses | 8 | 152
men in black hats | trouver | 5 | 95
more smoked leet chicken | atmail | 23 | 437
more smoked leet chicken | avoir | 6 | 114
more smoked leet chicken | bookworm | 1 | 19
more smoked leet chicken | lonetuna | 10 | 190
more smoked leet chicken | reeses | 5 | 95
more smoked leet chicken | trouver | 5 | 95
PPP | atmail | 4 | 76
PPP | avoir | 2 | 38
PPP | bookworm | 3 | 57
PPP | lonetuna | 45 | 855
PPP | reeses | 9 | 171
PPP | trouver | 2 | 38
pwnies | atmail | 10 | 190
pwnies | avoir | 13 | 247
pwnies | bookworm | 4 | 76
pwnies | lonetuna | 141 | 2679
pwnies | reeses | 18 | 342
pwnies | trouver | 3 | 57
pwningyeti | atmail | 27 | 513
pwningyeti | avoir | 14 | 266
pwningyeti | bookworm | 18 | 342
pwningyeti | lonetuna | 124 | 2356
pwningyeti | reeses | 13 | 247
pwningyeti | trouver | 12 | 228
raon_ASRT | atmail | 41 | 779
raon_ASRT | avoir | 3 | 57
raon_ASRT | bookworm | 2 | 38
raon_ASRT | lonetuna | 38 | 722
raon_ASRT | reeses | 14 | 266
raon_ASRT | trouver | 3 | 57
Robot Mafia | atmail | 30 | 570
Robot Mafia | avoir | 36 | 684
Robot Mafia | bookworm | 47 | 893
Robot Mafia | lonetuna | 150 | 2850
Robot Mafia | reeses | 36 | 684
Robot Mafia | trouver | 40 | 760
routards | atmail | 8 | 152
routards | avoir | 4 | 76
routards | bookworm | 1 | 19
routards | lonetuna | 34 | 646
routards | reeses | 22 | 418
routards | trouver | 16 | 304
Samurai | atmail | 61 | 1159
Samurai | avoir | 7 | 133
Samurai | bookworm | 4 | 76
Samurai | lonetuna | 104 | 1976
Samurai | reeses | 15 | 285
Samurai | trouver | 7 | 133
shell corp | atmail | 78 | 1482
shell corp | avoir | 4 | 76
shell corp | bookworm | 6 | 114
shell corp | lonetuna | 106 | 2014
shell corp | reeses | 14 | 266
shell corp | trouver | 5 | 95
shellphish | atmail | 17 | 323
shellphish | avoir | 19 | 361
shellphish | bookworm | 3 | 57
shellphish | lonetuna | 60 | 1140
shellphish | reeses | 8 | 152
shellphish | trouver | 14 | 266
sutegoma2 | atmail | 5 | 95
sutegoma2 | avoir | 6 | 114
sutegoma2 | bookworm | 27 | 513
sutegoma2 | lonetuna | 75 | 1425
sutegoma2 | reeses | 15 | 285
sutegoma2 | trouver | 25 | 475
[Technopandas] | atmail | 61 | 1159
[Technopandas] | avoir | 7 | 133
[Technopandas] | bookworm | 18 | 342
[Technopandas] | lonetuna | 129 | 2451
[Technopandas] | reeses | 11 | 209
[Technopandas] | trouver | 6 | 114
The European Nopsled Team | atmail | 20 | 380
The European Nopsled Team | avoir | 4 | 76
The European Nopsled Team | lonetuna | 109 | 2071
The European Nopsled Team | reeses | 25 | 475
The European Nopsled Team | trouver | 12 | 228
WOWHacker-BI0S | atmail | 72 | 1368
WOWHacker-BI0S | avoir | 10 | 190
WOWHacker-BI0S | bookworm | 2 | 38
WOWHacker-BI0S | lonetuna | 94 | 1786
WOWHacker-BI0S | reeses | 14 | 266
WOWHacker-BI0S | trouver | 9 | 171
(121 rows)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment