From 9917ceba63481a389d1b636bb95b443a5d475403 Mon Sep 17 00:00:00 2001
From: emkael <emkael@tlen.pl>
Date: Sat, 9 Nov 2019 12:21:59 +0100
Subject: Fetching rankings from database according to baza2.csv format

---
 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 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
-- 
cgit v1.2.3