From 184310dea9f3b6d22786dd42776ff6e7093c58e9 Mon Sep 17 00:00:00 2001 From: emkael Date: Sat, 20 Nov 2021 15:20:22 +0100 Subject: DB dump, players DB and team Cezar mapping settings updated for 2021/22 --- dumps/.cezar-teams-dmp202021_1n | 16 ---------------- dumps/.cezar-teams-dmp202021_1n_b | 16 ---------------- dumps/.cezar-teams-dmp202021_1n_z1 | 16 ---------------- dumps/.cezar-teams-dmp202021_1n_z3 | 16 ---------------- dumps/.cezar-teams-dmp202021_1s | 16 ---------------- dumps/.cezar-teams-dmp202021_2ne | 16 ---------------- dumps/.cezar-teams-dmp202021_2nw | 16 ---------------- dumps/.cezar-teams-dmp202021_2se | 14 -------------- dumps/.cezar-teams-dmp202021_2sw | 16 ---------------- dumps/.cezar-teams-dmp202021_e | 16 ---------------- dumps/.cezar-teams-dmp202122_1n | 18 ++++++++++++++++++ dumps/.cezar-teams-dmp202122_1s | 16 ++++++++++++++++ dumps/.cezar-teams-dmp202122_2ne | 16 ++++++++++++++++ dumps/.cezar-teams-dmp202122_2nw | 16 ++++++++++++++++ dumps/.cezar-teams-dmp202122_2se | 15 +++++++++++++++ dumps/.cezar-teams-dmp202122_2sw | 16 ++++++++++++++++ dumps/.cezar-teams-dmp202122_e | 16 ++++++++++++++++ dumps/.mapping | 8 +++++++- dumps/.paid-queries | 15 +++++++-------- dumps/.queries | 1 - dumps/import-players.sh | 2 +- 21 files changed, 128 insertions(+), 169 deletions(-) delete mode 100644 dumps/.cezar-teams-dmp202021_1n delete mode 100644 dumps/.cezar-teams-dmp202021_1n_b delete mode 100644 dumps/.cezar-teams-dmp202021_1n_z1 delete mode 100644 dumps/.cezar-teams-dmp202021_1n_z3 delete mode 100644 dumps/.cezar-teams-dmp202021_1s delete mode 100644 dumps/.cezar-teams-dmp202021_2ne delete mode 100644 dumps/.cezar-teams-dmp202021_2nw delete mode 100644 dumps/.cezar-teams-dmp202021_2se delete mode 100644 dumps/.cezar-teams-dmp202021_2sw delete mode 100644 dumps/.cezar-teams-dmp202021_e create mode 100644 dumps/.cezar-teams-dmp202122_1n create mode 100644 dumps/.cezar-teams-dmp202122_1s create mode 100644 dumps/.cezar-teams-dmp202122_2ne create mode 100644 dumps/.cezar-teams-dmp202122_2nw create mode 100644 dumps/.cezar-teams-dmp202122_2se create mode 100644 dumps/.cezar-teams-dmp202122_2sw create mode 100644 dumps/.cezar-teams-dmp202122_e (limited to 'dumps') diff --git a/dumps/.cezar-teams-dmp202021_1n b/dumps/.cezar-teams-dmp202021_1n deleted file mode 100644 index 3b5d002..0000000 --- a/dumps/.cezar-teams-dmp202021_1n +++ /dev/null @@ -1,16 +0,0 @@ -1 10761 -2 10868 -3 10845 -4 10837 -5 10770 -6 10838 -7 10823 -8 10795 -9 10841 -10 10727 -11 10801 -12 10817 -13 10734 -14 10744 -15 10865 -16 10852 diff --git a/dumps/.cezar-teams-dmp202021_1n_b b/dumps/.cezar-teams-dmp202021_1n_b deleted file mode 100644 index 3b5d002..0000000 --- a/dumps/.cezar-teams-dmp202021_1n_b +++ /dev/null @@ -1,16 +0,0 @@ -1 10761 -2 10868 -3 10845 -4 10837 -5 10770 -6 10838 -7 10823 -8 10795 -9 10841 -10 10727 -11 10801 -12 10817 -13 10734 -14 10744 -15 10865 -16 10852 diff --git a/dumps/.cezar-teams-dmp202021_1n_z1 b/dumps/.cezar-teams-dmp202021_1n_z1 deleted file mode 100644 index 3b5d002..0000000 --- a/dumps/.cezar-teams-dmp202021_1n_z1 +++ /dev/null @@ -1,16 +0,0 @@ -1 10761 -2 10868 -3 10845 -4 10837 -5 10770 -6 10838 -7 10823 -8 10795 -9 10841 -10 10727 -11 10801 -12 10817 -13 10734 -14 10744 -15 10865 -16 10852 diff --git a/dumps/.cezar-teams-dmp202021_1n_z3 b/dumps/.cezar-teams-dmp202021_1n_z3 deleted file mode 100644 index 3b5d002..0000000 --- a/dumps/.cezar-teams-dmp202021_1n_z3 +++ /dev/null @@ -1,16 +0,0 @@ -1 10761 -2 10868 -3 10845 -4 10837 -5 10770 -6 10838 -7 10823 -8 10795 -9 10841 -10 10727 -11 10801 -12 10817 -13 10734 -14 10744 -15 10865 -16 10852 diff --git a/dumps/.cezar-teams-dmp202021_1s b/dumps/.cezar-teams-dmp202021_1s deleted file mode 100644 index 61f2726..0000000 --- a/dumps/.cezar-teams-dmp202021_1s +++ /dev/null @@ -1,16 +0,0 @@ -1 10760 -2 10743 -3 10878 -4 10840 -5 10890 -6 10829 -7 10780 -8 10889 -9 10773 -10 10803 -11 10797 -12 10813 -13 10811 -14 10802 -15 10887 -16 10824 diff --git a/dumps/.cezar-teams-dmp202021_2ne b/dumps/.cezar-teams-dmp202021_2ne deleted file mode 100644 index 124c369..0000000 --- a/dumps/.cezar-teams-dmp202021_2ne +++ /dev/null @@ -1,16 +0,0 @@ -1 10924 -2 10722 -3 10900 -4 10923 -5 10884 -6 10765 -7 10877 -8 10757 -9 10881 -10 10762 -11 10796 -12 10888 -13 10984 -14 10724 -15 10806 -16 10825 diff --git a/dumps/.cezar-teams-dmp202021_2nw b/dumps/.cezar-teams-dmp202021_2nw deleted file mode 100644 index bcefd40..0000000 --- a/dumps/.cezar-teams-dmp202021_2nw +++ /dev/null @@ -1,16 +0,0 @@ -1 10821 -2 10897 -3 10753 -4 10767 -5 10864 -6 10751 -7 10763 -8 10737 -9 10926 -10 10922 -11 10896 -12 10895 -13 10799 -14 10800 -15 10735 -16 10828 diff --git a/dumps/.cezar-teams-dmp202021_2se b/dumps/.cezar-teams-dmp202021_2se deleted file mode 100644 index 8cada06..0000000 --- a/dumps/.cezar-teams-dmp202021_2se +++ /dev/null @@ -1,14 +0,0 @@ -1 10774 -2 10787 -3 10911 -4 10925 -5 10928 -6 10812 -7 10879 -8 10764 -9 10860 -10 10914 -11 10891 -12 10968 -13 10912 -14 10933 diff --git a/dumps/.cezar-teams-dmp202021_2sw b/dumps/.cezar-teams-dmp202021_2sw deleted file mode 100644 index 3fcdd81..0000000 --- a/dumps/.cezar-teams-dmp202021_2sw +++ /dev/null @@ -1,16 +0,0 @@ -1 10844 -2 10788 -3 10782 -4 10846 -5 10871 -6 10741 -7 10873 -8 10831 -9 10742 -10 10739 -11 10898 -12 10872 -13 10848 -14 0 -15 10904 -16 10759 diff --git a/dumps/.cezar-teams-dmp202021_e b/dumps/.cezar-teams-dmp202021_e deleted file mode 100644 index 6a76a05..0000000 --- a/dumps/.cezar-teams-dmp202021_e +++ /dev/null @@ -1,16 +0,0 @@ -1 10793 -2 10804 -3 10836 -4 10784 -5 10798 -6 10749 -7 10875 -8 10882 -9 10777 -10 10772 -11 10835 -12 10771 -13 10805 -14 10779 -15 10880 -16 10740 diff --git a/dumps/.cezar-teams-dmp202122_1n b/dumps/.cezar-teams-dmp202122_1n new file mode 100644 index 0000000..92d8f13 --- /dev/null +++ b/dumps/.cezar-teams-dmp202122_1n @@ -0,0 +1,18 @@ +1 11308 +2 11499 +3 11538 +4 11536 +5 11580 +6 11329 +7 11574 +8 11439 +9 11362 +10 11336 +11 11357 +12 11378 +13 11457 +14 11356 +15 11456 +16 11437 +17 11502 +18 11374 diff --git a/dumps/.cezar-teams-dmp202122_1s b/dumps/.cezar-teams-dmp202122_1s new file mode 100644 index 0000000..67dfbd9 --- /dev/null +++ b/dumps/.cezar-teams-dmp202122_1s @@ -0,0 +1,16 @@ +1 11428 +2 11271 +3 11307 +4 11436 +5 11321 +6 11555 +7 11455 +8 11565 +9 11576 +10 11447 +11 11429 +12 11441 +13 11372 +14 11322 +15 11464 +16 11327 diff --git a/dumps/.cezar-teams-dmp202122_2ne b/dumps/.cezar-teams-dmp202122_2ne new file mode 100644 index 0000000..bfb5a5a --- /dev/null +++ b/dumps/.cezar-teams-dmp202122_2ne @@ -0,0 +1,16 @@ +1 11373 +2 11527 +3 11537 +4 11442 +5 11523 +6 11467 +7 11519 +8 11477 +9 11382 +10 11478 +11 11468 +12 11470 +13 11573 +14 11479 +15 11535 +16 11404 diff --git a/dumps/.cezar-teams-dmp202122_2nw b/dumps/.cezar-teams-dmp202122_2nw new file mode 100644 index 0000000..1deaed3 --- /dev/null +++ b/dumps/.cezar-teams-dmp202122_2nw @@ -0,0 +1,16 @@ +1 11430 +2 11286 +3 11500 +4 0 +5 11569 +6 11328 +7 11387 +8 11575 +9 11358 +10 11338 +11 11400 +12 11310 +13 11581 +14 11406 +15 11460 +16 11432 diff --git a/dumps/.cezar-teams-dmp202122_2se b/dumps/.cezar-teams-dmp202122_2se new file mode 100644 index 0000000..c8c68e6 --- /dev/null +++ b/dumps/.cezar-teams-dmp202122_2se @@ -0,0 +1,15 @@ +1 11427 +2 11469 +3 11461 +4 11542 +5 11425 +6 11458 +7 11452 +8 11454 +9 11448 +10 11526 +11 11566 +13 11579 +14 11572 +15 11451 +16 11366 diff --git a/dumps/.cezar-teams-dmp202122_2sw b/dumps/.cezar-teams-dmp202122_2sw new file mode 100644 index 0000000..f333d3b --- /dev/null +++ b/dumps/.cezar-teams-dmp202122_2sw @@ -0,0 +1,16 @@ +1 11255 +2 11258 +3 11274 +4 11272 +5 11273 +6 11546 +7 11544 +8 11543 +9 11545 +10 11431 +11 11311 +12 11368 +13 11326 +14 11324 +15 11485 +16 11450 diff --git a/dumps/.cezar-teams-dmp202122_e b/dumps/.cezar-teams-dmp202122_e new file mode 100644 index 0000000..9744211 --- /dev/null +++ b/dumps/.cezar-teams-dmp202122_e @@ -0,0 +1,16 @@ +1 11309 +2 11433 +3 11282 +4 11337 +5 11539 +6 11254 +7 11475 +8 11488 +9 11434 +10 11423 +11 11554 +12 11462 +13 11435 +14 11463 +15 11297 +16 11449 diff --git a/dumps/.mapping b/dumps/.mapping index 148f3a0..2ef8a5b 100644 --- a/dumps/.mapping +++ b/dumps/.mapping @@ -1 +1,7 @@ -dmp202021_1n sync/dmp202021_1n.sql +dmp202122_e sync/eliga2122.sql +dmp202122_1n sync/_22_1ligan.sql +dmp202122_1s sync/liga2122.sql +dmp202122_2ne sync/nerr.sql +dmp202122_2nw sync/22nwrr.sql +dmp202122_2se sync/serr.sql +dmp202122_2sw sync/2swrr.sql diff --git a/dumps/.paid-queries b/dumps/.paid-queries index fb34de1..b6b4472 100644 --- a/dumps/.paid-queries +++ b/dumps/.paid-queries @@ -1,8 +1,7 @@ -dmp202021_1n 6 15 -dmp202021_1n_z3 1 5 -dmp202021_1s 6 15 -dmp202021_2ne 6 15 -dmp202021_2se 6 13 -dmp202021_2nw 6 15 -dmp202021_2sw 6 15 -dmp202021_e 8 15 +dmp202122_1n 1 5 +dmp202122_1s 1 5 +dmp202122_2ne 1 5 +dmp202122_2se 1 5 +dmp202122_2nw 1 5 +dmp202122_2sw 1 5 +dmp202122_e 1 8 diff --git a/dumps/.queries b/dumps/.queries index 6996af3..2b06dea 100644 --- a/dumps/.queries +++ b/dumps/.queries @@ -1,3 +1,2 @@ SELECT shortname, rnd, segm FROM admin; UPDATE params SET path = "C:\\wwwliga\\"; -UPDATE admin SET oldbutler = "dmp202021_1n" WHERE oldbutler = "_21_1ligan" diff --git a/dumps/import-players.sh b/dumps/import-players.sh index 9763ab5..3edb7c7 100755 --- a/dumps/import-players.sh +++ b/dumps/import-players.sh @@ -1,7 +1,7 @@ #!/bin/bash cd $(dirname $0) DBNAME=${LIGA_PLAYERS_DB_NAME} -curl ${LIGA_BAZA_CSV} | iconv -f cp1250 -t utf8 | grep '^[0-9]' | sed 's/;[0-9]\{4\}-[0-9]\{2\}-[0-9]\{2\}/;T/g' | cut -d';' -f1-7,10-11 > baza.csv +curl ${LIGA_BAZA_CSV} | iconv -f cp1250 -t utf8 | grep '^[0-9]' | sed 's/;[0-9]\{4\}-[0-9]\{2\}-[0-9]\{2\}/;T/g' | cut -d';' -f1-7,9,11 > baza.csv mysql ${LIGA_MYSQL_CONNECTION_OPTS} --local-infile=1 $DBNAME -e "TRUNCATE players; LOAD DATA LOCAL INFILE 'baza.csv' REPLACE -- cgit v1.2.3