summaryrefslogtreecommitdiff
path: root/dumps
diff options
context:
space:
mode:
Diffstat (limited to 'dumps')
-rw-r--r--dumps/.backup6
-rw-r--r--dumps/.cezar-teams-dmp202223_1n16
-rw-r--r--dumps/.cezar-teams-dmp202223_1s16
-rw-r--r--dumps/.cezar-teams-dmp202223_2ne16
-rw-r--r--dumps/.cezar-teams-dmp202223_2nw16
-rw-r--r--dumps/.cezar-teams-dmp202223_2se16
-rw-r--r--dumps/.cezar-teams-dmp202223_2sw16
-rw-r--r--dumps/.cezar-teams-dmp202223_e16
-rw-r--r--dumps/.cezar-teams-dmp202324_1n16
-rw-r--r--dumps/.cezar-teams-dmp202324_1s16
-rw-r--r--dumps/.cezar-teams-dmp202324_2ne16
-rw-r--r--dumps/.cezar-teams-dmp202324_2nw16
-rw-r--r--dumps/.cezar-teams-dmp202324_2se16
-rw-r--r--dumps/.cezar-teams-dmp202324_2sw15
-rw-r--r--dumps/.cezar-teams-dmp202324_e16
-rw-r--r--dumps/.paid-queries14
-rwxr-xr-xdumps/check-paid.sh2
17 files changed, 122 insertions, 123 deletions
diff --git a/dumps/.backup b/dumps/.backup
index 268874a..e7506ec 100644
--- a/dumps/.backup
+++ b/dumps/.backup
@@ -1,3 +1,3 @@
-dmp202223_b0
-dmp202223_b1
-dmp202223_b2
+dmp202324_b0
+dmp202324_b1
+dmp202324_b2
diff --git a/dumps/.cezar-teams-dmp202223_1n b/dumps/.cezar-teams-dmp202223_1n
deleted file mode 100644
index a64e9fa..0000000
--- a/dumps/.cezar-teams-dmp202223_1n
+++ /dev/null
@@ -1,16 +0,0 @@
-1 11916
-2 11927
-3 11816
-4 11896
-5 11790
-6 11865
-7 11894
-8 11817
-9 11862
-10 11880
-11 11877
-12 11858
-13 11785
-14 11823
-15 11809
-16 11831
diff --git a/dumps/.cezar-teams-dmp202223_1s b/dumps/.cezar-teams-dmp202223_1s
deleted file mode 100644
index b38fbe4..0000000
--- a/dumps/.cezar-teams-dmp202223_1s
+++ /dev/null
@@ -1,16 +0,0 @@
-1 11872
-2 11802
-3 11954
-4 11844
-5 11819
-6 11868
-7 11921
-8 11814
-9 11881
-10 11825
-11 11801
-12 11832
-13 12004
-14 11841
-15 11852
-16 11795
diff --git a/dumps/.cezar-teams-dmp202223_2ne b/dumps/.cezar-teams-dmp202223_2ne
deleted file mode 100644
index a3873bf..0000000
--- a/dumps/.cezar-teams-dmp202223_2ne
+++ /dev/null
@@ -1,16 +0,0 @@
-1 11824
-2 11941
-3 11919
-4 11885
-5 11883
-6 11882
-7 12028
-8 11820
-9 11936
-10 11818
-11 11935
-12 11953
-13 11886
-14 11808
-15 11981
-16 11890
diff --git a/dumps/.cezar-teams-dmp202223_2nw b/dumps/.cezar-teams-dmp202223_2nw
deleted file mode 100644
index bf5d767..0000000
--- a/dumps/.cezar-teams-dmp202223_2nw
+++ /dev/null
@@ -1,16 +0,0 @@
-1 11846
-2 11797
-3 11789
-4 11791
-5 11835
-6 11786
-7 11799
-8 11800
-9 11912
-10 11806
-11 11834
-12 11876
-13 11879
-14 11891
-15 11899
-16 11798
diff --git a/dumps/.cezar-teams-dmp202223_2se b/dumps/.cezar-teams-dmp202223_2se
deleted file mode 100644
index a67ccbe..0000000
--- a/dumps/.cezar-teams-dmp202223_2se
+++ /dev/null
@@ -1,16 +0,0 @@
-1 11849
-2 11855
-3 11947
-4 11932
-5 11985
-6 11803
-7 11833
-8 11805
-9 11839
-10 11901
-11 11851
-12 11853
-13 11917
-14 11796
-15 11909
-16 11840
diff --git a/dumps/.cezar-teams-dmp202223_2sw b/dumps/.cezar-teams-dmp202223_2sw
deleted file mode 100644
index 33db08b..0000000
--- a/dumps/.cezar-teams-dmp202223_2sw
+++ /dev/null
@@ -1,16 +0,0 @@
-1 11787
-2 11866
-3 11815
-4 11847
-5 11933
-6 11784
-7 11905
-8 11863
-9 11867
-10 11887
-11 11897
-12 11892
-13 11898
-14 11893
-15 11915
-16 11827
diff --git a/dumps/.cezar-teams-dmp202223_e b/dumps/.cezar-teams-dmp202223_e
deleted file mode 100644
index eead659..0000000
--- a/dumps/.cezar-teams-dmp202223_e
+++ /dev/null
@@ -1,16 +0,0 @@
-1 11837
-2 11794
-3 11895
-4 11864
-5 11918
-6 12024
-7 11922
-8 11913
-9 11822
-10 11821
-11 11993
-12 11826
-13 11884
-14 11871
-15 11792
-16 11788
diff --git a/dumps/.cezar-teams-dmp202324_1n b/dumps/.cezar-teams-dmp202324_1n
new file mode 100644
index 0000000..469c856
--- /dev/null
+++ b/dumps/.cezar-teams-dmp202324_1n
@@ -0,0 +1,16 @@
+1
+2
+3
+4
+5
+6
+7
+8
+9
+10
+11
+12
+13
+14
+15
+16
diff --git a/dumps/.cezar-teams-dmp202324_1s b/dumps/.cezar-teams-dmp202324_1s
new file mode 100644
index 0000000..462c149
--- /dev/null
+++ b/dumps/.cezar-teams-dmp202324_1s
@@ -0,0 +1,16 @@
+1 12582
+2 12550
+3 12481
+4 12359
+5 12419
+6 12408
+7 12410
+8 12429
+9 12432
+10 12554
+11 12482
+12 12438
+13 12340
+14 12463
+15 12341
+16 12592
diff --git a/dumps/.cezar-teams-dmp202324_2ne b/dumps/.cezar-teams-dmp202324_2ne
new file mode 100644
index 0000000..469c856
--- /dev/null
+++ b/dumps/.cezar-teams-dmp202324_2ne
@@ -0,0 +1,16 @@
+1
+2
+3
+4
+5
+6
+7
+8
+9
+10
+11
+12
+13
+14
+15
+16
diff --git a/dumps/.cezar-teams-dmp202324_2nw b/dumps/.cezar-teams-dmp202324_2nw
new file mode 100644
index 0000000..469c856
--- /dev/null
+++ b/dumps/.cezar-teams-dmp202324_2nw
@@ -0,0 +1,16 @@
+1
+2
+3
+4
+5
+6
+7
+8
+9
+10
+11
+12
+13
+14
+15
+16
diff --git a/dumps/.cezar-teams-dmp202324_2se b/dumps/.cezar-teams-dmp202324_2se
new file mode 100644
index 0000000..469c856
--- /dev/null
+++ b/dumps/.cezar-teams-dmp202324_2se
@@ -0,0 +1,16 @@
+1
+2
+3
+4
+5
+6
+7
+8
+9
+10
+11
+12
+13
+14
+15
+16
diff --git a/dumps/.cezar-teams-dmp202324_2sw b/dumps/.cezar-teams-dmp202324_2sw
new file mode 100644
index 0000000..11fa5c1
--- /dev/null
+++ b/dumps/.cezar-teams-dmp202324_2sw
@@ -0,0 +1,15 @@
+1 12363
+2 12522
+3 12517
+4 12380
+5 12443
+6 12362
+7 12548
+8 12461
+9 12503
+10 12339
+11 12540
+12 12485
+13 12488
+14 12542
+15 12489
diff --git a/dumps/.cezar-teams-dmp202324_e b/dumps/.cezar-teams-dmp202324_e
new file mode 100644
index 0000000..f2b6b0d
--- /dev/null
+++ b/dumps/.cezar-teams-dmp202324_e
@@ -0,0 +1,16 @@
+1 12501
+2 12337
+3 12401
+4 12386
+5 12609
+6 12387
+7 12601
+8 12381
+9 12543
+10 12504
+11 12553
+12 12420
+13 12357
+14 12544
+15 12475
+16 12555
diff --git a/dumps/.paid-queries b/dumps/.paid-queries
index 33ea65f..0db9821 100644
--- a/dumps/.paid-queries
+++ b/dumps/.paid-queries
@@ -1,7 +1,7 @@
-dmp202223_1n 11 15
-dmp202223_1s 11 15
-dmp202223_2ne 11 15
-dmp202223_2se 11 15
-dmp202223_2nw 11 15
-dmp202223_2sw 11 15
-dmp202223_e 9 15
+dmp202324_1n 1 5
+dmp202324_1s 1 5
+dmp202324_2ne 1 5
+dmp202324_2se 1 5
+dmp202324_2nw 1 5
+dmp202324_2sw 1 5
+dmp202324_e 1 7
diff --git a/dumps/check-paid.sh b/dumps/check-paid.sh
index c76fb15..3cf1244 100755
--- a/dumps/check-paid.sh
+++ b/dumps/check-paid.sh
@@ -4,5 +4,5 @@ PLAYERSDB=${LIGA_PLAYERS_DB_NAME}
ROUNDFROM=$2
ROUNDTO=$3
echo $DBNAME
-QUERY="SELECT dmpplayers.link, CONCAT(dmpplayers.gname, ' ', dmpplayers.sname), teams.fullname, CONCAT(segments.rnd, '-', segments.segment), players.flag1, players.flag2 FROM $DBNAME.butler butler JOIN $DBNAME.players dmpplayers ON dmpplayers.id = butler.id LEFT JOIN $PLAYERSDB.players players ON players.id = dmpplayers.link JOIN $DBNAME.teams teams ON teams.id = dmpplayers.team JOIN (SELECT rnd, segment, openN as pl FROM $DBNAME.segments UNION SELECT rnd, segment, openE as pl FROM $DBNAME.segments UNION SELECT rnd, segment, openW as pl FROM $DBNAME.segments UNION SELECT rnd, segment, openS as pl FROM $DBNAME.segments UNION SELECT rnd, segment, closeN as pl FROM $DBNAME.segments UNION SELECT rnd, segment, closeE as pl FROM $DBNAME.segments UNION SELECT rnd, segment, closeW as pl FROM $DBNAME.segments UNION SELECT rnd, segment, closeS as pl FROM $DBNAME.segments) segments ON segments.pl = dmpplayers.id WHERE COALESCE(players.flag2, 'N') <> 'T' AND segments.rnd >= $ROUNDFROM AND segments.rnd <= $ROUNDTO ORDER BY dmpplayers.link, segments.rnd, segments.segment;"
+QUERY="SELECT dmpplayers.link, CONCAT(dmpplayers.gname, ' ', dmpplayers.sname), teams.fullname, CONCAT(segments.rnd, '-', segments.segment), players.flag1, players.flag2 FROM $DBNAME.butler butler JOIN $DBNAME.players dmpplayers ON dmpplayers.id = butler.id LEFT JOIN $PLAYERSDB.players players ON players.id = dmpplayers.link JOIN $DBNAME.teams teams ON teams.id = dmpplayers.team JOIN (SELECT rnd, segment, openN as pl FROM $DBNAME.segments UNION SELECT rnd, segment, openE as pl FROM $DBNAME.segments UNION SELECT rnd, segment, openW as pl FROM $DBNAME.segments UNION SELECT rnd, segment, openS as pl FROM $DBNAME.segments UNION SELECT rnd, segment, closeN as pl FROM $DBNAME.segments UNION SELECT rnd, segment, closeE as pl FROM $DBNAME.segments UNION SELECT rnd, segment, closeW as pl FROM $DBNAME.segments UNION SELECT rnd, segment, closeS as pl FROM $DBNAME.segments) segments ON segments.pl = dmpplayers.id WHERE (COALESCE(players.flag2, 'N') <> 'T' AND COALESCE(players.flag1, 'N') <> 'T') AND segments.rnd >= $ROUNDFROM AND segments.rnd <= $ROUNDTO ORDER BY dmpplayers.link, segments.rnd, segments.segment;"
echo $QUERY | mysql ${LIGA_MYSQL_CONNECTION_OPTS} -N
generated by cgit v1.2.3 (git 2.46.0) at 2024-11-22 13:18:56 +0000