Skip to content

Instantly share code, notes, and snippets.

@ctfaddict

ctfaddict/figure19 Secret

Created Apr 24, 2014
Embed
What would you like to do?
scorebot_production=# select rt.name as attacker, it.name as victim, count(*) as steals
from redemptions r, instances i, teams rt, teams it, tokens t
where r.token_id = t.id and t.instance_id = i.id and r.team_id = rt.id
and i.team_id = it.id and r.team_id != i.team_id
group by rt.name, it.name
order by rt.name asc, count(*) desc;
attacker | victim | steals
---------------------------+---------------------------+--------
9447 | pwnies | 134
9447 | APT8 | 132
9447 | Samurai | 79
9447 | shell corp | 65
9447 | Alternatives | 50
9447 | Robot Mafia | 48
9447 | blue lotus | 46
9447 | shellphish | 40
9447 | WOWHacker-BI0S | 34
9447 | clgt | 33
9447 | raon_ASRT | 21
9447 | The European Nopsled Team | 18
9447 | men in black hats | 17
9447 | more smoked leet chicken | 16
9447 | [Technopandas] | 12
9447 | routards | 9
9447 | pwningyeti | 3
Alternatives | APT8 | 273
Alternatives | pwnies | 147
Alternatives | shell corp | 98
Alternatives | clgt | 94
Alternatives | Samurai | 83
Alternatives | Robot Mafia | 75
Alternatives | blue lotus | 59
Alternatives | 9447 | 58
Alternatives | WOWHacker-BI0S | 50
Alternatives | more smoked leet chicken | 32
Alternatives | PPP | 25
Alternatives | pwningyeti | 24
Alternatives | shellphish | 24
Alternatives | raon_ASRT | 22
Alternatives | [Technopandas] | 19
Alternatives | The European Nopsled Team | 9
Alternatives | men in black hats | 2
Alternatives | routards | 1
APT8 | [Technopandas] | 16
APT8 | shell corp | 12
APT8 | pwnies | 8
blue lotus | APT8 | 280
blue lotus | pwnies | 155
blue lotus | shell corp | 106
blue lotus | clgt | 93
blue lotus | Samurai | 92
blue lotus | Robot Mafia | 77
blue lotus | 9447 | 69
blue lotus | Alternatives | 46
blue lotus | WOWHacker-BI0S | 42
blue lotus | more smoked leet chicken | 27
blue lotus | raon_ASRT | 26
blue lotus | shellphish | 22
blue lotus | [Technopandas] | 19
blue lotus | pwningyeti | 18
blue lotus | PPP | 13
blue lotus | The European Nopsled Team | 11
blue lotus | routards | 4
clgt | APT8 | 174
clgt | pwnies | 84
clgt | Samurai | 51
clgt | Robot Mafia | 21
clgt | WOWHacker-BI0S | 19
clgt | shell corp | 11
clgt | [Technopandas] | 10
clgt | Alternatives | 6
clgt | raon_ASRT | 4
clgt | pwningyeti | 3
clgt | PPP | 2
clgt | blue lotus | 1
men in black hats | APT8 | 260
men in black hats | pwnies | 195
men in black hats | WOWHacker-BI0S | 127
men in black hats | [Technopandas] | 121
men in black hats | Robot Mafia | 109
men in black hats | Samurai | 103
men in black hats | clgt | 96
men in black hats | blue lotus | 86
men in black hats | Alternatives | 80
men in black hats | shell corp | 77
men in black hats | shellphish | 57
men in black hats | pwningyeti | 50
men in black hats | more smoked leet chicken | 45
men in black hats | raon_ASRT | 43
men in black hats | routards | 39
men in black hats | PPP | 36
men in black hats | 9447 | 31
men in black hats | sutegoma2 | 30
men in black hats | The European Nopsled Team | 9
more smoked leet chicken | APT8 | 302
more smoked leet chicken | pwnies | 201
more smoked leet chicken | shell corp | 119
more smoked leet chicken | Robot Mafia | 118
more smoked leet chicken | WOWHacker-BI0S | 109
more smoked leet chicken | Samurai | 108
more smoked leet chicken | clgt | 106
more smoked leet chicken | blue lotus | 94
more smoked leet chicken | Alternatives | 92
more smoked leet chicken | [Technopandas] | 90
more smoked leet chicken | 9447 | 79
more smoked leet chicken | shellphish | 66
more smoked leet chicken | PPP | 50
more smoked leet chicken | routards | 40
more smoked leet chicken | pwningyeti | 38
more smoked leet chicken | The European Nopsled Team | 22
more smoked leet chicken | raon_ASRT | 21
more smoked leet chicken | men in black hats | 16
more smoked leet chicken | sutegoma2 | 9
PPP | APT8 | 341
PPP | pwnies | 307
PPP | [Technopandas] | 242
PPP | WOWHacker-BI0S | 197
PPP | blue lotus | 178
PPP | shell corp | 162
PPP | clgt | 148
PPP | Robot Mafia | 136
PPP | Alternatives | 121
PPP | 9447 | 120
PPP | Samurai | 97
PPP | The European Nopsled Team | 81
PPP | shellphish | 80
PPP | more smoked leet chicken | 71
PPP | pwningyeti | 63
PPP | raon_ASRT | 55
PPP | sutegoma2 | 55
PPP | routards | 46
PPP | men in black hats | 25
pwnies | APT8 | 75
pwnies | Samurai | 57
pwnies | 9447 | 51
pwnies | Alternatives | 48
pwnies | Robot Mafia | 44
pwnies | blue lotus | 37
pwnies | WOWHacker-BI0S | 34
pwnies | shell corp | 33
pwnies | clgt | 27
pwnies | shellphish | 27
pwnies | raon_ASRT | 22
pwnies | [Technopandas] | 19
pwnies | The European Nopsled Team | 18
pwnies | more smoked leet chicken | 18
pwnies | men in black hats | 11
pwnies | pwningyeti | 6
pwnies | routards | 6
pwnies | PPP | 3
pwningyeti | APT8 | 237
pwningyeti | pwnies | 138
pwningyeti | Samurai | 79
pwningyeti | shell corp | 68
pwningyeti | clgt | 51
pwningyeti | Robot Mafia | 47
pwningyeti | 9447 | 40
pwningyeti | Alternatives | 35
pwningyeti | blue lotus | 34
pwningyeti | WOWHacker-BI0S | 32
pwningyeti | shellphish | 23
pwningyeti | raon_ASRT | 17
pwningyeti | [Technopandas] | 11
pwningyeti | The European Nopsled Team | 9
pwningyeti | routards | 8
pwningyeti | PPP | 8
pwningyeti | more smoked leet chicken | 4
raon_ASRT | APT8 | 352
raon_ASRT | pwnies | 206
raon_ASRT | shell corp | 130
raon_ASRT | clgt | 124
raon_ASRT | WOWHacker-BI0S | 115
raon_ASRT | Samurai | 108
raon_ASRT | Alternatives | 96
raon_ASRT | [Technopandas] | 94
raon_ASRT | blue lotus | 82
raon_ASRT | Robot Mafia | 64
raon_ASRT | PPP | 61
raon_ASRT | shellphish | 58
raon_ASRT | more smoked leet chicken | 54
raon_ASRT | 9447 | 45
raon_ASRT | routards | 44
raon_ASRT | pwningyeti | 42
raon_ASRT | The European Nopsled Team | 18
raon_ASRT | men in black hats | 16
raon_ASRT | sutegoma2 | 16
Robot Mafia | APT8 | 68
Robot Mafia | pwnies | 44
Robot Mafia | WOWHacker-BI0S | 19
Robot Mafia | clgt | 18
Robot Mafia | Samurai | 10
Robot Mafia | [Technopandas] | 6
Robot Mafia | Alternatives | 3
Robot Mafia | pwningyeti | 2
Robot Mafia | shell corp | 1
routards | APT8 | 301
routards | pwnies | 191
routards | clgt | 94
routards | WOWHacker-BI0S | 85
routards | Samurai | 78
routards | [Technopandas] | 63
routards | Robot Mafia | 52
routards | shell corp | 28
routards | Alternatives | 21
routards | blue lotus | 12
routards | 9447 | 12
routards | raon_ASRT | 9
routards | pwningyeti | 3
routards | The European Nopsled Team | 1
routards | more smoked leet chicken | 1
Samurai | APT8 | 243
Samurai | pwnies | 153
Samurai | [Technopandas] | 83
Samurai | WOWHacker-BI0S | 61
Samurai | shell corp | 44
Samurai | clgt | 43
Samurai | blue lotus | 33
Samurai | pwningyeti | 31
Samurai | PPP | 24
Samurai | Robot Mafia | 21
Samurai | more smoked leet chicken | 16
Samurai | Alternatives | 12
Samurai | raon_ASRT | 9
Samurai | 9447 | 5
Samurai | men in black hats | 3
Samurai | shellphish | 3
Samurai | The European Nopsled Team | 1
shell corp | APT8 | 196
shell corp | pwnies | 136
shell corp | Samurai | 68
shell corp | clgt | 59
shell corp | Robot Mafia | 52
shell corp | WOWHacker-BI0S | 35
shell corp | Alternatives | 32
shell corp | 9447 | 26
shell corp | raon_ASRT | 17
shell corp | [Technopandas] | 16
shell corp | pwningyeti | 15
shell corp | blue lotus | 13
shell corp | shellphish | 8
shell corp | more smoked leet chicken | 6
shell corp | routards | 4
shell corp | men in black hats | 2
shell corp | PPP | 2
shell corp | The European Nopsled Team | 1
shellphish | APT8 | 261
shellphish | pwnies | 193
shellphish | Samurai | 90
shellphish | shell corp | 79
shellphish | blue lotus | 71
shellphish | clgt | 65
shellphish | [Technopandas] | 63
shellphish | WOWHacker-BI0S | 62
shellphish | Robot Mafia | 59
shellphish | Alternatives | 59
shellphish | 9447 | 57
shellphish | pwningyeti | 35
shellphish | more smoked leet chicken | 29
shellphish | raon_ASRT | 26
shellphish | PPP | 22
shellphish | The European Nopsled Team | 21
shellphish | routards | 17
shellphish | men in black hats | 13
sutegoma2 | pwnies | 113
sutegoma2 | APT8 | 92
sutegoma2 | Samurai | 75
sutegoma2 | 9447 | 53
sutegoma2 | Alternatives | 47
sutegoma2 | Robot Mafia | 42
sutegoma2 | shell corp | 41
sutegoma2 | shellphish | 39
sutegoma2 | WOWHacker-BI0S | 34
sutegoma2 | clgt | 27
sutegoma2 | The European Nopsled Team | 20
sutegoma2 | raon_ASRT | 20
sutegoma2 | more smoked leet chicken | 18
sutegoma2 | men in black hats | 14
sutegoma2 | [Technopandas] | 13
sutegoma2 | routards | 9
sutegoma2 | pwningyeti | 4
[Technopandas] | pwnies | 140
[Technopandas] | APT8 | 130
[Technopandas] | Samurai | 80
[Technopandas] | shell corp | 55
[Technopandas] | clgt | 32
[Technopandas] | WOWHacker-BI0S | 30
[Technopandas] | 9447 | 23
[Technopandas] | Alternatives | 21
[Technopandas] | raon_ASRT | 14
[Technopandas] | blue lotus | 6
[Technopandas] | shellphish | 5
[Technopandas] | pwningyeti | 3
[Technopandas] | The European Nopsled Team | 2
The European Nopsled Team | APT8 | 150
The European Nopsled Team | pwnies | 135
The European Nopsled Team | Samurai | 89
The European Nopsled Team | shell corp | 50
The European Nopsled Team | WOWHacker-BI0S | 44
The European Nopsled Team | Robot Mafia | 43
The European Nopsled Team | clgt | 42
The European Nopsled Team | Alternatives | 35
The European Nopsled Team | 9447 | 30
The European Nopsled Team | raon_ASRT | 21
The European Nopsled Team | [Technopandas] | 21
The European Nopsled Team | blue lotus | 15
The European Nopsled Team | PPP | 13
The European Nopsled Team | more smoked leet chicken | 11
The European Nopsled Team | routards | 11
The European Nopsled Team | pwningyeti | 10
The European Nopsled Team | shellphish | 8
The European Nopsled Team | men in black hats | 3
WOWHacker-BI0S | APT8 | 131
WOWHacker-BI0S | pwnies | 67
WOWHacker-BI0S | Samurai | 53
WOWHacker-BI0S | clgt | 44
WOWHacker-BI0S | Robot Mafia | 37
WOWHacker-BI0S | blue lotus | 21
WOWHacker-BI0S | PPP | 20
WOWHacker-BI0S | Alternatives | 17
WOWHacker-BI0S | pwningyeti | 15
WOWHacker-BI0S | raon_ASRT | 11
WOWHacker-BI0S | shell corp | 8
WOWHacker-BI0S | [Technopandas] | 8
WOWHacker-BI0S | routards | 5
WOWHacker-BI0S | more smoked leet chicken | 4
WOWHacker-BI0S | shellphish | 1
(318 rows)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment