* Initial SDK and dependency bumps
* Bump Pomelo.EntityFrameworkCore.MySql to 8.0.0-beta.2
Should fix the MissingMethodException error in unit tests
* Update CI workflow to use .NET 8
* Apply suggested change from compile time warnings
* Fix digest tests
* Bump dependencies once more
* Update xunit
* Remove obsolete ISystemClock from TokenAuthHandler
* Update dependencies
* Add digest debug preprocessors back
* Maybe don't break #966
* Bump EF Driver and update various NET7 references
* Fix warnings in digest middleware tests
---------
Co-authored-by: Slendy <josh@slendy.pw>
* Migrate to GitInfo for embedding git information
* Adjust gitignore to reflect new git system
* Fix changes from broken merge
* Remove vestigial code in VersionHelper
---------
Co-authored-by: sudokoko <koko@drones.gay>
* Implement basic RPC information endpoint with test data
* Implement configuration options for RPC
* Rename RpcConfiguration to RpcResponse
* Rider insists on modifying dataSources.xml
* Implement documentation and fix code quality/gitignore issues
* Use SerializableAttribute instead of UsedImplicitlyAttribute
* Add warning regarding nullable assets
* Prevent precision issues with application ID
* Check asset properties for null/whitespace and return null
* Remove most non DI usages of DbContext
* Optimize website queries and refactor startup to use top level statements
* Remove unused functions in UserEntity and SlotEntity
* Optimize LBP1 LevelTags
* Add /api/v1/users/online endpoint
* Fix chaining style
* Return empty list if none online
* Return by ascending login time and limit to 50
* Improve pagination clamping
* Correct login time sort
* Initial implementation of new slot sorting and filtering system
* Initial implementation of filtering for lbp3 community tab
* Add support for organization on lbp3
* Add playlist and user categories
* Implement unit tests for all filters
Refactor more systems to use PaginationData
* Fix PlayerCountFilter test
* Add more unit tests and integration tests for the filter system
* Fix LBP2 move filter and gameFilterType
* Fix sort by likes in LBP3 category
* Add sort for total plays
* Remove extra whitespace and make styling more consistent
* Order hearted and queued levels by primary key ID
* Fix query without order warnings
* Reorganize tests into unit/integration pattern
* Make DbSets virtual so they can be overridden by tests
* Add MessageControllerTests
* Implement DigestMiddlewareTests
* Refactor SMTPHelper to follow DI pattern which allows for mocking in unit tests.
* Fix MailQueueService service registration and shutdown
* Implement tests for Status and StatisticsController and reorganize tests
* Start working on UserControllerTests
* Start refactoring tests to use In-Memory EF provider
* Refactor integration tests to reset the database every time
Change default unit testing database credentials
* Update credentials to use default root with different passwords
* Throw exception when integration db is not available instead of falling back to in-memory
* Evaluate DbConnected every time
* Remove default DbContext constructor
* Setup DbContexts with options builder
* Convert remaining Moq DbContexts to InMemory ones
* Add more tests and use Assert.IsType for testing status code
* Add collection attribute to LighthouseServerTest
* Remove unused directives and calculate digest in tests
* Fix digest calculation in tests
* Add test database call
* Clear rooms after each test
* Fix CommentControllerTests.cs
* Disable test parallelization for gameserver tests
* Fix failing tests
Fix SlotTests
Make CreateUser actually add user to database
Fix dbConnected Lazy and change expected status codes
Properly Remove fragment from url for digest calculation
Fix digest calculation for regular requests
[skip ci] Remove unused directive
Don't use Database CreateUser function
Get rid of userId argument for generating random user
Rewrite logic for generating random users
Fix integration tests
* Implement changes from self-code review
* Fix registration tests
* Replace MailQueueService usages with IMailService
* Convert entities to serializable after aggregating rather before
* Cache instances of CustomXmlSerializer and create readonly constants for reused settings
* Change CustomXmlSerializer and serializer cache to work with deserializer
* Initial work for serialization refactor
* Experiment with new naming conventions
* Mostly implement user and slot serialization.
Still needs to be fine tuned to match original implementation
Many things are left in a broken state like website features/api endpoints/lbp3 categories
* Fix release building
* Migrate scores, reviews, and more to new serialization system.
Many things are still broken but progress is steadily being made
* Fix Api responses and migrate serialization for most types
* Make serialization better and fix bugs
Fix recursive PrepareSerialization when recursive item is set during root item's PrepareSerialization, items, should be properly indexed in order but it's only tested to 1 level of recursion
* Fix review serialization
* Fix user serialization producing malformed SQL query
* Remove DefaultIfEmpty query
* MariaDB doesn't like double nested queries
* Fix LBP1 tag counter
* Implement lbp3 categories and add better deserialization handling
* Implement expression tree caching to speed up reflection and write new serializer tests
* Remove Game column from UserEntity and rename DatabaseContextModelSnapshot.cs back to DatabaseModelSnapshot.cs
* Make UserEntity username not required
* Fix recursive serialization of lists and add relevant unit tests
* Actually commit the migration
* Fix LocationTests to use new deserialization class
* Fix comments not serializing the right author username
* Replace all occurrences of StatusCode with their respective ASP.NET named result
instead of StatusCode(403) everything is now in the form of Forbid()
* Fix SlotBase.ConvertToEntity and LocationTests
* Fix compilation error
* Give Location a default value in GameUserSlot and GameUser
* Reimplement stubbed website functions
* Convert grief reports to new serialization system
* Update DatabaseModelSnapshot and bump dotnet tool version
* Remove unused directives
* Fix broken type reference
* Fix rated comments on website
* Don't include banned users in website comments
* Optimize score submission
* Fix slot id calculating in in-game comment posting
* Move serialization interfaces to types folder and add more documentation
* Allow uploading of versus scores
* Start of reorganization and cleanup
* Remove duplicate title id
* Refactor types
* Fix Release building
* Move classes in /Types to a Types namespace
* Fix compilation error (RoomVisualizerPage strikes again)
* Fix bugs created from auto merge
* Fix auto-merge compilation error
* Changes from review/fix failed merge
* Initial work for verifying login ticket signatures
* Add candidate psn public key
* Add candidate psn public key and fix nuget packages
* Finalize npticket changes
* Add support for ticket version 3.0
* Rework login system to link platform accounts instead of using ip addresses
* Make linked accounts green instead of blue
* Fix api building
* Fix unit tests
* Actually fix unit tests
* Set unit test user's linked platform
* Why was this the wrong default value?
* Fix username change code
* Make TicketHash hash the entire ticket instead of just the serial
* Send password setup email when user sets their email for the first time
* Changes from self review
* NET 7.0 support
* Bump Pomelo MySql to support EF7
* Its net7.0 time
* Trying to resolve dependencies by hand
* Fix .NET 7 warnings
* Bump InfluxDB version
* Fix bad null handling
* Add prefilled username to registration token
* call toString on query to work with EF
* Fix typo in RegisterForm.cshtml
* Only show username notice if the user's username hasn't been chosen already
* Add confirmation message to DeleteUserCommand
* Initial work for rate limiting
* Refactor GameServerStartup and change default rate limit config
* Adjust config naming and add Enabled option to global and override rate limits
* Fix LBP3 republish bug
* Fix bugs in rate limiting and allow for multiple matched overrides
* Add this qualifier for private variable
* Changes from self review
* Baseline LBP3 Adventure slot support
VERY unsafe and hacky to use as of now, this is just testing the waters.
* ADC file type checking
* Refactor & trimming
This might need to be adjusted if any feature is found to be missing
* isAdventure added to API
* Prototype Adventure icons for Website
I am not an artist, please make this more in line with the originals.
* Override border radius for LBP3 Adventures
* Cleaning
* Remove WriteLine and unused property
* Remove unused libraries
* Handle tracking and submitting of Adventure scores
* Check for null instead of 0
Non-adventure slots will report null, not 0
* Score for adventure slot instead of main slot
* Tweaks for PR
* Identify levels for photos by level resource
Verify this doesn't break anything.
* SlotCardPartial merge with main changes
* PR resolution 2
* probably not what was wanted
Use variables for style extension
* Internal slots already properly identified
* Return line breaks to end of Slot.cs
* Remove line break added by Github
thanks
* Github.
* Make this a one-liner
* Reduce to two lines
* This can also be one line
* This can *also* be one line
* Update ProjectLighthouse.Servers.Website/Pages/Partials/SlotCardPartial.cshtml
Co-authored-by: Josh <josh@slendy.pw>
* PR changes
* Update ProjectLighthouse/Migrations/20220916141401_ScoreboardAdvSlot.cs
Co-authored-by: Josh <josh@slendy.pw>
Co-authored-by: Josh <josh@slendy.pw>
* Many bug fixes and performance enhancements
* Fix warnings and speed up photos with me
* Finish refactoring user serialization
* Finish refactoring user serialization
Use GameTokens instead of User when possible
Prevent negative page sizes
* Fix debug compilation
* Add gzip compression to example nginx config
* Remove deflate changes
* Add UsernameFromWebToken
Co-authored-by: Jayden <jvyden@jvyden.xyz>
* Added user invite system
* Added user invite system
* Revert recent migrations and try again
* stopped implicitly assigning token variables
* Added correct context to migrations
* Apply suggestions from code review
Some grammar changes, etc.
Co-authored-by: Jayden <jvyden@jvyden.xyz>
* Updated the API key page
* Removed enabled field from APIKey
* Removed reference to APIKey.Enabled
* Add creation guide text
* Fix this.Forbid() usage
Causes an exception on my machine for some reason, always has.
* Fix more forbid usages
* Return 404 if trying to generate token when private registration is disabled
* Capture authentication schema more cleanly
Co-authored-by: Jayden <jvyden@jvyden.xyz>
* workaround for NETSDK1152 error
gets rid of Found multiple publish output files with the same relative path error
* fixed mixed indents, thanks visual studio