Rates Problems ...

[Rezk]

Hi

i have a probleme on rates .. xp , sp i have tried the tool already and its have been changed but to 200x

And now i cant change it to normal anyone can help me ? just explain me this command and how its work please ?

UPDATE t_npc SET a_exp = a_exp * 1;
UPDATE t_npc SET a_skill_point = a_skill_point * 1;
UPDATE t_npc SET a_prize = a_prize * 1;

# droptable
UPDATE t_npc SET a_item_percent_0 = a_item_percent_0 * 1;
UPDATE t_npc SET a_item_percent_1 = a_item_percent_1 * 1;
UPDATE t_npc SET a_item_percent_2 = a_item_percent_2 * 1;
UPDATE t_npc SET a_item_percent_3 = a_item_percent_3 * 1;
UPDATE t_npc SET a_item_percent_4 = a_item_percent_4 * 1;
UPDATE t_npc SET a_item_percent_5 = a_item_percent_5 * 1;
UPDATE t_npc SET a_item_percent_6 = a_item_percent_6 * 1;
UPDATE t_npc SET a_item_percent_7 = a_item_percent_7 * 1;
UPDATE t_npc SET a_item_percent_8 = a_item_percent_8 * 1;
UPDATE t_npc SET a_item_percent_9 = a_item_percent_9 * 1;
UPDATE t_npc SET a_item_percent_10 = a_item_percent_10 * 1;
UPDATE t_npc SET a_item_percent_11 = a_item_percent_11 * 1;
UPDATE t_npc SET a_item_percent_12 = a_item_percent_12 * 1;
UPDATE t_npc SET a_item_percent_13 = a_item_percent_13 * 1;
UPDATE t_npc SET a_item_percent_14 = a_item_percent_14 * 1;
UPDATE t_npc SET a_item_percent_15 = a_item_percent_15 * 1;
UPDATE t_npc SET a_item_percent_16 = a_item_percent_16 * 1;
UPDATE t_npc SET a_item_percent_17 = a_item_percent_17 * 1;
UPDATE t_npc SET a_item_percent_18 = a_item_percent_18 * 1;
UPDATE t_npc SET a_item_percent_19 = a_item_percent_19 * 1;

[dateone]

UPDATE t_npc <- which table is to be changed, in this case the table t_npc

SET a_exp <- which column is to be updated/changed

= a_exp * 2 <- how it is to be changed, here: current exp multiplied with 2

 

That means if you want to change the exp from x200 to x1 then you have to type this into the console:

 

UPDATE t_npc SET a_exp = a_exp / 200;