Core/Commands: Added a set of commands to manage battle.net accounts

TODO: Ban commands, linking game accounts to battle.net accounts

2 files changed, 33 insertions, 0 deletions

diff --git a/sql/updates/auth/2014_06_08_02_rbac_permissions_434.sql b/sql/updates/auth/2014_06_08_02_rbac_permissions_434.sql
new file mode 100644
index 00000000000..508e1147e9c
--- /dev/null
+++ b/sql/updates/auth/2014_06_08_02_rbac_permissions_434.sql
@@ -0,0 +1,19 @@
+DELETE FROM `rbac_permissions` WHERE `id` IN (207,208,209,210,211,212,213);
+INSERT INTO `rbac_permissions` (`id`, `name`) VALUES
+(207, 'Command: battlenetaccount'),
+(208, 'Command: battlenetaccount create'),
+(209, 'Command: battlenetaccount lock country'),
+(210, 'Command: battlenetaccount lock ip'),
+(211, 'Command: battlenetaccount password'),
+(212, 'Command: battlenetaccount set'),
+(213, 'Command: battlenetaccount set password');
+
+DELETE FROM `rbac_linked_permissions` WHERE `linkedId` IN (207,208,209,210,211,212,213);
+INSERT INTO `rbac_linked_permissions` (`id`, `linkedId`) VALUES
+(199, 207),
+(196, 208),
+(199, 209),
+(199, 210),
+(199, 211),
+(196, 212),
+(196, 213);
diff --git a/sql/updates/world/2014_06_08_00_world_trinity_string_434.sql b/sql/updates/world/2014_06_08_00_world_trinity_string_434.sql
new file mode 100644
index 00000000000..806ff6bd233
--- /dev/null
+++ b/sql/updates/world/2014_06_08_00_world_trinity_string_434.sql
@@ -0,0 +1,14 @@
+DELETE FROM `trinity_string` WHERE `entry`=1029;
+
+INSERT INTO `trinity_string` (`entry`, `content_default`) VALUES
+(1029, 'Account name must contain the @ symbol.');
+
+DELETE FROM `command` WHERE `permission` IN (207,208,209,210,211,212,213);
+INSERT INTO `command` (`name`, `permission`, `help`) VALUES
+('battlenetaccount', 207, 'Syntax: .battlenetaccount $subcommand\r\nType .battlenetaccount to see the list of possible subcommands or .help account set $subcommand to see info on subcommands.'),
+('battlenetaccount create', 208, 'Syntax: .battlenetaccount create $account $password\r\nCreate battle.net account and set password to it. Account must contain the @ symbol.'),
+('battlenetaccount lock country', 209, 'Syntax: .battlenetaccount lock country [on|off]\r\nAllow login to account only from current used Country or remove this requirement.'),
+('battlenetaccount lock ip', 210, 'Syntax: .battlenetaccount lock ip [on|off]\nAllow login to account only from current used IP or remove this requirement.'),
+('battlenetaccount password', 211, 'Syntax: .battlenetaccount password $old_password $new_password $new_password\nChange your account password.'),
+('battlenetaccount set', 212, 'Syntax: .battlenetaccount set $subcommand\nType .battlenetaccount set to see the list of possible subcommands or .help account set $subcommand to see info on subcommands.'),
+('battlenetaccount set password', 213, 'Syntax: .battlenetaccount set password $account $password $password\nSet password for account.');