summaryrefslogtreecommitdiff
path: root/dumps
diff options
context:
space:
mode:
Diffstat (limited to 'dumps')
-rw-r--r--dumps/.cezar-teams-dmp202021_1n16
-rw-r--r--dumps/.cezar-teams-dmp202021_1n_b16
-rw-r--r--dumps/.cezar-teams-dmp202021_1n_z116
-rw-r--r--dumps/.cezar-teams-dmp202021_1n_z316
-rw-r--r--dumps/.cezar-teams-dmp202021_1s16
-rw-r--r--dumps/.cezar-teams-dmp202021_2ne16
-rw-r--r--dumps/.cezar-teams-dmp202021_2nw16
-rw-r--r--dumps/.cezar-teams-dmp202021_2se14
-rw-r--r--dumps/.cezar-teams-dmp202021_2sw16
-rw-r--r--dumps/.cezar-teams-dmp202021_e16
-rw-r--r--dumps/.cezar-teams-dmp202122_1n18
-rw-r--r--dumps/.cezar-teams-dmp202122_1s16
-rw-r--r--dumps/.cezar-teams-dmp202122_2ne16
-rw-r--r--dumps/.cezar-teams-dmp202122_2nw16
-rw-r--r--dumps/.cezar-teams-dmp202122_2se15
-rw-r--r--dumps/.cezar-teams-dmp202122_2sw16
-rw-r--r--dumps/.cezar-teams-dmp202122_e16
-rw-r--r--dumps/.mapping8
-rw-r--r--dumps/.paid-queries15
-rw-r--r--dumps/.queries1
-rwxr-xr-xdumps/import-players.sh2
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
generated by cgit v1.2.3 (git 2.46.0) at 2024-11-22 13:27:51 +0000