| demweb | ||
| oofsgi | ||
| .flaskenv | ||
| .gitignore | ||
| app.py | ||
| config.py | ||
| db_create.py | ||
| demopus.py | ||
| done.txt | ||
| parser.py | ||
| README.md | ||
| requirements.txt | ||
| work.txt | ||
| WSGI.py | ||
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
);