Core/Quests: implement Quest Greeting (DB table quest_greeting)

* Core/Quests: implement Quest Greetings. Partial port https://github.com/TrinityCore/TrinityCore/commit/22e230ecec1c7ce4eb4daeb60adfa03098271f34

2 files changed, 43 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);
diff --git a/sql/updates/world/3.3.5/2017_10_29_01_world_335.sql b/sql/updates/world/3.3.5/2017_10_29_01_world_335.sql
new file mode 100644
index 00000000000..466fc840efa
--- /dev/null
+++ b/sql/updates/world/3.3.5/2017_10_29_01_world_335.sql
@@ -0,0 +1,28 @@
+DELETE FROM `command` WHERE `name`='reload quest_greeting';
+INSERT INTO `command` (`name`, `permission`, `help`) VALUES
+('reload quest_greeting', 843, 'Syntax: .reload quest_greeting\nReload quest_greeting table.');
+
+DELETE FROM `command` WHERE `name`='reload quest_greeting_locale';
+INSERT INTO `command` (`name`, `permission`, `help`) VALUES
+('reload quest_greeting_locale', 867, 'Syntax: .reload quest_greeting_locale\nReload quest_greeting_locale table.');
+
+DROP TABLE IF EXISTS `quest_greeting`;
+CREATE TABLE `quest_greeting` (
+  `ID` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
+  `Type` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
+  `GreetEmoteType` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
+  `GreetEmoteDelay` INT(10) UNSIGNED NOT NULL DEFAULT '0',
+  `Greeting` TEXT,
+  `VerifiedBuild` SMALLINT(5) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`,`Type`)
+) ENGINE=MYISAM DEFAULT CHARSET=utf8;
+
+DROP TABLE IF EXISTS `quest_greeting_locale`;
+CREATE TABLE `quest_greeting_locale` (
+  `ID` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
+  `Type` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
+  `locale` VARCHAR(4) NOT NULL,
+  `Greeting` TEXT,
+  `VerifiedBuild` SMALLINT(5) DEFAULT '0',
+  PRIMARY KEY (`ID`,`Type`)
+) ENGINE=MYISAM DEFAULT CHARSET=utf8;