Core/Creatures: Rewrite trainer handling to properly support multiple trainers on the same creature

* Trainers are now defined as templates (sniffable), assigned by gossip options

1 files changed, 104 insertions, 0 deletions

diff --git a/sql/updates/world/master/2017_07_26_00_world.sql b/sql/updates/world/master/2017_07_26_00_world.sql
new file mode 100644
index 00000000000..5e00c950a7b
--- /dev/null
+++ b/sql/updates/world/master/2017_07_26_00_world.sql
@@ -0,0 +1,104 @@
+--
+-- Table structure for table `gossip_menu_option_action`
+--
+DROP TABLE IF EXISTS `gossip_menu_option_action`;
+CREATE TABLE `gossip_menu_option_action` (
+  `MenuId` int(11) UNSIGNED NOT NULL DEFAULT '0',
+  `OptionIndex` int(11) UNSIGNED NOT NULL DEFAULT '0',
+  `ActionMenuId` int(11) UNSIGNED NOT NULL DEFAULT '0',
+  `ActionPoiId` int(11) UNSIGNED NOT NULL DEFAULT '0',
+  PRIMARY KEY (`MenuId`,`OptionIndex`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+ 
+--
+-- Table structure for table `gossip_menu_option_box`
+--
+DROP TABLE IF EXISTS `gossip_menu_option_box`;
+CREATE TABLE `gossip_menu_option_box` (
+  `MenuId` int(11) UNSIGNED NOT NULL DEFAULT '0',
+  `OptionIndex` int(11) UNSIGNED NOT NULL DEFAULT '0',
+  `BoxCoded` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
+  `BoxMoney` int(11) UNSIGNED NOT NULL DEFAULT '0',
+  `BoxText` text,
+  `BoxBroadcastTextId` int(11) UNSIGNED NOT NULL DEFAULT '0',
+  PRIMARY KEY (`MenuId`,`OptionIndex`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+--
+-- Table structure for table `gossip_menu_option_trainer`
+--
+DROP TABLE IF EXISTS `gossip_menu_option_trainer`;
+CREATE TABLE `gossip_menu_option_trainer` (
+  `MenuId` int(11) UNSIGNED NOT NULL DEFAULT '0',
+  `OptionIndex` int(11) UNSIGNED NOT NULL DEFAULT '0',
+  `TrainerId` int(11) UNSIGNED NOT NULL DEFAULT '0',
+  PRIMARY KEY (`MenuId`,`OptionIndex`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+ 
+INSERT INTO `gossip_menu_option_action` SELECT `menu_id`,`id`,`action_menu_id`,`action_poi_id` FROM `gossip_menu_option` WHERE `action_menu_id`!=0 OR `action_poi_id`!=0;
+INSERT INTO `gossip_menu_option_box` SELECT `menu_id`,`id`,`box_coded`,`box_money`,`box_text`,`BoxBroadcastTextID` FROM `gossip_menu_option` WHERE `box_coded`!=0 OR `box_money`!=0 OR LENGTH(`box_text`)>0;
+
+ALTER TABLE `gossip_menu_option` DROP PRIMARY KEY;
+ALTER TABLE `gossip_menu_option`
+  CHANGE `menu_id` `MenuId` int(11) UNSIGNED NOT NULL DEFAULT '0' FIRST,
+  CHANGE `id` `OptionIndex` int(11) UNSIGNED NOT NULL DEFAULT '0' AFTER `MenuId`,
+  CHANGE `option_icon` `OptionIcon` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' AFTER `OptionIndex`,
+  CHANGE `option_text` `OptionText` text AFTER `OptionIcon`,
+  CHANGE `OptionBroadcastTextID` `OptionBroadcastTextId` int(11) UNSIGNED NOT NULL DEFAULT '0' AFTER `OptionText`,
+  CHANGE `option_id` `OptionType` int(11) UNSIGNED NOT NULL DEFAULT '0' AFTER `OptionBroadcastTextId`,
+  CHANGE `npc_option_npcflag` `OptionNpcflag` bigint(20) UNSIGNED NOT NULL DEFAULT '0' AFTER `OptionType`,
+  DROP `action_menu_id`,
+  DROP `action_poi_id`,
+  DROP `box_coded`,
+  DROP `box_money`,
+  DROP `box_text`,
+  DROP `BoxBroadcastTextID`;
+ALTER TABLE `gossip_menu_option` ADD PRIMARY KEY (`MenuId`,`OptionIndex`);
+
+--
+-- Table structure for table `trainer`
+--
+DROP TABLE IF EXISTS `trainer`;
+CREATE TABLE `trainer` (
+  `Id` int(10) UNSIGNED NOT NULL DEFAULT '0',
+  `Type` tinyint(2) UNSIGNED NOT NULL DEFAULT '2',
+  `Greeting` TEXT,
+  `VerifiedBuild` SMALLINT (5) DEFAULT '0',
+  PRIMARY KEY (`Id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+ 
+--
+-- Table structure for table `trainer_locale`
+--
+DROP TABLE IF EXISTS `trainer_locale`;
+CREATE TABLE `trainer_locale` (
+  `Id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
+  `locale` VARCHAR(4) NOT NULL,
+  `Greeting_lang` text,
+  `VerifiedBuild` SMALLINT(5) DEFAULT '0',
+  PRIMARY KEY (`Id`,`locale`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+ 
+--
+-- Table structure for table `trainer_spell`
+--
+DROP TABLE IF EXISTS `trainer_spell`;
+CREATE TABLE `trainer_spell` (
+  `TrainerId` int(10) UNSIGNED NOT NULL DEFAULT '0',
+  `SpellId` int(10) UNSIGNED NOT NULL DEFAULT '0',
+  `MoneyCost` int(10) UNSIGNED NOT NULL DEFAULT '0',
+  `ReqSkillLine` int(10) UNSIGNED NOT NULL DEFAULT '0',
+  `ReqSkillRank` int(10) UNSIGNED NOT NULL DEFAULT '0',
+  `ReqAbility1` int(10) UNSIGNED NOT NULL DEFAULT '0',
+  `ReqAbility2` int(10) UNSIGNED NOT NULL DEFAULT '0',
+  `ReqAbility3` int(10) UNSIGNED NOT NULL DEFAULT '0',
+  `ReqLevel` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
+  `VerifiedBuild` SMALLINT (5) DEFAULT '0',
+  PRIMARY KEY (`TrainerId`,`SpellId`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+DROP TABLE IF EXISTS `npc_trainer`;
+
+DELETE FROM `command` WHERE `name` IN ('reload npc_trainer','reload trainer');
+INSERT INTO `command` (`name`,`permission`,`help`) VALUES
+('reload trainer', 672, 'Syntax: .reload trainer\nReloads trainer, trainer_locale and trainer_spell tables.');