11-01-2011, 06:43 PM
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