diff options
| -rw-r--r-- | butler/config.json | 25 | ||||
| -rw-r--r-- | dumps/.mapping | 14 | ||||
| -rw-r--r-- | dumps/.paid-queries | 1 | ||||
| -rw-r--r-- | dumps/.queries | 1 |
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" |