Version 3.31.0 adds a few minor enhancements, resolves some bugs, contains some app infrastructure upgrades, and (for now) ends GB support for Microsoft SQL Server as its database.

New features

• A new user role permission has been added that allows the deletion of games with one or more registered players (resolves Deleting Card with Enrolled Players Yields 500 #281).
  • Deletion of these games was previously unsupported (and threw an error if you tried)
  • Deletion of any game now requires a confirmation. If the game has attached players, their count will be listed to before deletion is confirmed.
  • This permission has been granted to Admins and Directors.

Enhancements

• The "Search Practice Challenges" textbox now uses slightly fuzzier search logic to allow for non-sequential text matches (resolves Practice Area Search Enhancements #503)
• Game cards for unpublished games in the Home tab now show an icon to elevated users to indicate their publishing status (resolves Visual bug - clarify hidden games in the general user area #527)
• Mousing over a game's info bubble in Admin now shows its number of registered players/teams.
• The Observe tab in Game Center has been lightly redesigned to clarify its toggle between challenge and team grouping (resolves Clarify observe mode toggle #585)

Bug fixes

• Fixed a few filtering bugs on Game Center -> Practice (resolves Updates to Game Center -> Practice #586)
• Fixed a bug that made the "view this player's practice session" button in Admin -> Live fail to correctly link to the game's practice tab
• Fixed an issue that caused layout bugs in the Ticket Details screen if an extremely wide screenshot was added.
• Fixed an issue that caused the feedback form to fail to show in practice on first page load of a new challenge.

Infrastructure and App Health

• Gameboard now uses Serilog as its logging provider (resolves Standardize log output format #152).
  • This provides enhanced log control and flexibility and prepares us for a much healthier logging subsystem going forward.'
  • New appsettings.conf settings have been added which allow configuration of the default minimum log level and per-namespace configuration of the info, warning, error, and fatal log levels.
  • By default, Gameboard uses the Console Serilog sink (which can be ingested by many logging providers directly). There are also new appsettings.conf options which support a URL and API key for a Seq instance if desired.
• BREAKING: Microsoft SQL Server has been disabled as a provider for Gameboard's database.
  • In practice, we don't have anyone using a non-Postgres database, and maintaining two sets of migrations has been impractical for large schema changes
  • While we have no current plans to support it in the future, we may opt to reintroduce support at a later date for new installations.