diff options
| author | emkael <emkael@tlen.pl> | 2019-11-09 12:21:59 +0100 |
|---|---|---|
| committer | emkael <emkael@tlen.pl> | 2019-11-09 12:22:29 +0100 |
| commit | 9917ceba63481a389d1b636bb95b443a5d475403 (patch) | |
| tree | 8c30060063c2aae0f5520000efc87138284fdd23 | |
| parent | e401b88b24e25598dc488e080f4bf2200b45efdd (diff) | |
Fetching rankings from database according to baza2.csv format
| -rw-r--r-- | scripts/pyranking/fetch.py | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/scripts/pyranking/fetch.py b/scripts/pyranking/fetch.py index 67ab5a6..b157280 100644 --- a/scripts/pyranking/fetch.py +++ b/scripts/pyranking/fetch.py @@ -7,8 +7,8 @@ def fetch_ranking(date, assoc=False): CONCAT(players.name, " ", players.surname) player, rankings.rank, rankings.region, rankings.club, - REPLACE(rankings.flags, "K", "") age, - IF(rankings.flags LIKE 'K%', "K", "") gender, + rankings.flags age, + rankings.gender, rankings.score, rankings.hidden FROM rankings |