aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorr4dish <ovitnez@gmail.com>2024-01-06 12:51:24 +0200
committerShauren <shauren.trinity@gmail.com>2024-01-06 23:43:59 +0100
commitc2831bafded61dcd417535a444c2dfbb454171bb (patch)
tree2b48e27af6cbd5d7c99f974c7022f5047f3d995a /sql/updates
parent554fc8eee0bcbb70acd012c04f6f02197c6d949c (diff)
Scripts/Commands: Implemented .bg start and .bg stop commands.
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/auth/3.3.5/2024_01_06_02_auth.sql10
-rw-r--r--sql/updates/world/3.3.5/2024_01_06_00_world.sql7
2 files changed, 17 insertions, 0 deletions
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.');