ofs | hex dump | ascii |
---|
0000 | 03 f3 0d 0a 2f 56 e5 58 63 00 00 00 00 00 00 00 00 02 00 00 00 40 00 00 00 73 20 00 00 00 64 00 | ..../V.Xc............@...s....d. |
0020 | 00 64 01 00 6c 00 00 6d 01 00 5a 01 00 01 65 02 00 64 02 00 84 01 00 5a 03 00 64 03 00 53 28 04 | .d..l..m..Z...e..d.....Z..d..S(. |
0040 | 00 00 00 69 ff ff ff ff 28 01 00 00 00 74 06 00 00 00 63 75 72 73 6f 72 63 02 00 00 00 08 00 00 | ...i....(....t....cursorc....... |
0060 | 00 06 00 00 00 43 00 00 00 73 53 01 00 00 64 01 00 7d 02 00 74 00 00 6a 01 00 7c 02 00 69 01 00 | .....C...sS...d..}..t..j..|..i.. |
0080 | 7c 00 00 64 02 00 36 83 02 00 01 69 03 00 69 00 00 64 03 00 36 69 00 00 64 04 00 36 69 00 00 64 | |..d..6....i..i..d..6i..d..6i..d |
00a0 | 05 00 36 7d 03 00 74 00 00 6a 02 00 83 00 00 7d 04 00 78 d9 00 7c 04 00 44 5d d1 00 7d 05 00 7c | ..6}..t..j.....}..x..|..D]..}..| |
00c0 | 05 00 64 03 00 19 64 06 00 6b 02 00 72 6e 00 64 07 00 7c 05 00 64 03 00 3c 6e 00 00 78 72 00 64 | ..d...d..k..rn.d..|..d..<n..xr.d |
00e0 | 03 00 64 04 00 64 05 00 67 03 00 44 5d 61 00 7d 06 00 7c 05 00 7c 06 00 19 7c 03 00 7c 06 00 19 | ..d..d..g..D]a.}..|..|...|..|... |
0100 | 6b 07 00 72 ad 00 64 08 00 7c 03 00 7c 06 00 19 7c 05 00 7c 06 00 19 3c 6e 00 00 7c 03 00 7c 06 | k..r..d..|..|...|..|...<n..|..|. |
0120 | 00 19 7c 05 00 7c 06 00 19 63 02 00 19 64 09 00 37 03 3c 7c 03 00 7c 06 00 19 7c 05 00 7c 06 00 | ..|..|...c...d..7.<|..|...|..|.. |
0140 | 19 19 7c 05 00 7c 06 00 64 0a 00 17 3c 71 7e 00 57 78 36 00 64 0b 00 64 03 00 64 04 00 64 05 00 | ..|..|..d...<q~.Wx6.d..d..d..d.. |
0160 | 67 04 00 44 5d 22 00 7d 06 00 64 0c 00 7c 05 00 7c 06 00 64 0d 00 17 3c 64 0e 00 7c 05 00 7c 06 | g..D]".}..d..|..|..d...<d..|..|. |
0180 | 00 64 0f 00 17 3c 71 f6 00 57 71 4b 00 57 7c 01 00 72 4f 01 69 00 00 7d 07 00 78 1c 00 7c 04 00 | .d...<q..WqK.W|..rO.i..}..x..|.. |
01a0 | 44 5d 14 00 7d 05 00 7c 05 00 7c 07 00 7c 05 00 64 10 00 19 3c 71 33 01 57 7c 07 00 53 7c 04 00 | D]..}..|..|..|..d...<q3.W|..S|.. |
01c0 | 53 28 11 00 00 00 4e 73 7f 01 00 00 53 45 4c 45 43 54 0a 20 20 20 20 72 61 6e 6b 69 6e 67 73 2e | S(....Ns....SELECT.....rankings. |
01e0 | 70 6c 61 63 65 2c 0a 20 20 20 20 72 61 6e 6b 69 6e 67 73 2e 70 69 64 2c 0a 20 20 20 20 43 4f 4e | place,.....rankings.pid,.....CON |
0200 | 43 41 54 28 70 6c 61 79 65 72 73 2e 6e 61 6d 65 2c 20 22 20 22 2c 20 70 6c 61 79 65 72 73 2e 73 | CAT(players.name,.".",.players.s |
0220 | 75 72 6e 61 6d 65 29 20 70 6c 61 79 65 72 2c 0a 20 20 20 20 70 6c 61 79 65 72 73 2e 72 61 6e 6b | urname).player,.....players.rank |
0240 | 2c 0a 20 20 20 20 72 61 6e 6b 69 6e 67 73 2e 72 65 67 69 6f 6e 2c 20 70 6c 61 79 65 72 73 2e 63 | ,.....rankings.region,.players.c |
0260 | 6c 75 62 2c 0a 20 20 20 20 52 45 50 4c 41 43 45 28 72 61 6e 6b 69 6e 67 73 2e 66 6c 61 67 73 2c | lub,.....REPLACE(rankings.flags, |
0280 | 20 22 4b 22 2c 20 22 22 29 20 61 67 65 2c 0a 20 20 20 20 49 46 28 72 61 6e 6b 69 6e 67 73 2e 66 | ."K",."").age,.....IF(rankings.f |
02a0 | 6c 61 67 73 20 4c 49 4b 45 20 27 4b 25 27 2c 20 22 4b 22 2c 20 22 22 29 20 67 65 6e 64 65 72 2c | lags.LIKE.'K%',."K",."").gender, |
02c0 | 0a 20 20 20 20 72 61 6e 6b 69 6e 67 73 2e 73 63 6f 72 65 0a 46 52 4f 4d 20 72 61 6e 6b 69 6e 67 | .....rankings.score.FROM.ranking |
02e0 | 73 0a 4a 4f 49 4e 20 70 6c 61 79 65 72 73 0a 20 20 20 20 4f 4e 20 70 6c 61 79 65 72 73 2e 69 64 | s.JOIN.players.....ON.players.id |
0300 | 20 3d 20 72 61 6e 6b 69 6e 67 73 2e 70 69 64 0a 57 48 45 52 45 20 72 61 6e 6b 69 6e 67 73 2e 64 | .=.rankings.pid.WHERE.rankings.d |
0320 | 61 74 65 20 3d 20 25 28 64 61 74 65 29 73 0a 4f 52 44 45 52 20 42 59 20 72 61 6e 6b 69 6e 67 73 | ate.=.%(date)s.ORDER.BY.rankings |
0340 | 2e 70 6c 61 63 65 0a 20 20 20 20 74 04 00 00 00 64 61 74 65 74 06 00 00 00 67 65 6e 64 65 72 74 | .place.....t....datet....gendert |
0360 | 03 00 00 00 61 67 65 74 06 00 00 00 72 65 67 69 6f 6e 74 00 00 00 00 74 01 00 00 00 4d 69 00 00 | ....aget....regiont....t....Mi.. |
0380 | 00 00 69 01 00 00 00 73 06 00 00 00 2d 70 6c 61 63 65 74 05 00 00 00 70 6c 61 63 65 74 01 00 00 | ..i....s....-placet....placet... |
03a0 | 00 4e 73 07 00 00 00 2d 63 68 61 6e 67 65 74 04 00 00 00 69 6e 66 6f 73 0d 00 00 00 2d 63 68 61 | .Ns....-changet....infos....-cha |
03c0 | 6e 67 65 2d 63 6c 61 73 73 74 03 00 00 00 70 69 64 28 03 00 00 00 52 00 00 00 00 74 07 00 00 00 | nge-classt....pid(....R....t.... |
03e0 | 65 78 65 63 75 74 65 74 08 00 00 00 66 65 74 63 68 61 6c 6c 28 08 00 00 00 52 01 00 00 00 74 05 | executet....fetchall(....R....t. |
0400 | 00 00 00 61 73 73 6f 63 74 03 00 00 00 73 71 6c 74 05 00 00 00 72 61 6e 6b 73 74 07 00 00 00 72 | ...assoct....sqlt....rankst....r |
0420 | 61 6e 6b 69 6e 67 74 03 00 00 00 72 6f 77 74 08 00 00 00 63 61 74 65 67 6f 72 79 74 06 00 00 00 | ankingt....rowt....categoryt.... |
0440 | 72 65 73 75 6c 74 28 00 00 00 00 28 00 00 00 00 73 41 00 00 00 2f 73 72 76 2f 77 65 62 73 69 74 | result(....(....sA.../srv/websit |
0460 | 65 73 2f 64 75 7a 6f 2d 72 6f 7a 6e 79 63 68 2d 74 61 62 65 6c 65 6b 2e 65 6d 6b 61 65 6c 2e 69 | es/duzo-roznych-tabelek.emkael.i |
0480 | 6e 66 6f 2f 70 79 72 61 6e 6b 69 6e 67 2f 66 65 74 63 68 2e 70 79 74 0d 00 00 00 66 65 74 63 68 | nfo/pyranking/fetch.pyt....fetch |
04a0 | 5f 72 61 6e 6b 69 6e 67 03 00 00 00 73 30 00 00 00 00 0f 06 01 17 01 03 01 07 01 07 01 0a 02 0c | _ranking....s0.................. |
04c0 | 01 0d 01 10 01 0d 01 16 01 14 01 15 01 18 01 1e 01 19 01 0e 01 16 01 06 01 06 01 0d 01 12 01 04 | ................................ |
04e0 | 01 4e 28 04 00 00 00 74 0c 00 00 00 70 79 72 61 6e 6b 69 6e 67 2e 64 62 52 00 00 00 00 74 05 00 | .N(....t....pyranking.dbR....t.. |
0500 | 00 00 46 61 6c 73 65 52 14 00 00 00 28 00 00 00 00 28 00 00 00 00 28 00 00 00 00 73 41 00 00 00 | ..FalseR....(....(....(....sA... |
0520 | 2f 73 72 76 2f 77 65 62 73 69 74 65 73 2f 64 75 7a 6f 2d 72 6f 7a 6e 79 63 68 2d 74 61 62 65 6c | /srv/websites/duzo-roznych-tabel |
0540 | 65 6b 2e 65 6d 6b 61 65 6c 2e 69 6e 66 6f 2f 70 79 72 61 6e 6b 69 6e 67 2f 66 65 74 63 68 2e 70 | ek.emkael.info/pyranking/fetch.p |
0560 | 79 74 08 00 00 00 3c 6d 6f 64 75 6c 65 3e 01 00 00 00 73 02 00 00 00 10 02 | yt....<module>....s...... |