leaderboard times

[Die4Ever]

show in the credits? ask the server for the leaderboard for the current seed and flagshash, and also for the flagshash with any seed? this helps prepare for monthly seeds #290

maybe also track leaderboards for number of deaths, number of loads, and number of saves?

data to store:

playthrough_id, player_name, version, seed, flagshash, difficulty (some can also read it from the other tables)
bools for isMonthly? Max Rando? Chosen seed vs random seed? (the GUI can remember which seed it generated)
in-game time, complete in-game time, menu time, complete menu time (all broken down by mission?)
deaths, loads, saves (also broken down by mission? deaths could be queried with a join, except deaths while offline)
bingo progress? which ending, and carriedItem?

maybe just use sql columns like:

playthrough_id, keyname, mission, value

so you could do keyname for menutime, value would be the timer, and have it for each mission, although a playthrough can have multiple completions so maybe need an autoincrement id too

currently (2023-02-13) we have:

select id, map, created, version, ip, seed, flagshash, modname, firstword, playthrough_id, message from logs where firstword is not null order by id desc limit 1;
| id     | map               | created             | version       | ip            | seed   | flagshash  | modname       | firstword     | playthrough_id | message
| 489831 | 12_Vandenberg_Cmd | 2023-02-13 12:36:44 | v2.2.5.2 Beta | 66.219.235.28 | 955328 | 2033105280 | VMDRandomizer | PreFirstEntry |      170195277 |

INFO: 12_Vandenberg_Cmd.DXRando7: RandoEnter() firstTime: True, IsTravel: True, seed: 955328 12_VANDENBERG_CMD
INFO: 12_Vandenberg_Cmd.DXRando7: randomizing 12_VANDENBERG_CMD using seed 955328
INFO: 12_Vandenberg_Cmd.DXRFlags6: PreFirstEntry 12_VANDENBERG_CMD VMDRandomizer.DXRFlags - version: v2.2.5.2 Beta, flagshash: 2033105280, seed: 955328, maxrando: 0, autosave: 0, crowdcontrol: 0, loadout: 0, newgameplus_loops: 0, playthrough_id: 170195277, gamemode: 0, difficulty: 2, minskill: 50, maxskill: 300, ammo: 70, multitools: 70
INFO: 12_Vandenberg_Cmd.DXRFlags6: lockpicks: 70, biocells: 70, speedlevel: 1, keys: 4, keys_containers: 0, doorspickable: 50, doorsdestructible: 50, deviceshackable: 100, passwordsrandomized: 100, medkits: 70, enemiesrandomized: 30, hiddenenemiesrandomized: 30, enemiesshuffled: 100, infodevices: 100, infodevices_containers: 0, dancingpercent: 25
INFO: 12_Vandenberg_Cmd.DXRFlags6: doorsmode: 259, enemyrespawn: 0, skills_disable_downgrades: 0, skills_reroll_missions: 5, skills_independent_levels: 0, startinglocations: 100, goals: 100, equipment: 2, medbots: 25, repairbots: 25, medbotuses: 5, repairbotuses: 5, medbotcooldowns: 1, repairbotcooldowns: 1, medbotamount: 1, repairbotamount: 1
INFO: 12_Vandenberg_Cmd.DXRFlags6: turrets_move: 50, turrets_add: 70, merchants: 30, banned_skills: 5, banned_skill_level: 5, enemies_nonhumans: 60, bot_weapons: 0, bot_stats: 0, swapitems: 100, swapcontainers: 100, augcans: 100, aug_value_rando: 100, skill_value_rando: 100, min_weapon_dmg: 50, max_weapon_dmg: 150, min_weapon_shottime: 50
INFO: 12_Vandenberg_Cmd.DXRFlags6: PreFirstEntry 12_VANDENBERG_CMD max_weapon_shottime: 150, prison_pocket: 0, bingo_win: 0, bingo_freespaces: 1, spoilers: 1
INFO: 12_Vandenberg_Cmd.DXRMissions5: Moving Backup Power Keypad to Outdoor Power Generator (12_VANDENBERG_CMD -2371.028564,-96.179214,-2070.390625)
INFO: 12_Vandenberg_Cmd.DXRMissions5: Moving Backup Power Keypad to Near Pipes (12_VANDENBERG_CMD -288.769806,1103.257813,-1984.334717)

select * from deaths order by log_id desc limit 1;
+--------+---------+---------+--------------+------------+----------+----------+--------+------+
| log_id | name    | killer  | killerclass  | damagetype | x        | y        | z      | id   |
+--------+---------+---------+--------------+------------+----------+----------+--------+------+
| 489819 | jesus11 | jesus11 | JCDentonMale | exploded   | -1822.81 | -113.169 | -219.2 | 7592 |
+--------+---------+---------+--------------+------------+----------+----------+--------+------+

select * from logs where id=489819;
+------------------+---------------------+----------+----------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------+------------+--------+---------+-----------+----------------+
| map              | created             | version  | ip             | message                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       | seed   | flagshash  | id     | modname | firstword | playthrough_id |
+------------------+---------------------+----------+----------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------+------------+--------+---------+-----------+----------------+
| 15_Area51_bunker | 2023-02-12 03:48:11 | v2.2.4.5 | 203.217.93.123 | EVENT: 15_Area51_bunker.JCDentonMale10: {"type":"DEATH","victim":"jesus11","victimBindName":"JCDenton","victimRandomizedName":"","killerclass":"JCDentonMale","killer":"jesus11","killerRandomizedName":"","dmgtype":"exploded","PlayerName":"jesus11","map":"15_AREA51_BUNKER","mapname":"Area 51 - Bunker","mission":"15","TrueNorth":"0","PlayerIsFemale":"False","GameMode":"Normal Randomizer","newgameplus_loops":"0","loadout":"All Items Allowed","location":"-1822.809814,-113.168938,-219.199997"}
 | 713664 | 1801441664 | 489819 | DeusEx  | NULL      |      630850919 |
+------------------+---------------------+----------+----------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------+------------+--------+---------+-----------+----------------+

[Die4Ever]

maybe loadouts should add to the score?

[Die4Ever]

https://github.com/Die4Ever/deus-ex-randomizer-telemetry/commit/c3bc22dbac529d76aafd3abcf8ed9eef4d5edcf2

https://github.com/Die4Ever/deus-ex-randomizer-telemetry/commit/458b7adf235d9aa1684ec59997399ac95c6bf512

https://github.com/Die4Ever/deus-ex-randomizer-telemetry/commit/79bb39f71ffc4cb87bbeeb4fcd5e41ca51b5fe1b

https://github.com/Die4Ever/deus-ex-randomizer-telemetry/commit/42dfa526d9699e378b5583b2f9260766d9bc1a0a

https://github.com/Die4Ever/deus-ex-randomizer-telemetry/commit/553a1f75a8c94b9d512ef80a4f9face525e9668e

https://github.com/Die4Ever/deus-ex-randomizer/commit/c428ef57f97c28add82d7e139f8543a6749b239a