Query

[RiiOT]

Hello guys i wanted to know if their is a sql query to make the leveling easy at first then harder at the end, thanks.

 

example

 

at lvl 1-40 its simple then 40-90 its hard.

 

thanks.

[LikeToMove]

Its a bit hard to explain cause you have a lot of way to do it.

If you mean exp table (t_exp on your newproject_data) you can try with it:

UPDATE t_exp SET a_exp = a_exp / 10 WHERE a_level BETWEEN 1 AND 40;
UPDATE t_exp SET a_exp = a_exp * 10 WHERE a_level BETWEEN 41 AND 90;

It is just an example, with this query you decrease the exp needed for the first 40 levels and inccrease it * 10 for the latest 50.

 

Hope can help you

[RiiOT]

Thanks this worked perfectly 

[dethunter12]

nice  keep in mind if you do it from t_npc that can generate bugs and you might set npcs that are shops to give exp which would be a bug .

[SibaN]

Hi.
As you got your answer, and your problem is solved, I am gonna move that topic to Solved section and mark it as solved.

Thanks,

-LCKB Staff

[SibaN]

Hi.

As you got your answer, and your problem is solved, I am gonna move that topic to Solved section and mark it as solved.

 

Thanks,

 

-LCKB Staff