Changing the rates

[lukaslt]

Hey community,

 

It might sound stupid but i havent worked on rates till now, Im kinda confused, the offset editor got codes instead of number e.g. 100 and such, my question would be how are you changing the rates ? e.g exp, sp, and such

[MrBuSta]

Open in navicat newproject_data click on it and run Console and press this:

EXP:

UPDATE t_npc SET a_exp = a_exp * 1;

Replace 1 with the Rate that you would have. (thanks Gothic) (newproject_data)

SP:

UPDATE t_npc SET a_skill_point = a_skill_point * 1;

Replace 1 with the Rate that you would have. (thanks Gothic) (newproject_data)

Gold:

UPDATE t_npc SET a_prize = a_prize * 1;

Replace 1 with the Rate that you would have. (thanks Gothic) (newproject_data)

Item Drop Rate:

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;

Replace 1 with the Rate that you would have. (thanks Gothic) (newproject_data)

[lukaslt]

Open in navicat newproject_data click on it and run Console and press this:

EXP:

UPDATE t_npc SET a_exp = a_exp * 1;

Replace 1 with the Rate that you would have. (thanks Gothic) (newproject_data)

SP:

UPDATE t_npc SET a_skill_point = a_skill_point * 1;

Replace 1 with the Rate that you would have. (thanks Gothic) (newproject_data)

Gold:

UPDATE t_npc SET a_prize = a_prize * 1;

Replace 1 with the Rate that you would have. (thanks Gothic) (newproject_data)

Item Drop Rate:

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;

Replace 1 with the Rate that you would have. (thanks Gothic) (newproject_data)

 

isnt there anything like rate changer for ep1 ;/?

[Paramount]

You are in EP2 section right now.

But anyway, its the same how to change the rates in EP1 or EP2.