blob: 825b456d4b58cc33bbcd558a99d031d7343a45e9 (plain)

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......