Iv made some custom heirloom sets available for download. These have not all been tested yet but feel free to dive in and mod these with Kiera.
And I have also made this spreadsheet which will hopefully be useful for your own experiments. It also contains the item IDs, simply log in as a gm and .additem 9000 etc. Or add to a custom vendor if you like.
Although there are some limitations as to what can and cannot be made. There are restricted choices with armor scaling. This is only using the game's already existing code and does not require any modding. I have not yet tested everything and if I find anything I will update the download sql. The stats are not too crazy and the max bonus xp is only 25% however you can customize and mod with Kiera to a certain extent.
Instructions.
1.Delete the cache folder in your game client.
2.Shut down the server and back up everything. (relaunch mysql, using heidisql tools >export database as sql tick wotlkarmory >sql export > tick create for database and table. > set data to insert and export. Repeat for wotlkcharacters, wotlklogs, wotlkmangos, wotlkrealmd)
3.select the wotlkmangos database and file > run sql.
4.select the downloaded sqls, all at once if you wish.
5.close heidiesql and launch the auth and wold servers
6.launch game, as a gm use .additem most items are in the 9000s except for only 1 or 2 which had to be a different number or they would not work.
This is untested on Trinitycore but may work ok.
You can now play with an entire 16 slots of heirlooms! No repairs are necessary and always look like a badass.
I have found that some heirloom weapons did not work properly in cmangos. Damage would remain very low. I did include a weapon fix sql but in case I have missed one, change the weapon max damage from 0 to 3 or something. It doesn't seem to scale when it is 0.
Enjoy!
And I have also made this spreadsheet which will hopefully be useful for your own experiments. It also contains the item IDs, simply log in as a gm and .additem 9000 etc. Or add to a custom vendor if you like.
Although there are some limitations as to what can and cannot be made. There are restricted choices with armor scaling. This is only using the game's already existing code and does not require any modding. I have not yet tested everything and if I find anything I will update the download sql. The stats are not too crazy and the max bonus xp is only 25% however you can customize and mod with Kiera to a certain extent.
Instructions.
1.Delete the cache folder in your game client.
2.Shut down the server and back up everything. (relaunch mysql, using heidisql tools >export database as sql tick wotlkarmory >sql export > tick create for database and table. > set data to insert and export. Repeat for wotlkcharacters, wotlklogs, wotlkmangos, wotlkrealmd)
3.select the wotlkmangos database and file > run sql.
4.select the downloaded sqls, all at once if you wish.
5.close heidiesql and launch the auth and wold servers
6.launch game, as a gm use .additem most items are in the 9000s except for only 1 or 2 which had to be a different number or they would not work.
This is untested on Trinitycore but may work ok.
You can now play with an entire 16 slots of heirlooms! No repairs are necessary and always look like a badass.
I have found that some heirloom weapons did not work properly in cmangos. Damage would remain very low. I did include a weapon fix sql but in case I have missed one, change the weapon max damage from 0 to 3 or something. It doesn't seem to scale when it is 0.
Enjoy!
