From c8bd6a7ec58f87b092b733c4b62546d821322fe8 Mon Sep 17 00:00:00 2001 From: DDuarte Date: Sun, 16 Oct 2016 20:20:55 +0100 Subject: SQLs: Move SQL updates the correct sub-folder (6.x -> master) --- sql/updates/auth/6.x/2016_10_17_00_auth.sql | 1 - sql/updates/auth/master/2016_10_17_00_auth.sql | 1 + sql/updates/characters/6.x/2016_10_17_00_characters.sql | 1 - .../characters/master/2016_10_17_00_characters.sql | 1 + sql/updates/hotfixes/6.x/2016_10_17_00_hotfixes.sql | 1 - sql/updates/hotfixes/master/2016_10_17_00_hotfixes.sql | 1 + sql/updates/world/6.x/2016_10_17_00_world.sql | 3 --- sql/updates/world/6.x/2016_10_17_01_world.sql | 15 --------------- sql/updates/world/master/2016_10_17_00_world.sql | 3 +++ sql/updates/world/master/2016_10_17_01_world.sql | 15 +++++++++++++++ 10 files changed, 21 insertions(+), 21 deletions(-) delete mode 100644 sql/updates/auth/6.x/2016_10_17_00_auth.sql create mode 100644 sql/updates/auth/master/2016_10_17_00_auth.sql delete mode 100644 sql/updates/characters/6.x/2016_10_17_00_characters.sql create mode 100644 sql/updates/characters/master/2016_10_17_00_characters.sql delete mode 100644 sql/updates/hotfixes/6.x/2016_10_17_00_hotfixes.sql create mode 100644 sql/updates/hotfixes/master/2016_10_17_00_hotfixes.sql delete mode 100644 sql/updates/world/6.x/2016_10_17_00_world.sql delete mode 100644 sql/updates/world/6.x/2016_10_17_01_world.sql create mode 100644 sql/updates/world/master/2016_10_17_00_world.sql create mode 100644 sql/updates/world/master/2016_10_17_01_world.sql (limited to 'sql') diff --git a/sql/updates/auth/6.x/2016_10_17_00_auth.sql b/sql/updates/auth/6.x/2016_10_17_00_auth.sql deleted file mode 100644 index 4e3ed5809bf..00000000000 --- a/sql/updates/auth/6.x/2016_10_17_00_auth.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `updates` SET `state`='ARCHIVED'; -- TDB 703.00 diff --git a/sql/updates/auth/master/2016_10_17_00_auth.sql b/sql/updates/auth/master/2016_10_17_00_auth.sql new file mode 100644 index 00000000000..4e3ed5809bf --- /dev/null +++ b/sql/updates/auth/master/2016_10_17_00_auth.sql @@ -0,0 +1 @@ +UPDATE `updates` SET `state`='ARCHIVED'; -- TDB 703.00 diff --git a/sql/updates/characters/6.x/2016_10_17_00_characters.sql b/sql/updates/characters/6.x/2016_10_17_00_characters.sql deleted file mode 100644 index 4e3ed5809bf..00000000000 --- a/sql/updates/characters/6.x/2016_10_17_00_characters.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `updates` SET `state`='ARCHIVED'; -- TDB 703.00 diff --git a/sql/updates/characters/master/2016_10_17_00_characters.sql b/sql/updates/characters/master/2016_10_17_00_characters.sql new file mode 100644 index 00000000000..4e3ed5809bf --- /dev/null +++ b/sql/updates/characters/master/2016_10_17_00_characters.sql @@ -0,0 +1 @@ +UPDATE `updates` SET `state`='ARCHIVED'; -- TDB 703.00 diff --git a/sql/updates/hotfixes/6.x/2016_10_17_00_hotfixes.sql b/sql/updates/hotfixes/6.x/2016_10_17_00_hotfixes.sql deleted file mode 100644 index 4e3ed5809bf..00000000000 --- a/sql/updates/hotfixes/6.x/2016_10_17_00_hotfixes.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `updates` SET `state`='ARCHIVED'; -- TDB 703.00 diff --git a/sql/updates/hotfixes/master/2016_10_17_00_hotfixes.sql b/sql/updates/hotfixes/master/2016_10_17_00_hotfixes.sql new file mode 100644 index 00000000000..4e3ed5809bf --- /dev/null +++ b/sql/updates/hotfixes/master/2016_10_17_00_hotfixes.sql @@ -0,0 +1 @@ +UPDATE `updates` SET `state`='ARCHIVED'; -- TDB 703.00 diff --git a/sql/updates/world/6.x/2016_10_17_00_world.sql b/sql/updates/world/6.x/2016_10_17_00_world.sql deleted file mode 100644 index ed811f52fd7..00000000000 --- a/sql/updates/world/6.x/2016_10_17_00_world.sql +++ /dev/null @@ -1,3 +0,0 @@ -UPDATE `version` SET `db_version`='TDB 703.00', `cache_id`=5 LIMIT 1; - -UPDATE `updates` SET `state`='ARCHIVED'; diff --git a/sql/updates/world/6.x/2016_10_17_01_world.sql b/sql/updates/world/6.x/2016_10_17_01_world.sql deleted file mode 100644 index 969c69c846c..00000000000 --- a/sql/updates/world/6.x/2016_10_17_01_world.sql +++ /dev/null @@ -1,15 +0,0 @@ -DELETE FROM `npc_text` WHERE `ID` IN (30502 /*30502*/, 27571 /*27571*/, 30293 /*30293*/, 30271 /*30271*/, 30270 /*30270*/, 28396 /*28396*/, 28245 /*28245*/, 28243 /*28243*/, 30259 /*30259*/); -INSERT INTO `npc_text` (`ID`, `Probability0`, `Probability1`, `Probability2`, `Probability3`, `Probability4`, `Probability5`, `Probability6`, `Probability7`, `BroadcastTextId0`, `BroadcastTextId1`, `BroadcastTextId2`, `BroadcastTextId3`, `BroadcastTextId4`, `BroadcastTextId5`, `BroadcastTextId6`, `BroadcastTextId7`, `VerifiedBuild`) VALUES -(30502, 1, 0, 0, 0, 0, 0, 0, 0, 122417, 0, 0, 0, 0, 0, 0, 0, 22810), -- 30502 -(27571, 1, 0, 0, 0, 0, 0, 0, 0, 100487, 0, 0, 0, 0, 0, 0, 0, 22810), -- 27571 -(30293, 1, 0, 0, 0, 0, 0, 0, 0, 121622, 0, 0, 0, 0, 0, 0, 0, 22810), -- 30293 -(30271, 1, 0, 0, 0, 0, 0, 0, 0, 121490, 0, 0, 0, 0, 0, 0, 0, 22810), -- 30271 -(30270, 1, 0, 0, 0, 0, 0, 0, 0, 121487, 0, 0, 0, 0, 0, 0, 0, 22810), -- 30270 -(28396, 1, 0, 0, 0, 0, 0, 0, 0, 105763, 0, 0, 0, 0, 0, 0, 0, 22810), -- 28396 -(28245, 1, 1, 1, 1, 1, 1, 1, 1, 104662, 104663, 104664, 104665, 104666, 104667, 104668, 104669, 22810), -- 28245 -(28243, 1, 0, 0, 0, 0, 0, 0, 0, 104606, 0, 0, 0, 0, 0, 0, 0, 22810), -- 28243 -(30259, 1, 0, 0, 0, 0, 0, 0, 0, 121442, 0, 0, 0, 0, 0, 0, 0, 22810); -- 30259 - -UPDATE `npc_text` SET `VerifiedBuild`=22810 WHERE `ID`=5069; -- 5069 -UPDATE `npc_text` SET `VerifiedBuild`=22810 WHERE `ID`=18354; -- 18354 -UPDATE `npc_text` SET `VerifiedBuild`=22810 WHERE `ID`=10000; -- 10000 diff --git a/sql/updates/world/master/2016_10_17_00_world.sql b/sql/updates/world/master/2016_10_17_00_world.sql new file mode 100644 index 00000000000..ed811f52fd7 --- /dev/null +++ b/sql/updates/world/master/2016_10_17_00_world.sql @@ -0,0 +1,3 @@ +UPDATE `version` SET `db_version`='TDB 703.00', `cache_id`=5 LIMIT 1; + +UPDATE `updates` SET `state`='ARCHIVED'; diff --git a/sql/updates/world/master/2016_10_17_01_world.sql b/sql/updates/world/master/2016_10_17_01_world.sql new file mode 100644 index 00000000000..969c69c846c --- /dev/null +++ b/sql/updates/world/master/2016_10_17_01_world.sql @@ -0,0 +1,15 @@ +DELETE FROM `npc_text` WHERE `ID` IN (30502 /*30502*/, 27571 /*27571*/, 30293 /*30293*/, 30271 /*30271*/, 30270 /*30270*/, 28396 /*28396*/, 28245 /*28245*/, 28243 /*28243*/, 30259 /*30259*/); +INSERT INTO `npc_text` (`ID`, `Probability0`, `Probability1`, `Probability2`, `Probability3`, `Probability4`, `Probability5`, `Probability6`, `Probability7`, `BroadcastTextId0`, `BroadcastTextId1`, `BroadcastTextId2`, `BroadcastTextId3`, `BroadcastTextId4`, `BroadcastTextId5`, `BroadcastTextId6`, `BroadcastTextId7`, `VerifiedBuild`) VALUES +(30502, 1, 0, 0, 0, 0, 0, 0, 0, 122417, 0, 0, 0, 0, 0, 0, 0, 22810), -- 30502 +(27571, 1, 0, 0, 0, 0, 0, 0, 0, 100487, 0, 0, 0, 0, 0, 0, 0, 22810), -- 27571 +(30293, 1, 0, 0, 0, 0, 0, 0, 0, 121622, 0, 0, 0, 0, 0, 0, 0, 22810), -- 30293 +(30271, 1, 0, 0, 0, 0, 0, 0, 0, 121490, 0, 0, 0, 0, 0, 0, 0, 22810), -- 30271 +(30270, 1, 0, 0, 0, 0, 0, 0, 0, 121487, 0, 0, 0, 0, 0, 0, 0, 22810), -- 30270 +(28396, 1, 0, 0, 0, 0, 0, 0, 0, 105763, 0, 0, 0, 0, 0, 0, 0, 22810), -- 28396 +(28245, 1, 1, 1, 1, 1, 1, 1, 1, 104662, 104663, 104664, 104665, 104666, 104667, 104668, 104669, 22810), -- 28245 +(28243, 1, 0, 0, 0, 0, 0, 0, 0, 104606, 0, 0, 0, 0, 0, 0, 0, 22810), -- 28243 +(30259, 1, 0, 0, 0, 0, 0, 0, 0, 121442, 0, 0, 0, 0, 0, 0, 0, 22810); -- 30259 + +UPDATE `npc_text` SET `VerifiedBuild`=22810 WHERE `ID`=5069; -- 5069 +UPDATE `npc_text` SET `VerifiedBuild`=22810 WHERE `ID`=18354; -- 18354 +UPDATE `npc_text` SET `VerifiedBuild`=22810 WHERE `ID`=10000; -- 10000 -- cgit v1.2.3