Skip to content

Instantly share code, notes, and snippets.

@ctfaddict

ctfaddict/figure18 Secret

Created Apr 24, 2014
Embed
What would you like to do?
scorebot_production=# select rt.name as team, s.name as svc, count(*) as steals
from redemptions r, instances i, teams rt, services s, tokens t
where r.token_id = t.id and t.instance_id = i.id and s.id = i.service_id
and r.team_id = rt.id and r.team_id != i.team_id
group by rt.name, s.name
order by rt.name asc, s.name asc;
team | svc | steals
---------------------------+----------+--------
9447 | atmail | 757
Alternatives | atmail | 726
Alternatives | avoir | 106
Alternatives | bookworm | 247
Alternatives | lonetuna | 2
Alternatives | trouver | 14
APT8 | atmail | 20
APT8 | lonetuna | 16
blue lotus | atmail | 797
blue lotus | avoir | 121
blue lotus | bookworm | 182
clgt | atmail | 295
clgt | bookworm | 91
men in black hats | atmail | 705
men in black hats | bookworm | 320
men in black hats | lonetuna | 53
men in black hats | reeses | 334
men in black hats | trouver | 182
more smoked leet chicken | atmail | 959
more smoked leet chicken | avoir | 195
more smoked leet chicken | bookworm | 304
more smoked leet chicken | lonetuna | 71
more smoked leet chicken | reeses | 132
more smoked leet chicken | trouver | 19
PPP | atmail | 864
PPP | avoir | 365
PPP | bookworm | 181
PPP | lonetuna | 581
PPP | reeses | 377
PPP | trouver | 157
pwnies | atmail | 536
pwningyeti | atmail | 688
pwningyeti | bookworm | 153
raon_ASRT | atmail | 800
raon_ASRT | avoir | 304
raon_ASRT | bookworm | 350
raon_ASRT | lonetuna | 24
raon_ASRT | reeses | 140
raon_ASRT | trouver | 107
Robot Mafia | atmail | 148
Robot Mafia | bookworm | 23
routards | atmail | 506
routards | avoir | 132
routards | bookworm | 133
routards | trouver | 180
Samurai | atmail | 292
Samurai | avoir | 119
Samurai | bookworm | 219
Samurai | lonetuna | 30
Samurai | trouver | 125
shell corp | atmail | 537
shell corp | avoir | 52
shell corp | bookworm | 99
shellphish | atmail | 893
shellphish | avoir | 139
shellphish | bookworm | 187
shellphish | trouver | 3
sutegoma2 | atmail | 637
sutegoma2 | lonetuna | 8
sutegoma2 | trouver | 16
[Technopandas] | atmail | 541
The European Nopsled Team | atmail | 664
The European Nopsled Team | avoir | 13
The European Nopsled Team | bookworm | 43
The European Nopsled Team | lonetuna | 11
WOWHacker-BI0S | atmail | 297
WOWHacker-BI0S | bookworm | 145
(67 rows)
scorebot_production=# select s.name as svc, rt.name as team, count(*) as steals from redemptions r, instances i, teams rt, services s, tokens t where r.token_id = t.id and t.instance_id = i.id and s.id = i.service_id and r.team_id = rt.id and r.team_id != i.team_id group by s.name, rt.name order by s.name asc, count(*) desc;
svc | team | steals
----------+---------------------------+--------
atmail | more smoked leet chicken | 959
atmail | shellphish | 893
atmail | PPP | 864
atmail | raon_ASRT | 800
atmail | blue lotus | 797
atmail | 9447 | 757
atmail | Alternatives | 726
atmail | men in black hats | 705
atmail | pwningyeti | 688
atmail | The European Nopsled Team | 664
atmail | sutegoma2 | 637
atmail | [Technopandas] | 541
atmail | shell corp | 537
atmail | pwnies | 536
atmail | routards | 506
atmail | WOWHacker-BI0S | 297
atmail | clgt | 295
atmail | Samurai | 292
atmail | Robot Mafia | 148
atmail | APT8 | 20
avoir | PPP | 365
avoir | raon_ASRT | 304
avoir | more smoked leet chicken | 195
avoir | shellphish | 139
avoir | routards | 132
avoir | blue lotus | 121
avoir | Samurai | 119
avoir | Alternatives | 106
avoir | shell corp | 52
avoir | The European Nopsled Team | 13
bookworm | raon_ASRT | 350
bookworm | men in black hats | 320
bookworm | more smoked leet chicken | 304
bookworm | Alternatives | 247
bookworm | Samurai | 219
bookworm | shellphish | 187
bookworm | blue lotus | 182
bookworm | PPP | 181
bookworm | pwningyeti | 153
bookworm | WOWHacker-BI0S | 145
bookworm | routards | 133
bookworm | shell corp | 99
bookworm | clgt | 91
bookworm | The European Nopsled Team | 43
bookworm | Robot Mafia | 23
lonetuna | PPP | 581
lonetuna | more smoked leet chicken | 71
lonetuna | men in black hats | 53
lonetuna | Samurai | 30
lonetuna | raon_ASRT | 24
lonetuna | APT8 | 16
lonetuna | The European Nopsled Team | 11
lonetuna | sutegoma2 | 8
lonetuna | Alternatives | 2
reeses | PPP | 377
reeses | men in black hats | 334
reeses | raon_ASRT | 140
reeses | more smoked leet chicken | 132
trouver | men in black hats | 182
trouver | routards | 180
trouver | PPP | 157
trouver | Samurai | 125
trouver | raon_ASRT | 107
trouver | more smoked leet chicken | 19
trouver | sutegoma2 | 16
trouver | Alternatives | 14
trouver | shellphish | 3
(67 rows)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment