1N tournament added to butler bundles

4 files changed, 32 insertions, 9 deletions

diff --git a/butler/config.json b/butler/config.json
index 7c4cb04..3654b57 100644
--- a/butler/config.json
+++ b/butler/config.json
@@ -2,6 +2,7 @@
     "1+2": {
         "source": [
             "dmp202021_1n_b",
+            "dmp202021_1n_z3",
             "dmp202021_1s",
             "dmp202021_2se",
             "dmp202021_2sw",
@@ -13,6 +14,7 @@
     "1": {
         "source": [
             "dmp202021_1n_b",
+            "dmp202021_1n_z3",
             "dmp202021_1s"
         ],
         "output": "dmp202021_b_1"
@@ -30,6 +32,7 @@
         "dmp202021_e": "E",
         "dmp202021_1s": "S",
         "dmp202021_1n_b": "N",
+        "dmp202021_1n_z3": "N",
         "dmp202021_2se": "SE",
         "dmp202021_2sw": "SW",
         "dmp202021_2ne": "NE",
@@ -38,7 +41,27 @@
     "__queries": {
         "dmp202021_1n_b": [
             "UPDATE _matches SET mtitle = '--' WHERE rnd < 6;",
-            "UPDATE _segments SET openN = 0, openS = 0, openW = 0, openE = 0, closeN = 0, closeS = 0, closeW = 0, closeE = 0, towel = 1 WHERE rnd < 6;"
+            "DELETE FROM _segments WHERE rnd < 6;",
+            "UPDATE _matches SET mtitle = '--' WHERE rnd > 10;",
+            "DELETE FROM _segments WHERE rnd > 10;",
+            "TRUNCATE _players;"
+        ],
+        "dmp202021_1n_z3": [
+            "UPDATE _rounds SET rnd = rnd + 10;",
+            "UPDATE _matches SET rnd = rnd + 10;",
+            "UPDATE _segments SET rnd = rnd + 10, openN = openN - 400, openS = openS - 400, openE = openE - 400, openW = openW - 400, closeN = closeN - 400, closeS = closeS - 400, closeE = closeE - 400, closeW = closeW - 400;",
+            "UPDATE _players SET id = id - 400;",
+            "UPDATE _scores SET rnd = rnd + 10;",
+            "INSERT INTO _matches(rnd, tabl, homet, visit, mtitle) SELECT 1, id, id, id+8, '--' FROM teams WHERE id < 9;",
+            "INSERT INTO _matches(rnd, tabl, homet, visit, mtitle) SELECT 2, id, id, id+8, '--' FROM teams WHERE id < 9;",
+            "INSERT INTO _matches(rnd, tabl, homet, visit, mtitle) SELECT 3, id, id, id+8, '--' FROM teams WHERE id < 9;",
+            "INSERT INTO _matches(rnd, tabl, homet, visit, mtitle) SELECT 4, id, id, id+8, '--' FROM teams WHERE id < 9;",
+            "INSERT INTO _matches(rnd, tabl, homet, visit, mtitle) SELECT 5, id, id, id+8, '--' FROM teams WHERE id < 9;",
+            "INSERT INTO _matches(rnd, tabl, homet, visit, mtitle) SELECT 6, id, id, id+8, '--' FROM teams WHERE id < 9;",
+            "INSERT INTO _matches(rnd, tabl, homet, visit, mtitle) SELECT 7, id, id, id+8, '--' FROM teams WHERE id < 9;",
+            "INSERT INTO _matches(rnd, tabl, homet, visit, mtitle) SELECT 8, id, id, id+8, '--' FROM teams WHERE id < 9;",
+            "INSERT INTO _matches(rnd, tabl, homet, visit, mtitle) SELECT 9, id, id, id+8, '--' FROM teams WHERE id < 9;",
+            "INSERT INTO _matches(rnd, tabl, homet, visit, mtitle) SELECT 10, id, id, id+8, '--' FROM teams WHERE id < 9;"
         ],
         "dmp202021_2se": [
             "UPDATE admin SET roundcnt = 15;",
diff --git a/dumps/.mapping b/dumps/.mapping
index ca8abda..d036f9c 100644
--- a/dumps/.mapping
+++ b/dumps/.mapping
@@ -1,8 +1,6 @@
-dmp202021_e     sync/eliga2021.sql
-dmp202021_1n    sync/_21_1ligan.sql
-dmp202021_1n_b  sync/_21_1ligan.sql
-dmp202021_1s    sync/tel.sql
-dmp202021_2ne   sync/2nerr.sql
-dmp202021_2nw   sync/20nwrr.sql
-dmp202021_2se   sync/serrr.sql
-dmp202021_2sw   sync/2swrr.sql
+dmp202021_1n_z3  sync/dmp202021_1n_z3.sql
+dmp202021_1s     sync/tel.sql
+dmp202021_2ne    sync/dmp202021_2ne.sql
+dmp202021_2nw    sync/20nwrr.sql
+dmp202021_2se    sync/serrr.sql
+dmp202021_2sw    sync/dmp202021_2sw.sql
diff --git a/dumps/.paid-queries b/dumps/.paid-queries
index 34d1547..fb34de1 100644
--- a/dumps/.paid-queries
+++ b/dumps/.paid-queries
@@ -1,4 +1,5 @@
 dmp202021_1n 6 15
+dmp202021_1n_z3 1 5
 dmp202021_1s 6 15
 dmp202021_2ne 6 15
 dmp202021_2se 6 13
diff --git a/dumps/.queries b/dumps/.queries
index 2b06dea..6996af3 100644
--- a/dumps/.queries
+++ b/dumps/.queries
@@ -1,2 +1,3 @@
 SELECT shortname, rnd, segm FROM admin;
 UPDATE params SET path = "C:\\wwwliga\\";
+UPDATE admin SET oldbutler = "dmp202021_1n" WHERE oldbutler = "_21_1ligan"