[Bug] Main Player missing from 'player' table for raids, inconsistent problem.

christopher-talke commented 1 month ago

I've had a few reports now of people's Main Player missing from the 'player' table, need to implement a sanity check either throughout a raid, or at the very end of the raid to make sure that all "players" are accounted for or the playback system just gets confused, as do timeline matches.

Two things that need to change:

GameSessionEndPatch need to send all RAID_REVIEW.trackingPlayers to the server to be checked against the database in the mod.ts file.
Express Server Position Route need to modify this to send a object structured like this { [key: string] : positions[] }> back to the client instead of positions[][]. Currently I'm doing "guess work" in the web client to determine who matches up with who in the Legend, it's a really stupid and lazy way of doing this.

Attached are database query examples based on data sent to me by a user:

Player Found

Player Not Found

christopher-talke commented 3 weeks ago

Just deployed 0.0.4, will wait a few days to see what the results are...

christopher-talke commented 2 weeks ago

I think we've completely fixed this issue with the recent changes, closing ticket.

ekky-llc / spt-raid-review

[Bug] Main Player missing from 'player' table for raids, inconsistent problem. #25