Core/Players: Implement basics for the honor system

Closes #18480
Closes #19277

2 files changed, 73 insertions, 0 deletions

diff --git a/sql/updates/characters/master/2017_06_04_00_characters.sql b/sql/updates/characters/master/2017_06_04_00_characters.sql
new file mode 100644
index 00000000000..30f85396e24
--- /dev/null
+++ b/sql/updates/characters/master/2017_06_04_00_characters.sql
@@ -0,0 +1,6 @@
+ALTER TABLE `characters`
+  ADD `honor` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `deleteDate`,
+  ADD `honorLevel` INT(10) UNSIGNED NOT NULL DEFAULT '1' AFTER `honor`,
+  ADD `prestigeLevel` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `honorLevel`,
+  ADD `honorRestState` TINYINT UNSIGNED NOT NULL DEFAULT '2' AFTER `prestigeLevel`,
+  ADD `honorRestBonus` FLOAT NOT NULL DEFAULT '0' AFTER `honorRestState`;
diff --git a/sql/updates/hotfixes/master/2017_06_04_00_hotfixes.sql b/sql/updates/hotfixes/master/2017_06_04_00_hotfixes.sql
new file mode 100644
index 00000000000..2a8e08c01b4
--- /dev/null
+++ b/sql/updates/hotfixes/master/2017_06_04_00_hotfixes.sql
@@ -0,0 +1,67 @@
+--
+-- Table structure for table `pvp_reward`
+--
+DROP TABLE IF EXISTS `pvp_reward`;
+CREATE TABLE `pvp_reward` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `HonorLevel` int(10) unsigned NOT NULL DEFAULT '0',
+  `Prestige` int(10) unsigned NOT NULL DEFAULT '0',
+  `RewardPackID` int(10) unsigned NOT NULL DEFAULT '0',
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+--
+-- Table structure for table `prestige_level_info`
+--
+DROP TABLE IF EXISTS `prestige_level_info`;
+CREATE TABLE `prestige_level_info` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `IconID` int(10) unsigned NOT NULL DEFAULT '0',
+  `PrestigeText` text,
+  `PrestigeLevel` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `Flags` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+--
+-- Table structure for table `prestige_level_info_locale`
+--
+DROP TABLE IF EXISTS `prestige_level_info_locale`;
+CREATE TABLE `prestige_level_info_locale` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `locale` varchar(4) NOT NULL,
+  `PrestigeText_lang` text,
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`,`locale`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+--
+-- Table structure for table `reward_pack`
+--
+DROP TABLE IF EXISTS `reward_pack`;
+CREATE TABLE `reward_pack` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `Money` int(10) unsigned NOT NULL DEFAULT '0',
+  `ArtifactXPMultiplier` float NOT NULL DEFAULT '0',
+  `ArtifactXPDifficulty` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `ArtifactCategoryID` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `TitleID` int(10) unsigned NOT NULL DEFAULT '0',
+  `Unused` int(10) unsigned NOT NULL DEFAULT '0',
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+--
+-- Table structure for table `reward_pack_x_item`
+--
+DROP TABLE IF EXISTS `reward_pack_x_item`;
+CREATE TABLE `reward_pack_x_item` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `ItemID` int(10) unsigned NOT NULL DEFAULT '0',
+  `RewardPackID` int(10) unsigned NOT NULL DEFAULT '0',
+  `Amount` int(10) unsigned NOT NULL DEFAULT '0',
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;