From ea0cd9366289a3cecdc78ed4a69c08fecc55a2c0 Mon Sep 17 00:00:00 2001 From: ariel- Date: Fri, 6 Jan 2017 02:13:27 -0300 Subject: Core/Scripts: added command to move characters across accounts (cherry-picked from f7f865f81803effa17b19ef79762a72fe726b1ac) --- sql/updates/auth/master/2018_12_09_00_auth_2017_01_06_00_auth.sql | 5 +++++ .../world/master/2018_12_09_00_world_2017_01_06_00_world.sql | 7 +++++++ 2 files changed, 12 insertions(+) create mode 100644 sql/updates/auth/master/2018_12_09_00_auth_2017_01_06_00_auth.sql create mode 100644 sql/updates/world/master/2018_12_09_00_world_2017_01_06_00_world.sql (limited to 'sql/updates') 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'); -- cgit v1.2.3