[trnity sql dev pack] 10000% stats gourgious sql

**^_^ Electrify** · 20-07-11, 05:36 PM

Just run this SQL in world DB and all the gear stats will have 10000% more stats

Code:

UPDATE item_template SET `stat_value1` = `stat_value1` * 100 ;
UPDATE item_template SET `stat_value2` = `stat_value2` * 100 ;
UPDATE item_template SET `stat_value3` = `stat_value3` * 100 ;
UPDATE item_template SET `stat_value4` = `stat_value4` * 100 ;
UPDATE item_template SET `stat_value5` = `stat_value5` * 100 ;
UPDATE item_template SET `stat_value6` = `stat_value6` * 100 ;
UPDATE item_template SET `stat_value7` = `stat_value7` * 100 ;
UPDATE item_template SET `stat_value8` = `stat_value8` * 100 ;
UPDATE item_template SET `stat_value9` = `stat_value9` * 100 ;
UPDATE item_template SET `stat_value10` = `stat_value10` * 100 ;