Scale Item Damage

[gelbes]

Hey, I would like to scale the damage and armor of all items, has someone a clue, how to do that?
I mean because

UPDATE item_template SET armor = (armor *1.10) WHERE itemlevel = @itemlevel,
UPDATE item_template SET dmg_min1 = (dmg_min1 * 1.10) WHERE class = 2 AND itemlevel = @itemlevel,
UPDATE item_template SET dmg_max1 = (dmg_max1 * 1.10) WHERE class = 2 AND itemlevel = @itemlevel;

will not work, due to the missing three columns..

 

[Birdseye123]

The armor one seems right, but I'm not completely familiar with TC 4.x item_template structure.
If the armor column doesn't work, it's based off of item level and armor type. There is no damage table as it goes off of item level.

UPDATE item_template SET itemlevel = (itemlevel * 1.10) WHERE class = 2 AND itemlevel = @itemlevel;

If you wanted to narrow it down a bit more, you would need to do something more like this...

UPDATE world.item_template SET `itemlevel` = (`itemlevel` * 1.10) WHERE `class` = 2 AND `itemlevel`= 496 AND `name` LIKE Tyrannical Gladiator/'s%;

If you need anymore help leave a reply.. I'l bee looking more into Cata Trinitycore's structure since I'm currently working on something.