+- 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: Tutorials & Guides (https://lckb.dev/forum/forumdisplay.php?fid=124)
+----- Forum: General Guides (https://lckb.dev/forum/forumdisplay.php?fid=194)
+----- Thread: [Guide] To change the rates (/showthread.php?tid=213)
- goldenchip444 - 04-02-2012
what do you do if it is not working? i set exp to 70 sp to 150 and drop to 70 .... but the rates are much higher everytime i kill something it levels me like 30 times and even if i kill a blue name it will level me 2-3 times iv tried to change the rates multiple times but it seems to be stuck?? any help ..
this is what i put it as
mysql> UPDATE t_npc SET a_exp = a_exp * 70;UPDATE t_npc SET a_skill_point = a_skill_point * 150;
UPDATE t_npc SET a_prize = a_prize * 70;
# 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;
Query OK, 0 rows affected
Rows matched: 1303 Changed: 0 Warnings: 879
Query OK, 0 rows affected
Rows matched: 1303 Changed: 0 Warnings: 834
Query OK, 0 rows affected
Rows matched: 1303 Changed: 0 Warnings: 774
Query OK, 0 rows affected
Rows matched: 1303 Changed: 0 Warnings: 0
Query OK, 0 rows affected
Rows matched: 1303 Changed: 0 Warnings: 0
Query OK, 0 rows affected
Rows matched: 1303 Changed: 0 Warnings: 0
Query OK, 0 rows affected
Rows matched: 1303 Changed: 0 Warnings: 0
Query OK, 0 rows affected
Rows matched: 1303 Changed: 0 Warnings: 0
Query OK, 0 rows affected
Rows matched: 1303 Changed: 0 Warnings: 0
Query OK, 0 rows affected
Rows matched: 1303 Changed: 0 Warnings: 0
Query OK, 0 rows affected
Rows matched: 1303 Changed: 0 Warnings: 0
Query OK, 0 rows affected
Rows matched: 1303 Changed: 0 Warnings: 0
Query OK, 0 rows affected
Rows matched: 1303 Changed: 0 Warnings: 0
Query OK, 0 rows affected
Rows matched: 1303 Changed: 0 Warnings: 0
Query OK, 0 rows affected
Rows matched: 1303 Changed: 0 Warnings: 0
Query OK, 0 rows affected
Rows matched: 1303 Changed: 0 Warnings: 0
Query OK, 0 rows affected
Rows matched: 1303 Changed: 0 Warnings: 0
Query OK, 0 rows affected
Rows matched: 1303 Changed: 0 Warnings: 0
Query OK, 0 rows affected
Rows matched: 1303 Changed: 0 Warnings: 0
Query OK, 0 rows affected
Rows matched: 1303 Changed: 0 Warnings: 0
Query OK, 0 rows affected
Rows matched: 1303 Changed: 0 Warnings: 0
Query OK, 0 rows affected
Rows matched: 1303 Changed: 0 Warnings: 0
Query OK, 0 rows affected
Rows matched: 1303 Changed: 0 Warnings: 0
mysql>
- halohalo - 04-08-2012
I have the same problem lol
- halohalo - 04-10-2012
nvm thanks, solved
- Douglas Farias - 05-06-2012
because dont drop itens here ????? sp done xp and gold done more only drop gold ?????
- someone - 05-06-2012
There already is a table for gold/drop rates.
- balkia1 - 05-07-2012
Did somebody know how i change the max upgrade for weapons and armor?
- RomainLastChaos - 05-07-2012
in the GameServer --> Server.cfg
- Blackfire - 05-09-2012
I dont really understand what you do with that code.
- CyberClaus - 08-20-2012
I'm sorry but i download the files in this page:2 , and in the newproject_data i cant found this comands:
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;
What i do to change the rates or how i found the commands?
Its funny how you ask a question like this, wich is simple basics and a couple months later you post a modified gameserver of your own XD It does look fishy !!!
- IceCreamRockZ - 09-29-2012
so many warnings with this command "UPDATE t_npc SET a_exp = a_exp * 50;" when i set it to custom (UPDATE t_npc SET a_exp = a_exp * 1
have no problem and with my edits have warnings, how to solve?