writer-bot/bot

bot's Issues

Errors running project command

[2023-01-20 21:12:35][INFO] user 816262064712187935 called project in server 841447639798251520
{"options":[{"name":"view","type":1,"options":[{"name":"shortcode","type":3,"value":"sea"}]}],"uuid":"4e8e8031-c01e-4cb3-91fb-a47cdc854201"}

{"uuid":"4e8e8031-c01e-4cb3-91fb-a47cdc854201","stack":"TypeError: Cannot read properties of null (reading 'length')\n    at Helper.truncate (/app/src/classes/helper.js:139:23)\n    at Project.embed (/app/src/classes/project.js:153:37)\n    at Project.command_view (/app/src/classes/project.js:345:31)\n    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)\n    at async Object.execute (/app/src/commands/writing/project.js:266:20)\n    at async Client.<anonymous> (/app/src/bot.js:59:9)"}
[2023-01-20 21:12:41][ERROR] Error running command: project

[Command/Utils] Help

Implement the help command.

I'm thinking this should just link to the wiki, rather than duplicating information that then needs updating in 2 places.

[Command/Fun] 8Ball

Implement the 8ball command.

Add command: define

This lets you look up words definitions and thesaurus entries.

[Command/Writing] Sprint

Implement the sprint command.

Notify a role when a sprint starts

Add a command for server admins to add a role that gets notified.
/sprint notify-role role

[Backend] CI Tools

Investigate if I can move from Buddy to Github Actions to build and deploy.

Daily goal XP being granted multiple times

hello, Writer bot keep giving me daily goal xp for 3 sprints in a row whenever I hit my daily goal in the sprints

first sprint
https://cdn.discordapp.com/attachments/727089984661618751/1067489796966060072/image.png
second sprint:
https://cdn.discordapp.com/attachments/727089984661618751/1067489940176375913/image.png
third sprint:
https://cdn.discordapp.com/attachments/727089984661618751/1067490122599239790/image.png

sprint not honouring sprint delay setting

my sprinters also noticed the bot isnt recognizing the fact the server settings show sprint delay is set for 10 minutes, but when a sprint ends it only gives them 2 minutes to input their wordcounts.

[Command/Fun] Roll

Implement the roll command.

Writer Bot Missing Commands

Hello,

Writer bot went offline for a bit yesterday and has been buggy since. One person started a sprint and the time period was set for 15 minutes, but more than 15 minutes passed and writer-bot didn't stop the sprint. When pinged about the current sprint, writer bot claimed there was no sprint in effect.

No one else used it at that point and roughly 10 hours later, writer bot announced the end of the sprint and pinged the user for their word count update.

Today, a sprint was started, but when the user tried to join it with a wordcount, the option to join with a wordcount was no longer listed.

How do we fix this?

Thank you

sprint join same not using old project

also that /sprint join same isn't copying across project data, so that's having to be added manually every time

https://cdn.discordapp.com/attachments/727089984661618751/1065365903488860220/Screenshot_2023-01-18_at_20.23.23.png

/sprint project not working for some users

Might be a project-related issue. Or might be only works for sprint maker. not sure,.

https://discord.com/channels/503593039541960704/727089984661618751/1077954336983887933

Make sprint status work for non-sprinters

Should just show the time left

[Command/Utils] Mysetting

Implement the mysetting command, to allow users to alter their own settings, such as:

• Timezone
• Max WPM

Goal history wrong

Goal history repeating with blank values.,

https://discord.com/channels/503593039541960704/503593833850994698/1076093262756053103

[Command/Writing] Goal

Implement the goal command, allowing users to set daily, weekly, monthly, yearly goals, and check them. Plus update towards their goal when they write things in any of the other commands.

project list with status leads to error

{"options":[{"name":"list","type":1,"options":[{"name":"status","type":3,"value":"progress"}]}],"uuid":"e6c74167-20de-473a-88f6-4def401a8416"}

[2023-01-18 19:11:33][ERROR] Error running command: project
{"uuid":"e6c74167-20de-473a-88f6-4def401a8416","stack":"TypeError [CommandInteractionOptionType]: Option \"status\" is of type: 3; expected 5.\n    at CommandInteractionOptionResolver._getTypedOption (/app/node_modules/discord.js/src/structures/CommandInteractionOptionResolver.js:99:13)\n    at CommandInteractionOptionResolver.getBoolean (/app/node_modules/discord.js/src/structures/CommandInteractionOptionResolver.js:137:25)\n    at Object.execute (/app/src/commands/writing/project.js:265:48)\n    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)\n    at async Client.<anonymous> (/app/src/bot.js:59:9)"}

[Command/Writing] Project

Implement the project command, to let users add/edit/delete projects, as well as the options to add to project word counts with other commands, such as wrote and sprint

Meeting goal not giving xp or maybe just the message

Words written in a sprint didn't count toward my daily goal, neither did words that I added directly using /wrote. I had to manually use goal update.

https://cdn.discordapp.com/attachments/727089984661618751/1065544737366474782/Screen_Shot_2023-01-19_at_12.13.22_AM.png
https://cdn.discordapp.com/attachments/727089984661618751/1065544737685250058/Screen_Shot_2023-01-19_at_12.13.40_AM.png

[Command/Fun] Flip

Implement the coin flip command.

