Skip to content

Instantly share code, notes, and snippets.

@ctfaddict

ctfaddict/figure27 Secret

Created Apr 24, 2014
Embed
What would you like to do?
scorebot_production=# select c.flag_id as flag, c.round_id as round, c.redemption_id as redemption,
rt.name as attacker, it.name as victim, s.name as svc
from captures c, redemptions r, tokens tk, instances i, services s, teams rt, teams it
where r.id = c.redemption_id and r.token_id = tk.id and tk.instance_id = i.id
and i.service_id = s.id and r.team_id = rt.id and i.team_id = it.id
and c.flag_id = 17153
order by c.flag_id, c.created_at desc;
flag | round | redemption | attacker | victim | svc
-------+-------+------------+---------------------------+---------------------------+----------
17153 | 255 | 195984 | PPP | raon_ASRT | reeses
17153 | 254 | 195220 | raon_ASRT | shellphish | reeses
17153 | 253 | 194733 | men in black hats | men in black hats | avoir
17153 | 253 | 194737 | men in black hats | men in black hats | trouver
17153 | 253 | 194736 | men in black hats | men in black hats | reeses
17153 | 253 | 194735 | men in black hats | men in black hats | lonetuna
17153 | 253 | 194734 | men in black hats | men in black hats | bookworm
17153 | 253 | 194732 | men in black hats | men in black hats | atmail
17153 | 252 | 193836 | men in black hats | men in black hats | avoir
17153 | 252 | 193842 | men in black hats | men in black hats | trouver
17153 | 252 | 193841 | men in black hats | men in black hats | reeses
17153 | 252 | 193839 | men in black hats | men in black hats | lonetuna
17153 | 252 | 193838 | men in black hats | men in black hats | bookworm
17153 | 252 | 193835 | men in black hats | men in black hats | atmail
17153 | 251 | 190692 | men in black hats | men in black hats | avoir
17153 | 251 | 190696 | men in black hats | men in black hats | trouver
17153 | 251 | 190695 | men in black hats | men in black hats | reeses
17153 | 251 | 190694 | men in black hats | men in black hats | lonetuna
17153 | 251 | 190693 | men in black hats | men in black hats | bookworm
17153 | 251 | 190691 | men in black hats | men in black hats | atmail
17153 | 250 | 189240 | men in black hats | men in black hats | avoir
17153 | 250 | 189245 | men in black hats | men in black hats | trouver
17153 | 250 | 189243 | men in black hats | men in black hats | reeses
17153 | 250 | 189242 | men in black hats | men in black hats | lonetuna
17153 | 250 | 189241 | men in black hats | men in black hats | bookworm
17153 | 250 | 189239 | men in black hats | men in black hats | atmail
17153 | 249 | 187632 | men in black hats | men in black hats | avoir
17153 | 249 | 187636 | men in black hats | men in black hats | trouver
17153 | 249 | 187635 | men in black hats | men in black hats | reeses
17153 | 249 | 187634 | men in black hats | men in black hats | lonetuna
17153 | 249 | 187633 | men in black hats | men in black hats | bookworm
17153 | 249 | 187631 | men in black hats | men in black hats | atmail
17153 | 248 | 186206 | men in black hats | men in black hats | avoir
17153 | 248 | 186211 | men in black hats | men in black hats | trouver
17153 | 248 | 186210 | men in black hats | men in black hats | reeses
17153 | 248 | 186208 | men in black hats | men in black hats | lonetuna
17153 | 248 | 186207 | men in black hats | men in black hats | bookworm
17153 | 248 | 186204 | men in black hats | men in black hats | atmail
17153 | 247 | 184670 | men in black hats | men in black hats | avoir
17153 | 247 | 184674 | men in black hats | men in black hats | trouver
17153 | 247 | 184673 | men in black hats | men in black hats | reeses
17153 | 247 | 184672 | men in black hats | men in black hats | lonetuna
17153 | 247 | 184671 | men in black hats | men in black hats | bookworm
17153 | 247 | 184669 | men in black hats | men in black hats | atmail
17153 | 246 | 183241 | men in black hats | men in black hats | avoir
17153 | 246 | 183245 | men in black hats | men in black hats | trouver
17153 | 246 | 183244 | men in black hats | men in black hats | reeses
17153 | 246 | 183243 | men in black hats | men in black hats | lonetuna
17153 | 246 | 183242 | men in black hats | men in black hats | bookworm
17153 | 246 | 183240 | men in black hats | men in black hats | atmail
17153 | 245 | 182007 | men in black hats | men in black hats | avoir
17153 | 245 | 182011 | men in black hats | men in black hats | trouver
17153 | 245 | 182010 | men in black hats | men in black hats | reeses
17153 | 245 | 182009 | men in black hats | men in black hats | lonetuna
17153 | 245 | 182008 | men in black hats | men in black hats | bookworm
17153 | 245 | 182006 | men in black hats | men in black hats | atmail
17153 | 244 | 180407 | men in black hats | men in black hats | avoir
17153 | 244 | 180415 | men in black hats | men in black hats | trouver
17153 | 244 | 180414 | men in black hats | men in black hats | reeses
17153 | 244 | 180412 | men in black hats | men in black hats | lonetuna
17153 | 244 | 180410 | men in black hats | men in black hats | bookworm
17153 | 244 | 180405 | men in black hats | men in black hats | atmail
17153 | 243 | 178784 | men in black hats | men in black hats | avoir
17153 | 243 | 178788 | men in black hats | men in black hats | trouver
17153 | 243 | 178787 | men in black hats | men in black hats | reeses
17153 | 243 | 178786 | men in black hats | men in black hats | lonetuna
17153 | 243 | 178785 | men in black hats | men in black hats | bookworm
17153 | 243 | 178782 | men in black hats | men in black hats | atmail
17153 | 242 | 177393 | men in black hats | men in black hats | avoir
17153 | 242 | 177401 | men in black hats | men in black hats | trouver
17153 | 242 | 177399 | men in black hats | men in black hats | reeses
17153 | 242 | 177397 | men in black hats | men in black hats | lonetuna
17153 | 242 | 177395 | men in black hats | men in black hats | bookworm
17153 | 242 | 177391 | men in black hats | men in black hats | atmail
17153 | 241 | 176018 | men in black hats | men in black hats | avoir
17153 | 241 | 176022 | men in black hats | men in black hats | trouver
17153 | 241 | 176021 | men in black hats | men in black hats | reeses
17153 | 241 | 176020 | men in black hats | men in black hats | lonetuna
17153 | 241 | 176019 | men in black hats | men in black hats | bookworm
17153 | 241 | 176017 | men in black hats | men in black hats | atmail
17153 | 240 | 174818 | men in black hats | men in black hats | avoir
17153 | 240 | 174822 | men in black hats | men in black hats | trouver
17153 | 240 | 174821 | men in black hats | men in black hats | reeses
17153 | 240 | 174820 | men in black hats | men in black hats | lonetuna
17153 | 240 | 174819 | men in black hats | men in black hats | bookworm
17153 | 240 | 174817 | men in black hats | men in black hats | atmail
17153 | 239 | 172970 | men in black hats | men in black hats | avoir
17153 | 239 | 172974 | men in black hats | men in black hats | trouver
17153 | 239 | 172973 | men in black hats | men in black hats | reeses
17153 | 239 | 172972 | men in black hats | men in black hats | lonetuna
17153 | 239 | 172971 | men in black hats | men in black hats | bookworm
17153 | 239 | 172969 | men in black hats | men in black hats | atmail
17153 | 238 | 171904 | men in black hats | men in black hats | avoir
17153 | 238 | 171908 | men in black hats | men in black hats | trouver
17153 | 238 | 171907 | men in black hats | men in black hats | reeses
17153 | 238 | 171906 | men in black hats | men in black hats | lonetuna
17153 | 238 | 171905 | men in black hats | men in black hats | bookworm
17153 | 238 | 171903 | men in black hats | men in black hats | atmail
17153 | 237 | 170468 | men in black hats | men in black hats | reeses
17153 | 237 | 170467 | men in black hats | men in black hats | lonetuna
17153 | 237 | 170466 | men in black hats | men in black hats | bookworm
17153 | 237 | 170464 | men in black hats | men in black hats | atmail
17153 | 237 | 170465 | men in black hats | men in black hats | avoir
17153 | 237 | 170469 | men in black hats | men in black hats | trouver
17153 | 236 | 168864 | men in black hats | men in black hats | avoir
17153 | 236 | 168868 | men in black hats | men in black hats | trouver
17153 | 236 | 168867 | men in black hats | men in black hats | reeses
17153 | 236 | 168866 | men in black hats | men in black hats | lonetuna
17153 | 236 | 168865 | men in black hats | men in black hats | bookworm
17153 | 236 | 168863 | men in black hats | men in black hats | atmail
17153 | 235 | 167787 | men in black hats | men in black hats | avoir
17153 | 235 | 167793 | men in black hats | men in black hats | trouver
17153 | 235 | 167792 | men in black hats | men in black hats | reeses
17153 | 235 | 167504 | men in black hats | raon_ASRT | reeses
17153 | 233 | 166461 | raon_ASRT | PPP | avoir
17153 | 232 | 165205 | PPP | men in black hats | lonetuna
17153 | 232 | 165442 | men in black hats | men in black hats | bookworm
17153 | 232 | 165439 | men in black hats | men in black hats | atmail
17153 | 231 | 165306 | men in black hats | men in black hats | avoir
17153 | 231 | 165310 | men in black hats | men in black hats | trouver
17153 | 231 | 165309 | men in black hats | men in black hats | reeses
17153 | 231 | 165297 | men in black hats | raon_ASRT | reeses
17153 | 228 | 161798 | raon_ASRT | raon_ASRT | avoir
17153 | 228 | 161792 | raon_ASRT | PPP | avoir
17153 | 228 | 161587 | PPP | men in black hats | lonetuna
17153 | 228 | 162278 | men in black hats | men in black hats | bookworm
17153 | 228 | 162276 | men in black hats | men in black hats | atmail
17153 | 227 | 161084 | men in black hats | men in black hats | avoir
17153 | 227 | 161091 | men in black hats | men in black hats | trouver
17153 | 227 | 161090 | men in black hats | men in black hats | reeses
17153 | 227 | 161307 | men in black hats | raon_ASRT | reeses
17153 | 226 | 160304 | raon_ASRT | raon_ASRT | avoir
17153 | 226 | 159991 | raon_ASRT | PPP | avoir
17153 | 226 | 159806 | PPP | men in black hats | lonetuna
17153 | 226 | 160108 | men in black hats | men in black hats | bookworm
17153 | 226 | 160106 | men in black hats | men in black hats | atmail
17153 | 225 | 159499 | men in black hats | men in black hats | avoir
17153 | 225 | 159503 | men in black hats | men in black hats | trouver
17153 | 225 | 159502 | men in black hats | men in black hats | reeses
17153 | 225 | 159437 | men in black hats | raon_ASRT | reeses
17153 | 223 | 154026 | raon_ASRT | The European Nopsled Team | trouver
17153 | 223 | 153936 | The European Nopsled Team | APT8 | atmail
17153 | 122 | 57692 | sutegoma2 | 9447 | atmail
17153 | 122 | 57172 | 9447 | pwnies | atmail
(144 rows)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment