ccev / discordopole Goto Github PK

Second table for mons is good and second table for Shiny would be also realy good... shiny table for MAD is trs_stats_detect_raw and it is big as hell, so it need a truncate from time to time with loss of all... so a second table would be realy usefull if discordopole could read out and use it... simple: shiny; named table. mysql command for transfer (MAD tested): insert into shiny select * from trs_stats_detect_raw on duplicate key update shiny.id=trs_stats_detect_raw.id,shiny.worker=trs_stats_detect_raw.worker,
shiny.type_id=trs_stats_detect_raw.type_id,shiny.type=trs_stats_detect_raw.type,
shiny.count=trs_stats_detect_raw.count,shiny.is_shiny=trs_stats_detect_raw.is_shiny,
shiny.timestamp_scan=trs_stats_detect_raw.timestamp_scan;

Integration realy apreciated.

Can you please add a space between quest and lures, like the other stats.

i wanted to see if we could add the level number to the raid boards title to be helpful if you have a separate board for each level.

Command issue: you wrote !boards create... on all commands in readme for raids / eggs... it is just !board.... and you could write !board create stats area ...

With some Pokémon or after a few attempts in short time, I getting every time this error, all modules are up to date!

requested Wingull stats for area Alle
using alt table, because starttime older than oldest mon. starttime: 2020-06-14 05:03:33, oldest mon: 2020-06-29 05:02:47

Task was destroyed but it is pending!
task: <ClientEventTask state=pending event=on_message coro=<bound method BotBase.on_message of <discord.ext.commands.bot.Bot object at 0x7fbd873704c0>>>
Ignoring exception in command pokemon:
Traceback (most recent call last):
File "/usr/local/lib/python3.8/dist-packages/aiomysql/connection.py", line 598, in _read_bytes
data = await self._reader.readexactly(num_bytes)
GeneratorExit

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/usr/local/lib/python3.8/dist-packages/discord/ext/commands/core.py", line 83, in wrapped
ret = await coro(*args, **kwargs)
File "discordopole.py", line 198, in pokemon
alt_shiny_count = await queries.get_shiny_count(mon.id, area[0], alt_timespan[0], alt_timespan[1], bot.config, use_alt_table=True)
File "/home/..../Discordopole/util/queries.py", line 59, in get_shiny_count
await cursor_shiny_count.execute(query_shiny_count)
File "/usr/local/lib/python3.8/dist-packages/aiomysql/cursors.py", line 239, in execute
await self._query(query)
File "/usr/local/lib/python3.8/dist-packages/aiomysql/cursors.py", line 457, in _query
await conn.query(q)
File "/usr/local/lib/python3.8/dist-packages/aiomysql/connection.py", line 428, in query
await self._read_query_result(unbuffered=unbuffered)
File "/usr/local/lib/python3.8/dist-packages/aiomysql/connection.py", line 622, in _read_query_result
await result.read()
File "/usr/local/lib/python3.8/dist-packages/aiomysql/connection.py", line 1105, in read
first_packet = await self.connection._read_packet()
File "/usr/local/lib/python3.8/dist-packages/aiomysql/connection.py", line 561, in _read_packet
packet_header = await self._read_bytes(4)
File "/usr/local/lib/python3.8/dist-packages/aiomysql/connection.py", line 599, in _read_bytes
except asyncio.streams.IncompleteReadError as e:
AttributeError: module 'asyncio.streams' has no attribute 'IncompleteReadError'

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/usr/local/lib/python3.8/dist-packages/discord/ext/commands/bot.py", line 892, in invoke
await ctx.command.invoke(ctx)
File "/usr/local/lib/python3.8/dist-packages/discord/ext/commands/core.py", line 797, in invoke
await injected(*ctx.args, **ctx.kwargs)
File "/usr/local/lib/python3.8/dist-packages/discord/ext/commands/core.py", line 92, in wrapped
raise CommandInvokeError(exc) from exc
discord.ext.commands.errors.CommandInvokeError: Command raised an exception: AttributeError: module 'asyncio.streams' has no attribute 'IncompleteReadError'