From 455959c6064af6f7863a6b4b57cb0ef1646bd8ef Mon Sep 17 00:00:00 2001 From: Shauren Date: Mon, 3 Jun 2019 20:40:34 +0200 Subject: Core/PacketIO: Rewrite updatefield handling --- sql/updates/auth/master/2019_06_08_01_auth.sql | 2 ++ sql/updates/characters/master/2019_06_08_00_characters.sql | 2 ++ sql/updates/world/master/2019_06_08_01_world.sql | 1 + 3 files changed, 5 insertions(+) create mode 100644 sql/updates/auth/master/2019_06_08_01_auth.sql create mode 100644 sql/updates/characters/master/2019_06_08_00_characters.sql create mode 100644 sql/updates/world/master/2019_06_08_01_world.sql (limited to 'sql/updates') diff --git a/sql/updates/auth/master/2019_06_08_01_auth.sql b/sql/updates/auth/master/2019_06_08_01_auth.sql new file mode 100644 index 00000000000..1c4f66a2567 --- /dev/null +++ b/sql/updates/auth/master/2019_06_08_01_auth.sql @@ -0,0 +1,2 @@ +DELETE FROM `rbac_linked_permissions` WHERE `linkedId` IN (307,308,313,332,333,334,338,546); +DELETE FROM `rbac_permissions` WHERE `id` IN (307,308,313,332,333,334,338,546); diff --git a/sql/updates/characters/master/2019_06_08_00_characters.sql b/sql/updates/characters/master/2019_06_08_00_characters.sql new file mode 100644 index 00000000000..c7ef28d4e34 --- /dev/null +++ b/sql/updates/characters/master/2019_06_08_00_characters.sql @@ -0,0 +1,2 @@ +ALTER TABLE `character_void_storage` DROP `suffixFactor`; +ALTER TABLE `item_loot_items` DROP `rnd_suffix`; diff --git a/sql/updates/world/master/2019_06_08_01_world.sql b/sql/updates/world/master/2019_06_08_01_world.sql new file mode 100644 index 00000000000..8a37ec2737f --- /dev/null +++ b/sql/updates/world/master/2019_06_08_01_world.sql @@ -0,0 +1 @@ +DELETE FROM `command` WHERE `name` IN ('debug setbit','debug getvalue','debug getitemvalue','debug Mod32Value','debug setitemvalue','debug setvalue','debug update','modify bit'); -- cgit v1.2.3