[Guide] To change the rates

[damona]

warmonger you cant make the "admin" command from the gameserver what are you selling :O

have you nigthshadow? all map files ?

lol

 

mfg damona

Ps Gothic it must a sql data and not a text data

[Azkeel]

This is not working for me, i set the exp and sp to 100 and it stills the same as before. Also to the upgraded euipment drops i setted the min to +10 and the max to +25 and mobs drop +150...

[damona]

fail the max rates by exp all monsters give 2 146 314 894

 

 

warmonger the real question have you nightshadow or not

[123456789]

bei mir gehts nicht so ganz. ich hab immer ne menge wanrings dabei:

UPDATE t_npc SET a_exp = a_exp * 70;

UPDATE t_npc SET a_skill_point = a_skill_point * 950

;

UPDATE t_npc SET a_prize = a_prize * 70;

 

# droptable

UPDATE t_npc SET a_item_percent_0 = a_item_percent_0 * 120;

UPDATE t_npc SET a_item_percent_1 = a_item_percent_1 * 120;

UPDATE t_npc SET a_item_percent_2 = a_item_percent_2 * 120;

UPDATE t_npc SET a_item_percent_3 = a_item_percent_3 * 120;

UPDATE t_npc SET a_item_percent_4 = a_item_percent_4 * 120;

UPDATE t_npc SET a_item_percent_5 = a_item_percent_5 * 120;

UPDATE t_npc SET a_item_percent_6 = a_item_percent_6 * 120;

UPDATE t_npc SET a_item_percent_7 = a_item_percent_7 * 120;

UPDATE t_npc SET a_item_percent_8 = a_item_percent_8 * 120;

UPDATE t_npc SET a_item_percent_9 = a_item_percent_9 * 120;

UPDATE t_npc SET a_item_percent_10 = a_item_percent_10 * 120;

UPDATE t_npc SET a_item_percent_11 = a_item_percent_11 * 120;

UPDATE t_npc SET a_item_percent_12 = a_item_percent_12 * 120;

UPDATE t_npc SET a_item_percent_13 = a_item_percent_13 * 120;

UPDATE t_npc SET a_item_percent_14 = a_item_percent_14 * 120;

UPDATE t_npc SET a_item_percent_15 = a_item_percent_15 * 120;

UPDATE t_npc SET a_item_percent_16 = a_item_percent_16 * 120;

UPDATE t_npc SET a_item_percent_17 = a_item_percent_17 * 120;

 

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;

1264 - Out of range value for column a_exp at row 38

1264 - Out of range value for column a_skill_point at row 1

1264 - Out of range value for column a_prize at row 149

1264 - Out of range value for column a_item_percent_0 at row 260

1264 - Out of range value for column a_item_percent_1 at row 260

1264 - Out of range value for column a_item_percent_2 at row 260

1264 - Out of range value for column a_item_percent_3 at row 260

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 1264 - Out of range value for column a_exp at row 38

1264 - Out of range valu at line 1

Query OK, 0 rows affected

Rows matched: 1123 Changed: 0 Warnings: 833

 

Query OK, 441 rows affected

Rows matched: 1123 Changed: 441 Warnings: 693

 

Query OK, 0 rows affected

Rows matched: 1123 Changed: 0 Warnings: 1123

 

Query OK, 0 rows affected

Rows matched: 1123 Changed: 0 Warnings: 1123

 

Query OK, 0 rows affected

Rows matched: 1123 Changed: 0 Warnings: 1123

 

Query OK, 0 rows affected

Rows matched: 1123 Changed: 0 Warnings: 1123

 

Query OK, 0 rows affected

Rows matched: 1123 Changed: 0 Warnings: 1123

 

Query OK, 0 rows affected

Rows matched: 1123 Changed: 0 Warnings: 1123

 

Query OK, 0 rows affected

Rows matched: 1123 Changed: 0 Warnings: 1123

 

Query OK, 0 rows affected

Rows matched: 1123 Changed: 0 Warnings: 1123

 

Query OK, 0 rows affected

Rows matched: 1123 Changed: 0 Warnings: 1123

 

Query OK, 0 rows affected

Rows matched: 1123 Changed: 0 Warnings: 1123

 

Query OK, 0 rows affected

Rows matched: 1123 Changed: 0 Warnings: 1123

 

Query OK, 0 rows affected

Rows matched: 1123 Changed: 0 Warnings: 1123

 

Query OK, 0 rows affected

Rows matched: 1123 Changed: 0 Warnings: 1123

 

Query OK, 0 rows affected

Rows matched: 1123 Changed: 0 Warnings: 1123

 

Query OK, 0 rows affected

Rows matched: 1123 Changed: 0 Warnings: 1123

 

Query OK, 0 rows affected

Rows matched: 1123 Changed: 0 Warnings: 1123

 

Query OK, 0 rows affected

Rows matched: 1123 Changed: 0 Warnings: 1123

 

Query OK, 0 rows affected

Rows matched: 1123 Changed: 0 Warnings: 1123

 

Query OK, 0 rows affected

Rows matched: 1123 Changed: 0 Warnings: 0

 

Query OK, 0 rows affected

Rows matched: 1123 Changed: 0 Warnings: 0

[hansi123]

und wo öffnes du das um es zu sehen ?

[Odin90]

You have to do a right click on the DB newproject_data and than choose Console in the menue, there you can run this commands. In the press Enter. 

 

You only need to set the last number on which the Rates requested

 

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;

 

Code for Chance the item Drop with min and max +

 

With this you can influence the rates. (With + - * /)

With the arithmetic operators you can then edit the rates further.

 

 

Please copy the first in the DB: 2

Then comes the change to the script also rates +

# droptable
UPDATE t_npc SET a_minplus = a_minplus +1;
UPDATE t_npc SET a_maxplus = a_maxplus +15;

 

 

work perfekt ty

[twini]

have a problem and that once I guess thats not changeable bug weill the NEN is because you get too much endweder or no previous exp / fp gold, etc.

[StylerStar01]

You have to do a right click on the DB newproject_data and than choose Console in the menue, there you can run this commands. In the press Enter. 

 

You only need to set the last number on which the Rates requested

 

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;

 

Code for Chance the item Drop with min and max +

 

With this you can influence the rates. (With + - * /)

With the arithmetic operators you can then edit the rates further.

 

 

Please copy the first in the DB: 2

Then comes the change to the script also rates +

# droptable
UPDATE t_npc SET a_minplus = a_minplus +1;
UPDATE t_npc SET a_maxplus = a_maxplus +15;

 

Where i have to Copy this Code? With EXP/SP/DROP Table.

[dateone]

Is it possible to edit the needed exp and not the exp you gain by killing monsters? Found nothing yet in the forum.

[Accubens3]

Im sorry but i download the files in this page:http://chaos.wizatek.be/showthread.php?2856-Episode-1-Releases-amp-Tuts-Index , 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?