diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/base/auth_database.sql | 9 | ||||
| -rw-r--r-- | sql/updates/auth/3.3.5/2024_01_06_02_auth.sql | 10 | ||||
| -rw-r--r-- | sql/updates/world/3.3.5/2024_01_06_00_world.sql | 7 |
3 files changed, 24 insertions, 2 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql index da86b9094d6..1e48c9e75b6 100644 --- a/sql/base/auth_database.sql +++ b/sql/base/auth_database.sql @@ -995,6 +995,8 @@ INSERT INTO `rbac_linked_permissions` VALUES (197,863), (197,864), (197,865), +(197,884), +(197,885), (198,218), (198,300), (198,312), @@ -1794,7 +1796,9 @@ INSERT INTO `rbac_permissions` VALUES (878,'Command: debug questreset'), (879,'Command: debug poolstatus'), (880,'Command: pdump copy'), -(881,'Command: reload vehicle_template'); +(881,'Command: reload vehicle_template'), +(884,'Command: bg start'), +(885,'Command: bg stop'); /*!40000 ALTER TABLE `rbac_permissions` ENABLE KEYS */; UNLOCK TABLES; @@ -2016,7 +2020,8 @@ INSERT INTO `updates` VALUES ('2023_06_14_00_auth.sql','BB8A7EB214F4F3632C4F54EA596CB7C8FBA305D5','ARCHIVED','2023-06-14 19:34:24',0), ('2023_11_21_00_auth.sql','146E5E6EF94C5DB78343372A8FDB32B062B80040','RELEASED','2023-11-21 11:24:11',0), ('2024_01_06_00_auth.sql','767D697594D5471B67CC0FDF0D7BB15374116A71','RELEASED','2024-01-06 09:53:51',0), -('2024_01_06_01_auth.sql','3D9E0A906A357877DB8E7B72E0797AB38EF884BC','RELEASED','2024-01-06 11:33:07',0); +('2024_01_06_01_auth.sql','3D9E0A906A357877DB8E7B72E0797AB38EF884BC','RELEASED','2024-01-06 11:33:07',0), +('2024_01_06_02_auth.sql','B14F889C198A4F640A968BAB8A4C262AC61634C7','RELEASED','2024-01-06 12:43:47',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; diff --git a/sql/updates/auth/3.3.5/2024_01_06_02_auth.sql b/sql/updates/auth/3.3.5/2024_01_06_02_auth.sql new file mode 100644 index 00000000000..2e3b0616aa3 --- /dev/null +++ b/sql/updates/auth/3.3.5/2024_01_06_02_auth.sql @@ -0,0 +1,10 @@ +-- +DELETE FROM `rbac_permissions` WHERE `id` IN (884, 885); +INSERT INTO `rbac_permissions` (`id`, `name`) VALUES +(884, "Command: bg start"), +(885, "Command: bg stop"); + +DELETE FROM `rbac_linked_permissions` WHERE `linkedId` IN (884, 885); +INSERT INTO `rbac_linked_permissions` (`id`, `linkedId`) VALUES +(197, 884), +(197, 885); diff --git a/sql/updates/world/3.3.5/2024_01_06_00_world.sql b/sql/updates/world/3.3.5/2024_01_06_00_world.sql new file mode 100644 index 00000000000..57ffdac7986 --- /dev/null +++ b/sql/updates/world/3.3.5/2024_01_06_00_world.sql @@ -0,0 +1,7 @@ +-- +DELETE FROM `trinity_string` WHERE `entry` IN (395, 396); +INSERT INTO `trinity_string` (`entry`,`content_default`) VALUES +(395, '### USAGE: .bg start +Skips battleground preparation time and starts the battle.'), +(396, '### USAGE: .bg stop +Immediately ends the battleground.'); |