[Release] Rates Changer

[someone]

Suggestion:

For drop and gold rates there is already a table(t_drop_prob);

for EXP/SP, create a Table int the new project_data

 

The TOOL will check if table exists, if table will not exists will run this sql:

CREATE TABLE IF NOT EXISTS t_rates(
a_index int(11) NOT NULL ,
a_exp bigint(20),
a_sp int(11),
a_exp_rate int(11) DEFAULT 1,
a_sp_rate int(11) DEFAULT 1
);

INSERT INTO t_rates(a_index, a_exp, a_sp)
SELECT a_index, a_exp, a_skill_point from t_npc;

 

Changing rates:

The tool will read the exp/sp from t_rates(a_exp, a_sp) and will multiply with a multiplier(rate), and will save the result to t_npc(a_exp,a_skill_point), and the multiplier to t_rates(a_exp_rate,a_sp_rate).

 

This way changing rates will be much safer.