From 6f9756cf49e2e2802916ef251732a9377ddd756b Mon Sep 17 00:00:00 2001 From: emkael Date: Fri, 24 Aug 2018 12:53:41 +0200 Subject: Alowingg players to not be displayed by name in the rankings --- bin/rankings-csv-import.sh | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'bin/rankings-csv-import.sh') diff --git a/bin/rankings-csv-import.sh b/bin/rankings-csv-import.sh index 90ce6bc..54ce6bc 100755 --- a/bin/rankings-csv-import.sh +++ b/bin/rankings-csv-import.sh @@ -7,10 +7,11 @@ REPLACE INTO TABLE temp_rankings FIELDS TERMINATED BY ','; INSERT INTO rankings ( - SELECT pid, \`date\`, place, score, region, flags, rank, club + SELECT pid, \`date\`, place, score, region, flags, rank, club, 0 FROM temp_rankings JOIN players ON players.id = temp_rankings.pid ); +UPDATE rankings SET hidden = 1 WHERE pid IN (SELECT pid FROM hidden_players); SET foreign_key_checks = 1 " ${DBCONFIG[4]} -- cgit v1.2.3