From 42bfe1195b453feec3018b15f8a99b5f2f9f4339 Mon Sep 17 00:00:00 2001 From: emkael Date: Thu, 7 Sep 2017 14:44:00 +0200 Subject: Connecting players' ranks and clubs with specific ranking edition --- scripts/pyranking/fetch.py | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'scripts') diff --git a/scripts/pyranking/fetch.py b/scripts/pyranking/fetch.py index 0d301d4..304f509 100644 --- a/scripts/pyranking/fetch.py +++ b/scripts/pyranking/fetch.py @@ -5,8 +5,8 @@ def fetch_ranking(date, assoc=False): rankings.place, rankings.pid, CONCAT(players.name, " ", players.surname) player, - players.rank, - rankings.region, players.club, + rankings.rank, + rankings.region, rankings.club, REPLACE(rankings.flags, "K", "") age, IF(rankings.flags LIKE 'K%', "K", "") gender, rankings.score -- cgit v1.2.3