diff options
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/auth/master/2016_12_18_00_auth.sql | 7 | ||||
| -rw-r--r-- | sql/updates/world/master/2016_12_18_00_world.sql | 12 |
2 files changed, 19 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); 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'; |