How to extend beyond 2 min update

I cannot seem to update the 2 minute time limit for the end of the sprint… how do I fix

[Backend] Logging

Implement a logging system, to log commands which are run, who ran it, which server it was in, plus any errors.

Goals not resetting at correct time

[Backend] General

• Investigate how to make docker containers restart if they crash.
• Investigate if discord js clusters will restart on failure

[Command/Writing] Generate

Implement the generate command, allowing users to generate various things.

[Future] Events

Re-implement event command

should goals be showing reset time and stuff that they used to?

just spotted in the test channel that the goals should still have a countdown, so reporting that here that it doesn't for me

I can't remember if there was a reason it was left out.

[Backend] Cron tasks

Implement scheduled tasks on a cron, to do things like send sprint messages, goal resets, etc...

Info stats wrong?

Active sprints is always around the same number and is way too high. Must be wrong.

Also change all long numbers to localestings.

[Command/Fun] Reassure

Implement the reassure command.

[Command/Utils] Info

Implement the info command with server stats.

Error running sprint wc

[2023-01-20 04:56:53][INFO] user 343564229669945356 called sprint in server 1055897168889774200
{"options":[{"name":"wc","type":1,"options":[{"name":"amount","type":4,"value":5517}]}],"uuid":"ecbcc59f-d170-4593-bb3f-053883f9561a"}

{"uuid":"ecbcc59f-d170-4593-bb3f-053883f9561a","stack":"TypeError: Cannot create property 'current_wc' on boolean 'false'\n    at Sprint.updateUser (/app/src/classes/sprint.js:554:31)\n    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)\n    at async Sprint.setUserWordCount (/app/src/classes/sprint.js:624:13)\n    at async Object.execute (/app/src/commands/writing/sprint.js:203:20)\n    at async Client.<anonymous> (/app/src/bot.js:59:9)"}

Looks like sprint_user record is somehow missing or empty?

Make other project commands have the visible option like project view

project list
possibly project update?

[Command/Utils] Export

A command to let the user export all their data from writer bot, in the following formats:

• text
• json
• sql (maybe)

This will be for mostly when users want to migrate their data into their own instance of writer-bot.

XP for setting project to finished isn';t appliued

Forgot to add that back in

[Command/Utils] Reset

Implement the reset command to allow the user to reset certain aspects of their profile data.

Change project default to public instead of private

[Command/Utils] Setting

Implement the server setting command, to allow server owners/mods to:

• Enable/Disable certain commands
• Set the sprint delay setting

Refactor DB connection code

• Remove db connection from bot.js
• Only connect to database within commands which need it, and then close connection when finished
• Make sure on error we still close connections

DB cleanup script

Write a script to clean up some old data in the database we don't need any more, for example old sprint_users records.

Also explore if there's a way to reduce the size of the goals history table, as it is by far the largest.

SQL error running sprint status

[2023-01-20 06:54:58][INFO] user 765126981872123916 called sprint in server 1035641333089574973
{"options":[{"name":"status","type":1,"options":[]}],"uuid":"fed3a706-6071-4f39-be49-c034a828743e"}

{"uuid":"fed3a706-6071-4f39-be49-c034a828743e","stack":"SqlError: Parameter at position 1 is undefined\nSELECT * FROM projects WHERE id = ? - parameters:[undefined]\nsql: SELECT * FROM projects WHERE id = ? - parameters:[undefined]\n    at module.exports.createError (/app/node_modules/mariadb/lib/misc/errors.js:57:10)\n    at Query.throwUnexpectedError (/app/node_modules/mariadb/lib/cmd/command.js:40:24)\n    at Query.throwNewError (/app/node_modules/mariadb/lib/cmd/command.js:70:22)\n    at Query.validateParameters (/app/node_modules/mariadb/lib/cmd/query.js:176:14)\n    at Query.start (/app/node_modules/mariadb/lib/cmd/query.js:54:17)\n    at Connection.addCommandEnablePipeline (/app/node_modules/mariadb/lib/connection.js:1055:11)\n    at Connection.query (/app/node_modules/mariadb/lib/connection.js:1289:10)\n    at new Promise (<anonymous>)\n    at ConnectionPromise.query (/app/node_modules/mariadb/lib/connection-promise.js:87:12)\n    at DB._build_get (/app/src/classes/database.js:71:38)"}

Looks like its assuming a project exists for the sprint_user where there isn't one.

Check sprint points

• non-wc sprinters should all get same points, apparently not happening atm

"it's the same if there's only non-wc sprinters"

[Docs] Wiki

Create wiki in this project and update with correct information.

Look into issues with pool connections being unavailable

Seems that on any kind of error the connection doesn't get ended properly.

Also need to look into re-doing how the db connections are done, so as not to open on every command, only open when needed. But split that into another issue.

[Command/Writing] Challenge

Implement the challenge command, allowing users to set writing challenges which they can try to meet.

[Command/Writing] Wrote

Implement the wrote command, to let users add words written.

[Command/Utils] Profile

Implement the profile command to show the user's xp and other stats.

Fix nightly backup not running

Can Writer-Bot Tell You How Much Time Is Left On A Sprint?

Sorry, I couldn't find an answer on the wiki.

Is there a command that can find out how much time is left on a sprint once it's started?