Commit graph

29 commits

Author SHA1 Message Date
sudokoko
262ada37ae
Bump dependencies 2024-05-31 13:53:41 -04:00
dependabot[bot]
e1cc214f44
Bump dotnet-ef from 7.0.13 to 8.0.3 (#997)
Bumps [dotnet-ef](https://github.com/dotnet/efcore) from 7.0.13 to 8.0.3.
- [Release notes](https://github.com/dotnet/efcore/releases)
- [Commits](https://github.com/dotnet/efcore/compare/v7.0.13...v8.0.3)

---
updated-dependencies:
- dependency-name: dotnet-ef
  dependency-type: direct:production
  update-type: version-update:semver-major
...

Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>
2024-03-27 22:13:11 -04:00
dependabot[bot]
7382c7cea9
Bump dotnet-trace from 7.0.447801 to 8.0.452401 (#933)
Bumps [dotnet-trace](https://github.com/dotnet/diagnostics) from 7.0.447801 to 8.0.452401.
- [Release notes](https://github.com/dotnet/diagnostics/releases)
- [Commits](https://github.com/dotnet/diagnostics/compare/v7.0.447801...v8.0.452401)

---
updated-dependencies:
- dependency-name: dotnet-trace
  dependency-type: direct:production
  update-type: version-update:semver-major
...

Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>
2023-10-31 10:59:12 +00:00
dependabot[bot]
d2fb464c55
Bump dotnet-ef from 7.0.11 to 7.0.13 (#929)
Bumps [dotnet-ef](https://github.com/dotnet/efcore) from 7.0.11 to 7.0.13.
- [Release notes](https://github.com/dotnet/efcore/releases)
- [Commits](https://github.com/dotnet/efcore/compare/v7.0.11...v7.0.13)

---
updated-dependencies:
- dependency-name: dotnet-ef
  dependency-type: direct:production
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>
2023-10-25 13:25:54 +00:00
dependabot[bot]
c314e8d340
Bump dotnet-trace from 7.0.442301 to 7.0.447801 (#910)
Bumps [dotnet-trace](https://github.com/dotnet/diagnostics) from 7.0.442301 to 7.0.447801.
- [Release notes](https://github.com/dotnet/diagnostics/releases)
- [Commits](https://github.com/dotnet/diagnostics/compare/v7.0.442301...v7.0.447801)

---
updated-dependencies:
- dependency-name: dotnet-trace
  dependency-type: direct:production
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>
2023-10-03 22:46:39 +00:00
dependabot[bot]
3c945859c0
Bump dotnet-ef from 7.0.10 to 7.0.11 (#896)
Bumps [dotnet-ef](https://github.com/dotnet/efcore) from 7.0.10 to 7.0.11.
- [Release notes](https://github.com/dotnet/efcore/releases)
- [Commits](https://github.com/dotnet/efcore/compare/v7.0.10...v7.0.11)

---
updated-dependencies:
- dependency-name: dotnet-ef
  dependency-type: direct:production
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>
2023-09-17 00:40:31 +00:00
dependabot[bot]
bdaee323af
Bump dotnet-trace from 7.0.430602 to 7.0.442301 (#885)
Bumps [dotnet-trace](https://github.com/dotnet/diagnostics) from 7.0.430602 to 7.0.442301.
- [Release notes](https://github.com/dotnet/diagnostics/releases)
- [Commits](https://github.com/dotnet/diagnostics/compare/v7.0.430602...v7.0.442301)

---
updated-dependencies:
- dependency-name: dotnet-trace
  dependency-type: direct:production
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>
2023-08-29 17:37:35 +00:00
dependabot[bot]
87a5855db6
Bump dotnet-ef from 7.0.9 to 7.0.10 (#857)
Bumps [dotnet-ef](https://github.com/dotnet/efcore) from 7.0.9 to 7.0.10.
- [Release notes](https://github.com/dotnet/efcore/releases)
- [Commits](https://github.com/dotnet/efcore/compare/v7.0.9...v7.0.10)

---
updated-dependencies:
- dependency-name: dotnet-ef
  dependency-type: direct:production
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>
2023-08-12 21:33:18 +00:00
Slendy
282fd4e073
Bump dependencies and fix digest unit tests 2023-07-14 16:41:15 -05:00
dependabot[bot]
a7545d9b3e
Bump dotnet-ef from 7.0.7 to 7.0.8 (#813)
Bumps [dotnet-ef](https://github.com/dotnet/efcore) from 7.0.7 to 7.0.8.
- [Release notes](https://github.com/dotnet/efcore/releases)
- [Commits](https://github.com/dotnet/efcore/compare/v7.0.7...v7.0.8)

---
updated-dependencies:
- dependency-name: dotnet-ef
  dependency-type: direct:production
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>
2023-06-26 23:51:33 +00:00
dependabot[bot]
1c3869cf00
Bump dotnet-ef from 7.0.5 to 7.0.7 (#798)
Bumps [dotnet-ef](https://github.com/dotnet/efcore) from 7.0.5 to 7.0.7.
- [Release notes](https://github.com/dotnet/efcore/releases)
- [Commits](https://github.com/dotnet/efcore/compare/v7.0.5...v7.0.7)

---
updated-dependencies:
- dependency-name: dotnet-ef
  dependency-type: direct:production
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>
2023-06-17 02:19:21 +00:00
dependabot[bot]
dc3a9a75b1
Bump dotnet-trace from 7.0.421201 to 7.0.430602 (#788)
Bumps [dotnet-trace](https://github.com/dotnet/diagnostics) from 7.0.421201 to 7.0.430602.
- [Release notes](https://github.com/dotnet/diagnostics/releases)
- [Commits](https://github.com/dotnet/diagnostics/compare/v7.0.421201...v7.0.430602)

---
updated-dependencies:
- dependency-name: dotnet-trace
  dependency-type: direct:production
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>
2023-06-09 17:03:09 +00:00
dependabot[bot]
8c19634e09
Bump dotnet-trace from 6.0.351802 to 7.0.421201 (#749)
Bumps [dotnet-trace](https://github.com/dotnet/diagnostics) from 6.0.351802 to 7.0.421201.
- [Release notes](https://github.com/dotnet/diagnostics/releases)
- [Commits](https://github.com/dotnet/diagnostics/compare/v6.0.351802...v7.0.421201)

---
updated-dependencies:
- dependency-name: dotnet-trace
  dependency-type: direct:production
  update-type: version-update:semver-major
...

Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>
2023-04-25 16:26:13 +00:00
dependabot[bot]
b46959762c
Bump dotnet-ef from 7.0.4 to 7.0.5 (#748)
Bumps [dotnet-ef](https://github.com/dotnet/efcore) from 7.0.4 to 7.0.5.
- [Release notes](https://github.com/dotnet/efcore/releases)
- [Commits](https://github.com/dotnet/efcore/compare/v7.0.4...v7.0.5)

---
updated-dependencies:
- dependency-name: dotnet-ef
  dependency-type: direct:production
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>
2023-04-25 16:24:37 +00:00
Josh
329ab66043
Refactor serialization system (#702)
* 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
2023-03-28 00:39:54 +00:00
Josh
35ea2682b9
Replace Location table with packed 64-bit int (#679)
* Replace Location table with packed 64 bit int

* Remove double Include and fix Slot documentation

* Fix compilation errors from merge

* Fix namespaces and add expected values to unit tests
2023-02-21 14:53:38 -06:00
Josh
4559d26a54
Fix bug where users can't be deleted (#648)
* Add username to mod cases if user is deleted

* Add timezone package to docker container

* Remove extra space in migration sql statement

* Changes from self-review
2023-01-29 22:10:36 -06:00
Josh
19ea44e0e2
Rework login and registration systems (#600)
* 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
2022-12-26 01:03:14 -08:00
Josh
d16132f67f
NET 7.0 support (#581)
* 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
2022-12-13 18:17:28 -06:00
Josh
14d2f0305e
Implement 2FA (#577)
* Initial work for TOTP 2FA

* Fix bug in 2FA code script

* Add translations for two factor and /disable2fa

* Fix compilation error

* Add TwoFactorLoginPage

* Add two factor login process

* Little bit of backup code work

* Finish two factor

* Fix unit tests

* ??? goofy ahh code

* Use SHA-256 instead of SHA-512

* I guess SHA-256 doesn't work either

* Fix comments in Base32 helper

* Move QRCoder package to website

* Add name to endregion comment in css

* Fix bug with redirects
2022-12-12 21:11:39 -06:00
Slendy
63c9a75c31
Update EntityFramework and ASP.NET to 6.0.9 2022-09-17 14:37:47 -05:00
jvyden
c023d40dfb
Update dotnet-ef to 6.0.8 2022-08-12 14:12:31 -04:00
jvyden
4ba75f09a9
Make all tokens expire
Closes #335
2022-07-29 15:08:41 -04:00
jvyden
eb21c7042f
Only allow a single approved IP address 2022-06-11 18:43:30 -04:00
jvyden
e8a10245c8
Update dotnet-ef tools command to 6.0.5 2022-05-22 15:22:55 -04:00
jvyden
9f6517dbe5
[skip ci] Update dotnet-ef tool to 6.0.4 2022-04-13 15:36:37 -04:00
jvyden
9d46110b7c
Add defaults to nullable strings in User 2021-11-15 00:14:35 -05:00
jvyden
aeb3ba12f0
Update dotnet-ef tool to 5.0.12 2021-11-07 20:55:36 -05:00
jvyden
ccaebbf9fc
Add EntityFramework code first database migrations 2021-10-18 22:35:23 -04:00