[Guide] To change the rates

[goldenchip444]

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]

I have the same problem lol

[halohalo]

nvm thanks, solved

[Douglas Farias]

because dont drop itens here ????? sp done xp and gold done more only drop gold ?????

[someone]

There already is a table for gold/drop rates.

[balkia1]

Did somebody know how i change the max upgrade for weapons and armor?

[RomainLastChaos]

in the GameServer --> Server.cfg

[Blackfire]

I dont really understand what you do with that code.

[CyberClaus]

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]

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?