+- LCKB (https://lckb.dev/forum)
+-- Forum: ** OLD LCKB DATABASE ** (https://lckb.dev/forum/forumdisplay.php?fid=109)
+--- Forum: Guides & Help Section (https://lckb.dev/forum/forumdisplay.php?fid=193)
+---- Forum: Help & Support (https://lckb.dev/forum/forumdisplay.php?fid=157)
+----- Forum: Ep3 Support (https://lckb.dev/forum/forumdisplay.php?fid=150)
+------ Forum: Solved topics (https://lckb.dev/forum/forumdisplay.php?fid=151)
+------ Thread: Query (/showthread.php?tid=3626)
- RiiOT - 03-12-2014
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 - 03-12-2014
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 - 03-13-2014
Thanks this worked perfectly
- dethunter12 - 03-13-2014
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 - 03-13-2014
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 - 03-13-2014
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