From b633d61899bbbd723d4c0b2cbc850d5b686be46c Mon Sep 17 00:00:00 2001 From: Shauren Date: Sun, 18 Dec 2016 12:35:27 +0100 Subject: Core/Commands: Added new 'bnetaccount listgameaccounts' command to display all `account` table entries linked to a given battle.net email * Also fixed errors about bad commands in db Closes #18474 --- sql/updates/auth/master/2016_12_18_00_auth.sql | 7 +++++++ sql/updates/world/master/2016_12_18_00_world.sql | 12 ++++++++++++ 2 files changed, 19 insertions(+) create mode 100644 sql/updates/auth/master/2016_12_18_00_auth.sql create mode 100644 sql/updates/world/master/2016_12_18_00_world.sql (limited to 'sql/updates') diff --git a/sql/updates/auth/master/2016_12_18_00_auth.sql b/sql/updates/auth/master/2016_12_18_00_auth.sql new file mode 100644 index 00000000000..2a513fcd146 --- /dev/null +++ b/sql/updates/auth/master/2016_12_18_00_auth.sql @@ -0,0 +1,7 @@ +DELETE FROM `rbac_permissions` WHERE `id`=830; +INSERT INTO `rbac_permissions` (`id`,`name`) VALUES +(830,'Command: .bnetaccount listgameaccounts'); + +DELETE FROM `rbac_linked_permissions` WHERE `id`=196 AND `linkedId`=830; +INSERT INTO `rbac_linked_permissions` (`id`, `linkedId`) VALUES +(196, 830); diff --git a/sql/updates/world/master/2016_12_18_00_world.sql b/sql/updates/world/master/2016_12_18_00_world.sql new file mode 100644 index 00000000000..8aa931c5d2b --- /dev/null +++ b/sql/updates/world/master/2016_12_18_00_world.sql @@ -0,0 +1,12 @@ +DELETE FROM `command` WHERE `name`='bnetaccount listgameaccounts'; +INSERT INTO `command` (`name`,`permission`,`help`) VALUES +('bnetaccount listgameaccounts', 830, 'Syntax: .bnetaccount listgameaccounts $email $password\nLists all game accounts linked to battle.net $email'); + +DELETE FROM `trinity_string` WHERE `entry` IN (1034,1035); +INSERT INTO `trinity_string` (`entry`,`content_default`) VALUES +(1034, '| Account Id | Internal name | Display name |'), +(1035, 'Battle.net account %s has no linked game accounts.'); + +-- fix bad entries +UPDATE `command` SET `name`='scene playpackage',`help`='Syntax: .scene playpackage #scenePackageId #playbackFlags\nPlays scene with package id and playback flags for targeted player' WHERE `name`='scene play package'; +UPDATE `command` SET `name`='reload scene_template',`help`='Syntax: .reload scene_template\nReload scene_template table.' WHERE `name`='reload scenes'; -- cgit v1.2.3