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

1 files changed, 70 insertions, 0 deletions

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);