[QUESTION:WotlK] Editing spell power on items

[silverl0l]

Hey guys.

I was wondering if there's a way to edit the amount of spellpower an item gives you, as I can't seem to figure it out in the database. I've managed to scale all the other stats but not the spellpower one, and I can't seem to find the stat_value or stat_type anywhere on the items.

My appologies if this has been asked before, but I've searched basically everywhere - no results whatsoever...

Hoping there's a chance one of you guys might know how to edit it.

Btw, running on trinitycore 3.3.5a (newest rev), compiled the core earlier today.


Thanks in advance!

[Romzarah]

In one of the Stat _Type box's put 45, in the Stat _Value box next to it put the number you want.. Example 280

I am using SqlYog, you can do this in Sql script.

[Amaroth]

You can basically encounter two types of delivering stats from items.

A: stats given by stat_type (ID specifies type of stat) and by stat_value (value of stat given), and there is also field StatCount, defining how many stats of up to 10 usable "slots" will be used. Simple and quite self-explanatory way I suppose, especially when you take a look at this:
http://collab.kpsn.org/display/tc/item_ ... StatsCount

B: stats given by spells. Items can have up to 5 different spells which might be either used by clicking on item, procing while user attacks with weapon... or are triggered whenever user equips item and thus work as passive aura. A lot of items have those auras and quite a lot of them are giving stats. You can even encounter items where there are lets say 50 intellect, 25 stamina AND passive spell aura, which gives another 50 spell power, so in the end item gives also that spell power, however, you can't find spell power in stats in this case.


So, if you have item of type B, which I suppose you have, otherwise you probably wouldn't need to start such topic, take a look at spells given by item and delete those which give spell power aura on user of item by setting their spellid in item's item_template to 0.

[silverl0l]

In one of the Stat _Type box's put 45, in the Stat _Value box next to it put the number you want.. Example 280

I am using SqlYog, you can do this in Sql script.

Wouldn't work without deleting the spellid as Amaroth stated below, if I added another stat_value it would have 2 +spell power stats. But after deleting the spellid I added the stat_type and stat_value, thanks anyway!

You can basically encounter two types of delivering stats from items.
B: stats given by spells. Items can have up to 5 different spells which might be either used by clicking on item, procing while user attacks with weapon... or are triggered whenever user equips item and thus work as passive aura. A lot of items have those auras and quite a lot of them are giving stats. You can even encounter items where there are lets say 50 intellect, 25 stamina AND passive spell aura, which gives another 50 spell power, so in the end item gives also that spell power, however, you can't find spell power in stats in this case.


So, if you have item of type B, which I suppose you have, otherwise you probably wouldn't need to start such topic, take a look at spells given by item and delete those which give spell power aura on user of item by setting their spellid in item's item_template to 0.

B Worked! Thanks a lot, I didnt know about the spellid. Sucks I gotta delete it and add spellpower on all items manually tho :lol:

[Amaroth]

Yup, it also quite messed up my plans with item mass edits. Well, I still have and use them, but it just makes you to control all items manually anyway.

[Romzarah]

I rarely edit bliz items.. It is more fun to make your own..

[silverl0l]

I rarely edit bliz items.. It is more fun to make your own..

Except for the red question marks, dbc edits and custom patches you need your players to download (unless you're using unused blizz entries) - then yea, I agree, but Im trying to avoid that  

[Romzarah]

I use this site to speed up creating items.. When using this site, the items have the icons I chose wile the items are in my bags or on the chr.. Though you will see the red question mark when dragging the items.. You will also have to drag items like armor and rings to the chr card to equip them.. This site will generate a SQL file for you to run in your SQLYOG or what ever you use...

http://wow-v.com/

You can also read my / Tutorial Custom Armor sets to see how useful this can be..

viewtopic.php?f=26&t=7627

and (Tutorial) Custom Armor Sets (Icon Change)

viewtopic.php?f=26&t=7650

[silverl0l]

I use this site to speed up creating items.. When using this site, the items have the icons I chose wile the items are in my bags or on the chr.. Though you will see the red question mark when dragging the items.. You will also have to drag items like armor and rings to the chr card to equip them.. This site will generate a SQL file for you to run in your SQLYOG or what ever you use...

http://wow-v.com/

You can also read my / Tutorial Custom Armor sets to see how useful this can be..

viewtopic.php?f=26&t=7627

and (Tutorial) Custom Armor Sets (Icon Change)

viewtopic.php?f=26&t=7650

Appreciate it, but I already have all my sets fully working with no red question marks at all. Thanks any way. Problem is solved thanks to Amaroth