Core/Player: implemented Heirloom Collection

* implemented all things related to that collection
* you can create heirloom by click on item in collection
* also you can upgrade heirlooms by using specific kits
* old heirlooms are converted to new ones

3 files changed, 110 insertions, 0 deletions

diff --git a/sql/updates/auth/2015_10_16_00_auth.sql b/sql/updates/auth/2015_10_16_00_auth.sql
new file mode 100644
index 00000000000..1efefca6c9a
--- /dev/null
+++ b/sql/updates/auth/2015_10_16_00_auth.sql
@@ -0,0 +1,8 @@
+DROP TABLE IF EXISTS `battlenet_account_heirlooms`;
+
+CREATE TABLE `battlenet_account_heirlooms` (
+  `accountId` int(10) unsigned NOT NULL,
+  `itemId` int(11) unsigned NOT NULL DEFAULT '0',
+  `flags` int(10) unsigned NOT NULL DEFAULT '0',
+  PRIMARY KEY (`accountId`,`itemId`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
diff --git a/sql/updates/characters/2015_10_16_00_characters.sql b/sql/updates/characters/2015_10_16_00_characters.sql
new file mode 100644
index 00000000000..549797fee96
--- /dev/null
+++ b/sql/updates/characters/2015_10_16_00_characters.sql
@@ -0,0 +1,70 @@
+--
+UPDATE `item_instance` SET `itemEntry`=122353 WHERE `itemEntry` IN(42947, 93854);
+UPDATE `item_instance` SET `itemEntry`=122365 WHERE `itemEntry` IN(44092, 93851);
+UPDATE `item_instance` SET `itemEntry`=122363 WHERE `itemEntry` IN(79131, 93844);
+UPDATE `item_instance` SET `itemEntry`=122352 WHERE `itemEntry` IN(42946, 93855);
+UPDATE `item_instance` SET `itemEntry`=122356 WHERE `itemEntry` IN(42950, 93887);
+UPDATE `item_instance` SET `itemEntry`=122349 WHERE `itemEntry` IN(42943, 93843);
+UPDATE `item_instance` SET `itemEntry`=122351 WHERE `itemEntry` IN(42945, 93856);
+UPDATE `item_instance` SET `itemEntry`=122376 WHERE `itemEntry` IN(44103, 93867);
+UPDATE `item_instance` SET `itemEntry`=122355 WHERE `itemEntry` IN(42949, 93890);
+UPDATE `item_instance` SET `itemEntry`=122358 WHERE `itemEntry` IN(42952, 93862);
+UPDATE `item_instance` SET `itemEntry`=122350 WHERE `itemEntry` IN(42944, 93857);
+UPDATE `item_instance` SET `itemEntry`=122359 WHERE `itemEntry` IN(42984, 93864);
+UPDATE `item_instance` SET `itemEntry`=122362 WHERE `itemEntry` IN(42992, 93897);
+UPDATE `item_instance` SET `itemEntry`=122357 WHERE `itemEntry` IN(42951, 93876);
+UPDATE `item_instance` SET `itemEntry`=122360 WHERE `itemEntry` IN(42985, 93859);
+UPDATE `item_instance` SET `itemEntry`=122377 WHERE `itemEntry` IN(44105, 93866);
+UPDATE `item_instance` SET `itemEntry`=122354 WHERE `itemEntry` IN(42948, 93853);
+UPDATE `item_instance` SET `itemEntry`=122364 WHERE `itemEntry` IN(44091, 93852);
+UPDATE `item_instance` SET `itemEntry`=122366 WHERE `itemEntry` IN(44093, 93841);
+UPDATE `item_instance` SET `itemEntry`=122367 WHERE `itemEntry` IN(44094, 93850);
+UPDATE `item_instance` SET `itemEntry`=122370 WHERE `itemEntry` IN(44097, 93898);
+UPDATE `item_instance` SET `itemEntry`=122368 WHERE `itemEntry` IN(44095, 93849);
+UPDATE `item_instance` SET `itemEntry`=122369 WHERE `itemEntry` IN(44096, 93848);
+UPDATE `item_instance` SET `itemEntry`=122361 WHERE `itemEntry` IN(42991, 93896);
+UPDATE `item_instance` SET `itemEntry`=122378 WHERE `itemEntry` IN(44107, 93861);
+UPDATE `item_instance` SET `itemEntry`=122372 WHERE `itemEntry` IN(44099, 93895);
+UPDATE `item_instance` SET `itemEntry`=122373 WHERE `itemEntry` IN(44100, 93894);
+UPDATE `item_instance` SET `itemEntry`=122374 WHERE `itemEntry` IN(44101, 93886);
+UPDATE `item_instance` SET `itemEntry`=122375 WHERE `itemEntry` IN(44102, 93889);
+UPDATE `item_instance` SET `itemEntry`=122371 WHERE `itemEntry` IN(44098, 93899);
+UPDATE `item_instance` SET `itemEntry`=122529 WHERE `itemEntry` IN(50255);
+UPDATE `item_instance` SET `itemEntry`=122384 WHERE `itemEntry` IN(48691, 93860);
+UPDATE `item_instance` SET `itemEntry`=122382 WHERE `itemEntry` IN(48687, 93865);
+UPDATE `item_instance` SET `itemEntry`=122383 WHERE `itemEntry` IN(48689, 93863);
+UPDATE `item_instance` SET `itemEntry`=122380 WHERE `itemEntry` IN(48683, 93885);
+UPDATE `item_instance` SET `itemEntry`=122381 WHERE `itemEntry` IN(48685, 93891);
+UPDATE `item_instance` SET `itemEntry`=122386 WHERE `itemEntry` IN(48718, 93846);
+UPDATE `item_instance` SET `itemEntry`=122385 WHERE `itemEntry` IN(48716, 93847);
+UPDATE `item_instance` SET `itemEntry`=122379 WHERE `itemEntry` IN(48677, 93888);
+UPDATE `item_instance` SET `itemEntry`=122261 WHERE `itemEntry` IN(62039);
+UPDATE `item_instance` SET `itemEntry`=122262 WHERE `itemEntry` IN(62040);
+UPDATE `item_instance` SET `itemEntry`=122260 WHERE `itemEntry` IN(62038);
+UPDATE `item_instance` SET `itemEntry`=122255 WHERE `itemEntry` IN(62027);
+UPDATE `item_instance` SET `itemEntry`=122251 WHERE `itemEntry` IN(62023);
+UPDATE `item_instance` SET `itemEntry`=122252 WHERE `itemEntry` IN(62024);
+UPDATE `item_instance` SET `itemEntry`=122253 WHERE `itemEntry` IN(62025);
+UPDATE `item_instance` SET `itemEntry`=122254 WHERE `itemEntry` IN(62026);
+UPDATE `item_instance` SET `itemEntry`=122245 WHERE `itemEntry` IN(61931);
+UPDATE `item_instance` SET `itemEntry`=122256 WHERE `itemEntry` IN(62029);
+UPDATE `item_instance` SET `itemEntry`=122249 WHERE `itemEntry` IN(61942);
+UPDATE `item_instance` SET `itemEntry`=122250 WHERE `itemEntry` IN(61958);
+UPDATE `item_instance` SET `itemEntry`=122248 WHERE `itemEntry` IN(61937);
+UPDATE `item_instance` SET `itemEntry`=122246 WHERE `itemEntry` IN(61935);
+UPDATE `item_instance` SET `itemEntry`=122247 WHERE `itemEntry` IN(61936);
+UPDATE `item_instance` SET `itemEntry`=122263 WHERE `itemEntry` IN(69887);
+UPDATE `item_instance` SET `itemEntry`=122264 WHERE `itemEntry` IN(69888);
+UPDATE `item_instance` SET `itemEntry`=122387 WHERE `itemEntry` IN(69889, 93892);
+UPDATE `item_instance` SET `itemEntry`=122388 WHERE `itemEntry` IN(69890, 93893);
+UPDATE `item_instance` SET `itemEntry`=122389 WHERE `itemEntry` IN(69893, 93845);
+UPDATE `item_instance` SET `itemEntry`=122266 WHERE `itemEntry` IN(69892);
+UPDATE `item_instance` SET `itemEntry`=122392 WHERE `itemEntry` IN(93903);
+UPDATE `item_instance` SET `itemEntry`=122396 WHERE `itemEntry` IN(92948, 93858);
+UPDATE `item_instance` SET `itemEntry`=122390 WHERE `itemEntry` IN(93904);
+UPDATE `item_instance` SET `itemEntry`=122530 WHERE `itemEntry` IN(93900);
+UPDATE `item_instance` SET `itemEntry`=122391 WHERE `itemEntry` IN(93902);
+UPDATE `item_instance` SET `itemEntry`=128173 WHERE `itemEntry` IN(44102, 93889);
+UPDATE `item_instance` SET `itemEntry`=128169 WHERE `itemEntry` IN(44102, 93889);
+UPDATE `item_instance` SET `itemEntry`=128172 WHERE `itemEntry` IN(44102, 93889);
+UPDATE `item_instance` SET `itemEntry`=128318 WHERE `itemEntry` IN(42992);
diff --git a/sql/updates/hotfixes/2015_10_16_00_hotfixes.sql b/sql/updates/hotfixes/2015_10_16_00_hotfixes.sql
new file mode 100644
index 00000000000..de01e908d49
--- /dev/null
+++ b/sql/updates/hotfixes/2015_10_16_00_hotfixes.sql
@@ -0,0 +1,32 @@
+DROP TABLE IF EXISTS `heirloom`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `heirloom` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `ItemID` int(10) unsigned NOT NULL DEFAULT '0',
+  `Flags` int(10) unsigned NOT NULL DEFAULT '0',
+  `SourceText` text,
+  `Source` int(10) unsigned NOT NULL DEFAULT '0',
+  `OldItem1` int(10) unsigned NOT NULL DEFAULT '0',
+  `OldItem2` int(10) unsigned NOT NULL DEFAULT '0',
+  `NextDifficultyItemID` int(10) unsigned NOT NULL DEFAULT '0',
+  `UpgradeItemID1` int(10) unsigned NOT NULL DEFAULT '0',
+  `UpgradeItemID2` int(10) unsigned NOT NULL DEFAULT '0',
+  `ItemBonusListID1` int(10) unsigned NOT NULL DEFAULT '0',
+  `ItemBonusListID2` int(10) unsigned NOT NULL DEFAULT '0',
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+DROP TABLE IF EXISTS `heirloom_locale`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `heirloom_locale` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `locale` varchar(4) NOT NULL,
+  `SourceText_lang` text,
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`,`locale`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;