diff options
author | emkael <emkael@tlen.pl> | 2021-03-01 16:21:34 +0100 |
---|---|---|
committer | emkael <emkael@tlen.pl> | 2021-03-01 16:21:34 +0100 |
commit | f5cce81e9a745e40909b08c9cf87113035e3f7eb (patch) | |
tree | 84bcf2c3f5ded4524be16288c8b7a5d47c8a74b2 | |
parent | 916332a89547e69e5fe297811eca32806a9225a7 (diff) |
Hidden players script adjustments: flag as hidden immediately and ensure CSV import into MySQL
-rwxr-xr-x | bin/hidden-import.sh | 3 |
1 files changed, 2 insertions, 1 deletions
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]} |