Changes the way in-game bug reports are stored and handled
What Does This PR Do
- Global bug report list no longer exists and bug reports only exist for as long as they are being looked at.
- SSbugreports has been removed since syncing is no longer needed
- The DB is now queried every time bug reports need to be viewed
- Bug report table primary key is now row index
- Adds a new "submitted" field which is 0 for unhandled bug reports, 1 for submitted ones and 2 for rejected ones.
- Bug reports now open as read only if already accessed by someone else
- Bug report creation now notifies devs as well as admins with a boxed message and a sound fixes #30910 if it hasn't been fixed already.
Why It's Good For The Game
Removes the need to sync between the live round and the DB which should hopefully eliminate the issues stemming from it, and simplify the system overall.
Images of changes
Testing
- Created a bug report
- Viewed a bug report
- Rejected a bug report
- Approved a bug report
Declaration
- [x] I confirm that I either do not require pre-approval for this PR, or I have obtained such approval and have included a screenshot to demonstrate this below.
Changelog
:cl: tweak: Bug report creation now notifies both admins and devs with a boxed chat message and a sound tweak: Bug reports open as read only if already being accessed by someone else. /:cl:
Does this fix #30910?
Does this fix #30910?
This should already be fixed. But if it isn't this would fix it. I'll give it a mention anyhow.
This pull request seems to be stale as there have been no changes in 14 days, please make changes within 7 days or the PR will be closed. If you believe this is a mistake, please inform a development team member on Discord.
Made some changes to the DB stuff to prevent conflicts. I did some testing and it worked fine but I'm not entirely confident yet