DB dump, players DB and team Cezar mapping settings updated for 2021/22

21 files changed, 128 insertions, 169 deletions

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