SQL command for decreasing all stats on items

[Rick]

Hey, can anyone share the sql command for nerfing all stats on all items (including custom items) and is it possible to decrease also stats like attack power, spell power on the items too ?
Thanks!

 

[MuDZaHeDiN]

Of course you can, you can also write an update that takes the old value and reduces it by 10% rounded.
And since not every DB is the same, you should read through the DB yourself and change the values that come to mind.

 

[OnlyFans]

Of course you can, you can also write an update that takes the old value and reduces it by 10% rounded.
And since not every DB is the same, you should read through the DB yourself and change the values that come to mind.

This ^

 

[MuDZaHeDiN]

this command decreases the value of all rows in a column by 10%.
UPDATE tablename SET columnname = columnname * 0.9;

 

[RedLine]

this will reduce all items stats in item_template (3.3.5 Trinity core) by 50%
You can change the 0.5 at the end according to what you want

item template - Pastebin.com

Pastebin.com is the number one paste tool since 2002. Pastebin is a website where you can store text online for a set period of time.

pastebin.com

 

[Ahlander]

this will reduce all items stats in item_template (3.3.5 Trinity core) by 50%
You can change the 0.5 at the end according to what you want

item template - Pastebin.com

Pastebin.com is the number one paste tool since 2002. Pastebin is a website where you can store text online for a set period of time.

pastebin.com

This is 95% correct, just a few errors that I corrected if you don't mind. You had stat value 8 twice instead of stat value 2 and you used the stat_value1*0.5 as the modifier for all columns instead of using the corresponding stat. This would result in replacing stat value 2 through 10 as a half modifier of 1 rather than just reducing all the corresponding values by half.

Here is an updated using 95% of what you have but adjusting the above things: Pastebin

 

[RedLine]

This is 95% correct, just a few errors that I corrected if you don't mind. You had stat value 8 twice instead of stat value 2 and you used the stat_value1*0.5 as the modifier for all columns instead of using the corresponding stat. This would result in replacing stat value 2 through 10 as a half modifier of 1 rather than just reducing all the corresponding values by half.

Here is an updated using 95% of what you have but adjusting the above things: Pastebin

oh shoot lol
i just wrote the first line and copy pasted and seems like i only change one number.
My ADHD
but appreciate it.