Custom update item

Custom Code and Mods Custom Code and Requests
1

how to upgrade item all stat_value *5

pleas help to make qurey for mysql

2

UPDATE item_template SET stat_value1 = (stat_value1*5);
UPDATE item_template SET stat_value2 = (stat_value2*5);
UPDATE item_template SET stat_value3 = (stat_value3*5);
UPDATE item_template SET stat_value4 = (stat_value4*5);
UPDATE item_template SET stat_value5 = (stat_value5*5);
UPDATE item_template SET stat_value6 = (stat_value6*5);
UPDATE item_template SET stat_value7 = (stat_value7*5);
UPDATE item_template SET stat_value8 = (stat_value8*5);
UPDATE item_template SET stat_value9 = (stat_value9*5);
Learn SQL next time.

3

Query:
UPDATE item_template SET stat_value1 = (stat_value1*5)

Error Code: 1264 - Out of range value for column ‘stat_value1’ at row 68

use to 4.3.4 world database

4

In case you didn’t notice, item_template table only has a tiny fraction of all items (192). Most items are in Item-sparse.db2 file, that you can’t simply change with a query.

— Canned message start —

This thread is not related to the official Trinity codebase and was moved to the Custom Code section.

Please read the stickies next time.

— Canned message end —