aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/auth
diff options
context:
space:
mode:
authorShauren <shauren.trinity@gmail.com>2016-12-18 12:35:27 +0100
committerShauren <shauren.trinity@gmail.com>2016-12-18 12:35:27 +0100
commitb633d61899bbbd723d4c0b2cbc850d5b686be46c (patch)
treed7a79b34779399be1ab823d39572500794038cb8 /sql/updates/auth
parentbc758991140e961ceac46b17b766b0d54b8129fb (diff)
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
Diffstat (limited to 'sql/updates/auth')
-rw-r--r--sql/updates/auth/master/2016_12_18_00_auth.sql7
1 files changed, 7 insertions, 0 deletions
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);