diff options
author | emkael <emkael@tlen.pl> | 2018-08-24 12:53:41 +0200 |
---|---|---|
committer | emkael <emkael@tlen.pl> | 2018-08-24 12:54:15 +0200 |
commit | 6f9756cf49e2e2802916ef251732a9377ddd756b (patch) | |
tree | 66bf607583b9ed856341454b505b0c50d9487d24 /bin/rankings-csv-import.sh | |
parent | 83c732f6c67c05b641cd0d37d9e8718cbf061c65 (diff) |
Alowingg players to not be displayed by name in the rankings
Diffstat (limited to 'bin/rankings-csv-import.sh')
-rwxr-xr-x | bin/rankings-csv-import.sh | 3 |
1 files changed, 2 insertions, 1 deletions
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]} |