pieinthesky-inc/pss-fleet-helper

A bot assisting in Discord management

pss-fleet-helper's Issues

Add a command to prune everyone without a role who has joined a specified number of days ago.

Add a server backup feature

Make server backups. Channels, roles, server settings (like a template does). Able to create content backups, too. By channel.

Add a command to edit an embed message

E.g. vv embed replace taking a link to the message to be edited and an embed definition.

Add a command to track and print tournament performance for a specified fleet

Add some sort of progress display for commands `role addtorole` & `role removefromrole`

Looks like for large numbers of affected users, the command is very slow (probably due to rate-limits) and you can't tell when it's finished or how many users have been edited so far.

Add a command to update Discord roles according to in game fleet and rank

`vivi rr add` fails with AttributeError

When attempting to edit a Reaction Role ask to deactivate it

instead of throwing an error.

Add a command to relate in game fleets and ranks to Discord roles

Add a command to prune Discord members from the database

Removes anyone not on the Discord server anymore from the database.
Make the user choose if all of those shall be pruned or only those that also aren't in a fleet anymore

Add command to remove a role from all members

`role addtorole` & `role removefromrole` don't notify the user if no member matches

Catch psycopg2.OperationalError

2022-04-13T12:34:26.808525+00:00 app[worker.1]:   File "/app/.heroku/python/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1802, in _execute_context
2022-04-13T12:34:26.808526+00:00 app[worker.1]:     self.dialect.do_execute(
2022-04-13T12:34:26.808547+00:00 app[worker.1]:   File "/app/.heroku/python/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute
2022-04-13T12:34:26.808547+00:00 app[worker.1]:     cursor.execute(statement, parameters)
2022-04-13T12:34:26.808549+00:00 app[worker.1]: sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) terminating connection due to administrator command
2022-04-13T12:34:26.808550+00:00 app[worker.1]: SSL connection has been closed unexpectedly
2022-04-13T12:34:26.808550+00:00 app[worker.1]: 
2022-04-13T12:34:26.808551+00:00 app[worker.1]: [SQL: SELECT pss_chat_log.pss_chat_log_id AS pss_chat_log_pss_chat_log_id, pss_chat_log.created_at AS pss_chat_log_created_at, pss_chat_log.modified_at AS pss_chat_log_modified_at, pss_chat_log.guild_id AS pss_chat_log_guild_id, pss_chat_log.channel_id AS pss_chat_log_channel_id, pss_chat_log.pss_channel_key AS pss_chat_log_pss_channel_key, pss_chat_log.last_pss_message_id AS pss_chat_log_last_pss_message_id, pss_chat_log.name AS pss_chat_log_name 
2022-04-13T12:34:26.808552+00:00 app[worker.1]: FROM pss_chat_log]
2022-04-13T12:34:26.808552+00:00 app[worker.1]: (Background on this error at: https://sqlalche.me/e/14/e3q8)

Add a command to prune PSS players from the database

Reaction Roles: if a user does not meet an RR's requirements, remove the reaction they added

Reaction Role: A message configured to be sent when performing a reaction role doesn't get send.

Add a command to specify promotion/demotion criteria by fleet

Add a command to relate PSS players to Discord users and store that relation

Keep in mind that this is an m:n relation

Add a command to update Discord roles accordingly to in game fleet(s) and rank(s)

Add command to remove a role from multiple users

The `embed` command breaks, if author, image or thumbnail are specified

Add a command to track and print tournament performance for members of a specified fleet

Add command to add a role to multiple users

Add a command to update tournament achievement roles

Refer to Issue #15

1st deploy fails

The bot is trying to access the database, before it's created.

Add a command to define sending a message when someone gets a specific role added/removed

So when someone gets a role added/removed a message will be sent to a specified channel or dm.

Add a command for creating timezone-aware timestamps

Like these: https://hammertime.cyou/en-GB

Ask to activate a newly created or edited Reaction Role

Just a simple: do you want to (re-)activate the Reaction Role now?

Add a command to get all members (not) having one or more specified roles

Something along vivi members [[+|-][role1]]< [[+|-][role2]] ... [[+|-][roleN]]>

• +role: members having that role
• -role: members not having that role

`rr activate all` returns negative reaction role count

Add a way to have a specific fleet chat mirrored into a specific Discord channel

Make it possible to select a fleet.
Don't allow setting up the same channel for multiple fleets.

`vivi rr add` fails right before creating the reaction role

This occurs after having entered all data.

Implement a Welcome Message feature

Make it possible to configure a custom welcome message:

• that is an embed (to define the embed, a JSON definition shall be used)
• that adds one or more reactions for the user to select
• when the user adds a reaction, a custom message will be sent in the same channel

Add a command to define tournament achievement criteria

Special achievements for getting a set amount of stars.
Make it possible to relate these to specific roles.
Make it possible to limit these to specific fleets.

Add a way to mark ships in fleets as alts

Add command to get info about the bot

`vv embed replace` doesn't work in forums

The bot takes any message as input when waiting for user input

Example: User is editing/creating a reaction role and the bot inquires for plain text (e.g.: the name of the RR). Then the bot receives any message, e.g. it posting a chatlog itself. The content of that message will be used, if it meets the check.

When adding a Reaction Role Change check if the role is managed.

And disallow adding/removing a managed role as the bot can't do this.

Role commands fail for unknown users

Print the unknown user ids instead of failing completely.

Add command to create an invite link for the bot

Allow more customization

For example, but not limited to:

• Chat logger interval
• Command prefix (unless Slash commands get implemented)

Add Reaction Roles

A reaction role should be configurable to:

• have requirements (the user needs to have specific roles)
• add or remove roles on reaction
• have toggleable roles (reverses adding/removing roles upon reaction removal)

Add a command to produce a list of fleet members to be promoted/demotes based on set criteria

When having created a reaction role, print note that it has to be activated along with its ID

Add command to give/remove/toggle a role to everyone with one or more specific roles

Like the dyno command ?role in [role] <+|->[role] but better, accepting multiple ids, like:

vivi role in [role]( <role2> ... <roleN>); <+|->[role]( <+|->[role2] ... <+|->[roleN])

1. iteration should just mimic the dyno command.

Or expand vivi role add to also accept role ids/mentions (with pluses and minuses)

Add a command to produce message content and embed definitions from any message

The command takes a message link and returns the message content and embed definition(s) in the format of the LeoLevel Embed Visualizer.

Reaction Role: Configuring the reaction role to send a message or embed doesn't let you skip entering a message

When creating a reaction role and wanting to send an embed message into any channel, trying to skip the normal message doesn't work.
This results in having to type a normal message that you don't actually want showing up, like in the screenshot
if you write "skip", it doesn't skip anything, the dialog to enter a normal message shows up again

Workaround: send an "empty" message, like a formatted blank space (_ _)