Core/Scripts: added command to move characters across accounts

(cherry-picked from f7f865f81803effa17b19ef79762a72fe726b1ac)

2 files changed, 12 insertions, 0 deletions

diff --git a/sql/updates/auth/master/2018_12_09_00_auth_2017_01_06_00_auth.sql b/sql/updates/auth/master/2018_12_09_00_auth_2017_01_06_00_auth.sql
new file mode 100644
index 00000000000..0def4608ca2
--- /dev/null
+++ b/sql/updates/auth/master/2018_12_09_00_auth_2017_01_06_00_auth.sql
@@ -0,0 +1,5 @@
+DELETE FROM `rbac_permissions` WHERE `id`=698;
+INSERT INTO `rbac_permissions` (`id`, `name`) VALUES
+(698, 'Command: character changeaccount');
+INSERT INTO `rbac_linked_permissions` (`id`, `linkedId`) VALUES
+(196, 698);
diff --git a/sql/updates/world/master/2018_12_09_00_world_2017_01_06_00_world.sql b/sql/updates/world/master/2018_12_09_00_world_2017_01_06_00_world.sql
new file mode 100644
index 00000000000..90a47b39b3a
--- /dev/null
+++ b/sql/updates/world/master/2018_12_09_00_world_2017_01_06_00_world.sql
@@ -0,0 +1,7 @@
+DELETE FROM `command` WHERE `permission`=698;
+INSERT INTO `command` (`name`, `permission`, `help`) VALUES
+('character changeaccount', 698, 'Syntax: .character changeaccount [$player] $account\n\nTransfers ownership of named (or selected) character to another account');
+
+DELETE FROM `trinity_string` WHERE `entry`=1192;
+INSERT INTO `trinity_string` (`entry`, `content_default`) VALUES
+(1192, 'Successfully transferred ownership of character %s to account %s');