LCKB
[Release] Rates Changer - Printable Version

+- LCKB (https://lckb.dev/forum)
+-- Forum: ** OLD LCKB DATABASE ** (https://lckb.dev/forum/forumdisplay.php?fid=109)
+--- Forum: Release Zone (https://lckb.dev/forum/forumdisplay.php?fid=190)
+---- Forum: Episode 1 Releases (https://lckb.dev/forum/forumdisplay.php?fid=191)
+----- Forum: Tools (https://lckb.dev/forum/forumdisplay.php?fid=163)
+----- Thread: [Release] Rates Changer (/showthread.php?tid=615)

Pages: 1 2


- Akyma777 - 01-19-2012

oh... im sorry for this. Ill do something with this sh*t




- Akyma777 - 01-19-2012

Ok this file is without any viruses :3




- lol102 - 01-19-2012

I not got virus with ur tool for rates ;D




- babbonatale - 01-21-2012

how to set the values ??to change the rates? EXP GOLD DROP SP?




- Koko - 01-23-2012


how to set the values ??to change the rates? EXP GOLD DROP SP?
 

Eeer, open the tool? ._.




- someone - 01-31-2012


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.




- lol102 - 01-31-2012

But is it the faults of the tool that my rates change alone, or its me ?




- Wrong - 02-14-2012


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.

 

Im kinda confused after reading this, so how would be the way to edit rates sucesfully for example to 1 (like an official server)?

 

For exp and sp




- Mikail2244 - 03-03-2012


It keeps saying "Out of Range value for column a_exp at row (110)"

 

Pls help me..