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

2 files changed, 16 insertions, 0 deletions

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.');