| 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.......... |
 |
index : HoraK-FDF/manachat | |
| Travis' Manachat. For chatting without a game UI. | root |
| summaryrefslogtreecommitdiff |
blob: 9de8f66ad8756f01a7e4a9330ad5ddee74414a81 (plain)