blob: 9de8f66ad8756f01a7e4a9330ad5ddee74414a81 (plain)

ofs	hex dump	ascii
0000	03 f3 0d 0a c8 6e 6e 57 63 00 00 00 00 00 00 00 00 03 00 00 00 40 00 00 00 73 3b 00 00 00 64 00	.....nnWc............@...s;...d.
0020	00 64 01 00 6c 00 00 5a 00 00 64 00 00 64 01 00 6c 01 00 5a 01 00 64 00 00 64 01 00 6c 02 00 5a	.d..l..Z..d..d..l..Z..d..d..l..Z
0040	02 00 64 02 00 64 04 00 64 03 00 84 00 00 83 00 00 59 5a 03 00 64 01 00 53 28 05 00 00 00 69 ff	..d..d..d........YZ..d..S(....i.
0060	ff ff ff 4e 74 07 00 00 00 47 75 69 6c 64 44 42 63 00 00 00 00 00 00 00 00 02 00 00 00 42 00 00	...Nt....GuildDBc............B..
0080	00 73 8f 00 00 00 65 00 00 5a 01 00 64 00 00 84 00 00 5a 02 00 64 01 00 84 00 00 5a 03 00 64 02	.s....e..Z..d.....Z..d.....Z..d.
00a0	00 84 00 00 5a 04 00 64 03 00 84 00 00 5a 05 00 64 04 00 84 00 00 5a 06 00 64 05 00 84 00 00 5a	....Z..d.....Z..d.....Z..d.....Z
00c0	07 00 64 06 00 84 00 00 5a 08 00 64 07 00 64 08 00 84 01 00 5a 09 00 64 09 00 84 00 00 5a 0a 00	..d.....Z..d..d.....Z..d.....Z..
00e0	64 0a 00 64 0b 00 84 01 00 5a 0b 00 65 0c 00 64 0c 00 84 01 00 5a 0d 00 64 0d 00 84 00 00 5a 0e	d..d.....Z..e..d.....Z..d.....Z.
0100	00 64 0e 00 84 00 00 5a 0f 00 64 0f 00 84 00 00 5a 10 00 52 53 28 10 00 00 00 63 02 00 00 00 02	.d.....Z..d.....Z..RS(....c.....
0120	00 00 00 03 00 00 00 43 00 00 00 73 67 00 00 00 7c 01 00 7c 00 00 5f 00 00 74 01 00 6a 02 00 64	.......C...sg...|..|.._..t..j..d
0140	01 00 83 01 00 7c 00 00 5f 03 00 7c 00 00 6a 04 00 7c 01 00 83 01 00 5c 02 00 7c 00 00 5f 05 00	.....|.._..|..j..|.....\..|.._..
0160	7c 00 00 5f 06 00 7c 00 00 6a 06 00 6a 07 00 64 02 00 83 01 00 01 7c 00 00 6a 06 00 6a 07 00 64	|.._..|..j..j..d......|..j..j..d
0180	03 00 83 01 00 01 7c 00 00 6a 05 00 6a 08 00 83 00 00 01 64 00 00 53 28 04 00 00 00 4e 73 0e 00	......|..j..j......d..S(....Ns..
01a0	00 00 4d 61 6e 61 43 68 61 74 2e 47 75 69 6c 64 73 18 01 00 00 63 72 65 61 74 65 20 74 61 62 6c	..ManaChat.Guilds....create.tabl
01c0	65 20 69 66 20 6e 6f 74 20 65 78 69 73 74 73 20 47 55 49 4c 44 53 28 20 20 20 20 20 20 20 20 20	e.if.not.exists.GUILDS(.........
01e0	20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 49 44 20 20 20 20 20 20 20 69 6e	.....................ID.......in
0200	74 65 67 65 72 20 70 72 69 6d 61 72 79 20 6b 65 79 2c 20 20 20 20 20 20 20 20 20 20 20 20 20 20	teger.primary.key,..............
0220	20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 4e 41 4d 45 20 20 20 20 20 74 65 78 74 5b 32 35	................NAME.....text[25
0240	5d 20 6e 6f 74 20 6e 75 6c 6c 20 75 6e 69 71 75 65 2c 20 20 20 20 20 20 20 20 20 20 20 20 20 20	].not.null.unique,..............
0260	20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 43 52 45 41 54 45 44 20 20 64 61 74 65 74 69 6d	................CREATED..datetim
0280	65 20 64 65 66 61 75 6c 74 20 63 75 72 72 65 6e 74 5f 74 69 6d 65 73 74 61 6d 70 2c 20 20 20 20	e.default.current_timestamp,....
02a0	20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 4d 4f 54 44 20 20	..........................MOTD..
02c0	20 20 20 74 65 78 74 5b 31 30 30 5d 29 73 c9 01 00 00 63 72 65 61 74 65 20 74 61 62 6c 65 20 69	...text[100])s....create.table.i
02e0	66 20 6e 6f 74 20 65 78 69 73 74 73 20 50 4c 41 59 45 52 53 28 20 20 20 20 20 20 20 20 20 20 20	f.not.exists.PLAYERS(...........
0300	20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 49 44 20 20 20 20 20 20 20 69 6e 74 65	...................ID.......inte
0320	67 65 72 20 70 72 69 6d 61 72 79 20 6b 65 79 2c 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20	ger.primary.key,................
0340	20 20 20 20 20 20 20 20 20 20 20 20 20 20 4e 41 4d 45 20 20 20 20 20 74 65 78 74 5b 32 35 5d 20	..............NAME.....text[25].
0360	6e 6f 74 20 6e 75 6c 6c 20 75 6e 69 71 75 65 2c 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20	not.null.unique,................
0380	20 20 20 20 20 20 20 20 20 20 20 20 20 20 4c 41 53 54 53 45 45 4e 20 64 61 74 65 2c 20 20 20 20	..............LASTSEEN.date,....
03a0	20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 47 55 49 4c 44 5f	..........................GUILD_
03c0	49 44 20 69 6e 74 65 67 65 72 2c 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20	ID.integer,.....................
03e0	20 20 20 20 20 20 20 20 20 41 43 43 45 53 53 20 20 20 69 6e 74 65 67 65 72 20 6e 6f 74 20 6e 75	.........ACCESS...integer.not.nu
0400	6c 6c 20 64 65 66 61 75 6c 74 20 2d 31 30 2c 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20	ll.default.-10,.................
0420	20 20 20 20 20 20 20 20 20 20 20 20 20 53 48 4f 57 49 4e 46 4f 20 62 6f 6f 6c 65 61 6e 20 6e 6f	.............SHOWINFO.boolean.no
0440	74 20 6e 75 6c 6c 20 64 65 66 61 75 6c 74 20 30 2c 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20	t.null.default.0,...............
0460	20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 66 6f 72 65 69 67 6e 20 6b 65 79 28 47 55 49 4c 44	...............foreign.key(GUILD
0480	5f 49 44 29 20 72 65 66 65 72 65 6e 63 65 73 20 47 55 49 4c 44 53 28 49 44 29 29 28 09 00 00 00	_ID).references.GUILDS(ID))(....
04a0	74 07 00 00 00 5f 64 62 66 69 6c 65 74 07 00 00 00 6c 6f 67 67 69 6e 67 74 09 00 00 00 67 65 74	t...._dbfilet....loggingt....get
04c0	4c 6f 67 67 65 72 74 06 00 00 00 6c 6f 67 67 65 72 74 0f 00 00 00 5f 6f 70 65 6e 5f 73 71 6c 69	Loggert....loggert...._open_sqli
04e0	74 65 5f 64 62 74 02 00 00 00 64 62 74 03 00 00 00 63 75 72 74 07 00 00 00 65 78 65 63 75 74 65	te_dbt....dbt....curt....execute
0500	74 06 00 00 00 63 6f 6d 6d 69 74 28 02 00 00 00 74 04 00 00 00 73 65 6c 66 74 06 00 00 00 64 62	t....commit(....t....selft....db
0520	66 69 6c 65 28 00 00 00 00 28 00 00 00 00 73 1b 00 00 00 70 6c 75 67 69 6e 73 2f 67 75 69 6c 64	file(....(....s....plugins/guild
0540	62 6f 74 2f 67 75 69 6c 64 64 62 2e 70 79 74 08 00 00 00 5f 5f 69 6e 69 74 5f 5f 08 00 00 00 73	bot/guilddb.pyt....__init__....s
0560	10 00 00 00 00 01 09 01 12 01 1b 03 09 04 07 01 09 07 07 01 63 01 00 00 00 01 00 00 00 05 00 00	....................c...........
0580	00 43 00 00 00 73 29 00 00 00 79 11 00 7c 00 00 6a 00 00 6a 01 00 83 00 00 01 57 6e 11 00 04 74	.C...s)...y..|..j..j......Wn...t
05a0	02 00 6b 0a 00 72 24 00 01 01 01 6e 01 00 58 64 00 00 53 28 01 00 00 00 4e 28 03 00 00 00 52 06	..k..r$....n..Xd..S(....N(....R.
05c0	00 00 00 74 05 00 00 00 63 6c 6f 73 65 74 09 00 00 00 45 78 63 65 70 74 69 6f 6e 28 01 00 00 00	...t....closet....Exception(....
05e0	52 0a 00 00 00 28 00 00 00 00 28 00 00 00 00 73 1b 00 00 00 70 6c 75 67 69 6e 73 2f 67 75 69 6c	R....(....(....s....plugins/guil
0600	64 62 6f 74 2f 67 75 69 6c 64 64 62 2e 70 79 74 07 00 00 00 5f 5f 64 65 6c 5f 5f 1d 00 00 00 73	dbot/guilddb.pyt....__del__....s
0620	08 00 00 00 00 01 03 01 11 01 0d 01 63 02 00 00 00 05 00 00 00 05 00 00 00 43 00 00 00 73 65 00	............c............C...se.
0640	00 00 79 1f 00 74 00 00 6a 01 00 7c 01 00 83 01 00 7d 02 00 7c 02 00 6a 02 00 83 00 00 7d 03 00	..y..t..j..|.....}..|..j.....}..
0660	57 6e 39 00 04 74 00 00 6a 03 00 6b 0a 00 72 5a 00 01 7d 04 00 01 7c 00 00 6a 04 00 6a 05 00 64	Wn9..t..j..k..rZ..}...|..j..j..d
0680	01 00 7c 04 00 6a 06 00 83 02 00 01 74 07 00 6a 08 00 64 02 00 83 01 00 01 6e 01 00 58 7c 02 00	..|..j......t..j..d......n..X|..
06a0	7c 03 00 66 02 00 53 28 03 00 00 00 73 47 00 00 00 0a 20 20 20 20 20 20 20 20 4f 70 65 6e 20 73	|..f..S(....sG............Open.s
06c0	71 6c 69 74 65 20 64 62 2c 20 61 6e 64 20 72 65 74 75 72 6e 20 74 75 70 6c 65 20 28 63 6f 6e 6e	qlite.db,.and.return.tuple.(conn
06e0	65 63 74 69 6f 6e 2c 20 63 75 72 73 6f 72 29 0a 20 20 20 20 20 20 20 20 73 11 00 00 00 73 71 6c	ection,.cursor).........s....sql
0700	69 74 65 33 20 65 72 72 6f 72 3a 20 25 73 69 01 00 00 00 28 09 00 00 00 74 07 00 00 00 73 71 6c	ite3.error:.%si....(....t....sql
0720	69 74 65 33 74 07 00 00 00 63 6f 6e 6e 65 63 74 74 06 00 00 00 63 75 72 73 6f 72 74 05 00 00 00	ite3t....connectt....cursort....
0740	45 72 72 6f 72 52 04 00 00 00 74 05 00 00 00 65 72 72 6f 72 74 07 00 00 00 6d 65 73 73 61 67 65	ErrorR....t....errort....message
0760	74 03 00 00 00 73 79 73 74 04 00 00 00 65 78 69 74 28 05 00 00 00 52 0a 00 00 00 52 0b 00 00 00	t....syst....exit(....R....R....
0780	52 06 00 00 00 52 07 00 00 00 74 01 00 00 00 65 28 00 00 00 00 28 00 00 00 00 73 1b 00 00 00 70	R....R....t....e(....(....s....p
07a0	6c 75 67 69 6e 73 2f 67 75 69 6c 64 62 6f 74 2f 67 75 69 6c 64 64 62 2e 70 79 52 05 00 00 00 23	lugins/guildbot/guilddb.pyR....#
07c0	00 00 00 73 0e 00 00 00 00 04 03 01 0f 01 10 01 12 01 16 01 11 01 63 02 00 00 00 02 00 00 00 03	...s..................c.........
07e0	00 00 00 43 00 00 00 73 61 00 00 00 7c 00 00 6a 00 00 6a 01 00 64 01 00 7c 01 00 66 01 00 83 02	...C...sa...|..j..j..d..|..f....
0800	00 01 7c 00 00 6a 02 00 6a 03 00 83 00 00 01 7c 00 00 6a 00 00 6a 04 00 72 46 00 7c 00 00 6a 05	..|..j..j......|..j..j..rF.|..j.
0820	00 6a 06 00 64 02 00 7c 01 00 83 02 00 01 74 07 00 53 7c 00 00 6a 05 00 6a 06 00 64 03 00 7c 01	.j..d..|......t..S|..j..j..d..|.
0840	00 83 02 00 01 74 08 00 53 64 00 00 53 28 04 00 00 00 4e 73 22 00 00 00 69 6e 73 65 72 74 20 69	.....t..Sd..S(....Ns"...insert.i
0860	6e 74 6f 20 47 55 49 4c 44 53 28 4e 41 4d 45 29 20 76 61 6c 75 65 73 28 3f 29 73 12 00 00 00 43	nto.GUILDS(NAME).values(?)s....C
0880	72 65 61 74 65 64 20 67 75 69 6c 64 20 22 25 73 22 73 19 00 00 00 45 72 72 6f 72 20 63 72 65 61	reated.guild."%s"s....Error.crea
08a0	74 69 6e 67 20 67 75 69 6c 64 20 22 25 73 22 28 09 00 00 00 52 07 00 00 00 52 08 00 00 00 52 06	ting.guild."%s"(....R....R....R.
08c0	00 00 00 52 09 00 00 00 74 08 00 00 00 72 6f 77 63 6f 75 6e 74 52 04 00 00 00 74 04 00 00 00 69	...R....t....rowcountR....t....i
08e0	6e 66 6f 74 04 00 00 00 54 72 75 65 74 05 00 00 00 46 61 6c 73 65 28 02 00 00 00 52 0a 00 00 00	nfot....Truet....False(....R....
0900	74 04 00 00 00 6e 61 6d 65 28 00 00 00 00 28 00 00 00 00 73 1b 00 00 00 70 6c 75 67 69 6e 73 2f	t....name(....(....s....plugins/
0920	67 75 69 6c 64 62 6f 74 2f 67 75 69 6c 64 64 62 2e 70 79 74 0c 00 00 00 67 75 69 6c 64 5f 63 72	guildbot/guilddb.pyt....guild_cr
0940	65 61 74 65 2f 00 00 00 73 0e 00 00 00 00 01 16 01 0d 01 0c 01 13 01 04 02 13 01 63 02 00 00 00	eate/...s..................c....
0960	04 00 00 00 03 00 00 00 43 00 00 00 73 a0 00 00 00 7c 00 00 6a 00 00 6a 01 00 64 01 00 7c 01 00	........C...s....|..j..j..d..|..
0980	66 01 00 83 02 00 01 7c 00 00 6a 00 00 6a 02 00 83 00 00 7d 02 00 7c 02 00 72 85 00 7c 02 00 64	f......|..j..j.....}..|..r..|..d
09a0	02 00 19 7d 03 00 7c 00 00 6a 00 00 6a 01 00 64 03 00 7c 01 00 66 01 00 83 02 00 01 7c 00 00 6a	...}..|..j..j..d..|..f......|..j
09c0	00 00 6a 01 00 64 04 00 7c 03 00 66 01 00 83 02 00 01 7c 00 00 6a 03 00 6a 04 00 83 00 00 01 7c	..j..d..|..f......|..j..j......|
09e0	00 00 6a 05 00 6a 06 00 64 05 00 7c 01 00 83 02 00 01 74 07 00 53 7c 00 00 6a 05 00 6a 08 00 64	..j..j..d..|......t..S|..j..j..d
0a00	06 00 7c 01 00 83 02 00 01 74 09 00 53 64 00 00 53 28 07 00 00 00 4e 73 24 00 00 00 73 65 6c 65	..|......t..Sd..S(....Ns$...sele
0a20	63 74 20 49 44 20 66 72 6f 6d 20 47 55 49 4c 44 53 20 77 68 65 72 65 20 6e 61 6d 65 20 3d 20 3f	ct.ID.from.GUILDS.where.name.=.?
0a40	69 00 00 00 00 73 1f 00 00 00 64 65 6c 65 74 65 20 66 72 6f 6d 20 47 55 49 4c 44 53 20 77 68 65	i....s....delete.from.GUILDS.whe
0a60	72 65 20 6e 61 6d 65 3d 3f 73 62 00 00 00 75 70 64 61 74 65 20 50 4c 41 59 45 52 53 20 73 65 74	re.name=?sb...update.PLAYERS.set
0a80	20 47 55 49 4c 44 5f 49 44 20 3d 20 4e 55 4c 4c 2c 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20	.GUILD_ID.=.NULL,...............
0aa0	20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 41 43 43 45 53 53 20 3d 20 2d 31 30 2c 20 77 68	................ACCESS.=.-10,.wh
0ac0	65 72 65 20 47 55 49 4c 44 5f 49 44 20 3d 20 3f 73 12 00 00 00 44 65 6c 65 74 65 64 20 67 75 69	ere.GUILD_ID.=.?s....Deleted.gui
0ae0	6c 64 20 22 25 73 22 73 14 00 00 00 47 75 69 6c 64 20 22 25 73 22 20 6e 6f 74 20 66 6f 75 6e 64	ld."%s"s....Guild."%s".not.found
0b00	28 0a 00 00 00 52 07 00 00 00 52 08 00 00 00 74 08 00 00 00 66 65 74 63 68 6f 6e 65 52 06 00 00	(....R....R....t....fetchoneR...
0b20	00 52 09 00 00 00 52 04 00 00 00 52 1a 00 00 00 52 1b 00 00 00 52 14 00 00 00 52 1c 00 00 00 28	.R....R....R....R....R....R....(
0b40	04 00 00 00 52 0a 00 00 00 52 1d 00 00 00 74 03 00 00 00 72 6f 77 74 08 00 00 00 67 75 69 6c 64	....R....R....t....rowt....guild
0b60	5f 69 64 28 00 00 00 00 28 00 00 00 00 73 1b 00 00 00 70 6c 75 67 69 6e 73 2f 67 75 69 6c 64 62	_id(....(....s....plugins/guildb
0b80	6f 74 2f 67 75 69 6c 64 64 62 2e 70 79 74 0c 00 00 00 67 75 69 6c 64 5f 64 65 6c 65 74 65 39 00	ot/guilddb.pyt....guild_delete9.
0ba0	00 00 73 18 00 00 00 00 01 16 01 0f 01 06 01 0a 01 16 01 09 01 0d 01 0d 01 13 01 04 02 13 01 63	..s............................c
0bc0	03 00 00 00 03 00 00 00 04 00 00 00 43 00 00 00 73 67 00 00 00 7c 00 00 6a 00 00 6a 01 00 64 01	............C...sg...|..j..j..d.
0be0	00 7c 02 00 7c 01 00 66 02 00 83 02 00 01 7c 00 00 6a 02 00 6a 03 00 83 00 00 01 7c 00 00 6a 00	.|..|..f......|..j..j......|..j.
0c00	00 6a 04 00 72 4c 00 7c 00 00 6a 05 00 6a 06 00 64 02 00 7c 01 00 7c 02 00 83 03 00 01 74 07 00	.j..rL.|..j..j..d..|..|......t..
0c20	53 7c 00 00 6a 05 00 6a 08 00 64 03 00 7c 01 00 83 02 00 01 74 09 00 53 64 00 00 53 28 04 00 00	S|..j..j..d..|......t..Sd..S(...
0c40	00 4e 73 28 00 00 00 75 70 64 61 74 65 20 47 55 49 4c 44 20 73 65 74 20 4d 4f 54 44 20 3d 20 3f	.Ns(...update.GUILD.set.MOTD.=.?
0c60	20 77 68 65 72 65 20 4e 41 4d 45 20 3d 20 3f 73 13 00 00 00 47 75 69 6c 64 20 22 25 73 22 20 4d	.where.NAME.=.?s....Guild."%s".M
0c80	4f 54 44 3a 20 25 73 73 20 00 00 00 45 72 72 6f 72 20 73 65 74 74 69 6e 67 20 4d 4f 54 44 20 66	OTD:.%ss....Error.setting.MOTD.f
0ca0	6f 72 20 67 75 69 6c 64 3a 20 25 73 28 0a 00 00 00 52 07 00 00 00 52 08 00 00 00 52 06 00 00 00	or.guild:.%s(....R....R....R....
0cc0	52 09 00 00 00 52 19 00 00 00 52 04 00 00 00 52 1a 00 00 00 52 1b 00 00 00 52 14 00 00 00 52 1c	R....R....R....R....R....R....R.
0ce0	00 00 00 28 03 00 00 00 52 0a 00 00 00 52 1d 00 00 00 74 04 00 00 00 6d 6f 74 64 28 00 00 00 00	...(....R....R....t....motd(....
0d00	28 00 00 00 00 73 1b 00 00 00 70 6c 75 67 69 6e 73 2f 67 75 69 6c 64 62 6f 74 2f 67 75 69 6c 64	(....s....plugins/guildbot/guild
0d20	64 62 2e 70 79 74 0e 00 00 00 67 75 69 6c 64 5f 73 65 74 5f 6d 6f 74 64 48 00 00 00 73 10 00 00	db.pyt....guild_set_motdH...s...
0d40	00 00 01 0c 01 0d 01 0d 01 0c 01 16 01 04 02 13 01 63 02 00 00 00 03 00 00 00 03 00 00 00 43 00	.................c............C.
0d60	00 00 73 29 00 00 00 64 01 00 7d 02 00 7c 00 00 6a 00 00 6a 01 00 7c 02 00 7c 01 00 66 01 00 83	..s)...d..}..|..j..j..|..|..f...
0d80	02 00 01 7c 00 00 6a 00 00 6a 02 00 83 00 00 53 28 02 00 00 00 4e 73 ac 00 00 00 73 65 6c 65 63	...|..j..j.....S(....Ns....selec
0da0	74 20 47 55 49 4c 44 53 2e 49 44 2c 47 55 49 4c 44 53 2e 4e 41 4d 45 2c 41 43 43 45 53 53 0a 20	t.GUILDS.ID,GUILDS.NAME,ACCESS..
0dc0	20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 66 72 6f 6d 20 50 4c 41 59 45 52 53 20 6a	..................from.PLAYERS.j
0de0	6f 69 6e 20 47 55 49 4c 44 53 0a 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 6f 6e	oin.GUILDS....................on
0e00	20 50 4c 41 59 45 52 53 2e 47 55 49 4c 44 5f 49 44 20 3d 20 47 55 49 4c 44 53 2e 49 44 0a 20 20	.PLAYERS.GUILD_ID.=.GUILDS.ID...
0e20	20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 77 68 65 72 65 20 50 4c 41 59 45 52 53 2e 4e	.................where.PLAYERS.N
0e40	41 4d 45 20 3d 20 3f 28 03 00 00 00 52 07 00 00 00 52 08 00 00 00 52 1f 00 00 00 28 03 00 00 00	AME.=.?(....R....R....R....(....
0e60	52 0a 00 00 00 52 1d 00 00 00 74 05 00 00 00 71 75 65 72 79 28 00 00 00 00 28 00 00 00 00 73 1b	R....R....t....query(....(....s.
0e80	00 00 00 70 6c 75 67 69 6e 73 2f 67 75 69 6c 64 62 6f 74 2f 67 75 69 6c 64 64 62 2e 70 79 74 0b	...plugins/guildbot/guilddb.pyt.
0ea0	00 00 00 70 6c 61 79 65 72 5f 69 6e 66 6f 53 00 00 00 73 06 00 00 00 00 04 06 01 16 01 74 00 00	...player_infoS...s..........t..
0ec0	00 00 63 03 00 00 00 05 00 00 00 04 00 00 00 43 00 00 00 73 44 00 00 00 64 01 00 7d 03 00 7c 00	..c............C...sD...d..}..|.
0ee0	00 6a 00 00 6a 01 00 7c 03 00 7c 01 00 7c 02 00 66 02 00 83 02 00 01 7c 00 00 6a 00 00 6a 02 00	.j..j..|..|..|..f......|..j..j..
0f00	83 00 00 7d 04 00 7c 04 00 72 3c 00 7c 04 00 64 02 00 19 53 64 03 00 53 64 00 00 53 28 04 00 00	...}..|..r<.|..d...Sd..Sd..S(...
0f20	00 4e 73 29 00 00 00 73 65 6c 65 63 74 20 41 43 43 45 53 53 20 66 72 6f 6d 20 50 4c 41 59 45 52	.Ns)...select.ACCESS.from.PLAYER
0f40	53 20 77 68 65 72 65 20 4e 41 4d 45 20 3d 20 3f 69 00 00 00 00 69 f6 ff ff ff 28 03 00 00 00 52	S.where.NAME.=.?i....i....(....R
0f60	07 00 00 00 52 08 00 00 00 52 1f 00 00 00 28 05 00 00 00 52 0a 00 00 00 52 1d 00 00 00 74 0a 00	....R....R....(....R....R....t..
0f80	00 00 67 75 69 6c 64 5f 6e 61 6d 65 52 25 00 00 00 52 20 00 00 00 28 00 00 00 00 28 00 00 00 00	..guild_nameR%...R....(....(....
0fa0	73 1b 00 00 00 70 6c 75 67 69 6e 73 2f 67 75 69 6c 64 62 6f 74 2f 67 75 69 6c 64 64 62 2e 70 79	s....plugins/guildbot/guilddb.py
0fc0	74 11 00 00 00 70 6c 61 79 65 72 5f 67 65 74 5f 61 63 63 65 73 73 5b 00 00 00 73 0c 00 00 00 00	t....player_get_access[...s.....
0fe0	01 06 01 19 01 0f 01 06 01 08 03 63 03 00 00 00 04 00 00 00 04 00 00 00 43 00 00 00 73 30 00 00	...........c............C...s0..
1000	00 64 01 00 7d 03 00 7c 00 00 6a 00 00 6a 01 00 7c 03 00 7c 01 00 7c 02 00 66 02 00 83 02 00 01	.d..}..|..j..j..|..|..|..f......
1020	7c 00 00 6a 02 00 6a 03 00 83 00 00 01 64 00 00 53 28 02 00 00 00 4e 73 45 00 00 00 75 70 64 61	|..j..j......d..S(....NsE...upda
1040	74 65 20 74 61 62 6c 65 20 50 4c 41 59 45 52 53 20 73 65 74 20 41 43 43 45 53 53 20 3d 20 3f 0a	te.table.PLAYERS.set.ACCESS.=.?.
1060	20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 77 68 65 72 65 20 6e 61 6d 65 20 3d 20	...................where.name.=.
1080	3f 28 04 00 00 00 52 07 00 00 00 52 08 00 00 00 52 06 00 00 00 52 09 00 00 00 28 04 00 00 00 52	?(....R....R....R....R....(....R
10a0	0a 00 00 00 52 1d 00 00 00 74 0c 00 00 00 61 63 63 65 73 73 5f 6c 65 76 65 6c 52 25 00 00 00 28	....R....t....access_levelR%...(
10c0	00 00 00 00 28 00 00 00 00 73 1b 00 00 00 70 6c 75 67 69 6e 73 2f 67 75 69 6c 64 62 6f 74 2f 67	....(....s....plugins/guildbot/g
10e0	75 69 6c 64 64 62 2e 70 79 74 11 00 00 00 70 6c 61 79 65 72 5f 73 65 74 5f 61 63 63 65 73 73 65	uilddb.pyt....player_set_accesse
1100	00 00 00 73 06 00 00 00 00 02 06 01 19 01 69 00 00 00 00 63 04 00 00 00 07 00 00 00 05 00 00 00	...s..........i....c............
1120	43 00 00 00 73 b7 00 00 00 7c 00 00 6a 00 00 6a 01 00 64 01 00 7c 02 00 66 01 00 83 02 00 01 7c	C...s....|..j..j..d..|..f......|
1140	00 00 6a 00 00 6a 02 00 83 00 00 7d 04 00 7c 04 00 72 38 00 7c 04 00 64 02 00 19 7d 05 00 6e 17	..j..j.....}..|..r8.|..d...}..n.
1160	00 7c 00 00 6a 03 00 6a 04 00 64 03 00 7c 02 00 83 02 00 01 74 05 00 53 64 04 00 7d 06 00 7c 00	.|..j..j..d..|......t..Sd..}..|.
1180	00 6a 00 00 6a 01 00 7c 06 00 7c 05 00 7c 03 00 66 02 00 83 02 00 01 64 05 00 7d 06 00 7c 00 00	.j..j..|..|..|..f......d..}..|..
11a0	6a 00 00 6a 01 00 7c 06 00 7c 01 00 7c 05 00 7c 03 00 66 03 00 83 02 00 01 7c 00 00 6a 06 00 6a	j..j..|..|..|..|..f......|..j..j
11c0	07 00 83 00 00 01 7c 00 00 6a 03 00 6a 08 00 64 06 00 7c 01 00 7c 02 00 83 03 00 01 74 09 00 53	......|..j..j..d..|..|......t..S
11e0	28 07 00 00 00 4e 73 24 00 00 00 73 65 6c 65 63 74 20 49 44 20 66 72 6f 6d 20 47 55 49 4c 44 53	(....Ns$...select.ID.from.GUILDS
1200	20 77 68 65 72 65 20 4e 41 4d 45 20 3d 20 3f 69 00 00 00 00 73 14 00 00 00 47 75 69 6c 64 20 22	.where.NAME.=.?i....s....Guild."
1220	25 73 22 20 6e 6f 74 20 66 6f 75 6e 64 73 6a 00 00 00 75 70 64 61 74 65 20 6f 72 20 69 67 6e 6f	%s".not.foundsj...update.or.igno
1240	72 65 20 50 4c 41 59 45 52 53 0a 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 73 65	re.PLAYERS....................se
1260	74 20 47 55 49 4c 44 5f 49 44 20 3d 20 3f 2c 20 41 43 43 45 53 53 20 3d 20 3f 0a 20 20 20 20 20	t.GUILD_ID.=.?,.ACCESS.=.?......
1280	20 20 20 20 20 20 20 20 20 20 20 20 20 20 77 68 65 72 65 20 4e 41 4d 45 20 3d 20 3f 73 6b 00 00	..............where.NAME.=.?sk..
12a0	00 69 6e 73 65 72 74 20 6f 72 20 69 67 6e 6f 72 65 20 69 6e 74 6f 0a 20 20 20 20 20 20 20 20 20	.insert.or.ignore.into..........
12c0	20 20 20 20 20 20 20 20 20 20 50 4c 41 59 45 52 53 28 4e 41 4d 45 2c 20 47 55 49 4c 44 5f 49 44	..........PLAYERS(NAME,.GUILD_ID
12e0	2c 20 41 43 43 45 53 53 29 0a 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 76 61 6c	,.ACCESS)....................val
1300	75 65 73 28 3f 2c 20 3f 2c 20 3f 29 73 1f 00 00 00 41 64 64 65 64 20 70 6c 61 79 65 72 20 22 25	ues(?,.?,.?)s....Added.player."%
1320	73 22 20 74 6f 20 67 75 69 6c 64 20 22 25 73 22 28 0a 00 00 00 52 07 00 00 00 52 08 00 00 00 52	s".to.guild."%s"(....R....R....R
1340	1f 00 00 00 52 04 00 00 00 52 14 00 00 00 52 1c 00 00 00 52 06 00 00 00 52 09 00 00 00 52 1a 00	....R....R....R....R....R....R..
1360	00 00 52 1b 00 00 00 28 07 00 00 00 52 0a 00 00 00 74 06 00 00 00 70 6c 61 79 65 72 74 05 00 00	..R....(....R....t....playert...
1380	00 67 75 69 6c 64 74 06 00 00 00 61 63 63 65 73 73 74 0a 00 00 00 67 75 69 6c 64 5f 69 6e 66 6f	.guildt....accesst....guild_info
13a0	52 21 00 00 00 52 25 00 00 00 28 00 00 00 00 28 00 00 00 00 73 1b 00 00 00 70 6c 75 67 69 6e 73	R!...R%...(....(....s....plugins
13c0	2f 67 75 69 6c 64 62 6f 74 2f 67 75 69 6c 64 64 62 2e 70 79 74 11 00 00 00 70 6c 61 79 65 72 5f	/guildbot/guilddb.pyt....player_
13e0	6a 6f 69 6e 5f 67 75 69 6c 64 6b 00 00 00 73 1c 00 00 00 00 01 16 01 0f 01 06 01 0d 02 13 01 04	join_guildk...s.................
1400	04 06 01 19 04 06 01 1c 02 0d 02 0c 01 0a 01 63 03 00 00 00 04 00 00 00 04 00 00 00 43 00 00 00	...............c............C...
1420	73 30 00 00 00 64 01 00 7d 03 00 7c 00 00 6a 00 00 6a 01 00 7c 03 00 7c 01 00 7c 02 00 66 02 00	s0...d..}..|..j..j..|..|..|..f..
1440	83 02 00 01 7c 00 00 6a 02 00 6a 03 00 83 00 00 01 64 00 00 53 28 02 00 00 00 4e 73 47 00 00 00	....|..j..j......d..S(....NsG...
1460	75 70 64 61 74 65 20 74 61 62 6c 65 20 50 4c 41 59 45 52 53 20 73 65 74 20 53 48 4f 57 49 4e 46	update.table.PLAYERS.set.SHOWINF
1480	4f 20 3d 20 3f 0a 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 77 68 65 72 65 20 6e	O.=.?....................where.n
14a0	61 6d 65 20 3d 20 3f 28 04 00 00 00 52 07 00 00 00 52 08 00 00 00 52 06 00 00 00 52 09 00 00 00	ame.=.?(....R....R....R....R....
14c0	28 04 00 00 00 52 0a 00 00 00 52 2c 00 00 00 74 02 00 00 00 73 69 52 25 00 00 00 28 00 00 00 00	(....R....R,...t....siR%...(....
14e0	28 00 00 00 00 73 1b 00 00 00 70 6c 75 67 69 6e 73 2f 67 75 69 6c 64 62 6f 74 2f 67 75 69 6c 64	(....s....plugins/guildbot/guild
1500	64 62 2e 70 79 74 13 00 00 00 70 6c 61 79 65 72 5f 73 65 74 5f 73 68 6f 77 69 6e 66 6f 84 00 00	db.pyt....player_set_showinfo...
1520	00 73 06 00 00 00 00 02 06 01 19 01 63 02 00 00 00 03 00 00 00 03 00 00 00 43 00 00 00 73 2d 00	.s..........c............C...s-.
1540	00 00 64 01 00 7d 02 00 7c 00 00 6a 00 00 6a 01 00 7c 02 00 7c 01 00 66 01 00 83 02 00 01 7c 00	..d..}..|..j..j..|..|..f......|.
1560	00 6a 02 00 6a 03 00 83 00 00 01 64 00 00 53 28 02 00 00 00 4e 73 52 00 00 00 75 70 64 61 74 65	.j..j......d..S(....NsR...update
1580	20 50 4c 41 59 45 52 53 20 73 65 74 20 47 55 49 4c 44 5f 49 44 20 3d 20 4e 55 4c 4c 2c 20 41 43	.PLAYERS.set.GUILD_ID.=.NULL,.AC
15a0	43 45 53 53 20 3d 20 2d 31 30 0a 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 77 68	CESS.=.-10....................wh
15c0	65 72 65 20 4e 41 4d 45 20 3d 20 3f 28 04 00 00 00 52 07 00 00 00 52 08 00 00 00 52 06 00 00 00	ere.NAME.=.?(....R....R....R....
15e0	52 09 00 00 00 28 03 00 00 00 52 0a 00 00 00 74 0b 00 00 00 70 6c 61 79 65 72 5f 6e 61 6d 65 52	R....(....R....t....player_nameR
1600	25 00 00 00 28 00 00 00 00 28 00 00 00 00 73 1b 00 00 00 70 6c 75 67 69 6e 73 2f 67 75 69 6c 64	%...(....(....s....plugins/guild
1620	62 6f 74 2f 67 75 69 6c 64 64 62 2e 70 79 74 13 00 00 00 67 75 69 6c 64 5f 72 65 6d 6f 76 65 5f	bot/guilddb.pyt....guild_remove_
1640	70 6c 61 79 65 72 8a 00 00 00 73 06 00 00 00 00 02 06 01 16 01 63 02 00 00 00 03 00 00 00 03 00	player....s..........c..........
1660	00 00 43 00 00 00 73 1c 00 00 00 64 01 00 7d 02 00 7c 00 00 6a 00 00 6a 01 00 7c 02 00 7c 01 00	..C...s....d..}..|..j..j..|..|..
1680	66 01 00 83 02 00 53 28 02 00 00 00 4e 73 8f 00 00 00 73 65 6c 65 63 74 20 4e 41 4d 45 20 66 72	f.....S(....Ns....select.NAME.fr
16a0	6f 6d 20 50 4c 41 59 45 52 53 0a 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 77 68	om.PLAYERS....................wh
16c0	65 72 65 20 47 55 49 4c 44 5f 49 44 20 3d 20 28 73 65 6c 65 63 74 20 47 55 49 4c 44 5f 49 44 20	ere.GUILD_ID.=.(select.GUILD_ID.
16e0	66 72 6f 6d 20 50 4c 41 59 45 52 53 0a 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20	from.PLAYERS....................
1700	20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 77 68 65 72 65 20 4e 41 4d 45 20 3d 20 3f	..................where.NAME.=.?
1720	29 28 02 00 00 00 52 07 00 00 00 74 08 00 00 00 66 65 74 63 68 61 6c 6c 28 03 00 00 00 52 0a 00	)(....R....t....fetchall(....R..
1740	00 00 52 33 00 00 00 52 25 00 00 00 28 00 00 00 00 28 00 00 00 00 73 1b 00 00 00 70 6c 75 67 69	..R3...R%...(....(....s....plugi
1760	6e 73 2f 67 75 69 6c 64 62 6f 74 2f 67 75 69 6c 64 64 62 2e 70 79 74 16 00 00 00 61 6c 6c 5f 70	ns/guildbot/guilddb.pyt....all_p
1780	6c 61 79 65 72 73 5f 73 61 6d 65 5f 67 75 69 6c 64 90 00 00 00 73 04 00 00 00 00 03 06 01 63 01	layers_same_guild....s........c.
17a0	00 00 00 02 00 00 00 02 00 00 00 43 00 00 00 73 16 00 00 00 64 01 00 7d 01 00 7c 00 00 6a 00 00	...........C...s....d..}..|..j..
17c0	6a 01 00 7c 01 00 83 01 00 53 28 02 00 00 00 4e 73 3d 00 00 00 73 65 6c 65 63 74 20 4e 41 4d 45	j..|.....S(....Ns=...select.NAME
17e0	20 66 72 6f 6d 20 50 4c 41 59 45 52 53 0a 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20	.from.PLAYERS...................
1800	20 77 68 65 72 65 20 41 43 43 45 53 53 20 3e 3d 20 30 28 02 00 00 00 52 07 00 00 00 52 35 00 00	.where.ACCESS.>=.0(....R....R5..
1820	00 28 02 00 00 00 52 0a 00 00 00 52 25 00 00 00 28 00 00 00 00 28 00 00 00 00 73 1b 00 00 00 70	.(....R....R%...(....(....s....p
1840	6c 75 67 69 6e 73 2f 67 75 69 6c 64 62 6f 74 2f 67 75 69 6c 64 64 62 2e 70 79 74 15 00 00 00 61	lugins/guildbot/guilddb.pyt....a
1860	6c 6c 5f 70 6c 61 79 65 72 73 5f 61 6e 79 5f 67 75 69 6c 64 96 00 00 00 73 04 00 00 00 00 02 06	ll_players_any_guild....s.......
1880	01 28 11 00 00 00 74 08 00 00 00 5f 5f 6e 61 6d 65 5f 5f 74 0a 00 00 00 5f 5f 6d 6f 64 75 6c 65	.(....t....__name__t....__module
18a0	5f 5f 52 0c 00 00 00 52 0f 00 00 00 52 05 00 00 00 52 1e 00 00 00 52 22 00 00 00 52 24 00 00 00	__R....R....R....R....R"...R$...
18c0	52 26 00 00 00 52 29 00 00 00 52 2b 00 00 00 52 30 00 00 00 52 1b 00 00 00 52 32 00 00 00 52 34	R&...R)...R+...R0...R....R2...R4
18e0	00 00 00 52 36 00 00 00 52 37 00 00 00 28 00 00 00 00 28 00 00 00 00 28 00 00 00 00 73 1b 00 00	...R6...R7...(....(....(....s...
1900	00 70 6c 75 67 69 6e 73 2f 67 75 69 6c 64 62 6f 74 2f 67 75 69 6c 64 64 62 2e 70 79 52 00 00 00	.plugins/guildbot/guilddb.pyR...
1920	00 06 00 00 00 73 1c 00 00 00 06 02 09 15 09 06 09 0c 09 0a 09 0f 09 0b 09 08 0c 0a 09 06 0c 19	.....s..........................
1940	0c 06 09 06 09 06 28 00 00 00 00 28 04 00 00 00 52 02 00 00 00 52 16 00 00 00 52 10 00 00 00 52	......(....(....R....R....R....R
1960	00 00 00 00 28 00 00 00 00 28 00 00 00 00 28 00 00 00 00 73 1b 00 00 00 70 6c 75 67 69 6e 73 2f	....(....(....(....s....plugins/
1980	67 75 69 6c 64 62 6f 74 2f 67 75 69 6c 64 64 62 2e 70 79 74 08 00 00 00 3c 6d 6f 64 75 6c 65 3e	guildbot/guilddb.pyt....<module>
19a0	01 00 00 00 73 06 00 00 00 0c 01 0c 01 0c 03	....s..........