aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/auth
diff options
context:
space:
mode:
authorForesterDev <forester.manv@gmail.com>2017-10-29 13:15:22 +0400
committerAokromes <Aokromes@users.noreply.github.com>2017-10-29 10:15:22 +0100
commita64d1ec51eb11fd01a26d08a09de3d8d7dd89675 (patch)
treed596fc0956ea1ff59493d5f41d9a789a73be733f /sql/updates/auth
parentbbd339370ed2eea5f12e79a977fd9e0e93543101 (diff)
Core/Quests: implement Quest Greeting (DB table quest_greeting)
* Core/Quests: implement Quest Greetings. Partial port https://github.com/TrinityCore/TrinityCore/commit/22e230ecec1c7ce4eb4daeb60adfa03098271f34
Diffstat (limited to 'sql/updates/auth')
-rw-r--r--sql/updates/auth/3.3.5/2017_10_29_00_auth.sql15
1 files changed, 15 insertions, 0 deletions
diff --git a/sql/updates/auth/3.3.5/2017_10_29_00_auth.sql b/sql/updates/auth/3.3.5/2017_10_29_00_auth.sql
new file mode 100644
index 00000000000..186012cd88e
--- /dev/null
+++ b/sql/updates/auth/3.3.5/2017_10_29_00_auth.sql
@@ -0,0 +1,15 @@
+DELETE FROM `rbac_permissions` WHERE `id` = 843; -- this id does not exist in TDB 335.63
+INSERT INTO `rbac_permissions` (`id`,`name`) VALUES
+(843, 'Command: reload quest_greeting');
+
+DELETE FROM `rbac_linked_permissions` WHERE `linkedId` = 843;
+INSERT INTO `rbac_linked_permissions` (`id`,`linkedId`) VALUES
+(196, 843);
+
+DELETE FROM `rbac_permissions` WHERE `id` = 867;
+INSERT INTO `rbac_permissions` (`id`,`name`) VALUES
+(867, 'Command: reload quest_greeting_locale');
+
+DELETE FROM `rbac_linked_permissions` WHERE `id` = 867;
+INSERT INTO `rbac_linked_permissions` (`id`,`linkedId`) VALUES
+(196, 867);