Go to file
2021-05-23 16:55:57 +02:00
demweb good progress 2021-05-23 16:55:57 +02:00
oofsgi initial commit 2021-05-16 16:31:31 +02:00
.flaskenv initial commit 2021-05-16 16:31:31 +02:00
.gitignore initial commit 2021-05-16 16:31:31 +02:00
app.py progress 2021-05-20 00:31:31 +02:00
config.py initial commit 2021-05-16 16:31:31 +02:00
db_create.py initial commit 2021-05-16 16:31:31 +02:00
demopus.py progress 2021-05-20 00:31:31 +02:00
done.txt initial commit 2021-05-16 16:31:31 +02:00
parser.py good progress 2021-05-23 16:55:57 +02:00
README.md good progress 2021-05-23 16:55:57 +02:00
requirements.txt good progress 2021-05-23 16:55:57 +02:00
work.txt initial commit 2021-05-16 16:31:31 +02:00
WSGI.py initial commit 2021-05-16 16:31:31 +02:00

Populate player name (from most used one) after database is fully populated:

UPDATE `player` SET `name`=(
    SELECT `name`
    FROM `player_names`
    WHERE `player_names`.guid = `player`.guid
    GROUP BY guid, name
    ORDER BY MAX(`time`) DESC LIMIT 1
);