PDA

View Full Version : [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


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 ;

Nickz
29-11-11, 05:57 PM
How do you remove it if you did it?

michoacano094
10-01-12, 03:14 AM
Thanks For Sharing!


How do you remove it if you did it?

Lol i Think That Is Only Possible With make a Backup Before Of Run This Sql