Fix DB script to account for ignoring times from specific users (banned users?)

p2sr / portal2-cm-boards-v2

A from-scratch rewrite of the Portal 2 Challenge mode Leaderboards using Rust (actix.rs) and JS (React).

https://danielbatesj.github.io/Portal2-Boards-Rust-API-Docs/docs/target/doc/doc/server/index.html

Apache License 2.0

3 stars 6 forks source link

Fix DB script to account for ignoring times from specific users (banned users?) #7

Closed DanielBatesJ closed 2 years ago

DanielBatesJ commented 3 years ago

There are a few issues I fixed manually when scripting through the db. I would want to eliminate these somehow, either hardcode them out in the script, or figure out a way to handle three way ties on the same timestamp.

DanielBatesJ commented 3 years ago

This issue is resolved, however we ran into a few issues with duplicate scores in the DB, this needs to be checked in the future so leaving this issue open for now.

DanielBatesJ commented 2 years ago

This should now be focused on trying to synchronize more users, especially with auto-submit desync. From early asking, it seems like just extending the threshold for times being close enough to around 5~ minutes.