Build the balance view - Githubissues

SGA-A commented 9 months ago

Quite a lot of changes going on recently. Here's what's changed in this PR (more to come):

A new view has been added onto the balance command so that you can directly withdraw/deposit your ingame currency, without having to call the command again. This was mostly an idea taken from Dank Memer (props to them as always)
The way commits are being made has been changed (this is a backend feature). Because the bot has become so big, data is needed from different tables, fields etc. This means multiple sql queries to update or insert data needs to be made all at once. So, instead of commiting these changes one by one, a single commit is now made after all changes have been applied. This should hopefully reduce some performance issues and also some data corruption that has been detected lately.
Some other commands' backend design have also been redesigned for performance improvements.

Took over 4 hours to make these changes, tested thoroughly as per-standards.

SGA-A commented 9 months ago

@serephenna, if you could review the changes, thanks.

SGA-A commented 9 months ago

Working on a fix. Will also work on some command optimization changes as I go.

SGA-A / c2c