aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorariel- <ariel-@users.noreply.github.com>2017-01-06 02:13:27 -0300
committerariel- <ariel-@users.noreply.github.com>2017-01-06 02:34:52 -0300
commitf7f865f81803effa17b19ef79762a72fe726b1ac (patch)
treef91afd183510df8e7584fbeb14e4659042bf2e2b /sql/updates
parent829deec2bdda228cbf0144bfe7c639a1c1c0ee09 (diff)
Core/Scripts: added command to move characters across accounts
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/auth/3.3.5/2017_01_06_00_auth.sql5
-rw-r--r--sql/updates/world/3.3.5/2017_01_06_00_world.sql7
2 files changed, 12 insertions, 0 deletions
diff --git a/sql/updates/auth/3.3.5/2017_01_06_00_auth.sql b/sql/updates/auth/3.3.5/2017_01_06_00_auth.sql
new file mode 100644
index 00000000000..0def4608ca2
--- /dev/null
+++ b/sql/updates/auth/3.3.5/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/3.3.5/2017_01_06_00_world.sql b/sql/updates/world/3.3.5/2017_01_06_00_world.sql
new file mode 100644
index 00000000000..61a7c137261
--- /dev/null
+++ b/sql/updates/world/3.3.5/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`=1184;
+INSERT INTO `trinity_string` (`entry`, `content_default`) VALUES
+(1184, 'Successfully transferred ownership of character %s to account %s');