Forum > Serverside Modding

[QUESTION:WotlK] Editing spell power on items

(1/2) > >>

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:

--- Quote from: "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.
--- End quote ---

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! :)


--- Quote from: "Amaroth" ---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.
--- End quote ---

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.

Navigation

[0] Message Index

[#] Next page