Heirloom and Custom Spell Text

[lilkid91]

Hey there! Today I'll be teaching you how to make "Heirloom" items. COMMENT YOU LLEECHERS!! :O

First, what you'll need is:
Database access - Items
Navicat

Alright first, you'll need the item you are changing to a heirloom in Navicat. (Or your sql thing...)

Now find the field StatScalingDistribution, and StatScalingValue.
Put under [ StatScalingDistribution | 1] (for strength stamina and critical as your primary stats on it.)
And for [ statscalingvalue | 1 - 1000 ] for different types. I don't know I haven't finished my list yet.
Umm... thats about it for that; I'm not good at this.

Custom Spell Text

Finally! Custom spell text that really doesn't do anything but teach you a spell.
Put under [Spellid_1 | 55884] [spelltrigger_1 | 1]
Now under [ Spellid_2 | 1 ] [ Spelltrigger_2 | 6 ]
Put an unknown, the spell won't do anything.

Having problems making heirlooms? This isn't needed but try to change flags to [Flags | 134221824]

The quote is the spell text. :P
Credit: Konata, Pholopalus/Yyx
Special thanks: Echeloned! and my cat.

List:
StatValue 1: typical blue stats for your distribution.
Statvalue 1000: 120 dps for weapon. Shows 0 armor though.
<HERE BEYOND ARE BEING TESTED>
--------------------------------------- 306
--------------------------------------- 305
--------------------------------------- 304
--------------------------------------- 303
--------------------------------------- 302
--------------------------------------- 301
--------------------------------------- 300
--------------------------------------- 299
--------------------------------------- 298
--------------------------------------- 297
--------------------------------------- 296
--------------------------------------- 294
--------------------------------------- 293
--------------------------------------- 292
------------------------------------------------------------------
Statdistribution 1: Strength, Stamina, and Critical Strike rating.
Statdistribution 2: Agility, Hit rating and attack power. (I think)
<Here Beyond is being tested>
------------------------------------ 33
------------------------------------ 65
------------------------------------ 129
------------------------------------ 257
------------------------------------ 2
------------------------------------ 516
------------------------------------ 32767
------------------------------------ 8208
------------------------------------ 1032
------------------------------------ 516

(Will put in stat values for those later.)

This was a total copy of a Private Server forum, echelonedwow.net

I am just sharing this. I take no credit.. AT ALL!!!!!!!!!!!!!

This is for Mangos item DB.. If you are handy dandy with DB, you will find what to do for ascent yourself. Good Luck!

[2dgreengiant]

Moved to the correct section