aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorForesterDev <forester.manv@gmail.com>2017-05-26 10:52:56 +0400
committerfunjoker <funjoker109@gmail.com>2020-06-14 23:49:04 +0200
commit7211c6e51d7471cef6c2de6bf1b1bf3711887835 (patch)
tree6dbb91b574fc698e8b1d2342c8a5c69f73d860be /sql
parent3f83c9dd1d409afa5f81dfc2cdcf21cb15b6c06b (diff)
Scripts/Command: implement .debug play music command
Closes #19809 (cherry picked from commit dd4ff1fe5458c89fc1d988fcc6ba5792ee482dcf)
Diffstat (limited to 'sql')
-rw-r--r--sql/base/auth_database.sql3
-rw-r--r--sql/updates/auth/master/2020_05_19_00_auth.sql7
-rw-r--r--sql/updates/world/master/2020_06_14_18_world_2017_05_29_00_world.sql3
3 files changed, 13 insertions, 0 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql
index 5ebb0a579eb..da0258f519b 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -1267,6 +1267,7 @@ INSERT INTO `rbac_linked_permissions` VALUES
(198,316),
(198,317),
(198,318),
+(198,855),
(198,367),
(198,368),
(198,369),
@@ -2084,6 +2085,7 @@ INSERT INTO `rbac_permissions` VALUES
(852,'Command: go offset'),
(853,'Command: .reload conversation_template'),
(854,'Command: .debug conversation'),
+(855,'Command: debug play music'),
(868,'Command: modify power'),
(869,'Command: debug send playerchoice'),
(872,'Command: server debug');
@@ -2331,6 +2333,7 @@ INSERT INTO `updates` VALUES
('2020_03_31_00_auth.sql','BA82A58E95730A397922B6723DA027986E6CD535','RELEASED','2020-03-31 17:00:16',0),
('2020_04_04_00_auth.sql','5F118989A9F8AFA3B2065AB9C2C0BB7D9A0EB97A','RELEASED','2020-04-04 13:23:53',0),
('2020_04_30_00_auth.sql','2FD304B8EF82D529D69287BF22EF061A267F827E','RELEASED','2020-04-30 00:39:29',0),
+('2020_05_19_00_auth.sql','12D9F26538F63546B74793499E8A71BD885E8E5F','RELEASED','2020-05-19 12:00:00',0),
('2020_06_04_00_auth.sql','BA797B558196B1A07F8FF66E5288AD04659CF6AC','RELEASED','2020-06-04 09:57:07',0);
/*!40000 ALTER TABLE `updates` ENABLE KEYS */;
UNLOCK TABLES;
diff --git a/sql/updates/auth/master/2020_05_19_00_auth.sql b/sql/updates/auth/master/2020_05_19_00_auth.sql
new file mode 100644
index 00000000000..7ddeabe630c
--- /dev/null
+++ b/sql/updates/auth/master/2020_05_19_00_auth.sql
@@ -0,0 +1,7 @@
+DELETE FROM `rbac_permissions` WHERE `id` = 855;
+INSERT INTO `rbac_permissions` (`id`,`name`) VALUES
+(855, 'Command: debug play music');
+
+DELETE FROM `rbac_linked_permissions` WHERE `id` = 855;
+INSERT INTO `rbac_linked_permissions` (`id`,`linkedId`) VALUES
+(198, 855);
diff --git a/sql/updates/world/master/2020_06_14_18_world_2017_05_29_00_world.sql b/sql/updates/world/master/2020_06_14_18_world_2017_05_29_00_world.sql
new file mode 100644
index 00000000000..6282e1c7b69
--- /dev/null
+++ b/sql/updates/world/master/2020_06_14_18_world_2017_05_29_00_world.sql
@@ -0,0 +1,3 @@
+DELETE FROM `command` WHERE `name` = 'debug play music';
+INSERT INTO `command` (`name`,`permission`,`help`) VALUES
+('debug play music', 855, 'Syntax: .debug play music #musicId\nPlay music with #musicId.\nMusic will be played only for you. Other players will not hear this.');