You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
|
2 years ago | |
---|---|---|
demweb | 2 years ago | |
oofsgi | 2 years ago | |
.flaskenv | 2 years ago | |
.gitignore | 2 years ago | |
README.md | 2 years ago | |
WSGI.py | 2 years ago | |
app.py | 2 years ago | |
config.py | 2 years ago | |
db_create.py | 2 years ago | |
demopus.py | 2 years ago | |
done.txt | 2 years ago | |
parser.py | 2 years ago | |
requirements.txt | 2 years ago | |
work.txt | 2 years ago |
README.md
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
);