[Guide] To change the rates

[Sutz]

mysql> UPDATE t_npc SET a_exp = a_exp * 70;
UPDATE t_npc SET a_skill_point = a_skill_point * 140;
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
Query OK, 206 rows affected
Rows matched: 498 Changed: 206 Warnings: 0
Query OK, 205 rows affected
Rows matched: 498 Changed: 205 Warnings: 0

Query OK, 205 rows affected
Rows matched: 498 Changed: 205 Warnings: 0

Query OK, 203 rows affected
Rows matched: 498 Changed: 203 Warnings: 0

Query OK, 199 rows affected
Rows matched: 498 Changed: 199 Warnings: 0

Query OK, 190 rows affected
Rows matched: 498 Changed: 190 Warnings: 0

Query OK, 186 rows affected
Rows matched: 498 Changed: 186 Warnings: 0

Query OK, 182 rows affected
Rows matched: 498 Changed: 182 Warnings: 0

Query OK, 178 rows affected
Rows matched: 498 Changed: 178 Warnings: 0

Query OK, 173 rows affected
Rows matched: 498 Changed: 173 Warnings: 0

Query OK, 166 rows affected
Rows matched: 498 Changed: 166 Warnings: 0

Query OK, 157 rows affected
Rows matched: 498 Changed: 157 Warnings: 0

Query OK, 141 rows affected
Rows matched: 498 Changed: 141 Warnings: 0

Query OK, 127 rows affected
Rows matched: 498 Changed: 127 Warnings: 0

Query OK, 0 rows affected
Rows matched: 498 Changed: 0 Warnings: 0

Query OK, 0 rows affected
Rows matched: 498 Changed: 0 Warnings: 0

mysql>