From f5cce81e9a745e40909b08c9cf87113035e3f7eb Mon Sep 17 00:00:00 2001
From: emkael <emkael@tlen.pl>
Date: Mon, 1 Mar 2021 16:21:34 +0100
Subject: Hidden players script adjustments: flag as hidden immediately and
 ensure CSV import into MySQL

---
 bin/hidden-import.sh | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

(limited to 'bin/hidden-import.sh')

diff --git a/bin/hidden-import.sh b/bin/hidden-import.sh
index ecd9f27..6f3104a 100755
--- a/bin/hidden-import.sh
+++ b/bin/hidden-import.sh
@@ -1,9 +1,10 @@
 #!/bin/bash
 DBCONFIG=($(jq -r '.[]' config/import-db.json))
-mysql -h ${DBCONFIG[2]} -P ${DBCONFIG[3]} -u ${DBCONFIG[0]} --password=${DBCONFIG[1]} -e "SET foreign_key_checks = 0;
+mysql --local-infile=1 -h ${DBCONFIG[2]} -P ${DBCONFIG[3]} -u ${DBCONFIG[0]} --password=${DBCONFIG[1]} -e "SET foreign_key_checks = 0;
 DELETE FROM hidden_players;
 LOAD DATA LOCAL INFILE '$1'
 INTO TABLE hidden_players
 FIELDS TERMINATED BY ';' ENCLOSED BY '\"';
+UPDATE rankings SET hidden = 1 WHERE pid IN (SELECT pid FROM hidden_players);
 SET foreign_key_checks = 1
 " ${DBCONFIG[4]}
-- 
cgit v1.2.3