From bf0ae32d189d4579920e027f9d2dbfacc5552df3 Mon Sep 17 00:00:00 2001 From: Shauren Date: Sat, 11 Nov 2017 22:41:05 +0100 Subject: Core/Commands: Added .modify power command allowing to change any power as long as player class can use it * Power names are taken from PowerType.db2 (lowercase, using _ is optional) Closes #20833 --- sql/updates/auth/master/2017_11_11_01_auth.sql | 7 +++++++ sql/updates/world/master/2017_11_11_10_world.sql | 9 +++++++++ 2 files changed, 16 insertions(+) create mode 100644 sql/updates/auth/master/2017_11_11_01_auth.sql create mode 100644 sql/updates/world/master/2017_11_11_10_world.sql (limited to 'sql/updates') diff --git a/sql/updates/auth/master/2017_11_11_01_auth.sql b/sql/updates/auth/master/2017_11_11_01_auth.sql new file mode 100644 index 00000000000..e046cca6bdc --- /dev/null +++ b/sql/updates/auth/master/2017_11_11_01_auth.sql @@ -0,0 +1,7 @@ +-- +DELETE FROM `rbac_permissions` WHERE `id`=867; +INSERT INTO `rbac_permissions` (`id`, `name`) VALUES +(867, 'Command: modify power'); + +DELETE FROM `rbac_linked_permissions` WHERE `id`=198 AND `linkedId`=867; +INSERT INTO `rbac_linked_permissions` (`id`, `linkedId`) VALUES (198, 867); diff --git a/sql/updates/world/master/2017_11_11_10_world.sql b/sql/updates/world/master/2017_11_11_10_world.sql new file mode 100644 index 00000000000..35bb932f320 --- /dev/null +++ b/sql/updates/world/master/2017_11_11_10_world.sql @@ -0,0 +1,9 @@ +DELETE FROM `trinity_string` WHERE `entry` IN (11019,11020,11021); +INSERT INTO `trinity_string` (`entry`,`content_default`,`content_loc1`,`content_loc2`,`content_loc3`,`content_loc4`,`content_loc5`,`content_loc6`,`content_loc7`,`content_loc8`) VALUES +(11019, 'You changed %s of %s to %d/%d.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), +(11020, '%s changed your %s to %d/%d.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), +(11021, 'Invalid power name.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); + +DELETE FROM `command` WHERE `name`='modify power' and `permission`= 867; +INSERT INTO `command` (`name`, `permission`, `help`) VALUES +('modify power', 867, 'Syntax: .modify power #powerType #amount \r\n\r\nModify the power of the selected player. If no player is selected, modify your power.'); -- cgit v1.2.3