[Sql] Increase all by scale

[Mamel!]

Good morning to everyone:

I have seen many servers "over" with attributes of weapons, armor and NPCs. My question is this: If I change all the attributes a 5000% do I have to do it manually or is there any easiest way to get it?

Att: Mamel

[Kiev]

There is a easy way.

You need to run a SQL query that updates them for you, although i cant create it of the top of my head (Not a SQL wiz).

Someone else will be able to provide you with the query.

[MCdeathMC]

this is what i use to upgrade item stats


UPDATE items SET stat_value1 = stat_value1 * 1.5 WHERE stat_type1 > 0 AND entry < 100000;
UPDATE items SET stat_value2 = stat_value2 * 1.5 WHERE stat_type2 > 0 AND entry < 100000;
UPDATE items SET stat_value3 = stat_value3 * 1.5 WHERE stat_type3 > 0 AND entry < 100000;
UPDATE items SET stat_value4 = stat_value4 * 1.5 WHERE stat_type4 > 0 AND entry < 100000;
UPDATE items SET stat_value5 = stat_value5 * 1.5 WHERE stat_type5 > 0 AND entry < 100000;
UPDATE items SET stat_value6 = stat_value6 * 1.5 WHERE stat_type6 > 0 AND entry < 100000;
UPDATE items SET stat_value7 = stat_value7 * 1.5 WHERE stat_type7 > 0 AND entry < 100000;
UPDATE items SET stat_value8 = stat_value8 * 1.5 WHERE stat_type8 > 0 AND entry < 100000;
UPDATE items SET stat_value9 = stat_value9 * 1.5 WHERE stat_type9 > 0 AND entry < 100000;
UPDATE items SET stat_value10 = stat_value10 * 1.5 WHERE stat_type10 > 0 AND entry < 100000;

[Mamel!]

if anyone has this sql file, please let me pay to modify it and do some tests ^ ^

[Kiev]

You just need to go into Navicat or whatever program you use, click execute query and copy and paste that in. Change the 1.5 to whatever you want it to be timesd by.

[Mamel!]

yes but i need the sql, i dont want do manually

[Kiev]

... That is the sql file, just not saved.

Copy and paste it to notepad, go to save as, save it as "whatever.sql" (Select all files from the dropdown), then execute it, its the same thing.

[Mamel!]

o ty, but with this sql the stats improve too many... i have 19200mil with a priest lvl 80 with start items jajajajaja in 1.5 (i didnt modify the query)

[Kiev]

Haha, thats not good. I should have told you to create a backup first.

Your gonna need to change the number to reset all the stats (No idea what number this would be), then do it again by like 0.2 or something.