diff options
| author | ariel- <ariel-@users.noreply.github.com> | 2017-01-06 02:13:27 -0300 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2018-12-09 14:18:42 +0100 |
| commit | ea0cd9366289a3cecdc78ed4a69c08fecc55a2c0 (patch) | |
| tree | 21dc4ca6b10a015452b39000761dae4c68b3d272 /sql | |
| parent | b5174339aec22f1d2c1ec3f2615eeb13d0f06b34 (diff) | |
Core/Scripts: added command to move characters across accounts
(cherry-picked from f7f865f81803effa17b19ef79762a72fe726b1ac)
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/base/auth_database.sql | 5 | ||||
| -rw-r--r-- | sql/updates/auth/master/2018_12_09_00_auth_2017_01_06_00_auth.sql | 5 | ||||
| -rw-r--r-- | sql/updates/world/master/2018_12_09_00_world_2017_01_06_00_world.sql | 7 |
3 files changed, 15 insertions, 2 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql index 211d7baaa29..b3626081523 100644 --- a/sql/base/auth_database.sql +++ b/sql/base/auth_database.sql @@ -1888,7 +1888,7 @@ INSERT INTO `rbac_permissions` VALUES (695,'Command: reload spell_loot_template'), (696,'Command: reload spell_linked_spell'), (697,'Command: reload spell_pet_auras'), -(698,'Command: reload spell_proc_event'), +(698,'Command: character changeaccount'), (699,'Command: reload spell_proc'), (700,'Command: reload spell_scripts'), (701,'Command: reload spell_target_position'), @@ -2242,7 +2242,8 @@ INSERT INTO `updates` VALUES ('2018_05_24_00_auth.sql','B98FD71AAA13810856729E034E6B8C9F8D5D4F6B','RELEASED','2018-05-24 22:32:49',0), ('2018_06_14_00_auth.sql','67EAB915BF0C7F2D410BE45F885A1A39D42C8C14','RELEASED','2018-06-14 23:06:59',0), ('2018_06_22_00_auth.sql','9DA24F70B8A365AFDEF58A9B578255CDEDFCA47C','RELEASED','2018-06-22 17:45:45',0), -('2018_06_29_00_auth.sql','03AAEA7E52848FA5522C3F0C6D9C38B988407480','RELEASED','2018-06-29 22:34:04',0); +('2018_06_29_00_auth.sql','03AAEA7E52848FA5522C3F0C6D9C38B988407480','RELEASED','2018-06-29 22:34:04',0), +('2018_12_09_00_auth_2017_01_06_00_auth.sql','6CCFE6A9774EC733C9863D36A0F15F3534189BBD','RELEASED','2018-11-22 22:21:26',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; 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'); |