Hello! These are completely custom made HEIRLOOM SETS (includes offset + weapons) for EACH Class. WoTLK-Based.
An MPQ Editor (Such as Ladik's MPQ Editor)
A DBC Editor (Such as WDBX Editor or Tails)
Common Sense
An SQL Editor (Such as HeidiSQL Or Navicat)
Obviously, your own Server. [1] (This tutorial is made for TrinityCore, you can try with other servers but I'm unaware if it would work the same, I say give er a shot if you want)
DO NOTE:
Entry IDs to ALL Heirlooms are set to 0, ZERO, THAT IS A Z. E. R. O! Why? So you can automatically set the Entry ID yourself.
Weapon Speeds are NOT inputted (Meaning, you will need to manually set the Weapon Speed for Each Weapon. Why? I'm a dumbass, this will probably be fixed whenever I get time...which is rare).
Rings and Necklace DISPLAY IDs are messed up.
GETTING STARTED:
First thing we're going to need you to do is to pull up your SQL Editor and Open to your server's database. You will go into World and apply each .sql file Manually (These SQL Files are located in respective folders, weapons for weapons, Paladin for Paladin Heirlooms, Warrior for Warrior Heirlooms, Offset for Offset, etc.)
As you can see here, Light-Up, (A One-handed sword), is put in the query. Change the Entry ID from 0, to the Entry ID you want, (So if you have 60,000 items, best to start off 61,000.)
After you've entered the Entry ID, you can go ahead and run this query in the SQL. Once it's been ran, you can find the item in your item_template (make sure to click Show All), go down to your Item and find ScalingStatDistribution & ScalingStatValue
The IDs and Values are already listed for you IN the .txt file (List of IDs), each folder has its OWN List of IDs respectively. If you're doing weapons, MAKE SURE to change DMG_MIN1 to from 0 to 1. This is weapons only and to assure they have proper damage.
ScalingStatDistribution is your actual Stats for your Item, ScalingStatValue is how they progress. I showed and explained this on my Custom Heirloom Guide. There you can find different item progressions and how they work. But I've already given you the IDs & Values for it.
In this case, Light-Up's ScalingStatDistribution is 513, this is its ACTUAL Stats. And its ScalingStatValues is, like I said how it progresses. 512 (1-Handed Weapon DPS progression) + 1 (Normal Stat Progression), 513. (If you wanted Boosted Stats it would be 512 + 4, 516)
If you're doing Wands, while you shouldn't need to as they SHOULD already be set, but you can set them here. (I don't know the damage type IDs, nor do I know if it works for non-wand weapons, this site is a good resource to find lots of IDs https://wowdev.wiki/Main_Page)
If you have a Spell you want to put on your Weapon or Armor piece, find spellid_1, and enter your Spell's ID. Then you must change spell_trigger1 to how you want the spell to trigger.
0 - Use
1 - Equip
2 - Chance on Hit
(Correct me if I'm wrong, I know Equip Effects are 1, but I can't remember which is which for the other 2 effects).
After you've done all heirlooms, your next step is to MAKE SURE TO UPDATE YOUR DBCs. In the .rar file, you will find, ScalingStatDistribution.dbc & ScalingStatValues.dbc, replace the ones in the .rar file with your ones in your server's dbc files.
Then there should be a Patch-IA rar file, it should contain Patch-IA.mpq, put this in your DATA folder in your wotlk client. Delete your cache to make sure it refreshes.
TO-DO-LIST:
Add Weapon Speed to all Weapons (so you won't have to manually but feel free to add your own anyways)
Rings and Necklace DISPLAY IDs are messed up.
Forgot Hunter Heirlooms (Thought I made these, but it's not implemented in the slightest)
Add Held-In-Off Hand (These are low priority and for later)
Add Relic/3rd Weapon Slot Heirlooms (Low Priority)
Add Trinkets (Low Priority)
Figure out how to make custom ScalingStatValue (meaning custom progressions to see if I can do multi-weapon dmg types)
Additional Notes:
Weapon Names are based on Songs, I'm terrible at naming so I just did that for fun. They also got quotes.
There's a lot of OLD text files that I kept in there, ignore those, those are just for me. I didn't bother removing it and kept it in the .rar file.
- Warrior:
- Valor - DPS
- Heroism - Tank
- Paladin:
- Lightforge - Ret
- Soulforge - Holy
- Scarlet Protector - Protection
- Hunter:
- Beaststalker Armor - Primary
- Beastmaster Hide - Alt
- Rogue:
- Shadowcraft Armor - Primary
- Darkmantle Equipment - Alternative
- Priest:
- Virtuous - Heal
- Devout - dps
- Death Knight:
- Dreadnaught Plate - Tank
- Blackknight Armor - DPS
- Archerus' Return Battlegear - DPS Alt
- Shaman:
- The Elements - Elementalist
- Five Thunders - Enhancement
- Tidefury - Restoration
- Mage:
- Magister's Regalia - Primary
- Sorcerer's Clothing - Alternative
- Warlock:
- Dreadmist Raiment - Primary
- Deathmist Regalia - Alternative
- Druid:
- Wildheart Raiment - Restoration
- Feralheart Outfit - Balance
- Moonglade Hide - Feral
- Borean Embrace - Feral (Tank)
An MPQ Editor (Such as Ladik's MPQ Editor)
A DBC Editor (Such as WDBX Editor or Tails)
Common Sense
An SQL Editor (Such as HeidiSQL Or Navicat)
Obviously, your own Server. [1] (This tutorial is made for TrinityCore, you can try with other servers but I'm unaware if it would work the same, I say give er a shot if you want)
DO NOTE:
Entry IDs to ALL Heirlooms are set to 0, ZERO, THAT IS A Z. E. R. O! Why? So you can automatically set the Entry ID yourself.
Weapon Speeds are NOT inputted (Meaning, you will need to manually set the Weapon Speed for Each Weapon. Why? I'm a dumbass, this will probably be fixed whenever I get time...which is rare).
Rings and Necklace DISPLAY IDs are messed up.
GETTING STARTED:
First thing we're going to need you to do is to pull up your SQL Editor and Open to your server's database. You will go into World and apply each .sql file Manually (These SQL Files are located in respective folders, weapons for weapons, Paladin for Paladin Heirlooms, Warrior for Warrior Heirlooms, Offset for Offset, etc.)
As you can see here, Light-Up, (A One-handed sword), is put in the query. Change the Entry ID from 0, to the Entry ID you want, (So if you have 60,000 items, best to start off 61,000.)
After you've entered the Entry ID, you can go ahead and run this query in the SQL. Once it's been ran, you can find the item in your item_template (make sure to click Show All), go down to your Item and find ScalingStatDistribution & ScalingStatValue
The IDs and Values are already listed for you IN the .txt file (List of IDs), each folder has its OWN List of IDs respectively. If you're doing weapons, MAKE SURE to change DMG_MIN1 to from 0 to 1. This is weapons only and to assure they have proper damage.
ScalingStatDistribution is your actual Stats for your Item, ScalingStatValue is how they progress. I showed and explained this on my Custom Heirloom Guide. There you can find different item progressions and how they work. But I've already given you the IDs & Values for it.
In this case, Light-Up's ScalingStatDistribution is 513, this is its ACTUAL Stats. And its ScalingStatValues is, like I said how it progresses. 512 (1-Handed Weapon DPS progression) + 1 (Normal Stat Progression), 513. (If you wanted Boosted Stats it would be 512 + 4, 516)
If you're doing Wands, while you shouldn't need to as they SHOULD already be set, but you can set them here. (I don't know the damage type IDs, nor do I know if it works for non-wand weapons, this site is a good resource to find lots of IDs https://wowdev.wiki/Main_Page)
If you have a Spell you want to put on your Weapon or Armor piece, find spellid_1, and enter your Spell's ID. Then you must change spell_trigger1 to how you want the spell to trigger.
0 - Use
1 - Equip
2 - Chance on Hit
(Correct me if I'm wrong, I know Equip Effects are 1, but I can't remember which is which for the other 2 effects).
After you've done all heirlooms, your next step is to MAKE SURE TO UPDATE YOUR DBCs. In the .rar file, you will find, ScalingStatDistribution.dbc & ScalingStatValues.dbc, replace the ones in the .rar file with your ones in your server's dbc files.
Then there should be a Patch-IA rar file, it should contain Patch-IA.mpq, put this in your DATA folder in your wotlk client. Delete your cache to make sure it refreshes.
TO-DO-LIST:
Add Weapon Speed to all Weapons (so you won't have to manually but feel free to add your own anyways)
Rings and Necklace DISPLAY IDs are messed up.
Forgot Hunter Heirlooms (Thought I made these, but it's not implemented in the slightest)
Add Held-In-Off Hand (These are low priority and for later)
Add Relic/3rd Weapon Slot Heirlooms (Low Priority)
Add Trinkets (Low Priority)
Figure out how to make custom ScalingStatValue (meaning custom progressions to see if I can do multi-weapon dmg types)
Additional Notes:
Weapon Names are based on Songs, I'm terrible at naming so I just did that for fun. They also got quotes.
There's a lot of OLD text files that I kept in there, ignore those, those are just for me. I didn't bother removing it and kept it in the .rar file.
