[Guide] To change the rates

[StylerStar01]

You have to do a right click on the DB newproject_data and than choose Console in the menue, there you can run this commands. In the press Enter. 

 

You only need to set the last number on which the Rates requested

 

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;

 

Code for Chance the item Drop with min and max +

 

With this you can influence the rates. (With + - * /)

With the arithmetic operators you can then edit the rates further.

 

 

Please copy the first in the DB: 2

Then comes the change to the script also rates +

# droptable
UPDATE t_npc SET a_minplus = a_minplus +1;
UPDATE t_npc SET a_maxplus = a_maxplus +15;

 

Where i have to Copy this Code? With EXP/SP/DROP Table.