Question - Stat Type ID's

[fosterboy123]

hey guys,

firstly, thanks for looking!

Ok here goes, i run a private server with a few friends, nothing major. running the latest ultracore repack v6, which is amazing btw. im using funserver config atm and i have managed to make some pretty awesome custom weapons using the slots pryd left for people to mess with, however, in the sql, the area you edit the stats in, there is a column for stat_type and a column for stat_value, value is obvious and atm ive just being experimenting with different stat_type values, between str/sta/csr etc, however i wondered if somebody knew where abouts i could find a list of the stat_type value/corresponding stat if there was one, as it would make things a lot easier. no problem if not, and thanks for reading.

sorry if the english is sloppy, i am english, however i am also on complete brain shutdown from sleep deprivation, so now im going to get some shut eye.

Thanks!

[Elidan0]

i don't have a list of stat IDs, but what i do have is a link to wow-v where you can make anything from items, to NPC's, to loot, to graveyards, all with really easy to use tools.

[shadowknight513]

i don't have a list of stat IDs, but what i do have is a link to wow-v where you can make anything from items, to NPC's, to loot, to graveyards, all with really easy to use tools.

Yup, just what I was about to say.

[fosterboy123]

holy crap, amazing website. thanks!

i assume i use mangos sql batch, however, the npc creator doesnt work, gives me errors.

do the structures differ in creature_template between mangos and trinitycore?

cheers!

[Elidan0]

you are using Trinity, right? well then i have some bad news for you, read here, but if you and mabey some other trinity using people gather up the data needed then you and all trinity users will have trinity support, it has been done for a core before, i don't remember which one though.

[Ab3n]

Just in case anyone else wondered or you didn't get the results you were looking for, here's a list:

• Agility = 3
• Strength = 4
• Intellect = 5
• Spirit = 6
• Stamina = 7
• Defense Rating = 12
• Dodge Rating = 13
• Parry Rating = 14
• Block Rating = 15
• Melee Hit = 16
• Ranged Hit = 17
• Spell Hit = 18
• Melee Crit = 19
• Ranged Crit = 20
• Spell Crit = 21
• Melee Haste = 28
• Ranged Haste = 29
• Spell Haste = 30
• General Hit = 31
• General Crit = 32
• Resilience = 35
• General Haste = 36
• Expertise = 37

[hamcakee]

And here is some more:

• 38 = Attack Power
• 39 = Ranged Attack Power
• 40 = Feral Attack Power
• 41 = Spell Power (healing - old doesn't work)
• 42 = Spell Power (damage - old doesn't work)
• 43 = Mana per 5
• 44 = Armor Penetration
• 45 = Spell Power (new use this one)
  

[Wtfluxx]

And here is some more:

• 38 = Attack Power
• 39 = Ranged Attack Power
• 40 = Feral Attack Power
• 41 = Spell Power (healing - old doesn't work)
• 42 = Spell Power (damage - old doesn't work)
• 43 = Mana per 5
• 44 = Armor Penetration
• 45 = Spell Power (new use this one)
  

The spell power and other stats displayed in green which indicates it is a spell does not work to modify with those values. Nor do they show up as "white" stats. How can I modify a weapons spell power?